Aatest.php 46 KB

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