tplDirectory = "warehouse/views/inventory/"; $this->serviceClass = new Service_ProductInventoryLog(); } public function listAction(){ $wh=Common_DataCache::getWarehouseSimple(); if ($this->_request->isPost()) { $page = $this->_request->getParam('page', 1); $pageSize = $this->_request->getParam('pageSize', 20); $page = $page ? $page : 1; $pageSize = $pageSize ? $pageSize : 20; $return = array( "state" => 0, "message" => "No Data" ); $params = $this->_request->getParams(); $condition = $this->serviceClass->getMatchFields($params); $condition['product_sku'] = $params['product_sku']; $condition['dateFor'] = $params['dateFor']; $condition['dateTo'] = $params['dateTo']; $condition['customer_code'] = $params['customerCode']; $count = $this->serviceClass->getJoinProductByCondition($condition, 'count(*)'); $return['total'] = $count; if ($count) { $showFields = array( 'pil_id', 'product_id', 'product_barcode', 'warehouse_id', 'reference_code', 'pil_onway', 'pil_pending', 'pil_sellable', 'pil_unsellable', 'pil_reserved', 'pil_shipped', 'pil_add_time', 'product_sku', 'customer_code', ); $showFields = $this->serviceClass->getFieldsAlias($showFields); $rows = $this->serviceClass->getJoinProductByCondition($condition, $showFields, $pageSize, $page, array('pil_add_time desc')); $return['data'] = $rows; $return['warehouse'] = $wh; $return['state'] = 1; $return['message'] = ""; } die(Zend_Json::encode($return)); } echo Ec::renderTpl($this->tplDirectory . "product-inventory-log.tpl", 'layout'); } public function exportAction(){ header('Pragma:public'); header('Content-Type:application/x-msexecl;name=productInventoryLog.xls' ); header("Content-Disposition:inline;filename=productInventoryLog.xls"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $params = $this->_request->getParams(); if($params['exportType'] == '1'){ $pilIdArr = $this->_request->getParam('pilId',''); foreach($pilIdArr as $pil_id){ $productInventoryLog = Service_ProductInventoryLog::getByField($pil_id,"pil_id","*"); echo ""; echo ""; $product = Service_Product::getByField($productInventoryLog['product_id'],"product_id","*"); echo ""; echo ""; $warehouse = Service_Warehouse::getByField($productInventoryLog['warehouse_id'],"warehouse_id","*"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } }else{ $condition = $this->serviceClass->getMatchFields($params); $condition['product_sku'] = $params['product_sku']; $condition['dateFor'] = $params['dateFor']; $condition['dateTo'] = $params['dateTo']; $condition['customer_code'] = $params['customerCode']; $count = $this->serviceClass->getJoinProductByCondition($condition, 'count(*)'); if($count){ $pageSize = 20; $totalPage = ceil($count/$pageSize); for($page=1;$page<=$totalPage;$page++){ $showFields = array( 'pil_id', 'product_id', 'product_barcode', 'warehouse_id', 'reference_code', 'pil_onway', 'pil_pending', 'pil_sellable', 'pil_unsellable', 'pil_reserved', 'pil_shipped', 'pil_add_time', 'product_sku', 'customer_code', ); $showFields = $this->serviceClass->getFieldsAlias($showFields); $rows = $this->serviceClass->getJoinProductByCondition($condition, $showFields, $pageSize, $page, array('pil_add_time desc')); foreach($rows as $key=>$value){ echo ""; echo ""; $product = Service_Product::getByField($value['E1'],'product_id',"*"); echo ""; echo ""; $warehouse = Service_Warehouse::getByField($value['E3'],"warehouse_id","*"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } } } } }

产品代码	产品SKU	客户代码	仓库	在途	已收货	可用	不良品	冻结	已出货	时间
{$productInventoryLog['product_barcode']}	{$product['product_sku']}	{$product['customer_code']}	{$warehouse['warehouse_code']}	{$productInventoryLog['pil_onway']}	{$productInventoryLog['pil_pending']}	{$productInventoryLog['pil_sellable']}	{$productInventoryLog['pil_unsellable']}	{$productInventoryLog['pil_reserved']}	{$productInventoryLog['pil_shipped']}	{$productInventoryLog['pil_add_time']}
{$value['E2']}	{$value['product_sku']}	{$product['customer_code']}	{$warehouse['warehouse_code']}	{$value['E6']}	{$value['E7']}	{$value['E8']}	{$value['E9']}	{$value['E10']}	{$value['E11']}	{$value['E16']}