';
$this->exportFilename = '澳洲专线预报數據檔案-' . date('YmdHis') . '.xls';
$this->serviceClass = new Service_Orders();
}
public function printAction() {
set_time_limit(0);
$exportType = (int) trim($this->getRequest()->getParam('type', 0));
if (1 === $exportType) {
$this->printSelected();
}
else {
$this->printAll();
}
}
private function printSelected() {
$selectedOrder = $this->getRequest()->getPost('orderId', array());
$total = 0;
$content = '';
if (empty($selectedOrder)) {
exit('No Data ...');
}
$content .= '';
$content .= 'CountryCode
From | '; // 出发港地区代码
$content .= 'Postcode
From | '; // 出发港邮政编码
$content .= 'City
From | '; // 发货城市
$content .= 'Address1
From | '; // 发货人地址
$content .= 'Address2
From | '; // 发货人地址2
$content .= 'Address3
From | '; // 发货人地址3
$content .= 'FirstName
From | '; // 发货人名
$content .= 'LastName
From | '; // 发货人姓
$content .= 'Company
From | '; // 出发港国家
$content .= 'EmailFrom | '; // 发货人邮件地址
$content .= 'PhoneFrom | '; // 发货人联系电话
$content .= 'Country
CodeTo | '; // 目的港国家代码
$content .= 'Postcode
To | '; // 目的港邮政编码
$content .= 'CityTo | '; //目的港城市
$content .= 'Address 1
To | '; // 收件人地址一
$content .= 'Address 2
To | '; // 收件人地址二
$content .= 'Address 3
To | '; // 收件人地址三
$content .= 'FirstName
To | '; //收货人名
$content .= 'LastName
To | '; //收货人姓
$content .= 'CompanyTo | '; //收货公司名称
$content .= 'Email | '; // 收件人电邮
$content .= 'Phone | '; // 收件人电话
$content .= 'CarrierId | ';//承运商
$content .= 'ServiceId | ';//服务商
$content .= 'Length
in cm | '; // 长
$content .= 'Width
in cm | '; // 宽
$content .= 'Height
in cm | '; // 高
$content .= 'Weight
in kg | '; //计费重
$content .= 'product | ';//产品名称
$content .= 'Quantity | ';//数量
$content .= 'Item
Price | ';//单价
$content .= 'Country of
Manufacture | ';//生产国
$content .= 'Reason_of_export | ';//出口原因
$content .= 'Additional_comments | ';//订单备注
$content .= 'Product
Description | ';//产品描述
$content .= 'Tax
status | ';//纳税人身份
$content .= 'Customer
reference | '; //订单号
$content .= '
';
foreach ($selectedOrder as $selected) {
if (!is_numeric($selected)) {
continue ;
}
$selected = (int) $selected;
if ($selected < 1) {
continue ;
}
$order = Service_Orders::getByField($selected, 'order_id');
if (empty($order) || 'AUP' !== $order['sm_code']) {
continue ;
}
++$total;
$address = Service_OrderAddressBook::getByField($order['order_code'], 'order_code');
$shipOrder = Service_ShipOrder::getByField($order['order_code'], 'order_code');
$shipOrderDetail = Service_ShipOrderDetail::getByField($order['order_code'], 'order_code');
$country = Service_Country::getByField((int) $address['oab_country_id'], 'country_id');
$products = Service_OrderProduct::getByCondition(array('order_code' => $order['order_code']));
$totalVal = 0;
$skuArray = array();
foreach ($products as $item)
{
$product = Service_Product::getByField((int) $item['product_id'], 'product_id');
$skuArray[] = $product['product_sku'];
$totalVal += $item['op_quantity'] * $item['op_purpose_declared_value'];
}
$skuArray = array_unique($skuArray);
$skuArray = join($skuArray, '/');
$content .= '';
$content .= '| | '; // 出发港地区代码
$content .= ' | '; // 出发港邮政编码
$content .= ' | '; // 发货城市
$content .= ' | '; // 发货人地址
$content .= ' | '; // 发货人地址2
$content .= ' | '; // 发货人地址3
$content .= ' | '; // 发货人名
$content .= ' | '; // 发货人姓
$content .= ' | '; // 出发港国家
$content .= ' | '; // 发货人邮件地址
$content .= ' | '; // 发货人联系电话
$osa = Service_OrderAddressBook::getByCondition(array('order_code'=>$order['order_code'],'oab_type'=>'0'),"*");
$orderSendAddress = $osa[0];
$country = Service_Country::getByField($orderSendAddress['oab_country_id'],"country_id","*");
$content .= '' . $country['country_code'] . ' | '; // 订单国家二字码
$content .= '' .$address['oab_postcode'] . ' | '; // 收件人邮编
$content .= '' . $address['oab_city'] . ' | '; // 收件人城市
$content .= '' . $address['oab_street_address1'] . ' | '; // 收件人地址一
$content .= '' . $address['oab_street_address2'] . ' | '; // 收件人地址二
$content .= '' . $address['oab_street_address3'] . ' | '; // 收件人地址三
$content .= '' . $address['oab_firstname'] . ' | '; // 收件人名
$content .= '' . $address['oab_lastname'] . ' | '; // 收件人姓
$content .= '' .$address['oab_company'] . ' | '; // 收件人公司
$content .= '' . (empty($address['oab_email']) ? ' ' : $address['oab_email']) . ' | '; // 收件人邮件
$content .= '' . $address['oab_cell_phone'] . ' | '; // 收件人电话
$content .= 'Australia Post | '; // 承运商
$content .= '1876 | '; // 服务商
$content .= '' .(empty($shipOrderDetail['sod_length']) ? ' ' : $shipOrderDetail['sod_length']) . ' | '; // 长
$content .= '' . $shipOrderDetail['sod_width'] . ' | '; // 宽
$content .= '' . $shipOrderDetail['sod_height'] . ' | '; // 高
$content .= '' . $shipOrder['so_fee_weight'] . ' | '; // 计费重
$content .= '' . $item['product_title_en'] . ' | '; // 产品名称
$content .= '' . $item['op_quantity'] . ' | '; // 产品数量
$content .= '' . $item['op_purpose_declared_value'] . ' | '; // 目的海关申报单价
$content .= 'CN | '; // 生产国 CN 固定为中国
$content .= 'Purchase | '; // 出口原因 Purchase 固定为 ：Purchase
$content .= '' . (empty($order['remark']) ? ' ' : $order['remark']) . ' | '; // 订单备注
$content .= '' . $item['product_title_en'] . ' | '; // 描述
$content .= ' | '; // 纳税人身份
$content .= '' . $order['order_code'] . ' | ';//订单号
$content .= '
';
}
if ($total < 1) {
exit('No Data ...');
}
header('pragma: public');
header('content-type: application/x-msexecl; name=' . $this->exportFilename);
header('content-disposition: inline; filename=' . $this->exportFilename);
echo '';
}
private function printAll() {
set_time_limit(0);
$params = $this->_request->getParams();
$condition = $this->serviceClass->getNewMatchFields($params);
if( is_array( $condition['oab_country_id'] ) && count( $condition['oab_country_id'] ) == 1 && $condition['oab_country_id'][0] === '' ) {
unset($condition['oab_country_id']);
}
if ('orderCode' == $params['searchType']) {
$condition['order_code'] = $params['searchCode'];
} else {
$condition['reference_no'] = $params['searchCode'];
}
$time = Common_Common::getStartAndEndTime($params['dateFor'],$params['dateTo']);
$conditionTemp['dateFor'] = $time[0];
$conditionTemp['dateTo'] = $time[1];
unset($condition['dateFor']);
unset($condition['dateTo']);
$searchDateType = isset($params['searchDateType']) ? $params['searchDateType'] : '';
switch ($searchDateType) {
case 'createDate':
$condition['dateFor'] = $conditionTemp['dateFor'];
$condition['dateTo'] = $conditionTemp['dateTo'];
break;
case 'printTime':
$condition['printDateFor'] = $conditionTemp['dateFor'];
$condition['printDateTo'] = $conditionTemp['dateTo'];
break;
case 'packTime':
$condition['packDateFor'] = $conditionTemp['dateFor'];
$condition['packDateTo'] = $conditionTemp['dateTo'];
break;
case 'shipTime':
$condition['shipDateFor'] = $conditionTemp['dateFor'];
$condition['shipDateTo'] = $conditionTemp['dateTo'];
break;
default:
break;
}
$condition['oab_type'] = '0';
$condition['sm_code'] = 'AUP';
if ($condition['tracking_number']) {
$shipOrder = Service_ShipOrder::getByField($condition['tracking_number'], 'tracking_number');
if (!empty($shipOrder)) {
$condition['order_id'] = $shipOrder['order_id'];
}
else {
$condition['order_id'] = 'none';
}
}
$selectedOrder = $this->serviceClass->getOrderInnerJoinProductByCondition($condition);
$total = 0;
$content = '';
$content .= '';
$content .= 'CountryCode
From | '; // 出发港地区代码
$content .= 'Postcode
From | '; // 出发港邮政编码
$content .= 'City
From | '; // 发货城市
$content .= 'Address1
From | '; // 发货人地址
$content .= 'Address2
From | '; // 发货人地址2
$content .= 'Address3
From | '; // 发货人地址3
$content .= 'FirstName
From | '; // 发货人名
$content .= 'LastName
From | '; // 发货人姓
$content .= 'Company
From | '; // 出发港国家
$content .= 'EmailFrom | '; // 发货人邮件地址
$content .= 'PhoneFrom | '; // 发货人联系电话
$content .= 'Country
CodeTo | '; // 目的港国家代码
$content .= 'Postcode
To | '; // 目的港邮政编码
$content .= 'CityTo | '; //目的港城市
$content .= 'Address 1
To | '; // 收件人地址一
$content .= 'Address 2
To | '; // 收件人地址二
$content .= 'Address 3
To | '; // 收件人地址三
$content .= 'FirstName
To | '; //收货人名
$content .= 'LastName
To | '; //收货人姓
$content .= 'CompanyTo | '; //收货公司名称
$content .= 'Email | '; // 收件人电邮
$content .= 'Phone | '; // 收件人电话
$content .= 'CarrierId | ';//承运商
$content .= 'ServiceId | ';//服务商
$content .= 'Length
in cm | '; // 长
$content .= 'Width
in cm | '; // 宽
$content .= 'Height
in cm | '; // 高
$content .= 'Weight
in kg | '; //计费重
$content .= 'product | ';//产品名称
$content .= 'Quantity | ';//数量
$content .= 'Item
Price | ';//单价
$content .= 'Country of
Manufacture | ';//生产国
$content .= 'Reason_of_export | ';//出口原因
$content .= 'Additional_comments | ';//订单备注
$content .= 'Product
Description | ';//产品描述
$content .= 'Tax
status | ';//纳税人身份
$content .= 'Customer
reference | '; //订单号
$content .= '
';
foreach ($selectedOrder as $order) {
if (empty($order) || 'AUP' !== $order['sm_code']) {
continue ;
}
++$total;
$address = Service_OrderAddressBook::getByField($order['order_code'], 'order_code');
$shipOrder = Service_ShipOrder::getByField($order['order_code'], 'order_code');
$shipOrderDetail = Service_ShipOrderDetail::getByField($order['order_code'], 'order_code');
$country = Service_Country::getByField((int) $address['oab_country_id'], 'country_id');
$products = Service_OrderProduct::getByCondition(array('order_code' => $order['order_code']));
$totalVal = 0;
$skuArray = array();
foreach ($products as $item) {
$product = Service_Product::getByField((int) $item['product_id'], 'product_id');
$skuArray[] = $product['product_sku'];
$totalVal += $item['op_quantity'] * $item['op_purpose_declared_value'];
}
$skuArray = array_unique($skuArray);
$skuArray = join($skuArray, '/');
$content .= '';
$content .= '| | '; // 出发港地区代码
$content .= ' | '; // 出发港邮政编码
$content .= ' | '; // 发货城市
$content .= ' | '; // 发货人地址
$content .= ' | '; // 发货人地址2
$content .= ' | '; // 发货人地址3
$content .= ' | '; // 发货人名
$content .= ' | '; // 发货人姓
$content .= ' | '; // 出发港国家
$content .= ' | '; // 发货人邮件地址
$content .= ' | '; // 发货人联系电话
$osa = Service_OrderAddressBook::getByCondition(array('order_code'=>$order['order_code'],'oab_type'=>'0'),"*");
$orderSendAddress = $osa[0];
$country = Service_Country::getByField($orderSendAddress['oab_country_id'],"country_id","*");
$content .= '' . $country['country_code'] . ' | '; // 订单国家二字码
$content .= '' .$address['oab_postcode'] . ' | '; // 收件人邮编
$content .= '' . $address['oab_city'] . ' | '; // 收件人城市
$content .= '' . $address['oab_street_address1'] . ' | '; // 收件人地址一
$content .= '' . $address['oab_street_address2'] . ' | '; // 收件人地址二
$content .= '' . $address['oab_street_address3'] . ' | '; // 收件人地址三
$content .= '' . $address['oab_firstname'] . ' | '; // 收件人名
$content .= '' . $address['oab_lastname'] . ' | '; // 收件人姓
$content .= '' .$address['oab_company'] . ' | '; // 收件人公司
$content .= '' . (empty($address['oab_email']) ? ' ' : $address['oab_email']) . ' | '; // 收件人邮件
$content .= '' . $address['oab_cell_phone'] . ' | '; // 收件人电话
$content .= 'Australia Post | '; // 承运商
$content .= '1876 | '; // 服务商
$content .= '' .(empty($shipOrderDetail['sod_length']) ? ' ' : $shipOrderDetail['sod_length']) . ' | '; // 长
$content .= '' . $shipOrderDetail['sod_width'] . ' | '; // 宽
$content .= '' . $shipOrderDetail['sod_height'] . ' | '; // 高
$content .= '' . $shipOrder['so_fee_weight'] . ' | '; // 计费重
$content .= '' . $item['product_title_en'] . ' | '; // 产品名称
$content .= '' . $item['op_quantity'] . ' | '; // 产品数量
$content .= '' . $item['op_purpose_declared_value'] . ' | '; // 目的海关申报单价
$content .= 'CN | '; // 生产国 CN 固定为中国
$content .= 'Purchase | '; // 出口原因 Purchase 固定为 ：Purchase
$content .= '' . (empty($order['remark']) ? ' ' : $order['remark']) . ' | '; // 订单备注
$content .= '' . $item['product_title_en'] . ' | '; // 描述
$content .= ' | '; // 纳税人身份
$content .= '' . $order['order_code'] . ' | ';//订单号
$content .= '
';
}
if ($total < 1) {
exit('No Data ...');
}
header('pragma: public');
header('content-type: application/x-msexecl; name=' . $this->exportFilename);
header('content-disposition: inline; filename=' . $this->exportFilename);
echo '';
}
}