Model_logic_u9ztsd.php 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  1. <?php
  2. /**
  3. * 系统自动处理在途库存的香港问题
  4. */
  5. class Model_logic_u9ztsd extends Lin_Model {
  6. public $xczzcode = '130';//许昌销售公司编码
  7. public $xccp_code = '13001';//许昌成品库的编码
  8. public $xgzzcode = '140';//香港组织公司编码
  9. public $xgzt_code = '14001';//香港在途库的编码
  10. public $xgmc_code = '14002';//香港美仓的编码
  11. public $ztcode = '001';//账套的code;
  12. public $tb_org_arr =[140];//同步组织
  13. public $gys = "98002";//供应商 98001 龙盈 98002 龙熠
  14. public $yyid = "98003";
  15. //切记要修改token_120的token真正的token!!!!
  16. function __construct(){
  17. parent::__construct();
  18. $this->load->_model('Model_settingtest','settingtest');
  19. $this->load->_model("Model_apiyyv1",'apiyyv1');
  20. $this->load->_model('Model_classid','classid');
  21. $this->load->_model('Model_typeclass','typeclass');
  22. $this->load->_model('Model_shop','shop');
  23. $this->load->_model('Model_zzquque_u9','zzquque_u9');
  24. $this->load->_model('Model_zzququeu9_logs','zzququeu9_logs');
  25. $this->load->_model('Model_logic_tools','logic_tools');
  26. $this->load->_model('Model_logic_u9tools','logic_u9tools');
  27. $this->load->_model("Model_logic_order","logic_order");
  28. $this->load->_model('Model_whlabeltransport', 'whlabeltransport');
  29. $this->load->_model("Model_logic_ding","logic_ding");
  30. }
  31. public function getToken($type){
  32. $name = "get_yytoken_".$type;
  33. $token = $this->settingtest->$name();
  34. return $token;
  35. }
  36. //转码准备数据
  37. public function transPrepare(){
  38. $classid = $this->classid->sku();
  39. $tcall = $this->typeclass->find_all();
  40. foreach ($tcall as $v)
  41. {
  42. $tcjm[$v['id']] = array($v['jm'],$v['classid']);
  43. $typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
  44. }
  45. return [
  46. 'classid'=>$classid,
  47. 'typeclass'=>$typeclass,
  48. ];
  49. }
  50. //创建调出单
  51. public function createdDc($info){
  52. $pre_data = $this->transPrepare();
  53. $typeclass = $pre_data['typeclass'];
  54. $classid = $pre_data['classid'];
  55. $list = $this->whlabeltransport->find_all("order_no = '".$info['order_no']."'");
  56. $do_flag = true;
  57. foreach($list as $k=>$v){
  58. if($v['cz'] ==1 ){
  59. $do_flag = false;
  60. }
  61. }
  62. if(!$do_flag){
  63. $this->editData($info['id'],[
  64. 'dc_status'=>-1,
  65. 'update_time'=>time()
  66. ],$info['order_no'],1,1,'dc',[],$this->logic_tools->ret_arr(-1,'此单有已经完成的数据,不能进行同步'));
  67. return ;
  68. }
  69. $shipremarks = "";
  70. $dc_list = [];
  71. foreach($list as $k=>$v){
  72. if(stripos($v['features'],'-131-') !== false)
  73. {
  74. continue;
  75. }
  76. $v['features'] = str_replace(array('-163-','-164-','-165-','-166-'),'-',$v['features']);
  77. $shipremarks = $v["text"];
  78. $tmp_ret = $this->logic_u9tools->getOneU9bm($v['features'],$classid,$typeclass);
  79. $dc_list[] =[
  80. 'jm'=>$tmp_ret['jm'],
  81. 'bm'=>$tmp_ret['bm'],
  82. 'zh'=>$tmp_ret['zh'],
  83. 'dcsl'=>$v['num'],
  84. 'is_register'=>0,//商品是否被注册 先都当没注册 后面会先确认下
  85. ];
  86. }
  87. if(empty($dc_list)){
  88. $this->editData($info['id'],[
  89. 'dc_status'=>-1,
  90. 'update_time'=>time()
  91. ],$info['order_no'],1,1,'dc',[],$this->logic_tools->ret_arr(-1,'此单sku转化为u9编码,发现没有匹配数据'));
  92. return ;
  93. }
  94. $time = time();
  95. $dc_params = [
  96. 'gys'=>$this->gys,//供应商
  97. 'number'=>$info['order_no'],//erp订单编码
  98. "TransOutDocType_Code"=>"TransOut001",//组织间调拨
  99. "time"=>$time,
  100. 'TransferDirection'=>0,//普通
  101. 'yyid'=>"",//来源店铺 这种需要在店铺表中有
  102. 'shipremarks'=>$shipremarks,//订单的备注
  103. 'dcckbm'=>$this->xccp_code,//调出仓库编码
  104. 'drckbm'=>$this->xgzt_code,//调入仓库编码
  105. 'drzz_code'=>$this->xgzzcode,//调入组织Code
  106. 'owner_code'=>$this->xczzcode,//货主组织Code
  107. 'ztcode'=>$this->ztcode,//账套
  108. 'tb_org_arr'=>$this->tb_org_arr,//要同步的组织列表
  109. 'list'=>$dc_list
  110. ];
  111. $cxdcd_r = $this->apiyyv1->xcDcdByOtherId($dc_params['number'],$this->getToken(130));
  112. $ret_data = $cxdcd_r[0]['Data'];
  113. //调出单存在就不在执行了
  114. if(isset($ret_data[0])){
  115. $descflexfield_pubdescseg4 = $ret_data[0]['descflexfield_pubdescseg4'];
  116. if($dc_params['number'] == $descflexfield_pubdescseg4){
  117. return $this->logic_tools->ret_arr(-1,"对应的调出单已存在请勿重复操作");
  118. }
  119. }
  120. //检测料品是否在u9被添加 检测香港组织有没有 许昌组织一定要有 没有
  121. $r = $this->checkLp($dc_params,$this->getToken(140));
  122. if($r['code'] !=1){
  123. $this->editData($info['id'],['dc_status'=>-1,'update_time'=>time()],$info['order_no'],1,1,'lpck',$r['msg'][1],$r['msg'][0]);
  124. return $this->logic_tools->ret_arr(-1,"同步料品失败");
  125. }
  126. //创建调出单
  127. $dcd_res = $this->apiyyv1->dcdCrate($dc_params,$this->getToken(130));
  128. if(empty($dcd_res[0]['Data'][0]["Code"])){
  129. $this->editData($info['id'],['dc_status'=>-1,'update_time'=>time()],$info['order_no'],1,1,'dc',$dcd_res[1],$dcd_res[0]);
  130. return $this->logic_tools->ret_arr(-1,"创建调出单失败");
  131. }
  132. //更新
  133. $dcd_no = $dcd_res[0]['Data'][0]["Code"];
  134. $this->editData($info['id'],['dc_no'=>$dcd_no,'dc_status'=>1,'update_time'=>time()],$info['order_no'],1,1,'dc',$dcd_res[1],$dcd_res[0]);
  135. return $this->logic_tools->ret_arr(1,"创建调出单成功");
  136. }
  137. //根据返回的状态修改对应的值
  138. protected function editData($zq_u9_id,$z_qu_arr,$number,$one_type,$two_type,$apply_api,$apply_data,$ret_data){
  139. $this->zzquque_u9->save($z_qu_arr,$zq_u9_id);
  140. $this->zzququeu9_logs->insert([
  141. 'oid'=>$zq_u9_id,
  142. 'number'=>$number,
  143. 'one_type'=>$one_type,
  144. 'two_type'=>$two_type,
  145. 'apply_api'=>$apply_api,
  146. 'apply_data'=>json_encode($apply_data,JSON_UNESCAPED_UNICODE),
  147. 'ret_data'=>json_encode($ret_data,JSON_UNESCAPED_UNICODE),
  148. 'create_time'=>time(),
  149. 'read_time'=>date("Y-m-d H:i:s")
  150. ]);
  151. }
  152. //检查u9编码是否存在 如果不存在 请先添加并
  153. protected function checkLp($info,$token){
  154. //未注册的货品的列表
  155. $unregister_goods = [];
  156. $r = $this->apiyyv1->cxLp($info['list'],$token);
  157. $this->logic_ding->sendToDing("创建料品异常【".json_encode($r));
  158. if(!$r[0]['Success']){
  159. return $this->logic_tools->ret_arr(-1,'查询商品信息异常'.json_encode($r,JSON_UNESCAPED_UNICODE));
  160. }
  161. foreach($r[0]['Data'] as $k=>$v)
  162. {
  163. foreach($info['list'] as $kk => $vv){
  164. if($v['m_code'] == $vv['jm']){
  165. $info['list'][$kk]['is_register'] = 1;
  166. }
  167. }
  168. }
  169. foreach($info['list'] as $k => $v){
  170. if($v['is_register'] == 0){
  171. $unregister_goods[] = $v;
  172. }
  173. }
  174. if(empty($unregister_goods)){
  175. return $this->logic_tools->ret_arr(1,"料品无异常");
  176. }
  177. $tb_info = $info;
  178. $tb_info['list'] = $unregister_goods;
  179. // //return $this->tbXgLp($tb_info,$token);
  180. return $this->tbXgLp($tb_info);
  181. }
  182. //将许昌仓的料品同步到香港仓
  183. public function tbXgLp($tb_info){
  184. $rr = $this->apiyyv1->tbLp($tb_info,$this->getToken(130));
  185. if($rr[0]['Success']){
  186. return $this->logic_tools->ret_arr(1,$rr);
  187. }else{
  188. return $this->logic_tools->ret_arr(-1,$rr);
  189. }
  190. }
  191. }