lachang/app/api/model/member/MemberWelfare.php

<?php

namespace app\api\model\member;

use app\api\model\Coupon;
use app\api\model\UserCoupon;
use app\common\model\member\MemberWelfare as MemberWelfareModel;

/**
 * 会员卡行为操作模型
 * @package app\common\model
 */
class MemberWelfare extends MemberWelfareModel
{
    protected $append = [];


    public static function currMonthWelfare($userId){
        $nextM = mktime(0,0,0,date('m') +1,1,date('Y'));
        $this_month = date('Y-m-d',$nextM - 1 );
        $from_this_month = date('Y-m-01');

       $list =  self::with(['file'])
           ->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);
    }

}