<?php

namespace App\Models;

use App\Classes\General\Interfaces\Documentable;
use App\Classes\General\Interfaces\Contactable;
use App\Classes\ValueObjects\Constants\BusinessType;
use Eloquent;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\HasManyThrough;
use Illuminate\Database\Eloquent\Relations\MorphMany;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Support\Carbon;
use Spatie\Activitylog\Models\Activity;
use Staudenmeir\EloquentHasManyDeep\HasManyDeep;
use Staudenmeir\EloquentHasManyDeep\HasRelationships;

/**
 * Class Company
 *
 * @package App\Models
 * @property Country country_id
 * @property State state_id
 * @property District district_id
 * @property string postcode
 * @property string street_one
 * @property string street_two
 * @property integer billing_type
 * @property int $id
 * @property string $name
 * @property string $reference
 * @property string|null $debtor
 * @property int $type
 * @property int $status
 * @property Carbon|null $deleted_at
 * @property Carbon|null $created_at
 * @property Carbon|null $updated_at
 * @property-read Collection|Activity[] $activities
 * @property-read int|null $activities_count
 * @property-read Collection|Address[] $addresses
 * @property-read int|null $addresses_count
 * @property-read Collection|BankAccount[] $banks
 * @property-read int|null $banks_count
 * @property-read Model|Eloquent $causer
 * @property-read Collection|CompanyModule[] $companyModules
 * @property-read int|null $company_modules_count
 * @property-read Collection|Contact[] $contacts
 * @property-read int|null $contacts_count
 * @property-read Collection|Document[] $documents
 * @property-read int|null $documents_count
 * @property-read Collection|User[] $employees
 * @property-read int|null $employees_count
 * @property-read Model|Eloquent $subject
 * @property-read Model|Eloquent $target
 * @method static Builder|Company newModelQuery()
 * @method static Builder|Company newQuery()
 * @method static \Illuminate\Database\Query\Builder|Company onlyTrashed()
 * @method static Builder|Company query()
 * @method static Builder|Company whereCreatedAt($value)
 * @method static Builder|Company whereDebtor($value)
 * @method static Builder|Company whereDeletedAt($value)
 * @method static Builder|Company whereId($value)
 * @method static Builder|Company whereName($value)
 * @method static Builder|Company whereReference($value)
 * @method static Builder|Company whereStatus($value)
 * @method static Builder|Company whereType($value)
 * @method static Builder|Company whereUpdatedAt($value)
 * @method static \Illuminate\Database\Query\Builder|Company withTrashed()
 * @method static \Illuminate\Database\Query\Builder|Company withoutTrashed()
 * @mixin Eloquent
 */
class Company extends AbstractModel implements Documentable, Contactable
{
    use HasRelationships;
    use SoftDeletes;

    protected $table = 'companies';

    protected $dates = ['deleted_at'];

    /**
     * @return MorphMany
     */
    public function addresses(): morphMany
    {
        return $this->morphMany(Address::class, 'owner');
    }

    /**
     * @return HasMany
     */
    public function companyModules(): hasMany
    {
        return $this->hasMany(CompanyModule::class);
    }

    /**
     * @return hasManyThrough
     */
    public function employees(): hasManyThrough
    {
        return $this->hasManyThrough(User::class, CompanyModule::class, 'company_id', 'company_module_id');
    }

    public function orders()
    {
        return $this->companyModules()->where('type', '=', BusinessType::IMPORTER)->first()->orders->sortByDesc('id');
        $orders = [];

        $this->CompanyModules->each(function ($companyModule) {
            $orders[] = $companyModule->orders->sortByDesc('id');
        });

        return collect($orders);
    }

    /**
     * Has Confirmed orders
     * @return bool
     */
    public function hasConfirmedOrder(): bool
    {
        $importerModule = $this->companyModules()->where('type', BusinessType::IMPORTER)->first();

        if (!$importerModule) {
            return false; // Return false if no relation  found
        }

        $hasConfirmedOrder = $importerModule->orders()
            ->where('status', '!=', 0)
            ->exists();

        return (bool)$hasConfirmedOrder;

    }


    /**
     * @return MorphMany
     */
    public function documents(): morphMany
    {
        return $this->morphMany(Document::class, 'owner');
    }

    /**
     * @return MorphMany
     */
    public function contacts(): morphMany
    {
        return $this->morphMany(Contact::class, 'owner');
    }

    /**
     * @return HasMany
     */
    public function banks(): HasMany
    {
        return $this->HasMany(BankAccount::class, 'company_id');
    }

    /**
     * @return hasManyDeep
     */
    public function parcels(): hasManyDeep
    {
        return $this->hasManyDeep(Package::class, [CompanyModule::class, Order::class, PackingList::class], ['company_id', 'company_module_id', ['owner_type', 'owner_id'], 'packing_list_id'], ['id', 'id', null, 'id']);
    }

}