57 lines
1.4 KiB
PHP
57 lines
1.4 KiB
PHP
<?php
|
|
|
|
namespace App\Models\Wilayah;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\SoftDeletes;
|
|
use App\Models\Wilayah\KabupatenKota;
|
|
use App\Models\Wilayah\DesaKelurahan;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
use Illuminate\Database\Eloquent\Builder;
|
|
|
|
class Kecamatan extends Model
|
|
{
|
|
use SoftDeletes;
|
|
|
|
protected $table = 'master_kecamatan';
|
|
|
|
protected $fillable = [
|
|
'kode',
|
|
'nama',
|
|
'path',
|
|
'kabupaten_kota_id',
|
|
];
|
|
|
|
public function kabupatenKota() {
|
|
return $this->belongsTo(KabupatenKota::class, 'kabupaten_kota_id');
|
|
}
|
|
|
|
public function desaKelurahan()
|
|
{
|
|
return $this->hasMany(DesaKelurahan::class, 'kecamatan_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('kecamatan_id')
|
|
->from('core_program_lokasi')
|
|
->where('program_id', $programId)
|
|
->whereNotNull('kecamatan_id');
|
|
});
|
|
});
|
|
});
|
|
}
|
|
}
|