<?php

namespace App\Models;

use App\Traits\SyncModelBoot;
use Illuminate\Database\Eloquent\Model;

class Order extends Model
{
    protected $guarded = ['id'];
    protected $connection = 'mysql_proj';
    protected $appends = ['full_address'];

    use SyncModelBoot;

    public function customer()
    {
        return $this->belongsTo(Customer::class);
    }

    public function customerAddress()
    {
        return $this->belongsTo(CustomerAddress::class);
    }

    public function subdistrictArea()
    {
        return $this->belongsTo(SubdistrictArea::class);
    }

    public function orderServices()
    {
        return $this->hasMany(OrderService::class);
    }

    public function getTotalPricesAttribute()
    {
        return $this->orderServices->sum('total_price');
    }

    public function getFullAddressAttribute()
    {
        return $this->address . ", "
            . 
            ($this->subdistrict_area_name ? $this->subdistrict_area_name . ", " : "") 
            . 
            ($this->subdistrict ? $this->subdistrict . ", " : "")
            .
            ($this->city ? $this->city . ", " : "")
            .
            ($this->province ? $this->province : "");
    }

    public function budgetPlanDeal()
    {
        return $this->hasOne(BudgetPlan::class)->whereHas('deal');
    }

    public function budgetPlan()
    {
        return $this->hasOne(BudgetPlan::class);
    }

    public function orderStatus()
    {
        return $this->belongsTo(Requirement::class, 'order_status_id');
    }

    public function businessCategory()
    {
        return $this->belongsTo(Requirement::class, 'business_category_id');
    }

    public function leadSource()
    {
        return $this->belongsTo(Requirement::class, 'lead_source_id');
    }

    public function orderChannel()
    {
        return $this->belongsTo(Requirement::class, 'order_channel_id');
    }
}