📄 new.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>自定义字段</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n if(document.form1.FIELDNAME.value==\"\")\r\n { alert(\"字段名称不能为空！\");\r\n return (false);\r\n }\r\n \r\n if(document.form1.ORDERNO.value==\"\")\r\n { alert(\"排序号不能为空！\");\r\n return (false);\r\n }\r\n \r\n if(document.form1.STYPE.value==\"D\" || document.form1.STYPE.value==\"R\" || document.form1.STYPE.value==\"C\")\r\n { \r\n \t if(document.form1.TYPECODE.value==\"\" && (document.form1.TYPENAME.value==\"\" || document.form1.TYPEVALUE.value==\"\"))\r\n \t {\r\n \t alert(\"选项不能为空！\");\r\n return (false);\r\n }\r\n }\r\n}\r\n\r\nfunction SelChange()\r\n{\r\n if(document.form1.STYPE.value==\"T\" || document.form1.STYPE.value==\"MT\" || document.form1.STYPE.value==\"F\" || document.form1.STYPE.value==\"DT\" || document.form1.STYPE.value==\"TT\" || document.form1.STYPE.value==\"UT\" || document.form1.STYPE.value==\"NT\" || document.form1.STYPE.value==\"\")\r\n {\r\n document.getElementById(\"select_option\").style.display=\"none\";\r\n document.getElementById(\"code_list\").style.display=\"none\";\r\n document.getElementById(\"code_def\").style.display=\"none\";\r\n }\r\n else\r\n {\r\n \t document.getElementById(\"select_option\").style.display=\"\";\r\n \t \r\n \t if(document.getElementById(\"CODE_TYPE1\").checked)\r\n \t SelCode(1);\r\n \t if(document.getElementById(\"CODE_TYPE2\").checked)\r\n \t SelCode(2);\r\n }\r\n}\r\nfunction SelCode(val)\r\n{\r\n if(val==1)\r\n {\r\n document.getElementById(\"code_list\").style.display=\"\";\r\n document.getElementById(\"code_def\").style.display=\"none\";\r\n }\r\n else if(val==2)\r\n {\r\n document.getElementById(\"code_list\").style.display=\"none\";\r\n document.getElementById(\"code_def\").style.display=\"\";\r\n }\r\n form1.CODE_TYPE.value=val;\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"document.form1.FIELDNAME.focus();\">\r\n";
$query = "SELECT * from SYS_CODE where CODE_NO='".$TABLENAME."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NAME = $ROW['CODE_NAME'];
}
if ( $FIELDNO != "" )
{
$query = "SELECT * from FIELDSETTING where TABLENAME='".$TABLENAME."' and FIELDNO='{$FIELDNO}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELDNO = $ROW['FIELDNO'];
$FIELDNAME = $ROW['FIELDNAME'];
$ORDERNO = $ROW['ORDERNO'];
$STYPE = $ROW['STYPE'];
$TYPECODE = $ROW['TYPECODE'];
$TYPENAME = $ROW['TYPENAME'];
$TYPEVALUE = $ROW['TYPEVALUE'];
$ISQUERY = $ROW['ISQUERY'];
if ( $TYPECODE != "" )
{
$CODE_TYPE = 1;
}
else if ( $TYPENAME != "" && $TYPECODE == "" )
{
$CODE_TYPE = 2;
}
}
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 增加自定义字段 — ";
echo $CODE_NAME;
echo "</span>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"90%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n <form action=\"insert.php\" method=\"post\" name=\"form1\" onsubmit=\"return CheckForm();\">\r\n <tr class=\"TableData\">\r\n <td width=\"80\">字段名称：</td>\r\n <td>\r\n <input type=\"text\" name=\"FIELDNAME\" class=\"BigInput\" size=\"20\" maxlength=\"100\" value=\"";
echo $FIELDNAME;
echo "\"> \r\n </td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>排 序 号：</td>\r\n <td>\r\n <input type=\"text\" name=\"ORDERNO\" class=\"BigInput\" size=\"12\" maxlength=\"20\" value=\"";
echo $ORDERNO;
echo "\">\r\n </td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>字段类型：</td>\r\n <td>\r\n <select name=\"STYPE\" class=\"BigSelect\" onchange=\"SelChange();\">\r\n <option value=\"T\"";
if ( $STYPE == "T" )
{
echo " selected";
}
echo ">单行输入框</option>\r\n <option value=\"MT\"";
if ( $STYPE == "MT" )
{
echo " selected";
}
echo ">多行输入框</option>\r\n <option value=\"NT\"";
if ( $STYPE == "NT" )
{
echo " selected";
}
echo ">数字输入框</option>\r\n <option value=\"UT\"";
if ( $STYPE == "UT" )
{
echo " selected";
}
echo ">网址输入框</option>\r\n <option value=\"DT\"";
if ( $STYPE == "DT" )
{
echo " selected";
}
echo ">日期输入框</option>\r\n <option value=\"TT\"";
if ( $STYPE == "TT" )
{
echo " selected";
}
echo ">时间输入框</option>\r\n <option value=\"D\"";
if ( $STYPE == "D" )
{
echo " selected";
}
echo ">下拉菜单</option>\r\n <option value=\"R\"";
if ( $STYPE == "R" )
{
echo " selected";
}
echo ">单选框</option>\r\n <option value=\"C\"";
if ( $STYPE == "C" )
{
echo " selected";
}
echo ">复选框</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr class=\"TableData\" id=\"select_option\" style=\"display:";
if ( $STYPE == "T" || $STYPE == "MT" || $STYPE == "F" || $STYPE == "DT" || $STYPE == "TT" || $STYPE == "UT" || $STYPE == "NT" || $STYPE == "" )
{
echo "none";
}
else
{
echo "";
}
echo ";\">\r\n <td>代码类型：</td>\r\n <td>\r\n <input type=\"radio\" name=\"radio\" id=\"CODE_TYPE1\"";
if ( $TYPECODE != "" )
{
echo " checked";
}
echo " onclick=\"SelCode(1);\"><label for=\"CODE_TYPE1\">系统代码</label>\r\n <input type=\"radio\" name=\"radio\" id=\"CODE_TYPE2\"";
if ( $TYPENAME != "" && $TYPECODE == "" )
{
echo " checked";
}
echo " onclick=\"SelCode(2);\"><label for=\"CODE_TYPE2\">自定义选项</label>\r\n </td>\r\n </tr>\r\n <tr class=\"TableData\" id=\"code_list\" style=\"display:";
if ( ( $STYPE == "D" || $STYPE == "R" || $STYPE == "C" ) && $TYPECODE != "" )
{
echo "";
}
else
{
echo "none";
}
echo ";\">\r\n <td>系统代码：</td>\r\n <td>\r\n <select class=\"BigSelect\" name=\"TYPECODE\">\r\n <option value=\"\"></option>\r\n";
$query = "SELECT * from SYS_CODE where PARENT_NO='' order by CODE_ORDER";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_ID = $ROW['CODE_ID'];
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
if ( $CODE_NO == $TYPECODE )
{
$SELECTED = "selected";
}
else
{
$SELECTED = "";
}
echo " <option value=\"".$CODE_NO."\" ".$SELECTED.">".$CODE_NAME."</option>\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n <tbody id=\"code_def\" style=\"display:";
if ( ( $STYPE == "D" || $STYPE == "R" || $STYPE == "C" ) && $TYPENAME != "" && $TYPECODE == "" )
{
echo "";
}
else
{
echo "none";
}
echo ";\">\r\n <tr class=\"TableData\">\r\n <td>选项名称：</td>\r\n <td>\r\n <textarea name=\"TYPENAME\" cols=\"45\" rows=\"3\">";
echo $TYPENAME;
echo "</textarea>\r\n <br>显示的选项，用中文或西文逗号隔开如:（选项1,选项2,选项3）</font>\r\n </td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>选项的值：</td>\r\n <td>\r\n <textarea name=\"TYPEVALUE\" cols=\"45\" rows=\"3\">";
echo $TYPEVALUE;
echo "</textarea>\r\n <br>选项对应存储的值，非重复的数字，用逗号隔开如:（1,2,3）\r\n </td>\r\n </tr>\r\n </tbody>\r\n <tr class=\"TableData\">\r\n <td>字段选项：</td>\r\n <td>\r\n <input type=\"checkbox\" name=\"ISQUERY\" id=\"ISQUERY\"";
if ( $ISQUERY == "1" )
{
echo " checked";
}
echo "><label for=\"ISQUERY\">做为查询字段</label>\r\n </td>\r\n </tr>\r\n <tr class=\"TableControl\">\r\n <td nowrap colspan=\"2\" align=\"center\">\r\n <input type=\"hidden\" name=\"TABLENAME\" value=\"";
echo $TABLENAME;
echo "\">\r\n <input type=\"hidden\" name=\"FIELDNO\" value=\"";
echo $FIELDNO;
echo "\">\r\n <input type=\"hidden\" name=\"CODE_TYPE\" value=\"";
echo $CODE_TYPE;
echo "\">\r\n <input type=\"submit\" value=\"确定\" class=\"BigButton\"> \r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"history.back();\">\r\n </td>\r\n </form>\r\n</table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -