现在的位置: 首页 > 综合 > 正文

php导出excel word表格 实例(二)

2013年10月13日 ⁄ 综合 ⁄ 共 1486字 ⁄ 字号 评论关闭

<? session_start();
if ($_SESSION['Company']==''){
 //exit;
}

Header("Content-type:   application/octet-stream");
Header("Accept-Ranges:   bytes");
Header("Content-type:application/vnd.ms-excel");   
Header("Content-Disposition:attachment;filename=GoodsCheckTable.xls");  

$path = dirname(__FILE__);
require_once($path.'/../../Module/Factory.php');

$Factory = new Factory();
$BLL_Goods = $Factory->FactoryGoods();
$Goods=new Goods();
$Goods->BarCode=$_GET['GoodsID'];
$Goods->Product->BarCode=$_GET['ProductID'];

if($_SESSION['StationTitle']==''){
 $Goods->Station->ID = $_SESSION['Station'];
}
else {
 $Goods->Station->ID = $_GET['StationID'];
}
$Goods->State->ID=$_GET['StateID'];
$GoodsList=$BLL_Goods->ScanGoods($Goods);

 
   
echo   $Station2->Title."物品盘点表/n";
echo   "/n";

echo "物品条码/t";
echo "所属产品/t";
echo "入库时间/t";
echo "租金/天/t";
echo "物品价格/t";
echo "物品状态/t";
echo "所在地点/t";
echo "/n";
 if (count($GoodsList)!=0) {
     foreach ($GoodsList as $Goods){
      $Station = new Station();
      $Station->ID = $Goods->Station->ID;
      $Station = $BLL_Goods->GetStation($Station);
      $State=new State();
      $State->ID=$Goods->State->ID;
      $State=$BLL_Goods->GetState($State);
      $Product=new Product();
      $Product->BarCode= $Goods->Product->BarCode;
      $Product=$BLL_Goods->GetProduct($Product);
      
      echo "/n";
   echo $Goods->BarCode."/t";
   echo $Goods->Product->BarCode.'→'.$Product->Title."/t";
   echo date('Y年m月d日',$Goods->EntTime)."/t";
   echo $Product->Hire."/t";
   echo $Product->Price."/t";
   echo $State->Title."/t";
   echo $Station->Title."/t";
   }
}

?>

抱歉!评论已关闭.