📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
📖 第 1 页 / 共 2 页
字号:
上一页 12
    }
  }
?>
     <td class="<?=$DAY_COLOR?>" width="30" align="center">
       <b><a href="javascript:cur_month('index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$DAY?>&END_DAY=<?=$DAY?>');"><?=$DAY?></a></b>
     </td>
<?
  if ($WEEK==6)
  {

      $WEEK_COUNT++;

      $BEGIN_DAY=$DAY-6;
      if($BEGIN_DAY<0)
         $BEGIN_DAY=1;
?>
     <td class="TableData" width="50" align="center"><a href="javascript:cur_month('index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$BEGIN_DAY?>&END_DAY=<?=$DAY?>');">第<?=$WEEK_COUNT?>周</a></td>
   </tr>
<?
   }

  $DAY++;
}//while

//------------- 补结尾空格 -------------
if($WEEK!=6)
{
  for($I=$WEEK;$I<6;$I++)
  {
?>
     <td class="TableData" width="30">&nbsp;</td>
<?
  }

  $WEEK_COUNT++;

  $DAY--;
  $BEGIN_DAY=$DAY-$WEEK;
  if($BEGIN_DAY<0)
     $BEGIN_DAY=1;
?>
     <td class="TableData" width="50" align="center"><a href="javascript:cur_month('index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$BEGIN_DAY?>&END_DAY=<?=$DAY?>');">第<?=$WEEK_COUNT?>周</a></td>
   </tr>
<?
}
?>
</table>
</td>
</tr>

 <tr>
 	  <td nowrap class="TableData" colspan=4> 客户名称：<input type="text" name="CUSTOMER_NAME" class="SmallInput" size="15" value="<?=$CUSTOMER_NAME?>" maxlength="100">&nbsp;&nbsp;
    联系人：<input type="text" name="LINKMAN_NAME" value="<?=$LINKMAN_NAME?>" 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"><?=$CONTACT_CONTENT?></textarea>
 	 	</td>
</tr>
<tr>
 	<td nowrap class="TableData" colspan=4>
       <input value="快速查询" type="button" class="SmallButton" onclick="javascript:cur_month('index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>');" 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>
</fieldset>
</div>
<br></form>
<?


//-----------先组织SQL语句-----------

 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;
}

$CUSTOMER_COUNT=0;
$query="SELECT count(*) from CONTACT a LEFT OUTER JOIN SYS_CODE b
        ON a.CONTACT_TYPE=b.CODE_NO AND b.PARENT_NO = 'CONTACT_TYPE'
        LEFT OUTER JOIN CUSTOMER c ON a.CUSTOMER_ID = c.CUSTOMER_ID
        LEFT OUTER JOIN SYS_CODE d ON c.KIND=d.CODE_NO AND d.PARENT_NO='CRM_KIND'
        LEFT OUTER JOIN SYS_CODE e ON c.SELLMODE=e.CODE_NO AND e.PARENT_NO='SELL_MODE'
        LEFT OUTER JOIN LINKMAN f ON a.LINKMAN_ID = f.LINKMAN_ID where a.SELLER='$LOGIN_USER_ID' ". $WHERE_STR;
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
  $CUSTOMER_COUNT=$ROW[0];

 $PER_PAGE=6;
 $PAGE_COUNT=ceil($CUSTOMER_COUNT/$PER_PAGE);
if($CUR_PAGE<=0 || $CUR_PAGE=="")
    $CUR_PAGE=1;
if($CUR_PAGE>$PAGE_COUNT)
    $CUR_PAGE=$PAGE_COUNT;
$query1="SELECT a.CONTACT_ID as CONTACT_ID ,c.CUSTOMER_NAME as CUSTOMER_NAME,d.CODE_NAME as KIND,e.CODE_NAME as SELLMODE,b.CODE_NAME as CONTACT_TYPE,a.CONTACT_DATE as CONTACT_DATE,a.CONTACT_CONTENT as CONTACT_CONTENT,a.SELLER as SELLER from CONTACT a LEFT OUTER JOIN SYS_CODE b
         ON a.CONTACT_TYPE=b.CODE_NO AND b.PARENT_NO = 'CONTACT_TYPE'
         LEFT OUTER JOIN CUSTOMER c ON a.CUSTOMER_ID = c.CUSTOMER_ID
         LEFT OUTER JOIN SYS_CODE d ON c.KIND=d.CODE_NO AND d.PARENT_NO='CRM_KIND'
         LEFT OUTER JOIN SYS_CODE e ON c.SELLMODE=e.CODE_NO AND e.PARENT_NO='SELL_MODE'
         LEFT OUTER JOIN LINKMAN f ON a.LINKMAN_ID = f.LINKMAN_ID where a.SELLER='$LOGIN_USER_ID' ". $WHERE_STR.$OREDERBY;

