📄 search.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/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";
echo "<s";
echo "cript src=\"/inc/common.js\"></script>\r\n";
echo "<s";
echo "cript language=\"javascript\">\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:280px;dialogHeight:205px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft";
echo "+\"px\");\r\n}\r\n\r\nfunction submitForm(){\r\n\tformsearch.submit();\r\n}\r\n</script>\r\n";
echo "<s";
echo "cript>\r\n\r\n</script> \r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n <tr class=\"tablehead1\">\r\n <td ><img src=\"/images/workflow.gif\" align=\"absmiddle\">流程报表数据查询\r\n </td>\r\n </tr>\r\n\t\r\n\r\n <tr class=\"tablehead2\">\r\n <td><BUTTON class=btn onclick=\"submitForm();\"><table><tr valign=middle ><td><img src=\"/images/littlegif/b_u.gif\" al";
echo "ign=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\"> 确 定</span></td></tr></table></BUTTON>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n";
$sql = "SELECT * FROM flow_sort WHERE ID='".$FLOW_SORT."'";
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$sortname = $row['TITLE'];
$sql = "SELECT * FROM flow_type WHERE FLOW_ID='".$FLOW_ID."'";
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$flowname = $row['FLOW_NAME'];
echo "\t\r\n\t ";
echo $sortname;
echo " -> ";
echo $flowname;
echo "<table border=\"0\" width=\"100%\" cellpadding=\"5\" cellspacing=\"1\" align=\"center\" class=\"small\">\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"2\" height=\"28\"><b> 工作流程基本信息</b></td>\r\n </tr>\r\n\r\n</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<form action=\"search_result.php\" method=\"post\" name=\"formsearch\">\r\n <input type=\"hidden\" name=\"FLOW_SORT\" value=\"";
echo $_REQUEST['FLOW_SORT'];
echo "\">\r\n <input type=\"hidden\" name=\"FLOW_ID\" value=\"";
echo $_REQUEST['FLOW_ID'];
echo "\">\r\n \r\n <tr>\r\n <td><table border=\"0\" width=\"100%\" cellpadding=\"5\" cellspacing=\"1\" align=\"center\" class=\"small\">\r\n <tr>\r\n <td nowrap class=\"TableLine2\" width=\"20%\">工作流状态：</td>\r\n <td class=\"TableLine1\">";
echo "<s";
echo "elect name=\"FLOW_STATUS\" class=\"SmallSelect\">\r\n <option value=\"ALL\">所有</option>\r\n <option value=\"1\">已完成</option>\r\n <option value=\"0\">执行中</option>\r\n </select>\r\n <input type=\"hidden\" name=\"FLOW_SORT\" value=\"";
echo $_REQUEST['FLOW_SORT'];
echo "\">\r\n <input type=\"hidden\" name=\"FLOW_ID\" value=\"";
echo $_REQUEST['FLOW_ID'];
echo "\"></td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\">创建人：</td>\r\n <td nowrap class=\"TableLine1\"><input name=\"CREATE_USER_ID\" type=\"hidden\" class=\"SmallInput\" id=\"CREATE_USER_ID\" ><input name=\"CREATE_USER_NAME\" type=\"text\" class=\"SmallInput\" id=\"CREATE_USER_NAME\" > <input type=\"button\" value=\"选 择\" class=\"SmallInput\" onclick=\"LoadWindowUserSingle('CREATE_USER_ID','CREATE_USER_";
echo "NAME','formsearch')\">\r\n\r\n </td>\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableLine2\">文号：</td>\r\n <td nowrap class=\"TableLine1\"><input name=\"RUN_SEQ\" type=\"text\" class=\"SmallInput\" id=\"RUN_SEQ\" size=\"30\" maxlength=\"100\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\">说明：</td>\r\n <td nowrap class=\"TableLine1\"><input name=\"RUN_NAME\" type=\"text\" ";
echo "class=\"SmallInput\" id=\"RUN_NAME\" size=\"30\" maxlength=\"100\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\">流程开始日期：</td>\r\n <td class=\"TableLine1\"><input name=\"PRCS_DATE1\" type=\"text\" class=\"SmallInput\" id=\"PRCS_DATE1\" size=\"10\">\r\n <img src=\"/images/menu/calendar1.gif\" align=absmiddle border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('formsearch.PRC";
echo "S_DATE1');\"> －\r\n <input name=\"PRCS_DATE2\" type=\"text\" class=\"SmallInput\" id=\"PRCS_DATE2\" size=\"10\">\r\n <img src=\"/images/menu/calendar1.gif\" align=absmiddle border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('formsearch.PRCS_DATE2');\"> 可只填一项 </td>\r\n </tr>\r\n <tr>\r\n <td height=\"26\" nowrap class=\"TableLine2\">公共附件名称：</td>\r\n <td nowrap class=\"TableLine1\"";
echo "><input name=\"ATTACHMENT_NAME\" type=\"text\" class=\"SmallInput\" id=\"ATTACHMENT_NAME\" size=\"30\">\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n ";
if ( $_REQUEST['FLOW_ID'] != "" )
{
$sqlff = "SELECT * FROM flow_type WHERE FLOW_ID=".$_REQUEST['FLOW_ID'];
$rsff = exequery( $connection, $sqlff );
$rowff = mysql_fetch_array( $rsff );
$FORM_ID = $rowff['FORM_ID'];
$query = "SELECT * from FLOW_FORM_TYPE WHERE FORM_ID={$FORM_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FORM_NAME = $ROW['FORM_NAME'];
$PRINT_MODEL = $ROW['PRINT_MODEL'];
}
echo " <table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"5\" cellspacing=\"1\">\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"3\" height=\"28\"><b> 表单数据信息（表单名称：\r\n ";
echo $FORM_NAME;
echo " ）</b> </td>\r\n </tr>\r\n ";
$ELEMENT_ARRAY = html_element( $PRINT_MODEL );
$ITEM_ID_MAX = sizeof( $ELEMENT_ARRAY );
$ITEM_ID = 0;
$I = 0;
for ( ; $I < $ITEM_ID_MAX; ++$I )
{
$ELEMENT = $ELEMENT_ARRAY[$I];
$ENAME = get_attr( $ELEMENT, "NAME" );
$EVALUE = get_attr( $ELEMENT, "VALUE" );
$ETITLE = get_attr( $ELEMENT, "TITLE" );
$ETITLE = str_replace( "<", "<", $ETITLE );
$ETITLE = str_replace( ">", ">", $ETITLE );
$ETITLE = stripslashes( $ETITLE );
$ECLASS = get_attr( $ELEMENT, "CLASS" );
if ( $ECLASS != "DATE" )
{
++$ITEM_ID;
}
if ( $ENAME == "INPUT" )
{
if ( strstr( $ELEMENT, "type=checkbox" ) )
{
$ELEMENT_OUT = "<SELECT class=SmallSelect><option value='SELECT_ALL_VALUE'>所有</option><option value='CHECKBOX_ON'>是</option><option value='CHECKBOX_OFF'>否</option></SELECT>";
$ENAME = "SELECT";
}
else
{
$ELEMENT_OUT = "<INPUT type=text size=30 class=SmallInput>";
}
}
else if ( $ENAME == "SELECT" )
{
if ( $ECLASS != "AUTO" )
{
$ELEMENT_OUT = "<SELECT class=SmallSelect><option value='SELECT_ALL_VALUE'>所有</option>".$EVALUE."</SELECT>";
$ELEMENT_OUT = str_replace( " selected", "", $ELEMENT_OUT );
}
else
{
$EDATAFLD = get_attr( $ELEMENT, "DATAFLD" );
$ELEMENT_OUT = "<SELECT class=SmallSelect><option value='SELECT_ALL_VALUE'>所有</option>";
switch ( $EDATAFLD )
{
case "SYS_LIST_DEPT" :
$ELEMENT_OUT .= my_dept_tree( 0, $ITEM_VALUE, 0 );
break;
case "SYS_LIST_USER" :
case "SYS_LIST_PRCSUSER1" :
case "SYS_LIST_PRCSUSER2" :
$query_auto = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NAME";
$cursor_auto = exequery( $connection, $query_auto );
while ( $ROW = mysql_fetch_array( $cursor_auto ) )
{
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$ELEMENT_OUT .= "<option value=\"{$USER_ID}\"";
$ELEMENT_OUT .= ">{$USER_NAME}</option>\n";
}
break;
case "SYS_LIST_PRIV" :
$query_auto = "SELECT * from USER_PRIV order by PRIV_NO";
$cursor_auto = exequery( $connection, $query_auto );
while ( $ROW = mysql_fetch_array( $cursor_auto ) )
{
$USER_PRIV = $ROW['USER_PRIV'];
$PRIV_NAME = $ROW['PRIV_NAME'];
$ELEMENT_OUT .= "<option value=\"{$USER_PRIV}\"";
$ELEMENT_OUT .= ">{$PRIV_NAME}</option>\n";
}
break;
case "SYS_LIST_SQL" :
$EDATASRC = get_attr( $ELEMENT, "DATASRC" );
$EDATASRC = str_replace( "`", "'", $EDATASRC );
$cursor_SYS_SQL = exequery( $connection, $EDATASRC );
while ( $ROW = mysql_fetch_array( $cursor_SYS_SQL ) )
{
$AUTO_VALUE_SQL = $ROW[0];
$ELEMENT_OUT .= "<option value=\"{$AUTO_VALUE_SQL}\"";
$ELEMENT_OUT .= ">{$AUTO_VALUE_SQL}</option>\n";
}
}
$ELEMENT_OUT .= "</SELECT>";
}
}
else if ( $ENAME == "TEXTAREA" )
{
$ELEMENT_OUT = "<INPUT type=text size=30 class=SmallInput>";
$ENAME = "INPUT";
}
$ELEMENT_OUT = str_replace( "<{$ENAME}", "<{$ENAME} name='DATA_{$ITEM_ID}'", $ELEMENT_OUT );
if ( $I % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td width=\"20%\">";
echo $ETITLE;
echo " ：</td>\r\n <td nowrap>";
echo "<s";
echo "elect name=\"RELATION_";
echo $ITEM_ID;
echo "\" class=\"SmallSelect\">\r\n <option value=\"1\">等于</option>\r\n ";
if ( $ENAME != "SELECT" )
{
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 <option value=\"7\">开始为</option>\r\n <option value=\"8\" selected>包含</option>\r\n <option value=\"9\">结束为</option>\r\n ";
}
echo " </select>\r\n </td>\r\n <td>";
echo $ELEMENT_OUT;
echo " </td>\r\n </tr>\r\n ";
}
echo " </table>\r\n <table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr class=\"TableLine2\">\r\n <td colspan=\"2\" align=\"center\" nowrap><input type=\"hidden\" value=\"";
echo $RUN_ID;
echo "\" name=\"RUN_ID\">\r\n <input type=\"hidden\" value=\"";
echo $ITEM_ID;
echo "\" name=\"ITEM_ID_MAX\">\r\n </td>\r\n <td width=\"80%\" height=\"30\" nowrap><input type=\"image\" title=\"查询\" src=\"/images/button/search.gif\" name=\"submit1\"></td>\r\n </tr>\r\n </table>\r\n ";
}
echo "</td>\r\n </tr></form>\r\n</table>\r\n\r\n \r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -