Queueu9.php 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153
  1. <?php defined('BASEPATH') OR exit('No direct script access allowed');
  2. /**
  3. * 该类执行队列使用
  4. */
  5. class Queueu9 extends Start_Controller {
  6. private $url = "http://git.wepolicy.cn/";
  7. private $api = 20250217;
  8. public function __construct(){
  9. parent::__construct();
  10. $this->load->_model("Model_zzquque_u9",'zzquque_u9');
  11. $this->load->_model("Model_aaconf","aaconf");
  12. $this->load->_model("Model_logic_u9xg",'logic_u9xg');
  13. $this->load->_model("Model_logic_order","logic_order");
  14. $this->load->_model("Model_logic_u9zt","logic_u9zt");
  15. $this->load->_model('Model_classid','classid');
  16. $this->load->_model('Model_typeclass','typeclass');
  17. }
  18. //定义方法的调用规则 获取URI第二段值
  19. public function _remap($arg,$arg_array)
  20. {
  21. $api = $this->input->get('api',true);
  22. if($api != $this->api){
  23. exit('No direct script access allowed');
  24. }
  25. if($arg == 'xdls')//执行小单的流转到临时仓的队列
  26. {
  27. $this->_xdls();
  28. }
  29. if($arg == 'ztdl')//执行在途的队列
  30. {
  31. $this->_zt();
  32. }
  33. else
  34. {
  35. $this->_index();
  36. }
  37. }
  38. public function _index(){
  39. }
  40. //执行小单的流转到临时仓的队列
  41. public function _xdls(){
  42. //第一步生成 许昌成品库的调出单
  43. $list = $this->zzquque_u9->find_all("type = 10 and dc_status = 0 and cg_status = 0 and xs_status = 0 ",'*','id asc');
  44. $do_list = [];
  45. foreach($list as $k=>$v){
  46. $tmp_info = $this->logic_order->getInfoByPlat($v['platform'],$v['order_no']);
  47. $tmp_info['zq_u9_id'] = $v['id'];
  48. $do_list[] = $tmp_info;
  49. }
  50. $this->logic_u9xg->xdlsOneStep($do_list);
  51. //新加一步 查询修改调出单的审核结果
  52. $list = $this->zzquque_u9->find_all("type = 10 and dc_status = 1 and cg_status = 0 and xs_status = 0 ",'*','id asc');
  53. $this->logic_u9xg->xdlsOneExtraStep($list);
  54. //var_dump($list);
  55. //第二步 创建的采购单和销售单
  56. $list = $this->zzquque_u9->find_all("type = 10 and dc_status = 3 and dc_data_status = 1 and cg_status = 0 and xs_status = 0 ");
  57. // var_dump($list);
  58. // die;
  59. //var_dump($list);
  60. $this->logic_u9xg->xdlsTwoStep($list);
  61. //审核销售单和采购单
  62. $list = $this->zzquque_u9->find_all("type = 10 and dc_status = 3 and dc_data_status = 1 and cg_status = 1 and xs_status = 1");
  63. //var_dump($list);
  64. $this->logic_u9xg->xdlsTwoExtraStep($list);
  65. sleep(3);
  66. //第三步 查询调出单生成的调入单是否生成 如果生成了就审核 如果没生成 说明异常了 这种都是按步骤走的
  67. $list = $this->zzquque_u9->find_all("type = 10 and dc_status = 3 and cg_status = 3 and xs_status = 3 and dr_status = 0");
  68. $this->logic_u9xg->xdlsThreeStep($list);
  69. //第四步 建立香港的销售单 标准出库单有源的需要先审核 先创建销售单
  70. $list = $this->zzquque_u9->find_all("type = 10 and dc_status = 3 and cg_status = 3 and xs_status = 3 and dr_status = 3 and xs_two_status = 0 ");
  71. $do_list = [];
  72. foreach($list as $k=>$v){
  73. $tmp_info = $this->logic_order->getInfoByPlat($v['platform'],$v['order_no']);
  74. $tmp_info['zq_u9_id'] = $v['id'];
  75. $tmp_info['dc_no'] = $v['dc_no'];
  76. $tmp_info['dc_data'] = $v['dc_data'];
  77. $do_list[] = $tmp_info;
  78. }
  79. $this->logic_u9xg->xdlsFourStep($do_list);
  80. //执行第五步骤 审核销售单 并同时生成标准出货单
  81. $list = $this->zzquque_u9->find_all("type = 10 and dc_status = 3 and cg_status = 3 and xs_status = 3 and dr_status = 3 and xs_two_status = 1 and bzch_status = 0 ");
  82. if(!empty($list)){
  83. $this->logic_u9xg->xdlsFiveStep($list);
  84. }
  85. sleep(3);
  86. $list = $this->zzquque_u9->find_all("type = 10 and dc_status = 3 and cg_status = 3 and xs_status = 3 and dr_status = 3 and xs_two_status = 3 and bzch_status = 1 ");
  87. $this->logic_u9xg->xdlsSixStep($list);
  88. }
  89. public function _zt(){
  90. echo "<pre>";
  91. $classid = $this->classid->sku();
  92. $tcall = $this->typeclass->find_all();
  93. foreach ($tcall as $v)
  94. {
  95. $tcjm[$v['id']] = array($v['jm'],$v['classid']);
  96. $typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
  97. }
  98. //第一步生成 许昌成品库的调出单
  99. $list = $this->zzquque_u9->find_all("type = 1 and dc_status = 0 and cg_status = 0 and xs_status = 0 ",'*','id asc',0,5);
  100. //ZT250314172219
  101. // $list = $this->zzquque_u9->find_all("order_no = 'ZT250314173250' and cg_status = 0 and xs_status = 0 ",'*','id asc',0,1);
  102. foreach($list as $k=>$v){
  103. $this->logic_u9zt->createdDc($v,$classid,$typeclass);
  104. }
  105. //第二步查询调出但状态
  106. $list = $this->zzquque_u9->find_all("type = 1 and dc_status = 1 and cg_status = 0 and xs_status = 0 ",'*','id asc');
  107. foreach($list as $k=>$v){
  108. $this->logic_u9zt->cxDxcheck($v);
  109. }
  110. //第三步创建销售单和采购单
  111. $list = $this->zzquque_u9->find_all("type = 1 and dc_status = 3 and dc_data_status = 1 and cg_status = 0 and xs_status = 0 ",'*','id asc');
  112. foreach($list as $k=>$v){
  113. $this->logic_u9zt->createXsAndCg($v);
  114. }
  115. sleep(2);
  116. //第四部查询调出单产生的调入单
  117. $list = $this->zzquque_u9->find_all("type = 1 and dc_status = 3 and dc_data_status = 1 and cg_status = 1 and xs_status = 1 and dr_status = 0 ",'*','id asc');
  118. foreach($list as $k=>$v){
  119. $this->logic_u9zt->cxDrByDc($v);
  120. }
  121. //第五步审核产生的销售单和采购单
  122. $list = $this->zzquque_u9->find_all("type = 1 and dc_status = 3 and dc_data_status = 1 and cg_status = 1 and xs_status = 1 and dr_status = 3 ",'*','id asc');
  123. foreach($list as $k=>$v){
  124. $this->logic_u9zt->shCgAndXs($v);
  125. }
  126. //第六步更新在途库存
  127. $list = $this->zzquque_u9->find_all("type = 2 and dc_status = 0 and dc_data_status = 0 and dr_status = 0 ",'*','id asc');
  128. foreach($list as $k=>$v){
  129. $this->logic_u9zt->createDcTwo($v);
  130. }
  131. }
  132. }