Model_apiyyv1.php 35 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120
  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 cjLp($params,$token){
  427. $list = $this->cjlpDataTrans($params);
  428. $url = '/U9C/webapi/ItemMaster/Create';
  429. $url = $this->base_url.$url;
  430. $header[] = "Content-Type: application/json";
  431. $header[] = "Token: ".$token;
  432. $res = $this->sendReq($url,$header,json_encode($list));
  433. $this->logic_ding->sendToDing("创建料品监听".json_encode($params,JSON_UNESCAPED_UNICODE)."||".json_encode($res,JSON_UNESCAPED_UNICODE)."||".$url);
  434. return array($res,$list);
  435. }
  436. /**
  437. * 同步通知
  438. */
  439. public function tbLp($params,$token){
  440. $list = [];
  441. foreach($params['list'] as $k=>$v){
  442. $list[] = [
  443. "EntityFullName"=>'UFIDA.U9.CBO.SCM.Item.ItemMaster',//实体全名
  444. "EntityCode"=>$v['jm'],
  445. "FromOrgCode"=>$params['owner_code'],//创建组织编码
  446. "ToOrgCodeList"=>[140],//要同步的组织
  447. "OtherID"=>'',
  448. "ContextDTO"=>[
  449. "EntCode"=>$params['ztcode'],//企业编码
  450. "OrgCode"=>$params['owner_code'],//组织编码
  451. "UserCode"=>'xk',//用户编码
  452. "UserPwd"=>'',//用户密码
  453. ]
  454. ];
  455. }
  456. $url = '/U9C/webapi/ControlObjSend/ControlObjSend';
  457. $url = $this->base_url.$url;
  458. $header[] = "Content-Type: application/json";
  459. $header[] = "Token: ".$token;
  460. $res = $this->sendReq($url,$header,json_encode($list));
  461. return array($res,$list);
  462. }
  463. //由于逻辑修改造成 需要查询调出单是审核完毕
  464. public function xdlsCxDcd($dcd_no,$token){
  465. $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."'";
  466. //$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."'";
  467. $url = '/U9C/webapi/QueryCommon/QueryInfoBySql';
  468. $url = $this->base_url.$url;
  469. $header[] = "Content-Type: application/json";
  470. $header[] = "Token: ".$token;
  471. $res = $this->sendReq($url,$header,json_encode($list));
  472. return array($res,$list);
  473. }
  474. public function sendReq($url,$header,$list){
  475. $ch = curl_init();
  476. curl_setopt($ch, CURLOPT_URL, $url);
  477. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  478. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  479. curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
  480. curl_setopt($ch, CURLOPT_POST, 1);
  481. curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
  482. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  483. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
  484. $res = curl_exec($ch);
  485. $res = json_decode($res,true);
  486. return $res;
  487. }
  488. //调出单的数据转化
  489. public function dcDataTrans($params){
  490. $trans_out_lines = [];
  491. foreach($params['list'] as $k=>$v){
  492. $trans_out_lines[] = [
  493. "ItemInfo" =>[
  494. "ItemCode"=>$v['jm'],//用友的简码
  495. ],
  496. "TransOutWh_Code"=>$params['dcckbm'],//调出仓库编码
  497. "StoreUOM_Code"=>"条",//调出库存单位Code 如条
  498. "StoreUOMQty"=>$v['dcsl'],//调出数量
  499. "StorageType"=>4,//存储类型:待检;1:在检;2:不合格;3:报废;4:可用;5:冻结;6:退回;7:待返工
  500. "LotInfo_Code"=>"",//批号Code 不知道有啥用 暂时留空吧
  501. "TransOutOwnerOrg_Code"=>$params['owner_code'],//货主组织Code
  502. "TransOutSubLines"=>[
  503. [
  504. 'TransInWh_Code'=>$params['drckbm']."",//调入仓库编码
  505. 'StorageType'=>4,//存储类型:待检;1:在检;2:不合格;3:报废;4:可用;5:冻结;6:退回;7:待返工
  506. 'TransInOrg_Code'=>$params['drzz_code']."",//调入组织Code
  507. 'TransOutOwnerOrg_Code'=>$params['owner_code']."",//货主组织Code
  508. 'StoreUOMQty'=>$v['dcsl'],
  509. ]
  510. ],
  511. "TransOutBins"=>[
  512. [
  513. 'BinInfo_Code'=>'',//库位Code
  514. 'StoreUOMQty'=>$v['dcsl']// 分配数量
  515. ]
  516. ]
  517. ,"DescFlexField"=>[
  518. "PubDescSeg2"=>$params['yyid'],//来源店铺 这种需要在店铺表中有
  519. "PubDescSeg4"=>$params['number'],//订单编码
  520. "PubDescSeg5"=>$params['shipremarks'],//订单的备注
  521. ],
  522. ];
  523. }
  524. $data = [];
  525. $data[] = [
  526. "OtherID"=>$params['number'],//第三方数据唯一性标识,此字段需要返回
  527. "TransOutDocType_Code"=> $params['TransOutDocType_Code'],//单据类型在u9中设置的 详情到u9界面查看 TransOut001 组织间调拨 TransOut002 仓库转储 TransOut004 委外加工发料 TransOut005 委外加工退料
  528. "BusinessDate"=>date("Y-m-d",$params['time']),//日期
  529. "TransferDirection"=>$params['TransferDirection'],//调拨方向 0:普通;1:退货
  530. "TransOutLines"=>$trans_out_lines,
  531. "DescFlexField"=>[
  532. "PubDescSeg2"=>$params['yyid'],//来源店铺 这种需要在店铺表中有
  533. "PubDescSeg4"=>$params['number'],//订单编码
  534. "PubDescSeg5"=>$params['shipremarks'],//订单的备注
  535. ],
  536. ];
  537. return $data;
  538. }
  539. //销售单的数据转化
  540. public function xsdDataTrans($params){
  541. $so_lines = [];
  542. foreach($params['list'] as $k=>$v){
  543. $so_lines[] = [
  544. 'TU'=>"条",//销售单位编码
  545. 'ItemCode'=>$v['jm'],//用友的编码
  546. 'PU'=>'条',//计价单位编码
  547. "ShipTogetherFlag"=>-1,//成套收发货标志
  548. 'DocLineNo'=>$k+1,
  549. 'CustomerItemNo'=>'',//客户料号
  550. 'CustomerItemName'=>'',//客户品名
  551. 'FinallyPriceTC'=>$v['final_price'],//最终价 单价
  552. 'PubDescSeg10'=>'',
  553. 'SOShiplineDTOList'=>[ //销售订单计划行
  554. [
  555. 'IsMRPRequire', //MRP需求
  556. 'DemandType',//需求分类
  557. 'RequireDate'=>date('m/d/Y H:i:s',$params['time']),
  558. ]
  559. ],
  560. 'RecTerm'=>'',//目前找不到了
  561. 'FreeType'=>($v['final_price'] < 0.01)?0: -1,//免费品类型 (无默认值请传-1;赠品请传0;备损品请传1) 徐凯设定的是 如果钱小于0.01 那么就传0 其他的传递-1
  562. 'UsableQtyOfInv'=>0,//文档中未查询到
  563. 'PubDescSeg3'=>'',
  564. 'PubDescSeg4'=>'',
  565. 'PriceList'=>'',//价表编码 (该属性可为空,且无默认值)
  566. 'TaxMoneyTC'=>0,//税额 (该属性可为空,且无默认值)
  567. 'TaxSchedule'=>'YZ05',//税组合编码 (该属性可为空,且无默认值) 不知道这个是啥 徐凯的老代码是这么写的
  568. 'DescFlexField'=>[
  569. 'PubDescSeg3'=>'',
  570. ],
  571. 'OrderByQtyTU'=>$v['dcsl'],//销售数量 (该属性可为空,且无默认值)
  572. 'OrderByQtyPU'=>$v['dcsl'],//计价数量 (该属性可为空,且无默认值)
  573. 'OrderPriceTC'=>'',//定价 (该属性可为空,且无默认值)
  574. 'Memo'=>'',//备注
  575. ];
  576. }
  577. $data = [];
  578. $data[] = [
  579. "OrderBy"=>$params['yyid'],//用友的商户的id
  580. "OtherID"=>$params['number'],//第三方传入ID
  581. "SaleDepartment"=>"",//部门编码 可为空
  582. "DocumentType"=>"SO1",//单据类型编码 标准销售单 So1是默认值
  583. "DocNo"=>'',//单据类型编码
  584. "AC"=>"C001",//人民币
  585. "TC"=>"C001",//人民币
  586. "ShipToSite"=>"",//收货位置编码
  587. "PubDescSeg2"=>"",
  588. "SOSrcType"=>0,
  589. "Seller"=>"",//业务员编码 可为空
  590. "ConfirmTerm"=>"",//但是现有文档没有
  591. "Memo"=>$params['number'],//备注
  592. "ShipRule"=>"",//但是现有文档没有
  593. "SOLineDTOList"=>$so_lines,
  594. ];
  595. return $data;
  596. }
  597. //销售单的数据转化 工厂对外的销售单
  598. public function xsdDataTransGC($params){
  599. $so_lines = [];
  600. foreach($params['list'] as $k=>$v){
  601. $so_lines[] = [
  602. 'TU'=>"条",//销售单位编码
  603. 'ItemCode'=>$v['jm'],//用友的编码
  604. 'PU'=>'条',//计价单位编码
  605. "ShipTogetherFlag"=>-1,//成套收发货标志
  606. 'DocLineNo'=>$k+1,
  607. 'CustomerItemNo'=>'',//客户料号
  608. 'CustomerItemName'=>'',//客户品名
  609. //'FinallyPriceTC'=>$v['final_price'],//最终价 单价
  610. 'PubDescSeg10'=>'',
  611. 'PriceSource'=>0,//从价目表中 获取价格
  612. 'SOShiplineDTOList'=>[ //销售订单计划行
  613. [
  614. 'IsMRPRequire', //MRP需求
  615. 'DemandType',//需求分类
  616. 'RequireDate'=>date('m/d/Y H:i:s',$params['time']),
  617. ]
  618. ],
  619. 'RecTerm'=>'',//目前找不到了
  620. 'FreeType'=>($v['final_price'] < 0.01)?0: -1,//免费品类型 (无默认值请传-1;赠品请传0;备损品请传1) 徐凯设定的是 如果钱小于0.01 那么就传0 其他的传递-1
  621. 'UsableQtyOfInv'=>0,//文档中未查询到
  622. 'PubDescSeg3'=>'',
  623. 'PubDescSeg4'=>'',
  624. 'PriceList'=>'',//价表编码 (该属性可为空,且无默认值)
  625. 'TaxMoneyTC'=>0,//税额 (该属性可为空,且无默认值)
  626. 'TaxSchedule'=>'YZ05',//税组合编码 (该属性可为空,且无默认值) 不知道这个是啥 徐凯的老代码是这么写的
  627. 'DescFlexField'=>[
  628. 'PubDescSeg3'=>'',
  629. ],
  630. 'OrderByQtyTU'=>$v['dcsl'],//销售数量 (该属性可为空,且无默认值)
  631. 'OrderByQtyPU'=>$v['dcsl'],//计价数量 (该属性可为空,且无默认值)
  632. 'OrderPriceTC'=>'',//定价 (该属性可为空,且无默认值)
  633. 'Memo'=>'',//备注
  634. ];
  635. }
  636. $data = [];
  637. $data[] = [
  638. "OrderBy"=>$params['yyid'],//用友的商户的id
  639. "OtherID"=>$params['number'],//第三方传入ID
  640. "SaleDepartment"=>"",//部门编码 可为空
  641. "DocumentType"=>"SO1",//单据类型编码 标准销售单 So1是默认值
  642. "DocNo"=>'',//单据类型编码
  643. "AC"=>"C001",//人民币
  644. "TC"=>"C001",//人民币
  645. "ShipToSite"=>"",//收货位置编码
  646. "PubDescSeg2"=>"",
  647. "SOSrcType"=>0,
  648. "Seller"=>"",//业务员编码 可为空
  649. "ConfirmTerm"=>"",//但是现有文档没有
  650. "Memo"=>$params['number'],//备注
  651. "ShipRule"=>"",//但是现有文档没有
  652. "SOLineDTOList"=>$so_lines,
  653. ];
  654. return $data;
  655. }
  656. public function xsdTwoDataTrans($params){
  657. $so_lines = [];
  658. foreach($params['list'] as $k=>$v){
  659. $so_lines[] = [
  660. 'TU'=>"条",//销售单位编码
  661. 'ItemCode'=>$v['jm'],//用友的编码
  662. 'PU'=>'条',//计价单位编码
  663. "ShipTogetherFlag"=>-1,//成套收发货标志
  664. 'DocLineNo'=>$k+1,
  665. 'CustomerItemNo'=>'',//客户料号
  666. 'CustomerItemName'=>'',//客户品名
  667. 'FinallyPriceTC'=>$v['final_price'],//最终价 单价
  668. 'PubDescSeg10'=>'',
  669. 'SOShiplineDTOList'=>[ //销售订单计划行
  670. [
  671. 'IsMRPRequire', //MRP需求
  672. 'DemandType',//需求分类
  673. 'RequireDate'=>date('m/d/Y H:i:s',$params['time']),
  674. ]
  675. ],
  676. 'RecTerm'=>'',//目前找不到了
  677. 'FreeType'=>($v['final_price'] < 0.01)?0: -1,//免费品类型 (无默认值请传-1;赠品请传0;备损品请传1) 徐凯设定的是 如果钱小于0.01 那么就传0 其他的传递-1
  678. 'UsableQtyOfInv'=>0,//文档中未查询到
  679. 'PubDescSeg3'=>'',
  680. 'PubDescSeg4'=>'',
  681. 'PriceList'=>'',//价表编码 (该属性可为空,且无默认值)
  682. 'TaxMoneyTC'=>0,//税额 (该属性可为空,且无默认值)
  683. 'TaxSchedule'=>'YZ05',//税组合编码 (该属性可为空,且无默认值) 不知道这个是啥 徐凯的老代码是这么写的
  684. 'DescFlexField'=>[
  685. 'PubDescSeg3'=>'',
  686. ],
  687. 'OrderByQtyTU'=>$v['dcsl'],//销售数量 (该属性可为空,且无默认值)
  688. 'OrderByQtyPU'=>$v['dcsl'],//计价数量 (该属性可为空,且无默认值)
  689. 'OrderPriceTC'=>'',//定价 (该属性可为空,且无默认值)
  690. 'Memo'=>'',//备注
  691. ];
  692. }
  693. $data = [];
  694. $data[] = [
  695. "OrderBy"=>$params['yyid'],//用友的商户的id
  696. "OtherID"=>$params['number'],//第三方传入ID
  697. "SaleDepartment"=>"",//部门编码 可为空
  698. "DocumentType"=>"SO1",//单据类型编码 标准销售单 So1是默认值
  699. "DocNo"=>'',//单据类型编码
  700. "AC"=>"C009",//美金
  701. "TC"=>"C009",//美金
  702. "ShipToSite"=>"",//收货位置编码
  703. "PubDescSeg2"=>"",
  704. "SOSrcType"=>0,
  705. "Seller"=>"",//业务员编码 可为空
  706. "ConfirmTerm"=>"",//但是现有文档没有
  707. "Memo"=>$params['number'],//备注
  708. "ShipRule"=>"",//但是现有文档没有
  709. "SOLineDTOList"=>$so_lines,
  710. ];
  711. return $data;
  712. }
  713. public function cgdDataTrans($params){
  714. $po_lines = [];
  715. foreach($params['list'] as $k=>$v){
  716. $po_lines[] = [
  717. //"POLineID"=>0,//采购订单行ID
  718. 'ItemInfo'=>[
  719. 'm_code'=>$v['jm'],//用友料号
  720. ],
  721. "ReqQtyTU"=>$v['dcsl'],//需求数量
  722. "ReqQtyTBU"=>0,//确认数量
  723. "SupplierConfirmQtyTU"=>$v['dcsl'],//确认数量
  724. "SupplierConfirmQtyTBU"=>0,//确认数量
  725. "FinallyPriceTC"=>$v['final_price'],//最终价格
  726. "IsPresent"=>false,//赠品
  727. ];
  728. }
  729. $data = [];
  730. $data[] = [
  731. 'DocNo'=>"",
  732. "DocumentType"=>'PO01',//PO01 标准采购默认值
  733. 'BizType'=>0,//业务类型:AR_Invoice 销售发票 0 (默认值),PM005 标准采购 316 ,PM055 全程委外采购 326 ,PM050 工序外协采购 325
  734. "BusinessDate"=>date("Y-m-d H:i:s"),
  735. 'OtherID'=>$params['number'],
  736. 'DescFlexField'=>(object)[
  737. ],
  738. 'TC'=>'C001',
  739. 'AC'=>'C001',
  740. "Memo"=>$params['number'],
  741. 'Supplier'=>[
  742. 'Code'=>$params['gys'],//供应商编码 到时间找下
  743. ],
  744. 'IsPriceIncludeTax'=>false,
  745. "POLineDTOList"=>$po_lines
  746. ];
  747. return $data;
  748. }
  749. public function yybzchDataTrans($params){
  750. $data = [];
  751. foreach($params['list'] as $k=>$v ){
  752. $data[] = [
  753. "SrcDocType"=>1,//售订单 Value:1 出货计划 Value:2 销售合同 Value:3 预出货单 Value:4
  754. "SrcDocNo"=>$params['xs_no'],//来源单号
  755. "SrcDocLineNo"=>$v['doclineno'],
  756. "SrcDocSubLineNo"=>$v['docsublineno'],
  757. //"WH"=>'',//存储地点ID 找不到id 那就找个WHcode
  758. 'WHCode'=>$params['drckbm'],//存储地点code 这里的参数为啥这么诡异 是因为 不想在很设置参数了 都按照调出的写法组件数据了
  759. "CurShipQty1"=>$v['dcsl'],//本次出货量
  760. "SOIsConsign"=>false,// 是否补货
  761. "OptionalSplitTerm"=>[],
  762. "DescFlexField"=>(object)[],
  763. "LineDescFlexField"=>(object)[],
  764. //"ShipDate",//出货单日期(该属性可为空,且无默认值)
  765. //"ShipConfirmDate"//出货确认日期(该属性可为空,且无默认值)
  766. "DocStatus"=>0,//单据状态:0开立;1审核中;2已审核,可用值:0,1,2,3
  767. ];
  768. }
  769. return $data;
  770. }
  771. //销售单的数据转化
  772. public function cjlpDataTrans($params){
  773. $list = [];
  774. foreach($params['list'] as $k=>$v){
  775. $list[] = [
  776. "Code"=>$v['jm'],//料号
  777. "Code1"=>"",//参考料号1
  778. "Name"=>$v['zh'],//品名
  779. "MainItemCategory"=>[
  780. "Code"=>$v['bm']
  781. ],
  782. "Org"=>[
  783. "Code"=>$params['ztcode']
  784. ],
  785. "OtherID"=>1,
  786. "PurchaseInfo"=>[
  787. "BudgetControlType"=>-1,//预算控制方式
  788. "PriceSource"=>2,//取价来源
  789. "InquireRule"=>-1,//询价策略
  790. 'InquireFixedPeriod'=>0,//间隔期
  791. "StatisticPeriod"=>-1,//配额统计期间
  792. "IsPUTradePathModify"=>true,//采购贸易路径可改
  793. "IsPURtnTradePathModify"=>true,//采购退货贸易路径可改
  794. ],
  795. "InventoryUOM"=>[
  796. "Code"=>'条'
  797. ],
  798. "InventorySecondUOM"=>[
  799. "Code"=>''
  800. ],
  801. "IsDualUOM"=>false,
  802. "InventoryInfo"=>[
  803. "InventoryPlanningMethod"=>4,//规划方法
  804. "InventoryPlanTime"=>-1,//
  805. "TurnOverRate"=>1,//
  806. "ReserveMode"=>-1,//
  807. "SupplyMethod"=>-1,//
  808. ],
  809. "DescFlexField"=>[
  810. "PrivateDescSeg1"=>"01",
  811. "PubDescSeg5"=>"01"
  812. ],
  813. "Description"=>$v['title'],
  814. "ItemForm"=>2001,//料品形态
  815. "ItemFormAttribute"=>10,//料品形态属性
  816. "IsInventoryEnable"=>true,//可库存交易
  817. "IsPurchaseEnable"=>true,//可采购
  818. "IsSalesEnable"=>true,//可采购
  819. "IsBuildEnable"=>true,//可生产
  820. "IsOutsideOperationEnable"=>true,//可委外
  821. "IsMRPEnable"=>true,//可MRP
  822. "IsBOMEnable"=>true,//可BOM
  823. "IsCostCalByGrade"=>false,//等级影响成本
  824. "IsCostCalByPotency"=>false,//成分影响成本
  825. "IsGradeControl"=>false,//等级控制
  826. "StandardGrade"=>-1,//标准等级
  827. "StartGrade"=>-1,//起始等级
  828. "EndGrade"=>-1,//结束等级
  829. "IsPotencyControl"=>false,//成分控制
  830. "StandardPotency"=>-1,//标准成分
  831. "StartPotency"=>-1,//起始成分
  832. "EndPotency"=>-1,// 结束成分
  833. ];
  834. }
  835. return $list;
  836. }
  837. public function cprkDataTrans($params){
  838. $list = [];
  839. foreach($params['list'] as $k=>$v){
  840. $tmp = [
  841. "MOKey"=>[
  842. "OtherID"=>"",
  843. "ID"=>0,
  844. "DocNo"=>$params['rkcode'],//需要填写入库 rkcode 传递
  845. "OrgID"=>0,
  846. "IsSuccess"=>1,
  847. "ErrorInfo"=>"",
  848. "CUD"=>0,
  849. ],
  850. "Wh"=>[
  851. "Code"=>$params['rev_wh_code'],//存储地点信息 传递
  852. ],
  853. "LineNum"=>$k,//行号
  854. "StorageType"=>4,//
  855. "Grade"=>0,//等级
  856. "Element"=>0,
  857. "CompleteQty"=>$v['sl'],//申报数量(生产单位)
  858. "CompleteQtyByWhUOM"=>$v['sl'],//申报数量(库存单位)
  859. "CompleteQtyByCostUOM"=>$v['sl'],//申报数量(成本单位)
  860. "CUD"=>0,
  861. "OwnerOrg"=>[
  862. "Code"=>$params['org_code'],//货主组织编码
  863. ],
  864. "OutputType"=>0,//产出类型
  865. "Item"=>[
  866. "Code"=>$v['jm'],//编码 其实是用友的料号
  867. ],
  868. "ScrapQty"=>0,//报废数量
  869. "ScrapQtyByCostUOM"=>0,//报废数量(成本单位)
  870. "PUToPBURate"=>0,//生产主-生产副
  871. "CUToCBURate"=>0,//成本主-成本副
  872. "PBUToCBURate"=>0,//生产-成本
  873. "SourceRcvRptLine"=>[ //来源入库单行
  874. "RcvRptDocDTO"=>[ //入库单DTO
  875. "ID"=>0, //唯一标示
  876. "DocType"=>[ //单据类型
  877. 'Code'=>0,
  878. ],
  879. "BusinessDate"=>'',//业务日期
  880. "DocNo"=>"",//单号
  881. "SourceDoc"=>[ //来源单据
  882. "MOSrcDocType"=>0,//来源单据类型
  883. "SrcDocOrg"=>0,//
  884. "SrcDoc"=>[ //来源单据
  885. "ID"=>$params['rkid'], //单据ID 徐凯传递的是$data['rkid']
  886. "EntityType"=>'UFIDA.U9.MO.MO.MO',//单据类型
  887. ],
  888. "SrcDocVer"=>'',//单据版本
  889. "SrcDocLine"=>[
  890. "ID"=>0,
  891. "EntityType"=>'',
  892. ],
  893. "SrcDocSubline"=>[
  894. "ID"=>0,
  895. "EntityType"=>'',
  896. ],
  897. "SrcDocNo"=>$params['rkid'],//单据号 徐凯传递了$data['rkid']
  898. "SrcDocLineNo"=>'',//行号
  899. "SrcDocSublineNo"=>10+$k,
  900. "SrcDocID"=>$params['rkid'],//来源单据ID 徐凯传递了$data['rkid']
  901. "SrcDocLineID"=>0,
  902. "SrcDocType"=>'',
  903. ],
  904. "DocDate"=>date("Y-m-d",time()),
  905. "RcvOrg"=>[ //入库组织
  906. "Code"=>$params['rec_code'],//入库组织编码 需填写
  907. ],
  908. "Org"=>[
  909. "Code"=>$params['org_code'],//组织编码 需填写
  910. ],
  911. "Direction"=>0,
  912. "DocState"=>0,
  913. "RcvDep"=>[
  914. "ID"=>0,
  915. "Code"=>'',
  916. "Name"=>''
  917. ],
  918. "RcvPerson"=>[
  919. "ID"=>0,
  920. "Code"=>'',
  921. "Name"=>''
  922. ],
  923. "OtherID"=>"",
  924. ],
  925. "ProductUOM"=>[
  926. "Code"=>'条',
  927. ],
  928. "ProductBaseUOM"=>[
  929. "Code"=>'条',
  930. ],
  931. "StoreUOM"=>[
  932. "Code"=>'条',
  933. ],
  934. "StoreBaseUOM"=>[
  935. "Code"=>'条',
  936. ],
  937. "CoUOM"=>[
  938. "Code"=>'条',
  939. ],
  940. "CostBaseUOM"=>[
  941. "Code"=>'条',
  942. ],
  943. "OperationState"=>0,
  944. "OutputType"=>0,
  945. "Item"=>[
  946. "Code"=>$v['jm'],//料号 徐凯传递的是$data['jm']
  947. ],
  948. "OwnerOrg"=>[
  949. "Code"=>$params['org_code'],//货主组织编码 需填写
  950. ],
  951. "PUToPBURate"=>0,
  952. "SUToSBURate"=>0,
  953. "PBUToSBURate"=>0,
  954. "CUToCBURate"=>0,
  955. "PBUToCBURate"=>0,
  956. "Grade"=>0,
  957. "Element"=>0,
  958. "Wh"=>[
  959. "Code"=>$params['rev_wh_code'],//存储地点信息 传递
  960. ],
  961. "StorageType"=>4,
  962. "RcvValiddate"=>0,
  963. "RcvQtyByProductUOM"=>0,
  964. "RcvQtyByWhUOM"=>0,
  965. "RcvQtyByCostUom"=>0,
  966. "RcvOrg"=>[ //入库组织
  967. "Code"=>001,//编码
  968. ],
  969. "PerformingOrg"=>[ //执行组织
  970. "Code"=>001 //编码
  971. ],
  972. "CUD"=>0,
  973. "LineNum"=>0,
  974. "MO"=>[ //生产订单
  975. "Code"=>$params['rkcode'],//徐凯写了 rkcode
  976. ],
  977. "ID"=>0,
  978. ]
  979. ];
  980. $list[] = $tmp;
  981. }
  982. $res = [
  983. "DocNo"=>"",//
  984. "CompleteList"=>$list,
  985. "DescFlexField"=>[
  986. //"PubDescSeg2"=>$params['yyid'],//kh
  987. "PubDescSeg4"=>$params['number'],//订单编码
  988. "PubDescSeg5"=>$params['shipremarks'],//备注
  989. ],
  990. "DocType"=>[
  991. "Code"=>0,
  992. ],
  993. "BusinessDate"=>(date("Y-m-d",time())),
  994. "OtherID"=>'',//订单编码
  995. "Direction"=>0,
  996. "IsOffLine"=>1, //是否撤线报
  997. "DocState"=>0,
  998. "Remark"=>time(),
  999. "RcvPerson"=>[
  1000. "Code"=>"ERP"
  1001. ]
  1002. ];
  1003. if(!empty($params['yyid'])){
  1004. $res['DescFlexField']['PubDescSeg2'] = $params['yyid'];//备注-客户
  1005. }
  1006. return [$res];
  1007. }
  1008. public function scdDataTrans($params){
  1009. $list = [];
  1010. foreach($params['list'] as $k=>$v){
  1011. $info = [
  1012. "OtherID"=>"",
  1013. "Org"=>[
  1014. "Code"=>$params['org_code']//生产组织编码
  1015. ],
  1016. "ItemMaster"=>[
  1017. "Code"=>$v['jm'],//料号
  1018. ],
  1019. "DocType"=>[
  1020. "Code"=>$params['djhlx']//单据类型
  1021. ],
  1022. "Department"=>[
  1023. "Code"=>$params['scbm_code']//生产部门编码
  1024. ],
  1025. "ExpandLevel"=>0, //展开阶数
  1026. "AlternateType"=>0,//生产目的
  1027. "RoutingAlternate"=>0,//工艺生产目的
  1028. "RoutingEffeDate"=>'',//工艺有效日期
  1029. "ProductQty"=>$v['sl'],
  1030. "ProductUOM"=>[
  1031. "Code"=>'条'
  1032. ],
  1033. "StartDate"=>date('Y-m-d',$params['time']),//计划开工日期
  1034. "CompleteDate"=>date('Y-m-d',$params['time']),//计划完工日期
  1035. "MOSourceDocType"=>0,//来源单据类型
  1036. "OwnerOrg"=>[
  1037. "Code"=>$params['owner_org_code']//货主组织编码
  1038. ],
  1039. "SCVWh"=>[
  1040. "Code"=>$v['drck']//完工存储地点编码
  1041. ],
  1042. "DemandCode"=>-1,//需求分类
  1043. "IsFirmed"=>false,//锁定标志
  1044. "IsCapacityLimit"=>false,//有限产能
  1045. "Priority"=>0,// 优先级
  1046. "CUD"=>0,//增删改类型
  1047. "BOMType"=>0,//BOM类型
  1048. "Description"=>$params['title'],//备注
  1049. "MRPQty"=>0,//MRP数量
  1050. "MOID"=>0,//生产订单ID
  1051. "PBUToSBURate"=>0,//生产-库存
  1052. "PBUToCBURate"=>0,//生产-成本
  1053. "DescFlexField"=>[
  1054. "PubDescSeg4"=>$params['title'],//erp单号
  1055. "PubDescSeg5"=>$params['shipremarks'],//erp备注
  1056. ]
  1057. ];
  1058. if(!empty($params['yyid'])){
  1059. $info['DescFlexField']['PubDescSeg2'] = $params['yyid'];//备注-客户
  1060. }
  1061. $list[] = $info;
  1062. }
  1063. return $list;
  1064. }
  1065. }