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" );
include_once( "inc/function_flow.php" );
$connection = openconnection( );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( !prcs_role( $FLOW_ID, 1 ) )
{
	exit( );
}
switch ( $_REQUEST['f'] )
{
case "create" :
	$sql = "SELECT FLOW_NAME FROM flow_type WHERE FLOW_ID=".$_REQUEST['FLOW_ID'];
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$FLOW_NAME = $row['FLOW_NAME'];
	$RUN_NAME = $FLOW_NAME."(".date( "Y-m-d H:i" ).")";
	$FLOW_ID = $_REQUEST['FLOW_ID'];
	$RUN_SEQ_AUTO = getseqauto( $_REQUEST['FLOW_ID'] );
	$CREATE_TIME = date( "Y-m-d H:i:s" );
	$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,RUN_SEQ,CREATE_TIME) values ({$RUN_ID},'{$RUN_NAME}',{$FLOW_ID},'{$RUN_SEQ_AUTO}','{$CREATE_TIME}')";
	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_RUN WHERE RUN_ID={$RUN_ID}";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$FLOW_ID = $ROW['FLOW_ID'];
	}
	$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'];
	}
	$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" )
		{
			++$ITEM_ID;
			continue;
			if ( $ENAME != "SELECT" )
			{
				$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 );
		}
	}
	header( "location:main.php?RUN_ID=".$RUN_ID."&FLOW_ID=".$FLOW_ID."&PRCS_ID=1&FLOW_PRCS=1&FLOW_TYPE=".$FLOW_TYPE );
	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 == "" )
	{
		header( "location:/general/workflow/stop.php?RUN_ID=\$RUN_ID&PRCS_ID=\$PRCS_ID" );
		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:freeedit2.php?RUN_ID={$RUN_ID}&FLOW_ID={$FLOW_ID}&PRCS_ID={$PRCS_ID}&FLOW_PRCS={$flow_prcs_turn}" );
	exit( );
}
?>