<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use App\Models\traits\SetConnection;

class Buyer extends Model
{
    protected $fillable = ['user_id', 'name'];

    use SetConnection;

    public function articles()
    {
        return $this->hasMany(RelationBuyerArticle::class);
    }

    public static function getDataByUser()
    {
        $buyer = Buyer::query();
        $buyer->select('buyers.*');
        $buyer->leftJoin('users', 'users.id', '=', 'buyers.user_id');
        $buyer->where('users.company_id', '=', auth()->user()->company_id);
        $buyer->where('users.id', '=', auth()->user()->id);
        $res = $buyer->get();
        return $res;
    }
}