freedo.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_html.php" );
include_once( "inc/utility_sms1.php" );
include_once( "../prcs_role.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/mobile_sms.inc.php" );
$connection = openconnection( );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( !run_role( $RUN_ID, $PRCS_ID ) )
{
	exit( );
}
switch ( $_REQUEST['f'] )
{
case "create" :
	$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 );
	header( "location:edit2.php?RUN_ID=".$RUN_ID."&FLOW_ID=".$FLOW_ID."&PRCS_ID=1" );
	exit( );
case "turnnext" :
	$I = 1;
	for ( ;	$I <= $ITEM_ID_MAX;	++$I	)
	{
		$STR = "DATA_".$I;
		$query = "select * from FLOW_RUN_DATA where RUN_ID={$RUN_ID} and ITEM_ID={$I}";
		$cursor = exequery( $connection, $query );
		if ( mysql_fetch_array( $cursor ) )
		{
			$query = "update FLOW_RUN_DATA set ITEM_DATA='".$$STR."' where RUN_ID={$RUN_ID} and ITEM_ID={$I}";
		}
		else
		{
			$query = "INSERT INTO FLOW_RUN_DATA (RUN_ID,ITEM_ID,ITEM_DATA) VALUES ({$RUN_ID},{$I},'".$$STR."')";
		}
		exequery( $connection, $query );
	}
	if ( $TO_ID == "" )
	{
		$query = "update FLOW_RUN_PRCS set PRCS_FLAG='4' WHERE RUN_ID={$RUN_ID}";
		exequery( $connection, $query );
		echo "<script>";
		echo "location='../work_list.php'";
		echo "</script>";
		exit( );
	}
	$PRCS_ID1 = $PRCS_ID + 1;
	$query = "insert into FLOW_RUN_PRCS(RUN_ID,PRCS_ID,USER_ID,PRCS_FLAG,LIMIT_DATE) values ({$RUN_ID},{$PRCS_ID1},'{$TO_ID}','1','{$LIMIT_DATE}')";
	exequery( $connection, $query );
	$SMS_CONTENT = "工作流提醒：您有新的工作需要办理！";
	send_sms( $connection, $LOGIN_USER_ID, $TO_ID, 7, $SMS_CONTENT );
	if ( ifsendmbsms( ) && $MOBILE_SMS_REMIND == "1" )
	{
		$newSms = new mobilesms( );
		$newSms->selfsendmore( $TO_ID, $_REQUEST['mobilect'] );
	}
	if ( $OP != "MANAGE" )
	{
		$query = "update FLOW_RUN_PRCS set DELIVER_TIME='{$CUR_TIME}',PRCS_FLAG='3' WHERE RUN_ID={$RUN_ID} and PRCS_ID={$PRCS_ID} AND USER_ID='{$LOGIN_USER_ID}'";
	}
	else
	{
		$query = "update FLOW_RUN_PRCS set DELIVER_TIME='{$CUR_TIME}',PRCS_FLAG='3' WHERE RUN_ID={$RUN_ID} and PRCS_ID={$PRCS_ID}";
	}
	exequery( $connection, $query );
	if ( $OP == "MANAGE" )
	{
		$PRCS_ID1 = $PRCS_ID - 1;
		$query = "update FLOW_RUN_PRCS set PRCS_FLAG='4' WHERE RUN_ID={$RUN_ID} AND PRCS_ID={$PRCS_ID1}";
		exequery( $connection, $query );
	}
	echo "<script>";
	echo "location='../work_list.php'";
	echo "</script>";
	exit( );
case "opsaveform" :
	$I = 1;
	for ( ;	$I <= $ITEM_ID_MAX;	++$I	)
	{
		$STR = "DATA_".$I;
		$query = "select * from FLOW_RUN_DATA where RUN_ID={$RUN_ID} and ITEM_ID={$I}";
		$cursor = exequery( $connection, $query );
		if ( mysql_fetch_array( $cursor ) )
		{
			$query = "update FLOW_RUN_DATA set ITEM_DATA='".$$STR."' where RUN_ID={$RUN_ID} and ITEM_ID={$I}";
		}
		else
		{
			$query = "INSERT INTO FLOW_RUN_DATA (RUN_ID,ITEM_ID,ITEM_DATA) VALUES ({$RUN_ID},{$I},'".$$STR."')";
		}
		exequery( $connection, $query );
	}
	$sql = " \r\n\t\t       SELECT FLOW_PRCS FROM flow_run_prcs \r\n\t\t\t\t    WHERE RUN_ID=".$_REQUEST['RUN_ID']." \r\n\t\t\t\t    AND USER_ID='".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t\t    AND PRCS_ID=".$_REQUEST['PRCS_ID'];
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$flow_prcs_turn = $row['FLOW_PRCS'];
	header( "location:free_input_form.php?RUN_ID={$RUN_ID}&FLOW_ID={$FLOW_ID}&PRCS_ID={$PRCS_ID}&FLOW_PRCS={$flow_prcs_turn}" );
	exit( );
}
?>