📄 worktype.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\n<html>\n<head>\n<title>工作流查询</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\n\n<script>\nfunction delete_form(FORM_ID)\n{\n msg='确认要删除该表单么？这将删除表单描述与字段设置且不可恢复！';\n if(window.confirm(msg))\n {\n URL=\"delete.php?FORM_ID=\"+FORM_ID;\n window.location=URL;\n }\n}\n</script>\n</head>\n\n <body class=\"bodycolor\" topmargin=\"5\">\n\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\n <tr>\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 查询分类</span><br>\n </td>\n </tr>\n</table>\n\n\n<!--\n<div align=\"center\">\n<input type=\"button\" value=\"新建表单\" class=\"BigButton\" onClick=\"location='edit.php';\" title=\"新建表单\">\n</div>\n-->\n<br>\n\n<!--\n<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"3\">\n <tr>\n <td background=\"/images/dian1.gif\" width=\"100%\"></td>\n </tr>\n</table>\n\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\n <tr>\n <td class=\"Big\"><img src=\"/images/notify_open.gif\" align=\"absmiddle\"><span class=\"big3\"> 管理表单</span><br>\n </td>\n </tr>\n</table>\n<br>\n-->\n\n";
$FORM_COUNT = 0;
$INT_SORT = 0;
$FORM_COUNT1 = 0;
$query = "SELECT flow_run.flow_id,flow_form_type.form_id\n,form_name,sort_id,sort_name,count(*) as flow_num \nfrom flow_run,flow_run_data,flow_type,flow_sort,\nflow_form_type,flow_run_prcs WHERE flow_run.RUN_ID=flow_run_data.RUN_ID\nand flow_run.flow_id=flow_type.flow_id\nand flow_type.form_id=flow_form_type.form_id\nand flow_type.flow_sort=flow_sort.sort_id \nand flow_run.RUN_ID=flow_run_prcs.RUN_ID \nand prcs_time>='".$TABLE_TIME."' \nand prcs_time<='{$END_TIME}' \nand ITEM_DATA='{$DEPT_NAME}' \ngroup by flow_id,form_id,form_name,sort_id,sort_name \norder by sort_id,form_id";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID = $ROW['sort_id'];
$SORT_NAME = $ROW['sort_name'];
$FLOW_ID = $ROW['flow_id'];
$FORM_ID = $ROW['form_id'];
$FORM_NAME = $ROW['form_name'];
$FLOW_NUM = $ROW['flow_num'];
$SORT_NAME = str_replace( "<", "<", $SORT_NAME );
$SORT_NAME = str_replace( ">", ">", $SORT_NAME );
$SORT_NAME = stripslashes( $SORT_NAME );
++$FORM_COUNT;
++$FORM_COUNT1;
if ( $FORM_COUNT == 1 || $INT_SORT != $SORT_ID )
{
if ( $INT_SORT != $SORT_ID && $FORM_COUNT != 1 )
{
echo "</table></fieldset><br>";
}
$FORM_COUNT1 = 0;
echo "<fieldset>\n <legend class=\"small1\" align=left>\n <b>";
echo $SORT_NAME;
echo "</b>\n </legend>\n \n <table border=\"0\" cellspacing=\"1\" width=\"99%\" align=\"center\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\n <tr class=\"TableHeader\">\n <td nowrap align=\"center\">表单名称</td>\n <td nowrap align=\"center\">操作</td>\n </tr>\n";
}
$TAB_TIME = $TABLE_TIME;
if ( $FORM_COUNT1 % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <form action=\"findflow.php\" method=\"post\" name=\"form1\">\n <tr class=\"";
echo $TableLine;
echo "\">\n <td width=\"70%\" nowrap align=\"center\">";
echo $FORM_NAME." （共".$FLOW_NUM."项）";
echo "</td>\n <td nowrap class=\"TableControl\" align=\"center\"> \n \t<input type=\"hidden\" name=\"DEPT_NAME\" value=\"";
echo $DEPT_NAME;
echo "\">\n \t<input type=\"hidden\" name=\"DEPT_ID\" value=\"";
echo $DEPT_ID;
echo "\">\n \t<input type=\"hidden\" name=\"FLOW_ID\" value=\"";
echo $FLOW_ID;
echo "\">\n \t<input type=\"hidden\" name=\"TABLE_TIME\" value=\"";
echo $TABLE_TIME;
echo "\">\n \t<input type=\"hidden\" name=\"END_TIME\" value=\"";
echo $END_TIME;
echo "\"> \t\n \t<input type=\"submit\" value=\"查询\" class=\"SmallButton\" title=\"查询\" name=\"button\"> \n </td>\n </tr>\n </form>\n\n<!-- <a href=\"findflow.php?FLOW_ID=";
echo $FLOW_ID;
echo "&TABLE_TIME=";
echo $TABLE_TIME;
echo "&DEPT_NAME=";
echo $DEPT_NAME;
echo " \">查询</a> \n <a href=\"#\" onclick=\"javascript:window.open('cool_form?FORM_ID=";
echo $FORM_ID;
echo "','cool_form','menubar=0,toolbar=0,scrollbars=no,status=0,resizable=1')\">表单智能设计</a> \n <a href=\"form_view.php?FORM_ID=";
echo $FORM_ID;
echo "\" target=\"_blank\" title=\"表单预览\">预览</a> \n <a href=\"import.php?FORM_ID=";
echo $FORM_ID;
echo "\" title=\"可将一些备份的表单或优秀的表单导入\">导入</a> \n <a href=\"export.php?FORM_ID=";
echo $FORM_ID;
echo "\" title=\"可以将表单导出后，与其他OA用户分享\" target=\"_blank\">导出</a> \n-->\n \n \n";
$INT_SORT = $SORT_ID;
}
if ( $FORM_COUNT == 0 )
{
message( "", "尚未定义流程" );
}
echo "\n</body>\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -