Model_logic_u9xgsd.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624
  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. //创建调出单
  196. $dcd_res = $this->apiyyv1->dcdCrate($dc_params,$this->getToken(130));
  197. if(empty($dcd_res[0]['Data'][0]["Code"])){
  198. $this->editData($info['zq_u9_id'],['dc_status'=>-1,'update_time'=>time()],$info['number'],1,1,'dc',$dcd_res[1],$dcd_res[0]);
  199. return $this->logic_tools->ret_arr(-1,"创建调出单失败");
  200. }
  201. //更新
  202. $dcd_no = $dcd_res[0]['Data'][0]["Code"];
  203. $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]);
  204. return $this->logic_tools->ret_arr(1,"创建调出单成功");
  205. }
  206. //提交调出单
  207. public function subDc($info){
  208. $r = $this->apiyyv1->dcdSubmit([
  209. 'number'=>$info['dc_no']
  210. ],$this->getToken(130));
  211. if(!$r[0]['Data'][0]['IsSucess']){
  212. $this->editData($info['id'],['dc_status'=>-2,'update_time'=>time()],$info['order_no'],1,2,'dc',$r[1],$r[0]);
  213. return $this->logic_tools->ret_arr(-1,"提交调出单失败");
  214. }
  215. //更新调出单
  216. $this->editData($info['id'],['dc_status'=>2,'update_time'=>time()],$info['order_no'],1,2,'dc',$r[1],$r[0]);
  217. return $this->logic_tools->ret_arr(1,"提交调出单失败");
  218. }
  219. //审核调出单
  220. public function shDc($info){
  221. $rr = $this->apiyyv1->dcdApprove([
  222. 'number'=>$info['dc_no']
  223. ],$this->getToken(130));
  224. if(!$rr[0]['Data'][0]['IsSucess']){
  225. $this->editData($info['id'],['dc_status'=>-3,'update_time'=>time()],$info['order_no'],1,3,'dc',$rr[1],$rr[0]);
  226. return $this->logic_tools->ret_arr(-1,"审核调出单失败");
  227. }
  228. $this->editData($info['id'],['dc_status'=>3,'update_time'=>time()],$info['order_no'],1,3,'dc',$rr[1],$rr[0]);
  229. return $this->logic_tools->ret_arr(1,"审核调出单成功");
  230. }
  231. //创建采购单
  232. public function createCg($info){
  233. //在创建前边执行查询调出单
  234. if($info['dc_data_status'] != 1)
  235. {
  236. $r = $this->xdlsCxDcd($info);
  237. if($r['code']!= 1){
  238. return $this->logic_tools->ret_arr(-1,"调出单未被审核,请先去审核");
  239. }
  240. $info['dc_data'] = json_encode($r['data']['data']);
  241. }
  242. $dc_params = $this->createDataTwo($info);
  243. //创建香港公司的采购单
  244. $cgd_res = $this->apiyyv1->cgdCreate($dc_params,$this->getToken(140));
  245. if(empty($cgd_res[0]['Data'][0]["Code"])){
  246. $this->editData($info['id'],['cg_status'=>-1,'update_time'=>time()],$info['order_no'],3,1,'cg',$cgd_res[1],$cgd_res[0]);
  247. return $this->logic_tools->ret_arr(-1,"创建采购单失败");
  248. }
  249. $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]);
  250. return $this->logic_tools->ret_arr(1,"创建采购单成功");
  251. }
  252. //提交采购单
  253. public function subCg($info){
  254. $r = $this->apiyyv1->cgdSubmit([
  255. 'number'=>$info['cg_no']
  256. ],$this->getToken(140));
  257. if(!$r[0]['Data'][0]['IsSucess']){
  258. $this->editData($info['id'],['cg_status'=>-2,'update_time'=>time()],$info['order_no'],3,2,'cg',$r[1],$r[0]);
  259. return $this->logic_tools->ret_arr(-1,"提交采购单失败");
  260. }
  261. //更新采购单
  262. $this->editData($info['id'],['cg_status'=>2,'update_time'=>time()],$info['order_no'],3,2,'cg',$r[1],$r[0]);
  263. return $this->logic_tools->ret_arr(1,"提交采购单成功");
  264. }
  265. //审核采购单
  266. public function shCg($info){
  267. $rr = $this->apiyyv1->cgdApprove([
  268. 'number'=>$info['cg_no']
  269. ],$this->getToken(140));
  270. if(!$rr[0]['Data'][0]['IsSucess']){
  271. $this->editData($info['id'],['cg_status'=>-3,'update_time'=>time()],$info['order_no'],3,3,'cg',$rr[1],$rr[0]);
  272. return $this->logic_tools->ret_arr(-1,"审核采购单失败");
  273. }
  274. $this->editData($info['id'],['cg_status'=>3,'update_time'=>time()],$info['order_no'],3,3,'cg',$rr[1],$rr[0]);
  275. return $this->logic_tools->ret_arr(1,"审核采购单成功");
  276. }
  277. //创建销售单
  278. public function createXs($info){
  279. //在创建前边执行查询调出单
  280. if($info['dc_data_status'] != 1)
  281. {
  282. $r = $this->xdlsCxDcd($info);
  283. if($r['code']!= 1){
  284. return $this->logic_tools->ret_arr(-1,"调出单未被审核,请先去审核");
  285. }
  286. $info['dc_data'] = json_encode($r['data']['data']);
  287. }
  288. $dc_params = $this->createDataTwo($info);
  289. //创建许昌成品库的销售单
  290. $xsd_res = $this->apiyyv1->xsdCreate($dc_params,$this->getToken(130));
  291. if(empty($xsd_res[0]['Data'][0]['m_code'])){
  292. $this->editData($info['id'],['xs_status'=>-1,'update_time'=>time()],$info['order_no'],2,1,'xs',$xsd_res[1],$xsd_res[0]);
  293. return $this->logic_tools->ret_arr(-1,"创建销售单失败");
  294. }
  295. //更新销售单数据
  296. $xs_no = $xsd_res[0]['Data'][0]["m_code"];
  297. $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]);
  298. return $this->logic_tools->ret_arr(1,"创建销售单成功");
  299. }
  300. //提交销售单
  301. public function subXs($info){
  302. $r = $this->apiyyv1->xsdSubmit([
  303. 'number'=>$info['xs_no']
  304. ],$this->getToken(130));
  305. if(!$r[0]['Data'][0]['m_isSucess']){
  306. $this->editData($info['id'],['xs_status'=>-2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  307. return $this->logic_tools->ret_arr(-1,"提交销售单成功");
  308. }
  309. $this->editData($info['id'],['xs_status'=>2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  310. return $this->logic_tools->ret_arr(1,"提交销售单成功");
  311. }
  312. //审核销售单
  313. public function shXs($info){
  314. $rr = $this->apiyyv1->xsdApprove([
  315. 'number'=>$info['xs_no']
  316. ],$this->getToken(130));
  317. if(!$rr[0]['Data'][0]['m_isSucess']){
  318. $this->editData($info['id'],['xs_status'=>-3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  319. return $this->logic_tools->ret_arr(-1,"审核销售单成功");
  320. }
  321. $this->editData($info['id'],['xs_status'=>3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  322. return $this->logic_tools->ret_arr(1,"审核销售单成功");
  323. }
  324. //创建关联销售单
  325. public function createXsTwo($tmp_info){
  326. $time = time();
  327. if(empty($tmp_info['dc_data'])){
  328. return ;
  329. }
  330. $tmp_list = json_decode($tmp_info['dc_data'],true);
  331. if(empty($tmp_list)){
  332. return ;
  333. }
  334. $info = $this->logic_order->getInfoByPlat($tmp_info['platform'],$tmp_info['order_no']);
  335. $info['zq_u9_id'] = $tmp_info['id'];
  336. $info['dc_no'] = $tmp_info['dc_no'];
  337. $info['dc_data'] = $tmp_info['dc_data'];
  338. $total_goods_num = 0;//订单产品总数量
  339. foreach($tmp_list as $k=>$v){
  340. $total_goods_num += $v['costuomqty'];
  341. }
  342. $avg_price = floor(($info['shouldmoney']*1000)/$total_goods_num)/1000;
  343. $list = [];
  344. foreach($tmp_list as $k=>$v){
  345. $list[] = [
  346. 'jm'=>$v['iteminfo_itemcode'],
  347. 'zh'=>$v['iteminfo_itemname'],
  348. 'final_price'=>$avg_price,//目前先不设置 等后期财务说了再说
  349. 'dcsl'=>$v['costuomqty'],
  350. 'is_register'=>0,//商品是否被注册 先都当没注册 后面会先确认下
  351. ];
  352. }
  353. $dc_params = [
  354. 'gys'=>$this->gys,//供应商
  355. 'number'=>$info['number'],//erp订单编码
  356. "TransOutDocType_Code"=>"TransOut001",//组织间调拨
  357. "time"=>$time,
  358. 'TransferDirection'=>0,//普通
  359. 'yyid'=>$tmp_list[0]['descflexfield_pubdescseg2'],//来源店铺 这种需要在店铺表中有
  360. 'shipremarks'=>$tmp_list[0]['descflexfield_pubdescseg5'],//订单的备注
  361. 'dcckbm'=>$this->xdcp_code,//调出仓库编码
  362. 'drckbm'=>$this->xdxgls_code,//调入仓库编码
  363. 'drzz_code'=>$this->xdxgzzcode,//调入组织Code
  364. 'owner_code'=>$this->xdzzcode,//货主组织Code
  365. 'ztcode'=>$this->ztcode,//账套
  366. 'tb_org_arr'=>$this->tb_org_arr,//要同步的组织列表
  367. 'list'=>$list
  368. ];
  369. //创建香港仓的销售单
  370. $xsd_res = $this->apiyyv1->xsdTwoCreate($dc_params,$this->getToken(140));
  371. if(empty($xsd_res[0]['Data'][0]['m_code'])){
  372. $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]);
  373. return $this->logic_tools->ret_arr(-1,"创建香港销售单失败");
  374. }
  375. //更新销售单数据
  376. $xs_no = $xsd_res[0]['Data'][0]["m_code"];
  377. $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]);
  378. return $this->logic_tools->ret_arr(1,"创建香港销售单成功");
  379. }
  380. //提交审关联销售单
  381. public function subXsTwo($info){
  382. $r = $this->apiyyv1->xsdSubmit([
  383. 'number'=>$info['xs_two_no']
  384. ],$this->getToken(140));
  385. if(!$r[0]['Data'][0]['m_isSucess']){
  386. $this->editData($info['id'],['xs_two_status'=>-2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  387. return $this->logic_tools->ret_arr(-1,"提交香港销售单失败");
  388. }
  389. $this->editData($info['id'],['xs_two_status'=>2,'update_time'=>time()],$info['order_no'],2,2,'xs',$r[1],$r[0]);
  390. return $this->logic_tools->ret_arr(1,"提交香港销售单成功");
  391. }
  392. //审核关联销售单
  393. public function shXsTwo($info){
  394. $rr = $this->apiyyv1->xsdApprove([
  395. 'number'=>$info['xs_two_no']
  396. ],$this->getToken(140));
  397. if(!$rr[0]['Data'][0]['m_isSucess']){
  398. $this->editData($info['id'],['xs_two_status'=>-3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  399. return $this->logic_tools->ret_arr(-1,"审核香港销售单失败");
  400. }
  401. $this->editData($info['id'],['xs_two_status'=>3,'update_time'=>time()],$info['order_no'],2,3,'xs',$rr[1],$rr[0]);
  402. return $this->logic_tools->ret_arr(1,"审核香港销售单成功");
  403. }
  404. //创建出货单
  405. public function createCh($info){
  406. $r = $this->apiyyv1->xscsByordernos([$info['xs_two_no']],$this->getToken(140));
  407. if(empty($r[0]['Data'])){
  408. return ;
  409. }
  410. $tmp_list = [];
  411. foreach($r[0]['Data'] as $k=>$v){
  412. $v['dcsl'] = $v['shipplanqtypu'];
  413. $tmp_list[$v['docno']][] = $v;
  414. }
  415. $list = [$info];
  416. $final_list = [];
  417. foreach($tmp_list as $k=>$v){
  418. foreach($list as $item){
  419. if($item['xs_two_no'] == $k){
  420. $final_list[] = [
  421. 'zq_u9_id'=>$item['id'],
  422. 'drckbm'=>$this->xdxgls_code,
  423. 'number'=>$item['order_no'],
  424. 'order_no'=>$item['order_no'],
  425. 'xs_no'=>$k,
  426. 'xs_two_no'=>$k,
  427. 'list'=>$v
  428. ];
  429. }
  430. }
  431. }
  432. $do_data = $final_list[0];
  433. $bzch_res = $this->apiyyv1->bzchCreate($do_data,$this->getToken(140));
  434. if(empty($bzch_res[0]['Data'][0]['m_code'])){
  435. $this->editData($info['id'],['bzch_status'=>-1,'update_time'=>time()],$info['order_no'],4,1,'bzch',$bzch_res[1],$bzch_res[0]);
  436. return $this->logic_tools->ret_arr(-1,"创建标准出货单失败");
  437. }
  438. //更新销售单数据
  439. $bzch_no = $bzch_res[0]['Data'][0]["m_code"];
  440. $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]);
  441. return $this->logic_tools->ret_arr(1,"创建标准出货单成功");
  442. }
  443. //提交并审核出货单
  444. public function subAndShCh($info){
  445. $bzch_res = $this->apiyyv1->bzchSubmitAndApprove(['number'=>$info['bzch_no']],$this->getToken(140));
  446. if(empty($bzch_res[0]['Data'][0]['m_code'])){
  447. $this->editData($info['id'],['bzch_status'=>-3,'update_time'=>time()],$info['order_no'],4,3,'bzch',$bzch_res[1],$bzch_res[0]);
  448. return $this->logic_tools->ret_arr(-1,"提交标准出货单失败");
  449. }
  450. //更新销售单数据
  451. $bzch_no = $bzch_res[0]['Data'][0]["m_code"];
  452. $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]);
  453. return $this->logic_tools->ret_arr(1,"提交标准出货单成功");
  454. }
  455. //查询调入单
  456. public function createDr($info){
  457. $r = $this->apiyyv1->drdcxBydcd($info['dc_no'],$this->getToken(140));
  458. //如果获取对应调入单没有成功
  459. if(empty($r[0]['Data'][0]['docno'])){
  460. $this->editData($info['id'],['dr_status'=>-1,'update_time'=>time()],$info['order_no'],6,1,'dr',$r[1],$r[0]);
  461. return $this->logic_tools->ret_arr(-1,"审核标准出货单失败");
  462. }
  463. $dr_no = $r[0]['Data'][0]["docno"];
  464. $this->editData($info['id'],['dr_no'=>$dr_no,'dr_status'=>1,'update_time'=>time()],$info['order_no'],6,1,'dr',$r[1],$r[0]);
  465. return $this->logic_tools->ret_arr(1,"审核标准出货单成功");
  466. }
  467. //提交调入单
  468. public function subDr($info){
  469. //提交调入单
  470. $rr = $this->apiyyv1->drdSubmit(['number'=>$info['dr_no']],$this->getToken(140));
  471. if(!$rr[0]['Data'][0]['IsSucess']){
  472. $this->editData($info['id'],['dr_status'=>-2,'update_time'=>time()],$info['order_no'],6,2,'dr',$rr[1],$rr[0]);
  473. return $this->logic_tools->ret_arr(-1,"提交调入单失败");
  474. }
  475. $this->editData($info['id'],['dr_status'=>2,'update_time'=>time()],$info['order_no'],6,2,'dr',$rr[1],$rr[0]);
  476. return $this->logic_tools->ret_arr(1,"提交调入单成功");
  477. }
  478. //审核调入单
  479. public function shDr($info){
  480. //审核调入单
  481. $rrr = $this->apiyyv1->drdApprove(['number'=>$info['dr_no']],$this->getToken(140));
  482. if(!$rrr[0]['Data'][0]['IsSucess']){
  483. $this->editData($info['id'],['dr_status'=>-3,'update_time'=>time()],$info['order_no'],6,3,'dr',$rrr[1],$rrr[0]);
  484. return $this->logic_tools->ret_arr(-1,"审核调入单失败");
  485. }
  486. $this->editData($info['id'],['dr_status'=>3,'update_time'=>time()],$info['order_no'],6,3,'dr',$rrr[1],$rrr[0]);
  487. return $this->logic_tools->ret_arr(1,"审核调入单成功");
  488. }
  489. //检查u9编码是否存在 如果不存在 请先添加并
  490. protected function checkLp($info,$token){
  491. //未注册的货品的列表
  492. $unregister_goods = [];
  493. $r = $this->apiyyv1->cxLp($info['list'],$token);
  494. if(!$r[0]['Success']){
  495. return $this->logic_tools->ret_arr(-1,'查询商品信息异常'.json_encode($r,JSON_UNESCAPED_UNICODE));
  496. }
  497. foreach($r[0]['Data'] as $k=>$v)
  498. {
  499. foreach($info['list'] as $kk => $vv){
  500. if($v['m_code'] == $vv['jm']){
  501. $info['list'][$kk]['is_register'] = 1;
  502. }
  503. }
  504. }
  505. foreach($info['list'] as $k => $v){
  506. if($v['is_register'] == 0){
  507. $unregister_goods[] = $v;
  508. }
  509. }
  510. if(empty($unregister_goods)){
  511. return $this->logic_tools->ret_arr(1,"料品无异常");
  512. }
  513. $tb_info = $info;
  514. $tb_info['list'] = $unregister_goods;
  515. // //return $this->tbXgLp($tb_info,$token);
  516. return $this->tbXgLp($tb_info);
  517. }
  518. //将许昌仓的料品同步到香港仓
  519. public function tbXgLp($tb_info){
  520. $this->cxLp($tb_info);
  521. //先检测料品是否存在
  522. $rr = $this->apiyyv1->tbLp($tb_info,$this->getToken(130));
  523. if($rr[0]['Success']){
  524. return $this->logic_tools->ret_arr(1,$rr);
  525. }else{
  526. return $this->logic_tools->ret_arr(-1,$rr);
  527. }
  528. }
  529. public function cxLp($tb_info){
  530. $apply_list = $tb_info['list'];
  531. $rr = $this->apiyyv1->cxLp($apply_list,$this->getToken(130));
  532. foreach($rr[0]['Data'] as $v){
  533. foreach($apply_list as $kk=>$vv){
  534. if($v['m_code'] == $vv['jm']){
  535. $apply_list[$kk]['is_register'] = 1;
  536. }
  537. }
  538. }
  539. //找出未添加的数组 然后执行去添加
  540. $goods_unadd = [];
  541. foreach($apply_list as $v){
  542. if($v['is_register'] == 0){
  543. $goods_unadd[] = $v;
  544. }
  545. }
  546. if(empty($goods_unadd)){
  547. return ;
  548. }
  549. $tmp_info = $tb_info;
  550. $tmp_info['list'] = $goods_unadd;
  551. //m_code
  552. $this->addLp($tmp_info);
  553. usleep(100);
  554. }
  555. public function addLp($info){
  556. $this->apiyyv1->cjLp($info,$this->getToken(130));
  557. }
  558. //根据返回的状态修改对应的值
  559. protected function editData($zq_u9_id,$z_qu_arr,$number,$one_type,$two_type,$apply_api,$apply_data,$ret_data){
  560. $this->zzquque_u9->save($z_qu_arr,$zq_u9_id);
  561. $this->zzququeu9_logs->insert([
  562. 'oid'=>$zq_u9_id,
  563. 'number'=>$number,
  564. 'one_type'=>$one_type,
  565. 'two_type'=>$two_type,
  566. 'apply_api'=>$apply_api,
  567. 'apply_data'=>json_encode($apply_data,JSON_UNESCAPED_UNICODE),
  568. 'ret_data'=>json_encode($ret_data,JSON_UNESCAPED_UNICODE),
  569. 'create_time'=>time(),
  570. 'read_time'=>date("Y-m-d H:i:s")
  571. ]);
  572. }
  573. //调出单查询并保存
  574. public function xdlsCxDcd($info){
  575. $r = $this->apiyyv1->xdlsCxDcd($info['dc_no'],$this->getToken(130));
  576. if(empty($r[0]['Data'])){
  577. return $this->logic_tools->ret_arr(-1,"该订单还未被审核,请先去审核");
  578. }
  579. //更新销售单数据
  580. $xs_no = json_encode($r[0]['Data']);
  581. $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]);
  582. return $this->logic_tools->ret_arr(1,"审核成功",$r[0]);
  583. }
  584. }