export.php

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

<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/check_type.php" );
$EXCEL_OUT = "办公用品名称,办公用品描述,办公用品类别,计量单位,供应商,警戒库存,当前库存,创建人,管理人,归属部门";
$EXCEL_OUT .= "\n";
if ( $PRO_NAME != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRO_NAME like '%".$PRO_NAME."%'";
	}
	else
	{
		$WHERE_STR .= " and PRO_NAME like '%".$PRO_NAME."%'";
	}
}
if ( $PRO_DESC != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRO_DESC like '%".$PRO_DESC."%'";
	}
	else
	{
		$WHERE_STR .= " and PRO_DESC like '%".$PRO_DESC."%'";
	}
}
if ( $PRO_UNIT != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRO_UNIT like '%".$PRO_UNIT."%'";
	}
	else
	{
		$WHERE_STR .= " and PRO_UNIT like '%".$PRO_UNIT."%'";
	}
}
if ( $PRO_SUPPLIER != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRO_SUPPLIER like '%".$PRO_SUPPLIER."%'";
	}
	else
	{
		$WHERE_STR .= " and PRO_SUPPLIER like '%".$PRO_SUPPLIER."%'";
	}
}
if ( $PRO_LOWSTOCK1 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRO_LOWSTOCK>=".$PRO_LOWSTOCK1;
	}
	else
	{
		$WHERE_STR .= " and PRO_LOWSTOCK>=".$PRO_LOWSTOCK1;
	}
}
if ( $PRO_LOWSTOCK2 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRO_LOWSTOCK<=".$PRO_LOWSTOCK2;
	}
	else
	{
		$WHERE_STR .= " and PRO_LOWSTOCK<=".$PRO_LOWSTOCK2;
	}
}
if ( $PRO_STOCK1 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRO_STOCK>=".$PRO_STOCK1;
	}
	else
	{
		$WHERE_STR .= " and PRO_STOCK>=".$PRO_STOCK1;
	}
}
if ( $PRO_STOCK2 != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where PRO_STOCK<=".$PRO_STOCK2;
	}
	else
	{
		$WHERE_STR .= " and PRO_STOCK<=".$PRO_STOCK2;
	}
}
if ( $LOW_Stock == -1 )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= "  where `PRO_STOCK` < `PRO_LOWSTOCK`";
	}
	else
	{
		$WHERE_STR .= " and `PRO_STOCK` < `PRO_LOWSTOCK`";
	}
}
$query1 = "select * from OFFICE_PRODUCTS".$WHERE_STR;
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRO_MANAGER = $ROW['PRO_MANAGER'];
	$PRO_DEPT = $ROW['PRO_DEPT'];
	$PRO_CREATOR = $ROW['PRO_CREATOR'];
	$OFFICE_PROTYPE = get_code_name( $ROW['OFFICE_PROTYPE'], "OFFICE_PROTYPE" );
	$query = "select USER_NAME from USER WHERE USER_ID='".$PRO_CREATOR."'";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$USER_NAME = $ROW1['USER_NAME'];
	}
	$query = "select USER_NAME from USER WHERE USER_ID='".$PRO_MANAGER."'";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$PRO_MANAGER_NAME1 = $ROW1['USER_NAME'];
	}
	$query = "select DEPT_ID,DEPT_NAME from DEPARTMENT";
	$cursor1 = exequery( $connection, $query );
	while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$DEPT_ID = $ROW1['DEPT_ID'];
		$DEPT_NAME = $ROW1['DEPT_NAME'];
		if ( find_id( $PRO_DEPT, $DEPT_ID ) )
		{
			$TO_NAME .= $DEPT_NAME." ";
		}
	}
	if ( $PRO_DEPT == "ALL_DEPT" )
	{
		$TO_NAME = "全体部门";
	}
	$EXCEL_OUT .= $ROW['PRO_NAME'].",".$ROW['PRO_DESC'].",".$OFFICE_PROTYPE.",".$ROW['PRO_UNIT'].",".$ROW['PRO_SUPPLIER'].",".$ROW['PRO_LOWSTOCK'].",".$ROW['PRO_STOCK'].",".$USER_NAME.",".$PRO_MANAGER_NAME1.",".$TO_NAME;
	$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=办公用品.csv" );
echo $EXCEL_OUT;
?>