📄 index.php

📁 通达OA2007SE源代码非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
上一页 12
        </select>
    </td>
    <td nowrap class="TableData">爱好：</td>
    <td nowrap class="TableData">
        <input type="text" name="HOBBY" class="SmallInput" size="15" maxlength="100">
    </td>
    <td nowrap class="TableData">&nbsp;&nbsp;&';
  echo 'nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
    <td nowrap class="TableData">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
   </tr>
  ';
  $count = 0;
  $query = 'select count(*) from FIELDSETTING where TABLENAME=\'LINKMAN\' 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="8" align="left">
      &nbsp;&nbsp;用户自定义字段：
    </td>
   </tr>
';
    $query = 'select * from FIELDSETTING where TABLENAME=\'LINKMAN\' 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="7">
';
      if (($STYPE == 'T'))
      {
        echo '     <input type="text" name=\'LINKMAN';
        echo $FIELDNO;
        echo '\' class="SmallInput" size="33" maxlength="25" value="">
';
      }
      if (($STYPE == 'MT'))
      {
        echo '     <textarea cols=37 rows=1 name=\'LINKMAN';
        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=\'LINKMAN';
        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=\'LINKMAN';
        echo $FIELDNO;
        echo '\'>
';
        for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
        {
          echo '       <input type="checkbox" name=\'CLINKMAN';
          echo $FIELDNO;
          echo '\' id=\'CLINKMAN';
          echo $FIELDNO;
          echo $I;
          echo '\' value="';
          echo $TYPEVALUE_ARRAY[$I];
          echo '" onclick="return chk(this,\'CLINKMAN';
          echo $FIELDNO;
          echo '\',\'LINKMAN';
          echo $FIELDNO;
          echo '\',\'';
          echo $TYPENAME_COUNT;
          echo '\');"><label for="CLINKMAN';
          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=\'LINKMAN';
          echo $FIELDNO;
          echo '\' id=\'LINKMAN';
          echo $FIELDNO;
          echo $I;
          echo '\' value="';
          echo $TYPEVALUE_ARRAY[$I];
          echo '"><label for="LINKMAN';
          echo $FIELDNO;
          echo $I;
          echo '">';
          echo $TYPENAME_ARRAY[$I];
          echo '</label>
';
        }
      }
      echo '    </td>
 </tr>
';
    }
  }
  echo '
   <tr>
 		<td nowrap class="TableData"  colspan="8" 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="wi';
  echo 'dth: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">
     ';
  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" size="15" readonly maxlength="100">&nbsp;
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.CONTACT_DATE1\');">
        至
        <input type="text" name="CONT';
  echo 'ACT_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 ro';
  echo 'ws=1 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>
</form>
</table>
</fieldset>
</div>
</body>
</html>
';
?>
上一页 12
⌨️ 快捷键说明

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