📄 new.php
字号:
<?php
include_once( "../auth1.php" );
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "../utility_html.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</head>\r\n\r\n";
echo "<S";
echo "CRIPT language=javascript>\r\nfunction clear_content(obj)\r\n{\r\n obj.value=\"\";\r\n}\r\n\r\nfunction LoadWindow(field_id,id,desc)\r\n{\r\n URL=\"../select?FIELD_ID=\"+field_id+\"&ID=\"+id+\"&DESC=\"+desc;\r\n loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n window.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizabl";
echo "e:1;dialogWidth:300px;dialogHeight:250px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\nfunction td_calendar(fieldname)\r\n{\r\n myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\r\n mytop=document.body.scrollTop+event.clientY-event.offsetY+140;\r\n\r\n window.showModalDialog(\"/inc/calendar.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280";
echo "px;dialogHeight:205px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\r\n}\r\n\r\nfunction td_clock(fieldname)\r\n{\r\n myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\r\n mytop=document.body.scrollTop+event.clientY-event.offsetY+140;\r\n\r\n window.showModalDialog(\"/inc/clock.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:120px;";
echo "dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\r\n}\r\n</SCRIPT>\r\n<body topmargin=\"5\">\r\n<center>\r\n<form enctype=\"multipart/form-data\" action=\"insert.php\" target=\"_parent\" method=\"post\" name=\"form1\">\r\n\r\n";
$connection = openconnection( );
$query = "SELECT * from IK_APP where APP_ID={$APP_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FORM_ID = $ROW['FORM_ID'];
$APP_FLD_VIEW = $ROW['APP_FLD_VIEW'];
$APP_FLD_READONLY = $ROW['APP_FLD_READONLY'];
$APP_FLD_LIST = $ROW['APP_FLD_LIST'];
$APP_FLD_REPORT = $ROW['APP_FLD_REPORT'];
$APP_FLD_CTRL = $ROW['APP_FLD_CTRL'];
$APP_DESC = $ROW['APP_DESC'];
}
$query = "SELECT * from IK_FORM where FORM_ID={$FORM_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FORM_ID = $ROW['FORM_ID'];
$TABLE_ID = $ROW['TABLE_ID'];
$FORM_HTML = $ROW['FORM_HTML'];
$FORM_DESC = $ROW['FORM_DESC'];
}
$PRINT_MODEL = $FORM_HTML;
$ELEMENT_ARRAY = html_element( $PRINT_MODEL );
$FIELD_NAME_STR = "";
$ELEMENT_NUM = sizeof( $ELEMENT_ARRAY );
$I = 0;
for ( ; $I < $ELEMENT_NUM; ++$I )
{
$ELEMENT = $ELEMENT_ARRAY[$I];
$ATTR_ARRAY = element_analysis( $ELEMENT );
$ENAME = "";
$ENAME = get_attr( $ATTR_ARRAY, "name" );
if ( find_id( $APP_FLD_VIEW, $ENAME ) )
{
$PRINT_MODEL = str_replace( $ELEMENT_ARRAY[$I], "", $PRINT_MODEL );
}
else
{
$query = "SELECT * from IK_FIELD where TABLE_ID={$TABLE_ID} and FIELD_NAME='{$ENAME}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELD_ID = $ROW['FIELD_ID'];
$TABLE_ID = $ROW['TABLE_ID'];
$FIELD_NAME = $ROW['FIELD_NAME'];
$FIELD_DESC = $ROW['FIELD_DESC'];
$FIELD_TYPE = $ROW['FIELD_TYPE'];
$FIELD_LEN = $ROW['FIELD_LEN'];
$FIELD_DEFVALUE = $ROW['FIELD_DEFVALUE'];
$FIELD_AUTOVALUE = $ROW['FIELD_AUTOVALUE'];
$FIELD_INDEX = $ROW['FIELD_INDEX'];
$FIELD_CODE_FIX = $ROW['FIELD_CODE_FIX'];
$FIELD_CODE_SQL = $ROW['FIELD_CODE_SQL'];
$FIELD_INTERFACE_TYPE = $ROW['FIELD_INTERFACE_TYPE'];
$FIELD_RELATION = $ROW['FIELD_RELATION'];
}
$INIT_VALUE = "";
if ( $FIELD_DEFVALUE != "" )
{
$INIT_VALUE = $FIELD_DEFVALUE;
}
else if ( $FIELD_AUTOVALUE != "" )
{
if ( $FIELD_AUTOVALUE == "D" )
{
$INIT_VALUE = date( "Y-m-d" );
}
else if ( $FIELD_AUTOVALUE == "T" )
{
$INIT_VALUE = date( "h:i:s" );
}
else if ( $FIELD_AUTOVALUE == "DT" )
{
$INIT_VALUE = date( "Y-m-d H:i:s", time( ) );
}
}
if ( $FIELD_RELATION == $ID )
{
$INIT_VALUE = $ID_VALUE;
}
$FIELD_NAME_STR .= $ENAME.",";
if ( $FIELD_INTERFACE_TYPE == 1 )
{
$ELEMENT = "<INPUT ";
$FLAG = true;
$ATTR_NUM = sizeof( $ATTR_ARRAY );
$INDEX = 0;
for ( ; $INDEX < $ATTR_NUM; ++$INDEX )
{
if ( $ATTR_ARRAY[$INDEX][0] == "value" && $ATTR_ARRAY[$INDEX][1] == "" )
{
$ATTR_ARRAY[$INDEX][1] = "\"".$INIT_VALUE."\"";
$FLAG = false;
}
$ELEMENT .= $ATTR_ARRAY[$INDEX][0]."=".$ATTR_ARRAY[$INDEX][1]." ";
}
if ( $FLAG )
{
$ELEMENT .= "value=\"".$INIT_VALUE."\"";
}
if ( find_id( $APP_FLD_READONLY, $ENAME ) )
{
$ELEMENT .= " readonly class=BigStatic";
}
else
{
$ELEMENT .= " class=BigInput";
}
$ELEMENT .= ">";
if ( $FIELD_AUTOVALUE == "D" && !find_id( $APP_FLD_READONLY, $ENAME ) )
{
$ELEMENT .= "<img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.".$ENAME."');\">";
}
else if ( $FIELD_AUTOVALUE == "T" && !find_id( $APP_FLD_READONLY, $ENAME ) )
{
$ELEMENT .= "<img src=\"/images/menu/clock.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_clock('form1.".$ENAME."');\">";
}
else if ( $FIELD_AUTOVALUE == "DT" && !find_id( $APP_FLD_READONLY, $ENAME ) )
{
$ELEMENT .= "<img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.".$ENAME."');\">";
$ELEMENT .= "<img src=\"/images/menu/clock.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_clock('form1.".$ENAME."');\">";
}
}
else if ( $FIELD_INTERFACE_TYPE == 2 )
{
$ELEMENT = "<TEXTAREA ";
$ATTR_NUM = sizeof( $ATTR_ARRAY );
$INDEX = 0;
for ( ; $INDEX < $ATTR_NUM; ++$INDEX )
{
$ELEMENT .= $ATTR_ARRAY[$INDEX][0]."=".$ATTR_ARRAY[$INDEX][1]." ";
}
if ( find_id( $APP_FLD_READONLY, $ENAME ) )
{
$ELEMENT .= " readonly class=BigStatic";
}
else
{
$ELEMENT .= " class=BigInput>";
}
if ( $INIT_VALUE != "''" )
{
$ELEMENT .= $INIT_VALUE."</TEXTAREA>";
}
$ELEMENT .= "</TEXTAREA>";
}
else if ( $FIELD_INTERFACE_TYPE == 3 )
{
$ELEMENT = "<SELECT ";
$ATTR_NUM = sizeof( $ATTR_ARRAY );
$INDEX = 0;
for ( ; $INDEX < $ATTR_NUM; ++$INDEX )
{
$ELEMENT .= $ATTR_ARRAY[$INDEX][0]."=".$ATTR_ARRAY[$INDEX][1]." ";
}
$ELEMENT .= " class=BigSelect";
$ELEMENT .= ">";
if ( $FIELD_CODE_SQL != "" )
{
$cursor1 = exequery( $connection, $FIELD_CODE_SQL );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$VALUE = $ROW1[0];
$DESC = $ROW1[1];
$ELEMENT .= "<option value={$VALUE}>{$DESC}</option>";
}
}
else if ( $FIELD_CODE_FIX != "" )
{
$OPTION_ARRAY = explode( ",", $FIELD_CODE_FIX );
$OPTION_ARRAY_NUM = sizeof( $OPTION_ARRAY );
$INDEX = 0;
for ( ; $INDEX < $OPTION_ARRAY_NUM; ++$INDEX )
{
$ELEMENT .= "<option value={$INDEX}>{$OPTION_ARRAY[$INDEX]}</option>";
}
}
$ELEMENT .= "</SELECT>";
}
else if ( $FIELD_INTERFACE_TYPE == 4 )
{
$ELEMENT = "<table border=0 cellspacing=0 cellpadding=0><tr><td>";
$ELEMENT .= "<input type=hidden name={$ENAME}>";
$ELEMENT .= "<input type=text name=".$ENAME."_FIELD_DESC class=BigStatic size=20 maxlength=100 readonly>";
if ( !find_id( $APP_FLD_READONLY, $ENAME ) )
{
$ELEMENT .= "<input type=button value='选 择' class=SmallButton style=height:22px onClick=LoadWindow({$FIELD_ID},'{$ENAME}','".$ENAME."_FIELD_DESC') title=选择 name=button>";
}
$ELEMENT .= "</td></tr></table>";
}
else if ( $FIELD_INTERFACE_TYPE == 5 )
{
$ELEMENT = "<INPUT ";
$ATTR_NUM = sizeof( $ATTR_ARRAY );
$INDEX = 0;
for ( ; $INDEX < $ATTR_NUM; ++$INDEX )
{
$ELEMENT .= $ATTR_ARRAY[$INDEX][0]."=".$ATTR_ARRAY[$INDEX][1]." ";
}
if ( find_id( $APP_FLD_READONLY, $ENAME ) )
{
$ELEMENT .= " readonly class=BigStatic";
}
else
{
$ELEMENT .= " class=BigInput";
}
$ELEMENT .= ">";
}
$PRINT_MODEL = str_replace( $ELEMENT_ARRAY[$I], $ELEMENT, $PRINT_MODEL );
}
}
echo $PRINT_MODEL;
$FIELD_NAME_STR = substr( $FIELD_NAME_STR, 0, strlen( $FIELD_NAME_STR ) - 1 );
echo "<INPUT type=hidden name=TABLE_ID value={$TABLE_ID}>";
echo "<INPUT type=hidden name=FIELD_NAME_STR value={$FIELD_NAME_STR}>";
echo "<INPUT type=hidden name=APP_TYPE value={$APP_TYPE}>";
echo "<INPUT type=hidden name=APP_ID value={$APP_ID}>";
echo "<INPUT type=hidden name=FORM_ID value={$FORM_ID}>";
echo "<INPUT type=hidden name=ID value={$ID}>";
echo "<INPUT type=hidden name=ID_VALUE value={$ID_VALUE}>";
echo "<br>";
echo "\r\n</form>\r\n";
echo "<S";
echo "CRIPT language=javascript>\r\nfunction check_form()\r\n{\r\n";
$APP_FLD_LIST_ARRAY = explode( ",", $APP_FLD_LIST );
$APP_FLD_LIST_NUM = sizeof( $APP_FLD_LIST_ARRAY ) - 1;
$I = 0;
for ( ; $I < $APP_FLD_LIST_NUM; ++$I )
{
$query = "select * from IK_FIELD where FIELD_NAME='{$APP_FLD_LIST_ARRAY[$I]}' and TABLE_ID={$TABLE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELD_DESC = $ROW['FIELD_DESC'];
}
echo " if(document.form1.{$APP_FLD_LIST_ARRAY[$I]}.value==\"\")\n";
echo " {\n";
echo " alert(\"【".$FIELD_DESC."】不能为空！\");\n";
echo " return;\n";
echo " }\n";
}
echo " document.form1.submit();\r\n}\r\n</script>\r\n</center>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -