export.php

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

<?php

include_once( "inc/auth.php" );
$str = "类别\t名称\t规格\t数量\t单价\t金额\t操作员\t入库时间\t入库单据号\n";
if ( $_REQUEST['choose'] == "exports" )
{
	$str .= $_REQUEST['sort']."\t";
	$str .= $_REQUEST['appellation']."\t";
	$str .= $_REQUEST['spec']."\t";
	$str .= $_REQUEST['join_amount']."\t";
	$str .= $_REQUEST['price']."\t";
	$str .= $_REQUEST['money']."\t";
	$str .= $_REQUEST['user_name']."\t";
	$str .= $_REQUEST['date']."\t";
	$str .= $_REQUEST['bill']."\t";
	$str .= $_REQUEST['provider_name']."\t\n";
}
if ( $_REQUEST['choose'] == "exports_all" )
{
	$connection = openconnection( );
	$cursor = exequery( $connection, stripslashes( $_REQUEST['query'] ) );
	while ( $row = mysql_fetch_array( $cursor ) )
	{
		$storeroom_id = $row['STOREROOM_ID'];
		$join_date = $row['JOIN_DATE'];
		$provider_id = $row['PROVIDER_ID'];
		$bill = $row['BILL'];
		$appellation_id = $row['APPELLATION_ID'];
		$price = $row['PRICE'];
		$join_amount = $row['JOIN_AMOUNT'];
		$money = $row['MONEY'];
		$storeroom_stockpile = $row['STOREROOM_STOCKPILE'];
		$operator = $row['OPERATOR'];
		$provider_name = $row['provider_name'];
		$date = explode( " ", $join_date );
		$query2 = "\r\n\t\t\tSELECT oa.APPELLATION, os.SORT, oa.SPEC \r\n\t\t\tFROM officeitem_appellation as oa, officeitem_sort as os \r\n\t\t\tWHERE oa.APPELLATION_ID=".$appellation_id." && os.SORT_ID=oa.SORT_ID\r\n\t\t\t";
		$cursor2 = exequery( $connection, $query2 );
		if ( $row2 = mysql_fetch_row( $cursor2 ) )
		{
			$appellation = $row2[0];
			$sort = $row2[1];
			$spec = $row2[2];
		}
		$query3 = "SELECT USER_NAME FROM user WHERE USER_ID='".$operator."'";
		$cursor3 = exequery( $connection, $query3 );
		if ( $row3 = mysql_fetch_row( $cursor3 ) )
		{
			$user_name = $row3[0];
		}
		$str .= $sort."\t";
		$str .= $appellation."\t";
		$str .= $spec."\t";
		$str .= $join_amount."\t";
		$str .= $price."\t";
		$str .= $money."\t";
		$str .= $user_name."\t";
		$str .= $date[0]."\t";
		$str .= $bill."\t";
		$str .= $provider_name."\t\n";
	}
}
if ( $_REQUEST['choose'] == "exports_all" )
{
	$str .= "总计：\t";
	$str .= "\t";
	$str .= "\t";
	$str .= $_REQUEST['sum_join_amount']."\t";
	$str .= "\t";
	$str .= $_REQUEST['sum_money']."\t";
	$str .= "\t";
	$str .= "\t";
	$str .= "\t";
	$str .= "\t\n";
}
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/vnd.ms-excel" );
header( "Accept-Ranges: bytes" );
header( "Accept-Length: ".strlen( $str ) );
header( "Content-Disposition: attachment; filename=入库单.xls" );
echo $str;
?>