XLJK-api/app/Models/UserCourse.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class UserCourse extends Model
{
    protected $table = 'user_course';
    protected $primaryKey = 'id';

    const CREATED_AT = 'creation_date';

    public static function getLabel(int $page,int $limit,int $id)
    {
        $offset = ($page - 1) * $limit;
        $query = self::query()->where(['user_course.status'=>1])
            ->leftJoin('course_base','course_base.id','=','user_course.course_id')
            ->orderBy('user_course.created_at','desc')
            ->where('user_course.user_id',$id)
            ->offset($offset)
            ->limit($limit)
            ->get(['course_base.one_level_label']);
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function getListByUserId(int $id)
    {
        $query = self::query()->where(['user_id'=>$id])->get(['course_id']);
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function getOne(int $id,int $course)
    {
        $query = self::query()->where(['user_id'=>$id,'course_id'=>$course])->first();
        if ($query){
            return $query->toArray();
        }else{
            return null;
        }
    }
    public static function insertData(array $data)
    {
        return self::query()->insert($data);
    }

    public static function del(int $id)
    {
        return self::query()->where('id', $id)->delete();
    }
}