';
$exportContent .= '| 前海湾保税港区跨境电商项目转关入区装箱清单 |
';
$exportContent .= '';
$exportContent .= '| 序号 | ';
$exportContent .= '入区单号 | ';
$exportContent .= '建单时间 | ';
$exportContent .= '收货完成时间 | ';
$exportContent .= '订单号 | ';
$exportContent .= '运单号 | ';
$exportContent .= '产品SKU | ';
$exportContent .= '数量 | ';
$exportContent .= '单位 | ';
$exportContent .= '料件号 | ';
$exportContent .= '海关商品编码 | ';
$exportContent .= '海关品名 | ';
$exportContent .= '单价(USD) | ';
$exportContent .= '总价(USD) | ';
$exportContent .= '重量(KG) | ';
$exportContent .= '报关单项号 | ';
$exportContent .= '客户名称 | ';
$exportContent .= '
';
$exportIndex = 1;
$filename = 'ReceivingCustomsInfo-'. date('YmdHis') . '.xls';
header('Pragma:public');
header('Content-Type:application/x-msexecl;name="' . $filename . '"');
header('Content-Disposition:inline;filename=' . $filename);
foreach ($selectedAsn as $asnCode) {
$asn = Service_Receiving::getByField($asnCode, 'receiving_code');
$receivingAttr=Service_ReceivingAttribute::getByField($asnCode,'receiving_code');
if (empty($asn)) {
continue ;
}
$formIdMap = array();
$asnSplit = Service_ReceivingXml::getByCondition(array(
'receiving_code' => $asnCode,
));
if (!empty($asnSplit)) {
foreach ($asnSplit as $item) {
$formIdMap[$item['sub_receiving_code']] = $item['refercence_form_id'];
}
}
if (1 === (int) $asn['receive_model_type']) {
// 集货模式
$asnOrder = Service_ReceivingOrderDetail::getByCondition(array(
'receiving_code' => $asn['receiving_code'],
));
foreach ($asnOrder as $item) {
$order = Service_Orders::getByField($item['order_code'], 'order_code');
$customer = Service_Customer::getByField($order['customer_code'], 'customer_code');
$orderProduct = Service_OrderProduct::getByCondition(array(
'order_code' => $order['order_code'],
));
foreach ($orderProduct as $opItem) {
$product = Service_Product::getByField($opItem['product_id'], 'product_id');
if (empty($product)) {
continue ;
}
if (1 == (int) $product['product_type']) {
// 组合产品需要分拆
$productCombine = Service_ProductCombineRelation::getByCondition(array(
'product_id' => $product['product_id'],
));
foreach ($productCombine as $pcItem) {
$subProduct = Service_Product::getByField($pcItem['pcr_product_id'], 'product_id');
if (empty($product)) {
continue ;
}
// 由产品料件号反推获取相关信息
$asnSplitDetail = Service_ReceivingXmlDetail::getByCondition(array(
'from_id' => $asn['receiving_code'],
'goods_id' => $subProduct['goods_id'],
));
if (!empty($asnSplitDetail) && isset($formIdMap[$asnSplitDetail[0]['sub_receiving_code']])) {
$formId = $formIdMap[$asnSplitDetail[0]['sub_receiving_code']];
}
else {
$formId = '';
}
$exportContent .= '';
$exportContent .= '| ' . $exportIndex . ' | ';
$exportContent .= '' . $asn['receiving_code'] . ' | ';
$exportContent .= '' . $asn['receiving_add_time'] . ' | ';
$exportContent .= '' . $receivingAttr['complete_received_time'] . ' | ';
$exportContent .= '' . $order['order_code'] . ' | ';
$exportContent .= '' . $order['ref_tracking_number'] . ' | ';
$exportContent .= '' . $subProduct['product_sku'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $pcItem['pcr_quantity'] . ' | ';
$exportContent .= '' . $this->productUom[$subProduct['pu_code']] . ' | ';
$exportContent .= '' . $subProduct['goods_id'] . ' | ';
$exportContent .= '' . $subProduct['hs_code'] . ' | ';
$exportContent .= '' . $subProduct['hs_goods_name'] . ' | ';
$exportContent .= '' . $subProduct['product_declared_value'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $pcItem['pcr_quantity'] * $subProduct['product_declared_value'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $pcItem['pcr_quantity'] * $subProduct['product_weight'] . ' | ';
$exportContent .= '' . $formId . ' | ';
$exportContent .= '' . $customer['customer_company_name'] . ' | ';
$exportContent .= '
';
++$exportIndex;
}
}
else {
// 普通产品
// 由产品料件号反推获取相关信息
$asnSplitDetail = Service_ReceivingXmlDetail::getByCondition(array(
'from_id' => $asn['receiving_code'],
'goods_id' => $product['goods_id'],
));
if (!empty($asnSplitDetail) && isset($formIdMap[$asnSplitDetail[0]['sub_receiving_code']])) {
$formId = $formIdMap[$asnSplitDetail[0]['sub_receiving_code']];
}
else {
$formId = '';
}
$exportContent .= '';
$exportContent .= '| ' . $exportIndex . ' | ';
$exportContent .= '' . $asn['receiving_code'] . ' | ';
$exportContent .= '' . $asn['receiving_add_time'] . ' | ';
$exportContent .= '' . $receivingAttr['complete_received_time'] . ' | ';
$exportContent .= '' . $order['order_code'] . ' | ';
$exportContent .= '' . $order['ref_tracking_number'] . ' | ';
$exportContent .= '' . $product['product_sku'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] . ' | ';
$exportContent .= '' . $this->productUom[$product['pu_code']] . ' | ';
$exportContent .= '' . $product['goods_id'] . ' | ';
$exportContent .= '' . $product['hs_code'] . ' | ';
$exportContent .= '' . $product['hs_goods_name'] . ' | ';
$exportContent .= '' . $product['product_declared_value'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $product['product_declared_value'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $product['product_weight'] . ' | ';
$exportContent .= '' . $formId . ' | ';
$exportContent .= '' . $customer['customer_company_name'] . ' | ';
$exportContent .= '
';
++$exportIndex;
}
}
}
}
else {
// 备货模式
$asnProduct = Service_ReceivingDetail::getByCondition(array(
'receiving_code' => $asn['receiving_code'],
));
foreach ($asnProduct as $apItem) {
$product = Service_Product::getByField($apItem['product_id'], 'product_id');
if (empty($product)) {
continue ;
}
$customer = Service_Customer::getByField($product['customer_id'], 'customer_id');
if (1 == (int) $product['product_type']) {
// 组合产品需要分拆
$productCombine = Service_ProductCombineRelation::getByCondition(array(
'product_id' => $product['product_id'],
));
foreach ($productCombine as $pcItem) {
$subProduct = Service_Product::getByField($pcItem['pcr_product_id'], 'product_id');
if (empty($product)) {
continue ;
}
// 由产品料件号反推获取相关信息
$asnSplitDetail = Service_ReceivingXmlDetail::getByCondition(array(
'from_id' => $asn['receiving_code'],
'goods_id' => $subProduct['goods_id'],
));
if (!empty($asnSplitDetail) && isset($formIdMap[$asnSplitDetail[0]['sub_receiving_code']])) {
$formId = $formIdMap[$asnSplitDetail[0]['sub_receiving_code']];
}
else {
$formId = '';
}
$exportContent .= '';
$exportContent .= '| ' . $exportIndex . ' | ';
$exportContent .= '' .$asn['receiving_code'] . ' | ';
$exportContent .= '' . $asn['receiving_add_time'] . ' | ';
$exportContent .= '' . $receivingAttr['complete_received_time'] . ' | ';
$exportContent .= ' | ';
$exportContent .= ' | ';
$exportContent .= '' . $subProduct['product_sku'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $pcItem['pcr_quantity'] . ' | ';
$exportContent .= '' . $this->productUom[$subProduct['pu_code']] . ' | ';
$exportContent .= '' . $subProduct['goods_id'] . ' | ';
$exportContent .= '' . $subProduct['hs_code'] . ' | ';
$exportContent .= '' . $subProduct['hs_goods_name'] . ' | ';
$exportContent .= '' . $subProduct['product_declared_value'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $pcItem['pcr_quantity'] * $subProduct['product_declared_value'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $pcItem['pcr_quantity'] * $subProduct['product_weight'] . ' | ';
$exportContent .= '' . $formId . ' | ';
$exportContent .= '' . $customer['customer_company_name'] . ' | ';
$exportContent .= '
';
++$exportIndex;
}
}
else {
// 普通产品
// 由产品料件号反推获取相关信息
$asnSplitDetail = Service_ReceivingXmlDetail::getByCondition(array(
'from_id' => $asn['receiving_code'],
'goods_id' => $product['goods_id'],
));
if (!empty($asnSplitDetail) && isset($formIdMap[$asnSplitDetail[0]['sub_receiving_code']])) {
$formId = $formIdMap[$asnSplitDetail[0]['sub_receiving_code']];
}
else {
$formId = '';
}
$exportContent .= '';
$exportContent .= '| ' . $exportIndex . ' | ';
$exportContent .= '' . $asn['receiving_code'] . ' | ';
$exportContent .= '' . $asn['receiving_add_time'] . ' | ';
$exportContent .= '' . $receivingAttr['complete_received_time'] . ' | ';
$exportContent .= ' | ';
$exportContent .= ' | ';
$exportContent .= '' . $product['product_sku'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] . ' | ';
$exportContent .= '' . $this->productUom[$product['pu_code']] . ' | ';
$exportContent .= '' . $product['goods_id'] . ' | ';
$exportContent .= '' . $product['hs_code'] . ' | ';
$exportContent .= '' . $product['hs_goods_name'] . ' | ';
$exportContent .= '' . $product['product_declared_value'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $product['product_declared_value'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $product['product_weight'] . ' | ';
$exportContent .= '' . $formId . ' | ';
$exportContent .= '' . $customer['customer_company_name'] . ' | ';
$exportContent .= '
';
++$exportIndex;
}
}
}
ob_flush();
flush();
}
$exportContent .= '
';
echo $exportContent;
exit();
}
public function exportAllAction() {
set_time_limit(0);
ini_set('memory_limit', '1024M');
$params = $this->_request->getParams();
$operationType = isset($params['operationType']) ? $params['operationType'] : '';
$operationCode = isset($params['operationCode']) ? $params['operationCode'] : '';
if (!empty($operationCode)) {
$params[$operationType] = $operationCode;
}
$condition = $this->serviceClass->getMatchFields($params);
$condition['dateFor'] = isset($params['dateFor']) ? $params['dateFor'] : '';
$condition['dateTo'] = isset($params['dateTo']) ? $params['dateTo'] : '';
$condition['receiving_status_arr'] = isset($params['receiving_status_arr']) ? trim($params['receiving_status_arr']) : '';
$asnRows = $this->serviceClass->getByCondition($condition);
$exportContent = '';
$exportContent .= '| 前海湾保税港区跨境电商项目转关入区装箱清单 |
';
$exportContent .= '';
$exportContent .= '| 序号 | ';
$exportContent .= '入区单号 | ';
$exportContent .= '建单时间 | ';
$exportContent .= '收货完成时间 | ';
$exportContent .= '订单号 | ';
$exportContent .= '运单号 | ';
$exportContent .= '产品SKU | ';
$exportContent .= '数量 | ';
$exportContent .= '单位 | ';
$exportContent .= '料件号 | ';
$exportContent .= '海关商品编码 | ';
$exportContent .= '海关品名 | ';
$exportContent .= '单价(USD) | ';
$exportContent .= '总价(USD) | ';
$exportContent .= '重量(KG) | ';
$exportContent .= '报关单项号 | ';
$exportContent .= '客户名称 | ';
$exportContent .= '
';
$exportIndex = 1;
$filename = 'ReceivingCustomsInfo-'. date('YmdHis') . '.xls';
header('Pragma:public');
header('Content-Type:application/x-msexecl;name="' . $filename . '"');
header('Content-Disposition:inline;filename=' . $filename);
if (!empty($asnRows)) {
foreach ($asnRows as $asn) {
$formIdMap = array();
$asnSplit = Service_ReceivingXml::getByCondition(array(
'receiving_code' => $asn['receiving_code'],
));
$receivingAttr=Service_ReceivingAttribute::getByField($asn['receiving_code'],'receiving_code');
if (!empty($asnSplit)) {
foreach ($asnSplit as $item) {
$formIdMap[$item['sub_receiving_code']] = $item['refercence_form_id'];
}
}
if (1 === (int) $asn['receive_model_type']) {
// 集货模式
$asnOrder = Service_ReceivingOrderDetail::getByCondition(array(
'receiving_code' => $asn['receiving_code'],
));
foreach ($asnOrder as $item) {
$order = Service_Orders::getByField($item['order_code'], 'order_code');
$customer = Service_Customer::getByField($order['customer_code'], 'customer_code');
$orderProduct = Service_OrderProduct::getByCondition(array(
'order_code' => $order['order_code'],
));
foreach ($orderProduct as $opItem) {
$product = Service_Product::getByField($opItem['product_id'], 'product_id');
if (1 == (int) $product['product_type']) {
// 组合产品需要分拆
$productCombine = Service_ProductCombineRelation::getByCondition(array(
'product_id' => $product['product_id'],
));
foreach ($productCombine as $pcItem) {
$subProduct = Service_Product::getByField($pcItem['pcr_product_id'], 'product_id');
// 由产品料件号反推获取相关信息
$asnSplitDetail = Service_ReceivingXmlDetail::getByCondition(array(
'from_id' => $asn['receiving_code'],
'goods_id' => $subProduct['goods_id'],
));
if (!empty($asnSplitDetail) && isset($formIdMap[$asnSplitDetail[0]['sub_receiving_code']])) {
$formId = $formIdMap[$asnSplitDetail[0]['sub_receiving_code']];
}
else {
$formId = '';
}
$exportContent .= '';
$exportContent .= '| ' . $exportIndex . ' | ';
$exportContent .= '' . $asn['receiving_code'] . ' | ';
$exportContent .= '' . $asn['receiving_add_time'] . ' | ';
$exportContent .= '' . $receivingAttr['complete_received_time'] . ' | ';
$exportContent .= '' . $order['order_code'] . ' | ';
$exportContent .= '' . $order['ref_tracking_number'] . ' | ';
$exportContent .= '' . $subProduct['product_sku'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $pcItem['pcr_quantity'] . ' | ';
$exportContent .= '' . $this->productUom[$subProduct['pu_code']] . ' | ';
$exportContent .= '' . $subProduct['goods_id'] . ' | ';
$exportContent .= '' . $subProduct['hs_code'] . ' | ';
$exportContent .= '' . $subProduct['hs_goods_name'] . ' | ';
$exportContent .= '' . $subProduct['product_declared_value'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $pcItem['pcr_quantity'] * $subProduct['product_declared_value'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $pcItem['pcr_quantity'] * $subProduct['product_weight'] . ' | ';
$exportContent .= '' . $formId . ' | ';
$exportContent .= '' . $customer['customer_company_name'] . ' | ';
$exportContent .= '
';
++$exportIndex;
}
}
else {
// 普通产品
// 由产品料件号反推获取相关信息
$asnSplitDetail = Service_ReceivingXmlDetail::getByCondition(array(
'from_id' => $asn['receiving_code'],
'goods_id' => $product['goods_id'],
));
if (!empty($asnSplitDetail) && isset($formIdMap[$asnSplitDetail[0]['sub_receiving_code']])) {
$formId = $formIdMap[$asnSplitDetail[0]['sub_receiving_code']];
}
else {
$formId = '';
}
$exportContent .= '';
$exportContent .= '| ' . $exportIndex . ' | ';
$exportContent .= '' . $asn['receiving_code'] . ' | ';
$exportContent .= '' . $asn['receiving_add_time'] . ' | ';
$exportContent .= '' . $receivingAttr['complete_received_time'] . ' | ';
$exportContent .= '' . $order['order_code'] . ' | ';
$exportContent .= '' . $order['ref_tracking_number'] . ' | ';
$exportContent .= '' . $product['product_sku'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] . ' | ';
$exportContent .= '' . $this->productUom[$product['pu_code']] . ' | ';
$exportContent .= '' . $product['goods_id'] . ' | ';
$exportContent .= '' . $product['hs_code'] . ' | ';
$exportContent .= '' . $product['hs_goods_name'] . ' | ';
$exportContent .= '' . $product['product_declared_value'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $product['product_declared_value'] . ' | ';
$exportContent .= '' . $opItem['op_quantity'] * $product['product_weight'] . ' | ';
$exportContent .= '' . $formId . ' | ';
$exportContent .= '' . $customer['customer_company_name'] . ' | ';
$exportContent .= '
';
++$exportIndex;
}
}
}
}
else {
// 备货模式
$asnProduct = Service_ReceivingDetail::getByCondition(array(
'receiving_code' => $asn['receiving_code'],
));
foreach ($asnProduct as $apItem) {
$product = Service_Product::getByField($apItem['product_id'], 'product_id');
if (empty($product)) {
continue ;
}
$customer = Service_Customer::getByField($product['customer_id'], 'customer_id');
if (1 == (int) $product['product_type']) {
// 组合产品需要分拆
$productCombine = Service_ProductCombineRelation::getByCondition(array(
'product_id' => $product['product_id'],
));
foreach ($productCombine as $pcItem) {
$subProduct = Service_Product::getByField($pcItem['pcr_product_id'], 'product_id');
// 由产品料件号反推获取相关信息
$asnSplitDetail = Service_ReceivingXmlDetail::getByCondition(array(
'from_id' => $asn['receiving_code'],
'goods_id' => $subProduct['goods_id'],
));
if (!empty($asnSplitDetail) && isset($formIdMap[$asnSplitDetail[0]['sub_receiving_code']])) {
$formId = $formIdMap[$asnSplitDetail[0]['sub_receiving_code']];
}
else {
$formId = '';
}
$exportContent .= '';
$exportContent .= '| ' . $exportIndex . ' | ';
$exportContent .= '' . $asn['receiving_code'] . ' | ';
$exportContent .= '' . $asn['receiving_add_time'] . ' | ';
$exportContent .= '' . $receivingAttr['complete_received_time'] . ' | ';
$exportContent .= ' | ';
$exportContent .= ' | ';
$exportContent .= '' . $subProduct['product_sku'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $pcItem['pcr_quantity'] . ' | ';
$exportContent .= '' . $this->productUom[$subProduct['pu_code']] . ' | ';
$exportContent .= '' . $subProduct['goods_id'] . ' | ';
$exportContent .= '' . $subProduct['hs_code'] . ' | ';
$exportContent .= '' . $subProduct['hs_goods_name'] . ' | ';
$exportContent .= '' . $subProduct['product_declared_value'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $pcItem['pcr_quantity'] * $subProduct['product_declared_value'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $pcItem['pcr_quantity'] * $subProduct['product_weight'] . ' | ';
$exportContent .= '' . $formId . ' | ';
$exportContent .= '' . $customer['customer_company_name'] . ' | ';
$exportContent .= '
';
++$exportIndex;
}
}
else {
// 普通产品
// 由产品料件号反推获取相关信息
$asnSplitDetail = Service_ReceivingXmlDetail::getByCondition(array(
'from_id' => $asn['receiving_code'],
'goods_id' => $product['goods_id'],
));
if (!empty($asnSplitDetail) && isset($formIdMap[$asnSplitDetail[0]['sub_receiving_code']])) {
$formId = $formIdMap[$asnSplitDetail[0]['sub_receiving_code']];
}
else {
$formId = '';
}
$exportContent .= '';
$exportContent .= '| ' . $exportIndex . ' | ';
$exportContent .= '' . $asn['receiving_code'] . ' | ';
$exportContent .= '' . $asn['receiving_add_time'] . ' | ';
$exportContent .= '' . $receivingAttr['complete_received_time'] . ' | ';
$exportContent .= ' | ';
$exportContent .= ' | ';
$exportContent .= '' . $product['product_sku'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] . ' | ';
$exportContent .= '' . $this->productUom[$product['pu_code']] . ' | ';
$exportContent .= '' . $product['goods_id'] . ' | ';
$exportContent .= '' . $product['hs_code'] . ' | ';
$exportContent .= '' . $product['hs_goods_name'] . ' | ';
$exportContent .= '' . $product['product_declared_value'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $product['product_declared_value'] . ' | ';
$exportContent .= '' . $apItem['rd_receiving_qty'] * $product['product_weight'] . ' | ';
$exportContent .= '' . $formId . ' | ';
$exportContent .= '' . $customer['customer_company_name'] . ' | ';
$exportContent .= '
';
++$exportIndex;
}
}
}
ob_flush();
flush();
}
}
$exportContent .= '
';
echo $exportContent;
exit();
}
public function exportOutAction()
{
if ($this->_request->isPost()) {
$selectedCode =$this->_request->getParam('selectedCode',array());
if (!empty($selectedCode)) {
}else{
$params = $this->_request->getParams();
$operationType = isset($params['operationType']) ? $params['operationType'] : '';
$operationCode = isset($params['operationCode']) ? $params['operationCode'] : '';
if (!empty($operationCode)) {
$params[$operationType] = $operationCode;
}
$condition = $this->serviceClass->getMatchFields($params);
if($operationType == 'E18'){
unset($condition['receiving_id']);
$receiving = Service_ReceivingOrderDetail::getByCondition(array('order_code'=>$operationCode),array('receiving_id'));
if($receiving){
foreach($receiving AS $value){
$condition['receiving_id'][$value['
receiving_id']] = $value['receiving_id'];
}
}
}
$condition['dateFor'] = isset($params['dateFor'])?$params['dateFor']:'';
$condition['dateTo'] = isset($params['dateTo'])?$params['dateTo']:'';
$condition['customer_code'] = trim(isset($params['E8'])?$params['E8']:'');
$condition['is_delivery'] = isset($params['E41'])?$params['E41']:($params['E41']==0?0:'');
if (empty($condition['customer_code'])) {
$condition['customer_code'] = trim(isset($params['cu'])?$params['cu']:'');
}
// if ($condition['is_delivery']=='') {
// $condition['is_delivery'] = trim(isset($params['de'])?$params['de']:'');
// }
$condition['receiving_status_arr'] = isset($params['receiving_status_arr']) ? trim($params['receiving_status_arr']) : '';
unset($params);
// print_r($condition);exit;
$rows = $this->serviceClass->getByCondition($condition);
if (!empty($rows)) {
$selectedCode=array();
foreach ($rows as $key => $value) {
$selectedCode[]=$value['receiving_code'];
}
}
}
$filename = "export".date("YmdHis");
require_once("PHPExcel.php");
require_once("PHPExcel/Reader/Excel2007.php");
require_once("PHPExcel/Reader/Excel5.php");
require_once ('PHPExcel/IOFactory.php');
$objExcel = new PHPExcel();
$objProps = $objExcel->getProperties();
$objProps->setCreator('EC');
$objProps->setTitle('Template');
$objExcel->setActiveSheetIndex(0);
$objActSheet = $objExcel->getActiveSheet();
$objActSheet->getStyle("C".$index)->getNumberFormat()->setFormatCode('0.00');
$objActSheet->getStyle("D".$index)->getNumberFormat()->setFormatCode('0.00');
// $objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objActSheet->getColumnDimension('A')->setWidth(15);
$objActSheet->getColumnDimension('B')->setWidth(15);
$objActSheet->getColumnDimension('C')->setWidth(15);
$objActSheet->getColumnDimension('D')->setWidth(15);
$objActSheet->setCellValue('A1','收货单号');
$objActSheet->setCellValue('B1','是否提货');
$objActSheet->setCellValue('C1','毛重');
$objActSheet->setCellValue('D1','仓库确认重量');
$dataList = array();
// print_r($selectedCode);
foreach($selectedCode as $k=>$code){
$receivingRow = Service_Receiving::getByField($code,"receiving_code","*");
$dataList[$k]['receiving_code'] = $receivingRow['receiving_code'];
$dataList[$k]['roughweight'] = $receivingRow['roughweight'];
$dataList[$k]['netweight'] = $receivingRow['netweight'];
$dataList[$k]['is_delivery'] = $receivingRow['is_delivery']==0?'否':'是';
}
$index = 2;
foreach($dataList as $key=>$value){
$objActSheet->setCellValue("A".$index,$value['receiving_code']);
$objActSheet->setCellValue("B".$index,$value['is_delivery']);
$objActSheet->setCellValueExplicit("C".$index,$value['roughweight'],PHPExcel_Cell_DataType::TYPE_NUMERIC);
$objActSheet->setCellValue("D".$index,$value['netweight'],PHPExcel_Cell_DataType::TYPE_NUMERIC);
$index++;
}
header('Pragma:public');
header('Content-Type:application/x-msexecl;name="' . $filename . '.xls');
header("Content-Disposition:inline;filename=" . $filename . '.xls');
$objWriter = PHPExcel_IOFactory::createWriter($objExcel, 'Excel5');
$objWriter->save('php://output');
}
}
}