erp/core/CoreApp/controllers/Aatest.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Aatest extends Start_Controller {
	public function __construct(){
        parent::__construct();
        $this->load->library('session');
		$this->load->_model('Model_whlabel','whlabel');
		$this->load->_model('Model_warehouse','warehouse');
		$this->load->_model('Model_productprice','productprice');
		$this->load->_model('Model_excel','excel');
		$this->load->_model('Model_fullorder','fullorder');
		$this->load->_model('Model_fullordertt','fullordertt');
		$this->load->_model('Model_fullordersmt','fullordersmt');
		$this->load->_model('Model_outbound','outbound');
		$this->load->_model('Model_express','express');
		$this->load->_model('Model_shop','shop');
		$this->load->_model('Model_typeclass','typeclass');
		$this->load->_model('Model_country','country');
		$this->load->_model('Model_kdniao','kdniao');
		$this->load->_model('Model_notice','notice');
		$this->load->_model('Model_dhl','dhl');
		$this->load->_model('Model_dhlhz','dhlhz');
		$this->load->_model('Model_usps','usps');
		$this->load->_model('Model_fedex','fedex');
		$this->load->_model('Model_fedex_cby','fedex_cby');
		$this->load->_model('Model_ups','ups');
		$this->load->_model('Model_ali','ali');
		$this->load->_model('Model_dpd','dpd');
		$this->load->_model('Model_user','user');
		$this->load->_model('Model_whlabel','whlabel');
		$this->load->_model('Model_specialstock','specialstock');
		$this->load->_model('Model_ck','ck');
		$this->load->_model('Model_whlabellabel','whlabellabel');
		$this->load->_model('Model_apiyy','apiyy');
		$this->load->helper('url');
		$this->load->_model('Model_whlabel_fc','whlabel_fc');
		$this->load->_model('Model_systemtransfer','systemtransfer');
		$this->load->_model('Model_classid','classid');
		$this->load->_model('Model_allocation','allocation');
		$this->load->_model('Model_fullorderxw','fullorderxw');
		$this->load->_model('Model_fullorderpaypal','fullorderpaypal');
    	$this->load->_model('Model_fedexv1','fedexv1');
		$this->load->_model('Model_logic_crm','logic_crm');
		$this->load->_model("Model_fullorder","fullorder");
		$this->load->_model("Model_express","express");
		$this->load->_model("Model_logic_ding","logic_ding");
		$this->load->_model("Model_api",'api');
		$this->load->_model("Model_usps",'usps');
		$this->load->_model('Model_emaildata','emaildata');
		 $this->load->_model('Model_logic_tools','logic_tools');
		 $this->load->_model('Model_logic_order','logic_order');
		 $this->load->_model('Model_returngoods','returngoods');
		 $this->load->_model('Model_returnlogs','returnlogs');
		 $this->load->_model('Model_productdescribe','productdescribe');

		 $this->load->_model('Model_logic_u9tools','logic_u9tools');
		 $this->load->_model('Model_17track','17track');

		 $this->load->_model('Model_customer','customer');
		$this->load->_model('Model_express','express');
		$this->load->_model('Model_weight','weight');
		$this->load->_model('Model_cne','cne');
		$this->load->_model("Model_zzjobs","zzjobs");
		$this->load->_model("Model_zzerrlog","zzerrlog");
		$this->load->_model("Model_zzhjobs","zzhjobs");
		$this->load->_model('Model_apiyy','apiyy');
		$this->load->_model('Model_systemtransfer','systemtransfer');
		$this->load->_model('Model_afspaypal','afspaypal');
		$this->load->_model('Model_message','message');
		$this->load->_model('Model_itsxb','itsxb');
		$this->load->_model("Model_logic_order","logic_order");
		$this->load->_model("Model_job_get3pewaybillid",'job_get3pewaybillid');
		$this->load->_model("Model_yuntu","yuntu");
		$this->load->_model("Model_job_getyuntuwaybillid","job_getyuntuwaybillid");
		$this->load->_model("Model_hualei",'hualei');
		$this->load->_model("Model_job_gethualeiwaybillid","job_gethualeiwaybillid");
		$this->load->_model("Model_apiyyv1","apiyyv1");
		$this->load->_model("Model_settingtest","settingtest");
		$this->load->_model("Model_cne","cne");
		$this->load->_model("Model_apismt","apismt");
		$this->load->_model("Model_notice","notice");
		$this->load->_model("Model_producttitle","producttitle");
		$this->load->_model("Model_apitt","apitt");
		$this->load->_model("Model_zzjobs","zzjobs");
		$this->load->_model("Model_logic_goods_replace","logic_goods_replace");
		$this->load->_model("Model_apittv1","apittv1");
		$this->load->_model("Model_express_tt","express_tt");
		$this->load->_model("Model_check","check");
		$this->load->_model("Model_logic_express","logic_express");
    }
	

    //定义方法的调用规则 获取URI第二段值
    public function _remap($arg,$arg_array)
    {  
		$list = $this->db->from("outbound")->where("time >= 1764804828")->get()->result_array();
		echo "<pre>";
		var_dump(date("Y-m-d H:i:s"));
		
		foreach($list as $k=>$v){
			$express_info = $this->express->read($v['express']);
			if(empty($v['express'])){
				continue;
			}
			if(empty($v['waybill'])){
			    var_dump("===================================");
			    
			  var_dump($v['number']."----".$v['waybill']."-----".$express_info['servicename']."----".$v['express']."----".$express_info['printcode']);
			    var_dump("===================================");
			    
				continue;
			}
		
			$r = $this->logic_express->ydCheckById($v['waybill'],$v['express']);
			$y = $this->logic_express->ydCheckByPrintcode($v['waybill'],$express_info['printcode']);
			echo "<hr>";
			var_dump("----R:".$r."----Y:".$y);
			var_dump($v['number']."----".$v['waybill']."-----".$express_info['servicename']."----".$v['express']."----".$express_info['printcode']);
		}
		var_dump(date("Y-m-d H:i:s"));
		die;
		//测试 erp现在还在用的数据
		//
		$list = $this->fullorder->find_all("print = 3","*","id desc",0,3000);
		echo "<pre>";
		foreach($list as $k=>$v){
		    	$express_info = $this->express->read($v['express']);
			if(empty($v['express'])){
				continue;
			}
			if(empty($v['waybill'])){
			    var_dump("===================================");
			    
			  var_dump($v['number']."----".$v['waybill']."-----".$express_info['servicename']."----".$v['express']."----".$express_info['printcode']);
			    var_dump("===================================");
			    
				continue;
			}
		
			$r = $this->logic_express->ydCheckById($v['waybill'],$v['express']);
			$y = $this->logic_express->ydCheckByPrintcode($v['waybill'],$express_info['printcode']);
			echo "<hr>";
			var_dump("----R:".$r."----Y:".$y);
			var_dump($v['number']."----".$v['waybill']."-----".$express_info['servicename']."----".$v['express']."----".$express_info['printcode']);
		}

		die;
		$info = $this->logic_order->getInfo("orderinfo = '577193171472388208'");
		
		
		if(is_string($info['extra_text'])){
			$extra_text = json_decode($info['extra_text'],true);
			//快递服务商
			$server_info = $extra_text['server_info'];
		}else{
			//快递服务商
			$server_info = $info['extra_text'];
		}
		
		$post = [
			'order_id'=>$server_info['order_id'],
			"order_line_item_ids"=>$server_info['order_line_id'],
			"dimension"=>$server_info['dimension'],
			"shipping_service_id"=>$server_info['shipping_services'][$info['ttsp_xz']]['id'],
			"weight"=>$server_info['weight'],
		];
		die;
		$shop = $this->shop->read(35);
		//$order_id = "577182146069041251";
		// $info = $this->logic_order->getInfo("orderinfo = '577192556139286742'");
		// $r = $this->express_tt->get_data($info,'CBT');
		// echo "<pre>";
		// print_r($r);
		// $r = $this->check->checkOverdue("Miran Emmanuel","KISS-PF1-251105-003","");
		// var_dump($r);
		$info = $this->logic_order->getInfo("orderinfo = '577182146069041251'");
		$r = $this->express_tt->downloadExpressLabel($info,$shop);
		echo "<pre>";
		print_r($r);
		die;

        // $res = "";

		// $r = json_decode($res,true);

		// var_dump($r);
		// die;

        // $list = $this->fullordertt->find_all("express = 83 and printtime >= 1762780009","orderinfo,extra_text");
        // echo "<pre>";
        // var_dump(count($list));
        // foreach($list as $k=>$v){
        //   $extra_text = json_decode($v['extra_text'],true); 
        //   if(empty($extra_text['label_info'])){
        //       var_dump("----".$v['orderinfo']);
        //       var_dump($extra_text);
        //       var_dump("----".$v['orderinfo']);
        //   }else{
        //       if($extra_text['label_info']['order_id'] == $v['orderinfo']){
        //           var_dump($v['orderinfo']);
        //       }
        //   }
           
        // }

		
// 		$where_arr = [
//             //"shop"=>35,//当前店铺为tt-wk
//             "express"=>83,//快递为tt-cbt
//             "print"=>2,//未打印
//             "printnumber"=>0,//打印次数
//             'library'=>1,//未出库
//             //'libraryconfirm'=>2,//允许出库
//             "review >"=>4,//审核通过或自动审核
//         ];
//         //$shop_info = $this->shop->read(35);
//         $shop_list = $this->shop->find_all('id in (35,46)');
//         $shop_list = array_column($shop_list,null,'id');
//         // if(empty($shop_info)){
//         //     exit("当前店铺不存在");
//         // }
//         $list = $this->db->from("fullordertt")
//             ->select("id,orderinfo,shop,express,print,printnumber,library,review,state")
//             ->where($where_arr)
//             ->where_not_in('state',[214,217])
//             ->get()->result_array();
//         if(empty($list)){
//             exit("没有符合条件的订单");
//         }
//         echo "<pre>";
//         print_r($list);


//         die;
    //     $orderinfo = "577174340616098089";
    //     $str = '{"code":0,"data":{"dimension":{"height":"1.97","length":"5.91","unit":"INCH","width":"3.93"},"order_id":"577174340616098089","order_line_item_ids":["577174340616491305","577174340616556841","577174340616229161","577174340616294697","577174340616360233","577174340616425769"],"package_id":"1155116736406327593","shipping_service_info":{"currency":"USD","earliest_delivery_days":3,"id":"7503454530349205291","latest_delivery_days":9,"name":"Collections by TikTok","price":"$5.28","shipping_provider_id":"7502286278856017685","shipping_provider_name":"Collections by TikTok"},"weight":{"unit":"POUND","value":"0.88"}},"message":"Success","request_id":"20251110141801260DFACC7E0FE5757FB3"}';
    //     $res = json_decode($str,true);
    //     $info = $this->fullordertt->get_orderinfo($orderinfo);
	   // $extra_text = json_decode($info['extra_text'],true);
    //     $extra_text['label_info'] = $res['data'];
    //     $info['extra_text'] = json_encode($extra_text,JSON_UNESCAPED_UNICODE);
    //     $this->db->update('fullordertt', [
    //         'extra_text' => $info['extra_text']
    //     ], ['id' => $info['id']]) ;
		die;
		//$str = preg_replace('/\s*\|\s*/', '|', $str);
		
		// $list = $this->db->from("fullorder")->order_by('id' ,'desc')->limit(3000,0)->get()->result_array();
		// foreach($list as $k => $v){
		// 	$fpdata = preg_replace('/\s*\|\s*/', '|', $v['fpdata']);
		// 	$this->fullorder->save(['fpdata'=>$fpdata],$v['id']);
		// }
		// $this->logic_ding->sendToDing("source != '1' and dlzemail < '1' and");
		// $product_id = 33204;
		// $r = $this->db->from("fullorder")->where('extra_price IS NOT NULL', NULL, FALSE)->where('number','ALIP-251105-082')->where("JSON_SEARCH(extra_price, 'one', '$product_id', NULL, '$[*].product_id') IS NOT NULL")->get()->result_array();
		// echo "<pre>";
		// print_r($r);
		die;
		//	$r = $this->db->from("fullorder")->where('extra_price IS NOT NULL', NULL, FALSE)->where("JSON_SEARCH(extra_price, 'one', '$product_id', NULL, '$[*].product_id') IS NOT NULL")->get()->result_array();
		die;
         $where_arr = [
            "shop"=>35,//当前店铺为tt-wk
            "express"=>83,//快递为tt-cbt
            "print"=>2,//未打印
            "printnumber"=>0,//打印次数
            'library'=>1,//未出库
            "review >"=>4,//审核通过或自动审核
        ];
        $list = $this->db->from("fullordertt")
            ->where($where_arr)
			->where_not_in('state',[214,217])
            ->get()->result_array();
        echo "<pre>";
        print_r($list);
        die;
		$info = $this->logic_order->getInfo("number = '".$arg_array[0]."'");
		echo "<pre>";
		$res = $this->express_tt->get_data($info,'CBT');
		
		print_r($res);

		die;
		$info = $this->logic_order->getInfo("number = '".$arg_array[0]."'");

		$extra_text = json_decode($info['extra_text'],true);
		$packages = $extra_text['packages'];
		$package_id = $packages[0]['id'];
		$shop = $this->shop->read($info['shop']);
        //$r = $this->apitt->downloadLabel($package_id,$shop,$info);
		$r = $this->apittv1->ShipByTiktok($package_id,$shop,$info);
		var_dump($r);
		die;


		//$this->_print();
		exit('No direct script access allowed');
		if($arg == 'dayin')
        {
			$this->_a();
            //$this->_pdfurl("https://www.fedex.com/document/v1/cache/retrieve/SH,bfa0bef58beaa8cc884714432636_SHIPPING_Z?isLabel=true&autoPrint=false&retrievalMode=THERMAL",'ces','20210825155500');
        }elseif($arg == 'getorder'){
			$this->_getorder();
		}else{
			exit('No direct script access allowed');
		}
    }
	private  function _tbuni(){
		
		// echo "<pre>";
		// $fdata = $this->fullorder->find_all("express = 81 and librarytime >= 1761580800 and librarytime <= 1764172800 and state = 207 and shop < 10");
	
		// foreach($fdata as $k => $v){
		// 	$this->fullorder->save(array('state'=>216),$v['id']);
		// }
		// echo "ok";	
		// die;
		$dataorder = array();$datashop = array();$dataex = array();$datack = array();
		//  订单加入键值-k 
		$fdata = $this->fullorder->find_all("express = 81 and librarytime >= 1761580800 and librarytime <= 1764172800 and state = 207");//,'source,id,orderinfo,waybill,shop,express,type,msg,bname,state,client,name,phone,zipcode,address,email,shopify'
	
		//*  订单加入键值-j 
		//*  店铺加入键值-j 
		$fshop = $this->shop->find_all('1=1');
		foreach ($fshop as $v)
		{
			$datashop[$v['id']] = $v;
		}
		//*  店铺加入键值-k 
		//*  快递加入键值-j 
		$fex = $this->express->find_all('1=1');
		foreach ($fex as $v) 
		{
			$dataex[$v['id']] = $v;
		}
		//*  快递加入键值-k 
		//*  仓库加入键值-k 
		$fwh = $this->warehouse->find_all('1=1');
		foreach ($fwh as $v) 
		{
			$datack[$v['id']] = $v;
		}
		//*  仓库加入键值-j 
		$i = 0;$j = 0;$ed = array();
		echo "<pre>";
		print_r(count($fdata));
		die;
		foreach ($fdata as $key=>$value)
		{
			if($value['source'] == 1)
			{
				$this->fullorder->save(array('dlz'=>3,'state'=>216),$value['id']);
			}
			else
			{
				if($value['shop'] == 5){
					$ddh = $value['orderinfo'];
				}else{
					$ddh = substr($value['orderinfo'],1);
				}
			    
			    $ydh = $value['waybill'];
			    $xg = $value;//此订单数据
			    $shop = $datashop[$xg['shop']];//此订单店铺
			    $ex = $dataex[$xg['express']];//此订单快递
			    $warehouse = $datack[$xg['type']];//此订单仓库
				$shopifyid = $value['shopify'];
				if($xg['shop'] < 7)
				{
		            $xg['iscode'] = $ex['title'];
		            $xg['url'] = $shop['shopname'];
				    @$fs = $this->api->get_paypal($xg);
					$this->afspaypal->insert(array('number'=>$xg['number'],'cs'=>$fs));
				}
				$ms = $this->message->find_all("express like '%,".$xg['express'].",%'");
				if(!isset($ms[0]))
				{
					$ms = $this->message->read(2);
				}
				else
				{
					$ms = $ms[0];
				}
				$shopname = $shop['brandname'];  //店铺名
				$buyername = $xg['bname'];   //Bill Name
				$email_call = $shop['shopid']; //发货人邮箱;
				$phone = $shop['shopphone'];   //发货人电话
				$track_type = $ex['title'];   //快递名称
				$service = $ex['title'];   //快递追踪名称
				$track_link = $ex['url'];   //快递查询网址
				$logistics_number = $ydh;    //运单号
				$t= array('%buyername%','%email_call%','%track_type%','%service%','%track_link%','%logistics_number%','%shop%','%phone%','%jtime%');
				$h= array($buyername,$email_call,$track_type,$service,$track_link,$logistics_number,$shopname,$phone,$ex['yjtime']);
				$remark = str_replace($t,$h,$ms['content']);
				var_dump($xg['number']);

			    // @$gx = $this->api->get_gx($ddh,$ydh,$xg,$shop,$ex,$remark,$shopifyid);
				
				// if(!isset($gx['res']))
				// {
				// 	continue;
				// }
			    // $this->fullorder->save(array('dlz'=>$gx['res'],'state'=>$gx['state']),$value['id']);
			}
		}
	}
	private function _cbtxcel(){
		$list = $this->db->from("fullordertt")->where("source` = 2 AND `express` = 83 AND `librarytime` >= 1763730574 AND `librarytime` <= 1763762974")->get()->result_array();

		//生成excel
		$filename = date("Y-m-d")."TTS导出.xls";
		$str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
		<head>
		<!--[if gte mso 9]><xml>
		<x:ExcelWorkbook>
		<x:ExcelWorksheets>
		<x:ExcelWorksheet>
		<x:Name>EXCEL</x:Name>
		<x:WorksheetOptions>
		<x:Print>
		<x:ValidPrinterInfo />
		</x:Print>
		</x:WorksheetOptions>
		</x:ExcelWorksheet>
		</x:ExcelWorksheets>
		</x:ExcelWorkbook>
		</xml>
		<![endif]-->
		</head><body>";
		$str .= "<table border=1 style='font-family: Microsoft Yahei;font-size: 13px;'>"; 
		$str .= "<tr><td>订单ID</td><td>订单编码</td><td>快递类型</td><td>运单号</td><td>打印时间</td><td>出库时间</td></tr>";
		foreach ($list as $key=>$value) 
		{ 
			
			$str .= "<tr>";
			$str .= "<td>`". $value['orderinfo']. "</td>";
			$str .= "<td>". $value['number']. "</td>";	
			$str .= "<td>". $value['express']. "</td>";	
			$str .= "<td>`". $value['waybill']. "</td>";	
			$str .= "<td>". date("Y-m-d H:i:s",$value['printtime']). "</td>";
			$str .= "<td>". date("Y-m-d H:i:s",$value['librarytime']). "</td>";
			$str .= "</tr>";
		}
		$str .= "</table></body></html>"; 
		header( "Content-Type: application/vnd.ms-excel; name='excel'" ); 
		header( "Content-type: application/octet-stream" ); 
		header( "Content-Disposition: attachment; filename=".$filename ); 
		header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); 
		header( "Pragma: no-cache" ); 
		header( "Expires: 0" ); 
		exit($str); 
	}
    private function jiai($arg_array){
            $key = "6amg!pnfrlbpnjgirv"; //加密所需要到的key
            $iv = "6ook4k!2w94m6jtm";//加密所需要到的iv
            
            $time = time();
            $data = array(
                "order_no" => $arg_array[0],
                "shop" => "3",
                "time"=>time()
            
            );
            $decrypt = "alipearlhair+".$data['time'];
            $key =  openssl_encrypt($decrypt,'AES-128-CBC',$key,0,$iv);
            
            $data['key'] = $key;
            
            // 将PHP数组编码为JSON字符串
            $jsonData = json_encode($data);
            
            
            $url = "https://1.wepolicy.cn/apiexpress/search";
            // 初始化cURL
            $ch = curl_init($url);
            
            // 设置cURL选项
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
            curl_setopt($ch, CURLOPT_POST, true);
            // 直接传入JSON字符串作为POST数据
            curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonData);
            
            // 关键：设置HTTP头，声明内容类型为JSON
            curl_setopt($ch, CURLOPT_HTTPHEADER, array(
                'Content-Type: application/json',
                'Content-Length: ' . strlen($jsonData) // 可选项，设置数据长度
            ));
            
            // 执行请求
            $response = curl_exec($ch);
            
            // 检查cURL执行是否出错
            if (curl_errno($ch)) {
                $error_msg = curl_error($ch);
                // 处理错误
            }
            
            // 关闭cURL会话
            curl_close($ch);
            
            // 处理API返回的JSON响应
             $responseData = json_decode($response, true);
             echo "<pre>";
             print_r($response);
    }
	private function _ttexpress(){
		$info = $this->logic_order->getInfo("number = 'TT-KISS-251021-001'");
		$res = $this->express_tt->get_data($info,'FBT');
		echo "<pre>";
		print_r($res);
	}
	private function dokucun(){
		//美仓 未出库
	//   $info = 	$this->db->from("whlabel")->where([
	// 	"warehouse"=>13,
	// 	'state'=>0
	//   ])->select("id,number,sku,warehouse,title,details,cpid,COUNT(id) AS total_num,GROUP_CONCAT(IFNULL(details, '') SEPARATOR '，') AS total_details,GROUP_CONCAT(IFNULL(cpid, '') SEPARATOR '，') AS total_cpid")->group_by('number')->order_by('total_num','desc')->limit(10,0)->get();

	  $info = 	$this->db->from("whlabel")->where([
		"warehouse"=>13,
		'state'=>0
	  ])->select("id,number,sku,warehouse,title,details,cpid,COUNT(id) AS total_num")->group_by('number')->order_by('total_num','desc')->limit(10,0)->get();
	  echo "<pre>";
	  print_r($info->result_array());
	  die;
	}

	public function _pdfurl($pdf,$title,$bctime)
    {
    	$pdf_path = './data/pdf/'.$bctime.'/';
        $pdf = fopen($pdf,"r");
		if(!is_dir($pdf_path))mkdir($pdf_path,0777); //上传目录不存在则创建
        file_put_contents($pdf_path.$title.'.pdf',$pdf);
		return $bctime;
    }

	public function _linshittmsg(){
	    exit;
		$fullorder = $this->fullordertt->get_orderinfo("577118877757837357");
		$shop = $this->shop->read($fullorder['shop']);
		$express = $this->express->read($fullorder['express']);
		$notice = $this->notice->find_all("id = 134");
		echo "<pre>";
		// print_r($fullorder);
		// print_r($shop);
		// print_r($express);
		// print_r($notice);
		// die;
// 		$list = $fullorder;
// 		$ProductName = '';
// 		if(empty($list['fpdata'])){
// 			$st = [];
// 		}else{
// 			$st =  explode(';',trim($list['fpdata'],';'));
// 		}
		
// 		foreach ($st as $v) 
// 		{
// 			$v =  explode('|',trim($v,'|'));
// 			if(isset($v[1]))
// 			{
// 			    $th = $this->producttitle->get_title($v[1]);
// 			    if($th)
// 			    {
// 				$ProductName .= $th['th'].', ';
// 				}
// 				else
// 				{
// 					$ProductName .= $v[1].', ';
// 				}
// 			}
// 		}
// 		var_dump($ProductName);
// 		die;
		$go = $this->notice->get_god($fullorder,$shop,$express,$notice[0]);
		echo "<pre>";
		print_r($go);
		die;
	}

	public function _u9dcd(){
		$token = $this->settingtest->get_yytoken_120();
		$doc_no = $this->input->get('doc_no',true);
		$res = $this->apiyyv1->cxScdStatus($doc_no,$token);
		echo "<pre>";
		var_dump($res);
		die;
	}

	public function _apismtOrder(){
		$post = $this->apismt->get_order("8204437130874932","50000601909fLFcsqEWGf1fd9756fw3q0TfklNpzHt1GHWEQtdwSvsNsWTa0WCkkIgJ");
		echo "<pre>";
		var_dump($post);
		die;
	}
	public function dock(){

	
		$fp = "87,-128-1620-80-2584-856-104-146-30-72-2071-|Wigs CR 9A LY065 HL1B/27#WK Deep Wave 13*4 Frontal Wig Medium 180% Ready to Go 18inch |1|0|0|18|0|0|0|0;-131-2247-|Gift HairElastic |1|0|0||0|0|0|0;-131-2236-|Gift WKElasticBand |1|0|0||0|0|0|0;-131-2492-|Gift PackTTWK |1|0|0||0|0|0|0;-131-2235-|Gift EdgeBrush |1|0|0||0|0|0|0;-131-2250-|Gift BoxWK |1|0|0||0|0|0|0;";
		$wh = "|1288087258485610414630722071-1-0|1312247-1-0|1312236-1-0|1312492-1-0|1312235-1-0|1312250-1-0|";
		$number = "TT-WK-250811-087";
        $warehouse = $this->warehouse->find_all("fpzd = '1'",'*','fpsx desc');
		echo "<pre>";

		foreach ($warehouse as $v) 
		{
			
			$yx = 'get_yx_'.$v['bdck'];
			$kczd = $this->ck->$yx(207,$v,35,$number,$wh,$fp);
			var_dump($kczd);
		}
	}

	public function getToken($type){
        $name = "get_yytoken_".$type;
        $token = $this->settingtest->$name();
        return $token;
    }
	public function _notice(){
		$notice = $this->notice->read(30);
		$v = $this->fullorder->get_number('Y-50728-010');
		$shop = $this->shop->read($v['shop']);
		$express = $this->express->read($v['express']);
		echo "<pre>";
		print_r($notice);
		print_r($v);
		print_r($shop);
		die;
		$fs = $this->notice->get_god($v,$shop,$express,$notice);
	}


	public function _error(){
		// echo $c;
		set_error_handler(function($severity, $message, $file, $line) {
			// 自定义错误处理逻辑
			
			throw new ErrorException($message, 0, $severity, $file, $line);
			//return true; // 返回true表示已处理，阻止CI继续处理
		});

		set_exception_handler(function($exception) {
			// 自定义异常处理逻辑
			// 一般也就是处理一下抛出可允许的错误 允许往下执行  目前这里不做任何处理  只关注于 sql的错误和程序执行的异常
		});
		$this->db->db_debug = false;
		$this->db->trans_begin();
		try{ 
			$do_sql = $this->db->insert('table', []); 
			if(!$do_sql){
				throw new Exception("sql error:【".$this->db->error()['message']."】");
			}
			
			
		}catch(Exception $e){
			$this->db->trans_rollback();
			exit(json_encode(['msg'=>$e->getMessage(),'success'=>false],JSON_UNESCAPED_UNICODE));
		}finally{
			if ($this->db->trans_status() === TRUE)
			{
				$this->db->trans_commit();
				exit(json_encode(['msg'=>"操作成功",'success'=>true],JSON_UNESCAPED_UNICODE));
			}
			else
			{
				$this->db->trans_rollback();
				exit(json_encode(['msg'=>"sql语句执行",'success'=>false],JSON_UNESCAPED_UNICODE));
			}
		}

	}
	public function _plcl(){
	
		$typeclass = [];
		$classid = $this->classid->sku();
		$tcall = $this->typeclass->find_all();
		
		foreach ($tcall as $v)
		{
			//$tcjm[$v['id']] = array($v['jm'],$v['classid']);
			$typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
		}
		$dtctitle = [];
		foreach($tcall as $v){
			$dtctitle[$v['id']] = $v['title'];
		}
		$dtc = [];
		foreach ($tcall as $v) {
			if (stripos($v['spare'], '|') !== false) //如果有多个值
			{
				$v['spare'] = explode('|', $v['spare']);
				foreach ($v['spare'] as $k => $vs) {
					if (stripos($v['zh'], '|') !== false) {
						$vzh = explode('|', $v['zh']);
						$dtc[strtolower($vs)] = array('classid' => $v['classid'], 'zh' => $vzh[$k], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $vs);
					} else {
						$dtc[strtolower($vs)] = array('classid' => $v['classid'], 'zh' => $v['zh'], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $vs);
					}
				}
			} else {
				$dtc[strtolower($v['spare'])] = array('classid' => $v['classid'], 'zh' => $v['zh'], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $v['spare']);
			}
		}
		$tmp_sku ="RTG-A033-STW-13*4BobWig-250%-10";
		$u9_info = $this->logic_order->skuTransferFeatures($tmp_sku,$typeclass,$dtc,$dtctitle,$classid);
		echo "<pre>";
		var_dump($tmp_sku);
		var_dump($u9_info);
		die;

	}
	public function _print(){
		$this->_Template('aaadayin',$this->data);
	}
    
	public function _doWcCp(){
		$info = $this->zzhjobs->find("status = 0");
		$this->zzhjobs->save(['status'=>30],$info['id']);
		
		echo "<pre>";

		$info['payload']  = json_decode($info['payload'],true);
		//print_r($info);
		var_dump($info['payload']);
		$lb = $this->systemtransfer->read($info['payload']['fid']);
		$nu = $this->fullorder->get_number($lb['number']);
		if(!$nu)
		{
			$nu = $this->fullordersmt->get_number($lb['number']);
			if(!$nu)
			{
				$nu = $this->fullordertt->get_number($lb['number']);
			}
		}
		if(empty($nu)){
			echo "数据不存在";
			die;
		}
		$s = $this->shop->read($nu['shop']);
		$lb['kh'] = $s['yyid'];
		$lb['ts'] = 1;
		
		// var_dump($lb);
		$rk = $this->apiyy->_newrk($lb);
		var_dump($rk);
		// $list = $this->zzerrlog->find_all("content like '%检测货物流转打印情况13|2%'  and time >= 1745881418  and time <=  1745967818 ");
		// echo "<pre>";
		// print_r(count($list));
		// foreach($list as $k=>$v){
		// 	$tmp_arr = explode("|",$v['content']);
		// 	$params = [
		// 		"transfer"=>13,
		// 		"type"=>2,
		// 		"number"=>$tmp_arr[2],
		// 		'fid'=>$tmp_arr[3]
		// 	];

		// 	$this->zzhjobs->insert(
		// 		[
		// 			'status'=>0,
		// 			'quque'=>'xgwsu9',
		// 			'payload'=>json_encode($params),
		// 			'do_interval'=>1,
		// 			'create_time'=>time(),
		// 		]
		// 	);
		// }
	}
    public function _th($arg_array){
        die;
        if(empty($arg_array)){
            die(1);
        }
        $order_no = $arg_array[0];
        var_dump($order_no);
        $data = $this->fullorder->get_number($order_no);
        
        if(empty($data)){
            echo 2;
            exit(2);
        }
        
        $r = $this->usps->get_return($data);
        echo "<pre>";
        print_r($r);
    }

	//物流轨迹
	public function  _logistic(){
	    
		echo "<pre>";
		
	
		$fs = $this->cne->get_logistics_yskx([
			[
				"TrackNumber"=>"880739284316",
			]
		]);
 		print_r($fs);
        //$fs = $this->usps->get_logistics($v);
		die;
	}


	public function _getorder(){
		
		$name = 'Alipearl';
		  $userKey = array(
			'Alipearl' => array('username'=>'huchunmei','api_key'=>'huchunmei126_alipearl_erp888','url'=>'https://www.alipearlhair.com'),
			'Asteria'  => array('username'=>'huchunmei','api_key'=>'huchunmei126_asteria_erp888','url'=>'https://www.asteriahair.com'),
			'WestKiss' => array('username'=>'huchunmei','api_key'=>'huchunmei126_westkiss_erp868','url'=>'https://www.westkiss.com'),
			'SuperNova' => array('username'=>'huchunmei','api_key'=>'huchunmei126_supernova_erp6898','url'=>'https://www.supernovahair.com'),
			'Wiggins' => array('username'=>'huchunmei','api_key'=>'huchunmei126_wiggins_erp652','url'=>'https://www.wigginshair.com'),
			'Yolissa' => array('username'=>'huchunmei','api_key'=>'huchunmei126_yolissa_688','url'=>'https://www.yolissahair.com'),
			);
			
			$proxy = new SoapClient($userKey[$name]['url'].'/api/soap/?wsdl');
			try {
				$sessionId = $proxy->login($userKey[$name]['username'], $userKey[$name]['api_key']);
			} 
			catch (Exception $e) {
				echo $e->getMessage();
			}
			
			$data =	array('proxy'=>$proxy,'sessionId'=>$sessionId,'url'=>$userKey[$name]['url']);
			
			$fromTime = date('Y-m-d H:i:s',time()- 3600*24*6);
			$toTime = date('Y-m-d H:i:s',time());
			$filters = array(array('created_at'=>array('from'=>$fromTime,'to'=>$toTime)));
			$result = $data['proxy']->call($data['sessionId'],'sales_order.list',$filters);
			echo "<pre>";

			// print_r($result[0]);
			foreach($result as $item)
			{
				// print_r($item);exit;
				$iteminfo= $data['proxy']->call($data['sessionId'], 'sales_order.info', $item['increment_id']);
				print_r($iteminfo['items']);
			
			}	
	}

	public function getDtc(){
		$dictionaries = $this->typeclass->find_all('spare!= "" and classid != 1 and classid != 2 and classid != 3 and classid != 4 and classid != 5 and classid != 11 and classid != 16 and classid != 17 and classid != 20 and classid != 21 and classid != 23 and classid != 24 and classid != 29 and classid != 30 and classid != 31 and classid != 32 and classid != 36');
		$dtc = array();
		foreach ($dictionaries as $v) 
		{
			if(stripos($v['spare'],'|') !== false)//如果有多个值
			{
				$v['spare'] = explode('|',$v['spare']);
				foreach ($v['spare'] as $k=>$vs) 
		        {
					if(stripos($v['zh'],'|') !== false)
					{
						$vzh = explode('|',$v['zh']);
						$dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
					}
					else
					{
					    $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
					}
				}
			}
			else
			{
				$dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
			}
			
		}
		$dtctitle = [];
		$dictionaries2 = $this->typeclass->find_all();
		foreach ($dictionaries2 as $v)
		{
			$dtctitle[$v['id']] = $v['title'];
		}
		return [
			'dtc'=>$dtc,
			'dtctitle'=>$dtctitle
		];
	}
    public function _a(){
		
		
		$list = [
			[
				'sku2'=>'-1297-80-2602-1306-57-101-1283-',
			]
		];
		$r = $this->logic_u9tools->getU9bm($list,'sku2');
		echo "<pre>";
		var_dump($r);
		die;
		$data = $this->getDtc();
		$dtc = $data['dtc'];
		$dtctitle = $data['dtctitle'];
		//die;
		$quantity = '1';
		//$issku = 'NW-Ponytail-10-Accs-175g';
		$issku = "Accs-STW-Topper-6*7-8";
		$money = array();
			$productdescribe = $this->productdescribe->find_all('1=1');
			foreach ($productdescribe as $v) 
			{
				$money[$v['number']] = array();
			}
			/*  价格加入  */
			/*  匹配ID加入  */
			$int = array();
			$intdata = $this->typeclass->find_all('classid=14','id,spare');
			foreach ($intdata as $v) 
			{
				$v['spare'] = explode('|',$v['spare']);
				$int[$v['id']] = $v['spare'][0];
			}	
		// var_dump($dtc);
		// var_dump($dtctitle);
		$r = $this->api->matching($quantity,$issku,$dtc,$money,$int,$dtctitle,[1],[
			
		]);
		echo "<pre>";
		var_dump($r);
		
		die;
	
        $time = time();
        $jiami = "alipearlhair+".(string)$time;
        echo json_encode([
			'shop'=>3,
			'waybill'=>'283786008019',
			'time'=>$time,
			'key'=>$this->logic_tools->toolsjiami($jiami,"6amg!pnfrlbpnjgirv", "6ook4k!2w94m6jtm"),
		]);
        die;

		$dtc = array();
		/*  订单号加入键值-j  */
		/*  匹配加入  */
		$dictionaries = $this->typeclass->find_all('spare!= "" and classid != 1 and classid != 2 and classid != 3 and classid != 4 and classid != 5 and classid != 11 and classid != 16 and classid != 17 and classid != 20 and classid != 21 and classid != 23 and classid != 24 and classid != 29 and classid != 30 and classid != 31 and classid != 32 and classid != 36');
		// and (classid=13 or classid=22 or classid=8 or classid=15 or classid=27 or classid=25 or classid=26 or classid=18 or classid=14 or classid=9 or classid=12 or classid=10 or classid=6 or classid=100 or classid=999)
		foreach ($dictionaries as $v) 
		{
			if(stripos($v['spare'],'|') !== false)//如果有多个值
			{
				$v['spare'] = explode('|',$v['spare']);
				foreach ($v['spare'] as $k=>$vs) 
		        {
					if(stripos($v['zh'],'|') !== false)
					{
						$vzh = explode('|',$v['zh']);
						$dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
					}
					else
					{
					    $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
					}
				}
			}
			else
			{
				$dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
			}
			
		}
		$dtctitle = [];
		$dictionaries2 = $this->typeclass->find_all();
		foreach ($dictionaries2 as $v)
		{
			$dtctitle[$v['id']] = $v['title'];
		}
		echo "<pre>";
		$sku = "Free,Gift--PackQQS,NW--3+Ori6*6C-22 24 26-20-6*6C";
		$sl = "1;1;1;";
		$r = $this->api->matching($sl,$sku,$dtc,"","",$dtctitle,$shop=[],$extra = [
			"price"=>"565.7700",
			"row_total"=>"565.7700"
		]);
		var_dump($r['title']);
		$r = $r['product'];
		$rr = explode(";",$r);
		print_r($rr);
	
	    
    }
	public function _fout()
	{
		$waybill = $this->input->get('waybill');
		$info = $this->fullorder->get_waybill($waybill);
			
		//$r = $this->usps->get_new_logistics($info);
		$r = $this->fedexv1->get_logistics(123);
		echo "<pre>";
		var_dump($r);
        //$this->fedexv1->makeAccessToken();
		
	}
	
	public function _waybillemail()
	{
		$urls = array();$sl = 0;$time = time();
		$wid = 2;
		// if(date("H",time()) == '8' && date("i",time()) > '20' && date("i",time()) < '39')//USPS-USA单
		// {
		// 	$wid = 1;
		// }
		// else if(date("H",time()) == '20' && date("i",time()) > '20' && date("i",time()) < '39')//其他快递
		// {
		// 	$wid = 2;
		// }
		// else
		// {
		// 	exit;
		// }
		$notice = $this->notice->find_all("message = '1' and state = '1' and type = '4' and ktime < '$time' and jtime > '$time'");//已有自动发送,这个是物流发送
		foreach ($notice as $key=>$var)
		{
			$this->_waybillfs([
				'var'=>$var,
				'wid'=>$wid
			]);
		}
	
	}

	public function upadtel(){
		
		$returngoods_id = 150;
		$insert_flag = 1217819;
		$number = 'KISS-50206-004';

		$returngoods_info = $this->returngoods->read($returngoods_id);
		$this->returngoods->save([
			'status'=>80,
			'back_no'=>$number,
			'back_id'=>$insert_flag,
			'update_time'=>date('Y-m-d H:i:s'),
		],$returngoods_id);
		$this->returnlogs->insert([
			'rg_id'=>(int)$returngoods_id,
			'operat_id'=>10,
			'operat_name'=>'admin',
			'remark'=>"订单号：".$returngoods_info['orderinfo']."重新换货-换货新订单编码".$number,
			'create_time'=>date('Y-m-d H:i:s'),
		]);
	}
	
	
	public function _waybillfs($data)
	{
		if($data)
		{
		    $notice = $data['var'];
			$notice['email'] = $this->emaildata->read($notice['email']);
			$wid = $data['wid'];
			$fsjs = "";
			if($wid == 1 && (stripos($notice['express'],',2,') !== false || stripos($notice['express'],',63,') !== false || stripos($notice['express'],',64,') !== false))
			{
				$js = explode(',',trim($notice['js'],','));
				if(count($js) > 1)
				{
					$fsjs = " and (";
				    foreach ($js as $v)
				    {
					    $fsjs .= "js = '$v' or ";
				    }
					$fsjs = trim($fsjs,' or ').")" ;
				}
				else if(count($js) == 1)
				{
					$fsjs = " and js = '$js[0]'";
				}
				$where = "(express = '2' or express = '63' or express = '64') and librarytime > '".strtotime(date("Y-m-d 8:30:0",strtotime("-6 day")))."' and librarytime < '".strtotime(date("Y-m-d 8:30:0",time()))."'".$fsjs;//3
			}
			
			else if($wid == 2 && stripos($notice['express'],',1,') !== false)
			{
			 	$where = "express != '2' and express != '63' and  express != '64' and printtype = '1' and waybill != '' and librarytime > '".strtotime(date("Y-m-d 20:00:0",strtotime("-6 day")))."' and librarytime < '".strtotime(date("Y-m-d 20:00:0",time()))."'";//4
			}
			else
			{
				exit;
			}
			$this->logic_ding->sendToDing("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
// 		    $wlfs = array();
// 		    $dd = $this->fullorder->find_all("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
// 			foreach($dd as $v){
// 				$this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】");
// 			}
		    // foreach ($dd as $v)
		    // {
			//     $shop = $this->shop->read($v['shop']);
			//     $express = $this->express->read($v['express']);
			//     $fs = $this->notice->get_god($v,$shop,$express,$notice);
			//     $this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】获取快递信息【".json_encode($notice,JSON_UNESCAPED_UNICODE)."】返回的信息".json_encode($fs));
			//     if($fs == 1)
			//     {
			// 	    $this->fullorder->save(array('dlzemail'=>1,'dlzemailtime'=>time()),$v['id']);
				    
			// 	    //给crm发送信息 先存储数据 后续定时任务执行
			// 		if($v['shop'] < 10){
						
			// 			$this->zztmpdata->insert([
			// 				'type'=>2,
			// 				'act_name'=>'crm_order',
			// 				'content'=>json_encode($v),
			// 				'create_time'=>time()
			// 			]);
						
			// 		}

				    
				    
			//     }
			//     else
			//     {
			// 		//$pdtime = date('Y-m-d',time());
			// 		//$folderPath = './data/dlzemail/'.$pdtime; // 文件夹路径
			// 		//$permissions = 0777; // 权限设置
			// 		//if (!file_exists($folderPath)) { mkdir($folderPath, $permissions); }//创建文件夹
			// 		//file_exists($folderPath);
			// 		if(!is_file("./data/dlzemail/".$v['number'].".txt"))
			// 		{
			// 			$myfile = fopen("./data/dlzemail/".$v['number'].".txt", "w") or die("Unable to open file!");
			// 			fwrite($myfile, json_encode($fs.'；'.$v.'；'.$shop.'；'.$express.'；'.$notice));
			// 			fclose($myfile);
			// 		}
			// 		else
			// 		{
			// 			$myfile = fopen("./data/dlzemail/".$v['number'].".txt", "a+") or die("Unable to open file!");
			// 			fwrite($myfile, json_encode($fs.'；'.$v.'；'.$shop.'；'.$express.'；'.$notice));
			// 			fclose($myfile);
			// 		}
			// 	    $this->fullorder->save(array('dlzemail'=>2,'dlzemailtime'=>time()),$v['id']);
			//     }
			//     sleep(50);
		    // }
		}
	}


	public function ll(){
		$str = 'sourcetype=2&warehouse=13&currency=219&capital=3&shop=52&pay=22&country=192&sbpm=Human Hair Wigs&zwpm=人发制假发*头套&hgbm=6704200000&express=1&printtype=1&msg=1&ioss=&qm=0&js=0&yc=0&orderinfo=&shouldmoney=1431.29&freight=0&expressmoney=0&insurance=0&paypal=0KE88673623148406&guarantee=无&quantity=1&buytime=2025-02-22&bname=Deidre Brown&sname=Deidre Brown&baddress=3854 Wordsworth Ave,Memphis,Tennessee,38128,US,9012890773&saddress=3854 Wordsworth Ave,Memphis,Tennessee,38128,US,9012890773&email=deidreb89.db@gmail.com&phone=9012890773&province=Tennessee&client=Deidre Brown&city=Memphis&name=Deidre Brown&zipcode=38128&address2=&address=3854 Wordsworth Ave&ts=8&dtsbjz=25&zsbjz=200.00&zzl=0.4&zjs=1&bx=0.00&freight=0&expressmoney=0&id=&purchase=0.00&cost=0.00&et=0&jgyc=1&customerid=1083429&shop=52&mdedit=&product=All+HD+lace+180%25density,+cap+size+21.5inch,+pre+plucked+and+pre+bleached.%0Acustom+black+mesh+cap,+only+1+comb+in+the+back,+no+tags%0A1.+16in+BW+5x5%0A2.+18IN+BW+6X6%0A3.+20in+BW+5x5%0A4.+24IN+BW+5x5%0A5.+24IN+BW+6x6%0A6.+22in+BW+5x5%0A7.+22in+BW+6x6%0A8.+20in+613+BW+5x5+%0AGifts:++HD+wig+cap,+Pink+Edge+Brushes&orderremarks=+%E6%89%B9%E5%8F%91%E5%AE%A2%E6%88%B7%EF%BC%88%E5%A4%A9%E5%AE%87%EF%BC%89&shipremarks=wig&jweight=0&whlabel=|12824698680571035402921382028-1-0|128246987805710321712921382028-1-0|12824698880571035402921382028-1-0|12824699080571035402921382028-1-0|128246990805710321712921382028-1-0|12824698980571035403021382028-1-0|128246989805710321712921382028-1-0|12824698881441035402921382028-1-0|&fpdata=86,-128-2469-80-57-103-540-29-2138-2028-%7CWigs+BenDang+9A+Natural+Black+Body+Wave+HD+5*5+Closure+Wig+Small+CustomizedDensity+HKK+16inch+%7C1%7C0.00%7C0.00%7C16%7C0.00%7C0.00%7C0%7C0;87,-128-2469-80-57-103-2171-29-2138-2028-%7CWigs+BenDang+9A+Natural+Black+Body+Wave+HD+6*6+Closure+Wig+Small+CustomizedDensity+HKK+18inch+%7C1%7C0.00%7C0.00%7C18%7C0.00%7C0.00%7C0%7C0;88,-128-2469-80-57-103-540-29-2138-2028-%7CWigs+BenDang+9A+Natural+Black+Body+Wave+HD+5*5+Closure+Wig+Small+CustomizedDensity+HKK+20inch+%7C1%7C0.00%7C0.00%7C20%7C0.00%7C0.00%7C0%7C0;90,-128-2469-80-57-103-540-29-2138-2028-%7CWigs+BenDang+9A+Natural+Black+Body+Wave+HD+5*5+Closure+Wig+Small+CustomizedDensity+HKK+24inch+%7C1%7C0.00%7C0.00%7C24%7C0.00%7C0.00%7C0%7C0;90,-128-2469-80-57-103-2171-29-2138-2028-%7CWigs+BenDang+9A+Natural+Black+Body+Wave+HD+6*6+Closure+Wig+Small+CustomizedDensity+HKK+24inch+%7C1%7C0.00%7C0.00%7C24%7C0.00%7C0.00%7C0%7C0;89,-128-2469-80-57-103-540-30-2138-2028-%7CWigs+BenDang+9A+Natural+Black+Body+Wave+HD+5*5+Closure+Wig+Medium+CustomizedDensity+HKK+22inch+%7C1%7C0.00%7C0.00%7C22%7C0.00%7C0.00%7C0%7C0;89,-128-2469-80-57-103-2171-29-2138-2028-%7CWigs+BenDang+9A+Natural+Black+Body+Wave+HD+6*6+Closure+Wig+Small+CustomizedDensity+HKK+22inch+%7C1%7C0.00%7C0.00%7C22%7C0.00%7C0.00%7C0%7C0;88,-128-2469-81-44-103-540-29-2138-2028-%7CWigs+BenDang+10A+#613+Body+Wave+HD+5*5+Closure+Wig+Small+CustomizedDensity+HKK+20inch+%7C1%7C0.00%7C0.00%7C20%7C0.00%7C0.00%7C0%7C0;&fpcount=-128-2469-86-80-57-103-540-29-2138-2028-|-128-2469-87-80-57-103-2171-29-2138-2028-|-128-2469-88-80-57-103-540-29-2138-2028-|-128-2469-90-80-57-103-540-29-2138-2028-|-128-2469-90-80-57-103-2171-29-2138-2028-|-128-2469-89-80-57-103-540-30-2138-2028-|-128-2469-89-80-57-103-2171-29-2138-2028-|-128-2469-88-81-44-103-540-29-2138-2028-|&budget=&
';
		parse_str($str, $output);

		return  $output;
	}

	//修改客户分类
	public function _mdedit($arg_array)
	{
	    die;
		$user = $this->user->read(10);
		
		$post = $this->ll();
		if(isset($post['shop']))
		{
			$fpcount = $post['fpcount'];
			if(!$fpcount)
			{
				echo json_encode(array('msg'=>'需要先清理浏览器缓存，刷新当前页面后再试！','success'=>false));exit;
			}
			$customerid = $post['customerid'];
			$shop = $post['shop'];
			$sp = $this->shop->read($shop);
			$num = $this->fullorder->find_count('shop = "'.$sp['id'].'" and gtime = "'.date('Ymd',time()).'"');
			$post['source'] = 1;//订单类型：1.线下订单2.PC3.手机
			$post['state'] = 207;//订单状态：207等待发货
			$post['review'] = 2;//审核状态：1.未送审2.待审核3.不通过4取消重审5.审核通过6.自动通过
			$post['print'] = 1;//打印状态：1.不可打印2.未打印3.已打印
			$post['library'] = 1;//出库状态：1.未出库2.已出库3.已退库
			$post['libraryconfirm'] = 1;//出库确认：1.不允许2.允许
			$post['link'] = $sp['link'];
			$post['issku'] = $sp['sku'];
			if($post['print'] != 3)
			{
			    $post['librarynot'] = "订单未打印，未审核或未通过";//不能出库原因
			}
			$orderinfo = $post['orderinfo'];
			$post['shop'] = $sp['id'];
			$post['user'] = $sp['shopuser'];
			$post['number'] = $sp['shortname'].'-'.substr(date('ymd',time()),1).'-'.(substr(strval($num+1+1000),1,3));//编号 
			if($orderinfo != "")
			{
				$ordefin = $this->fullorder->get_orderinfo($orderinfo);
				if($ordefin)
				{
					echo json_encode(array('msg'=>'订单号重复！','success'=>false));exit;
				}
				else
				{
				    $post['orderinfo'] = $orderinfo;
				}
			}
			else
			{
			    $post['orderinfo'] = $sp['id'].date('ymdHis',time()).rand(0,1);//订单号
			}
			if($post['paypal'] != '')
			{
			    $pp = $this->fullorder->get_paypal($post['paypal']);	
			    if($pp)
			    {
				    echo json_encode(array('msg'=>'此交易号的订单已存在！','success'=>false));exit;
			    }
		    }
			$post['client'] = $post['client'];//客户名称
			$btime = $post['buytime'];//付款时间
			$post['buytime'] = strtotime($btime);//时间转UX
			$post['dtime'] = time();//订单时间
			$post['gtime'] = date('Ymd',time());//格式化时间
			$post['pay'] = $post['pay'];//支付方式
			$post['capital'] = $post['capital'];//资金状态
			$post['type'] = $post['warehouse'];//发货仓库
			$post['currency'] = $post['currency'];//币种
			$currency = $this->typeclass->read($post['currency']);
			$post['currencytitle'] = $currency['title'];//币种名称
			$post['freight'] = $post['freight'];//运费
			$post['expressmoney'] = $post['expressmoney'];//物流金额
			$post['shouldmoney'] = $post['shouldmoney'];//应收金额
			$post['skje'] = $post['shouldmoney'];//收款金额
			$product = $post['product'];//产品名称
			$product = str_replace(array('%26','%2B'),array('&','+'),$product);
			$post['product'] = preg_replace('/( |　| |\s)/',' ',$product);
			$orderremarks = $post['orderremarks'];//订单备注
			$orderremarks = str_replace(array('%26','%2B'),array('&','+'),$orderremarks);
			$post['orderremarks'] = preg_replace('/( |　| |\s)/',' ',$orderremarks);
			$shipremarks = $post['shipremarks'];//仓库品名
			$shipremarks = str_replace(array('%26','%2B'),array('&','+'),$shipremarks);//仓库品名
			$post['shipremarks'] = preg_replace('/( |　| |\s)/',' ',$shipremarks);
			$post['email'] = $post['email'];//邮箱
			$name = $post['name'];//名称
			$post['name'] = preg_replace('/( |　| |\s)/',' ',$name);
			$post['phone'] = $post['phone'];//电话
			$post['phone'] = preg_replace('/\D/s','',$post['phone']);
			$post['country'] = $post['country'];//国家
			$ct = $this->country->read($post['country']);//国家
			$post['al'] = $ct['lb'];//国家二字码
			$post['province'] = $post['province'];//省、州
			$post['province'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['province']); //替换开头空字符
            $post['province'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['province']); //替换结尾空字符
			$post['city'] = $post['city'];//城市
			$post['city'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['city']); //替换开头空字符
            $post['city'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['city']); //替换结尾空字符
			$post['zipcode'] = $post['zipcode'];//邮编
			$post['zipcode'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['zipcode']); //替换开头空字符
            $post['zipcode'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['zipcode']); //替换结尾空字符
			$post['address'] = $post['address'];//地址
			$post['printtype'] = $post['printtype'];//打印类型
			$fpdata = $post['fpdata'];//购买产品内容
			$fpdata = str_replace(array('%26','%2B'),array('&','+'),$fpdata);
			$post['fpdata'] = $fpdata;
			$post['sbpm'] = $post['sbpm'];//申报品名
			$post['zwpm'] = $post['zwpm'];//中文品名
			$post['ts'] = $post['ts'];//条数
			$post['dtsbjz'] = $post['dtsbjz'];//单条申报价
			$post['zsbjz'] = $post['zsbjz'];//总申报价
			$post['zzl'] = $post['zzl'];//总重量
			$post['zjs'] = $post['zjs'];//总件数
			$post['express'] = $post['express'];//快递公司
			$post['printtype'] = $post['printtype'];//打印类型
			$post['quantity'] = $post['quantity'];//数量
			$post['paypal'] = $post['paypal'];//支付号
			$post['guarantee'] = $post['guarantee'];//卖家保障
			$post['msg'] = $post['msg'];//发送留言类型
			$post['ioss'] = $post['ioss'];
			$post['sbpm'] = $post['sbpm'];
			$pay = $this->pay->get_typeclass($post['pay']);
			$yga = $post['shouldmoney'];
			$post['budget'] = 0;
			if($pay)
			{
				$ygc = $pay['estimaterate'];//预估到账公式
				$ifbudget = eval("return $yga*1.$ygc;");
				$post['estimaterate'] = $pay['estimaterate'];
				if($ifbudget > 0)
				{
				    $post['budget'] = eval("return $yga*1.$ygc;");//预估到帐金额
				}
			}
			else
			{
				$ygb = $sp['estimaterate'];//店铺默认到账公式
				$ifbudget = eval("return $yga*1.$ygb;");
				$post['estimaterate'] = $sp['estimaterate'];
				if($ifbudget > 0)
				{
		    	    $post['budget'] = eval("return $yga*1.$ygb;");//预估到帐金额
				}
			}
			$baddress = $post['baddress'];
			$saddress = $post['saddress'];
			$baddress = array_reverse(explode(',',$baddress));
			$saddress = array_reverse(explode(',',$saddress));
			$bar = '';$sar = '';
			$cr = $this->country->read($post['country']);
			$baddress[1] = $cr['lb'];
			$saddress[1] = $cr['lb'];
			$baddress = array_reverse($baddress);
			$saddress = array_reverse($saddress);
			for($i=0;$i<count($baddress);$i++)
			{
				$bar .= $baddress[$i].',';
			}
			for($i=0;$i<count($saddress);$i++)
			{
				$sar .= $saddress[$i].',';
			}
			$post['baddress'] = rtrim($bar,',');//卖家保障
			$post['saddress'] = rtrim($sar,',');//卖家保障
			$whlabel = $post['whlabel'];
			if($post['express'] == 2 && (stripos($post['name'],'&') !== false || stripos($post['name'],"'") !== false))
			{
				echo json_encode(array('msg'=>'USPS收件人或公司名不可用特殊符号！','success'=>false));exit;
			}
			if(strlen($post['client']) > 35 || strlen($post['name']) > 35)//收件人姓名或公司名不允许超过35位
			{
				echo json_encode(array('msg'=>'收件人姓名或公司名不可超过35个字符！','success'=>false));exit;
			}
			if(($post['express'] == '5' || $post['express'] == '24' || $post['express'] == '42' || $post['express'] == '31') && $post['country'] != 192)
			{
				echo json_encode(array('msg'=>'非美国无法选择Fedex、DHL官方-美国！','success'=>false));exit;
			}
			if($post['express'] == '3' && $post['country'] != 192 && $post['country'] != 35)
			{
				echo json_encode(array('msg'=>'非美国和加拿大无法选择UPS！','success'=>false));exit;
			}
			if($post['express'] == '3' && $post['country'] == 35 && $post['zsbjz'] > 20)
			{
				echo json_encode(array('msg'=>'UPS加拿大最高申报不可超过20','success'=>false));exit;
			}
			if($post['express'] == '2' && $post['warehouse'] != 5)
			{
				echo json_encode(array('msg'=>'非美国仓无法选择USPS！','success'=>false));exit;
			}
			if($post['express'] == '99' && $post['bx'] > 0)
			{
				echo json_encode(array('msg'=>'此物流不允许购买保险','success'=>false));exit;
			}
			if($post['express'] == 42 && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 || 
			{
				echo json_encode(array('msg'=>'此快递方式必须选择Human Hair Wigs/Human Hair Goods！','success'=>false));exit;
			}
			if($post['express'] == 24 && $post['sbpm'] != 'Hair Sample' && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 || 
			{
				echo json_encode(array('msg'=>'此快递方式必须选择Hair Sample/Human Hair Wigs/Human Hair Goods！','success'=>false));exit;
			}
			if($post['country'] != 192 && $post['express'] == 1 && $post['sbpm'] != 'Synthetic Hair Wigs' && $post['sbpm'] != 'Synthetic Hair Goods')//$post['express'] == 3 || 
			{
				echo json_encode(array('msg'=>'非美国选择官方DHL必须选择Synthetic Hair Wigs/Synthetic Hair Goods','success'=>false));exit;
			}
			if($post['pay'] == '22' && ($post['paypal'] == '' || $post['guarantee'] == ''))
			{
				echo json_encode(array('msg'=>'交易号和卖家保障必须填写','success'=>false));exit;
			}
			if($post['pay'] == '23' && $post['paypal'] == '')
			{
				echo json_encode(array('msg'=>'交易号必须填写','success'=>false));exit;
			}
			$express = $this->express->read($post['express']);
			if($post['zsbjz'] > $express['sbjz'])
			{
				echo json_encode(array('msg'=>'总申报价值不可超出'.$express['sbjz'],'success'=>false));exit;
			}
			if($post['shouldmoney'] > $express['shouldmoney'] && $express['shouldmoney'] != 0)
			{
				echo json_encode(array('msg'=>'订单金额不可超出'.$express['shouldmoney'],'success'=>false));exit;
			}
			if($express['ioss'] == 1 && $post['ioss'] == '')
			{
				 echo json_encode(array('msg'=>'此快递方式必须选择IOSS！','success'=>false));exit;
			}
			if(strlen($post['address']) > $express['addresssize'] || strlen($post['address2']) > $express['addresssize'])
			{
				echo json_encode(array('msg'=>'此快递方地址不可超出'.$express['addresssize'].'个字符','success'=>false));exit;
			}
			if(strlen($post['address']) < 5)
			{
				echo json_encode(array('msg'=>'地址不可留空！','success'=>false));exit;
			}
			if($post['express'] == '2' && $post['zzl'] > '16' && $post['js'] == '0')
			{
				echo json_encode(array('msg'=>'重量大于16不可按Ground Advantage提交！','success'=>false));exit;
			}
			if($post['express'] == '2' && isset($post['js']) && $post['js'] == '0'&& $post['qm'] == '1')
			{
				echo json_encode(array('msg'=>'Ground Advantage不可使用签名服务！','success'=>false));exit;
			}
			if(($post['express'] == '3' || $post['express'] == '42' || $post['express'] == '24') && $post['shouldmoney'] < 1)
			{
				echo json_encode(array('msg'=>'零金额订单不可发 UPS/DHL官方-美国/Fedex(杭州)','success'=>false));exit;
			}
			if($post['express'] == '42' && $post['zsbjz'] < 1)
			{
				echo json_encode(array('msg'=>'零申报金额不可发 DHL官方-美国','success'=>false));exit;
			}
			if($post['express'] == '6' && $post['province'] == '')
			{
				echo json_encode(array('msg'=>'选择DPEX必须填写州信息','success'=>false));exit;
			}
			
			$dtctitle = array();
			$dictionaries = $this->typeclass->find_all();
			foreach ($dictionaries as $v)
			{
				$dtctitle[$v['id']] = array($v['title'],$v['bqsku']);
			}
			$fpdata = $post['fpdata'];
			if(stripos($fpdata,'-128-') !== false || stripos($fpdata,'-127-') !== false)
			{
			    $dfp =  explode(';',trim($fpdata,';'));
			    $fdata = '';
			    foreach ($dfp as $k=>$v)
			    {
				    $ptitleb = '';
				    $fp = explode('|',trim($v,'|'));
				    $fp0 = explode(',',$fp[0]);
					if(isset($fp0[1]))
					{
				        $fp1 = explode('-',trim($fp0[1],'-'));
					}
					else
					{
						$fp1 = explode('-',trim($fp[0],'-'));
					}
				    foreach ($fp1 as $vv)
				    {
					    $ptitleb .= isset($dtctitle[$vv])?$dtctitle[$vv][0].' ':'';
				    }
					if(isset($fp0[1]))
					{
				         $ptitleb .= $dtctitle[$fp0[0]][1].'inch ';
				         $fp[1] = $ptitleb;
					}
				    $fdata .= implode("|",$fp).";";
			    }
			    $fpdata = $fdata;
			}
			
			$warehouse = $this->warehouse->read($post['type']);
			if($warehouse['bdcountry'] != 0 && $post['country'] != $warehouse['bdcountry'])
			{
				echo json_encode(array('msg'=>'当前国家无法选择'.$warehouse['title'].'！','success'=>false));exit;
			}
			
			    // $kcyz = $this->ck->get_kc($post['state'],$warehouse,$post['shop'],$post['number'],$whlabel,$fpdata);
			    // if($kcyz['t'] > '0')
			    // {
				// 	echo $kcyz['m'];exit;
			    // }
			    // else if($kcyz['fpdata'] != '')
			    // {
				//     $post['whlabel'] = $kcyz['whlabel'];
				//     $post['fpdata'] = $kcyz['fpdata'];
			    // }
				// $fl = $this->ck->get_fl($warehouse['hz'],$whlabel,$fpdata);
				// $post['sfxh'] = $fl['sfxh'];
				// $post['ckfl'] = $fl['ckfl'];
				
				//查询净重开始
			$post['jweight'] = $this->weight->get_weightcx($post['fpdata']);
			//查询净重结束
					$cusnum = $this->customer->read($customerid);
					// $this->customer->save(array('num'=>$cusnum['num']+1,'time'=>$post['buytime']),$customerid);
					// $this->fullorder->insert($post);
					echo json_encode(array('msg'=>'下单成功','success'=>true));exit;	
		}
		
		
		echo "1";
		die;
	}
	
	public function cc(){
		$filename = date("Y-m-d") . "产品入库导出.xls";
		$str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
		<head>
		<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
		<!--[if gte mso 9]>
		<xml>
			<x:ExcelWorkbook>
				<x:ExcelWorksheets>
					<x:ExcelWorksheet>
						<x:Name>产品入库</x:Name>
						<x:WorksheetOptions>
							<x:Print>
								<x:ValidPrinterInfo />
							</x:Print>
						</x:WorksheetOptions>
					</x:ExcelWorksheet>
				</x:ExcelWorksheets>
			</x:ExcelWorkbook>
		</xml>
		<![endif]-->
		<style>
			tr { mso-height-source: auto; }
			.fixed-height { 
				height: 100px; /* 设置固定行高 */
				mso-height-source: userset; /* 强制Excel使用设定高度 */
			}
				
			
			
		</style>
		</head>
		<body>";
		
		$str .= "<table border='1' cellspacing='0' style='border-collapse: collapse; font-family: Microsoft Yahei; font-size: 13px;'>"; 
		$str .= "<tr >"; // 应用固定高度类
		$str .= "<td>产品ID</td>";
		$str .= "<td>图片1</td>";
		$str .= "</tr>";
		
		$str .= "<tr class='fixed-height'>"; // 应用固定高度类
		$str .= "<td>ceshi12321312312312312312312312312312312</td>";    
		$str .= '<td >
		<table border="0">
			<tr class="fixed-height" >
			<td ><img class="excel-image" width="70" height="auto" src="http://1.wepolicy.cn/data/img/20250703/20250703_085106_9716.png"></td>
			<td ><img class="excel-image" width="70" height="auto" src="http://1.wepolicy.cn/data/img/20250703/20250703_085106_9716.png"></td>
			</tr>
		</table>
		</td>';    
		// $str .= '<td class="image-cell" style="width: 100px; height: 100px;"><img class="excel-image" width="80" height="auto" src="http://1.wepolicy.cn/data/img/20250703/20250703_085106_9716.png"></td>';    
		$str .= "</tr>";
		
		$str .= "</table></body></html>"; 
		
		header("Content-Type: application/vnd.ms-excel; charset=utf-8"); 
		header("Content-Disposition: attachment; filename=".$filename); 
		header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
		header("Pragma: no-cache"); 
		header("Expires: 0"); 
		exit($str); 
	}


	
}