434 lines
18 KiB
PHP
434 lines
18 KiB
PHP
<?php
|
|
|
|
use Illuminate\Support\Facades\Route;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Illuminate\Http\Request;
|
|
|
|
use App\Models\CalonPenerima;
|
|
use App\Models\Dusun;
|
|
use App\Models\PenerimaFinal;
|
|
|
|
use App\Http\Controllers\LandingPageController;
|
|
|
|
use App\Http\Controllers\Admin\AdminController;
|
|
use App\Http\Controllers\Admin\FilterisasiController;
|
|
use App\Http\Controllers\Admin\LaporanController;
|
|
// RT Controllers
|
|
use App\Http\Controllers\Rt\DashboardController as RtDashboardController;
|
|
use App\Http\Controllers\Rt\CalonPenerimaController as RtCalonPenerimaController;
|
|
use App\Http\Controllers\Rt\LaporanController as RtLaporanController;
|
|
|
|
// Manual Password Reset
|
|
use App\Http\Controllers\Auth\ManualPasswordResetController;
|
|
|
|
/*
|
|
|--------------------------------------------------------------------------
|
|
| ROOT / LANDING PAGE PUBLIK
|
|
|--------------------------------------------------------------------------
|
|
*/
|
|
Route::get('/', [LandingPageController::class, 'index'])->name('landing');
|
|
|
|
/*
|
|
|--------------------------------------------------------------------------
|
|
| MANUAL PASSWORD RESET (guest only)
|
|
|--------------------------------------------------------------------------
|
|
*/
|
|
Route::get('/forgot-password', [ManualPasswordResetController::class, 'showForm'])
|
|
->middleware('guest')
|
|
->name('password.request');
|
|
|
|
Route::post('/password/manual/check', [ManualPasswordResetController::class, 'checkEmail'])
|
|
->middleware('guest')
|
|
->name('password.manual.check');
|
|
|
|
Route::post('/password/manual/update', [ManualPasswordResetController::class, 'updatePassword'])
|
|
->middleware('guest')
|
|
->name('password.manual.update');
|
|
|
|
/*
|
|
|--------------------------------------------------------------------------
|
|
| DASHBOARD UTAMA (redirect sesuai role)
|
|
|--------------------------------------------------------------------------
|
|
*/
|
|
Route::get('/dashboard', function () {
|
|
$user = request()->user();
|
|
|
|
if (!$user) {
|
|
return redirect()->route('login');
|
|
}
|
|
|
|
if ($user->role === 'admin') {
|
|
return redirect()->route('admin.dashboard');
|
|
}
|
|
|
|
if ($user->role === 'rt') {
|
|
return redirect()->route('rt.dashboard');
|
|
}
|
|
|
|
abort(403, 'Role tidak dikenali.');
|
|
})->middleware(['auth', 'verified'])->name('dashboard');
|
|
|
|
/*
|
|
|--------------------------------------------------------------------------
|
|
| ADMIN ROUTES (ADMIN ONLY)
|
|
|--------------------------------------------------------------------------
|
|
*/
|
|
Route::middleware(['auth', 'verified', 'is_active'])
|
|
->prefix('admin')
|
|
->name('admin.')
|
|
->group(function () {
|
|
|
|
// DASHBOARD ADMIN
|
|
Route::get('/dashboard', function (Request $request) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$visibleStatuses = ['terkirim', 'sedang_validasi', 'selesai'];
|
|
|
|
$totalWarga = CalonPenerima::whereIn('tracking_status', $visibleStatuses)->count();
|
|
|
|
$totalDusun = Dusun::count();
|
|
|
|
$totalPenerima = CalonPenerima::whereIn('tracking_status', $visibleStatuses)
|
|
->where('status_verifikasi', 'disetujui')
|
|
->count();
|
|
|
|
$totalPending = CalonPenerima::whereIn('tracking_status', $visibleStatuses)
|
|
->where('status_verifikasi', 'pending')
|
|
->count();
|
|
|
|
$statusDistribution = CalonPenerima::select('status_verifikasi as status', DB::raw('COUNT(*) as total'))
|
|
->whereIn('tracking_status', $visibleStatuses)
|
|
->groupBy('status_verifikasi')
|
|
->get();
|
|
|
|
$wargaPerDusun = DB::table('dusuns')
|
|
->leftJoin('rts', 'rts.dusun_id', '=', 'dusuns.id')
|
|
->leftJoin('calon_penerimas', function ($join) use ($visibleStatuses) {
|
|
$join->on('calon_penerimas.rt_id', '=', 'rts.id')
|
|
->whereIn('calon_penerimas.tracking_status', $visibleStatuses);
|
|
})
|
|
->select('dusuns.nama_dusun as dusun', DB::raw('COUNT(calon_penerimas.id) as total'))
|
|
->groupBy('dusuns.id', 'dusuns.nama_dusun')
|
|
->orderBy('dusuns.nama_dusun')
|
|
->get();
|
|
|
|
$topWarga = DB::table('calon_penerimas')
|
|
->join('prediksi_kelayakans', 'prediksi_kelayakans.calon_penerima_id', '=', 'calon_penerimas.id')
|
|
->leftJoin('rts', 'rts.id', '=', 'calon_penerimas.rt_id')
|
|
->leftJoin('dusuns', 'dusuns.id', '=', 'rts.dusun_id')
|
|
->select(
|
|
'calon_penerimas.nik',
|
|
'calon_penerimas.nama_lengkap as nama',
|
|
'calon_penerimas.pekerjaan',
|
|
'dusuns.nama_dusun as dusun',
|
|
'calon_penerimas.penghasilan',
|
|
'prediksi_kelayakans.probability as probabilitas',
|
|
'calon_penerimas.status_verifikasi as status'
|
|
)
|
|
->whereIn('calon_penerimas.tracking_status', $visibleStatuses)
|
|
->orderBy('prediksi_kelayakans.probability', 'desc')
|
|
->limit(10)
|
|
->get();
|
|
|
|
return view('admin.dashboard', compact(
|
|
'totalWarga',
|
|
'totalDusun',
|
|
'totalPenerima',
|
|
'totalPending',
|
|
'statusDistribution',
|
|
'wargaPerDusun',
|
|
'topWarga'
|
|
));
|
|
})->name('dashboard');
|
|
|
|
// DATA WARGA + SEARCH
|
|
Route::get('/data-warga', function (Request $request) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$dusuns = Dusun::orderBy('nama_dusun')->get();
|
|
$q = trim((string) $request->query('q', ''));
|
|
|
|
$wargasQuery = CalonPenerima::with(['rt.dusun', 'prediksiKelayakan', 'user'])
|
|
->whereIn('tracking_status', ['terkirim', 'sedang_validasi', 'selesai', 'ditinjau_ulang'])
|
|
->whereNull('arsip_tahun')
|
|
->latest();
|
|
|
|
if ($q !== '') {
|
|
$wargasQuery->where(function ($sub) use ($q) {
|
|
$sub->where('nik', 'like', "%{$q}%")
|
|
->orWhere('nama_lengkap', 'like', "%{$q}%");
|
|
|
|
$sub->orWhereHas('user', function ($uq) use ($q) {
|
|
$uq->where('name', 'like', "%{$q}%")
|
|
->orWhere('email', 'like', "%{$q}%");
|
|
});
|
|
});
|
|
}
|
|
|
|
$wargas = $wargasQuery->paginate(10)->withQueryString();
|
|
|
|
return view('admin.data-warga', compact('dusuns', 'wargas'));
|
|
})->name('data-warga');
|
|
|
|
// LIHAT ARSIP — harus di atas semua route {id} agar tidak bentrok
|
|
Route::get('/data-warga/arsip', function (Request $request) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$tahun = $request->query('tahun', now()->year);
|
|
$q = trim((string) $request->query('q', ''));
|
|
$daftarTahun = CalonPenerima::whereNotNull('arsip_tahun')
|
|
->distinct()
|
|
->orderByDesc('arsip_tahun')
|
|
->pluck('arsip_tahun');
|
|
|
|
$arsipQuery = CalonPenerima::with(['rt.dusun', 'prediksiKelayakan', 'user'])
|
|
->where('arsip_tahun', $tahun)
|
|
->latest();
|
|
|
|
if ($q !== '') {
|
|
$arsipQuery->where(function ($sub) use ($q) {
|
|
$sub->where('nik', 'like', "%{$q}%")
|
|
->orWhere('nama_lengkap', 'like', "%{$q}%");
|
|
});
|
|
}
|
|
|
|
$arsips = $arsipQuery->paginate(10)->withQueryString();
|
|
|
|
return view('admin.data-warga-arsip', compact('arsips', 'tahun', 'daftarTahun'));
|
|
})->name('data-warga.arsip');
|
|
|
|
// MULAI VALIDASI
|
|
Route::post('/data-warga/{id}/mulai-validasi', function (Request $request, $id) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$warga = CalonPenerima::findOrFail($id);
|
|
|
|
if (!in_array($warga->tracking_status, ['terkirim', 'ditinjau_ulang'])) {
|
|
return back()->with('error', 'Data ini belum bisa masuk tahap validasi.');
|
|
}
|
|
|
|
$warga->update([
|
|
'tracking_status' => 'sedang_validasi',
|
|
'status_verifikasi' => 'pending',
|
|
]);
|
|
|
|
return back()->with('success', 'Proses validasi data telah dimulai.');
|
|
})->name('data-warga.mulai-validasi');
|
|
|
|
// KIRIM HASIL VALIDASI KE RT
|
|
Route::post('/data-warga/{id}/selesai-validasi', function (Request $request, $id) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$warga = CalonPenerima::findOrFail($id);
|
|
|
|
if ($warga->tracking_status !== 'sedang_validasi') {
|
|
return back()->with('error', 'Data ini belum berada pada tahap sedang divalidasi.');
|
|
}
|
|
|
|
if (!in_array($warga->status_verifikasi, ['disetujui', 'ditolak'])) {
|
|
return back()->with('error', 'Hasil akhir belum ditetapkan. Silakan proses filterisasi terlebih dahulu.');
|
|
}
|
|
|
|
$warga->update([
|
|
'tracking_status' => 'selesai',
|
|
]);
|
|
|
|
return back()->with('success', 'Hasil validasi berhasil dikirim ke RT.');
|
|
})->name('data-warga.selesai-validasi');
|
|
|
|
// TERIMA LANGSUNG
|
|
Route::post('/data-warga/{id}/terima', function (Request $request, $id) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$warga = CalonPenerima::findOrFail($id);
|
|
|
|
if (!in_array($warga->tracking_status, ['terkirim', 'sedang_validasi', 'ditinjau_ulang'])) {
|
|
return back()->with('error', 'Status tidak memungkinkan untuk diterima langsung.');
|
|
}
|
|
|
|
$warga->update([
|
|
'tracking_status' => 'selesai',
|
|
'status_verifikasi' => 'disetujui',
|
|
]);
|
|
|
|
return back()->with('success', 'Warga berhasil diterima sebagai penerima BLT-DD.');
|
|
})->name('data-warga.terima');
|
|
|
|
// TOLAK LANGSUNG
|
|
Route::post('/data-warga/{id}/tolak', function (Request $request, $id) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$warga = CalonPenerima::findOrFail($id);
|
|
|
|
if (!in_array($warga->tracking_status, ['terkirim', 'sedang_validasi', 'ditinjau_ulang'])) {
|
|
return back()->with('error', 'Status tidak memungkinkan untuk ditolak langsung.');
|
|
}
|
|
|
|
$warga->update([
|
|
'tracking_status' => 'selesai',
|
|
'status_verifikasi' => 'ditolak',
|
|
]);
|
|
|
|
// Otomatis catat sebagai penerima final dengan status ditolak,
|
|
// agar langsung muncul di Laporan dan tidak ikut Filterisasi.
|
|
PenerimaFinal::updateOrCreate(
|
|
[
|
|
'nik' => $warga->nik,
|
|
'periode_bantuan' => '2026 Triwulan 1',
|
|
],
|
|
[
|
|
'nama_lengkap' => $warga->nama_lengkap ?? '-',
|
|
'no_kk' => $warga->no_kk ?? '-',
|
|
'rt_id' => $warga->rt_id,
|
|
'nomor_rt' => $warga->rt?->nomor_rt ?? null,
|
|
'nama_dusun' => $warga->rt?->dusun?->nama_dusun ?? '-',
|
|
'pekerjaan' => $warga->pekerjaan ?? '-',
|
|
'penghasilan' => $warga->penghasilan ?? 0,
|
|
'jumlah_tanggungan' => $warga->jumlah_tanggungan ?? 0,
|
|
'aset_kepemilikan' => $warga->aset_kepemilikan ?? '-',
|
|
'kondisi_rumah' => $warga->kondisi_rumah ?? 'Tidak Diketahui',
|
|
'meteran_listrik' => $warga->meteran_listrik ?? 'Tidak Diketahui',
|
|
'sumber_air' => $warga->sumber_air ?? 'Tidak Diketahui',
|
|
'bantuan_lain' => $warga->bantuan_lain ?? 'tidak',
|
|
'usia' => $warga->usia ?? 0,
|
|
'probability' => $warga->prediksiKelayakan->probability ?? 0,
|
|
'status_verifikasi' => 'ditolak',
|
|
'tanggal_penetapan' => now()->toDateString(),
|
|
'periode_bantuan' => '2026 Triwulan 1',
|
|
'jumlah_bantuan' => 300000,
|
|
]
|
|
);
|
|
|
|
return back()->with('success', 'Pengajuan warga berhasil ditolak.');
|
|
})->name('data-warga.tolak');
|
|
|
|
// AKTIFKAN KEMBALI
|
|
Route::post('/data-warga/{id}/aktifkan-kembali', function (Request $request, $id) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$warga = CalonPenerima::findOrFail($id);
|
|
|
|
if ($warga->tracking_status !== 'selesai') {
|
|
return back()->with('error', 'Hanya data yang sudah selesai yang bisa diaktifkan kembali.');
|
|
}
|
|
|
|
// Jika warga sebelumnya tercatat sebagai PenerimaFinal dengan status ditolak
|
|
// (hasil tolak langsung dari Data Warga), hapus agar tidak nyangkut di Laporan
|
|
// saat diaktifkan kembali untuk ditinjau ulang.
|
|
PenerimaFinal::where('nik', $warga->nik)
|
|
->where('periode_bantuan', '2026 Triwulan 1')
|
|
->where('status_verifikasi', 'ditolak')
|
|
->delete();
|
|
|
|
$warga->update([
|
|
'tracking_status' => 'ditinjau_ulang',
|
|
'status_verifikasi' => 'pending',
|
|
'arsip_tahun' => null,
|
|
]);
|
|
|
|
return back()->with('success', 'Pengajuan warga berhasil diaktifkan kembali untuk ditinjau ulang.');
|
|
})->name('data-warga.aktifkan-kembali');
|
|
|
|
// ARSIPKAN
|
|
Route::post('/data-warga/{id}/arsipkan', function (Request $request, $id) {
|
|
$user = $request->user();
|
|
|
|
if (!$user || $user->role !== 'admin') {
|
|
abort(403, 'Akses ditolak: hanya Admin.');
|
|
}
|
|
|
|
$warga = CalonPenerima::findOrFail($id);
|
|
|
|
if ($warga->tracking_status !== 'selesai') {
|
|
return back()->with('error', 'Hanya data selesai yang bisa diarsipkan.');
|
|
}
|
|
|
|
$warga->update([
|
|
'arsip_tahun' => now()->year,
|
|
]);
|
|
|
|
return back()->with('success', 'Data berhasil diarsipkan ke tahun ' . now()->year . '.');
|
|
})->name('data-warga.arsipkan');
|
|
|
|
// DATA AKUN
|
|
Route::get('/data-akun', [AdminController::class, 'dataAkun'])->name('data-akun');
|
|
Route::post('/data-akun/{id}/role', [AdminController::class, 'ubahRole'])->name('data-akun.role');
|
|
Route::post('/data-akun/{id}/toggle-aktif', [AdminController::class, 'toggleAktif'])->name('data-akun.toggle-aktif');
|
|
Route::delete('/data-akun/{id}/hapus', [AdminController::class, 'hapusUser'])->name('data-akun.hapus');
|
|
|
|
// FILTERISASI
|
|
Route::get('/filterisasi', [FilterisasiController::class, 'index'])->name('filterisasi');
|
|
Route::post('/filterisasi/tetapkan', [FilterisasiController::class, 'tetapkan'])->name('filterisasi.tetapkan');
|
|
Route::post('/filterisasi/reset', [FilterisasiController::class, 'resetDusun'])->name('filterisasi.reset');
|
|
Route::post('/filterisasi/simpan-periode', [FilterisasiController::class, 'simpanPeriode'])->name('filterisasi.simpanPeriode');
|
|
Route::delete('/filterisasi/hapus-periode/{id}', [FilterisasiController::class, 'hapusPeriode'])->name('filterisasi.hapusPeriode');
|
|
|
|
// LAPORAN ADMIN
|
|
Route::get('/laporan', [LaporanController::class, 'index'])->name('laporan');
|
|
Route::get('/laporan/pdf', [LaporanController::class, 'exportPdf'])->name('laporan.pdf');
|
|
Route::get('/laporan/excel', [LaporanController::class, 'exportExcel'])->name('laporan.excel');
|
|
Route::post('/laporan/kirim-ke-rt', [LaporanController::class, 'kirimKeRt'])->name('laporan.kirim-ke-rt');
|
|
Route::post('/laporan/reset-manual', [LaporanController::class, 'resetManual'])->name('laporan.reset-manual');
|
|
Route::post('/laporan/upload-publik-pdf', [LaporanController::class, 'uploadPublikPdf'])->name('laporan.upload-publik-pdf');
|
|
Route::delete('/laporan/publik-pdf/{id}', [LaporanController::class, 'hapusPublikPdf'])->name('laporan.hapus-publik-pdf');
|
|
Route::delete('/laporan/bersihkan-riwayat-selesai', [LaporanController::class, 'bersihkanRiwayatSelesai'])
|
|
->name('laporan.bersihkan-riwayat-selesai');
|
|
});
|
|
|
|
/*
|
|
|--------------------------------------------------------------------------
|
|
| RT ROUTES (RT ONLY)
|
|
|--------------------------------------------------------------------------
|
|
*/
|
|
Route::middleware(['auth', 'verified', 'is_active'])
|
|
->prefix('rt')
|
|
->name('rt.')
|
|
->group(function () {
|
|
|
|
// DASHBOARD RT
|
|
Route::get('/dashboard', [RtDashboardController::class, 'index'])->name('dashboard');
|
|
|
|
// LAPORAN RT
|
|
Route::get('/laporan', [RtLaporanController::class, 'index'])->name('laporan.index');
|
|
|
|
// AJUKAN DATA KE ADMIN
|
|
Route::patch('/calon-penerima/{calonPenerima}/ajukan', [RtCalonPenerimaController::class, 'ajukan'])
|
|
->name('calon-penerima.ajukan');
|
|
|
|
// RESOURCE RT
|
|
Route::resource('calon-penerima', RtCalonPenerimaController::class);
|
|
});
|
|
|
|
require __DIR__ . '/auth.php'; |