tplDirectory = "ship/views/"; $this->serviceClass = new Service_FeeCostDetail(); } public function listAction(){ $currency = Common_DataCache::getCurrency(); $type = Common_Type::SMFeeType('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" ); $sm_code = $this->_request->getParam("sm_code",""); $fc_id = $this->_request->getParam("fc_id",""); $code_number = $this->_request->getParam("code_number",""); $fee_code = $this->_request->getParam("fee_code",""); $country_code = $this->_request->getParam("country_code",""); $reference_no = $this->_request->getParam('reference_no',""); $tracking_number = $this->_request->getParam("tracking_number",""); $add_time_start = $this->_request->getParam("add_time_start",""); $add_time_end = $this->_request->getParam("add_time_end",""); $customer_code = $this->_request->getParam("customer_code",""); $sp_code = $this->_request->getParam("sp_code",""); $condition = array( 'sm_code' => $sm_code, 'customer_code' => $customer_code, 'sp_code' => $sp_code, 'fc_id' => $fc_id, 'fee_code' => $fee_code, 'code_number' => $code_number, 'country_code' => $country_code, 'reference_no' => $reference_no, 'tracking_number' => $tracking_number, 'add_time_start' => $add_time_start, 'add_time_end' => $add_time_end, ); //删选掉成本为0的 $condition['cost_amount_sp'] = 0; $count = Service_FeeCostDetail::getByCondition($condition,"count(*)"); $return['total'] = $count; if ($count){ $rows = Service_FeeCostDetail::getByCondition($condition,"*",$pageSize, $page,"fc_id desc"); foreach($rows as $key=>$value){ $country = Service_Country::getByField($value['country_code'],"country_code","*"); $rows[$key]['country_name'] = $country['country_name']; } $return['data'] = $rows; $return['state'] = 1; $return['message'] = ""; } die(Zend_Json::encode($return)); } $this->view->fee = Service_OtherFee::getAll(); $this->view->currency = $currency; $this->view->type = $type; $this->view->SM = Common_DataCache::getShippingMethodSimple(); $this->view->countryArr = Common_DataCache::getCountry(); echo Ec::renderTpl($this->tplDirectory . "fee-cost-detail.tpl", 'layout'); } public function exportAction(){ $crIdArr = $this->_request->getParam('fcid',''); $exportType = $this->_request->getParam("exportType",""); if($exportType=="1"){ header('Pragma:public'); header('Content-Type:application/x-msexecl;name=costRecording.xls'); header("Content-Disposition:inline;filename=costRecording.xls"); $html = ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; //$html .= ""; //$html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; foreach($crIdArr as $val){ if($val=="") continue; $value = Service_FeeCostDetail::getByField($val,'fc_id',"*"); $country = Service_Country::getByField($value['country_code'],"country_code","*"); $html.=""; $html.=""; $html.=""; $html.=""; $html.=""; $html.=""; $html.=""; $html.=""; $html.=""; //$html.=""; //$html.=""; $html.=""; $html.=""; $html.=""; $html.=""; $html.=""; $html.=""; } $html.= "

订单号

交易订单号

跟踪号

运输方式

国家

杂费代码

杂费名称

客户代码

费用金额

费用币种

服务商代码

成本金额

成本币种

操作人

费用发生时间

".$value['code_number']."

".$value['reference_no']."

".$value['tracking_number']."

".$value['sm_code']."

".$country['country_name']."

".$value['fee_code']."

".$value['fee_name']."

".$value['customer_code']."

".$value['fee_amount_customer']."

".$value['fee_currency_code_customer']."

".$value['sp_code']."

".$value['cost_amount_sp']."

".$value['cost_currency_code_sp']."

".$value['operator']."

".$value['fee_time']."

"; echo $html; }else{ header('Pragma:public'); header('Content-Type:application/x-msexecl;name=costRecording.xls'); header("Content-Disposition:inline;filename=costRecording.xls"); $html = ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; //$html .= ""; //$html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $sm_code = $this->_request->getParam("sm_code",""); $country_code = $this->_request->getParam("country_code",""); $code_number = $this->_request->getParam("code_number",""); $reference_no = $this->_request->getParam('reference_no',""); $tracking_number = $this->_request->getParam("tracking_number",""); $add_time_start = $this->_request->getParam("add_time_start",""); $add_time_end = $this->_request->getParam("add_time_end",""); $customer_code = $this->_request->getParam("customer_code",""); $fee_code = $this->_request->getParam("fee_code",""); $condition = array( 'sm_code' => $sm_code, 'customer_code' => $customer_code, 'sp_code' => $sp_code, 'fee_code' => $fee_code, 'country_code' => $country_code, 'code_number' => $code_number, 'reference_no' => $reference_no, 'tracking_number' => $tracking_number, 'currency_code' => $tracking_number, 'add_time_start' => $add_time_start, 'add_time_end' => $add_time_end, ); $condition['cost_amount_sp'] = 0; $rows = Service_FeeCostDetail::getByCondition($condition,"*",0, 0,"country_code desc"); if(!empty($rows)){ foreach($rows as $key=>$value){ $country = Service_Country::getByField($value['country_code'],"country_code","*"); $rows[$key]['country_name'] = $country['country_name']; $html .= ""; //$html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; //$html .= ""; //$html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; $html .= ""; } } $html.= "

订单号

交易订单号

跟踪号

运输方式

国家

杂费代码

杂费名称

客户代码

费用金额

费用币种

服务商代码

成本金额

成本币种

操作人

费用发生时间

".$value['customer_code']."

".$value['code_number']."

".$value['reference_no']."

".$value['tracking_number']."

".$value['sm_code']."

".$country['country_name']."

".$value['fee_code']."

".$value['fee_name']."

".$value['customer_code']."

".$value['fee_amount_customer']."

".$value['fee_currency_code_customer']."

".$value['sp_code']."

".$value['cost_amount_sp']."

".$value['cost_currency_code_sp']."

".$value['operator']."

".$value['fee_time']."

"; echo $html; } } }