📄 insert.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_sms1.php" );
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";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $TASK_NO != "" && !is_number( $TASK_NO ) )
{
	message( "", "排序号应为数字型" );
	button_back( );
	exit( );
}
if ( $BEGIN_DATE != "" && !is_date( $BEGIN_DATE ) )
{
	message( "", "起始日期应为日期型，如：1999-01-01" );
	button_back( );
	exit( );
}
if ( $END_DATE != "" && !is_date( $END_DATE ) )
{
	message( "", "结束日期应为日期型，如：1999-01-01" );
	button_back( );
	exit( );
}
if ( $FINISH_TIME != "" && !is_date_time( $FINISH_TIME ) )
{
	message( "", "完成时间应为时间型，如：1999-01-01 10:08:10" );
	button_back( );
	exit( );
}
if ( ( $SMS_REMIND == "on" || $SMS_REMIND2 == "on" ) && $REMIND_TIME == "" )
{
	message( "", "请指定提醒时间" );
	button_back( );
	exit( );
}
if ( $REMIND_TIME != "" && !is_date_time( $REMIND_TIME ) )
{
	message( "", "提醒时间应为时间型，如：1999-01-01 10:08:10" );
	button_back( );
	exit( );
}
if ( $RATE != "" && !is_number( $RATE ) )
{
	message( "", "完成率应为数字型" );
	button_back( );
	exit( );
}
if ( $TOTAL_TIME != "" && !is_number( $TOTAL_TIME ) )
{
	message( "", "工作总量应为数字型" );
	button_back( );
	exit( );
}
if ( $USE_TIME != "" && !is_number( $USE_TIME ) )
{
	message( "", "实际工作应为数字型" );
	button_back( );
	exit( );
}
$CAL_ID = 1;
$query = "INSERT INTO `TASK`(`USER_ID` , `TASK_NO` , `TASK_TYPE` , `TASK_STATUS` , `COLOR` , `IMPORTANT` , `SUBJECT` , `EDIT_TIME` , `BEGIN_DATE` , `END_DATE` , `CONTENT` , `RATE` , `FINISH_TIME` , `TOTAL_TIME` , `USE_TIME` , `CAL_ID` )\r\nVALUES ('".$LOGIN_USER_ID."', '{$TASK_NO}', '{$TASK_TYPE}', '{$TASK_STATUS}', '{$COLOR}', '{$IMPORTANT}', '{$SUBJECT}', '{$CUR_TIME}', '{$BEGIN_DATE}', '{$END_DATE}', '{$CONTENT}', '{$RATE}', '{$FINISH_TIME}', '{$TOTAL_TIME}', '{$USE_TIME}', '{$CAL_ID}');";
exequery( $connection, $query );
$TASK_ID = mysql_insert_id( );
if ( $REMIND_TIME != "" && $SMS_REMIND == "on" )
{
	$REMIND_URL = "1:calendar/task/note.php?TASK_ID=".$TASK_ID;
	$SMS_CONTENT = "请查看我的任务！\n标题：".csubstr( $SUBJECT, 0, 50 );
	send_sms( $REMIND_TIME, $LOGIN_USER_ID, $LOGIN_USER_ID, 5, $SMS_CONTENT, $REMIND_URL );
}
if ( $REMIND_TIME != "" && $SMS2_REMIND == "on" )
{
	$SMS_CONTENT = "OA任务:".$SUBJECT;
	send_mobile_sms_user( $REMIND_TIME, $LOGIN_USER_ID, $LOGIN_USER_ID, $SMS_CONTENT, 5 );
}
header( "location: index.php?PAGE_START=".$PAGE_START );
echo "\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -