XLJK-api/app/Models/User.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    protected $table = 'user_info';

    public static function getList(int $page, int $limit,int $identity)
    {
        $offset = ($page - 1) * $limit;

        $query = User::query()
            ->where(['identity'=>$identity])
            ->offset($offset)
            ->limit($limit)
            ->get(['id','nickname','desc','avater']);
        if ($query) {
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function getInfoByOpenid(string $openid){
        $query = User::query()->where(['openid'=>$openid])->first(['id','nickname','desc','avater','identity','session_key']);
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function getInfoById(int $id){
        $query = User::query()->where(['id'=>$id])->first(['id','nickname','desc','avater','identity','openid']);
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function insert(array $data){
        $query = User::query()->insertGetId($data);
        if ($query) {
            return $query;
        }else{
            return false;
        }
    }
    public static function updateById(int $id,array $data){
        $query = User::query()->where('id',$id)->update($data);
        if ($query) {
            return true;
        }else{
            return false;
        }
    }
    public static function updateByOpenid(string $openid,array $data){
        $query = User::query()->where('openid',$openid)->update($data);
        if ($query) {
            return true;
        }else{
            return false;
        }
    }
    public static function getUserListInUserIds(array $id){
        $query = User::query()->whereIn('id',$id)->get(['id','nickname','avater']);
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
}