<?php

namespace App\Carriers\Models;

use App\Bookings\Models\Booking;
use App\Clients\Models\Client;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 *
 *
 * @property int $id
 * @property int|null $mc_number
 * @property int $dot_number
 * @property bool $is_disqualified
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property \Illuminate\Support\Carbon|null $deleted_at
 * @property bool $is_imported
 * @property string|null $legal_name
 * @property string|null $dba_name
 * @property int|null $owned_tractors
 * @property int|null $owned_trailers
 * @property int|null $power_units
 * @property int|null $total_trucks
 * @property int|null $total_trailers
 * @property string|null $contact_email
 * @property string|null $contact_phone
 * @property string|null $contact_cellphone
 * @property string|null $contact_fax
 * @property string|null $physical_address_city
 * @property string|null $physical_address_state_code
 * @property string|null $physical_address_postal_code
 * @property string|null $mailing_address_city
 * @property string|null $mailing_address_state_code
 * @property string|null $mailing_address_postal_code
 * @property string|null $risk_score
 * @property string|null $risk_score_probability
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier onlyTrashed()
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier query()
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereContactCellphone($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereContactEmail($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereContactFax($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereContactPhone($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereDbaName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereDeletedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereDotNumber($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereIsDisqualified($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereIsImported($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereLegalName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereMailingAddressCity($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereMailingAddressPostalCode($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereMailingAddressStateCode($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereMcNumber($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereOwnedTractors($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereOwnedTrailers($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier wherePhysicalAddressCity($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier wherePhysicalAddressPostalCode($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier wherePhysicalAddressStateCode($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier wherePowerUnits($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereRiskScore($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereRiskScoreProbability($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereTotalTrailers($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereTotalTrucks($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier whereUpdatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier withTrashed()
 * @method static \Illuminate\Database\Eloquent\Builder|Carrier withoutTrashed()
 * @mixin \Eloquent
 */
class Carrier extends Model
{
    use SoftDeletes;

    protected $connection = 'newtrul';

    protected $fillable = [
        'dot_number',
        'mc_number',
        'is_imported',
        'legal_name',
        'dba_name',
        'owned_tractors',
        'owned_trailers',
        'power_units',
        'total_trucks',
        'total_trailers',
        'contact_email',
        'contact_phone',
        'contact_cellphone',
        'contact_fax',
        'physical_address_city',
        'physical_address_state_code',
        'physical_address_postal_code',
        'mailing_address_city',
        'mailing_address_state_code',
        'mailing_address_postal_code',
        'risk_score',
        'risk_score_probability',
    ];


    public function inNetwork(Client $client): bool
    {
        return ClientCarrier::query()->where('client_id', $client->id)
            ->where('carrier_id', $this->id)
            ->where('active', true)->exists();
    }


    public function bookings(): BelongsToMany
    {
        return $this->belongsToMany(Booking::class);
    }

    public function preferredLanes(): BelongsToMany
    {
        return $this->belongsToMany(ClientCarrierPreferredLane::class, 'carrier_id', 'id');
    }
}