CustomCoupon.php 3.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. <?php namespace App\Http\Controllers\Admin;
  2. use App\Models\Custom;
  3. use App\Models\CustomCoupon as Model;
  4. use App\Models\Coupon as Coupon;
  5. use App\Http\Requests\Admin\CustomCoupon as Request;
  6. /**
  7. * 优惠券管理
  8. *
  9. * @author 刘相欣
  10. *
  11. */
  12. class CustomCoupon 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,Coupon $Coupon,Custom $Custom){
  23. // 接受参数
  24. $code = request('coupon_code','');
  25. $customCode = request('custom_code','');
  26. $startTime = request('start_time','');
  27. $endTime = request('end_time','');
  28. $status = request('status');
  29. // 编码转ID
  30. $couponId = $code ? $Coupon->codeToId($code) : 0;
  31. $customUid = $customCode ? $Custom->codeToId($customCode) : 0;
  32. // 查询条件
  33. $map = [];
  34. // 编码ID
  35. if( $couponId ) $map[] = ['coupon.id','=',$couponId];
  36. if( $customUid ) $map[] = ['custom_coupon.custom_uid','=',$customUid];
  37. if( $startTime ) $map[] = ['custom_coupon.insert_time','>=',strtotime($startTime)];
  38. if( $endTime ) $map[] = ['custom_coupon.insert_time','<=',strtotime($endTime)];
  39. if( !is_null($status) ) $map[] = ['custom_coupon.status','=',$status];
  40. // 查询数据
  41. $list = $Model
  42. ->query()->join('coupon','custom_coupon.coupon_id','=','coupon.id')
  43. ->where($map)
  44. ->orderBy('custom_coupon.status')
  45. ->orderByDesc('custom_coupon.id')
  46. ->select(['custom_coupon.id','coupon.id as coupon_id','coupon.name as coupon_name','coupon.type_id','coupon.rebate_type','coupon.std_pay','coupon.rebate','custom_coupon.status','custom_coupon.custom_uid','custom_coupon.exp_time'])
  47. ->paginate(request('limit',config('page_num',10)))
  48. ->appends(request()->all());
  49. // 循环处理数据
  50. foreach ($list as $key => $value) {
  51. // id转编号
  52. $value['coupon_code']= $Coupon->idToCode($value['coupon_id']);
  53. // id转编号
  54. $value['custom_code'] = $Custom->idToCode($value['custom_uid']);
  55. // 如果过期时间
  56. if( $value['status'] == 0 && ( $value['exp_time']>0 && $value['exp_time']< time() ) ) {
  57. // 状态设置
  58. $Model->edit($value['id'],['status'=>3]);
  59. // 状态设置
  60. $value['status'] = 3;
  61. }
  62. // 重组
  63. $list[$key] = $value;
  64. }
  65. // 分配数据
  66. $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
  67. $this->assign('list', $list);
  68. // 加载模板
  69. return $this->fetch();
  70. }
  71. /**
  72. * 状态
  73. *
  74. * */
  75. public function set_status( Request $request, Model $Model){
  76. // 验证参数
  77. $request->scene('set_status')->validate();
  78. // 接收参数
  79. $id = request('id',0);
  80. $status = request('status',0);
  81. // 查询数据
  82. $result = $Model->edit($id,['status'=>$status]);
  83. // 提示新增失败
  84. if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']);
  85. // 记录行为
  86. $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,[],['status'=>$status]);
  87. // 告知结果
  88. return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
  89. }
  90. }