📄 query.php
字号:
<?php
include_once( "../auth1.php" );
include_once( "inc/auth.php" );
include_once( "inc/utility.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</head>\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\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:2";
echo "80px;dialogHeight:205px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\r\n}\r\n</SCRIPT>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\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 ) )
{
$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 ) )
{
$TABLE_ID = $ROW['TABLE_ID'];
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\" align=\"center\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 请指定查询条件</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n\r\n<table border=\"0\" width=\"500\" cellpadding=\"3\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n<form action=\"search.php\" target=\"_parent\" method=\"post\" name=\"form1\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\"><b>名称</b></td>\r\n <td nowrap align=\"center\"><b>关系</b></td>\r\n <td nowrap align=\"c";
echo "enter\"><b>取值</b></td>\r\n <td nowrap align=\"center\"><b>列表项</b></td>\r\n <td nowrap align=\"center\"><b>排序项</b></td>\r\n <td nowrap align=\"center\"><b>合计项</b></td>\r\n </tr>\r\n\r\n";
$query = "SELECT * from IK_FIELD where TABLE_ID={$TABLE_ID} order by FIELD_INDEX DESC,FIELD_ID";
$cursor = exequery( $connection, $query );
while ( $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_RELATION == $ID )
{
$INIT_VALUE = $ID_VALUE;
}
$INIT_VALUE = "'".$INIT_VALUE."'";
$FIELD_NAME_STR .= $FIELD_NAME.",";
++$ELEMENT_COUNT;
if ( $FIELD_INTERFACE_TYPE == 1 )
{
$ELEMENT = "<INPUT type=text name=\"{$FIELD_NAME}\" size=34 class=SmallInput>";
}
else if ( $FIELD_INTERFACE_TYPE == 2 )
{
$ELEMENT = "<INPUT type=text name=\"{$FIELD_NAME}\" size=34 class=SmallInput>";
}
else if ( $FIELD_INTERFACE_TYPE == 3 )
{
$ELEMENT = "<SELECT name=\"{$FIELD_NAME}\" style=\"width:215px\" class=SmallSelect><option value='SELECT_ALL_VALUE'>所有</option>";
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=\"{$FIELD_NAME}\">";
$ELEMENT .= "<input type=text name=\"".$FIELD_NAME."_FIELDDESC\" class=BigStatic size=20 maxlength=100 readonly>";
$ELEMENT .= "<input type=button value='选 择' class=SmallButton style=height:22px onClick=LoadWindow({$FIELD_ID},'{$FIELD_NAME}','".$FIELD_NAME."_FIELDDESC') title=选择 name=button>";
$ELEMENT .= "</td></tr></table>";
}
else if ( $FIELD_INTERFACE_TYPE == 5 )
{
$ELEMENT = "<SELECT name=\"{$FIELD_NAME}\" style='width:215px' class=SmallSelect><option value='SELECT_ALL_VALUE'>所有</option><option value='CHECKBOX_ON'>是</option><option value='CHECKBOX_OFF'>否</option></SELECT>";
}
if ( $ELEMENT_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap>";
echo $FIELD_DESC;
echo "：</td>\r\n <td nowrap>\r\n";
if ( $FIELD_TYPE != "D" )
{
echo " ";
echo "<s";
echo "elect name=\"";
echo $FIELD_NAME;
echo "_RELATION\" style='width:70px' class=\"SmallSelect\">\r\n <option value=\"1\">等于</option>\r\n";
if ( $FIELD_INTERFACE_TYPE != 3 )
{
echo " <option value=\"2\">大于</option>\r\n <option value=\"3\">小于</option>\r\n <option value=\"4\">大于等于</option>\r\n <option value=\"5\">小于等于</option>\r\n <option value=\"6\">不等于</option>\r\n";
if ( $FIELD_TYPE != "N" )
{
echo " <option value=\"7\">开始为</option>\r\n <option value=\"8\" selected>包含</option>\r\n <option value=\"9\">结束为</option>\r\n";
}
}
echo " </select>\r\n\r\n";
}
echo " </td>\r\n <td nowrap>\r\n";
if ( $FIELD_TYPE != "D" )
{
echo $ELEMENT;
}
else
{
$CUR_DATE = date( "Y-m-d", time( ) );
echo "从 <INPUT type=text name=\"";
echo $FIELD_NAME;
echo "_TIME1\" size=10 class=SmallInput><img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.";
echo $FIELD_NAME;
echo "_TIME1');\">\r\n至 <INPUT type=text name=\"";
echo $FIELD_NAME;
echo "_TIME2\" size=10 class=SmallInput><img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.";
echo $FIELD_NAME;
echo "_TIME2');\">\r\n";
}
echo " </td>\r\n <td align=\"center\">\r\n <input type=\"checkbox\" name=\"";
echo $FIELD_NAME;
echo "_LIST_CHECK\" ";
if ( find_id( $APP_FLD_LIST, $FIELD_NAME ) )
{
echo "checked";
}
echo ">\r\n </td>\r\n <td nowrap align=\"center\">\r\n 排序<input type=\"checkbox\" name=\"";
echo $FIELD_NAME;
echo "_ORDER_CHECK\">\r\n 逆序<input type=\"checkbox\" name=\"";
echo $FIELD_NAME;
echo "_REV_CHECK\">\r\n </td>\r\n <td align=\"center\">\r\n <input type=\"checkbox\" name=\"";
echo $FIELD_NAME;
echo "_REPORT_CHECK\" ";
if ( find_id( $APP_FLD_REPORT, $FIELD_NAME ) )
{
echo "checked";
}
echo ">\r\n </td>\r\n </tr>\r\n";
}
echo "\r\n<INPUT type=hidden name=\"TABLE_ID\" value=\"";
echo $TABLE_ID;
echo "\">\r\n<INPUT type=hidden name=\"FIELD_NAME_STR\" value=\"";
echo $FIELD_NAME_STR;
echo "\">\r\n<INPUT type=hidden name=\"APP_ID\" value=\"";
echo $APP_ID;
echo "\">\r\n\r\n</form>\r\n</table>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -