?? query.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>\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+\"px\");\r\n}\r\n</script>\r\n";
echo "</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/green_arrow.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 請指定查詢條件</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n<table border=\"0\" width=\"500\" cellpadding=\"3\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <form action=\"search.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"3\" height=\"28\"><b> 工作流程基本信息</b></td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"><b>流";
echo "程名稱：</b></td>\r\n <td class=\"TableData\" colspan=\"2\">\r\n ";
echo "<s";
echo "elect name=\"FLOW_ID\" class=\"SmallStatic\">\r\n";
$connection = openconnection( );
$query = "SELECT * from FLOW_TYPE where FLOW_ID={$FLOW_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_ID = $ROW['FLOW_ID'];
$FLOW_NAME = $ROW['FLOW_NAME'];
$FORM_ID = $ROW['FORM_ID'];
echo " <option value=\"";
echo $FLOW_ID;
echo "\">";
echo $FLOW_NAME;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"><b>工作流狀態(tài)：</b></td>\r\n <td class=\"TableData\" colspan=\"2\">\r\n ";
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\">執(zhí)行中</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"><b>文號：</b></td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo "<s";
echo "elect name=\"RUN_NAME_RELATION\" class=\"SmallSelect\">\r\n <option value=\"1\">等于</option>\r\n <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";
echo " value=\"9\">結(jié)束為</option>\r\n </select>\r\n </td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"RUN_NAME\" size=\"30\" maxlength=\"100\" class=\"SmallInput\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\"><b>流程開始日期：</b></td>\r\n <td class=\"TableData\" colspan=\"2\">\r\n 從 <input type=\"text\" name=\"PRCS_DATE1\" size=\"10\" class=\"SmallInput\"><img src=\"/images";
echo "/menu/calendar.gif\" align=absmiddle border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.PRCS_DATE1');\">\r\n 至 <input type=\"text\" name=\"PRCS_DATE2\" size=\"10\" class=\"SmallInput\"><img src=\"/images/menu/calendar.gif\" align=absmiddle border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.PRCS_DATE2');\">\r\n 可只填一項(xiàng)\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableConte";
echo "nt\"><b>公共附件名稱：</b></td>\r\n <td nowrap class=\"TableData\">\r\n 包含\r\n </td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"ATTACHMENT_NAME\" size=\"30\" class=\"SmallInput\">\r\n </td>\r\n </tr>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"3\" nowrap>\r\n <input type=\"submit\" value=\"查詢\" class=\"BigButton\" name=\"submit1\"> \r\n ";
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" name=\"back1\" onClick=\"location='index.php'\">\r\n </td>\r\n </tr>\r\n";
$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 " <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"3\" height=\"28\"><b> 表單數(shù)據(jù)信息（表單名稱：";
echo $FORM_NAME;
echo "）</b>\r\n </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>";
echo $ETITLE;
echo "：</td>\r\n <td nowrap>\r\n ";
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\">結(jié)束為</option>\r\n";
}
echo " </select>\r\n </td>\r\n <td>\r\n ";
echo $ELEMENT_OUT;
echo " </td>\r\n </tr>\r\n";
}
echo " <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"3\" nowrap>\r\n <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 <input type=\"submit\" value=\"查詢\" class=\"BigButton\" name=\"submit\"> \r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" name=\"back\" onClick=\"location='index.php'\">\r\n </td>\r\n </tr>\r\n </form>\r\n</table>\r\n\r\n</body>\r\n</html>";
?>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -