📄 submit.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.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";
if ( $OP == "2" )
{
	if ( substr( $EXPORT_PATH, 0, -1 ) != "\\" )
	{
		$EXPORT_PATH .= "\\";
	}
	$EXPORT_PATH = str_replace( "\\\\", "\\", $EXPORT_PATH );
}
$query = "SELECT * from FLOW_RUN,FLOW_RUN_PRCS where FLOW_RUN.RUN_ID=FLOW_RUN_PRCS.RUN_ID and FLOW_ID=".$FLOW_ID."  and PRCS_ID=1 ";
if ( $BEGIN_DATE != "" )
{
	$query .= " and PRCS_TIME>='".$BEGIN_DATE." 00:00:00'";
}
if ( $END_DATE != "" )
{
	$query .= " and PRCS_TIME<='".$END_DATE." 23:59:59'";
}
if ( $BEGIN_RUN_ID != "" )
{
	$query .= " and FLOW_RUN.RUN_ID>='".$BEGIN_RUN_ID."'";
}
if ( $END_RUN_ID != "" )
{
	$query .= " and FLOW_RUN.RUN_ID<='".$END_RUN_ID."'";
}
if ( $COPY_TO_ID != "" )
{
	$query .= " and find_in_set(USER_ID,'".$COPY_TO_ID."')";
}
$COUNT = 0;
$cursor = exequery( $connection, $query );
do
{
	do
	{
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			++$COUNT;
			$RUN_ID = $ROW['RUN_ID'];
			$PRCS_TIME = $ROW['PRCS_TIME'];
			$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
			$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
			if ( !( $OP == 1 ) )
			{
				break;
			}
			if ( $ATTACHMENT_NAME != "" )
			{
				$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
				$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
				$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
				$I = 0;
				for ( ;	$I < $ARRAY_COUNT;	++$I	)
				{
					if ( $ATTACHMENT_ID_ARRAY[$I] != "" )
					{
						delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
					}
				}
			}
			$query1 = "select * from FLOW_RUN_FEEDBACK where RUN_ID=".$RUN_ID;
			$cursor1 = exequery( $connection, $query1 );
			$ATTACHMENT_NAME = "";
			while ( $ROW = mysql_fetch_array( $cursor1 ) )
			{
				$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
				$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
				if ( !( $ATTACHMENT_NAME != "" ) )
				{
					continue;
				}
				$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
				$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
				$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
				$I = 0;
				for ( ;	$I < $ARRAY_COUNT;	++$I	)
				{
					if ( $ATTACHMENT_ID_ARRAY[$I] != "" )
					{
						delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
					}
				}
			}
			$query = "delete from FLOW_RUN_FEEDBACK where RUN_ID=".$RUN_ID;
			exequery( $connection, $query );
			$query = "delete from FLOW_RUN_DATA where RUN_ID=".$RUN_ID;
			exequery( $connection, $query );
			$query = "delete from FLOW_RUN_PRCS where RUN_ID=".$RUN_ID;
			exequery( $connection, $query );
			$query = "delete from FLOW_RUN where RUN_ID=".$RUN_ID;
			exequery( $connection, $query );
		}
		$PRCS_TIME = str_replace( ":", ".", $PRCS_TIME );
		$PRCS_TIME = str_replace( " ", "~", $PRCS_TIME );
		$OUT_PATH = $EXPORT_PATH.$PRCS_TIME;
		$ATTACH_PATH = str_replace( "/", "\\", $ATTACH_PATH );
		if ( $ATTACHMENT_NAME != "" )
		{
			$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
			$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
			$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
			$I = 0;
			for ( ;	$I < $ARRAY_COUNT;	++$I	)
			{
				if ( $ATTACHMENT_ID_ARRAY[$I] != "" )
				{
					$PATH = $ATTACH_PATH.$ATTACHMENT_ID_ARRAY[$I];
					$EXOPORT_STR .= "xcopy /y ".$PATH." ".$OUT_PATH."\\公共附件\\\r\n";
				}
			}
		}
		$query1 = "select * from FLOW_RUN_FEEDBACK where RUN_ID=".$RUN_ID;
		$cursor1 = exequery( $connection, $query1 );
		$ATTACHMENT_NAME = "";
	} while ( !( $ROW = mysql_fetch_array( $cursor1 ) ) );
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
	$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
	$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
	$I = 0;
} while ( $I < $ARRAY_COUNT );
do
{
	do
	{
		++$I;
	} while ( 1 );
	$PATH = $ATTACH_PATH.$ATTACHMENT_ID_ARRAY[$I];
	$EXOPORT_STR .= "xcopy /y ".$PATH." ".$OUT_PATH."\\会签附件\\\r\n";
} while ( 1 );
if ( $OP == 1 )
{
	message( "提示", "共删除 ".$COUNT." 项工作的数据" );
	button_back( );
}
else
{
	ob_end_clean( );
	header( "Cache-control: private" );
	header( "Content-type: application/octet-stream" );
	header( "Accept-Ranges: bytes" );
	header( "Content-Disposition: attachment; filename=工作流附件导出.bat" );
	if ( $EXOPORT_STR != "" )
	{
		echo "@echo 正在导出工作流附件...\r\n".$EXOPORT_STR."\r\n@echo 工作流附件导出完毕!\r\npause";
	}
	else
	{
		echo "@echo 无符合条件的工作流附件\r\npause";
	}
}
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -