BAB V KESIMPULAN DAN SARAN A. Kesimpulanrepository.upy.ac.id/741/5/Dokumen BAB V dan Daftar Pustaka + Lampiran...metode pengetesan Alfa dari 30 responden. Menghasilkan Sistem yang

87

BAB V

KESIMPULAN DAN SARAN

A. Kesimpulan

Dari hasil penelitian ini, dapat diambil kesimpulan bahwa :

1. Sistem ini dibuat dengan menggunakan HTML, MYSQL dan PHP. HTML

merupakan salah satu format yang digunakan dalam pembuatan dokumen

dan aplikasi yang berjalan dihalaman web. MYSQL merupakan software

yang tergolong database server dan bersifat Open Source dan dapat

dijalankan pada berbagai sistem operasi. PHP adalah bahasa pemrograman

berbasis web yang memiliki kemampuan untuk memproses data

dinamis. Sehingga, menghasilkan website yang dapat menampung Sistem

Informasi Geografis pembangunan fisik PNPM berbasis web.

2. Pengujian Sistem menggunakan metode pengetesan kotak hitam dan

metode pengetesan Alfa dari 30 responden. Menghasilkan Sistem yang

mudah dioperasikan dengan tampilan menarik, dan bermanfaat yang dapat

dilihat dari grafik pengujian sistem.

.

B. Saran

Saran yang dapat diberikan untuk pengembangan sistem ini selanjutnya adalah

sebagai berikut :

1. Pencarian dapat dilakukan berdasarkan nama kegiatan dan sumber dana

sehingga lebih memudahkan pengguna.

2. Form pengambilan koordinat dan form tambah data menjadi satu halaman.

88

DAFTAR PUSTAKA

Jogiyanto. 2001. Analisis & Desain Sistem Informasi : pendekatan terstruktur

teori dan praktek aplikasi bisnis. Andi, Yogyakarta.

Kadir, Abdul. 2009. From ZeRO tO a PRO Membuat Aplikasi Web dengan PHP

dan Database MySQL. Yogyakarta : Andi Offset.

Kadir, Abdul. 2009. Pengenalan Sistem Informasi. Yogyakarta : Andi.

Ladjamudin, bin Albahra. 2005. Analisis dan Design Sistem Informasi.

Yogyakarta : Graha Ilmu

Nugroho, Adi. 2002. Analisis dan perancangan sistem informasi dengan

metodologi berorientasi objek. Informatika, Bandung.

Nugroho, Bunafit. 2009. PHP & MySQL (Aplikasi Pemrograman Web Dinamis).

Yogyakarta : Penerbit Gava Media.

Nugroho, Bunafit. 2007. Trik dan Rahasia Membuat Aplikasi Web dengan PHP.

Yogyakarta : Penerbit Gava Media.

Nur Mardika Sari, Wulan. 2010. Membangun aplikasi sistem informasi geografis

berbasis desktop untuk sentra industri kerajinan bantul Yogyakarta.

Skripsi. Yogyakarta: Sekolah Tinggi Manajemen Informatika Dan

Komputer AmikomYogyakarta.

Prahasta, Eddy. 2002. Sistem Informasi Geografis: Konsep-Konsep Dasar

Informasi Goegrafis. Bandung : Informatika Bandung.

Romadhona, Y. 2010. Sistem komputerisasi realisasi penggunaan dana pnpm

mandiri pada pemerintah kabupaten kulon progo berbasis client server

menggunakan delphi dan mysql. Skripsi. Yogyakarta: IST Akprind

Yogyakarta.

Waljiyanto.2000. Sistem basis data: analisis dan pemodelan data.

Skripsi.Yogyakarta: Universitas Negeri Malang.

Widarningsih, Dwi. 2010. Sistem Informasi Geografis Inventarisasi Jembatan

Dinas Pekerjaan Umum Kabupaten Belitung Barat Berbasis Desktp.

Skripsi. Yogyakarta: Sekolah Tinggi Manajemen Informatika Dan

Komputer AmikomYogyakarta.

http://www.pnpm-mandiri.org/index.php diakses tanggal 5 November 2014 pukul

20.44.

http://ie.akprind.ac.id/publikasi?f%5bauthor%5d=71

http://www.pnpm-mandiri.org/index.php

LAMPIRAN

Index.php <?php

error_reporting(E_ALL &! E_NOTICE);

session_start();

require_once("pages/koneksi.php");

//require_once("../pages/functions.php");

// include("../lang.en.php");

define('ONLINE',false);

define('BASE','http://localhost/pnpm/');

if($_GET[id]){

if($_GET[id]==6){

include "load/sumberejo.php";

}elseif($_GET[id]==1){

include "load/semin.php";

}elseif($_GET[id]==7){

include "load/candirejo.php";

}elseif($_GET[id]==9){

include "load/karangsari.php";

}elseif($_GET[id]==2){

include "load/kalitekuk.php";

}elseif($_GET[id]==8){

include "load/rejosari.php";

}elseif($_GET[id]==4){

include "load/bulurejo.php";

}elseif($_GET[id]==5){

include "load/bendung.php";

}elseif($_GET[id]==3){

include "load/kemejing.php";

}elseif($_GET[id]==10){

include "load/pundungsari.php";

}}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

<title>PNPM Mandiri Perdesaan</title>

0.5.css" />

1.3.2.min.js"></script>

0.5.min.js"></script>

src="lib/easySlider1.5.js"></script>

src="lib/jquery.cycle.lite.min.js"></script>

