<?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 Kota extends Model implements Auditable
{
    use HasFactory,SoftDeletes;

    use \OwenIt\Auditing\Auditable;

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

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