Model_apiyy-.php 48 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107
  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"] = 1;
  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",$data['librarytime']);
  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 $res;
  364. }
  365. public function get_chd_cs($data)//出货单
  366. {
  367. $list["0"]["SrcDocType"] = 1;
  368. $list["0"]["SrcDocNo"] = $data['number'];
  369. $list["0"]["SrcDocLineNo"] = 1;
  370. $list["0"]["SrcDocSubLineNo"] = 10;
  371. $list["0"]["WH"] = 1002309200047445;
  372. $list["0"]["CurShipQty1"] = $data['ts'];
  373. $list["0"]["SOIsConsign"] = false;
  374. $list["0"]["OptionalSplitTerm"] = array();
  375. $list["0"]["DescFlexField"] = (object)array();
  376. $list["0"]["LineDescFlexField"] = (object)array();
  377. //$list["0"]["ShipDate"] = date("Y-m-d",$data['librarytime']+24*3600);
  378. $list["0"]["ShipConfirmDate"] = date("Y-m-d",$data['librarytime']);
  379. $list["0"]["DocStatus"] = 0;
  380. $list = json_encode($list);
  381. return $list;
  382. }
  383. public function get_cprk($data)//产品入库
  384. {
  385. $list["0"]["DocNo"] = '';
  386. $list["0"]["CompleteList"]["0"]["MOKey"]["OtherID"] = '';
  387. $list["0"]["CompleteList"]["0"]["MOKey"]["ID"] = 0;
  388. $list["0"]["CompleteList"]["0"]["MOKey"]["DocNo"] = $data['rkcode'];
  389. $list["0"]["CompleteList"]["0"]["MOKey"]["OrgID"] = 0;
  390. $list["0"]["CompleteList"]["0"]["MOKey"]["IsSuccess"] = 1;
  391. $list["0"]["CompleteList"]["0"]["MOKey"]["ErrorInfo"] = '';
  392. $list["0"]["CompleteList"]["0"]["MOKey"]["CUD"] = 0;
  393. $list["0"]["CompleteList"]["0"]["Wh"]["Code"] = 02;
  394. $list["0"]["CompleteList"]["0"]["LineNum"] = 0;
  395. $list["0"]["CompleteList"]["0"]["StorageType"] = 4;
  396. $list["0"]["CompleteList"]["0"]["Grade"] = 0;
  397. $list["0"]["CompleteList"]["0"]["Element"] = 0;
  398. $list["0"]["CompleteList"]["0"]["CompleteQty"] = $data['ts'];
  399. $list["0"]["CompleteList"]["0"]["CompleteQtyByWhUOM"] = $data['ts'];
  400. $list["0"]["CompleteList"]["0"]["CompleteQtyByCostUOM"] = $data['ts'];
  401. $list["0"]["CompleteList"]["0"]["CUD"] = 0;
  402. $list["0"]["CompleteList"]["0"]["OwnerOrg"]["Code"] = 120;
  403. $list["0"]["CompleteList"]["0"]["OutputType"] = 0;
  404. $list["0"]["CompleteList"]["0"]["Item"]["Code"] = $data['jm'];
  405. $list["0"]["CompleteList"]["0"]["ScrapQty"] = 0;
  406. $list["0"]["CompleteList"]["0"]["ScrapQtyByCostUOM"] = 0;
  407. $list["0"]["CompleteList"]["0"]["PUToPBURate"] = 0;
  408. $list["0"]["CompleteList"]["0"]["CUToCBURate"] = 0;
  409. $list["0"]["CompleteList"]["0"]["PBUToCBURate"] = 0;
  410. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ID"] = 0;
  411. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocType"]["Code"] = 0;
  412. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["BusinessDate"] = '';
  413. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocNo"] = '';
  414. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["MOSrcDocType"] = 0;
  415. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocOrg"] = 0;
  416. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDoc"]["ID"] = $data['rkid'];
  417. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDoc"]["EntityType"] = 'UFIDA.U9.MO.MO.MO';
  418. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocVer"] = '';
  419. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLine"]["ID"] = 0;
  420. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLine"]["EntityType"] = '';
  421. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSubline"]["ID"] = 0;
  422. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSubline"]["EntityType"] = '';
  423. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocNo"] = $data['rkid'];
  424. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLineNo"] = '';
  425. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocSublineNo"] = 10;
  426. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocID"] = $data['rkid'];
  427. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocLineID"] = 0;
  428. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["SourceDoc"]["SrcDocType"] = '';
  429. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocDate"] = '';
  430. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["ActualRcvTime"] = '';
  431. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvOrg"]["Code"] = 120;
  432. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["Org"]["Code"] = 120;
  433. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["Direction"] = 0;
  434. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["DocState"] = 0;
  435. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["ID"] = 0;
  436. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["Code"] = '';
  437. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvDep"]["Name"] = '';
  438. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["ID"] = 0;
  439. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["Code"] = '';
  440. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["RcvPerson"]["Name"] = '';
  441. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvRptDocDTO"]["OtherID"] = '';
  442. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ProductUOM"]["Code"] = '条';
  443. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ProductBaseUOM"]["Code"] = '条';
  444. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StoreUOM"]["Code"] = '条';
  445. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StoreBaseUOM"]["Code"] = '条';
  446. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CoUOM"]["Code"] = '条';
  447. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CostBaseUOM"]["Code"] = '条';
  448. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OperationState"] = 0;
  449. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OutputType"] = 0;
  450. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Item"]["Code"] = $data['jm'];
  451. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["OwnerOrg"]["Code"] = 120;
  452. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PUToPBURate"] = 0;
  453. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["SUToSBURate"] = 0;
  454. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PBUToSBURate"] = 0;
  455. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CUToCBURate"] = 0;
  456. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PBUToCBURate"] = 0;
  457. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Grade"] = 0;
  458. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Element"] = 0;
  459. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["Wh"]["Code"] = 02;
  460. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["StorageType"] = 4;
  461. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvValiddate"] = 0;
  462. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByProductUOM"] = 0;
  463. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByWhUOM"] = 0;
  464. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvQtyByCostUom"] = 0;
  465. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["RcvOrg"]["Code"] = 001;
  466. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["PerformingOrg"]["Code"] = 001;
  467. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["CUD"] = 0;
  468. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["LineNum"] = 0;
  469. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["MO"]["Code"] = $data['rkcode'];
  470. $list["0"]["CompleteList"]["0"]["SourceRcvRptLine"]["ID"] = 0;
  471. $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  472. $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  473. $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  474. $list["0"]["DocType"]["Code"] = 0;
  475. $list["0"]["BusinessDate"] = '';
  476. $list["0"]["OtherID"] = '';
  477. $list["0"]["Direction"] = 0;
  478. $list["0"]["IsOffLine"] = 1;
  479. $list["0"]["DocState"] = 0;
  480. $list["0"]["Remark"] = time();
  481. $list["0"]["RcvPerson"]["Code"] = 'ERP';
  482. $list = json_encode($list);
  483. $token = $this->setting->get_yytoken_120();
  484. $url = 'http://172.31.105.167/U9C/webapi/RcvRptDoc/Create';
  485. $header[] = "Content-Type: application/json";
  486. $header[] = "Token: ".$token;
  487. $ch = curl_init();
  488. curl_setopt($ch, CURLOPT_URL, $url);
  489. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  490. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  491. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  492. curl_setopt($ch, CURLOPT_POST, 1);
  493. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  494. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  495. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  496. $res = curl_exec($ch);
  497. $res = json_decode($res,true);
  498. return array($res,$list);
  499. }
  500. public function get_dc($data)//调出
  501. {
  502. $list["0"]["OtherID"] = $data['number'];
  503. $list["0"]["TransOutDocType_Code"] = 'TransOut001';
  504. $list["0"]["BusinessDate"] = date('Y-m-d',time());
  505. $list["0"]["TransferDirection"] = 0;
  506. //$list["0"]["DescFlexField"] = (object)array();
  507. $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  508. $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  509. $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  510. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  511. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['drck'];
  512. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  513. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];;
  514. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  515. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  516. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "120";
  517. $list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  518. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = "13001";
  519. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4;
  520. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130";
  521. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "120";
  522. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts'];
  523. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = "";
  524. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1;
  525. $list = json_encode($list);
  526. $token = $this->setting->get_yytoken_120();
  527. $url = 'http://172.31.105.167/U9C/webapi/TransferOut/Create';
  528. $header[] = "Content-Type: application/json";
  529. $header[] = "Token: ".$token;
  530. $ch = curl_init();
  531. curl_setopt($ch, CURLOPT_URL, $url);
  532. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  533. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  534. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  535. curl_setopt($ch, CURLOPT_POST, 1);
  536. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  537. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  538. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  539. $res = curl_exec($ch);
  540. $res = json_decode($res,true);
  541. return array($res.$list);
  542. }
  543. public function get_dc_cs($data)//调出
  544. {
  545. $list["0"]["OtherID"] = $data['number'];
  546. $list["0"]["TransOutDocType_Code"] = 'TransOut001';
  547. $list["0"]["BusinessDate"] = date('Y-m-d',time());
  548. $list["0"]["TransferDirection"] = 0;
  549. //$list["0"]["DescFlexField"] = (object)array();
  550. $list["0"]["DescFlexField"]["PubDescSeg2"] = $data['kh'];
  551. $list["0"]["DescFlexField"]["PubDescSeg4"] = $data['number'];
  552. $list["0"]["DescFlexField"]["PubDescSeg5"] = $data['shipremarks'];
  553. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  554. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['drck'];
  555. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  556. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];;
  557. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  558. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  559. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "120";
  560. $list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  561. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = "13001";
  562. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4;
  563. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130";
  564. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "120";
  565. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts'];
  566. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = "";
  567. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1;
  568. $list = json_encode($list);
  569. return $list;
  570. }
  571. public function get_cpdc($data)//成品仓调出到其它外贸仓
  572. {
  573. $list["0"]["OtherID"] = $data['number'];
  574. $list["0"]["TransOutDocType_Code"] = 'TransOut002';
  575. $list["0"]["BusinessDate"] = date('Y-m-d',time());
  576. $list["0"]["TransferDirection"] = 0;
  577. $list["0"]["DescFlexField"] = (object)array();
  578. $list["0"]["TransOutLines"][0]['ItemInfo']['ItemCode'] = $data['jm'];
  579. $list["0"]["TransOutLines"][0]["TransOutWh_Code"] = $data['dccbm'];//调出仓编码
  580. $list["0"]["TransOutLines"][0]["StoreUOM_Code"] = "条";
  581. $list["0"]["TransOutLines"][0]["StoreUOMQty"] = $data['ts'];
  582. $list["0"]["TransOutLines"][0]["StorageType"] = 4;
  583. $list["0"]["TransOutLines"][0]["LotInfo_Code"] = "";
  584. $list["0"]["TransOutLines"][0]["TransOutOwnerOrg_Code"] = "130";
  585. $list["0"]["TransOutLines"][0]["DescFlexField"] = (object)array();
  586. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInWh_Code'] = $data['drcbm'];//调入仓编码
  587. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StorageType'] = 4;
  588. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransInOrg_Code'] = "130";
  589. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['TransOutOwnerOrg_Code'] = "130";
  590. $list["0"]["TransOutLines"][0]["TransOutSubLines"][0]['StoreUOMQty'] = $data['ts'];
  591. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['BinInfo_Code'] = "";
  592. $list["0"]["TransOutLines"][0]["TransOutBins"][0]['StoreUOMQty'] = 1;
  593. $list = json_encode($list);
  594. $token = $this->setting->get_yytoken_130();
  595. $url = 'http://172.31.105.167/U9C/webapi/TransferOut/Create';
  596. $header[] = "Content-Type: application/json";
  597. $header[] = "Token: ".$token;
  598. $ch = curl_init();
  599. curl_setopt($ch, CURLOPT_URL, $url);
  600. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  601. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  602. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  603. curl_setopt($ch, CURLOPT_POST, 1);
  604. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  605. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  606. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  607. $res = curl_exec($ch);
  608. $res = json_decode($res,true);
  609. return $res;
  610. }
  611. public function get_order_sh($data,$url1,$url2,$qs)//订单 提交-》审核
  612. {
  613. if($qs == 120)
  614. {
  615. $token = $this->setting->get_yytoken_120();
  616. }
  617. else
  618. {
  619. $token = $this->setting->get_yytoken_130();
  620. }
  621. $list["0"]["Code"] = $data['number'];
  622. $list = json_encode($list);
  623. $url = 'http://172.31.105.167/U9C/webapi/'.$url1;
  624. $header[] = "Content-Type: application/json";
  625. $header[] = "Token: ".$token;
  626. $ch = curl_init();
  627. curl_setopt($ch, CURLOPT_URL, $url);
  628. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  629. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  630. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  631. curl_setopt($ch, CURLOPT_POST, 1);
  632. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  633. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  634. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  635. $res = curl_exec($ch);
  636. //提交结束 审核开始
  637. $url = 'http://172.31.105.167/U9C/webapi/'.$url2;
  638. $ch = curl_init();
  639. curl_setopt($ch, CURLOPT_URL, $url);
  640. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  641. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  642. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  643. curl_setopt($ch, CURLOPT_POST, 1);
  644. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  645. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  646. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  647. $res = curl_exec($ch);
  648. $res = json_decode($res,true);
  649. return $res;
  650. }
  651. public function get_wcrk_sh($data)//入库审核
  652. {
  653. $list["0"]["DocNo"] = $data['co'];
  654. $list = json_encode($list);
  655. $token = $this->setting->get_yytoken_120();
  656. $url = 'http://172.31.105.167/U9C/webapi/RcvRptDoc/Approve';
  657. $header[] = "Content-Type: application/json";
  658. $header[] = "Token: ".$token;
  659. $ch = curl_init();
  660. curl_setopt($ch, CURLOPT_URL, $url);
  661. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  662. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  663. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  664. curl_setopt($ch, CURLOPT_POST, 1);
  665. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  666. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  667. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  668. $res = curl_exec($ch);
  669. $res = json_decode($res,true);
  670. return array($res,$list);
  671. }
  672. public function get_order($data)//订单 标准销售
  673. {
  674. $shouldmoney = ($data['shouldmoney'] > 0)?sprintf("%01.2f",$data['shouldmoney']/count($data['lh'])):$data['shouldmoney'];
  675. $list["0"]["OrderBy"] = $data['yyid'];
  676. for($i=0;$i<count($data['lh']);$i++)
  677. {
  678. $list["0"]["SOLineDTOList"][$i]['TU'] = '条';
  679. $list["0"]["SOLineDTOList"][$i]['ItemCode'] = $data['lh'][$i]['sku'];//料号
  680. $list["0"]["SOLineDTOList"][$i]['PU'] = '条';
  681. $list["0"]["SOLineDTOList"][$i]['ShipTogetherFlag'] = -1;
  682. $list["0"]["SOLineDTOList"][$i]['DocLineNo'] = $i+1;
  683. $list["0"]["SOLineDTOList"][$i]['CustomerItemNo'] = '';
  684. $list["0"]["SOLineDTOList"][$i]['CustomerItemName'] = '';
  685. $list["0"]["SOLineDTOList"][$i]['FinallyPriceTC'] = $shouldmoney;
  686. $list["0"]["SOLineDTOList"][$i]['PubDescSeg10'] = '';
  687. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['IsMRPRequire'] = 1;
  688. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['DemandType'] = -1;
  689. $list["0"]["SOLineDTOList"][$i]['SOShiplineDTOList'][0]['RequireDate'] = date('m/d/Y H:i:s',$data['dtime']);
  690. $list["0"]["SOLineDTOList"][$i]['RecTerm'] = '';
  691. $list["0"]["SOLineDTOList"][$i]['FreeType'] = ($data['shouldmoney'] < 0.01)?0:-1;
  692. $list["0"]["SOLineDTOList"][$i]['UsableQtyOfInv'] = 0;
  693. $list["0"]["SOLineDTOList"][$i]['PubDescSeg3'] = '';
  694. $list["0"]["SOLineDTOList"][$i]['PubDescSeg4'] = '0.00';
  695. $list["0"]["SOLineDTOList"][$i]['PriceList'] = '';
  696. $list["0"]["SOLineDTOList"][$i]['TaxMoneyTC'] = 0;
  697. $list["0"]["SOLineDTOList"][$i]['TotalMoneyTC'] = $data['budget'];
  698. $list["0"]["SOLineDTOList"][$i]['TaxSchedule'] = 'YZ05';
  699. $list["0"]["SOLineDTOList"][$i]['DescFlexField']['PubDescSeg3'] = '';
  700. $list["0"]["SOLineDTOList"][$i]['OrderByQtyTU'] = $data['lh'][$i]['ts'];//条数
  701. $list["0"]["SOLineDTOList"][$i]['OrderByQtyPU'] = $data['lh'][$i]['ts'];//条数
  702. $list["0"]["SOLineDTOList"][$i]['OrderPriceTC'] = $shouldmoney;
  703. $list["0"]["SOLineDTOList"][$i]['Memo'] = '321321';
  704. }
  705. $list["0"]["AC"] = 'C009';//美金
  706. $list["0"]["SaleDepartment"] = '02';
  707. $list["0"]["BusinessDate"] = date('m/d/Y H:i:s',$data['dtime']);
  708. $list["0"]["DocumentType"] = 'SO1';
  709. $list["0"]["DocNo"] = $data['number'];
  710. $list["0"]["TC"] = 'C009';
  711. $list["0"]["ShipToSite"] = '';
  712. $list["0"]["PubDescSeg2"] = '';
  713. $list["0"]["SOSrcType"] = 0;
  714. $list["0"]["Seller"] = '201';
  715. $list["0"]["ConfirmTerm"] = '';
  716. $list["0"]["Memo"] = '';
  717. $list["0"]["ShipRule"] = '';
  718. $list = json_encode($list);
  719. $token = $this->setting->get_yytoken_130();
  720. $url = 'http://172.31.105.167/U9C/webapi/SO/Create';
  721. $header[] = "Content-Type: application/json";
  722. $header[] = "Token: ".$token;
  723. $ch = curl_init();
  724. curl_setopt($ch, CURLOPT_URL, $url);
  725. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  726. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  727. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  728. curl_setopt($ch, CURLOPT_POST, 1);
  729. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  730. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  731. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  732. $res = curl_exec($ch);
  733. $res = json_decode($res,true);
  734. return $res;
  735. }
  736. public function get_scdd($data)//数据查询
  737. {
  738. $list["0"]["OtherID"] = '123';
  739. $list["0"]["Org"]["Code"] = 120;
  740. $list["0"]["ItemMaster"]["Code"] = '#017(Old)-BW-13*4Wig-20-200%-Medium';
  741. $list["0"]["DocType"]["Code"] = 1;
  742. $list["0"]["Department"]["Code"] = 03;
  743. $list["0"]["ExpandLevel"] = 0;
  744. $list["0"]["AlternateType"] = 0;
  745. $list["0"]["RoutingAlternate"] = 0;
  746. $list["0"]["RoutingEffeDate"] = '';
  747. $list["0"]["ProductQty"] = 5;
  748. $list["0"]["ProductUOM"]["Code"] = '条';
  749. $list["0"]["StartDate"] = '2023-08-15';
  750. $list["0"]["CompleteDate"] = '2023-08-22';
  751. $list["0"]["MOSourceDocType"] = 0;
  752. $list["0"]["OwnerOrg"]["Code"] = 120;
  753. $list["0"]["SCVWh"]["Code"] = 02;
  754. $list["0"]["IsFirmed"] = 1;
  755. $list["0"]["IsCapacityLimit"] = false;
  756. $list["0"]["Priority"] = 0;
  757. $list["0"]["CUD"] = 0;
  758. $list["0"]["BOMType"] = 0;
  759. $list["0"]["Description"] = '测试';
  760. $list["0"]["MRPQty"] = 0;
  761. $list["0"]["MOID"] = 0;
  762. $list["0"]["PBUToSBURate"] = 0;
  763. $list["0"]["PBUToCBURate"] = 0;
  764. $list = json_encode($list);
  765. $token = $this->setting->get_yytoken_101();
  766. $url = 'http://172.31.105.167/U9C/webapi/Customer/Create';
  767. $header[] = "Content-Type: application/json";
  768. $header[] = "Token: ".$token;
  769. $ch = curl_init();
  770. curl_setopt($ch, CURLOPT_URL, $url);
  771. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  772. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  773. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  774. curl_setopt($ch, CURLOPT_POST, 1);
  775. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  776. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  777. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  778. $res = curl_exec($ch);
  779. $res = json_decode($res,true);
  780. return $res;
  781. }
  782. public function get_cxkc($data)//查询库存
  783. {
  784. $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';
  785. $list = json_encode($list);
  786. $token = $this->setting->get_yytoken_101();
  787. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  788. $header[] = "Content-Type: application/json";
  789. $header[] = "Token: ".$token;
  790. $ch = curl_init();
  791. curl_setopt($ch, CURLOPT_URL, $url);
  792. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  793. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  794. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  795. curl_setopt($ch, CURLOPT_POST, 1);
  796. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  797. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  798. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  799. $res = curl_exec($ch);
  800. $res = json_decode($res,true);
  801. return $res;
  802. }
  803. public function get_cxck($data)//查询所有仓库
  804. {
  805. $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";
  806. $list = json_encode($list);
  807. $token = $this->setting->get_yytoken_101();
  808. $url = 'http://172.31.105.167/U9C/webapi/QueryCommon/QueryInfoBySql';
  809. $header[] = "Content-Type: application/json";
  810. $header[] = "Token: ".$token;
  811. $ch = curl_init();
  812. curl_setopt($ch, CURLOPT_URL, $url);
  813. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  814. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  815. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  816. curl_setopt($ch, CURLOPT_POST, 1);
  817. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  818. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  819. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  820. $res = curl_exec($ch);
  821. $res = json_decode($res,true);
  822. return $res;
  823. }
  824. public function _neworder($data)
  825. {
  826. $res = $this->get_order($data);
  827. if(isset($res['Data'][0]))
  828. {
  829. if($res['Data'][0]['m_isSucess'] == 1)
  830. {
  831. sleep(1);
  832. $sh = $this->get_order_sh($data,'SO/Submit','SO/Approve',130);
  833. if($sh['Data'][0]['m_isSucess'] == 1)
  834. {
  835. return array('c'=>0);exit;
  836. }
  837. else
  838. {
  839. return array('c'=>1,'error'=>$sh['Data'][0]['m_errorMsg']);exit;
  840. }
  841. }
  842. else
  843. {
  844. return array('c'=>1,'error'=>$res['Data'][0]['m_errorMsg']);exit;
  845. }
  846. }
  847. else
  848. {
  849. return array('c'=>1,'error'=>json_encode($res));exit;
  850. }
  851. }
  852. public function _peihuo($data,$kh,$number,$num,$djlx = 1000)
  853. {
  854. if(stripos($data['features'],'-126-') !== false)
  855. {
  856. $drck = '12003';//进入发条库
  857. }
  858. else if(stripos($data['features'],'-127-') !== false)
  859. {
  860. $drck = '12004';//进入发块库
  861. }
  862. else
  863. {
  864. $drck = '12006';//其它进入完成库
  865. }
  866. $error = '';$scid = '';
  867. $lh = $this->get_cjlp(array('jm'=>$data['jm'],'title'=>$data['title'],'zh'=>$data['pm'],'bm'=>$data['bm']));
  868. if(isset($lh['Data'][0]))
  869. {
  870. if($lh['Data'][0]['m_isSucess'] != 1)
  871. {
  872. if($lh['Data'][0]['m_errorMsg'] != '料号 已存在,请重新输入!')
  873. {
  874. $lc = 1;
  875. $error .= $lh['Data'][0]['m_errorMsg'];
  876. }
  877. }
  878. }
  879. else
  880. {
  881. $lc = 1;
  882. $error .= json_encode($lh);
  883. }
  884. if($error != '')
  885. {
  886. return array('c'=>1,'lc'=>1,'error'=>$error,'number'=>$data['number']);exit;
  887. }
  888. if($data['type'] == 0)
  889. {
  890. $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));
  891. if(isset($sc['Data'][0]))
  892. {
  893. if($sc['Data'][0]['m_isSucess'] != 1)
  894. {
  895. $lc = 2;
  896. $error .= $sc['Data'][0]['m_errorMsg'];
  897. }
  898. else
  899. {
  900. $scid .= $sc['Data'][0]['m_iD'].'~'.$sc['Data'][0]['m_code'].'~'.$drck;
  901. }
  902. }
  903. else
  904. {
  905. $lc = 2;
  906. $error .= json_encode($sc);
  907. }
  908. }
  909. else
  910. {
  911. $sc = $this->apiyy->get_cg(array('orderinfo'=>$number,'purchase'=>$data['purchase'],'sku'=>$data['jm'],'ts'=>$num));
  912. if(isset($sc['Data'][0]))
  913. {
  914. if($sc['Data'][0]['IsSucess'] != 1)
  915. {
  916. $lc = 2;
  917. $error .= $sc['Data'][0]['ErrorMsg'].' - '.$data['jm'];
  918. }
  919. else
  920. {
  921. $scid .= $sc['Data'][0]['ID'].'~'.$sc['Data'][0]['Code']."~13001";
  922. }
  923. }
  924. else
  925. {
  926. $lc = 2;
  927. $error .= json_encode($sc);
  928. }
  929. }
  930. if($error != '')
  931. {
  932. return array('c'=>1,'lc'=>$lc,'error'=>$error,'number'=>$data['number']);exit;
  933. }
  934. return array('c'=>0,'scid'=>$scid);exit;
  935. }
  936. public function _newrk($data)
  937. {
  938. $log = '';
  939. $dbapi = 0;$error = '';$scid = $data['scid'];
  940. $orderinfo = (isset($data['orderinfo']))?$data['orderinfo']:$data['number'];
  941. if($data['dbapi'] == 1 || $data['dbapi'] == 0)
  942. {
  943. $xydc = array();
  944. $sc = explode('~',$data['scid']);
  945. $data['rkid'] = $sc[0];
  946. $data['rkcode'] = $sc[1];
  947. $wcrk = $this->get_cprk($data);
  948. $log .= $orderinfo.'-RK-F = '.$wcrk[1].'<br>';//入库发送日志
  949. $log .= $orderinfo.'-RK-J = '.json_encode($wcrk[0]).'<br>';//入库接收
  950. $wcrk = $wcrk[0];
  951. if(isset($wcrk['Data'][0]))
  952. {
  953. if($wcrk['Data'][0]['m_isSucess'] != 1)
  954. {
  955. $dbapi = 1;
  956. $error .= $wcrk['Data'][0]['m_errorMsg'].';完成入库';
  957. }
  958. else
  959. {
  960. $scid .= '~'.$wcrk['Data'][0]['m_code'];
  961. $data['co'] = $wcrk['Data'][0]['m_code'];
  962. sleep(1);
  963. $sh = $this->get_wcrk_sh($data);
  964. $log .= $orderinfo.'-SH-F = '.$sh[1].'<br>';//审核发送日志
  965. $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'<br>';//审核接收
  966. $sh = $sh[0];
  967. if($sh['Data'][0]['m_isSucess'] != 1)
  968. {
  969. $dbapi = 2;
  970. $error .= $sh['Data'][0]['m_errorMsg'].';';
  971. }
  972. }
  973. }
  974. else
  975. {
  976. $dbapi = 1;
  977. $error .= json_encode($wcrk);
  978. }
  979. }
  980. if($error != '')
  981. {
  982. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  983. }
  984. if($data['dbapi'] == 2)
  985. {
  986. $sc = explode('~',$scid);
  987. $sc = array_reverse($sc);
  988. $rkd = '';
  989. foreach ($sc as $v)
  990. {
  991. if(stripos($v,'CPRK-') !== false)
  992. {
  993. $rkd = $v;
  994. continue;
  995. }
  996. }
  997. if($rkd == '')
  998. {
  999. $dbapi = 2;
  1000. $error .= 'ERP未找到入库单;完成审核';
  1001. }
  1002. else
  1003. {
  1004. $data['co'] = $rkd;
  1005. $sh = $this->get_wcrk_sh($data);
  1006. $log .= $orderinfo.'-SH-F = '.$sh[1].'<br>';//审核发送日志
  1007. $log .= $orderinfo.'-SH-J = '.json_encode($sh[0]).'<br>';//审核接收
  1008. $sh = $sh[0];
  1009. if($sh['Data'][0]['m_isSucess'] != 1)
  1010. {
  1011. $dbapi = 2;
  1012. $error .= $sh['Data'][0]['m_errorMsg'].';完成审核';
  1013. }
  1014. }
  1015. }
  1016. if($error != '')
  1017. {
  1018. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  1019. }
  1020. $sc = explode('~',$scid);
  1021. $data['scid'] = $sc[0];
  1022. $data['sccode'] = $sc[1];
  1023. $data['drck'] = $sc[2];
  1024. if($data['dbapi'] == 3 || $data['dbapi'] == 0)
  1025. {
  1026. $dc = $this->get_dc($data);
  1027. $log .= $orderinfo.'-DC-F = '.$dc[1].'<br>';//审核发送日志
  1028. $log .= $orderinfo.'-DC-J = '.json_encode($dc[0]).'<br>';//审核接收
  1029. $dc = $dc[0];
  1030. if(isset($dc['Data'][0]))
  1031. {
  1032. if($dc['Data'][0]['IsSucess'] != 1)
  1033. {
  1034. $dbapi = 3;
  1035. $error .= $dc['Data'][0]['ErrorMsg'].';调出';
  1036. }
  1037. else
  1038. {
  1039. $scid .= '~'.$dc['Data'][0]['Code'];
  1040. }
  1041. }
  1042. else
  1043. {
  1044. $dbapi = 3;
  1045. $error .= json_encode($dc);
  1046. }
  1047. }
  1048. if($error != '')
  1049. {
  1050. return array('c'=>1,'dbapi'=>$dbapi,'scid'=>$scid,'error'=>$error);exit;
  1051. }
  1052. return array('c'=>0,'scid'=>$scid);exit;
  1053. }
  1054. public function _log($orderinfo,$data)
  1055. {
  1056. $pdtime = date('Y-m-d',time());
  1057. $folderPath = './data/yylog/'; // 文件夹路径
  1058. $permissions = 0777; // 权限设置
  1059. if (!file_exists($folderPath)) {
  1060. mkdir($folderPath, $permissions);
  1061. echo '文件夹创建成功!';
  1062. } else {
  1063. echo '文件夹已存在!';
  1064. }
  1065. if(is_file("./data/yylog/".$pdtime.".txt"))
  1066. {
  1067. $myfile = fopen("./data/yylog/".$pdtime.".txt", "r") or die("Unable to open file!");
  1068. $bc = fread($myfile,filesize("./data/yylog/".$pdtime.".txt"));
  1069. fclose($myfile);
  1070. $bc = json_decode($bc,true);
  1071. $zzt = array($bc['zzt'][0],$bc['zzt'][1]);
  1072. }
  1073. }
  1074. }