excel_report.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$query = "SELECT count(*) from SAL_ITEM";
$ITEM_COUNT = 0;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ITEM_COUNT = $ROW[0];
}
if ( $ITEM_COUNT == 0 )
{
	exit( );
}
$query = "SELECT * from SAL_FLOW where FLOW_ID={$FLOW_ID}";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CONTENT = $ROW['CONTENT'];
}
$EXCEL_OUT .= "部门\t";
$EXCEL_OUT .= "姓名\t";
$EXCEL_OUT .= "职务\t";
$query = "SELECT * from SAL_FLOW where FLOW_ID={$FLOW_ID}";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CONTENT = $ROW['CONTENT'];
	$STYLE = $ROW['STYLE'];
}
if ( $STYLE == "" )
{
	$query = "SELECT max( `FLOW_ID` ) as FLOW_ID,isnull(max( `FLOW_ID` )) AS flag FROM `SAL_FLOW` WHERE FLOW_ID < '{$FLOW_ID}' AND `STYLE` IS NOT NULL  AND `STYLE` !=''";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$FLOWID = $ROW['FLOW_ID'];
		$flag = $ROW['flag'];
	}
	if ( $flag == "0" )
	{
		$query = "SELECT * from SAL_FLOW where FLOW_ID={$FLOWID}";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$STYLE = $ROW['STYLE'];
		}
	}
	else
	{
		$query = "SELECT * from SAL_ITEM ORDER BY `ITEM_ID`";
		$cursor = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$ITEM_ID = $ROW['ITEM_ID'];
			$STYLE .= $ITEM_ID.",";
		}
	}
}
$STYLE_ARRAY = explode( ",", $STYLE );
$ARRAY_COUNT = sizeof( $STYLE_ARRAY );
$COUNT = 0;
if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$query1 = "select ITEM_ID,ITEM_NAME from SAL_ITEM where ITEM_ID='{$STYLE_ARRAY[$I]}'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$ITEM_NAME = $ROW['ITEM_NAME'];
		$ITEM_ID[$COUNT] = $ROW['ITEM_ID'];
		$EXCEL_OUT .= $ITEM_NAME."\t";
	}
	++$COUNT;
}
$EXCEL_OUT .= "\n";
if ( $DEPT_FLAG != 1 )
{
	$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";
}
else
{
	$query = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID=0";
}
$cursor = exequery( $connection, $query );
$USER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$USER_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$USER_PRIV = $ROW['USER_PRIV'];
	if ( $DEPT_ID == 0 )
	{
		$DEPT_NAME = "离职人员/外部人员";
	}
	else
	{
		$query1 = "select * from DEPARTMENT where DEPT_ID={$DEPT_ID}";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$DEPT_NAME = $ROW['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'];
	}
	$EXCEL_OUT .= $DEPT_NAME."\t";
	$EXCEL_OUT .= $USER_NAME."\t";
	$EXCEL_OUT .= $USER_PRIV."\t";
	$query1 = "select * from SAL_DATA where FLOW_ID={$FLOW_ID} and USER_ID='{$USER_ID}'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$I = 0;
		for ( ;	$I < $COUNT;	++$I	)
		{
			$STR = "S".$ITEM_ID[$I];
			$$STR = format_money( $ROW["{$STR}"] );
		}
	}
	else
	{
		$I = 0;
		for ( ;	$I < $COUNT;	++$I	)
		{
			$STR = "S".$ITEM_ID[$I];
			$$STR = "";
		}
	}
	$I = 0;
	for ( ;	$I < $COUNT;	++$I	)
	{
		$STR = "S".$ITEM_ID[$I];
		$STR_COUNT = $STR."_COUNT";
		$$STR_COUNT += $$STR;
		$EXCEL_OUT .= $$STR."\t";
	}
	$EXCEL_OUT .= "\n";
}
if ( $USER_COUNT != 0 )
{
	$EXCEL_OUT .= "合计\t\t\t";
	$I = 0;
	for ( ;	$I < $COUNT;	++$I	)
	{
		$STR = "S".$ITEM_ID[$I];
		$STR_COUNT = $STR."_COUNT";
		$DATA = format_money( $$STR_COUNT );
		$EXCEL_OUT .= $DATA."\t";
	}
	$EXCEL_OUT .= "\n";
}
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Accept-Ranges: bytes" );
header( "Accept-Length: ".strlen( $EXCEL_OUT ) );
header( "Content-Disposition: attachment; filename= 工资报表-{$CONTENT}.xls" );
echo $EXCEL_OUT;
?>