Api.php 93 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551
  1. <?php defined('BASEPATH') OR exit('No direct script access allowed');
  2. class Api extends Start_Controller {
  3. public function __construct(){
  4. parent::__construct();
  5. $this->load->library('session');
  6. $this->load->_model('Model_api','api');
  7. $this->load->_model('Model_shop','shop');
  8. $this->load->_model('Model_fullorder','fullorder');
  9. $this->load->_model('Model_fullordertt','fullordertt');
  10. $this->load->_model('Model_fullorder_smt','fullorder_smt');
  11. $this->load->_model('Model_fullordersmt','fullordersmt');
  12. $this->load->_model('Model_country','country');
  13. $this->load->_model('Model_hl','hl');
  14. $this->load->_model('Model_is','is');
  15. $this->load->_model('Model_kdniao','kdniao');
  16. $this->load->_model('Model_typeclass','typeclass');
  17. $this->load->_model('Model_warehouse','warehouse');
  18. $this->load->_model('Model_fullorderexcel','fullorderexcel');
  19. $this->load->_model('Model_dhl','dhl');
  20. $this->load->_model('Model_usps','usps');
  21. $this->load->_model('Model_ups','ups');
  22. $this->load->_model('Model_dhltest','dhltest');
  23. $this->load->_model('Model_customer','customer');
  24. $this->load->_model('Model_express','express');
  25. $this->load->_model('Model_notice','notice');
  26. $this->load->_model('Model_emaildata','emaildata');
  27. $this->load->_model('Model_whlabel','whlabel');
  28. $this->load->_model('Model_productdescribe','productdescribe');
  29. $this->load->_model('Model_ljg','ljg');
  30. $this->load->_model('Model_commodityread','commodityread');
  31. $this->load->_model('Model_service','service');
  32. $this->load->_model('Model_fedex','fedex');
  33. $this->load->_model('Model_apismt','apismt');
  34. $this->load->_model('Model_cne','cne');
  35. $this->load->_model('Model_specialstock','specialstock');
  36. $this->load->_model('Model_whlabellabel','whlabellabel');
  37. $this->load->_model('Model_allocation','allocation');
  38. $this->load->_model('Model_yswaybill','yswaybill');
  39. $this->load->_model('Model_paypal','paypal');
  40. $this->load->_model('Model_17track','17track');
  41. $this->load->_model('Model_ck','ck');
  42. $this->load->_model('Model_weight','weight');
  43. $this->load->_model('Model_pay','pay');
  44. $this->load->_model('Model_setting','setting');
  45. $this->load->_model('Model_classid','classid');
  46. $this->load->_model('Model_apiyy','apiyy');
  47. $this->load->_model('Model_whlabel_fc','whlabel_fc');
  48. $this->load->_model('Model_shopsku','shopsku');
  49. $this->load->_model('Model_awlgx','awlgx');
  50. $this->load->_model('Model_apitt','apitt');
  51. $this->load->_model('Model_producttitle','producttitle');
  52. $this->load->_model('Model_afspaypal','afspaypal');
  53. $this->load->_model('Model_message','message');
  54. $this->load->_model("Model_zztmpdata",'zztmpdata');
  55. $this->load->_model("Model_logic_ding","logic_ding");
  56. }
  57. //定义方法的调用规则 获取URI第二段值
  58. public function _remap($arg,$arg_array)
  59. {
  60. if($arg == 'isorder')//添加
  61. {
  62. $this->_isorder();
  63. }
  64. else if($arg == 'tb')//同步独立站
  65. {
  66. $this->_tb();
  67. }
  68. else if($arg == 'waybill')//运单上传独立站
  69. {
  70. $this->_waybill($arg_array);
  71. }
  72. else if($arg == 'waybillemail')
  73. {
  74. $this->_waybillemail($arg_array);
  75. }
  76. else if($arg == 'waybillfs')
  77. {
  78. $this->_waybillfs($arg_array);
  79. }
  80. else if($arg == 'headgear')//传输头套信息
  81. {
  82. $this->_headgear($arg_array);
  83. }
  84. else if($arg == 'fsstate')
  85. {
  86. $this->_fsstate();
  87. }
  88. else if($arg == 'fswaybillemail')
  89. {
  90. $this->_fswaybillemail();
  91. }
  92. else if($arg == 'zz')
  93. {
  94. $this->_zz();
  95. }
  96. else if($arg == 'zzcs')
  97. {
  98. $this->_zzcs();
  99. }
  100. else if($arg == 'cangku')
  101. {
  102. $this->_cangku();
  103. }
  104. else if($arg == 'kc')
  105. {
  106. $this->_kc();
  107. }
  108. else if($arg == 'wlfs')
  109. {
  110. $this->_wlfs();
  111. }
  112. else if($arg == 'query')
  113. {
  114. $this->_query();
  115. }
  116. else if($arg == 'kcjc')
  117. {
  118. $this->_kcjc();
  119. }
  120. else if($arg == 'klarna')
  121. {
  122. $this->_klarna();
  123. }
  124. else if($arg == 'logistics')
  125. {
  126. $this->_logistics();
  127. }
  128. else if($arg == 'hqpaypal')
  129. {
  130. $this->_hqpaypal();
  131. }
  132. else if($arg == 'hqstripe')
  133. {
  134. $this->_hqstripe();
  135. }
  136. else if($arg == 'htmlstock')
  137. {
  138. $this->_htmlstock();
  139. }
  140. else if($arg == 'dhl')
  141. {
  142. $this->_dhl();
  143. }
  144. else if($arg == '17track')
  145. {
  146. $this->_17track();
  147. }
  148. else if($arg == 'zc17track')
  149. {
  150. $this->_zc17track();
  151. }
  152. }
  153. //通过地址直接获取独立站订单信息
  154. public function _isorder()
  155. {
  156. $sid = '';$sd = array();
  157. if(isset($_SESSION['api']))
  158. {
  159. $user = $this->user->get_api($_SESSION['api']);
  160. $user = explode('|',trim($user['shop'],'|'));
  161. foreach ($user as $value)
  162. {
  163. $sid .= " id = '$value' or";
  164. }
  165. $sid = " and (".rtrim($sid,'or').")";
  166. }
  167. $post = $this->input->post(NULL, TRUE);
  168. $api = $this->input->get('api',true);
  169. $dshop = $this->input->get('dshop',true);
  170. //@$gethl = $this->hl->get_hl();//获取即时汇率
  171. $gethl = array();
  172. /* 订单号加入键值-k */
  173. /**
  174. $dataorder = array();
  175. $fdata = $this->fullorder->find_all('dtime > "'.(time()-96*3600).'"','orderinfo');
  176. foreach ($fdata as $v)
  177. {
  178. $dataorder[$v['orderinfo']] = "";//获取到单号
  179. }
  180. **/
  181. /* 订单号加入键值-j */
  182. /* 匹配加入 */
  183. $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');
  184. // 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)
  185. $dtc = array();
  186. foreach ($dictionaries as $v)
  187. {
  188. if(stripos($v['spare'],'|') !== false)//如果有多个值
  189. {
  190. $v['spare'] = explode('|',$v['spare']);
  191. foreach ($v['spare'] as $k=>$vs)
  192. {
  193. if(stripos($v['zh'],'|') !== false)
  194. {
  195. $vzh = explode('|',$v['zh']);
  196. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  197. }
  198. else
  199. {
  200. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  201. }
  202. }
  203. }
  204. else
  205. {
  206. $dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
  207. }
  208. }
  209. $dictionaries2 = $this->typeclass->find_all();
  210. foreach ($dictionaries2 as $v)
  211. {
  212. $dtctitle[$v['id']] = $v['title'];
  213. }
  214. /* 匹配结束 */
  215. /* 价格加入 */
  216. /**
  217. $money = array();
  218. $productdescribe = $this->productdescribe->find_all('1=1','number,purchase,cost,salesprice,title');
  219. foreach ($productdescribe as $v)
  220. {
  221. $money[$v['number']] = array('purchase'=>$v['purchase'],'cost'=>$v['cost'],'salesprice'=>$v['salesprice'],'title'=>$v['title']);
  222. }
  223. **/
  224. /* 价格加入 */
  225. /* 匹配ID加入 */
  226. $int = array();
  227. $intdata = $this->typeclass->find_all('classid=14','id,spare');
  228. foreach ($intdata as $v)
  229. {
  230. $v['spare'] = explode('|',$v['spare']);
  231. $int[$v['id']] = $v['spare'][0];
  232. }
  233. /* 匹配ID结束 */
  234. /* 国家加入键值-k */
  235. $cuy = array();
  236. $cuydata = $this->country->find_all('1=1','lb,id');
  237. foreach ($cuydata as $v)
  238. {
  239. $cuy[$v['lb']] = $v['id'];//获取到国家ID
  240. }
  241. /* 国家加入键值-j */
  242. /* 币种加入键值-k */
  243. $typeclass = array();
  244. $tdata = $this->typeclass->find_all('classid=30','id,title');
  245. foreach ($tdata as $v)
  246. {
  247. $typeclass[$v['title']] = $v['id'];
  248. }
  249. /* 币种加入键值-j */
  250. /* 支付方式-k */
  251. $pay = array();
  252. $tdata = $this->typeclass->find_all('classid=4','id,spare');
  253. foreach ($tdata as $v)
  254. {
  255. $paytype = $this->pay->get_typeclass($v['id']);
  256. if(isset($paytype['estimaterate']))
  257. {
  258. $estimaterate = $paytype['estimaterate'];
  259. }
  260. else
  261. {
  262. $estimaterate = 0;
  263. }
  264. if(stripos($v['spare'],'|') !== false)//如果有多个值
  265. {
  266. $v['spare'] = explode('|',$v['spare']);
  267. foreach ($v['spare'] as $k=>$vs)
  268. {
  269. $pay[$vs] = array('id'=>$v['id'],'estimaterate'=>$estimaterate);
  270. }
  271. }
  272. else
  273. {
  274. $pay[$v['spare']] = array('id'=>$v['id'],'estimaterate'=>$estimaterate);
  275. }
  276. }
  277. $pay['stripeios'] = $pay['stripe_payments'];
  278. /* 支付方式-j */
  279. /* 新增SKU-k */
  280. $zjsku = array();
  281. $shopsku = $this->shopsku->find_all();
  282. foreach ($shopsku as $val)
  283. {
  284. $ss = explode(',',trim($val['shop'],','));
  285. foreach ($ss as $v)
  286. {
  287. if(isset($zjsku[$v]))
  288. {
  289. $zjsku[$v] .= ','.trim($val['sku'],',');
  290. }
  291. else
  292. {
  293. $zjsku[$v] = trim($val['sku'],',');
  294. }
  295. }
  296. }
  297. /* 新增SKU-j */
  298. $is = $this->is->find_all('1=1','*','number asc');//获取仓库平匹配表
  299. if(isset($post['is']) || (isset($api) && $api = '89757'))
  300. {
  301. $tb = 0;
  302. if($dshop)
  303. {
  304. $shop = $this->shop->find_all("id = '$dshop'");
  305. }
  306. else
  307. {
  308. $shop = $this->shop->find_all("type = 269 and tb = 1".$sid);//获取独立站信息
  309. }
  310. foreach ($shop as $value)
  311. {
  312. if((time()-$value['tbtime']) < 600)
  313. {
  314. $tb = 1;//正在同步中
  315. break;
  316. }
  317. else
  318. {
  319. $this->shop->save(array('tbtime'=>time()),$value['id']);
  320. }
  321. $setting = $this->setting->get_settings();
  322. $this->db->trans_begin();
  323. $res = $this->api->get_hq($value['brandname'],$value['shopadmin'],$value);
  324. $sd[] = $res;
  325. $sjc = $setting['sctime'];//时间差 之前是3600 现在为0
  326. if($res)
  327. {
  328. foreach ($res as $v)
  329. {
  330. if(!isset($v['order_id']))
  331. {
  332. continue;
  333. }
  334. if($value['token'] == 'SU')
  335. {
  336. $time = $v['purchased_on']-7*3600-$sjc;//之前是+$sjc
  337. }
  338. else if($value['program'] == 'Shopify')
  339. {
  340. $time = $v['purchased_on'];
  341. }
  342. else
  343. {
  344. if($value['id'] == 1)
  345. {
  346. $time = strtotime($v['purchased_on'])-7*3600-$sjc;//-$sjc;//之前是+$sjc
  347. }
  348. else
  349. {
  350. $time = strtotime($v['purchased_on'])-7*3600-$sjc;//订单时间更为时间戳 //之前是+$sjc
  351. }
  352. }
  353. $num = $this->fullorder->find_count('gtime = "'.date('Ymd',$time).'" and shop = "'.$value['id'].'"');
  354. $order_id = $value['id'].$v['order_id'];
  355. $tc = 0;
  356. if(isset($v['global_currency_code']))
  357. {
  358. $tc = isset($typeclass[$v['global_currency_code']])?$typeclass[$v['global_currency_code']]:0;
  359. }
  360. $dataorder = $this->fullorder->get_orderinfo($order_id);
  361. $hmdid = '';
  362. if($value['program'] == 'Shopify' && isset($dataorder['id']))
  363. {
  364. if($v['order_comment'] != $dataorder['clientremarks'])
  365. {
  366. $this->fullorder->save(array('clientremarks'=>$v['order_comment']),$dataorder['id']);
  367. }
  368. }
  369. if(!isset($dataorder['id']))
  370. //现在为所有订单都获取。!$ord && strcasecmp($v['isstatus'],'processing') == 0如果没有此订单并且订单状态为等待发货则继续
  371. {
  372. if(!isset($cuy[$v['country']]))
  373. {
  374. $cuy[$v['country']] = 1004;
  375. }
  376. $post = $this->api->get_data($value,$v,$gethl,$time,$cuy[$v['country']],$is,$num,$v['country'],$tc,$dtc,array(),$int,$dtctitle,$pay,$zjsku);
  377. $kn = explode('-',$post['paypal']);
  378. if($post['pay'] == 23 && $value['klarnaname'] != '' && $value['klarnapass'] != '')
  379. {
  380. $klarna = $this->_klarnadata($post['paypal'],$value['klarnaname'],$value['klarnapass']);
  381. if($klarna != '')
  382. {
  383. $post['klarnadata'] = $klarna;
  384. }
  385. }
  386. if($post['pay'] == 26 && $value['afterpayname'] != '' && $value['afterpaypass'] != '')
  387. {
  388. $afterpay = $this->_afterpay($post['paypal'],$value['afterpayname'],$value['afterpaypass']);
  389. if($afterpay != '')
  390. {
  391. $post['klarnadata'] = $afterpay;
  392. }
  393. }
  394. if($post['pay'] == 27 && $value['clearpayname'] != '' && $value['clearpaypass'] != '')
  395. {
  396. $clearpay = $this->_clearpay($post['paypal'],$value['clearpayname'],$value['clearpaypass']);
  397. if($clearpay != '')
  398. {
  399. $post['klarnadata'] = $clearpay;
  400. }
  401. }
  402. if($post['pay'] == '28' && $post['state'] != '207')
  403. {
  404. continue;
  405. }
  406. if($post['state'] == '217' || $post['state'] == '203')
  407. {
  408. continue;
  409. }
  410. /**
  411. else if($post['pay'] == 22 && $value['paypalname'] != '' && $value['paypalpass'] != '')
  412. {
  413. $paypal = $this->_paypaldata($post['paypal'],$value['paypalname'],$value['paypalpass']);
  414. if($paypal != '')
  415. {
  416. $post['klarnadata'] = $paypal;
  417. }
  418. }
  419. **/
  420. /** 启用自动分配仓库 **/
  421. $post['express'] = 0;
  422. $warehouse = $this->warehouse->find_all("fpzd = '1'",'*','fpsx desc');
  423. foreach ($warehouse as $v)
  424. {
  425. if($v['bdcountry'] != 0 && $v['bdcountry'] != $post['country'])
  426. {
  427. continue;
  428. }
  429. $yx = 'get_yx_'.$v['bdck'];
  430. $kczd = $this->ck->$yx($post['state'],$v,$post['shop'],$post['number'],$post['whlabel'],$post['fpdata']);
  431. if($kczd['t'] == 0)
  432. {
  433. $country = $this->country->read($post['country']);//获取国家中配置物流
  434. if($country['express'] != 0)
  435. {
  436. $post['express'] = $country['express'];
  437. }
  438. if($v['express'] != 0)//优先使用仓库指定物流,替换掉上面的国家配置物流
  439. {
  440. $post['express'] = $v['express'];
  441. }
  442. $post['type'] = $v['id'];
  443. $post['whlabel'] = $kczd['whlabel'];
  444. $post['fpdata'] = $kczd['fpdata'];
  445. if(stripos($kczd['whlabel'],$v['hz']) !== false)
  446. {
  447. break 1;
  448. }
  449. }
  450. }
  451. $qdw = $this->warehouse->read($post['type']);
  452. $fl = $this->ck->get_fl($qdw['hz'],$post['whlabel'],$post['fpdata']);
  453. $post['sfxh'] = $fl['sfxh'];
  454. $post['ckfl'] = $fl['ckfl'];
  455. $zipcode = substr($post['zipcode'],0,1);
  456. if($post['type'] == 5 && $zipcode > 4)
  457. {
  458. $post['express'] = 63;
  459. }
  460. if($post['express'] > 0)
  461. {
  462. $xze = $this->express->read($post['express']);
  463. $post['printtype'] = $xze['type'];
  464. }
  465. //自动写位置 开始
  466. $zclp = array();$pxsl = array();
  467. $slpx = explode('|',$post['slpx']);//排序
  468. //监听报错原因
  469. //解决礼物类没有slpx的数据
  470. if(!empty($post['slpx'])){
  471. foreach ($slpx as $k=>$v)
  472. {
  473. $v = explode('-',$v);
  474. if(!isset($v[1]))
  475. {
  476. $v[1] == 1;
  477. }
  478. for($i=$v[0];$i<$v[1];$i++)
  479. {
  480. $pxsl[$i] = $k;
  481. }
  482. }
  483. }
  484. $mc = $qdw['bdck'];$zdidjl = '';$zdwzjl = '';
  485. if($qdw['wz'] == 1)
  486. {
  487. $pm = explode(';',trim($post['shipremarks'],';'));
  488. foreach ($pm as $k=>$vv)
  489. {
  490. $vv = trim($vv,' ');
  491. $tmp_vv = str_replace("'","",$vv);
  492. $lp = $this->typeclass->find_all("zh = '$tmp_vv'");
  493. if(isset($lp[0]['classid']))
  494. {
  495. $zclp[] = $vv;
  496. unset($pm[$k]);
  497. }
  498. }
  499. $pm = array_values($pm);
  500. $w = explode('|',trim($post['whlabel'],'|'));
  501. foreach ($w as $k=>$val)
  502. {
  503. $hwm = '';
  504. if(stripos($val,$qdw['hz']) !== false)
  505. {
  506. $num = explode('-',trim($val,'-'));
  507. $xq = explode('~',trim($num[2],'~'));
  508. $pmxq = '(';
  509. foreach ($xq as $v)
  510. {
  511. $zdidjl .= '('.trim($v,$qdw['hz']).')';
  512. $h = $this->$mc->read(trim($v,$qdw['hz']));
  513. if($h['details'] != '')
  514. {
  515. $pmxq .= $qdw['title'].':'.$h['details'].(($h['cpid']>0)?'-'.$h['cpid']:'').',';
  516. }
  517. }
  518. $xrid = ($h['cpid']>0)?'-'.$h['cpid']:'';
  519. if(isset($pxsl[$k]))
  520. {
  521. if(stripos($pm[$pxsl[$k]],$qdw['title'].':'.$h['details'].$xrid) === false)
  522. {
  523. $pm[$pxsl[$k]] .= trim($pmxq,',').')';
  524. }
  525. }
  526. $zdwzjl .= $h['details'].(($h['cpid']>0)?'-'.$h['cpid']:'');
  527. }
  528. }
  529. if($zclp)
  530. {
  531. $zclp = ';'.implode(";",$zclp);
  532. }
  533. else
  534. {
  535. $zclp = '';
  536. }
  537. $post['shipremarks'] = implode(";",$pm).$zclp;
  538. $post['contents'] = $zdidjl.' - '.$zdwzjl;
  539. }
  540. //自动写位置 结束
  541. //条数及申报
  542. $ts = 0;
  543. $dtsbjz = 0;
  544. $zsbjz = 0;
  545. $w = explode('|',trim($post['whlabel'],'|'));
  546. foreach ($w as $k=>$val)
  547. {
  548. $num = explode('-',trim($val,'-'));
  549. //$ts += $num[1];
  550. //判断是否是礼物 礼物不计数
  551. $is_gift_str = substr($num[0], 0, 3);
  552. if($is_gift_str != '131'){
  553. $ts += $num[1];
  554. }
  555. }
  556. if($ts > 0 && $ts < 6 && $post['country'] == 192)
  557. {
  558. $dtsbjz = ($ts==3)?sprintf("%.2f",100/$ts):100/$ts;
  559. $zsbjz = sprintf("%.2f",$dtsbjz*$ts);
  560. }
  561. $post['ts'] = $ts;
  562. $post['dtsbjz'] = $dtsbjz;
  563. $post['zsbjz'] = $zsbjz;
  564. /** **/
  565. //合并重复项
  566. $hbcfw = explode('|',trim($post['whlabel'],'|'));
  567. $hbcff = explode(';',trim($post['fpdata'],';'));
  568. $c = 0;
  569. $hbw = array();
  570. $hbf = array();
  571. for($i=0;$i<count($hbcfw);$i++)
  572. {
  573. $w = explode('-',$hbcfw[$i]);
  574. $f = explode('|',$hbcff[$i]);
  575. $w2 = ($w[2]==0)?0:'';
  576. if(!isset($hbw[$w[0].$w2]))
  577. {
  578. $hbw[$w[0].$w2] = $hbcfw[$i];
  579. $hbf[$w[0].$w2] = $hbcff[$i];
  580. }
  581. else
  582. {
  583. $c++;
  584. $cw = explode('-',$hbw[$w[0].$w2]);
  585. $cf = explode('|',$hbf[$w[0].$w2]);
  586. if($cw[2] != 0 && $w[2] != 0)
  587. {
  588. $cf[2] += $f[2];
  589. $cf[9] .= '~'.$f[9];
  590. $hbf[$w[0].$w2] = implode("|",$cf);
  591. $cw[1] += $f[2];
  592. $cw[2] .= '~'.$f[9];
  593. $hbw[$w[0].$w2] = implode("-",$cw);
  594. }
  595. else if($cw[2] == 0 && $w[2] == 0)
  596. {
  597. $cf[2] += $f[2];
  598. $hbf[$w[0].$w2] = implode("|",$cf);
  599. $cw[1] += $f[2];
  600. $hbw[$w[0].$w2] = implode("-",$cw);
  601. }
  602. else
  603. {
  604. $hbw[] = $hbcfw[$i];
  605. $hbf[] = $hbcff[$i];
  606. }
  607. }
  608. }
  609. if($c > 0)
  610. {
  611. $post['fpdata'] = implode(";",$hbf).';';
  612. $post['whlabel'] = '|'.implode("|",$hbw).'|';
  613. }
  614. //合并重复项结束
  615. //非占单设置为禁止占单开始
  616. $hbw = explode('|',trim($post['whlabel'],'|'));
  617. $hbf = explode(';',trim($post['fpdata'],';'));
  618. foreach ($hbw as $k=>$val)
  619. {
  620. $w = explode('-',$val);
  621. $f = explode('|',$hbf[$k]);
  622. if(!isset($w[2]) || $w[2] == 0)
  623. {
  624. $w[2] = "DNOTO";
  625. $f[9] = "DNOTO";
  626. $hbf[$k] = implode("|",$f);
  627. $hbw[$k] = implode("-",$w);
  628. }
  629. }
  630. $post['fpdata'] = implode(";",$hbf).';';
  631. $post['whlabel'] = '|'.implode("|",$hbw).'|';
  632. //非占单设置为禁止占单结束
  633. //查询净重开始
  634. $post['jweight'] = $this->weight->get_weightcx($post['fpdata']);
  635. $post['zzl'] = ($post['jweight']+100)/1000;
  636. if($post['express'] == 2)
  637. {
  638. $post['zzl'] = intval(($post['jweight']+100)*0.035);
  639. }
  640. //查询净重结束
  641. $tjid = $this->fullorder->insert($post);
  642. if($post['email'] == '')
  643. {
  644. $post['email'] = $post['name'].'@qq.com';
  645. }
  646. $adrs = $this->customer->get_email($post['email'],$post['shop']);
  647. preg_match_all('/[0-9]/u',$post['phone'],$result);
  648. $numphone = join('',$result[0]);
  649. $hmdaddress1 = str_replace(array(' parkway',' drive',' street',' road',' avenue',' boulevard',' alley',' court',' place',' lane',' manor',' terrace',' trail',' view',' cove'),array(' pkwy',' dr',' st',' rd',' av',' blvd',' aly',' ct',' pl',' ln',' mnr',' ter',' trl',' vw',' cv'),strtolower($post['address']));
  650. $hmdaddress2 = str_replace(array(' pkwy',' dr',' st',' rd',' av',' blvd',' aly',' ct',' pl',' ln',' mnr',' ter',' trl',' vw',' cv'),array(' parkway',' drive',' street',' road',' avenue',' boulevard',' alley',' court',' place',' lane',' manor',' terrace',' trail',' view',' cove'),strtolower($post['address']));
  651. $hmdaddress3 = str_replace(array(' avenue',' ave',' av'),array(' ave',' avenue',' ave'),strtolower($post['address']));
  652. $hmdid = '';
  653. $customerb = $this->customer->find_all("type = 2 and (email = '".$post['email']."' or address = '".$post['address']."' or address = '".$hmdaddress1."' or address = '".$hmdaddress2."' or address = '".$hmdaddress3."' or numphone = '".$numphone."')",'*','id desc');
  654. $lkh = (isset($customerb[0]['id']))?2:1;//白名单1黑名单2
  655. if($lkh == 2)
  656. {
  657. $hmdid = $customerb[0]['id'].'-('.$post['email'].'|'.$post['address'].'|'.$numphone.')'.'('.$customerb[0]['email'].'|'.$customerb[0]['address'].$customerb[0]['numphone'].')';
  658. }
  659. if($adrs)
  660. {
  661. $pdlkh = 1;//这个是判断是否老客户
  662. $this->customer->save(array('time'=>$post['dtime'],'is_tb'=>0,'num'=>$adrs['num']+1,'money'=>$adrs['money']+$post['shouldmoney']),$adrs['id']);
  663. $khid = $adrs['id'];
  664. }
  665. else
  666. {
  667. $str = $post['phone'];
  668. preg_match_all('/[0-9]/u',$str,$result);
  669. $numphone = join('',$result[0]);
  670. $ct['shop'] = $post['shop'];
  671. $ct['source'] = 10;
  672. $ct['level'] = 5;
  673. $ct['country'] = $post['country'];
  674. $ct['time'] = $post['dtime'];
  675. $ct['num'] = 1;
  676. $ct['money'] = $post['shouldmoney'];
  677. $ct['zipcode'] = $post['zipcode'];
  678. $ct['name'] = $post['name'];
  679. $ct['phone'] = $post['phone'];
  680. $ct['numphone'] = $numphone;
  681. $ct['email'] = preg_replace('/( | | |\s)+/','',$post['email']);
  682. $ct['province'] = $post['province'];
  683. $ct['city'] = $post['city'];
  684. $ct['address'] = $post['address'];
  685. $ct['zhcx'] = $post['shop'].'-'.$ct['email'];
  686. $ct['is_tb'] = 0;
  687. $khid = $this->customer->insert($ct);
  688. $pdlkh = 0;
  689. }
  690. $this->_znxc($post,$order_id,$lkh,$pdlkh,$hmdid);
  691. /**
  692. if($post['shop'] == '1' || $post['shop'] == '2' || $post['shop'] == '6' || $post['shop'] == '5')
  693. {
  694. $this->_znxc($post,$order_id,$lkh);
  695. }
  696. else
  697. {
  698. $this->_znx($post,$order_id,$lkh);
  699. }
  700. **/
  701. }//else{}如果有此订单
  702. }
  703. }
  704. if ($this->db->trans_status() === FALSE)
  705. {
  706. $this->db->trans_commit();
  707. }
  708. else
  709. {
  710. $this->db->trans_commit();
  711. }
  712. usleep(50);//停留2秒
  713. }
  714. if($tb == 1)
  715. {
  716. echo json_encode(array('msg'=>'有店铺正在同步中,请5分钟后再试!','success'=>true));exit;
  717. }
  718. echo json_encode(array('msg'=>'OK!','success'=>true));exit;
  719. }
  720. }
  721. public function _tb()
  722. {
  723. $api = $this->input->get('api',true);
  724. if(isset($api) && $api = '89757')
  725. {
  726. $data = $this->fullorder->find_all('dlz < 1 and source != 1 and waybill != "" and dtime > "'.(time()-48*3600).'"');
  727. $dataorder = array();$datashop = array();$dataex = array();$datack = array();
  728. /* 店铺加入键值-j */
  729. $fshop = $this->shop->find_all('1=1');
  730. foreach ($fshop as $v)
  731. {
  732. $datashop[$v['id']] = $v;
  733. }
  734. /* 店铺加入键值-k */
  735. /* 快递加入键值-j */
  736. $fex = $this->express->find_all('1=1');
  737. foreach ($fex as $v)
  738. {
  739. $dataex[$v['id']] = $v;
  740. }
  741. /* 快递加入键值-k */
  742. /* 仓库加入键值-k */
  743. $fwh = $this->warehouse->find_all('1=1');
  744. foreach ($fwh as $v)
  745. {
  746. $datack[$v['id']] = $v;
  747. }
  748. /* 仓库加入键值-j */
  749. //$fs = $this->notice->get_ordertatus(216);//216成功状态
  750. foreach ($data as $v)
  751. {
  752. $ddh = substr($v['orderinfo'],1);
  753. $ydh = $v['waybill'];
  754. $xg = $v;//此订单数据
  755. $shop = $datashop[$xg['shop']];//此订单店铺
  756. $ex = $dataex[$xg['express']];//此订单快递
  757. $warehouse = $datack[$xg['type']];//此订单仓库
  758. $shopifyid = $v['shopify'];
  759. if($xg['shop'] < 7)
  760. {
  761. $xg['iscode'] = $ex['title'];
  762. $xg['url'] = $shop['shopname'];
  763. @$fs = $this->api->get_paypal($xg);
  764. $this->afspaypal->insert(array('number'=>$xg['number'],'cs'=>$fs));
  765. }
  766. $ms = $this->message->find_all("express like '%,".$xg['express'].",%'");
  767. if(!isset($ms[0]))
  768. {
  769. $ms = $this->message->read(2);
  770. }
  771. else
  772. {
  773. $ms = $ms[0];
  774. }
  775. $shopname = $shop['brandname']; //店铺名
  776. $buyername = $xg['bname']; //Bill Name
  777. $email_call = $shop['shopid']; //发货人邮箱;
  778. $phone = $shop['shopphone']; //发货人电话
  779. $track_type = $ex['title']; //快递名称
  780. $service = $ex['title']; //快递追踪名称
  781. $track_link = $ex['url']; //快递查询网址
  782. $logistics_number = $ydh; //运单号
  783. $t= array('%buyername%','%email_call%','%track_type%','%service%','%track_link%','%logistics_number%','%shop%','%phone%','%jtime%');
  784. $h= array($buyername,$email_call,$track_type,$service,$track_link,$logistics_number,$shopname,$phone,$ex['yjtime']);
  785. $remark = str_replace($t,$h,$ms['content']);
  786. @$gx = $this->api->get_gx($ddh,$ydh,$xg,$shop,$ex,$remark,$shopifyid);
  787. if(!isset($gx['res']))
  788. {
  789. continue;
  790. }
  791. $this->fullorder->save(array('dlz'=>$gx['res'],'state'=>$gx['state']),$v['id']);
  792. }
  793. }
  794. }
  795. //更新独立站运单信息
  796. public function _waybill($arg_array)
  797. {
  798. $where = "dlz < '1' and state = '207' and shop != '19' and ";
  799. if(date("H",time()) == '8' && date("i",time()) > '20' && date("i",time()) < '39')//USPS-USA单,已出库——使用模板3 每天早上8点半 触发发送【昨天早上7点-今天早上7点】出库的
  800. {
  801. $where .= "(express = '2' or express = '63' or express = '64') and librarytime > '".strtotime(date("Y-m-d 7:00:0",strtotime("-1 day")))."' and librarytime < '".strtotime(date("Y-m-d 7:00:0",time()))."'";
  802. $readid = 3;
  803. }
  804. else if(date("H",time()) == '21' && date("w",time()) != '0')//二、杭州联邦+杭州联邦-不报关,单独用一个模板—新模板2 每天晚上9点半 触发发送 【昨天晚上9:30——今天晚上9:30】出库的
  805. {
  806. if(date("w",time()) == '1')//周一执行:周六晚上9点半——周一晚上9点半 之间出库的
  807. {
  808. $where .= "(express = '24' or express = '31') and librarytime > '".strtotime(date("Y-m-d 21:00:0",strtotime("-2 day")))."' and librarytime < '".strtotime(date("Y-m-d 21:00:0",time()))."'";
  809. }
  810. else //周二到周六: 前一天晚上9点半——当天晚上9点半之间出库的
  811. {
  812. $where .= "(express = '24' or express = '31') and librarytime > '".strtotime(date("Y-m-d 21:00:0",strtotime("-1 day")))."' and librarytime < '".strtotime(date("Y-m-d 21:00:0",time()))."'";
  813. }
  814. $readid = 2;
  815. }
  816. else if(date("H",time()) == '19' && date("w",time()) != '0')//其他快递-使用模板1 DHL官方、UPS、DPEX 等系统里打印运单自动有运单号的,出库后当天晚上7点执行。
  817. {
  818. if(date("w",time()) == '1')//周一执行:周六晚上9点半——周一晚上9点半 之间出库的
  819. {
  820. $where .= "express != '2' and express != '24' and express != '31' and printtype = '1' and waybill != '' and librarytime > '".strtotime(date("Y-m-d 19:00:0",strtotime("-2 day")))."' and librarytime < '".strtotime(date("Y-m-d 19:00:0",time()))."'";
  821. }
  822. else //周二到周六: 前一天晚上9点半——当天晚上9点半之间出库的
  823. {
  824. $where .= "express != '2' and express != '24' and express != '31' and printtype = '1' and waybill != '' and librarytime > '".strtotime(date("Y-m-d 19:00:0",strtotime("-1 day")))."' and librarytime < '".strtotime(date("Y-m-d 19:00:0",time()))."'";
  825. }
  826. $readid = 1;
  827. }
  828. else
  829. {
  830. exit;
  831. }
  832. $dataorder = array();$datashop = array();$dataex = array();$datack = array();
  833. // 订单加入键值-k
  834. $fdata = $this->fullorder->find_all($where);//,'source,id,orderinfo,waybill,shop,express,type,msg,bname,state,client,name,phone,zipcode,address,email,shopify'
  835. //* 订单加入键值-j
  836. //* 店铺加入键值-j
  837. $fshop = $this->shop->find_all('1=1');
  838. foreach ($fshop as $v)
  839. {
  840. $datashop[$v['id']] = $v;
  841. }
  842. //* 店铺加入键值-k
  843. //* 快递加入键值-j
  844. $fex = $this->express->find_all('1=1');
  845. foreach ($fex as $v)
  846. {
  847. $dataex[$v['id']] = $v;
  848. }
  849. //* 快递加入键值-k
  850. //* 仓库加入键值-k
  851. $fwh = $this->warehouse->find_all('1=1');
  852. foreach ($fwh as $v)
  853. {
  854. $datack[$v['id']] = $v;
  855. }
  856. //* 仓库加入键值-j
  857. $i = 0;$j = 0;$ed = array();
  858. foreach ($fdata as $key=>$value)
  859. {
  860. if($value['source'] == 1)
  861. {
  862. $this->fullorder->save(array('dlz'=>3,'state'=>216),$value['id']);
  863. }
  864. else
  865. {
  866. $ddh = substr($value['orderinfo'],1);
  867. $ydh = $value['waybill'];
  868. $xg = $value;//此订单数据
  869. $shop = $datashop[$xg['shop']];//此订单店铺
  870. $ex = $dataex[$xg['express']];//此订单快递
  871. $warehouse = $datack[$xg['type']];//此订单仓库
  872. $shopifyid = $value['shopify'];
  873. if($xg['shop'] < 7)
  874. {
  875. $xg['iscode'] = $ex['title'];
  876. $xg['url'] = $shop['shopname'];
  877. @$fs = $this->api->get_paypal($xg);
  878. $this->afspaypal->insert(array('number'=>$xg['number'],'cs'=>$fs));
  879. }
  880. $ms = $this->message->find_all("express like '%,".$xg['express'].",%'");
  881. if(!isset($ms[0]))
  882. {
  883. $ms = $this->message->read(2);
  884. }
  885. else
  886. {
  887. $ms = $ms[0];
  888. }
  889. $shopname = $shop['brandname']; //店铺名
  890. $buyername = $xg['bname']; //Bill Name
  891. $email_call = $shop['shopid']; //发货人邮箱;
  892. $phone = $shop['shopphone']; //发货人电话
  893. $track_type = $ex['title']; //快递名称
  894. $service = $ex['title']; //快递追踪名称
  895. $track_link = $ex['url']; //快递查询网址
  896. $logistics_number = $ydh; //运单号
  897. $t= array('%buyername%','%email_call%','%track_type%','%service%','%track_link%','%logistics_number%','%shop%','%phone%','%jtime%');
  898. $h= array($buyername,$email_call,$track_type,$service,$track_link,$logistics_number,$shopname,$phone,$ex['yjtime']);
  899. $remark = str_replace($t,$h,$ms['content']);
  900. @$gx = $this->api->get_gx($ddh,$ydh,$xg,$shop,$ex,$remark,$shopifyid);
  901. if(!isset($gx['res']))
  902. {
  903. continue;
  904. }
  905. $this->fullorder->save(array('dlz'=>$gx['res'],'state'=>$gx['state']),$value['id']);
  906. }
  907. //sleep(4);
  908. }
  909. //同步更新 淘宝的运单号
  910. $this->_taobao();
  911. $this->_kcjc();
  912. }
  913. public function _taobao()
  914. {
  915. $data = $this->fullorder->find_all("shop = 19 and dlz != '3' and state = '207' and librarytime > 0");
  916. foreach ($data as $k=>$v)
  917. {
  918. $this->fullorder->save(array('dlz'=>3,'state'=>216),$v['id']);
  919. }
  920. }
  921. public function _kcjc()
  922. {
  923. $gethl = $this->whlabel->find_all("zd != '' and state = '0'");
  924. $b = array();
  925. foreach ($gethl as $k=>$v)
  926. {
  927. $a = $this->fullorder->get_number($v['zd']);
  928. if($a['librarytime'] > 0 && $a['library'] == 2)
  929. {
  930. //$b[] = array($v['sku'],$v['zd']);
  931. $this->whlabel->save(array('state'=>1,'orderinfo'=>$a['orderinfo'],'waybill'=>$a['waybill'],'outk'=>$a['librarytime'],'time'=>$a['librarytime']),$v['id']);
  932. }
  933. }
  934. }
  935. public function _waybillemail($arg_array)
  936. {
  937. $urls = array();$sl = 0;$time = time();
  938. /**
  939. if(date("H",time()) == '8' && date("i",time()) > '20' && date("i",time()) < '39')//USPS-USA单
  940. {
  941. $wid = 1;
  942. }
  943. else if(date("H",time()) == '22' && date("w",time()) != '0' && date("i",time()) > '20' && date("i",time()) < '39')//二、杭州联邦+杭州联邦-不报关
  944. {
  945. if(date("w",time()) == '1')//周一执行:周六晚上9点半——周一晚上9点半 之间出库的
  946. {
  947. $wid = 2;
  948. }
  949. else //周二到周六: 前一天晚上9点半——当天晚上9点半之间出库的
  950. {
  951. $wid = 3;
  952. }
  953. }
  954. else if(date("H",time()) == '20' && date("w",time()) != '0' && date("i",time()) > '20' && date("i",time()) < '39')//其他快递
  955. {
  956. if(date("w",time()) != '1')
  957. {
  958. $wid = 4;
  959. }
  960. else
  961. {
  962. $wid = 5;
  963. }
  964. }
  965. **/
  966. if(date("H",time()) == '8' && date("i",time()) > '20' && date("i",time()) < '39')//USPS-USA单
  967. {
  968. $wid = 1;
  969. }
  970. else if(date("H",time()) == '20' && date("i",time()) > '20' && date("i",time()) < '39')//其他快递
  971. {
  972. $wid = 2;
  973. }
  974. else
  975. {
  976. exit;
  977. }
  978. $notice = $this->notice->find_all("message = '1' and state = '1' and type = '4' and ktime < '$time' and jtime > '$time'");//已有自动发送,这个是物流发送
  979. foreach ($notice as $key=>$var)
  980. {
  981. $urls[] = array('url'=>'http://1.wepolicy.cn/api/waybillfs?v='.$var['id'],'data'=>array('var'=>$var,'wid'=>$wid));
  982. }
  983. foreach($urls as $value) {
  984. $ch = curl_init();
  985. $url = $value['url'];
  986. curl_setopt($ch,CURLOPT_URL,$url);
  987. curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
  988. curl_setopt($ch,CURLOPT_HEADER,0);
  989. curl_setopt($ch,CURLOPT_POST, 1);
  990. curl_setopt($ch,CURLOPT_TIMEOUT,1);
  991. //设置post数据
  992. $post = array();
  993. $post['data'] = $value['data'];
  994. curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($post));
  995. $res = curl_exec($ch);
  996. curl_close($ch);
  997. $sl++;
  998. }
  999. echo $sl;
  1000. echo "<pre>";
  1001. print_r($urls);
  1002. }
  1003. public function _waybillfs()
  1004. {
  1005. $post = $this->input->post(NULL, TRUE);
  1006. $data = $this->input->post('data',true);
  1007. if($data)
  1008. {
  1009. $notice = $data['var'];
  1010. $notice['email'] = $this->emaildata->read($notice['email']);
  1011. $wid = $data['wid'];
  1012. $fsjs = "";
  1013. if($wid == 1 && (stripos($notice['express'],',2,') !== false || stripos($notice['express'],',63,') !== false || stripos($notice['express'],',64,') !== false))
  1014. {
  1015. $js = explode(',',trim($notice['js'],','));
  1016. if(count($js) > 1)
  1017. {
  1018. $fsjs = " and (";
  1019. foreach ($js as $v)
  1020. {
  1021. $fsjs .= "js = '$v' or ";
  1022. }
  1023. $fsjs = trim($fsjs,' or ').")" ;
  1024. }
  1025. else if(count($js) == 1)
  1026. {
  1027. $fsjs = " and js = '$js[0]'";
  1028. }
  1029. $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
  1030. }
  1031. /**
  1032. else if($wid == 2 && stripos($notice['express'],',1,') !== false)
  1033. {
  1034. $where = "(express = '24' or express = '31') and librarytime > '".strtotime(date("Y-m-d 22:00:0",strtotime("-6 day")))."' and librarytime < '".strtotime(date("Y-m-d 22:00:0",time()))."'";//4
  1035. }
  1036. else if($wid == 3 && stripos($notice['express'],',1,') !== false)
  1037. {
  1038. $where = "(express = '24' or express = '31') and librarytime > '".strtotime(date("Y-m-d 22:00:0",strtotime("-6 day")))."' and librarytime < '".strtotime(date("Y-m-d 22:00:0",time()))."'";//3
  1039. }
  1040. else if($wid == 4 && stripos($notice['express'],',1,') !== false)
  1041. {
  1042. $where = "express != '2' and express != '24' and express != '31' 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()))."'";//3
  1043. }
  1044. else if($wid == 5 && stripos($notice['express'],',1,') !== false)
  1045. {
  1046. $where = "express != '2' and express != '24' and express != '31' 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
  1047. }
  1048. **/
  1049. else if($wid == 2 && stripos($notice['express'],',1,') !== false)
  1050. {
  1051. $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
  1052. }
  1053. else
  1054. {
  1055. exit;
  1056. }
  1057. $wlfs = array();
  1058. $dd = $this->fullorder->find_all("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
  1059. $this->logic_ding->sendToDing("获取发送快件的快递条件"."source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
  1060. foreach ($dd as $v)
  1061. {
  1062. $shop = $this->shop->read($v['shop']);
  1063. $express = $this->express->read($v['express']);
  1064. $fs = $this->notice->get_god($v,$shop,$express,$notice);
  1065. $this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】获取快递信息【".json_encode($notice,JSON_UNESCAPED_UNICODE)."】返回的信息".json_encode($fs));
  1066. if($fs == 1)
  1067. {
  1068. $this->fullorder->save(array('dlzemail'=>1,'dlzemailtime'=>time()),$v['id']);
  1069. //给crm发送信息 先存储数据 后续定时任务执行
  1070. if($v['shop'] < 10){
  1071. $this->zztmpdata->insert([
  1072. 'type'=>2,
  1073. 'act_name'=>'crm_order',
  1074. 'content'=>json_encode($v),
  1075. 'create_time'=>time()
  1076. ]);
  1077. }
  1078. }
  1079. else
  1080. {
  1081. //$pdtime = date('Y-m-d',time());
  1082. //$folderPath = './data/dlzemail/'.$pdtime; // 文件夹路径
  1083. //$permissions = 0777; // 权限设置
  1084. //if (!file_exists($folderPath)) { mkdir($folderPath, $permissions); }//创建文件夹
  1085. //file_exists($folderPath);
  1086. if(!is_file("./data/dlzemail/".$v['number'].".txt"))
  1087. {
  1088. $myfile = fopen("./data/dlzemail/".$v['number'].".txt", "w") or die("Unable to open file!");
  1089. fwrite($myfile, json_encode($fs.';'.$v.';'.$shop.';'.$express.';'.$notice));
  1090. fclose($myfile);
  1091. }
  1092. else
  1093. {
  1094. $myfile = fopen("./data/dlzemail/".$v['number'].".txt", "a+") or die("Unable to open file!");
  1095. fwrite($myfile, json_encode($fs.';'.$v.';'.$shop.';'.$express.';'.$notice));
  1096. fclose($myfile);
  1097. }
  1098. $this->fullorder->save(array('dlzemail'=>2,'dlzemailtime'=>time()),$v['id']);
  1099. }
  1100. sleep(50);
  1101. }
  1102. }
  1103. }
  1104. /**
  1105. //更新独立站运单信息
  1106. public function _waybill($arg_array)
  1107. {
  1108. //这里订单索引需要修改 8点是出已打印已出库 11点是已打印未出库
  1109. if(!isset($arg_array[0]) || !isset($arg_array[1]))
  1110. {
  1111. exit;
  1112. }
  1113. if(date("w",time()) == '0' && $arg_array[0] != '3')//非usps周日不更新
  1114. {
  1115. echo 7;exit;
  1116. }
  1117. if($arg_array[0] == 3)
  1118. {
  1119. $argarray = 2;
  1120. $typec = ' and express = 2 and printtime > "'.strtotime("-3 day").'"';//更新usps-usa快递的订单
  1121. }
  1122. else
  1123. {
  1124. $argarray = $arg_array[0];
  1125. $typec = ' and librarytime > "'.strtotime(date("Y-m-d 16:30:0",strtotime("-5 day"))).'" and librarytime < "'.strtotime(date("Y-m-d 18:0:0",time())).'"';//更新快递的订单
  1126. }
  1127. $dataorder = array();$datashop = array();$dataex = array();$datack = array();
  1128. // 订单加入键值-k
  1129. $fdata = $this->fullorder->find_all('state = "207" and print = "3" and dlz < "1" and libraryconfirm = "2" and library = "'.$argarray.'" and waybill != ""'.$typec,'source,id,orderinfo,waybill,shop,express,type,msg,bname,state,client,name,phone,zipcode,address,email');
  1130. //* 订单加入键值-j
  1131. //* 店铺加入键值-j
  1132. $fshop = $this->shop->find_all('1=1');
  1133. foreach ($fshop as $v)
  1134. {
  1135. $datashop[$v['id']] = $v;
  1136. }
  1137. //* 店铺加入键值-k
  1138. //* 快递加入键值-j
  1139. $fex = $this->express->find_all('1=1');
  1140. foreach ($fex as $v)
  1141. {
  1142. $dataex[$v['id']] = $v;
  1143. }
  1144. //* 快递加入键值-k
  1145. //* 仓库加入键值-k
  1146. $fwh = $this->warehouse->find_all('1=1');
  1147. foreach ($fwh as $v)
  1148. {
  1149. $datack[$v['id']] = $v;
  1150. }
  1151. //* 仓库加入键值-j
  1152. //$fs = $this->notice->get_ordertatus(216);//216成功状态
  1153. $i = 0;$j = 0;$ed = array();
  1154. foreach ($fdata as $key=>$value)
  1155. {
  1156. if($value['source'] == 1)
  1157. {
  1158. $this->fullorder->save(array('dlz'=>3,'state'=>216),$value['id']);
  1159. }
  1160. else
  1161. {
  1162. $ddh = substr($value['orderinfo'],1);
  1163. $ydh = $value['waybill'];
  1164. $xg = $value;//此订单数据
  1165. $shop = $datashop[$xg['shop']];//此订单店铺
  1166. $ex = $dataex[$xg['express']];//此订单快递
  1167. $warehouse = $datack[$xg['type']];//此订单仓库
  1168. //独立站地址更新订单状态、物流信息
  1169. if($arg_array[0] == 1)//23点更新用留言2
  1170. {
  1171. $readid = 2;
  1172. }
  1173. else if($arg_array[0] == 3)//7点更新用留言3
  1174. {
  1175. $readid = 3;
  1176. }
  1177. else //20点更新用默认留言(默认留言为1)
  1178. {
  1179. $readid = $xg['msg'];
  1180. }
  1181. @$gx = $this->api->get_gx($ddh,$ydh,$xg,$shop,$ex,$readid);
  1182. if(!isset($gx['res']))
  1183. {
  1184. exit;
  1185. }
  1186. $this->fullorder->save(array('dlz'=>$gx['res'],'state'=>$gx['state']),$xg['id']);
  1187. }
  1188. //if($gx['res'] == 1 && $fs)
  1189. //{
  1190. // $ck = $this->_email($fs['content'],$xg,$warehouse['company']);
  1191. //}
  1192. sleep(2);//停留2秒
  1193. }
  1194. }
  1195. **/
  1196. public function _headgear($arg_array)
  1197. {
  1198. $ip = $this->input->ip_address();
  1199. if(!isset($arg_array[0]) || !isset($arg_array[1]))
  1200. {
  1201. exit;
  1202. }
  1203. if(!is_numeric($arg_array[0]) || !is_numeric($arg_array[1]))
  1204. {
  1205. exit;
  1206. }
  1207. $where = 'printtime > "'.strtotime(date('Y-m-d',$arg_array[0])).'" and print = 3 and library = 1 and (type = 4 or type = 13 or type = 11 or type = 12 or type = 16)';//(type = 4 or type = 7)
  1208. if($arg_array[1] == 1)
  1209. {
  1210. $data = $this->fullordersmt->find_all($where,'express,number,orderinfo,shipremarks,printtime');
  1211. }
  1212. else
  1213. {
  1214. $data = $this->fullorder->find_all($where,'express,number,orderinfo,shipremarks,printtime');
  1215. }
  1216. foreach ($data as $k=>$v)
  1217. {
  1218. $express = $this->express->read($v['express']);
  1219. $data[$k]['express'] = $express['servicename'];
  1220. if($data[$k]['printtime'] > 0)
  1221. {
  1222. $data[$k]['printtime'] = date('Y-m-d H:i:s',$v['printtime']);
  1223. }
  1224. }
  1225. //$state = $this->api->get_headgear($data);
  1226. echo json_encode($data);
  1227. }
  1228. public function _kc_old()
  1229. {
  1230. $post = $this->input->post(NULL, TRUE);
  1231. if(isset($post['sku']))
  1232. {
  1233. $sku = $this->input->post('sku',true);
  1234. $warehouse = $this->warehouse->find_all();
  1235. $data = array();
  1236. foreach ($sku as $val)
  1237. {
  1238. $datasku = array();
  1239. foreach ($warehouse as $v)
  1240. {
  1241. $z = $this->whlabel->find_count('sku = "'.$val.'" and zd = "" and state = 0 and warehouse = "'.$v['id'].'"');
  1242. $datasku[] = array('name'=>$v['title'],'number'=>$z);
  1243. }
  1244. $data[$val] = $datasku;
  1245. }
  1246. }
  1247. echo json_encode($data);
  1248. }
  1249. public function _kc()
  1250. {
  1251. $datasku = array();
  1252. $info_list = $this->whlabel->find_pc("warehouse = '5'",'sku,features,warehouse','sku');
  1253. foreach ($info_list as $val)
  1254. {
  1255. $z = $this->whlabel->find_count('sku = "'.$val['sku'].'" and zd = "" and state = 0 and warehouse = "5"');
  1256. $datasku[] = array('sku'=>$val['sku'],'number'=>$z);
  1257. }
  1258. echo json_encode($datasku);
  1259. }
  1260. public function _fsstate()//订单消息页手动发送
  1261. {
  1262. $post = $this->input->post(NULL, TRUE);
  1263. if(isset($post['s']))
  1264. {
  1265. $id_arr = $this->input->post('s');
  1266. $notice = $this->input->post('notice');
  1267. $noticeid = $this->input->post('noticeid');
  1268. $id_arr = explode(',',trim($id_arr,','));
  1269. if(!$id_arr)
  1270. {
  1271. echo json_encode(array('msg'=>'参数错误!','success'=>false));exit;
  1272. }
  1273. if($notice == '1' || $notice == '')
  1274. {
  1275. foreach ($id_arr as $v)
  1276. {
  1277. $data = $this->fullorder->read($v);
  1278. $adrs = $this->customer->get_email($data['email'],$data['shop']);
  1279. //$lkh = ($adrs['type'] == 1)?1:2;//白名单1黑名单2
  1280. $lkh = 1;
  1281. $pdlkh = ($adrs['num'] > 1)?1:0;//判断是否老客户
  1282. $fs = $this->_znxc($data,$data['orderinfo'],$lkh,$pdlkh);
  1283. if($fs == 1)
  1284. {
  1285. $this->fullorder->save(array('exstateerror'=>''),$data['id']);
  1286. }
  1287. sleep(40);
  1288. }
  1289. }
  1290. else
  1291. {
  1292. foreach ($id_arr as $v)
  1293. {
  1294. $data = $this->fullorder->read($v);
  1295. $fs = $this->_sdfs($data,$noticeid);
  1296. sleep(40);
  1297. }
  1298. }
  1299. echo json_encode(array('msg'=>'发送完成!','id'=>$id_arr,'success'=>true));exit;
  1300. }
  1301. }
  1302. public function _fswaybillemail()//运单号通知页手动发送
  1303. {
  1304. $post = $this->input->post(NULL, TRUE);
  1305. if(isset($post['s']))
  1306. {
  1307. $time = time();
  1308. $id_arr = $this->input->post('s');
  1309. $id_arr = explode(',',trim($id_arr,','));
  1310. if(!$id_arr)
  1311. {
  1312. echo json_encode(array('msg'=>'参数错误!','success'=>false));exit;
  1313. }
  1314. foreach ($id_arr as $v)
  1315. {
  1316. $d = $this->fullorder->read($v);
  1317. $shop = $this->shop->read($d['shop']);
  1318. $ex = $this->express->read($d['express']);
  1319. $fs = $this->notice->find_all("shop = '".$d['shop']."' and message = '1' and state = '1' and type = '4' and ktime < '$time' and jtime > '$time'");
  1320. $fs = $fs[0];
  1321. $fs['email'] = $this->emaildata->read($fs['email']);
  1322. $ck = $this->notice->get_god($d,$shop,$ex,$fs);
  1323. if($ck == 1)
  1324. {
  1325. $this->fullorder->save(array('dlzemail'=>1,'dlzemailtime'=>time()),$v);
  1326. }
  1327. sleep(1);
  1328. }
  1329. echo json_encode(array('msg'=>'发送完成!请检查是否成功','id'=>$id_arr,'success'=>true));exit;
  1330. }
  1331. }
  1332. /**
  1333. public function _fsstate()//订单消息页手动发送 _znxc 针对模板对应类型发送
  1334. {
  1335. $post = $this->input->post(NULL, TRUE);
  1336. if(isset($post['s']))
  1337. {
  1338. $id_arr = $this->input->post('s');
  1339. $id_arr = explode(',',$id_arr);
  1340. if(!$id_arr)
  1341. {
  1342. echo json_encode(array('msg'=>'参数错误!','success'=>false));exit;
  1343. }
  1344. foreach ($id_arr as $v)
  1345. {
  1346. $data = $this->fullorder->read($v);
  1347. $adrs = $this->customer->get_email($data['email'],$data['shop']);
  1348. $lkh = ($adrs['type'] == 1)?1:2;//白名单1黑名单2
  1349. $fs = $this->_znxc($data,$data['orderinfo'],$lkh);
  1350. if($fs == 1)
  1351. {
  1352. $this->fullorder->save(array('exstateerror'=>''),$data['id']);
  1353. }
  1354. }
  1355. echo json_encode(array('msg'=>'发送完成!','id'=>$id_arr[0],'success'=>true));exit;
  1356. }
  1357. }
  1358. **/
  1359. public function _cangku()
  1360. {
  1361. $post = $this->input->post(NULL, TRUE);
  1362. if(isset($post['tk']))
  1363. {
  1364. $tk = $this->input->post('tk');
  1365. $tj = $this->input->post('tj');
  1366. $d = $this->fullorder->find_all("dtime > '$tk' and dtime < '$tj'");
  1367. $k = $this->customer->find_all("time > '$tk' and time < '$tj'");
  1368. echo json_encode(array('d'=>$d,'k'=>$k));exit;
  1369. }
  1370. }
  1371. public function _znxc($fullorder,$order_id,$lkh,$pdlkh,$hmdid='')
  1372. {
  1373. $time = time();
  1374. $sl = explode(';',$fullorder['quantity']);
  1375. $quantity = 0;
  1376. foreach ($sl as $v)
  1377. {
  1378. if($v > 1)
  1379. {
  1380. $quantity = 1;
  1381. }
  1382. }
  1383. $fid = $this->fullorder->get_orderinfo($order_id);
  1384. if($lkh == 2 || (count($sl) > 1 && $quantity == 1) || stripos($fullorder['address'],'PO ') !== false || stripos($fullorder['address'],'P.O.') !== false || stripos($fullorder['address'],'P. O.') !== false || stripos($fullorder['address'],'PO.') !== false || stripos($fullorder['address'],'P.O') !== false || stripos($fullorder['address'],' APO ') !== false)//如果是黑名单客户、多产品的、有用户留言的、包含PO BOX、包含APO //留言的正常发$fullorder['clientremarks'] != '' ||
  1385. {
  1386. $asdasd = 0;
  1387. if($lkh == 2)
  1388. {
  1389. $asdasd = 1;
  1390. }
  1391. if(count($sl) > 1 && $quantity == 1)
  1392. {
  1393. $asdasd = 2;
  1394. }
  1395. if(stripos($fullorder['address'],'PO ') !== false || stripos($fullorder['address'],'P.O.') !== false || stripos($fullorder['address'],'P. O.') !== false || stripos($fullorder['address'],'PO.') !== false || stripos($fullorder['address'],'P.O') !== false || stripos($fullorder['address'],' APO ') !== false)
  1396. {
  1397. $asdasd = 3;
  1398. }
  1399. $this->fullorder->save(array('content'=>$fid['content'].'黑名单客户、多产品的、包含PO BOX、包含APO的不发送-'.$asdasd.(($hmdid)?'['.$hmdid.']':''),'zdstate'=>$fid['zdstate'].'1-x|'),$fid['id']);//留言的现在正常发
  1400. return 'a';
  1401. }
  1402. else
  1403. {
  1404. if(count($sl) == '1' && $fullorder['quantity'] > 1)//如果item(产品)是1,但quantity大于等于2
  1405. {
  1406. $tab = 2;
  1407. }
  1408. else if($fullorder['shouldmoney'] > '400' && $fullorder['guarantee'] == 'Ineligible')//如果金额大于400美元并且无卖家保障
  1409. {
  1410. $tab = 1;
  1411. }
  1412. /**
  1413. else if(count($sl) == '1' && $fullorder['quantity'] > 1 && $fullorder['baddress'] != $fullorder['saddress'])//如果item(产品)是1,但quantity大于等于2并且Bill Address不等于Ship Address
  1414. {
  1415. $tab = 4;
  1416. }
  1417. else if($fullorder['baddress'] != $fullorder['saddress'])//如果Bill Address不等于Ship Address
  1418. {
  1419. $tab = 3;
  1420. }
  1421. **/
  1422. else//常规模板
  1423. {
  1424. $tab = 0;
  1425. }
  1426. $notice = $this->notice->find_all("shop = '".$fullorder['shop']."' and ordertatus = '".$fullorder['state']."' and tab = '$tab' and message = '1' and state = '1' and ktime < '$time' and jtime > '$time'");//有条件不同模板匹配
  1427. if(isset($notice[0]['content']))
  1428. {
  1429. if($pdlkh == '1' && $notice[0]['thq'] != ''&& $notice[0]['thh'] != '')//非常规和老客户模板,如果是老客户并且需要替换的话
  1430. {
  1431. $notice[0]['content'] = str_replace($notice[0]['thq'],$notice[0]['thh'],$notice[0]['content']);
  1432. }
  1433. $shop = $this->shop->read($fullorder['shop']);
  1434. //$express = $this->express->read($fullorder['express']);
  1435. //$service = $this->service->read($express['service']);
  1436. $country = $this->country->read($fullorder['country']);
  1437. $fullorder['country'] = $country['ename'];
  1438. //$express['servicename'] =$service['title'];//增加快递名称
  1439. $express = array();
  1440. $notice[0]['email'] = $this->emaildata->read($notice[0]['email']);
  1441. $go = $this->notice->get_god($fullorder,$shop,$express,$notice[0]);
  1442. if($go == 1)
  1443. {
  1444. $this->fullorder->save(array('content'=>$fid['content'].'自动发送-成功;','zdstate'=>$fid['zdstate'].$notice[0]['type'].'-'.$notice[0]['tab'].'|','exstateerror'=>''),$fid['id']);
  1445. return 1;
  1446. }
  1447. else
  1448. {
  1449. $this->fullorder->save(array('exstateerror'=>'自动发送失败1:'.date('Y-m-d H',time()).'-'.$go.'('.$notice[0]['type'].'-'.$notice[0]['message'].')'),$fid['id']);
  1450. }
  1451. }
  1452. else
  1453. {
  1454. $this->fullorder->save(array('exstateerror'=>'当前订单状态无匹配模板'),$fid['id']);
  1455. }
  1456. }
  1457. }
  1458. public function _sdfs($fullorder,$id)//手动发送信息
  1459. {
  1460. $time = time();
  1461. $notice = $this->notice->read($id);//无条件同模板匹配
  1462. $notice['email'] = $this->emaildata->read($notice['email']);
  1463. $shop = $this->shop->read($fullorder['shop']);
  1464. $express = $this->express->read($fullorder['express']);
  1465. if($notice['type'] == '1')
  1466. {
  1467. $fslx = 'tab';
  1468. $content = '自动发送';
  1469. $stripos = '1-';
  1470. }
  1471. else if ($notice['type'] == '2')
  1472. {
  1473. $fslx = 'logisticstatus';
  1474. $content = $notice['title'];
  1475. $stripos = $notice['type'].'-'.$notice[$fslx].'|';
  1476. }
  1477. if(stripos($fullorder['zdstate'],$stripos) === false && $fullorder['wltype'] == '0')//如果没发送过并且允许发送
  1478. {
  1479. $go = $this->notice->get_god($fullorder,$shop,$express,$notice);
  1480. if($go == 1)
  1481. {
  1482. if($notice['type'] == '1')
  1483. {
  1484. $this->fullorder->save(array('content'=>$fullorder['content'].$content.'-成功;','zdstate'=>$fullorder['zdstate'].$notice['type'].'-'.$notice[$fslx].'|','exstateerror'=>'','wlerror'=>''),$fullorder['id']);
  1485. }
  1486. else if ($notice['type'] == '2')
  1487. {
  1488. $this->fullorder->save(array('wlcontent'=>$fullorder['wlcontent'].$content.'-成功;','wlfstime'=>time(),'zdstate'=>$fullorder['zdstate'].$notice['type'].'-'.$notice[$fslx].'|','exstateerror'=>'','wlerror'=>''),$fullorder['id']);
  1489. }
  1490. return 1;
  1491. }
  1492. else
  1493. {
  1494. if($notice['type'] == '1')
  1495. {
  1496. $this->fullorder->save(array('exstateerror'=>$content.'发送失败1:'.date('Y-m-d H',time()).'-'.$go.'('.$notice['type'].'-'.$notice[$fslx].')'),$fullorder['id']);
  1497. }
  1498. else if ($notice['type'] == '2')
  1499. {
  1500. $this->fullorder->save(array('wlerror'=>$content.'发送失败2:'.date('Y-m-d H',time()).'-'.$go.'('.$notice['type'].'-'.$notice[$fslx].')'),$fullorder['id']);
  1501. }
  1502. }
  1503. }
  1504. }
  1505. public function _zz()
  1506. {
  1507. //$f = $this->fullorder->find_all("1=1",'wlfstime','wlfstime desc',0,2);
  1508. if(date("w") == '0')
  1509. {
  1510. exit;
  1511. }
  1512. $f17 = array();
  1513. $time = time();
  1514. $tjlike = array();
  1515. $urls = array();$sl = 0;
  1516. $notice = $this->notice->find_all("message = '1' and state = '1' and type = '2' and ktime < '$time' and jtime > '$time'");//已有自动发送,这个是物流发送
  1517. foreach ($notice as $key=>$var)
  1518. {
  1519. $urls[] = array('url'=>'http://a'.rand(10,50).'.wepolicy.cn/api/wlfs?v='.$var['id'],'data'=>array('where'=>array('shop'=>$var['shop'],'expressstate'=>$var['logisticstatus'],'wlcontent'=>$var['title']),'var'=>$var));
  1520. }
  1521. foreach($urls as $value) {
  1522. $tjlike[] = $value['url'];
  1523. $ch = curl_init();
  1524. $url = $value['url'];
  1525. curl_setopt($ch,CURLOPT_URL,$url);
  1526. curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
  1527. curl_setopt($ch,CURLOPT_HEADER,0);
  1528. curl_setopt($ch,CURLOPT_POST, 1);
  1529. curl_setopt($ch,CURLOPT_TIMEOUT,5);
  1530. //设置post数据
  1531. $post = array();
  1532. $post['data'] = $value['data'];
  1533. curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($post));
  1534. $res = curl_exec($ch);
  1535. curl_close($ch);
  1536. $sl++;
  1537. }
  1538. echo "<pre>";
  1539. print_r($tjlike);
  1540. echo $sl;
  1541. /**
  1542. $urls = array();
  1543. $notice = $this->notice->find_all("message = '1' and state = '1' and type = '2' and ktime < '$time' and jtime > '$time'");//已有自动发送,这个是物流发送
  1544. foreach ($notice as $key=>$var)
  1545. {
  1546. $urls[] = array('url'=>'http://1.wepolicy.cn/api/wlfs?v='.$var['id'],'data'=>array('where'=>array('shop'=>$var['shop'],'expressstate'=>$var['logisticstatus'],'wlcontent'=>$var['title']),'var'=>$var));
  1547. }
  1548. $mh = curl_multi_init();
  1549. $urlHandlers = array();
  1550. $urlData = array();
  1551. // 初始化多个请求句柄为一个
  1552. foreach($urls as $value) {
  1553. $ch = curl_init();
  1554. $url = $value['url'];
  1555. $url .= strpos($url, '?') ? '&' : '?';
  1556. curl_setopt($ch, CURLOPT_URL, $url);
  1557. // 设置数据通过字符串返回,而不是直接输出
  1558. curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  1559. curl_setopt($ch,CURLOPT_HEADER,0);
  1560. curl_setopt($ch,CURLOPT_POST, 1);
  1561. $post = array();
  1562. $post['data'] = $value['data'];
  1563. curl_setopt($ch,CURLOPT_POSTFIELDS,http_build_query($post));
  1564. $urlHandlers[] = $ch;
  1565. curl_multi_add_handle($mh, $ch);
  1566. }
  1567. $active = null;
  1568. // 检测操作的初始状态是否OK,CURLM_CALL_MULTI_PERFORM为常量值-1
  1569. do {
  1570. // 返回的$active是活跃连接的数量,$mrc是返回值,正常为0,异常为-1
  1571. $mrc = curl_multi_exec($mh, $active);
  1572. } while ($mrc == CURLM_CALL_MULTI_PERFORM);
  1573. // 如果还有活动的请求,同时操作状态OK,CURLM_OK为常量值0
  1574. while ($active && $mrc == CURLM_OK) {
  1575. // 持续查询状态并不利于处理任务,每60ms检查一次,此时释放CPU,降低机器负载
  1576. usleep(50000);
  1577. // 如果批处理句柄OK,重复检查操作状态直至OK。select返回值异常时为-1,正常为1(因为只有1个批处理句柄)
  1578. if (curl_multi_select($mh) != -1) {
  1579. do {
  1580. $mrc = curl_multi_exec($mh, $active);
  1581. } while ($mrc == CURLM_CALL_MULTI_PERFORM);
  1582. }
  1583. }
  1584. // 获取返回结果
  1585. foreach($urlHandlers as $index => $ch) {
  1586. $urlData[$index] = curl_multi_getcontent($ch);
  1587. // 移除单个curl句柄
  1588. curl_multi_remove_handle($mh, $ch);
  1589. }
  1590. curl_multi_close($mh);
  1591. print_r($urlData);
  1592. **/
  1593. /**
  1594. $notice = $this->notice->find_all("message = '1' and state = '1' and type = '2' and ktime < '$time' and jtime > '$time'");//已有自动发送,这个是物流发送
  1595. foreach ($notice as $key=>$var)
  1596. {
  1597. $where = "shop = '".$var['shop']."' and waybill != '' and library = '2' and expressstate <= '".$var['logisticstatus']."' and librarytime > '".(time()-15*24*3600)."' and wlcontent not like '%".$var['title']."%'";//正式发送的时候开启这个"'
  1598. //$where = "shop = '2' and waybill != '' and library = '2' and librarytime > '".(time()-15*24*3600)."'";
  1599. $ch = curl_init();
  1600. curl_setopt($ch,CURLOPT_URL,'http://'.$_SERVER['HTTP_HOST'].'/api/wlfs?v='.$var['id']);
  1601. curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
  1602. curl_setopt($ch,CURLOPT_HEADER,0);
  1603. curl_setopt($ch,CURLOPT_POST, 1);
  1604. curl_setopt($ch,CURLOPT_TIMEOUT,1);
  1605. //设置post数据
  1606. $post = array();
  1607. $post['data'] = array('where'=>$where,'var'=>$var);
  1608. curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($post));
  1609. $res = curl_exec($ch);
  1610. curl_close($ch);
  1611. //$this->_wlfs($where,$var);
  1612. }
  1613. **/
  1614. /**
  1615. $var = $this->notice->read(63);//已有自动发送,这个是物流发送
  1616. $where = "shop = '".$var['shop']."' and waybill != '' and library = '2' and expressstate <= '".$var['logisticstatus']."' and librarytime > '".(time()-15*24*3600)."' and wlcontent not like '%".$var['title']."%'";//正式发送的时候开启这个"'
  1617. $this->_wlfs($where,$var);
  1618. **/
  1619. }
  1620. public function _wlfs()
  1621. {
  1622. $webhookregister = 0;
  1623. $post = $this->input->post(NULL, TRUE);
  1624. $data = $this->input->post('data',true);
  1625. $where = $data['where'];
  1626. $var = $data['var'];
  1627. $wlfs = array();
  1628. $shopid = $where['shop'];
  1629. @$this->allocation->insert(array('title'=>date('Y-m-d',time()).'-'.$shopid));
  1630. $where = "shop = '".$where['shop']."' and waybill != '' and library = '2' and expressstate <= '".$where['expressstate']."' and librarytime > '".(time()-22*24*3600)."' and wlcontent not like '%".$where['wlcontent']."%'";//正式发送的时候开启这个"'
  1631. //$where = "shop = '".$where['shop']."' and waybill != '' and library = '2' and express = '3' and librarytime > '1636300800' and wlcontent not like '%".$where['wlcontent']."%'";//正式发送的时候开启这个"'
  1632. $data = $this->fullorder->find_all($where);
  1633. $csck = array();
  1634. foreach ($data as $k=>$v)
  1635. {
  1636. //$this->logic_ding->sendToDing("获取订单的物流信息".$v['number']);
  1637. $vexpress = $v['express'];
  1638. $shop = $this->shop->read($v['shop']);
  1639. $express = $this->express->read($v['express']);
  1640. $service = $this->service->read($express['service']);
  1641. $country = $this->country->read($v['country']);
  1642. $v['country'] = $country['ename'];
  1643. $express['servicename'] =$service['title'];//增加快递名称
  1644. $v['cxcode'] = strtolower($express['cxcode']);//增加快递服务商码
  1645. if($v['expressstate'] == $var['logisticstatus'] && $v['wlyc'] == '0' && $v['wltype'] != '1' && $v['source'] != '1')//获取快递状态等于模板状态、订单状态等于模板状态、出库时间大于-、未加入物流异常、允许发送邮件状态、非线下单
  1646. {
  1647. if($v['shop'] < '7')// && $v['shouldmoney'] > 100)
  1648. {
  1649. $wlfs[] = array('v'=>$v,'id'=>$var['id']);
  1650. //$go = $this->_sdfs($v,$var['id']);//更新顺带发送
  1651. }
  1652. continue;
  1653. }
  1654. if(($express['cxcode'] == '' && $v['exstateerror'] == '') || ($express['cxcode'] == '' && $v['exstateerror'] != ''))
  1655. {
  1656. continue;
  1657. }
  1658. else if($express['cxcode'] == 'usps')//$express['cxcode'] == 'fedex' || $express['cxcode'] == 'dhl' || $express['cxcode'] == 'cne' || $express['cxcode'] == 'dpex' || $express['cxcode'] == 'dpd'
  1659. {
  1660. /**
  1661. if($express['cxcode'] == 'dpex' || $express['cxcode'] == 'dpd')
  1662. {
  1663. $express['cxcode'] = 'cne';
  1664. }
  1665. **/
  1666. $logistics = $express['cxcode'];
  1667. }
  1668. else if(($express['cxcode'] == 'ups' && $v['webhookregister'] == 1) || $express['cxcode'] == '17track')
  1669. {
  1670. continue;
  1671. }
  1672. else if($express['cxcode'] == 'ups' && $v['webhookregister'] < 1)//使用webhook注册模式 || $express['cxcode'] == '17track'
  1673. {
  1674. $logistics = $express['cxcode'];
  1675. $webhookregister = 1;
  1676. }
  1677. else
  1678. {
  1679. //暂时不启用第三方,这里直接跳出
  1680. $this->fullorder->save(array('expressstate'=>'99'),$v['id']);
  1681. continue;
  1682. //$logistics = 'apismt';
  1683. //$v['express'] = strtolower($express['cxcode']);//替换为快递服务商码
  1684. }
  1685. $this->logic_ding->sendToDing("检测是否检测--".$v['number']."--执行的轨迹追踪信息--".$logistics);
  1686. $v['servicename'] =$service['title'];//增加快递名称
  1687. $v['url'] = $express['url'];//增加快递链接
  1688. @$fs = $this->$logistics->get_logistics($v);
  1689. $csck[] = array($v['number'],$fs['f'],$fs['content']);
  1690. if(!isset($fs['f']))
  1691. {
  1692. $fs = $this->$logistics->get_logistics($v);
  1693. if(!isset($fs['f']))
  1694. {
  1695. continue;
  1696. }
  1697. if($fs['f'] == '1')
  1698. {
  1699. $v['express'] = $vexpress;
  1700. if($fs['exstate'] > $v['expressstate'] || isset($fs['webhookregister']))
  1701. {
  1702. $this->fullorder->save(array('expressstate'=>$fs['exstate'],'excontent'=>$fs['data'],'webhookregister'=>$webhookregister,'wlerror'=>''),$v['id']);
  1703. }
  1704. if($fs['exstate'] == $var['logisticstatus'] && $v['wlyc'] == '0' && $v['wltype'] != '1' && $v['source'] != '1')//获取快递状态等于模板状态、订单状态等于模板状态、出库时间大于-、未加入物流异常、允许发送邮件状态、非线下单
  1705. {
  1706. if($v['shop'] < '7')// && $v['shouldmoney'] > 100)
  1707. {
  1708. $wlfs[] = array('v'=>$v,'id'=>$var['id']);
  1709. //$go = $this->_sdfs($v,$var['id']);//更新顺带发送
  1710. }
  1711. }
  1712. }
  1713. /**
  1714. if($logistics == 'apismt')//第三方未购买,第三方查询直接进入无法查询状态
  1715. {
  1716. $this->fullorder->save(array('expressstate'=>'99'),$v['id']);
  1717. }
  1718. **/
  1719. }
  1720. else
  1721. {
  1722. if($fs['f'] == '1')
  1723. {
  1724. $v['express'] = $vexpress;
  1725. if($fs['exstate'] > $v['expressstate'] || isset($fs['webhookregister']))
  1726. {
  1727. $this->fullorder->save(array('expressstate'=>$fs['exstate'],'excontent'=>$fs['data'],'webhookregister'=>$webhookregister,'wlerror'=>''),$v['id']);
  1728. }
  1729. if($fs['exstate'] == $var['logisticstatus'] && $v['wlyc'] == '0' && $v['wltype'] != '1' && $v['source'] != '1')//获取快递状态等于模板状态、订单状态等于模板状态、出库时间大于-、未加入物流异常、允许发送邮件状态、非线下单
  1730. {
  1731. if($v['shop'] < '7')// && $v['shouldmoney'] > 100)
  1732. {
  1733. $wlfs[] = array('v'=>$v,'id'=>$var['id']);
  1734. //$go = $this->_sdfs($v,$var['id']);//更新顺带发送
  1735. }
  1736. }
  1737. }
  1738. else
  1739. {
  1740. $this->fullorder->save(array('wlerror'=>$fs['content']),$v['id']);
  1741. }
  1742. }
  1743. }
  1744. @$this->allocation->insert(array('title'=>$shopid.'-'.json_encode($csck)));
  1745. if($wlfs)
  1746. {
  1747. foreach ($wlfs as $k=>$v)
  1748. {
  1749. $t1 = microtime(true);
  1750. $this->_sdfs($v['v'],$v['id']);
  1751. $t2 = microtime(true);
  1752. $t3 = (40-($t2-$t1) < 1)?1:round(40-($t2-$t1));
  1753. sleep($t3);
  1754. }
  1755. }
  1756. }
  1757. public function _zzold()
  1758. {
  1759. $data = $this->fullorder->find_all("library = '2' and waybill != '' and exstate != '4' and exstate != '5' and dtime > '1580486400'");
  1760. foreach ($data as $k=>$v)
  1761. {
  1762. $shop = $this->shop->read($v['shop']);
  1763. $express = $this->express->read($v['express']);
  1764. $service = $this->service->read($express['service']);
  1765. $country = $this->country->read($v['country']);
  1766. $v['country'] = $country['ename'];
  1767. $express['servicename'] =$service['title'];//增加快递名称
  1768. if($express['cxcode'] == '' && $v['exstateerror'] == '')
  1769. {
  1770. continue;
  1771. }
  1772. else if($express['cxcode'] == '' && $v['exstateerror'] != '')
  1773. {
  1774. continue;
  1775. }
  1776. else if($express['cxcode'] == 'fedex' || $express['cxcode'] == 'usps' || $express['cxcode'] == 'dhl' || $express['cxcode'] == 'cne' || $express['cxcode'] == 'dpex' || $express['cxcode'] == 'dpd')
  1777. {
  1778. $logistics = $express['cxcode'];
  1779. }
  1780. else
  1781. {
  1782. $logistics = 'apismt';
  1783. }
  1784. $v['express'] = strtolower($express['cxcode']);//替换为快递服务商码
  1785. $v['servicename'] =$service['title'];//增加快递名称
  1786. $v['url'] = $express['url'];//增加快递链接
  1787. $fs = $this->$logistics->get_logistics($v);
  1788. if(!isset($fs['f']))
  1789. {
  1790. $this->fullorder->save(array('exstate'=>'99'),$v['id']);
  1791. }
  1792. else
  1793. {
  1794. if($fs['f'] == '0')
  1795. {
  1796. $this->fullorder->save(array('excontent'=>$fs['content']),$v['id']);
  1797. }
  1798. if($fs['f'] == '2')
  1799. {
  1800. }
  1801. else
  1802. {
  1803. $this->fullorder->save(array('exstate'=>$fs['exstate'],'excontent'=>$fs['data']),$v['id']);
  1804. }
  1805. }
  1806. }
  1807. }
  1808. public function _query()
  1809. {
  1810. header('Access-Control-Allow-Origin: *');
  1811. $post = $this->input->post(NULL, TRUE);
  1812. if(isset($post['orderinfo']))
  1813. {
  1814. $list = array();
  1815. $orderinfo = $this->input->post('orderinfo',true);
  1816. $orderinfo = explode(',',trim($orderinfo,','));
  1817. foreach ($orderinfo as $v)
  1818. {
  1819. $exp="/^([0-9A-Za-z\\-_\\.]+)@([0-9a-z]+\\.[a-z]{2,3}(\\.[a-z]{2})?)$/i";
  1820. if(is_numeric($v) && mb_strlen($v) > 8)
  1821. {
  1822. $w = "orderinfo like '%$v%'";
  1823. }
  1824. else if(filter_var($v, FILTER_VALIDATE_EMAIL))
  1825. {
  1826. $w = "email like '%$v%'";
  1827. }
  1828. else
  1829. {
  1830. echo json_encode(array('site'=>0,'success'=>true));exit;
  1831. }
  1832. $data = $this->fullorder->find_all($w." and dtime > '1577811600'");
  1833. if(isset($data[0]))
  1834. {
  1835. if($data[0]['library'] != '2')
  1836. {
  1837. $list[] = array('orderinfo'=>$v,'site'=>1);
  1838. }
  1839. else if($data[0]['library'] == '2' && $data[0]['exstate'] == '99')
  1840. {
  1841. $list[] = array('orderinfo'=>$v,'site'=>2);
  1842. }
  1843. else if($data[0]['library'] == '2' && $data[0]['exstate'] != '99')
  1844. {
  1845. if($data[0]['excontent'] != '成功;' && $data[0]['excontent'] != '')
  1846. {
  1847. $list[] = array('orderinfo'=>$v,'site'=>3,'data'=>$data[0]['excontent']);
  1848. }
  1849. else
  1850. {
  1851. $list[] = array('orderinfo'=>$v,'site'=>2);
  1852. }
  1853. }
  1854. }
  1855. else
  1856. {
  1857. $list[] = array('orderinfo'=>$v,'site'=>0);
  1858. }
  1859. }
  1860. echo json_encode(array('t'=>count($orderinfo),'list'=>$list,'success'=>true));exit;
  1861. }
  1862. }
  1863. public function _logistics()
  1864. {
  1865. if(isset($_GET['waybill']))
  1866. {
  1867. $waybill = $this->input->get('waybill',true);
  1868. $s = $this->input->get('shop',true);
  1869. //$express = $this->input->get('express',true);
  1870. $data = $this->fullorder->get_waybill($waybill);
  1871. if(isset($data['excontent']) && $data['excontent'] != '')
  1872. {
  1873. //$a = $this->$express->get_logistics(array('waybill'=>$waybill));
  1874. echo json_encode(array('track'=>array('f'=>1,'data'=>$data['excontent']),'msg'=>'','success'=>1));exit;
  1875. }
  1876. else
  1877. {
  1878. $shop = $this->shop->get_shopname($s);
  1879. if(!$shop)
  1880. {
  1881. echo json_encode(array('track'=>'','msg'=>'No logistics information','success'=>0));exit;
  1882. }
  1883. $data = $this->fullorder->get_orderinfo($shop.$waybill);
  1884. if(isset($data['excontent']) && $data['excontent'] != '')
  1885. {
  1886. echo json_encode(array('track'=>array('f'=>1,'data'=>$data['excontent']),'msg'=>'','success'=>1));exit;
  1887. }
  1888. echo json_encode(array('track'=>'','msg'=>'No logistics information','success'=>0));exit;
  1889. }
  1890. }
  1891. }
  1892. public function _klarna()
  1893. {
  1894. $shop = array();$cg = array();$sb = array();
  1895. $ftime = strtotime(date("Y-m-d 0:00:0",strtotime("-10 day")))+8*3600;
  1896. $ttime = strtotime(date("Y-m-d 8:00:0",time()));
  1897. $shopdata = $this->shop->find_all("type = '269' and klarnaname != '' and klarnapass != ''");
  1898. foreach($shopdata as $v)
  1899. {
  1900. $data = $this->fullorder->find_all("paypal like '%-%-%-%' and librarytime > '$ftime' and librarytime < '$ttime' and pay = '23' and library = '2' and source != '1' and klarna < '2' and shop = '".$v['id']."'","id,number,orderinfo,paypal,shouldmoney,shop");
  1901. foreach($data as $val)
  1902. {
  1903. $api = $this->_klarnaapi($val['paypal'],$val['shouldmoney'],$v['klarnaname'],$v['klarnapass']);
  1904. $header = $api['header'];
  1905. $api = $api['res'];
  1906. if(isset($api['error_messages'][0]))
  1907. {
  1908. if(stripos($api['error_messages'][0],'amount is 0 for') !== false)
  1909. {
  1910. $this->fullorder->save(array('klarna'=>3),$val['id']);
  1911. $sb[] = array($val['number'],$val['orderinfo'],'oooo3');
  1912. }
  1913. else
  1914. {
  1915. $this->fullorder->save(array('klarna'=>1,'klarnaerror'=>$api['error_messages'][0]),$val['id']);
  1916. $sb[] = array($val['number'],$val['orderinfo'],'oooo1');
  1917. }
  1918. }
  1919. else if($api == '')
  1920. {
  1921. if(isset($header['http_code']) && $header['http_code'] == 201)
  1922. {
  1923. $this->fullorder->save(array('klarna'=>2),$val['id']);
  1924. $cg[] = array($val['number'],$val['orderinfo'],'oooo2');
  1925. }
  1926. else
  1927. {
  1928. $this->fullorder->save(array('klarna'=>1,'klarnaerror'=>'未知错误'),$val['id']);
  1929. $sb[] = array($val['number'],$val['orderinfo'],'oooo0');
  1930. }
  1931. }
  1932. else if(isset($api['cs']))
  1933. {
  1934. $this->fullorder->save(array('klarna'=>1,'klarnaerror'=>'超时'),$val['id']);
  1935. $sb[] = array($val['number'],$val['orderinfo'],'oooo0');
  1936. }
  1937. else
  1938. {
  1939. $this->fullorder->save(array('klarna'=>1,'klarnaerror'=>'未知错误'),$val['id']);
  1940. $sb[] = array($val['number'],$val['orderinfo'],'oooo0');
  1941. }
  1942. }
  1943. }
  1944. echo "<pre>";
  1945. print_r($cg);
  1946. echo "<pre>";
  1947. print_r($sb);
  1948. }
  1949. public function _klarnaapi($paypal,$shouldmoney,$name,$pass)
  1950. {
  1951. $url = 'https://api-na.klarna.com/ordermanagement/v1/orders/'.$paypal.'/captures';
  1952. $data = '{"captured_amount": '.str_replace('.','',$shouldmoney).'}';
  1953. $header[] = "Content-Type:application/json";
  1954. $header[] = "Authorization: Basic ".base64_encode($name.":".$pass);
  1955. $ch = curl_init();
  1956. curl_setopt($ch, CURLOPT_URL, $url);
  1957. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  1958. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  1959. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  1960. curl_setopt($ch, CURLOPT_POST, 1);
  1961. curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
  1962. curl_setopt($ch, CURLOPT_TIMEOUT, 20);
  1963. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  1964. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  1965. $res = curl_exec($ch);
  1966. $header = curl_getinfo($ch);
  1967. if($res === false)
  1968. {
  1969. if(curl_errno($ch))
  1970. {
  1971. return array('res'=>'1','header'=>'','cs'=>1);
  1972. }
  1973. }
  1974. else
  1975. {
  1976. $res = json_decode($res,true);
  1977. return array('res'=>$res,'header'=>$header);
  1978. }
  1979. curl_close($ch);
  1980. }
  1981. public function _klarnadata($paypal,$name,$pass)
  1982. {
  1983. $url = 'https://api-na.klarna.com/ordermanagement/v1/orders/'.$paypal;
  1984. $header[] = "Content-Type:application/json";
  1985. $header[] = "Authorization: Basic ".base64_encode($name.":".$pass);
  1986. $ch = curl_init();
  1987. curl_setopt($ch, CURLOPT_URL, $url);
  1988. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  1989. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  1990. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  1991. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  1992. $res = curl_exec($ch);
  1993. curl_close($ch);
  1994. $res = json_decode($res,true);
  1995. $data = '';
  1996. if(isset($res['fraud_status']))
  1997. {
  1998. // $data = (($res['fraud_status'] == 'ACCEPTED')?1:2).'|<strong>'.$res['purchase_currency'].($res['order_amount']/100).'</strong> , '.(($res['fraud_status'] != 'ACCEPTED')?'<font style="color:#f00">'.$res['fraud_status'].'</font>':$res['fraud_status']).' , description:'.$res['initial_payment_method']['description'].' , number of installments:'.$res['initial_payment_method']['number_of_installments'].'|'.$res['billing_address']['street_address'].(($res['billing_address']['street_address2']!='')?' '.$res['billing_address']['street_address2']:'').','.$res['billing_address']['city'].','.$res['billing_address']['region'].','.$res['billing_address']['postal_code'].','.$res['billing_address']['country'].','.$res['billing_address']['given_name'].' '.$res['billing_address']['family_name'].','.$res['billing_address']['phone'].','.$res['billing_address']['email'].'|'.str_replace('|','&#124;',$res['shipping_address']['street_address']).(($res['shipping_address']['street_address2']!='')?' '.str_replace('|','&#124;',$res['shipping_address']['street_address2']):'').','.$res['shipping_address']['city'].','.$res['shipping_address']['region'].','.$res['shipping_address']['postal_code'].','.$res['shipping_address']['country'].','.$res['shipping_address']['given_name'].' '.$res['shipping_address']['family_name'].','.$res['shipping_address']['phone'].','.$res['shipping_address']['email'];
  1999. if(isset($res['initial_payment_method']['number_of_installments'])){
  2000. $number_of_installments = $res['initial_payment_method']['number_of_installments'];
  2001. }else{
  2002. $number_of_installments = 0;
  2003. }
  2004. $data = (($res['fraud_status'] == 'ACCEPTED')?1:2).'|<strong>'.$res['purchase_currency'].($res['order_amount']/100).'</strong> , '.(($res['fraud_status'] != 'ACCEPTED')?'<font style="color:#f00">'.$res['fraud_status'].'</font>':$res['fraud_status']).' , description:'.$res['initial_payment_method']['description'].' , number of installments:'.$number_of_installments.'|'.$res['billing_address']['street_address'].(($res['billing_address']['street_address2']!='')?' '.$res['billing_address']['street_address2']:'').','.$res['billing_address']['city'].','.$res['billing_address']['region'].','.$res['billing_address']['postal_code'].','.$res['billing_address']['country'].','.$res['billing_address']['given_name'].' '.$res['billing_address']['family_name'].','.$res['billing_address']['phone'].','.$res['billing_address']['email'].'|'.str_replace('|','&#124;',$res['shipping_address']['street_address']).(($res['shipping_address']['street_address2']!='')?' '.str_replace('|','&#124;',$res['shipping_address']['street_address2']):'').','.$res['shipping_address']['city'].','.$res['shipping_address']['region'].','.$res['shipping_address']['postal_code'].','.$res['shipping_address']['country'].','.$res['shipping_address']['given_name'].' '.$res['shipping_address']['family_name'].','.$res['shipping_address']['phone'].','.$res['shipping_address']['email'];
  2005. }
  2006. return $data;
  2007. }
  2008. public function _hqpaypal()
  2009. {
  2010. $shop = $this->shop->find_all("paypalname != ''");
  2011. foreach ($shop as $val)
  2012. {
  2013. $d = $this->fullorder->find_all("shop = '".$val['id']."' and dtime > '".(time()-(5*24*3600))."' and dtime < '".(time()-(3*3600))."' and (pay = '22' || pay = '7') and klarnadata = ''");
  2014. foreach ($d as $v)
  2015. {
  2016. $paypal = $this->paypal->data($v['paypal'],$val);
  2017. if($paypal != '')
  2018. {
  2019. $this->fullorder->save(array('klarnadata'=>$paypal),$v['id']);
  2020. }
  2021. }
  2022. }
  2023. }
  2024. public function _hqstripe()
  2025. {
  2026. $shop = $this->shop->find_all("stripe != ''");
  2027. foreach ($shop as $val)
  2028. {
  2029. $d = $this->fullorder->find_all("shop = '".$val['id']."' and dtime > '".(time()-(5*24*3600))."' and dtime < '".time()."' and pay = '1211' and klarnadata = ''");
  2030. foreach ($d as $v)
  2031. {
  2032. $paypal = $this->_stripe($v['paypal'],$val['stripe']);
  2033. if($paypal != '')
  2034. {
  2035. $this->fullorder->save(array('klarnadata'=>$paypal),$v['id']);
  2036. }
  2037. }
  2038. }
  2039. }
  2040. public function _stripe($pay,$stripe)
  2041. {
  2042. $url = 'https://api.stripe.com/v1/payment_intents/'.$pay;
  2043. $header[] = "Authorization:Bearer ".$stripe;
  2044. $ch = curl_init();
  2045. curl_setopt($ch, CURLOPT_URL, $url);
  2046. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  2047. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  2048. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  2049. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  2050. $res = curl_exec($ch);
  2051. curl_close($ch);
  2052. $res = json_decode($res,true);
  2053. $k = '';
  2054. if(isset($res['shipping']['name']))
  2055. {
  2056. $line = ($res['shipping']['address']['line2'] != '')?$res['shipping']['address']['line1'].' '.$res['shipping']['address']['line2']:$res['shipping']['address']['line1'];
  2057. $k = 'stripe|'.json_encode(array('name'=>$res['shipping']['name'],'email'=>$res['receipt_email'],'address'=>$line.','.$res['shipping']['address']['city'].','.$res['shipping']['address']['state'].','.$res['shipping']['address']['postal_code'].','.$res['shipping']['address']['country'].','.$res['shipping']['phone'],'shouldmoney'=>$res['amount']/100));
  2058. }
  2059. return $k;
  2060. }
  2061. public function _afterpay($paypal,$name,$pass)
  2062. {
  2063. $url = 'https://global-api.afterpay.com/v2/payments?ids='.$paypal;
  2064. $header[] = "Accept:application/json";
  2065. $header[] = "User-Agent: Readme.io API Simulator'";
  2066. $header[] = "Authorization: Basic ".base64_encode($name.":".$pass);
  2067. $ch = curl_init();
  2068. curl_setopt($ch, CURLOPT_URL, $url);
  2069. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  2070. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  2071. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  2072. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  2073. $res = curl_exec($ch);
  2074. curl_close($ch);
  2075. $res = json_decode($res,true);
  2076. $data = '';
  2077. if(isset($res['results'][0]['orderDetails']['consumer']['email']))
  2078. {
  2079. $data = $res['results'][0]['orderDetails']['consumer']['email'].'|'.str_replace('|','&#124;',$res['results'][0]['orderDetails']['billing']['line1']).','.str_replace('|','&#124;',$res['results'][0]['orderDetails']['billing']['line2']).','.$res['results'][0]['orderDetails']['billing']['area1'].','.$res['results'][0]['orderDetails']['billing']['region'].','.$res['results'][0]['orderDetails']['billing']['postcode'].','.$res['results'][0]['orderDetails']['billing']['countryCode'].','.$res['results'][0]['orderDetails']['billing']['name'].','.$res['results'][0]['orderDetails']['billing']['phoneNumber'].'|'.str_replace('|','&#124;',$res['results'][0]['orderDetails']['shipping']['line1']).','.str_replace('|','&#124;',$res['results'][0]['orderDetails']['shipping']['line2']).','.$res['results'][0]['orderDetails']['shipping']['area1'].','.$res['results'][0]['orderDetails']['shipping']['region'].','.$res['results'][0]['orderDetails']['shipping']['postcode'].','.$res['results'][0]['orderDetails']['shipping']['countryCode'].','.$res['results'][0]['orderDetails']['shipping']['name'].','.$res['results'][0]['orderDetails']['shipping']['phoneNumber'];
  2080. $data = str_replace(',,',',',$data);
  2081. }
  2082. return $data;
  2083. }
  2084. public function _clearpay($paypal,$name,$pass)
  2085. {
  2086. $url = 'https://global-api.afterpay.com/v2/payments?ids='.$paypal;
  2087. $header[] = "Accept:application/json";
  2088. $header[] = "User-Agent: Readme.io API Simulator'";
  2089. $header[] = "Authorization: Basic ".base64_encode($name.":".$pass);
  2090. $ch = curl_init();
  2091. curl_setopt($ch, CURLOPT_URL, $url);
  2092. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  2093. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  2094. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  2095. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  2096. $res = curl_exec($ch);
  2097. curl_close($ch);
  2098. $res = json_decode($res,true);
  2099. $data = '';
  2100. if(isset($res['results'][0]['orderDetails']['consumer']['email']))
  2101. {
  2102. $data = $res['results'][0]['orderDetails']['consumer']['email'].'|'.str_replace('|','&#124;',$res['results'][0]['orderDetails']['billing']['line1']).','.str_replace('|','&#124;',$res['results'][0]['orderDetails']['billing']['line2']).','.$res['results'][0]['orderDetails']['billing']['area1'].','.$res['results'][0]['orderDetails']['billing']['region'].','.$res['results'][0]['orderDetails']['billing']['postcode'].','.$res['results'][0]['orderDetails']['billing']['countryCode'].','.$res['results'][0]['orderDetails']['billing']['name'].','.$res['results'][0]['orderDetails']['billing']['phoneNumber'].'|'.str_replace('|','&#124;',$res['results'][0]['orderDetails']['shipping']['line1']).','.str_replace('|','&#124;',$res['results'][0]['orderDetails']['shipping']['line2']).','.$res['results'][0]['orderDetails']['shipping']['area1'].','.$res['results'][0]['orderDetails']['shipping']['region'].','.$res['results'][0]['orderDetails']['shipping']['postcode'].','.$res['results'][0]['orderDetails']['shipping']['countryCode'].','.$res['results'][0]['orderDetails']['shipping']['name'].','.$res['results'][0]['orderDetails']['shipping']['phoneNumber'];
  2103. $data = str_replace(',,',',',$data);
  2104. }
  2105. return $data;
  2106. }
  2107. public function _htmlstock()
  2108. {
  2109. if(isset($_GET['hq']))
  2110. {
  2111. $ProductsType = $this->typeclass->find_all("classid = '16' and hq = '1'",'id,title','sequence asc');
  2112. foreach ($ProductsType as $k=>$v)
  2113. {
  2114. if($v['title'] == 'Closure')
  2115. {
  2116. $ProductsType[$k]['title'] = 'Closure/Frontal';
  2117. }
  2118. }
  2119. $HairColor = $this->typeclass->find_all("classid = '8' and hq = '1'",'id,title','sequence asc');
  2120. $HairWavy = $this->typeclass->find_all("classid = '15' and hq = '1'",'id,title','sequence asc');
  2121. $WigType = $this->typeclass->find_all("classid = '18' and hq = '1'",'id,title','sequence asc');
  2122. $Length = $this->typeclass->find_all("classid = '14' and hq = '1'",'id,title','sequence asc');
  2123. echo json_encode(array('ProductsType'=>$ProductsType,'HairColor'=>$HairColor,'HairWavy'=>$HairWavy,'WigType'=>$WigType,'Length'=>$Length));exit;
  2124. //http://1.wepolicy.cn/api/htmlstock?hq=1
  2125. }
  2126. if(isset($_GET['page']))
  2127. {
  2128. $del = array();
  2129. $typeclass13 = $this->typeclass->find_all("classid = '13'");
  2130. $typeclass16 = $this->typeclass->find_all("classid = '16'");
  2131. foreach ($typeclass16 as $key=>$value)
  2132. {
  2133. foreach ($typeclass13 as $v)
  2134. {
  2135. $del[] = $value['title'].' '.$v['title'];
  2136. }
  2137. }
  2138. $page = $this->input->get('page',true);
  2139. $perpage = $this->input->get('perpage',true);
  2140. $category = $this->input->get('ProductsType',true);//类目
  2141. $color = $this->input->get('HairColor',true);//颜色
  2142. $lowe = $this->input->get('HairWavy',true);//花型
  2143. $lacetype = $this->input->get('WigType',true);//头套种类
  2144. $size = $this->input->get('Length',true);//长度
  2145. $title = $this->input->get('title',true);//传输文本
  2146. $warehouse = 5;
  2147. $state = $this->input->get('state',true);
  2148. $where = "warehouse = '5' and state = '0'";
  2149. if($category)
  2150. {
  2151. $where .= " and features like '%-$category-%'";
  2152. }
  2153. if($color)
  2154. {
  2155. $where .= " and features like '%-$color-%'";
  2156. }
  2157. if($lowe)
  2158. {
  2159. $where .= " and features like '%-$lowe-%'";
  2160. }
  2161. if($lacetype)
  2162. {
  2163. $where .= " and features like '%-$lacetype-%'";
  2164. }
  2165. if($size)
  2166. {
  2167. $where .= " and features like '%-$size-%'";
  2168. }
  2169. if($title)
  2170. {
  2171. $where .= " and title like '%$title%'";
  2172. }
  2173. $order_str = "id desc";
  2174. if(empty($page))
  2175. {
  2176. $start = 0;
  2177. $perpage = 1;
  2178. }
  2179. else
  2180. {
  2181. $start = ($page - 1)*$perpage;
  2182. }
  2183. $info_list = $this->whlabel->find_pc($where,'sku,features,warehouse','id,warehouse,sku,title,features,number',$order_str,$start,$perpage);
  2184. $data = array();
  2185. foreach ($info_list as $key=>$value)
  2186. {
  2187. $c = $this->whlabel->find_count($where.' and sku = "'.$value['sku'].'" and state = 0 and warehouse = "5" and features = "'.$value['features'].'" and zd = ""');
  2188. if($c > 1)
  2189. {
  2190. $data[] = array('Item'=>str_replace($del,'',$value['title']),'Stock'=>$c);
  2191. }
  2192. }
  2193. $total = count($this->whlabel->find_pc($where,'sku,features,warehouse','id,warehouse,sku,title,features,number'));
  2194. $pagenum = ceil($total/$perpage);
  2195. $over = $total-($start+$perpage);
  2196. $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($data));//总数量,剩余数量,总页数,数据
  2197. echo json_encode($rows);exit;
  2198. ///api/htmlstock?page=1&perpage=50&ProductsType=&HairColor=&HairWavy=&WigType=&Length= //页数、每页数量、类目、颜色、花型、头套种类、尺寸
  2199. }
  2200. }
  2201. public function _zc17track()
  2202. {
  2203. $express = array();
  2204. $ex = $this->express->find_all("cxcode = '17track'");
  2205. foreach ($ex as $v)
  2206. {
  2207. $express[$v['id']] = $v['title'];
  2208. }
  2209. $time_threshold = time() - 12 * 24 * 3600;
  2210. $this->db->select('a.number, a.express,a.waybill');
  2211. $this->db->from('crowd_fullorder as a');
  2212. $this->db->join('express as b', 'a.express = b.id', 'inner');
  2213. $this->db->where('a.waybill !=', '');
  2214. $this->db->where('a.library', '2');
  2215. $this->db->where('a.librarytime >', $time_threshold);
  2216. $this->db->where('a.webhookregister <', 1);
  2217. $this->db->where('b.cxcode', '17track');
  2218. $query = $this->db->get();
  2219. $data = $query->result_array();
  2220. $fsdata = array();
  2221. foreach ($data as $v)
  2222. {
  2223. if(!isset($express[$v['express']]))
  2224. {
  2225. continue;
  2226. }
  2227. if(stripos($express[$v['express']],'DHL') !== false)
  2228. {
  2229. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'100001');
  2230. }
  2231. else if(stripos($express[$v['express']],'UPS') !== false)
  2232. {
  2233. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'100002');
  2234. }
  2235. else if((stripos($express[$v['express']],'FEDEX') !== false)||(stripos($express[$v['express']],'FedEx') !== false) )
  2236. {
  2237. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'100003');
  2238. }
  2239. else if(stripos($express[$v['express']],'TNT') !== false)
  2240. {
  2241. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'100004');
  2242. }
  2243. else if(stripos($express[$v['express']],'ARAMEX') !== false)
  2244. {
  2245. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'100006');
  2246. }
  2247. else if(stripos($express[$v['express']],'YunExpress') !== false){
  2248. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'190008');
  2249. }
  2250. else if(stripos($express[$v['express']],'DEPX') !== false){
  2251. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'100014');
  2252. }
  2253. else if(stripos($express[$v['express']],'EMS') !== false)
  2254. {
  2255. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'3013');
  2256. }
  2257. else if(stripos($express[$v['express']],'GES') !== false)
  2258. {
  2259. $fsdata[] = array('number'=>$v['waybill'],'carrier'=>'190258');
  2260. }
  2261. else
  2262. {
  2263. $fsdata[] = array('number'=>$v['waybill'],'auto_detection'=>'true');
  2264. }
  2265. }
  2266. $fsdata = array_chunk($fsdata, 40);
  2267. $logistics = '17track';
  2268. foreach ($fsdata as $v)
  2269. {
  2270. $fs = $this->$logistics->get_logistics(json_encode($v));
  2271. $this->logic_ding->sendToDing("监听17track注册为什么获取不到的原因,请求参数".json_encode($v));
  2272. $this->logic_ding->sendToDing("监听17track注册为什么获取不到的原因,返回参数".json_encode($fs));
  2273. if(isset($fs['f']))
  2274. {
  2275. $csck[] = array($v,$fs['f'],$fs['content']);
  2276. foreach ($v as $val)
  2277. {
  2278. $d = $this->fullorder->get_waybill($val['number']);
  2279. if($fs['f'] == '1')
  2280. {
  2281. $this->fullorder->save(array('webhookregister'=>1,'wlerror'=>''),$d['id']);
  2282. }
  2283. else
  2284. {
  2285. $this->fullorder->save(array('wlerror'=>$fs['content']),$d['id']);
  2286. }
  2287. }
  2288. }
  2289. else
  2290. {
  2291. $csck[] = array($v,'CW',"CS");
  2292. }
  2293. sleep(3);
  2294. }
  2295. @$this->allocation->insert(array('title'=>json_encode($csck)));
  2296. /**
  2297. $data = $this->fullorder->find_all("waybill != '' and library = '2' and librarytime > '".(time()-12*24*3600)."' and webhookregister < 1");
  2298. $csck = array();
  2299. foreach ($data as $k=>$v)
  2300. {
  2301. $express = $this->express->read($v['express']);
  2302. $service = $this->service->read($express['service']);
  2303. $v['servicename'] =$service['title'];//增加快递名称
  2304. $v['url'] = $express['url'];//增加快递链接
  2305. $logistics = '17track';
  2306. $fs = $this->$logistics->get_logistics($v);
  2307. if(isset($fs['f']))
  2308. {
  2309. $csck[] = array($v['number'],$fs['f'],$fs['content']);
  2310. if($fs['f'] == '1')
  2311. {
  2312. $this->fullorder->save(array('webhookregister'=>1,'wlerror'=>''),$v['id']);
  2313. }
  2314. else
  2315. {
  2316. $this->fullorder->save(array('wlerror'=>$fs['content']),$v['id']);
  2317. }
  2318. }
  2319. else
  2320. {
  2321. $csck[] = array($v['number'],'CW',"CS");
  2322. }
  2323. sleep(1);
  2324. }
  2325. @$this->allocation->insert(array('title'=>$shopid.'-'.json_encode($csck)));
  2326. **/
  2327. }
  2328. public function _17track()
  2329. {
  2330. $xq = array();
  2331. $j = file_get_contents('PHP://input');
  2332. $j = json_decode($j, true);
  2333. $j = $j['data'];
  2334. $express = array();
  2335. $expressdata = $this->express->find_all('1=1');
  2336. foreach ($expressdata as $v)
  2337. {
  2338. $express[$v['id']] = $v['title'];
  2339. }
  2340. //$sh = hash("sha256",$j['event'].'/'.json_encode($j).'/0811AC1711EAABB7D764D04B824F8C2D');
  2341. $f = 'fullorder';
  2342. $d = $this->fullorder->get_waybill($j['number']);
  2343. if(!$d)
  2344. {
  2345. $f = 'fullordersmt';
  2346. $d = $this->fullordersmt->get_waybill($j['number']);
  2347. if(!$d)
  2348. {
  2349. $f = 'fullordertt';
  2350. $d = $this->fullordertt->get_waybill($j['number']);
  2351. }
  2352. }
  2353. if(!$d)
  2354. {
  2355. exit;
  2356. }
  2357. $state = '';
  2358. $zxzt = array_reverse($j['track_info']['milestone']);
  2359. foreach ($zxzt as $v)
  2360. {
  2361. if($v['time_iso'] != NULL)
  2362. {
  2363. $state = $v['key_stage'];
  2364. break;
  2365. }
  2366. }
  2367. $exstate = 0;//无信息
  2368. if($state == 'InfoReceived' || $state == 'PickedUp' || $state == 'Departure' || $state == 'Arrival')//运输途中
  2369. {
  2370. $exstate = 3;//在途中
  2371. }
  2372. else if($state == 'OutForDelivery')//派送中
  2373. {
  2374. $exstate = 4;
  2375. }
  2376. else if($state == 'Returned' || $zxzt == 'Returning')//投递失败
  2377. {
  2378. $exstate = 1;//派送异常
  2379. }
  2380. else if($state == 'Delivered')//成功签收
  2381. {
  2382. $exstate = 6;//签收
  2383. }
  2384. $pd = array();$xq = '';
  2385. if(isset($j['track_info']['tracking']['providers'][0]['events']))
  2386. {
  2387. foreach ($j['track_info']['tracking']['providers'][0]['events'] as $k=>$v)
  2388. {
  2389. if($k == 0)
  2390. {
  2391. $pd = $v['description'];
  2392. }
  2393. $xq .= date('Y-m-d H:i:s',strtotime($v['time_iso'])).' ['.$v['location'].'] '.$v['description'].'<br />';// a日期 c地址 z状态
  2394. }
  2395. if(stripos($express[$d['express']],'Fedex') !== false && stripos($pd,'International shipment release - Import') !== false)
  2396. {
  2397. $exstate = 4;//即将派送
  2398. }
  2399. else if(stripos($express[$d['express']],'DHL') !== false && stripos($pd,'Clearance processing complete') !== false)
  2400. {
  2401. $exstate = 4;//即将派送
  2402. }
  2403. else if(stripos($express[$d['express']],'UPS') !== false && stripos($pd['c'],'Louisville, KY, US') !== false && stripos($pd,'Departed from Facility') !== false)
  2404. {
  2405. $exstate = 4;//即将派送
  2406. }
  2407. else if(stripos($express[$d['express']],'GES') !== false && stripos($pd,'Shipment picked up') !== false)
  2408. {
  2409. $exstate = 4;//即将派送
  2410. }
  2411. else if(stripos($pd,'Delivery exception') !== false || stripos($pd,'Addressee Unknown') !== false || stripos($pd,'Delivered to Agent for Final Delivery') !== false || stripos($pd,'Reminder to pick up your item') !== false || stripos($pd,'Available for Pickup') !== false || stripos($pd,'Processing Exception') !== false || stripos($pd,'Return to Sender Processed') !== false || stripos($pd,'Redelivery Scheduled') !== false || stripos($pd,'Notice Left') !== false || stripos($pd,'Delivery attempted but no response at Consignee address') !== false || stripos($pd,'Delivery attempt could not be completed') !== false || stripos($pd,'Forwarded to a third party agent') !== false || stripos($pd,'Awaiting collection by the consignee') !== false || stripos($pd,'Consignee has moved from the address provided') !== false || stripos($pd,'awaiting customer pickup') !== false)
  2412. {
  2413. $exstate = 1;//异常
  2414. }
  2415. }
  2416. $awlgx = $this->awlgx->get_number($d['number']);
  2417. if($awlgx)
  2418. {
  2419. $this->awlgx->save(array("content"=>$xq,"time"=>time(),'exstate'=>$exstate,'type'=>$f),$awlgx['id']);
  2420. }
  2421. else
  2422. {
  2423. $this->awlgx->insert(array("number"=>$d['number'],"content"=>$xq,"time"=>time(),'exstate'=>$exstate,'type'=>$f));
  2424. }
  2425. if($xq != '')
  2426. {
  2427. $this->$f->save(array('expressstate'=>$exstate,'excontent'=>$xq),$d['id']);
  2428. $time = time();
  2429. if($f == 'fullorder')
  2430. {
  2431. $notice = $this->notice->find_all("message = '1' and state = '1' and type = '2' and ktime < '$time' and jtime > '$time' and shop = '".$d['shop']."' and logisticstatus = '".$exstate."'");
  2432. if($notice && $d['wlyc'] == '0' && $d['wltype'] != '1' && $d['source'] != '1' && stripos($d['wlcontent'],$notice[0]['title']) === false)
  2433. {
  2434. $this->_sdfs($d,$notice[0]['id']);
  2435. //给crm发送信息 先存储数据 后续定时任务执行
  2436. if($d['shop'] < 10){
  2437. //派送中
  2438. if($exstate == 4){
  2439. $this->zztmpdata->insert([
  2440. 'type'=>3,
  2441. 'act_name'=>'crm_order',
  2442. 'content'=>json_encode($d),
  2443. 'create_time'=>time()
  2444. ]);
  2445. }
  2446. //签收完成
  2447. if($exstate == 6){
  2448. $this->zztmpdata->insert([
  2449. 'type'=>4,
  2450. 'act_name'=>'crm_order',
  2451. 'content'=>json_encode($d),
  2452. 'create_time'=>time()
  2453. ]);
  2454. }
  2455. }
  2456. }
  2457. }
  2458. }
  2459. }
  2460. public function _dhl()//DHL
  2461. {
  2462. die;
  2463. $data = $this->dhl->find_all("type != 1 and time > '".(time()-24*3600)."'");
  2464. foreach ($data as $v)
  2465. {
  2466. $y = $this->fullorder->get_number($v['number']);
  2467. if(!$y)
  2468. {
  2469. $y = $this->fullordertt->get_number($v['number']);
  2470. if(!$y)
  2471. {
  2472. $y = $this->fullordersmt->get_number($v['number']);
  2473. if(!$y)
  2474. {
  2475. continue;
  2476. }
  2477. }
  2478. }
  2479. $this->dhl->get_data_c($y,$v['id']);
  2480. }
  2481. }
  2482. }