create_excel.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$sql = "SELECT CONTENT FROM sal_flow WHERE FLOW_ID=".$_REQUEST['FLOW_ID'];
$cursor = exequery( $connection, $sql );
$row = mysql_fetch_array( $cursor );
$file_name = $row['CONTENT'].time( ).".xls";
$title = "部门\t姓名\t职务\t";
$sql = "SELECT ITEM_ID,ITEM_NAME FROM sal_item";
$cursor = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $cursor ) )
{
	$title .= $row['ITEM_NAME']."\t";
}
$title .= "合计\t";
$title .= "\r";
$query_c = "SELECT count(*) from SAL_ITEM";
$ITEM_COUNT = 0;
$cursor_c = exequery( $connection, $query_c );
if ( $ROW_c = mysql_fetch_array( $cursor_c ) )
{
	$ITEM_COUNT = $ROW_c[0];
}
$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV order by DEPT_NO,PRIV_NO,USER_NAME";
$cursor = exequery( $connection, $query );
$USER_COUNT = 0;
$LINE_COUNT = 0;
$TOTAL_U_STR = "";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$USER_COUNT;
	++$LINE_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$USER_PRIV = $ROW['USER_PRIV'];
	$query1 = "select * from DEPARTMENT where DEPT_ID={$DEPT_ID}";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$DEPT_NAME = $ROW['DEPT_NAME'];
	}
	if ( $DEPT_ID == 0 )
	{
		$DEPT_NAME = "离职人员/外部人员";
	}
	$query1 = "SELECT * from USER_PRIV where USER_PRIV='{$USER_PRIV}'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$USER_PRIV = $ROW['PRIV_NAME'];
	}
	$content .= $DEPT_NAME."\t";
	$content .= $USER_NAME."\t";
	$content .= $USER_PRIV."\t";
	$query1 = "select * from SAL_DATA where FLOW_ID={$FLOW_ID} and USER_ID='{$USER_ID}'";
	$cursor1 = exequery( $connection, $query1 );
	$totalPnStr = "";
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$I = 1;
		for ( ;	$I <= $ITEM_COUNT;	++$I	)
		{
			$STR = "S".$I;
			$$STR = format_money( $ROW["{$STR}"] );
			$content .= $$STR."\t";
			$totalPnStr += $$STR;
		}
		$totalPnStr = format_money( $totalPnStr );
	}
	else
	{
		$I = 1;
		for ( ;	$I <= $ITEM_COUNT;	++$I	)
		{
			$STR = "S".$I;
			$$STR = "";
			$content .= $$STR."\t";
		}
	}
	$content .= $totalPnStr."\t";
	$TOTAL_U_STR += $totalPnStr;
	$I = 1;
	for ( ;	$I <= $ITEM_COUNT;	++$I	)
	{
		$STR = "S".$I;
		$STR_COUNT = $STR."_COUNT";
		$$STR_COUNT += $$STR;
		if ( $$STR == "" )
		{
			$$STR = "";
		}
	}
	$content .= "\r";
}
$TOTAL_U_STR = format_money( $TOTAL_U_STR );
$content .= "\t\t合计\t";
$I = 1;
for ( ;	$I <= $ITEM_COUNT;	++$I	)
{
	$STR = "S".$I;
	$STR_COUNT = $STR."_COUNT";
	$DATA = format_money( $$STR_COUNT );
	if ( $DATA == "" )
	{
		$DATA = "";
	}
	$content .= $DATA."\t";
}
$content .= $TOTAL_U_STR."\t";
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Accept-Ranges: bytes" );
header( "Accept-Length: ".strlen( $outStr ) );
header( "Content-Disposition: attachment; filename=".$file_name );
echo $title.$content;
?>