<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Institution extends Model
{
    protected $table = 'institution';
    protected $primaryKey = 'user_id';

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

        $query = User::query()
            ->where(['status'=>1])
            ->offset($offset)
            ->limit($limit)
            ->get(['user_id','nickname']);
        if ($query) {
            return $query->toArray();
        }else{
            return [];
        }
    }

    public static function insertData(array $data)
    {
        return Institution::query()->insert($data);
    }

    public static function checkInstitution(int $user_id)
    {
        $query = Institution::query()->where(['user_id'=>$user_id,'status'=>1])->first(['user_id','nickname']);

        if ($query) {
            return $query->toArray();
        }else{
            return [];
        }
    }
}