<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

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

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

    public function province()
    {
        return $this->belongsTo(Province::class);
    }

    public function city()
    {
        return $this->belongsTo(City::class);
    }

    public function subdistrict()
    {
        return $this->belongsTo(Subdistrict::class);
    }

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