index.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 1,211 行 · 第 1/3 页
PHP
1,211 行
<?
  function getalldate ($CODE, $GETVALUE)
  {
    global $connection;
    $query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
    $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))
      {
        echo (((('<option value='.$CODE_NO).'  selected>').$CODE_NAME).'</option>');
        continue;
      }
      else
      {
        echo (((('<option value='.$CODE_NO).' >').$CODE_NAME).'</option>');
        continue;
      }
    }
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $PAGE_SIZE = 10;
  $query = 'select * from SALE_MANAGER where MANAGER_ID=1';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $MANAGER_ID = $ROW['MANAGER_ID'];
    $MANAGERS = $ROW['MANAGERS'];
  }
  echo '
<html>
<head>
<title>销售记录快速搜索 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
  function delete_customer(HISTORY_ID)
{
 msg=\'确认要删除该销售记录？\';
 if(window.confirm(msg))
 {
  URL="delete.php?CUSTOMER_NAME=';
  echo $CUSTOMER_NAME;
  echo '&CUSTOMER_CODE=';
  echo $CUSTOMER_CODE;
  echo '&CUSTOMER_SHORT=';
  echo $CUSTOMER_SHORT;
  echo '&ARE=';
  echo $ARE;
  echo '&KIND=';
  echo $KIND;
  echo '&SELLMODE=';
  echo $SELLMODE;
  echo '&ATTRIBUTE=';
  echo $ATTRIBUTE;
  echo '&ENTERTYPE=';
  echo $ENTERTYPE;
  echo '&PRODUCT_NAME=';
  echo $PRODUCT_NAME;
  echo '&PRODUCT_MODE=';
  echo $PRODUCT_MODE;
  echo '&PRODUCT_TYPE=';
  echo $PRODUCT_TYPE;
  echo '&SERVICE_NAME=';
  echo $SERVICE_NAME;
  echo '&SERVICE_DESC=';
  echo $SERVICE_DESC;
  echo '&DATE1=';
  echo $DATE1;
  echo '&DATE2=';
  echo $DATE2;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&HISTORY_ID=" + HISTORY_ID;
  window.location=URL;
 }
}
function set_page()
{
 PAGE_START=PAGE_NUM.value;
 location="index.php?CUSTOMER_NAME=';
  echo $CUSTOMER_NAME;
  echo '&CUSTOMER_CODE=';
  echo $CUSTOMER_CODE;
  echo '&CUSTOMER_SHORT=';
  echo $CUSTOMER_SHORT;
  echo '&ARE=';
  echo $ARE;
  echo '&KIND=';
  echo $KIND;
  echo '&SELLMODE=';
  echo $SELLMODE;
  echo '&ATTRIBUTE=';
  echo $ATTRIBUTE;
  echo '&ENTERTYPE=';
  echo $ENTERTYPE;
  echo '&PRODUCT_NAME=';
  echo $PRODUCT_NAME;
  echo '&PRODUCT_MODE=';
  echo $PRODUCT_MODE;
  echo '&PRODUCT_TYPE=';
  echo $PRODUCT_TYPE;
  echo '&SERVICE_NAME=';
  echo $SERVICE_NAME;
  echo '&SERVICE_DESC=';
  echo $SERVICE_DESC;
  echo '&DATE1=';
  echo $DATE1;
  echo '&DATE2=';
  echo $DATE2;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&CUR_PAGE="+PAGE_START;
}
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"';
  echo 'px");
}
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("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"';
  echo ').checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
function delete_mail()
{
  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)
  {
      ';
  echo 'el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("请至少选择其中一条销售记录。");
     return;
  }
  msg=\'确认要删除所选销售记录？\';
  if(window.confirm(msg))
  {
    URL="delete.php?CUSTOMER_NAME=';
  echo $CUSTOMER_NAME;
  echo '&CUSTOMER_CODE=';
  echo $CUSTOMER_CODE;
  echo '&CUSTOMER_SHORT=';
  echo $CUSTOMER_SHORT;
  echo '&ARE=';
  echo $ARE;
  echo '&KIND=';
  echo $KIND;
  echo '&SELLMODE=';
  echo $SELLMODE;
  echo '&ATTRIBUTE=';
  echo $ATTRIBUTE;
  echo '&ENTERTYPE=';
  echo $ENTERTYPE;
  echo '&PRODUCT_NAME=';
  echo $PRODUCT_NAME;
  echo '&PRODUCT_MODE=';
  echo $PRODUCT_MODE;
  echo '&PRODUCT_TYPE=';
  echo $PRODUCT_TYPE;
  echo '&SERVICE_NAME=';
  echo $SERVICE_NAME;
  echo '&SERVICE_DESC=';
  echo $SERVICE_DESC;
  echo '&DATE1=';
  echo $DATE1;
  echo '&DATE2=';
  echo $DATE2;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&delete_str=" + delete_str;
    window.location=URL;
  }
}
</script>
</head>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
	 <legend class="small" align=left>
      <b>快速查询</b>
  </legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
  <form action="index.php"  method="post" name="form1">
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;客户';
  echo '名称： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_NAME" class="SmallInput" size="15" maxlength="100" value="';
  echo $CUSTOMER_NAME;
  echo '">
    </td>
   <td nowrap class="TableData">客户编码： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_CODE" class="SmallInput" size="15" maxlength="100" value="';
  echo $CUSTOMER_CODE;
  echo '">
    </td>
    <td nowrap class="TableData">客户简称： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_SHORT" class="SmallInput" size="15" maxlength="100" value="';
  echo $CUSTOMER_SHORT;
  echo '">
    </td>
    <td nowrap class="TableData">地区： </td>
    <td nowrap class="TableData" >
        ';
  echo '<s';
  echo 'elect name="ARE" class="SmallSelect">
