XLJK-api/app/Models/Course.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Course extends Model
{
    protected $table = 'course_base';
    protected $primaryKey = 'id';

    const CREATED_AT = 'creation_date';

    public static function getList(int $page,int $limit)
    {
        $offset = ($page - 1) * $limit;
        $query = self::query()->where(['status'=>0])->orderBy('created_at','desc')->offset($offset)->limit($limit)->get();
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function isPay(array $list,int $id){
        if (empty($list)){
            return [];
        }
        if (empty($id)){
            $payList = [];
        }else{
            $payList = UserCourse::getListByUserId($id);
            $payList = array_column($payList,'course_id');
        }
        foreach ($list as &$v){
            if (in_array($v['id'],$payList)){
                $v['is_pay'] = 1;
            }else{
                $v['is_pay'] = 0;
            }
        }
        return $list;
    }
    public static function getOne($where)
    {
        $query = self::query()->where($where)->first();
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function getCourse(int $page,int $limit,array $where)
    {
        $offset = ($page - 1) * $limit;
        $where['status'] = 0;
        $query = self::query()->where($where)->orderBy('created_at','desc')->offset($offset)->limit($limit)->get();
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function getPayCountList(int $page,int $limit)
    {
        $offset = ($page - 1) * $limit;
        $query = self::query()->where(['status'=>0])->orderBy('pay_count','desc')->offset($offset)->limit($limit)->get();
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }
    public static function getListByLabel(int $page,int $limit,array $label)
    {
        $offset = ($page - 1) * $limit;
        $query = self::query()
            ->where(['status'=>0])
            ->whereIn('one_level_label',$label)
            ->orderBy('pay_count','desc')
            ->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 countIncrement(int $id,string $column)
    {
        return self::query()->where('id', $id)->increment($column);
    }
}