RegimentActive.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Http\Requests\Admin\RegimentActive as Request;
  3. use App\Models\RegimentActive as Model;
  4. use App\Models\Regiment;
  5. use App\Models\Product as Product;
  6. use Illuminate\Support\Facades\DB;
  7. /**
  8. * 拼团活动
  9. *
  10. * @author jun
  11. *
  12. */
  13. class RegimentActive extends Auth{
  14. protected function _initialize(){
  15. parent::_initialize();
  16. $this->assign('breadcrumb1','拼团活动');
  17. $this->assign('breadcrumb2','拼团活动列表');
  18. }
  19. /**
  20. * 列表页
  21. *
  22. * */
  23. public function index(Model $Model){
  24. // 接收参数
  25. $name = request('name','');
  26. // 查询条件
  27. $map = [];
  28. // 组合条件
  29. if( $name ) $map[] = ['regiment_active.name','=',$name];
  30. $select = ['regiment_active.*','product.name as product_name'];
  31. // 查询数据
  32. $list = $Model->query()
  33. ->join('product','product.id','=','regiment_active.product_id')
  34. ->where($map)
  35. ->select($select)
  36. ->orderByDesc('regiment_active.id')
  37. ->paginate(config('page_num',10));
  38. // 循环处理数据
  39. foreach ($list as $key => &$value) {
  40. $value['code'] = $Model->idToCode($value['id']);
  41. }
  42. // 分配数据
  43. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  44. $this->assign('list',$list);
  45. // 加载模板
  46. return $this->fetch();
  47. }
  48. /**
  49. * 添加
  50. *
  51. * */
  52. public function add(Request $request, Model $Model, Product $Product){
  53. if( request()->isMethod('post') ){
  54. // 验证参数
  55. $request->scene('add')->validate();
  56. // 接收数据
  57. $product_code = request('product_code','');
  58. $data['product_id'] = $Product->codeToId($product_code);
  59. if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
  60. $data['regiment_price'] = request('regiment_price',0);
  61. $data['quota'] = request('quota','');
  62. $data['name'] = request('name','');
  63. $data['number'] = request('number',0);
  64. $expiration_day = request('expiration_day',0);
  65. $expiration_hours = request('expiration_hours',0);
  66. //$data['expiration'] = $expiration_day * 24 + $expiration_hours;
  67. $data['expiration'] = $expiration_hours;
  68. $data['start_time'] = request('start_time','');
  69. $data['end_time'] = request('end_time','');
  70. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  71. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  72. $data['participation_number'] = request('participation_number',0);
  73. $data['open_people'] = request('open_people',1);
  74. $data['partake_people'] = request('partake_people',1);
  75. $data['exceed_people'] = request('exceed_people',1);
  76. $data['automatic'] = request('automatic',1);
  77. $data['virtually'] = request('virtually',1);
  78. $data['status'] = 1;
  79. $where = [
  80. ['status','=', 1],
  81. ['product_id','=', $data['product_id']],
  82. ['end_time','>=', time()]
  83. ];
  84. $product_res = $Model::query()->where($where)->first();
  85. if ($product_res) return json_send(['code'=>'error','msg'=>'该产品正在参加拼团活动']);
  86. // 写入数据表
  87. $id = $Model->add($data);
  88. // 如果操作失败
  89. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  90. //商户开团
  91. if ($data['automatic'] == 1){
  92. $regimentData = [
  93. 'custom_uid' => 0,
  94. 'active_id' => $id,
  95. 'product_id' => $data['product_id'],
  96. 'status' => 1,
  97. 'start_time' => $data['start_time'],
  98. 'end_time' => $data['start_time'] + $data['expiration']*60*60,
  99. 'update_time' => time(),
  100. 'insert_time' => time(),
  101. ];
  102. $regimentRes = Regiment::query()->where($where)->insert($regimentData);
  103. if (!$regimentRes) return json_send(['code'=>'error','msg'=>'商户开团失败']);
  104. }
  105. // 记录行为
  106. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  107. // 告知结果
  108. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  109. }
  110. // 标签列表
  111. $tagList = [];
  112. $cityList = [];
  113. // 分配数据
  114. $this->assign('cityList',$cityList);
  115. $this->assign('tagList',$tagList);
  116. $this->assign('crumbs','新增');
  117. // 加载模板
  118. return $this->fetch();
  119. }
  120. /**
  121. * 修改
  122. *
  123. * */
  124. public function edit(Request $request,Model $Model,Product $Product){
  125. // 接收参数
  126. $id = request('id',0);
  127. // 查询用户
  128. $oldData = $Model->where(['id'=>$id])->first()->toArray();
  129. // 修改
  130. if(request()->isMethod('post')){
  131. // 验证参数
  132. $request->scene('edit')->validate();
  133. // 接收数据
  134. $product_code = request('product_code','');
  135. $data['product_id'] = $Product->codeToId($product_code);
  136. if (!$data['product_id']) return json_send(['code'=>'error','msg'=>'产品不存在']);
  137. $data['regiment_price'] = request('regiment_price',0);
  138. $data['quota'] = request('quota','');
  139. $data['name'] = request('name','');
  140. $data['number'] = request('number',0);
  141. $expiration_day = request('expiration_day',0);
  142. $expiration_hours = request('expiration_hours',0);
  143. $data['expiration'] = $expiration_day * 24 + $expiration_hours;
  144. $data['start_time'] = request('start_time','');
  145. $data['end_time'] = request('end_time','');
  146. $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : 0;
  147. $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : 0;
  148. $data['participation_number'] = request('participation_number',0);
  149. $data['open_people'] = request('open_people',1);
  150. $data['partake_people'] = request('partake_people',1);
  151. $data['exceed_people'] = request('exceed_people',1);
  152. $data['automatic'] = request('automatic',1);
  153. $data['virtually'] = request('virtually',1);
  154. // 写入数据表
  155. $result = $Model->edit($id,$data);
  156. // 如果操作失败
  157. if( !$result ) return json_send(['code'=>'error','msg'=>'修改失败']);
  158. // 记录行为
  159. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  160. // 告知结果
  161. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  162. }
  163. // 错误告知
  164. if( !$oldData ) return $this->error('查无数据');
  165. $oldData['product_code'] = $Product->idToCode($oldData['product_id']);
  166. $this->assign('oldData',$oldData);
  167. $this->assign('crumbs','修改');
  168. // 加载模板
  169. return $this->fetch();
  170. }
  171. /**
  172. * 修改状态
  173. *
  174. * */
  175. public function set_status(Request $request,Model $Model){
  176. // 验证参数
  177. $request->scene('set_status')->validate();
  178. // 设置状态
  179. $id = request('id',0);
  180. $status = request('status',0);
  181. // 查询用户
  182. $oldData = $Model->where(['id'=>$id])->first();
  183. // 如果用户不存在
  184. if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']);
  185. // 执行修改
  186. $result = $Model->edit($id,['status'=>$status]);
  187. // 提示新增失败
  188. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  189. // 记录行为
  190. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  191. // 告知结果
  192. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  193. }
  194. /**
  195. * 复制
  196. *
  197. * */
  198. public function copy(Request $request,Model $Model,Clockin $Clockin){
  199. // 验证参数
  200. $request->scene('copy')->validate();
  201. // 设置状态
  202. $id = request('id',0);
  203. $time = time();
  204. // 查询
  205. $data = $Model->where(['id'=>$id])->first()->toArray();
  206. if (!$data) json_send(['code'=>'error','msg'=>'复制失败,活动不存在']);
  207. $clockinList = $Clockin->getActiveList($id);
  208. DB::beginTransaction();
  209. try {
  210. unset($data['id']);
  211. $data['status'] = 1;
  212. $data['name'] = $data['name'].'复制';
  213. //复制活动
  214. $newId = $Model->add($data);
  215. if (!$newId){
  216. DB::rollBack();
  217. return json_send(['code'=>'error','msg'=>'复制失败']);
  218. }
  219. if ($clockinList){
  220. foreach ($clockinList as &$clockin){
  221. $clockin['active_id'] = $newId;
  222. $clockin['insert_time'] = $time;
  223. $clockin['update_time'] = $time;
  224. unset($clockin['id']);
  225. }
  226. $re = $Clockin->Query()->insert($clockinList);
  227. if (!$re) return json_send(['code'=>'error','msg'=>'复制失败']);
  228. }
  229. DB::commit();
  230. }catch (\Exception $e){
  231. // 回退数据
  232. DB::rollBack();
  233. // 失败提示
  234. return json_send(['code'=>'error','msg'=>'复制失败','data'=>['error'=>$e->getMessage().$e->getLine()]]);
  235. }
  236. return json_send(['code'=>'success','msg'=>'复制成功','path'=>'']);
  237. }
  238. }