1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 |
- <?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);
- }
- }
|