k_online_backend/service/ocean_order.class.php

<?php

if (!defined('IN_ONLINE')) {
    exit('Access Denied');
}

/**
 * Description of ocean
 *
 * @author Administrator
 */
class ocean_order {

    private static $_ocean;

    function __construct() {  
       
    }

    public static function getInstance() {
        global $memory_limit;
        $memory_limit = ini_get("memory_limit");
        ini_set("memory_limit", '2048M');
        if (!self::$_ocean) {
            $c = __CLASS__;
            self::$_ocean = new $c;
        }
        return self::$_ocean;
    }

    public function ocean_order() {
        $operate = utils::_get('operate');
        $operate = strtolower($operate);

        if (empty($operate)) {
            //search
            //栏位信息
            $column = column::getInstance()->getDisplayColumn('Ocean_Search');
            $BookingTableColumns = column::getInstance()->tableColumns('Ocean_Search',$column);
            $data['TrackingTableColumns'] = $BookingTableColumns;
            common::echo_json_encode(200,$data);
            exit();
        }

        if ($operate == "search") {
            $this->_ocean_search();
        }

        if ($operate == "detail") {
            $serial_no = common::deCode($_GET['a'], 'D');
            $transport_mode = common::excuteOneSql("SELECT transport_mode FROM public.kln_ocean ob WHERE  ob.serial_no = '$serial_no'");
            if ($transport_mode == "sea"){
                $this->_ocean_detail();
            } elseif ($transport_mode == "air"){
                $this->_air_ocean_detail();
            } else {
                $this->_ocean_detail();
            }
        }

        if ($operate == "ams_isf_log"){
            $this->_ams_isf_log();
        }

        /*
         * export ocean order to excel
        */
        if ($operate == "excel") {
            $this->_ocean_excel();
        }

        /*
         * download Revenue
        */
        if ($operate == "revenue") {
            $this->_revenue_download();
        }
       
        if ($operate == 'setting_ocean_order_display') {
            column::getInstance()->settingDisplay('Ocean_Search', 'main_new_version.php?action=ocean_order');
        }

        /*
        * download  batch document 
        */
        if ($operate == "batch_download_load") {
            $this->_batch_download_load();
        }


        /*
        * download  batch document 
        */
        if ($operate == "batch_download") {
            $data = $_POST['data'];
            $fileMap = array();
            foreach($data as $key => $_data){
                $url_param = $_data['url_param'];
                $url = $_data['url'];
                $h_bol = $_data['h_bol'];
                $label = $_data['label'];
                $standard = $_data['standard'];
                $is_topocean = $_data['is_topocean'];
                if($is_topocean[$key] == 't'){
                    //这个不会进来,现在文件全是从online 这边查询的
                    continue;
                }else{
                    $filename = common::deCode($url_param, 'D');
                    $filename = str_replace("/", DIRECTORY_SEPARATOR, $filename);
                    $filename = str_replace("\\", DIRECTORY_SEPARATOR, $filename);
                    if (!file_exists($filename)){
                        $display_name = basename($filename);
                        $data = array(
                            'msg' => $display_name.": File Not Exist."
                        );
                        common::echo_json_encode(500, $data);
                    }

                    $fileMap[] = [
                            'file_path' => $filename,
                            'h_bol' => $h_bol,
                            'format_name' => $label,
                            'standard' => $standard
                        ];
                }
            }
            common::downloadFilesAsZip($fileMap);
        }

        /*
        * download document
        */
        if ($operate == "download") {
            $this->_download();
        }

        /*
        * document upload
        */
        if ($operate == "document_upload"){
            //只查询public,两边数据一样，不用去同步更新新加的Client_Upload ，Notify Station，Auto-sync to Station
            $transport_mode = $_POST['transport_mode'];
            if($transport_mode == 'sea'){
                $document = _getViewDocType($_REQUEST["_schemas"]);
            }else{
                $document = _getAirViewDocType($_REQUEST["_schemas"]);
            }
            $file_serial_nos = array();
            foreach ($document as $v) {
                $types = $v['serial_no'];
                $types = strtolower($types);
                $types = explode(";", $types);
                foreach ($types as $k => $type) {
                    $file_serial_nos[] = $type;
                }
            }
            $file_serial_nos = utils::implode(';',$file_serial_nos);
            if($transport_mode == 'sea'){
                $sql = "select display_name,format_name as file_type,serial_no,m_h from public.ra_online_file_format where lower(serial_no) " . common::getInNotInSql($file_serial_nos) . " 
                        and active = true and client_upload = true";
            }else{
                $sql = "select display_name,format_name as file_type,serial_no,m_h from public.air_file_format where lower(serial_no) " . common::getInNotInSql($file_serial_nos) . " 
                    and active = true and client_upload = true";
            }
            $display_name = common::excuteListSql($sql);
            $data['File Type'] = $display_name;
            common::echo_json_encode(200,$data);
            exit();
        }

        /*
        * document upload do
        */
        if ($operate == "document_upload_do"){
            //checked from 
            if(empty($_POST['file_type']) || empty($_FILES['file']["name"])){
                $data = array(
                    'msg' => 'File Type or File must select.'
                );
                common::echo_json_encode(500,$data);
                exit();
            }
            $_schemas = $_REQUEST["_schemas"];
            $transport_mode = $_POST['transport_mode'];
            $bol = $_POST['h_bol'];
            $_bol = "";
            if ($transport_mode == "sea") {
                //m_bol,h_bol,job_no
                $count = common::excuteObjectSql("select * from ocean where lower(h_bol) = '" . strtolower($bol) . "'");
                $_bol = $count['m_bol'];
            } elseif ($transport_mode == "air") {
                //mawb,mawb_name,hawb
                $count = common::excuteObjectSql("select * from air where lower(hawb) = '" . strtolower($bol) . "'");
                $_bol = $count['mawb'] . '-' . $count['mawb_name'];
            }
            if (empty($count) || utils::count($count) <= 0){
                $data = array(
                    'msg' => 'HBOL does not exist.'
                );
                common::echo_json_encode(500,$data);
                exit();
            }

            $file_type = $_POST['file_type'];
            $_table =  $transport_mode == "sea" ? "ra_online_doc_upload" : "air_doc_upload";
            $_table_format =  $transport_mode == "sea" ? "ra_online_file_format" : "air_file_format";
            //格式配置只查询public
            $format = common::excuteObjectSql("select serial_no,m_h,standard,client_upload,notify_station,auto_sync_to_station from public.$_table_format where format_name = '$file_type'");       
            //查询存在的文件类型最大序号
            //$num = common::excuteOneSql("select count(*) from $_table where lower(bol) = '" . strtolower($bol) . "' and  format_serailno = '".$format['serial_no']."'");
            $num = 0;
            if ($transport_mode == "sea") {
                if (strtolower($format["m_h"]) == 'm'){
                    $num = common::excuteOneSql("select count(*) from $_schemas.$_table where (lower(bol) = '" . strtolower($count['m_bol']) . "' or lower(bol) = '" . strtolower($count['job_no']) . "') and  format_serailno = '".$format['serial_no']."'");
                }
                if (strtolower($format["m_h"]) == 'h'){
                   $num = common::excuteOneSql("select count(*) from $_schemas.$_table where lower(bol) = '" . strtolower($count['h_bol']) . "' and  format_serailno = '".$format['serial_no']."'");
                }
                if (strtolower($format["m_h"]) == 'a'){
                    $num = common::excuteOneSql("select count(*) from $_schemas.$_table where(lower(bol) = '" . strtolower($count['m_bol']) . "' or lower(bol) = '" . strtolower($count['h_bol']) . "' or lower(bol) = '" . strtolower($count['job_no']) . "') and  format_serailno = '".$format['serial_no']."'");
                }
            } elseif ($transport_mode == "air") {
                if (strtolower($format["m_h"]) == 'm'){
                    $num = common::excuteOneSql("select count(*) from $_schemas.$_table where lower(bol) = '" . strtolower($count['mawb'] . '-' . $count['mawb_name']) . "' and  format_serailno = '".$format['serial_no']."'");
                }
                if (strtolower($format["m_h"]) == 'h'){
                    $num = common::excuteOneSql("select count(*) from $_schemas.$_table where lower(bol) = '" . strtolower($count['hawb']) . "' and  format_serailno = '".$format['serial_no']."'");
                }
                if (strtolower($format["m_h"]) == 'a'){
                    $num = common::excuteOneSql("select count(*) from $_schemas.$_table where ( lower(bol) = '" . strtolower($count['hawb']) . "'  OR  lower(bol) = '" . strtolower($count['mawb'] . '-' . $count['mawb_name']) . "') and  format_serailno = '".$format['serial_no']."'");
                }
            }

            try {
                //$allow_extend = "|.pdf|.xlsx|.docx|";
                $allow_extend = "|.pdf|";
                $file_name = $_FILES['file']["name"];
                $errorMsg = "";
                $sql = "";
                
                foreach ($file_name as $i => $v) {
                    if (empty($v)) {
                        continue;
                    }
                    $size = floor($_FILES ["file"]['size'][$i] / 1024 / 1024);
                    if ($size > 5) {
                        $errorMsg = $_FILES['file']["name"][$i] ." is larger than 5M.";
                        continue;
                    }
                    if ($_FILES["file"]["error"][$i] > 0) {
                        $errorMsg = " File Upload Error(". $_FILES ["file"]["error"][$i] .")";
                        continue;
                    }
                    $path_parts = pathinfo($file_name[$i]);
                    $exten = $path_parts['extension'];
                    if (stristr($allow_extend, "|." . $exten . "|") === FALSE) {
                        $errorMsg = $_FILES['file']["name"][$i].', File type error.';
                        //continue;
                    }

                    $filename = $bol."_".$format['standard']."_V".($i+1+$num). "." . $exten;
                    $file_size = floor($_FILES ["file"]['size'][$i] / 1024) . "KB";
                    $order_type =  $transport_mode == "sea" ? "ocean" : "air";
                   
                    $origin_station = $count["origin_station"];
                    $destination_station = $count["destination_station"];

                    $format_serialno = $format['serial_no'];
                    $serial_no = utils::uuid();

                    $from_station = $count["from_station"];
                    if (strtolower($_schemas) == "public") {
                        if ($transport_mode == "sea")
                            $folder = DOCUMENT_OCEAN_UPLOAD_PATH . $from_station;
                        elseif ($transport_mode == "air")
                            $folder = DOCUMENT_AIR_UPLOAD_PATH . $from_station;
                    }else {
                        if ($transport_mode == "sea")
                            $folder = DOCUMENT_SFSOCEAN_UPLOAD_PATH . $from_station;
                        elseif ($transport_mode == "air")
                            $folder = DOCUMENT_SFSAIR_UPLOAD_PATH . $from_station;
                    }
    
                    $save_path = $folder . DS . date("Ymd") . DS;
                    if (common::mkdirs($save_path) === FALSE){
                        $errorMsg = "Save Folder create error.";
                        continue;
                    }
                    //pdf文件不需要处理宏，直接保存
                    $_bol_filed =  (strtolower($format["m_h"]) == 'm') ? $_bol : $bol;
                    if($exten == "pdf"){
                        if (move_uploaded_file($_FILES['file']['tmp_name'][$i], $save_path . $filename)) {
                            $sql .= "insert into $_schemas.$_table (file_name, file_path, upload_date, upload_ip, upload_by, bol, file_type, file_size, online_upload, 
                                origin, destination, from_station, serial_no, 
                                online_format,format_serailno,source_filename) 
                            values ('" . common::check_input($filename) . "','" . common::check_input($save_path) . "', now(), '" . common::ip() . "', 
                                    '" . common::check_input(_getLoginName()) . "','" . common::check_input(strtoupper($_bol_filed)) . "', '$order_type', '" . common::check_input($file_size) . "',
                                    't', '" . common::check_input($origin_station) . "', '" .common::check_input($destination_station) . "',
                                    '" . common::check_input($from_station) . "', '" . $serial_no . "',
                                    '" . common::check_input($file_type) . "','" . common::check_input($format_serialno) . "','" . common::check_input($filename) . "');";        
                        } else {
                            error_log("Upload Filed Failed: move_uploaded_file error,".$save_path . $filename);
                            error_log("Upload Filed Info:".json_encode($_FILES));
                            $errorMsg = "Upload Filed Failed.";
                            continue;
                        }
                    } else {
                        $outputFileName = $save_path . $filename;
                        if(move_uploaded_file($_FILES['file']['tmp_name'][$i],$outputFileName)){
                            //判断文件时候待宏，如果则这删除
                            if(utils::hasMacros($outputFileName)){
                                unlink($outputFileName);
                                $errorMsg = "Upload Filed Has Macros,Please remove and re-upload.";
                                continue;
                            }
                            $sql .= "insert into $_schemas.$_table (file_name, file_path, upload_date, upload_ip, upload_by, bol, file_type, file_size, online_upload, 
                                    origin, destination, from_station, serial_no, 
                                    online_format,format_serailno,source_filename) 
                                values ('" . common::check_input($filename) . "','" . common::check_input($save_path) . "', now(), '" . common::ip() . "', 
                                        '" . common::check_input(_getLoginName()) . "','" . common::check_input(strtoupper($_bol_filed)) . "', '$order_type', '" . common::check_input($file_size) . "',
                                        't', '" . common::check_input($origin_station) . "', '" .common::check_input($destination_station) . "',
                                        '" . common::check_input($from_station) . "', '" . $serial_no . "',
                                        '" . common::check_input($file_type) . "','" . common::check_input($format_serialno) . "','" . common::check_input($filename) . "');";
                        } else {
                            $errorMsg = "Upload Filed Failed.";
                            continue;
                        }
                    } 
                    //根据配置，看需要同步文件,
                    $doc_upload_log_table =  $transport_mode == "sea" ? "ra_online_doc_upload_log" : "air_doc_upload_log";
                    if(!empty($format['auto_sync_to_station'])){
                        if($format['auto_sync_to_station'] == "Origin Station"){
                            $sql .= "INSERT INTO public.$doc_upload_log_table(serial_no, station, download_time)
                                VALUES ('".$serial_no."', '" .common::check_input($destination_station) . "', now());";
                        }
                        if($format['auto_sync_to_station'] == "Destination Station"){
                            $sql .= "INSERT INTO public.$doc_upload_log_table(serial_no, station, download_time)
                                VALUES ('".$serial_no."', '" .common::check_input($origin_station) . "', now());";
                        }
                        if($format['auto_sync_to_station'] == "Origin and Destination Stations"){
                            //这个都同步，不需要手动补充记录去阻止文件的同步
                        }
                    } else {
                        //如果没有配置。这代表不同步文件
                        $sql .= "INSERT INTO public.$doc_upload_log_table(serial_no, station, download_time)
                                VALUES ('".$serial_no."', '" .common::check_input($destination_station) . "', now());";
                        $sql .= "INSERT INTO public.$doc_upload_log_table(serial_no, station, download_time)
                                VALUES ('".$serial_no."', '" .common::check_input($origin_station) . "', now());";       
                    }
                }
                //根据配置发送通知邮件 相同文件类型只提醒一次
                if(!empty($format['notify_station'])  && empty($errorMsg)){
                    $origin_op_email = common::excuteOneSql("select email from employee where employee_id = '".$count["origin_op_id"]."' limit 1");
                    $dest_op_email = common::excuteOneSql("select email from employee where employee_id = '".$count["dest_op"]."' limit 1");
                    $ks_from = common::excuteOneSql("select ksmart_station from public.contract_region_mapping where overeas = '".$count["from_station"]."' limit 1");
                    $ks_to = common::excuteOneSql("select ksmart_station from public.contract_region_mapping where overeas = '".$count["destination_station"]."' limit 1");
                    $ks_from = empty($ks_from)? 'f' : $ks_from;
                    $ks_to = empty($ks_to)? 'f' : $ks_to;
                    if($ks_from == "f" && $ks_to == "f"){
                        $errorMsg = "Both Non Ksmart,Please checked.";
                    }
                    
                    $curr_date_config = common::excuteObjectSql("SELECT to_char(now()::date,'Mon_DD_YYYY') as d1_day,to_char(now()::date,'Mon_DD_YYYY HH:MM') as d2_day");
                    $subject = "External Documentation Upload Notification"."_".$curr_date_config['d1_day'];
                    $email_from = "US.KApex.Online@kerryapex.com";
                    $upload_user_name = _getLoginName();
                    $upload_user_email = _getLoginEamil();
                    //如果有多個就留空，給Email信息就行
                    if ($transport_mode == "sea") {
                        $company =utils::getConpanyForNotify($_schemas,'ocean');  
                    }else{
                        $company =utils::getConpanyForNotify($_schemas,'air');
                    }

                    //Ksmart--> Ksmart
                    if ($ks_from == "t" && $ks_to == "t"){
                        if($format['notify_station'] == "Origin Station" || $format['notify_station'] == "Origin and Destination Stations"){
                            if(!empty($origin_op_email)){
                                //立即发送
                                $content = utils::getKlnDocNotifyContent($bol,$file_type,$upload_user_name,$upload_user_email,$company,$curr_date_config['d2_day']);
                                $sql .= "INSERT INTO email_record(type, title, from_email, to_email, content, insert_date, cc_email, attachment_path)
                                    VALUES ('KLN_DOC_Notify', '" . pg_escape_string($subject) . "', '" . pg_escape_string($email_from) . "', '" .
                                    pg_escape_string($origin_op_email) . "', '" . pg_escape_string($content) . "', now(), '', '');";
                            }else{
                                //加入队列状态
                                $sql .=  "INSERT INTO public.kln_online_upload_file_notify(h_bol, file_type, upload_by, upload_time, email, company, 
                                            is_send, checked_time, checked_type,origin_op,dest_op)
                                    VALUES ('$bol','$file_type','$upload_user_name', now(),'$upload_user_email', '$company', 
                                            false, now(), 'origin_op_email','".$count["origin_op_id"]."','".$count["dest_op"]."');";
                                //做好加入队列时的日志记录
                                $user_type = _isApexLogin() ? "Employee" : "Customer";
                                $detail = $bol.": $file_type File upload,origin_op_email is null, Add Notification wait";       
                                utils::single_operation_log_save($user_type,$upload_user_name,"Tracking","upload_file_pending",$detail);            
                            }
                        }
                        if($format['notify_station'] == "Destination Station" || $format['notify_station'] == "Origin and Destination Stations"){
                            if(!empty($dest_op_email)){
                                //立即发送
                                $content = utils::getKlnDocNotifyContent($bol,$file_type,$upload_user_name,$upload_user_email,$company,$curr_date_config['d2_day']);
                                $sql .= "INSERT INTO email_record(type, title, from_email, to_email, content, insert_date, cc_email, attachment_path)
                                    VALUES ('KLN_DOC_Notify', '" . pg_escape_string($subject) . "', '" . pg_escape_string($email_from) . "', '" .
                                    pg_escape_string($dest_op_email) . "', '" . pg_escape_string($content) . "', now(), '', '');";
                            }else{
                                //加入队列状态
                                $sql .=  "INSERT INTO public.kln_online_upload_file_notify(h_bol, file_type, upload_by, upload_time, email, company, 
                                            is_send, checked_time, checked_type,origin_op,dest_op)
                                    VALUES ('$bol','$file_type','$upload_user_name', now(),'$upload_user_email', '$company', 
                                            false, now(), 'dest_op_email','".$count["origin_op_id"]."','".$count["dest_op"]."');";
                                //做好加入队列时的日志记录
                                $user_type = _isApexLogin() ? "Employee" : "Customer";
                                $detail = $bol.": $file_type File upload,dest_op_email is null, Add Notification wait";       
                                utils::single_operation_log_save($user_type,$upload_user_name,"Tracking","upload_file_pending",$detail);            
                            }
                        }
                    }

                    //Ksmart-->non Ksmart
                    if ($ks_from == "t" && $ks_to == "f"){
                        if($format['notify_station'] == "Destination Station" || $format['notify_station'] == "Origin and Destination Stations"){
                            //避免重复邮件发给origin_op，  dest_op信息缺失的话，会发送给origin_op
                            $dest_op_email_temp = empty($dest_op_email)? $origin_op_email:$dest_op_email;
                            if(!empty($dest_op_email_temp)){
                                //立即发送
                                $content = utils::getKlnDocNotifyContent($bol,$file_type,$upload_user_name,$upload_user_email,$company,$curr_date_config['d2_day']);
                                $sql .= "INSERT INTO email_record(type, title, from_email, to_email, content, insert_date, cc_email, attachment_path)
                                    VALUES ('KLN_DOC_Notify', '" . pg_escape_string($subject) . "', '" . pg_escape_string($email_from) . "', '" .
                                    pg_escape_string($dest_op_email_temp) . "', '" . pg_escape_string($content) . "', now(), '', '');";
                            }else{
                                //加入队列状态 如果缺失，用origin_op_email
                                $sql .=  "INSERT INTO public.kln_online_upload_file_notify(h_bol, file_type, upload_by, upload_time, email, company, 
                                            is_send, checked_time, checked_type,origin_op,dest_op)
                                    VALUES ('$bol','$file_type','$upload_user_name', now(),'$upload_user_email', '$company', 
                                            false, now(), 'origin_op_email','".$count["origin_op_id"]."','".$count["dest_op"]."');";
                                //做好加入队列时的日志记录
                                $user_type = _isApexLogin() ? "Employee" : "Customer";
                                $detail = $bol.": $file_type File upload,origin_op_email is null, Add Notification wait";       
                                utils::single_operation_log_save($user_type,$upload_user_name,"Tracking","upload_file_pending",$detail);             
                            }
                        }

                        if($format['notify_station'] == "Origin Station" || $format['notify_station'] == "Origin and Destination Stations"){
                            if(empty($dest_op_email) && $format['notify_station'] == "Origin and Destination Stations"){

                            }else{
                            if(!empty($origin_op_email)){
                                //立即发送
                                $content = utils::getKlnDocNotifyContent($bol,$file_type,$upload_user_name,$upload_user_email,$company,$curr_date_config['d2_day']);
                                $sql .= "INSERT INTO email_record(type, title, from_email, to_email, content, insert_date, cc_email, attachment_path)
                                    VALUES ('KLN_DOC_Notify', '" . pg_escape_string($subject) . "', '" . pg_escape_string($email_from) . "', '" .
                                    pg_escape_string($origin_op_email) . "', '" . pg_escape_string($content) . "', now(), '', '');";
                            }else{
                                //加入队列状态
                                $sql .=  "INSERT INTO public.kln_online_upload_file_notify(h_bol, file_type, upload_by, upload_time, email, company, 
                                            is_send, checked_time, checked_type,origin_op,dest_op)
                                    VALUES ('$bol','$file_type','$upload_user_name', now(),'$upload_user_email', '$company', 
                                            false, now(), 'origin_op_email','".$count["origin_op_id"]."','".$count["dest_op"]."');";
                                //做好加入队列时的日志记录
                                $user_type = _isApexLogin() ? "Employee" : "Customer";
                                $detail = $bol.": $file_type File upload,origin_op_email is null, Add Notification wait";       
                                utils::single_operation_log_save($user_type,$upload_user_name,"Tracking","upload_file_pending",$detail);            
                            }
                            }
                        }
                    }

                    //Non Ksmart-->Ksmart
                    if ($ks_from == "f" && $ks_to == "t"){
                        if($format['notify_station'] == "Origin Station" || $format['notify_station'] == "Origin and Destination Stations"){
                            $origin_op_email_temp = empty($origin_op_email)? $dest_op_email:$origin_op_email;
                            if(!empty($origin_op_email_temp)){
                                //立即发送
                                $content = utils::getKlnDocNotifyContent($bol,$file_type,$upload_user_name,$upload_user_email,$company,$curr_date_config['d2_day']);
                                $sql .= "INSERT INTO email_record(type, title, from_email, to_email, content, insert_date, cc_email, attachment_path)
                                    VALUES ('KLN_DOC_Notify', '" . pg_escape_string($subject) . "', '" . pg_escape_string($email_from) . "', '" .
                                    pg_escape_string($origin_op_email_temp) . "', '" . pg_escape_string($content) . "', now(), '', '');";
                            }else{
                                //加入队列状态
                                $sql .=  "INSERT INTO public.kln_online_upload_file_notify(h_bol, file_type, upload_by, upload_time, email, company, 
                                            is_send, checked_time, checked_type,origin_op,dest_op)
                                    VALUES ('$bol','$file_type','$upload_user_name', now(),'$upload_user_email', '$company', 
                                            false, now(), 'dest_op_email','".$count["origin_op_id"]."','".$count["dest_op"]."');";
                                //做好加入队列时的日志记录
                                $user_type = _isApexLogin() ? "Employee" : "Customer";
                                $detail = $bol.": $file_type File upload,dest_op_email is null, Add Notification wait";       
                                utils::single_operation_log_save($user_type,$upload_user_name,"Tracking","upload_file_pending",$detail);             

                            }
                        }
                        if($format['notify_station'] == "Destination Station" || $format['notify_station'] == "Origin and Destination Stations"){
                            //避免重复邮件发给dest_op，  origin_op信息缺失的话，会发送给dest_op
                            if(empty($origin_op_email) && $format['notify_station'] == "Origin and Destination Stations"){

                            }else{
                            if(!empty($dest_op_email)){
                                //立即发送
                                $content = utils::getKlnDocNotifyContent($bol,$file_type,$upload_user_name,$upload_user_email,$company,$curr_date_config['d2_day']);
                                $sql .= "INSERT INTO email_record(type, title, from_email, to_email, content, insert_date, cc_email, attachment_path)
                                    VALUES ('KLN_DOC_Notify', '" . pg_escape_string($subject) . "', '" . pg_escape_string($email_from) . "', '" .
                                    pg_escape_string($dest_op_email) . "', '" . pg_escape_string($content) . "', now(), '', '');";
                            }else{
                                //加入队列状态
                                $sql .=  "INSERT INTO public.kln_online_upload_file_notify(h_bol, file_type, upload_by, upload_time, email, company, 
                                            is_send, checked_time, checked_type,origin_op,dest_op)
                                    VALUES ('$bol','$file_type','$upload_user_name', now(),'$upload_user_email', '$company', 
                                            false, now(), 'dest_op_email','".$count["origin_op_id"]."','".$count["dest_op"]."');";
                                //做好加入队列时的日志记录
                                $user_type = _isApexLogin() ? "Employee" : "Customer";
                                $detail = $bol.": $file_type File upload,dest_op_email is null, Add Notification wait";       
                                utils::single_operation_log_save($user_type,$upload_user_name,"Tracking","upload_file_pending",$detail);           
                            }
                            }
                        }
                    }
                }

                //代表前面有错误发生，终止SQL的执行
                if (!empty($errorMsg)) {
                    $data = array(
                        'msg' => $errorMsg
                    );
                    common::echo_json_encode(500,$data);
                    exit();
                }
                common::excuteUpdateSql($sql);
                $data = array(
                    'msg' => "success"
                );
                common::echo_json_encode(200,$data);
                exit();
            } catch (Exception $e) {
                error_log("Upload Filed Failed:".$e->getTraceAsString());
                $data = array(
                    'msg' => "Upload Filed Failed."
                );
                common::echo_json_encode(500,$data);
            }
        }

        if ($operate == "save_communication") {
            try {
                $content = $_POST["content"];
                $content = common::check_input($content);
                $text = $_POST["text"];
                $content = urldecode($content);
                $web_content = urldecode($text);

                $communication_cc = $_POST["communication_cc"];
                $serial_no = common::uuid();
                $email_uuid = $_POST["serial_no"];
                $add_by = _getLoginName();
                $refer_id = 0;
               
                $email = $this->getEmail($email_uuid);
                $from_email = "US.KApex.Online@kerryapex.com";
                $to_email = $email["email"];
                $cc_email = $_SESSION['ONLINE_USER']['email'] . ";ApexOnlineCommunication@apexshipping.com";
                $communication_cc = trim($communication_cc);
                if (!empty($communication_cc)) {
                    $communication_cc = common::check_input($communication_cc);
                    $cc_email .= ";" . $communication_cc;
                }


                $user_from = _getLoginName();
                $user_to = $email["name"];
                $user_cc = $_SESSION['ONLINE_USER']['first_name'];
                if (empty($user_cc)) {
                    $user_cc = _getLoginName();
                }
                $user_cc .= ";ApexOnlineCommunication";

                //邮件发送
                $poKey = "<br><br>Important note: when you reply this email, do not remove ApexOnlineCommunication@apexshipping.com<br>Below is system code, do not delete.<br>@@";
                $emailSql = "select encode(public.pgp_sym_encrypt('" . $serial_no . "','pom_key'), 'base64')::text;";
                $key = common::excuteOneSql($emailSql);

                $historyEmails = "";

                $title = "Communication from " . _getLoginName() . ", HBOL: " . $email["h_bol"] . ", Consignee: " . $email["consignee"];
                $emailContent = $content . $poKey . $key . ";" . "@@<br>For your convenience weblink: https://ra.kerryapex.com/<br><br>" . $historyEmails;

                common::excuteUpdateSql("insert into public.email_record (type,title,from_email,to_email,cc_email,content,insert_date)values('Communication','$title','$from_email','$to_email','$cc_email','$emailContent',now());");

                $rs = common::excuteUpdateSql("INSERT INTO public.online_ocean_communication(serial_no, email_uuid, content,web_content,user_from, user_to, user_cc, refer_id, add_by, add_time, cc_email) 
                VALUES ('$serial_no', '$email_uuid', '$emailContent','$web_content', '$user_from', '$to_email', '$cc_email', $refer_id, '$add_by', now(), '$communication_cc');");

                $emailRecords = $this->getCommunicationNew($email_uuid);
                common::echo_json_encode(200,array("msg" => "Sent Successfully", "emailRecords" => $emailRecords));
                exit();
            } catch (Exception $e) {
                common::echo_json_encode(500,array("msg" => "Sent Error."));
                exit();
            }
        }

        if ($operate == "ocean_vgm") {
            if (!_canEdiVgm()) {
                $data = array("msg" =>"Vgm Permission Error");
                common::echo_json_encode(400, $data);
                exit();
            }
            $serial_no = common::deCode(($_GET["a"]), 'D');
            $sqlWhere = " and o.serial_no='" . $serial_no . "'";
            $column = "*";
            $schemas = $_GET["_schemas"];
            if (empty($schemas)) {
                $schemas = "public";
            }
            $ocean_info_sql = "select o.from_station as o_from_station, o.h_bol as o_h_bol, o.carrier_booking, o.m_vessel, o.m_voyage, to_char(o.f_etd, 'MM/DD/YYYY') as f_etd, to_char(o.m_eta, 'MM/DD/YYYY') as m_eta, v.*, o.master_base_number from "
                    . "$schemas.ocean o left join $schemas.ocean_vgm v on o.serial_no=v.serial_no or o.master_base_number=v.master_base_number where 1=1  and o.status::text <> 'Cancelled'::text AND o.bol_type::text <> 'BOOKING'::text AND o.bol_type::text <> 'QUOTE'::text" . $sqlWhere;
            $ocean_info = common::excuteObjectSql($ocean_info_sql);

            $rs_sql = "select o.service, o.ctnr, v.carrier_booking_no, o.ctnr, o.size, v.vgm_weight, v.unit, v.vgm_time, v.vgm_method, o.grs_kgs, o.grs_lbs, ov.id as ocean_vgm_id, v.id as ocean_vgm_container_id from "
                    . "$schemas.oc_container o left join $schemas.ocean oc on o.serial_no=oc.serial_no "
                    . " left join $schemas.ocean_vgm ov on oc.serial_no=ov.serial_no or oc.master_base_number=ov.master_base_number "
                    . " left join $schemas.ocean_vgm_container v on ov.serial_no=v.serial_no and o.ctnr=v.ctnr "
                    . " where 1=1 and oc.status::text <> 'Cancelled'::text AND oc.bol_type::text <> 'BOOKING'::text AND oc.bol_type::text <> 'QUOTE'::text and oc.master_base_number='" . $ocean_info["master_base_number"] . "' and oc.from_station='" . $ocean_info["o_from_station"] . "'";
            $rs = common::excuteListSql($rs_sql);
            $ocean_info["is_send"] = (empty($ocean_info["is_send"]) ? "f" : $ocean_info["is_send"]);
            if (empty($ocean_info["id"])) {
                $ocean_info["is_send"] = "t";
            }
            $err_msg = "";
            if (empty($ocean_info["carrier_booking"])) {
                $err_msg = "Carrier Booking is empty.";
            }
            if ($schemas <> "public") {
                $err_msg .= "This hbol do not support.";
            }
            $err_msg_ctnr = "";
            $err_msg_CFS = "";
            foreach ($rs as $cv) {
                if (empty($cv["ctnr"])) {
                    $err_msg_ctnr = "Container# is empty.";
                }
                if (substr($cv["service"], 0, 3) == "CFS") {
                    $err_msg_CFS = "CFS cannot support update.";
                }
            }
            if (!empty($err_msg)) {
                $err_msg = "You cant't add this VGM, (" . $err_msg ." ". $err_msg_ctnr." ".$err_msg_CFS.")";
            }
            $serial_no = common::deCode($serial_no, "E");

            //default
            if (empty($rs["id"])) {
                $default = common::excuteObjectSql("select * from ocean_vgm_setting where login_name ilike '" . _getLoginName() . "'");
            }

            $log = common::excuteListSql("select * from ocean_vermas where from_serial_no ilike '" . $ocean_info["master_base_number"] . "'");

            //detail  information 
            $detail_information_column = array();
            $detail_information_column[] = array("title" =>"SN","field" =>"sn","formatter" =>"","edit_type" =>"normal",);
            $detail_information_column[] = array("title" =>"Carrier Booking No.","field" =>"carrier_booking_no","formatter" =>"","edit_type" =>"normal");
            $detail_information_column[] = array("title" =>"Container No","field" =>"container_no","formatter" =>"","edit_type" =>"normal");
            $detail_information_column[] = array("title" =>"VGM Weight","field" =>"vgm_weight","formatter" =>"","edit_type" =>"number");
            $detail_information_column[] = array("title" =>"VGM Unit","field" =>"vgm_kg_lg","formatter" =>"","edit_type" =>"select");
            $detail_information_column[] = array("title" =>"VGM Time","field" =>"vgm_date","formatter" =>"","edit_type" =>"dateTime");
            $detail_information_column[] = array("title" =>"VGM Method","field" =>"vgm_method","formatter" =>"","edit_type" =>"input");

            foreach($rs as $rk => $rv){
                $rs[$rk]['sn'] = $rk +1;
                $rs[$rk]['container_no'] = $rv['ctnr'];
                $rs[$rk]['vgm_kg_lg'] = $rv['unit'];
                $rs[$rk]['vgm_date'] = $rv['vgm_time'];
                $rs[$rk]['cargo_weight_kg'] = $rv['grs_kgs'];
                $rs[$rk]['cargo_weight_lb'] = $rv['grs_lbs'];
                //这个是前端逻辑,carrier_booking_no为空的话，取carrier_booking
                if(empty($rs[$rk]['carrier_booking_no'])){
                    $rs[$rk]['carrier_booking_no'] = $ocean_info["carrier_booking"];
                }
            }
            $detail_information =array("detail_information_column" =>$detail_information_column,
                "detail_information_data" =>$rs);

            $data = array("msg" =>$err_msg);

            $Submitter = $ocean_info["authorized_company"];
            if(empty($ocean_info["id"])){
                $Submitter = $default["submitter"];
            }

            $signature = $ocean_info["signature"];
            if(empty($ocean_info["id"])){
                $signature = $default["signature"];
            }

            $authorized_email = $ocean_info["authorized_email"];
            if(empty($ocean_info["id"])){
                $authorized_email = $default["authorized_email"];
            }

            $authorized_tel = $ocean_info["authorized_tel"];
            if(empty($ocean_info["id"])){
                $authorized_tel = $default["authorized_tel"];
            }
            
            $data["general_information"] = array("HBL No."=>$ocean_info["o_h_bol"],
                "Carrier Booking No."=>$ocean_info["carrier_booking"],
                "Vessel"=>$ocean_info["m_vessel"],"Voyage"=>$ocean_info["m_voyage"],
                "ETD"=>$ocean_info["f_etd"],"ETA"=>$ocean_info["m_eta"],
                "Last updated User"=>$ocean_info["modify_user"],"Last updated Time"=>$ocean_info["modify_time"],
                "submitter" =>$Submitter,"signature" =>$signature,"authorized_email" =>$authorized_email,"authorized_tel" =>$authorized_tel,"is_send" =>$ocean_info['is_send']);

            $data["detail_information"] = $detail_information;
            $data["schemas"] = $schemas;
            $data["serial_no"] = $serial_no;

            common::echo_json_encode(200, $data);
            exit();
        }

        if ($operate == "save_ocean_vgm") {
            if (!_canEdiVgm()) {
                $data = array("msg" =>"Vgm Permission Error");
                common::echo_json_encode(400, $data);
                exit();
            }
            $msg = $this->save_vgm();
            if ($msg == "success"){
                $data = array("msg" =>$msg);
                common::echo_json_encode(200, $data);
            } else {
                $data = array("msg" =>$msg);
                common::echo_json_encode(500, $data);
            }
            exit();
        }

        if ($operate == "default_vgm"){
            $vgm = array();
            $isvgm = false;
            if (_canEdiVgm()) {
                $isvgm = true;
            }
            if ($isvgm) {
                $vgm = common::excuteObjectSql("select * from ocean_vgm_setting where login_name ilike '" . _getLoginName() . "'");
            }

            $data = array("isvgm" =>$isvgm,"vgm" => $vgm);
            common::echo_json_encode(200,$data);
            exit();
        }
        
        if ($operate == "default_vgm_update"){
            $vgm = array();
            if (_canEdiVgm()) {
                $submitter = $_POST['submitter'];
                $signature = $_POST['signature'];
                $authorized_email = $_POST['authorized_email'];
                $authorized_tel = $_POST['authorized_tel'];
                $count = common::excuteOneSql("select count(*) from ocean_vgm_setting where  login_name ilike '" . _getLoginName() . "'");

                if($count > 0){
                    $rs = common::excuteUpdateSql("update ocean_vgm_setting set submitter = '" . common::check_input($submitter) . "', "
                        . "signature = '" . common::check_input($signature) . "', authorized_email = '" . common::check_input($authorized_email) . "', "
                        . "authorized_tel = '" . common::check_input($authorized_tel) . "' where login_name ilike '" . _getLoginName() . "'");
                }else{
                    $rs =common::excuteUpdateSql("INSERT INTO ocean_vgm_setting(login_name, submitter, signature, authorized_email, authorized_tel) "
                        . "VALUES ('" . _getLoginName() . "', '" . common::check_input($submitter) . "', "
                        . "'" . common::check_input($signature) . "', '" . common::check_input($authorized_email) . "', "
                        . "'" . common::check_input($authorized_tel) . "');");
                }
                $vgm["submitter"] = $submitter;
                $vgm["signature"] = $signature;
                $vgm["authorized_email"] = $authorized_email;
                $vgm["authorized_tel"] = $authorized_tel;
            }

            $data = array("msg" =>"Save Successful","vgm" => $vgm);
            common::echo_json_encode(200,$data);
            exit();
        }
        /*
         * share_shipment 这个提交的意义，是为了留下记录用户信息
        */
        if ($operate == "share_shipment") {
            $data = array("msg" =>"share_shipment");
            common::echo_json_encode(200,$data);
            exit();
        }
    }

    /*
    * ocean order search
    */
    private function _ocean_search() {
        //分担查询
        include ONLINE_ROOT . 'libs' . DS . 'map_config.ini.php';

        $cp = common::check_input($_POST ['cp']); //current_page
        $ps = common::check_input($_POST ['ps']); //ps
        if (empty($ps))
            $ps = 100;
        if (empty($cp))
            $cp = 1;

        $sqlWhere = ' where ' . common::searchExtendHand_KLN("ocean", $_SESSION["ONLINE_USER"]);
        $sqlWhere .= search::getInstance()->getSearchSQL("Ocean_Search");

        if (!empty($_REQUEST["_reportRef"])) {
            $_reportType = $_REQUEST["_reportType"];
            $_reportRef = $_REQUEST["_reportRef"];
            if ($_reportType == "r3") {
                if ($_reportRef == "Previous 7 Days") {
                    $sqlWhere .= " and eta>(current_date-interval '7 days') and eta<current_date";
                } else if ($_reportRef == "≤1 Day") {
                    $sqlWhere .= " and eta=current_date";
                } else if ($_reportRef == "1-2 Days") {
                    $sqlWhere .= " and eta>current_date and eta<=(current_date+interval '2 days')";
                } else if ($_reportRef == "3-6 Days") {
                    $sqlWhere .= " and eta>(current_date+interval '2 days') and eta<=(current_date+interval '6 days')";
                } else if ($_reportRef == "≥7 Days") {
                    $sqlWhere .= " and eta>(current_date+interval '6 days')";
                } else {
                    $sqlWhere .= " and 1<>1";
                }
            } else if ($_reportType == "r4") {
                if ($_reportRef == "Previous 7 Days") {
                    $sqlWhere .= " and etd>(current_date-interval '7 days') and etd<current_date";
                } else if ($_reportRef == "≤1 Day") {
                    $sqlWhere .= " and etd=current_date";
                } else if ($_reportRef == "1-2 Days") {
                    $sqlWhere .= " and etd>current_date and etd<=(current_date+interval '2 days')";
                }  else if ($_reportRef == "3-6 Days") {
                    $sqlWhere .= " and etd>(current_date+interval '2 days') and etd<=(current_date+interval '6 days')";
                } else if ($_reportRef == "≥7 Days") {
                    $sqlWhere .= " and etd>(current_date+interval '6 days')";
                } else {
                    $sqlWhere .= " and 1<>1";
                }
            } else if ($_reportType == "ata_r3") {
                if ($_reportRef == "≤1 Day") {
                    $sqlWhere .= " and ata >= etd and (ata-etd) >= 0 and (ata-etd) < 1";
                } else if ($_reportRef == "1-2 Days") {
                    $sqlWhere .= " and ata >= etd and (ata-etd) >= 1 and (ata-etd) < 2";
                }  else if ($_reportRef == "3-6 Days") {
                    $sqlWhere .= " and ata >= etd and (ata-etd) >= 2 and (ata-etd) < 6";
                } else if ($_reportRef == "≥7 Days") {
                    $sqlWhere .= " and ata >= etd and (ata-etd) >= 6";
                } else {
                    $sqlWhere .= " and 1<>1";
                }
            } else if ($_reportType == "atd_r4") {
                if ($_reportRef == "≤1 Day") {
                    $sqlWhere .= " and atd >= etd and (atd-etd) >= 0 and (atd-etd) < 1";
                } else if ($_reportRef == "1-2 Days") {
                    $sqlWhere .= " and atd >= etd and (atd-etd) >= 1 and (atd-etd) < 2";
                }  else if ($_reportRef == "3-6 Days") {
                    $sqlWhere .= " and atd >= etd and (atd-etd) >= 2 and (atd-etd) < 6";
                } else if ($_reportRef == "≥7 Days") {
                    $sqlWhere .= " and atd >= etd and (atd-etd) >= 6 ";
                } else {
                    $sqlWhere .= " and 1<>1";
                }
            } else if ($_reportType == "top") {
                if (!empty($_reportRef)) {
                    $_reportStationType = $_REQUEST["_reportStationType"];
                    
                    if($_reportStationType == 'shippr_uncode'){
                        $sqlWhere .= " and shippr_uncode  = '$_reportRef'";
                    }
                    if($_reportStationType == 'fport_of_loading_un'){
                        $sqlWhere .= " and fport_of_loading_un  = '$_reportRef'";
                    }
                    if($_reportStationType == 'consignee_uncode'){
                        $sqlWhere .= " and  consignee_uncode = '$_reportRef'";
                    }
                    if($_reportStationType == 'mport_of_discharge_un'){
                        $sqlWhere .= " and  mport_of_discharge_un = '$_reportRef'";
                    }
                    
                } else {
                    $sqlWhere .= " and 1<>1";
                }
            } else if ($_reportType == "co2e") {
                $_reportDataType = $_REQUEST["_reportDataType"];
                //查询sea 其他的为空
                if (!empty($_reportRef) && $_reportDataType == "sea") {
                    $_reportStationType = $_REQUEST["_reportStationType"];
                    if($_reportStationType == 'origin'){
                        $sqlWhere .= " and  shippr_uncode = '$_reportRef'";
                    }else{
                        $sqlWhere .= " and  consignee_uncode = '$_reportRef'";
                    }
                    
                } else {
                    $sqlWhere .= " and 1<>1";
                }
            } else {
                $_reportRef = explode("-", $_REQUEST["_reportRef"]);
                $_reportRefb_date = $_REQUEST["_reportRefb_date"];
                $bdate = common::excuteOneSql("select to_date('$_reportRefb_date','mm/YYYY')");
                $_reportRefe_date = $_REQUEST["_reportRefe_date"];
                $edate = common::excuteOneSql("select to_date('$_reportRefe_date','mm/YYYY') + interval '1 month' - interval '1 day'");
                //$sqlWhere .= " and eta>='$bdate' and eta<='$edate'";
                if ($_REQUEST["_reportRef"] == "Over 80 Days") {
                    $sqlWhere .= " and (eta-etd)>80";
                } else {
                    $sqlWhere .= " and (eta-etd)>" . $_reportRef[0] . " and (eta-etd)<=" . substr($_reportRef[1], 0, 2);
                }
            }
        }
        //取消全文检索
        // if (!empty($_POST["_textSearch"])) {
        //     $sqlWhere .= " and text_search @@ (str_to_tsquery('" . common::check_input($_POST["_textSearch"]) . "'))";
        // }
        //处理reference类型的组合查询  Search booking No./HBL No./PO No./Carrier Booking No.
        if (!empty($_POST["_textSearch"])) {
            $textSearch_arr = $_POST['_textSearch'];
            if(!is_array($textSearch_arr)){
                $textSearch_arr = str_replace(",", ";", $textSearch_arr);
                $textSearch_arr = array($textSearch_arr);
            }
            $more_param = common::getInNotInSqlForSearch(strtolower(utils::implode(';',$textSearch_arr)));
            //$sqlWhere .= " and (ARRAY[$more_param] && array_append(array[lower(booking_no)::text,lower(h_bol)::text, lower(po_no),lower(carrier_booking),lower(tracking_no)],''))";
            $sqlWhere .= " and ((ARRAY[$more_param] && array_append(ARRAY[lower(booking_no::text), lower(h_bol::text), lower(m_bol), lower(carrier_booking), lower(quote_no), lower(tracking_no)]||string_to_array(lower(ctnrs),','), ''::text))
                or lower(po_no) like '%" . strtolower(common::check_input($_POST["_textSearch"])) . "%'
                or lower(invoice_no) like '%" . strtolower(common::check_input($_POST["_textSearch"])) . "%')";
        }
        //移除filterTag
        $sqlWhere_befrom_filterTag  = $sqlWhere;

        $mode_param = "";
        $transport_mode = empty($_POST["transport_mode"]) ? "all" : $_POST["transport_mode"];
        if(!is_array($transport_mode)){
            $transport_mode = array($transport_mode);
        }
        if((utils::count($transport_mode) == 1 && strtolower($transport_mode[0]) == 'all')){
            $transport_mode = array("sea","air","road","rail");         
        }
        $transport_mode = utils::implode(";",$transport_mode);

        $mode_param = common::getInNotInSqlForSearch($transport_mode);
        $sqlWhere .= " and transport_mode_extend in ($mode_param)";
        $transport_mode_search = " and transport_mode_extend in ($mode_param)";
        
        //查询tag
        // IFFBCF  Booking Confirmation                      Created
        // IFFCPU  Cargo Pickup                              Cargo Received
        // IFFREC  Cargo Arrived at Origin                   Cargo Received
        // IFFDEP  Departure                                 Departed
        // IFFARR  Arrived at Final Destination Port         Arrived
        // IFFAFD  Arrived at Final Destination              Completed (remove)

        // IFFDEL  document turnover/delivered              Completed
        $filterTag_param = "";
        if (!empty($_POST["filterTag"])) {
            if (utils::count($_POST['filterTag']) == 1){
                $filterTag = $_POST['filterTag'][0];
            }else{
                $filterTag = utils::implode(",", $_POST['filterTag']);
            }

            $_sqlwhere = "1<>1";
            $filterTag_param = "1<>1";
            if(strtolower($filterTag) == "all"){
                $filterTag_param = "1=1";
            }
            if (stripos($filterTag, "Created") !== FALSE) {
                $_sqlwhere .= " or ((m_iffbcf is not null or m_iffbcf is null) and m_iffcpu is null and m_iffrec is null and m_iffdep is null and m_iffarr is null and m_iffdel is null)";
                $filterTag_param .= " or ((m_iffbcf is not null or m_iffbcf is null) and m_iffcpu is null and m_iffrec is null and m_iffdep is null and m_iffarr is null and m_iffdel is null)";
            }
            if (stripos($filterTag, "Cargo Received") !== FALSE) {
                $_sqlwhere .= " or ((m_iffcpu is not null or m_iffrec is not null) and m_iffdep is null and m_iffarr is null and m_iffdel is null)";
                $filterTag_param .= " or ((m_iffcpu is not null or m_iffrec is not null) and m_iffdep is null and m_iffarr is null and m_iffdel is null)";
            }
            if (stripos($filterTag, "Departed") !== FALSE) {
                $_sqlwhere .= " or (m_iffdep is not null and m_iffarr is null and m_iffdel is null)";
                $filterTag_param .= " or (m_iffdep is not null and m_iffarr is null and m_iffdel is null)";
            }
            if (stripos($filterTag, "Arrived") !== FALSE) {
                $_sqlwhere .= " or (m_iffarr is not null and m_iffdel is null)";
                $filterTag_param .= " or (m_iffarr is not null and m_iffdel is null)";
            }
            if (stripos($filterTag, "Completed") !== FALSE) {
                $_sqlwhere .= " or (m_iffdel is not null)";
                $filterTag_param .= " or (m_iffdel is not null)";
            }
            if(strtolower($filterTag) <> "all" && !empty($filterTag)){
                $sqlWhere .= " and ($_sqlwhere)";
                $filterTag_param = " ($filterTag_param)";
            }
        }
        if(empty($filterTag_param)){
            $filterTag_param = "1=1";
        }
        $tag_and_mode_param = $filterTag_param.$transport_mode_search;
        $mode_param_search = "1=1 ".$transport_mode_search;

        $rc = $_POST ['rc'];
        //这里都要查询，除非多传几个参数回来
        if ($rc == - 1 || true) {
            $sql = "select count(1) as rc,
                sum(case when (1<>1 or (transport_mode_extend='sea')) then 1 else 0 end) as sea_rc, 
                sum(case when (1<>1 or (transport_mode_extend='air')) then 1 else 0 end) as air_rc, 
                sum(case when (1<>1 or (transport_mode_extend='road')) then 1 else 0 end) as road_rc, 
                sum(case when (1<>1 or (transport_mode_extend='rail')) then 1 else 0 end) as rail_rc, 
                sum(case when $tag_and_mode_param then 1 else 0 end) as seach_rc, 
                sum(case when ($mode_param_search and m_iffcpu is null and m_iffrec is null and m_iffdep is null and m_iffarr is null and m_iffdel is null)
                     then 1 else 0 end) 
                as created, 
                sum(case when ($mode_param_search and (m_iffcpu is not null or m_iffrec is not null) and m_iffdep is null and m_iffarr is null and m_iffdel is null)
                     then 1 else 0 end) 
                as cargo_received,
                sum(case when ($mode_param_search and m_iffdep is not null and m_iffarr is null and m_iffdel is null) then 1 else 0 end) as departed,
                sum(case when ($mode_param_search and m_iffarr is not null and m_iffdel is null) then 1 else 0 end) as arrived,
                sum(case when ($mode_param_search and m_iffdel is not null) then 1 else 0 end) as completed,
                string_agg(distinct incoterms, '<$>') as incoterm_str,
                string_agg(distinct service, '<$>') as service_str 
            from public.kln_ocean". $sqlWhere_befrom_filterTag;
            error_log("online_ocean_search_All_Status: ".$sql);

            //$sql_all_status_data = common::excuteObjectSql($sql);
            $sql_all_status_data =  $mapdb->GetRow($sql) or ( (!$mapdb->ErrorMsg()) or error_log(common::dbLog($mapdb, $sql), 0));
            $incoterms = explode("<$>", $sql_all_status_data['incoterm_str']);
            $IncotermsList = array();
            foreach($incoterms as $terms){
                if(!empty($terms)){
                    $IncotermsList[] = array("name"=>$terms,"checked"=>false);
                }
            }
            $service = explode("<$>", $sql_all_status_data['service_str']);
            $ServiceList = array();
            foreach($service as $_service){
                if(!empty($_service)){
                    $ServiceList[] = array("name"=>$_service,"checked"=>false);
                }
            }
            $rc = $sql_all_status_data['rc'];
            $search_rc = $sql_all_status_data['seach_rc'];
            $sea_rc = $sql_all_status_data['sea_rc'];
            $air_rc = $sql_all_status_data['air_rc'];
            $road_rc = $sql_all_status_data['road_rc'];
            $rail_rc = $sql_all_status_data['rail_rc'];
            $Created = $sql_all_status_data['created'];
            $Cargo_Received = $sql_all_status_data['cargo_received'];
            $Departed = $sql_all_status_data['departed'];
            $Arrived = $sql_all_status_data['arrived'];
            $Completed = $sql_all_status_data['completed'];
            
            if (!empty($_POST["filterTag"])) {
                $tagsList = array(array("name"=>"All","number"=>intval($rc),"type"=>"all","checked"=>utils::in_array('All', $_POST["filterTag"])? true : false),
                array("name"=>"Created","number"=>intval($Created),"type"=>"created","checked"=>utils::in_array('Created', $_POST["filterTag"])? true : false),
                array("name"=>"Cargo Received","number"=>intval($Cargo_Received),"type"=>"cargo_received","checked"=>utils::in_array('Cargo Received', $_POST["filterTag"])? true : false),
                array("name"=>"Departed","number"=>intval($Departed),"type"=>"departed","checked"=>utils::in_array('Departed', $_POST["filterTag"])? true : false),
                array("name"=>"Arrived","number"=>intval($Arrived),"type"=>"arrived","checked"=>utils::in_array('Arrived', $_POST["filterTag"])? true : false),
                array("name"=>"Completed","number"=>intval($Completed),"type"=>"completed","checked"=>utils::in_array('Completed', $_POST["filterTag"])? true : false));
            }else{
                //初始，前端有选择着带入选择
                $tagsList = array(array("name"=>"All","number"=>intval($rc),"type"=>"all","checked"=> true ),
                array("name"=>"Created","number"=>intval($Created),"type"=>"created","checked"=> false),
                array("name"=>"Cargo Received","number"=>intval($Cargo_Received),"type"=>"cargo_received","checked"=> false),
                array("name"=>"Departed","number"=>intval($Departed),"type"=>"departed","checked"=> false),
                array("name"=>"Arrived","number"=>intval($Arrived),"type"=>"arrived","checked"=> false),
                array("name"=>"Completed","number"=>intval($Completed),"type"=>"completed","checked"=>false));
            }

            $TransportList = array(
                array("name"=>"Ocean Freight","sname"=>"Sea","number"=>intval($sea_rc),"checked"=>false,"icon"=>"#icon-icon_ocean_b"),
                array("name"=>"Air Freight","sname"=>"Air","number"=>intval($air_rc),"checked"=>false,"icon"=>"#icon-icon_airplane_b"),
                array("name"=>"Rail Freight","sname"=>"Rail","number"=>intval($rail_rc),"checked"=>false,"icon"=>"#icon-icon_railway_b"),
                array("name"=>"Road Freight","sname"=>"Road","number"=>intval($road_rc),"checked"=>false,"icon"=>"#icon-icon_truck_b"));
            
            $transport_mode_arr = explode(";", $transport_mode);
            foreach($transport_mode_arr as $mode){
                foreach($TransportList as $tkey => $transport){
                    if(strtolower(trim($mode)) == strtolower($TransportList[$tkey]["sname"])){
                        $TransportList[$tkey]["checked"] = true;
                    }
                }
            }
            //现在下载交给前端，后台预先只返回全部字段的列,
            $allColumn = column::getInstance()->getDisplayColumnAllReomveDefault('Ocean_Search');
            $allBookingColumns = column::getInstance()->tableColumns('Ocean_Search',$allColumn);
        }
        $tp = ceil($rc / $ps);
        $order_by = " etd desc";
        if (_isCustomerLogin()) {
            $order_by = " eta desc";
        }
        if ($rc > 0) {
            // $ocean_ref_sql = " LEFT JOIN LATERAL ( SELECT string_agg(ref_code ||ref_value, ', ') AS other_refenrence_no
            //                 FROM public.ocean_reference temp WHERE temp.serial_no = oo.serial_no) aa ON true ";

            $sql = "with oo  as (SELECT oe.*, order_from as _schemas,serial_no as __serial_no, serial_no,transport_mode,transport_mode_extend,
                    h_bol as _hbol, isf_bol as _isfbol, consignee_city as _consignee_city,piece_count as _piece_count,
                    f_vessel as _f_vessel, f_voyage as _f_voyage,
                    COALESCE(oe.import_po_no,po_no) as _po_no,
                    (select user_login from public.kln_user_subscribed us  
                        where lower(us.user_login) = '".strtolower(_getLoginName())."' and us.subscribed_serial_no = kln_ocean.serial_no) as is_subscribe,
                    CASE
	    	            WHEN (m_iffcpu is null and m_iffrec is null and m_iffdep is null and m_iffarr is null and m_iffdel is null) THEN 'Created'::text
                        WHEN ((m_iffcpu is not null or m_iffrec is not null) and m_iffdep is null and m_iffarr is null and m_iffdel is null) THEN 'Cargo Received'::text
                        WHEN (m_iffdep is not null and m_iffarr is null and m_iffdel is null) THEN 'Departed'::text
                        WHEN (m_iffarr is not null and m_iffdel is null) THEN 'Arrived'::text
                        WHEN (m_iffdel is not null) THEN 'Completed'::text
	    	            ELSE 'Created'
		            END AS new_status, ".
                    column::getInstance()->getSearchSqlForDisplay('Ocean_Search') . " 
                from public.kln_ocean
                    LEFT JOIN LATERAL ( SELECT loadterm,
                        manifest_type,
                        volume,
                        last_mile_delivery_date,
                        container_size,
                        import_po_no
                    FROM public.kln_ocean_extend oe WHERE oe.serial_no::text = kln_ocean.serial_no::text and oe.order_from::text = kln_ocean.order_from::text) oe ON true " 
                . $sqlWhere . " order by $order_by limit " . $ps . " offset " . ($cp - 1) * $ps.") 
            select oo.* ,
                case when oo.transport_mode ='sea'
                        then ( SELECT string_agg(DISTINCT code || value,', ' ORDER BY code || value) AS other_refenrence_no FROM public.reference_all temp 
                                    WHERE temp.code <> 'PO' 
                                            AND COALESCE(temp.value,'')<>''
                                            AND temp.value IS NOT NULL  
                                            AND LENGTH(TRIM(BOTH FROM temp.value)) > 0  
                                            AND temp.serial_no = oo.serial_no)
                    when oo.transport_mode ='air' 
                        then ''
                    else '' 
                end as \"Other refenrence No.\"
            from oo";

            $tmp_search_without_limit = "with oo  as (SELECT oe.*, order_from as _schemas,serial_no as __serial_no, serial_no,transport_mode,transport_mode_extend,
                    h_bol as _hbol, isf_bol as _isfbol, consignee_city as _consignee_city,piece_count as _piece_count,
                    f_vessel as _f_vessel, f_voyage as _f_voyage,
                    COALESCE(oe.import_po_no,po_no) as _po_no,
                    (select user_login from public.kln_user_subscribed us  
                        where lower(us.user_login) = '".strtolower(_getLoginName())."' and us.subscribed_serial_no = kln_ocean.serial_no) as is_subscribe,
                    CASE
	    	            WHEN (m_iffcpu is null and m_iffrec is null and m_iffdep is null and m_iffarr is null and m_iffdel is null) THEN 'Created'::text
                        WHEN ((m_iffcpu is not null or m_iffrec is not null) and m_iffdep is null and m_iffarr is null and m_iffdel is null) THEN 'Cargo Received'::text
                        WHEN (m_iffdep is not null and m_iffarr is null and m_iffdel is null) THEN 'Departed'::text
                        WHEN (m_iffarr is not null and m_iffdel is null) THEN 'Arrived'::text
                        WHEN (m_iffdel is not null) THEN 'Completed'::text
	    	            ELSE 'Created'
		            END AS new_status, ".
                    column::getInstance()->getSearchSqlForDisplay('Ocean_Search') . " 
                from public.kln_ocean
                    LEFT JOIN LATERAL ( SELECT loadterm,
                        manifest_type,
                        volume,
                        last_mile_delivery_date,
                        container_size,
                        import_po_no
                    FROM public.kln_ocean_extend oe WHERE oe.serial_no::text = kln_ocean.serial_no::text and oe.order_from::text = kln_ocean.order_from::text) oe ON true " 
                . $sqlWhere . " order by $order_by) 
           select oo.* ,
                 case when oo.transport_mode ='sea'
                        then ( SELECT string_agg(DISTINCT code || value,', ' ORDER BY code || value) AS other_refenrence_no FROM public.reference_all temp 
                                    WHERE temp.code <> 'PO' 
                                            AND COALESCE(temp.value,'')<>''
                                            AND temp.value IS NOT NULL  
                                            AND LENGTH(TRIM(BOTH FROM temp.value)) > 0  
                                            AND temp.serial_no = oo.serial_no)
                    when oo.transport_mode ='air' 
                        then ''
                    else '' 
                end as \"Other refenrence No.\"
            from oo";
            
            //$rs = common::excuteListSql($sql);
            $rs =  $mapdb->GetAll($sql) or ( (!$mapdb->ErrorMsg()) or error_log(common::dbLog($mapdb, $sql), 0));
            error_log("online_ocean_search_SQL: ".$sql);
            
            //对查询的结果做特殊处理，比如要拼接某个值，合并值等
            foreach($rs as $index => $val) {
                //返回加密serial_no
                $rs[$index]["__serial_no"] = common::deCode($val['__serial_no'], 'E');
                //$rs[$index]["mode"] = "Ocean Freight";
                $rs[$index]["Mode"] = $val['transport_mode_extend'] == 'sea' ? "Ocean Freight" : ($val['transport_mode_extend'] == 'air' ? "Air Freight": 
                                                ($val['transport_mode_extend'] == 'rail' ? "Rail Freight": 
                                                ($val['transport_mode_extend'] == 'road' ? "Road Freight": "")));

                $rs[$index]["Vessel/Airline"] = utils::outDisplayForMerge($val['_f_vessel'],$val['Vessel/Airline']);
                $rs[$index]["Voyage/Flight"] = utils::outDisplayForMerge($val['_f_voyage'],$val['Voyage/Flight']);
                
                //po_no 处理 有import 显示import
                $rs[$index]["PO No."] = $rs[$index]["_po_no"];

                //status 改为ocean_milestone里的信息
                $rs[$index]["Status"] = $rs[$index]["new_status"];
                if($val['transport_mode'] == 'sea'){
                    $rs[$index]["Chargeable Weight"] = $rs[$index]["_piece_count"];
                }
                $rs[$index]["Shipment Type"] = $rs[$index]["Shipment Type"] == 'GPE' ? 'LCL' : $rs[$index]["Shipment Type"];
                //订阅的参数
                if(empty($rs[$index]["is_subscribe"])){
                    $rs[$index]['is_subscribe'] = false;
                }else{
                    $rs[$index]['is_subscribe'] = true;
                }
                //这个不影响，不会deCode两次，取得是临时变量的__serial_no，加这个是为了订阅
                $rs[$index]["a"] = common::deCode($val['__serial_no'], 'E');
            }
        
            $arrTmp = array('searchData' => $rs, 
               'tagsList' => $tagsList,
               'TransportList' => $TransportList,
               'allColums' => $allBookingColumns,
               'IncotermsList' =>$IncotermsList,
               'ServiceList' =>$ServiceList,
               'canEdiVgm' => _canEdiVgm(),
               'rc' => $search_rc,
               'ps' => $ps,
               'cp' => $cp,
               'tp' => $tp,
               'tmp_search' => common::deCode($tmp_search_without_limit, 'E'),
               'type' => common::check_input($_POST ['_ntype']));
        } else {
            $arrTmp = array('searchData' => array(), 
                'tagsList' => $tagsList,
                'TransportList' => $TransportList,
                'IncotermsList' =>$IncotermsList,
                'ServiceList' =>$ServiceList,
                'allColums' => $allBookingColumns,
                'canEdiVgm' => _canEdiVgm(),
                'rc' => $search_rc,
                'ps' => $ps,
                'cp' => $cp,
                'tp' => $tp,
                'tmp_search' => "",
                'type' => common::check_input($_POST ['_ntype']));
        }
        common::echo_json_encode(200,$arrTmp);
        exit();
    }

    private function _ocean_detail() {
        $serial_no = common::deCode($_GET['a'], 'D');
        $sql = $this->getOceanDetail($serial_no);
        $ocean = common::excuteObjectSql($sql);
        //(本质是是底表ocean 和 kln_oceans数据没有及时同步，详细页面有查询的ocean的时间照成的时间不一致),
        //单独处理一些，用kln_ocean里面的字段，与查询页面保持一致： etd as oo_etd, eta as oo_eta,atd as oo_atd,ata as oo_ata,
        //这样改动最小
        //这个是同步问题，同步是实时的
        //$ocean["f_etd"] = $ocean["oo_etd"];
        //$ocean["m_eta"] = $ocean["oo_eta"];
        //$ocean["atd"] = $ocean["oo_atd"];
        //$ocean["ata"] = $ocean["oo_ata"];
        
        if (!empty($ocean)) {
            $ocean['_isf_bol'] = $ocean['isf_bol'];
            if (empty($ocean['_isf_bol'])) {
                $ocean['_isf_bol'] = "AMAW" . $ocean['_h_bol'];
            }
            $isf_ss = md5(md5($ocean['_isf_bol']));
            $isf_ss = substr($isf_ss, 7) . substr($isf_ss, 0, 7);
            //ETA Dest的计算逻辑移除
            // most update status
            $_schemas = $_REQUEST["_schemas"];
            $mostStatusSql = "select last_status_loc, last_status_city, to_char(last_status_315_date, 'MM/DD/YYYY') as last_status_315_date,last_status_315_code "
                    . ", fport_of_loading_un, mport_of_discharge_un, place_of_receipt_un, place_of_delivery_un FROM public.kln_ocean "
                    . "where serial_no= '" . $ocean["serial_no"] . "'";
            if (!empty($_schemas)) {
                $mostStatusSql .= " and order_from='" . $_schemas . "'";
            }
            $mostStatus = common::excuteObjectSql($mostStatusSql);
            $state = -1;
            if (!empty($mostStatus["last_status_315_code"])) {
                //desc 逻辑处理取消
                $state = common::getStatusStage($mostStatus["last_status_315_code"]);
            }
            //请求地图是需要的参数
            $uncode = "'";
            if ($mostStatus["place_of_receipt_un"] != $mostStatus["fport_of_loading_un"]) {
                $uncode .= $mostStatus["place_of_receipt_un"];
            }
            $uncode .= "'|'" . $mostStatus["fport_of_loading_un"] . "'|'" . $mostStatus["mport_of_discharge_un"] . "'|'";
            if ($mostStatus["mport_of_discharge_un"] != $mostStatus["place_of_delivery_un"]) {
                $uncode .= $mostStatus["place_of_delivery_un"];
            }
            $uncode .= "'";
        }

        $vueData = $this->returnOceanDetailData($ocean,$state);

        //处理shipment data暂时写死
        $simplexData = $vueData['shipmentData'];
        //处理transportInfo信息数据
        $transportInfo = $vueData['transportInfo'];
        //处理basicInfo信息数据
        $basicInfo = $vueData['basicInfo'];
        //处理 拼接地址 ocean表单exp 字段无法精准分割电话和地址信息，只能从contacts表里查询
        $businessPartners = $vueData['businessPartners'];
        //处理routes 转船可能有多个情况
        $routes = $vueData['routes']; 
        //处理marksAndDescription
        $marksAndDescription = $vueData['marksAndDescription'];
        
        //处理containerStatusData
        $containerStatusData = $vueData['containerStatusData'];


        //处理ocean_reference
        $ref_no = array();
        if(!empty($ocean['_invoice_no'])){
            $ref_no[] = array("label"=>"Invoice No.","value"=>$ocean['_invoice_no']);
        }
        $ref_arr = common::excuteListSql("select code,value from public.reference_all where  code <> 'PO' 
            and COALESCE(value,'')<>''
            AND value IS NOT NULL  
            AND LENGTH(TRIM(BOTH FROM value)) > 0  
            and lower(serial_no) = '" . strtolower($serial_no) . "' group by code,value");
        if(!empty($ref_arr)){
            foreach($ref_arr as  $ref) {
                $ref_no[] = array("label"=>$ref["code"],"value"=>$ref["value"]);
            }
        }
        //处理Container ：配置Ocean_Container字段 UI 需要的字段有：Container.no Packing,quantity,Gross weight(kg),Gross weight(LB)，CBM，seal#，size.service
        $ocean_container_column = array();
        $container_column = column::getInstance()->getDisplayColumnAll('Ocean_Container');
        //特殊处理po_no,配置column在查询的时候，不好
        $container_column[] = array("database_column_name" => "po_no","name"=>"PO No.");
        $container_column_config = array("Quantity" => array("formatter"=>"number","digits"=>0),
                "Gross Weight" => array("formatter"=>"number","digits"=>3),
                "Gross Weight" => array("formatter"=>"number","digits"=>3),
                "CBM" => array("formatter"=>"number","digits"=>3),
                "CFT" => array("formatter"=>"number","digits"=>3));
        foreach($container_column as $cc){
            $cc['name'] = $cc['database_column_name'] == "grs_kgs" ? "Gross Weight(KGS)" : ($cc['database_column_name'] == "grs_lbs" ? "Gross Weight(LBS)" : $cc['name']);
            if(!empty($container_column_config[$cc['name']])){
                $ocean_container_column[] =array("field" =>$cc['database_column_name'],"title" =>$cc['name'],
                "formatter" =>$container_column_config[$cc['name']]["formatter"],
                "digits" =>$container_column_config[$cc['name']]["digits"],
                "type" =>"normal");
            }else{
                $ocean_container_column[] =array("field" =>$cc['database_column_name'],"title" =>$cc['name'],"formatter" =>"","type" =>"normal");
            }

        }
        $sql = "SELECT " . column::getInstance()->getSearchSql('Ocean_Container') . ",
                net_lbs,po_no as oc_po_no,
                (select po_no from oc_container_item where oc_container_id = oc_container.id) as item_po_no 
            from oc_container where lower(serial_no) = '" . strtolower($serial_no) . "'";
        $rss = common::excuteListSql($sql);

        $quantity_unit = array();
        $g_weight_tolal = 0;
        $ch_weight_tolal = 0;
        $ch_weight_tolal_grs_lbs = 0;
        $cbm_tolal = 0;
        foreach ($rss as $key => $rs) {
            //特殊处理po_no
            $rss[$key]['po_no'] = utils::outDisplayForMergeForDISTINCT($rs['oc_po_no'],$rs['item_po_no']);

            $unit = $rs['unit'];
            if (array_key_exists($unit, $quantity_unit)) {
                $quantity_unit[$unit] = $quantity_unit[$unit] + $rs['qty'];
            } else {
                $quantity_unit[$unit] =  $rs['qty'];
            }
            $g_weight_tolal += $rs['grs_kgs'];
            $ch_weight_tolal += $rs['net_lbs'];
            $ch_weight_tolal_grs_lbs += $rs['grs_lbs'];
            $cbm_tolal += $rs['cbm'];
            //特殊处理weight
            if(!empty($rss[$key]['grs_kgs'])){
                $rss[$key]['grs_kgs'] = $rs['grs_kgs'];
            }
            if(!empty($rss[$key]['grs_lbs'])){
                $rss[$key]['grs_lbs'] = $rs['grs_lbs'];
            }

            //为每个柜子下面单独加状态信息 ctnr_label  content
            $rss[$key]['containerStatusData'] = array();
            foreach($containerStatusData as $_containerStatusData){
                if(trim($_containerStatusData["ctnr_label"]) == trim($rs["ctnr"])){
                    $rss[$key]['containerStatusData'] = $_containerStatusData["content"];
                }
            }
        }
        $quantity_tolal = "";
        foreach($quantity_unit as $uk => $uv){
            // 使用substr()截取第一次出现之前的字符串
            $uk = substr($uk, 0, strpos($uk, "-"));
            $quantity_tolal.=$uv." ".$uk." ";
        }
        $ch_weight_tolal = empty($ch_weight_tolal) ? $ch_weight_tolal_grs_lbs : $ch_weight_tolal;

        $g_weight_tolal = sprintf("%.3f", $g_weight_tolal);
        $ch_weight_tolal = sprintf("%.3f", $ch_weight_tolal);
        $cbm_tolal = sprintf("%.4f", $cbm_tolal);
        //Containers信息
        $containers = array("container_column"=>$ocean_container_column,"container_data" =>$rss);
        //Packing信息  ocean G和 Ch Weight 改成一样
        $packing = array("Quantity/Unit"=>$quantity_tolal,"G. Weight" => $g_weight_tolal." KGS","Ch. Weight" => $g_weight_tolal." LBS","Volume" => $cbm_tolal." CBM");
        
        //Milestones info  列名固定
        $Milestones = common::getMilestonesInfo($ocean,"sea",$_schemas,$vueData['EDI315TimeAndLocation']);

        //页面固定写死的信息
        $document_column = array();
        $document_column[] = array("title" =>"File Type","field" =>"file_type","formatter" =>"","type" =>"normal");
        $document_column[] = array("title" =>"File","field" =>"file","formatter" =>"","type" =>"normal");

        $document_data = array();
        $document = _getViewDocType($_REQUEST["_schemas"]);
        $OutFileURL = common::excuteOneSql("select item_value from config where item='OutFileURL'");

        $ocean_can_view_file = common::excuteOneSql("select ocean_can_view_file from ra_online_user where lower(user_login)='".strtolower($_SESSION['ONLINE_USER']['user_login'])."'");
        if (!empty($document)) {
            foreach ($document as $v) {
                $file_type = $v['display_name'];
                $file_arr =  $this->getOceanFileByHbol($ocean['_m_bol'], $ocean['_h_bol'], $v['serial_no'], $v['m_h'], $v['display_name'], TRUE,$ocean['_job_bol']) ;

                $tar = json_decode($ocean_can_view_file,true);

                if(!empty($tar[$v['display_name']])){
                    foreach ($tar[$v['display_name']] as $dkey => $dvalue) {
                        switch ($v['display_name']) {
                            case 'HBL':
                                $sql = "SELECT (SELECT format_name  from $_schemas.ra_online_file_format where serial_no = ra_online_doc_upload.format_serailno) as format_name,
                                        from_system,serial_no,file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date
                                        from ra_online_doc_upload
                                        where lower(bol) = lower('".$ocean['_h_bol']."') and lower(format_serailno) in ('".strtolower(str_replace(";","','",$dvalue['value']))."')  and upper((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2]) = '".$dvalue['type']."'
                                        order by id desc";
                                break;
                            case 'MBL':
                                $sql = "SELECT (SELECT format_name  from $_schemas.ra_online_file_format where serial_no = ra_online_doc_upload.format_serailno) as format_name,
                                        from_system,serial_no,file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date
                                        from ra_online_doc_upload
                                        where ( lower(bol) = lower('".strtolower($ocean['_m_bol'])."') or lower(bol) = lower('".strtolower($ocean['_job_bol'])."')) and lower(format_serailno) in ('".strtolower(str_replace(";","','",$dvalue['value']))."')  and upper((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2]) = '".$dvalue['type']."'
                                        order by id desc";
                                break;
                            case 'Others':
                                $sql = "SELECT (SELECT format_name  from $_schemas.ra_online_file_format where serial_no = ra_online_doc_upload.format_serailno) as format_name,
                                        from_system,serial_no,file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date
                                        from ra_online_doc_upload
                                        where (lower(bol) = lower('".strtolower($ocean['_h_bol'])."') or lower(bol) = lower('".strtolower($ocean['_m_bol'])."') or lower(bol) = lower('".strtolower($ocean['_job_bol'])."')) and lower(format_serailno) in ('".strtolower(str_replace(";","','",$dvalue['value']))."')  and upper((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2]) = '".$dvalue['type']."'
                                        order by id desc";
                                break;
                            default:
                                $sql = "";
                                break;
                        }

                        if (!empty($sql)) {
                            $rss = common::excuteListSql($sql);
                            foreach ($rss as $rs) {
                                if ($rs['from_system']=="TOPOCEAN"||$rs['from_system']=="KSMART") {
                                    $file_arr[] = array("url"=>$OutFileURL."/download.php?_schemas=&a=".base64_encode(base64_encode($rs['serial_no'])),
                                        "file_name" => $rs['file_name'],
                                        "format_name" => $rs['format_name'],
                                        "detail"=>$rs['upload_date'],
                                        "can_delete"=>_getLoginName() == $rs['upload_by'],
                                        "from_system" =>'TOPOCEAN_KSMART');
                                }else{
                                    $file_arr[] = array("url"=>"main_new_version.php?action=ocean_order&operate=download&url=". (common::deCode($rs['file_path'] . DS . $rs['file_name'], 'E')),
                                        "file_name" => $rs['file_name'],
                                        "format_name" => $rs['format_name'],
                                        "detail"=>$rs['upload_date'],
                                        "can_delete"=>_getLoginName() == $rs['upload_by'],
                                        "from_system" =>'');
                                }
                            }
                        }
                    }

                }
                //$document_data[] = array("file_type"=>$file_type,"file"=>$file_arr);
                //按现在的逻辑，有值才会显示
                foreach($file_arr as $f){
                    $document_data[] = array("file_type"=>$f["format_name"],"file"=>$f);
                }
            }
        }
        $document_info = array("document_column"=>$document_column,"document_data" =>$document_data);

        $emailRecords = $this->getCommunicationNew($ocean["serial_no"]);
        $cc_email = common::excuteOneSql("select cc_email from public.online_ocean_communication where email_uuid='" . $ocean["serial_no"] . "' order by id desc limit 1");
        $email = $this->getEmail($ocean["serial_no"]);
        $email['cc_email'] = $cc_email;
        $email['emailRecords'] = $emailRecords;

        global $_COPYRIGHT;
        $data = array('transportInfo' => $transportInfo, 
                        'basicInfo' => $basicInfo,
                        'businessPartners' => $businessPartners,
                        'ref_no' => $ref_no,
                        'packing' => $packing,
                        'marksAndDescription' => $marksAndDescription,
                        'containers' => $containers,
                        'simplexData' =>$simplexData,
                        'containerStatusData' => $containerStatusData,
                        'document_info' => $document_info,
                        'Milestones' => $Milestones,
                        'routes' => $routes,
                        'email' => $email,
                        'ams_ss' =>  md5(md5($ocean['serial_no'])),
                        'isf_ss' => $isf_ss,
                        'transport_mode' =>"sea",
                        '_schemas' =>$_schemas,
                        'uncode' =>$uncode,
                        'serial_no' =>$serial_no,
                        'is_subscribe' =>common::checkedSubscribe($serial_no),
                        'a' =>common::deCode($serial_no, 'E'),
                        'can_upload_doc' => strtolower($_SESSION['ONLINE_USER']['can_upload_doc']) == 't' || strtolower($_SESSION['ONLINE_USER']['can_view_doc']) == 't',
                        'canEdiVgm' => _canEdiVgm(),
                        'canViewAMSLog'=>_canViewAMSLog(),
                        'canViewISFLog'=>_canViewISFLog(),
                        'copyright' =>$_COPYRIGHT,
                        'website' =>common::getWebiste($ocean['m_carrier']));
        common::echo_json_encode(200,$data);                
        exit(); 
    }

    private function _air_ocean_detail(){
        $serial_no = common::deCode($_GET['a'], 'D');
        $sql = $this->getAirDetail($serial_no);
        $air = common::excuteObjectSql($sql);
        
        //根据air_milestone 判断 shipment status的state
        $_schemas = $_REQUEST["_schemas"];
        $air_milestone_status = common::excuteListSql("select code,
                act_date,est_date,timezone 
            from  air_milestone a 
		 		where a.serial_no='$serial_no' and code in('IFFCPU','IFFREC','IFFONB','IFFARR','IFFDEL')
            order by id");
        $state = -1;
        if (!empty($air_milestone_status)) {
            $state_arr = array();
            foreach($air_milestone_status as $ms){
                if($ms['code'] == "IFFCPU"){
                    $state_arr[] = 0;
                }
                if($ms['code'] == "IFFREC" || $ms['code'] == "IFFONB"){
                    $state_arr[] = 1;
                }
                if($ms['code'] == "IFFARR"){
                    $state_arr[] = 2;
                }
                if($ms['code'] == "IFFDEL"){
                    $state_arr[] = 3;
                }
            }
            $state = max($state_arr);
        }        
        $vueData = $this->returnAirDetailData($air,$air_milestone_status,$state);

        //处理shipment data暂时写死
        $simplexData = $vueData['shipmentData'];
        //处理transportInfo信息数据
        $transportInfo = $vueData['transportInfo'];
        //处理basicInfo信息数据
        $basicInfo = $vueData['basicInfo'];
        //处理 拼接地址 ocean表单exp 字段无法精准分割电话和地址信息，只能从contacts表里查询
        $businessPartners = $vueData['businessPartners'];
        //处理routes 转船可能有多个情况
        $routes = $vueData['routes']; 
        //处理marksAndDescription
        $marksAndDescription = $vueData['marksAndDescription'];
        
        $quantity_tolal = empty($air['qty']) ? "" : $air['qty'].$air['qty_uom'];
        $g_weight_tolal = empty($air['piece_count']) ? "" : sprintf("%.3f", $air['piece_count'])." KGS";
        $ch_weight_tolal = empty($air['piece_count']) ? "": sprintf("%.3f", $air['weight'])." KGS";
        $cbm_tolal = empty($air['cbm']) ? "" : sprintf("%.4f", $air['cbm'])." CBM";
        //Packing信息
        $packing = array("Quantity/Unit"=>$quantity_tolal,"G. Weight" => $g_weight_tolal,"Ch. Weight" => $ch_weight_tolal,"Volume" => $cbm_tolal);
        
        //Milestones info  列名固定
        $Milestones = common::getMilestonesInfo($air,"air",$_schemas);

        //页面固定写死的信息
        $document_column = array();
        $document_column[] = array("title" =>"File Type","field" =>"file_type","formatter" =>"","type" =>"normal");
        $document_column[] = array("title" =>"File","field" =>"file","formatter" =>"","type" =>"normal");

        $document_data = array();

        $document = _getAirViewDocType($_REQUEST["_schemas"]);
        $air_can_view_file = common::excuteOneSql("select air_can_view_file from ra_online_user where lower(user_login)='".strtolower($_SESSION['ONLINE_USER']['user_login'])."'");
        if (!empty($document)) {
            foreach ($document as $v) {
                $file_type = $v['display_name'];
                $file_arr =  $this->getAirFileByHbol($air['_mawb'] . '-' . $air['_mawb_name'], $air['_h_bol'], $v['serial_no'], $v['m_h'], $v['display_name'], TRUE);

                $tar = json_decode($air_can_view_file,true);
                if(!empty($tar[$v['display_name']])){
                    foreach ($tar[$v['display_name']] as $dkey => $dvalue) {
                        switch ($v['display_name']) {
                            case 'HBL':
                                $sql = "SELECT (SELECT format_name  from $_schemas.air_file_format where serial_no = air_doc_upload.format_serailno) as format_name,
                                        file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date
                                        from air_doc_upload
                                        where lower(bol) = lower('".$air['_h_bol']."') and lower(format_serailno) in ('".strtolower(str_replace(";","','",$dvalue['value']))."')  and upper((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2]) = '".$dvalue['type']."'
                                        order by id desc";
                                break;
                            case 'MBL':
                                $sql = "SELECT (SELECT format_name  from $_schemas.air_file_format where serial_no = air_doc_upload.format_serailno) as format_name,
                                        file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date
                                        from air_doc_upload
                                        where lower(bol) = lower('".strtolower($air['_mawb'] . '-' . $air['_mawb_name'])."') and lower(format_serailno) in ('".strtolower(str_replace(";","','",$dvalue['value']))."')  and upper((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2]) = '".$dvalue['type']."'
                                        order by id desc";
                                break;
                            case 'Others':
                                $sql = "SELECT 
                                        (SELECT format_name  from $_schemas.air_file_format where serial_no = air_doc_upload.format_serailno) as format_name,
                                        file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date
                                        from air_doc_upload
                                        where (lower(bol) = lower('".strtolower($air['_h_bol'])."') or lower(bol) = lower('".strtolower($air['_mawb'] . '-' . $air['_mawb_name'])."')) and lower(format_serailno) in ('".strtolower(str_replace(";","','",$dvalue['value']))."')  and upper((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2]) = '".$dvalue['type']."'
                                        order by id desc";
                                break;
                            default:
                                $sql = "";
                                break;
                        }
                        if (!empty($sql)) {
                            $rss = common::excuteListSql($sql);
                            foreach ($rss as $rs) {
                                $file_arr[] = array("url"=>"main_new_version.php?action=ocean_order&operate=download&url=". (common::deCode($rs['file_path'] . DS . $rs['file_name'], 'E')),
                                        "file_name" => $rs['file_name'],
                                        "detail"=>$rs['upload_date'],
                                        "can_delete"=>_getLoginName() == $rs['upload_by'],
                                        "from_system" =>'');
                            }
                        }
                    }
                }
                //$document_data[] = array("file_type"=>$file_type,"file"=>$file_arr);
                //按现在的逻辑，有值才会显示
                foreach($file_arr as $f){
                    $document_data[] = array("file_type"=>$f["format_name"],"file"=>$f);
                }
            }
        }
        $document_info = array("document_column"=>$document_column,"document_data" =>$document_data);

        $emailRecords = $this->getCommunicationNew($air["serial_no"]);
        $cc_email = common::excuteOneSql("select cc_email from public.online_ocean_communication where email_uuid='" . $air["serial_no"] . "' order by id desc limit 1");
        $email = $this->getEmail($air["serial_no"]);
        $email['cc_email'] = $cc_email;
        $email['emailRecords'] = $emailRecords;

        global $_COPYRIGHT;
        $data = array('transportInfo' => $transportInfo, 
                        'basicInfo' => $basicInfo,
                        'businessPartners' => $businessPartners,
                        'ref_no' => array(),
                        'packing' => $packing,
                        'marksAndDescription' => $marksAndDescription,
                        'containers' => array(),
                        'simplexData' =>$simplexData,
                        'containerStatusData' => array(),
                        'document_info' => $document_info,
                        'containers' => array(),
                        'Milestones' => $Milestones,
                        'routes' => $routes,
                        'email' => $email,
                        'ams_ss' =>"",
                        'isf_ss' => "",
                        '_schemas' =>$_schemas,
                        'uncode' =>"",
                        'transport_mode' =>"air",
                        'serial_no' =>$serial_no,
                        'is_subscribe' =>common::checkedSubscribe($serial_no),
                        'a' =>common::deCode($serial_no, 'E'),
                        'can_upload_doc' => strtolower($_SESSION['ONLINE_USER']['can_upload_doc']) == 't' || strtolower($_SESSION['ONLINE_USER']['can_view_doc']) == 't',
                        'canEdiVgm' => _canEdiVgm(),
                        'canViewAMSLog'=>_canViewAMSLog(),
                        'canViewISFLog'=>_canViewISFLog(),
                        'copyright' =>$_COPYRIGHT,
                        'website' =>"");
        common::echo_json_encode(200,$data);                
        exit(); 
    }

    private function _ocean_excel() {
        $ss = "CGwJfEx%2BQ%2Ff3aJmJClY%2F7RHy5As3znfG0XuXRBGpw4bCE0wjLUDEoZ6%2B5BJo0OQFgDzK%2BM6rl5r0WZLcA9PEwkfev%2FhXF1%2FNCZapuYdz%2FydWzEAQHC7yzNG%2B5NJJIgepDzmgONIIJb%2FIWgWybMOgWi2YH3EyBRxenTHXO0l2m11cA4%2BKpc9VWuRVtanv03rsv7q%2FSOMLKAHWhpHYKJVjvLMk0jLWs0BLlZb1ZJBbWzb5j2hnO4%2BelxwNXGocd18JA30Qu0BnTGOXL222m3ReqGnLA27TZMcz77wdfQbfCe8gSPgJirjKowpFJzz5O5cvRhYzf2PpssPseyn9idYfOYSAys1j7wIsUJlLN0QX5Ce0OsbQEIRbgYGvwGo%2F%2B84X1BqpqOCLa72XgwQGkyQLYN2h6HlEHXGb4jcUTUSpLKg0zpj6HxIvA7mfmtnrQQQQSw0YOvRrZ6LGcXKcbQbZKi9q4n75JSyYe77f2zpz0QzpgV94kqBZJW4SGFL0mJwOb3Z%2BvJYIPo2AX%2BNkboUjSBOOe0DIyg%2Fgfd4Npf%2F0w8ZBOOT6s2TSQ8GCUHbr6h6cw9oSQXFI1SS2DluZfymVJtQNVkL4zhVPmjqks4sNDoARjc5eunbdwrBH8%2Fqw1bIKkJo%2BH22eSPzCb4X0Pfo%2BKPbU0GpKa%2By%2BAfsqUFQ7GLLhqQHpnn5g3LQzkyLPuNi6DZ7KPhujOwKLmK0Bsv%2Bon6vj6xiJbtzmMM4ZIOkN8yns%2F0EzxggYgQ2s%2F1WjiXpWrsFKuECu6RHiyWf%2FKqBfv0thCEa5uksXoS%2F0vT5aMD%2BOaa1XcnXy1xXNpEVTjJ6t%2F20j7RelfkmmTPWAGktQuswGHSYQ%2FHnYmnJ218rtUysC7phbIjBj76zN4LDikb2%2BY1E5Soe37xAwxfiv0L6JzZJ3JJ%2B%2F31CP%2F9BwwHkt%2FRlKCxq22f3mm%2BB8VLKaarlj6X5yFba9XPZ9PZbdHQzPW7Aj9AhtxDggEhjLy4RfWRbwmAM6ppIquj8Jt%2BVR1FRrgcAorFHS%2Bws0qm0VPJJOu26pWyhGhsBh215jxhdaMFFB8b0I6WB652nkCp1fy6hOTRtYvdJdjT8luHDdqzMgqo6v04SBM3PUww9fNhBdYPE67PCdOiWD%2FK%2F%2FdLsEZOHMG%2BQOD85lJlXN4N4xuqXNI1JxvrDuy6Xprs7jGZyDE2cy1VpvgJYEMfFG1ZLNV%2FcyzaIlFd3Ds7CDiDcRlO1dAGu88O9AwgOcAI5vpTwWKT3gR9tFJKWJRz7cv79wCaQu60ObqmdJ9tVA0B08RIe86xeae78rJBjtsodDS35td9czw30PaBg7Ffd1SKB9TNeloOwvoTtXxUIVkAXKNNtVc5QdRqLTsJBjcZxy0%2B9mEfgWKOBmz%2BRFbXti%2FEUSGfsiSn4MrzsmB%2FRKMF0JZMeGi3vzMNnp%2FLtxVUOAgvt9KgDRH1iN%2B5cG9yIa6n%2Fy%2BE0F9c%2F15ZhZm1MGrCXbFjYetnz1bhJW5UY9K6vNlh28S7vGKB9oO3H8fAdxr%2F8CyiVMhCxoNaGyh1oKgZ0013su1%2FEuMlO5vD9Kl62FuRuuS010nhKkj3GXPLvG0Zudw6Uoyiz2D0wsWgYYUZJsqMNyw8b1rjs1lt4tyjMi9oTG%2BqUG2XB%2FuuGdgRZwYbFn%2FHxHnO3SsslOEm%2Fu0lGCJfOx9A2lvGO4Tj8y5%2Fzal85twYww%2FxpDURf6FZcy3VorvuLydC%2FbViJm2WQeh%2BgV%2FO4ea0cXd5NN3sNElkdyDUTBllaKcgDYmpIK2BMMPZm%2BhbE2hZ%2FyGvHrOP8N8plDw0rNe58auRVUhFEtcDcoSzapuJ3QsdKR%2BKi5W5Fh%2BcRT0DASDFausZfX5QVoSNxHQUaAJaZ4o2D%2FdkAodQOv2Gg%2BpYtS3%2BjGU7LlANpACx5XsOas83PKI7wDuYuq1KhVwK5t8OiJimi6O5oOMf2cOQd0tddupMwFIryBQ92MnuA1WSw2zwMDyvGxyljXqlUASTlN9fZ5EQu%2FF7nWoTEcLOJjRvzkRYZsdC48fy%2B2lFiIwB%2FAWMqqL%2FTszHHZhuhWW0nYteVjyFGMCBzeaRq2jzdBJlf4Ds6DYfRYX9uL%2BbThrMj76NgOX8%2F9E0cnhU1p9vbxv6YeJ4zoZ8qy0DCGoZOIrn7M0%2Fx7AJk4vXV6NUE0zPPJ%2BAubiARCgZ0DEoGMucW7DHTiIi7FV%2BzRre84wxy4l4B5ELSupdtOAz5S9XAPCd2lSlpIAJScqJxa9kPCUv9J%2FBCFwoZ%2Fu2Sn7d3j8y3yeQddbyetouAR4hUP1cfQrQVtVrgnRIB%2FYVuLJnFm4ioUf4yoSc8f6m95cCeW62RIdjPDfIIoduyRF8WWHQYXEwZgcrURG0XQXZjmUxKT8HvaYRWWWfq19kIAgcRkHX8mzyZEfD%2Bvgw%2FKvicxq1FvvDh0qYmF3tfUmqOWshBvpOgYp135dPv597WrcUNgz695PghmWKOD5CetV07EGdKkDWYGtSUYE9zJP8sKlvEowK%2FlwNAK%2BiU6%2F%2FqBvX5dU3dhbhbHsO09ZzQuxo3FRdSFzT6QkiA7EAwhVLAd55%2FNaxTWPk%2B4tbDcJf7GdeeXOwclw3hmlvGLPFZq%2B%2FJkZbOQvrq1H39fkSm7qbxfYU1U5hLc24vXn0a58r4YLMBZNBEh6aJqy4DW%2BGHDohSL59GPbOwEvUPsoEg6I7ah2Q%2BPsgYnZhdR5LVonNCWu9BWfg4I%2Bm%2BLcoLBrGou4YLSTIVvRdHlNxhJZ%2BjWG1%2F9NiOPQS5QTpMXVJwOAbMz98S%2FDaUapuGsS2YUX9A2do5%2BWix12e1hvYrgOlhZIeaYsMB1NbZXaaeILY6dT9o8PzJ5PVgzOBfjSdojegnovFWD6rqGSGEfllStooCNF1kMHB4w50f859cCnm4qC%2FtT%2FYNWA6yvcCpXiHwNCemYd45j77qQBodxy50z870SCc6GWosCJzHvivg7HIOZhIPfH5yuEwgsqg7IZFw%2BjTjcemsJw6m%2BFzsrEBcgVFctOhufnjDlAd4OzxBrXUNT%2FcvvrjQ5JinugAx6nW8D58gURlAfB5cZr2fQxVQhOX2CSBWDRjeYYAcRGTRGVnYnB1otpzoABuBBnqKDPc5fHkZtmv1vhQtdpxQK17AlegiaUvZknwxbaax75vTcsgyA9jU81xteBaq5D5%2FBD%2BWTw3WxUtCibHN%2FgY1svcxBR88UfVgz88pAbdJTasGoZGPa2whf8o3gaSWVNjkSXV11w1L7J71bXOZecBbcpONZEXsRSrTpEvJv3m5h4%2B2QTOtxETz3MDLFmUOh1ca9X8cBNTbv9mlZsFiFphQdYgKnCMvrQNZHU%2ByE%2FVBTOeY8%2FAmcRxcua3%2BKYYVBRME3IIa%2FtmSx2uV3m%2FVoICqCH07yXogkKIJebKwvF1NrpAdsVY7V57TZUzHlCoZjqv0FvhxiA9Ru3MGjpHHfzUb8jLpb8WV4RMuRZv8EDejqJSRuh7QLxxmWtmsUD7vuzbR6myXtwu2k7hHYUjPMIhGGvZhayqZ%2Bg2Z77appoJ55oRTdk%2B0gt0TEUAzEIgODyK2MyhsA3otqTwTzY%2FCOnxFZPPnbH96rCr5pSNardx61AWLythjsB3Yo9URbGFVjYD29aiC2%2FUma%2BJcxImGbwkqwxIpd59v3RMMCbh3uu52jxj8jJFxHk1gL1%2BPoczMs1IVcmwOqh5d7m0bf1XMq4vjejmWHhJa7%2FkSLj%2B4G31aQC0K9jVAEtMfNqY%2Bi2PPsNBZpcZEWEGFdSj9jvY0%2FMlJ1sO2y%2BJelJdcJfkFCr2XW2HrY2KYnfcvE1mruhsqcMmsHeGDM7iPq%2F4%2FdkRnaovu%2BPgrEhwS87E85PnH1K%2BFGC%2FE39SReNd70iNBcLX3BNC22q2WQbH660EoDSskZg%2BYKG2TCkvgF%2BP5lR5f4eI%2FOC0GbF7IqIlvh5TL9IHuPqmGiZuAM3TXeaiLfMWU8%2BShT49U27QRj3WPyogwQtrYYKtwcPLCcoR79E1pF39wAOpy%2Bgzg0m1HkSThMo1b7%2FflBZUVPfH228K3vcGrvZO25LtlWyqK67scctgo%2Bm7XmSagfUSKgaxdm%2BTS3KII7i0Uym2GBVdYRN0VsKyWDCdMxxMl3qidvMa7pRvetCt9lh96GNEql6ZsjIwj%2F505oDDZWdMfP6afSZxvMsoRRPTyvgW64i8CXgFUxV7YueaWLHNiBx9uHgpDXEnzc7tPbpihEtDnwOWU1TiPTp%2B0BHmzaYEa8ZulsFC0ldODVHKPRdUe234dyZBFTVOP2Xo9KMB%2FUszLDDvXzUJSnEdqchGZIlXGZoMN4dqeXzN6HbJBdQUUsqJW%2BiKvUegnYcHwMFurt53I0kmy8N8R31HIwQToTLEpnVY5iYO1NWARZSdU4N%2BoSUQBRTEnwrokzR1FILyILH8I0ZoGECZhyXiaMbPzyGCndQnxq%2Bqkg%2FvhJr%2BIQzgqzJOlRCrA1cEUvHdFfadw2piIze%2FN8JXt0FTcNyGeV56GQ39aJXHCWt9HEDC1P3jZMj4NdOC7HZBKVeuxt23wZ1obrfriVqbp0w96ie5RR9PTN%2F%2F2ZdXL9lG48IMZrULoWBza6sbpgRUZ1rhov4KTT%2BN%2BFPfh%2BkGCXx25i8fjPWAnVvqekNC%2BGnoRcMa3zoDd8%2F4KQ1vadMIebOCzgvmv2gcivTxlkBml6JROxVvBzwuaaIICl4jLdbSTUI3SjsiA6Ur1oR%2BSpcdPXzDOjeJzpznLmpOzTHfYnM4Ow%2FgUfekZBVKo9tFjpCV%2FfD7711xMzOrXf9%2BBwFz7tZI0ZwC67JIeEfKK%2FkK0fA6X3gQJB9nxOvHoahRbFdolG%2F3R3Re4uEzi6ZpIkxBzzWWa7D5rx7EE1FhbzKRdPYbnWXOsWeSlKH9bxY1PMccYRufQyRgRf%2FoCPCCuWus1AM6IZq1q%2Fl92Pjdk6x%2B8mMpaCc1UIUfij843Vn21WePUm%2F6gt0F8vkJpHP3vffKse6Is4gFXr7DCgwhhjaHttv5J30j41FQSoL6uBeojOLo%2BjBRCPJa%2BnYt1vF84lwwzyn8epHE3baxctxcsNYXRmM4LqNcIaLWsQ8bYtOERn%2Bj49tgZDtq81vWDOW8TqLfx0Knah1E5exE5IbNsd1E%2Fc3ClRlP83kISjupc4IMeQDsoXZpEC2w59BL7yfJvj9A56GHGMSocniSnwrvl7Kye7MYK9VmD4yRFqr81T0hzOsnA0WsXd0Ik2zBdIDZrrukPrLpVvD66cNnkYFG%2FlAJgXo3EVi7rsFpejgkFk2MFYwTyxq%2F%2B%2FfZPtlrDJJEg2G4QdirnUnoEWX3L8W73%2FqDB3abeATFyO964d96DtaWUZiQt7lT%2B%2BtQ6ju6qRVMvG9nxilr%2B8tZIdzNRUIg4UyuVWKQoizOwOKYjmUGUuRf5HHIEEBvSAu%2FyQsacYUgVOExE8VxvLTpKsZkIxVUL01WGEm1Daa2wxk1vZIEBGB%2F%2B2BvgOHwJiWQKpPCru8fAkZNBwHz%2FGZcAQiFVS7VGD%2BV1%2BQyyjz%2BGw%2FSLqrdF4Zajr24BKs6lV58g5LgKhiSd5LxiRSzk2P6p0pkyXyf8g%2BKl05SyIH0hpAu6Va4ZCUfvbIxrDrXhU%2BDioypSvDBdFIB0dC7x2PjlZeftNBmbyD3b7cXWhtkKwrjqp%2BR6iMM8A3geYWqOyyx%2FfZsF3PXKjjmeYVemXiJsSlVjzkijJTb7wDZtFD%2FMm4b7p3ooe5AvVfFaGVicgP57CBHwWxC67g7csCX2UMh3BoMHujkQhKGhDEUYkiTBSryRG73WHacU%2FpzDSsUvvYu0QzTFykmHxa3zfE2eyqqCrRtRXuzUjbaka8dQxjQMYh1v2Xb3%2Bw8jLW5UshtArg1WnWg2oHhZgtQvzreHvvf%2B%2F9xtPdlv%2F1FgqfBPa1%2BM10FHfAxPKS6D3ENZol9dkydWHO9wOYhbyPBCFHTXIXB3FuYAr2XvON5rRVuyuVr%2BMj1GybAEvNOhw5x%2FJwiBYXxF40WgnUgBA9nUTEmkFbiTDWqgzwV9pZPKGOEBQdjmSAiMfQ3xLGAXkp2KwM2g0BX9H1btwPhK%2FKTpC3PlpiPyBw%2BG4PLxWkcrSPTMohoZHN1gt4%2B0b3uKASCf5JCfSJFAjQGCZX2k4Zw2nik%2FJ%2BcbZr3J5iWexTv7cfw0Eks9qxeHptAFfbLFFLEV6YvMJR5w5Y%2Fz8oPeKcDLBPoltw1z%2FsDa4BQyKWLIhxU8lFBY34N50zlPzcbmAwiXQ44IJPC4JYNvRqgCZjRgfuymSjjNVHPFTnG5mrFLYn%2FOUvFHvpbZ6WCJ69NczZFedHqGggjG8sMHh%2BHX%2BV8L5CPW3okXpkBj4LlATSfgMb3E3qDyj77g2HTVuM%2BKyCsxmVwxKLlbjQjM8iJUfiIDJQUQ0CC9%2Bldfc6tC78I2dVZhEt9adHQ0n94JbNb%2B8hcP0QLznf18Y5woQdSwQA73eBjNz22yKzo%2FA7NefBS60o16mzVVbU08lI1mKX%2FG84Ihmu73m2Hq87SjDiIEcmqIxP51OJHs%2BkuhzmoJP1rWfI3rd%2BYuswzXAXO5qHOBDn7I%2Fu1Mz7EeOXom%2F9joMxKgClwVO3anoFZQVdUTIT7I12TdVkp4P%2BMaxbioSQcify2%2FOd0Chu27yUHLhmgRAJ%2B0vxrKLwrqBbfwHC9gfqP7ssjng1viTdTnA3S1A5nERVQ8ZUAJF5QzhCdl7jen5aXU30c9SiEAqO0UwEqfacazHaQCWjGZF6ZEvUNr0CCtlw8nFwN5OitucDSf6kJ3sw7pk%2Bv01eydjDkwME9jcAiD3RFVNGf2KYO1iPyfnN6y4Sbuj%2FdpDVwyMuo7Q4P3kKN04s0pWjtUUO7YKvsCbq4fr15XYugfUdKlhhBxxG3DINlqTUNVkhRZ1WxtXRpuNvTcN9jOYEUIEGle9FihkQNBJIjgVOg5KyaBHmrzqVwffPyTt7%2FXsTjlIHH1TmFJFChCq9RQ2buP%2FE4Zob6M7TxQMj%2FmQ8W7tD1FAu6onjA7dK9xFrthHcxXucLJ8wJt3QgvUTNtDFjXyaIAS6jz65kyKJdYumauBYMiKJt71%2FbpqJr7tj3GVnFGl%2F47sg7WaHXp5tqJ3fhGTKBLdl6r285jgfCMhWz94gDhonOkjQvho9%2F2JyG4uFGgIUSJ%2Fp7A5nT%2BzgCd5ud5UVd%2FDZXelFSBzZt4dkahlU%2B0sWJgIxymUxwuF8t6NHen2rn%2FS6eOnxSWcGZoZIboBhPS2J6dXpN0IzOnfEUj5uj2Nyf668WgZNJetn6%2BaES59%2BdoVIDErVzM8jVFbHYvguJttoBKivXkNa%2B3YlZfxfFfl5sfHPkNs0loAmAd%2FqTXH4i59XjvXPCSV%2FR073KHpdfNXzHBjXWiVqxehUl7NVolZAtFEHxbn7u3l4KolUd6C582R84PlLHGsxR61YpXOCAkzPSDqXQgp03t8%2FZu6dOjB4J1oQEs2WFsqd7HhNATQztADDMcZGvmmcsZIfiCd%2F2mAhWTiNzTRp9zkX8ibWI0CAWyl6nFyefujz87trxM8qewiv9W9n3u%2BQVd5I1CSgS2C5od2Js3X04jtV5uRTf0mAD9gYxUVnygc3u%2BZKRxxpHISqXrboJIDw71NkJ8M%2F7uHOc19ZtfIAwBiK4OTbNfsN6Yd0VKJ92WoZ98NHzEapEhHcSFpHyg5iBSxQBR0XXSdqant%2FEPcIci8KX%2FN%2F15fxOjVCQDdNN7yxIDvbfivq017zCgLPr6rgmRm6QGbTvfquIZaR3CBRihbn%2BnhZJIFlZhMn%2BwsAdOy8pR7Kq8VzZ6zM7qjHPyl9XXyc9jVSefwkzmKSSaa97VYoHVMHPbK704mphZ2SWJWLeGe%2FEGiteuxyqchMqWxeUqjiI8F8aSRbrjjw9zG3yyKlKaKsf3ziw27T69pI4wwey87RtHaZp%2FE4fi6euqlIW1taE9je9Ln6s6LIvqf70Z5%2BN%2B0BzPp5T6MqiICuHS4Rr3vrPsplcQoD9RBcQEaMjgUwxfB18puiLtLS6IdWH7261ci6LqikH0QFmaMmnyepGIMXRkTy%2B%2BrHkctXdQRMM5wAIzkopDZOw3gvgG4LmKdM9bx1C7gjsrdKfONs4t3Fe8pMSyocc4IATpPHo0vEoqifIZ5C4isLsx%2BKKzHu51Za3EE39NSjR%2ByuG5SBD5170uegGbjsDJheAavlUMi%2BKe%2B2N7PYTY1M%2BiHtf5Dt7BgiKUWydJ9IzogtTGlCL9hcM6v3Yh5h0pFBOS6wFxScVPRWWc6voBZxSFuFf4gGtxHT0Kg4WJ8yrYpctI8QBaOeHHOePF5JDT4ica%2FOwG0nf1RGJ5Cpb3zh8iZHtxWzXHko8hdf%2Fx7O9g6TuYKPR273PE0x7nX0Lj8B2e%2BbUbRDVPxiO2smruRlK0nRt5EZ2fxSejhyRdAZfXTdtcWXV6KGrVxljzwAcU1uv%2FMJjwfkaUOg%2BQDITIVhciTG54h41zXxyYbnLONoVC%2FgAv3dsiDddjdvkiz9kZuKI9dOqmS%2Bci%2FTfk8GsjlPgHfuKWZYDbDNQCa%2FPYD8ur0antAtCM95DYh4Qyas3ioFK3VfgUSRphBYn1MLJZytElocvWhOcpofr6MMlwVbDZE0D9SOCTRnuY5eTbdzXCpeReGs4fgSIMOiCT2DZY%2Bcjq24gYwgI%2Fd3aOkgwZgRW1cY6ZQ69PUcjNH8R0uscbqhQbtEdkLCcRz9Twtae8ZfZeJY4zBelaEE2dPecdOr7PsBF2ocVHa16WL1g%2FR9xUJxjOMmQsp%2BBhSEW56ZH1SEkhmAJEDjJH5pt09IC%2FLieJNpgmHBPneQmKbs3xnpvAAPvgVoyT254%2FVxryAyhjhqyBr7einAhZTkTngwbAdeWLXgo33xePSktwc8eFiQfvPydy6M7qrlJyk6o%2FeXfWFodYUH6%2Bct%2BHW7qP5iN%2BPInhwWiJZVpyAMjRqk1XE%2BHQ0qdl5RZVTJqQLEFPQlRxDla9ufc9eJv27%2BJtQayRZzUJwS6jsXL6PfIWnCuHAQ1gTlJvI%2FNCxFSpk0j2aagxhGDXfXUX3xb1eK4dbhaJpaZvn5plk6zzat4%2FDjYDAEHgvfBOjECKV4IJAngFZcmxUIAv2U9dMtKbEFu3%2FCrFMYpx3FrGvO9RkzN72wZVDpo5%2BxAOg01xoirAbciDWuzBe8TPR%2FpmXyfvewp6xzIlPci2a2%2BieoRT22Nr1TK%2Bc9KODigfZuQEd%2F1k4dWErkI%2FkNfkzW5TkA9zHFFSm%2FJBjIXtAyH1JtfD96uqjBu4msZuXTKfVbJhKhnHnzIK%2F87rZ7YQsUH%2FI5alrFh%2Bnql7cSIlJ1IEBz3tvSHd3IDyVleqW6vrp1LiOz%2Bl8y%2BA9J8bpp39Bzz48XoIBasw5smxLUzHlA4qa4myWfYjl6w4geXhXVcIEmneblKYAch%2BYrftYPzf7nQD8JsySr%2FxDj2acPh%2Bi7Yr%2FhZxUUw1xd6wgO1x3eVOLyy6Txxq4PkGrKU%2BlJVU6HCksH6XGBI2ZubEvDUOHfKAxTbn9mijFyn6TmIpPG%2BPyUwiuGOzABXl60aysIrGxnaHbCCtoo813D64Uftgfhw8jNWA6wpx5Mwqq9V%2BzVGw65gsLnzXKZmrzM4zSUS61WXd7OHekzXdbM2jW%2FYYZO7rK78JTsmz0CkzjKhMZMJyNMzo%2FwPleKFf2ylwl6mRhgRSxKshBunazuvupiFJBd4T6PHuHgQ1XSvZZdRAq%2FuVPVk9XEUtmepqGaUFgUY2wZsTZ%2Ba%2Bc2Uyz8zfFfilAR8r%2FqFoJBugLdoMh2TEOiiVGB04Y5KJoHZATCSljgMu7sxkj6nJSnehPho7PimOVuu32DMuPNWESpwf7JRxebDNy48WTub%2FFVu05906FJygwvPu6ZIDCd%2BUkDCL0fJlXV0QqvEOnBa5rU8Rkg3lC6t7gLp%2F5eTq%2BgC%2FySBzeE0hLrnfA1m9knuAMP3QsPZRT2ccZJY1G4WNSCrifYl2TJGfHVEPkx8tz1lO6nd5g4kzs7o3WgvjYK5w%2B5%2Fv4IAegrqkCZMf37qsc%2B0Xjuq0%2BG29X94RfRyBGRdt7HrIrcq8%2FT8uIBZpVBTJVrzL4gIRlM54WVyKw0nEWY02UQSP0nEXO8yOhOsT5TlpJAqGcVELkT9S1At5IXnshVFzOu0sR5Fhe0mUCAzYWnhMwsnrhVSS4bbj6YLEB%2BC80mFo5uWmpCyH5pkir839FFzlm5bt%2BMAsTj%2FtDVVgeQmMwQ29jPOpxn9gKciDJ55ZWXInFwKN10Ya8JHgjJIgucwslBY64x6nxGLsR%2BVm42JToGVvjIITIoW%2B5x9tj52w7OcIceGuy1wGBfmXmFxmMAPmfqie4YJEfltUaXzjb5VwRKram4O0d5fBvNOq0XF4E4fSHQ7hIFZEmlhgi8NsAuUENiuZXtO%2BEZIySwUizxEwZveI2jUAbIYNC%2FzpblwP1bjksV%2BEEfzopogivElQEw%2BJVyVwFulDyIMP9u0T9dWIWiwpexkiUj3SP6BMGgpBZPOZu0z0hR%2BeX765YeKaij6Zng3m26iiq1hqSrlCjbESUUJppolZFtOlM3LlSe3YVP70m23e1xpSJVYYMqZts4QiS9U96bdEePZRs4XUw%2FuA6zQaCOtZ%2BqMMmu70%2F90IYynzeo0TY2b8%2BHpWtagRoLoMHQpp6BSN6d8aqBF8nkmB%2F134D%2BGK4Mg4fwy%2B4U%2FkF17BVi4q2txdEt2wgkP1BNYHYdYITTztO3fHWoyNOo2iltQJ8NyuaNT1pNp%2F6t7tXc3L2pznGt4rDc4n%2Frs%2BWeeWHq1fExdtvqB7E6XS%2BOWenvJCgdr0A3HV60lO3y0wi349HDLpXoJA%2FgcS6pWz66b4%2FCI8S%2FeK4irOVIEmXhySl7NxoZ3TXBUdEi8%2FRyG%2BS0c30etVKoPhKSjjkRRnlxiRQlec4%2Bk4h%2B8IPsFVFJXVhdkdi5jGSygXddvuI5RKDTZ%2FsDZ7Bt4FYOOeNHMVfzHa0AeY7wqQnvHj878%2BW7Bq3GLudZeVn4jAOBwdVUDNwGv%2B1yIzh76fY8%2F0FXiceQ4sWTyRC7YhHZW5nXAGGXyCjn2KFixIqYPaavex5BcdWulFyjqbav%2F71FE2urBCxMMXhnq%2FZSF90mVy0ekMZZy3Zs4KhbM2UYnAc7J3ovtmW4ghaNlKFEiBLZWEuqndizVB6XOhbDOhq7OQ78dV9%2Btzqk%2FDaeJJAdTcFWw6A%2FQlWhF3xDzdUOmdvPO0%2BH%2F4v5kmPbE2vMefIvj1VP8LUN1pMT8cmXY0Kr%2Fc9OZG9LjQRWOhGplh8ThD%2FTX%2BsKXOa1nqrPqV2KvjyqPCVZQ67XR20AZKIGe6zSLfhDJrmMYdDhbUwrFL9KjA5b6nBFTaeDa4VpGq0aJd04jlIxNSaEwAi08KQvae21M%2Bk%2F1LzNiekugQxv6F%2BjzXOjN8Eeno7OUej3BpzoPzj43JpvOdAaYNJuZI5ByxQsr3atYf1K5e8VsrX4zGn0DieuDfkGLdhvy6qgXW3Ad6aeZiiPC%2Bkiwi1e1cAs1Z5%2F9DI0Qlui2rxXiZGhEWurvob4Wwxty4itaLFOYpWk6q4M6G4q4o6hLI0ddrTNsut0WGQzP0EAk0Hyq8mHZz4hN7B7BMyPZwt8b7IR1syL545j0x%2FEp6KOnDcq209Vo0hQM1kdgNheealkwWYffYuYoWJUKPrJgA31div3YfEKymVl8NSUW2uYsp%2F9nlzTvjiB7%2F8fSvu4PFVJrQmKfmBdOvRh8SehwGeZWHrbGbn2XR7FaVcv6ZbWxoecIJX6430f4CK1dFcp48Mfroyv5V4%2BfzpKiEhGR8eNXMSdROnS5dMy3E%2FQi1Ixu%2F8XAmSJYSnXgBSHnZf1nXaqwUkWE4pzs8YYV1rc5XZTmH1hVC1s2yPZOWw5ZtjeWemyq0bpPg3mxav%2BJGL%2BYj66hS2YzL%2F0Jf8XvcoxuTw3T1mYggj27pVS0Qv6anqyhJ67SUJSxVN6uo0mbIeJDqMKjcpz%2F4iucaiCiUms0smCi%2BX6SnrN1wns2Xnx%2F%2BSaCmSd4DTOZvQyjbV0cPeHDFRzPkMgkjztBYnrg%2BZ3HSc%2BVTHCl0fBrlBif%2Fe3x%2FvrBAg5p2t6aNQvX1scnC4caXeG2tETnANY%2FACliTsvuPGNo59%2BztmFIg%2FF3U1olNP3I1y4LYOMutkXbVlMcyKgU2bCeBmo%2Bug7f2iB4jnKgU7manmIZz2x%2BfQLcYkwOxTMlJDICpkNUCFyCMofMIc4do5MPNXowz4hlFfdcA%2BYSO6lFnaJtuaIrv8eSHWXsoU57gVzCWIax3D%2FW%2FZ4LY9x0u0o1naXSMoLp2KT8967mGmKfqs8Ki6GPCOd6K0X1RDK5uyhqkyBkJlBPWfYb%2FowmafpmX7rBxu3fj7ay7Zm8xkClb2ZvZoK9pDFS0Ynqg6Qi9pNR21PeTtS3YwtnCqeqrvcl7Sj6SlpRA77M7qKHCw8jhjS%2FOEruZ2cYvHXCcOvoO8bqkxccA84smp7zRV6S8Ktv%2Bx61dnUZuhkq43GO9k0%2BkwBmtFHRZQK70GQJx%2FKsS7vue%2FBMAA%2BqBJWJbQJZ%2FDrKOW74rv4FrW%2Feb%2FjrstFl3ksJPQqnrgFbcGL5ES3i2ESdrF7u5ILPn9EsvmDv%2Ftmgl49oxJMEAlDDYmN3PTX0ApwcgNJ7t22CIX1L%2BpouU7In5GXnt5PiKekc0JV09bltJCP%2FncIl9ObseVoO0p5m%2BVOXMCqeh9%2Fwm5lURCgC3A7RVTS62GVFJM1bmXqSo5crNe%2B794pSOBoMLudgU%2Fy5bel7d1jfPdQT1DEvOIGn7jxAy4uG6o0LBylQ4qsDK3OPt4PUBTh%2Bzq%2BR5Yxe2APu320rAuvHGBUUkRxa7q7CQE7sw%2Bh30YLbZIPLEjtYcq%2BJ2A6eZXVRcn8Pi2Rfj8od4c9m2mpfTx%2BKRUSk1J69XnMStHu4QymOCDV5BEQglIj5CUhGF2biCYLzbZrHXhaQVCxuMZs03E11JHUK7OBaoDPfrU75OyziUCqqQ477kZziunKxrh5VSCayauq2JdXnZBaC3FkoCXOg1tlAeEpHWOnYMMnSvWw8blw721qiccGLZ8iqBEJeXK6SftnxTJDJ17MiO%2BUmbqO1Qw7E2e9YfkT1XmIhqef77CFGUdWNwIMYj3d5QJZU6NGQtCIvnqOrxjJVSk%2FEyLfUmtGL7FaiFQC0mcLbQa6IgtNWAnkWEJ%2F5To1Kj7Qp%2BqQTtb0xHf7YDfsxmSzVDbaZmY0bM7wHNuCGe3uYtlAVvYqqbBoISHASiqYnmDOPPyZ%2F7klrMsTp3QiCXHOOLInuNfJt8iaTaUH8Esv0aDXBCCLJcFMNRqbo64uuwQZslo59daQWmYPVmUzghS%2F0szz6rqy7vKLkidrnd81E5Dus46JetdwetZpIhLofp7rLzfQZs0eslxsEeANF3mcLVO0oFRO58pEIn%2FOb%2BN8otDvSBIdoPfhsbu60%2BhoDZG75B%2F6Rf1SzTjkfLnRV55pp7HE1GANd70egd3bBRswi41QOS8AU16ZJeLx8cZ573g1Ro8xguSLDAwnJjInd74AE%2Ffwnt%2BfhmzRvmOxOnmLslO8TBIouMQaBuCiNfxlFravN6Ye0tFiXsRxlfSI%2BPneOoQNO51gxA4rYIWL8Kjf%2FJRcTR9ahovCK4tFCziDzlA7vtQhf9MlXxwyZyzlLksrssy%2BsCkvh%2Fn9xuUIy2iJqU%2FgayBoo0ChFxWwK7zDgqi52URW9d0cw5l4BsZiBHkVT1mYK12Geu4lX4tvv7X9aFIORfnCbiWdU9eeMqr0UNabhUn1rlJ2H6vUQE15970VXJFLpydG35%2FL8L7jGBMj6yMkExG1M1Yln%2FeBD3p3YZxc2L186WZdblUhtaA1y%2BLMG0gk91Di%2FKmJtLN2Tn%2BJ6RtANuo8za2Ai%2BD6zgwC9GCCPcnbXWgNSy6axQ%2FcsLzB6RbdG6XyqAiy3uMmt2sHVV%2Bl555BHuH4KUAjq3Bkt4rOxqOVglaDkhl4Lr75NYYjDMmO8rrj%2FPAlmrQlKFss11kg%2B4Vm5X%2Brrjz8LcUjRkkfvAz8FBRb7TlOuMafaijvuuhBrRgZ68kz8ZX2UUKKpm0ePYWVK629hAv4ojGp%2Bem3c3TPJdMJ94hGMXjyHzpaMmLYINYDo%2BIu3zWsH%2FYBgPVJFIjuSSYLVyzank3RctseL7jz5w4CbiA9Gy6q%2FRDvKmKg9F%2BJBObp5q92ZIsgh0R1TiEx1zjeAhhBLjK38wWvMFVzxGDnt%2FujnE2jNT0T%2BTXom5CgkVhD%2BwHF0Eg%2F44aTsgYIN2jwH%2FmVV%2Bn3M9ER9ggko8gKrM4UKApsrp2Ax7FOhHXdbxPEFoDFNBX6Rh2uAOtNq9Hn4%2BtVcIELn5YV3AS0p7t47RfwdLIz0e4skrr8mpol%2B0vp%2Bedr5vxVT3VGqVh3yfx46ko6gKBe1eF7DkoCa4UtUDT47mS3Jag7zQHvEMW00yIz06HU6BaBKvudtdzxkxrY%2B%2FyL7Pm0JSD3ZYH0oFAFLN1ZVniwvKup%2FmKpcz37wupmfU%2FPW7nhsLFARpBI%2F9vEPyjmjV%2FngVmkzXGlB%2FjugBchzysRQIZeQv0N4p70LDZmKimjK7E3M%2BwSquGJZYdFeW8pk5c9sCdEZMv%2B4px%2BS8o1LU3IdlTigmvjfNkp9rzIZnTCldK9jg5Me26IkhnrEkTxIUGUIi9B61JVgnYqhw7OjjaD7OS5N2TQV40OA0NYNF6faDGy9xjltIkHsN4tBehLFV8cWgihT4UcQDAUyzkaGk2Yq2PyXqkjrqE2dE8ns2ozVpkt2qI%2FGn7e1YOJVOjWdHVTG2KYSpeRsWuvFPL157g%2Fr%2BSXaNZm0tYVrN2qyUAaME2golr71Tfw68%2BfvMS7Wne46Q4DtxLoSVDbOWGM1KvF7ReLWW9IX8CEyg2AnGKsxdn8rG7GaHK1joTJUTuwEAKSJ1Z8vsUdFgni1lGhq2Y5RdK2YToDUboIMA%2Bg1Fk1v70GgIR%2F2BIsxwShg%2FVnUnHHQkCLVSrezvNbul7vTtulheEXq6CH0AEYIJuYSOET13uaLVSFT5m03AUxGk2GniwqYBWRZwMskt%2BrFDhLCk2HK%2BF4vI77429ECE0ybug5H04%2FVm3M9y6flkev52PV9EAiypVE8Ot758eo4PDbz21XjNBP2edeMKrLrZN5lPIDem3YNLzzoOq7%2BOUYGzVrSKd%2FwwAwMZ4Eb6sxX55LAtdiQfREqcf3mW1zKBNzHyaXId1kDt3d7jCSryPr7rn97f7aKwhAhu0AEGtm9wR0jZwQzg6MXyNY9%2BBxrIvXRL5%2FPSdIxzEE49sZIgXaPrmboVe8tCl%2Fr9CujCfRwGFwf5aTCVGifworYQhV7zQK1EnvyEV9dVX6gzq1hAI%2Fbf9G6lGPJMpUOeoo%2Fo%2FfIMZ0Nf%2F5XGD8Zap0t9H%2FqiWlP6RoZTMApa5yL%2BzHo4p4KT5%2BapadReaG7nnRwyb5DIad3doJH1EUi%2FjwGfNGjrBfdm0Tih6D1ephTpTekRVyc4VPP985aCmpx416Y0DYCCW8X27d0ZHEvFu9boa7517OkL88T6SKwn0Vbkqx1u6LwMfOFRY5%2FoPSBNlV%2Bmq5H3VwMe7URvHVmAgcwe9DSy4r4XlRGH4R5eKMklWVZoymkCbJ%2BhlBwpltW7W%2BOWNt0yrovSvwEslQ9wu0sxMOGbczpwoJKOuEWU82gH6d3OtK8R4usUk7KE00bS9GnK4O58FKQvwliXV8aYpmJ8166040troujjVQXGWcA9ynSf14gp5q5ZYunMWEVNKthXTgykzVb2Twd27iaN0yw0M%2BpUoDeOEdRbenV%2BwHGSLQ%2BxDPMLREaYtmbhRYbJ0kN99XlgcrHNjlGLN4J1EAqFg%2FJ16neFcqg1u%2FXg3iNAx%2F5e9QJI8%2FFbhqc1GomTs29ryyqx2HOrbQzXpBYul6qNn8bIz5eqfT5KTU3fMz0grVrkYIV0XcIhFiDSgmkMt0GWgeoJaHWMcK3LNlXE5ImBSbQJfWyucOtElrc5sC2tMyTy7d6nluQy0M4jaiJFn0TZPzb6oGQNB6z9s1JQiuLkxMUcTfmcK8%2FTDbUiFI%2BdsWGvTqPPqAT7DTIwgKKG9RAeqv%2B4oCj5ohuX3q0JL6lD%2BWvjA1I17weM9P%2FIQA%2FEsrPIO6qgyBZRoSnVPYwRugItdNFn9XN6%2F554Ij6ZPlQcpCW70ETba4Dt%2BE84cVviIa1jIQ1wGEQfcWq9hFXirXS6euHVjSE3RUXyYIoCIgxOTBjbQRnxOmn8PHRogYkk4RoesBqS1TQ%2B7v485vbppVEkA4upQ0tZ9lOXZsQmd5jz8Fk5jf%2Fb17kIeDyXvsG%2B%2BY1TdHkRQ3w4913Kou2lL2wzJo0OXbnjF1c2kwbrKxl8whlANZaL3CaVM4jwocpuxHEbLQ7Wjg3FzJCX8SQxM1TmBSHFgZGkMV1ggM8oHtw2j%2BsvOWlMmTkFhuxZUP4oRUdNK6PiSX%2Fm20YvnNPQEzIgfS5FmW13iOpkFvItkYkHi3Av7G8Tb6pwGgz6p9qzNYQFg4XsxFGUOZi1QxYivh794W1RV6VF5BuwyOqQoszZk81WjYIBP%2FMoLNG06PU%2Bkjgq4iRz%2FcW8Ne1zz0oIEQ0h8IsbPvbqvghNgheILPKUcnNz41vPHICiIt0u18i1xCujSQv2dLBmbifUHtvFVW4tMrUoGkj4KwZwPTb33VU%2BFdf%2BElLrbuXgSMtYiYOYAPSbYabe1fiKT5lMrOJuEBw8zVNmAqr2U6h90MPm%2FWPe0J4%2BSmpCkCjbxmu%2BDL8kgEpiINn3MTZZmQPqhd4v22jOp5BdIVAKkPCtzlgZ%2BWsMTH1fzbPA1vPhJKrJgVt5BUS%2B%2BY7vLeG1aOXCay0K71NmwzFNOFW%2FtLWo7oEVsrCzBCq8b7RNk42IjRBDadUDZjQwS14UowsQJp8IpQDJ%2F27HgYahe4%2BSMajKC4JfWVIjl3xSrLPhVb1u0f7TTccLEzDtvbh66J6XNecFgSQgDFgT2J39iwFnP6ZTkd8nDA91aI1%2FpQVI%2FMVqqAv3nQnI00gdWlSLy42lJoybXquYT8xOpr54x91lv8cmgwQJ4bYERKuxnRAabZrke2LDIgtORSxExNGVKunPe482cptC6r0Ix80AdfFa7sX%2FS7iQ0raaoSMMc3ChcTi4p6qHXLR%2BAg5%2BAQtdeNC6nbdF%2FLzNrTi2%2FqZRdZwVdcrMtI7pq0EO4Tjm7ONlXjD9yzPcjZ0s0P%2F9lKYR1YuZiAtM2Vr2TpseNrWkbRnYtlM53hn0I6zlXv5PU8tctdFfVKnrdNzVhetn9DLTGtDooLVxVxrqGRVcMmWiUow1RVixWNcNo8cr0giMJO57GPZ%2FePBcUK4JEOcTrhN0Qld%2BZVXJUxx%2F%2BO1cm2gXCjewPlMGFgcQRXs4TbJdy2z7XPgd6kfnU0q%2FCRU%2ByomFT2uE%2FpYFk0qMeVyciWOv7umd12lj%2FzXmPFMilFhM82eVBZuSqJOD8D1Bs5NHt2PDE2KttYfAd5D2evNLT8ryVZLpv%2BhNniwGpB4JvV%2FQJjILe5zp4EMRNHMgfMEpLdTrZGkEbnyMNkwdzVktnnilqHnM8JKOetHk5sfgvI%2FMAcigPhaJDvW4ScrugFysL2o782a%2Bd86dUVAyJ2R571sR1G1WD43EjTGfqagKPGyzWyJDHXd%2BUANlLosbdqqzJw1UWLKq9IBDZIBIucxAwdpV65BU%2Bf4ZhYrQMOV%2FrO4qD5N6bxsmFM0EDhcBQcMJLZyS5CwYUjWq7cq%2FnzHQMXs%2BmaPMtsD3qiGrdbeYr49SeuRqTfxPYrYaxv3AOjCJM6%2Bo3ly%2BzKpkJqCivh7TcQwXMAo%2BCFKuJZvFWouHZHdse2mknbMk%2BleKF%2FKR%2FXybTxN4U7g8VrcuMNM4smjaFdPGoTcnTWldn%2BbrjhD7K0VpA6J9%2BZa4xaA9%2F5kem3aU6eO9IFtXOxhrcdJDB2tz7b%2BFb5Ayu%2FxIhHYqv6tbf4cZcfkFwp%2FYc9ljwm2nfnWnXgE%2Btsqt1QoEyz%2BnMAog8%2BH9pU2NZD3x31Y69PbImYcl9F2ZQiOR4miakUKoJDKXN%2F%2FM0AC3TPXi9LOUce9hxdQLzsxcQDr0WgfgGe%2BKW0NrB06gxfQ1qVJulQ2BxIELTHEMQK%2BCkZecCsram0YIA6bndLWIqJpz3zQYdQUXitfvdzfKAbrb7Ft6ZskW8UN5cHLTvUUnyvdwrvXrC7fPkNM4sV0JppsO%2BHyTO7sUzRhWZorEW5aDqvXlTHB%2BHSx%2FoRSTd09OXeXs%2BlnFGNt3cIgnNnzXLr3tCLG%2BMLaA4LDsIBvWagRO5s1lWTaLyteU7jo2x4vPRwTVaUMJqL00GP4V19L%2FjOVPfnmOofCJ49Np9%2BJIR2nZgceP15GuGIuNsvu3G7p0YiN2C3wmKLUFjzEkR6fuiah08Q%2F4fUM2X8oFysBSA1%2Fl3u4sUeEDtVYWfYpjNVspJgzaN0X3KuEjCjcWfmyHqeWqMcSA438cLwalcg5Flzwr8nhEbRa2lOb4WKTvSB%2FaMWl5pvMtgSGgz9MOxzWFYJA3wQbc8VJ1rahsSLYiaEHUbh1agzCfMH4f0o96gXsDP63BmRXmlqZWmu2zH22Ivd2j4J%2B6AGGgLXSVI%2Fi9hx5XLVDeMrJzs3STG7kqGCs2md7DzHw%2B1Kz21fGnn9urXVOqCfL%2B1jqg3Qd7GefXf8JEww3P7K%2FzbC26YobaO5VTs55bgYS%2FNJ7qSd6mlv2fThWqAsNNdPze4UChNzY8LjdDu78KdNY%2B36Kw1ch3QQGYkYDuQ1SUUCY53h8SRwvu3vI7iMX6zazG0Xu9Xc81t%2FXhTtCphhwbd4mwXVLBZhphdoBdNcMx2rXIsG%2BCnvbM1%2BDbdnZuss2sIo%2FT4DhOptWjaGZfskNfrrczC4NfninFvT22uKsZC9qDgo6h4Ely0tGYv6PUaBKx9ApIyv7xsc0%2BYLspITDWfjijNzDbgQwCd%2BgwLOvdVRk4tnRAxP9F8UXmomueCVxqZMmgHXQP1trf6YznL2UxYKwrP9AcptwbxIlHrfsWBdSbTTTtmykZICvUy39eE4i7iL5twqNrdrTSdp5ozCjBM15FiwxW8ELSIB8j2u7HFgQ%2B2lJCI9EYMCJKccipOFlck0SgApy6lDawubdMwvbeX%2BCsc9k37Woe1xa62jJjbg%2FDOyZZwQcwSbwKWRw3LQBd66TD%2FYHPV4Op3xfXncZlZGuQ0DXabCwjlzMMyDe8BJXN1VziaUWWFAZ3q9Ks6YgC6nJKa4dXnxXQgQM98TOPksG%2FHChiIseWbB5%2FD4GobBqnaMPtjJP%2FX5cFr%2BBNUcwsj8cuffiIsuLvwsnEVwwMMFdH6axQLadzE6OY4O%2BmhAkLdbLKWaY4GrKYFAHWDsZRnEyxZWNQhP0TC1BVjIssgQai%2FEu2jpb4A%2Fl9H6r7eNGsZMWiGcksW7jVmved4hwZg%2BIumHLvRNqrg92uxqsnABNvMcK7W%2BjBRqr7g%2B7tRFwEnpBMKEMZ7hr9Y6cuhssNYg3VUNDQhD3dhgjzUZ1bsS%2BWRaQ81%2BLz%2Bbsu50dMDk9RZJfpvkYxk1zGXL66A40SClyPnqXWj0G4gm1C6KSjG0rqVP6pyfR79vMwOx5lz%2BAZOuLDKfKZIzcrnrKGQKup4DONE9%2BmZSl%2BFqmsPhgeAR1VYATRFcd2Mgjzr2MaOxbT2qf%2BMHhYLsn%2BCyVy4DvT2yFFAbvqmGp4THM0eVlDm6e82TjRKXvyDGsNlaMar6L16zHPEwG5tDyzkOAsNXjr0leXMNIyo2I7hjRD%2FY5oLqwOK6cV0%2BxTelOm%2Bnw%2BxAPgBLbeayRcdxmfiy9PwzkW%2F4VB%2BkqKiOLAdG40OJylXOWi%2FZG1tWlAJ5Ychz8KA5IO8slf%2BSoRpX1YmynVk6ce6ArXH5KliuV1vFCRI7Yh7eyjiC8qqUXBM7si16zTb8bVL58zn%2FtxeENJaJnY07xv%2B9%2BnJQpICwINhebqrduyI%2B0SQ0Q2m7Oq5qOOKRjmu8ZOPo5K9LJ70%2BLGNI8tj7enUb44EqVldrlaYJ4mtL2vjzXGNdNUqrh2x%2BFGOMyEb8j2uVs%2BuoPuPUzC0xE4EE2k6%2Fg1%2F1A3fUK%2BsGSu9KCFhld%2B7lzjk6vo3BHrXTYxQmXjb%2F5o6Ri4Vwovul%2FEk9cAMjDqpWieU4bipB0jWmAn40ERZ1LNVlqfrQ7LgdbGVES46C7HAn%2Bd9ZUaiu84wKitZU2p3SSslCNGEUyjBRR7ETpWisbAAZxcll92tvPIT06%2FfYdtAp0IO%2FzJYG0Iz2Mkkwj6zKPy0D0ec2MU8gVDznP8P1P7xG%2BZjXmFNQGHw65gbjEureqbr%2FYzsZgvxLHMXKJ2uzUNlOqqtyLLCgDNik%2FubClUALqVFP94nM689XueBYy1SI4WjqO3NX4BFm3Q4oC5jLJCUgA2Y2R2ZX2XAtum4IOp9MKPhk0nF%2Fidi1fcpAeUExQQp1iCDXsm8zUpBSbnYDjQKDAoE7YHBCeXdvSXuFHuqNkHjAvN2SuhqDxxnTVHpq5Uj%2F0zW17DmFbNTxe2LOKLTYvm9nOcqly6Yzi5M5mwSbBAov9Vg%2B7HoIPPhYBm7pl3E7g9577KJ78fAlbg1MYnRos%2B8%2FZMhmTuvYeWf1xFrMiSMZZvGFWBHkO6pY8LpHnZuaV1l2jgWoRL5Tq5uNm1L%2FtmGgMbGVPu93UOBmDxpmya%2FB08rV7W4%2BasNxtHVEQQucvfgf%2Bx56%2BaUwqvbO5VZ3D6ERLkAPewSeQaKs0Aco8jsXxQcuBj8RqLSdyyui0tgUUpdPj73zy82PqZpB5czfUI8wHLvCZDci345nTNavGsymQwjIGsc75v1p4pJWMdM%2BmKD1TxgeAjX6dkJZ70M0WWRWredOCqsAO1fjWKCwWLNCZa05cEMN8dNyg6NT8Rbi1U2yldFsyQ65K5qqN%2FKt%2FzSS47i%2BdGhaCsKXJ1h3YKOUO2xJnfKqiVkin9uxN%2FSFUd4mODyusY6wniimtXYnPimepe9MRZy0%2BpSCq6kUe3prQolSoBnYuHbODTgCqMGFnQXR9%2B4XEiVCe5J%2BW2oBCkOLvDkaoeG8Lk4N9uXKIuP8TaVf5KQPxHnElsaFo6FYPEonYeHAmqvx71wJOwoCgqU6mFxE3m0Pyt4mVZQ%2FC%2FktqV41k%2BvuV8%2BOQI%2BAZ%2BU9OeNCcT1CmmJ6r5Btxu0o6YJRDWJZks60%2FO5arhzeX%2BO6YCHvuOLKTSH2wretz8qxzwhierMCvqFOqbupZpY2ENnhcN8Wg3Qv7o3k9bYnwN2aAVfwrkeoru99bSr%2Bx9fuoFQHi2lCobO0DVYg4lUucJK%2BhQrizEs5ySIqO9Bspn%2FtzXFyijW9Kes998PZ2%2F5xieNpzlxfqO0VFRgyba4o4xaanhpBgllrHqAvavSyqPwhP8CM9xhry9iDqnS4lJIMG6wNlicbg4gaR24wgd7OtgKT28OPSMjitqBDe89LgXWEfKo%2BYIaCahc4Ag1jja%2BvMlQ%2FHVkUYP1Qa6O31reGj10hk0WV8ZWrrsIdR%2BsTyRlQCDWI873rGJage7H%2FmVf2%2Fi8cv9JGZsIu2p%2BMt26gnH15EdwaaJYB1%2F4iIPoxvhW1%2BVgTkMDzPUz70vMTaMIrwuwAXNOyglgztV%2F6w7ghxFHpOERdp2QViezEyaH2aZ6Yrn1Neleyh8yaZM4tpkUTTArLZ6c%2BPnH1H%2BGyNQH%2F9yCN6xGbwcgHcZxGuxgDzYHqVHrwvCmI9P0tZIDLFkCqb9hRd%2FhxdiIp47HQeNbo2Xl%2BFfWIudo5tayUvikcJvFwmXRJjfwoKgoWY5MvGFZqUOrT%2Frm5vSiDd9fOBA20pUv8p12fWvPA1XtJUXC9q6P3C0SEFWeB0sFbJPmvJKNZNgCTGfAYA36JRI3DaLA7AkfLNzwV4pmzs6v6TfNYvp7cqzOFcCVR4ElejjF5VfzMEMmaltUGdi4YMnrUGAhz1ameP4jo2r9OrSN9ypM8kqoHkAUZQo6tXhfKKDVGRI19Qlio35nSWnHXNCpvjiB54TOOY%2BAPHR6p12BfivhcwN1KpaKep3wisHmRkbQdX2jlVSlwvn1iNKYJXAD5OUjZbjUOvLe3tq5C6aQyKDdz6TLxA1wHU72W5M5gHovnsOYRt7k5VWq3QDV7TZHHa445xWPR5ufjhBu01GwB%2BbGHIkqnVVgVQlD8FaETDuQnudNi0H%2B4q%2B1htgfKSTfzGjZfhww9jm14O8Eh2Ni%2FwMFfKEMV2bGGj%2B3Vt464C72H2d%2FmhtTjJMWk4PbUMbQ3msbVC4F4fRpvc8fOv3IXcCEW%2Boigdi%2FTfq6tjA%2Fn6y4QA%2FF0pGt0LPWsoFZJYdW8kvt5gBFiJCbmdNGWpsybdbNSJ8v3uPoeayPGRvz7TX%2BiohAuhk44fL3h44TtnMSUCuAi1igZDhzgyXn0qd6F0juMYAmVOl9MCN9ITlG4ybnPya7XM8tYLpY4eQbKNtmd1%2Fe0u96bs6sU9cw2z4t6INeWsZWOE6MnrxYRalieWXBQVOUm7oEX4dfaVoBSRh6btJf5YxjRxzfu8PuSpzeOncyVeSOFZeSY%2BR7SlVN0x4izZLShv%2FArLMdBHMDAnlME%2FiLHQ9LmFUj2EPuwQkEtgnzjPQELQV2li2OiOmpc7cPPaYfxu7rkD5lSVgml0mjQ7cFn1nGywden1QmM5eg6PeDY6Qkw90axFOgpx7VEXOpPRg%2FGU8BW4uhNaTXJpaVl7emqsBxjnDj318Ulos0iHoClEMI%2FWnIEZTtxWEWJFiC1jWgWDhS5mdgdGTQv7jCg1NKaEJ5k8CK99vnP0knnMNjIOIlpBvuNAk515WiYYGjlyj6zc0Z5Bm%2FzoqtB8iX5mYek5dc8ESQFOKTyyCdqrPSk%2F4qTLM7TLQhPEGk4lQTeZuCcEkuNFuXgT%2BMZ77isoeXXXIfSXhJbhzHuFkGgzhemVjWr9y9C7K0k0jVUDUZJY9wbf8t8l54OUrpAWl7Z3UjgHCnVyVwj6J1SyzL8tRqCORUsiB%2FT%2BnzfzA6Ca4EjGMkOZCJE7r3jRVltvBKr44vq%2Fgrq3Ah41SEkMvb3jIOvhoMsIssFRDbzQmX24Dn74SzjCXYRn6Qi5039ZzFO6%2BPgbSJttGrNq3xIAbnOyuIxmSeyMlCRAh%2BRI%2BTYaKdH2%2FBvTRwMJTPo9uF%2BXH%2FXwYpnofRdvmsgzcrcdlnWJrA80KpsRJTmjaZH1wQW4jcRghp7SO%2FeDd456uXtwbi9pEeQUYpibF%2BdK38BBV6R%2BTuvqCZjFDykMEs7LPN%2B5AFFYs%2FOVEVfsSEIoAs8sdh%2FyrRG0e4f9cQhfeHoX%2Br6EPz0i5omkI%2BNeg7QIEAdoHz0GH7eLfgdpQZbCDdMcIxA1vFw7eP1fhht6ryFNH9GHKFSpgwvU4il14camZNYgnTJRKnrnTOIiYMStE7Js5162P2kFdqTbSFuzrdIKXeZ%2Bd%2BJsNaNzdd5%2FhPzRmG93UmCNuyK%2BQ84rHoM54QhuOcorTpQE85mzk14WUNvvfLdxlEsinkYahjPY23N5c4VprwlbcszA4zpERuRptUJ85ka6THHPgmXxLoHmBdCVygLQn8WjgxrW0RJw%2ByTKbZia47n%2FQ4wZ0oCtypgMdUC6huqRPkc%2FPEvLelpOM9TipU8SSRKasJ5VNp86dtg3ixA0Tj%2Ft6QU8%2B6OgRaRDoqucX2mEKMzZr9Mg2r18122td2bS%2F3LYCDd00yNu9Pv%2FUd6ob%2FofdqnVuBWoF6t6JjEtVoHNycVTDh%2FC9vslZwG2f2ZrqauQAb1DNIbGO%2Betc8ND1b%2F3ZqqMdG0Ue6a9Al9WUWNlHZtc05xmXeRr29HBpIXmMjqVZS%2FnIGpYiUaXAg33%2BgpcOJqjum5OTTY1JgIf0p5hYFRA4OqMlbYWw7nyjPVLi5aFd4VUUKklcZ6BDEX8rwH83pQTclbaxdiKORYOAGDj%2BHX38TEFV2%2FhYCQx0%2BOzpPjchTZ%2BK3AVS3CoUF%2B0HFPXDJ1gVz1lmp%2F%2F5UI2XXfyHxliTJCrWxuQGiAG82bY%2FQtGMnyOYI4poYMirWdTcE9o%2FFXdjXQrUCeC%2FEdWbPkRGG%2BhxACZpgMTIzrRUp9cHfSlPS24bF1cV1aJr1GnQgYnkKh5wPvp3yz%2FFI2wATo8pPvRJoND06yNt3Y7ChkTob8RVDzqi%2BXmDngtYWCt7fWcgoFpEyRgOIy4aeUCmd7F%2BIO6GAnEQUsqxtgRzmaDE6NBq2IIPrwfFqa3gG%2BzhjDoseAeizRl%2FfmY8lucKxgAaIf4M2nLmJmkT0clrQIgf2RFdedLsWJUI9LHTWr3WT5Xmra4XFv5osfyXj6zSgQ2kMJGm0ZmSOEveq85rj3sqPon7fbfLCFBL1%2FJ9s0AlRZvquyfB%2F7fi579aSQRCUiHsmUSbDAUSWs%2B89tLykijmky3TnINBqirnbXrWNz5rcNydfpJD%2FeTa628Al2JHGgbLFjPfgRf6jA5kgt3Eo%2FWMN1JiZRtq9%2FV%2FmvEbnALnW94vWvZzWkYF7j%2BY3m8bCHk4cJbBOwFIcgRogD2EkYLsMXMwlgePmARJraX%2FqC2%2B7Mni%2BsJF4h9%2BmTUIxiIJzJgFPfLwLk1gfpoGl9KJ3%2FdjGlMU5eP5V0JzcV%2BNMrc%2BFwyslQccQdto%2BErNZK3qv%2FS0v4FjvRBBHfFAo5h%2F8JPUoKzJe9kV5Tmnd30pB0l%2F8M7HZN%2BM0uYVZeaWKT7hrCqbi1iqGyc%2B3tcOqh30iNds9xfotrhaag8N4u2ZkrD10h%2BASP11NL%2BtS%2FV0ne5AivV5XD0a6MHmJX3TnXEQpRuLR8cx0Rp6YgR7xAD%2BXcokoJPIpANWbw9kuV95kVQxVfvKALygYMWWdGL41kkvk4Q%2BKXXLfRhZXn39tb%2Fsw63OeW%2FhxyUGnMwbxRQfh7w5lQIOuMOpDivSqOzDtK8B1l2h%2B%2B4yCpOeor7lDqVATBJ7o1IBqtMYNWwYVC6mkifpicNX3e8H58OodOc0qRQR%2F5JHyStKLCnZgAuPyJWRH39GFODtNYTBnx4Lw94qsKISmEB5%2Bw8PP18I%2B8dyCoYUbcI7tt3VuQxTHMk3H7t%2F6U11GqDwumL4QhpsY1OY7ULSGOVuefm%2BJ6VkdT%2BjXGQ%2BY4J1t16PSfAoz0m7JYeOi8ruSxyb8pJCnZkxHE8HQJasE%2FhxuBGLJo6mhhactWVjc50bFCG%2BvX3iK91YAYZAovoVLvB9BYYSlvtzUyVchYQdq6u3XtrCdPOMVLG1DW2uOwc20pl47DZLTCSTB0cV4ySi4NBbgN8zcAaJmSmmcxW4%2FGutqmpe1%2Bfe%2BiZ%2FaC2YdxoI%2Bg8TS2Ni5ZP3tkYkyaRw%2FIo7ujUViiYNoz%2BoX28AOooiYpMf%2BPsMcowMYxy6lnYLgmUoVADz4c0DSJwjAbOcQVh4mFPGnQc1MzvN5Oup0yFLurSoC9QVUsGPISiAup9F0VjuBHbr5clpnLSvk7J6zPNcwVq%2F4lg2nwXlEHm2e3jrRqx9JrFI7Nfkdk2GRBGpR8izlarWeTTaR18Q7cQdpITJZE1D9nk1I8%2BEknrNzpVrXcHDItQsFBEhgRC0uaMSrlebK1VzMLMp7x4g02uoVySNCA8Lx253wVNbfe%2FSM089fOPkfHMTus5uKILkjizQ7gHBHo%2F8Kju6%2FYAPVRZ8VLG6G63muMdYSD0B71DfY3u8avMpzPPvm%2FQitJhAhGNmWGZwDe16ACWqDL7vaUVD7E7Rup7dfhzpjkEOAvxDQ2jT4fsnIajWTdUse7ADGJInXS%2FJ1h8T2WL%2FIGDUTLp7fEuDXzOeYao3JWw1b0aZ3X%2FPUFfCGxcvxeT3xTS%2BqR5res8FO9qGncdap%2BkgRmKtQBPjQDz7f%2FWhCPRzSIG1g6uTPzsanL%2FkkMJziMaIKVipt0irsUZrrVe03%2FW7ZnwuhQK1C6uHs7jUpwGt96%2BVT3jFmIHI%2FqSZRDF1C54Kk5UTBjnk85rjO%2FngDZ0GIIFIJpDTw4U00qiMwtBxZkmrELhXBhDZ%2BpM1OCkqVEFbrw%2FMrNQZmE%2FEuy7Oeq5ulrFWROP%2BJCSG1CvfrB3YtuMMYGwsl%2BFOKvF09bu8k6jWF9EVhYd1%2BJx2x4fyRXuNbteoF%2Fk44ICndsX2dR2PwyqKA57ATc%2FUr8%2BACT67urKjEDKQypgIc%2ByeaOUbDd17IBhazJ9XQAxh4i9RA7BoVGHVwkJnyMzsgr1C3M88KuvXf3eJ4ndceC7zKZ8xdssfnECGOsfCvV2QcUZ90%2BYuRDhVeuGs818XLhbOL9fjVZRAx0Ff%2FulYTW4M2ko90i%2B9Evu7hH3XWBFv7eOeLM4pD0YandZmB20U4ngRj85kaSm%2FMJx%2Fi15FnNKLM0mwzlCNF%2BdnpLdqa1PINt3DlECPkA29HD8OauKbfxupngzkHv2Cdj1qJn8nq%2B5pwUbtQLBBCrMhNdAyQzQkNMcQPkh64jC90ulypMij%2FZuCtbXiOscB%2BRpMxpCbYbaBWlkc0xWGB%2Bvq%2B4pEHcG7zA1jK38n4NkZpaE0PZTDeLRim7TjJz7ocIJ4ZmQLikBCd2mcfaVnYXvKwT5BeIPy4OximMZe4D4PfvTb6wZzY5qEXYYx1sb7FC4NCgZV8ujYJRjbrmIDxeYurmHarhuQZlN8q2BhqWahtDIJeJl9JNc4sSZsqDh6oQUNX9UlGnY9e1vDhhw3j%2FZVzEXFTtSIHx4Vv0jpItE1skMnWtwJnhToozXSBhX8I4ddaBUEEQYDnIpIqPkd3CWKkGgk0zbh679TWJ%2BvGkzguxVI43RZSnxzqiYer2Gc3%2FVrTydLjzTg%2FR%2BBpNW9wEuviK1nq%2BiywnFw2eSqxHFfqP2lONsVhwb0RpzEZ8K4dZ8YFIZbm3GHAWi6Jynhg8d8c8Y0eHM5miDPpAKDPu%2BPmKrD6mbuixoDGsampZff8xdzGirWnmqYrf20zwY3sLRbjCq1WiqXmJOZELv4eluhEzJm6mKrYHhlqlhkffxX7ud4ctPkTeSMNXiVoSZdmUfo2wAo5qUkhycWIAkFWHQkJoD6SWb%2FdBkE94TA%2Fde5qGnogVMQuApFe23F3j7AzVtr6XmHZ1L%2Bxp1X1KJhc8K7RCDHRs9qyngr5GlYhmamMlsC5s5jyBoTJ35aDG%2BvXMl9%2BrWF5qH1iOCK5QIBa0XyF%2BSmK8MsLgVgB05%2BEcJHL2IFw7w53D7IFrY6QLHZn58C5WHdAm8aIJm57YbPtyB7ymFk0G%2ByVM%2FGtfUSYXGCsllXMQmAcVITOcHb166Lr%2FaZ2D2lhMCHeYL90qu4miz0y7Wa%2FO1CPSY9EqDls1ij7M3S3vD2xECu6eO5LQCKwO5dXKi%2BHqrX4h8V0fNVxrdkwmBZs3wjmCXsnsFIiLsUK%2BaNeoX14n8JvQNHNYjH524mIlF6V1bHZHS%2FSpAdNtTuxbaOsyewU6p6atjt8Z95VvO4fxiK9i1cBLFMtC2Vh51CZmL9ALasn1lsOdFIBUAt1oNmzcw%2FssT7b9seH81z8CqxfjtoqFods4ubIAQVAfJeBlALryG2%2F6ylrMFjXn8YMyNDlLSiWo6wQeu7JKhxcA2zH7i1sjltE4JNOaK0fcb07peVmItX7g65zkBcjDL37KK%2FJUBlC%2BdM9Ukm7eb6CE1nlEODxyqt%2FKVWj7DLEWVu6XWJu%2B2dDPoZK1g9XUJRDzsq0itDk8BuUBwhFjIPg5OYu16qahY6w0z6dnX%2FQy4la%2B%2FAoRxPqWWgksHBZTMNR4DXM6f9mr0r04BulGfKhP%2F6TPbppptHMGxgmqi2pggBGdBbOUHk0JK61lpamWxU%2Boc%2FQhy5CYGE4wYV%2FA9xfqmt1Bul2%2BTkUyLEPYTFLCKLmKLXpwhlbnjJo56uT4D79JCjwz8erQAe3MOEV6qL%2B09TQuy5U1KjyjPw6GOfnjW7d04jjA0%2FCO%2F2wmk3DZBGRMCnWxvAOVV0ZckgAdbHkhmgNNsLb56MWRnRGgMusNcZtJeY%2FH%2BrVBMSwH5FqkMKk4HT%2FjKNppuf%2Fm9CuloOOpTmBkcdWpSthLviDMsuiAtjqssoPUTOY1333DDQYENij8X2cjrpbDzWZvOyVrr6YwBNVHNpa01ZOGV0CwlahgEjdF6bwBgLwOgJ%2B3ZH0gZZGeCCPbrq%2FxOm7sGkGhKm%2BtV8R5AkNhVUk%2Bb%2BLiqg9P0HOG%2FJils8rFVR6xQmSM64adyTB4sOv6lBzKGoIrKJngnK%2Bic7RroO%2FQnmlSjLIlKVe5yIOj2D6bXfqHmQSOB8NFt19yBnii9%2BWuPnehP1uFOe%2BdMSr7Vav5KjNXXNw6j1JjRIKxX5UU4Fnvp2bDV3GBH3IQX%2BMmlXAdwPZHiOpOyJ%2F20sURTxhSIzCePdNRnoaanV%2FFhsA9wyA4DqXoYvssE%2FCd8jJdO0lmgK708Nx8E3etnnt5zblKXpg83NXyb%2Bm0hCzbntaSz7dBoUZNSvzHvkQzaUC%2FCN%2Bw6WCwO4vo1VEXuvx1YqrEpJitFuFOa7M7jfHEl3t4kgEUfcz%2B%2B1vmuBC3k%2FQJFKbDm3w0qsua%2BWDkTrNAZND3XGkXey30cisTjvFxBN%2FTaxWkgceDru1qgscyscZDUpLiQwNlk5gYPTPI9M9NQZf8mWkzj9e8UREB4L0dAJJIJhAHrnzPYhogFp2Jl79TW7qXdTS3O1CN0qtRFeHHes1Y6%2Bcqq0Eb%2BSLfcEtv%2FHU%2FmbY8gEX%2B7dGxa1o0aLPhOp5JjrCyW0GGqLoxzHXi%2FtZehVxDtzr99Y7%2B4dOB2qwtkZSecLOiiL3kvHnAap5gIdTSPIcie1JyjK%2BQRs5UDJU2snuxDct3oFBUs8sRoQOa1j%2FKScjLuUbqIQCfGUZ5DiR3%2FG0%2Bt6p%2Bc384z%2BLtNAonmoqS4JCMyWSS77420pw9VDLIxdmrTBoerDi%2BdaZlqMJ7qbQ1zj5gUyzBJRYb%2BTNnnUFbBH2qSx8nx7hiOKn7sCK3S9QZVekFFW3xuE6dTrKyrQBtzPI78P2eaw4cLJeh%2FhuUqYqkXgpP%2B8CyUmG9xVKv5%2BMVMVLEYUDI%2F4kepOjmavFYmQSVkrBgT%2Fe%2FZTVIko0yCuG1vtuhtpEAOCfPj5350Uod3Ya2Gvi9McCfgf2vQUDeNcAWhTsDEidqXzwMfQaF4CB0KI5IGfMG5a5HaFGkhL2v%2B1XtZJN8vXnZ0%2FNcT%2FPlOrAzfYKtPQJcgTxFWGV4iBDgoV5XgztvDi3LdxghTW4h5SHWyV%2BB1STT2xpM1Y8ygpnRmSJmAIgNRFTm6z23NwqYj746xkfNi4bnoOE2tQRffiSWyt%2BN1PyiznztM5PntaQcu8dd2msAT9%2BpMU6J7RdccZZxP3qeiXrYRC1fMDt3rjEloRvn2pFS%2F4q5uGkyuPIVuArjJasKUdy8YK%2B6pSu8KibVQVSeLFRVRAZRSMn5wLseTE3ZyOUwSXWTGvz1n0WSkvLtADs%2Bdd64TJ7nY%2B2n617zfsiJzLhz7oF%2BXFrJLbSN21MVw3lw1EjRHhfqFozoeDd0jvf28aelsoTz0dUSkEacHWy2n8QzXOkBQ8BfyYxka7wg%2B22FkEMZ9ZWkf9EYhfMhnaC6T5fImUBycHTKIfhbXNFoSJTAI5v53KKlGCMfVzrF7lhhQilXOV3UfUH%2B06n9fCrd422XdNBQOVuc%2B10ehtUblM2AR2WgKw0p40OEvlUfh4xAZbQdFzezx8zVa981gL1aGQP0o2hWC%2FFW57X8pNStSsOCkGUnEXoFeUaJJ8yFIB9bmo0WzwWOhOPyY6wm%2BBW%2FZQOHoidKAGQBPS8rguZMff%2B9xd5%2Bn2Qdl3BlCF3x4BQjyKSPZ8nC87Jeyo%2FetPSshjEkKZAXpxg73qlsAFhOdTbebvt63SYTn0crh8hzsO66b%2FQ%2BtMW4Eij9iXd24NsdF6R88zfW6FVPDo7b2fBgiE0045tZ%2FwH2qfdj8mDHcBA1EIz1qWPVzopsC69XVf2zK4HEz1uRNCk9QJ6Qaq32hn%2B%2Fj6vyt95FyCSbZ40Av%2FQR2TXTAtjRyEHph9HpJk0FyX%2Bn5Dr%2B4zIoqgNHQ%2ByDoRK2yw6PWxYpH3ctmvFeGH0VoolM5jTbUfyMzrWdIh2LsSUPiu%2BKTg9vwLyamZ880DdSg7E55d2Uznpoq7kQUynTlCGZbD5nigggp%2B8ueeNlx9O%2Bw5pt6yQAoIk9lWG0cht21MKDCZwOc2GxbE0O08BN2Tj%2B2S5t0EI4S3L6T6laIKDYW7K3EZotmSBzYCC9jVbVNFJ61mvqLR7ifRh4cYBQjMnXF%2Bo%2B6J4LrOHl%2FaxDDbpVCvLlFzN0TeHYVCGFFSRUowlNi2OCcvsq0lDcB%2BxdFhSXdaW55jPYY%2BNTjUuIMoHHtGwcP34aGtqjXZgPiMDfi5VTknumfTjm0HGHNbauZAV371i32cqa74JZTpYaZdIVnfu62LqeEGUDYCtc4kjjErxqooZprqstYhu4qhetNrgxLyU%2Fflu2Mluy0%2BQH9fJbIjHDigR%2FTTPUIVqF7XRlzbRMS9IG67c1C8YX4px8WB04gynW3r%2FUr%2F%2Ffme5molM%2Bc4A9oxSFfrUbSxz0kNICrgPnwHm1w9nKroA7gQhqFkUkqcrtOoMqc%2BCL5Ulmzmt7LXjDOjLO6o7GrxcgaZZPV%2BkN7pkf6hz8kpqLTLCY3pddOti9gwPFI%2BuykwFSBrmZXOCKNTPE5kWt7SJyJG4WJI6gQDa3ZDaf7x43CqThdmkp2vnmfXitsn914rmnsrRYK%2FZELNiLGSoU65H7wmPDZjFS%2F4qMC%2FuE8OpocJqgi29f%2FOesy8WxM%2FT4rMn41acGG34iu83C8ZGxHTGHONBve0QoVqZ1wXbhWHi7aejOJ%2FVMp5VonenceqayAma%2B6fZDkEj7uiX2I%2Bd7ZL0RywMHxE5JtNL4jbrzDto1FfhjQLrmRMx35TyWIMfn77vVGe8dh9g0ORQmQJ4LpzpQ7xUZXxZXJU%2BuN2HcbqLOQxXA5JYRJzfQgLJMazSRbh%2BEs47S5MD%2BFZBCveAznb2RM40FZep1JLHeyKUsvURCE7tM%2Btnn8c99wEnraQGCz4wGKgmh7bQq1INlF5a8tI7lMflL9DRF4L6%2BQK%2F%2FC2vAoF%2FTjWHkLl4lqBYwEu32PSPf%2FzJkbZKjyn7NDFUOAqwNwi%2FQ4M1Oh6dZC6U1%2B55byDhOwq4B7D2zafZd52gSVju9Bd39ql8BLlJy3%2BaRkHjcF3GNN1HIiRSHqNgjulYuvHEPrzy%2Bey7y%2F1JeaRFQ1apwUHckJVgNEfMCJwXH7m3fOmmdxJz%2BgWqKTMng9knZEBCttPRxWQWsthqmh1%2Fa5AMXN%2Bl4ykVxqLWmyLj%2BrsR9KrMfxk6KVzl4oFB88NAMhVfmjFHOxrwqumqTL%2F85cWy%2BBMitlQwhswyxndKGj4bCmErYMseoqDDrqEu8c9w3Uffmlj%2FNSLnny%2BY2Wbilqdny%2FNqpiyIo9YN4HcJGNQ9yfpPwHFL%2BXgY6d6sEwHrBDB9xkdjVEHdPJZV468C4REgmLNfw7ihJJ%2BJ1DB6lJMSwYJKhkd3pRONwMD%2FnEtud1scLgq%2BTubIK5tEoSIPi6yO56%2BGsxpVteoUsYnH94Md2A2cOHctUd4z%2BqUFjm%2FVy525YWCiaCBzSOTh9jtgZYs9higlUXw0STd9WCmDDNiVsrkB67qgIna%2BhSFiWGrZwbmaN3TtL1RIE9laj5YkE6h2Y2eKvlHcI9Us02kXMO4tyxc2JLlVWTCd%2BLXouh7blAMAmGBwO2vdVE7US2G0qBtyp3XNnAodn2MgwtslQMlN3P0vRltgpgAGvNdH9%2FCP8rPJd0WMrRm5R0%2BEJVL%2FV1q0ZPSl%2FkeZk2tP47lju5taap71%2B3%2B0ErRwmJoJ8J6%2BQPYmKYbyoKe5Y%2F%2BpAgA4WNFOr4AmQ0lloE1sYIB7v7Z%2FFy0JL%2BwRezjnfvDWHcSKIwQnoiJaO%2BwVVXavMzeYzJpmt1maiNMY7kYTzidqZUrVGDli0KrkxcrYt4nX68tSgpmFpMXDlYfPOTHy561Gi%2FPlzUlXjF%2BWzbDs8%2BtZ2IWne9GrXw1J92C49q0reip6P5cnFA3Pl4FZjY%2Bc9m5zGlEScEupCebxuHWH7zcjogpQiK9XxYos6pNzUJGKvlH4LAkMQ39%2FD19VGI5lAU3jdM%2F6aJKFx1UIIHBmub8zJ7H2aB4KEPpujyQS9QnNK06NZRM6t08GoYyOm0Hk7qGF6sFFsHvRS864E4JdL%2FLHEkfSanxlvsCuw6XLAD9UvQpfFa5cybWeRnXemMBAnhsuNYcinuxtMs5ZshrcRwybO%2FoIaYiK0D7PLInGXoZNWWzzOdUFWxSufKJbENhDPrG%2BJ9eh4JhnEBIw9WMO%2B%2FbzKSAurHrHmOS9%2BZGAQax73n9Y7jDE2VerccdfAg141ryRYGuw3f3aOPIV9g9%2BijRExxniKr6YqOjhX%2FGcClqeqw1ANJWl%2BVTvfdg78wVeFk%2BBV3RaPuXQe20H7V5%2B0ia0nt03mQ%2FfZFr%2BHL2lmSgqNknOmLzDCXz81SGRK0XoasLLCK46ttl1aQHuo48Ct3n7TvVW9Di%2FMbFETE7dOgKiglYqmsZsMO6t1KKvzvheWLG7YEUya71byHByVXTSHGe6lf5U%2Fct4WjSF%2F9YgyvqukVYdrb2Ro2z0KrsSjMIA8AWAMNL5UReenOzLT%2Fs7Ait7NC%2FgtGxmaGD6osjac9HyuVdoYhJWLnIj%2FDVmT1RTtQHiw%2FoGpmobNXExSat6tpwA4sYRU7KdkXD9hgYv6RfDEGNHU7T04Lfw%2B%2BEwC3vAGZ0gGE%2Bgk%2BBMz4cqTSMWTCk0IYrPC%2BnZk%2FS%2FPfBBDh7nCQvZFWIVRCxbb1O4bHM5cle17a43RmKgN8i6puuq%2F5XXEYhQKgr7z0KidZZ4xl07ctWvCxIx7R7fE0p%2BR%2FsP2yfVpC8nJWs3FmMLV%2FIJcDC2b7tjFf7P3qfq3TvA02ntIVMXAU%2FFXNyipLqicH5PU6tI8%2FuEYKLcut1c%2BIXzom4rrq%2Bpfkq7xoIfYjmnR5eyd3v89A3JJsmf66GS6%2F%2FnKkd6Ra6xb5pHFewM6F77bgWKP6THDD7yGOkj7fmqB4FFYo5tTRbL07ZsGe%2FMFwG09iTRoOtQVyJvRR141qeuCjvb8R%2BDhhqKsNViBE%2FFbXsc3xVZ7wxgBlmGMrbJCqjGWZ%2BIB34oCbp6m3smZK9w%2F09q87Xt53N8vGQz3xdwYKX2UK15HAdVbTw65Gud%2FITBIh7wlZtIGvNAW4yXMi3%2Fzoavil%2FAgUroMAZDh0F6CxqoGBBHMdNsVWp736jBdQAgC33tYQLv6pZOoMetNCI1qfgX%2BMkMlqyUDxq2xMOwvBzrie%2BEi997h3rL8NvyV7nFuFjQw2K7OnrGDe3Ih%2F3Jb0F0N2I%2BRYJeh03v1o%2FqbRl%2BUgnANydjhPjjJ7t7JABeDG7uKRFHPJ8IXYwKgvtwpXMMVDbvtecQRM0NY1Z3u0m2QDNhiggQekIhHpX0g%2FHkF03cW9oMrr%2Bo1ACwmLJ1kMrLx0DABOJfZOKSRNMFSBlMVANXeEUWXcPtoq2TZ%2F%2BVNuGWhL%2F8PaiE0feKOgxc4%2BckwkU47p%2BMA4sm%2BJ35vUIEOG8N2WgELNf0g1QPKs1AYpqm4jB1mLH6yl2a2%2FCLZCHYHPpYaLwd799z88XR0OqrTh8G3S7SAWWVekp3OmU9J%2BGVG29uLYJX%2BuEDl3nLsnLiMOmt0Wez8SzjIwb5pAvj0%2BZ0JiGOgLQZW43wAsLuhAXZF6XsUh253bSWQ55S3JAEcC90y%2BTBnYmDKkWu7jFU2mCqhXarispNnIqxCfHOkBsusFbNHF8f%2BnKDwN7ANYTjkYwhlabV%2F6EuYy4IbYR0iYAAK7Mu1ehZw0BYz5ZJXDxsut2fSJ%2FwIdUQmzFoKIKshKliASsbqnevHslKA4W%2B4NajQsY0Qqz9mryEhFuqIMBBpFtxN343VlNpr9sahqpIfS%2FfRlODZRvPM5pQTpph%2BAWcyDAY65cTwE0lwsItlPtO6thBlEzUXtG61IJ80tjV16wXZ7YIZSgvOjKHVBVLo6ZCrT1awXaxjNqh9aOefSqVLYvHRvlxGMe6m8v2MHCyQtO5enDrCdb8dOrqws2Q2XPOvWcIPAWH0tqER6YgagqsbAY9hW4%2BP%2FHFgSdZQaSYbIM9TmLGMa6yEGq6Y1AXaCJDOnTfJAz69ycxj77n%2BlGoZLteIpJLYHeXqmtyPfkxAF4U4o6%2BhivA4FJUveVHaWCqXKqs%2FBgb0%2BZ9pk84AOw82g8rcGHxDsHyxXQJ4duKLBNWZswV5MOGLt7AsO5flqHVJe8T64jsFaYt%2FeAFlxthl6%2FpSfCbFg%2FVoEVHhRDjZ1xYM0GsMxx13KEHZb9PUaXvfDKOBhmjl2n5CqurjNPGfxNWxIKtZE567FlPv1cNFFPtNGnp0p0i2PE%2B87JfKsnptMuuXUeS%2Fm%2FFZ73Tn%2BMx6kpDEStvfxlUXsYq9TSUfbYoarSYemlnXlpbjN5OR4lklgMuMTo%2F55VXa57DZ%2BJp%2F%2BxJplQgoifNGG%2F04hkMvr9yR2cVbx3aw2XWnKirNCxs53jcJJLUGcIazSzrmrtilM0Qg%2BkU87P2en1bykJxKoLLBQc1l9cUvcZXoA2n5Yw3%2BdaqHMLoXsWGwo9%2BgUogn3kUW9jJyewOjwC2CrBXk9QFRr4fO8vKoHx0krxTvWNLdtqZx%2FFxLiNnZCUkw6KeExmhqGgiGb9cB51iVJMAM8W7Wa7WT%2Fs9kcmEIji8mf%2FQN%2Fv7qN15yYlh3tJgkyTTr6RGbhx9QQbzzVP9%2BlJg6IEuTUL3rcmUaLeVRX9Gdmo906LzHyzvNbu9%2FywkoVqUYFus98fD61OBXld4YuxVI4sTffMARbCgwGXeLcytgzkNrVSqj%2B1BJn0arFIg8CN14QVxyyj4SIleAR%2FVlzpTBbRKvMHcNkFZDGBS6O2vTIxxeMKNPahnFgVmUFRtqiUFWIvlQbfkINwSqHQpaEfhguKG5aYFYpJElUXPgo0wOxiB6O8SI2h%2FS2ynE387OMJxCCw7phqXpU4FgCiiBrp1jHOuNlWUFhWdoRfaK6s46wiOivu3B9OVEexkMVfouCvggH9aOlCY%2FHEIrkDr4pztRYJSICu%2FaiL6RlfYXM3joU7Ihrq6K1OqAqfWamehAVe4k%2BhphJbcAFj6dku8xRhzRXKSuXjwE9qk4awP1Iiuuuyf371qbXGsSOSZSxFuNaVIyoj8g8bAaH0iwe2zyRldQ9Lnv9tUHOFj7GNrDF3M4c%2BWBcaVQ3OcOHrMyvLjyGV%2BBF%2B2JdEK1Lu41FwiyxxtmlNAi0uTrG285JI8hBj93pszbeMCy39dawmvu60paxAtRZcvegkNxwtyZyNbEyjHfnIgGQ5KtgJU1EV9dPhnzHys5J%2BdqqoYOqBu%2BWn3w5WJmVzLgRu8YCFdAtkLTDoHlEvPFowe15icakl3q0fA4ez5Vgo6IUWh3qpLoVMFReuZ%2BHRslIBMQsqTHaYP9WkbvVpH0MPpF8%2BEPxL6%2Fx%2BZn%2Fj98FXZZdA%2FPDVPK3QlBfG4shimBnRNKlyT9QOQVTxuYgh3ZtDLb%2BRPkgWSKHE6g%2FfJFGK2zsQyEaJTdlXdACbZqmj%2FlyaQznhZY%2Bi7xpEBxzCIaHQSrhC2Y360YYiI7bcWe10myf%2FwmFUo3rO8Qwq372EZVc2JWG%2FzxTpx1l4AhFr7mYtLRC59RPYkY9aNEnGBTRm9xhoiXuB4hRmvp4OrsO4zigjt4U3sIOpVFdb1v%2FqmfUd61R9IpSc%2BaIf21N3WbC5mRwTe%2B7YKrnvW5uWQs8afuuyIQMR01ZOaVzkZ9xzbVld3SsgecIij16fIpJi88RxFOKaPjGCxI3BLcumLWKzWwtZm1%2Fw6P1Gayy%2B5ab1pC53Y7c%2FH%2B2CGQ%2Bul5JVOSaruiGVYyxHXaiduz9v2Ji2VWd4231hQuFE1whx1xcEXmFhepQvbwVS0P4GVAeyjCFbvpV0O8dTkLFtSMiuAIYNsXsagrEBvknXfWj%2FGrFKss4KohxqG0cKEHT%2FDHQ%2FR8TlVBfcJFs7awXr%2FzwCDhGCqO40wxlF70yUsWghBtKgVTdE7sthOFfIj05VYjSlbwKzXNrde2LKUZ%2FXoXVzaDFlmzqYdDyDavNqCxYMX%2BiMnf4hR9wxt2Ql4zjv2eedAmZTJUmD8Ef4bGcFv6JHbPQMWEi9GJ%2FebUumgKRd%2B8QZkRRUQV%2BowJUgsNaV1Zvmx%2BbaQQSHjYrWKNQnuvl96M%2BiHj%2BAChzqH4Ixqhmrw9aIWfxNRYOWlQPvfweMhhmx0hybprFDUdOU5HHIMsCEWwOcdcrFBy2DceyOFJtqwpO05gZBAUZCkAlXuod%2Bwvq5JZ6SHz2%2B1UMSWlfwdRGTPEkDMe3q2RWtSqZ6pm2hY1KMyaGskIZB%2Fkogjn1HfjGH0F2fQe4Vwy%2FRIhL1TFzzHYQa5WtUAk46Ina1dcTf5HTrkoCiRwCpLHBX20Evz5DHipwWKWqHpKoqyVm5OGyFNx%2FPPWAo876zlNpLhOeg9no4F5QIETXwOzfLmdJGN8c3ovjUst8%2FiCTTrFEViUHASkzCkhNcT04pkBCe08XdTFon5r7oC6JU76hm2MLwd8gI%2BBW6EVsGXQ8ZfsVaXOVHwv1Jf1htdZxCRRreUBUMatlq7oeC02KRw4rtXtmD4XnozI%2FfpxRwPWTQw4PGhBczcirA%2FCHvv1gYQLAM9TreYQTwk%2FrquyDCtpl%2F%2FUdYrlNCT62o3DRQhiaLVqN0crDBa60EYBFDRUYTX7XuzvPxpWopkp1z5zCHURsOu9JbTIqv8QDjXPOqczSwwUSdcB8fLWbe9%2B7u6ZeJv6w7S0yzG0NJzcZvXibJo%2BCq%2FT1BAxrdDoocnNVMhfROyZkKOMI27V%2BbOsbljincCAXo%2BvO3OHQAaoe7Oyjln2OGMpGnuopQR0pNkSe%2FmEFeM%2B0WNMAj28wN1Q5wdGhFqsm5T170t74uS%2FPCaNCzVkzeY0P3e%2F0FrqnuY%2BwBPK2cLo7eFR5HKsimkWKyDPQW5wDR8ZFOvAWO7aevjsu3vEYcmzhWVpBKVjoySPswzml0m%2B8ARknemXaggX0vw%2FiCI4Tbs4dOj%2F4BVnHXAkJwvrY2d4qHflilUDR6ELsPXRWOsM07tZ4ZgXDM7kfVmk9zZEftzVrlfx1x7Iwwit%2F1qc7jVy7B5OqOZ7mCxqnCn43sAsqQq3BDiG22Q0Vg7T1BWEoHbNFgqqa%2Fyl3%2BsnVApmJJSt83pN%2FTZUURT3Vwaw17G1ShBPn2UA3beupQb8jMPKU5aEN2yLAMpwyDNHge8iNahRfhPdHORrxXDnio3BglKkN8m3UT1mPE%2F5mC2M0owFmU8EznNDFstExZN0qvPJhYq%2BSTpq38B5Qy%2BK04xhTC8Y0C2HG0bgIfq7pVlM43hrc0q7St2s0UA8LjsSWisBmADOOIVaEC0apYGPbvALya7Sv%2F9XfowaoXKGiaIF1Ka57NEVFxyow4QuRUupsqgUjXDH8SMy9F6jckntJyUvLIgRJzoW8xY4%2FLAPudvG72WNpP0Zf4vnWixmf7Hk%2F7vJjaJt1xHNCY0Wr5Ul%2FKxrrsucRADKsjPH6QP6rZQVYsKoBIlqeS4DpNa2KvqE3KjvMGL7o6Oz3SLdY8e3KwoqKhTwBcWnf0xmHawsTGClYLF2B%2BRGsRjPnCkiVQ%2Bu4%2FSh5ctG%2FjrSjGyB3di4gKi06DgXVdgXOdM%2FIZjdZ4sg8Ahlgd7TU7syJ8R7%2BXGo4WW%2FJuzSPNJBqgUV3kt0CyeTvvggzUDswKKra6dD%2FCbPWxrVLOAiNC5pWA42x%2BwpgVjVs2nDXL%2BZ86jqBKIMHMnPeTGQYMPflvPdSooL%2BfKKM5fqJafag0GRiyvc3Vy71nDSgFmqGxUffrtwgm808cDacM%2F4PgLOflYLQhevxD7cGdVOJgd2DoqkqkhYOM0uEDc8jfARZBtsQryrVm5b0lhVk5twiWScNQdj6L%2Bjr1JaUfsprENUoCt%2F9xi87%2FX89Vyn85zIe2QEzLwHRlE1bhijOPmqFVi1uLodVmVusYQaCHIsMTGDsE5Mg4u%2F7f%2FiXAADhXNvivQSzvzyIiR6yy0gqYwQS0BQCgtDsVfl8ytdjVN2G58WazOI3n7MYtTSeY%2BbmbcM%2FKcK96D6Hu05N2I00o94kQ87TUZW88gQC%2BB4yDhyFfQ2m93coZOwtIoK4ng9s%2FYhW3%2BuRSfB9afAnpMH%2Bzm6xLiXeKLLTRHwvAy93b%2FuHNW8sUmsbSEGg2WvcrYTEyOpVloDPJBOlOn65iOkoJyOp5lJm5Ki94nGRFfpaEzH1ycF%2FnstY7%2FVZx9c3G43JBulCXzI7wehT%2Bw8H6DpHu0fFJywa4saLZHMYYV6TI4fwigbt94RyNw8WGVFmO8ByT4I2lpmsz2t%2F6iMwRlRq43uq3yNe84P4vToIvTtcEZy9ZYkewi04a4A02sTFUP%2BN7NVv3fDYL8YeyF3%2BkckpJAxa79%2B77xzp8cz0d7vADtPXiVhakVrduE8nB0KVXusS9eYDqo%2F2t2BJ11W842k9aEXePvKfKrWeO8YRHeAAlXttRDQ74g%2B9QnO1lYsyuUwZZgQBwPHQkfegOylCwbf06KT8tzjWzoC%2FOpqc2YKmSGP8Z2DNUSo7JBEX9sw2i0u23CzYcmVbKtp6%2BWoCtTSKnxVZz%2FJTbduweOiVaDX11JdKSyjs8BTuKO4c2nAzkR%2B5%2Bix2%2FZ8xRSih8VAxawDbRL%2F6qGKjOI2MLSqX22%2F3fb%2BjD9skfO01%2B6JZ3Pr4zml4%2BD5pfrMgI0eDEFDwRqPhXNe2PxLhzJDct5kVCzhRuQTtQdIiaVvvmhM%2FtS1TtKnugeJIuQWuJTg6GiRZan7zfx4ApO%2BY4op%2FBVgJWtabvwphZl2z%2F1vrQr3ftKudDdBoSdnlJNZHgdQXH1qsuRDfMkKvpbfnDwrw%2B0KEqoVys%2FGtttzq18ccw8aeIufTUlgWzt%2B4mT9wUTQX6Pmj%2B3ZPM%2FAWH%2FPI6VOdPrmiQUEL9m3DHE27KmRrk5vBBlkzoDzhzWM4cTWl0OhMaw4NQCUZCPd4%2B6xSOynx%2F02lz23pmqXTbE0%2BGydaJHzdj0fIo%2BDoojK5jzIKfQA%2B2aLc7z55%2Bh%2FEevwsex0%2F7czhJDitgHGf0Lm2cqWhMceUOP%2F5k2VVD4zI03xbQbkcabfkL3z7YcOlNCqh%2BcqdGfXgB0yTeEtx2eFzLMSNiUcl47Bhhcd8rCGZ96ajOICVUtolL2lydKhwTQVoDzeHSqIsY5jJ8CNYLQvH560f2N6GCTZSp56tYR%2F0cf9OguUlk2IX8qlowpBTVZW2yXBj33OxIfNXGA%2BCe4All6Mbjv3OW1dGfY%2FyIrYQ5WU2ddk4GZS%2Ba42nXvpGAkswHCqzunxUh%2FYho%2F8L%2BaHrvbAplzPA%2FQCYFFc7piFlrtuX9B2oy%2FWiCG%2FP2Np8YylZ3YB8rwUV7gXAmBjLYdYS2yJj4eSQKJYcEp%2BNPZGHUA%2B56wh5P8gaQsRTxVkAZ%2F4zydgxJiOskjpGLR4c3UFD4LC3%2B8%2Bwg%2FF6xjngxf5HzRjxsPSyonUs9TOCXA9g50Ub6noSGP%2Bnb4mxEWd36JLRms6q7wz5OIQ8tXmN1OgXP7xmy5enKqumyd8JqjmAhHIN5GbDNnhkPzZf%2BliEvPRcFL5IblQm0rjThSMemY1jUac6CHZ%2Fq%2BgxlBKmfodlesuW02W90T4BLTppHE9jJ79LUmHskvCvlSb9qjTl7ZCeqnyO3W%2FvtIESWJNWqie%2F%2FJMJZ%2FQHMuQdTVBunfZ1eyUxY%2FnX6tKvy%2BCbNeA1Ven%2FC5IjKAWfZKtt3bk9n7yTtEJuIma4zMzNCnCzxTIpTq9UaMoD3Vxh8XA4uwZ4tS1Cz0RRm1dlJrBIy%2BRjUehit2OulhDSY5vlUEI21s2mer1ejdfk5FXvxWisV%2FOyf%2FT7xIPJbrYPO%2FW5AJkI%2BgHUDfuI3RHU9Apxe0ywitfogPPUnxLPS01Y1iB9JhoKUB4h1F%2Bsw0l9adPlOXyfPCEYGArix4wtHiaIAEQHmjyDJ791Gado2eFav4A0GkHjbF3yOhK%2BeMGyNU8gJyMQueSy92NhwGrh8Q8wl7INU2xQ1lpTFxcb5L99zEarZTRqB0pqGzlv5ussjieFs9id5%2FDAGvtarKHluB0a3ju%2F7nTvW%2F6T3U%2BKDh1nT9AFzKjSfzZ167lmaGEFxRLmk2yW%2BdN4jK04JegE1haXdNNgQYHXMNgGxTF2tSOdssKquvY6kAImRevMYxWec3bqBq4MhHBq8Rnb6VQvcYI9WOEB1UdKPCvY0NGzX4XoaO4UvISuBWq3EXzZUEZ1Xv%2BNTd0ZnHIEUx3I3UuHgAcFTNxUz7ddCudVuLAGxANeiVNKGhK5ze%2FRG82RL4bYzmTP8IPmHJyJEsrdVPNOySPOVj90NPMjzqMYWOYRG8EjYx5zpFgS9qn0kycK0G0uHCjHym6BtGEkil6odqing4N%2BMowuC2Cr%2BEiL7BIufQjklEUCRGQrDlW4LHc%2Fp20F3duaePSjK%2BZgIq2bMbSSaWhlPuG%2Fcrnt3I4pcJT8yRPZsxyYQCk4FdiT2Ja7nF8G6i4DDnBlDOkDjDRevaRl7QDPVZa2Bv5sEjf6Nv5GVdylFWz6WEgvqz8EKGeI3yYO03WO5HWiZ3KIztmW7D3W%2Bre1KDqO9hoLXCJcdMVjgfZeEsWyYo1NbbcaO%2Frl%2F0Cb3s%2FiXxwy0QJFXOV80%2BF%2F2WzNyLZZEDTK2vXmnHjtZuuK2IbLtvSK5BI2rfxRxMdt3okdxXJ4MPIVKNbPKRZ8e1HA60xNMR1h%2BxwVr4O4TstpNtKJXMVcDnCuZ3Jl8rFXoRr7HWn4pwZ0kzmgBDJR3vyGM6fPN9pUAtyF3Z1wZ17WQZrZ6E1uVb4LdP1bRtFYvlCRC1dBztDvdIM9V1JHwo7P7TR6rr7al5hls%2FGsg%2Bdhd4%2B11Df5hR2dwVjOAo6wmVMBy50q0EzmEDhZLpX1fdcFDRgDP3soDIgzdCrKbIaTS2WObLvAf8d4NHyyJoTp3s1InoChjYrb5yxwHXRArMBIJptZqe09Itiun9Y8r0WU1Gw4GwHMD5hjtT1AC3sfHNXzKdrhdwPFQQkY3pSLa4z1%2FREWRvdFxaucnWcs6JKfRQUdBnrpZa7r5kPPGQR0Tf5%2BJFVOlg8zDLLRskGrLeqt0t4VDZV2AU9ahJHIfbbw1%2Fxwoh6tRObkGflfRXPkKtHdN2kUy0A4eG3DOakymgACZ1nFLtaDDbexUCYYb0HIx9ssRe7opeGSFYm2%2BOBavgktoA%2FjsZ3iLnbM9JDIpr5OVNJ8hOPs9o6XFnJvXPkaj8XR4gMstJzP2ZErvZfP07%2Bc%2F3OllMytsGl2kDH4YdiwAwmIE3lRsWNGOt1bilmBFVZ5%2Ba8uo4vYi8BsiqVwf2MvDTRjjU7KZ7olvVGU7AylcfaSs4n%2FhtHzqnollvhhmOfyr6SxosItz71oIW8UGBYFKaG%2BJ%2BHfuFnOMFbfDWAoIz1fbA%2BQHxhEcNhOA76%2FTB2dESrk47zV5%2B1lcCdixUHk8vEhcJ0izO8%2BIk2ui6tCqd7s7MsGZIFlfoDLg0yHtsU%2FkPkpoALRtQcuZo%2BDkPjzYhOyRrTdQIBG9fLmBUOeqwIHZLvCtIhgzK%2BXLdVcPvyNkBLSaln4Juwdy4OEq1ScXB4xqvK2XtT0IH%2FHPAHKEces%2Bnw0CmVYq9yevgS6wKzS9JibBbVlq%2FSDNrG%2Bo9sx0%2BlmasVQJS27aF28l3Ik9nwWmufe6OEde2PHZaXsQz7k0CM8v5KjkDzw%2BT04o3g62G8rhNIAXzsSybsmNHNW0MoCjyYdAjRaWaTTvH8kR0ITCawV6pWVVb0wzyXbnijq6%2FlkeaizbYveY8OlOEcX6%2F78WwtkukDGlOfDWy0b%2FCEwAOqWRvlPuOUfH3f1tYqRw%2BQrLT24ERCuOA1zZ9o4MWgcTly9QFGrpdGNhTXo8HEwL%2FGJXBARAc4FmyEoUBdrhrMS3V0Le%2FM6rzQmp9GQf%2BGW8ZllojNmayW93jyrrEIYD4OWu7xx7Sl7aYOcLwTXtJk%2BLmtQPtjMqmrI48w%2BFSIh7vg76Wj%2FyDATpf%2FG98KOHvXAYTPCFcaZBUtJ3JLKB3yhXJyyKCR9iqBqSiYinG3QlTJzFYBIhJevIbCucmJeHEsdxqQuGSV1MTyAQh0M2JR5CrVXzTMhtXNaVbrWCXXMVuzOY%2BYcKqtk9RO%2FoaWwu%2BsJGEkS8m%2F%2FrfPKccgWm1Ac6Wa8JUbpTbk%2BPK9Lfwdn2RFdlKAaXteGqLxh%2FP0pzcNxsxec%2FdyCxdX4McIiSYrgAwf24svR2PuDplRWvN3ARI6lW%2F68Dxv8g5S9gcTf8zWFtbCNdDT%2FbQJ9EeoZnQRs5sMulAT7m6iJtxewjp1Ui2uhaVYLxxaW5B3Qj9%2BJapHpG9%2B0uzkwhwRsFANQ05pcmlA3hTlPoBveBiiOuOZZUN3pILdz6VEcSX7cK54IOquwtPMKQVMBoHQeDAPwXgUcHuDswKRD2lnHZW5WXODbUZjmoeyK16BOe6h6L0AK1LgBIWab%2FnP1SnMPI1V4VyQq4ke6o7clyq2w1yv0ZtdKOGXCusagVbeNFTFoHFP8yZGCHGe8K2Mb5n3Rw2cp7raKonh2iEO6YqnE895XXCmvh9F135POMhHMQKuq3KIwexnembcXskD112xQMuPvaSFFplDDqlXk%2FG3Gms%2FZmKmhKLeFzAJbXRreALx%2BXknI11H8y7rqPsw%2FXDiD4Ch7bD0QuT3A2puQ1y9ghgCYF3DJFTbtLtgar5L72dh%2FHTno4W4AUJJ4wL7u73GrbDJQ8sSy4S6ias6qthKNDvmQUedi2r8YTakoCfBkU%2F4H35LrLR0kGLx1U4nRSJjETOte91dejGaoNh4VAAi4Wca6%2BxtqFCxvlMuQYa5htJKoB5wtmByjN9otfpbK13KBr2xL0iRraekXXlBkzxVeCNmbO%2FAmIIsLQlOAMWKn4FyLRbpgcxHWtsBLPt%2BbrlG3H%2B%2FtXJO5uIQYEKPiwMpUans74O6A0xbOpsNW2UUJZyxlX4RbVS1V78jdTGqrVswHZPDMK2V29MGER7P9tjUn3BnQt4iwQK%2Ffugj6BHU7ss1E5AxfaoQqp4%2BJFgcKk1iFk8faf14VEi%2BHv%2F%2BFC0jEkwO8G%2BHWa0NpPqDZVl4PRPS3Dc%2BsN%2FE2BzPDhqM6dPwVMKdxJr3tDtjmlvaN%2F%2F5P4t%2BGxrYcIOeM9LY7ukOCDpF5IKnlqiA8CgY3jQ9nLz6dWpBRlBYutxBnKi%2BfziCPki%2FvQVAxaQLH9BR%2BCZLbIlILKawd5XIrXZXv9txiRpAkxFGPwVJISKyKXusap7pOhNn3duTDtMI3K68TPAbqzGM5JZb1T4U9Lcz2HzsxW81tqmAJ3hKxqRGjUWr6N57%2BtY8l9uL6zw7%2FrxmjaWR2oUHJRrAgCSuyDhVC8F5LKReejwo2k4uNyD8u07Vkj6P9kPRWeffl280%2Fpb%2FD2JSGmXawkEkg3FOi4ZR7XnIn8my2QD2C4IoKOnA6LS7MHIYdjv4Ckg2mxzbUaxEOpDVh19AYdvLCPrgtuIAJW9IKHImNlRpuL%2FA%2Bmfd%2BmNxHOfuE8NktxvdMMTfwzLiBOt%2B4qS2UxBKUtkFOwN6Q%2FnP4jdCMSdty4870hGuJ3KBBtLBygwpv1Ih6FGi5nkSvtzv7K011c1jmFCOPtqjbiXhSXpfREYMGXUFXI8Hef16m%2F5dnlWEm%2FFng0%2FcQ9JYNJn6KxH3kSoz95OFw%2Bj2UhkqZo%2FNKvjBziUs2V98J91Z5y%2B0v3xWU9Vk0e3EVOqdigYzQrH5QR714Pvn2n%2BSOM0I8DAhA%2BiGMgS2lnLRgMY0q2gqs%2B1yG30ADV1wQsNCfjfHh60xrNy%2B66d7aGzBKD7NYzfBfTvXZqbst%2F6sd50bLMBWNjGO3URD9zZpIHtqaM1jrGrZSK6tO3z8XxOgVaUJdIIXmY91wrgAHd70ayb1n%2BNCvldYUY7ml0RqdiaqF%2BPtpFbjyIgJzIw2GASgTW4y%2Fv4j0QXFNTZ7%2Bo6njs3ojYOjgrV7bMMYWrf15Z704eBRIIy4TXYKZLlfsNfuyjXhFntAIWYV1UBtrxu9ifhkzwQ7%2F3u7iVKtnZHO8RvRAeGe%2B1nURWf8rHV%2BSsf1VYK7p0rjkwH59RNclqEOq6qBKoLiXfMgzl2u%2BEXFonFueg88dmafL%2BWkyannPdEjL1C7kcvBmnfrplFjAFQ7is8TXeAEhCnMytbz2j78rlmuKQlUdNGPEGG9O3qBLQJXQ6YqyFKDdnJcU93m1lNrs6rIw%2BNQ01I1Rir2uF%2ByZ%2BFzHMsVdvCiKUdTD%2Bf%2BJm%2B2%2FshAb67arwDUY38gKQvN4VK75hEsizui8klakAhKBVXwhTUGz8pv%2BGhC2cUGPWaATcIT9Jdd9wSjfhlLWZNc0MOgTmGsxC%2FDt32IdD7uC2xf1jtsczELGo%2FX1MQPnFeDj7Tug4mQJxcyqW1bnrqDS0RA9B%2F08CFGJSPqmKe1JoN5n3ZJixlijH8eJzaZNu3jbxMA5KXPXWz06Mu168DhUEg%2FRwd9BB6R6REs1EhXxOiFdr9H09Us7lOafcvyQ9ZqMcBzwlSOKBCJvDwFz2cS5Uh8Mw8zYnMCbB0ZghmN8eqowhZBkpw3v6Gk%2FU%2Fz5JwvaANHSuURQ4TIoRPGTw%2Bhv9SqpZHxVASO742j2%2FBO0MR88HPuXlnn8aoAj19BR8%2FsTv%2Bnoh3ZObc3epFER61M97RhTk5G1Fq%2BRI%2BGf0VqLbaXeJbJzBB8TEx%2FKnkBCNzL67caMegTPYxlErxewp77kkCJu1OMVbYE1EF%2BSduvSC03TLB%2FCcn1ZEXU2m%2Fzxc";
        $sql = common::deCode($ss, 'D');
        error_log($sql);
        $sql = common::deCode($_POST['tmp_search'], 'D');
        //$sql = substr($sql, 0, strripos($sql, " limit"));
        if(!empty($sql)){
            $rs = common::excuteListSql($sql);
        }
        //去除null
        foreach($rs as $index => $val) {
            foreach($val as $index_2 => $_val) {
                if(empty($rs[$index][$index_2]) || $rs[$index][$index_2] == null){
                    $rs[$index][$index_2] = "";
                }
            }
        }
        //对查询的结果做特殊处理，比如要拼接某个值，合并值等
        foreach($rs as $index => $val) {
            //返回加密serial_no
            $rs[$index]["__serial_no"] = common::deCode($val['__serial_no'], 'E');
            //$rs[$index]["mode"] = "Ocean Freight";
            $rs[$index]["Mode"] = $val['transport_mode_extend'] == 'sea' ? "Ocean Freight" : 
                        ($val['transport_mode_extend'] == 'air' ?  "Air Freight": 
                        ($val['transport_mode_extend'] == 'rail' ? "Rail Freight": 
                        ($val['transport_mode_extend'] == 'road'? "Road Freight": "")));

            $rs[$index]["Vessel/Airline"] = utils::outDisplayForMerge($val['_f_vessel'],$val['Vessel/Airline']);
            $rs[$index]["Voyage/Flight"] = utils::outDisplayForMerge($val['_f_voyage'],$val['Voyage/Flight']);   
                     
            //status 改为ocean_milestone里的信息
            $rs[$index]["Status"] = $rs[$index]["new_status"];

            //po_no 处理 有import 显示import
            $rs[$index]["PO No."] = $rs[$index]["_po_no"];
        }
        common::echo_json_encode(200,array("msg"=>"success","Data" => $rs));
        exit;
    }

    private function _revenue_download(){
        $r2_cloumn = array();
        $r2_cloumn[] = array("title" => "Month","dataIndex"=>"month");
        $r2_cloumn[] = array("title" => "Currency","dataIndex"=>"currency");
        $r2_cloumn[] = array("title" => "Total Amount","dataIndex"=>"invoice_amount");

        $r3_cloumn = array();
        $r3_cloumn[] = array("title" => "Invoice Issue Date","dataIndex"=>"invoice_date");
        $r3_cloumn[] = array("title" => "Invoice Number","dataIndex"=>"invoice_no");
        $r3_cloumn[] = array("title" => "HBL Number","dataIndex"=>"h_bol");
        $r3_cloumn[] = array("title" => "Amount","dataIndex"=>"ivnoice_amount");
        $r3_cloumn[] = array("title" => "Currency","dataIndex"=>"currency");

        $date_from = null;
        $date_to = null;
        if (isset($_REQUEST['date_start']) && !empty($_REQUEST['date_start'])){
            $date_start = common::dateFormatToYM($_REQUEST['date_start']);
            $date_from = $date_start."-01";
        }
        if (isset($_REQUEST['date_end']) && !empty($_REQUEST['date_end'])){
            $date_end = common::dateFormatToYM($_REQUEST['date_end']);
            $date_to = date('Y-m-t', strtotime($date_end."-01"));
        }
        $param = '{"user_login":"'._getLoginName().'","report_type":"ALL","date_from":"'.$date_from.'","date_to":"'.$date_to.'"}';

        //$sql = "SELECT * FROM get_customer_revenue_report('$param');FETCH ALL FROM r2;";
        //$sql = "select * from _test_data_table";
        //$r2_data = common::excuteListSql($sql);
        //只取r3  代码去计总r2 ，避免二次请求数据库
        $sql = "SELECT * FROM get_customer_revenue_report('$param');FETCH ALL FROM r3;";
        //$sql = "select * from _test_data_table_two";
        $r3_data = common::excuteListSql($sql);

        $group_data = array();
        foreach($r3_data as $r3){
            $r3['invoice_date'] = strtoupper(date('M,Y', strtotime($r3['invoice_date'])));
            $group_data[] = $r3;
        }
        //按货币和日期分组
        $groupedItems = array();
        foreach ($group_data as $item) {
            $key = $item['currency']."_".$item['invoice_date'];
            if(array_key_exists($key, $groupedItems)){
                $temp = $groupedItems[$key];
                $temp['invoice_amount'] = $temp['invoice_amount'] + $item['ivnoice_amount'];
                $groupedItems[$key] = $temp;
            }else{
                $groupedItems[$key] = array("month"=>$item['invoice_date'],"currency"=>$item['currency'],"invoice_amount"=>$item['ivnoice_amount']);
            }
        }
        $r2_data = array();
        foreach($groupedItems as $gt){
            $gt['invoice_amount'] = number_format($gt['invoice_amount'], 4, '.', '');
            $r2_data[] = $gt;
        }
        common::echo_json_encode(200,array("msg"=>"success","r2" => $r2_data,"r3"=>$r3_data,"r2_cloumn" => $r2_cloumn,"r3_cloumn" => $r3_cloumn,
           "r2_title"=>"Monthly Summary Data","r3_title"=>"Invoice Detailed Data"));
        exit;
    }
    
    private function _ams_isf_log(){
        include ONLINE_ROOT . 'libs' . DS . 'ams_config.ini.php';
        $ams_ss = $_POST['ams_ss'];
        $isf_ss = $_POST['isf_ss'];

        $amsLog = array();
        //页面固定写死的信息
        $amsLog_column = array();
        $amsLog_column[] = array("title" =>"Date Time","field" =>"atime","formatter" =>"","type" =>"dateTime");
        $amsLog_column[] = array("title" =>"Code","field" =>"cbperrorcode","formatter" =>"","type" =>"normal");
        $amsLog_column[] = array("title" =>"Name","field" =>"isams_submit","formatter" =>"","type" =>"normal");
        $amsLog_column[] = array("title" =>"Description","field" =>"amslog","formatter" =>"","type" =>"normal");
        $amsLog["amsLog_column"] = $amsLog_column;
        $amsLog["msg"] = "Origin have not filed ACE-M1, no data found";
        $amsLog["data"] = array();
        if (_canViewAMSLog()) {
            $s = $ams_ss;
            //$s = "PDLA200127H";
            if (!empty($s)) {
                //$cc = $cbpdb->GetAll("select distinct h_bol from ams_information where md5(md5(from_serial_no)) = '" . pg_escape_string($s) . "'");
                $cc = $cbpdb->GetAll("select distinct h_bol from ams_information where h_bol = '" . pg_escape_string($s) . "'");
                foreach ($cc as $v){
                    $amses[] = $cbpdb->GetAll("select * from ams_info where h_bol = '" . pg_escape_string($v['h_bol']) . "'");
                }
                //考虑一个情况
                if (utils::count($amses) > 0) {
                    $ams = $amses[0];
                    $carrier_hbol = substr($ams[0]['m_bol'], 4);
                    $carrier_scac = substr($ams[0]['m_bol'], 0, 4);
                    if (empty($ams[0]['h_bol'])){
                        $amsLog["msg"] = "Origin have not filed ACE-M1, no data found";
                        $amsLog["data"] = array();
                    }else{
                        $log = $cbpdb->GetAll("select cbpreplytime as atime, amslog, cbperrorcode, isams_submit 
                            from v_e_amslog where hbol = '" . pg_escape_string($ams[0]['h_bol']) . "' 
                            and split_part(stationname, ',', 1) = split_part('" . pg_escape_string($ams[0]['station_name']) . "', ',', 1) 
                            order by cbpreplytime desc, substr(cbperrorcode, 2, 1) desc");

                        $amsLog["msg"] = "";
                        $amsLog["data"] = $log;
                    }
                }
            }
        }

        $isfLog = array();
        //页面固定写死的信息
        $isfLog_column = array();
        $isfLog_column[] = array("title" =>"Date Time","field" =>"atime","formatter" =>"","type" =>"dateTime");
        $isfLog_column[] = array("title" =>"Code","field" =>"cbperrorcode","formatter" =>"","type" =>"normal");
        $isfLog_column[] = array("title" =>"Name","field" =>"isfsubmit","formatter" =>"","type" =>"normal");
        $isfLog_column[] = array("title" =>"Description","field" =>"isflog","formatter" =>"","type" =>"normal");
        $isfLog["isfLog_column"] = $isfLog_column;
        $isfLog["msg"] = "Origin have not filed ISF, no data found";
        $isfLog["data"] = array();
        if (_canViewISFLog()) {
            if (!empty($isf_ss)) {
                $ss = $isf_ss;
                $len = strlen($ss);
                    $b = substr($ss, $len - 7) . substr($ss, 0, $len - 7);

                if (empty($b)){
				    $isfLog["msg"] = "Origin have not filed ISF, no data found";
                    $isfLog["data"] = array();
                }else{
			        $isf = $cbpdb->GetRow("select * from ocean_isf where md5(md5(bol)) = '" . pg_escape_string($b) . "' or md5(md5(substr(bol, 5))) = '" . pg_escape_string($b) . "' order by id desc limit 1");
                }

                if (!empty($isf)) {
                    if (!empty($isf['dob'])){
                        $isf['dob'] = date("m/d/Y", strtotime($isf['dob']));
                    }       
                    $msg = $cbpdb->GetAll("select cbpreplytime as atime, isflog, cbperrorcode, isfsubmit, hbol 
                            from v_e_isflog where (case when coalesce(isf_no, '')<>'' 
                            then isf_no = '" . pg_escape_string($isf["isf_no"]) . "' else hbol = '" . pg_escape_string($isf["bol"]) . "'  
                            and stationname = '" . pg_escape_string($isf["station_name"]) . "' end) 
                            order by cbpreplytime desc, rowid desc");
                    $isfLog["msg"] = "";
                    $isfLog["data"] = $msg;
                }else{
                    $isfLog["msg"] = "Origin have not filed ISF, no data found";
                    $isfLog["data"] = array();
                }
                    
            }
        }

        $data =array("msg"=>"success",
            "canViewAMSLog" => _canViewAMSLog(),
            "canViewISFLog" => _canViewISFLog(),
            "amsLog" =>$amsLog, 
            "isfLog" =>$isfLog);
        common::echo_json_encode(200,$data);
        exit;
    }
    

    private function getEmail($serial_no) {
        return utils::getEmail($serial_no);
    }

    private function getCommunicationNew($serial_no) {
        $list = common::excuteListSql("select to_char(add_time, 'MM/dd/yyyy hh24:MI:ss') as add_times, * from public.online_ocean_communication where email_uuid='$serial_no' and refer_id = 0  order by id");
        $emialRecords =array();
        foreach ($list as $k => $v) {
            $msg =array();
            $msg["name"] = $v["add_by"];
            $msg["creatTime"] = $v["add_times"];
            $msg["content"] =  urldecode($v["web_content"]);
            $emialRecords[] = $msg;
        }
        return $emialRecords;
    }

    /*
     * get file by hbol/destination
     * H：HBL
     * M: MBL
     * F: FL
     * I: C/I & Packing list
     */
    private function getOceanFileByHbol($m_bol, $h_bol, $types, $m_bs, $display, $detail = FALSE,$job_no="") {
        $_schemas = $_REQUEST['_schemas'];
        $types = strtolower($types);
        $types = explode(";", $types);
        $m_bs = explode(";", $m_bs);
        $otheres = NULL;

        $filefilter = " ('TELEX') ";//过滤掉类型，单独配置 3537
        $OutFileURL = common::excuteOneSql("select item_value from config where item='OutFileURL'");
        $file = array();
        foreach ($types as $k => $type) {
            $m_b = $m_bs[$k];
            if (strtolower($m_b) == 'm')
                $sql = "SELECT (SELECT format_name  from $_schemas.ra_online_file_format where serial_no = ra_online_doc_upload.format_serailno) as format_name,
                    from_system,serial_no,file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date from $_schemas.ra_online_doc_upload where (lower(bol) = '" . strtolower($m_bol) . "' or lower(bol) ='".strtolower($job_no)."' ) and lower(format_serailno) = '$type' and upper(coalesce((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2],'')) not in ".$filefilter." order by id desc";
            if (strtolower($m_b) == 'h')
                $sql = "SELECT (SELECT format_name  from $_schemas.ra_online_file_format where serial_no = ra_online_doc_upload.format_serailno) as format_name,
                    from_system,serial_no,file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date from $_schemas.ra_online_doc_upload where lower(bol) =  '" . strtolower($h_bol) . "' and lower(format_serailno) = '$type' and upper(coalesce((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2],'')) not in ".$filefilter." order by id desc";
            if (strtolower($m_b) == 'a')
                $sql = "SELECT (SELECT format_name  from $_schemas.ra_online_file_format where serial_no = ra_online_doc_upload.format_serailno) as format_name,
                    from_system,serial_no,file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date from $_schemas.ra_online_doc_upload where (lower(bol) = '" . strtolower($m_bol) . "' or lower(bol) = '" . strtolower($h_bol) . "' or lower(bol) ='".strtolower($job_no)."') and lower(format_serailno) = '$type' and upper(coalesce((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2],'')) not in ".$filefilter." order by id desc";
            if (!empty($sql)) {
                $rss = common::excuteListSql($sql);
                foreach ($rss as $rs) {
                    if ($rs['from_system']=="TOPOCEAN"||$rs['from_system']=="KSMART") {
                        $file[] = array("url"=>$OutFileURL.'/download.php?_schemas=&a='.base64_encode(base64_encode($rs['serial_no'])),
                            "file_name" => $rs['file_name'],
                            "format_name" => $rs['format_name'],
                            "detail"=>$rs['upload_date'],
                            "can_delete"=>_getLoginName() == $rs['upload_by'],
                            "from_system" =>'TOPOCEAN_KSMART');
                    }else {
                        $file[] = array("url"=>"main_new_version.php?action=ocean_order&operate=download&url=". (common::deCode($rs['file_path'] . DS . $rs['file_name'], 'E')),
                        "file_name" => $rs['file_name'],
                        "format_name" => $rs['format_name'],
                        "detail"=>$rs['upload_date'],
                        "can_delete"=>_getLoginName() == $rs['upload_by'],
                        "from_system" =>'');
                    }
                }
            }
        }
        return $file;
    }

    /*
     * get file by hbol/destination
     * H：HBL
     * M: MBL
     * F: FL
     * I: C/I & Packing list
     */
    private function getAirFileByHbol($m_bol, $h_bol, $types, $m_bs, $display, $detail = FALSE) {
        $_schemas = $_REQUEST['_schemas'];
        $types = explode(";", $types);
        $m_bs = explode(";", $m_bs);
        $filefilter = " ('TELEX') ";//过滤掉类型，单独配置 3537

        $file = array();
        foreach ($types as $k => $type) {
            $m_b = $m_bs[$k];
            if (strtolower($m_b) == 'm')
                $sql = "SELECT (SELECT format_name  from $_schemas.air_file_format where serial_no = air_doc_upload.format_serailno) as format_name,
                    file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date from air_doc_upload where lower(bol) = '" . strtolower($m_bol) . "' and lower(format_serailno) " . common::getInNotInSql($type) . " and upper(coalesce((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2],''))  not in ".$filefilter." order by id desc";
            if (strtolower($m_b) == 'h')
                $sql = "SELECT (SELECT format_name  from $_schemas.air_file_format where serial_no = air_doc_upload.format_serailno) as format_name,
                    file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date from air_doc_upload where lower(bol) =  '" . strtolower($h_bol) . "' and lower(format_serailno) " . common::getInNotInSql($type) . " and upper(coalesce((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2],'')) not in ".$filefilter." order by id desc";
            if (strtolower($m_b) == 'a')
                $sql = "SELECT (SELECT format_name  from $_schemas.air_file_format where serial_no = air_doc_upload.format_serailno) as format_name,
                    file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date from air_doc_upload where (lower(bol) = '" . strtolower($m_bol) . "' or lower(bol) = '" . strtolower($h_bol) . "') and lower(format_serailno) " . common::getInNotInSql($type) . "and upper(coalesce((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2],'')) not in ".$filefilter." order by id desc";
            if (!empty($sql)) {
                $rss = common::excuteListSql($sql);
                foreach ($rss as $rs) {
                    $file[] = array("url"=>"main_new_version.php?action=ocean_order&operate=download&url=". (common::deCode($rs['file_path'] . DS . $rs['file_name'], 'E')),
                        "file_name" => $rs['file_name'],
                        "format_name" => $rs['format_name'],
                        "detail"=>$rs['upload_date'],
                        "can_delete"=>_getLoginName() == $rs['upload_by'],
                        "from_system" =>'');
                }
            }
        }
        return $file;
    }

    /**
     * 批量选着文件下载
     */
    private function _batch_download_load(){
        //ocean的相关配置参数    
        $OutFileURL = common::excuteOneSql("select item_value from config where item='OutFileURL'");
        $ocean_can_view_file = common::excuteOneSql("select ocean_can_view_file from ra_online_user where user_login='".$_SESSION['ONLINE_USER']['user_login']."'");
        //$ocean_can_view_file = '{"HBL":[{"type":"TELEX","value":""}],"MBL":[{"type":"TELEX","value":""}]}';
        $tar = json_decode($ocean_can_view_file,true);
        $sqlFiterWhere = "1<>1 ";
        foreach($tar as $_tar){
            foreach($_tar as $dkey => $dvalue){
                $sqlFiterWhere.= " or (lower(format_serailno) in ('".strtolower(str_replace(";","','",$dvalue['value']))."')  
                    and upper((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2]) = '".$dvalue['type']."')";
            }
        }

        //air的相关配置参数  
        $air_can_view_file = common::excuteOneSql("select air_can_view_file from ra_online_user where lower(user_login)='".strtolower($_SESSION['ONLINE_USER']['user_login'])."'");
        $air_tar = json_decode($air_can_view_file,true);
        $air_sqlFiterWhere = "1<>1 ";
        foreach($air_tar as $_air_tar){
            foreach($_air_tar as $air_dkey => $air_dvalue){
                $air_sqlFiterWhere.= " or (lower(format_serailno) in ('".strtolower(str_replace(";","','",$air_dvalue['value']))."')  
                    and upper((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2]) = '".$air_dvalue['type']."')";
            }
        }

        $vueData = array();
        $serial_no_arr = $_POST['serial_no_arr'];
        $_schemas_arr = $_POST['schemas_arr'];

        foreach($serial_no_arr as $key =>$serial_no){
            $_schemas = $_schemas_arr[$key];
            
            $ocean = common::excuteObjectSql("select m_bol as _m_bol,
                h_bol as _h_bol,
                transport_mode,
                order_from,
                case when transport_mode = 'sea' and order_from = 'public' then (select job_no from public.ocean o  where  o.serial_no = oo.serial_no)
                    when transport_mode = 'sea' and order_from = 'sfs' then (select job_no from sfs.ocean o  where  o.serial_no = oo.serial_no)
                else ''::text end as _job_bol
            from public.kln_ocean oo where oo.serial_no = '$serial_no' and order_from = '$_schemas'");

            $i = $key +1;
            if ($ocean["transport_mode"] == 'sea'){
                //ocean 能看的文件类型
                $document = _getViewDocType($_schemas);
                $file_serial_nos = array();
                foreach ($document as $v) {
                    $types = $v['serial_no'];
                    $types = strtolower($types);
                    $types = explode(";", $types);
                    foreach ($types as $k => $type) {
                        $file_serial_nos[] = $type;
                    }
                }
                $file_serial_nos = utils::implode(';',$file_serial_nos);

                $filefilter = " ('TELEX') ";
                $fileSql = "SELECT ff.format_name,ff.standard,
                            from_system,doc.serial_no,file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date
                        from $_schemas.ra_online_doc_upload doc
                            left join $_schemas.ra_online_file_format ff on ff.serial_no = doc.format_serailno
                    where (lower(bol) = '" . strtolower($ocean['_m_bol']) . "' or lower(bol) = '" . strtolower($ocean['_h_bol']) . "' or lower(bol) = '".strtolower($ocean['_job_bol'])."' )
                        and (
                            (upper(coalesce((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2],'')) not in ".$filefilter.") 
                            or  ".$sqlFiterWhere."
                        ) and lower(format_serailno) " . common::getInNotInSql($file_serial_nos) . "  order by ff.format_name ASC,doc.id desc"; 

                $rss = common::excuteListSql($fileSql);
                $file_arr = array();
                foreach ($rss as $rs) {
                    if ($rs['from_system']=="TOPOCEAN"||$rs['from_system']=="KSMART") {
                        $file_arr[] = array("url"=>$OutFileURL.'/download.php?_schemas=&a='.base64_encode(base64_encode($rs['serial_no'])),
                                    "url_param" =>$OutFileURL.'/download.php?_schemas=&a='.base64_encode(base64_encode($rs['serial_no'])),
                                    "file_name" => $rs['file_name'],
                                    "format_name" => $rs['format_name'],
                                    "standard" => $rs['standard'],
                                    "detail"=>$rs['upload_date'],
                                    "is_topocean" =>true);
                    }else {
                        $file_arr[] = array("url"=>"main_new_version.php?action=ocean_order&operate=download&url=". (common::deCode($rs['file_path'] . DS . $rs['file_name'], 'E')),
                                "url_param" => common::deCode($rs['file_path'] . DS . $rs['file_name'], 'E'),
                                "file_name" => $rs['file_name'],
                                "format_name" => $rs['format_name'],
                                "standard" => $rs['standard'],
                                "detail"=>$rs['upload_date'],
                                "is_topocean" =>false);
                    }
                } 
                $vueData[] = $this->batch_document_upload_Vue_Data($file_arr,$ocean['_h_bol'],$i);   
            }
            if ($ocean["transport_mode"] == 'air'){
                //air能看的文件类型
                $document = _getAirViewDocType($_schemas);
                $file_serial_nos = array();
                foreach ($document as $v) {
                    $types = $v['serial_no'];
                    $types = strtolower($types);
                    $types = explode(";", $types);
                    foreach ($types as $k => $type) {
                        $file_serial_nos[] = $type;
                    }
                }
                $file_serial_nos = utils::implode(';',$file_serial_nos);

                $filefilter = " ('TELEX') ";
                $fileSql = "SELECT ff.format_name,ff.standard,
                            file_path, file_name, upload_by, to_char(upload_date, 'MM/DD/YYYY') as upload_date
                        from $_schemas.air_doc_upload 
                            left join $_schemas.air_file_format ff on ff.serial_no = air_doc_upload.format_serailno
                    where (lower(bol) = '" . strtolower($ocean['_m_bol']) . "' or lower(bol) = '" . strtolower($ocean['_h_bol']) . "')
                        and (
                            (upper(coalesce((string_to_array((string_to_array(file_name,'.'))[1], '_'))[2],'')) not in ".$filefilter.") 
                            or  ".$sqlFiterWhere."
                        ) and lower(format_serailno) " . common::getInNotInSql($file_serial_nos) . "  order by ff.format_name ASC,air_doc_upload.id desc"; 

                $rss = common::excuteListSql($fileSql);
                $file_arr = array();
                foreach ($rss as $rs) {
                    $file_arr[] = array("url"=>"main_new_version.php?action=ocean_order&operate=download&url=". (common::deCode($rs['file_path'] . DS . $rs['file_name'], 'E')),
                                "url_param"=>common::deCode($rs['file_path'] . DS . $rs['file_name'], 'E'),
                                "file_name" => $rs['file_name'],
                                "format_name" => $rs['format_name'],
                                "standard" => $rs['standard'],
                                "detail"=>$rs['upload_date'],
                                "is_topocean" =>false);
                } 
                $vueData[] = $this->batch_document_upload_Vue_Data($file_arr,$ocean['_h_bol'],$i);   
            }
        }
        common::echo_json_encode(200, $vueData);
        exit();
    }

    /*
     * download file
    */
    private function _download() {
        $url = common::deCode($_GET['url'], 'D');
        common::download_file($url);
    }
    
    private function save_vgm() {
        $schemas = $_POST["schemas"];
        $serial_no = common::deCode($_POST["serial_no"], 'D');
        $ocean = common::excuteObjectSql("select m_bol, master_base_number, from_station, h_bol from $schemas.ocean where serial_no='" . common::check_input($serial_no) . "'");
        $contact = common::excuteObjectSql("select company, city, state, zipcode, phone_1, fax, email_1, contactname_1, address_1, address_2, address_3, address_4 from ocean.contacts where contact_id='" . $ocean["from_station"] . "'");
        $address = $contact["address_1"];
        if (!empty($address)) {
            $address .= "\r\n";
        }
        $address .= $contact["address_2"];
        if (!empty($address)) {
            $address .= "\r\n";
        }
        $address .= $contact["address_3"];
        if (!empty($address)) {
            $address .= "\r\n";
        }
        $address .= $contact["address_4"];

        $exists = common::excuteOneSql("select serial_no from $schemas.ocean_vgm_masterbasenumber where master_base_number ilike '" . $ocean["master_base_number"] . "'");

        global $db;
        $db->StartTrans();
        if (empty($_POST["is_send"])) {
            $_POST["is_send"] = 'f';
        }
        if (empty($exists)) {
            $db->Execute("insert into ocean_vgm_masterbasenumber (master_base_number, serial_no) values ('" . $ocean["master_base_number"] . "', '$serial_no');");
            $value["serial_no"] = $serial_no;
            $value["carrier_booking_no"] = $_POST["all_carrier_booking"];
            $value["modify_user"] = _getLoginName();
            $value["modify_time"] = "now()";
            $value["authorized_email"] = !empty($_POST["authorized_email"]) ? $_POST["authorized_email"] : "";
            $value["authorized_tel"] = !empty($_POST["authorized_tel"]) ? $_POST["authorized_tel"] : "";
            $value["authorized_company"] = !empty($_POST["submitter"]) ? $_POST["submitter"] : "";
            $value["signature"] = !empty($_POST["signature"]) ? $_POST["signature"] : "";
            $value["is_send"] = $_POST["is_send"];
            $value["action"] = "New";
            $value["type"] = "Shipper";

            $value["m_bol"] = $ocean["m_bol"];
            $value["master_base_number"] = $ocean["master_base_number"];
            $value["shipper_id"] = $ocean["from_station"];
            $value["shipper"] = $contact["company"];
            $value["shipper_address"] = $address;
            $value["shipper_contactname"] = $contact["contactname_1"];
            $value["shipper_email"] = $contact["email_1"];
            $value["shipper_fax"] = $contact["fax"];
            $value["shipper_telephone"] = $contact["phone_1"];
            $value["update_uuid"] = utils::uuid();
            $value["h_bol"] = $ocean["h_bol"];
            $value["from_station"] = $ocean["from_station"];

            $sql = common::getInsertSqlNull("$schemas .ocean_vgm", $value);
            $db->Execute($sql);
        } else {
            $serial_no = $exists;
            $db->Execute("update ocean_vgm_masterbasenumber set id=id where master_base_number ilike '" . $ocean["master_base_number"] . "';");

            $db->Execute("update $schemas.ocean_vgm set is_send='" . $_POST["is_send"] . "', carrier_booking_no='" . $_POST["all_carrier_booking"] . "', modify_user='" . _getLoginName() . "', modify_time=now(),"
                    . "authorized_email='" . $_POST["authorized_email"] . "', authorized_tel='" . $_POST["authorized_tel"] . "', authorized_company='" . $_POST["submitter"] . "', signature='" . $_POST["signature"] . "', send_time=null "
                    . ", update_uuid='" . utils::uuid() . "' where master_base_number ilike '" . $ocean["master_base_number"] . "';");
        }
        $db->Execute("delete from ocean_vgm_container where serial_no ilike '" . $serial_no . "';");

        foreach ($_POST["container_no"] as $i => $cv) {
            $value1["serial_no"] = $serial_no;
            $value1["carrier_booking_no"] = !empty($_POST["carrier_booking_no"][$i]) ? $_POST["carrier_booking_no"][$i] : "";
            $value1["ctnr"] = !empty($_POST["container_no"][$i]) ? $_POST["container_no"][$i] : "";
            $value1["size"] = !empty($_POST["size"][$i]) ? $_POST["size"][$i] : "";
            $value1["vgm_weight"] = !empty($_POST["vgm_weight"][$i]) ? $_POST["vgm_weight"][$i] : "";
            $value1["unit"] = !empty($_POST["vgm_kg_lg"][$i]) ? $_POST["vgm_kg_lg"][$i] : "";
            $value1["vgm_time"] = !empty($_POST["vgm_date"][$i]) ? $_POST["vgm_date"][$i] : "";
            $value1["cargo_weight_kgs"] = !empty($_POST["cargo_weight_kg"][$i]) ? $_POST["cargo_weight_kg"][$i] : "";
            $value1["cargo_weight_lbs"] = !empty($_POST["cargo_weight_lb"][$i]) ? $_POST["cargo_weight_lb"][$i] : "";
            $value1["vgm_method"] = !empty($_POST["vgm_method"][$i]) ? $_POST["vgm_method"][$i] : "";
            $value1["master_base_number"] = $ocean["master_base_number"];

            $sql = common::getInsertSqlNull("$schemas.ocean_vgm_container", $value1);
            $db->Execute($sql);
        }

        if ($db->CompleteTrans() === FALSE) {
            return "error";
        } else {
            return "success";
        }
    }

    private function getOceanDetail($serial_no) {
        $order_from = $_REQUEST['_schemas'];
        $_schemas = $_REQUEST['_schemas'];
        if($_schemas == 'public'){
            $_schemas = "ocean";
        }
        $sql = "with o as(
            SELECT  o.* from $order_from.ocean o where serial_no = '" . $serial_no . "'
        )
        SELECT m_eta as _m_eta,  h_bol as _h_bol, m_bol as _m_bol,job_no as _job_bol,
                o.* ,sh.*, cn.* ,aa.*,dd.*,fd.*,oo.*,koe.loadterm,
                COALESCE(koe.import_po_no,oo.po_no) as _po_no
        from o 
        LEFT JOIN LATERAL ( SELECT tracking_no as _tracking_no,shippr_uncode,shipper_city,
                    consignee_uncode,consignee_city,incoterms,
                    fport_of_loading_un,
                    mport_of_discharge_un,
                    place_of_receipt_un,
                    place_of_delivery_un,
                    etd as oo_etd,
                    eta as oo_eta,
                    atd as oo_atd,
                    ata as oo_ata,
                    carbon_emission,
                    transport_mode_extend,
                    port_of_transshipment_un,
                    (select time_zone from public.city_timezone where uncode = oo.fport_of_loading_un limit 1) as pol_timezone,
                    (select uncity from $order_from.ports where uncode = oo.fport_of_loading_un limit 1) as pol_uncity,
                    (select time_zone from public.city_timezone where uncode = oo.mport_of_discharge_un limit 1) as mpod_timezone,
                    (select uncity from $order_from.ports where uncode = oo.mport_of_discharge_un limit 1) as mpod_uncity,
                    (select time_zone from public.city_timezone where uncode = oo.place_of_receipt_un limit 1) as por_timezone,
                    (select uncity from $order_from.ports where uncode = oo.place_of_receipt_un limit 1) as por_uncity,
                    (select time_zone from public.city_timezone where uncode = oo.place_of_delivery_un limit 1) as pod_timezone,
                    (select uncity from $order_from.ports where uncode = oo.place_of_delivery_un limit 1) as pod_uncity,
                    (select time_zone from public.city_timezone where uncode = oo.final_desination_uncode limit 1) as _fd_timezone,
                    (select uncity from $order_from.ports where uncode = oo.final_desination_uncode limit 1) as _pd_uncity,
                    invoice_no as _invoice_no,
                    oo.po_no,
                    CASE
                        WHEN ((m_iffbcf is not null or m_iffbcf is null) and m_iffcpu is null and m_iffrec is null and m_iffdep is null and m_iffarr is null and m_iffdel is null) THEN 'Created'::text
                        WHEN ((m_iffcpu is not null or m_iffrec is not null) and m_iffdep is null and m_iffarr is null and m_iffdel is null) THEN 'Cargo Received'::text
                        WHEN (m_iffdep is not null and m_iffarr is null and m_iffdel is null) THEN 'Departed'::text
                        WHEN (m_iffarr is not null and m_iffdel is null) THEN 'Arrived'::text
                        WHEN (m_iffdel is not null) THEN 'Completed'::text
                        ELSE 'Created'::text
                    END AS new_status
                FROM  public.kln_ocean oo WHERE oo.serial_no::text = o.serial_no::text and order_from = '$order_from') oo ON true
            LEFT JOIN LATERAL ( SELECT loadterm,import_po_no
                FROM public.kln_ocean_extend  koe WHERE koe.serial_no::text = o.serial_no::text and koe.order_from = '$order_from') koe ON true    
            LEFT JOIN LATERAL ( SELECT company as cn_company,
                address_1 as cn_address_1,
                address_2 as cn_address_2,
                address_3 as cn_address_3,
                address_4 as cn_address_4,
                city as cn_city, state as cn_state, zipcode as cn_zipcode, country as cn_country,
                phone_1 as cn_phone
            FROM $_schemas.contacts c WHERE o.consignee::text = c.contact_id::text) cn ON true
            LEFT JOIN LATERAL ( SELECT company as sh_company,
                address_1 as sh_address_1,
                address_2 as sh_address_2,
                address_3 as sh_address_3,
                address_4 as sh_address_4,
                city as sh_city, state as sh_state, zipcode as sh_zipcode, country as sh_country,
                phone_1 as sh_phone
            FROM $_schemas.contacts c WHERE o.shipper::text = c.contact_id::text) sh ON true
            LEFT JOIN LATERAL ( SELECT company as aa_company,
                address_1 as aa_address_1,
                address_2 as aa_address_2,
                address_3 as aa_address_3,
                address_4 as aa_address_4,
                city as aa_city, state as aa_state, zipcode as aa_zipcode, country as aa_country,
                phone_1 as aa_phone,
                (select time_zone from public.city_timezone where uncode = LEFT(c.country, 2) || COALESCE(c.city_code,'') limit 1) as aa_timezone
            FROM $_schemas.contacts c WHERE o.origin_station::text = c.contact_id::text) aa ON true
            LEFT JOIN LATERAL ( SELECT company as dd_company,
                address_1 as dd_address_1,
                address_2 as dd_address_2,
                address_3 as dd_address_3,
                address_4 as dd_address_4,
                city as dd_city, state as dd_state, zipcode as dd_zipcode, country as dd_country,
                phone_1 as dd_phone,
                (select time_zone from public.city_timezone where uncode = LEFT(c.country, 2) || COALESCE(c.city_code,'') limit 1) as dd_timezone
            FROM $_schemas.contacts c WHERE o.destination_station::text = c.contact_id::text) dd ON true
            LEFT JOIN LATERAL ( SELECT 
                city as fd_city,
                (select time_zone from public.city_timezone where uncode = LEFT(c.country, 2) || COALESCE(c.city_code,'') limit 1) as fd_timezone
            FROM $_schemas.contacts c WHERE o.final_desination::text = c.contact_id::text) fd ON true";
        //error_log($sql);
        return $sql;
    }

    private function getAirDetail($serial_no) {
        $order_from = $_REQUEST['_schemas'];
        $_schemas = $_REQUEST['_schemas'];
        if($_schemas == 'public'){
            $_schemas = "ocean";
        }
        $sql = "with o as(
            SELECT  oo.*,m_bol as _m_bol, h_bol as _h_bol,
                    (select time_zone from public.city_timezone where uncode = oo.fport_of_loading_un limit 1) as pol_timezone,
                    (select city from sfs.airport where coalesce(airport.country_abb,'')||airport.airport_code = oo.fport_of_loading_un limit 1) as pol_uncity,
                    (select time_zone from public.city_timezone where uncode = oo.mport_of_discharge_un limit 1) as mpod_timezone,
                    (select city from sfs.airport where coalesce(airport.country_abb,'')||airport.airport_code = oo.mport_of_discharge_un limit 1) as mpod_uncity,
                    (select time_zone from public.city_timezone where uncode = oo.place_of_receipt_un limit 1) as por_timezone,
                    (select city from sfs.airport where coalesce(airport.country_abb,'')||airport.airport_code = oo.place_of_receipt_un limit 1)  as por_uncity,
                    (select time_zone from public.city_timezone where uncode = oo.place_of_delivery_un limit 1) as pod_timezone,
                    (select city from sfs.airport where coalesce(airport.country_abb,'')||airport.airport_code = oo.place_of_delivery_un limit 1) as pod_uncity,
                    (select time_zone from public.city_timezone where uncode = oo.final_desination_uncode limit 1) as _fd_timezone,
                    (select city from sfs.airport where coalesce(airport.country_abb,'')||airport.airport_code = oo.final_desination_uncode limit 1) as _pd_uncity,
                    CASE
                        WHEN ((m_iffbcf is not null or m_iffbcf is null) and m_iffcpu is null and m_iffrec is null and m_iffdep is null and m_iffarr is null and m_iffdel is null) THEN 'Created'::text
                        WHEN ((m_iffcpu is not null or m_iffrec is not null) and m_iffdep is null and m_iffarr is null and m_iffdel is null) THEN 'Cargo Received'::text
                        WHEN (m_iffdep is not null and m_iffarr is null and m_iffdel is null) THEN 'Departed'::text
                        WHEN (m_iffarr is not null and m_iffdel is null) THEN 'Arrived'::text
                        WHEN (m_iffdel is not null) THEN 'Completed'::text
                        ELSE 'Created'::text
                    END AS new_status
            from public.kln_ocean oo where oo.serial_no = '" . $serial_no . "' and oo.order_from = '$order_from'
        )
        SELECT  o.* ,sh.*, cn.*,
                aa.*,dd.*,fd.*,air.*
        from o 
            LEFT JOIN LATERAL ( SELECT  departure_airport_name as fport_of_loading_exp,
                destination_airport_name as mport_of_discharge_exp,
                mawb as _mawb, mawb_name as _mawb_name, hawb as _hawb
            FROM $order_from.air a WHERE a.serial_no = o.serial_no) air ON true
            LEFT JOIN LATERAL ( SELECT company as cn_company,
                address_1 as cn_address_1,
                address_2 as cn_address_2,
                address_3 as cn_address_3,
                address_4 as cn_address_4,
                city as cn_city, state as cn_state, zipcode as cn_zipcode, country as cn_country,
                phone_1 as cn_phone
            FROM $_schemas.contacts c WHERE o.consignee_id::text = c.contact_id::text) cn ON true
            LEFT JOIN LATERAL ( SELECT company as sh_company,
                address_1 as sh_address_1,
                address_2 as sh_address_2,
                address_3 as sh_address_3,
                address_4 as sh_address_4,
                city as sh_city, state as sh_state, zipcode as sh_zipcode, country as sh_country,
                phone_1 as sh_phone
            FROM $_schemas.contacts c WHERE o.shipper_id::text = c.contact_id::text) sh ON true
            LEFT JOIN LATERAL ( SELECT company as aa_company,
                address_1 as aa_address_1,
                address_2 as aa_address_2,
                address_3 as aa_address_3,
                address_4 as aa_address_4,
                city as aa_city, state as aa_state, zipcode as aa_zipcode, country as aa_country,
                phone_1 as aa_phone,
                (select time_zone from public.city_timezone where uncode = LEFT(c.country, 2) || COALESCE(c.city_code,'') limit 1) as aa_timezone
            FROM $_schemas.contacts c WHERE o.origin::text = c.contact_id::text) aa ON true
            LEFT JOIN LATERAL ( SELECT company as dd_company,
                address_1 as dd_address_1,
                address_2 as dd_address_2,
                address_3 as dd_address_3,
                address_4 as dd_address_4,
                city as dd_city, state as dd_state, zipcode as dd_zipcode, country as dd_country,
                phone_1 as dd_phone,
                (select time_zone from public.city_timezone where uncode = LEFT(c.country, 2) || COALESCE(c.city_code,'') limit 1) as dd_timezone
            FROM $_schemas.contacts c WHERE o.agent::text = c.contact_id::text) dd ON true
            LEFT JOIN LATERAL ( SELECT 
                city as fd_city,
                (select time_zone from public.city_timezone where uncode = LEFT(c.country, 2) || COALESCE(c.city_code,'') limit 1) as fd_timezone
            FROM $_schemas.contacts c WHERE o.final_desination::text = c.contact_id::text) fd ON true";
        //error_log($sql);
        return $sql;
    }

    private function returnOceanDetailData($ocean,$state){
        $data = array();
        //由于这些基础数据还待完善，而且现在提单样式改版也没有显示客户自身的地址数据，所以我们这边的这个取值也要麻烦调整一下：
        //1.Shipment detail顶部的Origin和Destination的取值换成Place of Receipt、Place of Delivery的UNCODE
        //2.Tracking列表页里面字段Origin和Destination先隐藏（客户地址），不做展示
        $ocean['shippr_uncode'] = $ocean['place_of_receipt_un'];
        $ocean['consignee_uncode'] = $ocean['place_of_delivery_un'];

        //delivery
        $order_from = $_REQUEST['_schemas'];
        $deliverySql = "with aa as (SELECT o.serial_no, o.master_base_number from  $order_from.ocean o WHERE o.serial_no='".$ocean["serial_no"]."'),             
                            h as (select * from station_data.do_header h where h.serial_no in (select serial_no from aa))
                    
                    select h.est_delivery_date,h.est_delivery_time,
                        h.consignee_country_code,h.consignee_city_code,
                        (select time_zone from public.city_timezone where uncode = CONCAT(h.consignee_country_code, h.consignee_city_code) limit 1) as timezone,
                        d.ctnr 
                    from h inner join station_data.do_detail d on h.id = d.do_header_id and h.from_station = d.from_station 
                        where h.from_station = '".$ocean["destination_station"]."'
                            order by h.est_delivery_date";
        // bb as (select o.serial_no from $order_from.ocean o
        //                             where exists(select 1 from aa where aa.master_base_number= o.master_base_number) 
        //                                 and o.bol_type = 'CONSOL' and o.status::text <> 'Cancelled'::text),                    
        // $deliverySql = "with aa as (SELECT o.serial_no, o.master_base_number from  $order_from.ocean o WHERE o.serial_no='".$ocean["serial_no"]."'),
        //                     bb as (select o.serial_no from $order_from.ocean o
        //                             where exists(select 1 from aa where aa.master_base_number= o.master_base_number) 
        //                                 and o.bol_type = 'CONSOL' and o.status::text <> 'Cancelled'::text),
        //                     cc as (select serial_no from aa 
        //                             union all 
        //                             select serial_no from bb 
        //                         ),              
        //                     h as (select * from do_header h where h.serial_no = (select serial_no from cc))
                    
        //             select h.est_delivery_date,h.est_delivery_time,
        //                 h.consignee_country_code,h.consignee_city_code,
        //                 (select time_zone from public.city_timezone where uncode = CONCAT(h.consignee_country_code, h.consignee_city_code) limit 1) as timezone,
        //                 d.ctnr 
        //             from h left join do_detail d on h.do_serial_no = d.do_serial_no  order by h.est_delivery_date";            

        $delivery = common::excuteListSql($deliverySql);            

        /* Container Status */
        //Container_Status　新版只显示几个状态， CTNR# EE Ｉ AE VD VA
        //记录所有的信息 EDI315TimeAndLocation
        $EDIDate = common::getEDI315StatusForDetail($ocean["serial_no"]);
        $deliveredData = array();
        $deliveredChildrenDate = "";
        if(!empty($delivery)){
            foreach($delivery as $_delivery){
                //添加containerStatusData的delivery
                $est_delivery_date = $_delivery["est_delivery_date"];
                if (!empty($_delivery["est_delivery_time"])) {
                    $est_delivery_date.= " " . $_delivery["est_delivery_time"];
                }

                $location_code = $_delivery["consignee_country_code"]."".$_delivery["consignee_city_code"];

                foreach($EDIDate['containerStatusData'] as $cskey => $csval){
                    if($csval['ctnr_label'] == $_delivery['ctnr']){
                        $_uncity = common::excuteObjectSql("select uncity from $order_from.ports where active = true and uncode = '".strtoupper($location_code)."' limit 1");
                        $contentTemp = array("title" =>"Last Mile Delivery",
                                "code"=>"UN-".$location_code,
                                "date"=>$est_delivery_date,
                                "country"=>$location_code,
                                "uncity"=>$_uncity['uncity'],
                                "timezone"=>$_delivery['timezone']);
                        $originalArray = $EDIDate['containerStatusData'][$cskey]['content'];
                        //$this->insertInDescendingOrder($originalArray, $contentTemp);
                        array_unshift($originalArray, $contentTemp);
                        //排序后重新赋值
                        $EDIDate['containerStatusData'][$cskey]['content'] = $originalArray;

                    }
                }
                //添加simplexData的delivery
                $deliveredData[] = array("label" =>"Delivered","date"=>$est_delivery_date,"location"=>$location_code,
                    "container"=>$_delivery['ctnr'],'timezone'=>$_delivery['timezone']);
                $deliveredChildrenDate =  $_delivery["est_delivery_date"];  
            }
        }

        $data['containerStatusData'] = $EDIDate['containerStatusData'];
        $data['EDI315TimeAndLocation'] = $EDIDate['EDI315TimeAndLocation'];
        $VD = $EDIDate['VD'];
        $VA = $EDIDate['VA'];

        //处理shipment data
        $ocean_milestone_status = common::excuteListSql("select code,
                act_date,est_date,timezone 
            from  ocean_milestone a 
		 		where a.serial_no='".$ocean["serial_no"]."' and code in('IFFREC','IFFONB','IFFDEP','IFFARR','IFFDEL')
            order by id");
        $ocean_milestone_status_code = array();
        foreach($ocean_milestone_status as $oms){
            $ocean_milestone_status_code[$oms['code']] = $oms;
        }
        
        if ($state < 1){
            //未发生前
            if(!empty($ocean_milestone_status_code['IFFDEP']['est_date'])){
                //如果milestone有值，或者与milestone不等，以milestone的优先度最高
                //$ocean['f_etd'] = $ocean_milestone_status_code['IFFDEP']['est_date'];
            } 
        } else{
            if(!empty($ocean_milestone_status_code['IFFDEP']['act_date'])){
                //如果milestone有值，或者与milestone不等，以milestone的优先度最高
                //$ocean['atd'] = $ocean_milestone_status_code['IFFDEP']['act_date'];
            }
        }    
        //先处理一下 ATD 和 ATA,在进行后面的取值
        if(empty($ocean['atd']) && !empty($VD)){
            //$ocean['atd'] = $VD;
        }
        if(empty($ocean['ata']) && !empty($VA)){
            //$ocean['ata'] = $VA;
        } 

        $simplexData = array();
        //place_of_Receipt
        $place_of_Receipt_stauts =  array("index" =>1,"label" =>"Place of Receipt",
            "path" =>$ocean['place_of_receipt_exp']."/".$ocean['place_of_receipt_un'],"isArrival" =>$state >= 0 ? true : false);
        $children = array();  
        if($state >= 1 && !empty($ocean_milestone_status_code['IFFREC']['act_date'])){
            //发生后，未发生前没有
            $children[] = array("label" =>"Cargo Received","date" =>$ocean_milestone_status_code['IFFREC']['act_date']);
        }
        $place_of_Receipt_stauts["children"] = $children;
        $simplexData[] = $place_of_Receipt_stauts;

        //port_of_Loading
        $port_of_Loading_stauts = array("index" =>2,"label" =>"Port of Loading",
            "path" =>$ocean['fport_of_loading_exp']."/".$ocean['fport_of_loading_un'],"isArrival" =>$state >= 1 ? true : false);
        $children = array();  
        if ($state < 1){
            $children[] = array("label" =>"Departure(ETD)","date" =>$ocean['f_etd']);
        } else{
            if(!empty($ocean_milestone_status_code['IFFONB']['act_date'])){
                $children[] = array("label" =>"On board","date" =>$ocean_milestone_status_code['IFFONB']['act_date']);
            }
            $children[] = array("label" =>"Departure(ATD)","date" =>$ocean['atd']);
        }                 
        $port_of_Loading_stauts["children"] = $children;        
        $simplexData[] = $port_of_Loading_stauts;

        //Port of Discharge
        $port_of_Discharge_status = array("index" =>3,"label" =>"Port of Discharge",
            "path" =>$ocean['mport_of_discharge_exp']."/".$ocean['mport_of_discharge_un'],"isArrival" =>$state >= 2 ? true : false);
        $children = array(); 
        // if ($state < 2){
        //     //未发生前
        //     if(!empty($ocean_milestone_status_code['IFFARR']['est_date'])){
        //         $children[] = array("label" =>"Arrival(ETA)","date" =>$ocean_milestone_status_code['IFFARR']['est_date']);
        //     }else{
        //         //没有,取eta
        //         $children[] = array("label" =>"Arrival(ETA)","date" =>$ocean['m_eta']);
        //     }
        // } else{
        //     if(!empty($ocean_milestone_status_code['IFFARR']['act_date'])){
        //         $children[] = array("label" =>"Arrival(ATA)","date" =>$ocean_milestone_status_code['IFFARR']['act_date']);
        //     }
        // } 
        //不需要判断是否发送，根据 milestone 和m_eta 的同步关系，这里m_eta 优先度最高
        if ($state < 2){
            $children[] = array("label" =>"Arrival(ETA)","date" =>$ocean['m_eta']);
        }else{
            $children[] = array("label" =>"Arrival(ATA)","date" =>$ocean['ata']);
        }             
        $port_of_Discharge_status["children"] = $children;     
        $simplexData[] = $port_of_Discharge_status;

        //Place of Delivery
        $place_of_Delivery_status = array("index" =>4,"label" =>"Place of Delivery",
            "path" =>$ocean['place_of_delivery_exp']."/".$ocean['place_of_delivery_un'],"isArrival" =>$state == 3 ? true : false);
        $children = array(); 
        if ($state < 3){
            //未发生前
        } else{
            if(!empty($ocean_milestone_status_code['IFFDEL']['act_date'])){
                $children[] = array("label" =>"Cargo handover/Delivered","date" =>$ocean_milestone_status_code['IFFDEL']['act_date']);
            }
        }
        if(!empty($deliveredChildrenDate)){
            $children[] = array("label" =>"Delivered","date" =>$deliveredChildrenDate);
        }

        $place_of_Delivery_status["children"] = $children;
        $place_of_Delivery_status["deliveredData"] = $deliveredData;     
        $simplexData[] = $place_of_Delivery_status;
        $data['shipmentData'] = $simplexData;

        //处理transportInfo信息数据(air改过，从KLN_Ocean主表信息 etd 和eta 的取值跟ocean的f_etd,m_eta)
        $_mode =  $ocean['transport_mode_extend'] == 'sea' ? "Ocean Freight" : 
                        ($ocean['transport_mode_extend'] == 'air' ?  "Air Freight": 
                        ($ocean['transport_mode_extend'] == 'rail' ? "Rail Freight": 
                        ($ocean['transport_mode_extend'] == 'road' ? "Road Freight": "")));

        $transportInfo = array("Tracking No." =>$ocean['_tracking_no'],"status"=>$ocean['new_status'],"mode" => $_mode,
            "origin" =>$ocean['shippr_uncode'],"destination" =>$ocean['consignee_uncode'],
            "etd" =>$ocean['f_etd'],"atd" =>$ocean['atd'],
            "etd_timezone" =>$ocean['pol_timezone'],
            "atd_timezone" =>$ocean['pol_timezone'],
            "eta" =>$ocean['m_eta'],"ata" =>$ocean['ata'],
            "eta_timezone" =>$ocean['mpod_timezone'],
            "ata_timezone" =>$ocean['mpod_timezone']);
        $data['transportInfo'] = $transportInfo;

        //处理basicInfo信息数据
        $vessel = utils::outDisplayForMerge($ocean['f_vessel'],$ocean['m_vessel']);
        $voyage = utils::outDisplayForMerge($ocean['f_voyage'],$ocean['m_voyage']);
        $basicInfo = array("MAWB/MBL No." =>$ocean['m_bol'],"HAWB/HBOL" => $ocean['h_bol'],"Carrier_Booking_No" =>$ocean['booking_no'],
            "PO_NO" =>$ocean['_po_no'],"Vessel/Airline" =>$vessel,"Voyage/Filght" =>$voyage,
            "Incoterm" =>$ocean['incoterms'],"Service_Type" =>$ocean['service'],
            "CO2 Emission" =>$ocean['carbon_emission'],"Load Terms" =>$ocean['loadterm'],
            "Shipment Type" =>$ocean['manifest_type'] == "GPE" ? "LCL" : $ocean['manifest_type']);
        $data['basicInfo'] = $basicInfo;    

        //处理 拼接地址 ocean表单exp 字段无法精准分割电话和地址信息，只能从contacts表里查询
        $shipper_address = common::retStationInfo($ocean['sh_address_1'], $ocean['sh_address_2'], $ocean['sh_address_3'], $ocean['sh_address_4'], 
            $ocean['sh_city'], $ocean['sh_state'], $ocean['sh_zipcode'], $ocean['sh_country']);
        $consignee_address = common::retStationInfo($ocean['cn_address_1'], $ocean['cn_address_2'], $ocean['cn_address_3'], $ocean['cn_address_4'], 
            $ocean['cn_city'], $ocean['cn_state'], $ocean['cn_zipcode'], $ocean['cn_country']);
        $origin_address = common::retStationInfo($ocean['aa_address_1'], $ocean['aa_address_2'], $ocean['aa_address_3'], $ocean['aa_address_4'], 
            $ocean['aa_city'], $ocean['aa_state'], $ocean['aa_zipcode'], $ocean['aa_country']); 
        $destination_address = common::retStationInfo($ocean['dd_address_1'], $ocean['dd_address_2'], $ocean['dd_address_3'], $ocean['dd_address_4'], 
            $ocean['dd_city'], $ocean['dd_state'], $ocean['dd_zipcode'], $ocean['dd_country']);    

        $shipperPartners = array("company" =>$ocean['sh_company'],"address"=>$shipper_address,"phone"=>$ocean['sh_phone']);
        $consigneePartners = array("company" =>$ocean['cn_company'],"address"=>$consignee_address,"phone"=>$ocean['cn_phone']);
        $originPartners = array("company" =>$ocean['aa_company'],"address"=>$origin_address,"phone"=>$ocean['aa_phone']);
        $destinationPartners = array("company" =>$ocean['dd_company'],"address"=>$destination_address,"phone"=>$ocean['dd_phone']);
        $businessPartners = array("shipper"=>$shipperPartners,"consignee" => $consigneePartners,"origin" => $originPartners,"destination" => $destinationPartners);
        $data['businessPartners'] = $businessPartners;  
    
        //处理routes 转船可能有多个情况
        if ($ocean['is_vessel_direct'] <> "t"){
            //不是直航
            $routes = array(array("mode" =>$_mode,"mode_label" =>"Sea", "origin" =>$ocean['shippr_uncode'],
                "destination" => $ocean['port_of_transshipment_un'],
                "etd" => $ocean['f_etd'],"atd" => $ocean['atd'],
                "eta" =>$ocean['f_eta'],"ata" =>$EDIDate['VA_RELAY'],
                "vessel" =>$ocean['f_vessel'],"voyageNo" =>$ocean['f_voyage']));
            $routes[] = array("mode" =>$_mode, "mode_label" =>"Sea","origin" =>$ocean['port_of_transshipment_un'],
                "destination" => $ocean['consignee_uncode'],
                "etd" => $ocean['m_etd'],"atd" => $EDIDate['VD_RELAY'],
                "eta" =>$ocean['m_eta'],"ata" =>$ocean['ata'],
                "vessel" =>$ocean['m_vessel'],"voyageNo" =>$ocean['m_voyage']);
        }else{
            $routes = array(array("mode" =>$_mode,"mode_label" =>"Sea", "origin" =>$ocean['shippr_uncode'],
                "destination" => $ocean['consignee_uncode'],
                "etd" => $ocean['f_etd'],"atd" => $ocean['atd'],
                "eta" =>$ocean['m_eta'],"ata" => $ocean['ata'],
                "vessel" =>$ocean['f_vessel'],"voyageNo" =>$ocean['f_voyage']));
        }
        $data['routes'] = $routes;
        
        //处理marksAndDescription
        $notes = common::excuteListSql("select notes from station_data.ocean_notes on2 where serial_no='".$ocean["serial_no"]."' and type_code = 'AO'");
        $remark = "";
        foreach($notes as $note){
            if(!empty($note['notes'])){
                $remark.=$note['notes']."\r\n";
            }
        }
        $marksAndDescription = array("marks"=>$ocean['marks'],"description"=>$ocean['description'],"remark"=>$remark);
        $data['marksAndDescription'] = $marksAndDescription;

        return $data;    
    }

    private function returnAirDetailData($ocean,$ocean_milestone_status,$state){
        $data = array();
        //由于这些基础数据还待完善，而且现在提单样式改版也没有显示客户自身的地址数据，所以我们这边的这个取值也要麻烦调整一下：
        //1.Shipment detail顶部的Origin和Destination的取值换成Place of Receipt、Place of Delivery的UNCODE
        //2.Tracking列表页里面字段Origin和Destination先隐藏（客户地址），不做展示
        //Origin和Destination的展示，能不能Origin of Cargo有值就用Origin of Cargo，Origin of Cargo就放Departure Airport? Destination也一樣？
        $ocean['shippr_uncode'] = !empty($ocean['place_of_receipt_un'])? $ocean['place_of_receipt_un'] : $ocean['fport_of_loading_un'];
        $ocean['consignee_uncode'] = !empty($ocean['place_of_delivery_un']) ? $ocean['place_of_delivery_un'] : $ocean['mport_of_discharge_un'];

        //处理shipment data
        $ocean_milestone_status_code = array();
        foreach($ocean_milestone_status as $oms){
            $ocean_milestone_status_code[$oms['code']] = $oms;
        }
        if ($state < 1){
            //未发生前
            if(!empty($ocean_milestone_status_code['IFFONB']['est_date'])){
                //如果milestone有值，或者与milestone不等，以milestone的优先度最高
                //$ocean['etd'] = $ocean_milestone_status_code['IFFONB']['est_date'];
            } 
        } else{
            if(!empty($ocean_milestone_status_code['IFFONB']['act_date'])){
                //如果milestone有值，或者与milestone不等，以milestone的优先度最高
                //ATD 取值为IFFONB milestone实际发生的时间
                //$ocean['atd'] = $ocean_milestone_status_code['IFFONB']['act_date'];
            }
        }

        $simplexData = array();
        //place_of_Receipt
        $place_of_Receipt_stauts =  array("index" =>1,"label" =>"Place of Receipt",
            "path" =>$ocean['place_of_receipt_exp']."/".$ocean['place_of_receipt_un'],"isArrival" =>$state >= 0 ? true : false);
        $children = array();  
        if($state >= 1 && !empty($ocean_milestone_status_code['IFFCPU']['act_date'])){
            //发生后，未发生前没有
            $children[] = array("label" =>"Cargo Received","date" =>$ocean_milestone_status_code['IFFCPU']['act_date']);
        }
        $place_of_Receipt_stauts["children"] = $children;
        $simplexData[] = $place_of_Receipt_stauts;

        //port_of_Loading
        $port_of_Loading_stauts = array("index" =>2,"label" =>"Port of Loading",
            "path" =>$ocean['fport_of_loading_exp']."/".$ocean['fport_of_loading_un'],"isArrival" =>$state >= 1 ? true : false);
        $children = array();  
        if ($state < 1){
            $children[] = array("label" =>"Departure(ETD)","date" =>$ocean['etd']);
        } else{
            if(!empty($ocean_milestone_status_code['IFFREC']['act_date'])){
                $children[] = array("label" =>"Cargo Received","date" =>$ocean_milestone_status_code['IFFREC']['act_date']);
            }
            if(!empty($ocean_milestone_status_code['IFFONB']['act_date'])){
                $children[] = array("label" =>"Departure(ATD)","date" =>$ocean_milestone_status_code['IFFONB']['act_date']);
            }
        }                 
        $port_of_Loading_stauts["children"] = $children;        
        $simplexData[] = $port_of_Loading_stauts;

        //Port of Discharge
        $port_of_Discharge_status = array("index" =>3,"label" =>"Port of Discharge",
            "path" =>$ocean['mport_of_discharge_exp']."/".$ocean['mport_of_discharge_un'],"isArrival" =>$state >= 2 ? true : false);
        $children = array(); 
        if ($state < 2){
            $children[] = array("label" =>"Arrival(ETA)","date" =>$ocean['eta']);
        }else{
            if(!empty($ocean_milestone_status_code['IFFARR']['act_date'])){
                $children[] = array("label" =>"Arrival(ATA)","date" =>$ocean_milestone_status_code['IFFARR']['act_date']);
                $ocean['ata'] = $ocean_milestone_status_code['IFFARR']['act_date'];
            }else{
                //IFFARR 如果同步异常没有值时，去表里的 ata_date AS ata
                $children[] = array("label" =>"Arrival(ATA)","date" =>$ocean['ata']);
            }
        }             
        $port_of_Discharge_status["children"] = $children;     
        $simplexData[] = $port_of_Discharge_status;

        //Place of Delivery
        $place_of_Delivery_status = array("index" =>4,"label" =>"Place of Delivery",
            "path" =>$ocean['place_of_delivery_exp']."/".$ocean['place_of_delivery_un'],"isArrival" =>$state == 3 ? true : false);
        $children = array(); 
        if ($state < 3){
            //未发生前
        } else{
            if(!empty($ocean_milestone_status_code['IFFDEL']['act_date'])){
                $children[] = array("label" =>"Cargo handover/Delivered","date" =>$ocean_milestone_status_code['IFFDEL']['act_date']);
            }
        }                 
        $simplexData[] = $place_of_Delivery_status;
        $data['shipmentData'] = $simplexData;

        //处理transportInfo信息数据(air改过，从KLN_Ocean主表信息 etd 和eta 的取值跟ocean的f_etd,m_eta)
        $_mode =  $ocean['transport_mode_extend'] == 'sea' ? "Ocean Freight" : 
                        ($ocean['transport_mode_extend'] == 'air' ?  "Air Freight": 
                        ($ocean['transport_mode_extend'] == 'rail' ? "Rail Freight": 
                        ($ocean['transport_mode_extend'] == 'road' ? "Road Freight": "")));
        $transportInfo = array("Tracking No." =>$ocean['tracking_no'],"status"=>$ocean['new_status'],"mode" => $_mode,
            "origin" =>$ocean['shippr_uncode'],"destination" =>$ocean['consignee_uncode'],
            "etd" =>$ocean['etd'],"atd" =>$ocean['atd'],
            "etd_timezone" =>$ocean['pol_timezone'],
            "atd_timezone" =>$ocean['pol_timezone'],
            "eta" =>$ocean['eta'],"ata" =>$ocean['ata'],
            "eta_timezone" =>$ocean['mpod_timezone'],
            "ata_timezone" =>$ocean['mpod_timezone']);
        $data['transportInfo'] = $transportInfo;

        //处理basicInfo信息数据
        $vessel = $ocean['vessel'];
        $voyage = $ocean['voyage'];
        $basicInfo = array("MAWB/MBL No." =>$ocean['m_bol'],"HAWB/HBOL" => $ocean['h_bol'],"Carrier_Booking_No" =>$ocean['booking_no'],
            "PO_NO" =>$ocean['po_no'],"Vessel/Airline" =>$vessel,"Voyage/Filght" =>$voyage,
            "Incoterm" =>$ocean['incoterms'],"Service_Type" =>$ocean['service'],
            "CO2 Emission" =>$ocean['carbon_emission'],"Load Terms" =>"",
            "Shipment Type" =>"");
        $data['basicInfo'] = $basicInfo;    

        //处理 拼接地址 ocean表单exp 字段无法精准分割电话和地址信息，只能从contacts表里查询
        $shipper_address = common::retStationInfo($ocean['sh_address_1'], $ocean['sh_address_2'], $ocean['sh_address_3'], $ocean['sh_address_4'], 
            $ocean['sh_city'], $ocean['sh_state'], $ocean['sh_zipcode'], $ocean['sh_country']);
        $consignee_address = common::retStationInfo($ocean['cn_address_1'], $ocean['cn_address_2'], $ocean['cn_address_3'], $ocean['cn_address_4'], 
            $ocean['cn_city'], $ocean['cn_state'], $ocean['cn_zipcode'], $ocean['cn_country']);
        $origin_address = common::retStationInfo($ocean['aa_address_1'], $ocean['aa_address_2'], $ocean['aa_address_3'], $ocean['aa_address_4'], 
            $ocean['aa_city'], $ocean['aa_state'], $ocean['aa_zipcode'], $ocean['aa_country']); 
        $destination_address = common::retStationInfo($ocean['dd_address_1'], $ocean['dd_address_2'], $ocean['dd_address_3'], $ocean['dd_address_4'], 
            $ocean['dd_city'], $ocean['dd_state'], $ocean['dd_zipcode'], $ocean['dd_country']);    

        $shipperPartners = array("company" =>$ocean['sh_company'],"address"=>$shipper_address,"phone"=>$ocean['sh_phone']);
        $consigneePartners = array("company" =>$ocean['cn_company'],"address"=>$consignee_address,"phone"=>$ocean['cn_phone']);
        $originPartners = array("company" =>$ocean['aa_company'],"address"=>$origin_address,"phone"=>$ocean['aa_phone']);
        $destinationPartners = array("company" =>$ocean['dd_company'],"address"=>$destination_address,"phone"=>$ocean['dd_phone']);
        $businessPartners = array("shipper"=>$shipperPartners,"consignee" => $consigneePartners,"origin" => $originPartners,"destination" => $destinationPartners);
        $data['businessPartners'] = $businessPartners;  
    
        //处理routes air不存在中转的
        $routes = array(array("mode" =>$_mode,"mode_label" =>"Air", "origin" =>$ocean['shippr_uncode'],
                "destination" => $ocean['consignee_uncode'],
                "etd" => $ocean['etd'],"atd" => $ocean['atd'],
                "eta" => $ocean['eta'],"ata" => $ocean['ata'],
                "vessel" =>$ocean['vessel'],"voyageNo" =>$ocean['voyage']));
        $data['routes'] = $routes;
        
        //处理marksAndDescription
        $notes = common::excuteListSql("select notes from station_data.air_notes on2 where serial_no='".$ocean["serial_no"]."' and type_code = 'AO'");
        $remark = "";
        foreach($notes as $note){
            if(!empty($note['notes'])){
                $remark.=$note['notes']."\r\n";
            }
        }
        $marksAndDescription = array("marks"=>$ocean['marks'],"description"=>$ocean['description'],"remark"=>$remark);
        $data['marksAndDescription'] = $marksAndDescription;
        return $data;    
    }

    private function getUploadFolder() {
        $sql = "SELECT ra_value from ra_online_config where lower(ra_name) = 'upload_document'";
        return common::excuteOneSql($sql);
    }

    private function batch_document_upload_Vue_Data($file_arr,$h_bol,$i){
        // ==================== 开始转换为目标结构 ====================
        $result = [
            'id'         => $i,
            'isSelect'   => false,
            'no'         => 'Shipment No. '.$h_bol, // 可动态传入
            'typeList'   => []
        ];
        // 按 format_name 分组
        $grouped = [];
        foreach ($file_arr as $file) {
            $formatName = $file['format_name'] ?: 'Other'; // 防止 null

            if (!isset($grouped[$formatName])) {
                $grouped[$formatName] = [
                    'label' => $formatName,
                    'attachmentList' => []
                ];
            }

            $grouped[$formatName]['attachmentList'][] = [
                'name'       => $file['file_name'],
                'isSelect'   => false,
                'url'        => $file['url'],
                'url_param'  => $file['url_param'],
                'detail'     => $file['detail'],
                "file_name"  => $file['file_name'],
                "standard"  => $file['standard'],
                'h_bol'      => $h_bol,
                'label'      => $formatName,
                'is_topocean'=> $file['is_topocean']
            ];
        }

        // 添加 number 字段，并保持自然顺序（PHP 数组顺序）
        foreach ($grouped as $key => $group) {
            $group['number'] = count($group['attachmentList']);
            $result['typeList'][] = $group;
        }
        return $result;
    }

    private function insertInDescendingOrder(&$array, $newItem) {
        // 标准化并解析新项的日期
        $newDateStr = preg_replace('/\s+/', ' ', trim($newItem['date']));
        $newTimestamp = strtotime($newDateStr);
        if ($newTimestamp === false) {
            // 无效日期，可选择丢弃或抛异常
            return false;
        }

        // 遍历已排序数组（倒序：最新 → 最旧）
        for ($i = 0; $i < count($array); $i++) {
            $existingDateStr = preg_replace('/\s+/', ' ', trim($array[$i]['date']));
            $existingTimestamp = strtotime($existingDateStr);

            // 如果新项比当前项更新（时间戳更大），就插在这里
            if ($newTimestamp > $existingTimestamp) {
                array_splice($array, $i, 0, [$newItem]);
                return true;
            }
        }

        // 如果没找到更旧的位置，说明新项是最旧的，插到末尾
        $array[] = $newItem;
        return true;
    }
}
?>