insert.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 94 行

PHP
94
字号
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>增加自定义字段</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  if (($CODE_TYPE == '1'))
  {
    $TYPENAME = '';
    $TYPEVALUE = '';
  }
  if (($CODE_TYPE == '2'))
  {
    $TYPECODE = '';
  }
  if (($TYPENAME != ''))
  {
    $TYPEVALUE = str_replace (',', ',', $TYPEVALUE);
    if ((substr ($TYPEVALUE, -1) == ','))
    {
      $TYPEVALUE = substr ($TYPEVALUE, 0, -1);
    }
    $TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
    $TYPENAME = str_replace (',', ',', $TYPENAME);
    if ((substr ($TYPENAME, -1) == ','))
    {
      $TYPENAME = substr ($TYPENAME, 0, -1);
    }
    $TYPENAME_ARRAY = explode (',', $TYPENAME);
    if ((count ($TYPENAME_ARRAY) != count ($TYPEVALUE_ARRAY)))
    {
      message ('', '选项名称和选项的值 项数不相等');
      button_back ();
      exit ();
    }
    if ((count ($TYPEVALUE_ARRAY) != count (array_unique ($TYPEVALUE_ARRAY))))
    {
      message ('', '选项的值 中有重复数值');
      button_back ();
      exit ();
    }
    if (!(array_search ('', $TYPEVALUE_ARRAY) === false))
    {
      message ('', '选项的值 中不能有空值');
      button_back ();
      exit ();
    }
  }
  if (($ISQUERY == 'on'))
  {
    $ISQUERY = 1;
  }
  if (($ISGROUY == 'on'))
  {
    $ISGROUY = 1;
  }
  if (($FIELDNO == ''))
  {
    $maxcount = 0;
    $query = (((''.'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'').$TABLENAME).'\'');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $FIELDNO = $ROW['FIELDNO'];
      if (($maxcount < intval (substr ($FIELDNO, 7))))
      {
        $maxcount = intval (substr ($FIELDNO, 7));
        continue;
      }
    }
    $FIELDNO = ('USERDEF'.($maxcount + 1));
    $query = (((((((((((((((((((((''.'insert into FIELDSETTING(TABLENAME,FIELDNO,FIELDNAME,ORDERNO,STYPE,TYPENAME,TYPEVALUE,TYPECODE,ISQUERY,ISGROUY) values (\'').$TABLENAME).'\',\'').$FIELDNO).'\',\'').$FIELDNAME).'\',\'').$ORDERNO).'\',\'').$STYPE).'\',\'').$TYPENAME).'\',\'').$TYPEVALUE).'\',\'').$TYPECODE).'\',\'').$ISQUERY).'\',\'').$ISGROUY).'\')');
  }
  else
  {
    $query = (((((((((((((((((((((''.'update FIELDSETTING set FIELDNAME=\'').$FIELDNAME).'\',ORDERNO=\'').$ORDERNO).'\',STYPE=\'').$STYPE).'\',TYPENAME=\'').$TYPENAME).'\',TYPEVALUE=\'').$TYPEVALUE).'\',TYPECODE=\'').$TYPECODE).'\',ISQUERY=\'').$ISQUERY).'\',ISGROUY=\'').$ISGROUY).'\' where TABLENAME=\'').$TABLENAME).'\' and FIELDNO=\'').$FIELDNO).'\'');
  }
  exequery ($connection, $query);
  message ('', '增加成功!');
  echo '
';
  echo '<s';
  echo 'cript>
parent.code_list.location.reload();
</script>
</body>
</html>
';
?>

⌨️ 快捷键说明

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