<?php

namespace App\Repositories\Eloquent;

use App\Models\Professional;
use Illuminate\Support\Facades\DB;
use App\Repositories\Interfaces\ProfessionalRepositoryInterface;

class ProfessionalRepository extends BaseRepository implements ProfessionalRepositoryInterface
{

    /**
     * ProfessionalRepository constructor.
     *
     * @param Professional $model
     */
    public function __construct(Professional $model)
    {
        parent::__construct($model);
    }

    public function getByProfession($professionId)
    {
        return $this->model->where('profession_id', $professionId)->get();
    }

    public function getList()
    {
        return DB::table('professionals')
        ->select(DB::raw("CONCAT(user_profiles.first_name,' ',user_profiles.last_name) AS professional_name"), 'professionals.id as professional_id')
        ->leftjoin('user_profiles','user_profiles.user_id','=','professionals.user_id')
        ->orderBy('professional_name','ASC')
        ->pluck('professional_name','professional_id');
    }
}