📄 index.php

📁 通达OA2007SE源代码非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
上一页 12
  $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) OR ($CUR_PAGE == '')))
  {
    $CUR_PAGE = 1;
  }
  if (($PAGE_COUNT < $CUR_PAGE))
  {
    $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);
  if (($offest < 0))
  {
    $offest = 0;
  }
  $query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
  $cursor1 = exequery ($connection, $query1);
  if (($CUSTOMER_COUNT == 0))
  {
    if (($flag == '1'))
    {
      message ('<br>提示', '今日没有客户服务安排');
    }
    else
    {
      message ('<br>提示', '没有符合条件的服务记录');
    }
    exit ();
  }
  else
  {
    echo '
<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="index.php?CUR_PAGE=1&YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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 '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
        <a href="index.php?CUR_PAGE=';
    echo ($CUR_PAGE - 1);
    echo '&YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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 '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
        <a href="index.php?CUR_PAGE=';
    echo ($CUR_PAGE + 1);
    echo '&YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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 '"><img src=\'/images/last01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'下一页\' style="cursor:hand"></a>
        <a href="index.php?CUR_PAGE=';
    echo $PAGE_COUNT;
    echo '&YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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 '"><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">
      ';
    echo $CUR_PAGE;
    echo '/';
    echo $PAGE_COUNT;
    echo '页&nbsp;共&nbsp;';
    echo $CUSTOMER_COUNT;
    echo '&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=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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=CUSTOMER_NAME&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">客户名称&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CUSTOMER_NAME')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CUSTOMER_NAME')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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=KIND&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">客户类别&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'KIND')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'KIND')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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=SELLMODE&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">销售方式&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'SELLMODE')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SELLMODE')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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=CONTACT_TYPE&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">服务类型&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CONTACT_TYPE')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CONTACT_TYPE')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center"><a href="index.php?YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&BEGIN_DAY=';
    echo $START_DAY;
    echo '&END_DAY=';
    echo $FINISH_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=CONTACT_DATE&ORDERSIGN=';
    if (($ORDERSIGN == 'DOWN'))
    {
      echo 'UP';
    }
    if (($ORDERSIGN == 'UP'))
    {
      echo 'DOWN';
    }
    if (($ORDERSIGN == ''))
    {
      if (($ORDERTYPE == 'ASC'))
      {
        echo 'UP';
      }
      else
      {
        echo 'DOWN';
      }
    }
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '">服务日期&nbsp;';
    if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CONTACT_DATE')))
    {
      echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
    }
    if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CONTACT_DATE')))
    {
      echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
    }
    echo '</a></td>
      <td nowrap align="center">服务内容</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';
      }
      echo '    <tr class="';
      echo $TableLine;
      echo '">
    	<td>&nbsp;<input type="checkbox" name="email_select" value="';
      echo $CONTACT_ID1;
      echo '" onClick="check_one(self);"></td>
      <td nowrap align="center">';
      echo $CUSTOMER_NAME1;
      echo '</td>
       <td nowrap align="center">';
      echo $KIND1;
      echo '</td>
       <td nowrap align="center">';
      echo $SELLMODE1;
      echo '</td>
      <td nowrap align="center">';
      echo $CONTACT_TYPE1;
      echo '</td>
      <td nowrap align="center">';
      echo $CONTACT_DATE1;
      echo '</td>
     <td nowrap align="center" style="cursor:hand" onclick="td_detail(\'';
      echo $CONTACT_ID1;
      echo '\');">点击查看</td>
      <td nowrap align="center">';
      echo $SELLER1;
      echo '</td>
      <td nowrap align="center">
	      <a href="edit.php?CONTACT_ID=';
      echo $CONTACT_ID1;
      echo '&YEAR=';
      echo $YEAR;
      echo '&MONTH=';
      echo $MONTH;
      echo '&BEGIN_DAY=';
      echo $START_DAY;
      echo '&END_DAY=';
      echo $FINISH_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 '&CUR_PAGE=';
      echo $CUR_PAGE;
      echo '&ORDERFIELD=';
      echo $ORDERFIELD;
      echo '&ORDERTYPE=';
      echo $ORDERTYPE;
      echo '"> 编辑</a>&nbsp;
        <a href="javascript:show_detail(';
      echo $CONTACT_ID1;
      echo ');"> 详细信息</a>&nbsp;
        <a href="javascript:delete_customer(';
      echo $CONTACT_ID1;
      echo ');">删除</a>
      </td>
    </tr>
    <tr class="TableData" id=';
      echo $CONTACT_ID1;
      echo ' style="display:none" onDblClick="td_close(\'';
      echo $CONTACT_ID1;
      echo '\');" title="双击关闭子窗口">
    <td align="left" colspan=10>
    ';
      echo '<s';
      echo 'pan class="big4">服务内容:';
      echo $CONTACT_CONTENT1;
      echo '</span>
    </td>	
   </tr>
';
    }
  }
  echo '<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>
';
?>
上一页 12
⌨️ 快捷键说明

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