XLJK-api/app/Models/Review.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Review extends Model
{
    protected $table = 'review_log';
    protected $primaryKey = 'user_id';
//    protected function serializeDate(\DateTimeImmutable $date)
//    {
//        return $date->format('Y-m-d H:i:s');
//    }
    const CREATED_AT = 'creation_date';

    public static function getList(int $id,int $page,int $limit)
    {
        $offset = ($page - 1) * $limit;
        $query = self::query()->where(['user_id'=>$id])->offset($offset)->limit($limit)->get();
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }

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

    public static function del(int $id)
    {
        return self::query()->where('id', $id)->delete();
    }
    public static function getInfoById(int $id,int $userId)
    {
        return self::query()->where(['user_id'=>$userId,'id'=>$id])->first();
    }
    public static function updateLog($where, $updateData)
    {
        return self::query()->where($where)->update($updateData);
    }
}