index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 480 行 · 第 1/2 页

  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))
    {
      $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>
</form>
</body>
</html>
';
?>