';
        print_r($receivingDetail);
        echo '

';
                print_r($result);
                echo '

';
    		 print_r($result);
    		echo '

';
		print_r($receivingInfo);
		echo '

";
            print_r($return);*/
            if($return['state']!='1'){
                die($return['message']);
            }else{
                //require_once "PHPExcel.php";
                //require_once "PHPExcel/IOFactory.php";

                /*require_once 'PHPExcel.php';
                require_once("PHPExcel/Reader/Excel5.php");
                require_once APPLICATION_PATH . '/../libs/PHPExcel/IOFactory.php';*/
                //phpinfo();

                require_once "PHPExcel1.8/PHPExcel.php";
                require_once "PHPExcel1.8/PHPExcel/Reader/Excel2007.php";
                require_once "PHPExcel1.8/PHPExcel/Reader/Excel5.php";
                require_once "PHPExcel1.8/PHPExcel/IOFactory.php";


                $path = APPLICATION_PATH . '/../data/file/baoguantemp.xls';
                $excel = PHPExcel_IOFactory::load($path);
                $baoguanSheet = $excel->getSheet(0);

                $excel->setActiveSheetIndex(0);
                $zhuangxiangSheet = $excel->getSheet(1);
                $fapiaoSheet = $excel->getSheet(2);
                $hetongSheet = $excel->getSheet(3);

                $asnRow = $return['data']['asnRow'];

                $ASNDetail = $return['data']['ASNDetail'];
                $defaultInfo = $return['data']['defaultInfo'];

                $baoguanSheet->setCellValue('B15', $asnRow['receiving_code']);//
                $baoguanSheet->setCellValue('H13', $asnRow['net_weight']);//
                $baoguanSheet->setCellValue('F13', $asnRow['pack_no']);//
                if($defaultInfo){
                   $defaultCell =[
                       "trade_co"=>"C4",//境内发货人
                        "trade_name"=>'A5',//"境内发货人名称",
                        "owner_code"=>'C8',//"生产销售单位",
                        "owner_name"=>'A9',//"生产销售单位名称",
                        "declare_port"=>'F5',//"出境关别",
                        "traf_mode"=>'F7',//"运输方式",
                        "trade_mode"=>'F9',//"监管方式",
                        "trade_area_code"=>'F11',//"贸易国别地区",
                        "trade_country"=>'H11',//"运抵国",
                        "destination_port"=>'J11',//"指运港",
                        "enty_port_code"=>'N11',//"离境口岸",
                        "trans_mode"=>'I13',//"成交方式",
                        "duty_mode"=>"H9", //征免性质,
                        "jingnei"=>"R17", //境内目的地,
//                        "destination_country":"最终目的国",
//                        "destination_country":"142-中国",
//                        "district_code":"境内货源地",
//                        "district_code":"44036-深圳前海湾保税港区",
                   ];
                   foreach ($defaultCell as $key=>$cell){
                       if($defaultInfo[$key]){
                           $baoguanSheet->setCellValueExplicit($cell,$defaultInfo[$key],PHPExcel_Cell_DataType::TYPE_STRING);
                       }
                   }
                }

                $uoms = Service_ProductUom::getByCondition();
                $uomKey = [];
                foreach ($uoms as $k=>$uom){
                    $uomKey[$uom['pu_code']] = $uom;
                }

                $index = 18;
                $i = 1;
                $total_amount = 0;
                foreach ($ASNDetail as $body) {
                    $baoguanSheet->insertNewRowBefore($index,1);  //在操作行的号前加一空行，这空行的行号就变成了当前的行号
                    $baoguanSheet->setCellValue('A' . $index, $i);//
                    //$baoguanSheet->setCellValue('B' . $index, $body['']);//备案序号
                    $baoguanSheet->setCellValue('C' . $index, $body['goods_id']);//商品料号
                    $baoguanSheet->setCellValueExplicit('D' . $index, $body['hs_code'],PHPExcel_Cell_DataType::TYPE_STRING);//商品编码(必填)
                    $baoguanSheet->setCellValue('E' . $index, $body['hs_goods_name']);//商品名称
                    $baoguanSheet->setCellValue('F' . $index, $body['product_model']);//规格型号
                    $baoguanSheet->setCellValueExplicit('G' . $index, $body['quantity'],PHPExcel_Cell_DataType::TYPE_STRING);//申报数量
                    $pu_code = $body['pu_code'];
                    $pu_name = "";
                    if(isset($uomKey[$pu_code])){
                        $pu_name = $uomKey[$pu_code]['pu_name'];
                    }
                    $pu_code_law = $body['pu_code_law'];
                    if(isset($uomKey[$pu_code_law])){
                        $pu_code_law_name = $uomKey[$pu_code_law]['pu_name'];
                    }
                    $baoguanSheet->setCellValueExplicit('H' . $index,$pu_name ,PHPExcel_Cell_DataType::TYPE_STRING);//申报单位
                    $baoguanSheet->setCellValueExplicit('I' . $index, $body['quantity_law'],PHPExcel_Cell_DataType::TYPE_STRING);//法定第一数量
                    $baoguanSheet->setCellValueExplicit('J' . $index, $pu_code_law_name,PHPExcel_Cell_DataType::TYPE_STRING);//法定第一单位
                    if($body['pu_code_second']!=''){
                        $pu_code_second = $body['pu_code_second'];
                        $pu_code_second_name = "";
                        if(isset($uomKey[$pu_code_second])){
                            $pu_code_second_name = $uomKey[$pu_code_second]['pu_name'];
                        }
                        $baoguanSheet->setCellValue('K' . $index, $body['quantity_second']);//法定第二数量
                        $baoguanSheet->setCellValue('L' . $index,$pu_code_second_name);//法定第二单位
                    }
                    $currency_code = $body['currency_code'];
                    $currency = Service_Currency::getByField($currency_code,'currency_code');
                    $currency_hs_code = "";
                    if(!empty($currency)){
                        $currency_hs_code = $currency['currency_hs_code'];
                        $currency_hs_code = $currency_hs_code."-".$currency['currency_name'];
                    }

                    $baoguanSheet->setCellValueExplicit('M' . $index, $body['product_declared_value'],PHPExcel_Cell_DataType::TYPE_STRING);//申报单价
                    $baoguanSheet->setCellValue('N' . $index, $body['declared_value']);//申报总价
                    $baoguanSheet->setCellValue('O' . $index, $currency_hs_code,PHPExcel_Cell_DataType::TYPE_STRING);//申报币值

                    $baoguanSheet->setCellValueExplicit('P' . $index, '142-中国',PHPExcel_Cell_DataType::TYPE_STRING);//原产国
                    $baoguanSheet->setCellValue('Q' . $index, '110-香港');//最终目的国

                    $baoguanSheet->setCellValue('S' . $index, '1-照章征税');//征免方式
                    if($defaultInfo){
                        if($defaultInfo['destination_country']){
                            $baoguanSheet->setCellValue('Q' . $index, $defaultInfo['destination_country']);//最终目的国
                        }
                        if($defaultInfo['district_code']){
                            $baoguanSheet->setCellValue('R' . $index, $defaultInfo['district_code']);//最终目的国
                        }
                        if($defaultInfo['duty_mode']){
                            $baoguanSheet->setCellValue('S' . $index, $defaultInfo['duty_mode']);//最终目的国
                        }
                    }
                    $total_amount+=$body['declared_value'];


                    $i++;
                    $index++;
                }
                $baoguanSheet->setCellValue('F15', $total_amount);//

                //装箱单
                $index = 13;
                $i = 1;
                foreach ($ASNDetail as $body) {
                    $zhuangxiangSheet->setCellValue('A' . $index, $i);//标记
                    $zhuangxiangSheet->setCellValue('B' . $index, $body['product_title']);//货物
                    //$zhuangxiangSheet->setCellValue('E' . $index, $body['goods_id']);//
                    $pu_code = $body['pu_code'];
                    $puRow = Service_ProductUom::getByField($pu_code,'pu_code');
                    $pu_name = "";
                    if(!empty($puRow)){
                        $pu_name = $puRow['pu_name'];
                    }
                    $zhuangxiangSheet->setCellValueExplicit('F' . $index, $body['quantity'].$pu_name,PHPExcel_Cell_DataType::TYPE_STRING);//数量(必填)
                    //$zhuangxiangSheet->setCellValue('J' . $index, '');//
                    $zhuangxiangSheet->setCellValue('L' . $index, $body['total_weight']);//
                    $i++;
                    $index++;
                }
                //发票
                $index = 11;
                $i = 1;
                foreach ($ASNDetail as $body) {
                    $fapiaoSheet->setCellValue('A' . $index, $i);//标记
                    $fapiaoSheet->setCellValue('B' . $index, $body['product_title']);//货物
                    //$zhuangxiangSheet->setCellValue('E' . $index, $body['goods_id']);//
                    $pu_code = $body['pu_code'];
                    $puRow = Service_ProductUom::getByField($pu_code,'pu_code');
                    $pu_name = "";
                    if(!empty($puRow)){
                        $pu_name = $puRow['pu_name'];
                    }
                    $fapiaoSheet->setCellValueExplicit('E' . $index, $body['quantity'].$pu_name,PHPExcel_Cell_DataType::TYPE_STRING);//数量(必填)
                    $fapiaoSheet->setCellValue('H' . $index, $body['product_unit_price']);//
                    $fapiaoSheet->setCellValue('I' . $index, $body['declared_value']);//
                    $i++;
                    $index++;
                }
                //合同
                $index = 18;
                $i = 1;
                foreach ($ASNDetail as $body) {
                    $hetongSheet->setCellValue('A' . $index, $body['product_title']);//货物
                    $pu_code = $body['pu_code'];
                    $puRow = Service_ProductUom::getByField($pu_code,'pu_code');
                    $pu_name = "";
                    if(!empty($puRow)){
                        $pu_name = $puRow['pu_name'];
                    }
                    $hetongSheet->setCellValueExplicit('F' . $index, $body['quantity'].$pu_name,PHPExcel_Cell_DataType::TYPE_STRING);//数量(必填)
                    $hetongSheet->setCellValue('G' . $index, $body['product_unit_price']);//
                    $hetongSheet->setCellValue('I' . $index, $body['declared_value']);//
                    $i++;
                    $index++;
                }
                $filename =  $asnRow['receiving_code'].'.xls';
                $filename = mb_convert_encoding($filename, 'gbk');
                $writer = PHPExcel_IOFactory::createWriter($excel, 'Excel5');
                header('Content-Type: application/vnd.ms-excel');
                header('Content-Type: application/force-download');
                header("Content-Disposition: attachment;filename=\"$filename\"");
                header("Content-Transfer-Encoding: binary");
                header('Cache-Control: max-age=0');
                $writer->save('php://output');

            }
            //var_dump($return);
        }

    }

    /**
     * @todo 下载客户已经上传的已经生成的报关单
     */
    public function downbgAction(){
        $receiving_code = $this->_request->getParam("receiving_code");
        if(!empty($receiving_code)){
            $receive = Service_Receiving::getByField($receiving_code,'receiving_code');
            if($receive['baoguan_file']!=''){
                if(file_exists($receive['baoguan_file'])){
                    $fullPath = $receive['baoguan_file'];
                    $filename = basename($fullPath);
                    $filearr = pathinfo($filename);
                    $name = $receive['receiving_code'].'-BG.'.$filearr['extension'];
                    Common_Common::downloadFile($fullPath,$name);
                }else{
                    echo "报关单数据未上传或者不存在";
                    exit;
                }
            }
        }else{
            die("参数错误!");
        }
        exit;
    }

    /**
     * @todo 报关单上传功能
     */
    public function uploadbaoguanImportAction(){
        if ($this->_request->isPost()) {
            $res = array(
                'state'=>0,
                'message'=>'',
                'error'=>[],
                'data'=>[],
            );
            try{
                $db = Common_Common::getAdapter();
                $db->beginTransaction();
                //var_dump($this->_request->getParams());
                $mergerbygoods = $this->_request->getParam('merge', '1'); //按料号合并，默认合并
                $receiving_code = $this->_request->getParam('receiving_code');
                if(empty($receiving_code)){
                    throw new Exception('入库单号为空');
                }
                $receiving = Service_Receiving::getByField($receiving_code,'receiving_code');
                if(empty($receiving)){
                    throw new Exception('入库单不存在:'.$receiving_code);
                }
                $upload = new Process_Upload();
                $savePath = APPLICATION_PATH . '/../data/baoguanTemp/';
                $savePath.= date("Y/m",time());
                $uploadInfo = $upload->uploadXls($savePath, 'baoguan_temp_file');
                if ($uploadInfo['state'] != 1) {
                    throw new Exception($uploadInfo['message']);
                }
                $filePath = $uploadInfo['path'];
                $uploadProcess = new Process_BaoguanUpload();
                $uploadProcess->setFilePath($filePath);
                $headInfo = $uploadProcess->getBaseInfo();
                $bodyInfo = $uploadProcess->getBodyInfo();

                if (empty($headInfo) || empty($bodyInfo)) {
                    throw new Exception('上传报关单信息不存在');
                }
                $error = $uploadProcess->validateInfo($headInfo,$bodyInfo,$receiving_code);
                if(!empty($error)){
                    $res['error'] = $error;
                }else{
                    //更新入库单报关单文件
                    $receiveRow = array(
                        'baoguan_file'=>$filePath,
                        'receiving_update_time'=>date("Y-m-d H:i:s",time()),
                    );
                    Service_Receiving::update($receiveRow,$receiving['receiving_id']);
                    $ASNLog = array(
                        'receiving_id' => $receiving['receiving_id'],
                        'receiving_code' => $receiving['receiving_code'],
                        'rl_type' => '0',
                        'user_id' => '-1',
                        'customer_code' => $receiving['customer_code'],
                        'rl_note' => "上传报关单",
                        'rl_status_from' => $receiving['receiving_status'],
                        'rl_status_to' => '2',    //方便测试暂时为4
                        'rl_add_time' => date('Y-m-d H:i:s', time()),
                        'rl_ip' => Common_Common::getIP(),
                        'extend_filed1'=>$filePath,
                    );
                    Service_ReceivingLog::add($ASNLog);
                    $res['state'] = 1;
                    $res['message'] = "报关单上传成功";
                }
                //$db->rollBack();
                $db->commit();
            }catch (Exception $e){
                $res['error'][] = $e->getMessage();
                $db->rollBack();
            }
            die(json_encode($res));
        }
    }
   
	
	
}