operation.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_sms1.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $OP == "0" )
{
	$query = "update NOTIFY set PUBLISH='3',AUDITER='".$LOGIN_USER_ID."',AUDIT_DATE='{$CUR_DATE}',REASON='{$REASON}' where NOTIFY_ID='{$NOTIFY_ID}'";
	exequery( $connection, $query );
	$query = "select FROM_ID,SUBJECT,BEGIN_DATE from NOTIFY where NOTIFY_ID='".$NOTIFY_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$FROM_ID = $ROW['FROM_ID'];
		$SUBJECT = $ROW['SUBJECT'];
		$BEGIN_DATE = $ROW['BEGIN_DATE'];
	}
	if ( compare_date( $BEGIN_DATE, $CUR_DATE ) == 1 )
	{
		$SEND_TIME = $BEGIN_DATE;
	}
	$SMS_CONTENT1 = "您提交的公告通知，标题：".csubstr( $SUBJECT, 0, 100 )." 审批未通过，原因是：".$REASON;
	send_sms( $SEND_TIME, $LOGIN_USER_ID, $FROM_ID, 1, $SMS_CONTENT1, "" );
	header( "location: unaudited.php" );
}
else
{
	$query = "update NOTIFY set PUBLISH='1',AUDITER='".$LOGIN_USER_ID."',AUDIT_DATE='{$CUR_DATE}' where NOTIFY_ID='{$NOTIFY_ID}'";
	exequery( $connection, $query );
	$query = "select * from NOTIFY where NOTIFY_ID='".$NOTIFY_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$FROM_ID = $ROW['FROM_ID'];
		$TO_ID = $ROW['TO_ID'];
		$SUBJECT = $ROW['SUBJECT'];
		$BEGIN_DATE = $ROW['BEGIN_DATE'];
		$END_DATE = $ROW['END_DATE'];
		$PRIV_ID = $ROW['PRIV_ID'];
		$TO_USER_ID = $ROW['USER_ID'];
	}
	$query_name = "select USER_NAME from USER where USER_ID='".$FROM_ID."'";
	$cursor_name = exequery( $connection, $query_name );
	if ( $ROW = mysql_fetch_array( $cursor_name ) )
	{
		$USER_NAME = $ROW['USER_NAME'];
	}
	$SMS_CONTENT = "请查看公告通知！\n标题：".csubstr( $SUBJECT, 0, 100 );
	if ( compare_date( $BEGIN_DATE, $CUR_DATE ) == 1 )
	{
		$SEND_TIME = $BEGIN_DATE;
	}
	if ( $TO_ID == "ALL_DEPT" )
	{
		$query = "select USER_ID from USER where NOT_LOGIN!='1'";
	}
	else
	{
		$query = "select USER_ID from USER where NOT_LOGIN!='1' and (find_in_set(DEPT_ID,'".$TO_ID."') or find_in_set(USER_PRIV,'{$PRIV_ID}') or find_in_set(USER_ID,'{$TO_USER_ID}'))";
	}
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$USER_ID_STR .= $ROW['USER_ID'].",";
	}
	$REMIND_URL = "1:notify/show/read_notify.php?NOTIFY_ID=".$NOTIFY_ID;
	$SMS_CONTENT1 = "您提交的公告通知，标题：".csubstr( $SUBJECT, 0, 100 )." 审批已通过。";
	send_sms( $SEND_TIME, $LOGIN_USER_ID, $FROM_ID, 1, $SMS_CONTENT1, "" );
	if ( $SMS_REMIND == "on" )
	{
		send_sms( $SEND_TIME, $FROM_ID, $USER_ID_STR, 1, $SMS_CONTENT, $REMIND_URL );
	}
	if ( $SMS2_REMIND == "on" )
	{
		$SMS_CONTENT = "OA公告,来自".$USER_NAME.":".$SUBJECT;
		send_mobile_sms_user( $SEND_TIME, $FROM_ID, $USER_ID_STR, $SMS_CONTENT, 1 );
	}
	header( "location: unaudited.php" );
}
?>