jucai/app/Repositories/ExplainRepository.php

<?php

namespace App\Repositories;

use App\Models\Explain;
use Prettus\Repository\Eloquent\BaseRepository;

/**
 * Class ExplainRepositoryEloquent.
 *
 * @package namespace App\Repositories;
 */
class ExplainRepository extends BaseRepository
{
    /**
     * Specify Model class name
     *
     * @return string
     */
    public function model()
    {
        return Explain::class;
    }

    /**
     * @param $where array
     * @return null|\Illuminate\Database\Eloquent\Model
     */
    public function getLimitExplains($where, $limit)
    {
        /*return $this->model->when(get_subsite_id()>0, function ($query) {
            $query->whereHas('subsites', function ($query) { $query->where('subsite_id', get_subsite_id());});
        })->where($where)->orderByRaw('list_order asc, ID desc')->limit($limit)->get();*/
        return $this->model->whereHas('subsites', function ($query) {
            $query->where('subsite_id', get_subsite_id());
        })->where($where)->orderByRaw('list_order desc, created_at desc')->limit($limit)->get();
    }
    public function getExplainInfo($where)
    {
        /*return $this->model->when(get_subsite_id()>0, function ($query) {
            $query->whereHas('subsites', function ($query) { $query->where('subsite_id', get_subsite_id());});
        })->where($where)->first();*/
        return $this->model->whereHas('subsites', function ($query) {
            $query->where('subsite_id', get_subsite_id());
        })->where($where)->first();
    }
    public function getWhere($where)
    {
        /*return $this->model->with(['show_category'])->when(get_subsite_id()>0, function ($query) {
            $query->whereHas('subsites', function ($query) {
                $query->where('subsite_id', get_subsite_id());
            });
        })->where($where)->orderBy('list_order', 'asc')->orderBy('id', 'desc')->get();*/
        return $this->model->with(['show_category'])->whereHas('subsites', function ($query) {
                $query->where('subsite_id', get_subsite_id());
        })->where($where)->orderBy('list_order', 'desc')->orderBy('created_at', 'desc')->get();
    }
    public function incrementData($where, $num, $filed)
    {
        return $this->model->where($where)->increment($filed, $num);
    }


}