Model_logic_u9xgsd.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626
  1. <?php
  2. /**
  3. * 手动处理香港小单列表的功能
  4. */
  5. class Model_logic_u9xgsd 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. $this->load->_model("Model_logic_order","logic_order");
  26. $this->load->_model("Model_logic_ding","logic_ding");
  27. }
  28. public function getToken($type){
  29. $name = "get_yytoken_".$type;
  30. $token = $this->settingtest->$name();
  31. return $token;
  32. }
  33. //转码准备数据
  34. public function transPrepare(){
  35. $classid = $this->classid->sku();
  36. $tcall = $this->typeclass->find_all();
  37. foreach ($tcall as $v)
  38. {
  39. $tcjm[$v['id']] = array($v['jm'],$v['classid']);
  40. $typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
  41. }
  42. return [
  43. 'classid'=>$classid,
  44. 'typeclass'=>$typeclass,
  45. ];
  46. }
  47. //组合成要处理的数据
  48. public function createData($info){
  49. $pre_data = $this->transPrepare();
  50. $typeclass = $pre_data['typeclass'];
  51. $classid = $pre_data['classid'];
  52. $time = time();
  53. $list = [];
  54. $fpdata = $info['fpdata'];
  55. $fpdata_list = explode(';',trim( $fpdata,';'));
  56. $whlabel_list = explode("|",trim($info['whlabel'],"|"));
  57. $total_goods_num = 0;//订单产品总数量
  58. foreach($whlabel_list as $k=>$v){
  59. $tmp_data = explode("-",trim($v,'-'));
  60. if(isset($tmp_data[1])){
  61. $total_goods_num += $tmp_data[1];
  62. }
  63. }
  64. $avg_price = floor(($info['skje']*1000)/$total_goods_num)/1000;
  65. foreach($fpdata_list as $k=>$v){
  66. //礼物不占库存
  67. if(stripos($v,'-131-') !== false)
  68. {
  69. continue;
  70. }
  71. $tmp_str = str_replace(array('-163-','-164-','-165-','-166-'),'-',$v);
  72. $tmp_arr = explode('|',trim($tmp_str,'|'));
  73. if(stripos($tmp_arr[0],',') !== false){
  74. $ft = explode(',',$tmp_arr[0]);
  75. $features = explode('-',trim($ft[1],'-'));
  76. $features[] = $ft[0];
  77. }else{
  78. $features = explode('-',trim($tmp_arr[0],'-'));
  79. }
  80. $sku = implode("-",$features);
  81. $tmp_ret = $this->logic_u9tools->getOneU9bm($sku,$classid,$typeclass);
  82. $list[] = [
  83. 'jm'=>$tmp_ret['jm'],
  84. 'bm'=>$tmp_ret['bm'],
  85. 'zh'=>$tmp_ret['zh'],
  86. 'final_price'=>$avg_price,//目前先不设置 等后期财务说了再说
  87. 'title'=>isset($tmp_arr[1])?$tmp_arr[1]:'无',
  88. 'dcsl'=>$tmp_arr[2],
  89. 'is_register'=>0,//商品是否被注册 先都当没注册 后面会先确认下
  90. ];
  91. }
  92. $shop = $this->shop->read($info['shop']);
  93. if(empty($shop['yyid'])){
  94. //如果没有在u9上设置店铺的组织 那么需要设置
  95. $this->editData($info['zq_u9_id'],['dc_status'=>-1,'update_time'=>time()],$info['number'],1,1,'',[],$this->logic_tools->ret_arr(-1,'店铺没有在u9平台设置参数'));
  96. return ;
  97. }
  98. $shipremarks = $info['shipremarks'];
  99. if(mb_strlen($shipremarks) > 960){
  100. $shipremarks = mb_substr($shipremarks, 0, 850);
  101. $shipremarks .= "...";
  102. }
  103. $dc_params = [
  104. 'gys'=>$this->gys,//供应商
  105. 'number'=>$info['number'],//erp订单编码
  106. "TransOutDocType_Code"=>"TransOut001",//组织间调拨
  107. "time"=>$time,
  108. 'TransferDirection'=>0,//普通
  109. 'yyid'=>$shop['yyid'],//来源店铺 这种需要在店铺表中有
  110. 'shipremarks'=> $shipremarks ,//订单的备注
  111. 'dcckbm'=>$this->xdcp_code,//调出仓库编码
  112. 'drckbm'=>$this->xdxgls_code,//调入仓库编码
  113. 'drzz_code'=>$this->xdxgzzcode,//调入组织Code
  114. 'owner_code'=>$this->xdzzcode,//货主组织Code
  115. 'ztcode'=>$this->ztcode,//账套
  116. 'tb_org_arr'=>$this->tb_org_arr,//要同步的组织列表
  117. 'list'=>$list
  118. ];
  119. return $dc_params;
  120. }
  121. //组合成要处理的数据 利用u9数据转化为提交数据 避免因为工厂出货和实际货不对版造成的
  122. public function createDataTwo($info){
  123. $tmp_list = json_decode($info['dc_data'],true);
  124. if(empty($tmp_list)){
  125. return ;
  126. }
  127. $time = time();
  128. $list = [];
  129. foreach($tmp_list as $k=>$v){
  130. $list[] = [
  131. 'jm'=>$v['iteminfo_itemcode'],
  132. 'zh'=>$v['iteminfo_itemname'],
  133. 'final_price'=>$v['costprice'],//目前先不设置 等后期财务说了再说
  134. 'dcsl'=>$v['costuomqty'],
  135. 'is_register'=>0,//商品是否被注册 先都当没注册 后面会先确认下
  136. ];
  137. }
  138. $dc_params = [
  139. 'gys'=>$this->gys,//供应商
  140. 'number'=>$info['order_no'],//erp订单编码
  141. "TransOutDocType_Code"=>"TransOut001",//组织间调拨
  142. "time"=>$time,
  143. 'TransferDirection'=>0,//普通
  144. 'yyid'=>$tmp_list[0]['descflexfield_pubdescseg2'],//来源店铺 这种需要在店铺表中有
  145. 'shipremarks'=>$tmp_list[0]['descflexfield_pubdescseg5'],//订单的备注
  146. 'dcckbm'=>$this->xdcp_code,//调出仓库编码
  147. 'drckbm'=>$this->xdxgls_code,//调入仓库编码
  148. 'drzz_code'=>$this->xdxgzzcode,//调入组织Code
  149. 'owner_code'=>$this->xdzzcode,//货主组织Code
  150. 'ztcode'=>$this->ztcode,//账套
  151. 'tb_org_arr'=>$this->tb_org_arr,//要同步的组织列表
  152. 'list'=>$list
  153. ];
  154. return $dc_params;
  155. }
  156. //创建调出单
  157. public function createDc($tmp_info){
  158. $info = $this->logic_order->getInfoByPlat($tmp_info['platform'],$tmp_info['order_no']);
  159. $info['zq_u9_id'] = $tmp_info['id'];
  160. $dc_params = $this->createData($info);
  161. //调出单检测是否存在
  162. $cxdcd_r = $this->apiyyv1->xcDcdByOtherId($dc_params['number'],$this->getToken(130));
  163. $ret_data = $cxdcd_r[0]['Data'];
  164. //$this->logic_ding->sendToDing("创建调出单的结果".json_encode($ret_data));
  165. if(isset($ret_data[0])){
  166. $descflexfield_pubdescseg4 = $ret_data[0]['descflexfield_pubdescseg4'];
  167. if($dc_params['number'] == $descflexfield_pubdescseg4){
  168. $cxdcd_r_check = $this->apiyyv1->xcDcdByOtherIdCheck($dc_params['number'],$this->getToken(130));
  169. if(!isset($cxdcd_r_check[0]['Success'])){
  170. return $this->logic_tools->ret_arr(-1,"对应的调出单二次核对异常");
  171. }
  172. if( !$cxdcd_r_check[0]['Success']){
  173. return $this->logic_tools->ret_arr(-1,"对应的调出单二次核对报错");
  174. }
  175. $check_ret_data = $cxdcd_r_check[0]['Data'] ;
  176. $dc_params['dcckbm'];
  177. $flag = true;
  178. foreach($check_ret_data as $k=>$v){
  179. if($v['code'] == $dc_params['dcckbm']){
  180. $flag = false;
  181. }
  182. }
  183. //目前相同组织的相同调出单 是不可能同时出现的
  184. if(!$flag){
  185. return $this->logic_tools->ret_arr(-1,"对应的调出单已存在请勿重复操作");
  186. }
  187. }
  188. }
  189. //检测料品是否在u9被添加 检测香港仓有没有 许昌仓一定要有 没有
  190. $r = $this->checkLp($dc_params,$this->getToken(140));
  191. if($r['code'] !=1){
  192. $this->editData($info['zq_u9_id'],['dc_status'=>-1,'update_time'=>time()],$info['number'],1,1,'lpck',$r['msg'][1],$r['msg'][0]);
  193. return $this->logic_tools->ret_arr(-1,"同步料品失败");
  194. }
  195. $dc_params = $r['data'];
  196. //创建调出单
  197. $dcd_res = $this->apiyyv1->dcdCrate($dc_params,$this->getToken(130));
  198. if(empty($dcd_res[0]['Data'][0]["Code"])){
  199. $this->editData($info['zq_u9_id'],['dc_status'=>-1,'update_time'=>time()],$info['number'],1,1,'dc',$dcd_res[1],$dcd_res[0]);
  200. return $this->logic_tools->ret_arr(-1,"创建调出单失败");
  201. }
  202. //更新
  203. $dcd_no = $dcd_res[0]['Data'][0]["Code"];
  204. $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]);
  205. return $this->logic_tools->ret_arr(1,"创建调出单成功");
  206. }
  207. //提交调出单
  208. public function subDc($info){
  209. $r = $this->apiyyv1->dcdSubmit([
  210. 'number'=>$info['dc_no']
  211. ],$this->getToken(130));
  212. if(!$r[0]['Data'][0]['IsSucess']){
  213. $this->editData($info['id'],['dc_status'=>-2,'update_time'=>time()],$info['order_no'],1,2,'dc',$r[1],$r[0]);
  214. return $this->logic_tools->ret_arr(-1,"提交调出单失败");
  215. }
  216. //更新调出单
  217. $this->editData($info['id'],['dc_status'=>2,'update_time'=>time()],$info['order_no'],1,2,'dc',$r[1],$r[0]);
  218. return $this->logic_tools->ret_arr(1,"提交调出单失败");
  219. }
  220. //审核调出单
  221. public function shDc($info){
  222. $rr = $this->apiyyv1->dcdApprove([
  223. 'number'=>$info['dc_no']
  224. ],$this->getToken(130));
  225. if(!$rr[0]['Data'][0]['IsSucess']){
  226. $this->editData($info['id'],['dc_status'=>-3,'update_time'=>time()],$info['order_no'],1,3,'dc',$rr[1],$rr[0]);
  227. return $this->logic_tools->ret_arr(-1,"审核调出单失败");
  228. }
  229. $this->editData($info['id'],['dc_status'=>3,'update_time'=>time()],$info['order_no'],1,3,'dc',$rr[1],$rr[0]);
  230. return $this->logic_tools->ret_arr(1,"审核调出单成功");
  231. }
  232. //创建采购单
  233. public function createCg($info){
  234. //在创建前边执行查询调出单
  235. if($info['dc_data_status'] != 1)
  236. {
  237. $r = $this->xdlsCxDcd($info);
  238. if($r['code']!= 1){
  239. return $this->logic_tools->ret_arr(-1,"调出单未被审核,请先去审核");
  240. }
  241. $info['dc_data'] = json_encode($r['data']['data']);
  242. }
  243. $dc_params = $this->createDataTwo($info);
  244. //创建香港公司的采购单
  245. $cgd_res = $this->apiyyv1->cgdCreate($dc_params,$this->getToken(140));
  246. if(empty($cgd_res[0]['Data'][0]["Code"])){
  247. $this->editData($info['id'],['cg_status'=>-1,'update_time'=>time()],$info['order_no'],3,1,'cg',$cgd_res[1],$cgd_res[0]);
  248. return $this->logic_tools->ret_arr(-1,"创建采购单失败");
  249. }
  250. $this->editData($info['id'],['cg_no'=>$cgd_res[0]['Data'][0]["Code"],'cg_status'=>1,'update_time'=>time()],$info['order_no'],3,1,'cg',$cgd_res[1],$cgd_res[0]);
  251. return $this->logic_tools->ret_arr(1,"创建采购单成功");
  252. }
  253. //提交采购单
  254. public function subCg($info){
  255. $r = $this->apiyyv1->cgdSubmit([
  256. 'number'=>$info['cg_no']
  257. ],$this->getToken(140));
  258. if(!$r[0]['Data'][0]['IsSucess']){
  259. $this->editData($info['id'],['cg_status'=>-2,'update_time'=>time()],$info['order_no'],3,2,'cg',$r[1],$r[0]);
  260. return $this->logic_tools->ret_arr(-1,"提交采购单失败");
  261. }
  262. //更新采购单
  263. $this->editData($info['id'],['cg_status'=>2,'update_time'=>time()],$info['order_no'],3,2,'cg',$r[1],$r[0]);
  264. return $this->logic_tools->ret_arr(1,"提交采购单成功");
  265. }
  266. //审核采购单
  267. public function shCg($info){
  268. $rr = $this->apiyyv1->cgdApprove([
  269. 'number'=>$info['cg_no']
  270. ],$this->getToken(140));
  271. if(!$rr[0]['Data'][0]['IsSucess']){
  272. $this->editData($info['id'],['cg_status'=>-3,'update_time'=>time()],$info['order_no'],3,3,'cg',$rr[1],$rr[0]);
  273. return $this->logic_tools->ret_arr(-1,"审核采购单失败");
  274. }
  275. $this->editData($info['id'],['cg_status'=>3,'update_time'=>time()],$info['order_no'],3,3,'cg',$rr[1],$rr[0]);
  276. return $this->logic_tools->ret_arr(1,"审核采购单成功");
  277. }
  278. //创建销售单
  279. public function createXs($info){
  280. //在创建前边执行查询调出单
  281. if($info['dc_data_status'] != 1)
  282. {
  283. $r = $this->xdlsCxDcd($info);
  284. if($r['code']!= 1){
  285. return $this->logic_tools->ret_arr(-1,"调出单未被审核,请先去审核");
  286. }
  287. $info['dc_data'] = json_encode($r['data']['data']);
  288. }
  289. $dc_params = $this->createDataTwo($info);
  290. //创建许昌成品库的销售单
  291. $xsd_res = $this->apiyyv1->xsdCreate($dc_params,$this->getToken(130));
  292. if(empty($xsd_res[0]['Data'][0]['m_code'])){
  293. $this->editData($info['id'],['xs_status'=>-1,'update_time'=>time()],$info['order_no'],2,1,'xs',$xsd_res[1],$xsd_res[0]);
  294. return $this->logic_tools->ret_arr(-1,"创建销售单失败");
  295. }
  296. //更新销售单数据
  297. $xs_no = $xsd_res[0]['Data'][0]["m_code"];
  298. $this->editData($info['id'],['xs_no'=>$xs_no,'xs_status'=>1,'update_time'=>time()],$info['order_no'],2,1,'xs',$xsd_res[1],$xsd_res[0]);
  299. return $this->logic_tools->ret_arr(1,"创建销售单成功");
  300. }
  301. //提交销售单
  302. public function subXs($info){
  303. $r = $this->apiyyv1->xsdSubmit([
  304. 'number'=>$info['xs_no']
  305. ],$this->getToken(130));
  306. if(!$r[0]['Data'][0]['m_isSucess']){
  307. $this->editData($info['id'],['xs_status'=>-2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  308. return $this->logic_tools->ret_arr(-1,"提交销售单成功");
  309. }
  310. $this->editData($info['id'],['xs_status'=>2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  311. return $this->logic_tools->ret_arr(1,"提交销售单成功");
  312. }
  313. //审核销售单
  314. public function shXs($info){
  315. $rr = $this->apiyyv1->xsdApprove([
  316. 'number'=>$info['xs_no']
  317. ],$this->getToken(130));
  318. if(!$rr[0]['Data'][0]['m_isSucess']){
  319. $this->editData($info['id'],['xs_status'=>-3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  320. return $this->logic_tools->ret_arr(-1,"审核销售单成功");
  321. }
  322. $this->editData($info['id'],['xs_status'=>3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  323. return $this->logic_tools->ret_arr(1,"审核销售单成功");
  324. }
  325. //创建关联销售单
  326. public function createXsTwo($tmp_info){
  327. $time = time();
  328. if(empty($tmp_info['dc_data'])){
  329. return ;
  330. }
  331. $tmp_list = json_decode($tmp_info['dc_data'],true);
  332. if(empty($tmp_list)){
  333. return ;
  334. }
  335. $info = $this->logic_order->getInfoByPlat($tmp_info['platform'],$tmp_info['order_no']);
  336. $info['zq_u9_id'] = $tmp_info['id'];
  337. $info['dc_no'] = $tmp_info['dc_no'];
  338. $info['dc_data'] = $tmp_info['dc_data'];
  339. $total_goods_num = 0;//订单产品总数量
  340. foreach($tmp_list as $k=>$v){
  341. $total_goods_num += $v['costuomqty'];
  342. }
  343. $avg_price = floor(($info['shouldmoney']*1000)/$total_goods_num)/1000;
  344. $list = [];
  345. foreach($tmp_list as $k=>$v){
  346. $list[] = [
  347. 'jm'=>$v['iteminfo_itemcode'],
  348. 'zh'=>$v['iteminfo_itemname'],
  349. 'final_price'=>$avg_price,//目前先不设置 等后期财务说了再说
  350. 'dcsl'=>$v['costuomqty'],
  351. 'is_register'=>0,//商品是否被注册 先都当没注册 后面会先确认下
  352. ];
  353. }
  354. $dc_params = [
  355. 'gys'=>$this->gys,//供应商
  356. 'number'=>$info['number'],//erp订单编码
  357. "TransOutDocType_Code"=>"TransOut001",//组织间调拨
  358. "time"=>$time,
  359. 'TransferDirection'=>0,//普通
  360. 'yyid'=>$tmp_list[0]['descflexfield_pubdescseg2'],//来源店铺 这种需要在店铺表中有
  361. 'shipremarks'=>$tmp_list[0]['descflexfield_pubdescseg5'],//订单的备注
  362. 'dcckbm'=>$this->xdcp_code,//调出仓库编码
  363. 'drckbm'=>$this->xdxgls_code,//调入仓库编码
  364. 'drzz_code'=>$this->xdxgzzcode,//调入组织Code
  365. 'owner_code'=>$this->xdzzcode,//货主组织Code
  366. 'ztcode'=>$this->ztcode,//账套
  367. 'tb_org_arr'=>$this->tb_org_arr,//要同步的组织列表
  368. 'list'=>$list
  369. ];
  370. //创建香港仓的销售单
  371. $xsd_res = $this->apiyyv1->xsdTwoCreate($dc_params,$this->getToken(140));
  372. if(empty($xsd_res[0]['Data'][0]['m_code'])){
  373. $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]);
  374. return $this->logic_tools->ret_arr(-1,"创建香港销售单失败");
  375. }
  376. //更新销售单数据
  377. $xs_no = $xsd_res[0]['Data'][0]["m_code"];
  378. $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]);
  379. return $this->logic_tools->ret_arr(1,"创建香港销售单成功");
  380. }
  381. //提交审关联销售单
  382. public function subXsTwo($info){
  383. $r = $this->apiyyv1->xsdSubmit([
  384. 'number'=>$info['xs_two_no']
  385. ],$this->getToken(140));
  386. if(!$r[0]['Data'][0]['m_isSucess']){
  387. $this->editData($info['id'],['xs_two_status'=>-2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  388. return $this->logic_tools->ret_arr(-1,"提交香港销售单失败");
  389. }
  390. $this->editData($info['id'],['xs_two_status'=>2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  391. return $this->logic_tools->ret_arr(1,"提交香港销售单成功");
  392. }
  393. //审核关联销售单
  394. public function shXsTwo($info){
  395. $rr = $this->apiyyv1->xsdApprove([
  396. 'number'=>$info['xs_two_no']
  397. ],$this->getToken(140));
  398. if(!$rr[0]['Data'][0]['m_isSucess']){
  399. $this->editData($info['id'],['xs_two_status'=>-3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  400. return $this->logic_tools->ret_arr(-1,"审核香港销售单失败");
  401. }
  402. $this->editData($info['id'],['xs_two_status'=>3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  403. return $this->logic_tools->ret_arr(1,"审核香港销售单成功");
  404. }
  405. //创建出货单
  406. public function createCh($info){
  407. $r = $this->apiyyv1->xscsByordernos([$info['xs_two_no']],$this->getToken(140));
  408. if(empty($r[0]['Data'])){
  409. return ;
  410. }
  411. $tmp_list = [];
  412. foreach($r[0]['Data'] as $k=>$v){
  413. $v['dcsl'] = $v['shipplanqtypu'];
  414. $tmp_list[$v['docno']][] = $v;
  415. }
  416. $list = [$info];
  417. $final_list = [];
  418. foreach($tmp_list as $k=>$v){
  419. foreach($list as $item){
  420. if($item['xs_two_no'] == $k){
  421. $final_list[] = [
  422. 'zq_u9_id'=>$item['id'],
  423. 'drckbm'=>$this->xdxgls_code,
  424. 'number'=>$item['order_no'],
  425. 'order_no'=>$item['order_no'],
  426. 'xs_no'=>$k,
  427. 'xs_two_no'=>$k,
  428. 'list'=>$v
  429. ];
  430. }
  431. }
  432. }
  433. $do_data = $final_list[0];
  434. $bzch_res = $this->apiyyv1->bzchCreate($do_data,$this->getToken(140));
  435. if(empty($bzch_res[0]['Data'][0]['m_code'])){
  436. $this->editData($info['id'],['bzch_status'=>-1,'update_time'=>time()],$info['order_no'],4,1,'bzch',$bzch_res[1],$bzch_res[0]);
  437. return $this->logic_tools->ret_arr(-1,"创建标准出货单失败");
  438. }
  439. //更新销售单数据
  440. $bzch_no = $bzch_res[0]['Data'][0]["m_code"];
  441. $this->editData($info['id'],['bzch_no'=>$bzch_no,'bzch_status'=>1,'update_time'=>time()],$info['order_no'],4,1,'bzch',$bzch_res[1],$bzch_res[0]);
  442. return $this->logic_tools->ret_arr(1,"创建标准出货单成功");
  443. }
  444. //提交并审核出货单
  445. public function subAndShCh($info){
  446. $bzch_res = $this->apiyyv1->bzchSubmitAndApprove(['number'=>$info['bzch_no']],$this->getToken(140));
  447. if(empty($bzch_res[0]['Data'][0]['m_code'])){
  448. $this->editData($info['id'],['bzch_status'=>-3,'update_time'=>time()],$info['order_no'],4,3,'bzch',$bzch_res[1],$bzch_res[0]);
  449. return $this->logic_tools->ret_arr(-1,"提交标准出货单失败");
  450. }
  451. //更新销售单数据
  452. $bzch_no = $bzch_res[0]['Data'][0]["m_code"];
  453. $this->editData($info['id'],['bzch_no'=>$bzch_no,'bzch_status'=>3,'update_time'=>time()],$info['order_no'],4,3,'bzch',$bzch_res[1],$bzch_res[0]);
  454. return $this->logic_tools->ret_arr(1,"提交标准出货单成功");
  455. }
  456. //查询调入单
  457. public function createDr($info){
  458. $r = $this->apiyyv1->drdcxBydcd($info['dc_no'],$this->getToken(140));
  459. //如果获取对应调入单没有成功
  460. if(empty($r[0]['Data'][0]['docno'])){
  461. $this->editData($info['id'],['dr_status'=>-1,'update_time'=>time()],$info['order_no'],6,1,'dr',$r[1],$r[0]);
  462. return $this->logic_tools->ret_arr(-1,"审核标准出货单失败");
  463. }
  464. $dr_no = $r[0]['Data'][0]["docno"];
  465. $this->editData($info['id'],['dr_no'=>$dr_no,'dr_status'=>1,'update_time'=>time()],$info['order_no'],6,1,'dr',$r[1],$r[0]);
  466. return $this->logic_tools->ret_arr(1,"审核标准出货单成功");
  467. }
  468. //提交调入单
  469. public function subDr($info){
  470. //提交调入单
  471. $rr = $this->apiyyv1->drdSubmit(['number'=>$info['dr_no']],$this->getToken(140));
  472. if(!$rr[0]['Data'][0]['IsSucess']){
  473. $this->editData($info['id'],['dr_status'=>-2,'update_time'=>time()],$info['order_no'],6,2,'dr',$rr[1],$rr[0]);
  474. return $this->logic_tools->ret_arr(-1,"提交调入单失败");
  475. }
  476. $this->editData($info['id'],['dr_status'=>2,'update_time'=>time()],$info['order_no'],6,2,'dr',$rr[1],$rr[0]);
  477. return $this->logic_tools->ret_arr(1,"提交调入单成功");
  478. }
  479. //审核调入单
  480. public function shDr($info){
  481. //审核调入单
  482. $rrr = $this->apiyyv1->drdApprove(['number'=>$info['dr_no']],$this->getToken(140));
  483. if(!$rrr[0]['Data'][0]['IsSucess']){
  484. $this->editData($info['id'],['dr_status'=>-3,'update_time'=>time()],$info['order_no'],6,3,'dr',$rrr[1],$rrr[0]);
  485. return $this->logic_tools->ret_arr(-1,"审核调入单失败");
  486. }
  487. $this->editData($info['id'],['dr_status'=>3,'update_time'=>time()],$info['order_no'],6,3,'dr',$rrr[1],$rrr[0]);
  488. return $this->logic_tools->ret_arr(1,"审核调入单成功");
  489. }
  490. //检查u9编码是否存在 如果不存在 请先添加并
  491. protected function checkLp($info,$token){
  492. //未注册的货品的列表
  493. $unregister_goods = [];
  494. $r = $this->apiyyv1->getLp($info['list'],$token);
  495. if(!$r[0]['Success']){
  496. return $this->logic_tools->ret_arr(-1,'查询商品信息异常'.json_encode($r,JSON_UNESCAPED_UNICODE));
  497. }
  498. foreach($r[0]['Data'] as $k=>$v)
  499. {
  500. foreach($info['list'] as $kk => $vv){
  501. if($v['m_code'] == $vv['jm']){
  502. $info['list'][$kk]['is_register'] = 1;
  503. $info['list'][$kk]['jm'] = $v['m_code'];
  504. }
  505. }
  506. }
  507. foreach($info['list'] as $k => $v){
  508. if($v['is_register'] == 0){
  509. $unregister_goods[] = $v;
  510. }
  511. }
  512. if(empty($unregister_goods)){
  513. return $this->logic_tools->ret_arr(1,"料品无异常",$info);
  514. }
  515. $tb_info = $info;
  516. $tb_info['list'] = $unregister_goods;
  517. // //return $this->tbXgLp($tb_info,$token);
  518. return $this->tbXgLp($tb_info,$info);
  519. }
  520. //将许昌仓的料品同步到香港仓
  521. public function tbXgLp($tb_info,$info){
  522. $this->cxLp($tb_info);
  523. //先检测料品是否存在
  524. $rr = $this->apiyyv1->tbLp($tb_info,$this->getToken(130));
  525. if($rr[0]['Success']){
  526. return $this->logic_tools->ret_arr(1,$rr,$info);
  527. }else{
  528. return $this->logic_tools->ret_arr(-1,$rr,$info);
  529. }
  530. }
  531. public function cxLp($tb_info){
  532. $apply_list = $tb_info['list'];
  533. $rr = $this->apiyyv1->cxLp($apply_list,$this->getToken(130));
  534. foreach($rr[0]['Data'] as $v){
  535. foreach($apply_list as $kk=>$vv){
  536. if($v['m_code'] == $vv['jm']){
  537. $apply_list[$kk]['is_register'] = 1;
  538. }
  539. }
  540. }
  541. //找出未添加的数组 然后执行去添加
  542. $goods_unadd = [];
  543. foreach($apply_list as $v){
  544. if($v['is_register'] == 0){
  545. $goods_unadd[] = $v;
  546. }
  547. }
  548. if(empty($goods_unadd)){
  549. return ;
  550. }
  551. $tmp_info = $tb_info;
  552. $tmp_info['list'] = $goods_unadd;
  553. //m_code
  554. $this->addLp($tmp_info);
  555. usleep(100);
  556. }
  557. public function addLp($info){
  558. $this->apiyyv1->cjLp($info,$this->getToken(130));
  559. }
  560. //根据返回的状态修改对应的值
  561. protected function editData($zq_u9_id,$z_qu_arr,$number,$one_type,$two_type,$apply_api,$apply_data,$ret_data){
  562. $this->zzquque_u9->save($z_qu_arr,$zq_u9_id);
  563. $this->zzququeu9_logs->insert([
  564. 'oid'=>$zq_u9_id,
  565. 'number'=>$number,
  566. 'one_type'=>$one_type,
  567. 'two_type'=>$two_type,
  568. 'apply_api'=>$apply_api,
  569. 'apply_data'=>json_encode($apply_data,JSON_UNESCAPED_UNICODE),
  570. 'ret_data'=>json_encode($ret_data,JSON_UNESCAPED_UNICODE),
  571. 'create_time'=>time(),
  572. 'read_time'=>date("Y-m-d H:i:s")
  573. ]);
  574. }
  575. //调出单查询并保存
  576. public function xdlsCxDcd($info){
  577. $r = $this->apiyyv1->xdlsCxDcd($info['dc_no'],$this->getToken(130));
  578. if(empty($r[0]['Data'])){
  579. return $this->logic_tools->ret_arr(-1,"该订单还未被审核,请先去审核");
  580. }
  581. //更新销售单数据
  582. $xs_no = json_encode($r[0]['Data']);
  583. $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]);
  584. return $this->logic_tools->ret_arr(1,"审核成功",$r[0]);
  585. }
  586. }