Model_logic_u9xg.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591
  1. <?php
  2. /**
  3. * 此模型是为了支持从许昌销售公司调出库存到香港公司仓库的功能支持
  4. */
  5. class Model_logic_u9xg extends Lin_Model {
  6. public $xdzzcode = '130';//许昌销售公司编码
  7. public $xdcp_code = '13001';//许昌成品库的编码 测试的时候就用龙盈工厂的仓库
  8. public $xdxgzzcode = '140';//香港组织公司编码
  9. public $xdxgls_code = '14003';//香港临时库的编码 测试的时候用销售公司成品库的编码
  10. public $ztcode = '001';//账套的code;
  11. public $tb_org_arr =[101,110,130,140];//同步组织
  12. public $gys = "98002";//供应商 98001 龙盈 98002 龙熠
  13. //切记要修改token_120的token真正的token!!!!
  14. function __construct(){
  15. parent::__construct();
  16. $this->load->_model('Model_settingtest','settingtest');
  17. $this->load->_model("Model_apiyyv1",'apiyyv1');
  18. $this->load->_model('Model_classid','classid');
  19. $this->load->_model('Model_typeclass','typeclass');
  20. $this->load->_model('Model_shop','shop');
  21. $this->load->_model('Model_zzquque_u9','zzquque_u9');
  22. $this->load->_model('Model_zzququeu9_logs','zzququeu9_logs');
  23. $this->load->_model('Model_logic_tools','logic_tools');
  24. $this->load->_model('Model_logic_u9tools','logic_u9tools');
  25. }
  26. public function getToken($type){
  27. $name = "get_yytoken_".$type;
  28. $token = $this->settingtest->$name();
  29. return $token;
  30. }
  31. //转码准备数据
  32. public function transPrepare(){
  33. $classid = $this->classid->sku();
  34. $tcall = $this->typeclass->find_all();
  35. foreach ($tcall as $v)
  36. {
  37. $tcjm[$v['id']] = array($v['jm'],$v['classid']);
  38. $typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
  39. }
  40. return [
  41. 'classid'=>$classid,
  42. 'typeclass'=>$typeclass,
  43. ];
  44. }
  45. //必须先建立许昌成品仓的销售单和调出单 香港仓的采购单 一次执行5单
  46. //循环执行许昌成品仓的销售单 调出单和香港仓的采购单
  47. public function xdlsOneStep($list){
  48. $pre_data = $this->transPrepare();
  49. foreach($list as $k=>$v){
  50. $this->xdlsBeforeCreate($v,$pre_data['typeclass'],$pre_data['classid']);
  51. }
  52. }
  53. //修正原来的逻辑 调出单审核完成后才可以在批量执行后续订单
  54. public function xdlsOneExtraStep($list){
  55. foreach($list as $k=>$v){
  56. $this->xdlsCxDcd($v);
  57. }
  58. }
  59. //循环执行许昌仓的销售单 调出单和香港仓的采购单 提交 顺带的也执行审核
  60. public function xdlsTwoStep($list){
  61. foreach($list as $k=>$v){
  62. $this->xsAddXsAndCg($v);
  63. }
  64. }
  65. //循环执行许昌仓的销售单 香港仓的采购单 提交 顺带的也执行审核
  66. public function xdlsTwoExtraStep($list){
  67. foreach($list as $k=>$v){
  68. $r2 = $this->cgSubAndCheck($v);
  69. if(!$r2){
  70. continue;
  71. }
  72. $this->xsSubAndCheck($v);
  73. }
  74. }
  75. //查询调出单生成的调入单是否生成 如果生成了就审核 如果没生成 说明异常了 这种都是按步骤走的
  76. public function xdlsThreeStep($list){
  77. foreach($list as $k=>$v){
  78. $r = $this->apiyyv1->drdcxBydcd($v['dc_no'],$this->getToken(140));
  79. //如果获取对应调入单没有成功
  80. if(empty($r[0]['Data'][0]['docno'])){
  81. $this->editData($v['id'],['dr_status'=>-1,'update_time'=>time()],$v['order_no'],6,1,'dr',$r[1],$r[0]);
  82. continue;
  83. }
  84. $dr_no = $r[0]['Data'][0]["docno"];
  85. $this->editData($v['id'],['dr_no'=>$dr_no,'dr_status'=>1,'update_time'=>time()],$v['order_no'],6,1,'dr',$r[1],$r[0]);
  86. //提交调入单
  87. $rr = $this->apiyyv1->drdSubmit(['number'=>$dr_no],$this->getToken(140));
  88. if(!$rr[0]['Data'][0]['IsSucess']){
  89. $this->editData($v['id'],['dr_status'=>-2,'update_time'=>time()],$v['order_no'],6,2,'dr',$rr[1],$rr[0]);
  90. continue;
  91. }
  92. $this->editData($v['id'],['dr_status'=>2,'update_time'=>time()],$v['order_no'],6,2,'dr',$rr[1],$rr[0]);
  93. //审核调入单
  94. $rrr = $this->apiyyv1->drdApprove(['number'=>$dr_no],$this->getToken(140));
  95. if(!$rrr[0]['Data'][0]['IsSucess']){
  96. $this->editData($v['id'],['dr_status'=>-3,'update_time'=>time()],$v['order_no'],6,3,'dr',$rrr[1],$rrr[0]);
  97. continue;
  98. }
  99. $this->editData($v['id'],['dr_status'=>3,'update_time'=>time()],$v['order_no'],6,3,'dr',$rrr[1],$rrr[0]);
  100. }
  101. }
  102. //建立香港的销售单 标准出库单有源的需要先审核
  103. public function xdlsFourStep($list){
  104. $pre_data = $this->transPrepare();
  105. foreach($list as $k=>$v){
  106. $this->xdlsAfterDetail($v,$pre_data['typeclass'],$pre_data['classid']);
  107. }
  108. }
  109. //审核香港销售单 同时生成标准出库单
  110. public function xdlsFiveStep($list){
  111. $xs_no_list = array_column($list,'xs_two_no');
  112. $r = $this->apiyyv1->xscsByordernos($xs_no_list,$this->getToken(140));
  113. if(empty($r[0]['Data'])){
  114. return ;
  115. }
  116. $tmp_list = [];
  117. foreach($r[0]['Data'] as $k=>$v){
  118. $v['dcsl'] = $v['shipplanqtypu'];
  119. $tmp_list[$v['docno']][] = $v;
  120. }
  121. $final_list = [];
  122. foreach($tmp_list as $k=>$v){
  123. foreach($list as $item){
  124. if($item['xs_two_no'] == $k){
  125. $final_list[] = [
  126. 'zq_u9_id'=>$item['id'],
  127. 'drckbm'=>$this->xdxgls_code,
  128. 'number'=>$item['order_no'],
  129. 'order_no'=>$item['order_no'],
  130. 'xs_no'=>$k,
  131. 'xs_two_no'=>$k,
  132. 'list'=>$v
  133. ];
  134. }
  135. }
  136. }
  137. foreach($final_list as $info){
  138. $this->xdlsFiveStepAfter($info);
  139. }
  140. }
  141. public function xdlsFiveStepAfter($info){
  142. //先审核 然后在执行
  143. $r = $this->xsSubAndCheck140($info);
  144. if(!$r){
  145. return ;
  146. }
  147. $bzch_res = $this->apiyyv1->bzchCreate($info,$this->getToken(140));
  148. if(empty($bzch_res[0]['Data'][0]['m_code'])){
  149. $this->editData($info['zq_u9_id'],['bzch_status'=>-1,'update_time'=>time()],$info['number'],4,1,'bzch',$bzch_res[1],$bzch_res[0]);
  150. return ;
  151. }
  152. //更新销售单数据
  153. $bzch_no = $bzch_res[0]['Data'][0]["m_code"];
  154. $this->editData($info['zq_u9_id'],['bzch_no'=>$bzch_no,'bzch_status'=>1,'update_time'=>time()],$info['number'],4,1,'bzch',$bzch_res[1],$bzch_res[0]);
  155. }
  156. //审核香港标准出库单
  157. public function xdlsSixStep($list){
  158. foreach($list as $k =>$v){
  159. $bzch_res = $this->apiyyv1->bzchSubmitAndApprove(['number'=>$v['bzch_no']],$this->getToken(140));
  160. if(empty($bzch_res[0]['Data'][0]['m_code'])){
  161. $this->editData($v['id'],['bzch_status'=>-3,'update_time'=>time()],$v['order_no'],4,3,'bzch',$bzch_res[1],$bzch_res[0]);
  162. return ;
  163. }
  164. //更新销售单数据
  165. $bzch_no = $bzch_res[0]['Data'][0]["m_code"];
  166. $this->editData($v['id'],['bzch_no'=>$bzch_no,'bzch_status'=>3,'update_time'=>time()],$v['order_no'],4,3,'bzch',$bzch_res[1],$bzch_res[0]);
  167. }
  168. }
  169. //由于调出单生成可能不会申请后实时出现 需要差几分钟再去申请,避免这种错误
  170. //从许昌成品库调出库存到香港临时仓
  171. //创建 调出单 销售单 采购单
  172. //必须先建立许昌成品仓的销售单和调出单 香港仓的采购单 因为u9生成需要时间 然后在进行 审核
  173. public function xdlsBeforeCreate($info,$typeclass,$classid){
  174. $time = time();
  175. $list = [];
  176. $fpdata = $info['fpdata'];
  177. $fpdata_list = explode(';',trim( $fpdata,';'));
  178. $whlabel_list = explode("|",trim($info['whlabel'],"|"));
  179. $total_goods_num = 0;//订单产品总数量
  180. foreach($whlabel_list as $k=>$v){
  181. $tmp_data = explode("-",trim($v,'-'));
  182. if(isset($tmp_data[1])){
  183. $total_goods_num += $tmp_data[1];
  184. }
  185. }
  186. $avg_price = floor(($info['skje']*1000)/$total_goods_num)/1000;
  187. foreach($fpdata_list as $k=>$v){
  188. $tmp_str = str_replace(array('-163-','-164-','-165-','-166-'),'-',$v);
  189. $tmp_arr = explode('|',trim($tmp_str,'|'));
  190. if(stripos($tmp_arr[0],',') !== false){
  191. $ft = explode(',',$tmp_arr[0]);
  192. $features = explode('-',trim($ft[1],'-'));
  193. $features[] = $ft[0];
  194. }else{
  195. $features = explode('-',trim($tmp_arr[0],'-'));
  196. }
  197. $sku = implode("-",$features);
  198. $tmp_ret = $this->logic_u9tools->getOneU9bm($sku,$classid,$typeclass);
  199. $list[] = [
  200. 'jm'=>$tmp_ret['jm'],
  201. 'bm'=>$tmp_ret['bm'],
  202. 'zh'=>$tmp_ret['zh'],
  203. 'final_price'=>$avg_price,//目前先不设置 等后期财务说了再说
  204. 'title'=>isset($tmp_arr[1])?$tmp_arr[1]:'无',
  205. 'dcsl'=>$tmp_arr[2],
  206. 'is_register'=>0,//商品是否被注册 先都当没注册 后面会先确认下
  207. ];
  208. }
  209. $shop = $this->shop->read($info['shop']);
  210. if(empty($shop['yyid'])){
  211. //如果没有在u9上设置店铺的组织 那么需要设置
  212. $this->editData($info['zq_u9_id'],['dc_status'=>-1,'update_time'=>time()],$info['number'],1,1,'',[],$this->logic_tools->ret_arr(-1,'店铺没有在u9平台设置参数'));
  213. return ;
  214. }
  215. $dc_params = [
  216. 'gys'=>$this->gys,//供应商
  217. 'number'=>$info['number'],//erp订单编码
  218. "TransOutDocType_Code"=>"TransOut001",//组织间调拨
  219. "time"=>$time,
  220. 'TransferDirection'=>0,//普通
  221. 'yyid'=>$shop['yyid'],//来源店铺 这种需要在店铺表中有
  222. 'shipremarks'=>$info['shipremarks'],//订单的备注
  223. 'dcckbm'=>$this->xdcp_code,//调出仓库编码
  224. 'drckbm'=>$this->xdxgls_code,//调入仓库编码
  225. 'drzz_code'=>$this->xdxgzzcode,//调入组织Code
  226. 'owner_code'=>$this->xdzzcode,//货主组织Code
  227. 'ztcode'=>$this->ztcode,//账套
  228. 'tb_org_arr'=>$this->tb_org_arr,//要同步的组织列表
  229. 'list'=>$list
  230. ];
  231. //调出单检测是否存在
  232. $cxdcd_r = $this->apiyyv1->xcDcdByOtherId($dc_params['number'],$this->getToken(130));
  233. $ret_data = $cxdcd_r[0]['Data'];
  234. if(isset($ret_data[0])){
  235. $descflexfield_pubdescseg4 = $ret_data[0]['descflexfield_pubdescseg4'];
  236. if($dc_params['number'] == $descflexfield_pubdescseg4){
  237. return ;
  238. }
  239. }
  240. //检测料品是否在u9被添加 检测香港仓有没有 许昌仓一定要有 没有
  241. $r = $this->checkLp($dc_params,$this->getToken(140));
  242. if($r['code'] !=1){
  243. $this->editData($info['zq_u9_id'],['dc_status'=>-1,'update_time'=>time()],$info['number'],1,1,'lpck',[],$r['msg']);
  244. return ;
  245. }
  246. //创建调出单
  247. $dcd_res = $this->apiyyv1->dcdCrate($dc_params,$this->getToken(130));
  248. if(empty($dcd_res[0]['Data'][0]["Code"])){
  249. $this->editData($info['zq_u9_id'],['dc_status'=>-1,'update_time'=>time()],$info['number'],1,1,'dc',$dcd_res[1],$dcd_res[0]);
  250. return ;
  251. }
  252. //更新
  253. $dcd_no = $dcd_res[0]['Data'][0]["Code"];
  254. $this->editData($info['zq_u9_id'],['dc_no'=>$dcd_no,'dc_status'=>1,'update_time'=>time()],$info['number'],1,1,'dc',$dcd_res[1],$dcd_res[0]);
  255. // //创建许昌成品库的销售单
  256. // $xsd_res = $this->apiyyv1->xsdCreate($dc_params,$this->getToken(130));
  257. // if(empty($xsd_res[0]['Data'][0]['m_code'])){
  258. // $this->editData($info['zq_u9_id'],['xs_status'=>-1,'update_time'=>time()],$info['number'],2,1,'xs',$xsd_res[1],$xsd_res[0]);
  259. // return ;
  260. // }
  261. // //更新销售单数据
  262. // $xs_no = $xsd_res[0]['Data'][0]["m_code"];
  263. // $this->editData($info['zq_u9_id'],['xs_no'=>$xs_no,'xs_status'=>1,'update_time'=>time()],$info['number'],2,1,'xs',$xsd_res[1],$xsd_res[0]);
  264. // //创建香港公司的采购单
  265. // $cgd_res = $this->apiyyv1->cgdCreate($dc_params,$this->getToken(140));
  266. // if(empty($cgd_res[0]['Data'][0]["Code"])){
  267. // $this->editData($info['zq_u9_id'],['cg_status'=>-1,'update_time'=>time()],$info['number'],3,1,'cg',$cgd_res[1],$cgd_res[0]);
  268. // return ;
  269. // }
  270. // $this->editData($info['zq_u9_id'],['cg_no'=>$cgd_res[0]['Data'][0]["Code"],'cg_status'=>1,'update_time'=>time()],$info['number'],3,1,'cg',$cgd_res[1],$cgd_res[0]);
  271. return ;
  272. }
  273. public function xsAddXsAndCg($info){
  274. if(empty($info['dc_data'])){
  275. return ;
  276. }
  277. $tmp_list = json_decode($info['dc_data'],true);
  278. if(empty($tmp_list)){
  279. return ;
  280. }
  281. $time = time();
  282. $list = [];
  283. foreach($tmp_list as $k=>$v){
  284. $list[] = [
  285. 'jm'=>$v['iteminfo_itemcode'],
  286. 'zh'=>$v['iteminfo_itemname'],
  287. 'final_price'=>$v['costprice'],//目前先不设置 等后期财务说了再说
  288. 'dcsl'=>$v['costuomqty'],
  289. 'is_register'=>0,//商品是否被注册 先都当没注册 后面会先确认下
  290. ];
  291. }
  292. $dc_params = [
  293. 'gys'=>$this->gys,//供应商
  294. 'number'=>$info['order_no'],//erp订单编码
  295. "TransOutDocType_Code"=>"TransOut001",//组织间调拨
  296. "time"=>$time,
  297. 'TransferDirection'=>0,//普通
  298. 'yyid'=>$tmp_list[0]['descflexfield_pubdescseg2'],//来源店铺 这种需要在店铺表中有
  299. 'shipremarks'=>$tmp_list[0]['descflexfield_pubdescseg5'],//订单的备注
  300. 'dcckbm'=>$this->xdcp_code,//调出仓库编码
  301. 'drckbm'=>$this->xdxgls_code,//调入仓库编码
  302. 'drzz_code'=>$this->xdxgzzcode,//调入组织Code
  303. 'owner_code'=>$this->xdzzcode,//货主组织Code
  304. 'ztcode'=>$this->ztcode,//账套
  305. 'tb_org_arr'=>$this->tb_org_arr,//要同步的组织列表
  306. 'list'=>$list
  307. ];
  308. //创建许昌成品库的销售单
  309. $xsd_res = $this->apiyyv1->xsdCreate($dc_params,$this->getToken(130));
  310. if(empty($xsd_res[0]['Data'][0]['m_code'])){
  311. $this->editData($info['id'],['xs_status'=>-1,'update_time'=>time()],$info['number'],2,1,'xs',$xsd_res[1],$xsd_res[0]);
  312. return ;
  313. }
  314. //更新销售单数据
  315. $xs_no = $xsd_res[0]['Data'][0]["m_code"];
  316. $this->editData($info['id'],['xs_no'=>$xs_no,'xs_status'=>1,'update_time'=>time()],$info['number'],2,1,'xs',$xsd_res[1],$xsd_res[0]);
  317. //创建香港公司的采购单
  318. $cgd_res = $this->apiyyv1->cgdCreate($dc_params,$this->getToken(140));
  319. if(empty($cgd_res[0]['Data'][0]["Code"])){
  320. $this->editData($info['id'],['cg_status'=>-1,'update_time'=>time()],$info['number'],3,1,'cg',$cgd_res[1],$cgd_res[0]);
  321. return ;
  322. }
  323. $this->editData($info['id'],['cg_no'=>$cgd_res[0]['Data'][0]["Code"],'cg_status'=>1,'update_time'=>time()],$info['number'],3,1,'cg',$cgd_res[1],$cgd_res[0]);
  324. return;
  325. }
  326. // 提交审核调出单调出单
  327. public function dcSubAndCheck($info){
  328. $r = $this->apiyyv1->dcdSubmit([
  329. 'number'=>$info['dc_no']
  330. ],$this->getToken(130));
  331. if(!$r[0]['Data'][0]['IsSucess']){
  332. $this->editData($info['id'],['dc_status'=>-2,'update_time'=>time()],$info['order_no'],1,2,'dc',$r[1],$r[0]);
  333. return false;
  334. }
  335. //更新调出单
  336. $this->editData($info['id'],['dc_status'=>2,'update_time'=>time()],$info['order_no'],1,2,'dc',$r[1],$r[0]);
  337. $rr = $this->apiyyv1->dcdApprove([
  338. 'number'=>$info['dc_no']
  339. ],$this->getToken(130));
  340. if(!$rr[0]['Data'][0]['IsSucess']){
  341. $this->editData($info['id'],['dc_status'=>-3,'update_time'=>time()],$info['order_no'],1,3,'dc',$rr[1],$rr[0]);
  342. return false;
  343. }
  344. $this->editData($info['id'],['dc_status'=>3,'update_time'=>time()],$info['order_no'],1,3,'dc',$rr[1],$rr[0]);
  345. return true;
  346. }
  347. //提交审核采购单
  348. public function cgSubAndCheck($info){
  349. $r = $this->apiyyv1->cgdSubmit([
  350. 'number'=>$info['cg_no']
  351. ],$this->getToken(140));
  352. if(!$r[0]['Data'][0]['IsSucess']){
  353. $this->editData($info['id'],['cg_status'=>-2,'update_time'=>time()],$info['order_no'],3,2,'cg',$r[1],$r[0]);
  354. return false;
  355. }
  356. //更新采购单
  357. $this->editData($info['id'],['cg_status'=>2,'update_time'=>time()],$info['order_no'],3,2,'cg',$r[1],$r[0]);
  358. $rr = $this->apiyyv1->cgdApprove([
  359. 'number'=>$info['cg_no']
  360. ],$this->getToken(140));
  361. if(!$rr[0]['Data'][0]['IsSucess']){
  362. $this->editData($info['id'],['cg_status'=>-3,'update_time'=>time()],$info['order_no'],3,3,'cg',$rr[1],$rr[0]);
  363. return false;
  364. }
  365. $this->editData($info['id'],['cg_status'=>3,'update_time'=>time()],$info['order_no'],3,3,'cg',$rr[1],$rr[0]);
  366. return true;
  367. }
  368. //提交审核销售单
  369. public function xsSubAndCheck($info){
  370. $r = $this->apiyyv1->xsdSubmit([
  371. 'number'=>$info['xs_no']
  372. ],$this->getToken(130));
  373. if(!$r[0]['Data'][0]['m_isSucess']){
  374. $this->editData($info['id'],['xs_status'=>-2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  375. return false;
  376. }
  377. $this->editData($info['id'],['xs_status'=>2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  378. $rr = $this->apiyyv1->xsdApprove([
  379. 'number'=>$info['xs_no']
  380. ],$this->getToken(130));
  381. if(!$rr[0]['Data'][0]['m_isSucess']){
  382. $this->editData($info['id'],['xs_status'=>-3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  383. return false;
  384. }
  385. $this->editData($info['id'],['xs_status'=>3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  386. return true;
  387. }
  388. public function xsSubAndCheck140($info){
  389. $r = $this->apiyyv1->xsdSubmit([
  390. 'number'=>$info['xs_two_no']
  391. ],$this->getToken(140));
  392. if(!$r[0]['Data'][0]['m_isSucess']){
  393. $this->editData($info['zq_u9_id'],['xs_two_status'=>-2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  394. return false;
  395. }
  396. $this->editData($info['zq_u9_id'],['xs_two_status'=>2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  397. $rr = $this->apiyyv1->xsdApprove([
  398. 'number'=>$info['xs_two_no']
  399. ],$this->getToken(140));
  400. if(!$rr[0]['Data'][0]['m_isSucess']){
  401. $this->editData($info['zq_u9_id'],['xs_two_status'=>-3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  402. return false;
  403. }
  404. $this->editData($info['zq_u9_id'],['xs_two_status'=>3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  405. return true;
  406. }
  407. //建立销售单 和出货单
  408. public function xdlsAfterDetail($info,$typeclass,$classid){
  409. $time = time();
  410. if(empty($info['dc_data'])){
  411. return ;
  412. }
  413. $tmp_list = json_decode($info['dc_data'],true);
  414. if(empty($tmp_list)){
  415. return ;
  416. }
  417. $total_goods_num = 0;//订单产品总数量
  418. foreach($tmp_list as $k=>$v){
  419. $total_goods_num += $v['costuomqty'];
  420. }
  421. $avg_price = floor(($info['shouldmoney']*1000)/$total_goods_num)/1000;
  422. $list = [];
  423. foreach($tmp_list as $k=>$v){
  424. $list[] = [
  425. 'jm'=>$v['iteminfo_itemcode'],
  426. 'zh'=>$v['iteminfo_itemname'],
  427. 'final_price'=>$avg_price,//目前先不设置 等后期财务说了再说
  428. 'dcsl'=>$v['costuomqty'],
  429. 'is_register'=>0,//商品是否被注册 先都当没注册 后面会先确认下
  430. ];
  431. }
  432. $dc_params = [
  433. 'gys'=>$this->gys,//供应商
  434. 'number'=>$info['number'],//erp订单编码
  435. "TransOutDocType_Code"=>"TransOut001",//组织间调拨
  436. "time"=>$time,
  437. 'TransferDirection'=>0,//普通
  438. 'yyid'=>$tmp_list[0]['descflexfield_pubdescseg2'],//来源店铺 这种需要在店铺表中有
  439. 'shipremarks'=>$tmp_list[0]['descflexfield_pubdescseg5'],//订单的备注
  440. 'dcckbm'=>$this->xdcp_code,//调出仓库编码
  441. 'drckbm'=>$this->xdxgls_code,//调入仓库编码
  442. 'drzz_code'=>$this->xdxgzzcode,//调入组织Code
  443. 'owner_code'=>$this->xdzzcode,//货主组织Code
  444. 'ztcode'=>$this->ztcode,//账套
  445. 'tb_org_arr'=>$this->tb_org_arr,//要同步的组织列表
  446. 'list'=>$list
  447. ];
  448. //创建香港仓的销售单
  449. $xsd_res = $this->apiyyv1->xsdTwoCreate($dc_params,$this->getToken(140));
  450. if(empty($xsd_res[0]['Data'][0]['m_code'])){
  451. $this->editData($info['zq_u9_id'],['xs_two_status'=>-1,'update_time'=>time()],$info['number'],7,1,'xs_two',$xsd_res[1],$xsd_res[0]);
  452. return ;
  453. }
  454. //更新销售单数据
  455. $xs_no = $xsd_res[0]['Data'][0]["m_code"];
  456. $this->editData($info['zq_u9_id'],['xs_two_no'=>$xs_no,'xs_two_status'=>1,'update_time'=>time()],$info['number'],7,1,'xs_two',$xsd_res[1],$xsd_res[0]);
  457. }
  458. //检查u9编码是否存在 如果不存在 请先添加并
  459. protected function checkLp($info,$token){
  460. //未注册的货品的列表
  461. $unregister_goods = [];
  462. // $info['list'][1]['jm'] ="9A-#NB-STW-20-FP-5*5C-C-180%-ww2";
  463. // $info['list'][1]['zh'] ="测试数据请删除2--".$info['list'][1]['zh'];
  464. // $info['list'][0]['jm'] ="9A-#NB-STW-22-ww2";
  465. // $info['list'][0]['zh'] ="测试数据请删除2--".$info['list'][0]['zh'];
  466. $r = $this->apiyyv1->cxLp($info['list'],$token);
  467. if(!$r[0]['Success']){
  468. return $this->logic_tools->ret_arr(-1,'查询商品信息异常'.json_encode($r,JSON_UNESCAPED_UNICODE));
  469. }
  470. foreach($r[0]['Data'] as $k=>$v)
  471. {
  472. foreach($info['list'] as $kk => $vv){
  473. if($v['m_code'] == $vv['jm']){
  474. $info['list'][$kk]['is_register'] = 1;
  475. }
  476. }
  477. }
  478. foreach($info['list'] as $k => $v){
  479. if($v['is_register'] == 0){
  480. $unregister_goods[] = $v;
  481. }
  482. }
  483. if(empty($unregister_goods)){
  484. return $this->logic_tools->ret_arr(1,"料品无异常");
  485. }
  486. $tb_info = $info;
  487. $tb_info['list'] = $unregister_goods;
  488. // //return $this->tbXgLp($tb_info,$token);
  489. return $this->tbXgLp($tb_info);
  490. }
  491. //将许昌仓的料品同步到香港仓
  492. public function tbXgLp($tb_info){
  493. $rr = $this->apiyyv1->tbLp($tb_info,$this->getToken(130));
  494. if($rr[0]['Success']){
  495. return $this->logic_tools->ret_arr(1,$rr);
  496. }else{
  497. return $this->logic_tools->ret_arr(-1,$rr);
  498. }
  499. }
  500. //添加料品并且下发
  501. // public function tjLpAndTb($tb_info,$token){
  502. // $r = $this->apiyyv1->cjLp($tb_info,$token);
  503. // if($r[0]["Success"]){
  504. // $rr = $this->apiyyv1->tbLp($tb_info,$token);
  505. // if($rr[0]['Success']){
  506. // return $this->logic_tools->ret_arr(1,$rr);
  507. // }else{
  508. // return $this->logic_tools->ret_arr(-1,$rr);
  509. // }
  510. // }else{
  511. // return $this->logic_tools->ret_arr(-1,$r);
  512. // }
  513. // }
  514. //根据返回的状态修改对应的值
  515. protected function editData($zq_u9_id,$z_qu_arr,$number,$one_type,$two_type,$apply_api,$apply_data,$ret_data){
  516. $this->zzquque_u9->save($z_qu_arr,$zq_u9_id);
  517. $this->zzququeu9_logs->insert([
  518. 'oid'=>$zq_u9_id,
  519. 'number'=>$number,
  520. 'one_type'=>$one_type,
  521. 'two_type'=>$two_type,
  522. 'apply_api'=>$apply_api,
  523. 'apply_data'=>json_encode($apply_data,JSON_UNESCAPED_UNICODE),
  524. 'ret_data'=>json_encode($ret_data,JSON_UNESCAPED_UNICODE),
  525. 'create_time'=>time(),
  526. 'read_time'=>date("Y-m-d H:i:s")
  527. ]);
  528. }
  529. public function xdlsCxDcd($info){
  530. $r = $this->apiyyv1->xdlsCxDcd($info['dc_no'],$this->getToken(130));
  531. if(empty($r[0]['Data'])){
  532. return ;
  533. }
  534. //更新销售单数据
  535. $xs_no = json_encode($r[0]['Data']);
  536. $this->editData($info['id'],['dc_data'=>$xs_no,'dc_data_status'=>1,'dc_status'=>3,'update_time'=>time()],$info['order_no'],8,1,'dc_xc',$r[1],$r[0]);
  537. }
  538. }