?? 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 language=javascript src=\"/inc/calendar/calendar.js\"></SCRIPT>\r\n";
echo "<s";
echo "cript language=\"javascript\">\r\nfunction highlight(o){\r\n\tvar trs = o.getElementsByTagName(\"tr\");\r\n\tfor(var i=0;i<trs.length;i++){\r\n\t\t//trs[i].className = (i%2)==0 ? 'highlight':'nohighlight';\r\n\t\ttrs[i].onmouseover = function(){this.style.backgroundColor='#d6d6d6';return false;}\r\n\t\ttrs[i].onmouseout = function(){this.style.backgroundColor='';return false;}\r\n\t}\r\n}\r\n</script>\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<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 <tr class=\"tablehead2\"><td>\r\n <input type=\"image\" src=\"/images/button/newwork.gif\" border=\"0\" accesskey=\"N\" onClick=\"javascript:location.href='../new'\" title=\"新建工作\">\r\n ";
echo "<input type=\"image\" src=\"/images/button/pendingwork.gif\" border=\"0\" accesskey=\"p\" onclick=\"javascript:location.href='../work_list.php'\" title=\"待辦工作\"> \r\n <input type=\"image\" src=\"/images/button/workwatch.gif\" border=\"0\" accesskey=\"W\" onClick=\"javascript:location.href='../manage.php'\" title=\"工作監(jiān)控\">\r\n <input type=\"image\" src=\"/images/button/worksearch.gif\" border=\"0\" accesskey=\"S\" onClick=\"ja";
echo "vascript:location.href='../query'\" title=\"工作查詢\">\r\n <input type=\"image\" src=\"/images/button/return.gif\" border=\"0\" accesskey=\"S\" onClick=\"history.back()\" title=\"返回\">\r\n </td></tr>\r\n</table>\r\n<form action=\"search.php\" method=\"post\" name=\"form1\">\r\n<table border=\"0\" width=\"100%\" cellpadding=\"5\" cellspacing=\"1\" align=\"center\" class=\"small\">\r\n \r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"3";
echo "\" height=\"28\"><b> 工作流程基本信息</b></td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\">流程名稱：</td>\r\n <td class=\"TableLine1\" 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=\"TableLine2\" width=\"20%\">工作流狀態(tài)：</td>\r\n <td class=\"TableLine1\" 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=\"TableLine2\">文號：</td>\r\n <td nowrap class=\"TableLine1\">\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=\"TableLine1\">\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=\"TableLine2\">流程開始日期：</td>\r\n <td class=\"TableLine1\" colspan=\"2\">\r\n 從 <input class='Wdate' type=\"text\" name=\"PRCS_DATE1\" id=\"PRCS_DATE1\" value=\"\" size=\"12\" m";
echo "axlength=\"10\" onClick=\"popUpCalendar(document.formsearch,document.formsearch.PRCS_DATE1,'yyyy-mm-dd')\"/>\r\n 至 <input class='Wdate' type=\"text\" name=\"PRCS_DATE2\" id=\"PRCS_DATE2\" value=\"\" size=\"12\" maxlength=\"10\" onClick=\"popUpCalendar(document.formsearch,document.formsearch.PRCS_DATE2,'yyyy-mm-dd')\"/>\r\n 可只填一項\r\n </td>\r\n </tr>\r\n <tr>\r\n <td height=\"26\" nowrap class=\"Table";
echo "Line2\">公共附件名稱：</td>\r\n <td nowrap class=\"TableLine1\" colspan=\"2\">\r\n 包含：<input type=\"text\" name=\"ATTACHMENT_NAME\" size=\"30\" class=\"SmallInput\">\r\n </td>\r\n </tr>\r\n </table>\r\n\t<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr class=\"TableLine2\">\r\n <td colspan=\"2\" align=\"center\" > \r\n </td>\r\n <td width=\"80%\" height=\"30\" ><input ";
echo "type=\"image\" title=\"查詢\" src=\"/images/button/search.gif\" name=\"submit12\"></td>\r\n </tr>\r\n\t</table>\r\n\t<br>\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 "<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> 表單數(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 width=\"20%\">";
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 "</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>\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 </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 \r\n</table>\r\n</form>\r\n</body>\r\n</html>";
?>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -