58 lines
1.4 KiB
PHP
58 lines
1.4 KiB
PHP
<?php
|
|
|
|
namespace App\Models\Wilayah;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\SoftDeletes;
|
|
use App\Models\Wilayah\Provinsi;
|
|
use App\Models\Wilayah\Kecamatan;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
use Illuminate\Database\Eloquent\Builder;
|
|
|
|
class KabupatenKota extends Model
|
|
{
|
|
use SoftDeletes;
|
|
|
|
protected $table = 'master_kabupaten_kota';
|
|
|
|
protected $fillable = [
|
|
'kode',
|
|
'nama',
|
|
'path',
|
|
'provinsi_id',
|
|
];
|
|
|
|
public function provinsi()
|
|
{
|
|
return $this->belongsTo(Provinsi::class, 'provinsi_id');
|
|
}
|
|
|
|
public function kecamatan()
|
|
{
|
|
return $this->hasMany(Kecamatan::class, 'kabupaten_kota_id');
|
|
}
|
|
|
|
protected static function booted()
|
|
{
|
|
static::addGlobalScope('program', function (Builder $builder) {
|
|
|
|
if (!app()->has('SystemProgram')) {
|
|
return;
|
|
}
|
|
|
|
$programId = app('SystemProgram')->id;
|
|
|
|
$builder->where(function ($query) use ($programId) {
|
|
|
|
$query->whereIn('id', function ($q) use ($programId) {
|
|
$q->select('kabupaten_kota_id')
|
|
->from('core_program_lokasi')
|
|
->where('program_id', $programId)
|
|
->whereNotNull('kabupaten_kota_id');
|
|
});
|
|
});
|
|
});
|
|
}
|
|
}
|