submit.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

<?php
 

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
if ( !is_number( $ORDER_NO ) )
{
	message( "错误", "排序号应为数字！" );
	button_back( );
	exit( );
}
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
$BEGIN_DATE = date( "Y-m-d", time( ) );
$query = "SELECT * from TRAIN_SURVEY_TITLE where SURVEY_ID='".$SURVEY_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$TO_ID = $ROW['TO_ID'];
	$PRIV_ID = $ROW['PRIV_ID'];
	$USER_ID = $ROW['USER_ID'];
	$CONTENT = $ROW['CONTENT'];
	$TYPE = $ROW['TYPE'];
	$MAX_NUM = $ROW['MAX_NUM'];
	$ANONYMITY = $ROW['ANONYMITY'];
	$VIEW_PRIV = $ROW['VIEW_PRIV'];
}
$query = "insert into TRAIN_SURVEY_TITLE(FROM_ID,TO_ID,PRIV_ID,USER_ID,ORDER_NO,SUBJECT,CONTENT,SEND_TIME,BEGIN_DATE,TYPE,MAX_NUM,ANONYMITY,VIEW_PRIV,PUBLISH) values ('".$LOGIN_USER_ID."','{$TO_ID}','{$PRIV_ID}','{$USER_ID}','{$ORDER_NO}','{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$BEGIN_DATE}','{$TYPE}',{$MAX_NUM},'{$ANONYMITY}','{$VIEW_PRIV}','0')";
exequery( $connection, $query );
$CLONE_SURVEY_ID = mysql_insert_id( );
$query = "SELECT * from TRAIN_SURVEY_TITLE where PARENT_ID='".$SURVEY_ID."'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$SUB_SURVEY_ID = $ROW['SURVEY_ID'];
	$SUBJECT = $ROW['SUBJECT'];
	$CONTENT = $ROW['CONTENT'];
	$TYPE = $ROW['TYPE'];
	$MAX_NUM = $ROW['MAX_NUM'];
	$ANONYMITY = $ROW['ANONYMITY'];
	$VIEW_PRIV = $ROW['VIEW_PRIV'];
	$ORDER_NO = $ROW['ORDER_NO'];
	$SUBJECT = addslashes( $SUBJECT );
	$query1 = "insert into TRAIN_SURVEY_TITLE(PARENT_ID,FROM_ID,ORDER_NO,SUBJECT,CONTENT,SEND_TIME,BEGIN_DATE,TYPE,MAX_NUM,ANONYMITY,VIEW_PRIV,PUBLISH) values ('".$CLONE_SURVEY_ID."','{$LOGIN_USER_ID}','{$ORDER_NO}','{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$BEGIN_DATE}','{$TYPE}',{$MAX_NUM},'{$ANONYMITY}','{$VIEW_PRIV}','0')";
	exequery( $connection, $query1 );
	$CLONE_SUB_SURVEY_ID = mysql_insert_id( );
	$query1 = "SELECT * from TRAIN_SURVEY_ITEM where SURVEY_ID='".$SUB_SURVEY_ID."' order by ITEM_ID asc";
	$cursor1 = exequery( $connection, $query1 );
	while ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$ITEM_NAME = $ROW['ITEM_NAME'];
		$ITEM_NAME = addslashes( $ITEM_NAME );
		$query2 = "insert into TRAIN_SURVEY_ITEM(SURVEY_ID,ITEM_NAME) values ('".$CLONE_SUB_SURVEY_ID."','{$ITEM_NAME}')";
		exequery( $connection, $query2 );
	}
}
header( "location: ../index1.php?CUR_PAGE=1" );
?>