Model_apiyy.php 59 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351
  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. $list["0"]["BusinessDate"] = date("Y-m-d H:i:s",time());
  203. $list["0"]["DocumentType"] = "PO01";
  204. $list["0"]["POLineDTOList"][0]["ItemInfo"]['m_code'] = $data['sku'];//料号
  205. $list["0"]["POLineDTOList"][0]["SupplierConfirmQtyTU"] = $data['ts'];//数量
  206. $list["0"]["POLineDTOList"][0]["ReqQtyTU"] = $data['ts'];
  207. //$list["0"]["POLineDTOList"][0]["FinallyPriceTC"] = '';//价格
  208. $list["0"]["POLineDTOList"][0]["SupplierConfirmQtyTBU"] = 0;
  209. //$list["0"]["POLineDTOList"][0]["DescFlexField"]['PubDescSeg3'] = 75;
  210. $list["0"]["POLineDTOList"][0]["ReqQtyTBU"] = 0;
  211. $list["0"]["POLineDTOList"][0]["POLineID"] = 0;
  212. $list["0"]["POLineDTOList"][0]["IsPresent"] = false;
  213. $list["0"]['BizType'] = 0;
  214. $list["0"]['DocNo'] = "";
  215. $list["0"]['OtherID'] = "";
  216. $list["0"]['DescFlexField'] = (object)array();
  217. $list["0"]['Supplier']['Code'] = $data['purchase'];
  218. $list["0"]['IsPriceIncludeTax'] = false;
  219. $list = json_encode($list);
  220. $token = $this->setting->get_yytoken_130();
  221. $url = 'http://172.31.105.167/U9C/webapi/PurchaseOrder/Create';
  222. $header[] = "Content-Type: application/json";
  223. $header[] = "Token: ".$token;
  224. $ch = curl_init();
  225. curl_setopt($ch, CURLOPT_URL, $url);
  226. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  227. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  228. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  229. curl_setopt($ch, CURLOPT_POST, 1);
  230. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  231. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  232. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  233. $res = curl_exec($ch);
  234. $res = json_decode($res,true);
  235. return $res;
  236. }
  237. //https://openapi.yyu9c.com/doc.html#/U9C%20OPENAPI/Receivement/Receivement_CreateRcvBySrcPO
  238. public function get_bzsh($data)//标准收货
  239. {
  240. $list["0"]["potorcvDTOS"][0]["BusinessDate"] = date("Y-m-d H:i:s",time());
  241. $list["0"]["potorcvDTOS"][0]["Amount1"] = $data['ts'];//收货数量
  242. $list["0"]["potorcvDTOS"][0]["Amount2"] = 0;//收货数量
  243. $list["0"]["potorcvDTOS"][0]["PONo"] = $data['od'];//订单号
  244. $list["0"]["potorcvDTOS"][0]["POLineNo"] = 10;
  245. $list["0"]["potorcvDTOS"][0]["POShipLineNo"] = 0;
  246. $list["0"]["potorcvDTOS"][0]["POShipLineKey"] = 0;
  247. $list["0"]["potorcvDTOS"][0]["DescFlexField"] = (object)array();
  248. $list["0"]["potorcvDTOS"][0]["Memo"] = $data['title'];
  249. /** 库位
  250. $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['BinCode'] = "";
  251. $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['LocationQtyTU'] = 0;
  252. $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['LocationNo'] = 0;
  253. $list["0"]["potorcvDTOS"][0]["rlInfo"]['RcvLineLocations'][0]['TallyTime'] = "";
  254. **/
  255. $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_iD'] = 0;
  256. $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_code'] = 13001;//许昌仓
  257. $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['m_name'] = "";
  258. $list["0"]["potorcvDTOS"][0]["rlInfo"]["Wh"]['sysState'] = 0;
  259. $list["0"]["potorcvDTOS"][0]["rlInfo"]["StorageType"] = 4;
  260. $list["0"]["SplitBy"] = array();
  261. $list["0"]["IsApproved"] = false;
  262. $list["0"]["DocStatus"] = 3;
  263. $list["0"]["OtherID"] = "";
  264. $list = json_encode($list);
  265. $token = $this->setting->get_yytoken_130();
  266. $url = 'http://172.31.105.167/U9C/webapi/Receivement/CreateRcvBySrcPO';
  267. $header[] = "Content-Type: application/json";
  268. $header[] = "Token: ".$token;
  269. $ch = curl_init();
  270. curl_setopt($ch, CURLOPT_URL, $url);
  271. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  272. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  273. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  274. curl_setopt($ch, CURLOPT_POST, 1);
  275. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  276. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  277. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  278. $res = curl_exec($ch);
  279. $res = json_decode($res,true);
  280. return $res;
  281. }
  282. public function get_sc($data)//生产订单
  283. {
  284. $list["0"]["OtherID"] = '';
  285. $list["0"]["Org"]['Code'] = "120";
  286. $list["0"]["ItemMaster"]["Code"] = $data['sku'];
  287. $list["0"]["DocType"]["Code"] = $data['djlx'];
  288. $list["0"]["Department"]["Code"] = "12008";
  289. $list["0"]["ExpandLevel"] = 0;
  290. $list["0"]["AlternateType"] = 0;
  291. $list["0"]["RoutingAlternate"] = 0;
  292. $list["0"]["RoutingEffeDate"] = '';
  293. $list["0"]["ProductQty"] = $data['ts'];
  294. $list["0"]["ProductUOM"]["Code"] = '条';
  295. $list["0"]["StartDate"] = date('Y-m-d',time());
  296. $list["0"]["CompleteDate"] = date('Y-m-d',$data['time']);
  297. $list["0"]["MOSourceDocType"] = 0;
  298. $list["0"]["OwnerOrg"]["Code"] = "120";
  299. $list["0"]["SCVWh"]["Code"] = $data['drck'];
  300. $list["0"]["DemandCode"] = -1;
  301. $list["0"]["IsFirmed"] = false;
  302. $list["0"]["IsCapacityLimit"] = false;
  303. $list["0"]["Priority"] = 0;
  304. $list["0"]["CUD"] = 0;
  305. $list["0"]["BOMType"] = 0;
  306. $list["0"]["Description"] = $data['title'];
  307. $list["0"]["MRPQty"] = 0;
  308. $list["0"]["MOID"] = 0;
  309. $list["0"]["PBUToSBURate"] = 0;
  310. $list["0"]["PBUToCBURate"] = 0;
  311. $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['yyid'];
  312. $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  313. $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  314. $list = json_encode($list);
  315. $token = $this->setting->get_yytoken_120();
  316. $url = 'http://172.31.105.167/U9C/webapi/MODoc/Create';
  317. $header[] = "Content-Type: application/json";
  318. $header[] = "Token: ".$token;
  319. $ch = curl_init();
  320. curl_setopt($ch, CURLOPT_URL, $url);
  321. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  322. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  323. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  324. curl_setopt($ch, CURLOPT_POST, 1);
  325. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  326. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  327. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  328. $res = curl_exec($ch);
  329. $res = json_decode($res,true);
  330. return $res;
  331. }
  332. public function get_chd($data)//出货单一次出整个订单
  333. {
  334. $list[0]["SrcDocType"] = 1;
  335. $list[0]["SrcDocNo"] = $data['number'];
  336. $list[0]["SrcDocLineNo"] = $data['i'];
  337. $list[0]["SrcDocSubLineNo"] = 10;
  338. $list[0]["WH"] = 1002309200047445;
  339. $list[0]["CurShipQty1"] = $data['ts'];
  340. $list[0]["SOIsConsign"] = false;
  341. $list[0]["OptionalSplitTerm"] = array();
  342. $list[0]["DescFlexField"] = (object)array();
  343. $list[0]["LineDescFlexField"] = (object)array();
  344. //$list[0]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600);
  345. //$list[0]["ShipConfirmDate"] = date("Y-m-d",time());
  346. $list[0]["DocStatus"] = 0;
  347. $list = json_encode($list);
  348. $token = $this->setting->get_yytoken_130();
  349. $url = 'http://172.31.105.167/U9C/webapi/Ship/CreateBySrcDoc';
  350. $header[] = "Content-Type: application/json";
  351. $header[] = "Token: ".$token;
  352. $ch = curl_init();
  353. curl_setopt($ch, CURLOPT_URL, $url);
  354. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  355. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  356. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  357. curl_setopt($ch, CURLOPT_POST, 1);
  358. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  359. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  360. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  361. $res = curl_exec($ch);
  362. $res = json_decode($res,true);
  363. return array($res,$list);
  364. }
  365. public function get_chd_zdd($data)//出货单一次出整个订单
  366. {
  367. for($i=0;$i<count($data['lh']);$i++)
  368. {
  369. $list[$i]["SrcDocType"] = 1;
  370. $list[$i]["SrcDocNo"] = $data['number'];
  371. $list[$i]["SrcDocLineNo"] = $i+1;
  372. $list[$i]["SrcDocSubLineNo"] = 10;
  373. $list[$i]["WH"] = 1002309200047445;
  374. $list[$i]["CurShipQty1"] = $data['lh'][$i]['ts'];
  375. $list[$i]["SOIsConsign"] = false;
  376. $list[$i]["OptionalSplitTerm"] = array();
  377. $list[$i]["DescFlexField"] = (object)array();
  378. $list[$i]["LineDescFlexField"] = (object)array();
  379. //$list[$i]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600);
  380. //$list[$i]["ShipConfirmDate"] = date("Y-m-d",time());
  381. $list[$i]["DocStatus"] = 0;
  382. }
  383. $list = json_encode($list);
  384. $token = $this->setting->get_yytoken_130();
  385. $url = 'http://172.31.105.167/U9C/webapi/Ship/CreateBySrcDoc';
  386. $header[] = "Content-Type: application/json";
  387. $header[] = "Token: ".$token;
  388. $ch = curl_init();
  389. curl_setopt($ch, CURLOPT_URL, $url);
  390. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  391. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  392. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  393. curl_setopt($ch, CURLOPT_POST, 1);
  394. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  395. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  396. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  397. $res = curl_exec($ch);
  398. $res = json_decode($res,true);
  399. return array($res,$list);
  400. }
  401. public function get_chd_cs($data)//出货单
  402. {
  403. $list["0"]["SrcDocType"] = 1;
  404. $list["0"]["SrcDocNo"] = $data['number'];
  405. $list["0"]["SrcDocLineNo"] = 1;
  406. $list["0"]["SrcDocSubLineNo"] = 10;
  407. $list["0"]["WH"] = 1002309200047445;
  408. $list["0"]["CurShipQty1"] = $data['ts'];
  409. $list["0"]["SOIsConsign"] = false;
  410. $list["0"]["OptionalSplitTerm"] = array();
  411. $list["0"]["DescFlexField"] = (object)array();
  412. $list["0"]["LineDescFlexField"] = (object)array();
  413. //$list["0"]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600);
  414. $list["0"]["ShipConfirmDate"] = date("Y-m-d",$data['librarytime']);
  415. $list["0"]["DocStatus"] = 0;
  416. $list = json_encode($list);
  417. return $list;
  418. }
  419. public function get_cprk($data)//产品入库
  420. {
  421. $list["0"]["DocNo"] = '';
  422. $list["0"]["CompleteList"]["0"]["MOKey"]["OtherID"] = '';
  423. $list["0"]["CompleteList"]["0"]["MOKey"]["ID"] = 0;
  424. $list["0"]["CompleteList"]["0"]["MOKey"]["DocNo"] = $data['rkcode'];
  425. $list["0"]["CompleteList"]["0"]["MOKey"]["OrgID"] = 0;
  426. $list["0"]["CompleteList"]["0"]["MOKey"]["IsSuccess"] = 1;
  427. $list["0"]["CompleteList"]["0"]["MOKey"]["ErrorInfo"] = '';
  428. $list["0"]["CompleteList"]["0"]["MOKey"]["CUD"] = 0;
  429. $list["0"]["CompleteList"]["0"]["Wh"]["Code"] = 02;
  430. $list["0"]["CompleteList"]["0"]["LineNum"] = 0;
  431. $list["0"]["CompleteList"]["0"]["StorageType"] = 4;
  432. $list["0"]["CompleteList"]["0"]["Grade"] = 0;
  433. $list["0"]["CompleteList"]["0"]["Element"] = 0;
  434. $list["0"]["CompleteList"]["0"]["CompleteQty"] = $data['ts'];
  435. $list["0"]["CompleteList"]["0"]["CompleteQtyByWhUOM"] = $data['ts'];
  436. $list["0"]["CompleteList"]["0"]["CompleteQtyByCostUOM"] = $data['ts'];
  437. $list["0"]["CompleteList"]["0"]["CUD"] = 0;
  438. $list["0"]["CompleteList"]["0"]["OwnerOrg"]["Code"] = 120;
  439. $list["0"]["CompleteList"]["0"]["OutputType"] = 0;
  440. $list["0"]["CompleteList"]["0"]["Item"]["Code"] = $data['jm'];
  441. $list["0"]["CompleteList"]["0"]["ScrapQty"] = 0;
  442. $list["0"]["CompleteList"]["0"]["ScrapQtyByCostUOM"] = 0;
  443. $list["0"]["CompleteList"]["0"]["PUToPBURate"] = 0;
  444. $list["0"]["CompleteList"]["0"]["CUToCBURate"] = 0;
  445. $list["0"]["CompleteList"]["0"]["PBUToCBURate"] = 0;
  446. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ID"] = 0;
  447. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocType"]["Code"] = 0;
  448. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["BusinessDate"] = '';
  449. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocNo"] = '';
  450. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["MOSrcDocType"] = 0;
  451. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocOrg"] = 0;
  452. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDoc"]["ID"] = $data['rkid'];
  453. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDoc"]["EntityType"] = 'UFIDA.U9.MO.MO.MO';
  454. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocVer"] = '';
  455. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLine"]["ID"] = 0;
  456. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLine"]["EntityType"] = '';
  457. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSubline"]["ID"] = 0;
  458. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSubline"]["EntityType"] = '';
  459. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocNo"] = $data['rkid'];
  460. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLineNo"] = '';
  461. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSublineNo"] = 10;
  462. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocID"] = $data['rkid'];
  463. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLineID"] = 0;
  464. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocType"] = '';
  465. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocDate"] = date("Y-m-d",time());
  466. //$list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ActualRcvTime"] = date("Y-m-d",time());
  467. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvOrg"]["Code"] = 120;
  468. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["Org"]["Code"] = 120;
  469. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["Direction"] = 0;
  470. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocState"] = 0;
  471. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["ID"] = 0;
  472. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["Code"] = '';
  473. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["Name"] = '';
  474. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["ID"] = 0;
  475. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["Code"] = '';
  476. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["Name"] = '';
  477. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["OtherID"] = '';
  478. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ProductUOM"]["Code"] = '条';
  479. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ProductBaseUOM"]["Code"] = '条';
  480. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StoreUOM"]["Code"] = '条';
  481. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StoreBaseUOM"]["Code"] = '条';
  482. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CoUOM"]["Code"] = '条';
  483. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CostBaseUOM"]["Code"] = '条';
  484. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OperationState"] = 0;
  485. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OutputType"] = 0;
  486. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Item"]["Code"] = $data['jm'];
  487. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OwnerOrg"]["Code"] = 120;
  488. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PUToPBURate"] = 0;
  489. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["SUToSBURate"] = 0;
  490. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PBUToSBURate"] = 0;
  491. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CUToCBURate"] = 0;
  492. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PBUToCBURate"] = 0;
  493. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Grade"] = 0;
  494. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Element"] = 0;
  495. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Wh"]["Code"] = 02;
  496. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StorageType"] = 4;
  497. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvValiddate"] = 0;
  498. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByProductUOM"] = 0;
  499. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByWhUOM"] = 0;
  500. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByCostUom"] = 0;
  501. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvOrg"]["Code"] = 001;
  502. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PerformingOrg"]["Code"] = 001;
  503. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CUD"] = 0;
  504. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["LineNum"] = 0;
  505. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["MO"]["Code"] = $data['rkcode'];
  506. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ID"] = 0;
  507. $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  508. $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  509. $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  510. $list["0"]["DocType"]["Code"] = 0;
  511. $list["0"]["BusinessDate"] = date("Y-m-d H:i:s",time());
  512. $list["0"]["OtherID"] = '';
  513. $list["0"]["Direction"] = 0;
  514. $list["0"]["IsOffLine"] = 1;
  515. $list["0"]["DocState"] = 0;
  516. $list["0"]["Remark"] = time();
  517. $list["0"]["RcvPerson"]["Code"] = 'ERP';
  518. $list = json_encode($list);
  519. $token = $this->setting->get_yytoken_120();
  520. $url = 'http://172.31.105.167/U9C/webapi/RcvRptDoc/Create';
  521. $header[] = "Content-Type: application/json";
  522. $header[] = "Token: ".$token;
  523. $ch = curl_init();
  524. curl_setopt($ch, CURLOPT_URL, $url);
  525. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  526. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  527. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  528. curl_setopt($ch, CURLOPT_POST, 1);
  529. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  530. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  531. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  532. $res = curl_exec($ch);
  533. $res = json_decode($res,true);
  534. return array($res,$list);
  535. }
  536. public function get_dc($data)//调出
  537. {
  538. $list["0"]["OtherID"] = $data['number'];
  539. $list["0"]["TransOutDocType_Code"] = 'TransOut001';
  540. $list["0"]["BusinessDate"] = date('Y-m-d',time());
  541. $list["0"]["TransferDirection"] = 0;
  542. //$list["0"]["DescFlexField"] = (object)array();
  543. //$list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  544. //$list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  545. //$list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  546. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  547. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['drck'];
  548. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  549. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];;
  550. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  551. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  552. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "120";
  553. //$list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  554. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  555. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  556. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  557. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = "13001";
  558. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4;
  559. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130";
  560. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "120";
  561. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts'];
  562. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = "";
  563. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1;
  564. $list = json_encode($list);
  565. $token = $this->setting->get_yytoken_120();
  566. $url = 'http://172.31.105.167/U9C/webapi/TransferOut/Create';
  567. $header[] = "Content-Type: application/json";
  568. $header[] = "Token: ".$token;
  569. $ch = curl_init();
  570. curl_setopt($ch, CURLOPT_URL, $url);
  571. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  572. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  573. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  574. curl_setopt($ch, CURLOPT_POST, 1);
  575. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  576. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  577. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  578. $res = curl_exec($ch);
  579. $res = json_decode($res,true);
  580. return array($res,$list);
  581. }
  582. public function get_dc_cs($data)//调出
  583. {
  584. $list["0"]["OtherID"] = $data['number'];
  585. $list["0"]["TransOutDocType_Code"] = 'TransOut001';
  586. $list["0"]["BusinessDate"] = date('Y-m-d',time());
  587. $list["0"]["TransferDirection"] = 0;
  588. //$list["0"]["DescFlexField"] = (object)array();
  589. //$list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  590. //$list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  591. //$list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  592. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  593. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['drck'];
  594. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  595. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];;
  596. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  597. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  598. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "120";
  599. //$list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  600. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  601. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  602. $list["0"]["TransOutLines"][0]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  603. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = "13001";
  604. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4;
  605. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130";
  606. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "120";
  607. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts'];
  608. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = "";
  609. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1;
  610. $list = json_encode($list);
  611. return $list;
  612. }
  613. public function get_cpdc($data)//成品仓调出到其它外贸仓
  614. {
  615. $list["0"]["OtherID"] = $data['number'];
  616. $list["0"]["TransOutDocType_Code"] = 'TransOut002';
  617. $list["0"]["BusinessDate"] = date('Y-m-d',time());
  618. $list["0"]["TransferDirection"] = 0;
  619. $list["0"]["DescFlexField"] = (object)array();
  620. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  621. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['dccbm'];//调出仓编码
  622. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  623. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];
  624. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  625. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  626. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "130";
  627. $list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  628. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = $data['drcbm'];//调入仓编码
  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'] = "130";
  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. $token = $this->setting->get_yytoken_130();
  637. $url = 'http://172.31.105.167/U9C/webapi/TransferOut/Create';
  638. $header[] = "Content-Type: application/json";
  639. $header[] = "Token: ".$token;
  640. $ch = curl_init();
  641. curl_setopt($ch, CURLOPT_URL, $url);
  642. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  643. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  644. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  645. curl_setopt($ch, CURLOPT_POST, 1);
  646. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  647. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  648. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  649. $res = curl_exec($ch);
  650. $res = json_decode($res,true);
  651. return $res;
  652. }
  653. public function get_order_sh($data,$url1,$url2,$qs)//订单 提交-》审核
  654. {
  655. if($qs == 120)
  656. {
  657. $token = $this->setting->get_yytoken_120();
  658. }
  659. else
  660. {
  661. $token = $this->setting->get_yytoken_130();
  662. }
  663. $list["0"]["Code"] = $data['number'];
  664. $list = json_encode($list);
  665. $url = 'http://172.31.105.167/U9C/webapi/'.$url1;
  666. $header[] = "Content-Type: application/json";
  667. $header[] = "Token: ".$token;
  668. $ch = curl_init();
  669. curl_setopt($ch, CURLOPT_URL, $url);
  670. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  671. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  672. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  673. curl_setopt($ch, CURLOPT_POST, 1);
  674. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  675. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  676. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  677. $res = curl_exec($ch);
  678. //提交结束 审核开始
  679. $url = 'http://172.31.105.167/U9C/webapi/'.$url2;
  680. $ch = curl_init();
  681. curl_setopt($ch, CURLOPT_URL, $url);
  682. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  683. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  684. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  685. curl_setopt($ch, CURLOPT_POST, 1);
  686. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  687. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  688. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  689. $res = curl_exec($ch);
  690. $res = json_decode($res,true);
  691. return $res;
  692. }
  693. public function get_wcrk_sh($data)//入库审核
  694. {
  695. $list["0"]["DocNo"] = $data['co'];
  696. //$list["0"]["OtherID"] = $data['co'];
  697. $list = json_encode($list);
  698. $token = $this->setting->get_yytoken_120();
  699. $url = 'http://172.31.105.167/U9C/webapi/RcvRptDoc/Approve';
  700. $header[] = "Content-Type: application/json";
  701. $header[] = "Token: ".$token;
  702. $ch = curl_init();
  703. curl_setopt($ch, CURLOPT_URL, $url);
  704. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  705. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  706. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  707. curl_setopt($ch, CURLOPT_POST, 1);
  708. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  709. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  710. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  711. $res = curl_exec($ch);
  712. $res = json_decode($res,true);
  713. return array($res,$list);
  714. }
  715. public function get_order($data)//订单 标准销售
  716. {
  717. $shouldmoney = ($data['shouldmoney'] > 0)?sprintf("%01.2f",$data['shouldmoney']/count($data['lh'])):$data['shouldmoney'];
  718. $list["0"]["OrderBy"] = $data['yyid'];
  719. for($i=0;$i<count($data['lh']);$i++)
  720. {
  721. $list["0"]["SOLineDTOList"][$i]['TU'] = '条';
  722. $list["0"]["SOLineDTOList"][$i]['ItemCode'] = $data['lh'][$i]['sku'];//料号
  723. $list["0"]["SOLineDTOList"][$i]['PU'] = '条';
  724. $list["0"]["SOLineDTOList"][$i]['ShipTogetherFlag'] = -1;
  725. $list["0"]["SOLineDTOList"][$i]['DocLineNo'] = $i+1;
  726. $list["0"]["SOLineDTOList"][$i]['CustomerItemNo'] = '';
  727. $list["0"]["SOLineDTOList"][$i]['CustomerItemName'] = '';
  728. $list["0"]["SOLineDTOList"][$i]['FinallyPriceTC'] = $shouldmoney;
  729. $list["0"]["SOLineDTOList"][$i]['PubDescSeg10'] = '';
  730. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['IsMRPRequire'] = 1;
  731. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['DemandType'] = -1;
  732. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['RequireDate'] = date('m/d/Y H:i:s',$data['dtime']);
  733. $list["0"]["SOLineDTOList"][$i]['RecTerm'] = '';
  734. $list["0"]["SOLineDTOList"][$i]['FreeType'] = ($data['shouldmoney'] < 0.01)?0:-1;
  735. $list["0"]["SOLineDTOList"][$i]['UsableQtyOfInv'] = 0;
  736. $list["0"]["SOLineDTOList"][$i]['PubDescSeg3'] = '';
  737. $list["0"]["SOLineDTOList"][$i]['PubDescSeg4'] = '0.00';
  738. $list["0"]["SOLineDTOList"][$i]['PriceList'] = '';
  739. $list["0"]["SOLineDTOList"][$i]['TaxMoneyTC'] = 0;
  740. $list["0"]["SOLineDTOList"][$i]['TotalMoneyTC'] = $data['budget'];
  741. $list["0"]["SOLineDTOList"][$i]['TaxSchedule'] = 'YZ05';
  742. $list["0"]["SOLineDTOList"][$i]['DescFlexField']['PubDescSeg3'] = '';
  743. $list["0"]["SOLineDTOList"][$i]['OrderByQtyTU'] = $data['lh'][$i]['ts'];//条数
  744. $list["0"]["SOLineDTOList"][$i]['OrderByQtyPU'] = $data['lh'][$i]['ts'];//条数
  745. $list["0"]["SOLineDTOList"][$i]['OrderPriceTC'] = $shouldmoney;
  746. $list["0"]["SOLineDTOList"][$i]['Memo'] = '321321';
  747. }
  748. $list["0"]["AC"] = 'C009';//美金
  749. $list["0"]["SaleDepartment"] = '02';
  750. $list["0"]["BusinessDate"] = date('m/d/Y H:i:s',$data['dtime']);
  751. $list["0"]["DocumentType"] = 'SO1';
  752. $list["0"]["DocNo"] = $data['number'];
  753. $list["0"]["TC"] = 'C009';
  754. $list["0"]["ShipToSite"] = '';
  755. $list["0"]["PubDescSeg2"] = '';
  756. $list["0"]["SOSrcType"] = 0;
  757. $list["0"]["Seller"] = '201';
  758. $list["0"]["ConfirmTerm"] = '';
  759. $list["0"]["Memo"] = '';
  760. $list["0"]["ShipRule"] = '';
  761. $list = json_encode($list);
  762. $token = $this->setting->get_yytoken_130();
  763. $url = 'http://172.31.105.167/U9C/webapi/SO/Create';
  764. $header[] = "Content-Type: application/json";
  765. $header[] = "Token: ".$token;
  766. $ch = curl_init();
  767. curl_setopt($ch, CURLOPT_URL, $url);
  768. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  769. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  770. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  771. curl_setopt($ch, CURLOPT_POST, 1);
  772. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  773. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  774. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  775. $res = curl_exec($ch);
  776. $res = json_decode($res,true);
  777. return array($res,$list);
  778. }
  779. public function get_order_cs($data)//订单 标准销售
  780. {
  781. $shouldmoney = ($data['shouldmoney'] > 0)?sprintf("%01.2f",$data['shouldmoney']/count($data['lh'])):$data['shouldmoney'];
  782. $list["0"]["OrderBy"] = $data['yyid'];
  783. for($i=0;$i<count($data['lh']);$i++)
  784. {
  785. $list["0"]["SOLineDTOList"][$i]['TU'] = '条';
  786. $list["0"]["SOLineDTOList"][$i]['ItemCode'] = $data['lh'][$i]['sku'];//料号
  787. $list["0"]["SOLineDTOList"][$i]['PU'] = '条';
  788. $list["0"]["SOLineDTOList"][$i]['ShipTogetherFlag'] = -1;
  789. $list["0"]["SOLineDTOList"][$i]['DocLineNo'] = $i+1;
  790. $list["0"]["SOLineDTOList"][$i]['CustomerItemNo'] = '';
  791. $list["0"]["SOLineDTOList"][$i]['CustomerItemName'] = '';
  792. $list["0"]["SOLineDTOList"][$i]['FinallyPriceTC'] = $shouldmoney;
  793. $list["0"]["SOLineDTOList"][$i]['PubDescSeg10'] = '';
  794. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['IsMRPRequire'] = 1;
  795. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['DemandType'] = -1;
  796. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['RequireDate'] = date('m/d/Y H:i:s',$data['dtime']);
  797. $list["0"]["SOLineDTOList"][$i]['RecTerm'] = '';
  798. $list["0"]["SOLineDTOList"][$i]['FreeType'] = ($data['shouldmoney'] < 0.01)?0:-1;
  799. $list["0"]["SOLineDTOList"][$i]['UsableQtyOfInv'] = 0;
  800. $list["0"]["SOLineDTOList"][$i]['PubDescSeg3'] = '';
  801. $list["0"]["SOLineDTOList"][$i]['PubDescSeg4'] = '0.00';
  802. $list["0"]["SOLineDTOList"][$i]['PriceList'] = '';
  803. $list["0"]["SOLineDTOList"][$i]['TaxMoneyTC'] = 0;
  804. $list["0"]["SOLineDTOList"][$i]['TotalMoneyTC'] = $data['budget'];
  805. $list["0"]["SOLineDTOList"][$i]['TaxSchedule'] = 'YZ05';
  806. $list["0"]["SOLineDTOList"][$i]['DescFlexField']['PubDescSeg3'] = '';
  807. $list["0"]["SOLineDTOList"][$i]['OrderByQtyTU'] = $data['lh'][$i]['ts'];//条数
  808. $list["0"]["SOLineDTOList"][$i]['OrderByQtyPU'] = $data['lh'][$i]['ts'];//条数
  809. $list["0"]["SOLineDTOList"][$i]['OrderPriceTC'] = $shouldmoney;
  810. $list["0"]["SOLineDTOList"][$i]['Memo'] = '321321';
  811. }
  812. $list["0"]["AC"] = 'C009';//美金
  813. $list["0"]["SaleDepartment"] = '02';
  814. $list["0"]["BusinessDate"] = date('m/d/Y H:i:s',$data['dtime']);
  815. $list["0"]["DocumentType"] = 'SO1';
  816. $list["0"]["DocNo"] = $data['number'];
  817. $list["0"]["TC"] = 'C009';
  818. $list["0"]["ShipToSite"] = '';
  819. $list["0"]["PubDescSeg2"] = '';
  820. $list["0"]["SOSrcType"] = 0;
  821. $list["0"]["Seller"] = '201';
  822. $list["0"]["ConfirmTerm"] = '';
  823. $list["0"]["Memo"] = '';
  824. $list["0"]["ShipRule"] = '';
  825. $list = json_encode($list);
  826. return $list;
  827. }
  828. public function get_scdd($data)//数据查询
  829. {
  830. $list["0"]["OtherID"] = '123';
  831. $list["0"]["Org"]["Code"] = 120;
  832. $list["0"]["ItemMaster"]["Code"] = '#017(Old)-BW-13*4Wig-20-200%-Medium';
  833. $list["0"]["DocType"]["Code"] = 1;
  834. $list["0"]["Department"]["Code"] = 03;
  835. $list["0"]["ExpandLevel"] = 0;
  836. $list["0"]["AlternateType"] = 0;
  837. $list["0"]["RoutingAlternate"] = 0;
  838. $list["0"]["RoutingEffeDate"] = '';
  839. $list["0"]["ProductQty"] = 5;
  840. $list["0"]["ProductUOM"]["Code"] = '条';
  841. $list["0"]["StartDate"] = '2023-08-15';
  842. $list["0"]["CompleteDate"] = '2023-08-22';
  843. $list["0"]["MOSourceDocType"] = 0;
  844. $list["0"]["OwnerOrg"]["Code"] = 120;
  845. $list["0"]["SCVWh"]["Code"] = 02;
  846. $list["0"]["IsFirmed"] = 1;
  847. $list["0"]["IsCapacityLimit"] = false;
  848. $list["0"]["Priority"] = 0;
  849. $list["0"]["CUD"] = 0;
  850. $list["0"]["BOMType"] = 0;
  851. $list["0"]["Description"] = '测试';
  852. $list["0"]["MRPQty"] = 0;
  853. $list["0"]["MOID"] = 0;
  854. $list["0"]["PBUToSBURate"] = 0;
  855. $list["0"]["PBUToCBURate"] = 0;
  856. $list = json_encode($list);
  857. $token = $this->setting->get_yytoken_101();
  858. $url = 'http://172.31.105.167/U9C/webapi/Customer/Create';
  859. $header[] = "Content-Type: application/json";
  860. $header[] = "Token: ".$token;
  861. $ch = curl_init();
  862. curl_setopt($ch, CURLOPT_URL, $url);
  863. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  864. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  865. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  866. curl_setopt($ch, CURLOPT_POST, 1);
  867. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  868. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  869. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  870. $res = curl_exec($ch);
  871. $res = json_decode($res,true);
  872. return $res;
  873. }
  874. public function get_cxkc($data)//查询库存
  875. {
  876. $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';
  877. $list = json_encode($list);
  878. $token = $this->setting->get_yytoken_101();
  879. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  880. $header[] = "Content-Type: application/json";
  881. $header[] = "Token: ".$token;
  882. $ch = curl_init();
  883. curl_setopt($ch, CURLOPT_URL, $url);
  884. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  885. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  886. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  887. curl_setopt($ch, CURLOPT_POST, 1);
  888. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  889. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  890. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  891. $res = curl_exec($ch);
  892. $res = json_decode($res,true);
  893. return $res;
  894. }
  895. public function get_cxck($data)//查询所有仓库
  896. {
  897. $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";
  898. $list = json_encode($list);
  899. $token = $this->setting->get_yytoken_101();
  900. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  901. $header[] = "Content-Type: application/json";
  902. $header[] = "Token: ".$token;
  903. $ch = curl_init();
  904. curl_setopt($ch, CURLOPT_URL, $url);
  905. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  906. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  907. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  908. curl_setopt($ch, CURLOPT_POST, 1);
  909. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  910. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  911. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  912. $res = curl_exec($ch);
  913. $res = json_decode($res,true);
  914. return $res;
  915. }
  916. public function get_cxrksh($data)//查询入库审核
  917. {
  918. $list["SqlString"] = "select docno,DescFlexField_PubDescSeg4 xukai_no,DocState from Complete_RcvRptDoc where docno = '".$data."' order by CreatedOn desc";
  919. $list = json_encode($list);
  920. $token = $this->setting->get_yytoken_101();
  921. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  922. $header[] = "Content-Type: application/json";
  923. $header[] = "Token: ".$token;
  924. $ch = curl_init();
  925. curl_setopt($ch, CURLOPT_URL, $url);
  926. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  927. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  928. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  929. curl_setopt($ch, CURLOPT_POST, 1);
  930. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  931. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  932. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  933. $res = curl_exec($ch);
  934. $res = json_decode($res,true);
  935. return $res;
  936. }
  937. public function _cxscdd($data)
  938. {
  939. $list["SqlString"] = "select DocNo,DescFlexField_PubDescSeg4 from MO_MO where DescFlexField_PubDescSeg4='".$data."' order by CreatedOn desc ";//查询生产订单
  940. $list = json_encode($list);
  941. $token = $this->setting->get_yytoken_101();
  942. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  943. $header[] = "Content-Type: application/json";
  944. $header[] = "Token: ".$token;
  945. $ch = curl_init();
  946. curl_setopt($ch, CURLOPT_URL, $url);
  947. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  948. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  949. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  950. curl_setopt($ch, CURLOPT_POST, 1);
  951. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  952. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  953. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  954. $res = curl_exec($ch);
  955. $res = json_decode($res,true);
  956. return $res;
  957. }
  958. public function _cxxsdd($data)
  959. {
  960. $list["SqlString"] = "select DocNo,DescFlexField_PubDescSeg4 from SM_SO where DocNo='".$data."' order by CreatedOn desc ";//销售订单
  961. $list = json_encode($list);
  962. $token = $this->setting->get_yytoken_101();
  963. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  964. $header[] = "Content-Type: application/json";
  965. $header[] = "Token: ".$token;
  966. $ch = curl_init();
  967. curl_setopt($ch, CURLOPT_URL, $url);
  968. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  969. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  970. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  971. curl_setopt($ch, CURLOPT_POST, 1);
  972. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  973. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  974. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  975. $res = curl_exec($ch);
  976. $res = json_decode($res,true);
  977. return $res;
  978. }
  979. public function _cxchd($data)
  980. {
  981. $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."'";//出货单
  982. $list = json_encode($list);
  983. $token = $this->setting->get_yytoken_101();
  984. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  985. $header[] = "Content-Type: application/json";
  986. $header[] = "Token: ".$token;
  987. $ch = curl_init();
  988. curl_setopt($ch, CURLOPT_URL, $url);
  989. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  990. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  991. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  992. curl_setopt($ch, CURLOPT_POST, 1);
  993. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  994. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  995. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  996. $res = curl_exec($ch);
  997. $res = json_decode($res,true);
  998. return $res;
  999. }
  1000. public function get_cxdc($data)//查询调出
  1001. {
  1002. $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')
  1003. $list = json_encode($list);
  1004. $token = $this->setting->get_yytoken_101();
  1005. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  1006. $header[] = "Content-Type: application/json";
  1007. $header[] = "Token: ".$token;
  1008. $ch = curl_init();
  1009. curl_setopt($ch, CURLOPT_URL, $url);
  1010. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  1011. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  1012. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  1013. curl_setopt($ch, CURLOPT_POST, 1);
  1014. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  1015. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  1016. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  1017. $res = curl_exec($ch);
  1018. $res = json_decode($res,true);
  1019. return $res;
  1020. }
  1021. public function _neworder($data)
  1022. {
  1023. $fh = $this->get_order($data);
  1024. $res = $fh[0];
  1025. $fs = $fh[1];
  1026. $fh = json_encode($res);
  1027. if(isset($res['Data'][0]))
  1028. {
  1029. if($res['Data'][0]['m_isSucess'] == 1)
  1030. {
  1031. sleep(1);
  1032. $sh = $this->get_order_sh($data,'SO/Submit','SO/Approve',130);
  1033. if($sh['Data'][0]['m_isSucess'] == 1)
  1034. {
  1035. return array('c'=>0,'fs'=>$fs,'fh'=>$fh);exit;
  1036. }
  1037. else
  1038. {
  1039. return array('c'=>1,'error'=>$sh['Data'][0]['m_errorMsg'],'fs'=>$fs,'fh'=>$fh);exit;
  1040. }
  1041. }
  1042. else if ($res['Data'][0]['m_isSucess'] != 1 && stripos($res['Data'][0]['m_errorMsg'],'单号已存在') !== false)
  1043. {
  1044. return array('c'=>0,'fs'=>$fs,'fh'=>$fh);exit;
  1045. }
  1046. else
  1047. {
  1048. return array('c'=>1,'error'=>$res['Data'][0]['m_errorMsg'],'fs'=>$fs,'fh'=>$fh);exit;
  1049. }
  1050. }
  1051. else
  1052. {
  1053. return array('c'=>1,'error'=>json_encode($res),'fs'=>$fs,'fh'=>$fh);exit;
  1054. }
  1055. }
  1056. public function _peihuo($data,$kh,$number,$num,$djlx = 1000)
  1057. {
  1058. if(stripos($data['features'],'-126-') !== false)
  1059. {
  1060. $drck = '12003';//进入发条库
  1061. }
  1062. else if(stripos($data['features'],'-127-') !== false)
  1063. {
  1064. $drck = '12004';//进入发块库
  1065. }
  1066. else
  1067. {
  1068. $drck = '12006';//其它进入完成库
  1069. }
  1070. $error = '';$scid = '';
  1071. $lh = $this->get_cjlp(array('jm'=>$data['jm'],'title'=>$data['title'],'zh'=>$data['pm'],'bm'=>$data['bm']));
  1072. if(isset($lh['Data'][0]))
  1073. {
  1074. if($lh['Data'][0]['m_isSucess'] != 1)
  1075. {
  1076. if($lh['Data'][0]['m_errorMsg'] != '料号 已存在,请重新输入!')
  1077. {
  1078. $lc = 1;
  1079. $error .= $lh['Data'][0]['m_errorMsg'].';料号:'.$data['jm'].'编码:'.$data['bm'];
  1080. }
  1081. }
  1082. }
  1083. else
  1084. {
  1085. $lc = 1;
  1086. $error .= json_encode($lh);
  1087. }
  1088. if($error != '')
  1089. {
  1090. return array('c'=>1,'lc'=>1,'error'=>$error,'number'=>$data['number']);exit;
  1091. }
  1092. if($data['type'] == 0)
  1093. {
  1094. $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));
  1095. if(isset($sc['Data'][0]))
  1096. {
  1097. if($sc['Data'][0]['m_isSucess'] != 1)
  1098. {
  1099. $lc = 2;
  1100. $error .= $sc['Data'][0]['m_errorMsg'];
  1101. }
  1102. else
  1103. {
  1104. $scid .= $sc['Data'][0]['m_iD'].'~'.$sc['Data'][0]['m_code'].'~'.$drck;
  1105. }
  1106. }
  1107. else
  1108. {
  1109. $lc = 2;
  1110. $error .= json_encode($sc);
  1111. }
  1112. }
  1113. else
  1114. {
  1115. $sc = $this->apiyy->get_cg(array('orderinfo'=>$number,'purchase'=>$data['purchase'],'sku'=>$data['jm'],'ts'=>$num));
  1116. if(isset($sc['Data'][0]))
  1117. {
  1118. if($sc['Data'][0]['IsSucess'] != 1)
  1119. {
  1120. $lc = 2;
  1121. $error .= $sc['Data'][0]['ErrorMsg'].' - '.$data['jm'];
  1122. }
  1123. else
  1124. {
  1125. $scid .= $sc['Data'][0]['ID'].'~'.$sc['Data'][0]['Code']."~13001";
  1126. }
  1127. }
  1128. else
  1129. {
  1130. $lc = 2;
  1131. $error .= json_encode($sc);
  1132. }
  1133. }
  1134. if($error != '')
  1135. {
  1136. return array('c'=>1,'lc'=>$lc,'error'=>$error,'number'=>$data['number']);exit;
  1137. }
  1138. return array('c'=>0,'scid'=>$scid);exit;
  1139. }
  1140. public function _newrk($data)
  1141. {
  1142. $log = '';
  1143. $dbapi = 0;$error = '';$scid = $data['scid'];
  1144. $orderinfo = $data['number'];
  1145. if($data['dbapi'] == 1 || $data['dbapi'] == 0)
  1146. {
  1147. $xydc = array();
  1148. $sc = explode('~',$data['scid']);
  1149. $data['rkid'] = $sc[0];
  1150. $data['rkcode'] = $sc[1];
  1151. $wcrk = $this->get_cprk($data);
  1152. $log .= $orderinfo.'-RK-F = '.$wcrk[1].'\n';//入库发送日志
  1153. $log .= $orderinfo.'-RK-J = '.json_encode($wcrk[0]).'\n';//入库接收
  1154. $wcrk = $wcrk[0];
  1155. if(isset($wcrk['Data'][0]))
  1156. {
  1157. if($wcrk['Data'][0]['m_isSucess'] != 1)
  1158. {
  1159. $dbapi = 1;
  1160. $error .= $wcrk['Data'][0]['m_errorMsg'].';完成入库';
  1161. }
  1162. else
  1163. {
  1164. $scid .= '~'.$wcrk['Data'][0]['m_code'];
  1165. $data['co'] = $wcrk['Data'][0]['m_code'];
  1166. sleep(1);
  1167. $sh = $this->get_wcrk_sh($data);
  1168. $log .= $orderinfo.'-SH-F = '.$sh[1].'\n';//审核发送日志
  1169. $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'\n';//审核接收
  1170. $sh = $sh[0];
  1171. if($sh['Data'][0]['m_isSucess'] != 1)
  1172. {
  1173. $cxsh = $this->get_cxrksh($data['co']);
  1174. if(isset($cxsh['Data'][0]['docstate']))
  1175. {
  1176. if($cxsh['Data'][0]['docstate'] != 2)
  1177. {
  1178. $dbapi = 1;
  1179. $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核';
  1180. }
  1181. }
  1182. else
  1183. {
  1184. $dbapi = 1;
  1185. $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核';
  1186. }
  1187. }
  1188. }
  1189. }
  1190. else
  1191. {
  1192. $dbapi = 1;
  1193. $error .= json_encode($wcrk);
  1194. }
  1195. }
  1196. if($error != '')
  1197. {
  1198. $this->_log($orderinfo,$log);
  1199. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  1200. }
  1201. if($data['dbapi'] == 2)
  1202. {
  1203. $sc = explode('~',$scid);
  1204. $sc = array_reverse($sc);
  1205. $rkd = '';
  1206. foreach ($sc as $v)
  1207. {
  1208. if(stripos($v,'CPRK-') !== false)
  1209. {
  1210. $rkd = $v;
  1211. continue;
  1212. }
  1213. }
  1214. if($rkd == '')
  1215. {
  1216. $dbapi = 2;
  1217. $error .= 'ERP未找到入库单;完成审核';
  1218. }
  1219. else
  1220. {
  1221. $data['co'] = $rkd;
  1222. $sh = $this->get_wcrk_sh($data);
  1223. $log .= $orderinfo.'-SH-F = '.$sh[1].'\n';//审核发送日志
  1224. $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'\n';//审核接收
  1225. $sh = $sh[0];
  1226. if($sh['Data'][0]['m_isSucess'] != 1)
  1227. {
  1228. $cxsh = $this->get_cxrksh($data['co']);
  1229. if(isset($cxsh['Data'][0]['docstate']))
  1230. {
  1231. if($cxsh['Data'][0]['docstate'] != 2)
  1232. {
  1233. $dbapi = 2;
  1234. $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核';
  1235. }
  1236. }
  1237. else
  1238. {
  1239. $dbapi = 2;
  1240. $error .= $data['co'].' - '.$sh['Data'][0]['m_errorMsg'].';完成审核';
  1241. }
  1242. }
  1243. }
  1244. }
  1245. if($error != '')
  1246. {
  1247. $this->_log($orderinfo,$log);
  1248. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  1249. }
  1250. $sc = explode('~',$scid);
  1251. $data['scid'] = $sc[0];
  1252. $data['sccode'] = $sc[1];
  1253. $data['drck'] = $sc[2];
  1254. $dc = $this->get_dc($data);
  1255. $log .= $orderinfo.'-DC-F = '.$dc[1].'\n';//审核发送日志
  1256. $log .= $orderinfo.'-DC-J = '.json_encode($dc[0]).'\n';//审核接收
  1257. $dc = $dc[0];
  1258. if(isset($dc['Data'][0]))
  1259. {
  1260. if($dc['Data'][0]['IsSucess'] != 1)
  1261. {
  1262. $dbapi = 3;
  1263. $error .= $dc['Data'][0]['ErrorMsg'].';调出';
  1264. }
  1265. else
  1266. {
  1267. $scid .= '~'.$dc['Data'][0]['Code'];
  1268. }
  1269. }
  1270. else
  1271. {
  1272. $dbapi = 3;
  1273. $error .= json_encode($dc);
  1274. }
  1275. if($error != '')
  1276. {
  1277. $this->_log($orderinfo,$log);
  1278. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  1279. }
  1280. $cxdc = $this->get_cxdc($data['number']);
  1281. if(!isset($cxdc['Data'][0]))
  1282. {
  1283. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$data['number'].'调出验证未通过');exit;
  1284. }
  1285. $this->_log($orderinfo,$log);
  1286. return array('c'=>0,'scid'=>$scid);exit;
  1287. }
  1288. public function _log($orderinfo,$data)
  1289. {
  1290. $pdtime = date('Y-m-d',time());
  1291. $folderPath = './data/yylog/'.$pdtime; // 文件夹路径
  1292. $permissions = 0777; // 权限设置
  1293. file_exists($folderPath);
  1294. if(!is_file("./data/yylog/".$orderinfo.".txt"))
  1295. {
  1296. $myfile = fopen("./data/yylog/RK-".$orderinfo.".txt", "w") or die("Unable to open file!");
  1297. fwrite($myfile, $data);
  1298. fclose($myfile);
  1299. }
  1300. else
  1301. {
  1302. $myfile = fopen("./data/yylog/RK-".$orderinfo.".txt", "a+") or die("Unable to open file!");
  1303. fwrite($myfile, $data);
  1304. fclose($myfile);
  1305. }
  1306. }
  1307. }