</script>

$(function() {

$( document ).tooltip();

});

</script>

<style>

area {

display: inline-block;

width: 5em;

}

</style>

<style>

body{

padding: 0px;

margin: 0px;

}

#divContainer, #divResize {

border:dashed 1px #990000;

width:100px;

height:20px;

padding:0px;

margin:0px;

font:13px Arial;

cursor:move;

float:left

position:relative !important;

background-color: rgba(255, 240, 224,0.5);

text-align: center;

vertical-align: middle;

-webkit-border-radius:10px;-moz-border-

radius:10px;border-radius:10px;

/*

*/

}

.ui-resizable{ -webkit-border-radius:10px;-moz-border-

radius:10px;border-radius:10px; }

.ui-resizable.ui-resizable-resizing, .ui-resizable.ui-

draggable-dragging{

border:2px dashed #ffcc66 !important;

}

</style>

</head>

<body>

<?php

//include "pages/koneksi.php";

?>

</div>

<li>

<a href="index.php">Beranda</a>

</li>

<li>

</li>

<li>

<a>Tujuan</a>

</li>

<li>

<?php

if($_GET[page]=='detail'){

$id=$_GET[id];

$jen=$_POST[jen];

$w=$_POST[w];

if(empty($w)){

$w=date('Y');

}

?>

<form method="post"

action="index.php?id=<?=$id?>&page=detail">

<label>Tahun :</label>

<option value="2011"<?php if($w=='2011'){echo

selected;}?>>2011</option>

<option value="2012"<?php if($w=='2012'){echo

selected;}?>>2012</option>

<option value="2013"<?php if($w=='2013'){echo

selected;}?>>2013</option>

<option value="2014"<?php if($w=='2014'){echo

selected;}?>>2014</option>

<option value="2015"<?php if($w=='2015'){echo

selected;}?>>2015</option>

</select></label>

<label>Jenis :</label>

<option value="SARANA PRASARANA" <?php

if($jen=='SARANA PRASARANA'){echo selected;} ?>>SARANA

PRASARANA</option>

<option value="PKH/KESEHATAN" <?php

if($jen=='PKH/KESEHATAN'){echo selected;}

?>>PKH/KESEHATAN</option>

<option value="PKH / PENDIDIKAN"<?php if($jen=="PKH /

PENDIDIKAN"){echo selected;} ?>>PKH / PENDIDIKAN</option>

</select></label>

<label><input class="btn btn-primary" type="submit"

value="Tampil">

</form></label>

<?php

}

?>

</li>

</ul>

</div>

<?php /* ------------------ Panel Kiri ---------------------------

---- <div class="map" style="background: #F3EFCF;"> </div> */ ?>

<?php

include "desa.htm";

?>

</div>

<?php /* ------------------------------------------------- */ ?>

<?php

if(empty($_GET['page'])) $_GET['page']='home';

$halaman = $_GET['page'].'.php';

if(file_exists('pages/'.$halaman)){

include 'pages/'.$halaman;

}else{

include 'pages/404.php';

}

?>

</div>

<?php

if($_GET[det]){

$tahun=$_GET['tahun'];

$det=$_GET[det];

$kuer=mysql_query("select * from data where id=$det");

$dat=mysql_fetch_assoc($kuer);

if($tahun=='2011'){

?>

<table class="table table-hover" border="1"

style="border:1px black !important;">

<tr>

<th rowspan="3" width="">Nama Kegiatan</th>

<th rowspan="2" colspan="4" width=""><center>Volume /

dimensi</center></th>

<th colspan="5" width=""><center>Pembiayaan</center></th>

<th rowspan="3">Sumber Dana</th>

<th rowspan="3" width="">Asal usulan</th>

<th rowspan="2" colspan="3" width=""><center>Pemanfaat /

Anggota Kelompok</center></th>

</tr>

<tr>

<th rowspan="2">Swadaya</th>

</tr>

<tr>

<th >Panjang</th>

<th width="">Lebar</th>

<th width="">Volume</th>

<th width="">Total</th>

</tr>

<tr>

</tr>

</table>

</div>

<?php

}elseif($tahun=='2012'){

?>

<table class="table table-hover" border="1"

style="border:1px black !important;">

<tr>

<th rowspan="3" width="">Nama Kegiatan</th>

<th rowspan="2" colspan="3" width=""><center>Volume /

dimensi</center></th>

<th colspan="8" width=""><center>Pembiayaan</center></th>

<th rowspan="3" width="">Asal usulan</th>

<th rowspan="2" colspan="3" width=""><center>Pemanfaat /

Anggota Kelompok</center></th>

</tr>

<tr>

<th rowspan="2">Jumlah BLM</th>

<th rowspan="2">Swadaya</th>

</tr>

<tr>

<th >Panjang</th>

<th width="">Lebar</th>

<th width="">Kegiatan</th>

<th width="">Kegiatan</th>

</tr>

<tr>

</tr>

</table>

</div>

<?php

}else{?>

<table class="table table-hover" border="1"

style="border:1px black !important;">

<tr>

<th rowspan="3" width="">Nama Kegiatan</th>

<th rowspan="2" colspan="4" width=""><center>Volume /

dimensi</center></th>

<th colspan="9" width=""><center>Pembiayaan</center></th>

<th rowspan="3" width="">Asal usulan</th>

<th rowspan="2" colspan="3" width=""><center>Pemanfaat /

Anggota Kelompok</center></th>

</tr>

<tr>

<th rowspan="2">Swadaya</th>

</tr>

<tr>

<th >Panjang</th>

<th width="">Lebar</th>

<th width="">Volume</th>

<th width="">Kegiatan</th>

<th width="">Total</th>

<th width="">Kegiatan</th>

<th width="">Total</th>

</tr>

<tr>

</tr>

</table>

</div>

<?php

}

?>

<?php /* ------------------------------------------------- */ ?>

<div class="footer">©PNPM Mandiri Perdesaan</div>

</div>

</body>

</html>

Login.php

<?php

error_reporting(E_ERROR);

session_start();

$_SESSION[username]='';

$_SESSION[password]='';

session_destroy();

?>

<style>

*{

margin:0;

padding:0;

}

body{

background:#fff;

font-family:tahoma,verdana,arial,sans-serif;

font-size:11px;

}

#toppanel{

background:#252525;

height:20px;

}

#containers{

width:700px !important;

margin:10px auto;

position:relative;

}

#logo{

height:65px;

line-height:65px;

width:400px;

}

#loginbg{

height:200px;

background:#252525;

border-radius:5px;

-moz-border-radius:5px;

-webkit-border-radius:5px;

}

#loginbg img{

border-radius:5px;

-moz-border-radius:5px;

-webkit-border-radius:5px;

border:1px solid #aaa;

width:698px;

height:198px;

}

#loginfoot{

width:700px;

height:162px;

}

#loginbox{

width:270px;

height:400px;

position:center;

margin-right: auto;

margin-left: auto;

}

#loginbox .header{

width:187px;

padding:10px 33px 10px 40px;

margin-left:4px;

height:45px;

line-height:45px;

text-align:center;

}

#loginbox .header h4{

font-size:14px;

display:block;

color:#222;

border-bottom:1px dotted #ccc;

}

#loginbox .content{

height:180px;

width:187px;

padding:10px;

margin-left:34px;

background:#fff;

opacity:0.95;;

}

#loginbox .footer{

width:187px;

padding:10px;

margin-left:34px;

text-align:center;

}

label{

display:block;

height:20px;

line-height:20px;

}

.inputbox{

border:1px solid #b4bbcd;

padding:5px 3px;

font-size:11px;

color:#907777;

width:178px;

}

.inputbox:focus{

color:#222;

background:#fffeee;

}

button{

float:right;

margin:10px 0 0;

padding:2px 5px;

border:1px solid #999999;

cursor:pointer;

color:#111;

}

button:hover{

border:1px solid #666;

}

#notification{

margin-bottom:5px;

text-align:center;

padding:5px;

color:#fff;

position:relative;

overflow:hidden;

}

#notification p img{

vertical-align:middle;

margin:-2px 5px 0 0;

}

#notification p{

position:relative;

z-index:2;

}

#notification.information{

background:#f2f2f2;

color:#222;

border:1px solid #eee;

}

#notification.failed{

background:#d03737;

}

.main {

background: #fff;

}

</style>

<div class="header"><h4>Login Admin</h4></div>

<label>Username :</label>

<input type="text" name="username" class="inputbox"

id="focus"/>

<label>Password :</label>

<button type="submit" class="btn"><i class="icon icon-

lock"></i> Login</button>

</form>

</div>

<?php if (isset($_SESSION['error'])){ ?>

<div class="message error" style="text-align: center;

color: red; font-weight: bold;">

<p>Username atau Password Anda salah!!Silahkan

ulangi lagi....</p>

</div>

<?php } ?>

<div class="row-fluid" style="margin-top:200px; text-

align:center;">

©PNPM Mandiri Perdesaan<br />

</div>

detail.php

<?php

if($_GET[det]){

$tahun=$_GET['tahun'];

$det=$_GET[det];

$kuer=mysql_query("select * from data where id=$det");

$dat=mysql_fetch_assoc($kuer);

if($tahun=='2011'){

?>

<table class="table table-hover" border="1"

style="border:1px black !important;">

<tr>

<th colspan="3" width="">Nama Kegiatan</th>

</tr><tr>

<th colspan="" colspan="" rowspan="4"

width=""><center>Volume / dimensi</center></th>

<th colspan="2" >Panjang</th>

<tr>

<th colspan="2" width="">Lebar</th>

</tr><tr>

<th colspan="2" width="">Volume</th>

</tr><tr>

</tr>

</tr><tr>

<th rowspan="5" width=""><center>Pembiayaan</center></th>

<tr>

</tr><tr>

</tr><tr>

<th width="">Total</th>

</tr><tr>

<th colspan="2">Swadaya</th>

</tr><tr>

<th colspan="3">Sumber Dana</th>

</tr><tr>

<th colspan="3" width="">Asal usulan</th>

</tr><tr>

<th colspan="2" rowspan="3" width=""><center>Pemanfaat /

Anggota Kelompok</center></th>

<tr>

</tr><tr>

</tr>

</table>

<tr><th colspan="4">Foto Proyek :</th>

</tr><tr>

<td colspan="4"><img width='550'

src="../images/foto/<?=$dat['foto']?>"></td></tr>

</table>

<?php

}elseif($tahun=='2012'){

?>

<table class="table table-hover" border="1"

style="border:1px black !important;">

<tr>

<th colspan="3" width="">Nama

Kegiatan</th><td><?=$dat["nama_kegiatan"]?></td>

</tr><tr>

<th colspan="2" rowspan="3" width=""><center>Volume /

dimensi</center></th>

<th >Panjang</th>

<tr>

<th width="">Lebar</th>

</tr><tr>

</tr>

</tr><tr>

<th rowspan="8" width=""><center>Pembiayaan</center></th>

<th width="">Kegiatan</th>

<tr>

</tr><tr>

</tr>

<th width="">Kegiatan</th>

<tr>

</tr><tr>

</tr>

<th colspan="2">Jumlah BLM</th>

<tr>

<th colspan="2">Swadaya</th>

</tr><tr>

<th colspan="3" width="">Asal usulan</th>

</tr><tr>

<th colspan="2" rowspan="3" width=""><center>Pemanfaat /

Anggota Kelompok</center></th>

<tr>

</tr><tr>

</tr>

</table>

<tr><th colspan="4">Foto Proyek :</th>

</tr><tr>

<td colspan="4"><img width='550'

src="../images/foto/<?=$dat['foto']?>"></td></tr>

</table>

<?php

}else{?>

<table class="table table-hover" border="1"

style="border:1px black !important;">

<tr>

<th colspan="3" width="">Nama Kegiatan</th>

</tr><tr>

<th colspan="2" rowspan="4"

width=""></center>Volume</center>/ dimensi</th>

<th >Panjang</th>

<tr>

<th width="">Lebar</th>

</tr><tr>

<th width="">Volume</th>

</tr><tr>

</tr><tr>

<th rowspan="9" width=""><center>Pembiayaan</center></th>

<th width="">Kegiatan</th>

<tr>

</tr><tr>

</tr><tr>

<th width="">Total</th>

</tr>

<tr>

<th width="">Kegiatan</th>

<tr>

</tr><tr>

</tr><tr>

<th width="">Total</th>

</tr>

<tr><th colspan="2">Swadaya</th>

</tr>

</tr><tr>

<th colspan="3" width="">Asal usulan</th>

</tr><tr>

<th colspan="2" rowspan="3" width=""><center>Pemanfaat /

Anggota Kelompok</center></th>

</tr><tr>

</tr><tr>

</tr>

</table>

<tr><th colspan="4">Foto Proyek :</th>

</tr><tr>

<td colspan="4"><img width='550'

src="../images/foto/<?=$dat['foto']?>"></td></tr>

</table>

<?php

}

?>

edit.php

<?php

include"koneksi.php";

$visi=$_POST[visi];

$misi=$_POST[misi];

//echo"shfghd";

$save=mysql_query("update tb_visi set visi='$visi',misi='$misi'

where id = 1");

if($save){

Header("Location:../index.php?hal=1&visi=1");

}

?>

form.php

<?php

if($_GET[idd]){

$idd=$_GET[idd];

$id=$_GET[id];

$action="pages/ubah_data.php?idd=$idd&id=$id&page=pilih";

$tombol="Simpan";

$bv=mysql_query("select * from data where id=$idd");

$bf=mysql_fetch_assoc($bv);

$koor=$bf['koordinat'];

}else{

$id=$_GET[id];

$action="pages/tambah_data.php?id=$id&page=pilih";

$tombol="Simpan";

$koor=$_POST[j];

}

if($koor==""){

echo "Maaf lokasi belum di tentukan, tentuken dulu

lokasinya";

}else{

?>

<center><h4>Form Tambah Data</h4></center><br><br>

<form method="post" action="<?php echo $action?>"

enctype="multipart/form-data" >

<tr><td>Tahun Kegiatan</td>

<td><input type="text" name="tahun_input"

value="<?=$bf['tahun']?>"></td></tr>

<tr><td>Jenis Kegiatan</td>

<td>

<option value="SARANA PRASARANA">SARANA PRASARANA</option>

<option value="PKH/KESEHATAN">PKH/KESEHATAN</option>

<option value="PKH / PENDIDIKAN">PKH / PENDIDIKAN</option>

</select>

</td></tr>

<tr><td>Nama Kegiatan</td>

<td><input type="text" name="nama_keg"

value="<?=$bf['nama_kegiatan']?>"></td></tr>

<tr><td>Panjang</td>

<td><input type="text" name="panjang"

value="<?=$bf['panjang']?>"></td></tr>

<tr><td>Lebar</td>

<td><input type="text" name="lebar"

value="<?=$bf['lebar']?>"></td></tr>

<tr><td>Volume</td>

<td><input type="text" name="volume"

value="<?=$bf['volume']?>"></td></tr>

<td><input type="text" name="unit"

value="<?=$bf['unit']?>"></td></tr>

<tr><td>Total APBN</td>

<td><input onkeyup="fill_n()" id="total_apbn" type="text"

name="total_a" value="<?=$bf['total_apbn']?>"></td></tr>

<td><input id="bop_tpk_apbn" readonly="readonly"

style="background-color:silver" type="text" name="bop_ta"

value="<?=$bf['bop_tpk_apbn']?>"></td></tr>

<td><input id="bop_upk_apbn" readonly="readonly"

style="background-color:silver" type="text" name="bop_ua"

value="<?=$bf['bop_upk_apbn']?>"></td></tr>

<tr><td>Dana kegiatan APBN</td>

<td><input type="text" id="xdanaapbn" name="dana_kn"

value="<?=$bf['dana_kegiatan_n']?>"></td></tr>

<tr><td>Total APBD</td>

<td><input id="total_apbd" onkeyup="fill_d()" type="text"

name="total_d" value="<?=$bf['total_d']?>"></td></tr>

<td><input id="bop_tpk_apbd" readonly="readonly"

style="background-color:silver" type="text" name="bop_td"

value="<?=$bf['bop_tpk_d']?>"></td></tr>

<td><input id="bop_upk_apbd" readonly="readonly"

style="background-color:silver" type="text" name="bop_ud"

value="<?=$bf['bop_upk_d']?>"></td></tr>

<tr><td>Dana kegiatan APBD</td>

<td><input type="text" id="xdanaapbd" name="dana_kd"

value="<?=$bf['dana_kegiatan_d']?>"></td></tr>

<tr><td>Dana Swadaya</td>

<td><input type="text" name="swadaya"

value="<?=$bf['swadaya']?>"></td></tr>

<tr><td>Usulan (p/c)</td>

<td>

<option <?php if($bf['usulan']=='c') echo

"selected='selected'";?> value="c">C</option>

<option <?php if($bf['usulan']=='p') echo

"selected='selected'";?> value="p">P</option>

<option <?php if($bf['usulan']=='l') echo

"selected='selected'";?> value="l">L</option>

<option <?php if($bf['usulan']=='l/p') echo

"selected='selected'";?> value="l/p">L/P</option>

</td>

</tr>

<tr><td>Jumlah anggota Laki-laki</td>

<tr><td>Jumlah anggota Perempuan</td>

<tr><td>Jumlah RTM</td>

<td><input type="text" name="rtm"

value="<?=$bf['rtm']?>"></td></tr>

<tr>

<td>Foto Proyek</td>

</tr>

<tr><td colspan="2" ><input class="btn btn-primary" type="submit"

value="<?php echo $tombol?>">

</table>

<form>

<?php

}

?>

function fill_n() {

var totaln = $("#total_apbn").val();

var tpkn = totaln * 3 / 100;

var upkn = totaln * 2 / 100;

$("#bop_upk_apbn").val(upkn);

$("#bop_tpk_apbn").val(tpkn);

$("#xdanaapbn").val(totaln-upkn-tpkn);

}

function fill_d() {

var totald = $("#total_apbd").val();

var tpkd = totald * 3 / 100;

var upkd = totald * 2 / 100;

$("#bop_upk_apbd").val(upkd);

$("#bop_tpk_apbd").val(tpkd);

$("#xdanaapbd").val(totald-upkd-tpkd);

}

</script>

Hapus_agenda.php

<?php

include"koneksi.php";

$s = "delete from tb_agenda where id_agenda = $_GET[id]";

mysql_query($s);

header('Location: ' . $_SERVER['HTTP_REFERER']);

?>

Hapus_data.php

<?php

include "koneksi.php";

$idd=$_GET[idd];

$id=$_GET[id];

$del=mysql_query("delete from data where id='$idd'");

if($del){

Header("Location:../index.php?id=$id&page=pilih");

}else{

echo "gagal";

}

?>

Koneksi.php

<?php

// define('BASE','http://localhost/pnpm/admin');

mysql_connect("localhost","root","");

mysql_select_db("pnpm");

?>

Simpan_agenda.php

<?php

include"koneksi.php";

$s = "insert into tb_agenda (judul,isi,tanggal,id_desa)

values('$_POST[judul_agenda]','$_POST[isi_agenda]','$_POST[tgl]','

0')";

mysql_query($s);

header('Location: ' . $_SERVER['HTTP_REFERER']);

?>

Tambah_data.php

<?php

include "koneksi.php";

$fileName = $_FILES['foto']['name'];

$fileSize = $_FILES['foto']['size'];

$tipefile = $_FILES['foto']['type'];

$fileError = $_FILES['foto']['error'];

$lokasi_file = $_FILES['foto']['tmp_name'];

$koor=$_POST["koor"];

$id=$_POST["id"];

$nama_keg=$_POST["nama_keg"];

$jenis=$_POST["jenis"];

$panjang=$_POST["panjang"];

$lebar=$_POST["lebar"];

$volume=$_POST["volume"];

$unit=$_POST["unit"];

$dana_kn=$_POST["dana_kn"];

$bop_ta=$_POST["bop_ta"];

$bop_ua=$_POST["bop_ua"];

$total_a=$_POST["total_a"];

$dana_kd=$_POST["dana_kd"];

$bop_td=$_POST["bop_td"];

$bop_ud=$_POST["bop_ud"];

$total_d=$_POST["total_d"];

$swadaya=$_POST["swadaya"];

$usulan=$_POST["usulan"];

$l=$_POST["l"];

$p=$_POST["p"];

$rtm=$_POST["rtm"];

$thn=$_POST["tahun_input"];

if($fileSize > 0 || $fileError == 0){

$move =

move_uploaded_file($_FILES['foto']['tmp_name'],

'../../images/foto/'.$fileName);

if(!$move){

echo "Gagal upload

foto";

exit();

}

$safe="insert into

data(jenis,nama_kegiatan,panjang,lebar,volume,dana_kegiatan_n,bop_

tpk_apbn,bop_upk_apbn,total_apbn,dana_kegiatan_d,bop_tpk_d,bop_upk

_d,total_d,swadaya,usulan,l,p,rtm,id_desa,koordinat,tahun,unit,fot

o) values

('$jenis','$nama_keg','$panjang','$lebar','$volume','$dana_kn','$b

op_ta','$bop_ua','$total_a','$dana_kd','$bop_td','$bop_ud','$total

_d','$swadaya','$usulan','$l','$p','$rtm','$id','$koor','$thn','$u

nit','$fileName')";

$save=mysql_query($safe);

if($save){

Header("Location:../index.php?id=$id&page=pilih");

}else{

echo "gagal";

}

?>

Prin.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

/>

<title>Untitled Document</title>

#taby {font-family: Verdana}

#taby td {border:1px solid #3c3c3c; padding:5px;font-size: 9px}

#taby th {border:1px solid #3c3c3c; padding:5px; font-family:

Verdana; color: white; background-color: orange; font-size: 14px}

</style>

</head>

<table width="1207" height="303" cellpadding="0" cellspacing="0"

border="0" id="taby">

<tr>

<th width="28" rowspan="3"><span class="style2">No

Urut</span></th>

<th width="79" rowspan="3"><span class="style2">Nama

Desa</span></th>

<th colspan="3"><span class="style2">Kegiatan</span></th>

<th colspan="4"><span class="style2">Dimensi</span></th>

<th colspan="8"><span class="style2">Pembiayaan

(Rp)</span></th>

<th width="59" rowspan="3"><span class="style2">Jumlah

BLM</span></th>

<th width="48" rowspan="3"><span

class="style2">Swadaya</span></th>

<th width="57" rowspan="3"><span class="style2">Usulan

(P/C)</span></th>

<th colspan="3"><span class="style2">Pemanfaatan / Anggota

Kelompok</span></th>

</tr>

<tr>

<th width="47" rowspan="2"><span

class="style2">Jenis</span></th>

<th width="84" rowspan="2"><span class="style2">Nama

Kegiatan</span></th>

<th width="64" rowspan="2"><span

class="style2">Lokasi</span></th>

<th width="28" rowspan="2"><span class="style2">P

(m)</span></th>

<th width="25" rowspan="2"><span class="style2">L

(m)</span></th>

<th width="21" rowspan="2"><span

class="style2">V/L</span></th>

<th width="32" rowspan="2"><span class="style2">Unit /

Klp</span></th>

<th colspan="4"><span class="style2">PNPM -MPd

(APBN)</span></th>

<th colspan="4"><span class="style2">PNPM-MPd

(APBD)</span></th>

<th width="72" rowspan="2"><span class="style2">Laki -

laki</span></th>

<th width="59" rowspan="2"><span

class="style2">Perempuan</span></th>

<th width="57" rowspan="2"><span

class="style2">RTM</span></th>

</tr>

<tr>

<th width="54"><span class="style2">Dana Kegiatan</span></th>

<th width="28"><span class="style2">Total</span></th>

<th width="48"><span class="style2">Dana Kegiatan</span></th>

<th width="43"><span class="style2">Total</span></th>

</tr>

<?php

include "koneksi.php";

function numerik($number) {

$h = number_format($number,0,',','.');

return $h;

}

$s = "select * from tb_desa order by nama_desa";

$q = mysql_query($s);

while($d = mysql_fetch_array($q)) {

$dd = 0;

$id_desa = $d['id_desa'];

$s_jenis = "SELECT DISTINCT(jenis),COUNT(id) AS tjenis FROM

`data` WHERE id_desa = $id_desa and tahun=$_GET[th] GROUP BY

id_desa,jenis";

$q_jenis = mysql_query($s_jenis);

while($d_jenis=mysql_fetch_array($q_jenis)) {

//reset counter & total

$jj = 0;

$j_jenis = $d_jenis['tjenis'];

$s_kegiatan = "SELECT * FROM `data` WHERE id_desa =

$id_desa and jenis = '$d_jenis[jenis]'";

$q_kegiatan = mysql_query($s_kegiatan);

$s_semua_kegiatan = "SELECT * FROM `data` WHERE id_desa =

$id_desa";

$q_semua_kegiatan = mysql_query($s_semua_kegiatan);

$d_desa = mysql_num_rows($q_semua_kegiatan);

while($d_kegiatan=mysql_fetch_array($q_kegiatan)) {

$jj++;

$dd++;

?>

<tr>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['dana_kegiatan_n']); $t_dana_kegiatan_n =

$t_dana_kegiatan_n + $d_kegiatan['dana_kegiatan_n']; ?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['bop_tpk_apbn']); $t_bop_tpk_apbn =

$t_bop_tpk_apbn + $d_kegiatan['bop_tpk_apbn']; ?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['bop_upk_apbn']); $t_bop_upk_apbn =

$t_bop_upk_apbn + $d_kegiatan['bop_upk_apbn']; ?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['total_apbn']); $t_total_apbn = $t_total_apbn

+ $d_kegiatan['total_apbn']; ?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['dana_kegiatan_d']); $t_dana_kegiatan_d =

$t_dana_kegiatan_d + $d_kegiatan['dana_kegiatan_d']; ?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['bop_tpk_d']); $t_bop_tpk_d = $t_bop_tpk_d +

$d_kegiatan['bop_tpk_d'];?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['bop_upk_d']); $t_bop_upk_d = $t_bop_upk_d +

$d_kegiatan['bop_upk_d'];?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['total_d']); $t_total_d = $t_total_d +

$d_kegiatan['total_d'];?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['total_apbn'] + $d_kegiatan['total_d']);

$t_total = $t_total + ($d_kegiatan['total_apbn'] +

$d_kegiatan['total_d']);?></td>

<td style="text-align:right"><?php echo

numerik($d_kegiatan['swadaya']); $t_swadaya = $t_swadaya +

$d_kegiatan['swadaya'];?></td>

<td><img style="width:120px;" src="../images/foto/<?php

echo $d_kegiatan[foto];?>"></td>

</tr>

<?php

if($jj==$j_jenis) { ?>

<td colspan='7' style="text-align:right;">Jumlah

Dana</td>

<td style="text-align:right;" ><?php echo

numerik($t_dana_kegiatan_n); $td_dana_kegiatan_n =

$td_dana_kegiatan_n + $t_dana_kegiatan_n; $t_dana_kegiatan_n = 0;

?></td>

<td style="text-align:right;" ><?php echo

numerik($t_bop_tpk_apbn); $td_bop_tpk_apbn = $td_bop_tpk_apbn +

$t_bop_tpk_apbn; $t_bop_tpk_apbn = 0; ?></td>

<td style="text-align:right;" ><?php echo

numerik($t_bop_upk_apbn); $td_bop_upk_apbn = $td_bop_upk_apbn +

$t_bop_upk_apbn; $t_bop_upk_apbn = 0;?></td>

<td style="text-align:right;" ><?php echo

numerik($t_total_apbn); $td_total_apbn = $td_total_apbn +

$t_total_apbn; $t_total_apbn = 0;?></td>

<td style="text-align:right;" ><?php echo

numerik($t_dana_kegiatan_d); $td_dana_kegiatan_d =

$td_dana_kegiatan_d + $t_dana_kegiatan_d; $t_dana_kegiatan_d =

0;?></td>

<td style="text-align:right;" ><?php echo

numerik($t_bop_tpk_d); $td_bop_tpk_d = $td_bop_tpk_d +

$t_bop_tpk_d; $t_bop_tpk_d = 0;?></td>

<td style="text-align:right;" ><?php echo

numerik($t_bop_upk_d); $td_bop_upk_d = $td_bop_upk_d +

$t_bop_upk_d; $t_bop_upk_d = 0;?></td>

<td style="text-align:right;" ><?php echo

numerik($t_total_d); $td_total_d = $td_total_d + $t_total_d;

$t_total_d = 0;?></td>

<td style="text-align:right;" ><?php echo

numerik($t_total); $td_total = $td_total + $t_total; $t_total =

0;?></td>

<td style="text-align:right;" ><?php echo

numerik($t_swadaya); $td_swadaya = $td_swadaya + $t_swadaya;

$t_swadaya = 0;?></td>

</tr>

<?php

if($dd==$d_desa) { ?>

<td colspan='7' style="text-align:right;">Jumlah

Dana Desa</td>

<td style="text-align:right;" ><?php echo

numerik($td_dana_kegiatan_n);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_bop_tpk_apbn);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_bop_upk_apbn);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_total_apbn);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_dana_kegiatan_d);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_bop_tpk_d);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_bop_upk_d);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_total_d);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_total);?></td>

<td style="text-align:right;" ><?php echo

numerik($td_swadaya);?></td>

</tr>

<?php

} //total tiap desa

}//total tiap jenis

}//kegiatan

}//jenis

}//id_desa

?>

</table>

</body>

</html>

Graf_kec.php

<?php // content="text/plain; charset=utf-8"

require_once ('../pages/koneksi.php');

require_once ('../jpgraph/src/jpgraph.php');

require_once ('../jpgraph/src/jpgraph_line.php');

$t = mysql_query("select distinct(tahun) as thn from data");

while($thn=mysql_fetch_array($t)) {

$tahun = $thn['thn'];

//sarana prasarana

$s = "SELECT jenis,tahun,IFNULL(SUM(total_apbn),0)/1000000 AS

tapbn, IFNULL(SUM(total_d),0)/1000000 AS td FROM DATA WHERE jenis

= 'SARANA PRASARANA' AND tahun = '$tahun' GROUP BY jenis ORDER BY

tahun";

$a = mysql_query($s);

if(mysql_num_rows($a)>0) {

$x = mysql_fetch_array($a);

$g1[] = $x[tapbn];

} else

$g1[] = 0;

//PKH / PENDIDIKAN

$s = "SELECT jenis,tahun,IFNULL(SUM(total_apbn),0)/1000000 AS

tapbn, IFNULL(SUM(total_d),0)/1000000 AS td FROM DATA WHERE jenis

= 'PKH / PENDIDIKAN' AND tahun = '$tahun' GROUP BY jenis ORDER BY

tahun";

$a = mysql_query($s);

if(mysql_num_rows($a)>0) {

$x = mysql_fetch_array($a);

$g2[] = $x[tapbn];

} else

$g2[] = 0;

//PKH/KESEHATAN

$s = "SELECT jenis,tahun,IFNULL(SUM(total_apbn),0)/1000000 AS

tapbn, IFNULL(SUM(total_d),0)/1000000 AS td FROM DATA WHERE jenis

= 'PKH/KESEHATAN' AND tahun = '$tahun' GROUP BY jenis ORDER BY

tahun";

$a = mysql_query($s);

if(mysql_num_rows($a)>0) {

$x = mysql_fetch_array($a);

$g3[] = $x[tapbn];

} else

$g3[] = 0;

}

//label

$lt = mysql_query("select distinct(tahun) as thn from data");

while($thn=mysql_fetch_array($lt)) {

$label[] = $thn['thn'];

}

//print_r($label);

//print_r($g1);

$datay1 = $g1; //array(20,15,23,15);

$datay2 = $g2;//array(12,9,42,8);

$datay3 = $g3;//(5,17,32,24);

// Setup the graph

$graph = new Graph(550,250);

$graph->SetScale("textlin");

$theme_class=new UniversalTheme;

$graph->SetTheme($theme_class);

$graph->img->SetAntiAliasing(false);

$graph->title->Set('Grafik Pembiayaan Kecamatan Semin');

$graph->SetBox(false);

$graph->img->SetAntiAliasing();

$graph->yaxis->HideZeroLabel();

$graph->yaxis->HideLine(false);

$graph->yaxis->HideTicks(false,false);

$graph->xgrid->Show();

$graph->xgrid->SetLineStyle("solid");

$graph->xaxis->SetTickLabels($label);

$graph->xgrid->SetColor('#E3E3E3');

// Create the first line

$p1 = new LinePlot($datay1);

$graph->Add($p1);

$p1->SetColor("#6495ED");

$p1->SetLegend('PRASARANA');

// Create the second line

$p2 = new LinePlot($datay2);

$graph->Add($p2);

$p2->SetColor("#B22222");

$p2->SetLegend('PKH / PENDIDIKAN');

// Create the third line

$p3 = new LinePlot($datay3);

$graph->Add($p3);

$p3->SetColor("#FF1493");

$p3->SetLegend('PKH/KESEHATAN');

$graph->legend->SetFrameWeight(1);

// Output line

$graph->Stroke();

?>

Tujuan.php

<?php

$k=mysql_query("select * from tb_tujuan where id=1");

$dat=mysql_fetch_assoc($k);

?>

<label>Tujuan PNPM :</label><br><br>

<?php

?>

Sumberejo.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:650px;

min-width:650px;

max-height:567px;

min-height:567px;

border: 1px solid orange;

}

</style>

Semin.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:650px;

min-width:650px;

max-height:770px;

min-height:770px;

border: 1px solid orange;

}

</style>

Rejosari.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:700px;

min-width:700px;

max-height:717px;

min-height:717px;

border: 1px solid orange;

}

</style>

Pundungsari.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:620px;

min-width:620px;

max-height:852px;

min-height:852px;

border: 1px solid orange;

}

</style>

Kemejing.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:520px;

min-width:520px;

max-height:698px;

min-height:698px;

border: 1px solid orange;

}

</style>

Karangsari.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:550px;

min-width:550px;

max-height:707px;

min-height:707px;

border: 1px solid orange;

}

</style>

Kalitekuk.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:530px;

min-width:530px;

max-height:1215px;

min-height:1215px;

border: 1px solid orange;

}

</style>

Candirejo.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:700px;

min-width:700px;

max-height:597px;

min-height:597px;

border: 1px solid orange;

}

</style>

Bulurejo.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:500px;

min-width:500px;

max-height:503px;

min-height:503px;

border: 1px solid orange;

}

</style>

Bending.php

<style>

.canvass {

padding: 0px;

margin: 0px;

max-width:530px;

min-width:530px;

max-height:749px;

min-height:749px;

border: 1px solid orange;

}

</style>

KUISIONER

SISTEM INFORMSI GEOGRAFIS PEMETAAN WILAYAH

PERSEBARAN PEMBANGUNAN FISIK PROGRAM NASIONAL

PEMBERDAYAAN MASYARAKAT (PNPM) DI GUNUNGKIDUL

BERBASIS WEB (STUDY KASUS KECAMATAN SEMIN)

Nama : ...................................................................................................

Alamat : ...................................................................................................

Pekerjaan : ...................................................................................................

Beri tanda silang (x) pada jawaban yang sesuai menurut anda!

Setelah mencoba dan menjalankan uji coba Sistem Informsi Geografis Pemetaan

Wilayah Persebaran Pembangunan Fisik Program Nasional Pemberdayaan

Masyarakat (Pnpm) Di Gunungkidul Berbasis Web (Study Kasus Kecamatan

Semin), bagaimana tanggapan anda mengenai sistem tersebut :

1. Format tampilan :

a. Sangat menarik b. Menarik c. Tidak menarik

2. Kompleksitas data dan informasi yang disajikan :

a.Sangat lengkap b. Lengkap c. Kurang lengkap

3. Kemudahan dalam pencarian :

a. Sangat mudah b. Mudah c. Sulit

4. Kemudahan dalam menginputkan data :

a. Sangat mudah b. Mudah c. Sulit

5. Kegunaan sistem :

a.Sangat Bermanfaat b. Bermanfaat c. Kurang Bermanfaat

Saran dan kritik :

.....................................................................................................

…………....................................2016

(............................................................)

bab v kesimpulan dan saran a. kesimpulanrepository.upy.ac.id/741/5/dokumen bab v dan daftar pustaka...

Documents

tugas akhir -...

pengetesan kecerdasan

bab iv deskripsi pekerjaan -...

perancangan aplikasi penyimpanan dan pengetesan baterai

catatan: form ini berisi rencana kegiatan pemeliharaan...

transformator division trafo.pdf · trafo, purifiying dan...

hioki hicorder mr8880-20 untuk pengetesan kopling...

lampiran -...

bab iii giant -...

hubungan konformitas teman sebaya...

pmk no. 741 ttg standar pelayanan minimal bidang kesehatan d

metode pemeriksaan dan pengetesan tanki pekerjaan

petunjuk praktikum listrik kapal - its.ac.id · pada...

sistem start -...

repository.fisip-untirta.ac.idrepository.fisip-untirta.ac.id/65/1/ana_muflihah_h._s.pdf ·...

lelang.ptpjb.com · pengecekan dan perawatan hoist...

bab v penutup -...

skd 04 - permenkes 741 thn 2008 ttg standar pelayanan mnimal...

tokoh edisi 741

soal sbmptn tkd soshum kode 741