⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 通达OA2007SE源代码 非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<?
  function getalldate ($CODE, $GETVALUE)
  {
    global $connection;
    $query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
    $cursor = exequery ($connection, $query);
    echo '<option value= ></option>';
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $CODE_NO = $ROW['CODE_NO'];
      $CODE_NAME = $ROW['CODE_NAME'];
      if ((($CODE_NO == $GETVALUE) AND ($GETVALUE != '')))
      {
        echo (((('<option value='.$CODE_NO).'  selected>').$CODE_NAME).'</option>');
        continue;
      }
      else
      {
        echo (((('<option value='.$CODE_NO).' >').$CODE_NAME).'</option>');
        continue;
      }
    }
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>客户服务安排查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function show_detail(CONTACT_ID)
{
 URL="showdetail.php?CONTACT_ID="+CONTACT_ID;
 myleft=(screen.availWidth-650)/2;
 window.open(URL,"formul_edit","height=550,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}	
function ad_query()
{
  URL="ad_query";
  window.location=URL;
}
my_top=50;
my_left=50;
function My_Submit()';
  echo '
{
  document.form1.submit();
}
function set_year(op)
{
  if(op==-1 && document.form1.YEAR.selectedIndex==0)
     return;
  if(op==1 && document.form1.YEAR.selectedIndex==(document.form1.YEAR.options.length-1))
     return;
  document.form1.YEAR.selectedIndex=document.form1.YEAR.selectedIndex+op;
  My_Submit();
}
function set_mon(op)
{
  if(op==-1 && document.form1.MONTH.selec';
  echo 'tedIndex==0)
     return;
  if(op==1 && document.form1.MONTH.selectedIndex==(document.form1.MONTH.options.length-1))
     return;
  document.form1.MONTH.selectedIndex=document.form1.MONTH.selectedIndex+op;
  My_Submit();
}
function cur_month(str)
{
  location=str+"&CONTACT_TYPE="+document.form1.CONTACT_TYPE.value+"&KIND="+document.form1.KIND.value+"&CUSTOMER_NAME="+document.form1.CUST';
  echo 'OMER_NAME.value+"&LINKMAN_NAME="+document.form1.LINKMAN_NAME.value+"&CONTACT_CONTENT="+document.form1.CONTACT_CONTENT.value;
}
function set_page()
{
 PAGE_START=PAGE_NUM.value;
 location="index.php?YEAR=';
  echo $YEAR;
  echo '&MONTH=';
  echo $MONTH;
  echo '&BEGIN_DAY=';
  echo $BEGIN_DAY;
  echo '&END_DAY=';
  echo $END_DAY;
  echo '&CONTACT_TYPE=';
  echo $CONTACT_TYPE;
  echo '&KIND=';
  echo $KIND;
  echo '&CUSTOMER_NAME=';
  echo $CUSTOMER_NAME;
  echo '&LINKMAN_NAME=';
  echo $LINKMAN_NAME;
  echo '&CONTACT_CONTENT=';
  echo $CONTACT_CONTENT;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&CUR_PAGE="+PAGE_START;
}
  function delete_customer(CONTACT_ID)
{
 msg=\'确认要删除该服务记录？\';
 if(window.confirm(msg))
 {
  URL="delete.php?YEAR=';
  echo $YEAR;
  echo '&MONTH=';
  echo $MONTH;
  echo '&BEGIN_DAY=';
  echo $BEGIN_DAY;
  echo '&END_DAY=';
  echo $END_DAY;
  echo '&CONTACT_TYPE=';
  echo $CONTACT_TYPE;
  echo '&KIND=';
  echo $KIND;
  echo '&CUSTOMER_NAME=';
  echo $CUSTOMER_NAME;
  echo '&LINKMAN_NAME=';
  echo $LINKMAN_NAME;
  echo '&CONTACT_CONTENT=';
  echo $CONTACT_CONTENT;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&CONTACT_ID=" + CONTACT_ID;
  window.location=URL;
 }
}
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=fals';
  echo 'e;
 }
 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
function delete_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+';
  echo '=val + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("请至少选择其中一个服务记录");
     return;
  }
  msg=\'确认要删除所选服务记录？\';
  if(window.confirm(msg))
  {
    URL="delete.php?YEAR=';
  echo $YEAR;
  echo '&MONTH=';
  echo $MONTH;
  echo '&BEGIN_DAY=';
  echo $BEGIN_DAY;
  echo '&END_DAY=';
  echo $END_DAY;
  echo '&CONTACT_TYPE=';
  echo $CONTACT_TYPE;
  echo '&KIND=';
  echo $KIND;
  echo '&CUSTOMER_NAME=';
  echo $CUSTOMER_NAME;
  echo '&LINKMAN_NAME=';
  echo $LINKMAN_NAME;
  echo '&CONTACT_CONTENT=';
  echo $CONTACT_CONTENT;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&delete_str=" + delete_str;
    window.location=URL;
  }
}
function td_detail(I)
{
   if(document.all(I).style.display=="none")
      {document.all(I).style.display="";
       document.all(I).style.cursor="hand";
      	}
   else
   	document.all(I).style.display="none";
}
 function td_close(I)
{
   	document.all(I).style.display="none";
} 
</script>
</head>
<body topmargin';
  echo '="5">
