Aatest.php 43 KB

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