Bargain.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326
  1. <?php
  2. /**
  3. * Niushop商城系统 - 团队十年电商经验汇集巨献!
  4. * =========================================================
  5. * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
  6. * ----------------------------------------------
  7. * 官方网址: https://www.niushop.com
  8. * =========================================================
  9. */
  10. namespace addon\bargain\shop\controller;
  11. use addon\bargain\model\Bargain as BargainModel;
  12. class Bargain extends BaseController
  13. {
  14. /*
  15. * 砍价商品列表
  16. */
  17. public function lists()
  18. {
  19. $model = new BargainModel();
  20. $condition = [
  21. [ 'pb.site_id', '=', $this->site_id ],
  22. [ 'g.goods_state', '=', 1 ],
  23. [ 'g.is_delete', '=', 0 ]
  24. ];
  25. //获取续签信息
  26. if (request()->isAjax()) {
  27. $page = input('page', 1);
  28. $page_size = input('page_size', PAGE_LIST_ROWS);
  29. $status = input('status', '');//砍价状态
  30. if ($status !== '') {
  31. $condition[] = [ 'pb.status', '=', $status ];
  32. }
  33. //商品名称
  34. $goods_name = input('goods_name', '');
  35. if ($goods_name) {
  36. $condition[] = [ 'g.goods_name', 'like', '%' . $goods_name . '%' ];
  37. }
  38. $start_time = input('start_time', '');
  39. $end_time = input('end_time', '');
  40. if ($start_time && !$end_time) {
  41. $condition[] = [ 'pb.end_time', '>=', date_to_time($start_time) ];
  42. } elseif (!$start_time && $end_time) {
  43. $condition[] = [ 'pb.start_time', '<=', date_to_time($end_time) ];
  44. } elseif ($start_time && $end_time) {
  45. $start_timestamp = date_to_time($start_time);
  46. $end_timestamp = date_to_time($end_time);
  47. $sql = "pb.start_time between {$start_timestamp} and {$end_timestamp}";
  48. $sql .= " or pb.end_time between {$start_timestamp} and {$end_timestamp}";
  49. $sql .= " or (pb.start_time <= {$start_timestamp} and pb.end_time >= {$end_timestamp})";
  50. $condition[] = [ '', 'exp', \think\facade\Db::raw($sql) ];
  51. }
  52. //排序
  53. $order = input('order', 'create_time');
  54. $sort = input('sort', 'desc');
  55. if (!empty($sort)) {
  56. $order_by = 'pb.' . $order . ' ' . $sort;
  57. } else {
  58. $order_by = 'pb.create_time desc';
  59. }
  60. $list = $model->getBargainPageList($condition, $page, $page_size, $order_by);
  61. return $list;
  62. } else {
  63. $bargain_status = $model->getBargainStatus();
  64. $this->assign('bargain_status', $bargain_status[ 'data' ]);
  65. $this->forthMenu();
  66. return $this->fetch("bargain/lists");
  67. }
  68. }
  69. /**
  70. * 添加活动
  71. */
  72. public function add()
  73. {
  74. if (request()->isAjax()) {
  75. $common_data = [
  76. 'site_id' => $this->site_id,
  77. 'bargain_name' => input('bargain_name', ''),
  78. 'is_fenxiao' => input('is_fenxiao', ''),
  79. 'buy_type' => input('buy_type', ''),
  80. 'bargain_type' => input('bargain_type', ''),
  81. 'bargain_num' => input('bargain_num', ''),
  82. 'bargain_time' => input('bargain_time', ''),
  83. 'remark' => input('remark', ''),
  84. 'is_own' => input('is_own', ''),
  85. 'start_time' => strtotime(input('start_time', '')),
  86. 'end_time' => strtotime(input('end_time', '')),
  87. 'is_differ_new_user' => input('is_differ_new_user', 0),
  88. 'distinguish' => input('distinguish', 1),
  89. 'new_low' => input('new_low', ''),
  90. 'aged_tall' => input('aged_tall'),
  91. 'aged_fixation' => input('aged_fixation'),
  92. 'bargain_max_num' => input('bargain_max_num', 0),
  93. 'help_bargain_num' => input('help_bargain_num', 0),
  94. ];
  95. $goods = [
  96. 'goods_ids' => input('goods_ids', ''),
  97. 'sku_ids' => input('sku_ids', ''),
  98. ];
  99. $sku_list = input('sku_list', '');
  100. $bargain_model = new BargainModel();
  101. return $bargain_model->addBargain($common_data, $goods, $sku_list);
  102. } else {
  103. $bargain_name = '砍价 ' . date('Y-m-d');
  104. $this->assign('bargain_name', $bargain_name);
  105. return $this->fetch("bargain/add");
  106. }
  107. }
  108. /**
  109. * 编辑活动
  110. */
  111. public function edit()
  112. {
  113. $bargain_model = new BargainModel();
  114. $bargain_id = input('bargain_id', '');
  115. if (request()->isAjax()) {
  116. $common_data = [
  117. 'bargain_id' => $bargain_id,
  118. 'site_id' => $this->site_id,
  119. 'bargain_name' => input('bargain_name', ''),
  120. 'is_fenxiao' => input('is_fenxiao', ''),
  121. 'buy_type' => input('buy_type', ''),
  122. 'bargain_type' => input('bargain_type', ''),
  123. 'bargain_num' => input('bargain_num', ''),
  124. 'bargain_time' => input('bargain_time', ''),
  125. 'remark' => input('remark', ''),
  126. 'is_own' => input('is_own', ''),
  127. 'start_time' => strtotime(input('start_time', '')),
  128. 'end_time' => strtotime(input('end_time', '')),
  129. 'is_differ_new_user' => input('is_differ_new_user', 0),
  130. 'distinguish' => input('distinguish', 1),
  131. 'new_low' => input('new_low', ''),
  132. 'aged_tall' => input('aged_tall'),
  133. 'aged_fixation' => input('aged_fixation'),
  134. 'bargain_max_num' => input('bargain_max_num', 0),
  135. 'help_bargain_num' => input('help_bargain_num', 0),
  136. ];
  137. $sku_list = input('sku_list', '');
  138. $goods = [
  139. 'goods_id' => input('goods_id', ''),
  140. 'sku_ids' => input('sku_ids', ''),
  141. ];
  142. return $bargain_model->editBargain($common_data, $goods, $sku_list);
  143. } else {
  144. //获取砍价信息
  145. $condition = [
  146. [ 'pb.bargain_id', '=', $bargain_id ],
  147. [ 'pb.site_id', '=', $this->site_id ],
  148. [ 'g.goods_state', '=', 1 ],
  149. [ 'g.is_delete', '=', 0 ]
  150. ];
  151. $bargain_info = $bargain_model->getBargainInfo($condition);
  152. if (empty($bargain_info[ 'data' ])) $this->error('未获取到活动数据', addon_url('bargain://shop/bargain/lists'));
  153. $this->assign('bargain_info', $bargain_info[ 'data' ]);
  154. return $this->fetch("bargain/edit");
  155. }
  156. }
  157. /*
  158. * 砍价详情
  159. */
  160. public function detail()
  161. {
  162. $bargain_model = new BargainModel();
  163. $bargain_id = input('bargain_id', '');
  164. //获取砍价信息
  165. $condition = [
  166. [ 'pb.bargain_id', '=', $bargain_id ],
  167. [ 'pb.site_id', '=', $this->site_id ],
  168. [ 'g.goods_state', '=', 1 ],
  169. [ 'g.is_delete', '=', 0 ]
  170. ];
  171. $bargain_info = $bargain_model->getBargainJoinGoodsList($condition);
  172. if (empty($bargain_info[ 'data' ])) $this->error('未获取到活动数据', addon_url('bargain://shop/bargain/lists'));
  173. $this->assign('bargain_info', $bargain_info[ 'data' ]);
  174. return $this->fetch("bargain/detail");
  175. }
  176. /*
  177. * 删除砍价活动
  178. */
  179. public function delete()
  180. {
  181. $bargain_id = input('bargain_id', '');
  182. $bargain_model = new BargainModel();
  183. return $bargain_model->deleteBargain($bargain_id, $this->site_id);
  184. }
  185. /*
  186. * 结束砍价活动
  187. */
  188. public function finish()
  189. {
  190. $bargain_id = input('bargain_id', '');
  191. $bargain_model = new BargainModel();
  192. return $bargain_model->finishBargain($bargain_id, $this->site_id);
  193. }
  194. /**
  195. * 获取商品列表
  196. * @return array
  197. */
  198. public function getSkuList()
  199. {
  200. if (request()->isAjax()) {
  201. $bargain_model = new BargainModel();
  202. $bargain_id = input('bargain_id', '');
  203. $bargain_info = $bargain_model->getBargainGoodsList($bargain_id, $this->site_id);
  204. return $bargain_info;
  205. }
  206. }
  207. /**
  208. * 砍价列表
  209. */
  210. public function launchList()
  211. {
  212. $bargain_id = input('bargain_id', '');
  213. if (request()->isAjax()) {
  214. $goods_name = input('goods_name', '');
  215. $nickname = input('nickname', '');
  216. $start_time = input('start_time', '');
  217. $end_time = input('end_time', '');
  218. $status = input('status', '');//砍价状态
  219. $page = input('page', 1);
  220. $page_size = input('page_size', PAGE_LIST_ROWS);
  221. $bargain_model = new BargainModel();
  222. $condition = [
  223. [ 'site_id', '=', $this->site_id ]
  224. ];
  225. if ($bargain_id) {
  226. $condition[] = [ 'bargain_id', '=', $bargain_id ];
  227. }
  228. if ($status !== '') {
  229. $condition[] = [ 'status', '=', $status ];
  230. }
  231. if ($goods_name) {
  232. $condition[] = [ 'sku_name', 'like', '%' . $goods_name . '%' ];
  233. }
  234. if ($nickname) {
  235. $condition[] = [ 'nickname', 'like', '%' . $nickname . '%' ];
  236. }
  237. if ($start_time && !$end_time) {
  238. $condition[] = [ 'start_time', '>=', date_to_time($start_time) ];
  239. } elseif (!$start_time && $end_time) {
  240. $condition[] = [ 'start_time', '<=', date_to_time($end_time) ];
  241. } elseif ($start_time && $end_time) {
  242. $condition[] = [ 'start_time', 'between', [ date_to_time($start_time), date_to_time($end_time) ] ];
  243. }
  244. $list = $bargain_model->getBargainLaunchPageList($condition, '', 'launch_id desc', $page, $page_size);
  245. return $list;
  246. } else {
  247. $this->assign('bargain_id', $bargain_id);
  248. $this->forthMenu();
  249. return $this->fetch('bargain/launch_list');
  250. }
  251. }
  252. /**
  253. * 帮砍记录
  254. * @return mixed
  255. */
  256. public function launchDetail()
  257. {
  258. $launch_id = input('launch_id', '');
  259. $bargain_model = new BargainModel();
  260. if (request()->isAjax()) {
  261. $page = input('page', 1);
  262. $page_size = input('page_size', PAGE_LIST_ROWS);
  263. $condition = [ [ 'launch_id', '=', $launch_id ] ];
  264. $list = $bargain_model->getBargainRecordPageList($condition, '', 'id desc', $page, $page_size);
  265. return $list;
  266. } else {
  267. $this->assign('launch_id', $launch_id);
  268. //获取发起人信息
  269. $info = $bargain_model->getBargainLaunchDetail([ [ 'launch_id', '=', $launch_id ], [ 'site_id', '=', $this->site_id ] ]);
  270. if (empty($info[ 'data' ])) $this->error('未获取到活动数据', addon_url('bargain://shop/bargain/launchlist'));
  271. $this->assign('info', $info[ 'data' ]);
  272. return $this->fetch('bargain/launch_detail');
  273. }
  274. }
  275. /**
  276. * 砍价推广
  277. */
  278. public function bargainUrl()
  279. {
  280. $bargain_id = input('bargain_id', '');
  281. $bargain_model = new BargainModel();
  282. $res = $bargain_model->urlQrcode('/pages_promotion/bargain/detail', [ 'b_id' => $bargain_id ], 'bargain', $this->site_id);
  283. return $res;
  284. }
  285. }