⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 通达OA2007SE源代码 非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<?
  function getalldate ($CODE)
  {
    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'];
      echo (((('<option value='.$CODE_NO).'>').$CODE_NAME).'</option>');
    }
  }
  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 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 chk(input,KC,KT,count)
{
  var lstr="";
  if(count==1)
  {
  	if(document.all(KC).checked)
  	{
  		document.all(KT).value=document.all(KC).value;
  	}
   else
    {
   	 document.all(KT).value="";
    }
  }
  else
  {
    for(i=0;i<document.all(KC).length;i++)
    {
       el=document.all(KC).item(i);
       if(el.checked)
       {
       	 val=el.value;
';
  echo '          lstr+=val+",";
       }
     }
     document.all(KT).value=lstr;
  }
}
</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="list.php"  method="post" name="form1">
  <tr>
    <td nowrap class="TableD';
  echo 'ata">&nbsp;&nbsp;服务类型： </td>
    <td nowrap class="TableData">
     ';
  echo '<s';
  echo 'elect name="CONTACT_TYPE" class="SmallSelect">
';
  getalldate ('CONTACT_TYPE');
  echo '     </select>
    </td>
   <td nowrap class="TableData">服务日期： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="CONTACT_DATE1" class="SmallStatic"  readonly size="15" maxlength="100">&nbsp;
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.CONTACT_DATE1\');">
        至
        <input type="text" name="CON';
  echo 'TACT_DATE2" class="SmallStatic" size="15" readonly maxlength="100" >&nbsp;
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.CONTACT_DATE2\');">
    </td>
   </tr>
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;客户满意度： </td>
    <td nowrap class="TableData" >
       ';
  echo '<s';
  echo 'elect name="SATISFY" class="SmallSelect">
        	<option value=""></option>
        	<option value=01>很满意</option>
        	<option value=02>比较满意</option>
        	<option value=3>不满意</option>
        	<option value=05>很不满意</option>
        </select>
    </td>
    <td nowrap class="TableData">服务内容： </td>
    <td nowrap class="TableData" colspan="3">
         <textarea cols=37 rows=1';
  echo ' name="CONTACT_CONTENT" class="BigInput" wrap="yes"></textarea>
    </td>
  </tr>
 ';
  $count = 0;
  $query = 'select count(*) from FIELDSETTING where TABLENAME=\'CONTACT\' and ISQUERY=\'1\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $count = $ROW[0];
  }
  if ((0 < $count))
  {
    echo '   <tr>
    <td nowrap  class="TableHeader" colspan="6" align="left">
     &nbsp;&nbsp;用户自定义字段：
    </td>
   </tr>
';
    $query = 'select * from FIELDSETTING where TABLENAME=\'CONTACT\' AND ISQUERY=\'1\' ORDER BY ORDERNO ASC  ';
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $FIELDNAME = $ROW['FIELDNAME'];
      $ORDERNO = $ROW['ORDERNO'];
      $STYPE = $ROW['STYPE'];
      $TYPENAME = $ROW['TYPENAME'];
      $TYPEVALUE = $ROW['TYPEVALUE'];
      $TYPECODE = $ROW['TYPECODE'];
      $ISQUERY = $ROW['ISQUERY'];
      $ISGROUY = $ROW['ISGROUY'];
      $FIELDNAME = $ROW['FIELDNAME'];
      $FIELDNO = $ROW['FIELDNO'];
      echo '   <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;';
      echo $FIELDNAME;
      echo '：</td>
    <td nowrap class="TableData" colspan="5">
';
      if (($STYPE == 'T'))
      {
        echo '     <input type="text" name=\'CONTACT';
        echo $FIELDNO;
        echo '\' class="SmallInput" size="33" maxlength="25" value="">
';
      }
      if (($STYPE == 'MT'))
      {
        echo '     <textarea cols=37 rows=1 name=\'CONTACT';
        echo $FIELDNO;
        echo '\' class="SmallInput" wrap="yes"></textarea>
';
      }
      if (($STYPE == 'D'))
      {
        if (($TYPECODE != ''))
        {
          $query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
          $cursor2 = exequery ($connection, $query2);
          while ($ROW = mysql_fetch_array ($cursor2))
          {
            $CODE_NO = $ROW['CODE_NO'];
            $CODE_NAME = $ROW['CODE_NAME'];
            $TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
            $TYPENAME = (($TYPENAME.$CODE_NAME).',');
          }
        }
        $TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
        $TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
        $TYPENAME = str_replace ('，', ',', $TYPENAME);
        $TYPENAME_ARRAY = explode (',', $TYPENAME);
        $TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
        if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
        {
          --$TYPENAME_COUNT;
        }
        echo '       ';
        echo '<s';
        echo 'elect name=\'CONTACT';
        echo $FIELDNO;
        echo '\' class="SmallSelect">
       <option value=""></option>
';
        for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
        {
          echo '
       <option value="';
          echo $TYPEVALUE_ARRAY[$I];
          echo '">';
          echo $TYPENAME_ARRAY[$I];
          echo '</option>
';
        }
      }
      if (($STYPE == 'C'))
      {
        if (($TYPECODE != ''))
        {
          $query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
          $cursor2 = exequery ($connection, $query2);
          while ($ROW = mysql_fetch_array ($cursor2))
          {
            $CODE_NO = $ROW['CODE_NO'];
            $CODE_NAME = $ROW['CODE_NAME'];
            $TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
            $TYPENAME = (($TYPENAME.$CODE_NAME).',');
          }
        }
        $TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
        $TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
        $TYPENAME = str_replace ('，', ',', $TYPENAME);
        $TYPENAME_ARRAY = explode (',', $TYPENAME);
        $TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
        if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
        {
          --$TYPENAME_COUNT;
        }
        echo '       <input type="hidden" name=\'CONTACT';
        echo $FIELDNO;
        echo '\'>
';
        for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
        {
          echo '       <input type="checkbox" name=\'CCONTACT';
          echo $FIELDNO;
          echo '\' id=\'CCONTACT';
          echo $FIELDNO;
          echo $I;
          echo '\' value="';
          echo $TYPEVALUE_ARRAY[$I];
          echo '" onclick="return chk(this,\'CCONTACT';
          echo $FIELDNO;
          echo '\',\'CONTACT';
          echo $FIELDNO;
          echo '\',\'';
          echo $TYPENAME_COUNT;
          echo '\');"><label for="CCONTACT';
          echo $FIELDNO;
          echo $I;
          echo '">';
          echo $TYPENAME_ARRAY[$I];
          echo '</label>
';
        }
      }
      if (($STYPE == 'R'))
      {
        if (($TYPECODE != ''))
        {
          $query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
          $cursor2 = exequery ($connection, $query2);
          while ($ROW = mysql_fetch_array ($cursor2))
          {
            $CODE_NO = $ROW['CODE_NO'];
            $CODE_NAME = $ROW['CODE_NAME'];
            $TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
            $TYPENAME = (($TYPENAME.$CODE_NAME).',');
          }
        }
        $TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
        $TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
        $TYPENAME = str_replace ('，', ',', $TYPENAME);
        $TYPENAME_ARRAY = explode (',', $TYPENAME);
        $TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
        if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
        {
          --$TYPENAME_COUNT;
        }
        for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
        {
          echo '      <input type="radio" name=\'CONTACT';
          echo $FIELDNO;
          echo '\' id=\'CONTACT';
          echo $FIELDNO;
          echo $I;
          echo '\' value="';
          echo $TYPEVALUE_ARRAY[$I];
          echo '"><label for="CONTACT';
          echo $FIELDNO;
          echo $I;
          echo '">';
          echo $TYPENAME_ARRAY[$I];
          echo '</label>
';
        }
      }
      echo '
    </td>
 </tr>
';
    }
  }
  echo '
 <tr>
 		<td nowrap class="TableData"  colspan="6" align="right" width="650">
     &nbsp;&nbsp;&nbsp;<input value="查询" type="submit" class="SmallButton" title="查询" name="button">
     &nbsp;&nbsp;<input value="返回" type="button" class="SmallButton" title="返回" name="button" onclick="location=\'../\'">
    </td>
 </tr>
