CouponActiveCoupon.php 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Http\Requests\Admin\Coupon\ActiveCoupon as Request;
  3. use App\Models\Coupon;
  4. use App\Models\Coupon\ActiveCoupon as Model;
  5. use App\Models\Coupon\Active as CouponActive;
  6. /**
  7. * 优惠券配置
  8. *
  9. * @author 刘相欣
  10. *
  11. */
  12. class CouponActiveCoupon extends Auth{
  13. protected function _initialize(){
  14. parent::_initialize();
  15. $this->assign('breadcrumb1','领券活动');
  16. $this->assign('breadcrumb2','优惠券配置');
  17. }
  18. /**
  19. * 列表页
  20. *
  21. * */
  22. public function index(Model $Model,CouponActive $CouponActive,Coupon $Coupon){
  23. // 接收参数
  24. $activeId = request('active_id',0);
  25. $couponCode = request('coupon_code','');
  26. $couponId = $Coupon->codeToId($couponCode);
  27. // 查询条件
  28. $map = [];
  29. // 组合条件
  30. if( $activeId ) $map[] = ['active_id','=',$activeId];
  31. if( $couponId ) $map[] = ['coupon_id','=',$couponId];
  32. // 查询数据
  33. $list = $Model->query()
  34. ->join('coupon','coupon.id','=','coupon_active_coupon.coupon_id')
  35. ->where($map)
  36. ->orderByDesc('id')
  37. ->select(['coupon_active_coupon.*','coupon.name as coupon_name'])
  38. ->paginate(config('page_num',10));
  39. // 循环处理数据
  40. foreach ($list as $key => $value) {
  41. // 优惠券编码
  42. $value['active_name'] = $CouponActive->getOne($value['active_id'],'name');
  43. // 优惠券编码
  44. $value['coupon_code'] = $Coupon->idToCode($value['coupon_id']);
  45. // 重组
  46. $list[$key] = $value;
  47. }
  48. // 获取列表
  49. $activeList = $CouponActive->query()->get(['id','name'])->toArray();
  50. // 分配数据
  51. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  52. $this->assign('activeList',$activeList);
  53. $this->assign('list',$list);
  54. // 加载模板
  55. return $this->fetch();
  56. }
  57. /**
  58. * 添加
  59. *
  60. * */
  61. public function add(Request $request,Model $Model,Coupon $Coupon,CouponActive $CouponActive){
  62. if( request()->isMethod('post') ){
  63. // 验证参数
  64. $request->scene('add')->validate();
  65. // 接收数据
  66. $couponCode = request('coupon_code','');
  67. $data['coupon_id'] = $Coupon->codeToId($couponCode);
  68. $data['active_id'] = request('active_id',0);
  69. // 如果操作失败
  70. if( !$data['coupon_id'] ) return json_send(['code'=>'error','msg'=>'请填写正确的优惠券编码']);
  71. // 查询产品ID是否存在
  72. $oldId = $Model->query()->where([['active_id','=',$data['active_id']],['coupon_id','=',$data['coupon_id']]])->value('id');
  73. // 重复提醒
  74. if( $oldId ) return json_send(['code'=>'error','msg'=>'优惠券编码已存在']);
  75. // 写入数据表
  76. $id = $Model->add($data);
  77. // 如果操作失败
  78. if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']);
  79. // 记录行为
  80. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data);
  81. // 告知结果
  82. return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']);
  83. }
  84. // 获取列表
  85. $activeList = $CouponActive->query()->get(['id','name'])->toArray();
  86. // 分配数据
  87. $this->assign('activeList',$activeList);
  88. $this->assign('crumbs','新增');
  89. // 加载模板
  90. return $this->fetch();
  91. }
  92. /**
  93. * 修改
  94. *
  95. * */
  96. public function edit(Request $request,Model $Model,Coupon $Coupon,CouponActive $CouponActive){
  97. // 接收参数
  98. $id = request('id',0);
  99. // 查询用户
  100. $oldData = $Model->where(['id'=>$id])->first();
  101. // 修改
  102. if(request()->isMethod('post')){
  103. // 验证参数
  104. $request->scene('edit')->validate();
  105. // 接收数据
  106. $couponCode = request('coupon_code','');
  107. $data['coupon_id'] = $Coupon->codeToId($couponCode);
  108. $data['active_id'] = request('active_id',0);
  109. // 如果操作失败
  110. if( !$data['coupon_id'] ) return json_send(['code'=>'error','msg'=>'请填写正确的优惠券编码']);
  111. // 查询产品ID是否存在
  112. $oldId = $Model->query()->where([['active_id','=',$data['active_id']],['coupon_id','=',$data['coupon_id']]])->value('id');
  113. // 重复提醒
  114. if( $oldId && $oldId != $id ) return json_send(['code'=>'error','msg'=>'优惠券编码已存在']);
  115. // 写入数据表
  116. $result = $Model->edit($id,$data);
  117. // 如果操作失败
  118. if( !$result ) return json_send(['code'=>'error','msg'=>'新增失败']);
  119. // 记录行为
  120. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data);
  121. // 告知结果
  122. return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']);
  123. }
  124. // 错误告知
  125. if( !$oldData ) return $this->error('查无数据');
  126. // 优惠券编码
  127. $oldData['coupon_code'] = $Coupon->idToCode($oldData['coupon_id']);
  128. // 获取列表
  129. $activeList = $CouponActive->query()->get(['id','name'])->toArray();
  130. // 分配数据
  131. $this->assign('activeList',$activeList);
  132. $this->assign('oldData',$oldData);
  133. $this->assign('crumbs','修改');
  134. // 加载模板
  135. return $this->fetch();
  136. }
  137. /**
  138. * 修改状态
  139. *
  140. * */
  141. public function set_status(Request $request,Model $Model){
  142. // 验证参数
  143. $request->scene('set_status')->validate();
  144. // 设置状态
  145. $id = request('id',0);
  146. $status = request('status',0);
  147. // 查询用户
  148. $oldData = $Model->where(['id'=>$id])->first();
  149. // 如果用户不存在
  150. if( !$oldData ) return json_send(['code'=>'error','msg'=>'数据不存在']);
  151. // 执行修改
  152. $result = $Model->edit($id,['status'=>$status]);
  153. // 提示新增失败
  154. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  155. // 记录行为
  156. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]);
  157. // 告知结果
  158. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  159. }
  160. }