Aatest.php 53 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420
  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. }
  76. //定义方法的调用规则 获取URI第二段值
  77. public function _remap($arg,$arg_array)
  78. {
  79. // $this->_notice();
  80. // die;
  81. // $list = explode(',',"14-36 Inch Water Wave Wigs HD Human Hair Lace Front And 5x5 Closure Wigs - 13x6 HD Lace / 30 / 180%");
  82. // echo "<pre>";
  83. // var_dump($list);
  84. die;
  85. // echo substr("FN0205389",0,1);
  86. // die;
  87. // echo "<pre>";
  88. // $url = "https://xxu7p0-3q.myshopify.com/admin/api/2022-10/orders/5907496796348/fulfillment_orders.json";
  89. // $headerA = array();
  90. // $headerA[] = "X-Shopify-Access-Token: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";
  91. // var_dump($url);
  92. // var_dump($headerA);
  93. // $ch = curl_init();
  94. // curl_setopt($ch, CURLOPT_URL, $url);
  95. // curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  96. // curl_setopt($ch, CURLOPT_HTTPHEADER, $headerA);
  97. // curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  98. // curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
  99. // $res = curl_exec($ch);
  100. // // 检查是否有错误发生
  101. // if(curl_errno($ch)) {
  102. // echo 'cURL error: ' . curl_error($ch);
  103. // }
  104. // curl_close($ch);
  105. // var_dump($res);
  106. // $post = [];
  107. // $post['shopify_yd_one'] = 1;
  108. // echo "<pre>";
  109. // $post['url'] = "https://xxu7p0-3q.myshopify.com/admin/api/2022-10/orders/5908299219132/fulfillment_orders.json";
  110. // $post['token'] = "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";
  111. // var_dump($post);
  112. // $ch = curl_init();
  113. // curl_setopt($ch,CURLOPT_URL,'https://edm.alipearl.net/soapapi.php');
  114. // curl_setopt($ch, CURLOPT_POST, 1);
  115. // curl_setopt($ch, CURLOPT_HEADER, 0);
  116. // curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
  117. // curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
  118. // curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1);
  119. // curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($post));
  120. // curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  121. // curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,1800000);
  122. // $res = curl_exec($ch);
  123. // var_dump($res);
  124. // die;
  125. $str = '{"fulfillment":{"notify_customer":false,"tracking_info":{"number":"9210890251001300104198","company":"USPS"},"line_items_by_fulfillment_order":[{"fulfillment_order_id":"7008714555580"}]}}';
  126. $data = [
  127. 'token'=>'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',
  128. 'shopify_yd_two'=>1,
  129. 'url'=>'https://xxu7p0-3q.myshopify.com/admin/api/2022-10/fulfillments.json',
  130. 'data'=>json_decode($str),
  131. ];
  132. $ch = curl_init();
  133. curl_setopt($ch,CURLOPT_URL,'https://edm.alipearl.net/soapapi.php');
  134. curl_setopt($ch, CURLOPT_POST, 1);
  135. curl_setopt($ch, CURLOPT_HEADER, 0);
  136. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
  137. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
  138. curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1);
  139. curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($data));
  140. curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  141. curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,1800000);
  142. $res = curl_exec($ch);
  143. var_dump($res);
  144. die;
  145. //7007609290940
  146. $url = "https://xxu7p0-3q.myshopify.com/admin/api/2022-10/fulfillments.json";
  147. $str = '{"fulfillment":{"notify_customer":false,"tracking_info":{"number":"9205590251001300110738","company":"USPS"},"line_items_by_fulfillment_order":[{"fulfillment_order_id":"7007609290940"}]}}';
  148. $data = [
  149. 'token'=>'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',
  150. 'shopify_yd_two'=>1,
  151. 'url'=>'https://xxu7p0-3q.myshopify.com/admin/api/2022-10/fulfillments.json',
  152. 'data'=>json_decode($str),
  153. ];
  154. echo "<pre>";
  155. print_r(json_encode($data)) ;
  156. die;
  157. $header = array();
  158. $header[] = "Content-Type: application/json";
  159. $header[] = "X-Shopify-Access-Token: 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";
  160. $ch = curl_init();
  161. curl_setopt($ch, CURLOPT_URL, $url);
  162. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  163. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  164. curl_setopt($ch, CURLINFO_HEADER_OUT, true);
  165. curl_setopt($ch, CURLOPT_POST, true);
  166. curl_setopt($ch, CURLOPT_POSTFIELDS, $str);
  167. // ========== 关键修复设置 ==========
  168. // 1. 强制使用 TLS 1.2(Shopify 要求)
  169. curl_setopt($ch, CURLOPT_SSLVERSION, CURL_SSLVERSION_TLSv1_2);
  170. // 2. 启用 DNS 缓存(避免 DNS 解析问题)
  171. curl_setopt($ch, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  172. // 3. 修复 Keep-Alive 问题
  173. curl_setopt($ch, CURLOPT_TCP_KEEPALIVE, 1);
  174. curl_setopt($ch, CURLOPT_TCP_KEEPIDLE, 10);
  175. curl_setopt($ch, CURLOPT_TCP_KEEPINTVL, 10);
  176. // 4. 连接超时设置(毫秒)
  177. curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30);
  178. curl_setopt($ch, CURLOPT_TIMEOUT, 60);
  179. // 5. 调试信息捕获(关键)
  180. curl_setopt($ch, CURLOPT_VERBOSE, true);
  181. $verbose = fopen('php://temp', 'w+');
  182. curl_setopt($ch, CURLOPT_STDERR, $verbose);
  183. // 6. 确保正确解析 SNI(服务器名称指示)
  184. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  185. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
  186. // ================================
  187. $res = curl_exec($ch);
  188. // 错误处理增强
  189. if (curl_errno($ch)) {
  190. $error = curl_error($ch);
  191. $errno = curl_errno($ch);
  192. // 获取详细调试信息
  193. rewind($verbose);
  194. $verboseLog = stream_get_contents($verbose);
  195. echo "cURL 错误 ($errno): $error\n";
  196. echo "详细调试信息:\n" . $verboseLog . "\n";
  197. // 获取更多连接信息
  198. $info = curl_getinfo($ch);
  199. echo "连接信息:\n";
  200. print_r([
  201. 'http_code' => $info['http_code'] ?? null,
  202. 'primary_ip' => $info['primary_ip'] ?? null,
  203. 'primary_port' => $info['primary_port'] ?? null,
  204. 'local_ip' => $info['local_ip'] ?? null,
  205. 'local_port' => $info['local_port'] ?? null
  206. ]);
  207. } else {
  208. // 成功时获取请求头信息
  209. $sentHeaders = curl_getinfo($ch, CURLINFO_HEADER_OUT);
  210. echo "发送的请求头:\n$sentHeaders\n";
  211. }
  212. curl_close($ch);
  213. echo $res;
  214. die;
  215. // die;
  216. // $url = "https://xxu7p0-3q.myshopify.com/admin/api/2025-07/orders/5908608483516/fulfillments.json";
  217. // $headerA[] = "X-Shopify-Access-Token: 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";
  218. // $ch = curl_init();
  219. // curl_setopt($ch, CURLOPT_URL, $url);
  220. // curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  221. // curl_setopt($ch, CURLOPT_HTTPHEADER, $headerA);
  222. // curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  223. // curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  224. // $res = curl_exec($ch);
  225. // $headerA = curl_getinfo($ch);
  226. // echo "<pre>";
  227. // var_dump($res);
  228. // die;
  229. $str = '{
  230. "fulfillment": {
  231. "notify_customer": false,
  232. "tracking_info": {
  233. "number": "9210890251001300104181",
  234. "company": "USPS"
  235. },
  236. "line_items_by_fulfillment_order": [
  237. ]
  238. }
  239. }';
  240. $arr = json_decode($str,true);
  241. $arr['fulfillment']['line_items_by_fulfillment_order'] = [
  242. ['fulfillment_order_id'=>'7009089323196']
  243. ];
  244. echo json_encode($arr);
  245. die;
  246. // $url = 'https://xxu7p0-3q.myshopify.com/admin/api/2022-10/fulfillments.json';
  247. // $header[] = "Content-Type: application/json";
  248. // $header[] = "X-Shopify-Access-Token: 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";
  249. // $ch = curl_init();
  250. // curl_setopt($ch, CURLOPT_URL, $url);
  251. // curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  252. // curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  253. // curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  254. // curl_setopt($ch, CURLOPT_POST, 1);
  255. // curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($arr));
  256. // curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  257. // curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  258. // $res = curl_exec($ch);
  259. // echo "<pre>";
  260. // var_dump($res);
  261. // die;
  262. $str = '{
  263. "fulfillment": {
  264. "notify_customer": false,
  265. "tracking_info": {
  266. "number": "9210890251001300104181",
  267. "company": "USPS"
  268. },
  269. "line_items_by_fulfillment_order": [
  270. ]
  271. }
  272. }';
  273. $arr = json_decode($str,true);
  274. $arr['fulfillment']['line_items_by_fulfillment_order'] = [
  275. 'fulfillment_order_id'=>'5908608483516'
  276. ];
  277. echo "<pre>";
  278. print_r(json_encode($arr));
  279. die;
  280. $ddh = "5908608483516";
  281. $ydh = "9210890251001300104181";
  282. $xg = $this->fullorder->read(1266262);
  283. $shop = $this->shop->read($xg['shop']);
  284. $ex = $this->express->read($xg['express']);
  285. $remark = "";
  286. $shopifyid = "";
  287. $gx = $this->api->get_gx($ddh,$ydh,$xg,$shop,$ex,$remark,$shopifyid);
  288. // $shopname = "yolissahair";
  289. // if(in_array($shopname,['alipearlstore','finsahair','baddiebeautyshop','yolissahair'])){
  290. // var_dump(true);
  291. // }else{
  292. // var_dump(false);
  293. // }
  294. $apiKey = "599c76d5939f1d868d71ab78a82298c7";
  295. $apiPassword = "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";
  296. $shopName = "xxu7p0-3q"; // 仅店铺名称部分
  297. $apiVersion = "2022-10";
  298. // 构建请求URL
  299. $url = "https://".$apiKey.":".$apiPassword."@".$shopName.".myshopify.com/admin/api/".$apiVersion."/orders.json?status=any&limit=100";
  300. echo $url;
  301. die;
  302. // 初始化cURL
  303. $ch = curl_init();
  304. curl_setopt($ch, CURLOPT_URL, $url);
  305. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  306. curl_setopt($ch, CURLOPT_HTTPHEADER, [
  307. 'Content-Type: application/json'
  308. ]);
  309. // 执行请求
  310. $response = curl_exec($ch);
  311. $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
  312. if (curl_errno($ch)) {
  313. die('cURL Error: ' . curl_error($ch));
  314. }
  315. curl_close($ch);
  316. // 处理响应
  317. if ($httpCode == 200) {
  318. $orders = json_decode($response, true);
  319. if (isset($orders['orders'])) {
  320. foreach ($orders['orders'] as $order) {
  321. echo "Order ID: " . $order['id'] . "\n";
  322. echo "Customer: " . $order['customer']['email'] . "\n";
  323. echo "Total: $" . $order['total_price'] . "\n\n";
  324. }
  325. } else {
  326. echo "No orders found.";
  327. }
  328. } else {
  329. die("API Error: HTTP $httpCode | Response: $response");
  330. }
  331. die;
  332. $warehouse = $this->warehouse->read(5);
  333. $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;");
  334. die;
  335. $data = $this->fullordertt->get_orderinfo("577020026957566570");
  336. $bctime = date('Ymd',time());
  337. if($data['library'] != 2){
  338. echo json_encode(array('msg'=>'此单不是出库状态,不允许退货','success'=>false));exit;
  339. }
  340. if($data['returndata'] != "")
  341. {
  342. echo json_encode(array('msg'=>'请求失败,已有Return Label信息!','success'=>false));exit;
  343. }
  344. $barcode = $this->usps->get_return_two($data);
  345. echo "<pre>";
  346. print_r($barcode);
  347. die;
  348. die;
  349. echo "<pre>";
  350. var_dump(date("Y-m-d H:i:s"));
  351. $post['shopify'] = 'https://ecdfe1ed62bedcbc70408fe0cd23ec40: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@karla-c561.myshopify.com/admin/api/2023-07/orders.json?status=any&limit=100';
  352. $ch = curl_init();
  353. curl_setopt($ch,CURLOPT_URL,'https://edm.alipearl.net/soapapi.php');
  354. curl_setopt($ch, CURLOPT_POST, 1);
  355. curl_setopt($ch, CURLOPT_HEADER, 0);
  356. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
  357. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
  358. curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1);
  359. curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($post));
  360. curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  361. curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,1800000);
  362. $res = curl_exec($ch);
  363. curl_close($ch);
  364. var_dump(date("Y-m-d H:i:s"));
  365. print_r($res);
  366. die;
  367. // $this->load->library('session');
  368. //$this->itsxb->getLabel('3PE0147167512300');
  369. //$this->itsxb->getWuliuFs();
  370. //$this->_a();
  371. // $this->zzjobs->insert([
  372. // 'status'=>0,
  373. // 'quque'=>'ysgjcx',//云尚轨迹查询
  374. // 'payload'=>json_encode([
  375. // 'v'=>$v,
  376. // 'id'=>$var['id']
  377. // ],JSON_UNESCAPED_UNICODE),
  378. // 'do_interval'=>1,
  379. // 'create_time'=>time()
  380. // ]);
  381. //$this->_getorder();
  382. // if($arg == 'fout')
  383. // {
  384. // //$this->_fout();
  385. // }else if($arg == 'waybillemail'){
  386. // //$this->_waybillemail();
  387. // }else if($arg == 'getorder'){
  388. // //$this->_getorder();
  389. // }elseif($arg == 'logistic'){
  390. // $this->_logistic($arg_array);
  391. // }elseif($arg == 'th'){
  392. // // $this->_th($arg_array);
  393. // }else{
  394. //$this->_logistic();
  395. //$this->linshi();
  396. // //$this->_mdedit($arg_array);
  397. // }
  398. //$this->_print();
  399. // die;
  400. // $time = time() - 10 * 3600 * 24;
  401. // //快递为3pe 76 出库时间十天前 waybillid 不能为空
  402. // $where = "express = 76 and librarytime >= ".$time ." and waybillid is not null";
  403. // $list = $this->fullorder->find_all($where,"id,number,waybill,waybillid,librarytime,express");
  404. // echo "<pre>";
  405. // print_r($list);
  406. // $res = $this->itsxb->getDetail('QQS-50621-021');
  407. // echo "<pre>";
  408. // print_r($res);
  409. // die;
  410. // $waybill_numbers = [
  411. // 'YT2515001700102272',
  412. // 'YT2514801700301845',
  413. // 'YT2514901700303013',
  414. // 'YT2514901700303005'
  415. // ];
  416. // $res = $this->yuntu->getTransferNumber($waybill_numbers);
  417. // $end_time = time() - 10 * 3600 * 24;
  418. // $start_time = time() - 3 * 3600 * 24;
  419. // //快递为3pe 76 出库时间十天前 waybillid 不能为空
  420. // $where = "express in (66,67) and librarytime >= ".$end_time ." and librarytime <= ".$start_time." ";
  421. // //$where = "express = 76 and librarytime <= ".$start_time." ";
  422. // $fields = "id,number,waybill,waybillid,librarytime,express";
  423. // $list = $this->fullorder->find_all($where,$fields);
  424. // //echo "<pre>";
  425. // $final_list = [];
  426. // foreach($list as $item){
  427. // if(empty($item['waybillid'])){
  428. // $final_list[] = $item['waybill'];
  429. // }else{
  430. // continue;
  431. // }
  432. // }
  433. // array_unique($final_list);
  434. // echo "<pre>";
  435. // var_dump($list);
  436. // var_dump($final_list);
  437. // die;
  438. // echo date("H",time());
  439. // set_time_limit(0);
  440. // $this->job_getyuntuwaybillid->do_job();
  441. //$this->job_get3pewaybillid->do_job();
  442. }
  443. public function _notice(){
  444. $notice = $this->notice->read(30);
  445. $v = $this->fullorder->get_number('Y-50728-010');
  446. $shop = $this->shop->read($v['shop']);
  447. $express = $this->express->read($v['express']);
  448. echo "<pre>";
  449. print_r($notice);
  450. print_r($v);
  451. print_r($shop);
  452. die;
  453. $fs = $this->notice->get_god($v,$shop,$express,$notice);
  454. }
  455. public function _error(){
  456. // echo $c;
  457. set_error_handler(function($severity, $message, $file, $line) {
  458. // 自定义错误处理逻辑
  459. throw new ErrorException($message, 0, $severity, $file, $line);
  460. //return true; // 返回true表示已处理,阻止CI继续处理
  461. });
  462. set_exception_handler(function($exception) {
  463. // 自定义异常处理逻辑
  464. // 一般也就是处理一下抛出可允许的错误 允许往下执行 目前这里不做任何处理 只关注于 sql的错误和程序执行的异常
  465. });
  466. $this->db->db_debug = false;
  467. $this->db->trans_begin();
  468. try{
  469. $do_sql = $this->db->insert('table', []);
  470. if(!$do_sql){
  471. throw new Exception("sql error:【".$this->db->error()['message']."】");
  472. }
  473. }catch(Exception $e){
  474. $this->db->trans_rollback();
  475. exit(json_encode(['msg'=>$e->getMessage(),'success'=>false],JSON_UNESCAPED_UNICODE));
  476. }finally{
  477. if ($this->db->trans_status() === TRUE)
  478. {
  479. $this->db->trans_commit();
  480. exit(json_encode(['msg'=>"操作成功",'success'=>true],JSON_UNESCAPED_UNICODE));
  481. }
  482. else
  483. {
  484. $this->db->trans_rollback();
  485. exit(json_encode(['msg'=>"sql语句执行",'success'=>false],JSON_UNESCAPED_UNICODE));
  486. }
  487. }
  488. }
  489. public function _plcl(){
  490. $typeclass = [];
  491. $classid = $this->classid->sku();
  492. $tcall = $this->typeclass->find_all();
  493. foreach ($tcall as $v)
  494. {
  495. //$tcjm[$v['id']] = array($v['jm'],$v['classid']);
  496. $typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
  497. }
  498. $dtctitle = [];
  499. foreach($tcall as $v){
  500. $dtctitle[$v['id']] = $v['title'];
  501. }
  502. $dtc = [];
  503. foreach ($tcall as $v) {
  504. if (stripos($v['spare'], '|') !== false) //如果有多个值
  505. {
  506. $v['spare'] = explode('|', $v['spare']);
  507. foreach ($v['spare'] as $k => $vs) {
  508. if (stripos($v['zh'], '|') !== false) {
  509. $vzh = explode('|', $v['zh']);
  510. $dtc[strtolower($vs)] = array('classid' => $v['classid'], 'zh' => $vzh[$k], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $vs);
  511. } else {
  512. $dtc[strtolower($vs)] = array('classid' => $v['classid'], 'zh' => $v['zh'], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $vs);
  513. }
  514. }
  515. } else {
  516. $dtc[strtolower($v['spare'])] = array('classid' => $v['classid'], 'zh' => $v['zh'], 'id' => $v['id'], 'jm' => $v['jm'], 'spare' => $v['spare']);
  517. }
  518. }
  519. $tmp_sku ="RTG-A033-STW-13*4BobWig-250%-10";
  520. $u9_info = $this->logic_order->skuTransferFeatures($tmp_sku,$typeclass,$dtc,$dtctitle,$classid);
  521. echo "<pre>";
  522. var_dump($tmp_sku);
  523. var_dump($u9_info);
  524. die;
  525. }
  526. public function _print(){
  527. $this->_Template('aaadayin',$this->data);
  528. }
  529. public function _doWcCp(){
  530. $info = $this->zzhjobs->find("status = 0");
  531. $this->zzhjobs->save(['status'=>30],$info['id']);
  532. echo "<pre>";
  533. $info['payload'] = json_decode($info['payload'],true);
  534. //print_r($info);
  535. var_dump($info['payload']);
  536. $lb = $this->systemtransfer->read($info['payload']['fid']);
  537. $nu = $this->fullorder->get_number($lb['number']);
  538. if(!$nu)
  539. {
  540. $nu = $this->fullordersmt->get_number($lb['number']);
  541. if(!$nu)
  542. {
  543. $nu = $this->fullordertt->get_number($lb['number']);
  544. }
  545. }
  546. if(empty($nu)){
  547. echo "数据不存在";
  548. die;
  549. }
  550. $s = $this->shop->read($nu['shop']);
  551. $lb['kh'] = $s['yyid'];
  552. $lb['ts'] = 1;
  553. // var_dump($lb);
  554. $rk = $this->apiyy->_newrk($lb);
  555. var_dump($rk);
  556. // $list = $this->zzerrlog->find_all("content like '%检测货物流转打印情况13|2%' and time >= 1745881418 and time <= 1745967818 ");
  557. // echo "<pre>";
  558. // print_r(count($list));
  559. // foreach($list as $k=>$v){
  560. // $tmp_arr = explode("|",$v['content']);
  561. // $params = [
  562. // "transfer"=>13,
  563. // "type"=>2,
  564. // "number"=>$tmp_arr[2],
  565. // 'fid'=>$tmp_arr[3]
  566. // ];
  567. // $this->zzhjobs->insert(
  568. // [
  569. // 'status'=>0,
  570. // 'quque'=>'xgwsu9',
  571. // 'payload'=>json_encode($params),
  572. // 'do_interval'=>1,
  573. // 'create_time'=>time(),
  574. // ]
  575. // );
  576. // }
  577. }
  578. public function _th($arg_array){
  579. die;
  580. if(empty($arg_array)){
  581. die(1);
  582. }
  583. $order_no = $arg_array[0];
  584. var_dump($order_no);
  585. $data = $this->fullorder->get_number($order_no);
  586. if(empty($data)){
  587. echo 2;
  588. exit(2);
  589. }
  590. $r = $this->usps->get_return($data);
  591. echo "<pre>";
  592. print_r($r);
  593. }
  594. //物流轨迹
  595. public function _logistic(){
  596. echo "<pre>";
  597. $fs = $this->cne->get_logistics_yskx([
  598. [
  599. "TrackNumber"=>"880739284316",
  600. ]
  601. ]);
  602. print_r($fs);
  603. //$fs = $this->usps->get_logistics($v);
  604. die;
  605. }
  606. public function _getorder(){
  607. $name = 'SuperNova';
  608. $userKey = array(
  609. 'Alipearl' => array('username'=>'huchunmei','api_key'=>'huchunmei126_alipearl_erp888','url'=>'https://www.alipearlhair.com'),
  610. 'Asteria' => array('username'=>'huchunmei','api_key'=>'huchunmei126_asteria_erp888','url'=>'https://www.asteriahair.com'),
  611. 'WestKiss' => array('username'=>'huchunmei','api_key'=>'huchunmei126_westkiss_erp868','url'=>'https://www.westkiss.com'),
  612. 'SuperNova' => array('username'=>'huchunmei','api_key'=>'huchunmei126_supernova_erp6898','url'=>'https://www.supernovahair.com'),
  613. 'Wiggins' => array('username'=>'huchunmei','api_key'=>'huchunmei126_wiggins_erp652','url'=>'https://www.wigginshair.com'),
  614. 'Yolissa' => array('username'=>'huchunmei','api_key'=>'huchunmei126_yolissa_688','url'=>'https://www.yolissahair.com'),
  615. );
  616. $proxy = new SoapClient($userKey[$name]['url'].'/api/soap/?wsdl');
  617. try {
  618. $sessionId = $proxy->login($userKey[$name]['username'], $userKey[$name]['api_key']);
  619. }
  620. catch (Exception $e) {
  621. echo $e->getMessage();
  622. }
  623. $data = array('proxy'=>$proxy,'sessionId'=>$sessionId,'url'=>$userKey[$name]['url']);
  624. $fromTime = date('Y-m-d H:i:s',time()- 3600*24*6);
  625. $toTime = date('Y-m-d H:i:s',time());
  626. $filters = array(array('created_at'=>array('from'=>$fromTime,'to'=>$toTime)));
  627. $result = $data['proxy']->call($data['sessionId'],'sales_order.list',$filters);
  628. echo "<pre>";
  629. // print_r($result[0]);
  630. foreach($result as $item)
  631. {
  632. // print_r($item);exit;
  633. $iteminfo= $data['proxy']->call($data['sessionId'], 'sales_order.info', $item['increment_id']);
  634. print_r($iteminfo['items']);
  635. }
  636. }
  637. public function getDtc(){
  638. $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');
  639. $dtc = array();
  640. foreach ($dictionaries as $v)
  641. {
  642. if(stripos($v['spare'],'|') !== false)//如果有多个值
  643. {
  644. $v['spare'] = explode('|',$v['spare']);
  645. foreach ($v['spare'] as $k=>$vs)
  646. {
  647. if(stripos($v['zh'],'|') !== false)
  648. {
  649. $vzh = explode('|',$v['zh']);
  650. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  651. }
  652. else
  653. {
  654. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  655. }
  656. }
  657. }
  658. else
  659. {
  660. $dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
  661. }
  662. }
  663. $dtctitle = [];
  664. $dictionaries2 = $this->typeclass->find_all();
  665. foreach ($dictionaries2 as $v)
  666. {
  667. $dtctitle[$v['id']] = $v['title'];
  668. }
  669. return [
  670. 'dtc'=>$dtc,
  671. 'dtctitle'=>$dtctitle
  672. ];
  673. }
  674. public function _a(){
  675. $list = [
  676. [
  677. 'sku2'=>'-1297-80-2602-1306-57-101-1283-',
  678. ]
  679. ];
  680. $r = $this->logic_u9tools->getU9bm($list,'sku2');
  681. echo "<pre>";
  682. var_dump($r);
  683. die;
  684. $data = $this->getDtc();
  685. $dtc = $data['dtc'];
  686. $dtctitle = $data['dtctitle'];
  687. //die;
  688. $quantity = '1';
  689. //$issku = 'NW-Ponytail-10-Accs-175g';
  690. $issku = "Accs-STW-Topper-6*7-8";
  691. $money = array();
  692. $productdescribe = $this->productdescribe->find_all('1=1');
  693. foreach ($productdescribe as $v)
  694. {
  695. $money[$v['number']] = array();
  696. }
  697. /* 价格加入 */
  698. /* 匹配ID加入 */
  699. $int = array();
  700. $intdata = $this->typeclass->find_all('classid=14','id,spare');
  701. foreach ($intdata as $v)
  702. {
  703. $v['spare'] = explode('|',$v['spare']);
  704. $int[$v['id']] = $v['spare'][0];
  705. }
  706. // var_dump($dtc);
  707. // var_dump($dtctitle);
  708. $r = $this->api->matching($quantity,$issku,$dtc,$money,$int,$dtctitle,[1],[
  709. ]);
  710. echo "<pre>";
  711. var_dump($r);
  712. die;
  713. $time = time();
  714. $jiami = "alipearlhair+".(string)$time;
  715. echo json_encode([
  716. 'shop'=>3,
  717. 'waybill'=>'283786008019',
  718. 'time'=>$time,
  719. 'key'=>$this->logic_tools->toolsjiami($jiami,"6amg!pnfrlbpnjgirv", "6ook4k!2w94m6jtm"),
  720. ]);
  721. die;
  722. $dtc = array();
  723. /* 订单号加入键值-j */
  724. /* 匹配加入 */
  725. $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');
  726. // 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)
  727. foreach ($dictionaries as $v)
  728. {
  729. if(stripos($v['spare'],'|') !== false)//如果有多个值
  730. {
  731. $v['spare'] = explode('|',$v['spare']);
  732. foreach ($v['spare'] as $k=>$vs)
  733. {
  734. if(stripos($v['zh'],'|') !== false)
  735. {
  736. $vzh = explode('|',$v['zh']);
  737. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  738. }
  739. else
  740. {
  741. $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
  742. }
  743. }
  744. }
  745. else
  746. {
  747. $dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
  748. }
  749. }
  750. $dtctitle = [];
  751. $dictionaries2 = $this->typeclass->find_all();
  752. foreach ($dictionaries2 as $v)
  753. {
  754. $dtctitle[$v['id']] = $v['title'];
  755. }
  756. echo "<pre>";
  757. $sku = "Free,Gift--PackQQS,NW--3+Ori6*6C-22 24 26-20-6*6C";
  758. $sl = "1;1;1;";
  759. $r = $this->api->matching($sl,$sku,$dtc,"","",$dtctitle,$shop=[],$extra = [
  760. "price"=>"565.7700",
  761. "row_total"=>"565.7700"
  762. ]);
  763. var_dump($r['title']);
  764. $r = $r['product'];
  765. $rr = explode(";",$r);
  766. print_r($rr);
  767. }
  768. public function _fout()
  769. {
  770. $waybill = $this->input->get('waybill');
  771. $info = $this->fullorder->get_waybill($waybill);
  772. //$r = $this->usps->get_new_logistics($info);
  773. $r = $this->fedexv1->get_logistics(123);
  774. echo "<pre>";
  775. var_dump($r);
  776. //$this->fedexv1->makeAccessToken();
  777. }
  778. public function _waybillemail()
  779. {
  780. $urls = array();$sl = 0;$time = time();
  781. $wid = 2;
  782. // if(date("H",time()) == '8' && date("i",time()) > '20' && date("i",time()) < '39')//USPS-USA单
  783. // {
  784. // $wid = 1;
  785. // }
  786. // else if(date("H",time()) == '20' && date("i",time()) > '20' && date("i",time()) < '39')//其他快递
  787. // {
  788. // $wid = 2;
  789. // }
  790. // else
  791. // {
  792. // exit;
  793. // }
  794. $notice = $this->notice->find_all("message = '1' and state = '1' and type = '4' and ktime < '$time' and jtime > '$time'");//已有自动发送,这个是物流发送
  795. foreach ($notice as $key=>$var)
  796. {
  797. $this->_waybillfs([
  798. 'var'=>$var,
  799. 'wid'=>$wid
  800. ]);
  801. }
  802. }
  803. public function upadtel(){
  804. $returngoods_id = 150;
  805. $insert_flag = 1217819;
  806. $number = 'KISS-50206-004';
  807. $returngoods_info = $this->returngoods->read($returngoods_id);
  808. $this->returngoods->save([
  809. 'status'=>80,
  810. 'back_no'=>$number,
  811. 'back_id'=>$insert_flag,
  812. 'update_time'=>date('Y-m-d H:i:s'),
  813. ],$returngoods_id);
  814. $this->returnlogs->insert([
  815. 'rg_id'=>(int)$returngoods_id,
  816. 'operat_id'=>10,
  817. 'operat_name'=>'admin',
  818. 'remark'=>"订单号:".$returngoods_info['orderinfo']."重新换货-换货新订单编码".$number,
  819. 'create_time'=>date('Y-m-d H:i:s'),
  820. ]);
  821. }
  822. public function _waybillfs($data)
  823. {
  824. if($data)
  825. {
  826. $notice = $data['var'];
  827. $notice['email'] = $this->emaildata->read($notice['email']);
  828. $wid = $data['wid'];
  829. $fsjs = "";
  830. if($wid == 1 && (stripos($notice['express'],',2,') !== false || stripos($notice['express'],',63,') !== false || stripos($notice['express'],',64,') !== false))
  831. {
  832. $js = explode(',',trim($notice['js'],','));
  833. if(count($js) > 1)
  834. {
  835. $fsjs = " and (";
  836. foreach ($js as $v)
  837. {
  838. $fsjs .= "js = '$v' or ";
  839. }
  840. $fsjs = trim($fsjs,' or ').")" ;
  841. }
  842. else if(count($js) == 1)
  843. {
  844. $fsjs = " and js = '$js[0]'";
  845. }
  846. $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
  847. }
  848. else if($wid == 2 && stripos($notice['express'],',1,') !== false)
  849. {
  850. $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
  851. }
  852. else
  853. {
  854. exit;
  855. }
  856. $this->logic_ding->sendToDing("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
  857. // $wlfs = array();
  858. // $dd = $this->fullorder->find_all("source != '1' and dlzemail < '1' and shop = '".$notice['shop']."' and library = 2 and ".$where);
  859. // foreach($dd as $v){
  860. // $this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】");
  861. // }
  862. // foreach ($dd as $v)
  863. // {
  864. // $shop = $this->shop->read($v['shop']);
  865. // $express = $this->express->read($v['express']);
  866. // $fs = $this->notice->get_god($v,$shop,$express,$notice);
  867. // $this->logic_ding->sendToDing($v['orderinfo']."监听邮件发送的异常:订单信息【".json_encode($v,JSON_UNESCAPED_UNICODE)."】获取快递信息【".json_encode($notice,JSON_UNESCAPED_UNICODE)."】返回的信息".json_encode($fs));
  868. // if($fs == 1)
  869. // {
  870. // $this->fullorder->save(array('dlzemail'=>1,'dlzemailtime'=>time()),$v['id']);
  871. // //给crm发送信息 先存储数据 后续定时任务执行
  872. // if($v['shop'] < 10){
  873. // $this->zztmpdata->insert([
  874. // 'type'=>2,
  875. // 'act_name'=>'crm_order',
  876. // 'content'=>json_encode($v),
  877. // 'create_time'=>time()
  878. // ]);
  879. // }
  880. // }
  881. // else
  882. // {
  883. // //$pdtime = date('Y-m-d',time());
  884. // //$folderPath = './data/dlzemail/'.$pdtime; // 文件夹路径
  885. // //$permissions = 0777; // 权限设置
  886. // //if (!file_exists($folderPath)) { mkdir($folderPath, $permissions); }//创建文件夹
  887. // //file_exists($folderPath);
  888. // if(!is_file("./data/dlzemail/".$v['number'].".txt"))
  889. // {
  890. // $myfile = fopen("./data/dlzemail/".$v['number'].".txt", "w") or die("Unable to open file!");
  891. // fwrite($myfile, json_encode($fs.';'.$v.';'.$shop.';'.$express.';'.$notice));
  892. // fclose($myfile);
  893. // }
  894. // else
  895. // {
  896. // $myfile = fopen("./data/dlzemail/".$v['number'].".txt", "a+") or die("Unable to open file!");
  897. // fwrite($myfile, json_encode($fs.';'.$v.';'.$shop.';'.$express.';'.$notice));
  898. // fclose($myfile);
  899. // }
  900. // $this->fullorder->save(array('dlzemail'=>2,'dlzemailtime'=>time()),$v['id']);
  901. // }
  902. // sleep(50);
  903. // }
  904. }
  905. }
  906. public function ll(){
  907. $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=&
  908. ';
  909. parse_str($str, $output);
  910. return $output;
  911. }
  912. //修改客户分类
  913. public function _mdedit($arg_array)
  914. {
  915. die;
  916. $user = $this->user->read(10);
  917. $post = $this->ll();
  918. if(isset($post['shop']))
  919. {
  920. $fpcount = $post['fpcount'];
  921. if(!$fpcount)
  922. {
  923. echo json_encode(array('msg'=>'需要先清理浏览器缓存,刷新当前页面后再试!','success'=>false));exit;
  924. }
  925. $customerid = $post['customerid'];
  926. $shop = $post['shop'];
  927. $sp = $this->shop->read($shop);
  928. $num = $this->fullorder->find_count('shop = "'.$sp['id'].'" and gtime = "'.date('Ymd',time()).'"');
  929. $post['source'] = 1;//订单类型:1.线下订单2.PC3.手机
  930. $post['state'] = 207;//订单状态:207等待发货
  931. $post['review'] = 2;//审核状态:1.未送审2.待审核3.不通过4取消重审5.审核通过6.自动通过
  932. $post['print'] = 1;//打印状态:1.不可打印2.未打印3.已打印
  933. $post['library'] = 1;//出库状态:1.未出库2.已出库3.已退库
  934. $post['libraryconfirm'] = 1;//出库确认:1.不允许2.允许
  935. $post['link'] = $sp['link'];
  936. $post['issku'] = $sp['sku'];
  937. if($post['print'] != 3)
  938. {
  939. $post['librarynot'] = "订单未打印,未审核或未通过";//不能出库原因
  940. }
  941. $orderinfo = $post['orderinfo'];
  942. $post['shop'] = $sp['id'];
  943. $post['user'] = $sp['shopuser'];
  944. $post['number'] = $sp['shortname'].'-'.substr(date('ymd',time()),1).'-'.(substr(strval($num+1+1000),1,3));//编号
  945. if($orderinfo != "")
  946. {
  947. $ordefin = $this->fullorder->get_orderinfo($orderinfo);
  948. if($ordefin)
  949. {
  950. echo json_encode(array('msg'=>'订单号重复!','success'=>false));exit;
  951. }
  952. else
  953. {
  954. $post['orderinfo'] = $orderinfo;
  955. }
  956. }
  957. else
  958. {
  959. $post['orderinfo'] = $sp['id'].date('ymdHis',time()).rand(0,1);//订单号
  960. }
  961. if($post['paypal'] != '')
  962. {
  963. $pp = $this->fullorder->get_paypal($post['paypal']);
  964. if($pp)
  965. {
  966. echo json_encode(array('msg'=>'此交易号的订单已存在!','success'=>false));exit;
  967. }
  968. }
  969. $post['client'] = $post['client'];//客户名称
  970. $btime = $post['buytime'];//付款时间
  971. $post['buytime'] = strtotime($btime);//时间转UX
  972. $post['dtime'] = time();//订单时间
  973. $post['gtime'] = date('Ymd',time());//格式化时间
  974. $post['pay'] = $post['pay'];//支付方式
  975. $post['capital'] = $post['capital'];//资金状态
  976. $post['type'] = $post['warehouse'];//发货仓库
  977. $post['currency'] = $post['currency'];//币种
  978. $currency = $this->typeclass->read($post['currency']);
  979. $post['currencytitle'] = $currency['title'];//币种名称
  980. $post['freight'] = $post['freight'];//运费
  981. $post['expressmoney'] = $post['expressmoney'];//物流金额
  982. $post['shouldmoney'] = $post['shouldmoney'];//应收金额
  983. $post['skje'] = $post['shouldmoney'];//收款金额
  984. $product = $post['product'];//产品名称
  985. $product = str_replace(array('%26','%2B'),array('&','+'),$product);
  986. $post['product'] = preg_replace('/( | | |\s)/',' ',$product);
  987. $orderremarks = $post['orderremarks'];//订单备注
  988. $orderremarks = str_replace(array('%26','%2B'),array('&','+'),$orderremarks);
  989. $post['orderremarks'] = preg_replace('/( | | |\s)/',' ',$orderremarks);
  990. $shipremarks = $post['shipremarks'];//仓库品名
  991. $shipremarks = str_replace(array('%26','%2B'),array('&','+'),$shipremarks);//仓库品名
  992. $post['shipremarks'] = preg_replace('/( | | |\s)/',' ',$shipremarks);
  993. $post['email'] = $post['email'];//邮箱
  994. $name = $post['name'];//名称
  995. $post['name'] = preg_replace('/( | | |\s)/',' ',$name);
  996. $post['phone'] = $post['phone'];//电话
  997. $post['phone'] = preg_replace('/\D/s','',$post['phone']);
  998. $post['country'] = $post['country'];//国家
  999. $ct = $this->country->read($post['country']);//国家
  1000. $post['al'] = $ct['lb'];//国家二字码
  1001. $post['province'] = $post['province'];//省、州
  1002. $post['province'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['province']); //替换开头空字符
  1003. $post['province'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['province']); //替换结尾空字符
  1004. $post['city'] = $post['city'];//城市
  1005. $post['city'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['city']); //替换开头空字符
  1006. $post['city'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['city']); //替换结尾空字符
  1007. $post['zipcode'] = $post['zipcode'];//邮编
  1008. $post['zipcode'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['zipcode']); //替换开头空字符
  1009. $post['zipcode'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['zipcode']); //替换结尾空字符
  1010. $post['address'] = $post['address'];//地址
  1011. $post['printtype'] = $post['printtype'];//打印类型
  1012. $fpdata = $post['fpdata'];//购买产品内容
  1013. $fpdata = str_replace(array('%26','%2B'),array('&','+'),$fpdata);
  1014. $post['fpdata'] = $fpdata;
  1015. $post['sbpm'] = $post['sbpm'];//申报品名
  1016. $post['zwpm'] = $post['zwpm'];//中文品名
  1017. $post['ts'] = $post['ts'];//条数
  1018. $post['dtsbjz'] = $post['dtsbjz'];//单条申报价
  1019. $post['zsbjz'] = $post['zsbjz'];//总申报价
  1020. $post['zzl'] = $post['zzl'];//总重量
  1021. $post['zjs'] = $post['zjs'];//总件数
  1022. $post['express'] = $post['express'];//快递公司
  1023. $post['printtype'] = $post['printtype'];//打印类型
  1024. $post['quantity'] = $post['quantity'];//数量
  1025. $post['paypal'] = $post['paypal'];//支付号
  1026. $post['guarantee'] = $post['guarantee'];//卖家保障
  1027. $post['msg'] = $post['msg'];//发送留言类型
  1028. $post['ioss'] = $post['ioss'];
  1029. $post['sbpm'] = $post['sbpm'];
  1030. $pay = $this->pay->get_typeclass($post['pay']);
  1031. $yga = $post['shouldmoney'];
  1032. $post['budget'] = 0;
  1033. if($pay)
  1034. {
  1035. $ygc = $pay['estimaterate'];//预估到账公式
  1036. $ifbudget = eval("return $yga*1.$ygc;");
  1037. $post['estimaterate'] = $pay['estimaterate'];
  1038. if($ifbudget > 0)
  1039. {
  1040. $post['budget'] = eval("return $yga*1.$ygc;");//预估到帐金额
  1041. }
  1042. }
  1043. else
  1044. {
  1045. $ygb = $sp['estimaterate'];//店铺默认到账公式
  1046. $ifbudget = eval("return $yga*1.$ygb;");
  1047. $post['estimaterate'] = $sp['estimaterate'];
  1048. if($ifbudget > 0)
  1049. {
  1050. $post['budget'] = eval("return $yga*1.$ygb;");//预估到帐金额
  1051. }
  1052. }
  1053. $baddress = $post['baddress'];
  1054. $saddress = $post['saddress'];
  1055. $baddress = array_reverse(explode(',',$baddress));
  1056. $saddress = array_reverse(explode(',',$saddress));
  1057. $bar = '';$sar = '';
  1058. $cr = $this->country->read($post['country']);
  1059. $baddress[1] = $cr['lb'];
  1060. $saddress[1] = $cr['lb'];
  1061. $baddress = array_reverse($baddress);
  1062. $saddress = array_reverse($saddress);
  1063. for($i=0;$i<count($baddress);$i++)
  1064. {
  1065. $bar .= $baddress[$i].',';
  1066. }
  1067. for($i=0;$i<count($saddress);$i++)
  1068. {
  1069. $sar .= $saddress[$i].',';
  1070. }
  1071. $post['baddress'] = rtrim($bar,',');//卖家保障
  1072. $post['saddress'] = rtrim($sar,',');//卖家保障
  1073. $whlabel = $post['whlabel'];
  1074. if($post['express'] == 2 && (stripos($post['name'],'&') !== false || stripos($post['name'],"'") !== false))
  1075. {
  1076. echo json_encode(array('msg'=>'USPS收件人或公司名不可用特殊符号!','success'=>false));exit;
  1077. }
  1078. if(strlen($post['client']) > 35 || strlen($post['name']) > 35)//收件人姓名或公司名不允许超过35位
  1079. {
  1080. echo json_encode(array('msg'=>'收件人姓名或公司名不可超过35个字符!','success'=>false));exit;
  1081. }
  1082. if(($post['express'] == '5' || $post['express'] == '24' || $post['express'] == '42' || $post['express'] == '31') && $post['country'] != 192)
  1083. {
  1084. echo json_encode(array('msg'=>'非美国无法选择Fedex、DHL官方-美国!','success'=>false));exit;
  1085. }
  1086. if($post['express'] == '3' && $post['country'] != 192 && $post['country'] != 35)
  1087. {
  1088. echo json_encode(array('msg'=>'非美国和加拿大无法选择UPS!','success'=>false));exit;
  1089. }
  1090. if($post['express'] == '3' && $post['country'] == 35 && $post['zsbjz'] > 20)
  1091. {
  1092. echo json_encode(array('msg'=>'UPS加拿大最高申报不可超过20','success'=>false));exit;
  1093. }
  1094. if($post['express'] == '2' && $post['warehouse'] != 5)
  1095. {
  1096. echo json_encode(array('msg'=>'非美国仓无法选择USPS!','success'=>false));exit;
  1097. }
  1098. if($post['express'] == '99' && $post['bx'] > 0)
  1099. {
  1100. echo json_encode(array('msg'=>'此物流不允许购买保险','success'=>false));exit;
  1101. }
  1102. if($post['express'] == 42 && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 ||
  1103. {
  1104. echo json_encode(array('msg'=>'此快递方式必须选择Human Hair Wigs/Human Hair Goods!','success'=>false));exit;
  1105. }
  1106. if($post['express'] == 24 && $post['sbpm'] != 'Hair Sample' && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 ||
  1107. {
  1108. echo json_encode(array('msg'=>'此快递方式必须选择Hair Sample/Human Hair Wigs/Human Hair Goods!','success'=>false));exit;
  1109. }
  1110. if($post['country'] != 192 && $post['express'] == 1 && $post['sbpm'] != 'Synthetic Hair Wigs' && $post['sbpm'] != 'Synthetic Hair Goods')//$post['express'] == 3 ||
  1111. {
  1112. echo json_encode(array('msg'=>'非美国选择官方DHL必须选择Synthetic Hair Wigs/Synthetic Hair Goods','success'=>false));exit;
  1113. }
  1114. if($post['pay'] == '22' && ($post['paypal'] == '' || $post['guarantee'] == ''))
  1115. {
  1116. echo json_encode(array('msg'=>'交易号和卖家保障必须填写','success'=>false));exit;
  1117. }
  1118. if($post['pay'] == '23' && $post['paypal'] == '')
  1119. {
  1120. echo json_encode(array('msg'=>'交易号必须填写','success'=>false));exit;
  1121. }
  1122. $express = $this->express->read($post['express']);
  1123. if($post['zsbjz'] > $express['sbjz'])
  1124. {
  1125. echo json_encode(array('msg'=>'总申报价值不可超出'.$express['sbjz'],'success'=>false));exit;
  1126. }
  1127. if($post['shouldmoney'] > $express['shouldmoney'] && $express['shouldmoney'] != 0)
  1128. {
  1129. echo json_encode(array('msg'=>'订单金额不可超出'.$express['shouldmoney'],'success'=>false));exit;
  1130. }
  1131. if($express['ioss'] == 1 && $post['ioss'] == '')
  1132. {
  1133. echo json_encode(array('msg'=>'此快递方式必须选择IOSS!','success'=>false));exit;
  1134. }
  1135. if(strlen($post['address']) > $express['addresssize'] || strlen($post['address2']) > $express['addresssize'])
  1136. {
  1137. echo json_encode(array('msg'=>'此快递方地址不可超出'.$express['addresssize'].'个字符','success'=>false));exit;
  1138. }
  1139. if(strlen($post['address']) < 5)
  1140. {
  1141. echo json_encode(array('msg'=>'地址不可留空!','success'=>false));exit;
  1142. }
  1143. if($post['express'] == '2' && $post['zzl'] > '16' && $post['js'] == '0')
  1144. {
  1145. echo json_encode(array('msg'=>'重量大于16不可按Ground Advantage提交!','success'=>false));exit;
  1146. }
  1147. if($post['express'] == '2' && isset($post['js']) && $post['js'] == '0'&& $post['qm'] == '1')
  1148. {
  1149. echo json_encode(array('msg'=>'Ground Advantage不可使用签名服务!','success'=>false));exit;
  1150. }
  1151. if(($post['express'] == '3' || $post['express'] == '42' || $post['express'] == '24') && $post['shouldmoney'] < 1)
  1152. {
  1153. echo json_encode(array('msg'=>'零金额订单不可发 UPS/DHL官方-美国/Fedex(杭州)','success'=>false));exit;
  1154. }
  1155. if($post['express'] == '42' && $post['zsbjz'] < 1)
  1156. {
  1157. echo json_encode(array('msg'=>'零申报金额不可发 DHL官方-美国','success'=>false));exit;
  1158. }
  1159. if($post['express'] == '6' && $post['province'] == '')
  1160. {
  1161. echo json_encode(array('msg'=>'选择DPEX必须填写州信息','success'=>false));exit;
  1162. }
  1163. $dtctitle = array();
  1164. $dictionaries = $this->typeclass->find_all();
  1165. foreach ($dictionaries as $v)
  1166. {
  1167. $dtctitle[$v['id']] = array($v['title'],$v['bqsku']);
  1168. }
  1169. $fpdata = $post['fpdata'];
  1170. if(stripos($fpdata,'-128-') !== false || stripos($fpdata,'-127-') !== false)
  1171. {
  1172. $dfp = explode(';',trim($fpdata,';'));
  1173. $fdata = '';
  1174. foreach ($dfp as $k=>$v)
  1175. {
  1176. $ptitleb = '';
  1177. $fp = explode('|',trim($v,'|'));
  1178. $fp0 = explode(',',$fp[0]);
  1179. if(isset($fp0[1]))
  1180. {
  1181. $fp1 = explode('-',trim($fp0[1],'-'));
  1182. }
  1183. else
  1184. {
  1185. $fp1 = explode('-',trim($fp[0],'-'));
  1186. }
  1187. foreach ($fp1 as $vv)
  1188. {
  1189. $ptitleb .= isset($dtctitle[$vv])?$dtctitle[$vv][0].' ':'';
  1190. }
  1191. if(isset($fp0[1]))
  1192. {
  1193. $ptitleb .= $dtctitle[$fp0[0]][1].'inch ';
  1194. $fp[1] = $ptitleb;
  1195. }
  1196. $fdata .= implode("|",$fp).";";
  1197. }
  1198. $fpdata = $fdata;
  1199. }
  1200. $warehouse = $this->warehouse->read($post['type']);
  1201. if($warehouse['bdcountry'] != 0 && $post['country'] != $warehouse['bdcountry'])
  1202. {
  1203. echo json_encode(array('msg'=>'当前国家无法选择'.$warehouse['title'].'!','success'=>false));exit;
  1204. }
  1205. // $kcyz = $this->ck->get_kc($post['state'],$warehouse,$post['shop'],$post['number'],$whlabel,$fpdata);
  1206. // if($kcyz['t'] > '0')
  1207. // {
  1208. // echo $kcyz['m'];exit;
  1209. // }
  1210. // else if($kcyz['fpdata'] != '')
  1211. // {
  1212. // $post['whlabel'] = $kcyz['whlabel'];
  1213. // $post['fpdata'] = $kcyz['fpdata'];
  1214. // }
  1215. // $fl = $this->ck->get_fl($warehouse['hz'],$whlabel,$fpdata);
  1216. // $post['sfxh'] = $fl['sfxh'];
  1217. // $post['ckfl'] = $fl['ckfl'];
  1218. //查询净重开始
  1219. $post['jweight'] = $this->weight->get_weightcx($post['fpdata']);
  1220. //查询净重结束
  1221. $cusnum = $this->customer->read($customerid);
  1222. // $this->customer->save(array('num'=>$cusnum['num']+1,'time'=>$post['buytime']),$customerid);
  1223. // $this->fullorder->insert($post);
  1224. echo json_encode(array('msg'=>'下单成功','success'=>true));exit;
  1225. }
  1226. echo "1";
  1227. die;
  1228. }
  1229. public function cc(){
  1230. $filename = date("Y-m-d") . "产品入库导出.xls";
  1231. $str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
  1232. <head>
  1233. <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
  1234. <!--[if gte mso 9]>
  1235. <xml>
  1236. <x:ExcelWorkbook>
  1237. <x:ExcelWorksheets>
  1238. <x:ExcelWorksheet>
  1239. <x:Name>产品入库</x:Name>
  1240. <x:WorksheetOptions>
  1241. <x:Print>
  1242. <x:ValidPrinterInfo />
  1243. </x:Print>
  1244. </x:WorksheetOptions>
  1245. </x:ExcelWorksheet>
  1246. </x:ExcelWorksheets>
  1247. </x:ExcelWorkbook>
  1248. </xml>
  1249. <![endif]-->
  1250. <style>
  1251. tr { mso-height-source: auto; }
  1252. .fixed-height {
  1253. height: 100px; /* 设置固定行高 */
  1254. mso-height-source: userset; /* 强制Excel使用设定高度 */
  1255. }
  1256. </style>
  1257. </head>
  1258. <body>";
  1259. $str .= "<table border='1' cellspacing='0' style='border-collapse: collapse; font-family: Microsoft Yahei; font-size: 13px;'>";
  1260. $str .= "<tr >"; // 应用固定高度类
  1261. $str .= "<td>产品ID</td>";
  1262. $str .= "<td>图片1</td>";
  1263. $str .= "</tr>";
  1264. $str .= "<tr class='fixed-height'>"; // 应用固定高度类
  1265. $str .= "<td>ceshi12321312312312312312312312312312312</td>";
  1266. $str .= '<td >
  1267. <table border="0">
  1268. <tr class="fixed-height" >
  1269. <td ><img class="excel-image" width="70" height="auto" src="http://1.wepolicy.cn/data/img/20250703/20250703_085106_9716.png"></td>
  1270. <td ><img class="excel-image" width="70" height="auto" src="http://1.wepolicy.cn/data/img/20250703/20250703_085106_9716.png"></td>
  1271. </tr>
  1272. </table>
  1273. </td>';
  1274. // $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>';
  1275. $str .= "</tr>";
  1276. $str .= "</table></body></html>";
  1277. header("Content-Type: application/vnd.ms-excel; charset=utf-8");
  1278. header("Content-Disposition: attachment; filename=".$filename);
  1279. header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
  1280. header("Pragma: no-cache");
  1281. header("Expires: 0");
  1282. exit($str);
  1283. }
  1284. }