📄 index.php

📁 通达OA2007SE源代码非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
上一页 12
    <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))
    {
      $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=\'CUSTOMER';
        echo $FIELDNO;
        echo '\' class="SmallInput" size="33" maxlength="25" value="">
';
      }
      if (($STYPE == 'MT'))
      {
        echo '     <textarea cols=37 rows=1 name=\'CUSTOMER';
        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=\'CUSTOMER';
        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=\'CUSTOMER';
        echo $FIELDNO;
        echo '\'>
';
        for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
        {
          echo '       <input type="checkbox" name=\'CCUSTOMER';
          echo $FIELDNO;
          echo '\' id=\'CCUSTOMER';
          echo $FIELDNO;
          echo $I;
          echo '\' value="';
          echo $TYPEVALUE_ARRAY[$I];
          echo '" onclick="return chk(this,\'CCUSTOMER';
          echo $FIELDNO;
          echo '\',\'CUSTOMER';
          echo $FIELDNO;
          echo '\',\'';
          echo $TYPENAME_COUNT;
          echo '\');"><label for="CCUSTOMER';
          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=\'CUSTOMER';
          echo $FIELDNO;
          echo '\' id=\'CUSTOMER';
          echo $FIELDNO;
          echo $I;
          echo '\' value="';
          echo $TYPEVALUE_ARRAY[$I];
          echo '"><label for="CUSTOMER';
          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">
      <input value="查询" type="submit" class="SmallButton" title="查询" name="button">
    </td>
 </tr>
</table>
</fieldset>
</div>
<br>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
	 <legend class="small" align=left>
      <b>联系人信息</b>
  </legend>
<table cellspacing="1" class="small" align="';
  echo 'left" cellpadding="3">
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;联系人姓名： </td>
    <td nowrap class="TableData">
        <input type="text" name="LINKMAN_NAME" class="SmallInput" size="15" maxlength="100">
    </td>
   <td nowrap class="TableData">性别：</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="SEX" class="SmallSelect">
        	<option value=""></option>
          <option value="0">男</option>
          <option value="1" >女</option>
        </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">
     </td>
 </tr>
</table>
</fieldset>
</div>
<br>
</form>
</body>
</html>
';
?>
上一页 12
⌨️ 快捷键说明

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