📄 edit.php
字号:
<?php
include_once( "inc/auth.php" );
if ( $FLOW_ID != "" )
{
$TITLE = "编辑流程基本属性";
}
else
{
$TITLE = "新建流程";
}
echo "\r\n<html>\r\n<head>\r\n<title>";
echo $TITLE;
echo "</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n<SCRIPT language=javascript>\r\nfunction check_form()\r\n{\r\n if(document.form1.FLOW_NAME.value == \"\")\r\n {\r\n alert(\"流程名称不能为空!\");\r\n return false;\r\n }\r\n\r\n return true;\r\n}\r\n\r\nfunction delete_form(FLOW_ID)\r\n{\r\n msg='确认要删除该流程么？\\n这将删除以下数据：\\n\\n1、流程描述与步骤设置\\n2、依托于该流程的所有工作';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?FLOW_ID=\"+FLOW_ID;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction empty_form(FLOW_ID)\r\n{\r\n msg='确认要清空依托于该流程的所有工作数据么？';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"empty.php?FLOW_ID=\"+FLOW_ID;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction flow_design(FLOW_ID)\r\n{\r\n window.open(\"flow_design?FLOW_ID=\"+FLOW_ID,\"flow_design\",\"height=600,width=800,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=10,left=10,resizable=yes\");\r\n}\r\n\r\nfunction menu_code(TYPE,ID)\r\n{\r\n window.open(\"/module/menu_code?TYPE=\"+TYPE+\"&ID=\"+ID,\"MENU_CODE\",\"height=270,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=10,left=10,resizable=yes\");\r\n}\r\n\r\nfunction my_tip()\r\n{\r\n if(tip.style.display==\"none\")\r\n tip.style.display=\"\";\r\n else\r\n \t tip.style.display=\"none\";\r\n}\r\n</SCRIPT>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"document.form1.FLOW_NO.focus();\">\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/edit.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> ";
echo $TITLE;
echo "</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n";
if ( $FLOW_ID != "" )
{
$query = "SELECT * from FLOW_TYPE where FLOW_ID=".$FLOW_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_NO = $ROW['FLOW_NO'];
$FLOW_SORT = $ROW['FLOW_SORT'];
$FORM_ID = $ROW['FORM_ID'];
$FLOW_DOC = $ROW['FLOW_DOC'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$AUTO_NAME = $ROW['AUTO_NAME'];
$AUTO_NUM = $ROW['AUTO_NUM'];
$AUTO_LEN = $ROW['AUTO_LEN'];
$FLOW_DESC = $ROW['FLOW_DESC'];
$AUTO_EDIT = $ROW['AUTO_EDIT'];
$AUTO_SQL = $ROW['AUTO_SQL'];
}
$query = "SELECT * from FLOW_RUN where FLOW_ID=".$FLOW_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_READ_ONLY = 1;
}
}
else
{
$AUTO_NUM = 0;
$AUTO_LEN = 0;
}
echo "\r\n<table border=\"0\" width=\"90%\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <form action=\"";
if ( $FLOW_ID != "" )
{
echo "update";
}
else
{
echo "insert";
}
echo ".php\" method=\"post\" name=\"form1\" onSubmit=\"return check_form();\">\r\n <tr>\r\n <td colspan=2 class=\"TableHeader\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> 流程基本属性</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">流程分类：</td>\r\n <td class=\"TableData\">\r\n <select name=\"FLOW_SORT\" class=\"BigSelect\">\r\n";
$query = "SELECT * from FLOW_SORT order by SORT_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID = $ROW['SORT_ID'];
$SORT_NAME = $ROW['SORT_NAME'];
echo " <option value=\"";
echo $SORT_ID;
echo "\" ";
if ( $SORT_ID == $FLOW_SORT )
{
echo "selected";
}
echo ">";
echo $SORT_NAME;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">流程排序号：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FLOW_NO\" size=\"4\" maxlength=\"100\" class=\"BigInput\" value=\"";
echo $FLOW_NO;
echo "\"> 控制同一分类下流程的排序\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">流程名称：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"FLOW_NAME\" size=\"30\" maxlength=\"100\" class=\"BigInput\" value=\"";
echo $FLOW_NAME;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">流程类型：</td>\r\n <td class=\"TableData\">\r\n <select name=\"FLOW_TYPE\" class=\"";
if ( $FLOW_READ_ONLY != 1 )
{
echo "BigSelect";
}
else
{
echo "BigStatic";
}
echo "\">\r\n";
if ( !( $FLOW_READ_ONLY == 1 ) && !( $FLOW_TYPE == "2" ) )
{
echo " <option value=\"1\" ";
if ( $FLOW_TYPE == "1" )
{
echo "selected";
}
echo ">固定流程</option>\r\n";
}
if ( !( $FLOW_READ_ONLY == 1 ) && !( $FLOW_TYPE == "1" ) )
{
echo " <option value=\"2\" ";
if ( $FLOW_TYPE == "2" )
{
echo "selected";
}
echo ">自由流程</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">表单：</td>\r\n <td class=\"TableData\">\r\n <select name=\"FORM_ID\" class=\"";
if ( $FLOW_READ_ONLY != 1 )
{
echo "BigSelect";
}
else
{
echo "BigStatic";
}
echo "\">\r\n";
$query = "SELECT * from FLOW_FORM_TYPE";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$FORM_ID1 = $ROW['FORM_ID'];
$FORM_NAME = $ROW['FORM_NAME'];
if ( $FLOW_READ_ONLY == 1 && $FORM_ID != $FORM_ID1 )
{
echo " <option value=\"";
echo $FORM_ID1;
echo "\" ";
if ( $FORM_ID == $FORM_ID1 )
{
echo "selected";
}
echo ">";
echo $FORM_NAME;
echo "</option>\r\n";
}
}
echo " </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">允许附件：</td>\r\n <td class=\"TableData\">\r\n <select name=\"FLOW_DOC\" class=\"BigSelect\">\r\n <option value=\"1\" ";
if ( $FLOW_DOC == "1" )
{
echo "selected";
}
echo ">是</option>\r\n <option value=\"0\" ";
if ( $FLOW_DOC == "0" )
{
echo "selected";
}
echo ">否</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">流程说明：</td>\r\n <td class=\"TableData\">\r\n <textarea cols=40 name=\"FLOW_DESC\" rows=\"2\" class=\"BigInput\" wrap=\"yes\">";
echo $FLOW_DESC;
echo "</textarea>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td colspan=2 class=\"TableHeader\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> 工作名称/文号的设定</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">自动文号表达式：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"AUTO_NAME\" size=\"30\" class=\"BigInput\" value=\"";
echo $AUTO_NAME;
echo "\">\r\n <a href=\"javascript:my_tip()\">查看说明</a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">自动编号计数器：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"AUTO_NUM\" size=\"11\" class=\"BigInput\" value=\"";
echo $AUTO_NUM;
echo "\"> 用于表达式编号标记\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">自动编号显示长度：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"AUTO_LEN\" size=\"2\" class=\"BigInput\" value=\"";
echo $AUTO_LEN;
echo "\"> 为0表示按实际编号位数显示\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">来自SQL查询语句：</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"AUTO_SQL\" size=\"20\" class=\"BigInput\" value=\"";
echo $AUTO_SQL;
echo "\"> <a href=\"sql_help.php\" target=\"_blank\">SQL查询语句书写指导</a>\r\n\r\n </td>\r\n </tr>\r\n <tr id=\"tip\" style=\"display:none\">\r\n <td nowrap class=\"TableData\">说明：</td>\r\n <td class=\"TableData\">表达式中可以使用以下特殊标记：<br>\r\n \t{Y}：表示年<br>\r\n \t{M}：表示月<br>\r\n {D}：表示日<br>\r\n {H}：表示时<br>\r\n {I}：表示分<br>\r\n {S}：表示秒<br>\r\n {T}：表示流程分类<br>\r\n {F}：表示流程名<br>\r\n {U}：表示用户姓名<br>\r\n {SD}：表示短部门<br>\r\n {LD}：表示长部门<br>\r\n {R}：表示角色<br>\r\n {N}：表示编号，通过 <u>编号计数器</u> 取值并自动增加计数值<br>\r\n {SQL}：表示来自SQL查询语句结果<br>\r\n <br>\r\n 例如，表达式为：成建委发[{Y}]{N}号，编号位数为4<br>\r\n 自动生成文号如：成建委发[2006]0001号<br>\r\n <br>\r\n 例如，表达式为：BH{N}，编号位数为3<br>\r\n 自动生成文号如：BH001<br>\r\n <br>\r\n 例如，表达式为：{F}流程（{Y}年{M}月{D}日{H}:{I}）{U}<br>\r\n 自动生成文号如：请假流程（2006年01月01日10:30）张三<br>\r\n <br>\r\n 可以不填写自动文号表达式，则系统默认按以下格式，如：<br>\r\n 请假流程(2006-01-01 10:30:30)\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">允许手工输入文号：</td>\r\n <td class=\"TableData\">\r\n <select name=\"AUTO_EDIT\" class=\"BigSelect\">\r\n <option value=\"1\" ";
if ( $AUTO_EDIT == "1" )
{
echo "selected";
}
echo ">是</option>\r\n <option value=\"0\" ";
if ( $AUTO_EDIT == "0" )
{
echo "selected";
}
echo ">否</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr align=\"center\" class=\"TableControl\">\r\n <td colspan=\"2\" nowrap>\r\n <input type='hidden' value=\"";
echo $FLOW_ID;
echo "\" name=\"FLOW_ID\">\r\n <input type=\"submit\" value=\"保存\" class=\"BigButton\" name=\"submit\"> \r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" name=\"back\" onClick=\"history.back();\">\r\n </td>\r\n </tr>\r\n </form>\r\n</table>\r\n\r\n";
if ( $FLOW_ID != "" )
{
echo "<br>\r\n <table border=\"0\" cellspacing=\"1\" width=\"90%\" align=\"center\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr>\r\n <td class=\"TableHeader\" nowrap colspan=2>\r\n \t<img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> <b>相关操作</b></td>\r\n </tr>\r\n <tr>\r\n <td class=\"TableData\" nowrap>\r\n";
if ( $FLOW_TYPE == "1" )
{
echo " <a href=\"javascript:flow_design('";
echo $FLOW_ID;
echo "');\">\r\n <img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"13\" align=\"absmiddle\"> 流程设计器 \r\n </a>\r\n";
}
else
{
echo " <a href=\"set_new.php?FLOW_ID=";
echo $FLOW_ID;
echo "\">\r\n <img border=0 src=\"/images/node_user.gif\" align=\"absmiddle\"> 新建权限 </a>\r\n";
}
echo " <a href=\"manage_priv/?FLOW_ID=";
echo $FLOW_ID;
echo "\">\r\n <img border=0 src=\"/images/node_user.gif\" align=\"absmiddle\"> 监控人员</a> \r\n <a href=\"set_query.php?FLOW_ID=";
echo $FLOW_ID;
echo "\">\r\n <img border=0 src=\"/images/node_user.gif\" align=\"absmiddle\"> 查询人员</a> \r\n <a href=\"set_query_item.php?FLOW_ID=";
echo $FLOW_ID;
echo "\">\r\n <img border=0 src=\"/images/query.gif\" align=absmiddle>查询字段</a> \r\n <a href=\"javascript:menu_code('FLOW','";
echo $FLOW_ID;
echo "')\">\r\n <img border=0 src=\"/images/menu/system.gif\" width=19 height=17 align=\"absmiddle\"> 菜单定义指南</a>\r\n </td>\r\n <td class=\"TableData\" align=\"center\" nowrap>\r\n \t <a href=\"data?FLOW_ID=";
echo $FLOW_ID;
echo "\">数据</a>\r\n <a href=\"clone?FLOW_ID=";
echo $FLOW_ID;
echo "\">克隆</a>\r\n <a href=\"javascript:empty_form(";
echo $FLOW_ID;
echo ");\">清空</a>\r\n <a href=\"javascript:delete_form(";
echo $FLOW_ID;
echo ");\">删除</a>\r\n\r\n </td>\r\n </tr>\r\n </table>\r\n";
}
echo "\r\n<br>\r\n<div class=\"small1\" align=center>\r\n\t不明白如何设计表单和设计流程？请参考官方网站下载中心的《工作流使用详解》。\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -