baseXX/application/wap/model/user/MemberShip.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------

namespace app\wap\model\user;

use traits\ModelTrait;
use basic\ModelBasic;
use think\Db;
use app\wap\model\user\User;
use app\wap\model\user\MemberRecord;


class MemberShip extends ModelBasic
{
    use ModelTrait;

    public static function membershipList(){
        $list=self::where('is_publish',1)->where('is_del',0)->where('type',1)->where('is_free',0)->order('sort DESC')->select();
        $list=$list ? $list->toArray() :[];
        foreach ($list as &$vc){
            $vc['sale']=bcsub($vc['original_price'],$vc['price'],2);
        }
        return $list;
    }

    public static function getUserMember($order,$userInfo){
        $member=self::where('is_publish',1)->where('is_del',0)->where('type',1)->where('id',$order['member_id'])->find();
        if(!$member) return false;
        $is_permanent=0;
        if($member['is_permanent']){
            $is_permanent=1;
            $overdue_time=0;
        }else {
            switch ($userInfo['level']) {
                case 1:
                    $overdue_time = bcadd(bcmul($member['vip_day'], 86400, 0), $userInfo['overdue_time'], 0);
                    break;
                case 0:
                    $overdue_time = bcadd(bcmul($member['vip_day'], 86400, 0),time(),0);
                    break;
            }
        }
        $data=[
            'oid'=>$order['id'],
            'uid'=>$order['uid'],
            'price'=>$member['price'],
            'validity'=>$member['vip_day'],
            'purchase_time'=>time(),
            'is_permanent'=>$is_permanent,
            'is_free'=>$member['is_free'],
            'overdue_time'=>$overdue_time,
            'add_time'=>time(),
        ];
        $res=MemberRecord::set($data);
        if($res) {
            switch ($userInfo['level']) {
                case 1:
                    $res1=User::edit(['overdue_time'=>$overdue_time,'is_permanent'=>$is_permanent],$order['uid'],'uid');
                    break;
                case 0:
                    $res1=User::edit(['level'=>1,'member_time'=>time(),'overdue_time'=>$overdue_time,'is_permanent'=>$is_permanent],$order['uid'],'uid');
                    break;
            }
        }
        $res2=$res && $res1;
        return $res2;
    }

    /**价格最低的会员
     * @return array|false|\PDOStatement|string|\think\Model
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function memberMinOne(){
         $member=self::where('is_publish',1)->where('is_del',0)->where('type',1)->where('is_free',0)->order('price ASC')->find();
        if($member) {
            $member=$member->toArray();
            switch ($member['vip_day']){
                case 30:
                    $member['unit']='月';
                  break;
                case 90:
                    $member['unit']='季';
                   break;
                case 365:
                    $member['unit']='年';
                   break;
                case -1:
                    $member['unit']='永久';
                    break;
            }
        }
        return $member;
    }

    /**
     * 免费
     */
    public static function memberFree($uid){
        $free=self::where('is_publish',1)->where('is_del',0)->where('type',1)->where('is_free',1)->find();
        $data['free']=$free ? $free->toArray() :[];
        $data['is_record'] = 0;
        if($data['free']) {
            $record = MemberRecord::where('uid', $uid)->where('is_free', 1)->find();
            if ($record) $data['is_record'] = 1;
        }
        return $data;
    }

    /**
     * 会员过期
     */
    public static function memberExpiration($uid){
        $user=User::where('uid',$uid)->find();
        if($user['level'] && $user['is_permanent']==0 && bcsub($user['overdue_time'],time(),0)<=0){
                User::edit(['level'=>0,'member_time'=>0],$uid,'uid');
        }
        return true;
    }
}