Groupbuy.php 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  1. <?php
  2. /**
  3. * Niushop商城系统 - 团队十年电商经验汇集巨献!
  4. * =========================================================
  5. * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
  6. * ----------------------------------------------
  7. * 官方网址: https://www.niushop.com
  8. * =========================================================
  9. */
  10. namespace addon\groupbuy\shop\controller;
  11. use app\model\goods\Goods as GoodsModel;
  12. use app\shop\controller\BaseShop;
  13. use addon\groupbuy\model\Groupbuy as GroupbuyModel;
  14. /**
  15. * 团购控制器
  16. */
  17. class Groupbuy extends BaseShop
  18. {
  19. /*
  20. * 团购活动列表
  21. */
  22. public function lists()
  23. {
  24. $model = new GroupbuyModel();
  25. //获取续签信息
  26. if (request()->isAjax()) {
  27. $condition = [
  28. [ 'pg.site_id', '=', $this->site_id ],
  29. [ 'g.goods_state', '=', 1 ],
  30. [ 'g.is_delete', '=', 0 ]
  31. ];
  32. $goods_name = input('goods_name', '');
  33. $status = input('status', '');//团购状态
  34. if ($status) {
  35. $condition[] = [ 'pg.status', '=', $status ];
  36. }
  37. if (!empty($goods_name)) {
  38. $condition[] = [ 'g.goods_name', 'like', '%' . $goods_name . '%' ];
  39. }
  40. $start_time = input('start_time', '');
  41. $end_time = input('end_time', '');
  42. if ($start_time && !$end_time) {
  43. $condition[] = [ 'pg.end_time', '>=', date_to_time($start_time) ];
  44. } elseif (!$start_time && $end_time) {
  45. $condition[] = [ 'pg.start_time', '<=', date_to_time($end_time) ];
  46. } elseif ($start_time && $end_time) {
  47. $start_timestamp = date_to_time($start_time);
  48. $end_timestamp = date_to_time($end_time);
  49. $sql = "pg.start_time between {$start_timestamp} and {$end_timestamp}";
  50. $sql .= " or pg.end_time between {$start_timestamp} and {$end_timestamp}";
  51. $sql .= " or (pg.start_time <= {$start_timestamp} and pg.end_time >= {$end_timestamp})";
  52. $condition[] = [ '', 'exp', \think\facade\Db::raw($sql) ];
  53. }
  54. //排序
  55. $order = input('order', 'create_time');
  56. $sort = input('sort', 'desc');
  57. if ($order == 'create_time') {
  58. $order_by = 'pg.' . $order . ' ' . $sort;
  59. } else {
  60. $order_by = 'pg.' . $order . ' ' . $sort . ',pg.create_time desc';
  61. }
  62. $page = input('page', 1);
  63. $page_size = input('page_size', PAGE_LIST_ROWS);
  64. $list = $model->getGroupbuyPageList($condition, $page, $page_size, $order_by);
  65. return $list;
  66. } else {
  67. return $this->fetch("groupbuy/lists");
  68. }
  69. }
  70. /**
  71. * 添加活动
  72. */
  73. public function add()
  74. {
  75. if (request()->isAjax()) {
  76. //获取商品信息
  77. $groupbuy_data = [
  78. 'site_id' => $this->site_id,
  79. 'start_time' => strtotime(input('start_time', '')),
  80. 'end_time' => strtotime(input('end_time', '')),
  81. 'rule' => input('rule', '')
  82. ];
  83. $goods_list = input('goods_list', '');
  84. $goods_ids = input('goods_ids', '');
  85. $groupbuy_model = new GroupbuyModel();
  86. return $groupbuy_model->addGroupbuy($groupbuy_data, $goods_list, $goods_ids);
  87. } else {
  88. return $this->fetch("groupbuy/add");
  89. }
  90. }
  91. /**
  92. * 编辑活动
  93. */
  94. public function edit()
  95. {
  96. $groupbuy_id = input('groupbuy_id', '');
  97. $groupbuy_model = new GroupbuyModel();
  98. if (request()->isAjax()) {
  99. //获取商品信息
  100. $goods_id = input('goods_id', '');
  101. $goods_model = new GoodsModel();
  102. $goods = $goods_model->getGoodsInfo([ [ 'goods_id', '=', $goods_id ] ], 'goods_name,goods_image,price');
  103. $goods_info = $goods[ 'data' ];
  104. $groupbuy_data = [
  105. 'goods_id' => $goods_id,
  106. 'goods_name' => $goods_info[ 'goods_name' ],
  107. 'goods_image' => $goods_info[ 'goods_image' ],
  108. 'goods_price' => $goods_info[ 'price' ],
  109. 'sku_id' => input('sku_id', ''),
  110. 'groupbuy_price' => input('groupbuy_price', ''),
  111. 'buy_num' => input('buy_num', ''),
  112. 'start_time' => strtotime(input('start_time', '')),
  113. 'end_time' => strtotime(input('end_time', '')),
  114. 'rule' => input('rule', '')
  115. ];
  116. return $groupbuy_model->editGroupbuy($groupbuy_id, $this->site_id, $groupbuy_data);
  117. } else {
  118. //获取团购信息
  119. $condition = [
  120. [ 'pg.groupbuy_id', '=', $groupbuy_id ],
  121. [ 'pg.site_id', '=', $this->site_id ],
  122. [ 'g.goods_state', '=', 1 ],
  123. [ 'g.is_delete', '=', 0 ]
  124. ];
  125. $groupbuy_info = $groupbuy_model->getGroupbuyInfo($condition)[ 'data' ];
  126. if (empty($groupbuy_info)) $this->error('未获取到活动数据', addon_url('groupbuy://shop/groupbuy/lists'));
  127. $this->assign('groupbuy_info', $groupbuy_info);
  128. return $this->fetch("groupbuy/edit");
  129. }
  130. }
  131. /*
  132. * 删除团购活动
  133. */
  134. public function delete()
  135. {
  136. $groupbuy_id = input('groupbuy_id', '');
  137. $groupbuy_model = new GroupbuyModel();
  138. return $groupbuy_model->deleteGroupbuy($groupbuy_id, $this->site_id);
  139. }
  140. /*
  141. * 结束团购活动
  142. */
  143. public function finish()
  144. {
  145. $groupbuy_id = input('groupbuy_id', '');
  146. $groupbuy_model = new GroupbuyModel();
  147. return $groupbuy_model->finishGroupbuy($groupbuy_id, $this->site_id);
  148. }
  149. /**
  150. * 团购推广
  151. */
  152. public function groupbuyUrl()
  153. {
  154. $groupbuy_id = input('groupbuy_id', '');
  155. $groupbuy_model = new GroupbuyModel();
  156. $res = $groupbuy_model->urlQrcode('/pages_promotion/groupbuy/detail', [ 'id' => $groupbuy_id ], 'groupbuy', $this->site_id);
  157. return $res;
  158. }
  159. }