Aatest.php 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899
  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_shop','shop');
  29. $this->load->_model('Model_user','user');
  30. $this->load->_model('Model_whlabel','whlabel');
  31. $this->load->_model('Model_specialstock','specialstock');
  32. $this->load->_model('Model_ck','ck');
  33. $this->load->_model('Model_whlabellabel','whlabellabel');
  34. $this->load->_model('Model_apiyy','apiyy');
  35. $this->load->helper('url');
  36. $this->load->_model('Model_whlabel_fc','whlabel_fc');
  37. $this->load->_model('Model_systemtransfer','systemtransfer');
  38. $this->load->_model('Model_classid','classid');
  39. $this->load->_model('Model_allocation','allocation');
  40. $this->load->_model('Model_fullorderxw','fullorderxw');
  41. $this->load->_model('Model_fullorderpaypal','fullorderpaypal');
  42. $this->load->_model('Model_fedexv1','fedexv1');
  43. $this->load->_model('Model_logic_crm','logic_crm');
  44. $this->load->_model("Model_fullorder","fullorder");
  45. $this->load->_model("Model_express","express");
  46. $this->load->_model("Model_logic_ding","logic_ding");
  47. $this->load->_model("Model_api",'api');
  48. $this->load->_model("Model_usps",'usps');
  49. $this->load->_model('Model_emaildata','emaildata');
  50. $this->load->_model('Model_logic_tools','logic_tools');
  51. $this->load->_model('Model_logic_order','logic_order');
  52. $this->load->_model('Model_returngoods','returngoods');
  53. $this->load->_model('Model_returnlogs','returnlogs');
  54. $this->load->_model('Model_productdescribe','productdescribe');
  55. $this->load->_model('Model_logic_u9tools','logic_u9tools');
  56. $this->load->_model('Model_17track','17track');
  57. $this->load->_model('Model_customer','customer');
  58. $this->load->_model('Model_express','express');
  59. $this->load->_model('Model_weight','weight');
  60. $this->load->_model('Model_cne','cne');
  61. $this->load->_model("Model_zzjobs","zzjobs");
  62. $this->load->_model("Model_zzerrlog","zzerrlog");
  63. $this->load->_model("Model_zzhjobs","zzhjobs");
  64. $this->load->_model('Model_apiyy','apiyy');
  65. $this->load->_model('Model_systemtransfer','systemtransfer');
  66. }
  67. //定义方法的调用规则 获取URI第二段值
  68. public function _remap($arg,$arg_array)
  69. {
  70. // $this->zzjobs->insert([
  71. // 'status'=>0,
  72. // 'quque'=>'ysgjcx',//云尚轨迹查询
  73. // 'payload'=>json_encode([
  74. // 'v'=>$v,
  75. // 'id'=>$var['id']
  76. // ],JSON_UNESCAPED_UNICODE),
  77. // 'do_interval'=>1,
  78. // 'create_time'=>time()
  79. // ]);
  80. // if($arg == 'fout')
  81. // {
  82. // //$this->_fout();
  83. // }else if($arg == 'waybillemail'){
  84. // //$this->_waybillemail();
  85. // }else if($arg == 'getorder'){
  86. // //$this->_getorder();
  87. // }elseif($arg == 'logistic'){
  88. // $this->_logistic($arg_array);
  89. // }elseif($arg == 'th'){
  90. // // $this->_th($arg_array);
  91. // }else{
  92. $this->_logistic();
  93. // //$this->_mdedit($arg_array);
  94. // }
  95. //$this->_print();
  96. }
  97. public function _print(){
  98. $this->_Template('aaadayin',$this->data);
  99. }
  100. public function _doWcCp(){
  101. $info = $this->zzhjobs->find("status = 0");
  102. $this->zzhjobs->save(['status'=>30],$info['id']);
  103. echo "<pre>";
  104. $info['payload'] = json_decode($info['payload'],true);
  105. //print_r($info);
  106. var_dump($info['payload']);
  107. $lb = $this->systemtransfer->read($info['payload']['fid']);
  108. $nu = $this->fullorder->get_number($lb['number']);
  109. if(!$nu)
  110. {
  111. $nu = $this->fullordersmt->get_number($lb['number']);
  112. if(!$nu)
  113. {
  114. $nu = $this->fullordertt->get_number($lb['number']);
  115. }
  116. }
  117. if(empty($nu)){
  118. echo "数据不存在";
  119. die;
  120. }
  121. $s = $this->shop->read($nu['shop']);
  122. $lb['kh'] = $s['yyid'];
  123. $lb['ts'] = 1;
  124. // var_dump($lb);
  125. $rk = $this->apiyy->_newrk($lb);
  126. var_dump($rk);
  127. // $list = $this->zzerrlog->find_all("content like '%检测货物流转打印情况13|2%' and time >= 1745881418 and time <= 1745967818 ");
  128. // echo "<pre>";
  129. // print_r(count($list));
  130. // foreach($list as $k=>$v){
  131. // $tmp_arr = explode("|",$v['content']);
  132. // $params = [
  133. // "transfer"=>13,
  134. // "type"=>2,
  135. // "number"=>$tmp_arr[2],
  136. // 'fid'=>$tmp_arr[3]
  137. // ];
  138. // $this->zzhjobs->insert(
  139. // [
  140. // 'status'=>0,
  141. // 'quque'=>'xgwsu9',
  142. // 'payload'=>json_encode($params),
  143. // 'do_interval'=>1,
  144. // 'create_time'=>time(),
  145. // ]
  146. // );
  147. // }
  148. }
  149. public function _th($arg_array){
  150. die;
  151. if(empty($arg_array)){
  152. die(1);
  153. }
  154. $order_no = $arg_array[0];
  155. var_dump($order_no);
  156. $data = $this->fullorder->get_number($order_no);
  157. if(empty($data)){
  158. echo 2;
  159. exit(2);
  160. }
  161. $r = $this->usps->get_return($data);
  162. echo "<pre>";
  163. print_r($r);
  164. }
  165. //物流轨迹
  166. public function _logistic(){
  167. echo "<pre>";
  168. if(empty($arg_array)){
  169. die(1);
  170. }
  171. $order_no = $arg_array[0];
  172. var_dump($order_no);
  173. // $list = $this->fullorder->find_all("waybill = 284280923614");
  174. // var_dump($list);
  175. // die;
  176. // $v = $list[0];
  177. // $v = [
  178. // 'waybill'=>'285250961332'
  179. // ];
  180. // $fs = $this->fedexv1->get_logistics($v);
  181. // var_dump($fs);
  182. // die;
  183. $fs = $this->cne->get_logistics_yskx([
  184. [
  185. "TrackNumber"=>'880645671607'
  186. ]
  187. ]);
  188. //@$fs = $this->usps->get_logistics_new($v);
  189. // $csck[] = array($v['number'],$fs['f'],$fs['content']);
  190. // if(!isset($fs['f']))
  191. // {
  192. // $fs = $this->usps->get_logistics($v);
  193. // }
  194. $fs = $this->cne->get_logistics_yskx([
  195. [
  196. "TrackNumber"=>"880739284316",
  197. ]
  198. ]);
  199. print_r($fs);
  200. //$fs = $this->usps->get_logistics($v);
  201. die;
  202. }
  203. public function _getorder(){
  204. $name = 'SuperNova';
  205. $userKey = array(
  206. 'Alipearl' => array('username'=>'huchunmei','api_key'=>'huchunmei126_alipearl_erp888','url'=>'https://www.alipearlhair.com'),
  207. 'Asteria' => array('username'=>'huchunmei','api_key'=>'huchunmei126_asteria_erp888','url'=>'https://www.asteriahair.com'),
  208. 'WestKiss' => array('username'=>'huchunmei','api_key'=>'huchunmei126_westkiss_erp868','url'=>'https://www.westkiss.com'),
  209. 'SuperNova' => array('username'=>'huchunmei','api_key'=>'huchunmei126_supernova_erp6898','url'=>'https://www.supernovahair.com'),
  210. 'Wiggins' => array('username'=>'huchunmei','api_key'=>'huchunmei126_wiggins_erp652','url'=>'https://www.wigginshair.com'),
  211. 'Yolissa' => array('username'=>'huchunmei','api_key'=>'huchunmei126_yolissa_688','url'=>'https://www.yolissahair.com'),
  212. );
  213. $proxy = new SoapClient($userKey[$name]['url'].'/api/soap/?wsdl');
  214. try {
  215. $sessionId = $proxy->login($userKey[$name]['username'], $userKey[$name]['api_key']);
  216. }
  217. catch (Exception $e) {
  218. echo $e->getMessage();
  219. }
  220. $data = array('proxy'=>$proxy,'sessionId'=>$sessionId,'url'=>$userKey[$name]['url']);
  221. $fromTime = date('Y-m-d H:i:s',time()- 3600*24*6);
  222. $toTime = date('Y-m-d H:i:s',time());
  223. $filters = array(array('created_at'=>array('from'=>$fromTime,'to'=>$toTime)));
  224. $result = $data['proxy']->call($data['sessionId'],'sales_order.list',$filters);
  225. echo "<pre>";
  226. // print_r($result[0]);
  227. foreach($result as $item)
  228. {
  229. // print_r($item);exit;
  230. $iteminfo= $data['proxy']->call($data['sessionId'], 'sales_order.info', $item['increment_id']);
  231. print_r($iteminfo['items']);
  232. die;
  233. }
  234. }
  235. public function getDtc(){
  236. $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');
  237. $dtc = array();
  238. foreach ($dictionaries as $v)
  239. {
  240. if(stripos($v['spare'],'|') !== false)//如果有多个值
  241. {
  242. $v['spare'] = explode('|',$v['spare']);
  243. foreach ($v['spare'] as $k=>$vs)
  244. {
  245. if(stripos($v['zh'],'|') !== false)
  246. {
  247. $vzh = explode('|',$v['zh']);
  248. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  249. }
  250. else
  251. {
  252. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  253. }
  254. }
  255. }
  256. else
  257. {
  258. $dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
  259. }
  260. }
  261. $dtctitle = [];
  262. $dictionaries2 = $this->typeclass->find_all();
  263. foreach ($dictionaries2 as $v)
  264. {
  265. $dtctitle[$v['id']] = $v['title'];
  266. }
  267. return [
  268. 'dtc'=>$dtc,
  269. 'dtctitle'=>$dtctitle
  270. ];
  271. }
  272. public function _a(){
  273. echo "<pre>";
  274. // $str = "86,-2397-957-101-146-29-72-2071-|A041 #P18/613 Straight 13*4 Frontal Wig Small 180% Ready to Go 16inch |1|0.00|0.00|16|0.00|0.00|255|0;87,-128-80-2323-57-104-146-29-72-2071-|Wigs 9A A032 Natural Black Deep Wave 13*4 Frontal Wig Small 180% Ready to Go 18inch |1|0.00|0.00|18|0.00|0.00|265|0;";
  275. // $r = $this->weight->get_weightcx($str);
  276. // var_dump($r);
  277. // die;
  278. // $list = [
  279. // [
  280. // 'sku2'=>'-128-80-89-57-106-341-30-72-',
  281. // ],
  282. // [
  283. // 'sku2'=>'-128-80-88-57-2248-2096-30-72-2071-1645-',
  284. // ]
  285. // ];
  286. // $r = $this->logic_u9tools->getU9bm($list,'sku2');
  287. // echo "<pre>";
  288. // var_dump($r);
  289. $data = $this->getDtc();
  290. $dtc = $data['dtc'];
  291. $dtctitle = $data['dtctitle'];
  292. //die;
  293. $quantity = '1';
  294. $issku = 'NW-Ponytail-10-Accs-175g';
  295. $money = array();
  296. $productdescribe = $this->productdescribe->find_all('1=1');
  297. foreach ($productdescribe as $v)
  298. {
  299. $money[$v['number']] = array();
  300. }
  301. /* 价格加入 */
  302. /* 匹配ID加入 */
  303. $int = array();
  304. $intdata = $this->typeclass->find_all('classid=14','id,spare');
  305. foreach ($intdata as $v)
  306. {
  307. $v['spare'] = explode('|',$v['spare']);
  308. $int[$v['id']] = $v['spare'][0];
  309. }
  310. // var_dump($dtc);
  311. // var_dump($dtctitle);
  312. $r = $this->api->matching($quantity,$issku,$dtc,$money,$int,$dtctitle,[1],[
  313. ]);
  314. echo "<pre>";
  315. var_dump($r);
  316. die;
  317. $time = time();
  318. $jiami = "alipearlhair+".(string)$time;
  319. echo json_encode([
  320. 'shop'=>3,
  321. 'waybill'=>'283786008019',
  322. 'time'=>$time,
  323. 'key'=>$this->logic_tools->toolsjiami($jiami,"6amg!pnfrlbpnjgirv", "6ook4k!2w94m6jtm"),
  324. ]);
  325. die;
  326. $dtc = array();
  327. /* 订单号加入键值-j */
  328. /* 匹配加入 */
  329. $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');
  330. // 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)
  331. foreach ($dictionaries as $v)
  332. {
  333. if(stripos($v['spare'],'|') !== false)//如果有多个值
  334. {
  335. $v['spare'] = explode('|',$v['spare']);
  336. foreach ($v['spare'] as $k=>$vs)
  337. {
  338. if(stripos($v['zh'],'|') !== false)
  339. {
  340. $vzh = explode('|',$v['zh']);
  341. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  342. }
  343. else
  344. {
  345. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  346. }
  347. }
  348. }
  349. else
  350. {
  351. $dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
  352. }
  353. }
  354. $dtctitle = [];
  355. $dictionaries2 = $this->typeclass->find_all();
  356. foreach ($dictionaries2 as $v)
  357. {
  358. $dtctitle[$v['id']] = $v['title'];
  359. }
  360. echo "<pre>";
  361. $sku = "Free,Gift--PackQQS,NW--3+Ori6*6C-22 24 26-20-6*6C";
  362. $sl = "1;1;1;";
  363. $r = $this->api->matching($sl,$sku,$dtc,"","",$dtctitle,$shop=[],$extra = [
  364. "price"=>"565.7700",
  365. "row_total"=>"565.7700"
  366. ]);
  367. var_dump($r['title']);
  368. $r = $r['product'];
  369. $rr = explode(";",$r);
  370. print_r($rr);
  371. }
  372. public function _fout()
  373. {
  374. $waybill = $this->input->get('waybill');
  375. $info = $this->fullorder->get_waybill($waybill);
  376. //$r = $this->usps->get_new_logistics($info);
  377. $r = $this->fedexv1->get_logistics(123);
  378. echo "<pre>";
  379. var_dump($r);
  380. //$this->fedexv1->makeAccessToken();
  381. }
  382. public function _waybillemail()
  383. {
  384. $urls = array();$sl = 0;$time = time();
  385. $wid = 2;
  386. // if(date("H",time()) == '8' && date("i",time()) > '20' && date("i",time()) < '39')//USPS-USA单
  387. // {
  388. // $wid = 1;
  389. // }
  390. // else if(date("H",time()) == '20' && date("i",time()) > '20' && date("i",time()) < '39')//其他快递
  391. // {
  392. // $wid = 2;
  393. // }
  394. // else
  395. // {
  396. // exit;
  397. // }
  398. $notice = $this->notice->find_all("message = '1' and state = '1' and type = '4' and ktime < '$time' and jtime > '$time'");//已有自动发送,这个是物流发送
  399. foreach ($notice as $key=>$var)
  400. {
  401. $this->_waybillfs([
  402. 'var'=>$var,
  403. 'wid'=>$wid
  404. ]);
  405. }
  406. }
  407. public function upadtel(){
  408. $returngoods_id = 150;
  409. $insert_flag = 1217819;
  410. $number = 'KISS-50206-004';
  411. $returngoods_info = $this->returngoods->read($returngoods_id);
  412. $this->returngoods->save([
  413. 'status'=>80,
  414. 'back_no'=>$number,
  415. 'back_id'=>$insert_flag,
  416. 'update_time'=>date('Y-m-d H:i:s'),
  417. ],$returngoods_id);
  418. $this->returnlogs->insert([
  419. 'rg_id'=>(int)$returngoods_id,
  420. 'operat_id'=>10,
  421. 'operat_name'=>'admin',
  422. 'remark'=>"订单号:".$returngoods_info['orderinfo']."重新换货-换货新订单编码".$number,
  423. 'create_time'=>date('Y-m-d H:i:s'),
  424. ]);
  425. }
  426. public function _waybillfs($data)
  427. {
  428. if($data)
  429. {
  430. $notice = $data['var'];
  431. $notice['email'] = $this->emaildata->read($notice['email']);
  432. $wid = $data['wid'];
  433. $fsjs = "";
  434. if($wid == 1 && (stripos($notice['express'],',2,') !== false || stripos($notice['express'],',63,') !== false || stripos($notice['express'],',64,') !== false))
  435. {
  436. $js = explode(',',trim($notice['js'],','));
  437. if(count($js) > 1)
  438. {
  439. $fsjs = " and (";
  440. foreach ($js as $v)
  441. {
  442. $fsjs .= "js = '$v' or ";
  443. }
  444. $fsjs = trim($fsjs,' or ').")" ;
  445. }
  446. else if(count($js) == 1)
  447. {
  448. $fsjs = " and js = '$js[0]'";
  449. }
  450. $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
  451. }
  452. else if($wid == 2 && stripos($notice['express'],',1,') !== false)
  453. {
  454. $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
  455. }
  456. else
  457. {
  458. exit;
  459. }
  460. $this->logic_ding->sendToDing("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
  461. // $wlfs = array();
  462. // $dd = $this->fullorder->find_all("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
  463. // foreach($dd as $v){
  464. // $this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】");
  465. // }
  466. // foreach ($dd as $v)
  467. // {
  468. // $shop = $this->shop->read($v['shop']);
  469. // $express = $this->express->read($v['express']);
  470. // $fs = $this->notice->get_god($v,$shop,$express,$notice);
  471. // $this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】获取快递信息【".json_encode($notice,JSON_UNESCAPED_UNICODE)."】返回的信息".json_encode($fs));
  472. // if($fs == 1)
  473. // {
  474. // $this->fullorder->save(array('dlzemail'=>1,'dlzemailtime'=>time()),$v['id']);
  475. // //给crm发送信息 先存储数据 后续定时任务执行
  476. // if($v['shop'] < 10){
  477. // $this->zztmpdata->insert([
  478. // 'type'=>2,
  479. // 'act_name'=>'crm_order',
  480. // 'content'=>json_encode($v),
  481. // 'create_time'=>time()
  482. // ]);
  483. // }
  484. // }
  485. // else
  486. // {
  487. // //$pdtime = date('Y-m-d',time());
  488. // //$folderPath = './data/dlzemail/'.$pdtime; // 文件夹路径
  489. // //$permissions = 0777; // 权限设置
  490. // //if (!file_exists($folderPath)) { mkdir($folderPath, $permissions); }//创建文件夹
  491. // //file_exists($folderPath);
  492. // if(!is_file("./data/dlzemail/".$v['number'].".txt"))
  493. // {
  494. // $myfile = fopen("./data/dlzemail/".$v['number'].".txt", "w") or die("Unable to open file!");
  495. // fwrite($myfile, json_encode($fs.';'.$v.';'.$shop.';'.$express.';'.$notice));
  496. // fclose($myfile);
  497. // }
  498. // else
  499. // {
  500. // $myfile = fopen("./data/dlzemail/".$v['number'].".txt", "a+") or die("Unable to open file!");
  501. // fwrite($myfile, json_encode($fs.';'.$v.';'.$shop.';'.$express.';'.$notice));
  502. // fclose($myfile);
  503. // }
  504. // $this->fullorder->save(array('dlzemail'=>2,'dlzemailtime'=>time()),$v['id']);
  505. // }
  506. // sleep(50);
  507. // }
  508. }
  509. }
  510. public function ll(){
  511. $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=&
  512. ';
  513. parse_str($str, $output);
  514. return $output;
  515. }
  516. //修改客户分类
  517. public function _mdedit($arg_array)
  518. {
  519. die;
  520. $user = $this->user->read(10);
  521. $post = $this->ll();
  522. if(isset($post['shop']))
  523. {
  524. $fpcount = $post['fpcount'];
  525. if(!$fpcount)
  526. {
  527. echo json_encode(array('msg'=>'需要先清理浏览器缓存,刷新当前页面后再试!','success'=>false));exit;
  528. }
  529. $customerid = $post['customerid'];
  530. $shop = $post['shop'];
  531. $sp = $this->shop->read($shop);
  532. $num = $this->fullorder->find_count('shop = "'.$sp['id'].'" and gtime = "'.date('Ymd',time()).'"');
  533. $post['source'] = 1;//订单类型:1.线下订单2.PC3.手机
  534. $post['state'] = 207;//订单状态:207等待发货
  535. $post['review'] = 2;//审核状态:1.未送审2.待审核3.不通过4取消重审5.审核通过6.自动通过
  536. $post['print'] = 1;//打印状态:1.不可打印2.未打印3.已打印
  537. $post['library'] = 1;//出库状态:1.未出库2.已出库3.已退库
  538. $post['libraryconfirm'] = 1;//出库确认:1.不允许2.允许
  539. $post['link'] = $sp['link'];
  540. $post['issku'] = $sp['sku'];
  541. if($post['print'] != 3)
  542. {
  543. $post['librarynot'] = "订单未打印,未审核或未通过";//不能出库原因
  544. }
  545. $orderinfo = $post['orderinfo'];
  546. $post['shop'] = $sp['id'];
  547. $post['user'] = $sp['shopuser'];
  548. $post['number'] = $sp['shortname'].'-'.substr(date('ymd',time()),1).'-'.(substr(strval($num+1+1000),1,3));//编号
  549. if($orderinfo != "")
  550. {
  551. $ordefin = $this->fullorder->get_orderinfo($orderinfo);
  552. if($ordefin)
  553. {
  554. echo json_encode(array('msg'=>'订单号重复!','success'=>false));exit;
  555. }
  556. else
  557. {
  558. $post['orderinfo'] = $orderinfo;
  559. }
  560. }
  561. else
  562. {
  563. $post['orderinfo'] = $sp['id'].date('ymdHis',time()).rand(0,1);//订单号
  564. }
  565. if($post['paypal'] != '')
  566. {
  567. $pp = $this->fullorder->get_paypal($post['paypal']);
  568. if($pp)
  569. {
  570. echo json_encode(array('msg'=>'此交易号的订单已存在!','success'=>false));exit;
  571. }
  572. }
  573. $post['client'] = $post['client'];//客户名称
  574. $btime = $post['buytime'];//付款时间
  575. $post['buytime'] = strtotime($btime);//时间转UX
  576. $post['dtime'] = time();//订单时间
  577. $post['gtime'] = date('Ymd',time());//格式化时间
  578. $post['pay'] = $post['pay'];//支付方式
  579. $post['capital'] = $post['capital'];//资金状态
  580. $post['type'] = $post['warehouse'];//发货仓库
  581. $post['currency'] = $post['currency'];//币种
  582. $currency = $this->typeclass->read($post['currency']);
  583. $post['currencytitle'] = $currency['title'];//币种名称
  584. $post['freight'] = $post['freight'];//运费
  585. $post['expressmoney'] = $post['expressmoney'];//物流金额
  586. $post['shouldmoney'] = $post['shouldmoney'];//应收金额
  587. $post['skje'] = $post['shouldmoney'];//收款金额
  588. $product = $post['product'];//产品名称
  589. $product = str_replace(array('%26','%2B'),array('&','+'),$product);
  590. $post['product'] = preg_replace('/( | | |\s)/',' ',$product);
  591. $orderremarks = $post['orderremarks'];//订单备注
  592. $orderremarks = str_replace(array('%26','%2B'),array('&','+'),$orderremarks);
  593. $post['orderremarks'] = preg_replace('/( | | |\s)/',' ',$orderremarks);
  594. $shipremarks = $post['shipremarks'];//仓库品名
  595. $shipremarks = str_replace(array('%26','%2B'),array('&','+'),$shipremarks);//仓库品名
  596. $post['shipremarks'] = preg_replace('/( | | |\s)/',' ',$shipremarks);
  597. $post['email'] = $post['email'];//邮箱
  598. $name = $post['name'];//名称
  599. $post['name'] = preg_replace('/( | | |\s)/',' ',$name);
  600. $post['phone'] = $post['phone'];//电话
  601. $post['phone'] = preg_replace('/\D/s','',$post['phone']);
  602. $post['country'] = $post['country'];//国家
  603. $ct = $this->country->read($post['country']);//国家
  604. $post['al'] = $ct['lb'];//国家二字码
  605. $post['province'] = $post['province'];//省、州
  606. $post['province'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['province']); //替换开头空字符
  607. $post['province'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['province']); //替换结尾空字符
  608. $post['city'] = $post['city'];//城市
  609. $post['city'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['city']); //替换开头空字符
  610. $post['city'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['city']); //替换结尾空字符
  611. $post['zipcode'] = $post['zipcode'];//邮编
  612. $post['zipcode'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['zipcode']); //替换开头空字符
  613. $post['zipcode'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['zipcode']); //替换结尾空字符
  614. $post['address'] = $post['address'];//地址
  615. $post['printtype'] = $post['printtype'];//打印类型
  616. $fpdata = $post['fpdata'];//购买产品内容
  617. $fpdata = str_replace(array('%26','%2B'),array('&','+'),$fpdata);
  618. $post['fpdata'] = $fpdata;
  619. $post['sbpm'] = $post['sbpm'];//申报品名
  620. $post['zwpm'] = $post['zwpm'];//中文品名
  621. $post['ts'] = $post['ts'];//条数
  622. $post['dtsbjz'] = $post['dtsbjz'];//单条申报价
  623. $post['zsbjz'] = $post['zsbjz'];//总申报价
  624. $post['zzl'] = $post['zzl'];//总重量
  625. $post['zjs'] = $post['zjs'];//总件数
  626. $post['express'] = $post['express'];//快递公司
  627. $post['printtype'] = $post['printtype'];//打印类型
  628. $post['quantity'] = $post['quantity'];//数量
  629. $post['paypal'] = $post['paypal'];//支付号
  630. $post['guarantee'] = $post['guarantee'];//卖家保障
  631. $post['msg'] = $post['msg'];//发送留言类型
  632. $post['ioss'] = $post['ioss'];
  633. $post['sbpm'] = $post['sbpm'];
  634. $pay = $this->pay->get_typeclass($post['pay']);
  635. $yga = $post['shouldmoney'];
  636. $post['budget'] = 0;
  637. if($pay)
  638. {
  639. $ygc = $pay['estimaterate'];//预估到账公式
  640. $ifbudget = eval("return $yga*1.$ygc;");
  641. $post['estimaterate'] = $pay['estimaterate'];
  642. if($ifbudget > 0)
  643. {
  644. $post['budget'] = eval("return $yga*1.$ygc;");//预估到帐金额
  645. }
  646. }
  647. else
  648. {
  649. $ygb = $sp['estimaterate'];//店铺默认到账公式
  650. $ifbudget = eval("return $yga*1.$ygb;");
  651. $post['estimaterate'] = $sp['estimaterate'];
  652. if($ifbudget > 0)
  653. {
  654. $post['budget'] = eval("return $yga*1.$ygb;");//预估到帐金额
  655. }
  656. }
  657. $baddress = $post['baddress'];
  658. $saddress = $post['saddress'];
  659. $baddress = array_reverse(explode(',',$baddress));
  660. $saddress = array_reverse(explode(',',$saddress));
  661. $bar = '';$sar = '';
  662. $cr = $this->country->read($post['country']);
  663. $baddress[1] = $cr['lb'];
  664. $saddress[1] = $cr['lb'];
  665. $baddress = array_reverse($baddress);
  666. $saddress = array_reverse($saddress);
  667. for($i=0;$i<count($baddress);$i++)
  668. {
  669. $bar .= $baddress[$i].',';
  670. }
  671. for($i=0;$i<count($saddress);$i++)
  672. {
  673. $sar .= $saddress[$i].',';
  674. }
  675. $post['baddress'] = rtrim($bar,',');//卖家保障
  676. $post['saddress'] = rtrim($sar,',');//卖家保障
  677. $whlabel = $post['whlabel'];
  678. if($post['express'] == 2 && (stripos($post['name'],'&') !== false || stripos($post['name'],"'") !== false))
  679. {
  680. echo json_encode(array('msg'=>'USPS收件人或公司名不可用特殊符号!','success'=>false));exit;
  681. }
  682. if(strlen($post['client']) > 35 || strlen($post['name']) > 35)//收件人姓名或公司名不允许超过35位
  683. {
  684. echo json_encode(array('msg'=>'收件人姓名或公司名不可超过35个字符!','success'=>false));exit;
  685. }
  686. if(($post['express'] == '5' || $post['express'] == '24' || $post['express'] == '42' || $post['express'] == '31') && $post['country'] != 192)
  687. {
  688. echo json_encode(array('msg'=>'非美国无法选择Fedex、DHL官方-美国!','success'=>false));exit;
  689. }
  690. if($post['express'] == '3' && $post['country'] != 192 && $post['country'] != 35)
  691. {
  692. echo json_encode(array('msg'=>'非美国和加拿大无法选择UPS!','success'=>false));exit;
  693. }
  694. if($post['express'] == '3' && $post['country'] == 35 && $post['zsbjz'] > 20)
  695. {
  696. echo json_encode(array('msg'=>'UPS加拿大最高申报不可超过20','success'=>false));exit;
  697. }
  698. if($post['express'] == '2' && $post['warehouse'] != 5)
  699. {
  700. echo json_encode(array('msg'=>'非美国仓无法选择USPS!','success'=>false));exit;
  701. }
  702. if($post['express'] == '99' && $post['bx'] > 0)
  703. {
  704. echo json_encode(array('msg'=>'此物流不允许购买保险','success'=>false));exit;
  705. }
  706. if($post['express'] == 42 && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 ||
  707. {
  708. echo json_encode(array('msg'=>'此快递方式必须选择Human Hair Wigs/Human Hair Goods!','success'=>false));exit;
  709. }
  710. if($post['express'] == 24 && $post['sbpm'] != 'Hair Sample' && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 ||
  711. {
  712. echo json_encode(array('msg'=>'此快递方式必须选择Hair Sample/Human Hair Wigs/Human Hair Goods!','success'=>false));exit;
  713. }
  714. if($post['country'] != 192 && $post['express'] == 1 && $post['sbpm'] != 'Synthetic Hair Wigs' && $post['sbpm'] != 'Synthetic Hair Goods')//$post['express'] == 3 ||
  715. {
  716. echo json_encode(array('msg'=>'非美国选择官方DHL必须选择Synthetic Hair Wigs/Synthetic Hair Goods','success'=>false));exit;
  717. }
  718. if($post['pay'] == '22' && ($post['paypal'] == '' || $post['guarantee'] == ''))
  719. {
  720. echo json_encode(array('msg'=>'交易号和卖家保障必须填写','success'=>false));exit;
  721. }
  722. if($post['pay'] == '23' && $post['paypal'] == '')
  723. {
  724. echo json_encode(array('msg'=>'交易号必须填写','success'=>false));exit;
  725. }
  726. $express = $this->express->read($post['express']);
  727. if($post['zsbjz'] > $express['sbjz'])
  728. {
  729. echo json_encode(array('msg'=>'总申报价值不可超出'.$express['sbjz'],'success'=>false));exit;
  730. }
  731. if($post['shouldmoney'] > $express['shouldmoney'] && $express['shouldmoney'] != 0)
  732. {
  733. echo json_encode(array('msg'=>'订单金额不可超出'.$express['shouldmoney'],'success'=>false));exit;
  734. }
  735. if($express['ioss'] == 1 && $post['ioss'] == '')
  736. {
  737. echo json_encode(array('msg'=>'此快递方式必须选择IOSS!','success'=>false));exit;
  738. }
  739. if(strlen($post['address']) > $express['addresssize'] || strlen($post['address2']) > $express['addresssize'])
  740. {
  741. echo json_encode(array('msg'=>'此快递方地址不可超出'.$express['addresssize'].'个字符','success'=>false));exit;
  742. }
  743. if(strlen($post['address']) < 5)
  744. {
  745. echo json_encode(array('msg'=>'地址不可留空!','success'=>false));exit;
  746. }
  747. if($post['express'] == '2' && $post['zzl'] > '16' && $post['js'] == '0')
  748. {
  749. echo json_encode(array('msg'=>'重量大于16不可按Ground Advantage提交!','success'=>false));exit;
  750. }
  751. if($post['express'] == '2' && isset($post['js']) && $post['js'] == '0'&& $post['qm'] == '1')
  752. {
  753. echo json_encode(array('msg'=>'Ground Advantage不可使用签名服务!','success'=>false));exit;
  754. }
  755. if(($post['express'] == '3' || $post['express'] == '42' || $post['express'] == '24') && $post['shouldmoney'] < 1)
  756. {
  757. echo json_encode(array('msg'=>'零金额订单不可发 UPS/DHL官方-美国/Fedex(杭州)','success'=>false));exit;
  758. }
  759. if($post['express'] == '42' && $post['zsbjz'] < 1)
  760. {
  761. echo json_encode(array('msg'=>'零申报金额不可发 DHL官方-美国','success'=>false));exit;
  762. }
  763. if($post['express'] == '6' && $post['province'] == '')
  764. {
  765. echo json_encode(array('msg'=>'选择DPEX必须填写州信息','success'=>false));exit;
  766. }
  767. $dtctitle = array();
  768. $dictionaries = $this->typeclass->find_all();
  769. foreach ($dictionaries as $v)
  770. {
  771. $dtctitle[$v['id']] = array($v['title'],$v['bqsku']);
  772. }
  773. $fpdata = $post['fpdata'];
  774. if(stripos($fpdata,'-128-') !== false || stripos($fpdata,'-127-') !== false)
  775. {
  776. $dfp = explode(';',trim($fpdata,';'));
  777. $fdata = '';
  778. foreach ($dfp as $k=>$v)
  779. {
  780. $ptitleb = '';
  781. $fp = explode('|',trim($v,'|'));
  782. $fp0 = explode(',',$fp[0]);
  783. if(isset($fp0[1]))
  784. {
  785. $fp1 = explode('-',trim($fp0[1],'-'));
  786. }
  787. else
  788. {
  789. $fp1 = explode('-',trim($fp[0],'-'));
  790. }
  791. foreach ($fp1 as $vv)
  792. {
  793. $ptitleb .= isset($dtctitle[$vv])?$dtctitle[$vv][0].' ':'';
  794. }
  795. if(isset($fp0[1]))
  796. {
  797. $ptitleb .= $dtctitle[$fp0[0]][1].'inch ';
  798. $fp[1] = $ptitleb;
  799. }
  800. $fdata .= implode("|",$fp).";";
  801. }
  802. $fpdata = $fdata;
  803. }
  804. $warehouse = $this->warehouse->read($post['type']);
  805. if($warehouse['bdcountry'] != 0 && $post['country'] != $warehouse['bdcountry'])
  806. {
  807. echo json_encode(array('msg'=>'当前国家无法选择'.$warehouse['title'].'!','success'=>false));exit;
  808. }
  809. // $kcyz = $this->ck->get_kc($post['state'],$warehouse,$post['shop'],$post['number'],$whlabel,$fpdata);
  810. // if($kcyz['t'] > '0')
  811. // {
  812. // echo $kcyz['m'];exit;
  813. // }
  814. // else if($kcyz['fpdata'] != '')
  815. // {
  816. // $post['whlabel'] = $kcyz['whlabel'];
  817. // $post['fpdata'] = $kcyz['fpdata'];
  818. // }
  819. // $fl = $this->ck->get_fl($warehouse['hz'],$whlabel,$fpdata);
  820. // $post['sfxh'] = $fl['sfxh'];
  821. // $post['ckfl'] = $fl['ckfl'];
  822. //查询净重开始
  823. $post['jweight'] = $this->weight->get_weightcx($post['fpdata']);
  824. //查询净重结束
  825. $cusnum = $this->customer->read($customerid);
  826. // $this->customer->save(array('num'=>$cusnum['num']+1,'time'=>$post['buytime']),$customerid);
  827. // $this->fullorder->insert($post);
  828. echo json_encode(array('msg'=>'下单成功','success'=>true));exit;
  829. }
  830. echo "1";
  831. die;
  832. }
  833. }