<div align="left">
<fieldset style="width:95%;padding-bottom:0px;padding-top:1px;">
	 <legend class="small" align=left>
      <b>快速查询</b>
    </legend>
<form action="index.php"  method="post" name="form1">
<table cellspacing="1" class="small" align="left" cellpadding="3" border="0">
 <tr>
 	 <td nowrap class="TableData" colspan=4>服务类别：';
  echo '<s';
  echo 'elect name="CONTACT_TYPE" class="SmallSelect">
';
  getalldate ('CONTACT_TYPE', $CONTACT_TYPE);
  echo '        </select>
     &nbsp; 客户类别：';
  echo '<s';
  echo 'elect name="KIND" class="SmallSelect">
';
  getalldate ('CRM_KIND', $KIND);
  echo '        </select>
 	 	</td>
    <td nowrap class="TableData">
<td nowrap class="TableData" rowspan="7">
<table border="0"  cellspacing="0" cellpadding="3" class="small" align="center">
  <tr>
  	<td nowrap>
';
  $START_DAY = $BEGIN_DAY;
  $FINISH_DAY = $END_DAY;
  $CUR_YEAR = date ('Y');
  $CUR_MON = date ('m');
  $CUR_DAY = date ('d');
  $DATE = 1;
  $DAY = 1;
  if ((((!$YEAR AND !$MONTH) AND !$BEGIN_DAY) AND !$END_DAY))
  {
    $YEAR = $CUR_YEAR;
    $MONTH = $CUR_MON;
    $START_DAY = $CUR_DAY;
    $FINISH_DAY = $CUR_DAY;
    $flag = '1';
  }
  if (!$MONTH)
  {
    $MONTH = $CUR_MON;
  }
  if (((9999 < $YEAR) OR ($YEAR < 0)))
  {
    echo '<script>
    alert(\'年份超出范围！\')
    history.go(-1)
    </script>
  ';
    exit ();
  }
  if (((12 < $MONTH) OR ($MONTH < 0)))
  {
    echo '<script>
    alert(\'月份超出范围！\')
    history.go(-1)
    </script>
  ';
    exit ();
  }
  while (checkdate ($MONTH, $DATE, $YEAR))
  {
    ++$DATE;
  }
  echo '
<!-------------- 年 ------------>
        &nbsp;&nbsp;&nbsp;<input type="button" value="<" class="SmallButton" title="上一年" onclick="set_year(-1);">';
  echo '<s';
  echo 'elect name="YEAR" class="SmallSelect" onchange="My_Submit();">
';
  for ($I = 2000; ($I <= 2015); ++$I)
  {
    echo '   <option value="';
    echo $I;
    echo '" ';
    if (($I == $YEAR))
    {
      echo 'selected';
    }
    echo '>';
    echo $I;
    echo '</option>
';
  }
  echo '   </select><input type="button" value=">" class="SmallButton" title="下一年" onclick="set_year(1);"> <b>年</b>
<!-------------- 月 ------------>
   <input type="button" value="<" class="SmallButton" title="上一月" onclick="set_mon(-1);">';
  echo '<s';
  echo 'elect name="MONTH" class="SmallSelect" onchange="My_Submit();">
';
  for ($I = 1; ($I <= 12); ++$I)
  {
    if (($I < 10))
    {
      $I = ('0'.$I);
    }
    echo '    <option value="';
    echo $I;
    echo '" ';
    if (($I == $MONTH))
    {
      echo 'selected';
    }
    echo '>';
    echo $I;
    echo '</option>
';
  }
  echo '        </select><input type="button" value=">" class="SmallButton" title="下一月" onclick="set_mon(1);"> <b>月</b>&nbsp;&nbsp;
        <input type="button" value="本月" class="SmallButton" title="本月" onclick="javascript:cur_month(\'index.php?YEAR=';
  echo $CUR_YEAR;
  echo '&MONTH=';
  echo $CUR_MONTH;
  echo '\');">
    </td>
  </tr>
</table>
  <table border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
    <tr align="center" class="TableHeader">
      <td width="30" bgcolor="#FFCCFF"><b>日</b></td>
      <td width="30"><b>一</b></td>
      <td width="30"><b>二</b></td>
      <td width="30"><b>三</b></td>
      <td width="30"><b>四</b></td>
      <td width="30"><b>五</b></td>
  ';
  echo '    <td width="30" bgcolor="#CCFFCC"><b>六</b></td>
      <td width="50"><b>周次</b></td>
    </tr>
';
  $WEEK_COUNT = 0;
  while (($DAY < $DATE))
  {
    if (((($DAY == $CUR_DAY) AND ($YEAR == $CUR_YEAR)) AND ($MONTH == $CUR_MON)))
    {
      $DAY_COLOR = 'TableContent';
    }
    else
    {
      $DAY_COLOR = 'TableData';
    }
    $WEEK = date ('w', mktime (0, 0, 0, $MONTH, $DAY, $YEAR));
    if ((($WEEK == 0) OR ($DAY == 1)))
    {
      echo '   <tr>
';
    }
    if (($DAY == 1))
    {
      for ($I = 0; ($I < $WEEK); ++$I)
      {
        echo '     <td class="TableData" width="30">&nbsp;</td>
';
      }
    }
    echo '     <td class="';
    echo $DAY_COLOR;
    echo '" width="30" align="center">
       <b><a href="javascript:cur_month(\'index.php?YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $DAY;
    echo '&END_DAY=';
    echo $DAY;
    echo '\');">';
    echo $DAY;
    echo '</a></b>
     </td>
';
    if (($WEEK == 6))
    {
      ++$WEEK_COUNT;
      $BEGIN_DAY = ($DAY - 6);
      if (($BEGIN_DAY < 0))
      {
        $BEGIN_DAY = 1;
      }
      echo '     <td class="TableData" width="50" align="center"><a href="javascript:cur_month(\'index.php?YEAR=';
      echo $YEAR;
      echo '&MONTH=';
      echo $MONTH;
      echo '&BEGIN_DAY=';
      echo $BEGIN_DAY;
      echo '&END_DAY=';
      echo $DAY;
      echo '\');">第';
      echo $WEEK_COUNT;
      echo '周</a></td>
   </tr>
';
    }
    ++$DAY;
  }
  if (($WEEK != 6))
  {
    for ($I = $WEEK; ($I < 6); ++$I)
    {
      echo '     <td class="TableData" width="30">&nbsp;</td>
';
    }
    ++$WEEK_COUNT;
    --$DAY;
    $BEGIN_DAY = ($DAY - $WEEK);
    if (($BEGIN_DAY < 0))
    {
      $BEGIN_DAY = 1;
    }
    echo '     <td class="TableData" width="50" align="center"><a href="javascript:cur_month(\'index.php?YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $BEGIN_DAY;
    echo '&END_DAY=';
    echo $DAY;
    echo '\');">第';
    echo $WEEK_COUNT;
    echo '周</a></td>
   </tr>
';
  }
  echo '</table>
</td>
</tr>
 <tr>
 	  <td nowrap class="TableData" colspan=4> 客户名称：<input type="text" name="CUSTOMER_NAME" class="SmallInput" size="15" value="';
  echo $CUSTOMER_NAME;
  echo '" maxlength="100">&nbsp;&nbsp;
    联系人：<input type="text" name="LINKMAN_NAME" value="';
  echo $LINKMAN_NAME;
  echo '" class="SmallInput" size="15" maxlength="100"></td>
</tr>
<tr>
 	 <td nowrap class="TableData" colspan=4>
 	 	服务内容：<textarea cols=47 rows=2 name="CONTACT_CONTENT" class="BigInput" wrap="yes">';
  echo $CONTACT_CONTENT;
  echo '</textarea>
 	 	</td>
</tr>
<tr>
 	<td nowrap class="TableData" colspan=4>
       <input value="快速查询" type="button" class="SmallButton" onclick="javascript:cur_month(\'index.php?YEAR=';
  echo $YEAR;
  echo '&MONTH=';
  echo $MONTH;
  echo '&BEGIN_DAY=';
  echo $START_DAY;
  echo '&END_DAY=';
  echo $FINISH_DAY;
  echo '\');" title="模糊查询" name="button">
  &nbsp;<input value="高级查询" type="button" class="SmallButton" title="模糊查询" name="button1" onClick="ad_query();">
 	 </td>
</tr>
<tr>
 	 <td nowrap class="TableData"  colspan=4>
  &nbsp;
 	 </td>
</tr>
<tr>
 	 <td nowrap class="TableData"  colspan=4>
  &nbsp;
 	 </td>
</tr>
</TABLE>
</form>
</fieldset>
</div>
<br>
';
  if (($CONTACT_TYPE != ''))
  {
    ($WHERE_STR .= (((''.' and a.CONTACT_TYPE=\'').$CONTACT_TYPE).'\''));
  }
  if (($KIND != ''))
  {
    ($WHERE_STR .= (((''.' and c.KIND=\'').$KIND).'\''));
  }
  if (($CUSTOMER_NAME != ''))
  {
    ($WHERE_STR .= ((' and c.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
  }
  if (($LINKMAN_NAME != ''))
  {
    ($WHERE_STR .= ((' and f.LINKMAN_NAME like \'%'.$LINKMAN_NAME).'%\''));
  }
  if (($CONTACT_CONTENT != ''))
  {
    ($WHERE_STR .= ((' and a.CONTACT_CONTENT like \'%'.$CONTACT_CONTENT).'%\''));
  }
  if (($YEAR != ''))
  {
    ($WHERE_STR .= (((''.' and YEAR(a.CONTACT_DATE)= \'').$YEAR).'\''));
  }
  if (($MONTH != ''))
  {
    ($WHERE_STR .= (((''.' and MONTH(a.CONTACT_DATE)= \'').$MONTH).'\''));
  }
  if (($START_DAY != ''))
  {
    ($WHERE_STR .= (((''.' and DAYOFMONTH(a.CONTACT_DATE)>= \'').$START_DAY).'\''));
  }
  if (($FINISH_DAY != ''))
  {
    ($WHERE_STR .= (((''.' and DAYOFMONTH(a.CONTACT_DATE)<= \'').$FINISH_DAY).'\''));
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -