📄 search.php
字号:
<?php
include_once( "../auth1.php" );
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/check_type.php" );
$connection = openconnection( );
$query = "SELECT * from IK_APP where APP_ID={$APP_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$APP_FLD_CTRL = $ROW['APP_FLD_CTRL'];
$APP_DESC = $ROW['APP_DESC'];
$EDIT_APP_ID = $ROW['EDIT_APP_ID'];
}
echo "\r\n<html>\r\n<head>\r\n<title>";
echo $APP_DESC;
echo "</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n";
echo "<s";
echo "cript>\r\nfunction delete_run(RUN_ID)\r\n{\r\n msg='确认要删除该记录么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"../delete.php?FLOW_ID=";
echo $FLOW_ID;
echo "&RUN_ID=\"+RUN_ID;\r\n location=url;\r\n }\r\n}\r\nfunction on_print(app_id,id,id_value)\r\n{\r\n URL=\"../print?APP_ID=\"+app_id+\"&ID=\"+id+\"&ID_VALUE=\"+id_value;\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.open(URL,\"表单打印页\",\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogTop:\"+loc_y+\"px;dialogLeft";
echo ":\"+loc_x+\"px\");\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/infofind.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 查询结果 - ";
echo $APP_DESC;
echo "</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n\r\n";
$query = "SELECT * from IK_TABLE where TABLE_ID={$TABLE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TABLE_NAME = $ROW['TABLE_NAME'];
}
$query = "SELECT * from IK_FIELD where TABLE_ID={$TABLE_ID} and FIELD_INDEX='1'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELD_INDEX_NAME = $ROW['FIELD_NAME'];
}
$query = "SELECT * from {$TABLE_NAME} ";
$FIELD_NAME_ARRAY = explode( ",", $FIELD_NAME_STR );
$ARRAY_COUNT = sizeof( $FIELD_NAME_ARRAY );
if ( $FIELD_NAME_ARRAY[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$STR = $FIELD_NAME_ARRAY[$I];
$FIELDVALUE = $$STR;
$FIELD_NAME = $STR;
if ( $FIELDVALUE == "CHECKBOX_ON" )
{
$FIELDVALUE = "1";
}
else if ( $FIELDVALUE == "CHECKBOX_OFF" )
{
$FIELDVALUE = "0";
}
$STR = $FIELD_NAME."_ORDER_CHECK";
if ( $$STR == "on" )
{
$ORDER_CHECK_STR .= ",".$FIELD_NAME;
$STR = $FIELD_NAME."_REV_CHECK";
if ( $$STR == "on" )
{
$ORDER_CHECK_STR .= " desc";
}
}
$STR = $FIELD_NAME."_LIST_CHECK";
if ( $$STR == "on" )
{
$LIST_CHECK_STR .= $FIELD_NAME.",";
}
$STR = $FIELD_NAME."_REPORT_CHECK";
if ( $$STR == "on" )
{
$REPORT_CHECK_STR .= $FIELD_NAME.",";
}
$STR = $FIELD_NAME."_RELATION";
$RELATION = $$STR;
if ( $FIELDVALUE != "" && $FIELDVALUE != "SELECT_ALL_VALUE" || $RELATION == "" )
{
$WHERE_STR .= " and {$FIELD_NAME}";
switch ( $RELATION )
{
case 1 :
$WHERE_STR .= "='".$FIELDVALUE."'";
break;
case 2 :
$WHERE_STR .= ">'".$FIELDVALUE."'";
break;
case 3 :
$WHERE_STR .= "<'".$FIELDVALUE."'";
break;
case 4 :
$WHERE_STR .= ">='".$FIELDVALUE."'";
break;
case 5 :
$WHERE_STR .= "<='".$FIELDVALUE."'";
break;
case 6 :
$WHERE_STR .= "!='".$FIELDVALUE."'";
break;
case 7 :
$WHERE_STR .= " like '".$FIELDVALUE."%'";
break;
case 8 :
$WHERE_STR .= " like '%".$FIELDVALUE."%'";
break;
case 9 :
$WHERE_STR .= " like '%".$FIELDVALUE."'";
break;
case "" :
$STR = $FIELD_NAME."_TIME1";
$FIELDVALUE1 = $$STR;
$STR = $FIELD_NAME."_TIME2";
$FIELDVALUE2 = $$STR;
if ( $FIELDVALUE1 != "" )
{
if ( !is_date( $FIELDVALUE1 ) )
{
message( "错误", "日期格式错误 - [{$FIELDVALUE1}]" );
button_back( );
exit( );
}
$WHERE_STR .= ">='{$FIELDVALUE1}'";
}
if ( !( $FIELDVALUE2 != "" ) )
{
break;
}
if ( !is_date( $FIELDVALUE2 ) )
{
message( "错误", "日期格式错误 - [{$FIELDVALUE2}]" );
button_back( );
exit( );
}
if ( $FIELDVALUE1 != "" )
{
$WHERE_STR .= " and {$FIELD_NAME}";
}
$WHERE_STR .= "<='{$FIELDVALUE2} 23:59:59'";
}
}
}
if ( $LIST_CHECK_STR == "" )
{
message( "提示", "至少选择一个列表项" );
button_back( );
exit( );
}
if ( $WHERE_STR != "" )
{
$WHERE_STR = substr( $WHERE_STR, 4 );
$query .= " where ".$WHERE_STR;
}
if ( $ORDER_CHECK_STR != "" )
{
$ORDER_CHECK_STR = substr( $ORDER_CHECK_STR, 1 );
$query .= " order by ".$ORDER_CHECK_STR;
}
$cursor = exequery( $connection, $query );
$NUM_FIELDS = mysql_num_fields( $cursor );
$DATA_COUNT = 0;
while ( $ROW1 = mysql_fetch_array( $cursor ) )
{
++$DATA_COUNT;
if ( $DATA_COUNT == 1 )
{
echo " <table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\">\r\n <tr class=\"TableHeader\">\r\n";
$I = 0;
for ( ; $I < $NUM_FIELDS; ++$I )
{
$FIELD_NAME = mysql_field_name( $cursor, $I );
if ( find_id( $LIST_CHECK_STR, $FIELD_NAME ) )
{
$query = "SELECT * from IK_FIELD where FIELD_NAME='{$FIELD_NAME}' and TABLE_ID={$TABLE_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FIELD_DESC = $ROW['FIELD_DESC'];
}
echo " <td nowrap align=\"center\"><b>";
echo $FIELD_DESC;
echo "</b>\r\n";
if ( strstr( $ORDER_CHECK_STR, $FIELD_NAME ) )
{
$IMAGE = "arrow_down";
if ( strstr( $ORDER_CHECK_STR, $FIELD_NAME." desc" ) )
{
$IMAGE = "arrow_up";
}
echo " <img border=0 src=\"/images/";
echo $IMAGE;
echo ".gif\" width=\"11\" height=\"10\">\r\n";
}
echo " </td>\r\n";
}
}
if ( $APP_FLD_CTRL == 1 )
{
echo " <td nowrap align=\"center\"><b>操 作</b></td>\r\n";
}
echo " </tr>\r\n";
}
if ( $DATA_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n";
$I = 0;
for ( ; $I < $NUM_FIELDS; ++$I )
{
$FIELD_VALUE = $ROW1[$I];
$FIELD_NAME = mysql_field_name( $cursor, $I );
$$FIELD_NAME = $FIELD_VALUE;
if ( find_id( $LIST_CHECK_STR, $FIELD_NAME ) )
{
$query = "SELECT * from IK_FIELD where FIELD_NAME='{$FIELD_NAME}' and TABLE_ID={$TABLE_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FIELD_TYPE = $ROW['FIELD_TYPE'];
$FIELD_AUTOVALUE = $ROW['FIELD_AUTOVALUE'];
$FIELD_CODE_FIX = $ROW['FIELD_CODE_FIX'];
$FIELD_CODE_SQL = $ROW['FIELD_CODE_SQL'];
$FIELD_INTERFACE_TYPE = $ROW['FIELD_INTERFACE_TYPE'];
}
if ( $FIELD_INTERFACE_TYPE == 5 )
{
if ( $FIELD_VALUE == "0" )
{
$FIELD_VALUE = "否";
}
else if ( $FIELD_VALUE == "1" )
{
$FIELD_VALUE = "是";
}
}
if ( $FIELD_AUTOVALUE == "D" )
{
$FIELD_VALUE = substr( $FIELD_VALUE, 0, 10 );
}
else if ( $FIELD_AUTOVALUE == "T" )
{
$FIELD_VALUE = substr( $FIELD_VALUE, 11 );
}
if ( $FIELD_CODE_SQL != "" )
{
$POS1 = strpos( $FIELD_CODE_SQL, " " ) + 1;
$POS2 = strpos( $FIELD_CODE_SQL, "," );
$FIELD = substr( $FIELD_CODE_SQL, $POS1, $POS2 - $POS1 );
$FIELD_CODE_SQL .= " where {$FIELD}='{$FIELD_VALUE}'";
$cursor1 = exequery( $connection, $FIELD_CODE_SQL );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FIELD_VALUE = $ROW[1];
}
}
else if ( $FIELD_CODE_FIX != "" )
{
$OPTION_ARRAY = explode( ",", $FIELD_CODE_FIX );
$FIELD_VALUE = $OPTION_ARRAY[$FIELD_VALUE];
}
echo " <td align=\"center\">";
echo $FIELD_VALUE;
echo "</td>\r\n";
if ( !( $REPORT_CHECK_STR != "" && $FIELD_INTERFACE_TYPE <= 2 && $FIELD_TYPE != "D" ) && !find_id( $REPORT_CHECK_STR, $FIELD_NAME ) )
{
$STR = $FIELD_NAME."_REPORT_COUNT";
$$STR += $FIELD_VALUE;
}
}
}
if ( $APP_FLD_CTRL == 1 )
{
echo " <td nowrap align=\"center\" nowrap>\r\n <a href=\"javascript:;\" onclick=\"on_print('";
echo $EDIT_APP_ID;
echo "','";
echo $FIELD_INDEX_NAME;
echo "','";
echo $$FIELD_INDEX_NAME;
echo "');\">打印</a> \r\n <a href=\"../?APP_ID=";
echo $EDIT_APP_ID;
echo "&ID=";
echo $FIELD_INDEX_NAME;
echo "&ID_VALUE=";
echo $$FIELD_INDEX_NAME;
echo "\">编辑</a> \r\n <a href=\"javascript:delete_item('";
echo $$FIELD_INDEX_NAME;
echo "')\">删除</a>\r\n </td>\r\n";
}
echo " </tr>\r\n";
}
if ( 0 < $DATA_COUNT )
{
if ( $REPORT_CHECK_STR != "" )
{
echo " <tr class=\"TableContent\">\r\n";
$I = 0;
for ( ; $I < $NUM_FIELDS; ++$I )
{
$FIELD_NAME = mysql_field_name( $cursor, $I );
if ( find_id( $LIST_CHECK_STR, $FIELD_NAME ) )
{
$REPORT_COUNT = "";
if ( find_id( $REPORT_CHECK_STR, $FIELD_NAME ) )
{
$STR = $FIELD_NAME."_REPORT_COUNT";
$REPORT_COUNT .= $$STR;
}
echo " <td align=\"center\">";
echo $REPORT_COUNT;
echo "</td>\r\n";
}
}
if ( $APP_FLD_CTRL == 1 )
{
echo " <td align=\"center\"><b>合计</b></td>\r\n";
}
echo " </tr>\r\n";
}
echo " </table>\r\n";
}
else
{
message( "", "无符合条件的记录" );
}
button_back( );
echo "\r\n";
echo "<s";
echo "cript>\r\nfunction delete_item(id)\r\n{\r\n msg='确认要删除该记录么？';\r\n if(window.confirm(msg))\r\n {\r\n url=\"delete.php?APP_ID=";
echo $APP_ID;
echo "&TABLE_ID=";
echo $TABLE_ID;
echo "&ID=";
echo $FIELD_INDEX_NAME;
echo "&ID_VALUE=\"+id;\r\n location=url;\r\n }\r\n}\r\n</script>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -