mccs/app/models/system/SystemStoreMember.php

<?php

namespace app\models\system;

use app\models\user\User;
use crmeb\basic\BaseModel;
use crmeb\traits\ModelTrait;

class SystemStoreMember extends BaseModel
{
    use ModelTrait;

    /**
     * 获取门店会员卡
     * @param int $reg_store_id
     * @return string
     */
    private static function getnextcardno($reg_store_id = 1)
    {
        $max = self::where('reg_store_id', $reg_store_id)->value('max(card_no)');
        $id = bcadd(substr($max, 4), 1);
        return str_pad($reg_store_id, "4", "0", STR_PAD_LEFT) . str_pad($id, 8, "0", STR_PAD_LEFT);
    }

    /**
     * 设置会员卡
     * @param $uid
     * @param int $reg_store_id
     * @return SystemStoreMember|\think\Model
     */
    public static function setstorecardno($uid, $reg_store_id = 1)
    {
        $card_no = self::getnextcardno($reg_store_id);
        $stock_rights = 1;
        User::where('uid', $uid)->update(['reg_store_id' => $reg_store_id]);
        return self::create(compact('uid', 'reg_store_id', 'card_no', 'stock_rights'));
    }

    /**
     * 获取用户会员卡
     * @param $uid
     * @return mixed
     */
    public static function getcardno($uid)
    {
        return self::where('uid', $uid)->value('card_no');
    }

    /**
     * 增加消费
     * @param $uid
     * @param $total_price
     */
    public static function add_consume($uid, $total_price)
    {
        $info = self::where('uid', $uid)->find();

        if (date("Y", time()) != $info['year']) {
            $consume_rights = bcsub(floor(bcdiv(bcadd($total_price, 0, 2), 1000, 2)), $info['use_consume_rights']);
            $data['year'] = date("Y");
            $data['consume_year'] = $total_price;
            return self::where('uid', $uid)->inc('consume_sum', $total_price)->inc('consume_rights', $consume_rights)->update($data);

        } else {
            $consume_rights = bcsub(floor(bcdiv(bcadd($total_price, $info['consume_sum'], 2), 1000, 2)), bcadd($info['use_consume_rights'], $info['consume_rights']));
            return self::where('uid', $uid)->inc('consume_sum', $total_price)->inc('consume_year', $total_price)->inc('consume_rights', $consume_rights)->update();
        }
    }

    public static function lst($where)
    {
        $model = new self;
        $model = $model->alias("a")->join("user b", "a.uid=b.uid", "left");
        if ($where['store_id'] > 0) $model = $model->where('a.reg_store_id', $where['store_id']);
        if ($where['key']) $model = $model->wherelike('b.phone|a.card_no', "%" . $where['key'] . "%");
        $model = $model->field('a.*,b.nickname,b.phone,b.avatar,b.now_money,b.consumer,b.integral');
        $count = $model->count();
        $data = $model->page($where['page'], $where['limit'])->order("a.uid desc")->select()->toarray();
        return compact('count', 'data');
    }
}