tplDirectory = "order/views/default/";
$this->serviceClass = new Service_Orders();
}
public function listAction()
{
$orderType=Common_Status::orderType('auto');
$orderStatus=Common_Status::orderStatus('auto');
$isFbaStatus=Common_Status::isFbaStatus('auto');
$interceptOrderStatus=Common_Status::interceptOrderStatus('auto');
$orderUnderReviewStatus=Common_Status::orderUnderReviewStatus('auto');
$this->view->trackingStatus = Common_Status::trackingStatus('auto');
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->getNewMatchFields($params);
if( is_array( $condition['sm_code'] ) && count( $condition['sm_code'] ) == 1 && $condition['sm_code'][0] === '' ) {
unset($condition['sm_code']);
}
if( is_array( $condition['oab_country_id'] ) && count( $condition['oab_country_id'] ) == 1 && $condition['oab_country_id'][0] === '' ) {
unset($condition['oab_country_id']);
}
if($params['searchType']=='orderCode'){
$condition['order_code']=$params['searchCode'];
}else{
$condition['reference_no']=$params['searchCode'];
}
$addTime = Common_Common::getStartAndEndTime($params['dateFor'],$params['dateTo']);
$conditionTemp['dateFor'] = $addTime[0];
$conditionTemp['dateTo'] = $addTime[1];
$searchDateType=isset($params['searchDateType'])?$params['searchDateType']:'';
unset($condition['dateFor']);
unset($condition['dateTo']);
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 'ship_Time':
$condition['shipTimekDateFor']= $conditionTemp['dateFor'];
$condition['shipTimeDateTo']= $conditionTemp['dateTo'];
break;
case 'shipmentTime':
$condition['shipmentDateFor']= $conditionTemp['dateFor'];
$condition['shipmentDateTo']= $conditionTemp['dateTo'];
break;
default:
break;
}
//产品代码、品类
$condition['oab_type'] = '0';
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';
}
}
unset($params);
if(isset($condition['chosen_country_code'])&&$condition['chosen_country_code']!==""){
$chosenCountryCodeStr = preg_replace('/([\x80-\xff]*)/i','|',$condition['chosen_country_code']);
$countryCodeArr = explode("||",$chosenCountryCodeStr);
//var_dump($countryCodeArr);
foreach($countryCodeArr as $v){
$country = Service_Country::getByField(str_replace("|","",$v),'country_code',"country_id");
$condition['oab_country_id'][] = $country['country_id'];
}
}
//var_dump($condition['oab_country_id']);
$count = $this->serviceClass->getOrderInnerJoinProductByCondition($condition, 'count(*)');
$return['total'] = $count;
if ($count) {
$showFields=array(
'order_code',
'customer_code',
'warehouse_id',
'order_type',
'sm_code',
'order_status',
'problem_status',
'underreview_status',
'intercept_status',
'add_time',
'order_pick_type',
'reference_no',
'picker_id',
'remark',
'order_id',
'order_mode_type',
'is_fba',
);
$showFields = $this->serviceClass->getFieldsAlias($showFields);
$rows = $this->serviceClass->getOrderInnerJoinProductByCondition($condition,$showFields, $pageSize, $page, array('orders.order_id desc'));
$return['data'] = $rows;
$return['state'] = 1;
$return['orderType'] = $orderType;
$return['orderPackType'] = Common_Status::orderPickType('auto');
$return['warehouse'] = Common_DataCache::getWarehouseSimple();
$return['orderStatus'] = $orderStatus;
$return['isFbaStatus'] = $isFbaStatus;
$return['interceptOrderStatus'] = $interceptOrderStatus;
$return['orderUnderReviewStatus'] = $orderUnderReviewStatus;
$return['message'] = "";
$return['order_status'] = $condition['order_status'];
$return['currentPage'] = intval($page);
}
die(Zend_Json::encode($return));
}
$this->view->plateForm = Service_OrderProcess::getPlateForm();
$this->view->SM=Common_DataCache::getShippingMethodSimple();
$this->view->SP=Common_DataCache::getProductCategory();
$this->view->country = Service_Country::getAll();
//$this->view->orderType=$orderType;
// $this->view->orderStatus=$orderStatus;
echo Ec::renderTpl($this->tplDirectory . "orders_index.tpl", 'layout-chosen');
}
public function getByJsonAction()
{
$result = array('state' => 0, 'message' => 'Fail', 'data' => array());
$paramId = $this->_request->getParam('paramId', '');
if (!empty($paramId) && $rows = $this->serviceClass->getByField($paramId, 'order_id')) {
$rows=$this->serviceClass->getVirtualFields($rows);
$result = array('state' => 1, 'message' => '', 'data' => $rows);
}
die(Zend_Json::encode($result));
}
/*订单详情*/
public function viewAction()
{
$ordersCode = $this->_request->getParam("order_code", "");
if(empty($ordersCode)){
die('orderCode can not be empty.');
}
$order = $this->serviceClass->getByField($ordersCode, "order_code", "*");
if(empty($order)){
die('Order does not exist.');
}
$customer_array = Service_Customer::getByField($order['customer_id'], 'customer_id');
if(empty($customer_array)){
die('没有对应的客户信息.');
}
$order['customer_currency'] = $customer_array['customer_currency'];
$orderLogService = new Service_OrderLog();
$orderLog = $orderLogService->getByCondition(array('order_code' => $ordersCode), "*",'','',array('ol_add_time DESC', 'ol_id DESC'));
$shipOrder = Service_ShipOrder::getByField($ordersCode,'order_code',"*");
if(isset($shipOrder['tracking_number'])){
$order['tracking_number'] = $shipOrder['tracking_number'];
}else{
$order['tracking_number'] = $order['ref_tracking_number'];
}
$userRow['-1']['user_code'] = 'Customer';
$userRow['0']['user_code'] = 'system';
foreach ($orderLog as $key => $value) {
// if ($value['user_id'] != "-1") {
if (!isset($userRow[$value['user_id']])) {
$userRow[$value['user_id']] = Service_User::getByField($value['user_id'], "user_id", array('user_code', 'user_id'));
}
$orderLog[$key]['user_code'] = $userRow[$value['user_id']]['user_code'];
if($value['user_id']<0){
if($value['account_id']!="0"){
$account = Service_Account::getByField($value['account_id'],"account_id","*");
$orderLog[$key]['customer_name'] = $account['account_name'];
}else{
$orderLog[$key]['customer_name'] = $order['customer_code'];
}
}
// }
}
$this->view->orderCode = $ordersCode;
$this->view->orderLog = $orderLog;
$this->view->orderStatus = Common_Status::orderStatus('auto');
$this->view->trackingStatus = Common_Status::trackingStatus('auto');
$orderOpNode = new Service_OrderOperationNode();
$OpNode = $orderOpNode->getByCondition(array('order_code' => $ordersCode), "*");
foreach ($OpNode as $key => $value) {
// if ($value['user_id'] !== "-1") {
if (!isset($userRow[$value['user_id']])) {
$userRow[$value['user_id']] = Service_User::getByField($value['user_id'], "user_id", array('user_code', 'user_id'));
}
$OpNode[$key]['user_code'] = $userRow[$value['user_id']]['user_code'];
// }
$op = Service_OrderOperationType::getByField($value['oot_code'], 'oot_code', '*');
$OpNode[$key]['oot_name'] = $op['oot_name'];
$OpNode[$key]['oot_name_en'] = $op['oot_name_en'];
}
$this->view->OpNode = $OpNode;
//$orderProduct = new Service_OrderProduct();
$parcel_declared_value = 0;
$orderProduct = Service_OrderProduct::getOrderProducts($ordersCode);
foreach($orderProduct as $ok=>$ov){
$p = Service_Product::getByField($ov['product_id'],"product_id","*");
$orderProduct[$ok]['cn_desc'] = $ov['product_title'];
$orderProduct[$ok]['en_desc'] = $ov['product_title_en'];
$orderProduct[$ok]['with_battery'] = $p['with_battery'];
$parcel_declared_value+= $ov['op_declared_value']*$ov['op_quantity'];
}
$order['parcel_declared_value'] = $parcel_declared_value;
$this->view->product = $orderProduct;
$warehouse = Service_Warehouse::getByField($order['warehouse_id'], "warehouse_id", array('warehouse_code'));
//$warehouse['warehouse_code'] = $order['warehouse_code'];
$order['warehouse_code'] = $warehouse['warehouse_code'];
if (!isset($userRow[$order['picker_id']])) {
$userRow[$order['picker_id']] = Service_User::getByField($order['picker_id'], "user_id", array('user_code', 'user_id'));
}
$orderAddress = Service_OrderAddressBook::getByField($order['order_code'], 'order_code');
$orderAddress['country'] = Service_Country::getByField($orderAddress['oab_country_id'], 'country_id');
$order['picker'] = $userRow[$order['picker_id']]['user_code'];
if($order['insurance'] == 1 ) {
$feeItem = Service_OtherFee::getByField($order['insurance_code'],'fee_code');
$order['insurance_name'] = $feeItem['fee_name'];
} else {
$order['insurance_name'] = '';
$order['insurance_rate'] = '';
}
$this->view->order = $order;
$this->view->orderAddress = $orderAddress;
//$this->view->countryArr=Common_DataCache::getCountry();
$shipOrderTracking = Service_ShipOrderTracking::getByCondition(array('order_code'=>$ordersCode),"*",0,0,'sot_add_time desc');
foreach($shipOrderTracking as $key=>$value){
$warehouse = Service_Warehouse::getByField($value['warehouse_id'],"warehouse_id","*");
$shipOrderTracking[$key]['warehouse_code'] = $warehouse['warehouse_code'];
}
$this->view->shipOrderTracking = $shipOrderTracking;
/*$orderTrackingInfo = Service_OrderTrackingInfo::getByCondition(array('order_id'=>$order['order_id']),'*',0,0,'create_time desc');
$users = Service_User::getAll();
foreach ($users as $key => $value) {
$user[$value['user_id']] = $value['user_name'];
}
unset($users);
foreach ($orderTrackingInfo as $key => $value) {
$orderTrackingInfo[$key]['user_name'] = $user[$value['user_id']] ? $user[$value['user_id']] : $value['user_id'];
}
$this->view->orderTrackingInfo = $orderTrackingInfo;*/
echo Ec::renderTpl($this->tplDirectory . "orders-detail.tpl", 'layout');
}
public function stopListAction() {
$orderType=Common_Status::orderType('auto');
$orderStatus=Common_Status::orderStatus('auto');
$interceptOrderStatus=Common_Status::interceptOrderStatus('auto');
$orderUnderReviewStatus=Common_Status::orderUnderReviewStatus('auto');
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);
if($params['searchType']=='orderCode'){
$condition['order_code']=$params['searchCode'];
}else{
$condition['reference_no']=$params['searchCode'];
}
$conditionTemp['dateFor'] = isset($params['dateFor'])?$params['dateFor']:'';
$conditionTemp['dateTo'] = isset($params['dateTo'])?$params['dateTo']:'';
$searchDateType=isset($params['searchDateType'])?$params['searchDateType']:'';
$isSearchDate=false;
if(!empty($conditionTemp['dateFor'])){
$isSearchDate=true;
$conditionTemp['dateFor']=date('Y-m-d H:i:s',strtotime($conditionTemp['dateFor']));
}
if(!empty($conditionTemp['dateTo'])){
$isSearchDate=true;
$conditionTemp['dateTo']=date('Y-m-d H:i:s',strtotime($conditionTemp['dateTo']));
}
if($isSearchDate){
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['product_barcode']=isset($params['product_barcode'])?$params['product_barcode']:'';
$condition['product_category']=isset($params['product_category'])?$params['product_category']:'';
$condition['tracking_status']=isset($params['tracking_status'])?$params['tracking_status']:'';
unset($params);
unset($condition['underreview_status']);
$count = $this->serviceClass->getOrderInnerJoinProductByCondition($condition, 'count(*)');
$return['total'] = $count;
if ($count) {
$showFields=array(
'order_code',
'customer_code',
'warehouse_id',
'order_type',
'sm_code',
'order_status',
'problem_status',
'underreview_status',
'intercept_status',
'add_time',
'order_pick_type',
'reference_no',
'picker_id',
'remark',
'order_id',
);
$showFields = $this->serviceClass->getFieldsAlias($showFields);
$rows = $this->serviceClass->getOrderInnerJoinProductByCondition($condition,$showFields, $pageSize, $page, array('orders.order_id desc'));
$return['data'] = $rows;
$return['state'] = 1;
$return['orderType'] = $orderType;
$return['orderPackType'] = Common_Status::orderPickType('auto');
$return['warehouse'] = Common_DataCache::getWarehouseSimple();
$return['orderStatus'] = $orderStatus;
$return['interceptOrderStatus'] = $interceptOrderStatus;
$return['orderUnderReviewStatus'] = $orderUnderReviewStatus;
$return['message'] = "";
}
die(Zend_Json::encode($return));
}
$this->view->SM=Common_DataCache::getShippingMethodSimple();
$this->view->SP=Common_DataCache::getProductCategory();
echo Ec::renderTpl($this->tplDirectory . "stop_list.tpl", 'layout');
}
public function stopAction()
{
if ($this->_request->isPost()) {
$response = array('state' => 0, 'message' => '');
$code = trim($this->_request->getParam('code'));
$reason = trim($this->_request->getParam('reason'));
if (empty($code)) {
$response['message'] = '请输入物流号或者订单号';
exit(Zend_Json::encode($response));
}
if (empty($reason)) {
$response['message'] = '请填写拦截原因';
exit(Zend_Json::encode($response));
}
$orderRow = Service_Orders::getByField($code, 'order_code');
if (empty($orderRow)) {
$aShipOrder = Service_ShipOrder::getByField($code, 'tracking_number');
if (empty($aShipOrder)) {
$response['message'] = '找不到订单，请校对所输入单号是否正确';
exit(Zend_Json::encode($response));
}
$code = $aShipOrder['order_code'];
}
$dispatchProcess = new Service_OrderDispatchProcess();
$result = $dispatchProcess->stopOrderTransaction($code, $reason);
exit(Zend_Json::encode($result));
} else {
echo Ec::renderTpl($this->tplDirectory . "stop_order.tpl", 'layout');
}
}
/**
* @desc 截单完成,回退库存
*/
public function confirmStopAction() {
if ($this->_request->isPost()) {
$response = array('state'=>0, 'message'=>'');
$code = trim($this->_request->getParam('code'));
if(empty($code)) {
$response['message'] = '请输入物流号或者订单号';
exit(Zend_Json::encode($response));
}
$dispatchProcess = new Service_OrderDispatchProcess();
$result = $dispatchProcess->confirmStopOrder($code);
exit(Zend_Json::encode($result));
} else {
echo Ec::renderTpl($this->tplDirectory . "confirm_stop_order.tpl", 'layout');
}
}
/**
* @desc 截单重新上架
*/
public function reShelfAction()
{
$codes = $this->_request->getParam('orderCodes');
if (empty($codes)) {
exit('找不到订单，请选择订单');
}
$obj=new Service_OrderDispatchProcess();
$result=$obj->stopOrderProcess($codes);
if($result['state']=='1'){
$this->view->data = $result['data'];
}
if(count($result['message'])>0){
$this->view->error = $result['message'];
}
$this->view->date = date('Y-m-d');
echo Ec::renderTpl($this->tplDirectory . "print_stop_detail.tpl", 'layout');
}
/**
* @desc 标记取消截单
*/
public function cancelStopAction()
{
$result = array('state' => 0, 'error' => array(),'message'=>'');
$data = array();
if ($this->_request->isPost()) {
$response = array('state' => 0, 'message' => '');
$code = trim($this->_request->getParam('code'));
$reason = trim($this->_request->getParam('reason'));
if (empty($code)) {
$response['message'] = '请输入物流号或者订单号';
exit(Zend_Json::encode($response));
}
if (empty($reason)) {
$response['message'] = '请填写拦截原因';
exit(Zend_Json::encode($response));
}
$orderRow = Service_Orders::getByField($code, 'order_code');
if (empty($orderRow)) {
$aShipOrder = Service_ShipOrder::getByField($code, 'tracking_number');
if (empty($aShipOrder)) {
$response['message'] = '找不到订单，请校对所输入单号是否正确';
exit(Zend_Json::encode($response));
}
$code = $aShipOrder['order_code'];
}
if ($orderRow['warehouse_id']!=$this->warehouse_id) {
$response['message'] = '在对应仓库，找不到订单，请校对所输入单号是否正确';
exit(Zend_Json::encode($response));
}
$dispatchProcess = new Service_OrderDispatchProcess();
$result = $dispatchProcess->stopOrderTransaction($code, $reason);
exit(Zend_Json::encode($result));
}
exit(Zend_Json::encode($result));
}
/**
* @desc 编辑收件人信息
*/
public function editAddressAction()
{
$return = array(
'state' => 0,
'message' => '',
'errorMessage' => array('操作失败')
);
if ($this->_request->isPost()) {
$params = $this->_request->getParams();
//echo '',print_r($params),'
';exit();
$deliveryAddr = trim($params['delivery_address']);
unset($params['delivery_address']);
//将E14值赋给E15(电话)
$params['E15'] = $params['E14'];
$return=Service_OrderAddressBook::edit($params);
Service_Orders::update(array(
'delivery_address' => $deliveryAddr,
), $params['E1'], 'order_id');
}
die(Zend_Json::encode($return));
}
public function comitToEpacketAction(){
//以下是成功的案列
$orderCode = $this->_request->getParam("order_code","SOE01361308090002");
$order = Service_Orders::getByField($orderCode,"order_code","*");
$receivingAddress = Service_OrderAddressBook::getByField($order['order_id'],'order_id',"*");
$country = Service_Country::getByField($receivingAddress["oab_country_id"],"country_id","*");
$shipToAddress = array(
'email' => $receivingAddress['oab_email'],
'company' => $receivingAddress['oab_company'],
'contact' => "Andy Liu",
'phone' => $receivingAddress['oab_cell_phone'],
'street' => $receivingAddress['oab_street_address1'],
'city' => $receivingAddress['oab_city'],
'province' => $receivingAddress['oab_state'],
'postcode' => $receivingAddress['oab_postcode'],
'country' => $country['country_name_en'],
'country_code' => $country['country_code'],
);
$shipFromAddress = array(
'contact' => 'Danny Zhou',
'company' => 'cargo company',
'street' => 'JinTian Road No.8086 AnLian A 25 Floor',
'district' => 'Futian district',
'city' => 'shenzhen city',
'province' => 'GUANGDONG',
'postcode' => '518026',
'country' => 'CHINA',
'email' => 'Dannyzhou@cargofe.com.cn',
'mobile' => '13594268155',
);
$returnAddress = array(
'company' => 'Cargo', //公司
'country' => "中国", //国家 中国
'province' => '广东', //省
'city' => 'shenzhen city', //城市
'district' => 'Futian district', //区
'street' => 'JinTian Road No.8086 AnLian A 25 Floor', //街道
'postcode' => '518026', //邮编
'contact' => 'Danny Murphy', //联系人
);
$pickUpAddress = array(
'email' => 'Dannyzhou@cargofe.com.cn',
'company' => 'cargo company',
'country' => '中国',
'province' => '440000',
'city' => '440300',
'district' => '440304',
'street' => 'JinTian Road',
'postcode' => '518026',
'contact' => 'Danny Zhou',
'mobile' => '0755-5180256',
'phone' => '13594268155',
);
$epacketService = Service_EpacketApi::getInstance();
$pickUpType = 0;
$epacketService->setPickUpType($pickUpType);
//$appUserId = "fzffzw84";
//$appPassword = "84089ZG8D1NW2Z4BY85ESXGCOFMUZB1KFLC9LIYXPW6OH2PEL7MTK2013154828";沙箱
$appUserId = "abing.967";
$appPassword = "467813WCPT3NSGPMROI29DCWSWO3LFGM26IMW5ZPME32WPXMDMNQ6O201310946";//正式
$epacketService->setHeader($order['order_code'],$appUserId,$appPassword,$appUserId);
$epacketService->verifyUser();
//print_r($epacketService);
$epacketService->setShipFromAddress($shipFromAddress);
$epacketService->setShipToAddress($shipToAddress);
$epacketService->setReturnAddress($returnAddress);
if($pickUpType==0){
$epacketService->setPickUpAddress($pickUpAddress);
}
$orderProduct = Service_OrderProduct::getByCondition(array("order_code"=>$order['order_code']),"*");
foreach($orderProduct as $k=>$v){
$product = Service_Product::getByField($v['product_id'],"product_id","*");
$epacketItem = array(
'skuid' => $product['product_sku'],
'weight' => 0.1,
'customs_title_cn' => $product['product_title'],
'customs_title_en' => $product['product_title_en'],
'declared_value' => $product['product_declared_value'],
'currency_code' => '',
'ebay_email' => '',
'ebay_buyer_id' => 'joshuaw7',
'ebay_item_id' => '181177693791',
'ebay_item_title' => '',
'ebay_message' => '',
'ebay_site_id' => '',
'ebay_transaction_id' => '1051636790008',
'note' => '',
'order_sales_record_number' => '',
'payment_date' =>'2013-08-07',
'paypal_email' => '',
'paypal_message' => '',
'posted_qty' => $v['op_quantity'],
'received_amount' =>$v['op_quantity']*$product['product_declared_value'],
'sales_record_number' => '',
'sold_date' => '2013-08-05',
'sold_price' => $product['product_sales_value'],
'sold_qty' => $v['op_quantity'],
);
$epacketService->addItem($epacketItem);
}
$result = $epacketService->AddPackage();
if (strtolower($result->AddAPACShippingPackageResult->Ack) == 'success') {
$confirmEpacket = $epacketService->confirmPackage(array('track_number' => $result->AddAPACShippingPackageResult->TrackCode));
if (strtolower($confirmEpacket->ConfirmAPACShippingPackageResult->Ack) == 'success') {
$TrackDetail = array(
'PageSize'=>'0',
'TrackCode'=>$result->AddAPACShippingPackageResult->TrackCode,
);
$label = $epacketService->getShippingLabel($TrackDetail);
$file = APPLICATION_PATH.'/../data/pdf/'.$order['order_code'].".pdf";
echo "file=".$file."";
if(!file_exists($file)){
$fp=fopen($file, "w+");
}
file_put_contents($file,$label);
$ret = array(
'ask'=>'1',
'message'=>'成功获取pdf标签'
);
die(json_encode($ret));
}else{
$ret = array(
'ask'=>'0',
'message'=>'获取pdf标签失败'
);
die(json_encode($ret));
}
} else {
$getTrackCodeArray = array(
'ebay_item_id' => '181177693791',
'ebay_transaction_id' => '1051636790008',
);
$trackNumberResult = $epacketService->getTrackCode($getTrackCodeArray);
if (strtolower($trackNumberResult->GetAPACShippingTrackCodeResult->Ack) == 'success') {
$TrackDetail = array(
'PageSize'=>1,
'track_number'=>$trackNumberResult->GetAPACShippingTrackCodeResult->TrackCode,
);
$label = $epacketService->getShippingLabel($TrackDetail);
$file = APPLICATION_PATH.'/../data/pdf/'.$order['order_code'].".pdf";
if(!file_exists($file)){
$fp=fopen($file, "w+");
}
file_put_contents($file,$label);
$ret = array(
'ask'=>'1',
'message'=>'成功获取pdf标签'
);
die(json_encode($ret));
}else{
$ret = array(
'ask'=>'0',
'message'=>'获取pdf标签失败'
);
die(json_encode($ret));
}
}
}
public function exportAction(){
error_reporting(E_ERROR);
set_time_limit(0);
@ini_set('memory_limit','2048M');
$path= realpath(APPLICATION_PATH . '/../data/cache/');
$tempFileBody =$path .'/'. md5('orderListBody') . time() . rand(0, 99999) . '.xls';
$tempFileHeader =$path . '/' . md5('orderListHeader') . time() . rand(0, 99999) . '.xls';
$tempCombineFile=$path .'/'. md5('orderList') . time() . rand(0, 99999) . '.xls';
$downLoadFilename = "orderListHorizontalall".date('YmdHis').'.xls';
$fileBody=new Common_ExportExcelByTable($tempFileBody);
$params = $this->_request->getParams();
$condition = array();
if($params['exportType'] == '1'){
$condition['order_id_array'] = $this->_request->getParam('orderId','');
}else{
$condition = $this->serviceClass->getNewMatchFields($params);
if( is_array( $condition['sm_code'] ) && count( $condition['sm_code'] ) == 1 && $condition['sm_code'][0] === '' ) {
unset($condition['sm_code']);
}
if( is_array( $condition['oab_country_id'] ) && count( $condition['oab_country_id'] ) == 1 && $condition['oab_country_id'][0] === '' ) {
unset($condition['oab_country_id']);
}
if($params['searchType']=='orderCode'){
$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 'ship_Time':
$condition['shipTimekDateFor']= $conditionTemp['dateFor'];
$condition['shipTimeDateTo']= $conditionTemp['dateTo'];
break;
case 'shipmentTime':
$condition['shipmentDateFor']= $conditionTemp['dateFor'];
$condition['shipmentDateTo']= $conditionTemp['dateTo'];
break;
default:
break;
}
$condition['oab_type'] = '0';
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';
}
}
unset($params);
}
//头部end
$index = 1;
$count = $this->serviceClass->getOrderInnerJoinProductByCondition($condition, 'count(*)');
$maxCountProduct = 1;
$countryList=array();
$feeItem = array();
$limitation = Service_ShippingMethod::getDeliveryLimitation();//时效
if($count>0){
$statusArr = Common_Status::orderStatus();
$pageSize = 5000;
$totalPage = ceil($count/$pageSize);
for($page=1;$page<=$totalPage;$page++){
$productList=array();
$csvData = array();
$rows = $this->serviceClass->getOrderInnerJoinProductByCondition($condition,'order_code', $pageSize, $page, array('orders.order_id desc'));
foreach ($rows as $key => $val) {
$orderRow = Service_Orders::getByField($val['order_code'],"order_code","*");
//订单模式
if($orderRow['order_mode_type']=="1"){
$csvData[$index][0] = '集货模式';
}else{
$csvData[$index][0] = '备货模式';
}
//客户代码
$customerRow = Service_Customer::getByField($orderRow['customer_code'],"customer_code","customer_company_name");
//服务商单号
$shipOrder = Service_ShipOrder::getByField($orderRow['order_code'],"order_code",array("tracking_number",'so_vol_weight','so_length','so_width','so_height','so_weight','so_fee_weight','so_piece'));
$trackingNumber = isset($shipOrder['tracking_number'])?$shipOrder['tracking_number']:"";
//仓库
$warehouse = Common_DataCache::getWarehouse(0,$orderRow['warehouse_id']);
//收件人国家
$osa = Service_OrderAddressBook::getByCondition(array('order_code'=>$orderRow['order_code'],'oab_type'=>'0'),"*",1,1);
$orderSendAddress = $osa[0];
if(!$countryList[$orderSendAddress['oab_country_id']] && $orderSendAddress['oab_country_id']!=''){
$countryList[$orderSendAddress['oab_country_id']] = Service_Country::getByField($orderSendAddress['oab_country_id'],"country_id","*");
}
$country= $countryList[$orderSendAddress['oab_country_id']];
// 提交时间
$opt = Service_OrderOperationTime::getByField($orderRow['order_code'],'order_code',array('submit_time','ship_time','creater_id','shipment_time'));
$csvData[$index][1] = $statusArr[$orderRow['order_status']];
$csvData[$index][2] = $orderRow['order_code'];
$csvData[$index][3] = $customerRow['customer_company_name'];
if($orderRow['change_order']=="1"){
$csvData[$index][4] = '是';
}else{
$csvData[$index][4] = '否';
}
$csvData[$index][5] = $trackingNumber;
$csvData[$index][6] = $warehouse['warehouse_code'];
if($orderRow['order_type']=="2"){
$csvData[$index][7] = '退货';
}elseif($orderRow['order_type']=="1"){
$csvData[$index][7] = '转仓';
}else{
$csvData[$index][7] = '普通';
}
$csvData[$index][8] = $country['country_name'];
$csvData[$index][9] = $country['country_name_en'];
$csvData[$index][10] = $country['country_code'];
$csvData[$index][11] = $opt['submit_time'];
$csvData[$index][14] = $orderRow['sm_code'];
$csvData[$index][15] = $orderRow['reference_no'];
$csvData[$index][16] = $orderSendAddress['oab_firstname'];
$csvData[$index][17] = $orderSendAddress['oab_company'];
$csvData[$index][18] = $orderSendAddress['oab_state'];
$csvData[$index][19] = $orderSendAddress['oab_city'];
$csvData[$index][20] = $orderSendAddress['oab_postcode'];
$csvData[$index][21] = $orderSendAddress['oab_street_address1'];
$csvData[$index][22] = $orderSendAddress['oab_street_address2'];
$csvData[$index][23] = $orderSendAddress['oab_phone'];
$csvData[$index][24] = $orderSendAddress['oab_email'];
$csvData[$index][25] = $orderRow['currency_code'];
//aa
$csvData[$index][26] = $orderRow['charge'];
$csvData[$index][27] = $orderRow['delivery_address'];
$csvData[$index][28] = $opt['shipment_time'];
//体积重
$volWeight = 0;
$shipOrderDetail = Service_ShipOrderDetail::getByCondition(array('order_code'=>$orderRow['order_code']),array('sod_vol_weight','sod_weight','sod_bill_weight','sod_length','sod_width','sod_height'));
$smRow = Service_ShippingMethod::getByField($orderRow['sm_code'],"sm_code",array('sm_is_volume','sm_vol_rate','sm_code'));
$LWH = "";
//总件数
$Total = $shipOrder['so_piece'];
// HKDHL的长宽高取ship_order_detail表的长宽高，体积重根据长宽高另外计算
// 非HKDHL得长宽高、体积重取ship_order表的长宽高、体积重
if ('1' == $smRow['sm_is_volume'] && !empty($shipOrderDetail)) {
foreach($shipOrderDetail as $sodK=>$sodV){
//$Total ++;
if($smRow['sm_vol_rate']!="0"&&$smRow['sm_vol_rate']!="")
$volWeight = $volWeight +$sodV['sod_length']*$sodV['sod_width']*$sodV['sod_height']/$smRow['sm_vol_rate'];
if($sodK=="0"){
$LWH.=$sodV["sod_length"]."*".$sodV["sod_width"]."*".$sodV["sod_height"];
}else{
$LWH.="/".$sodV["sod_length"]."*".$sodV["sod_width"]."*".$sodV["sod_height"];
}
}
} elseif (!empty($shipOrder)) {
$volWeight = $shipOrder['so_vol_weight'];
$LWH = $shipOrder['so_length'] . '*' . $shipOrder['so_width'] . '*' . $shipOrder['so_height'];
}
$shipWeight = isset($shipOrder['so_weight'])?$shipOrder['so_weight']:"";
$feeWeight = isset($shipOrder['so_fee_weight'])?$shipOrder['so_fee_weight']:"";
//ad
if ($orderRow['sm_code']=='HKUPS-KW') {
$volWeight='';
$shipWeight='';
$feeWeight='';
foreach ($shipOrderDetail as $key => $value) {
$volWeight.=$value['sod_vol_weight'].'/';
$shipWeight.=$value['sod_weight'].'/';
$feeWeight.=$value['sod_bill_weight'].'/';
}
$volWeight=rtrim($volWeight,'/');
$shipWeight=rtrim($shipWeight,'/');
$feeWeight=rtrim($feeWeight,'/');
}
$csvData[$index][29] = $volWeight;
$csvData[$index][30] = $LWH;
$csvData[$index][31] = $shipWeight;
$csvData[$index][32] = $feeWeight;
/* if($smRow['sm_is_volume']!="1") {
$Total = 1;
}else{
$sodList = Service_ShipOrderDetail::getByCondition(array('order_code'=>$orderRow['order_code']),array('sub_tracking_number'));
if($smRow['sm_code']=="HKDHL"){
$Total = count($sodList);
}else{
foreach($sodList as $sodRow){
if($sodRow['sub_tracking_number']!="") $Total++;
}
}
}*/
//件数
// $sodList=Service_ShipOrder::getByField($orderRow['order_code'],'order_code');
// $Total=$sodList['so_piece'];
//if($Total<1) $Total = 1;
$csvData[$index][33] = $Total;
$csvData[$index][35] = $orderRow['remark'];
$creater = "";
if(isset($opt['creater_id'])&&$opt['creater_id']!="0"){
$account = Service_Account::getByField($opt['creater_id'],'account_id',"account_name");
if(empty($account)){
$creater = $orderRow['customer_code'];
}else{
$creater = $account['account_name'];
}
}else{
$creater = $orderRow['customer_code'];
}
$csvData[$index][36] = $creater;
if($orderRow['is_fba']=="1"){
$csvData[$index][37] = '是';
}else{
$csvData[$index][37] = '否';
}
//保险
$csvData[$index][38] = $orderRow['insurance'] == 1 ? '是':'否';
if( !isset($feeItem[$orderRow['insurance_code']]) && !empty($orderRow['insurance_code'])) {
$feeItemRow = Service_OtherFee::getByField( $orderRow['insurance_code'],'fee_code' );
$feeItem[$orderRow['insurance_code']] = $feeItemRow;
}
$opTime = Service_OrderOperationTime::getByField( $orderRow['order_code'], 'order_code');
$deliveryDate = $opTime['shipment_time'] && $opTime['shipment_time'] != '0000-00-00 00:00:00' ? $opTime['shipment_time'] : '';
$limit = 0;
if( !isset($limitation[ $orderRow['sm_code'] ][ $country['country_area'] ])) {
$deliveryDate = '';
} else {
$limit = $limitation[ $orderRow['sm_code'] ][ $country['country_area'] ];
}
$csvData[$index][39] = $orderRow['insurance'] == 1 ? $feeItem[$orderRow['insurance_code']]['fee_name']:'';
$csvData[$index][40] = $orderRow['insurance'] == 1 && $deliveryDate != '' ? date('Y-m-d',strtotime('+'.($limit+1).' day '.$deliveryDate )) : '';
$csvData[$index][41] = $orderRow['is_remote_city'] ?'是':'否';
$csvData[$index][42] = $orderRow['is_fba_tax'] ?'预付':'到付';
$orderProduct = Service_OrderProduct::getByCondition(array('order_code'=>$orderRow['order_code']),"*");
$totalProduct = 0;
$op_declared_value = 0;
$op_purpose_declared_value = 0;
$columnCount = 43;
$maxCountProductTemp = count($orderProduct);
if($maxCountProductTemp > $maxCountProduct){
$maxCountProduct = $maxCountProductTemp;
}
foreach($orderProduct as $k=>$v){
$totalProduct +=$v['op_quantity'];
$op_declared_value +=$v['op_quantity']*$v['op_declared_value'];
$op_purpose_declared_value +=$v['op_quantity']*$v['op_purpose_declared_value'];
if(!$productList[$v['product_id']]){
@$productList[$v['product_id']]=Service_Product::getByField($v['product_id'],"product_id",array('product_title','product_sku','hs_goods_name','goods_id','hs_code','with_battery','is_scan_imei'));
}
$p = $productList[$v['product_id']];
$pickingDetail = Service_PickingDetail::getByCondition(array('order_code'=>$v['order_code'],'product_id'=>$v['product_id']),"ib_id",1,1);
$ib_fifo_time = "";
if(!empty($pickingDetail)){
$inventoryBatchLog = Service_InventoryBatchLog::getByCondition(array('ib_id'=>$pickingDetail[0]['ib_id'],'application_code'=>'Putaway','ibl_quantity_before'=>'0'),"*",1,1,'ibl_id asc');
if(!empty($inventoryBatchLog))
$ib_fifo_time = $inventoryBatchLog[0]['ibl_add_time'];
}
$csvData[$index][$columnCount++] = $p['product_title'];
$csvData[$index][$columnCount++] = $p['product_sku'];
$csvData[$index][$columnCount++] = $ib_fifo_time;
$csvData[$index][$columnCount++] = $v['product_title_en'];
if($p['is_scan_imei']=="1"){
$csvData[$index][$columnCount++] = "是";
}else{
$csvData[$index][$columnCount++] = "否";
}
$csvData[$index][$columnCount++] = $v['op_declared_value'];
$csvData[$index][$columnCount++] = $v['op_purpose_declared_value'];
$csvData[$index][$columnCount++] = $v['op_quantity'];
$csvData[$index][$columnCount++] = $p['hs_goods_name'];
$csvData[$index][$columnCount++] = $p['goods_id'];
$csvData[$index][$columnCount++] = $p['hs_code'];
$csvData[$index][$columnCount++] = $p['with_battery']==1?'是':'否';
}
$csvData[$index][12] = $op_declared_value;
$csvData[$index][13] = $op_purpose_declared_value;
$csvData[$index][34] = $totalProduct;
ksort($csvData[$index]);
$index++;
}
foreach($csvData as $cRow){
$insertRow="";
foreach($cRow as $col=>$k){
$style=$this->checkIsNumber($col);
$insertRow.=''.$k.'';
}
$insertRow.='
';
$fileBody->writeString($insertRow);
}
/*
$exportIndex = $exportObj->setRowsValue($csvData , $exportIndex , function($index)
{
$keys = array(2,15,5,20,23);
if(in_array($index , $keys)){
return Common_ExportForExcel::TYPE_STRING2;
}
if(($index - 36) > 0){
$key = ($index - 36) % 10;
$keys = array(2,9,0);
if(in_array($key , $keys)){
return Common_ExportForExcel::TYPE_STRING2;
}
}
$keys = array(12,13,26,29,31,32,33,34);
if(in_array($index , $keys)){
return Common_ExportForExcel::TYPE_NUMERIC;
}
return false;
});
* */
$csvData = array();
}
}
$fileBody->writeString('