</table>
</fieldset>
</div>
<br>
<div align="left">
<fieldset style="width:';
  echo '95%;padding-bottom:5px;">
	 <legend class="small" align=left>
      <b>客户信息</b>
  </legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;客户名称： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_NAME" class="SmallInput" size="15" maxlength="100">
    </td>
   <td nowrap class="TableData">';
  echo '客户编码： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_CODE" class="SmallInput" size="15" maxlength="100">
    </td>
     <td nowrap class="TableData">客户简称： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_SHORT" class="SmallInput" size="15" maxlength="100">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">&nb';
  echo 'sp;&nbsp;地区： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_AREA" class="SmallInput" size="15" maxlength="100">
    </td>
   <td nowrap class="TableData">地址： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="CUSTOMER_ADD" class="SmallInput" size="43" maxlength="100">
    </td>
   </tr>
  <tr>
    <td nowrap class="TableDat';
  echo 'a">&nbsp;&nbsp;客户来源： </td>
    <td nowrap class="TableData" >
        ';
  echo '<s';
  echo 'elect name="SOURCE" class="SmallSelect">
';
  getalldate ('CRM_SOURCE');
  echo '        </select>
    </td>
    <td nowrap class="TableData">客户类别： </td>
    <td nowrap class="TableData" >
        ';
  echo '<s';
  echo 'elect name="KIND" class="SmallSelect">
';
  getalldate ('CRM_KIND');
  echo '        </select>
    </td>
    <td nowrap class="TableData">销售方式： </td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="SELLMODE" class="SmallSelect">
';
  getalldate ('SELL_MODE');
  echo '        </select>
    </td>
  </tr>
 <tr>
 	<td nowrap class="TableData">&nbsp;&nbsp;行业属性： </td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="ATTRIBUTE" class="SmallSelect">
';
  getalldate ('CRM_ATTRIBUTE');
  echo '        </select>
    </td>
   <td nowrap class="TableData">企业性质： </td>
    <td nowrap class="TableData" >
        ';
  echo '<s';
  echo 'elect name="ENTERTYPE" class="SmallSelect">
';
  getalldate ('CRM_TYPE');
  echo '        </select>
    </td>
  <td nowrap class="TableData">企业描述： </td>
    <td nowrap class="TableData"  colspan="2">
        <input type="text" name="ENTERMEMO" class="SmallInput" size="15" maxlength="100">
    </td>
 </tr>
';
  $count = 0;
  $query = 'select count(*) from FIELDSETTING where TABLENAME=\'CUSTOMER\' and ISQUERY=\'1\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $count = $ROW[0];
  }
  if ((0 < $count))
  {
    echo '   <tr>
    <td nowrap  class="TableHeader" colspan="6" align="left">
    &nbsp;&nbsp;用户自定义字段：
    </td>
   </tr>
';
    $query = 'select * from FIELDSETTING where TABLENAME=\'CUSTOMER\' AND ISQUERY=\'1\' ORDER BY ORDERNO ASC  ';
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
12

⌨️ 快捷键说明

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