Model_apiyyv1.php 40 KB

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