Model_logic_u9xgsd.php 28 KB

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