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 + -
显示快捷键?