📄 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";
$connection = openconnection( );
$query = "SELECT MAX(RUN_ID) from FLOW_RUN";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_ID = $ROW[0] + 1;
}
$query = "insert into FLOW_RUN(RUN_ID,RUN_NAME,FLOW_ID) values ({$RUN_ID},'{$RUN_NAME}',{$FLOW_ID})";
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_RUN WHERE RUN_ID={$RUN_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FLOW_ID = $ROW['FLOW_ID'];
}
$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'];
}
$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" )
{
++$ITEM_ID;
continue;
if ( $ENAME != "SELECT" )
{
$ITEM_DATA = get_attr( $ELEMENT_ARRAY[$I], "VALUE" );
$ITEM_DATA = str_replace( "\"", "", $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 );
}
}
header( "location: ../index.php" );
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -