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: viewmutasipenduduk.php

<?php
/* Database connection start */
session_start();
include_once "../librari/inc.koneksidb.php";
include_once "../librari/inc.librari.php";
$hak_akses = isset($_SESSION['hak_akses']);

/* Database connection end */

// storing  request (ie, get/post) global array to a variable  
$requestData= $_REQUEST;

$columns = array( 
// datatable column index  => database column name
	
	0 => 'id_warga',
    1 => 'id_warga', 
	2 => 'jenis_mutasi',
	3 => 'tanggal',
    4 => 'keteranagan'
);

// getting total number records without any search
$sql = "SELECT * from mutasi_warga";
$query = mysql_query($sql, $koneksiDbs) or die("viewmutasipenduduk.php: get InventoryItems");
$totalData = mysql_num_rows($query);
$totalFiltered = $totalData;  // when there is no search parameter then total number rows = total number filtered rows.

if( !empty($requestData['search']['value']) ) {
	// if there is a search parameter
	$sql = "SELECT * from mutasi_warga where id_warga LIKE '".$requestData['search']['value']."%' OR jenis_mutasi LIKE '".$requestData['search']['value']."%'  LIMIT ".$requestData['start']." ,".$requestData['length']."  ";
	$query=mysql_query($sql, $koneksiDbs) or die("viewmutasipenduduk.php: get PO");
	$totalFiltered = mysql_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result without limit in the query

$query=mysql_query($sql, $koneksiDbs) or die("viewmutasipenduduk.php: get PO"); // again run query with limit
	
} else {

$sql = "SELECT * from mutasi_warga";
	$query=mysql_query($sql, $koneksiDbs) or die("viewmutasipenduduk.php: get PO");
	
}

$data = array();
$no=0;
while( $row=mysql_fetch_array($query) ) { // preparing an array
$no++;
	$id_warga = $row['id_warga'];
	if($row['jenis_mutasi'] == 'masuk' OR $row['jenis_mutasi'] == 'lahir'){
		$sqlwarga ="SELECT * FROM warga where no_ktp = '$id_warga'";
		$querywarga = mysql_query($sqlwarga,$koneksiDbs) or die ("query salah !".mysql_error()); 
		$dataWarga = mysql_fetch_array($querywarga);
	}
	if($row['jenis_mutasi'] == 'keluar' OR $row['jenis_mutasi'] == 'wafat'){
		$sqlwarga ="SELECT * FROM warga_keluar where no_ktp = '$id_warga'";
		$querywarga = mysql_query($sqlwarga,$koneksiDbs) or die ("query salah !".mysql_error()); 
		$dataWarga = mysql_fetch_array($querywarga);
	}
 
	$nestedData=array(); 
	$nestedData[] = '<center>'.$no.'</center>';
	$nestedData[] = $row["id_warga"];
	$nestedData[] = $dataWarga["nama"];
 $nestedData[] = '<td><center>'.$row["jenis_mutasi"].'</center></td>';
	$nestedData[] = '<center>'.tgl_eng_to_ind($row['tanggal']).'</center>';
 
	if ($_SESSION['hak_akses'] == 'admin'){
 $nestedData[] = '<td><center>
 <a href="" id="'.$row['id_warga'].'" name="'.$row['jenis_mutasi'].'" class="open_modal_mutasi btn btn-success btn-xs"> Detail</a>
					
 				 </center></td>';
	}
	else if ($_SESSION['hak_akses'] != 'admin'){
 $nestedData[] = '<td><center>
 <a href="" id="'.$row['id_warga'].'" name="'.$row['jenis_mutasi'].'" class="open_modal_mutasi btn btn-success btn-xs"> lihat</a>
						 </center></td>';

}
	$data[] = $nestedData;
    
}

$json_data = array(
			"draw"            => intval( $requestData['draw'] ),   // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw. 
			"recordsTotal"    => intval( $totalData ),  // total number of records
			"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
			"data"            => $data   // total data array
			);

echo json_encode($json_data);  // send data as json format

Catatan: Mengedit file biner tidak disarankan.

Litespeed Bypass Manager

Buat Folder Baru

Upload File

Isi Folder

Edit File: viewmutasipenduduk.php