where('is_delete',0) ->where('audit_status','=',1) ->where('start_time','<=',$this_month) ->where('end_time','>=',$from_this_month) ->field('id,img,use_up,target_type,coupon_id,order_at') ->order('order_at asc,id desc') ->limit(0,5) ->select()->toArray()/*->each(function (&$item) use ($userId){ $userWelfare = MemberWelfareDraw::where(['user_id'=>$userId,'target_id'=>$item['id']]) ->whereMonth('create_time','this month') ->field('id,use_status,check_status,user_coupon_id')->find(); $item['has_draw'] = $userWelfare?1:0; $item['draw_record'] = $userWelfare; })*/; $now = Date("Y-m-d H:i:s",time()); foreach ($list as $key=>&$item){ //检查券是否过期 if ($item['target_type'] == 1){ $cp = Coupon::where('coupon_id',$item['coupon_id'])->where('status',1) ->where('audit_status',10)->where('end_time','>',$now)->find(); if (empty($cp)){ unset($list[$key]);continue; } } $userWelfare = MemberWelfareDraw::where(['user_id'=>$userId,'target_id'=>$item['id']]) ->whereMonth('create_time','this month') ->field('id,use_status,check_status,user_coupon_id')->find(); $item['has_draw'] = $userWelfare?1:0; $item['draw_record'] = $userWelfare; } return array_values($list); } }