📄 linkmanlist.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  $PAGE_SIZE = 10;
  echo '<html>
<head>
<title>客户联系人管理 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
  function set_page()
{
 PAGE_START=PAGE_NUM.value;
 location="linkmanlist.php?CUSTOMER_ID=';
  echo $CUSTOMER_ID;
  echo '&CUR_PAGE="+PAGE_START;
}
function show_detail(LINKMAN_ID)
{
    URL="linkman/showdetail.php?LINKMAN_ID="+LINKMAN_ID;
    myleft=(screen.availWidth-650)/2;
    window.open(URL,"formul_edit","height=500,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body>
';
  $query = (((''.'SELECT count(*) FROM `LINKMAN` where CUSTOMER_ID=\'').$CUSTOMER_ID).'\'');
  $cursor = exequery ($connection, $query);
  $CUSTOMER_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $CUSTOMER_COUNT = $ROW[0];
  }
  $PER_PAGE = 10;
  $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 * from `LINKMAN` where CUSTOMER_ID=\'').$CUSTOMER_ID).'\' ');
  $offest = (($CUR_PAGE - 1) * $PAGE_SIZE);
  $query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
  $cursor1 = exequery ($connection, $query1);
  if (($CUSTOMER_COUNT == 0))
  {
    message ('<br>提示', '没有定义联系人');
    exit ();
  }
  else
  {
    echo '<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="linkmanlist.php?CUR_PAGE=1&CUSTOMER_ID=';
    echo $CUSTOMER_ID;
    echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
        <a href="linkmanlist.php?CUR_PAGE=';
    echo ($CUR_PAGE - 1);
    echo '&CUSTOMER_ID=';
    echo $CUSTOMER_ID;
    echo '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
        <a href="linkmanlist.php?CUR_PAGE=';
    echo ($CUR_PAGE + 1);
    echo '&CUSTOMER_ID=';
    echo $CUSTOMER_ID;
    echo '"><img src=\'/images/last01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'下一页\' style="cursor:hand"></a>
        <a href="linkmanlist.php?CUR_PAGE=';
    echo $PAGE_COUNT;
    echo '&CUSTOMER_ID=';
    echo $CUSTOMER_ID;
    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">
';
    $LINKMAN_COUNT = 0;
    while ($ROW = mysql_fetch_array ($cursor1))
    {
      $SIGN = '';
      ++$LINKMAN_COUNT;
      $LINKMAN_ID1 = $ROW['LINKMAN_ID'];
      $CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
      $LINKMAN_NAME1 = $ROW['LINKMAN_NAME'];
      $SEX1 = $ROW['SEX'];
      $TEL_NO_WORK1 = $ROW['TEL_NO_WORK'];
      $MOBILE1 = $ROW['MOBILE'];
      $EMAIL1 = $ROW['EMAIL'];
      $OICQ1 = $ROW['OICQ'];
      $ICQ1 = $ROW['ICQ'];
      $SELLER1 = $ROW['SELLER'];
      $query = (((''.'SELECT USER_NAME from USER where USER_ID=\'').$SELLER1).'\'');
      $cursor = exequery ($connection, $query);
      if ($ROW = mysql_fetch_array ($cursor))
      {
        $SELLER_NAME1 = $ROW['USER_NAME'];
      }
      if (($SELLER1 == $LOGIN_USER_ID))
      {
        $SIGN = '1';
      }
      if (($SEX1 == '0'))
      {
        $SEX_DESC = '男';
      }
      else
      {
        $SEX_DESC = '女';
      }
      if (($MOBILE1 != ''))
      {
        ($MOBIL_NO_STR .= ($MOBILE1.','));
      }
      if ((($LINKMAN_COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '
    <tr class="';
      echo $TableLine;
      echo '">
      <td nowrap align="center">';
      echo $LINKMAN_NAME1;
      echo '</td>
      <td nowrap align="center">';
      echo $SEX_DESC;
      echo '</td>
      <td nowrap align="center">';
      echo $OICQ1;
      echo '/';
      echo $ICQ1;
      echo '</td>
      <td nowrap align="center"><a href="/general/mobile_sms?TO_ID1=';
      echo $MOBILE1;
      echo '">';
      echo $MOBILE1;
      echo '</a></td>
      <td nowrap align="center">';
      echo $EMAIL1;
      echo '</td>
      <td nowrap align="center">';
      echo $SELLER_NAME1;
      echo '</td>
      <td nowrap align="center">
        <a href="javascript:show_detail(';
      echo $LINKMAN_ID1;
      echo ');"> 详细信息 </a>&nbsp;      
      </td>
    </tr>
';
    }
  }
  echo '  <thead class="TableHeader">
      <td nowrap align="center">联系人姓名</td>
      <td nowrap align="center">性别</td>
      <td nowrap align="center">QQ/MSN</td>
      <td nowrap align="center">手机<a href="/general/mobile_sms?TO_ID1=';
  echo $MOBIL_NO_STR;
  echo '">群发</a></td>
      <td nowrap align="center">电子邮件</td>
      <td nowrap align="center">记录员</td>
      <td nowrap align="center">操作</td>
  </thead>
</table>
<br>
</body>
</html>';
?>
⌨️ 快捷键说明

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