';
  getalldate ('AREA', $ARE);
  echo '        </select>
    </td>
   </tr>
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;客户类别： </td>
    <td nowrap class="TableData" >
        ';
  echo '<s';
  echo 'elect name="KIND" class="SmallSelect">
';
  getalldate ('CRM_KIND', $KIND);
  echo '        </select>
    </td>
    <td nowrap class="TableData">销售方式： </td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="SELLMODE" class="SmallSelect">
';
  getalldate ('SELL_MODE', $SELLMODE);
  echo '        </select>
    </td>
  <td nowrap class="TableData">行业属性： </td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="ATTRIBUTE" class="SmallSelect">
';
  getalldate ('CRM_ATTRIBUTE', $ATTRIBUTE);
  echo '        </select>
    </td>
   <td nowrap class="TableData">企业性质： </td>
    <td nowrap class="TableData" >
        ';
  echo '<s';
  echo 'elect name="ENTERTYPE" class="SmallSelect">
';
  getalldate ('CRM_TYPE', $ENTERTYPE);
  echo '        </select>
    </td>
  </tr>
 <tr>
 	<td nowrap class="TableData">&nbsp;&nbsp;产品类别：</td>
    <td nowrap class="TableData">
      ';
  echo '<s';
  echo 'elect name="PRODUCT_MODE" class="SmallSelect">
';
  getalldate ('PRODUCT_MODE', $PRODUCT_MODE);
  echo '      </select>
    </td>
    <td nowrap class="TableData">产品名称： </td>
    <td nowrap class="TableData">
        <input type="text" name="PRODUCT_NAME" class="SmallInput" size="15" maxlength="100">
    </td>
   <td nowrap class="TableData">产品型号： </td>
    <td nowrap class="TableData"  colspan="3">
        <input type="text" name="PRODUCT_TYPE" class="SmallInput" size="15" maxlength="100">
';
  echo '    </td>
   </tr>
 </tr>
 <tr>
 	   <td nowrap class="TableData">&nbsp;&nbsp;服务名称： </td>
     <td nowrap class="TableData">
        <input type="text" name="SERVICE_NAME" class="SmallInput" size="15" maxlength="100">
     </td>
     <td nowrap class="TableData">服务描述： </td>
    <td nowrap class="TableData" colspan="5">
       <textarea cols=37 rows=1 name="SERVICE_DESC" class="SmallInput" w';
  echo 'rap="yes">';
  echo $MEMO;
  echo '</textarea>
    </td>
 </tr>
 <tr>
 	<td nowrap class="TableData">&nbsp;&nbsp;记录日期： </td>
 	<td nowrap class="TableData" colspan="3">
      <input type="text" name="DATE1" size="15" maxlength="10" class="SmallStatic" readonly value="';
  echo $DATE1;
  echo '">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.DATE1\');">
       至<input type="text" name="DATE2" size="15" maxlength="10" class="SmallStatic" readonly value="';
  echo $DATE2;
  echo '">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.DATE2\');">
 	<td nowrap class="TableData"  colspan="3" >
 	&nbsp;<input value="快速查询" type="submit" class="SmallButton" title="快速查询" name="button">
  </td>
 </tr>
</form>
</table>
</fieldset>
</div>
<br>
';
  ($WHERE_STR .= (((((''.' where (a.SALESMAN=\'').$LOGIN_USER_ID).'\' or a.CREATOR=\'').$LOGIN_USER_ID).'\') and a.CONTRACT_ID=\'-1\' and a.LINE_ID=\'-1\' '));
  if (($CUSTOMER_NAME != ''))
  {
    ($WHERE_STR .= ((' and b.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
  }
  if (($CUSTOMER_CODE != ''))
  {
    ($WHERE_STR .= ((' and b.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
  }
  if (($CUSTOMER_SHORT != ''))
  {
    ($WHERE_STR .= ((' and b.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
  }
  if (($ARE != ''))
  {
    ($WHERE_STR .= (((''.' and b.CUSTOMER_AREA= \'').$ARE).'\''));
  }
  if (($KIND != ''))
  {
    ($WHERE_STR .= (((''.' and b.KIND= \'').$KIND).'\''));
  }
  if (($SELLMODE != ''))
  {
    ($WHERE_STR .= (((''.' and b.SELLMODE= \'').$SELLMODE).'\''));
  }
  if (($ATTRIBUTE != ''))
  {
    ($WHERE_STR .= (((''.' and b.ATTRIBUTE= \'').$ATTRIBUTE).'\''));
  }
  if (($ENTERTYPE != ''))
  {
    ($WHERE_STR .= (((''.' and b.ENTERTYPE= \'').$ENTERTYPE).'\''));
  }
  if (($PRODUCT_NAME != ''))
  {
    ($WHERE_STR .= ((' and c.PRODUCT_NAME like \'%'.$PRODUCT_NAME).'%\''));
  }
  if (($PRODUCT_MODE != ''))
  {
    ($WHERE_STR .= (((''.' and c.PRODUCT_MODE =\'').$PRODUCT_MODE).'\''));
  }
  if (($PRODUCT_TYPE != ''))
  {
    ($WHERE_STR .= ((' and c.PRODUCT_TYPE like \'%'.$PRODUCT_TYPE).'%\''));
  }
  if (($SERVICE_NAME != ''))
  {
    ($WHERE_STR .= ((' and d.SERVICE_NAME like \'%'.$SERVICE_NAME).'%\''));
  }
index.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 index.php 源码文件，采用 PHP 编程语言编写，共 1,211 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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