Model_apiyy.php 60 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381
  1. <?php
  2. class Model_apiyy extends Lin_Model
  3. {
  4. function __construct(){
  5. parent::__construct();
  6. $this->load->database();
  7. $this->table = 'apiyy';
  8. $this->load_table('apiyy');
  9. }
  10. public function get_number($number)
  11. {
  12. return $this->find("number = '$number'");
  13. }
  14. public function get_cjkh($data)//创建客户
  15. {
  16. $list["0"]["OtherID"] = $data['id'];//客户ID
  17. $list["0"]["Code"] = $data['id'];//客户编码
  18. $list["0"]["Name"] = $data['name'];//客户名称
  19. $list["0"]["ShortName"] = $data['name'];//客户简称
  20. $list["0"]["TradeCategory"] = 0;
  21. $list["0"]["State"] = 0;
  22. $list["0"]["IsHoldRelease"] = false;
  23. $list["0"]["IsMISC"] = false;
  24. $list["0"]["RegisterCapital"] = 0;
  25. $list["0"]["Turnover"] = 0;
  26. $list["0"]["EmployeeCount"] = 0;
  27. $list["0"]["SaleType"] = 0;
  28. $list["0"]["Bargain"] = 0;
  29. $list["0"]["IsTaxPrice"] = true;
  30. $list["0"]["PriceListID"] = 0;
  31. $list["0"]["IsPriceListModify"] = true;
  32. $list["0"]["IsHaveContract"] = false;
  33. $list["0"]["SupplySource"] = 0;
  34. $list["0"]["DemandTransType"] = 0;
  35. $list["0"]["IsShipmentModify"] = true;
  36. $list["0"]["TransitLeadTime"] = 0;
  37. $list["0"]["IsRecTermModify"] = true;
  38. $list["0"]["IsDeposit"] = true;
  39. $list["0"]["IsPreReceival"] = false;
  40. $list["0"]["PreRcvRate"] = 0;
  41. $list["0"]["IsPreRcvRateModify"] = false;
  42. $list["0"]["IsSalesDiscount"] = true;
  43. $list["0"]["QualityPledge"] = 0;
  44. $list["0"]["IsARCfmModify"] = true;
  45. $list["0"]["IsBillByBalance"] = true;
  46. $list["0"]["InvoiceVerificationOrder"] = 0;
  47. $list["0"]["VerificationMode"] = 0;
  48. $list["0"]["IsByAccountAge"] = true;
  49. $list["0"]["IsPost"] = true;
  50. $list["0"]["CheckAccountPeriod"] = 0;
  51. $list["0"]["IsCreditCheck"] = true;
  52. $list["0"]["CustomerSiteDTOs"]["0"]["Code"] = $data['id'];
  53. $list["0"]["CustomerSiteDTOs"]["0"]["SrcRowID"] = 0;
  54. $list["0"]["CustomerSiteDTOs"]["0"]["OperateType"] = 0;
  55. $list["0"]["CustomerSiteDTOs"]["0"]["IsShipTo"] = true;
  56. $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultShipTo"] = true;
  57. $list["0"]["CustomerSiteDTOs"]["0"]["IsBillTo"] = true;
  58. $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultBillTo"] = true;
  59. $list["0"]["CustomerSiteDTOs"]["0"]["IsClaim"] = true;
  60. $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultClaim"] = true;
  61. $list["0"]["CustomerSiteDTOs"]["0"]["IsPayment"] = true;
  62. $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultPayment"] = true;
  63. $list["0"]["CustomerSiteDTOs"]["0"]["IsContrast"] = true;
  64. $list["0"]["CustomerSiteDTOs"]["0"]["IsDefaultContrast"] = true;
  65. $list["0"]["CustomerSiteDTOs"]["0"]["PriceListID"] = 0;
  66. $list["0"]["CustomerSiteDTOs"]["0"]["IsPriceListModify"] = true;
  67. $list["0"]["CustomerSiteDTOs"]["0"]["SupplySource"] = 0;
  68. $list["0"]["CustomerSiteDTOs"]["0"]["DemandTransType"] = 0;
  69. $list["0"]["CustomerSiteDTOs"]["0"]["IsShippmentRuleEditable"] = true;
  70. $list["0"]["CustomerSiteDTOs"]["0"]["ShipmentMode"] = 0;
  71. $list["0"]["CustomerSiteDTOs"]["0"]["TransitLeadTime"] = 0;
  72. $list["0"]["CustomerSiteDTOs"]["0"]["ShippingHavenID"] = 0;
  73. $list["0"]["CustomerSiteDTOs"]["0"]["TargetHavenID"] = 0;
  74. $list["0"]["CustomerSiteDTOs"]["0"]["IsPaymentTermEditable"] = true;
  75. $list["0"]["CustomerSiteDTOs"]["0"]["IsSalesDiscount"] = true;
  76. $list["0"]["CustomerSiteDTOs"]["0"]["NeedDeposit"] = true;
  77. $list["0"]["CustomerSiteDTOs"]["0"]["IsPrePayment"] = true;
  78. $list["0"]["CustomerSiteDTOs"]["0"]["IsPostBankCheckList"] = true;
  79. $list["0"]["CustomerSiteDTOs"]["0"]["InvoiceVerificationOrder"] = 0;
  80. $list["0"]["CustomerSiteDTOs"]["0"]["VerificationMode"] = 0;
  81. $list["0"]["CustomerSiteDTOs"]["0"]["BankCheckPeriod"] = 0;
  82. $list["0"]["CustomerSiteDTOs"]["0"]["QualityGuaranteeType"] = 0;
  83. $list["0"]["RecervalTerm"]["Code"] = 'YZ01';
  84. $list["0"]["ARConfirmTerm"]["Code"] = 'YZ01';
  85. $list["0"]["ShippmentRule"]["Code"] = '01';
  86. $list = json_encode($list);
  87. $token = $this->setting->get_yytoken_130();
  88. $url = 'http://172.31.105.167/U9C/webapi/Customer/Create';
  89. $header[] = "Content-Type: application/json";
  90. $header[] = "Token: ".$token;
  91. $ch = curl_init();
  92. curl_setopt($ch, CURLOPT_URL, $url);
  93. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  94. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  95. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  96. curl_setopt($ch, CURLOPT_POST, 1);
  97. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  98. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  99. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  100. $res = curl_exec($ch);
  101. $res = json_decode($res,true);
  102. return $res;
  103. }
  104. public function get_cjlp($data)//创建料品
  105. {
  106. $list["0"]["Code"] = $data['jm'];//料号,SKU
  107. $list["0"]["Code1"] = '';
  108. $list["0"]["Name"] = $data['zh'];//产品名称
  109. $list["0"]["MainItemCategory"]["Code"] = $data['bm'];
  110. $list["0"]["Org"]["Code"] = 001;
  111. $list["0"]["OtherID"] = 1;
  112. $list["0"]["PurchaseInfo"]["BudgetControlType"] = -1;
  113. $list["0"]["PurchaseInfo"]["PriceSource"] = 2;
  114. $list["0"]["PurchaseInfo"]["InquireRule"] = -1;
  115. $list["0"]["PurchaseInfo"]["InquireFixedPeriod"] = 0;
  116. $list["0"]["PurchaseInfo"]["StatisticPeriod"] = -1;
  117. $list["0"]["PurchaseInfo"]["IsPUTradePathModify"] = true;
  118. $list["0"]["PurchaseInfo"]["IsPURtnTradePathModify"] = true;
  119. $list["0"]["InventoryUOM"]["Code"] = '条';
  120. $list["0"]["InventorySecondUOM"]["Code"] = '';
  121. $list["0"]["IsDualUOM"] = false;
  122. $list["0"]["InventoryInfo"]["InventoryPlanningMethod"] = 4;
  123. $list["0"]["InventoryInfo"]["InventoryPlanTime"] = -1;
  124. $list["0"]["InventoryInfo"]["TurnOverRate"] = 1;
  125. $list["0"]["InventoryInfo"]["ReserveMode"] = -1;
  126. $list["0"]["InventoryInfo"]["SupplyMethod"] = -1;
  127. $list["0"]["DescFlexField"]["PrivateDescSeg1"] = 01;
  128. $list["0"]["DescFlexField"]["PubDescSeg5"] = 01;
  129. $list["0"]["Description"] = $data['title'];
  130. $list["0"]["ItemForm"] = 2001;
  131. $list["0"]["ItemFormAttribute"] = 10;
  132. $list["0"]["IsInventoryEnable"] = true;
  133. $list["0"]["IsPurchaseEnable"] = true;
  134. $list["0"]["IsSalesEnable"] = true;
  135. $list["0"]["IsBuildEnable"] = true;
  136. $list["0"]["IsOutsideOperationEnable"] = true;
  137. $list["0"]["IsMRPEnable"] = true;
  138. $list["0"]["IsBOMEnable"] = true;
  139. $list["0"]["IsCostCalByGrade"] = false;
  140. $list["0"]["IsCostCalByPotency"] = false;
  141. $list["0"]["IsGradeControl"] = false;
  142. $list["0"]["StandardGrade"] = -1;
  143. $list["0"]["StartGrade"] = -1;
  144. $list["0"]["EndGrade"] = -1;
  145. $list["0"]["IsPotencyControl"] = false;
  146. $list["0"]["StandardPotency"] = -1;
  147. $list["0"]["StartPotency"] = -1;
  148. $list["0"]["EndPotency"] = -1;
  149. $list = json_encode($list);
  150. $token = $this->setting->get_yytoken_130();
  151. $url = 'http://172.31.105.167/U9C/webapi/ItemMaster/Create';
  152. $header[] = "Content-Type: application/json";
  153. $header[] = "Token: ".$token;
  154. $ch = curl_init();
  155. curl_setopt($ch, CURLOPT_URL, $url);
  156. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  157. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  158. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  159. curl_setopt($ch, CURLOPT_POST, 1);
  160. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  161. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  162. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  163. $res = curl_exec($ch);
  164. $res = json_decode($res,true);
  165. if(isset($res['Data'][0]))
  166. {
  167. $this->get_lpxf($data);
  168. }
  169. return $res;
  170. }
  171. public function get_lpxf($data)//传递料品
  172. {
  173. $list["0"]["EntityFullName"] = 'UFIDA.U9.CBO.SCM.Item.ItemMaster';
  174. $list["0"]["EntityCode"] = $data['jm'];//料号,SKU
  175. $list["0"]["FromOrgCode"] = "130";
  176. $list["0"]["ToOrgCodeList"] = array(101,120,110);
  177. $list["0"]["OtherID"] = "";
  178. $list["0"]["ContextDTO"]["EntCode"] = "001";
  179. $list["0"]["ContextDTO"]["OrgCode"] = "130";
  180. $list["0"]["ContextDTO"]["UserCode"] = "xk";
  181. $list["0"]["ContextDTO"]["UserPwd"] = "";
  182. $list = json_encode($list);
  183. $token = $this->setting->get_yytoken_130();
  184. $url = 'http://172.31.105.167/U9C/webapi/ControlObjSend/ControlObjSend';
  185. $header[] = "Content-Type: application/json";
  186. $header[] = "Token: ".$token;
  187. $ch = curl_init();
  188. curl_setopt($ch, CURLOPT_URL, $url);
  189. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  190. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  191. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  192. curl_setopt($ch, CURLOPT_POST, 1);
  193. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  194. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  195. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  196. $res = curl_exec($ch);
  197. $res = json_decode($res,true);
  198. return $res;
  199. }
  200. public function get_cg($data)//无源采购
  201. {
  202. $time = time();
  203. if($time > 1717171200 && $time < 1717257599)
  204. {
  205. $time = time()-24*3600;
  206. }
  207. $list["0"]["BusinessDate"] = date("Y-m-d H:i:s",$time);
  208. $list["0"]["DocumentType"] = "PO01";
  209. $list["0"]["POLineDTOList"][0]["ItemInfo"]['m_code'] = $data['sku'];//料号
  210. $list["0"]["POLineDTOList"][0]["SupplierConfirmQtyTU"] = $data['ts'];//数量
  211. $list["0"]["POLineDTOList"][0]["ReqQtyTU"] = $data['ts'];
  212. //$list["0"]["POLineDTOList"][0]["FinallyPriceTC"] = '';//价格
  213. $list["0"]["POLineDTOList"][0]["SupplierConfirmQtyTBU"] = 0;
  214. //$list["0"]["POLineDTOList"][0]["DescFlexField"]['PubDescSeg3'] = 75;
  215. $list["0"]["POLineDTOList"][0]["ReqQtyTBU"] = 0;
  216. $list["0"]["POLineDTOList"][0]["POLineID"] = 0;
  217. $list["0"]["POLineDTOList"][0]["IsPresent"] = false;
  218. $list["0"]['BizType'] = 0;
  219. $list["0"]['DocNo'] = "";
  220. $list["0"]['OtherID'] = "";
  221. $list["0"]['DescFlexField'] = (object)array();
  222. $list["0"]['Supplier']['Code'] = $data['purchase'];
  223. $list["0"]['IsPriceIncludeTax'] = false;
  224. $list = json_encode($list);
  225. $token = $this->setting->get_yytoken_130();
  226. $url = 'http://172.31.105.167/U9C/webapi/PurchaseOrder/Create';
  227. $header[] = "Content-Type: application/json";
  228. $header[] = "Token: ".$token;
  229. $ch = curl_init();
  230. curl_setopt($ch, CURLOPT_URL, $url);
  231. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  232. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  233. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  234. curl_setopt($ch, CURLOPT_POST, 1);
  235. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  236. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  237. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  238. $res = curl_exec($ch);
  239. $res = json_decode($res,true);
  240. return $res;
  241. }
  242. //https://openapi.yyu9c.com/doc.html#/U9C%20OPENAPI/Receivement/Receivement_CreateRcvBySrcPO
  243. public function get_bzsh($data)//标准收货
  244. {
  245. $time = time();
  246. if($time > 1717171200 && $time < 1717257599)
  247. {
  248. $time = time()-24*3600;
  249. }
  250. $list["0"]["potorcvDTOS"][0]["BusinessDate"] = date("Y-m-d H:i:s",$time);
  251. $list["0"]["potorcvDTOS"][0]["Amount1"] = $data['ts'];//收货数量
  252. $list["0"]["potorcvDTOS"][0]["Amount2"] = 0;//收货数量
  253. $list["0"]["potorcvDTOS"][0]["PONo"] = $data['od'];//订单号
  254. $list["0"]["potorcvDTOS"][0]["POLineNo"] = 10;
  255. $list["0"]["potorcvDTOS"][0]["POShipLineNo"] = 0;
  256. $list["0"]["potorcvDTOS"][0]["POShipLineKey"] = 0;
  257. $list["0"]["potorcvDTOS"][0]["DescFlexField"] = (object)array();
  258. $list["0"]["potorcvDTOS"][0]["Memo"] = $data['title'];
  259. /** 库位
  260. $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['BinCode'] = "";
  261. $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['LocationQtyTU'] = 0;
  262. $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['LocationNo'] = 0;
  263. $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['TallyTime'] = "";
  264. **/
  265. $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_iD'] = 0;
  266. $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_code'] = 13001;//许昌仓
  267. $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_name'] = "";
  268. $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['sysState'] = 0;
  269. $list["0"]["potorcvDTOS"][0]["rlInfo"]["StorageType"] = 4;
  270. $list["0"]["SplitBy"] = array();
  271. $list["0"]["IsApproved"] = false;
  272. $list["0"]["DocStatus"] = 3;
  273. $list["0"]["OtherID"] = "";
  274. $list = json_encode($list);
  275. $token = $this->setting->get_yytoken_130();
  276. $url = 'http://172.31.105.167/U9C/webapi/Receivement/CreateRcvBySrcPO';
  277. $header[] = "Content-Type: application/json";
  278. $header[] = "Token: ".$token;
  279. $ch = curl_init();
  280. curl_setopt($ch, CURLOPT_URL, $url);
  281. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  282. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  283. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  284. curl_setopt($ch, CURLOPT_POST, 1);
  285. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  286. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  287. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  288. $res = curl_exec($ch);
  289. $res = json_decode($res,true);
  290. return $res;
  291. }
  292. public function get_sc($data)//生产订单
  293. {
  294. $time = time();
  295. if($time > 1717171200 && $time < 1717257599)
  296. {
  297. $time = time()-24*3600;
  298. }
  299. $list["0"]["OtherID"] = '';
  300. $list["0"]["Org"]['Code'] = "120";
  301. $list["0"]["ItemMaster"]["Code"] = $data['sku'];
  302. $list["0"]["DocType"]["Code"] = $data['djlx'];
  303. $list["0"]["Department"]["Code"] = "12008";
  304. $list["0"]["ExpandLevel"] = 0;
  305. $list["0"]["AlternateType"] = 0;
  306. $list["0"]["RoutingAlternate"] = 0;
  307. $list["0"]["RoutingEffeDate"] = '';
  308. $list["0"]["ProductQty"] = $data['ts'];
  309. $list["0"]["ProductUOM"]["Code"] = '条';
  310. $list["0"]["StartDate"] = date('Y-m-d',$time);
  311. $list["0"]["CompleteDate"] = date('Y-m-d',$time);//$data['time']
  312. $list["0"]["MOSourceDocType"] = 0;
  313. $list["0"]["OwnerOrg"]["Code"] = "120";
  314. $list["0"]["SCVWh"]["Code"] = $data['drck'];
  315. $list["0"]["DemandCode"] = -1;
  316. $list["0"]["IsFirmed"] = false;
  317. $list["0"]["IsCapacityLimit"] = false;
  318. $list["0"]["Priority"] = 0;
  319. $list["0"]["CUD"] = 0;
  320. $list["0"]["BOMType"] = 0;
  321. $list["0"]["Description"] = $data['title'];
  322. $list["0"]["MRPQty"] = 0;
  323. $list["0"]["MOID"] = 0;
  324. $list["0"]["PBUToSBURate"] = 0;
  325. $list["0"]["PBUToCBURate"] = 0;
  326. $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['yyid'];
  327. $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  328. $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  329. $list = json_encode($list);
  330. $token = $this->setting->get_yytoken_120();
  331. $url = 'http://172.31.105.167/U9C/webapi/MODoc/Create';
  332. $header[] = "Content-Type: application/json";
  333. $header[] = "Token: ".$token;
  334. $ch = curl_init();
  335. curl_setopt($ch, CURLOPT_URL, $url);
  336. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  337. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  338. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  339. curl_setopt($ch, CURLOPT_POST, 1);
  340. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  341. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  342. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  343. $res = curl_exec($ch);
  344. $res = json_decode($res,true);
  345. return $res;
  346. }
  347. public function get_chd($data)//出货单一次出整个订单
  348. {
  349. $list[0]["SrcDocType"] = 1;
  350. $list[0]["SrcDocNo"] = $data['number'];
  351. $list[0]["SrcDocLineNo"] = $data['i'];
  352. $list[0]["SrcDocSubLineNo"] = 10;
  353. $list[0]["WH"] = 1002309200047445;
  354. $list[0]["CurShipQty1"] = $data['ts'];
  355. $list[0]["SOIsConsign"] = false;
  356. $list[0]["OptionalSplitTerm"] = array();
  357. $list[0]["DescFlexField"] = (object)array();
  358. $list[0]["LineDescFlexField"] = (object)array();
  359. //$list[0]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600);
  360. //$list[0]["ShipConfirmDate"] = date("Y-m-d",time());
  361. $list[0]["DocStatus"] = 0;
  362. $list = json_encode($list);
  363. $token = $this->setting->get_yytoken_130();
  364. $url = 'http://172.31.105.167/U9C/webapi/Ship/CreateBySrcDoc';
  365. $header[] = "Content-Type: application/json";
  366. $header[] = "Token: ".$token;
  367. $ch = curl_init();
  368. curl_setopt($ch, CURLOPT_URL, $url);
  369. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  370. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  371. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  372. curl_setopt($ch, CURLOPT_POST, 1);
  373. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  374. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  375. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  376. $res = curl_exec($ch);
  377. $res = json_decode($res,true);
  378. return array($res,$list);
  379. }
  380. public function get_chd_zdd($data)//出货单一次出整个订单
  381. {
  382. for($i=0;$i<count($data['lh']);$i++)
  383. {
  384. $list[$i]["SrcDocType"] = 1;
  385. $list[$i]["SrcDocNo"] = $data['number'];
  386. $list[$i]["SrcDocLineNo"] = $i+1;
  387. $list[$i]["SrcDocSubLineNo"] = 10;
  388. $list[$i]["WH"] = 1002309200047445;
  389. $list[$i]["CurShipQty1"] = $data['lh'][$i]['ts'];
  390. $list[$i]["SOIsConsign"] = false;
  391. $list[$i]["OptionalSplitTerm"] = array();
  392. $list[$i]["DescFlexField"] = (object)array();
  393. $list[$i]["LineDescFlexField"] = (object)array();
  394. //$list[$i]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600);
  395. //$list[$i]["ShipConfirmDate"] = date("Y-m-d",time());
  396. $list[$i]["DocStatus"] = 0;
  397. }
  398. $list = json_encode($list);
  399. $token = $this->setting->get_yytoken_130();
  400. $url = 'http://172.31.105.167/U9C/webapi/Ship/CreateBySrcDoc';
  401. $header[] = "Content-Type: application/json";
  402. $header[] = "Token: ".$token;
  403. $ch = curl_init();
  404. curl_setopt($ch, CURLOPT_URL, $url);
  405. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  406. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  407. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  408. curl_setopt($ch, CURLOPT_POST, 1);
  409. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  410. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  411. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  412. $res = curl_exec($ch);
  413. $res = json_decode($res,true);
  414. return array($res,$list);
  415. }
  416. public function get_chd_cs($data)//出货单
  417. {
  418. $list["0"]["SrcDocType"] = 1;
  419. $list["0"]["SrcDocNo"] = $data['number'];
  420. $list["0"]["SrcDocLineNo"] = 1;
  421. $list["0"]["SrcDocSubLineNo"] = 10;
  422. $list["0"]["WH"] = 1002309200047445;
  423. $list["0"]["CurShipQty1"] = $data['ts'];
  424. $list["0"]["SOIsConsign"] = false;
  425. $list["0"]["OptionalSplitTerm"] = array();
  426. $list["0"]["DescFlexField"] = (object)array();
  427. $list["0"]["LineDescFlexField"] = (object)array();
  428. //$list["0"]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600);
  429. $list["0"]["ShipConfirmDate"] = date("Y-m-d",$data['librarytime']);
  430. $list["0"]["DocStatus"] = 0;
  431. $list = json_encode($list);
  432. return $list;
  433. }
  434. public function get_cprk($data)//产品入库
  435. {
  436. $time = time();
  437. if($time > 1717171200 && $time < 1717257599)
  438. {
  439. $time = time()-24*3600;
  440. }
  441. $list["0"]["DocNo"] = '';
  442. $list["0"]["CompleteList"]["0"]["MOKey"]["OtherID"] = '';
  443. $list["0"]["CompleteList"]["0"]["MOKey"]["ID"] = 0;
  444. $list["0"]["CompleteList"]["0"]["MOKey"]["DocNo"] = $data['rkcode'];
  445. $list["0"]["CompleteList"]["0"]["MOKey"]["OrgID"] = 0;
  446. $list["0"]["CompleteList"]["0"]["MOKey"]["IsSuccess"] = 1;
  447. $list["0"]["CompleteList"]["0"]["MOKey"]["ErrorInfo"] = '';
  448. $list["0"]["CompleteList"]["0"]["MOKey"]["CUD"] = 0;
  449. $list["0"]["CompleteList"]["0"]["Wh"]["Code"] = 02;
  450. $list["0"]["CompleteList"]["0"]["LineNum"] = 0;
  451. $list["0"]["CompleteList"]["0"]["StorageType"] = 4;
  452. $list["0"]["CompleteList"]["0"]["Grade"] = 0;
  453. $list["0"]["CompleteList"]["0"]["Element"] = 0;
  454. $list["0"]["CompleteList"]["0"]["CompleteQty"] = $data['ts'];
  455. $list["0"]["CompleteList"]["0"]["CompleteQtyByWhUOM"] = $data['ts'];
  456. $list["0"]["CompleteList"]["0"]["CompleteQtyByCostUOM"] = $data['ts'];
  457. $list["0"]["CompleteList"]["0"]["CUD"] = 0;
  458. $list["0"]["CompleteList"]["0"]["OwnerOrg"]["Code"] = 120;
  459. $list["0"]["CompleteList"]["0"]["OutputType"] = 0;
  460. $list["0"]["CompleteList"]["0"]["Item"]["Code"] = $data['jm'];
  461. $list["0"]["CompleteList"]["0"]["ScrapQty"] = 0;
  462. $list["0"]["CompleteList"]["0"]["ScrapQtyByCostUOM"] = 0;
  463. $list["0"]["CompleteList"]["0"]["PUToPBURate"] = 0;
  464. $list["0"]["CompleteList"]["0"]["CUToCBURate"] = 0;
  465. $list["0"]["CompleteList"]["0"]["PBUToCBURate"] = 0;
  466. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ID"] = 0;
  467. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocType"]["Code"] = 0;
  468. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["BusinessDate"] = '';
  469. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocNo"] = '';
  470. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["MOSrcDocType"] = 0;
  471. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocOrg"] = 0;
  472. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDoc"]["ID"] = $data['rkid'];
  473. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDoc"]["EntityType"] = 'UFIDA.U9.MO.MO.MO';
  474. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocVer"] = '';
  475. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLine"]["ID"] = 0;
  476. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLine"]["EntityType"] = '';
  477. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSubline"]["ID"] = 0;
  478. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSubline"]["EntityType"] = '';
  479. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocNo"] = $data['rkid'];
  480. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLineNo"] = '';
  481. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSublineNo"] = 10;
  482. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocID"] = $data['rkid'];
  483. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLineID"] = 0;
  484. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocType"] = '';
  485. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocDate"] = date("Y-m-d",$time);
  486. //$list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ActualRcvTime"] = date("Y-m-d",time());
  487. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvOrg"]["Code"] = 120;
  488. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["Org"]["Code"] = 120;
  489. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["Direction"] = 0;
  490. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocState"] = 0;
  491. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["ID"] = 0;
  492. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["Code"] = '';
  493. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["Name"] = '';
  494. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["ID"] = 0;
  495. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["Code"] = '';
  496. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["Name"] = '';
  497. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["OtherID"] = '';
  498. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ProductUOM"]["Code"] = '条';
  499. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ProductBaseUOM"]["Code"] = '条';
  500. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StoreUOM"]["Code"] = '条';
  501. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StoreBaseUOM"]["Code"] = '条';
  502. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CoUOM"]["Code"] = '条';
  503. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CostBaseUOM"]["Code"] = '条';
  504. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OperationState"] = 0;
  505. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OutputType"] = 0;
  506. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Item"]["Code"] = $data['jm'];
  507. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OwnerOrg"]["Code"] = 120;
  508. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PUToPBURate"] = 0;
  509. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["SUToSBURate"] = 0;
  510. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PBUToSBURate"] = 0;
  511. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CUToCBURate"] = 0;
  512. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PBUToCBURate"] = 0;
  513. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Grade"] = 0;
  514. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Element"] = 0;
  515. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Wh"]["Code"] = 02;
  516. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StorageType"] = 4;
  517. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvValiddate"] = 0;
  518. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByProductUOM"] = 0;
  519. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByWhUOM"] = 0;
  520. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByCostUom"] = 0;
  521. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvOrg"]["Code"] = 001;
  522. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PerformingOrg"]["Code"] = 001;
  523. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CUD"] = 0;
  524. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["LineNum"] = 0;
  525. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["MO"]["Code"] = $data['rkcode'];
  526. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ID"] = 0;
  527. $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  528. $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  529. $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  530. $list["0"]["DocType"]["Code"] = 0;
  531. $list["0"]["BusinessDate"] = date("Y-m-d H:i:s",$time);
  532. $list["0"]["OtherID"] = '';
  533. $list["0"]["Direction"] = 0;
  534. $list["0"]["IsOffLine"] = 1;
  535. $list["0"]["DocState"] = 0;
  536. $list["0"]["Remark"] = time();
  537. $list["0"]["RcvPerson"]["Code"] = 'ERP';
  538. $list = json_encode($list);
  539. $token = $this->setting->get_yytoken_120();
  540. $url = 'http://172.31.105.167/U9C/webapi/RcvRptDoc/Create';
  541. $header[] = "Content-Type: application/json";
  542. $header[] = "Token: ".$token;
  543. $ch = curl_init();
  544. curl_setopt($ch, CURLOPT_URL, $url);
  545. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  546. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  547. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  548. curl_setopt($ch, CURLOPT_POST, 1);
  549. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  550. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  551. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  552. $res = curl_exec($ch);
  553. $res = json_decode($res,true);
  554. return array($res,$list);
  555. }
  556. public function get_dc($data)//调出
  557. {
  558. $time = time();
  559. if($time > 1717171200 && $time < 1717257599)
  560. {
  561. $time = time()-24*3600;
  562. }
  563. $list["0"]["OtherID"] = $data['number'];
  564. $list["0"]["TransOutDocType_Code"] = 'TransOut001';
  565. $list["0"]["BusinessDate"] = date('Y-m-d',$time);
  566. $list["0"]["TransferDirection"] = 0;
  567. //$list["0"]["DescFlexField"] = (object)array();
  568. //$list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  569. //$list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  570. //$list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  571. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  572. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['drck'];
  573. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  574. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];;
  575. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  576. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  577. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "120";
  578. //$list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  579. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  580. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  581. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  582. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = "13001";
  583. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4;
  584. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130";
  585. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "120";
  586. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts'];
  587. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = "";
  588. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1;
  589. $list = json_encode($list);
  590. $token = $this->setting->get_yytoken_120();
  591. $url = 'http://172.31.105.167/U9C/webapi/TransferOut/Create';
  592. $header[] = "Content-Type: application/json";
  593. $header[] = "Token: ".$token;
  594. $ch = curl_init();
  595. curl_setopt($ch, CURLOPT_URL, $url);
  596. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  597. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  598. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  599. curl_setopt($ch, CURLOPT_POST, 1);
  600. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  601. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  602. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  603. $res = curl_exec($ch);
  604. $res = json_decode($res,true);
  605. return array($res,$list);
  606. }
  607. public function get_dc_cs($data)//调出
  608. {
  609. $list["0"]["OtherID"] = $data['number'];
  610. $list["0"]["TransOutDocType_Code"] = 'TransOut001';
  611. $list["0"]["BusinessDate"] = date('Y-m-d',time());
  612. $list["0"]["TransferDirection"] = 0;
  613. //$list["0"]["DescFlexField"] = (object)array();
  614. //$list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  615. //$list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  616. //$list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  617. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  618. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['drck'];
  619. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  620. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];;
  621. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  622. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  623. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "120";
  624. //$list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  625. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  626. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  627. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  628. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = "13001";
  629. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4;
  630. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130";
  631. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "120";
  632. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts'];
  633. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = "";
  634. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1;
  635. $list = json_encode($list);
  636. return $list;
  637. }
  638. public function get_cpdc($data)//成品仓调出到其它外贸仓
  639. {
  640. $time = time();
  641. if($time > 1717171200 && $time < 1717257599)
  642. {
  643. $time = time()-24*3600;
  644. }
  645. $list["0"]["OtherID"] = $data['number'];
  646. $list["0"]["TransOutDocType_Code"] = 'TransOut002';
  647. $list["0"]["BusinessDate"] = date('Y-m-d',$time);
  648. $list["0"]["TransferDirection"] = 0;
  649. $list["0"]["DescFlexField"] = (object)array();
  650. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  651. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['dccbm'];//调出仓编码
  652. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  653. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];
  654. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  655. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  656. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "130";
  657. $list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  658. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = $data['drcbm'];//调入仓编码
  659. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4;
  660. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130";
  661. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "130";
  662. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts'];
  663. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = "";
  664. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1;
  665. $list = json_encode($list);
  666. $token = $this->setting->get_yytoken_130();
  667. $url = 'http://172.31.105.167/U9C/webapi/TransferOut/Create';
  668. $header[] = "Content-Type: application/json";
  669. $header[] = "Token: ".$token;
  670. $ch = curl_init();
  671. curl_setopt($ch, CURLOPT_URL, $url);
  672. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  673. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  674. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  675. curl_setopt($ch, CURLOPT_POST, 1);
  676. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  677. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  678. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  679. $res = curl_exec($ch);
  680. $res = json_decode($res,true);
  681. return $res;
  682. }
  683. public function get_order_sh($data,$url1,$url2,$qs)//订单 提交-》审核
  684. {
  685. if($qs == 120)
  686. {
  687. $token = $this->setting->get_yytoken_120();
  688. }
  689. else
  690. {
  691. $token = $this->setting->get_yytoken_130();
  692. }
  693. $list["0"]["Code"] = $data['number'];
  694. $list = json_encode($list);
  695. $url = 'http://172.31.105.167/U9C/webapi/'.$url1;
  696. $header[] = "Content-Type: application/json";
  697. $header[] = "Token: ".$token;
  698. $ch = curl_init();
  699. curl_setopt($ch, CURLOPT_URL, $url);
  700. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  701. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  702. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  703. curl_setopt($ch, CURLOPT_POST, 1);
  704. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  705. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  706. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  707. $res = curl_exec($ch);
  708. //提交结束 审核开始
  709. $url = 'http://172.31.105.167/U9C/webapi/'.$url2;
  710. $ch = curl_init();
  711. curl_setopt($ch, CURLOPT_URL, $url);
  712. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  713. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  714. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  715. curl_setopt($ch, CURLOPT_POST, 1);
  716. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  717. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  718. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  719. $res = curl_exec($ch);
  720. $res = json_decode($res,true);
  721. return $res;
  722. }
  723. public function get_wcrk_sh($data)//入库审核
  724. {
  725. $list["0"]["DocNo"] = $data['co'];
  726. //$list["0"]["OtherID"] = $data['co'];
  727. $list = json_encode($list);
  728. $token = $this->setting->get_yytoken_120();
  729. $url = 'http://172.31.105.167/U9C/webapi/RcvRptDoc/Approve';
  730. $header[] = "Content-Type: application/json";
  731. $header[] = "Token: ".$token;
  732. $ch = curl_init();
  733. curl_setopt($ch, CURLOPT_URL, $url);
  734. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  735. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  736. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  737. curl_setopt($ch, CURLOPT_POST, 1);
  738. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  739. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  740. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  741. $res = curl_exec($ch);
  742. $res = json_decode($res,true);
  743. return array($res,$list);
  744. }
  745. public function get_order($data)//订单 标准销售
  746. {
  747. $shouldmoney = ($data['shouldmoney'] > 0)?sprintf("%01.2f",$data['shouldmoney']/count($data['lh'])):$data['shouldmoney'];
  748. $list["0"]["OrderBy"] = $data['yyid'];
  749. for($i=0;$i<count($data['lh']);$i++)
  750. {
  751. $list["0"]["SOLineDTOList"][$i]['TU'] = '条';
  752. $list["0"]["SOLineDTOList"][$i]['ItemCode'] = $data['lh'][$i]['sku'];//料号
  753. $list["0"]["SOLineDTOList"][$i]['PU'] = '条';
  754. $list["0"]["SOLineDTOList"][$i]['ShipTogetherFlag'] = -1;
  755. $list["0"]["SOLineDTOList"][$i]['DocLineNo'] = $i+1;
  756. $list["0"]["SOLineDTOList"][$i]['CustomerItemNo'] = '';
  757. $list["0"]["SOLineDTOList"][$i]['CustomerItemName'] = '';
  758. $list["0"]["SOLineDTOList"][$i]['FinallyPriceTC'] = $shouldmoney;
  759. $list["0"]["SOLineDTOList"][$i]['PubDescSeg10'] = '';
  760. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['IsMRPRequire'] = 1;
  761. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['DemandType'] = -1;
  762. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['RequireDate'] = date('m/d/Y H:i:s',$data['dtime']);
  763. $list["0"]["SOLineDTOList"][$i]['RecTerm'] = '';
  764. $list["0"]["SOLineDTOList"][$i]['FreeType'] = ($data['shouldmoney'] < 0.01)?0:-1;
  765. $list["0"]["SOLineDTOList"][$i]['UsableQtyOfInv'] = 0;
  766. $list["0"]["SOLineDTOList"][$i]['PubDescSeg3'] = '';
  767. $list["0"]["SOLineDTOList"][$i]['PubDescSeg4'] = '0.00';
  768. $list["0"]["SOLineDTOList"][$i]['PriceList'] = '';
  769. $list["0"]["SOLineDTOList"][$i]['TaxMoneyTC'] = 0;
  770. //$list["0"]["SOLineDTOList"][$i]['TotalMoneyTC'] = $data['budget'];
  771. $list["0"]["SOLineDTOList"][$i]['TaxSchedule'] = 'YZ05';
  772. $list["0"]["SOLineDTOList"][$i]['DescFlexField']['PubDescSeg3'] = '';
  773. $list["0"]["SOLineDTOList"][$i]['OrderByQtyTU'] = $data['lh'][$i]['ts'];//条数
  774. $list["0"]["SOLineDTOList"][$i]['OrderByQtyPU'] = $data['lh'][$i]['ts'];//条数
  775. $list["0"]["SOLineDTOList"][$i]['OrderPriceTC'] = $shouldmoney;
  776. $list["0"]["SOLineDTOList"][$i]['Memo'] = '321321';
  777. }
  778. $list["0"]["AC"] = 'C009';//美金
  779. $list["0"]["SaleDepartment"] = '02';
  780. $list["0"]["BusinessDate"] = date('m/d/Y H:i:s',$data['dtime']);
  781. $list["0"]["DocumentType"] = 'SO1';
  782. $list["0"]["DocNo"] = $data['number'];
  783. $list["0"]["TC"] = 'C009';
  784. $list["0"]["ShipToSite"] = '';
  785. $list["0"]["PubDescSeg2"] = '';
  786. $list["0"]["SOSrcType"] = 0;
  787. $list["0"]["Seller"] = '201';
  788. $list["0"]["ConfirmTerm"] = '';
  789. $list["0"]["Memo"] = '';
  790. $list["0"]["ShipRule"] = '';
  791. $list = json_encode($list);
  792. $token = $this->setting->get_yytoken_130();
  793. $url = 'http://172.31.105.167/U9C/webapi/SO/Create';
  794. $header[] = "Content-Type: application/json";
  795. $header[] = "Token: ".$token;
  796. $ch = curl_init();
  797. curl_setopt($ch, CURLOPT_URL, $url);
  798. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  799. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  800. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  801. curl_setopt($ch, CURLOPT_POST, 1);
  802. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  803. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  804. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  805. $res = curl_exec($ch);
  806. $res = json_decode($res,true);
  807. return array($res,$list);
  808. }
  809. public function get_order_cs($data)//订单 标准销售
  810. {
  811. $shouldmoney = ($data['shouldmoney'] > 0)?sprintf("%01.2f",$data['shouldmoney']/count($data['lh'])):$data['shouldmoney'];
  812. $list["0"]["OrderBy"] = $data['yyid'];
  813. for($i=0;$i<count($data['lh']);$i++)
  814. {
  815. $list["0"]["SOLineDTOList"][$i]['TU'] = '条';
  816. $list["0"]["SOLineDTOList"][$i]['ItemCode'] = $data['lh'][$i]['sku'];//料号
  817. $list["0"]["SOLineDTOList"][$i]['PU'] = '条';
  818. $list["0"]["SOLineDTOList"][$i]['ShipTogetherFlag'] = -1;
  819. $list["0"]["SOLineDTOList"][$i]['DocLineNo'] = $i+1;
  820. $list["0"]["SOLineDTOList"][$i]['CustomerItemNo'] = '';
  821. $list["0"]["SOLineDTOList"][$i]['CustomerItemName'] = '';
  822. $list["0"]["SOLineDTOList"][$i]['FinallyPriceTC'] = $shouldmoney;
  823. $list["0"]["SOLineDTOList"][$i]['PubDescSeg10'] = '';
  824. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['IsMRPRequire'] = 1;
  825. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['DemandType'] = -1;
  826. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['RequireDate'] = date('m/d/Y H:i:s',$data['dtime']);
  827. $list["0"]["SOLineDTOList"][$i]['RecTerm'] = '';
  828. $list["0"]["SOLineDTOList"][$i]['FreeType'] = ($data['shouldmoney'] < 0.01)?0:-1;
  829. $list["0"]["SOLineDTOList"][$i]['UsableQtyOfInv'] = 0;
  830. $list["0"]["SOLineDTOList"][$i]['PubDescSeg3'] = '';
  831. $list["0"]["SOLineDTOList"][$i]['PubDescSeg4'] = '0.00';
  832. $list["0"]["SOLineDTOList"][$i]['PriceList'] = '';
  833. $list["0"]["SOLineDTOList"][$i]['TaxMoneyTC'] = 0;
  834. $list["0"]["SOLineDTOList"][$i]['TotalMoneyTC'] = $data['budget'];
  835. $list["0"]["SOLineDTOList"][$i]['TaxSchedule'] = 'YZ05';
  836. $list["0"]["SOLineDTOList"][$i]['DescFlexField']['PubDescSeg3'] = '';
  837. $list["0"]["SOLineDTOList"][$i]['OrderByQtyTU'] = $data['lh'][$i]['ts'];//条数
  838. $list["0"]["SOLineDTOList"][$i]['OrderByQtyPU'] = $data['lh'][$i]['ts'];//条数
  839. $list["0"]["SOLineDTOList"][$i]['OrderPriceTC'] = $shouldmoney;
  840. $list["0"]["SOLineDTOList"][$i]['Memo'] = '321321';
  841. }
  842. $list["0"]["AC"] = 'C009';//美金
  843. $list["0"]["SaleDepartment"] = '02';
  844. $list["0"]["BusinessDate"] = date('m/d/Y H:i:s',$data['dtime']);
  845. $list["0"]["DocumentType"] = 'SO1';
  846. $list["0"]["DocNo"] = $data['number'];
  847. $list["0"]["TC"] = 'C009';
  848. $list["0"]["ShipToSite"] = '';
  849. $list["0"]["PubDescSeg2"] = '';
  850. $list["0"]["SOSrcType"] = 0;
  851. $list["0"]["Seller"] = '201';
  852. $list["0"]["ConfirmTerm"] = '';
  853. $list["0"]["Memo"] = '';
  854. $list["0"]["ShipRule"] = '';
  855. $list = json_encode($list);
  856. return $list;
  857. }
  858. public function get_scdd($data)//数据查询
  859. {
  860. $list["0"]["OtherID"] = '123';
  861. $list["0"]["Org"]["Code"] = 120;
  862. $list["0"]["ItemMaster"]["Code"] = '#017(Old)-BW-13*4Wig-20-200%-Medium';
  863. $list["0"]["DocType"]["Code"] = 1;
  864. $list["0"]["Department"]["Code"] = 03;
  865. $list["0"]["ExpandLevel"] = 0;
  866. $list["0"]["AlternateType"] = 0;
  867. $list["0"]["RoutingAlternate"] = 0;
  868. $list["0"]["RoutingEffeDate"] = '';
  869. $list["0"]["ProductQty"] = 5;
  870. $list["0"]["ProductUOM"]["Code"] = '条';
  871. $list["0"]["StartDate"] = '2023-08-15';
  872. $list["0"]["CompleteDate"] = '2023-08-22';
  873. $list["0"]["MOSourceDocType"] = 0;
  874. $list["0"]["OwnerOrg"]["Code"] = 120;
  875. $list["0"]["SCVWh"]["Code"] = 02;
  876. $list["0"]["IsFirmed"] = 1;
  877. $list["0"]["IsCapacityLimit"] = false;
  878. $list["0"]["Priority"] = 0;
  879. $list["0"]["CUD"] = 0;
  880. $list["0"]["BOMType"] = 0;
  881. $list["0"]["Description"] = '测试';
  882. $list["0"]["MRPQty"] = 0;
  883. $list["0"]["MOID"] = 0;
  884. $list["0"]["PBUToSBURate"] = 0;
  885. $list["0"]["PBUToCBURate"] = 0;
  886. $list = json_encode($list);
  887. $token = $this->setting->get_yytoken_101();
  888. $url = 'http://172.31.105.167/U9C/webapi/Customer/Create';
  889. $header[] = "Content-Type: application/json";
  890. $header[] = "Token: ".$token;
  891. $ch = curl_init();
  892. curl_setopt($ch, CURLOPT_URL, $url);
  893. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  894. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  895. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  896. curl_setopt($ch, CURLOPT_POST, 1);
  897. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  898. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  899. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  900. $res = curl_exec($ch);
  901. $res = json_decode($res,true);
  902. return $res;
  903. }
  904. public function get_cxkc($data)//查询库存
  905. {
  906. $list["SqlString"] = 'select distinct a.id id,a.ItemInfo_ItemID itemid,a.ItemInfo_ItemCode itemcode,a.ItemInfo_ItemName itemname,c.Code1 code,a.SysVersion sysversion,c.specs specs,d.code itemflcode,d1.name itemflname,a.LotInfo_LotCode lotcode,e.code unitcode,e1.name unitname,SUM(a.StoreMainQty) kc_qty,SUM(a.StoreQtyCU) f_qty,SUM(a.StoreQty) qty,a.CreatedOn createdon,a.ModifiedOn modifiedon,a.Wh whid,b.code whcode,b1.Name whname,a.BinInfo_Code bincode,a.BinInfo_Name binname from InvTrans_WhQoh as a left join CBO_Wh as b on a.Wh=b.id left join CBO_Wh_Trl b1 on a.Wh=b1.ID left join CBO_ItemMaster as c on a.ItemInfo_ItemCode=c.Code left join CBO_Category as d on c.MainItemCategory=d.id left join CBO_Category_Trl as d1 on c.MainItemCategory=d1.id left join Base_UOM as e on a.StoreMainUOM = e.id left join Base_UOM_Trl as e1 on a.StoreMainUOM=e1.id GROUP BY a.id,a.ItemInfo_ItemID,a.ItemInfo_ItemCode,a.ItemInfo_ItemName,c.Code1,a.SysVersion,c.specs,d.code,d1.name,a.LotInfo_LotCode,e.code,e1.name,a.CreatedOn,a.ModifiedOn,a.Wh,b.code,b1.Name,a.BinInfo_Code,a.BinInfo_Name';
  907. $list = json_encode($list);
  908. $token = $this->setting->get_yytoken_101();
  909. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  910. $header[] = "Content-Type: application/json";
  911. $header[] = "Token: ".$token;
  912. $ch = curl_init();
  913. curl_setopt($ch, CURLOPT_URL, $url);
  914. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  915. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  916. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  917. curl_setopt($ch, CURLOPT_POST, 1);
  918. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  919. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  920. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  921. $res = curl_exec($ch);
  922. $res = json_decode($res,true);
  923. return $res;
  924. }
  925. public function get_cxck($data)//查询所有仓库
  926. {
  927. $list["SqlString"] = "select a.id,a.code,c.name,a.org,b.name org_name from CBO_Wh a left join CBO_Wh_trl c on c.id=a.id left join Base_Organization_trl b on a.org=b.id";
  928. $list = json_encode($list);
  929. $token = $this->setting->get_yytoken_101();
  930. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  931. $header[] = "Content-Type: application/json";
  932. $header[] = "Token: ".$token;
  933. $ch = curl_init();
  934. curl_setopt($ch, CURLOPT_URL, $url);
  935. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  936. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  937. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  938. curl_setopt($ch, CURLOPT_POST, 1);
  939. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  940. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  941. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  942. $res = curl_exec($ch);
  943. $res = json_decode($res,true);
  944. return $res;
  945. }
  946. public function get_cxrksh($data)//查询入库审核
  947. {
  948. $list["SqlString"] = "select docno,DescFlexField_PubDescSeg4 xukai_no,DocState from Complete_RcvRptDoc where docno = '".$data."' order by CreatedOn desc";
  949. $list = json_encode($list);
  950. $token = $this->setting->get_yytoken_101();
  951. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  952. $header[] = "Content-Type: application/json";
  953. $header[] = "Token: ".$token;
  954. $ch = curl_init();
  955. curl_setopt($ch, CURLOPT_URL, $url);
  956. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  957. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  958. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  959. curl_setopt($ch, CURLOPT_POST, 1);
  960. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  961. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  962. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  963. $res = curl_exec($ch);
  964. $res = json_decode($res,true);
  965. return $res;
  966. }
  967. public function _cxscdd($data)
  968. {
  969. $list["SqlString"] = "select DocNo,DescFlexField_PubDescSeg4 from MO_MO where DescFlexField_PubDescSeg4='".$data."' order by CreatedOn desc ";//查询生产订单
  970. $list = json_encode($list);
  971. $token = $this->setting->get_yytoken_101();
  972. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  973. $header[] = "Content-Type: application/json";
  974. $header[] = "Token: ".$token;
  975. $ch = curl_init();
  976. curl_setopt($ch, CURLOPT_URL, $url);
  977. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  978. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  979. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  980. curl_setopt($ch, CURLOPT_POST, 1);
  981. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  982. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  983. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  984. $res = curl_exec($ch);
  985. $res = json_decode($res,true);
  986. return $res;
  987. }
  988. public function _cxxsdd($data)
  989. {
  990. $list["SqlString"] = "select DocNo,DescFlexField_PubDescSeg4 from SM_SO where DocNo='".$data."' order by CreatedOn desc ";//销售订单
  991. $list = json_encode($list);
  992. $token = $this->setting->get_yytoken_101();
  993. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  994. $header[] = "Content-Type: application/json";
  995. $header[] = "Token: ".$token;
  996. $ch = curl_init();
  997. curl_setopt($ch, CURLOPT_URL, $url);
  998. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  999. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  1000. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  1001. curl_setopt($ch, CURLOPT_POST, 1);
  1002. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  1003. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  1004. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  1005. $res = curl_exec($ch);
  1006. $res = json_decode($res,true);
  1007. return $res;
  1008. }
  1009. public function _cxchd($data)
  1010. {
  1011. $list["SqlString"] = "select top 1 a.docno,b.SrcDocNo from SM_Ship a left join SM_ShipLine b on a.id=b.Ship where b.SrcDocNo='".$data."'";//出货单
  1012. $list = json_encode($list);
  1013. $token = $this->setting->get_yytoken_101();
  1014. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  1015. $header[] = "Content-Type: application/json";
  1016. $header[] = "Token: ".$token;
  1017. $ch = curl_init();
  1018. curl_setopt($ch, CURLOPT_URL, $url);
  1019. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  1020. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  1021. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  1022. curl_setopt($ch, CURLOPT_POST, 1);
  1023. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  1024. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  1025. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  1026. $res = curl_exec($ch);
  1027. $res = json_decode($res,true);
  1028. return $res;
  1029. }
  1030. public function get_cxdc($data)//查询调出
  1031. {
  1032. $list["SqlString"] = "select top 50 a.docno ruku_danhao,d.DescFlexField_PubDescSeg4 erp_danhao,a.CreatedBy,a.createdon,a.DocState,b.mo,d.docno mo_no,e.docno dianchu_danhao from Complete_RcvRptDoc a left join Complete_RcvRptDocLine b on b.RcvRptDoc=a.id left join CBO_ItemMaster c on b.item=c.id left join MO_MO d on b.mo=d.id left join InvDoc_TransferOut e on e.DescFlexField_PubDescSeg4=d.DescFlexField_PubDescSeg4 where (d.DescFlexField_PubDescSeg4 = '".$data."') order by a.createdon";//and (a.createdon >'2023-12-26' and a.createdon >'2023-12-27')
  1033. $list = json_encode($list);
  1034. $token = $this->setting->get_yytoken_101();
  1035. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  1036. $header[] = "Content-Type: application/json";
  1037. $header[] = "Token: ".$token;
  1038. $ch = curl_init();
  1039. curl_setopt($ch, CURLOPT_URL, $url);
  1040. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  1041. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  1042. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  1043. curl_setopt($ch, CURLOPT_POST, 1);
  1044. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  1045. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  1046. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  1047. $res = curl_exec($ch);
  1048. $res = json_decode($res,true);
  1049. return $res;
  1050. }
  1051. public function _neworder($data)
  1052. {
  1053. $fh = $this->get_order($data);
  1054. $res = $fh[0];
  1055. $fs = $fh[1];
  1056. $fh = json_encode($res);
  1057. if(isset($res['Data'][0]))
  1058. {
  1059. if($res['Data'][0]['m_isSucess'] == 1)
  1060. {
  1061. sleep(1);
  1062. $sh = $this->get_order_sh($data,'SO/Submit','SO/Approve',130);
  1063. if($sh['Data'][0]['m_isSucess'] == 1)
  1064. {
  1065. return array('c'=>0,'fs'=>$fs,'fh'=>$fh);exit;
  1066. }
  1067. else
  1068. {
  1069. return array('c'=>1,'error'=>$sh['Data'][0]['m_errorMsg'],'fs'=>$fs,'fh'=>$fh);exit;
  1070. }
  1071. }
  1072. else if ($res['Data'][0]['m_isSucess'] != 1 && stripos($res['Data'][0]['m_errorMsg'],'单号已存在') !== false)
  1073. {
  1074. return array('c'=>0,'fs'=>$fs,'fh'=>$fh);exit;
  1075. }
  1076. else
  1077. {
  1078. return array('c'=>1,'error'=>$res['Data'][0]['m_errorMsg'],'fs'=>$fs,'fh'=>$fh);exit;
  1079. }
  1080. }
  1081. else
  1082. {
  1083. return array('c'=>1,'error'=>json_encode($res),'fs'=>$fs,'fh'=>$fh);exit;
  1084. }
  1085. }
  1086. public function _peihuo($data,$kh,$number,$num,$djlx = 1000)
  1087. {
  1088. if(stripos($data['features'],'-126-') !== false)
  1089. {
  1090. $drck = '12003';//进入发条库
  1091. }
  1092. else if(stripos($data['features'],'-127-') !== false)
  1093. {
  1094. $drck = '12004';//进入发块库
  1095. }
  1096. else
  1097. {
  1098. $drck = '12006';//其它进入完成库
  1099. }
  1100. $error = '';$scid = '';
  1101. $lh = $this->get_cjlp(array('jm'=>$data['jm'],'title'=>$data['title'],'zh'=>$data['pm'],'bm'=>$data['bm']));
  1102. if(isset($lh['Data'][0]))
  1103. {
  1104. if($lh['Data'][0]['m_isSucess'] != 1)
  1105. {
  1106. if($lh['Data'][0]['m_errorMsg'] != '料号 已存在,请重新输入!')
  1107. {
  1108. $lc = 1;
  1109. $error .= $lh['Data'][0]['m_errorMsg'].';料号:'.$data['jm'].'编码:'.$data['bm'];
  1110. }
  1111. }
  1112. }
  1113. else
  1114. {
  1115. $lc = 1;
  1116. $error .= json_encode($lh);
  1117. }
  1118. if($error != '')
  1119. {
  1120. return array('c'=>1,'lc'=>1,'error'=>$error,'number'=>$data['number']);exit;
  1121. }
  1122. if($data['type'] == 0)
  1123. {
  1124. $sc = $this->apiyy->get_sc(array('sku'=>$data['jm'],'title'=>$data['title'],'ts'=>$num,'yyid'=>$kh,'number'=>$number,'shipremarks'=>$data['shipremarks'],'djlx'=>$djlx,'time'=>time(),'drck'=>$drck));
  1125. if(isset($sc['Data'][0]))
  1126. {
  1127. if($sc['Data'][0]['m_isSucess'] != 1)
  1128. {
  1129. $lc = 2;
  1130. $error .= $sc['Data'][0]['m_errorMsg'];
  1131. }
  1132. else
  1133. {
  1134. $scid .= $sc['Data'][0]['m_iD'].'~'.$sc['Data'][0]['m_code'].'~'.$drck;
  1135. }
  1136. }
  1137. else
  1138. {
  1139. $lc = 2;
  1140. $error .= json_encode($sc);
  1141. }
  1142. }
  1143. else
  1144. {
  1145. $sc = $this->apiyy->get_cg(array('orderinfo'=>$number,'purchase'=>$data['purchase'],'sku'=>$data['jm'],'ts'=>$num));
  1146. if(isset($sc['Data'][0]))
  1147. {
  1148. if($sc['Data'][0]['IsSucess'] != 1)
  1149. {
  1150. $lc = 2;
  1151. $error .= $sc['Data'][0]['ErrorMsg'].' - '.$data['jm'];
  1152. }
  1153. else
  1154. {
  1155. $scid .= $sc['Data'][0]['ID'].'~'.$sc['Data'][0]['Code']."~13001";
  1156. }
  1157. }
  1158. else
  1159. {
  1160. $lc = 2;
  1161. $error .= json_encode($sc);
  1162. }
  1163. }
  1164. if($error != '')
  1165. {
  1166. return array('c'=>1,'lc'=>$lc,'error'=>$error,'number'=>$data['number']);exit;
  1167. }
  1168. return array('c'=>0,'scid'=>$scid);exit;
  1169. }
  1170. public function _newrk($data)
  1171. {
  1172. $log = '';
  1173. $dbapi = 0;$error = '';$scid = $data['scid'];
  1174. $orderinfo = $data['number'];
  1175. if($data['dbapi'] == 1 || $data['dbapi'] == 0)
  1176. {
  1177. $xydc = array();
  1178. $sc = explode('~',$data['scid']);
  1179. $data['rkid'] = $sc[0];
  1180. $data['rkcode'] = $sc[1];
  1181. $wcrk = $this->get_cprk($data);
  1182. $log .= $orderinfo.'-RK-F = '.$wcrk[1].'\n';//入库发送日志
  1183. $log .= $orderinfo.'-RK-J = '.json_encode($wcrk[0]).'\n';//入库接收
  1184. $wcrk = $wcrk[0];
  1185. if(isset($wcrk['Data'][0]))
  1186. {
  1187. if($wcrk['Data'][0]['m_isSucess'] != 1)
  1188. {
  1189. $dbapi = 1;
  1190. $error .= $wcrk['Data'][0]['m_errorMsg'].';完成入库';
  1191. }
  1192. else
  1193. {
  1194. $scid .= '~'.$wcrk['Data'][0]['m_code'];
  1195. $data['co'] = $wcrk['Data'][0]['m_code'];
  1196. sleep(1);
  1197. $sh = $this->get_wcrk_sh($data);
  1198. $log .= $orderinfo.'-SH-F = '.$sh[1].'\n';//审核发送日志
  1199. $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'\n';//审核接收
  1200. $sh = $sh[0];
  1201. if($sh['Data'][0]['m_isSucess'] != 1)
  1202. {
  1203. $cxsh = $this->get_cxrksh($data['co']);
  1204. if(isset($cxsh['Data'][0]['docstate']))
  1205. {
  1206. if($cxsh['Data'][0]['docstate'] != 2)
  1207. {
  1208. $dbapi = 1;
  1209. $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核';
  1210. }
  1211. }
  1212. else
  1213. {
  1214. $dbapi = 1;
  1215. $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核';
  1216. }
  1217. }
  1218. }
  1219. }
  1220. else
  1221. {
  1222. $dbapi = 1;
  1223. $error .= json_encode($wcrk);
  1224. }
  1225. }
  1226. if($error != '')
  1227. {
  1228. $this->_log($orderinfo,$log);
  1229. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  1230. }
  1231. if($data['dbapi'] == 2)
  1232. {
  1233. $sc = explode('~',$scid);
  1234. $sc = array_reverse($sc);
  1235. $rkd = '';
  1236. foreach ($sc as $v)
  1237. {
  1238. if(stripos($v,'CPRK-') !== false)
  1239. {
  1240. $rkd = $v;
  1241. continue;
  1242. }
  1243. }
  1244. if($rkd == '')
  1245. {
  1246. $dbapi = 2;
  1247. $error .= 'ERP未找到入库单;完成审核';
  1248. }
  1249. else
  1250. {
  1251. $data['co'] = $rkd;
  1252. $sh = $this->get_wcrk_sh($data);
  1253. $log .= $orderinfo.'-SH-F = '.$sh[1].'\n';//审核发送日志
  1254. $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'\n';//审核接收
  1255. $sh = $sh[0];
  1256. if($sh['Data'][0]['m_isSucess'] != 1)
  1257. {
  1258. $cxsh = $this->get_cxrksh($data['co']);
  1259. if(isset($cxsh['Data'][0]['docstate']))
  1260. {
  1261. if($cxsh['Data'][0]['docstate'] != 2)
  1262. {
  1263. $dbapi = 2;
  1264. $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核';
  1265. }
  1266. }
  1267. else
  1268. {
  1269. $dbapi = 2;
  1270. $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核';
  1271. }
  1272. }
  1273. }
  1274. }
  1275. if($error != '')
  1276. {
  1277. $this->_log($orderinfo,$log);
  1278. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  1279. }
  1280. $sc = explode('~',$scid);
  1281. $data['scid'] = $sc[0];
  1282. $data['sccode'] = $sc[1];
  1283. $data['drck'] = $sc[2];
  1284. $dc = $this->get_dc($data);
  1285. $log .= $orderinfo.'-DC-F = '.$dc[1].'\n';//审核发送日志
  1286. $log .= $orderinfo.'-DC-J = '.json_encode($dc[0]).'\n';//审核接收
  1287. $dc = $dc[0];
  1288. if(isset($dc['Data'][0]))
  1289. {
  1290. if($dc['Data'][0]['IsSucess'] != 1)
  1291. {
  1292. $dbapi = 3;
  1293. $error .= $dc['Data'][0]['ErrorMsg'].';调出';
  1294. }
  1295. else
  1296. {
  1297. $scid .= '~'.$dc['Data'][0]['Code'];
  1298. }
  1299. }
  1300. else
  1301. {
  1302. $dbapi = 3;
  1303. $error .= json_encode($dc);
  1304. }
  1305. if($error != '')
  1306. {
  1307. $this->_log($orderinfo,$log);
  1308. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  1309. }
  1310. $cxdc = $this->get_cxdc($data['number']);
  1311. if(!isset($cxdc['Data'][0]))
  1312. {
  1313. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$data['number'].'调出验证未通过');exit;
  1314. }
  1315. $this->_log($orderinfo,$log);
  1316. return array('c'=>0,'scid'=>$scid);exit;
  1317. }
  1318. public function _log($orderinfo,$data)
  1319. {
  1320. $pdtime = date('Y-m-d',time());
  1321. $folderPath = './data/yylog/'.$pdtime; // 文件夹路径
  1322. $permissions = 0777; // 权限设置
  1323. file_exists($folderPath);
  1324. if(!is_file("./data/yylog/".$orderinfo.".txt"))
  1325. {
  1326. $myfile = fopen("./data/yylog/RK-".$orderinfo.".txt", "w") or die("Unable to open file!");
  1327. fwrite($myfile, $data);
  1328. fclose($myfile);
  1329. }
  1330. else
  1331. {
  1332. $myfile = fopen("./data/yylog/RK-".$orderinfo.".txt", "a+") or die("Unable to open file!");
  1333. fwrite($myfile, $data);
  1334. fclose($myfile);
  1335. }
  1336. }
  1337. }