Aatest.php 52 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365
  1. <?php defined('BASEPATH') OR exit('No direct script access allowed');
  2. class Aatest extends Start_Controller {
  3. public function __construct(){
  4. parent::__construct();
  5. $this->load->library('session');
  6. $this->load->_model('Model_whlabel','whlabel');
  7. $this->load->_model('Model_warehouse','warehouse');
  8. $this->load->_model('Model_productprice','productprice');
  9. $this->load->_model('Model_excel','excel');
  10. $this->load->_model('Model_fullorder','fullorder');
  11. $this->load->_model('Model_fullordertt','fullordertt');
  12. $this->load->_model('Model_fullordersmt','fullordersmt');
  13. $this->load->_model('Model_outbound','outbound');
  14. $this->load->_model('Model_express','express');
  15. $this->load->_model('Model_shop','shop');
  16. $this->load->_model('Model_typeclass','typeclass');
  17. $this->load->_model('Model_country','country');
  18. $this->load->_model('Model_kdniao','kdniao');
  19. $this->load->_model('Model_notice','notice');
  20. $this->load->_model('Model_dhl','dhl');
  21. $this->load->_model('Model_dhlhz','dhlhz');
  22. $this->load->_model('Model_usps','usps');
  23. $this->load->_model('Model_fedex','fedex');
  24. $this->load->_model('Model_fedex_cby','fedex_cby');
  25. $this->load->_model('Model_ups','ups');
  26. $this->load->_model('Model_ali','ali');
  27. $this->load->_model('Model_dpd','dpd');
  28. $this->load->_model('Model_user','user');
  29. $this->load->_model('Model_whlabel','whlabel');
  30. $this->load->_model('Model_specialstock','specialstock');
  31. $this->load->_model('Model_ck','ck');
  32. $this->load->_model('Model_whlabellabel','whlabellabel');
  33. $this->load->_model('Model_apiyy','apiyy');
  34. $this->load->helper('url');
  35. $this->load->_model('Model_whlabel_fc','whlabel_fc');
  36. $this->load->_model('Model_systemtransfer','systemtransfer');
  37. $this->load->_model('Model_classid','classid');
  38. $this->load->_model('Model_allocation','allocation');
  39. $this->load->_model('Model_fullorderxw','fullorderxw');
  40. $this->load->_model('Model_fullorderpaypal','fullorderpaypal');
  41. $this->load->_model('Model_fedexv1','fedexv1');
  42. $this->load->_model('Model_logic_crm','logic_crm');
  43. $this->load->_model("Model_fullorder","fullorder");
  44. $this->load->_model("Model_express","express");
  45. $this->load->_model("Model_logic_ding","logic_ding");
  46. $this->load->_model("Model_api",'api');
  47. $this->load->_model("Model_usps",'usps');
  48. $this->load->_model('Model_emaildata','emaildata');
  49. $this->load->_model('Model_logic_tools','logic_tools');
  50. $this->load->_model('Model_logic_order','logic_order');
  51. $this->load->_model('Model_returngoods','returngoods');
  52. $this->load->_model('Model_returnlogs','returnlogs');
  53. $this->load->_model('Model_productdescribe','productdescribe');
  54. $this->load->_model('Model_logic_u9tools','logic_u9tools');
  55. $this->load->_model('Model_17track','17track');
  56. $this->load->_model('Model_customer','customer');
  57. $this->load->_model('Model_express','express');
  58. $this->load->_model('Model_weight','weight');
  59. $this->load->_model('Model_cne','cne');
  60. $this->load->_model("Model_zzjobs","zzjobs");
  61. $this->load->_model("Model_zzerrlog","zzerrlog");
  62. $this->load->_model("Model_zzhjobs","zzhjobs");
  63. $this->load->_model('Model_apiyy','apiyy');
  64. $this->load->_model('Model_systemtransfer','systemtransfer');
  65. $this->load->_model('Model_afspaypal','afspaypal');
  66. $this->load->_model('Model_message','message');
  67. $this->load->_model('Model_itsxb','itsxb');
  68. $this->load->_model("Model_logic_order","logic_order");
  69. $this->load->_model("Model_job_get3pewaybillid",'job_get3pewaybillid');
  70. $this->load->_model("Model_yuntu","yuntu");
  71. $this->load->_model("Model_job_getyuntuwaybillid","job_getyuntuwaybillid");
  72. $this->load->_model("Model_hualei",'hualei');
  73. $this->load->_model("Model_job_gethualeiwaybillid","job_gethualeiwaybillid");
  74. $this->load->_model("Model_apiyyv1","apiyyv1");
  75. $this->load->_model("Model_settingtest","settingtest");
  76. $this->load->_model("Model_cne","cne");
  77. $this->load->_model("Model_apismt","apismt");
  78. $this->load->_model("Model_notice","notice");
  79. $this->load->_model("Model_producttitle","producttitle");
  80. $this->load->_model("Model_apitt","apitt");
  81. $this->load->_model("Model_zzjobs","zzjobs");
  82. $this->load->_model("Model_logic_goods_replace","logic_goods_replace");
  83. $this->load->_model("Model_apittv1","apittv1");
  84. $this->load->_model("Model_express_tt","express_tt");
  85. $this->load->_model("Model_check","check");
  86. $this->load->_model("Model_logic_express","logic_express");
  87. }
  88. //定义方法的调用规则 获取URI第二段值
  89. public function _remap($arg,$arg_array)
  90. {
  91. //测试 erp现在还在用的数据
  92. //
  93. $list = $this->fullordersmt->find_all("print = 3","*","id desc",0,1000);
  94. echo "<pre>";
  95. foreach($list as $k=>$v){
  96. $express_info = $this->express->read($v['express']);
  97. if(empty($v['express'])){
  98. continue;
  99. }
  100. if(empty($v['waybill'])){
  101. var_dump("===================================");
  102. var_dump($v['number']."----".$v['waybill']."-----".$express_info['servicename']."----".$v['express']."----".$express_info['printcode']);
  103. var_dump("===================================");
  104. continue;
  105. }
  106. $r = $this->logic_express->ydCheckById($v['waybill'],$v['express']);
  107. $y = $this->logic_express->ydCheckByPrintcode($v['waybill'],$express_info['printcode']);
  108. echo "<hr>";
  109. var_dump("----R:".$r."----Y:".$y);
  110. var_dump($v['number']."----".$v['waybill']."-----".$express_info['servicename']."----".$v['express']."----".$express_info['printcode']);
  111. }
  112. die;
  113. $info = $this->logic_order->getInfo("orderinfo = '577193171472388208'");
  114. if(is_string($info['extra_text'])){
  115. $extra_text = json_decode($info['extra_text'],true);
  116. //快递服务商
  117. $server_info = $extra_text['server_info'];
  118. }else{
  119. //快递服务商
  120. $server_info = $info['extra_text'];
  121. }
  122. $post = [
  123. 'order_id'=>$server_info['order_id'],
  124. "order_line_item_ids"=>$server_info['order_line_id'],
  125. "dimension"=>$server_info['dimension'],
  126. "shipping_service_id"=>$server_info['shipping_services'][$info['ttsp_xz']]['id'],
  127. "weight"=>$server_info['weight'],
  128. ];
  129. die;
  130. $shop = $this->shop->read(35);
  131. //$order_id = "577182146069041251";
  132. // $info = $this->logic_order->getInfo("orderinfo = '577179541684588966'");
  133. // $r = $this->express_tt->get_data($info,'CBT');
  134. // echo "<pre>";
  135. // print_r($r);
  136. // $r = $this->check->checkOverdue("Miran Emmanuel","KISS-PF1-251105-003","");
  137. // var_dump($r);
  138. $info = $this->logic_order->getInfo("orderinfo = '577182146069041251'");
  139. $r = $this->express_tt->downloadExpressLabel($info,$shop);
  140. echo "<pre>";
  141. print_r($r);
  142. die;
  143. // $res = "";
  144. // $r = json_decode($res,true);
  145. // var_dump($r);
  146. // die;
  147. // $list = $this->fullordertt->find_all("express = 83 and printtime >= 1762780009","orderinfo,extra_text");
  148. // echo "<pre>";
  149. // var_dump(count($list));
  150. // foreach($list as $k=>$v){
  151. // $extra_text = json_decode($v['extra_text'],true);
  152. // if(empty($extra_text['label_info'])){
  153. // var_dump("----".$v['orderinfo']);
  154. // var_dump($extra_text);
  155. // var_dump("----".$v['orderinfo']);
  156. // }else{
  157. // if($extra_text['label_info']['order_id'] == $v['orderinfo']){
  158. // var_dump($v['orderinfo']);
  159. // }
  160. // }
  161. // }
  162. // $where_arr = [
  163. // //"shop"=>35,//当前店铺为tt-wk
  164. // "express"=>83,//快递为tt-cbt
  165. // "print"=>2,//未打印
  166. // "printnumber"=>0,//打印次数
  167. // 'library'=>1,//未出库
  168. // //'libraryconfirm'=>2,//允许出库
  169. // "review >"=>4,//审核通过或自动审核
  170. // ];
  171. // //$shop_info = $this->shop->read(35);
  172. // $shop_list = $this->shop->find_all('id in (35,46)');
  173. // $shop_list = array_column($shop_list,null,'id');
  174. // // if(empty($shop_info)){
  175. // // exit("当前店铺不存在");
  176. // // }
  177. // $list = $this->db->from("fullordertt")
  178. // ->select("id,orderinfo,shop,express,print,printnumber,library,review,state")
  179. // ->where($where_arr)
  180. // ->where_not_in('state',[214,217])
  181. // ->get()->result_array();
  182. // if(empty($list)){
  183. // exit("没有符合条件的订单");
  184. // }
  185. // echo "<pre>";
  186. // print_r($list);
  187. // die;
  188. // $orderinfo = "577174340616098089";
  189. // $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"}';
  190. // $res = json_decode($str,true);
  191. // $info = $this->fullordertt->get_orderinfo($orderinfo);
  192. // $extra_text = json_decode($info['extra_text'],true);
  193. // $extra_text['label_info'] = $res['data'];
  194. // $info['extra_text'] = json_encode($extra_text,JSON_UNESCAPED_UNICODE);
  195. // $this->db->update('fullordertt', [
  196. // 'extra_text' => $info['extra_text']
  197. // ], ['id' => $info['id']]) ;
  198. die;
  199. //$str = preg_replace('/\s*\|\s*/', '|', $str);
  200. // $list = $this->db->from("fullorder")->order_by('id' ,'desc')->limit(3000,0)->get()->result_array();
  201. // foreach($list as $k => $v){
  202. // $fpdata = preg_replace('/\s*\|\s*/', '|', $v['fpdata']);
  203. // $this->fullorder->save(['fpdata'=>$fpdata],$v['id']);
  204. // }
  205. // $this->logic_ding->sendToDing("source != '1' and dlzemail < '1' and");
  206. // $product_id = 33204;
  207. // $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();
  208. // echo "<pre>";
  209. // print_r($r);
  210. die;
  211. // $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();
  212. die;
  213. $where_arr = [
  214. "shop"=>35,//当前店铺为tt-wk
  215. "express"=>83,//快递为tt-cbt
  216. "print"=>2,//未打印
  217. "printnumber"=>0,//打印次数
  218. 'library'=>1,//未出库
  219. "review >"=>4,//审核通过或自动审核
  220. ];
  221. $list = $this->db->from("fullordertt")
  222. ->where($where_arr)
  223. ->where_not_in('state',[214,217])
  224. ->get()->result_array();
  225. echo "<pre>";
  226. print_r($list);
  227. die;
  228. $info = $this->logic_order->getInfo("number = '".$arg_array[0]."'");
  229. echo "<pre>";
  230. $res = $this->express_tt->get_data($info,'CBT');
  231. print_r($res);
  232. die;
  233. $info = $this->logic_order->getInfo("number = '".$arg_array[0]."'");
  234. $extra_text = json_decode($info['extra_text'],true);
  235. $packages = $extra_text['packages'];
  236. $package_id = $packages[0]['id'];
  237. $shop = $this->shop->read($info['shop']);
  238. //$r = $this->apitt->downloadLabel($package_id,$shop,$info);
  239. $r = $this->apittv1->ShipByTiktok($package_id,$shop,$info);
  240. var_dump($r);
  241. die;
  242. //$this->_print();
  243. exit('No direct script access allowed');
  244. if($arg == 'dayin')
  245. {
  246. $this->_a();
  247. //$this->_pdfurl("https://www.fedex.com/document/v1/cache/retrieve/SH,bfa0bef58beaa8cc884714432636_SHIPPING_Z?isLabel=true&autoPrint=false&retrievalMode=THERMAL",'ces','20210825155500');
  248. }elseif($arg == 'getorder'){
  249. $this->_getorder();
  250. }else{
  251. exit('No direct script access allowed');
  252. }
  253. }
  254. private function jiai($arg_array){
  255. $key = "6amg!pnfrlbpnjgirv"; //加密所需要到的key
  256. $iv = "6ook4k!2w94m6jtm";//加密所需要到的iv
  257. $time = time();
  258. $data = array(
  259. "order_no" => $arg_array[0],
  260. "shop" => "3",
  261. "time"=>time()
  262. );
  263. $decrypt = "alipearlhair+".$data['time'];
  264. $key = openssl_encrypt($decrypt,'AES-128-CBC',$key,0,$iv);
  265. $data['key'] = $key;
  266. // 将PHP数组编码为JSON字符串
  267. $jsonData = json_encode($data);
  268. $url = "https://1.wepolicy.cn/apiexpress/search";
  269. // 初始化cURL
  270. $ch = curl_init($url);
  271. // 设置cURL选项
  272. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  273. curl_setopt($ch, CURLOPT_POST, true);
  274. // 直接传入JSON字符串作为POST数据
  275. curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonData);
  276. // 关键:设置HTTP头,声明内容类型为JSON
  277. curl_setopt($ch, CURLOPT_HTTPHEADER, array(
  278. 'Content-Type: application/json',
  279. 'Content-Length: ' . strlen($jsonData) // 可选项,设置数据长度
  280. ));
  281. // 执行请求
  282. $response = curl_exec($ch);
  283. // 检查cURL执行是否出错
  284. if (curl_errno($ch)) {
  285. $error_msg = curl_error($ch);
  286. // 处理错误
  287. }
  288. // 关闭cURL会话
  289. curl_close($ch);
  290. // 处理API返回的JSON响应
  291. $responseData = json_decode($response, true);
  292. echo "<pre>";
  293. print_r($response);
  294. }
  295. private function _ttexpress(){
  296. $info = $this->logic_order->getInfo("number = 'TT-KISS-251021-001'");
  297. $res = $this->express_tt->get_data($info,'FBT');
  298. echo "<pre>";
  299. print_r($res);
  300. }
  301. private function dokucun(){
  302. //美仓 未出库
  303. // $info = $this->db->from("whlabel")->where([
  304. // "warehouse"=>13,
  305. // 'state'=>0
  306. // ])->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();
  307. $info = $this->db->from("whlabel")->where([
  308. "warehouse"=>13,
  309. 'state'=>0
  310. ])->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();
  311. echo "<pre>";
  312. print_r($info->result_array());
  313. die;
  314. }
  315. public function _pdfurl($pdf,$title,$bctime)
  316. {
  317. $pdf_path = './data/pdf/'.$bctime.'/';
  318. $pdf = fopen($pdf,"r");
  319. if(!is_dir($pdf_path))mkdir($pdf_path,0777); //上传目录不存在则创建
  320. file_put_contents($pdf_path.$title.'.pdf',$pdf);
  321. return $bctime;
  322. }
  323. public function _linshittmsg(){
  324. exit;
  325. $fullorder = $this->fullordertt->get_orderinfo("577118877757837357");
  326. $shop = $this->shop->read($fullorder['shop']);
  327. $express = $this->express->read($fullorder['express']);
  328. $notice = $this->notice->find_all("id = 134");
  329. echo "<pre>";
  330. // print_r($fullorder);
  331. // print_r($shop);
  332. // print_r($express);
  333. // print_r($notice);
  334. // die;
  335. // $list = $fullorder;
  336. // $ProductName = '';
  337. // if(empty($list['fpdata'])){
  338. // $st = [];
  339. // }else{
  340. // $st = explode(';',trim($list['fpdata'],';'));
  341. // }
  342. // foreach ($st as $v)
  343. // {
  344. // $v = explode('|',trim($v,'|'));
  345. // if(isset($v[1]))
  346. // {
  347. // $th = $this->producttitle->get_title($v[1]);
  348. // if($th)
  349. // {
  350. // $ProductName .= $th['th'].', ';
  351. // }
  352. // else
  353. // {
  354. // $ProductName .= $v[1].', ';
  355. // }
  356. // }
  357. // }
  358. // var_dump($ProductName);
  359. // die;
  360. $go = $this->notice->get_god($fullorder,$shop,$express,$notice[0]);
  361. echo "<pre>";
  362. print_r($go);
  363. die;
  364. }
  365. public function _u9dcd(){
  366. $token = $this->settingtest->get_yytoken_120();
  367. $doc_no = $this->input->get('doc_no',true);
  368. $res = $this->apiyyv1->cxScdStatus($doc_no,$token);
  369. echo "<pre>";
  370. var_dump($res);
  371. die;
  372. }
  373. public function _apismtOrder(){
  374. $post = $this->apismt->get_order("8204437130874932","50000601909fLFcsqEWGf1fd9756fw3q0TfklNpzHt1GHWEQtdwSvsNsWTa0WCkkIgJ");
  375. echo "<pre>";
  376. var_dump($post);
  377. die;
  378. }
  379. public function dock(){
  380. $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;";
  381. $wh = "|1288087258485610414630722071-1-0|1312247-1-0|1312236-1-0|1312492-1-0|1312235-1-0|1312250-1-0|";
  382. $number = "TT-WK-250811-087";
  383. $warehouse = $this->warehouse->find_all("fpzd = '1'",'*','fpsx desc');
  384. echo "<pre>";
  385. foreach ($warehouse as $v)
  386. {
  387. $yx = 'get_yx_'.$v['bdck'];
  388. $kczd = $this->ck->$yx(207,$v,35,$number,$wh,$fp);
  389. var_dump($kczd);
  390. }
  391. }
  392. public function getToken($type){
  393. $name = "get_yytoken_".$type;
  394. $token = $this->settingtest->$name();
  395. return $token;
  396. }
  397. public function _notice(){
  398. $notice = $this->notice->read(30);
  399. $v = $this->fullorder->get_number('Y-50728-010');
  400. $shop = $this->shop->read($v['shop']);
  401. $express = $this->express->read($v['express']);
  402. echo "<pre>";
  403. print_r($notice);
  404. print_r($v);
  405. print_r($shop);
  406. die;
  407. $fs = $this->notice->get_god($v,$shop,$express,$notice);
  408. }
  409. public function _error(){
  410. // echo $c;
  411. set_error_handler(function($severity, $message, $file, $line) {
  412. // 自定义错误处理逻辑
  413. throw new ErrorException($message, 0, $severity, $file, $line);
  414. //return true; // 返回true表示已处理,阻止CI继续处理
  415. });
  416. set_exception_handler(function($exception) {
  417. // 自定义异常处理逻辑
  418. // 一般也就是处理一下抛出可允许的错误 允许往下执行 目前这里不做任何处理 只关注于 sql的错误和程序执行的异常
  419. });
  420. $this->db->db_debug = false;
  421. $this->db->trans_begin();
  422. try{
  423. $do_sql = $this->db->insert('table', []);
  424. if(!$do_sql){
  425. throw new Exception("sql error:【".$this->db->error()['message']."】");
  426. }
  427. }catch(Exception $e){
  428. $this->db->trans_rollback();
  429. exit(json_encode(['msg'=>$e->getMessage(),'success'=>false],JSON_UNESCAPED_UNICODE));
  430. }finally{
  431. if ($this->db->trans_status() === TRUE)
  432. {
  433. $this->db->trans_commit();
  434. exit(json_encode(['msg'=>"操作成功",'success'=>true],JSON_UNESCAPED_UNICODE));
  435. }
  436. else
  437. {
  438. $this->db->trans_rollback();
  439. exit(json_encode(['msg'=>"sql语句执行",'success'=>false],JSON_UNESCAPED_UNICODE));
  440. }
  441. }
  442. }
  443. public function _plcl(){
  444. $typeclass = [];
  445. $classid = $this->classid->sku();
  446. $tcall = $this->typeclass->find_all();
  447. foreach ($tcall as $v)
  448. {
  449. //$tcjm[$v['id']] = array($v['jm'],$v['classid']);
  450. $typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
  451. }
  452. $dtctitle = [];
  453. foreach($tcall as $v){
  454. $dtctitle[$v['id']] = $v['title'];
  455. }
  456. $dtc = [];
  457. foreach ($tcall as $v) {
  458. if (stripos($v['spare'], '|') !== false) //如果有多个值
  459. {
  460. $v['spare'] = explode('|', $v['spare']);
  461. foreach ($v['spare'] as $k => $vs) {
  462. if (stripos($v['zh'], '|') !== false) {
  463. $vzh = explode('|', $v['zh']);
  464. $dtc[strtolower($vs)] = array('classid' => $v['classid'], 'zh' => $vzh[$k], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $vs);
  465. } else {
  466. $dtc[strtolower($vs)] = array('classid' => $v['classid'], 'zh' => $v['zh'], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $vs);
  467. }
  468. }
  469. } else {
  470. $dtc[strtolower($v['spare'])] = array('classid' => $v['classid'], 'zh' => $v['zh'], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $v['spare']);
  471. }
  472. }
  473. $tmp_sku ="RTG-A033-STW-13*4BobWig-250%-10";
  474. $u9_info = $this->logic_order->skuTransferFeatures($tmp_sku,$typeclass,$dtc,$dtctitle,$classid);
  475. echo "<pre>";
  476. var_dump($tmp_sku);
  477. var_dump($u9_info);
  478. die;
  479. }
  480. public function _print(){
  481. $this->_Template('aaadayin',$this->data);
  482. }
  483. public function _doWcCp(){
  484. $info = $this->zzhjobs->find("status = 0");
  485. $this->zzhjobs->save(['status'=>30],$info['id']);
  486. echo "<pre>";
  487. $info['payload'] = json_decode($info['payload'],true);
  488. //print_r($info);
  489. var_dump($info['payload']);
  490. $lb = $this->systemtransfer->read($info['payload']['fid']);
  491. $nu = $this->fullorder->get_number($lb['number']);
  492. if(!$nu)
  493. {
  494. $nu = $this->fullordersmt->get_number($lb['number']);
  495. if(!$nu)
  496. {
  497. $nu = $this->fullordertt->get_number($lb['number']);
  498. }
  499. }
  500. if(empty($nu)){
  501. echo "数据不存在";
  502. die;
  503. }
  504. $s = $this->shop->read($nu['shop']);
  505. $lb['kh'] = $s['yyid'];
  506. $lb['ts'] = 1;
  507. // var_dump($lb);
  508. $rk = $this->apiyy->_newrk($lb);
  509. var_dump($rk);
  510. // $list = $this->zzerrlog->find_all("content like '%检测货物流转打印情况13|2%' and time >= 1745881418 and time <= 1745967818 ");
  511. // echo "<pre>";
  512. // print_r(count($list));
  513. // foreach($list as $k=>$v){
  514. // $tmp_arr = explode("|",$v['content']);
  515. // $params = [
  516. // "transfer"=>13,
  517. // "type"=>2,
  518. // "number"=>$tmp_arr[2],
  519. // 'fid'=>$tmp_arr[3]
  520. // ];
  521. // $this->zzhjobs->insert(
  522. // [
  523. // 'status'=>0,
  524. // 'quque'=>'xgwsu9',
  525. // 'payload'=>json_encode($params),
  526. // 'do_interval'=>1,
  527. // 'create_time'=>time(),
  528. // ]
  529. // );
  530. // }
  531. }
  532. public function _th($arg_array){
  533. die;
  534. if(empty($arg_array)){
  535. die(1);
  536. }
  537. $order_no = $arg_array[0];
  538. var_dump($order_no);
  539. $data = $this->fullorder->get_number($order_no);
  540. if(empty($data)){
  541. echo 2;
  542. exit(2);
  543. }
  544. $r = $this->usps->get_return($data);
  545. echo "<pre>";
  546. print_r($r);
  547. }
  548. //物流轨迹
  549. public function _logistic(){
  550. echo "<pre>";
  551. $fs = $this->cne->get_logistics_yskx([
  552. [
  553. "TrackNumber"=>"880739284316",
  554. ]
  555. ]);
  556. print_r($fs);
  557. //$fs = $this->usps->get_logistics($v);
  558. die;
  559. }
  560. public function _getorder(){
  561. $name = 'Alipearl';
  562. $userKey = array(
  563. 'Alipearl' => array('username'=>'huchunmei','api_key'=>'huchunmei126_alipearl_erp888','url'=>'https://www.alipearlhair.com'),
  564. 'Asteria' => array('username'=>'huchunmei','api_key'=>'huchunmei126_asteria_erp888','url'=>'https://www.asteriahair.com'),
  565. 'WestKiss' => array('username'=>'huchunmei','api_key'=>'huchunmei126_westkiss_erp868','url'=>'https://www.westkiss.com'),
  566. 'SuperNova' => array('username'=>'huchunmei','api_key'=>'huchunmei126_supernova_erp6898','url'=>'https://www.supernovahair.com'),
  567. 'Wiggins' => array('username'=>'huchunmei','api_key'=>'huchunmei126_wiggins_erp652','url'=>'https://www.wigginshair.com'),
  568. 'Yolissa' => array('username'=>'huchunmei','api_key'=>'huchunmei126_yolissa_688','url'=>'https://www.yolissahair.com'),
  569. );
  570. $proxy = new SoapClient($userKey[$name]['url'].'/api/soap/?wsdl');
  571. try {
  572. $sessionId = $proxy->login($userKey[$name]['username'], $userKey[$name]['api_key']);
  573. }
  574. catch (Exception $e) {
  575. echo $e->getMessage();
  576. }
  577. $data = array('proxy'=>$proxy,'sessionId'=>$sessionId,'url'=>$userKey[$name]['url']);
  578. $fromTime = date('Y-m-d H:i:s',time()- 3600*24*6);
  579. $toTime = date('Y-m-d H:i:s',time());
  580. $filters = array(array('created_at'=>array('from'=>$fromTime,'to'=>$toTime)));
  581. $result = $data['proxy']->call($data['sessionId'],'sales_order.list',$filters);
  582. echo "<pre>";
  583. // print_r($result[0]);
  584. foreach($result as $item)
  585. {
  586. // print_r($item);exit;
  587. $iteminfo= $data['proxy']->call($data['sessionId'], 'sales_order.info', $item['increment_id']);
  588. print_r($iteminfo['items']);
  589. }
  590. }
  591. public function getDtc(){
  592. $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');
  593. $dtc = array();
  594. foreach ($dictionaries as $v)
  595. {
  596. if(stripos($v['spare'],'|') !== false)//如果有多个值
  597. {
  598. $v['spare'] = explode('|',$v['spare']);
  599. foreach ($v['spare'] as $k=>$vs)
  600. {
  601. if(stripos($v['zh'],'|') !== false)
  602. {
  603. $vzh = explode('|',$v['zh']);
  604. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  605. }
  606. else
  607. {
  608. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  609. }
  610. }
  611. }
  612. else
  613. {
  614. $dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
  615. }
  616. }
  617. $dtctitle = [];
  618. $dictionaries2 = $this->typeclass->find_all();
  619. foreach ($dictionaries2 as $v)
  620. {
  621. $dtctitle[$v['id']] = $v['title'];
  622. }
  623. return [
  624. 'dtc'=>$dtc,
  625. 'dtctitle'=>$dtctitle
  626. ];
  627. }
  628. public function _a(){
  629. $list = [
  630. [
  631. 'sku2'=>'-1297-80-2602-1306-57-101-1283-',
  632. ]
  633. ];
  634. $r = $this->logic_u9tools->getU9bm($list,'sku2');
  635. echo "<pre>";
  636. var_dump($r);
  637. die;
  638. $data = $this->getDtc();
  639. $dtc = $data['dtc'];
  640. $dtctitle = $data['dtctitle'];
  641. //die;
  642. $quantity = '1';
  643. //$issku = 'NW-Ponytail-10-Accs-175g';
  644. $issku = "Accs-STW-Topper-6*7-8";
  645. $money = array();
  646. $productdescribe = $this->productdescribe->find_all('1=1');
  647. foreach ($productdescribe as $v)
  648. {
  649. $money[$v['number']] = array();
  650. }
  651. /* 价格加入 */
  652. /* 匹配ID加入 */
  653. $int = array();
  654. $intdata = $this->typeclass->find_all('classid=14','id,spare');
  655. foreach ($intdata as $v)
  656. {
  657. $v['spare'] = explode('|',$v['spare']);
  658. $int[$v['id']] = $v['spare'][0];
  659. }
  660. // var_dump($dtc);
  661. // var_dump($dtctitle);
  662. $r = $this->api->matching($quantity,$issku,$dtc,$money,$int,$dtctitle,[1],[
  663. ]);
  664. echo "<pre>";
  665. var_dump($r);
  666. die;
  667. $time = time();
  668. $jiami = "alipearlhair+".(string)$time;
  669. echo json_encode([
  670. 'shop'=>3,
  671. 'waybill'=>'283786008019',
  672. 'time'=>$time,
  673. 'key'=>$this->logic_tools->toolsjiami($jiami,"6amg!pnfrlbpnjgirv", "6ook4k!2w94m6jtm"),
  674. ]);
  675. die;
  676. $dtc = array();
  677. /* 订单号加入键值-j */
  678. /* 匹配加入 */
  679. $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');
  680. // 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)
  681. foreach ($dictionaries as $v)
  682. {
  683. if(stripos($v['spare'],'|') !== false)//如果有多个值
  684. {
  685. $v['spare'] = explode('|',$v['spare']);
  686. foreach ($v['spare'] as $k=>$vs)
  687. {
  688. if(stripos($v['zh'],'|') !== false)
  689. {
  690. $vzh = explode('|',$v['zh']);
  691. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  692. }
  693. else
  694. {
  695. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  696. }
  697. }
  698. }
  699. else
  700. {
  701. $dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
  702. }
  703. }
  704. $dtctitle = [];
  705. $dictionaries2 = $this->typeclass->find_all();
  706. foreach ($dictionaries2 as $v)
  707. {
  708. $dtctitle[$v['id']] = $v['title'];
  709. }
  710. echo "<pre>";
  711. $sku = "Free,Gift--PackQQS,NW--3+Ori6*6C-22 24 26-20-6*6C";
  712. $sl = "1;1;1;";
  713. $r = $this->api->matching($sl,$sku,$dtc,"","",$dtctitle,$shop=[],$extra = [
  714. "price"=>"565.7700",
  715. "row_total"=>"565.7700"
  716. ]);
  717. var_dump($r['title']);
  718. $r = $r['product'];
  719. $rr = explode(";",$r);
  720. print_r($rr);
  721. }
  722. public function _fout()
  723. {
  724. $waybill = $this->input->get('waybill');
  725. $info = $this->fullorder->get_waybill($waybill);
  726. //$r = $this->usps->get_new_logistics($info);
  727. $r = $this->fedexv1->get_logistics(123);
  728. echo "<pre>";
  729. var_dump($r);
  730. //$this->fedexv1->makeAccessToken();
  731. }
  732. public function _waybillemail()
  733. {
  734. $urls = array();$sl = 0;$time = time();
  735. $wid = 2;
  736. // if(date("H",time()) == '8' && date("i",time()) > '20' && date("i",time()) < '39')//USPS-USA单
  737. // {
  738. // $wid = 1;
  739. // }
  740. // else if(date("H",time()) == '20' && date("i",time()) > '20' && date("i",time()) < '39')//其他快递
  741. // {
  742. // $wid = 2;
  743. // }
  744. // else
  745. // {
  746. // exit;
  747. // }
  748. $notice = $this->notice->find_all("message = '1' and state = '1' and type = '4' and ktime < '$time' and jtime > '$time'");//已有自动发送,这个是物流发送
  749. foreach ($notice as $key=>$var)
  750. {
  751. $this->_waybillfs([
  752. 'var'=>$var,
  753. 'wid'=>$wid
  754. ]);
  755. }
  756. }
  757. public function upadtel(){
  758. $returngoods_id = 150;
  759. $insert_flag = 1217819;
  760. $number = 'KISS-50206-004';
  761. $returngoods_info = $this->returngoods->read($returngoods_id);
  762. $this->returngoods->save([
  763. 'status'=>80,
  764. 'back_no'=>$number,
  765. 'back_id'=>$insert_flag,
  766. 'update_time'=>date('Y-m-d H:i:s'),
  767. ],$returngoods_id);
  768. $this->returnlogs->insert([
  769. 'rg_id'=>(int)$returngoods_id,
  770. 'operat_id'=>10,
  771. 'operat_name'=>'admin',
  772. 'remark'=>"订单号:".$returngoods_info['orderinfo']."重新换货-换货新订单编码".$number,
  773. 'create_time'=>date('Y-m-d H:i:s'),
  774. ]);
  775. }
  776. public function _waybillfs($data)
  777. {
  778. if($data)
  779. {
  780. $notice = $data['var'];
  781. $notice['email'] = $this->emaildata->read($notice['email']);
  782. $wid = $data['wid'];
  783. $fsjs = "";
  784. if($wid == 1 && (stripos($notice['express'],',2,') !== false || stripos($notice['express'],',63,') !== false || stripos($notice['express'],',64,') !== false))
  785. {
  786. $js = explode(',',trim($notice['js'],','));
  787. if(count($js) > 1)
  788. {
  789. $fsjs = " and (";
  790. foreach ($js as $v)
  791. {
  792. $fsjs .= "js = '$v' or ";
  793. }
  794. $fsjs = trim($fsjs,' or ').")" ;
  795. }
  796. else if(count($js) == 1)
  797. {
  798. $fsjs = " and js = '$js[0]'";
  799. }
  800. $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
  801. }
  802. else if($wid == 2 && stripos($notice['express'],',1,') !== false)
  803. {
  804. $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
  805. }
  806. else
  807. {
  808. exit;
  809. }
  810. $this->logic_ding->sendToDing("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
  811. // $wlfs = array();
  812. // $dd = $this->fullorder->find_all("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
  813. // foreach($dd as $v){
  814. // $this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】");
  815. // }
  816. // foreach ($dd as $v)
  817. // {
  818. // $shop = $this->shop->read($v['shop']);
  819. // $express = $this->express->read($v['express']);
  820. // $fs = $this->notice->get_god($v,$shop,$express,$notice);
  821. // $this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】获取快递信息【".json_encode($notice,JSON_UNESCAPED_UNICODE)."】返回的信息".json_encode($fs));
  822. // if($fs == 1)
  823. // {
  824. // $this->fullorder->save(array('dlzemail'=>1,'dlzemailtime'=>time()),$v['id']);
  825. // //给crm发送信息 先存储数据 后续定时任务执行
  826. // if($v['shop'] < 10){
  827. // $this->zztmpdata->insert([
  828. // 'type'=>2,
  829. // 'act_name'=>'crm_order',
  830. // 'content'=>json_encode($v),
  831. // 'create_time'=>time()
  832. // ]);
  833. // }
  834. // }
  835. // else
  836. // {
  837. // //$pdtime = date('Y-m-d',time());
  838. // //$folderPath = './data/dlzemail/'.$pdtime; // 文件夹路径
  839. // //$permissions = 0777; // 权限设置
  840. // //if (!file_exists($folderPath)) { mkdir($folderPath, $permissions); }//创建文件夹
  841. // //file_exists($folderPath);
  842. // if(!is_file("./data/dlzemail/".$v['number'].".txt"))
  843. // {
  844. // $myfile = fopen("./data/dlzemail/".$v['number'].".txt", "w") or die("Unable to open file!");
  845. // fwrite($myfile, json_encode($fs.';'.$v.';'.$shop.';'.$express.';'.$notice));
  846. // fclose($myfile);
  847. // }
  848. // else
  849. // {
  850. // $myfile = fopen("./data/dlzemail/".$v['number'].".txt", "a+") or die("Unable to open file!");
  851. // fwrite($myfile, json_encode($fs.';'.$v.';'.$shop.';'.$express.';'.$notice));
  852. // fclose($myfile);
  853. // }
  854. // $this->fullorder->save(array('dlzemail'=>2,'dlzemailtime'=>time()),$v['id']);
  855. // }
  856. // sleep(50);
  857. // }
  858. }
  859. }
  860. public function ll(){
  861. $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=&
  862. ';
  863. parse_str($str, $output);
  864. return $output;
  865. }
  866. //修改客户分类
  867. public function _mdedit($arg_array)
  868. {
  869. die;
  870. $user = $this->user->read(10);
  871. $post = $this->ll();
  872. if(isset($post['shop']))
  873. {
  874. $fpcount = $post['fpcount'];
  875. if(!$fpcount)
  876. {
  877. echo json_encode(array('msg'=>'需要先清理浏览器缓存,刷新当前页面后再试!','success'=>false));exit;
  878. }
  879. $customerid = $post['customerid'];
  880. $shop = $post['shop'];
  881. $sp = $this->shop->read($shop);
  882. $num = $this->fullorder->find_count('shop = "'.$sp['id'].'" and gtime = "'.date('Ymd',time()).'"');
  883. $post['source'] = 1;//订单类型:1.线下订单2.PC3.手机
  884. $post['state'] = 207;//订单状态:207等待发货
  885. $post['review'] = 2;//审核状态:1.未送审2.待审核3.不通过4取消重审5.审核通过6.自动通过
  886. $post['print'] = 1;//打印状态:1.不可打印2.未打印3.已打印
  887. $post['library'] = 1;//出库状态:1.未出库2.已出库3.已退库
  888. $post['libraryconfirm'] = 1;//出库确认:1.不允许2.允许
  889. $post['link'] = $sp['link'];
  890. $post['issku'] = $sp['sku'];
  891. if($post['print'] != 3)
  892. {
  893. $post['librarynot'] = "订单未打印,未审核或未通过";//不能出库原因
  894. }
  895. $orderinfo = $post['orderinfo'];
  896. $post['shop'] = $sp['id'];
  897. $post['user'] = $sp['shopuser'];
  898. $post['number'] = $sp['shortname'].'-'.substr(date('ymd',time()),1).'-'.(substr(strval($num+1+1000),1,3));//编号
  899. if($orderinfo != "")
  900. {
  901. $ordefin = $this->fullorder->get_orderinfo($orderinfo);
  902. if($ordefin)
  903. {
  904. echo json_encode(array('msg'=>'订单号重复!','success'=>false));exit;
  905. }
  906. else
  907. {
  908. $post['orderinfo'] = $orderinfo;
  909. }
  910. }
  911. else
  912. {
  913. $post['orderinfo'] = $sp['id'].date('ymdHis',time()).rand(0,1);//订单号
  914. }
  915. if($post['paypal'] != '')
  916. {
  917. $pp = $this->fullorder->get_paypal($post['paypal']);
  918. if($pp)
  919. {
  920. echo json_encode(array('msg'=>'此交易号的订单已存在!','success'=>false));exit;
  921. }
  922. }
  923. $post['client'] = $post['client'];//客户名称
  924. $btime = $post['buytime'];//付款时间
  925. $post['buytime'] = strtotime($btime);//时间转UX
  926. $post['dtime'] = time();//订单时间
  927. $post['gtime'] = date('Ymd',time());//格式化时间
  928. $post['pay'] = $post['pay'];//支付方式
  929. $post['capital'] = $post['capital'];//资金状态
  930. $post['type'] = $post['warehouse'];//发货仓库
  931. $post['currency'] = $post['currency'];//币种
  932. $currency = $this->typeclass->read($post['currency']);
  933. $post['currencytitle'] = $currency['title'];//币种名称
  934. $post['freight'] = $post['freight'];//运费
  935. $post['expressmoney'] = $post['expressmoney'];//物流金额
  936. $post['shouldmoney'] = $post['shouldmoney'];//应收金额
  937. $post['skje'] = $post['shouldmoney'];//收款金额
  938. $product = $post['product'];//产品名称
  939. $product = str_replace(array('%26','%2B'),array('&','+'),$product);
  940. $post['product'] = preg_replace('/( | | |\s)/',' ',$product);
  941. $orderremarks = $post['orderremarks'];//订单备注
  942. $orderremarks = str_replace(array('%26','%2B'),array('&','+'),$orderremarks);
  943. $post['orderremarks'] = preg_replace('/( | | |\s)/',' ',$orderremarks);
  944. $shipremarks = $post['shipremarks'];//仓库品名
  945. $shipremarks = str_replace(array('%26','%2B'),array('&','+'),$shipremarks);//仓库品名
  946. $post['shipremarks'] = preg_replace('/( | | |\s)/',' ',$shipremarks);
  947. $post['email'] = $post['email'];//邮箱
  948. $name = $post['name'];//名称
  949. $post['name'] = preg_replace('/( | | |\s)/',' ',$name);
  950. $post['phone'] = $post['phone'];//电话
  951. $post['phone'] = preg_replace('/\D/s','',$post['phone']);
  952. $post['country'] = $post['country'];//国家
  953. $ct = $this->country->read($post['country']);//国家
  954. $post['al'] = $ct['lb'];//国家二字码
  955. $post['province'] = $post['province'];//省、州
  956. $post['province'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['province']); //替换开头空字符
  957. $post['province'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['province']); //替换结尾空字符
  958. $post['city'] = $post['city'];//城市
  959. $post['city'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['city']); //替换开头空字符
  960. $post['city'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['city']); //替换结尾空字符
  961. $post['zipcode'] = $post['zipcode'];//邮编
  962. $post['zipcode'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['zipcode']); //替换开头空字符
  963. $post['zipcode'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['zipcode']); //替换结尾空字符
  964. $post['address'] = $post['address'];//地址
  965. $post['printtype'] = $post['printtype'];//打印类型
  966. $fpdata = $post['fpdata'];//购买产品内容
  967. $fpdata = str_replace(array('%26','%2B'),array('&','+'),$fpdata);
  968. $post['fpdata'] = $fpdata;
  969. $post['sbpm'] = $post['sbpm'];//申报品名
  970. $post['zwpm'] = $post['zwpm'];//中文品名
  971. $post['ts'] = $post['ts'];//条数
  972. $post['dtsbjz'] = $post['dtsbjz'];//单条申报价
  973. $post['zsbjz'] = $post['zsbjz'];//总申报价
  974. $post['zzl'] = $post['zzl'];//总重量
  975. $post['zjs'] = $post['zjs'];//总件数
  976. $post['express'] = $post['express'];//快递公司
  977. $post['printtype'] = $post['printtype'];//打印类型
  978. $post['quantity'] = $post['quantity'];//数量
  979. $post['paypal'] = $post['paypal'];//支付号
  980. $post['guarantee'] = $post['guarantee'];//卖家保障
  981. $post['msg'] = $post['msg'];//发送留言类型
  982. $post['ioss'] = $post['ioss'];
  983. $post['sbpm'] = $post['sbpm'];
  984. $pay = $this->pay->get_typeclass($post['pay']);
  985. $yga = $post['shouldmoney'];
  986. $post['budget'] = 0;
  987. if($pay)
  988. {
  989. $ygc = $pay['estimaterate'];//预估到账公式
  990. $ifbudget = eval("return $yga*1.$ygc;");
  991. $post['estimaterate'] = $pay['estimaterate'];
  992. if($ifbudget > 0)
  993. {
  994. $post['budget'] = eval("return $yga*1.$ygc;");//预估到帐金额
  995. }
  996. }
  997. else
  998. {
  999. $ygb = $sp['estimaterate'];//店铺默认到账公式
  1000. $ifbudget = eval("return $yga*1.$ygb;");
  1001. $post['estimaterate'] = $sp['estimaterate'];
  1002. if($ifbudget > 0)
  1003. {
  1004. $post['budget'] = eval("return $yga*1.$ygb;");//预估到帐金额
  1005. }
  1006. }
  1007. $baddress = $post['baddress'];
  1008. $saddress = $post['saddress'];
  1009. $baddress = array_reverse(explode(',',$baddress));
  1010. $saddress = array_reverse(explode(',',$saddress));
  1011. $bar = '';$sar = '';
  1012. $cr = $this->country->read($post['country']);
  1013. $baddress[1] = $cr['lb'];
  1014. $saddress[1] = $cr['lb'];
  1015. $baddress = array_reverse($baddress);
  1016. $saddress = array_reverse($saddress);
  1017. for($i=0;$i<count($baddress);$i++)
  1018. {
  1019. $bar .= $baddress[$i].',';
  1020. }
  1021. for($i=0;$i<count($saddress);$i++)
  1022. {
  1023. $sar .= $saddress[$i].',';
  1024. }
  1025. $post['baddress'] = rtrim($bar,',');//卖家保障
  1026. $post['saddress'] = rtrim($sar,',');//卖家保障
  1027. $whlabel = $post['whlabel'];
  1028. if($post['express'] == 2 && (stripos($post['name'],'&') !== false || stripos($post['name'],"'") !== false))
  1029. {
  1030. echo json_encode(array('msg'=>'USPS收件人或公司名不可用特殊符号!','success'=>false));exit;
  1031. }
  1032. if(strlen($post['client']) > 35 || strlen($post['name']) > 35)//收件人姓名或公司名不允许超过35位
  1033. {
  1034. echo json_encode(array('msg'=>'收件人姓名或公司名不可超过35个字符!','success'=>false));exit;
  1035. }
  1036. if(($post['express'] == '5' || $post['express'] == '24' || $post['express'] == '42' || $post['express'] == '31') && $post['country'] != 192)
  1037. {
  1038. echo json_encode(array('msg'=>'非美国无法选择Fedex、DHL官方-美国!','success'=>false));exit;
  1039. }
  1040. if($post['express'] == '3' && $post['country'] != 192 && $post['country'] != 35)
  1041. {
  1042. echo json_encode(array('msg'=>'非美国和加拿大无法选择UPS!','success'=>false));exit;
  1043. }
  1044. if($post['express'] == '3' && $post['country'] == 35 && $post['zsbjz'] > 20)
  1045. {
  1046. echo json_encode(array('msg'=>'UPS加拿大最高申报不可超过20','success'=>false));exit;
  1047. }
  1048. if($post['express'] == '2' && $post['warehouse'] != 5)
  1049. {
  1050. echo json_encode(array('msg'=>'非美国仓无法选择USPS!','success'=>false));exit;
  1051. }
  1052. if($post['express'] == '99' && $post['bx'] > 0)
  1053. {
  1054. echo json_encode(array('msg'=>'此物流不允许购买保险','success'=>false));exit;
  1055. }
  1056. if($post['express'] == 42 && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 ||
  1057. {
  1058. echo json_encode(array('msg'=>'此快递方式必须选择Human Hair Wigs/Human Hair Goods!','success'=>false));exit;
  1059. }
  1060. if($post['express'] == 24 && $post['sbpm'] != 'Hair Sample' && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 ||
  1061. {
  1062. echo json_encode(array('msg'=>'此快递方式必须选择Hair Sample/Human Hair Wigs/Human Hair Goods!','success'=>false));exit;
  1063. }
  1064. if($post['country'] != 192 && $post['express'] == 1 && $post['sbpm'] != 'Synthetic Hair Wigs' && $post['sbpm'] != 'Synthetic Hair Goods')//$post['express'] == 3 ||
  1065. {
  1066. echo json_encode(array('msg'=>'非美国选择官方DHL必须选择Synthetic Hair Wigs/Synthetic Hair Goods','success'=>false));exit;
  1067. }
  1068. if($post['pay'] == '22' && ($post['paypal'] == '' || $post['guarantee'] == ''))
  1069. {
  1070. echo json_encode(array('msg'=>'交易号和卖家保障必须填写','success'=>false));exit;
  1071. }
  1072. if($post['pay'] == '23' && $post['paypal'] == '')
  1073. {
  1074. echo json_encode(array('msg'=>'交易号必须填写','success'=>false));exit;
  1075. }
  1076. $express = $this->express->read($post['express']);
  1077. if($post['zsbjz'] > $express['sbjz'])
  1078. {
  1079. echo json_encode(array('msg'=>'总申报价值不可超出'.$express['sbjz'],'success'=>false));exit;
  1080. }
  1081. if($post['shouldmoney'] > $express['shouldmoney'] && $express['shouldmoney'] != 0)
  1082. {
  1083. echo json_encode(array('msg'=>'订单金额不可超出'.$express['shouldmoney'],'success'=>false));exit;
  1084. }
  1085. if($express['ioss'] == 1 && $post['ioss'] == '')
  1086. {
  1087. echo json_encode(array('msg'=>'此快递方式必须选择IOSS!','success'=>false));exit;
  1088. }
  1089. if(strlen($post['address']) > $express['addresssize'] || strlen($post['address2']) > $express['addresssize'])
  1090. {
  1091. echo json_encode(array('msg'=>'此快递方地址不可超出'.$express['addresssize'].'个字符','success'=>false));exit;
  1092. }
  1093. if(strlen($post['address']) < 5)
  1094. {
  1095. echo json_encode(array('msg'=>'地址不可留空!','success'=>false));exit;
  1096. }
  1097. if($post['express'] == '2' && $post['zzl'] > '16' && $post['js'] == '0')
  1098. {
  1099. echo json_encode(array('msg'=>'重量大于16不可按Ground Advantage提交!','success'=>false));exit;
  1100. }
  1101. if($post['express'] == '2' && isset($post['js']) && $post['js'] == '0'&& $post['qm'] == '1')
  1102. {
  1103. echo json_encode(array('msg'=>'Ground Advantage不可使用签名服务!','success'=>false));exit;
  1104. }
  1105. if(($post['express'] == '3' || $post['express'] == '42' || $post['express'] == '24') && $post['shouldmoney'] < 1)
  1106. {
  1107. echo json_encode(array('msg'=>'零金额订单不可发 UPS/DHL官方-美国/Fedex(杭州)','success'=>false));exit;
  1108. }
  1109. if($post['express'] == '42' && $post['zsbjz'] < 1)
  1110. {
  1111. echo json_encode(array('msg'=>'零申报金额不可发 DHL官方-美国','success'=>false));exit;
  1112. }
  1113. if($post['express'] == '6' && $post['province'] == '')
  1114. {
  1115. echo json_encode(array('msg'=>'选择DPEX必须填写州信息','success'=>false));exit;
  1116. }
  1117. $dtctitle = array();
  1118. $dictionaries = $this->typeclass->find_all();
  1119. foreach ($dictionaries as $v)
  1120. {
  1121. $dtctitle[$v['id']] = array($v['title'],$v['bqsku']);
  1122. }
  1123. $fpdata = $post['fpdata'];
  1124. if(stripos($fpdata,'-128-') !== false || stripos($fpdata,'-127-') !== false)
  1125. {
  1126. $dfp = explode(';',trim($fpdata,';'));
  1127. $fdata = '';
  1128. foreach ($dfp as $k=>$v)
  1129. {
  1130. $ptitleb = '';
  1131. $fp = explode('|',trim($v,'|'));
  1132. $fp0 = explode(',',$fp[0]);
  1133. if(isset($fp0[1]))
  1134. {
  1135. $fp1 = explode('-',trim($fp0[1],'-'));
  1136. }
  1137. else
  1138. {
  1139. $fp1 = explode('-',trim($fp[0],'-'));
  1140. }
  1141. foreach ($fp1 as $vv)
  1142. {
  1143. $ptitleb .= isset($dtctitle[$vv])?$dtctitle[$vv][0].' ':'';
  1144. }
  1145. if(isset($fp0[1]))
  1146. {
  1147. $ptitleb .= $dtctitle[$fp0[0]][1].'inch ';
  1148. $fp[1] = $ptitleb;
  1149. }
  1150. $fdata .= implode("|",$fp).";";
  1151. }
  1152. $fpdata = $fdata;
  1153. }
  1154. $warehouse = $this->warehouse->read($post['type']);
  1155. if($warehouse['bdcountry'] != 0 && $post['country'] != $warehouse['bdcountry'])
  1156. {
  1157. echo json_encode(array('msg'=>'当前国家无法选择'.$warehouse['title'].'!','success'=>false));exit;
  1158. }
  1159. // $kcyz = $this->ck->get_kc($post['state'],$warehouse,$post['shop'],$post['number'],$whlabel,$fpdata);
  1160. // if($kcyz['t'] > '0')
  1161. // {
  1162. // echo $kcyz['m'];exit;
  1163. // }
  1164. // else if($kcyz['fpdata'] != '')
  1165. // {
  1166. // $post['whlabel'] = $kcyz['whlabel'];
  1167. // $post['fpdata'] = $kcyz['fpdata'];
  1168. // }
  1169. // $fl = $this->ck->get_fl($warehouse['hz'],$whlabel,$fpdata);
  1170. // $post['sfxh'] = $fl['sfxh'];
  1171. // $post['ckfl'] = $fl['ckfl'];
  1172. //查询净重开始
  1173. $post['jweight'] = $this->weight->get_weightcx($post['fpdata']);
  1174. //查询净重结束
  1175. $cusnum = $this->customer->read($customerid);
  1176. // $this->customer->save(array('num'=>$cusnum['num']+1,'time'=>$post['buytime']),$customerid);
  1177. // $this->fullorder->insert($post);
  1178. echo json_encode(array('msg'=>'下单成功','success'=>true));exit;
  1179. }
  1180. echo "1";
  1181. die;
  1182. }
  1183. public function cc(){
  1184. $filename = date("Y-m-d") . "产品入库导出.xls";
  1185. $str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
  1186. <head>
  1187. <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
  1188. <!--[if gte mso 9]>
  1189. <xml>
  1190. <x:ExcelWorkbook>
  1191. <x:ExcelWorksheets>
  1192. <x:ExcelWorksheet>
  1193. <x:Name>产品入库</x:Name>
  1194. <x:WorksheetOptions>
  1195. <x:Print>
  1196. <x:ValidPrinterInfo />
  1197. </x:Print>
  1198. </x:WorksheetOptions>
  1199. </x:ExcelWorksheet>
  1200. </x:ExcelWorksheets>
  1201. </x:ExcelWorkbook>
  1202. </xml>
  1203. <![endif]-->
  1204. <style>
  1205. tr { mso-height-source: auto; }
  1206. .fixed-height {
  1207. height: 100px; /* 设置固定行高 */
  1208. mso-height-source: userset; /* 强制Excel使用设定高度 */
  1209. }
  1210. </style>
  1211. </head>
  1212. <body>";
  1213. $str .= "<table border='1' cellspacing='0' style='border-collapse: collapse; font-family: Microsoft Yahei; font-size: 13px;'>";
  1214. $str .= "<tr >"; // 应用固定高度类
  1215. $str .= "<td>产品ID</td>";
  1216. $str .= "<td>图片1</td>";
  1217. $str .= "</tr>";
  1218. $str .= "<tr class='fixed-height'>"; // 应用固定高度类
  1219. $str .= "<td>ceshi12321312312312312312312312312312312</td>";
  1220. $str .= '<td >
  1221. <table border="0">
  1222. <tr class="fixed-height" >
  1223. <td ><img class="excel-image" width="70" height="auto" src="http://1.wepolicy.cn/data/img/20250703/20250703_085106_9716.png"></td>
  1224. <td ><img class="excel-image" width="70" height="auto" src="http://1.wepolicy.cn/data/img/20250703/20250703_085106_9716.png"></td>
  1225. </tr>
  1226. </table>
  1227. </td>';
  1228. // $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>';
  1229. $str .= "</tr>";
  1230. $str .= "</table></body></html>";
  1231. header("Content-Type: application/vnd.ms-excel; charset=utf-8");
  1232. header("Content-Disposition: attachment; filename=".$filename);
  1233. header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
  1234. header("Pragma: no-cache");
  1235. header("Expires: 0");
  1236. exit($str);
  1237. }
  1238. }