Ac.php 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629
  1. <?php defined('BASEPATH') OR exit('No direct script access allowed');
  2. class Ac extends Start_Controller {
  3. public function __construct(){
  4. parent::__construct();
  5. $this->load->_model('Model_shop','shop');
  6. $this->load->_model('Model_fullorder','fullorder');
  7. $this->load->_model('Model_fullordertt','fullordertt');
  8. $this->load->_model('Model_fullorderxw','fullorderxw');
  9. $this->load->_model('Model_fullordersmt','fullordersmt');
  10. $this->load->_model('Model_fullorder_2020','fullorder2020');
  11. $this->load->_model('Model_fullordersmt_2020','fullordersmt2020');
  12. $this->load->_model('Model_customersmt','customersmt');
  13. $this->load->_model('Model_country','country');
  14. $this->load->_model('Model_hl','hl');
  15. $this->load->_model('Model_is','is');
  16. $this->load->_model('Model_kdniao','kdniao');
  17. $this->load->_model('Model_typeclass','typeclass');
  18. $this->load->_model('Model_warehouse','warehouse');
  19. $this->load->_model('Model_fullorderexcel','fullorderexcel');
  20. $this->load->_model('Model_dhl','dhl');
  21. $this->load->_model('Model_usps','usps');
  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_whlabel','whlabel');
  27. $this->load->_model('Model_productdescribe','productdescribe');
  28. $this->load->_model('Model_ljg','ljg');
  29. $this->load->_model('Model_commodityread','commodityread');
  30. $this->load->_model('Model_service','service');
  31. $this->load->_model('Model_fedex','fedex');
  32. $this->load->_model('Model_commodity','commodity');
  33. $this->load->_model('Model_fullordersmtorder','fullordersmtorder');
  34. $this->load->_model('Model_ali','ali');
  35. $this->load->_model('Model_fullordersmthb','fullordersmthb');
  36. $this->load->_model('Model_fullordersmtbf','fullordersmtbf');
  37. $this->load->_model('Model_taxzhengzhou','taxzhengzhou');
  38. $this->load->_model('Model_taxshanghai','taxshanghai');
  39. $this->load->_model('Model_excel','excel');
  40. $this->load->_model('Model_ups','ups');
  41. $this->load->_model('Model_dpd','dpd');
  42. $this->load->_model('Model_dpdold','dpdold');
  43. $this->load->_model('Model_dpd_IOSS','dpd_IOSS');
  44. $this->load->_model('Model_dpdxw','dpdxw');
  45. $this->load->_model('Model_cne','cne');
  46. $this->load->_model('Model_outbound','outbound');
  47. $this->load->_model('Model_api','api');
  48. $this->load->_model('Model_dhlhz','dhlhz');
  49. $this->load->_model('Model_apismt','apismt');
  50. $this->load->_model('Model_specialstock','specialstock');
  51. $this->load->_model('Model_systemwigsout','systemwigsout');
  52. $this->load->_model('Model_purchaseorder','purchaseorder');
  53. $this->load->_model('Model_returns','returns');
  54. $this->load->_model('Model_whlabellabel','whlabellabel');
  55. $this->load->_model('Model_whlabelbarcode','whlabelbarcode');
  56. $this->load->_model('Model_tjadd','tjadd');
  57. $this->load->_model('Model_stafflist','stafflist');
  58. $this->load->_model('Model_paypal','paypal');
  59. $this->load->_model('Model_warehousefactory','warehousefactory');
  60. $this->load->_model('Model_commodityread_del','commodityreaddel');
  61. $this->load->_model('Model_als','als');
  62. $this->load->_model('Model_allocation','allocation');
  63. $this->load->_model('Model_17track','17track');
  64. $this->load->_model('Model_hualei','hualei');
  65. $this->load->_model('Model_hualeixw','hualeixw');
  66. $this->load->_model('Model_ck','ck');
  67. $this->load->_model('Model_colour','colour');
  68. $this->load->_model('Model_color','color');
  69. $this->load->_model('Model_emaildata','emaildata');
  70. $this->load->_model('Model_wigprint','wigprint');
  71. $this->load->_model('Model_weight','weight');
  72. $this->load->_model('Model_whlabeltransport','whlabeltransport');
  73. $this->load->_model('Model_pay','pay');
  74. $this->load->_model('Model_orderurl','orderurl');
  75. $this->load->_model('Model_classid','classid');
  76. $this->load->_model('Model_whlabel','whlabel');
  77. $this->load->_model('Model_systemtransfer','systemtransfer');
  78. $this->load->_model('Model_whlabel_bh','whlabel_bh');
  79. $this->load->_model('Model_excel','excel');
  80. $this->load->_model('Model_yuntu','yuntu');
  81. $this->load->_model('Model_fedex_ficp','fedex_ficp');
  82. $this->load->_model('Model_fedexv1','fedexv1');
  83. }
  84. //定义方法的调用规则 获取URI第二段值
  85. public function _remap($arg,$arg_array)
  86. {
  87. if($arg == 'x3')
  88. {
  89. $this->_x3($arg_array);
  90. }
  91. else if($arg == 'qk')
  92. {
  93. $this->_qk();
  94. }
  95. else if($arg == 'qczd')
  96. {
  97. $this->_qczd($arg_array);
  98. }
  99. else if($arg == 'd')
  100. {
  101. $this->_d($arg_array);
  102. }
  103. else if($arg == 'w')
  104. {
  105. $this->_w($arg_array);
  106. }
  107. else if($arg == 'wz')
  108. {
  109. $this->_wz($arg_array);//改仓库位置
  110. }
  111. else if($arg == 'qkyy')
  112. {
  113. $this->_qkyy($arg_array);//清除备货用友数据
  114. }
  115. else if($arg == 'cxxq')
  116. {
  117. $this->_cxxq($arg_array);//查询独立站订单详情
  118. }
  119. else if($arg == 'user')
  120. {
  121. $this->_user($arg_array);//批量添加店铺权限
  122. }
  123. }
  124. public function _x3($arg_array)
  125. {
  126. $fullorder = $this->fullorder->get_number($arg_array[0]);
  127. if(!$fullorder)
  128. {
  129. $fullorder = $this->fullordersmt->get_number($arg_array[0]);
  130. }
  131. if(!$fullorder)
  132. {
  133. $fullorder = $this->fullordertt->get_number($arg_array[0]);
  134. }
  135. if(!$fullorder)
  136. {
  137. $fullorder = $this->fullorderxw->get_number($arg_array[0]);
  138. }
  139. if(!$fullorder)
  140. {
  141. echo "编号错误";exit;
  142. }
  143. /** 发票地址信息暂时无用
  144. $fullorder['baddress'] = explode(',',$fullorder['baddress']);
  145. $fullorder['baddress'] = array_reverse($fullorder['baddress']);
  146. $fullorder['baddress'][1] = $country['ename'];
  147. **/
  148. //获取所用相关信息
  149. $warehouse = $this->warehouse->read($fullorder['type']);
  150. $country = $this->country->read($fullorder['country']);//订单国家信息
  151. $fcountry = $this->country->read($warehouse['country']);//仓库国家信息
  152. $warehouse['country'] = $fcountry['ename'];//仓库国家名
  153. $warehouse['lb'] = $fcountry['lb'];//仓库国家编码
  154. $fullorder['warehouse'] = $warehouse;//仓库数据加入订单
  155. $fullorder['lb'] = $country['lb'];//订单国家编码加入
  156. $fullorder['country'] = $country['ename'];//订单国家名
  157. $fullorder['zhou'] = $country['continent'];//所属州
  158. $express = $this->express->read($fullorder['express']);
  159. $fullorder['express'] = $express['servicename'];
  160. $fullorder['account'] = $express['account'];
  161. $fullorder['printcode'] = $express['printcode'];
  162. $fullorder['time'] = date('Y-m-d',time());
  163. $fullorder['times'] = date('Y-m-d H:i',time());
  164. $fullorder['sbbm']= ($fullorder['sbpm'] == 'Hair Sample') ? 67042000 : 67041100;
  165. $fullorder['address'] = str_replace(array('&'),array('&#38;'),$fullorder['address']);
  166. $fullorder['address2'] = str_replace(array('&'),array('&#38;'),$fullorder['address2']);
  167. $fullorder['shipremarks'] = str_replace(array('&lt;','&gt;'),array('<','>'),$fullorder['shipremarks']);
  168. $fullorder['shipremarks'] = str_replace(array('<','>',';',';'),array('&lt','&gt',';<br>',';<br>'),$fullorder['shipremarks']);
  169. $shop = $this->shop->read($fullorder['shop']);
  170. $fullorder['shop'] = $shop['shopname'];
  171. $fullorder['city'] = preg_replace('/( | | |\s)/',' ',$fullorder['city']);
  172. $fullorder['province'] = preg_replace('/( | | |\s)/',' ',$fullorder['province']);
  173. if(is_numeric($fullorder['pay']))
  174. {
  175. $pay = $this->typeclass->read($fullorder['pay']);
  176. if($pay['classid'] == '4')
  177. {
  178. $fullorder['pay'] = $pay['title'];
  179. }
  180. }
  181. if($fullorder['printcode'] != "USPS")
  182. {
  183. $fullorder['client'] = htmlspecialchars($fullorder['client']);
  184. $fullorder['name'] = htmlspecialchars($fullorder['name']);
  185. }
  186. //增加退货单所需信息
  187. $pt = '';
  188. $fpdata = explode(';',trim($fullorder['fpdata'],';'));
  189. foreach ($fpdata as $v)
  190. {
  191. $p = explode('|',trim($v,'|'));
  192. //$pt .= '<p>'.$p[1].' * '.$p[2].'</p>';
  193. }
  194. $fullorder['pt'] = $pt;
  195. $fullorder['printnumber'] += 2;
  196. //$fullorder['printcode'] = 'HUALEIXW-FEDEX';
  197. //$fullorder['sbbm']= ($fullorder['sbpm'] == 'Hair Sample') ? 67042000 : 67041100;
  198. //$fullorder['sbbm']= 4202320000;//($fullorder['sbpm'] == 'Hair Sample') ? 67042000 : 67041100;
  199. //$fullorder['sbpm']= 'eyelashes';
  200. //$fullorder['zwpm']= '假睫毛';
  201. //$fullorder['sbpm']= 'Satin Bag';
  202. //$fullorder['zwpm']= '袋子';
  203. //$fullorder['hgbm']= 4202320000;
  204. //$fullorder['address'] = '1653 Treutlan Place';
  205. //$fullorder['address2'] = '';
  206. //$fullorder['qm'] = 2;
  207. //$notice = $this->notice->read(6);
  208. //$fcountry['warehouse']['name'] = 'Hair Me Please LLC';
  209. //$fullorder['cxcode'] = strtolower($express['cxcode']);
  210. //$barcode = $this->fedex->get_logistics($fullorder);//获取联邦快递信息
  211. //echo $fullorder['name'];
  212. //$b = $this->yuntu->get_data($fullorder);
  213. //$b = $this->usps->get_logistics($fullorder);
  214. // $fullorder['printcode'] = 'HUALEI-DHL';
  215. //$fullorder['js'] = 2;
  216. // $fullorder['printcode'] = 'usps_priority';
  217. // $b = $this->cne->get_data($fullorder);
  218. //$b = $this->fedexv1->get_data($fullorder);
  219. //echo $fullorder['zzl'];
  220. echo "<pre>";
  221. //$b = $this->usps->get_data_new($fullorder);
  222. //$b = $this->ups->get_data($fullorder);
  223. echo "<pre>";
  224. print_r($b);
  225. $this->_pdf($b['labelImage'],"test",date("Ymd"));
  226. }
  227. public function get_data($data)
  228. {
  229. $ToState = array('alabama'=>'AL','alaska'=>'AK','arizona'=>'AZ','arkansas'=>'AR','california'=>'CA','colorado'=>'CO','connecticut'=>'CT','delaware'=>'DE','florida'=>'FL','georgia'=>'GA','hawaii'=>'HI','idaho'=>'ID','illinois'=>'IL','indiana'=>'IN','iowa'=>'IA','kansas'=>'KS','kentucky'=>'KY','louisiana'=>'LA','maine'=>'ME','maryland'=>'MD','massachusetts'=>'MA','michigan'=>'MI','minnesota'=>'MN','mississippi'=>'MS','missouri'=>'MO','montana'=>'MT','nebraska'=>'NE','nevada'=>'NV','new hampshire'=>'NH','new jersey'=>'NJ','new mexico'=>'NM','new york'=>'NY','north carolina'=>'NC','north dakota'=>'ND','ohio'=>'OH','oklahoma'=>'OK','oregon'=>'OR','pennsylvania'=>'PA','rhode island'=>'RI','south carolina'=>'SC','south dakota'=>'SD','tennessee'=>'TN','texas'=>'TX','utah'=>'UT','vermont'=>'VT','virginia'=>'VA','washington'=>'WA','west virginia'=>'WV','wisconsin'=>'WI','wyoming'=>'WY','district of columbia'=>'DC','virgin islands'=>'VI','guam'=>'GU','puerto rico'=>'PR');
  230. $data['province'] = preg_replace('/( | | |\s)/',' ',$data['province']);
  231. $data['province'] = trim($data['province'],' ');
  232. $dataprovince = strlen($data['province'])==2?$data['province']:$ToState[strtolower($data['province'])];
  233. $data['address'] = str_replace(array('#','&#38;','&'),array('%23','%26'),$data['address']);
  234. $data['address2'] = str_replace(array('#','&#38;','&'),array('%23','%26'),$data['address2']);
  235. $data['client'] = str_replace(array('#','&#38;','&'),array('%23','%26'),$data['client']);
  236. $data['name'] = str_replace(array('#','&#38;','&'),array('%23','%26'),$data['name']);
  237. $data['name'] = str_replace(' ',' ',$data['name']);
  238. $xml = "";
  239. $xml .= "<eVSRequest USERID='050GHAIR7974'>";
  240. $xml .= "<Option></Option>";
  241. $xml .= "<Revision>1</Revision>";
  242. $xml .= "<ImageParameters>";
  243. $xml .= "<ImageParameter>4X6LABELP</ImageParameter>";
  244. $xml .= "</ImageParameters>";
  245. $xml .= "<FromName>Kenny Kwok</FromName>";//发件人姓名或公司
  246. $xml .= "<FromFirm>Long Human Hair Factory Inc</FromFirm>";//发件人姓名或公司
  247. $xml .= "<FromAddress1></FromAddress1>";//发件人地址1 公寓或套房号码 不超过50个字符
  248. $xml .= "<FromAddress2>819 6th Avenue Store front</FromAddress2>";//发件人地址2
  249. $xml .= "<FromCity>New York</FromCity>";//发件人城市
  250. $xml .= "<FromState>NY</FromState>";//发件人所属州
  251. $xml .= "<FromZip5>10001</FromZip5>";//发件人邮政编码
  252. $xml .= "<FromZip4></FromZip4>";//发件人邮编2
  253. $xml .= "<FromPhone>8455583605</FromPhone>";//发件人电话,10位
  254. $xml .= "<AllowNonCleansedOriginAddr>true</AllowNonCleansedOriginAddr>";//是否检查地址 true不检查
  255. $xml .= "<ToName>".$data['name']."</ToName>";//收件人名称
  256. $xml .= "<ToFirm></ToFirm>";//收件人名称
  257. if($data['address2'] == "")
  258. {
  259. $xml .= "<ToAddress1>".$data['address2']."</ToAddress1>";//收件人地址1 不超过50个字符
  260. $xml .= "<ToAddress2>".$data['address']."</ToAddress2>";//收件人地址2
  261. }
  262. else
  263. {
  264. $xml .= "<ToAddress1>".$data['address']."</ToAddress1>";//收件人地址1 不超过50个字符
  265. $xml .= "<ToAddress2>".$data['address2']."</ToAddress2>";//收件人地址2
  266. }
  267. $xml .= "<ToCity>".$data['city']."</ToCity>";//收件人城市
  268. $xml .= "<ToState>".$dataprovince."</ToState>";//收件人州
  269. $xml .= "<ToZip5>".trim($data['zipcode'],' ')."</ToZip5>";//收件人邮编
  270. $xml .= "<ToZip4></ToZip4>";//收件人邮编2
  271. $xml .= "<ToPhone></ToPhone>";//收件人电话
  272. $xml .= "<POBox></POBox>";//目标地址是否为邮政信箱。
  273. if($data['qm']==1 && $data['js'] == 1)//如果需要签名,并且快递服务选择优先
  274. {
  275. $ServiceType = 'PRIORITY';
  276. $Container = 'FLAT RATE ENVELOPE';
  277. $ExtraService = '156';
  278. $ExtraServicebx = '125';
  279. }
  280. else if($data['qm']==1 && $data['js'] == 0)//如果需要签名,并且快递服务不选择优先
  281. {
  282. $ServiceType = 'FIRST CLASS';
  283. $Container = 'VARIABLE';
  284. $ExtraService = '120';
  285. $ExtraServicebx = '100';
  286. }
  287. else if($data['qm']==1 && $data['js'] == 2)//如果需要签名,并且快递服务选择PRIORITY EXPRESS
  288. {
  289. $ServiceType = 'PRIORITY EXPRESS';
  290. $Container = 'FLAT RATE ENVELOPE';
  291. $ExtraServicebx = '101';
  292. }
  293. else if($data['qm']==0 && $data['js'] == 1)//如果不需要签名,并且快递服务选择优先
  294. {
  295. $ServiceType = 'PRIORITY';
  296. $Container = 'FLAT RATE ENVELOPE';
  297. $ExtraServicebx = '125';
  298. }
  299. else if($data['qm']==0 && $data['js'] == 0)//如果不需要签名,并且快递服务不选择优先
  300. {
  301. $ServiceType = 'FIRST CLASS';
  302. $Container = 'VARIABLE';
  303. $ExtraServicebx = '100';
  304. }
  305. else if($data['qm']==0 && $data['js'] == 3)//如果不需要签名,并且快递服务不选择优先
  306. {
  307. $ServiceType = 'Standard Mail Marketing Parcel';
  308. $Container = 'VARIABLE';
  309. $ExtraServicebx = '100';
  310. }
  311. else if($data['qm']==0 && $data['js'] == 2)//如果不需要签名,并且快递服务选择PRIORITY EXPRESS
  312. {
  313. $ServiceType = 'PRIORITY EXPRESS';
  314. $Container = 'FLAT RATE ENVELOPE';
  315. $ExtraServicebx = '125';
  316. }
  317. if($data['email'])
  318. {
  319. if(strlen($data['email']) < 60 && stripos($data['email'],'tiktok') === false)
  320. {
  321. $xml .= "<ToContactPreference>EMAIL</ToContactPreference>";
  322. $xml .= "<ToContactEMail>".$data['email']."</ToContactEMail>";
  323. }
  324. }
  325. $xml .= "<AllowNonCleansedDestAddr>false</AllowNonCleansedDestAddr>";
  326. $xml .= "<WeightInOunces>".$data['zzl']."</WeightInOunces>";//重量
  327. $xml .= "<ServiceType>".$ServiceType."</ServiceType>";//服务类型
  328. $xml .= "<Container>".$Container."</Container>";//货物类型
  329. $xml .= "<Width></Width>";//可选
  330. $xml .= "<Length></Length>";//可选
  331. $xml .= "<Height></Height>";//可选
  332. $xml .= "<Machinable></Machinable>";//可选
  333. $xml .= "<ProcessingCategory></ProcessingCategory>";//可选
  334. $xml .= "<PriceOptions></PriceOptions>";//可选
  335. $xml .= "<InsuredAmount>".$data['bx']."</InsuredAmount>";//保险金 可选
  336. $xml .= "<AddressServiceRequested>True</AddressServiceRequested>";//可选 客户变更地址提醒
  337. /**
  338. $data['qm'] = ($data['qm']==1)?'False':'True';
  339. if($data['qm'] == 'False')
  340. {
  341. $xml .= "<ExpressMailOptions>";
  342. //$xml .= "<DeliveryOption>1</DeliveryOption>";//可选 交付选择 默认1:正常交付
  343. $xml .= "<WaiverOfSignature>".$data['qm']."</WaiverOfSignature>";//可选 接收签名用False
  344. $xml .= "</ExpressMailOptions>";
  345. }
  346. **/
  347. if($data['qm']==1 && $data['js'] == 2)
  348. {
  349. $xml .= "<ExpressMailOptions>";
  350. //$xml .= "<DeliveryOption>1</DeliveryOption>";//可选 交付选择 默认1:正常交付
  351. $xml .= "<WaiverOfSignature>FALSE</WaiverOfSignature>";//可选 接收签名用False
  352. $xml .= "</ExpressMailOptions>";
  353. }
  354. $xml .= "<ShipDate>".date('m/d/Y',time()-(12*3600)+($data['yc']*24*3600))."</ShipDate>";//可选 发货日期 当前至7天 格式 mm/ dd/ yyyy 延迟发货
  355. //$xml .= "<ReturnCommitments>true</ReturnCommitments>";
  356. $xml .= "<CustomerRefNo>".$data['number']."</CustomerRefNo>";//可选 内部编号显示在运单 不超过19字符
  357. $xml .= "<ExtraServices>";
  358. if(isset($ExtraService))
  359. {
  360. $xml .= "<ExtraService>".$ExtraService."</ExtraService>";//可选额外服务
  361. }
  362. if($data['bx'] > 0)
  363. {
  364. $xml .= "<ExtraService>".$ExtraServicebx."</ExtraService>";//可选额外服务
  365. }
  366. $xml .= "</ExtraServices>";
  367. $xml .= "<ReceiptOption>NONE</ReceiptOption>";//可选打印布局SEPARATE PAGE 或NONE
  368. $xml .= "<ImageType>PDF</ImageType>";//输出类型
  369. $xml .= "<HoldForManifest>Y</HoldForManifest>";
  370. $xml .= "<PrintCustomerRefNo>true</PrintCustomerRefNo>";//内部编号显示要用这个标签
  371. $xml .= "</eVSRequest>";
  372. /** 直连 **/
  373. $ch = curl_init();
  374. $url = 'https://secure.shippingapis.com/ShippingAPI.dll?API=eVS&XML='.$xml;
  375. $url = str_replace(" ",'%20',$url);
  376. curl_setopt($ch,CURLOPT_URL,$url);
  377. curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
  378. curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,0);
  379. curl_setopt($ch,CURLOPT_SSL_VERIFYPEER, FALSE); // https请求 不验证证书和hosts
  380. curl_setopt($ch,CURLOPT_SSL_VERIFYHOST, FALSE);
  381. curl_setopt($ch,CURLOPT_TIMEOUT,25);
  382. $data = curl_exec($ch);
  383. curl_close($ch);
  384. $data = utf8_encode($data);
  385. libxml_disable_entity_loader(true);
  386. // @$values = json_decode(json_encode(simplexml_load_string($data, 'SimpleXMLElement', LIBXML_NOCDATA)), true);
  387. return $data;
  388. /**
  389. $ch = curl_init();
  390. $url = 'http://z.wepolicy.cn/usps.php?XML='.$xml;
  391. $url = str_replace(" ",'%20',$url);
  392. curl_setopt($ch,CURLOPT_URL,$url);
  393. curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
  394. curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,0);
  395. curl_setopt($ch,CURLOPT_SSL_VERIFYPEER, FALSE); // https请求 不验证证书和hosts
  396. curl_setopt($ch,CURLOPT_SSL_VERIFYHOST, FALSE);
  397. curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,35);
  398. $data = curl_exec($ch);
  399. curl_close($ch);
  400. $data = json_decode($data,TRUE);
  401. return $data;
  402. //Description提示错误 LabelImage运单PDF BarcodeNumber运单号
  403. **/
  404. }
  405. public function _pdf($pdf,$title,$bctime)
  406. {
  407. $pdf_path = './data/pdf/'.$bctime.'/';
  408. $file_base64 = $pdf;
  409. $file_base64 = preg_replace('/data:.*;base64,/i', '', $file_base64);
  410. $file_base64 = base64_decode($file_base64);
  411. if(!is_dir($pdf_path))mkdir($pdf_path,0777); //上传目录不存在则创建
  412. file_put_contents($pdf_path.$title.'.pdf',$file_base64);
  413. return $bctime;
  414. }
  415. public function _qk()//清空用友数据
  416. {
  417. $sc = array();
  418. $a = $this->fullorder->find_all("scapi = '99'");
  419. foreach ($a as $v)
  420. {
  421. if(stripos($v['scid'],'XD') === false || $v['scid'] == '|' || $v['scid'] == '')
  422. {
  423. $this->fullorder->save(array('scid'=>'','scapi'=>0,'dbapi'=>0),$v['id']);
  424. continue;
  425. }
  426. $b = explode('|',trim($v['scid'],'|'));
  427. $b = explode('~',trim($b[0],'~'));
  428. //$c = str_replace('XD','',$b[1]);
  429. if(strlen($b[1]) != 12)
  430. {
  431. $this->fullorder->save(array('scid'=>'','scapi'=>0,'dbapi'=>0),$v['id']);
  432. continue;
  433. }
  434. }
  435. echo "<pre>";
  436. print_r($sc);
  437. exit;
  438. }
  439. public function _w($arg_array)
  440. {
  441. $a = $this->whlabel->read($arg_array[0]);
  442. $s = $this->whlabel->find_all("features = '".$a['features']."'");
  443. echo "<pre>";
  444. print_r($a);
  445. echo "<pre>";
  446. print_r($s);
  447. exit;
  448. }
  449. public function _qczd($arg_array)//清空用友数据
  450. {
  451. $a = $this->whlabel->find_all("zd = '$arg_array[0]'");
  452. foreach ($a as $v)
  453. {
  454. $this->whlabel->save(array('zd'=>''),$v['id']);
  455. }
  456. }
  457. public function _d($arg_array)
  458. {
  459. $a = $this->fullorder->get_number($arg_array[0]);
  460. if(!$a)
  461. {
  462. //$a = $this->fullorder->get_orderinfo($arg_array[0]);
  463. if(!$a)
  464. {
  465. $a = $this->fullordersmt->get_number($arg_array[0]);
  466. if(!$a)
  467. {
  468. //$a = $this->fullordersmt->get_orderinfo($arg_array[0]);
  469. if(!$a)
  470. {
  471. $a = $this->fullordertt->get_number($arg_array[0]);
  472. if(!$a)
  473. {
  474. $a = $this->fullorderxw->get_number($arg_array[0]);
  475. if(!$a)
  476. {
  477. //$a = $this->fullordertt->get_orderinfo($arg_array[0]);
  478. }
  479. }
  480. }
  481. }
  482. }
  483. }
  484. if($a)
  485. {
  486. echo "<pre>";
  487. print_r($a);
  488. }
  489. else
  490. {
  491. echo "没有此数据";
  492. }
  493. exit;
  494. }
  495. public function _wz($arg_array)
  496. {
  497. if(!isset($arg_array[1]))
  498. {
  499. //echo "没有位置数据";
  500. return "没有位置数据";
  501. }
  502. $cid = $this->whlabellabel->find_all("cpid = '".$arg_array[0]."'");
  503. if(isset($cid[0]))
  504. {
  505. $w = $this->whlabel->find_all("number = '".$cid[0]['number']."' and warehouse = '13'");
  506. foreach ($w as $v)
  507. {
  508. $this->whlabel->save(array('details'=>$arg_array[1]),$v['id']);
  509. }
  510. echo json_encode(array('msg'=>'!','success'=>true));exit;
  511. //echo '成功';
  512. //echo "<pre>";
  513. //print_r($w);
  514. }
  515. }
  516. public function _qkyy($arg_array)//清空备货用友数据
  517. {
  518. $y = $this->whlabel_bh->read($arg_array[0]);
  519. if($y)
  520. {
  521. $this->whlabel_bh->save(array('scid'=>'','scapi'=>0,'dbapi'=>0,'state'=>0),$y['id']);
  522. echo 'ok';
  523. }
  524. else
  525. {
  526. echo '没有ID';
  527. }
  528. }
  529. public function _cxxq()//查询独立站订单详情
  530. {
  531. $value = $this->shop->read(3);
  532. $res = $this->get_hq($value['brandname'],$value['shopadmin'],$value);
  533. echo "<pre>";
  534. print_r($res);
  535. }
  536. public function get_hq($name,$shopapi,$shop)
  537. {
  538. $jqtime = ($name=='SuperNova')?24*3600:2*3600;
  539. $fromTime = time()-24*3600-$jqtime;//strtotime('yesterday')-$jqtime;//昨日0点+1小时保险无漏单
  540. $toTime = time();
  541. $post['cs'] = 1;
  542. $post['name'] = $name;
  543. $post['from'] = $fromTime;
  544. $post['to'] = $toTime;
  545. $ch = curl_init();
  546. curl_setopt($ch,CURLOPT_URL,$shopapi);
  547. curl_setopt($ch, CURLOPT_POST, 1);
  548. curl_setopt($ch, CURLOPT_HEADER, 0);
  549. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
  550. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
  551. curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1);
  552. curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($post));
  553. curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  554. curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,1800000);
  555. $res = curl_exec($ch);
  556. curl_close($ch);
  557. if($res)
  558. {
  559. $res = json_decode($res,true);
  560. $x = array();
  561. foreach ($res as $v)
  562. {
  563. $source = '';
  564. $sc = substr($v['order_id'],0,3);
  565. if($sc == '600')
  566. {
  567. $source = $shop['thurl']; //手机订单
  568. }
  569. else
  570. {
  571. $source = $shop['url'];//PC订单
  572. }
  573. if($v['wjauthorid'] != '' && $v['sourcecontentid'] != '' && $source != '' && $shop['tweak'] != '')
  574. {
  575. $authorid = $this->authorid($source.'?author_id='.$v['wjauthorid'].'&source_content_id='.$v['sourcecontentid'],$shop['tweak']);
  576. if($authorid)
  577. {
  578. $v['authorid'] = $authorid;
  579. }
  580. }
  581. $x[] = $v;
  582. }
  583. return $x;
  584. }
  585. }
  586. public function _user($arg_array)//查询独立站订单详情
  587. {
  588. $id = $arg_array[0];
  589. $d = $arg_array[1];
  590. $shop = $this->shop->read($id);
  591. $value = $this->user->find_all("shop not like '|".$id."|' and shop like '%|".$d."|%'");
  592. foreach ($value as $v)
  593. {
  594. //$this->user->save(array('shop'=>$v['shop'].$id.'|','shoptext'=>$v['shoptext'].$shop[''].'|'),$v['id']);
  595. }
  596. echo "<pre>";
  597. print_r($value);
  598. }
  599. }