📄 showdetail.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  function getalldate ($CODE, $GETVALUE)
  {
    global $connection;
    $query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $CODE_NO = $ROW['CODE_NO'];
      $CODE_NAME = $ROW['CODE_NAME'];
      if (($CODE_NO == $GETVALUE))
      {
        echo $CODE_NAME;
        break;
      }
    }
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '<html>
<head>
<title>客户服务记录详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $query = ((''.'SELECT * from CONTACT where CONTACT_ID=').$CONTACT_ID);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $CONTACT_TYPE1 = $ROW['CONTACT_TYPE'];
    $CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
    $CONTACT_CONTENT1 = $ROW['CONTACT_CONTENT'];
    $CONTACT_CONTENT1 = str_replace ('"', '\'', $CONTACT_CONTENT1);
    $CONTACT_CONTENT1 = str_replace ('
', '<br>', $CONTACT_CONTENT1);
    $TIME_COST1 = $ROW['TIME_COST'];
    $MONEY_COST1 = $ROW['MONEY_COST'];
    $CONTACT_DATE1 = $ROW['CONTACT_DATE'];
    $LINKMAN_ID1 = $ROW['LINKMAN_ID'];
    $MEMO11 = $ROW['MEMO'];
    $MEMO12 = $ROW['MEMO1'];
    $SATISFY1 = $ROW['SATISFY'];
    $FEEDBACK1 = $ROW['FEEDBACK'];
    $USERDEF11 = $ROW['USERDEF1'];
    $USERDEF21 = $ROW['USERDEF2'];
    $USERDEF31 = $ROW['USERDEF3'];
    $USERDEF41 = $ROW['USERDEF4'];
    $USERDEF51 = $ROW['USERDEF5'];
  }
  $query = (((''.'SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID=\'').$CUSTOMER_ID1).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
  }
  $query = (((''.'SELECT LINKMAN_NAME from LINKMAN  where LINKMAN_ID=\'').$LINKMAN_ID1).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $LINKMAN_NAME1 = $ROW['LINKMAN_NAME'];
  }
  echo '<table border="0" width="100%"  cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/customerdetail.gif" align="absmiddle">&nbsp;&nbsp;';
  echo '<s';
  echo 'pan class="big3">客户服务信息查看</span>
    </td>
  </tr>
</table>
<br>
<table border="0" cellspacing="1" width="90%" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form method="post" name="form1">
   <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
     客户服务基本信息：
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">服务类型： </td>
    <td cl';
  echo 'ass="TableData">
';
  getalldate ('CONTACT_TYPE', $CONTACT_TYPE1);
  echo '     </td>
    <td nowrap class="TableData">服务日期： </td>
    <td nowrap class="TableData">
       ';
  echo $CONTACT_DATE1;
  echo '    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">客户名称： </td>
    <td class="TableData">
      ';
  echo $CUSTOMER_NAME1;
  echo '    </td>
    <td nowrap class="TableData">联系人： </td>
    <td nowrap class="TableData">
    	';
  echo $LINKMAN_NAME1;
  echo '    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">服务预估成本： </td>
    <td class="TableData">
      ';
  echo $MONEY_COST1;
  echo '元
    </td>
    <td nowrap class="TableData">时间成本： </td>
    <td nowrap class="TableData">
      ';
  echo $TIME_COST1;
  echo '小时
    </td>
   </tr>
  <tr>
    <td nowrap class="TableData">服务内容描述：</td>
    <td nowrap  class="TableData" colspan="3">
      ';
  echo $CONTACT_CONTENT1;
  echo '    </td>
  </tr>
   <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
     客户反馈：
    </td>
 </tr>
 <tr>
    <td nowrap class="TableData">客户满意度： </td>
    <td nowrap class="TableData" colspan="3">
       ';
  if (($SATISFY1 == '01'))
  {
    echo '很满意';
  }
  if (($SATISFY1 == '02'))
  {
    echo '比较满意';
  }
  if (($SATISFY1 == '3'))
  {
    echo '不满意';
  }
  if (($SATISFY1 == '05'))
  {
    echo '';
  }
  echo '    </td>
  </tr>
  <tr>
    <td nowrap class="TableData">客户反馈意见： </td>
    <td nowrap class="TableData" colspan="3">
      ';
  echo $FEEDBACK1;
  echo '    </td>
  </tr>
<tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
     描述：
    </td>
</tr>
<tr>
    <td nowrap class="TableData">备注1： </td>
    <td nowrap class="TableData" colspan="3">
      ';
  echo $MEMO11;
  echo '    </td>
</tr>
<tr>
    <td nowrap class="TableData">备注2： </td>
    <td nowrap class="TableData" colspan="3">
      ';
  echo $MEMO12;
  echo '    </td>
</tr>
<tr>
    <td class="TableData" colspan="8">
      ';
  echo get_field_table (get_field_text ('CONTACT', $CONTACT_ID));
  echo '     </td>
</tr>
<tr>
    <td nowrap  class="TableControl" colspan="4" align="center">
      &nbsp;<input type="button" value="关闭" class="SmallButton" onclick="window.close()">
    </td>
</tr>
</form>
</table>
</body>
</html>
';
?>
⌨️ 快捷键说明

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