📄 insert.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_html.php" );
include_once( "../prcs_role.php" );
if ( !prcs_role( $FLOW_ID, 1 ) )
{
exit( );
}
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</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$RUN_NAME = $RUN_NAME_LEFT.$RUN_NAME.$RUN_NAME_RIGHT;
$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;
}
if ( strstr( $RUN_NAME, "{RUN}" ) )
{
$RUN_NAME = str_replace( "{RUN}", $RUN_ID, $RUN_NAME );
}
$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 );
}
}
if ( $MENU_FLAG == "1" )
{
header( "location: ../list?FLOW_ID=".$FLOW_ID );
}
else if ( $AUTO_NEW )
{
header( "location: ../list/input_form?RUN_ID=".$RUN_ID."&FLOW_ID={$FLOW_ID}&PRCS_ID=1&FLOW_PRCS=1" );
}
else
{
header( "location: ../list" );
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -