<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use OwenIt\Auditing\Contracts\Auditable;

class Kecamatan extends Model implements Auditable
{
    use HasFactory,SoftDeletes;

    use \OwenIt\Auditing\Auditable;

    protected $fillable =   ['kota_id','nama'];

    public function getData($id)
    {
        $data       =$this
                    ->join('kotas', 'kotas.id', 'kecamatans.kota_id')
                    ->join('Provinsis', 'provinsis.id', 'kotas.provinsi_id')
                    ->select('provinsis.nama as provinsi','kotas.nama as kota','kecamatans.id','kecamatans.nama as kecamatan')
                    ->where('kecamatans.kota_id',$id)
                    ->get(); 
        return $data;                
    }

    public function getKotaID($id)
    {
        $data       =$this
                    ->join('kotas', 'kotas.id', 'kecamatans.kota_id')
                    ->join('provinsis', 'provinsis.id', 'kotas.provinsi_id')
                    ->select('kotas.id','kotas.nama as kota', 'provinsis.nama as provinsi')
                    ->where('kecamatans.id',$id)
                    ->first(); 
        return $data;                
    }  
   
}