📄 insert.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_html.php" );
include_once( "general/workflow/prcs_role.php" );
echo "<html>\r\n<head>\r\n<title>新建工作</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
if ( !prcs_role( $FLOW_ID, 1 ) )
{
message( "<body class=bodycolor>提示", "没有该流程新建权限，请与OA管理员联系" );
button_back( );
exit( );
}
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID=".$FLOW_ID;
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$FORM_ID = $ROW['FORM_ID'];
$AUTO_NAME = $ROW['AUTO_NAME'];
$AUTO_NUM = $ROW['AUTO_NUM'];
$AUTO_LEN = $ROW['AUTO_LEN'];
$AUTO_EDIT = $ROW['AUTO_EDIT'];
$FLOW_SORT = $ROW['FLOW_SORT'];
$FLOW_DESC = $ROW['FLOW_DESC'];
$FLOW_DESC = str_replace( "\n", "<br>", $FLOW_DESC );
}
if ( $AUTO_NAME == "" )
{
$RUN_NAME = $FLOW_NAME."(".$CUR_TIME.")";
}
else
{
$RUN_NAME = $AUTO_NAME;
$CUR_YEAR = date( "Y", time( ) );
$CUR_MON = date( "m", time( ) );
$CUR_DAY = date( "d", time( ) );
$CUR_HOUR = date( "H" );
$CUR_MINITE = date( "i" );
$CUR_SECOND = date( "s" );
$query = "SELECT USER_NAME from USER WHERE USER_ID='".$LOGIN_USER_ID."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW['USER_NAME'];
}
$query = "SELECT SORT_NAME from FLOW_SORT WHERE SORT_ID='".$FLOW_SORT."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SORT_NAME = $ROW['SORT_NAME'];
}
$query = "SELECT DEPT_NAME from DEPARTMENT WHERE DEPT_ID='".$LOGIN_DEPT_ID."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DEPT_NAME = $ROW['DEPT_NAME'];
}
$LONG_DEPT_NAME = dept_long_name( $LOGIN_DEPT_ID );
$query = "SELECT PRIV_NAME from USER_PRIV WHERE USER_PRIV='".$LOGIN_USER_PRIV."'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRIV_NAME = $ROW['PRIV_NAME'];
}
++$AUTO_NUM;
$LEN = strlen( $AUTO_NUM );
$I = 0;
for ( ; $I < $AUTO_LEN - $LEN; ++$I )
{
$AUTO_NUM = "0".$AUTO_NUM;
}
$RUN_NAME = str_replace( "{Y}", $CUR_YEAR, $RUN_NAME );
$RUN_NAME = str_replace( "{M}", $CUR_MON, $RUN_NAME );
$RUN_NAME = str_replace( "{D}", $CUR_DAY, $RUN_NAME );
$RUN_NAME = str_replace( "{H}", $CUR_HOUR, $RUN_NAME );
$RUN_NAME = str_replace( "{I}", $CUR_MINITE, $RUN_NAME );
$RUN_NAME = str_replace( "{S}", $CUR_SECOND, $RUN_NAME );
$RUN_NAME = str_replace( "{F}", $FLOW_NAME, $RUN_NAME );
$RUN_NAME = str_replace( "{FS}", $SORT_NAME, $RUN_NAME );
$RUN_NAME = str_replace( "{U}", $USER_NAME, $RUN_NAME );
$RUN_NAME = str_replace( "{SD}", $DEPT_NAME, $RUN_NAME );
$RUN_NAME = str_replace( "{LD}", $LONG_DEPT_NAME, $RUN_NAME );
$RUN_NAME = str_replace( "{R}", $PRIV_NAME, $RUN_NAME );
$RUN_NAME = str_replace( "{N}", $AUTO_NUM, $RUN_NAME );
}
$RUN_NAME = htmlspecialchars( $RUN_NAME );
$query = "SELECT 1 from FLOW_RUN WHERE RUN_NAME='".$RUN_NAME."' and FLOW_ID='{$FLOW_ID}'";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
message( "提示", "输入的工作名称/文号与之前的工作重复，请重新设置。" );
echo "<div align=center><input type=\"button\" value=\"重新设置\" class=\"BigButton\" onClick=\"location='edit.php?FLOW_ID=";
echo $FLOW_ID;
echo "';\"></div>\r\n";
exit( );
}
$query = "SELECT MAX(RUN_ID) from FLOW_RUN";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_ID = $ROW[0] + 1;
}
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "insert into FLOW_RUN(RUN_ID,RUN_NAME,FLOW_ID,BEGIN_USER,BEGIN_TIME) values (".$RUN_ID.",'{$RUN_NAME}',{$FLOW_ID},'{$LOGIN_USER_ID}','{$CUR_TIME}')";
exequery( $connection, $query );
$query = "insert into FLOW_RUN_PRCS(RUN_ID,PRCS_ID,USER_ID,PRCS_FLAG,FLOW_PRCS) values (".$RUN_ID.",1,'{$LOGIN_USER_ID}','1','1')";
exequery( $connection, $query );
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID=".$FLOW_ID;
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FORM_ID = $ROW['FORM_ID'];
$AUTO_NAME = $ROW['AUTO_NAME'];
}
if ( strstr( $AUTO_NAME, "{N}" ) )
{
$query = "update FLOW_TYPE set AUTO_NUM=AUTO_NUM+1 where FLOW_ID=".$FLOW_ID;
exequery( $connection, $query );
}
$query = "SELECT * from FLOW_FORM_TYPE WHERE FORM_ID=".$FORM_ID;
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRINT_MODEL = $ROW['PRINT_MODEL'];
}
$ELEMENT_ARRAY = html_element( $PRINT_MODEL );
$ARRAY_COUNT = sizeof( $ELEMENT_ARRAY );
$ITEM_ID = 0;
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$ENAME = get_attr( $ELEMENT_ARRAY[$I], "NAME" );
$ECLASS = get_attr( $ELEMENT_ARRAY[$I], "CLASS" );
if ( !( $ECLASS != "DATE" ) && !( $ECLASS != "USER" ) )
{
++$ITEM_ID;
if ( $ENAME != "SELECT" && $ECLASS != "LIST_VIEW" )
{
$ITEM_DATA = get_attr( $ELEMENT_ARRAY[$I], "VALUE" );
$ITEM_DATA = str_replace( "\"", "", $ITEM_DATA );
if ( $ITEM_DATA == "{宏控件}" )
{
$ITEM_DATA = "";
}
}
else
{
$ITEM_DATA = "";
}
$query = "insert into FLOW_RUN_DATA(RUN_ID,ITEM_ID,ITEM_DATA ) values (".$RUN_ID.",{$ITEM_ID},'{$ITEM_DATA}')";
exequery( $connection, $query );
}
}
$query = "update PROJ_TASK SET RUN_ID_STR=CONCAT(RUN_ID_STR,'".$RUN_ID.",') WHERE TASK_ID='{$TASK_ID}'";
exequery( $connection, $query );
header( "location: /general/workflow/list/input_form?RUN_ID=".$RUN_ID."&FLOW_ID={$FLOW_ID}&PRCS_ID=1&FLOW_PRCS=1" );
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -