📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "../prcs_role.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\nfunction td_calendar(fieldname)\r\n{\r\n ";
echo " 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\r\n</script>\r\n ";
echo "<s";
echo "cript>\r\n function TwoSubmit(form){\r\n if (form.select[1].selected){\r\n form.action='flow_run.php';\r\n }\r\n else{\r\n form.action='flow_top10.php';\r\n }\r\n form.submit();\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 ";
echo " </td>\r\n </tr>\r\n <tr class=\"tablehead2\">\r\n <td><a href=\"flow_run.php\"><img src=\"/images/button/runflow.gif\" border=\"0\"></a> <a href=\"flow_top10.php\"><img src=\"/images/button/latelytenflow.gif\" border=\"0\"></a></td>\r\n </tr>\r\n</table>\r\n\r\n<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" >\r\n <tr>\r\n <td><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> 查询所有工作\r\n </td>\r\n </tr>\r\n</t";
echo "able>\r\n<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 <tr>\r\n <td width=\"20%\" nowrap class=\"TableLine2\">流程分类:</td><form name=\"formsort\" action=\"";
echo $_SERVER['PHP_SELF'];
echo "\" method=\"get\" >\r\n <td class=\"TableLine1\">";
echo "<s";
echo "elect name=\"FLOW_SORT\" class=\"SmallStatic\" onChange=\"document.formsort.submit();\">\r\n\t<option value=\"\">请选择</option>\r\n\t";
$sqlfs = "SELECT * FROM flow_sort ORDER BY ID";
$rsfs = exequery( $connection, $sqlfs );
while ( $rowfs = mysql_fetch_array( $rsfs ) )
{
$flow_sort = $rowfs['ID'];
$sort_name = $rowfs['TITLE'];
$query = "SELECT * from FLOW_TYPE WHERE FLOW_SORT=".$flow_sort." order by FLOW_NAME";
$cursor = exequery( $connection, $query );
$flowct = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_ID = $ROW['FLOW_ID'];
$FORM_ID = $ROW['FORM_ID'];
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_DOC = $ROW['FLOW_DOC'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$MANAGE_USER = $ROW['MANAGE_USER'];
if ( $FLOW_TYPE == "1" && $LOGIN_USER_PRIV != "1" && !find_id( $MANAGE_USER, $LOGIN_USER_ID ) )
{
if ( prcs_role( $FLOW_ID, 0 ) )
{
++$flowct;
}
}
else
{
++$flowct;
}
}
if ( 0 < $flowct )
{
$strcheck = "";
if ( $_REQUEST['FLOW_SORT'] == $flow_sort )
{
$strcheck = " selected";
}
echo "<option value='".$flow_sort."'".$strcheck.">".$sort_name."</option>\n";
}
}
echo " </select></td></form>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableLine2\">流程名称：</td>\r\n\t<form name=\"formflow\" action=\"";
echo $_SERVER['PHP_SELF'];
echo "\" method=\"get\">\r\n <td class=\"TableLine1\">";
echo "<s";
echo "elect name=\"FLOW_ID\" class=\"SmallStatic\" onChange=\"document.formflow.submit();\">\r\n\t<option value=\"\">请选择</option>\r\n\t";
if ( $_REQUEST['FLOW_SORT'] != "" )
{
$query = "SELECT * from FLOW_TYPE WHERE FLOW_SORT=".$_REQUEST['FLOW_SORT']." order by FLOW_NAME";
$cursor = exequery( $connection, $query );
$flowct = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_ID = $ROW['FLOW_ID'];
$FORM_ID = $ROW['FORM_ID'];
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_DOC = $ROW['FLOW_DOC'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$MANAGE_USER = $ROW['MANAGE_USER'];
if ( $FLOW_TYPE == "1" && $LOGIN_USER_PRIV != "1" && !find_id( $MANAGE_USER, $LOGIN_USER_ID ) && !prcs_role( $FLOW_ID, 0 ) )
{
continue;
}
$strcheck = "";
if ( $_REQUEST['FLOW_ID'] == $FLOW_ID )
{
$strcheck = " selected";
}
echo "<option value='".$FLOW_ID."'".$strcheck.">".$FLOW_NAME."</option>";
}
}
echo "\r\n </select><input type=\"hidden\" name=\"FLOW_SORT\" value=\"";
echo $_REQUEST['FLOW_SORT'];
echo "\"> </td></form>\r\n </tr>\r\n \r\n</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<form action=\"search.php\" method=\"post\" name=\"formsearch\">\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=\"RUN_NAME\" type=\"text\" 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\">\r\n\t\t<input class='Wdate' type=\"text\" name=\"PRCS_DATE1\" id=\"PRCS_D";
echo "ATE1\" value=\"\" size=\"12\" maxlength=\"10\" onclick=\"popUpCalendar(document.formsearch,document.formsearch.PRCS_DATE1,'yyyy-mm-dd')\"/>\r\n\t\t－\r\n\t\t<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\t\t\r\n 可只填一项 </td>\r\n </tr>\r\n <tr>\r\n <td he";
echo "ight=\"26\" nowrap class=\"TableLine2\">公共附件名称：</td>\r\n <td nowrap class=\"TableLine1\"><input name=\"ATTACHMENT_NAME\" type=\"text\" class=\"SmallInput\" id=\"ATTACHMENT_NAME\" size=\"30\">\r\n </td>\r\n </tr>\r\n </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\" > </td>\r\n ";
echo " <td width=\"80%\" height=\"30\" ><input type=\"image\" title=\"查询\" src=\"/images/button/search.gif\" name=\"submit12\"></td>\r\n </tr>\r\n </table>\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 + -