Model_apiyyv1.php 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137
  1. <?php
  2. /**
  3. * 为防后期调用u9接口复用问题这里决定重新封装apiyy的接口
  4. */
  5. class Model_apiyyv1 extends Lin_Model
  6. {
  7. public $base_url = "http://139.129.33.38";
  8. function __construct(){
  9. parent::__construct();
  10. $this->load->database();
  11. $this->table = 'apiyy';
  12. $this->load_table('apiyy');
  13. $this->load->_model("Model_logic_ding","logic_ding");
  14. }
  15. /**
  16. * 生成u9的调出单
  17. */
  18. public function dcdCrate($params,$token){
  19. $list = $this->dcDataTrans($params);
  20. $url = '/U9C/webapi/TransferOut/Create';
  21. $url = $this->base_url.$url;
  22. $header[] = "Content-Type: application/json";
  23. $header[] = "Token: ".$token;
  24. $res = $this->sendReq($url,$header,json_encode($list));
  25. return array($res,$list);
  26. }
  27. /**
  28. * 提交调出单
  29. */
  30. public function dcdSubmit($params,$token){
  31. $list = [
  32. [
  33. 'Code'=>$params['number'] //调出单单号
  34. ]
  35. ];
  36. $url = '/U9C/webapi/TransferOut/Submit';
  37. $url = $this->base_url.$url;
  38. $header[] = "Content-Type: application/json";
  39. $header[] = "Token: ".$token;
  40. $res = $this->sendReq($url,$header,json_encode($list));
  41. return array($res,$list);
  42. }
  43. /**
  44. * 审核调出单
  45. */
  46. public function dcdApprove($params,$token){
  47. $list = [
  48. [
  49. 'Code'=>$params['number'] //调出单单号
  50. ]
  51. ];
  52. $url = '/U9C/webapi/TransferOut/Approve';
  53. $url = $this->base_url.$url;
  54. $header[] = "Content-Type: application/json";
  55. $header[] = "Token: ".$token;
  56. $res = $this->sendReq($url,$header,json_encode($list));
  57. return array($res,$list);
  58. }
  59. /**
  60. * 生成u9的销售单
  61. * 只是财务记录 不牵扯到库存
  62. */
  63. public function xsdCreate($params,$token){
  64. $list = $this->xsdDataTrans($params);
  65. $url = '/U9C/webapi/SO/Create';
  66. $url = $this->base_url.$url;
  67. $header[] = "Content-Type: application/json";
  68. $header[] = "Token: ".$token;
  69. $res = $this->sendReq($url,$header,json_encode($list));
  70. return array($res,$list);
  71. }
  72. /**
  73. * 工厂外销销售单
  74. */
  75. public function gcxsdWaiXiaoCreate($params,$token){
  76. $list = $this->xsdDataTrans($params);
  77. foreach($list as $k=>$v){
  78. $list[$k]['DescFlexField']["PrivateDescSeg3"] = $params['number'];
  79. $list[$k]['DescFlexField']["PrivateDescSeg6"] = 'MJ00199';
  80. $list[$k]['DescFlexField']["PubDescSeg6"] = 'MJ00199';
  81. $list[$k]['DescFlexField']["PubDescSeg3"] = $params['number'];
  82. // foreach($v['SOLineDTOList'] as $kk=>$vv){
  83. // $list[$k]['SOLineDTOList'][$kk]['DescFlexField']['PrivateDescSeg3'] = $params['number'];
  84. // $list[$k]['SOLineDTOList'][$kk]['DescFlexField']['PubDescSeg3'] = $params['number'];
  85. // }
  86. }
  87. $url = '/U9C/webapi/SO/Create';
  88. $url = $this->base_url.$url;
  89. $header[] = "Content-Type: application/json";
  90. $header[] = "Token: ".$token;
  91. $res = $this->sendReq($url,$header,json_encode($list));
  92. return array($res,$list);
  93. }
  94. /**
  95. * 工厂外销销售单
  96. */
  97. public function gcxsdWaiXiaoCreateBk($params,$token){
  98. $list = $this->xsdDataTransGC($params);
  99. foreach($list as $k=>$v){
  100. $list[$k]['DescFlexField']["PrivateDescSeg3"] = $params['number'];
  101. $list[$k]['DescFlexField']["PrivateDescSeg6"] = 'MJ00199';
  102. $list[$k]['DescFlexField']["PubDescSeg6"] = 'MJ00199';
  103. $list[$k]['DescFlexField']["PubDescSeg3"] = $params['number'];
  104. // foreach($v['SOLineDTOList'] as $kk=>$vv){
  105. // $list[$k]['SOLineDTOList'][$kk]['DescFlexField']['PrivateDescSeg3'] = $params['number'];
  106. // $list[$k]['SOLineDTOList'][$kk]['DescFlexField']['PubDescSeg3'] = $params['number'];
  107. // }
  108. }
  109. $url = '/U9C/webapi/SO/Create';
  110. $url = $this->base_url.$url;
  111. $header[] = "Content-Type: application/json";
  112. $header[] = "Token: ".$token;
  113. $res = $this->sendReq($url,$header,json_encode($list));
  114. return array($res,$list);
  115. }
  116. /**
  117. * 销售单状态查询 看看是否是审核状态
  118. */
  119. public function xsdCxByNo($xcd_no,$token){
  120. $list["SqlString"] = $list['SqlString'] = "select a.DocNo,a.Status,b.DocLineNo,c.DocSubLineNo,c.ShipPlanQtyPU,c.ItemInfo_ItemCode from SM_SO as a left join SM_SOLine as b on a.id = b.SO left join SM_SOShipline as c on c.SOLine = b.id where a.DocNo = '".$xcd_no."' order by a.CreatedOn desc ";;
  121. $url = '/U9C/webapi/QueryCommon/QueryInfoBySql';
  122. $url = $this->base_url.$url;
  123. $header[] = "Content-Type: application/json";
  124. $header[] = "Token: ".$token;
  125. $res = $this->sendReq($url,$header,json_encode($list));
  126. return array($res,$list);
  127. }
  128. /**
  129. * 生成u9的销售单
  130. * 只是财务记录 不牵扯到库存
  131. */
  132. public function xsdTwoCreate($params,$token){
  133. $list = $this->xsdTwoDataTrans($params);
  134. $url = '/U9C/webapi/SO/Create';
  135. $url = $this->base_url.$url;
  136. $header[] = "Content-Type: application/json";
  137. $header[] = "Token: ".$token;
  138. $res = $this->sendReq($url,$header,json_encode($list));
  139. return array($res,$list);
  140. }
  141. /**
  142. * 销售单提交
  143. */
  144. public function xsdSubmit($params,$token){
  145. $list = [
  146. [
  147. 'Code'=>$params['number'] //单号
  148. ]
  149. ];
  150. $url = '/U9C/webapi/SO/Submit';
  151. $url = $this->base_url.$url;
  152. $header[] = "Content-Type: application/json";
  153. $header[] = "Token: ".$token;
  154. $res = $this->sendReq($url,$header,json_encode($list));
  155. return array($res,$list);
  156. }
  157. /**
  158. * 销售单审核
  159. */
  160. public function xsdApprove($params,$token){
  161. $list = [
  162. [
  163. 'Code'=>$params['number'] //单号
  164. ]
  165. ];
  166. $url = '/U9C/webapi/SO/Approve';
  167. $url = $this->base_url.$url;
  168. $header[] = "Content-Type: application/json";
  169. $header[] = "Token: ".$token;
  170. $res = $this->sendReq($url,$header,json_encode($list));
  171. return array($res,$list);
  172. }
  173. /**
  174. * 根据调出单的单号做关联查询 然后匹配存储调入单的审核
  175. */
  176. public function drdcxBydcd($dcd_no,$token){
  177. // $list["SqlString"] = "select DescFlexField_PubDescSeg4 ,DocNo from InvDoc_TransferIn where DescFlexField_PubDescSeg4 = '".$dcd_no."'";
  178. $list["SqlString"] = "select a.docno,b.srcdocinfo_srcdocno from InvDoc_TransferIn as a left join InvDoc_TransInLine as b on a.id=b.TransferIn where srcdocinfo_srcdocno='".$dcd_no."'";
  179. $url = '/U9C/webapi/QueryCommon/QueryInfoBySql';
  180. $url = $this->base_url.$url;
  181. $header[] = "Content-Type: application/json";
  182. $header[] = "Token: ".$token;
  183. $res = $this->sendReq($url,$header,json_encode($list));
  184. return array($res,$list);
  185. }
  186. //销售单按照多单号查询
  187. public function xscsByordernos($xs_no_list,$token){
  188. $str = '';
  189. foreach($xs_no_list as $k=>$v){
  190. if($k==0){
  191. $str .="'".$v."'";
  192. }else{
  193. $str .=",'".$v."'";
  194. }
  195. }
  196. //$list['SqlString'] = "select a.DocNo,b.DocLineNo,c.DocSubLineNo,c.ShipPlanQtyPU from SM_SO as a left join SM_SOLine as b on a.id = b.SO left join SM_SOShipline as c on c.SOLine = b.id where a.DocNo in (".$str.") order by a.CreatedOn desc ";
  197. $list['SqlString'] = "select a.DocNo,b.DocLineNo,c.DocSubLineNo,c.ShipPlanQtyPU,c.ItemInfo_ItemCode from SM_SO as a left join SM_SOLine as b on a.id = b.SO left join SM_SOShipline as c on c.SOLine = b.id where a.DocNo in (".$str.") order by a.CreatedOn desc ";
  198. $url = '/U9C/webapi/QueryCommon/QueryInfoBySql';
  199. $url = $this->base_url.$url;
  200. $header[] = "Content-Type: application/json";
  201. $header[] = "Token: ".$token;
  202. $res = $this->sendReq($url,$header,json_encode($list));
  203. return array($res,$list);
  204. }
  205. /**
  206. * 调入单提交
  207. */
  208. public function drdSubmit($params,$token){
  209. $list = [
  210. [
  211. 'Code'=>$params['number'] //单号
  212. ]
  213. ];
  214. $url = '/U9C/webapi/TransferIn/Submit';
  215. $url = $this->base_url.$url;
  216. $header[] = "Content-Type: application/json";
  217. $header[] = "Token: ".$token;
  218. $res = $this->sendReq($url,$header,json_encode($list));
  219. return array($res,$list);
  220. }
  221. /**
  222. * 调入单审核
  223. */
  224. public function drdApprove($params,$token){
  225. $list = [
  226. [
  227. 'Code'=>$params['number'] //单号
  228. ]
  229. ];
  230. $url = '/U9C/webapi/TransferIn/Approve';
  231. $url = $this->base_url.$url;
  232. $header[] = "Content-Type: application/json";
  233. $header[] = "Token: ".$token;
  234. $res = $this->sendReq($url,$header,json_encode($list));
  235. return array($res,$list);
  236. }
  237. /**
  238. * 生成u9的采购单
  239. * 只是财务记录 不牵扯到库存
  240. * 目前采用的是无源的
  241. */
  242. public function cgdCreate($params,$token){
  243. $list = $this->cgdDataTrans($params);
  244. $url = '/U9C/webapi/PurchaseOrder/Create';
  245. $url = $this->base_url.$url;
  246. $header[] = "Content-Type: application/json";
  247. $header[] = "Token: ".$token;
  248. $res = $this->sendReq($url,$header,json_encode($list));
  249. return array($res,$list);
  250. }
  251. /**
  252. * 采购单提交
  253. */
  254. public function cgdSubmit($params,$token){
  255. $list = [
  256. [
  257. 'Code'=>$params['number'] //单号
  258. ]
  259. ];
  260. $url = '/U9C/webapi/PurchaseOrder/Submit';
  261. $url = $this->base_url.$url;
  262. $header[] = "Content-Type: application/json";
  263. $header[] = "Token: ".$token;
  264. $res = $this->sendReq($url,$header,json_encode($list));
  265. return array($res,$list);
  266. }
  267. /**
  268. * 采购单审核
  269. */
  270. public function cgdApprove($params,$token){
  271. $list = [
  272. [
  273. 'Code'=>$params['number'] //单号
  274. ]
  275. ];
  276. $url = '/U9C/webapi/PurchaseOrder/Approve';
  277. $url = $this->base_url.$url;
  278. $header[] = "Content-Type: application/json";
  279. $header[] = "Token: ".$token;
  280. $res = $this->sendReq($url,$header,json_encode($list));
  281. return array($res,$list);
  282. }
  283. /**
  284. * 生成u9的标准出货单
  285. * 会造成库存变动
  286. * 使用的是有源的就是销售单
  287. */
  288. public function bzchCreate($params,$token){
  289. $list = $this->yybzchDataTrans($params);
  290. $url = '/U9C/webapi/Ship/CreateBySrcDoc';
  291. $url = $this->base_url.$url;
  292. $header[] = "Content-Type: application/json";
  293. $header[] = "Token: ".$token;
  294. $res = $this->sendReq($url,$header,json_encode($list));
  295. return array($res,$list);
  296. }
  297. /**
  298. * 创建生产单
  299. */
  300. public function scdCreate($params,$token){
  301. $list = $this->scdDataTrans($params);
  302. $url = '/U9C/webapi/MODoc/Create';
  303. $url = $this->base_url.$url;
  304. $header[] = "Content-Type: application/json";
  305. $header[] = "Token: ".$token;
  306. $res = $this->sendReq($url,$header,json_encode($list));
  307. return array($res,$list);
  308. }
  309. /**
  310. * 查询生产订单状态
  311. */
  312. public function cxScdStatus($doc_no,$token){
  313. $list["SqlString"] = "select top 2 docno,DocState from mo_mo where docno = '".$doc_no."'";
  314. $url = '/U9C/webapi/QueryCommon/QueryInfoBySql';
  315. $url = $this->base_url.$url;
  316. $header[] = "Content-Type: application/json";
  317. $header[] = "Token: ".$token;
  318. $res = $this->sendReq($url,$header,json_encode($list));
  319. return array($res,$list);
  320. }
  321. /**
  322. * 标准出货单提交并审核
  323. */
  324. public function bzchSubmitAndApprove($params,$token){
  325. $list = [
  326. [
  327. 'Code'=>$params['number'] //单号
  328. ]
  329. ];
  330. $url = '/U9C/webapi/Ship/SubmitAndApprove';
  331. $url = $this->base_url.$url;
  332. $header[] = "Content-Type: application/json";
  333. $header[] = "Token: ".$token;
  334. $res = $this->sendReq($url,$header,json_encode($list));
  335. return array($res,$list);
  336. }
  337. /**
  338. * 生成u9的标准收获单
  339. * 会造成库存变动
  340. * 这个也是有源的是采购单 不过估计用不上 先不写
  341. */
  342. public function bzshCreate($params,$token){
  343. }
  344. /**
  345. * 生成成品入库单
  346. */
  347. public function cprkCreate($params,$token){
  348. $list = $this->cprkDataTrans($params);
  349. $url = '/U9C/webapi/RcvRptDoc/Create';
  350. $url = $this->base_url.$url;
  351. $header[] = "Content-Type: application/json";
  352. $header[] = "Token: ".$token;
  353. $res = $this->sendReq($url,$header,json_encode($list));
  354. return array($res,$list);
  355. }
  356. /**
  357. * 成品入库单提交
  358. */
  359. public function cprkApprove($params,$token){
  360. $url = '/U9C/webapi/RcvRptDoc/Approve';
  361. $url = $this->base_url.$url;
  362. $header[] = "Content-Type: application/json";
  363. $header[] = "Token: ".$token;
  364. $res = $this->sendReq($url,$header,json_encode($params));
  365. return array($res,$params);
  366. }
  367. /**
  368. * 成品入库查询
  369. */
  370. public function cprkCx($params,$token){
  371. $url = '/U9C/webapi/RcvRptDoc/Query';
  372. $url = $this->base_url.$url;
  373. $header[] = "Content-Type: application/json";
  374. $header[] = "Token: ".$token;
  375. $res = $this->sendReq($url,$header,json_encode($params));
  376. return array($res,$params);
  377. }
  378. /**
  379. * 成品入库单审核
  380. */
  381. //根据erp的单号查询调出单是够存在
  382. public function xcDcdByOtherId($dcd_no,$token){
  383. $list["SqlString"] = "select DescFlexField_PubDescSeg4,DocNo from InvDoc_TransferOut where DescFlexField_PubDescSeg4 = '".$dcd_no."'";
  384. $url = '/U9C/webapi/QueryCommon/QueryInfoBySql';
  385. $url = $this->base_url.$url;
  386. $header[] = "Content-Type: application/json";
  387. $header[] = "Token: ".$token;
  388. $res = $this->sendReq($url,$header,json_encode($list));
  389. return array($res,$list);
  390. }
  391. /**
  392. * 调出单的二次验证
  393. * 避免因为其他组织使用相同的erp单号导致的冲突 不能创建成品库的数据
  394. */
  395. public function xcDcdByOtherIdCheck($dcd_no,$token){
  396. $list["SqlString"] = "select a.DescFlexField_PubDescSeg4,a.DocNo,b.TransOutwh ,wh_out.code from InvDoc_TransferOut as a left join InvDoc_TransOutLine as b on a.id = b.TransferOut left join CBO_Wh wh_out on b.TransOutWh=wh_out.id where a.DescFlexField_PubDescSeg4 = '".$dcd_no."' ";
  397. $url = '/U9C/webapi/QueryCommon/QueryInfoBySql';
  398. $url = $this->base_url.$url;
  399. $header[] = "Content-Type: application/json";
  400. $header[] = "Token: ".$token;
  401. $res = $this->sendReq($url,$header,json_encode($list));
  402. return array($res,$list);
  403. }
  404. /**
  405. * 查询料品
  406. */
  407. public function cxLp($params,$token){
  408. $list = [];
  409. foreach($params as $k=>$v){
  410. $list[] =[
  411. "ItemMaster"=>[
  412. "Code"=>$v['jm']
  413. ]
  414. ];
  415. }
  416. $url = '/U9C/webapi/ItemMaster/Query';
  417. $url = $this->base_url.$url;
  418. $header[] = "Content-Type: application/json";
  419. $header[] = "Token: ".$token;
  420. $res = $this->sendReq($url,$header,json_encode($list));
  421. return array($res,$list);
  422. }
  423. /**
  424. * 查询料品
  425. */
  426. public function cxLpByJm($jm,$token){
  427. $list = [];
  428. $list[] =[
  429. "ItemMaster"=>[
  430. "Code"=>$jm
  431. ]
  432. ];
  433. $url = '/U9C/webapi/ItemMaster/Query';
  434. $url = $this->base_url.$url;
  435. $header[] = "Content-Type: application/json";
  436. $header[] = "Token: ".$token;
  437. $res = $this->sendReq($url,$header,json_encode($list));
  438. return $res;
  439. }
  440. /**
  441. * 创建料品
  442. */
  443. public function cjLp($params,$token){
  444. $list = $this->cjlpDataTrans($params);
  445. $url = '/U9C/webapi/ItemMaster/Create';
  446. $url = $this->base_url.$url;
  447. $header[] = "Content-Type: application/json";
  448. $header[] = "Token: ".$token;
  449. $res = $this->sendReq($url,$header,json_encode($list));
  450. $this->logic_ding->sendToDing("创建料品监听".json_encode($params,JSON_UNESCAPED_UNICODE)."||".json_encode($res,JSON_UNESCAPED_UNICODE)."||".$url);
  451. return array($res,$list);
  452. }
  453. /**
  454. * 同步通知
  455. */
  456. public function tbLp($params,$token){
  457. $list = [];
  458. foreach($params['list'] as $k=>$v){
  459. $list[] = [
  460. "EntityFullName"=>'UFIDA.U9.CBO.SCM.Item.ItemMaster',//实体全名
  461. "EntityCode"=>$v['jm'],
  462. "FromOrgCode"=>$params['owner_code'],//创建组织编码
  463. "ToOrgCodeList"=>[140],//要同步的组织
  464. "OtherID"=>'',
  465. "ContextDTO"=>[
  466. "EntCode"=>$params['ztcode'],//企业编码
  467. "OrgCode"=>$params['owner_code'],//组织编码
  468. "UserCode"=>'xk',//用户编码
  469. "UserPwd"=>'',//用户密码
  470. ]
  471. ];
  472. }
  473. $url = '/U9C/webapi/ControlObjSend/ControlObjSend';
  474. $url = $this->base_url.$url;
  475. $header[] = "Content-Type: application/json";
  476. $header[] = "Token: ".$token;
  477. $res = $this->sendReq($url,$header,json_encode($list));
  478. return array($res,$list);
  479. }
  480. //由于逻辑修改造成 需要查询调出单是审核完毕
  481. public function xdlsCxDcd($dcd_no,$token){
  482. $list["SqlString"] = "select a.DocNo,a.Status,a.DescFlexField_PubDescSeg2,a.DescFlexField_PubDescSeg4,a.DescFlexField_PubDescSeg5,b.ItemInfo_ItemCode,b.CostUOMQty,b.CostPrice,b.ItemInfo_ItemName from InvDoc_TransferOut as a left join InvDoc_TransOutLine as b on a.id = b.TransferOut where a.Status = 2 and a.DocNo = '".$dcd_no."'";
  483. //$list["SqlString"] = "select a.*,b.* from InvDoc_TransferOut as a left join InvDoc_TransOutLine as b on a.id = b.TransferOut where a.Status = 2 and a.DocNo = '".$dcd_no."'";
  484. $url = '/U9C/webapi/QueryCommon/QueryInfoBySql';
  485. $url = $this->base_url.$url;
  486. $header[] = "Content-Type: application/json";
  487. $header[] = "Token: ".$token;
  488. $res = $this->sendReq($url,$header,json_encode($list));
  489. return array($res,$list);
  490. }
  491. public function sendReq($url,$header,$list){
  492. $ch = curl_init();
  493. curl_setopt($ch, CURLOPT_URL, $url);
  494. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  495. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  496. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  497. curl_setopt($ch, CURLOPT_POST, 1);
  498. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  499. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  500. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  501. $res = curl_exec($ch);
  502. $res = json_decode($res,true);
  503. return $res;
  504. }
  505. //调出单的数据转化
  506. public function dcDataTrans($params){
  507. $trans_out_lines = [];
  508. foreach($params['list'] as $k=>$v){
  509. $trans_out_lines[] = [
  510. "ItemInfo" =>[
  511. "ItemCode"=>$v['jm'],//用友的简码
  512. ],
  513. "TransOutWh_Code"=>$params['dcckbm'],//调出仓库编码
  514. "StoreUOM_Code"=>"条",//调出库存单位Code 如条
  515. "StoreUOMQty"=>$v['dcsl'],//调出数量
  516. "StorageType"=>4,//存储类型:待检;1:在检;2:不合格;3:报废;4:可用;5:冻结;6:退回;7:待返工
  517. "LotInfo_Code"=>"",//批号Code 不知道有啥用 暂时留空吧
  518. "TransOutOwnerOrg_Code"=>$params['owner_code'],//货主组织Code
  519. "TransOutSubLines"=>[
  520. [
  521. 'TransInWh_Code'=>$params['drckbm']."",//调入仓库编码
  522. 'StorageType'=>4,//存储类型:待检;1:在检;2:不合格;3:报废;4:可用;5:冻结;6:退回;7:待返工
  523. 'TransInOrg_Code'=>$params['drzz_code']."",//调入组织Code
  524. 'TransOutOwnerOrg_Code'=>$params['owner_code']."",//货主组织Code
  525. 'StoreUOMQty'=>$v['dcsl'],
  526. ]
  527. ],
  528. "TransOutBins"=>[
  529. [
  530. 'BinInfo_Code'=>'',//库位Code
  531. 'StoreUOMQty'=>$v['dcsl']// 分配数量
  532. ]
  533. ]
  534. ,"DescFlexField"=>[
  535. "PubDescSeg2"=>$params['yyid'],//来源店铺 这种需要在店铺表中有
  536. "PubDescSeg4"=>$params['number'],//订单编码
  537. "PubDescSeg5"=>$params['shipremarks'],//订单的备注
  538. ],
  539. ];
  540. }
  541. $data = [];
  542. $data[] = [
  543. "OtherID"=>$params['number'],//第三方数据唯一性标识,此字段需要返回
  544. "TransOutDocType_Code"=> $params['TransOutDocType_Code'],//单据类型在u9中设置的 详情到u9界面查看 TransOut001 组织间调拨 TransOut002 仓库转储 TransOut004 委外加工发料 TransOut005 委外加工退料
  545. "BusinessDate"=>date("Y-m-d",$params['time']),//日期
  546. "TransferDirection"=>$params['TransferDirection'],//调拨方向 0:普通;1:退货
  547. "TransOutLines"=>$trans_out_lines,
  548. "DescFlexField"=>[
  549. "PubDescSeg2"=>$params['yyid'],//来源店铺 这种需要在店铺表中有
  550. "PubDescSeg4"=>$params['number'],//订单编码
  551. "PubDescSeg5"=>$params['shipremarks'],//订单的备注
  552. ],
  553. ];
  554. return $data;
  555. }
  556. //销售单的数据转化
  557. public function xsdDataTrans($params){
  558. $so_lines = [];
  559. foreach($params['list'] as $k=>$v){
  560. $so_lines[] = [
  561. 'TU'=>"条",//销售单位编码
  562. 'ItemCode'=>$v['jm'],//用友的编码
  563. 'PU'=>'条',//计价单位编码
  564. "ShipTogetherFlag"=>-1,//成套收发货标志
  565. 'DocLineNo'=>$k+1,
  566. 'CustomerItemNo'=>'',//客户料号
  567. 'CustomerItemName'=>'',//客户品名
  568. 'FinallyPriceTC'=>$v['final_price'],//最终价 单价
  569. 'PubDescSeg10'=>'',
  570. 'SOShiplineDTOList'=>[ //销售订单计划行
  571. [
  572. 'IsMRPRequire', //MRP需求
  573. 'DemandType',//需求分类
  574. 'RequireDate'=>date('m/d/Y H:i:s',$params['time']),
  575. ]
  576. ],
  577. 'RecTerm'=>'',//目前找不到了
  578. 'FreeType'=>($v['final_price'] < 0.01)?0: -1,//免费品类型 (无默认值请传-1;赠品请传0;备损品请传1) 徐凯设定的是 如果钱小于0.01 那么就传0 其他的传递-1
  579. 'UsableQtyOfInv'=>0,//文档中未查询到
  580. 'PubDescSeg3'=>'',
  581. 'PubDescSeg4'=>'',
  582. 'PriceList'=>'',//价表编码 (该属性可为空,且无默认值)
  583. 'TaxMoneyTC'=>0,//税额 (该属性可为空,且无默认值)
  584. 'TaxSchedule'=>'YZ05',//税组合编码 (该属性可为空,且无默认值) 不知道这个是啥 徐凯的老代码是这么写的
  585. 'DescFlexField'=>[
  586. 'PubDescSeg3'=>'',
  587. ],
  588. 'OrderByQtyTU'=>$v['dcsl'],//销售数量 (该属性可为空,且无默认值)
  589. 'OrderByQtyPU'=>$v['dcsl'],//计价数量 (该属性可为空,且无默认值)
  590. 'OrderPriceTC'=>'',//定价 (该属性可为空,且无默认值)
  591. 'Memo'=>'',//备注
  592. ];
  593. }
  594. $data = [];
  595. $data[] = [
  596. "OrderBy"=>$params['yyid'],//用友的商户的id
  597. "OtherID"=>$params['number'],//第三方传入ID
  598. "SaleDepartment"=>"",//部门编码 可为空
  599. "DocumentType"=>"SO1",//单据类型编码 标准销售单 So1是默认值
  600. "DocNo"=>'',//单据类型编码
  601. "AC"=>"C001",//人民币
  602. "TC"=>"C001",//人民币
  603. "ShipToSite"=>"",//收货位置编码
  604. "PubDescSeg2"=>"",
  605. "SOSrcType"=>0,
  606. "Seller"=>"",//业务员编码 可为空
  607. "ConfirmTerm"=>"",//但是现有文档没有
  608. "Memo"=>$params['number'],//备注
  609. "ShipRule"=>"",//但是现有文档没有
  610. "SOLineDTOList"=>$so_lines,
  611. ];
  612. return $data;
  613. }
  614. //销售单的数据转化 工厂对外的销售单
  615. public function xsdDataTransGC($params){
  616. $so_lines = [];
  617. foreach($params['list'] as $k=>$v){
  618. $so_lines[] = [
  619. 'TU'=>"条",//销售单位编码
  620. 'ItemCode'=>$v['jm'],//用友的编码
  621. 'PU'=>'条',//计价单位编码
  622. "ShipTogetherFlag"=>-1,//成套收发货标志
  623. 'DocLineNo'=>$k+1,
  624. 'CustomerItemNo'=>'',//客户料号
  625. 'CustomerItemName'=>'',//客户品名
  626. //'FinallyPriceTC'=>$v['final_price'],//最终价 单价
  627. 'PubDescSeg10'=>'',
  628. 'PriceSource'=>0,//从价目表中 获取价格
  629. 'SOShiplineDTOList'=>[ //销售订单计划行
  630. [
  631. 'IsMRPRequire', //MRP需求
  632. 'DemandType',//需求分类
  633. 'RequireDate'=>date('m/d/Y H:i:s',$params['time']),
  634. ]
  635. ],
  636. 'RecTerm'=>'',//目前找不到了
  637. 'FreeType'=>($v['final_price'] < 0.01)?0: -1,//免费品类型 (无默认值请传-1;赠品请传0;备损品请传1) 徐凯设定的是 如果钱小于0.01 那么就传0 其他的传递-1
  638. 'UsableQtyOfInv'=>0,//文档中未查询到
  639. 'PubDescSeg3'=>'',
  640. 'PubDescSeg4'=>'',
  641. 'PriceList'=>'',//价表编码 (该属性可为空,且无默认值)
  642. 'TaxMoneyTC'=>0,//税额 (该属性可为空,且无默认值)
  643. 'TaxSchedule'=>'YZ05',//税组合编码 (该属性可为空,且无默认值) 不知道这个是啥 徐凯的老代码是这么写的
  644. 'DescFlexField'=>[
  645. 'PubDescSeg3'=>'',
  646. ],
  647. 'OrderByQtyTU'=>$v['dcsl'],//销售数量 (该属性可为空,且无默认值)
  648. 'OrderByQtyPU'=>$v['dcsl'],//计价数量 (该属性可为空,且无默认值)
  649. 'OrderPriceTC'=>'',//定价 (该属性可为空,且无默认值)
  650. 'Memo'=>'',//备注
  651. ];
  652. }
  653. $data = [];
  654. $data[] = [
  655. "OrderBy"=>$params['yyid'],//用友的商户的id
  656. "OtherID"=>$params['number'],//第三方传入ID
  657. "SaleDepartment"=>"",//部门编码 可为空
  658. "DocumentType"=>"SO1",//单据类型编码 标准销售单 So1是默认值
  659. "DocNo"=>'',//单据类型编码
  660. "AC"=>"C001",//人民币
  661. "TC"=>"C001",//人民币
  662. "ShipToSite"=>"",//收货位置编码
  663. "PubDescSeg2"=>"",
  664. "SOSrcType"=>0,
  665. "Seller"=>"",//业务员编码 可为空
  666. "ConfirmTerm"=>"",//但是现有文档没有
  667. "Memo"=>$params['number'],//备注
  668. "ShipRule"=>"",//但是现有文档没有
  669. "SOLineDTOList"=>$so_lines,
  670. ];
  671. return $data;
  672. }
  673. public function xsdTwoDataTrans($params){
  674. $so_lines = [];
  675. foreach($params['list'] as $k=>$v){
  676. $so_lines[] = [
  677. 'TU'=>"条",//销售单位编码
  678. 'ItemCode'=>$v['jm'],//用友的编码
  679. 'PU'=>'条',//计价单位编码
  680. "ShipTogetherFlag"=>-1,//成套收发货标志
  681. 'DocLineNo'=>$k+1,
  682. 'CustomerItemNo'=>'',//客户料号
  683. 'CustomerItemName'=>'',//客户品名
  684. 'FinallyPriceTC'=>$v['final_price'],//最终价 单价
  685. 'PubDescSeg10'=>'',
  686. 'SOShiplineDTOList'=>[ //销售订单计划行
  687. [
  688. 'IsMRPRequire', //MRP需求
  689. 'DemandType',//需求分类
  690. 'RequireDate'=>date('m/d/Y H:i:s',$params['time']),
  691. ]
  692. ],
  693. 'RecTerm'=>'',//目前找不到了
  694. 'FreeType'=>($v['final_price'] < 0.01)?0: -1,//免费品类型 (无默认值请传-1;赠品请传0;备损品请传1) 徐凯设定的是 如果钱小于0.01 那么就传0 其他的传递-1
  695. 'UsableQtyOfInv'=>0,//文档中未查询到
  696. 'PubDescSeg3'=>'',
  697. 'PubDescSeg4'=>'',
  698. 'PriceList'=>'',//价表编码 (该属性可为空,且无默认值)
  699. 'TaxMoneyTC'=>0,//税额 (该属性可为空,且无默认值)
  700. 'TaxSchedule'=>'YZ05',//税组合编码 (该属性可为空,且无默认值) 不知道这个是啥 徐凯的老代码是这么写的
  701. 'DescFlexField'=>[
  702. 'PubDescSeg3'=>'',
  703. ],
  704. 'OrderByQtyTU'=>$v['dcsl'],//销售数量 (该属性可为空,且无默认值)
  705. 'OrderByQtyPU'=>$v['dcsl'],//计价数量 (该属性可为空,且无默认值)
  706. 'OrderPriceTC'=>'',//定价 (该属性可为空,且无默认值)
  707. 'Memo'=>'',//备注
  708. ];
  709. }
  710. $data = [];
  711. $data[] = [
  712. "OrderBy"=>$params['yyid'],//用友的商户的id
  713. "OtherID"=>$params['number'],//第三方传入ID
  714. "SaleDepartment"=>"",//部门编码 可为空
  715. "DocumentType"=>"SO1",//单据类型编码 标准销售单 So1是默认值
  716. "DocNo"=>'',//单据类型编码
  717. "AC"=>"C009",//美金
  718. "TC"=>"C009",//美金
  719. "ShipToSite"=>"",//收货位置编码
  720. "PubDescSeg2"=>"",
  721. "SOSrcType"=>0,
  722. "Seller"=>"",//业务员编码 可为空
  723. "ConfirmTerm"=>"",//但是现有文档没有
  724. "Memo"=>$params['number'],//备注
  725. "ShipRule"=>"",//但是现有文档没有
  726. "SOLineDTOList"=>$so_lines,
  727. ];
  728. return $data;
  729. }
  730. public function cgdDataTrans($params){
  731. $po_lines = [];
  732. foreach($params['list'] as $k=>$v){
  733. $po_lines[] = [
  734. //"POLineID"=>0,//采购订单行ID
  735. 'ItemInfo'=>[
  736. 'm_code'=>$v['jm'],//用友料号
  737. ],
  738. "ReqQtyTU"=>$v['dcsl'],//需求数量
  739. "ReqQtyTBU"=>0,//确认数量
  740. "SupplierConfirmQtyTU"=>$v['dcsl'],//确认数量
  741. "SupplierConfirmQtyTBU"=>0,//确认数量
  742. "FinallyPriceTC"=>$v['final_price'],//最终价格
  743. "IsPresent"=>false,//赠品
  744. ];
  745. }
  746. $data = [];
  747. $data[] = [
  748. 'DocNo'=>"",
  749. "DocumentType"=>'PO01',//PO01 标准采购默认值
  750. 'BizType'=>0,//业务类型:AR_Invoice 销售发票 0 (默认值),PM005 标准采购 316 ,PM055 全程委外采购 326 ,PM050 工序外协采购 325
  751. "BusinessDate"=>date("Y-m-d H:i:s"),
  752. 'OtherID'=>$params['number'],
  753. 'DescFlexField'=>(object)[
  754. ],
  755. 'TC'=>'C001',
  756. 'AC'=>'C001',
  757. "Memo"=>$params['number'],
  758. 'Supplier'=>[
  759. 'Code'=>$params['gys'],//供应商编码 到时间找下
  760. ],
  761. 'IsPriceIncludeTax'=>false,
  762. "POLineDTOList"=>$po_lines
  763. ];
  764. return $data;
  765. }
  766. public function yybzchDataTrans($params){
  767. $data = [];
  768. foreach($params['list'] as $k=>$v ){
  769. $data[] = [
  770. "SrcDocType"=>1,//售订单 Value:1 出货计划 Value:2 销售合同 Value:3 预出货单 Value:4
  771. "SrcDocNo"=>$params['xs_no'],//来源单号
  772. "SrcDocLineNo"=>$v['doclineno'],
  773. "SrcDocSubLineNo"=>$v['docsublineno'],
  774. //"WH"=>'',//存储地点ID 找不到id 那就找个WHcode
  775. 'WHCode'=>$params['drckbm'],//存储地点code 这里的参数为啥这么诡异 是因为 不想在很设置参数了 都按照调出的写法组件数据了
  776. "CurShipQty1"=>$v['dcsl'],//本次出货量
  777. "SOIsConsign"=>false,// 是否补货
  778. "OptionalSplitTerm"=>[],
  779. "DescFlexField"=>(object)[],
  780. "LineDescFlexField"=>(object)[],
  781. //"ShipDate",//出货单日期(该属性可为空,且无默认值)
  782. //"ShipConfirmDate"//出货确认日期(该属性可为空,且无默认值)
  783. "DocStatus"=>0,//单据状态:0开立;1审核中;2已审核,可用值:0,1,2,3
  784. ];
  785. }
  786. return $data;
  787. }
  788. //销售单的数据转化
  789. public function cjlpDataTrans($params){
  790. $list = [];
  791. foreach($params['list'] as $k=>$v){
  792. $list[] = [
  793. "Code"=>$v['jm'],//料号
  794. "Code1"=>"",//参考料号1
  795. "Name"=>$v['zh'],//品名
  796. "MainItemCategory"=>[
  797. "Code"=>$v['bm']
  798. ],
  799. "Org"=>[
  800. "Code"=>$params['ztcode']
  801. ],
  802. "OtherID"=>1,
  803. "PurchaseInfo"=>[
  804. "BudgetControlType"=>-1,//预算控制方式
  805. "PriceSource"=>2,//取价来源
  806. "InquireRule"=>-1,//询价策略
  807. 'InquireFixedPeriod'=>0,//间隔期
  808. "StatisticPeriod"=>-1,//配额统计期间
  809. "IsPUTradePathModify"=>true,//采购贸易路径可改
  810. "IsPURtnTradePathModify"=>true,//采购退货贸易路径可改
  811. ],
  812. "InventoryUOM"=>[
  813. "Code"=>'条'
  814. ],
  815. "InventorySecondUOM"=>[
  816. "Code"=>''
  817. ],
  818. "IsDualUOM"=>false,
  819. "InventoryInfo"=>[
  820. "InventoryPlanningMethod"=>4,//规划方法
  821. "InventoryPlanTime"=>-1,//
  822. "TurnOverRate"=>1,//
  823. "ReserveMode"=>-1,//
  824. "SupplyMethod"=>-1,//
  825. ],
  826. "DescFlexField"=>[
  827. "PrivateDescSeg1"=>"01",
  828. "PubDescSeg5"=>"01"
  829. ],
  830. "Description"=>$v['title'],
  831. "ItemForm"=>2001,//料品形态
  832. "ItemFormAttribute"=>10,//料品形态属性
  833. "IsInventoryEnable"=>true,//可库存交易
  834. "IsPurchaseEnable"=>true,//可采购
  835. "IsSalesEnable"=>true,//可采购
  836. "IsBuildEnable"=>true,//可生产
  837. "IsOutsideOperationEnable"=>true,//可委外
  838. "IsMRPEnable"=>true,//可MRP
  839. "IsBOMEnable"=>true,//可BOM
  840. "IsCostCalByGrade"=>false,//等级影响成本
  841. "IsCostCalByPotency"=>false,//成分影响成本
  842. "IsGradeControl"=>false,//等级控制
  843. "StandardGrade"=>-1,//标准等级
  844. "StartGrade"=>-1,//起始等级
  845. "EndGrade"=>-1,//结束等级
  846. "IsPotencyControl"=>false,//成分控制
  847. "StandardPotency"=>-1,//标准成分
  848. "StartPotency"=>-1,//起始成分
  849. "EndPotency"=>-1,// 结束成分
  850. ];
  851. }
  852. return $list;
  853. }
  854. public function cprkDataTrans($params){
  855. $list = [];
  856. foreach($params['list'] as $k=>$v){
  857. $tmp = [
  858. "MOKey"=>[
  859. "OtherID"=>"",
  860. "ID"=>0,
  861. "DocNo"=>$params['rkcode'],//需要填写入库 rkcode 传递
  862. "OrgID"=>0,
  863. "IsSuccess"=>1,
  864. "ErrorInfo"=>"",
  865. "CUD"=>0,
  866. ],
  867. "Wh"=>[
  868. "Code"=>$params['rev_wh_code'],//存储地点信息 传递
  869. ],
  870. "LineNum"=>$k,//行号
  871. "StorageType"=>4,//
  872. "Grade"=>0,//等级
  873. "Element"=>0,
  874. "CompleteQty"=>$v['sl'],//申报数量(生产单位)
  875. "CompleteQtyByWhUOM"=>$v['sl'],//申报数量(库存单位)
  876. "CompleteQtyByCostUOM"=>$v['sl'],//申报数量(成本单位)
  877. "CUD"=>0,
  878. "OwnerOrg"=>[
  879. "Code"=>$params['org_code'],//货主组织编码
  880. ],
  881. "OutputType"=>0,//产出类型
  882. "Item"=>[
  883. "Code"=>$v['jm'],//编码 其实是用友的料号
  884. ],
  885. "ScrapQty"=>0,//报废数量
  886. "ScrapQtyByCostUOM"=>0,//报废数量(成本单位)
  887. "PUToPBURate"=>0,//生产主-生产副
  888. "CUToCBURate"=>0,//成本主-成本副
  889. "PBUToCBURate"=>0,//生产-成本
  890. "SourceRcvRptLine"=>[ //来源入库单行
  891. "RcvRptDocDTO"=>[ //入库单DTO
  892. "ID"=>0, //唯一标示
  893. "DocType"=>[ //单据类型
  894. 'Code'=>0,
  895. ],
  896. "BusinessDate"=>'',//业务日期
  897. "DocNo"=>"",//单号
  898. "SourceDoc"=>[ //来源单据
  899. "MOSrcDocType"=>0,//来源单据类型
  900. "SrcDocOrg"=>0,//
  901. "SrcDoc"=>[ //来源单据
  902. "ID"=>$params['rkid'], //单据ID 徐凯传递的是$data['rkid']
  903. "EntityType"=>'UFIDA.U9.MO.MO.MO',//单据类型
  904. ],
  905. "SrcDocVer"=>'',//单据版本
  906. "SrcDocLine"=>[
  907. "ID"=>0,
  908. "EntityType"=>'',
  909. ],
  910. "SrcDocSubline"=>[
  911. "ID"=>0,
  912. "EntityType"=>'',
  913. ],
  914. "SrcDocNo"=>$params['rkid'],//单据号 徐凯传递了$data['rkid']
  915. "SrcDocLineNo"=>'',//行号
  916. "SrcDocSublineNo"=>10+$k,
  917. "SrcDocID"=>$params['rkid'],//来源单据ID 徐凯传递了$data['rkid']
  918. "SrcDocLineID"=>0,
  919. "SrcDocType"=>'',
  920. ],
  921. "DocDate"=>date("Y-m-d",time()),
  922. "RcvOrg"=>[ //入库组织
  923. "Code"=>$params['rec_code'],//入库组织编码 需填写
  924. ],
  925. "Org"=>[
  926. "Code"=>$params['org_code'],//组织编码 需填写
  927. ],
  928. "Direction"=>0,
  929. "DocState"=>0,
  930. "RcvDep"=>[
  931. "ID"=>0,
  932. "Code"=>'',
  933. "Name"=>''
  934. ],
  935. "RcvPerson"=>[
  936. "ID"=>0,
  937. "Code"=>'',
  938. "Name"=>''
  939. ],
  940. "OtherID"=>"",
  941. ],
  942. "ProductUOM"=>[
  943. "Code"=>'条',
  944. ],
  945. "ProductBaseUOM"=>[
  946. "Code"=>'条',
  947. ],
  948. "StoreUOM"=>[
  949. "Code"=>'条',
  950. ],
  951. "StoreBaseUOM"=>[
  952. "Code"=>'条',
  953. ],
  954. "CoUOM"=>[
  955. "Code"=>'条',
  956. ],
  957. "CostBaseUOM"=>[
  958. "Code"=>'条',
  959. ],
  960. "OperationState"=>0,
  961. "OutputType"=>0,
  962. "Item"=>[
  963. "Code"=>$v['jm'],//料号 徐凯传递的是$data['jm']
  964. ],
  965. "OwnerOrg"=>[
  966. "Code"=>$params['org_code'],//货主组织编码 需填写
  967. ],
  968. "PUToPBURate"=>0,
  969. "SUToSBURate"=>0,
  970. "PBUToSBURate"=>0,
  971. "CUToCBURate"=>0,
  972. "PBUToCBURate"=>0,
  973. "Grade"=>0,
  974. "Element"=>0,
  975. "Wh"=>[
  976. "Code"=>$params['rev_wh_code'],//存储地点信息 传递
  977. ],
  978. "StorageType"=>4,
  979. "RcvValiddate"=>0,
  980. "RcvQtyByProductUOM"=>0,
  981. "RcvQtyByWhUOM"=>0,
  982. "RcvQtyByCostUom"=>0,
  983. "RcvOrg"=>[ //入库组织
  984. "Code"=>001,//编码
  985. ],
  986. "PerformingOrg"=>[ //执行组织
  987. "Code"=>001 //编码
  988. ],
  989. "CUD"=>0,
  990. "LineNum"=>0,
  991. "MO"=>[ //生产订单
  992. "Code"=>$params['rkcode'],//徐凯写了 rkcode
  993. ],
  994. "ID"=>0,
  995. ]
  996. ];
  997. $list[] = $tmp;
  998. }
  999. $res = [
  1000. "DocNo"=>"",//
  1001. "CompleteList"=>$list,
  1002. "DescFlexField"=>[
  1003. //"PubDescSeg2"=>$params['yyid'],//kh
  1004. "PubDescSeg4"=>$params['number'],//订单编码
  1005. "PubDescSeg5"=>$params['shipremarks'],//备注
  1006. ],
  1007. "DocType"=>[
  1008. "Code"=>0,
  1009. ],
  1010. "BusinessDate"=>(date("Y-m-d",time())),
  1011. "OtherID"=>'',//订单编码
  1012. "Direction"=>0,
  1013. "IsOffLine"=>1, //是否撤线报
  1014. "DocState"=>0,
  1015. "Remark"=>time(),
  1016. "RcvPerson"=>[
  1017. "Code"=>"ERP"
  1018. ]
  1019. ];
  1020. if(!empty($params['yyid'])){
  1021. $res['DescFlexField']['PubDescSeg2'] = $params['yyid'];//备注-客户
  1022. }
  1023. return [$res];
  1024. }
  1025. public function scdDataTrans($params){
  1026. $list = [];
  1027. foreach($params['list'] as $k=>$v){
  1028. $info = [
  1029. "OtherID"=>"",
  1030. "Org"=>[
  1031. "Code"=>$params['org_code']//生产组织编码
  1032. ],
  1033. "ItemMaster"=>[
  1034. "Code"=>$v['jm'],//料号
  1035. ],
  1036. "DocType"=>[
  1037. "Code"=>$params['djhlx']//单据类型
  1038. ],
  1039. "Department"=>[
  1040. "Code"=>$params['scbm_code']//生产部门编码
  1041. ],
  1042. "ExpandLevel"=>0, //展开阶数
  1043. "AlternateType"=>0,//生产目的
  1044. "RoutingAlternate"=>0,//工艺生产目的
  1045. "RoutingEffeDate"=>'',//工艺有效日期
  1046. "ProductQty"=>$v['sl'],
  1047. "ProductUOM"=>[
  1048. "Code"=>'条'
  1049. ],
  1050. "StartDate"=>date('Y-m-d',$params['time']),//计划开工日期
  1051. "CompleteDate"=>date('Y-m-d',$params['time']),//计划完工日期
  1052. "MOSourceDocType"=>0,//来源单据类型
  1053. "OwnerOrg"=>[
  1054. "Code"=>$params['owner_org_code']//货主组织编码
  1055. ],
  1056. "SCVWh"=>[
  1057. "Code"=>$v['drck']//完工存储地点编码
  1058. ],
  1059. "DemandCode"=>-1,//需求分类
  1060. "IsFirmed"=>false,//锁定标志
  1061. "IsCapacityLimit"=>false,//有限产能
  1062. "Priority"=>0,// 优先级
  1063. "CUD"=>0,//增删改类型
  1064. "BOMType"=>0,//BOM类型
  1065. "Description"=>$params['title'],//备注
  1066. "MRPQty"=>0,//MRP数量
  1067. "MOID"=>0,//生产订单ID
  1068. "PBUToSBURate"=>0,//生产-库存
  1069. "PBUToCBURate"=>0,//生产-成本
  1070. "DescFlexField"=>[
  1071. "PubDescSeg4"=>$params['title'],//erp单号
  1072. "PubDescSeg5"=>$params['shipremarks'],//erp备注
  1073. ]
  1074. ];
  1075. if(!empty($params['yyid'])){
  1076. $info['DescFlexField']['PubDescSeg2'] = $params['yyid'];//备注-客户
  1077. }
  1078. $list[] = $info;
  1079. }
  1080. return $list;
  1081. }
  1082. }