insert.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 105 行

PHP
105
字号
<?php
 

function reg_sms1( )
{
	global $TD_MYOA_COMPANY_NAME;
	global $TD_MYOA_PRODUCT_NAME;
	global $TD_MYOA_WEB_SITE;
	global $connection;
	$CONTENT = "警告:".$TD_MYOA_PRODUCT_NAME."为".$TD_MYOA_COMPANY_NAME."版权所有,请在软件注册后使用,并请遵循有关法律,正版下载网址:".$TD_MYOA_WEB_SITE;
	$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
	$query = "select USER_ID from USER";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$USER_ID = $ROW['USER_ID'];
		$query1 = "insert into SMS(FROM_ID,TO_ID,SMS_TYPE,CONTENT,SEND_TIME,REMIND_FLAG) values ('admin','".$USER_ID."','0','{$CONTENT}','{$SEND_TIME}','1')";
		exequery( $connection, $query1 );
	}
}

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";
$query = "SELECT * from FLOW_RUN WHERE RUN_NAME='".$RUN_NAME."'";
$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;
}
$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_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 );
		}
		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 + =
减小字号Ctrl + -
显示快捷键?