NN2022060401/app/common/model/UserInfo.php

<?php
// +----------------------------------------------------------------------
// | 商城系统 [ 致力于通过产品和服务，帮助商家高效化开拓市场 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2017~2021 https://www.thinkphp.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed 这不是一个自由软件，不允许对程序代码以任何形式任何目的的再发行
// +----------------------------------------------------------------------
// | Author: thinkphp <admin@yiovo.com>
// +----------------------------------------------------------------------
declare (strict_types=1);

namespace app\common\model;

use cores\BaseModel;
use think\facade\Cache;
use think\model\relation\HasOne;

/**
 * 用户资料模型类
 * Class UserInfo
 * @package app\common\model
 */
class UserInfo extends BaseModel
{
    protected $globalScope = [''];

    // 定义表名
    protected $name = 'user_info';

    // 定义主键
    protected $pk = 'id';

    /**
     * 指定的手机号是否已存在
     * @param string $mobile
     * @return bool
     */
    public static function checkExistByIdcard(string $idcard): bool
    {
        $model = new static;
        return (bool)$model->alias('a')
            ->leftJoin('user u','u.user_id=a.user_id')
            ->where('a.idcard', '=', $idcard)
            ->where('u.is_delete', '=', 0)
            ->value('a.user_id');
    }

    /**
     * 身份证预览图
     * @param $value
     * @return string|string[]|null
     */
    public function getIdcardFrontImgAttr($value): string
    {
        return $value? getPreview($value) : '';
    }

    /**
     * 招生学校
     * @return HasOne
     */
    public function school(): HasOne
    {
        return $this->hasOne("School", 'id', 'school_id')->field('id,school_name,logo')->bind(['school_name']);
    }

    /**
     * 生源学校
     * @return HasOne
     */
    public function sourceSchool(): HasOne
    {
        return $this->hasOne("SourceShool", 'source_shools_id', 'school_id')->field('source_shools_id as id,source_shools_name as school_name')->bind(['school_name']);
    }

    /**
     * 默认每天解锁的用户
     * @param $userId
     * @return array|false|string[]
     */
    public static function getLockedIds($userId)
    {
        $ids = self::where(['user_id'=> $userId])->value('day_locked_uids');
        $ids = $ids? explode(',', $ids) : [];
        return $ids;
    }


}