bat_user_res.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

<?php
 

function delete_children( $SORT_PARENT )
{
	global $connection;
	global $EXOPORT_STR;
	global $ATTACH_PATH;
	global $EXPORT_PATH;
	$query = "select * from FILE_CONTENT where SORT_ID=".$SORT_PARENT." and ATTACHMENT_ID!=''";
	$cursor1 = exequery( $connection, $query );
	while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$ATTACHMENT_ID = $ROW1['ATTACHMENT_ID'];
		$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
		$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT - 1;	++$I	)
		{
			if ( !( $ATTACHMENT_ID_ARRAY[$I] == "" ) )
			{
				$EXOPORT_STR .= "xcopy /Q/R/Y ".str_replace( "/", "\\", $ATTACH_PATH ).$ATTACHMENT_ID_ARRAY[$I]." ".str_replace( "\\\\", "\\", $EXPORT_PATH )."folder".date( "ymdHi", time( ) )."\\".$ATTACHMENT_ID_ARRAY[$I]."\\\r\n";
			}
		}
	}
	$query = "select * from FILE_SORT where SORT_PARENT=".$SORT_PARENT;
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$SORT_ID = $ROW['SORT_ID'];
		delete_children( $SORT_ID );
	}
}

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$USER_ID_STR = substr( $TO_ID, 0, -1 );
if ( substr( $EXPORT_PATH, -1 ) != "\\" )
{
	$EXPORT_PATH .= "\\";
}
if ( $EMAIL == "on" )
{
	$query = "select * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and ATTACHMENT_ID!='' and FIND_IN_SET(FROM_ID, '".$USER_ID_STR."') or FIND_IN_SET(TO_ID, '{$USER_ID_STR}') group by EMAIL.BODY_ID";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
		$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
		$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT - 1;	++$I	)
		{
			if ( !( $ATTACHMENT_ID_ARRAY[$I] == "" ) )
			{
				$EXOPORT_STR .= "xcopy /Q/R/Y ".str_replace( "/", "\\", $ATTACH_PATH ).$ATTACHMENT_ID_ARRAY[$I]." ".str_replace( "\\\\", "\\", $EXPORT_PATH )."email".date( "ymdHi", time( ) )."\\".$ATTACHMENT_ID_ARRAY[$I]."\\\r\n";
			}
		}
	}
}
if ( $FOLDER == "on" )
{
	$query = "select * from FILE_SORT where SORT_TYPE='4' and SORT_PARENT=0 and FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$SORT_ID = $ROW['SORT_ID'];
		delete_children( $SORT_ID );
	}
	$query = "select * from FILE_CONTENT where SORT_ID=0 and ATTACHMENT_ID!='' and FIND_IN_SET(USER_ID, '".$USER_ID_STR."')";
	$cursor = exequery( $connection, $query );
	while ( $ROW1 = mysql_fetch_array( $cursor ) )
	{
		$ATTACHMENT_ID = $ROW1['ATTACHMENT_ID'];
		$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
		$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT - 1;	++$I	)
		{
			if ( !( $ATTACHMENT_ID_ARRAY[$I] == "" ) )
			{
				$EXOPORT_STR .= "xcopy /Q/R/Y ".str_replace( "/", "\\", $ATTACH_PATH ).$ATTACHMENT_ID_ARRAY[$I]." ".str_replace( "\\\\", "\\", $EXPORT_PATH )."folder".date( "ymdHi", time( ) )."\\".$ATTACHMENT_ID_ARRAY[$I]."\\\r\n";
			}
		}
	}
}
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";
}
?>