Model_logic_u9xgsd.php 31 KB

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