$offest=($CUR_PAGE-1)*6;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
if($CUSTOMER_COUNT==0)
{
   if($flag=="1")
    {
    	Message("<br>提示","今日没有客户服务安排");
    }
   else
    {
    	Message("<br>提示","没有符合条件的服务记录");
    }
    exit;
}
else
{
?>

<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="index.php?CUR_PAGE=1&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
        <a href="index.php?CUR_PAGE=<?=$CUR_PAGE-1?>&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
        <a href="index.php?CUR_PAGE=<?=$CUR_PAGE+1?>&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
        <a href="index.php?CUR_PAGE=<?=$PAGE_COUNT?>&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last02.gif'  width='24' border='0' height='15' alt='末页' style="cursor:hand"></a>

      到
      <input type="text" name="PAGE_NUM" size="3" maxlength="4"  class="SmallInput">
      页
      <img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page()" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
    </td>
    <td align="right">
      <?=$CUR_PAGE?>/<?=$PAGE_COUNT?>页&nbsp;共&nbsp;<?=$CUSTOMER_COUNT?>&nbsp;条
    </td>
  </tr>
</table>

<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">选择</td>
      <td nowrap align="center"><a href="index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">客户名称&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CUSTOMER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CUSTOMER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=KIND&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">客户类别&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="KIND"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="KIND"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=SELLMODE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">销售方式&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SELLMODE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SELLMODE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=CONTACT_TYPE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">服务类型&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CONTACT_TYPE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CONTACT_TYPE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&ORDERFIELD=CONTACT_DATE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">服务日期&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CONTACT_DATE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CONTACT_DATE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td align="center" width="150">服务内容</td>
      <td nowrap align="center">销售员</td>
      <td nowrap align="center">操作</td>
  </tr>

<?
  $CUSTOMER_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
    $CUSTOMER_COUNT++;
    $CONTACT_ID1=$ROW["CONTACT_ID"];
    $CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
    $KIND1=$ROW["KIND"];
    $SELLMODE1=$ROW["SELLMODE"];
    $CONTACT_TYPE1=$ROW["CONTACT_TYPE"];
    $CONTACT_DATE1=$ROW["CONTACT_DATE"];
    $CONTACT_CONTENT1=$ROW["CONTACT_CONTENT"];
    $SELLER1=$ROW["SELLER"];
	  $query2="select * from USER where USER_ID='$SELLER1'";
    $cursor2 = exequery($connection, $query2);
    if($ROW=mysql_fetch_array($cursor2))
       $SELLER1=$ROW["USER_NAME"];

    if($CUSTOMER_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
    	<td>&nbsp;<input type="checkbox" name="email_select" value="<?=$CONTACT_ID1?>" onClick="check_one(self);"></td>
      <td nowrap align="center"><?=$CUSTOMER_NAME1?></td>
       <td nowrap align="center"><?=$KIND1?></td>
       <td nowrap align="center"><?=$SELLMODE1?></td>
      <td nowrap align="center"><?=$CONTACT_TYPE1?></td>
      <td nowrap align="center"><?=$CONTACT_DATE1?></td>
      <td align="left" width="150"><?=$CONTACT_CONTENT1?></td>
      <td nowrap align="center"><?=$SELLER1?></td>
      <td nowrap align="center">
	      <a href="edit.php?CONTACT_ID=<?=$CONTACT_ID1?>&YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&BEGIN_DAY=<?=$START_DAY?>&END_DAY=<?=$FINISH_DAY?>&CONTACT_TYPE=<?=$CONTACT_TYPE?>&KIND=<?=$KIND?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"> 编辑</a>&nbsp;&nbsp;
        <a href="javascript:delete_customer(<?=$CONTACT_ID1?>);"> 删除 </a>
      </td>
    </tr>

<?
}
 }
?>
<tr class="TableControl">
 <td colspan="9">
 	   &nbsp;<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
      <label for="allbox_for">全选</label> &nbsp;
      <input type="button"  value="批量删除" class="SmallButton" onClick="delete_mail();" title="删除所选客户"> &nbsp;
 </td>
</tr>
</table>

</body>
</html>
<?
 function GETALLDATE($CODE,$GETVALUE)
{
  global $connection;
  $query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
  $connection=OpenConnection();
  $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>";}
   else
   {echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";}
  }

}
?>
上一页 12
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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