index.php

通达OA2007SE源代码 非常好的

  <input value="高级查询" type="button" class="SmallButton" title="模糊查询" name="button1" onClick="ad_query();">
   <input value="客户资料导入" type="button" class="SmallButton" title="客户资料导入" name="but';
  echo 'ton1" onClick="excel_import();">
  <input value="客户资料导出" type="button" class="SmallButton" title="客户资料导出" name="button1" onClick="excel_exmport();">
  </td>
 </tr>
</form>
</table>
</fieldset>
</div>
';
  if ((($SCOPE == '1') OR ($SCOPE == '')))
  {
    ($WHERE_STR .= (((((''.' where (SELLER=\'').$LOGIN_USER_ID).'\' or CREATOR=\'').$LOGIN_USER_ID).'\')'));
  }
  if (($SCOPE == '2'))
  {
    ($WHERE_STR .= (((((''.' where ((find_in_set( \'').$LOGIN_USER_ID).'\',SHAREUSER) and SHARE=\'1\') or (SHAREUSER=\'\' and  SELLER!=\'').$LOGIN_USER_ID).'\' and SHARE=\'1\'))'));
  }
  if (($SCOPE == '3'))
  {
    $query1 = 'select DEPT_ID from DEPARTMENT';
    $cursor1 = exequery ($connection, $query1);
    while ($ROW = mysql_fetch_array ($cursor1))
    {
      $DEPT_ID = $ROW['DEPT_ID'];
      if ((is_dept_priv ($DEPT_ID) == 1))
      {
        $TO_ID = (($TO_ID.$DEPT_ID).',');
        continue;
      }
    }
    $TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
    ($WHERE_STR .= (((((''.' where d.DEPT_ID in (').$TO_ID).') and SELLER!=\'').$LOGIN_USER_ID).'\' '));
  }
  if (($CUSTOMER_NAME != ''))
  {
    ($WHERE_STR .= ((' and CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
  }
  if (($TEL_NO != ''))
  {
    ($WHERE_STR .= ((' and a.TEL_NO like \'%'.$TEL_NO).'%\''));
  }
  if (($CUSTOMER_CODE != ''))
  {
    ($WHERE_STR .= ((' and CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
  }
  if (($CUSTOMER_SHORT != ''))
  {
    ($WHERE_STR .= ((' and CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
  }
  if (($SOURCE != ''))
  {
    ($WHERE_STR .= (((''.' and SOURCE= \'').$SOURCE).'\''));
  }
  if (($KIND != ''))
  {
    ($WHERE_STR .= (((''.' and KIND= \'').$KIND).'\''));
  }
  if (($SELLMODE != ''))
  {
    ($WHERE_STR .= (((''.' and SELLMODE= \'').$SELLMODE).'\''));
  }
  if (($ATTRIBUTE != ''))
  {
    ($WHERE_STR .= (((''.' and ATTRIBUTE= \'').$ATTRIBUTE).'\''));
  }
  if (($ENTERTYPE != ''))
  {
    ($WHERE_STR .= (((''.' and ENTERTYPE= \'').$ENTERTYPE).'\''));
  }
  if (($AREACODE != ''))
  {
    ($WHERE_STR .= (((''.' and CUSTOMER_AREA= \'').$AREACODE).'\''));
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  $CUSTOMER_COUNT = 0;
  $query = ('SELECT count(*) from CUSTOMER a
        LEFT OUTER JOIN SYS_CODE b ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = \'SELL_MODE\'
        LEFT OUTER JOIN SYS_CODE c ON a.KIND = c.CODE_NO AND c.PARENT_NO = \'CRM_KIND\'
        LEFT OUTER JOIN SYS_CODE e ON a.CUSTOMER_AREA=e.CODE_NO AND e.PARENT_NO = \'AREA\'
        LEFT OUTER JOIN USER d ON a.SELLER = d.USER_ID
         '.$WHERE_STR);
  $cursor = exequery ($connection, $query);
  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 CUSTOMER_ID,CUSTOMER_NAME,TEL_NO,FAX_NO, SELLER,a.EMAIL as EMAIL,b.CODE_NAME as SELLMODE, c.CODE_NAME as KIND,d.USER_NAME as SELLER,d.USER_ID as SELLERID,e.CODE_NAME as CUSTOMER_AREA,a.CREATDATE as CREATDATE,f.USER_NAME as CREATOR,a.CREATOR as CREATORID from CUSTOMER a
         LEFT OUTER JOIN SYS_CODE b
         ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = \'SELL_MODE\'
         LEFT OUTER JOIN SYS_CODE c
         ON a.KIND = c.CODE_NO AND c.PARENT_NO = \'CRM_KIND\'
         LEFT OUTER JOIN SYS_CODE e ON a.CUSTOMER_AREA=e.CODE_NO AND e.PARENT_NO = \'AREA\'
         LEFT OUTER JOIN USER d ON a.SELLER = d.USER_ID 
         LEFT OUTER JOIN USER f ON a.CREATOR = f.USER_ID '.$WHERE_STR).$OREDERBY);
  $offest = (($CUR_PAGE - 1) * 10);
  if (($offest < 0))
  {
    $offest = 0;
  }
  $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="index.php?CUR_PAGE=1&CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&SCOPE=';
    echo $SCOPE;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&SOURCE=';
    echo $SOURCE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&TEL_NO=';
    echo $TEL_NO;
    echo '&AREACODE=';
    echo $AREACODE;
    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 '&CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&SCOPE=';
    echo $SCOPE;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&SOURCE=';
    echo $SOURCE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&TEL_NO=';
    echo $TEL_NO;
    echo '&AREACODE=';
    echo $AREACODE;
    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 '&CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&SCOPE=';
    echo $SCOPE;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&SOURCE=';
    echo $SOURCE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&TEL_NO=';
    echo $TEL_NO;
    echo '&AREACODE=';
    echo $AREACODE;
    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 '&CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&SCOPE=';
    echo $SCOPE;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&SOURCE=';
    echo $SOURCE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&TEL_NO=';
    echo $TEL_NO;
    echo '&AREACODE=';
    echo $AREACODE;
    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" ';
    if (($SCOPE == '2'))
    {
      echo 'style=display:none';
    }
    echo '>选择</td>
      <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&SCOPE=';
    echo $SCOPE;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&SOURCE=';
    echo $SOURCE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&TEL_NO=';
    echo $TEL_NO;
    echo '&AREACODE=';
    echo $AREACODE;
    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?CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&SCOPE=';
    echo $SCOPE;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&SOURCE=';
    echo $SOURCE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;
    echo '&ATTRIBUTE=';
    echo $ATTRIBUTE;
    echo '&ENTERTYPE=';
    echo $ENTERTYPE;
    echo '&TEL_NO=';
    echo $TEL_NO;
    echo '&AREACODE=';
    echo $AREACODE;
    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?CUSTOMER_NAME=';
    echo $CUSTOMER_NAME;
    echo '&SCOPE=';
    echo $SCOPE;
    echo '&CUSTOMER_CODE=';
    echo $CUSTOMER_CODE;
    echo '&CUSTOMER_SHORT=';
    echo $CUSTOMER_SHORT;
    echo '&SOURCE=';
    echo $SOURCE;
    echo '&KIND=';
    echo $KIND;
    echo '&SELLMODE=';
    echo $SELLMODE;