📄 list.php

📁 通达OA2007SE源代码非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $PAGE_SIZE = 10;
  echo '
<html>
<head>
<title>客户查询结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
function set_page(urlstr)
{
 PAGE_START=PAGE_NUM.value;
 location="list.php?"+urlstr+"&CUR_PAGE="+PAGE_START+"&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '";
}
function show_detail(CUSTOMER_ID)
  {
    URL="showdetail.php?CUSTOMER_ID="+CUSTOMER_ID;
    myleft=(screen.availWidth-650)/2;
    window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all(';
  echo '"allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }
 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").che';
  echo 'cked=false;
}
function change_customer(urlstr)
{
  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+=val + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ';
  echo '",";
      }
  }
  if(delete_str=="")
  {
     alert("请至少选择其中一个客户。");
     return;
  }
  URL="change_customer?delete_str="+delete_str;
  myleft=(screen.availWidth-650)/2;
  window.open(URL,"change_customer","height=350,width=300,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
';
  if (($COPY_TO_ID != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('COPY_TO_ID='.$COPY_TO_ID);
    }
    else
    {
      $urlstr = (($urlstr.'&COPY_TO_ID=').$COPY_TO_ID);
    }
    $COPY_TO_ID = (('\''.str_replace (',', '\',\'', substr ($COPY_TO_ID, 0, -1))).'\'');
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.SELLER in (').$COPY_TO_ID).')'));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.SELLER in (').$COPY_TO_ID).')'));
    }
  }
  if ((($TO_ID != '') AND ($TO_ID != 'ALL_DEPT')))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('TO_ID='.$TO_ID);
    }
    else
    {
      $urlstr = (($urlstr.'&TO_ID=').$TO_ID);
    }
    $TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where h.DEPT_ID in (').$TO_ID).')'));
    }
    else
    {
      ($WHERE_STR .= (((''.' and h.DEPT_ID in (').$TO_ID).')'));
    }
  }
  if (($CUSTOMER_NAME != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_NAME='.$CUSTOMER_NAME);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_NAME=').$CUSTOMER_NAME);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
    }
  }
  if (($CUSTOMER_CODE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_CODE='.$CUSTOMER_CODE);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_CODE=').$CUSTOMER_CODE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
    }
  }
  if (($CUSTOMER_SHORT != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_SHORT='.$CUSTOMER_SHORT);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_SHORT=').$CUSTOMER_SHORT);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
    }
  }
  if (($CUSTOMER_AREA != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_AREA='.$CUSTOMER_AREA);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_AREA=').$CUSTOMER_AREA);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
    }
  }
  if (($CUSTOMER_ADD != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CUSTOMER_ADD='.$CUSTOMER_ADD);
    }
    else
    {
      $urlstr = (($urlstr.'&CUSTOMER_ADD=').$CUSTOMER_ADD);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
    }
  }
  if (($SOURCE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SOURCE='.$SOURCE);
    }
    else
    {
      $urlstr = (($urlstr.'&SOURCE=').$SOURCE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.SOURCE =\'').$SOURCE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.SOURCE =\'').$SOURCE).'\''));
    }
  }
  if (($KIND != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('KIND='.$KIND);
    }
    else
    {
      $urlstr = (($urlstr.'&KIND=').$KIND);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.KIND =\'').$KIND).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.KIND =\'').$KIND).'\''));
    }
  }
  if (($SELLMODE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SELLMODE='.$SELLMODE);
    }
    else
    {
      $urlstr = (($urlstr.'&SELLMODE=').$SELLMODE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.SELLMODE =\'').$SELLMODE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.SELLMODE =\'').$SELLMODE).'\''));
    }
  }
  if (($ATTRIBUTE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ATTRIBUTE='.$ATTRIBUTE);
    }
    else
    {
      $urlstr = (($urlstr.'&ATTRIBUTE=').$ATTRIBUTE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
    }
  }
  if (($TEL_NO != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('TEL_NO='.$TEL_NO);
    }
    else
    {
      $urlstr = (($urlstr.'&TEL_NO=').$TEL_NO);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.TEL_NO like \'%'.$TEL_NO).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.TEL_NO like \'%'.$TEL_NO).'%\''));
    }
  }
  if (($ENTERTYPE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ENTERTYPE='.$ENTERTYPE);
    }
    else
    {
      $urlstr = (($urlstr.'&ENTERTYPE=').$ENTERTYPE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where a.ENTERTYPE =\'').$ENTERTYPE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and a.ENTERTYPE =\'').$ENTERTYPE).'\''));
    }
  }
  if (($ENTERMEMO != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('ENTERMEMO='.$ENTERMEMO);
    }
    else
    {
      $urlstr = (($urlstr.'&ENTERMEMO=').$ENTERMEMO);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
    }
  }
  if (($LINKMAN_NAME != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('LINKMAN_NAME='.$LINKMAN_NAME);
    }
    else
    {
      $urlstr = (($urlstr.'&LINKMAN_NAME=').$LINKMAN_NAME);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where i.LINKMAN_NAME like \'%'.$LINKMAN_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and i.LINKMAN_NAME like \'%'.$LINKMAN_NAME).'%\''));
    }
  }
  if (($SEX != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SEX='.$SEX);
    }
    else
    {
      $urlstr = (($urlstr.'&SEX=').$SEX);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where i.SEX =\'').$SEX).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and i.SEX =\'').$SEX).'\''));
    }
  }
  if (($HOBBY != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('HOBBY='.$HOBBY);
    }
    else
    {
      $urlstr = (($urlstr.'&HOBBY=').$HOBBY);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where i.HOBBY like \'%'.$HOBBY).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and i.HOBBY like \'%'.$HOBBY).'%\''));
    }
  }
  if (($CONTACT_TYPE != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTACT_TYPE='.$CONTACT_TYPE);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTACT_TYPE=').$CONTACT_TYPE);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where j.CONTACT_TYPE =\'').$CONTACT_TYPE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and j.CONTACT_TYPE =\'').$CONTACT_TYPE).'\''));
    }
  }
  if (($CONTACT_DATE1 != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTACT_DATE1='.$CONTACT_DATE1);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTACT_DATE1=').$CONTACT_DATE1);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where j.CONTACT_DATE>=\'').$CONTACT_DATE1).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.'  and j.CONTACT_DATE>=\'').$CONTACT_DATE1).'\''));
    }
  }
  if (($CONTACT_DATE2 != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTACT_DATE2='.$CONTACT_DATE2);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTACT_DATE2=').$CONTACT_DATE2);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where j.CONTACT_DATE<=\'').$CONTACT_DATE2).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.'  and j.CONTACT_DATE<=\'').$CONTACT_DATE2).'\''));
    }
  }
  if (($SATISFY != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('SATISFY='.$SATISFY);
    }
    else
    {
      $urlstr = (($urlstr.'&SATISFY=').$SATISFY);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where j.SATISFY =\'').$SATISFY).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and j.SATISFY =\'').$SATISFY).'\''));
    }
  }
  if (($CONTACT_CONTENT != ''))
  {
    if (($urlstr == ''))
    {
      $urlstr = ('CONTACT_CONTENT='.$CONTACT_CONTENT);
    }
    else
    {
      $urlstr = (($urlstr.'&CONTACT_CONTENT=').$CONTACT_CONTENT);
    }
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where j.CONTACT_CONTENT like \'%'.$CONTACT_CONTENT).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and j.CONTACT_CONTENT like \'%'.$CONTACT_CONTENT).'%\''));
    }
  }
  $query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'CUSTOMER\'';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $FIELDNO = ('CUSTOMER'.$ROW['FIELDNO']);
    if (($$FIELDNO != ''))
    {
      $CUSTOMERID_STR = '';
      if (($urlstr == ''))
      {
        $urlstr = (($FIELDNO.'=').$$FIELDNO);
      }
      else
      {
        $urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
      }
      $WHERE_STR1 = ((((' where TABLENAME=\'CUSTOMER\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
      $query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
      $cursor1 = exequery ($connection, $query1);
      while ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $CUSTOMERID_STR = (($CUSTOMERID_STR.$ROW1['IDENTY_ID']).',');
      }
      $CUSTOMERID_STR = (('\''.str_replace (',', '\',\'', substr ($CUSTOMERID_STR, 0, -1))).'\'');
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where a.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
        continue;
      }
      else
      {
        ($WHERE_STR .= (((''.' and a.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
        continue;
      }
      continue;
    }
  }
  $query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'LINKMAN\'';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $FIELDNO = ('LINKMAN'.$ROW['FIELDNO']);
    if (($$FIELDNO != ''))
    {
      $LINKMANID_STR = '';
      if (($urlstr == ''))
      {
        $urlstr = (($FIELDNO.'=').$$FIELDNO);
      }
      else
      {
        $urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
      }
      $WHERE_STR1 = ((((' where TABLENAME=\'LINKMAN\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
      $query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
      $cursor1 = exequery ($connection, $query1);
      while ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $LINKMANID_STR = (($LINKMANID_STR.$ROW1['IDENTY_ID']).',');
      }
      $LINKMANID_STR = (('\''.str_replace (',', '\',\'', substr ($LINKMANID_STR, 0, -1))).'\'');
      if (($WHERE_STR == ''))
12 下一页
⌨️ 快捷键说明

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