assign('breadcrumb1','营销管理'); $this->assign('breadcrumb2','客户优惠券'); } /** * 首页列表 * * */ public function index(Model $Model,Coupon $Coupon,Custom $Custom){ // 接受参数 $code = request('coupon_code',''); $customCode = request('custom_code',''); $startTime = request('start_time',''); $endTime = request('end_time',''); $status = request('status'); // 编码转ID $couponId = $code ? $Coupon->codeToId($code) : 0; $customUid = $customCode ? $Custom->codeToId($customCode) : 0; // 查询条件 $map = []; // 编码ID if( $couponId ) $map[] = ['coupon.id','=',$couponId]; if( $customUid ) $map[] = ['custom_coupon.custom_uid','=',$customUid]; if( $startTime ) $map[] = ['custom_coupon.insert_time','>=',strtotime($startTime)]; if( $endTime ) $map[] = ['custom_coupon.insert_time','<=',strtotime($endTime)]; if( !is_null($status) ) $map[] = ['custom_coupon.status','=',$status]; // 查询数据 $list = $Model ->query()->join('coupon','custom_coupon.coupon_id','=','coupon.id') ->where($map) ->orderBy('custom_coupon.status') ->orderByDesc('custom_coupon.id') ->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']) ->paginate(request('limit',config('page_num',10))) ->appends(request()->all()); // 循环处理数据 foreach ($list as $key => $value) { // id转编号 $value['coupon_code']= $Coupon->idToCode($value['coupon_id']); // id转编号 $value['custom_code'] = $Custom->idToCode($value['custom_uid']); // 如果过期时间 if( $value['status'] == 0 && ( $value['exp_time']>0 && $value['exp_time']< time() ) ) { // 状态设置 $Model->edit($value['id'],['status'=>3]); // 状态设置 $value['status'] = 3; } // 重组 $list[$key] = $value; } // 分配数据 $this->assign('empty', '~~暂无数据'); $this->assign('list', $list); // 加载模板 return $this->fetch(); } /** * 状态 * * */ public function set_status( Request $request, Model $Model){ // 验证参数 $request->scene('set_status')->validate(); // 接收参数 $id = request('id',0); $status = request('status',0); // 查询数据 $result = $Model->edit($id,['status'=>$status]); // 提示新增失败 if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']); // 记录行为 $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,[],['status'=>$status]); // 告知结果 return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']); } }