DAFTAR ISI
advertisement
DAFTAR ISI Halaman : HALAMAN DEPAN .................................................................................. i HALAMAN JUDUL ................................................................................... ii HALAMAN PERSETUJUAN ..................................................................... iii HALAMAN PENGESAHAN ....................................................................... iv HALAMAN MOTTO DAN PERSEMBAHAN .............................................. v INTISARI .................................................................................................. vi KATA PENGANTAR ................................................................................. vii DAFTAR ISI ............................................................................................. ix DAFTAR TABEL ...................................................................................... xiv DAFTAR GAMBAR .................................................................................. xv BAB I BAB II PENDAHULUAN ....................................................................... 1 1.1 Latar Belakang Masalah .................................................. 1 1.2 Maksud ............................................................................. 2 1.3 Tujuan .............................................................................. 2 1.4 Batasan Masalah ............................................................. 3 1.5 Sistematika Penulisan ...................................................... 3 LANDASAN TEORI .................................................................. 5 2.1 Kondisi Wilayah Kabupaten TTU ..................................... 5 2.1.1 Letak Geografis...................................................... 5 2.1.2 Luas Wilayah ......................................................... 5 2.1.3 Kondisi Fisik ........................................................... 6 2.1.4 Curah Hujan........................................................... 6 ix BAB III 2.1.5 Pembagian Wilayah Daerah Aliran Sungai............ 6 2.1.6 Keadaan Hutan ..................................................... 7 2.2 Konsep Dasar Sistem ...................................................... 8 2.3 Konsep Database ............................................................ 8 2.3.1 Pengertian Database ............................................ 8 2.3.2 Perancangan Database ........................................ 10 2.3.3 Perancangan Database Teknik Entity Relationship 11 2.4 Pegertian Internet ............................................................ 12 2.5 WWW (World Wide Web) ................................................ 13 2.6 Hyper Text Transfer Protocol (HTTP) ............................... 13 2.7 Hyper Text Markup Language (HTML) ............................. 14 2.8 Web Server ...................................................................... 15 2.9 Web Browser ................................................................... 15 2.10 Uniform Resource Locator (URL) ...................................... 15 2.11 Home Page....................................................................... 16 2.12 Mengenal PHP ................................................................. 16 2.13 Beberapa Kegunaan PHP ................................................. 17 2.14 Teknik Menulis Skrip PHP................................................. 17 2.15 Mengenal MYSQL............................................................ 18 2.16 Perintah_Perintah Dasar MYSQL .................................... 19 2.17 Diagram Alir Data (Data Flow Diagram) ........................... 21 2.18 Diagram Alir Sistem ......................................................... 22 PERANCANGAN SISTEM ........................................................ 23 3.1 Perancangan Sistem .................................................... … 23 3.2 Perangkat Lunak…………………….. ................................ 23 x 3.3 Perangkat Keras ............................................................... 24 3.4 Perancangan Basis Data .................................................. 24 3.4.1 Diagram Alir Data ................................................. 24 3.4.2 Diagram Konteks .................................................. 25 3.4.3 Diagram Alir Data Level 0 ..................................... 26 3.4.4 Diagram Alir Data Level 1 Proses 1 ...................... 29 3.4.5 Diagram Alir Data Level 1 Proses 2 ...................... 29 3.4.6 Diagram Alir Data Level 1 Proses 3 ...................... 30 3.4.7 Diagram Alir Data Level 1 Proses 4 ...................... 31 3.4.8 Diagram Alir Data Level 1 Proses 5 ...................... 31 3.4.9 Diagram Alir Data Level 1 Proses 6 ...................... 32 3.4.10 Diagram Alir Data Level 1 Proses 7 ...................... 33 3.4.11 Diagram Alir Data Level 1 Proses 8 ...................... 34 3.4.12 Diagram Alir Data Level 1 Proses 9 ...................... 34 3.4.13 Diagram Alir Data Level 1 Proses 10 .................... 35 3.4.14 Diagram Alir Sistem .............................................. 38 3.4.15 Penjelasan Diagram Alir sistem ............................ 37 3.4.16 Struktur Data Base ............................................... 45 3.4.17 Perancangan Relasi Tabel .................................... 52 3.4.18 Penjelasan Relasi Tabel ....................................... 53 Perancangan Input ........................................................... 54 3.5.1 Rancangan Input Jenis Wisata ............................. 54 3.5.2 Perancangan Input Wisata .................................... 54 3.5.3 Perancangan Input Kecamatan............................. 55 3.5.4 Perancangan Input desa ....................................... 55 3.5 xi 3.6 3.5.5 Perancangan Input jenis Hutan ............................. 56 3.5.6 Perancangan Input Hasil Hutan ............................ 56 3.5.7 Perancangan Input detail Hasil hutan ................... 57 3.5.8 Perancangan Input Pegawai ................................. 57 3.5.9 Perancangan Input Bidang ................................... 58 3.5.10 Perancangan Input Agenda .................................. 58 3.5.11 Rancangan Login Admin....................................... 59 3.5.12 Rancangan Input Buku Tamu ............................... 59 Perancangan Output ........................................................ 60 3.6.1 Perancangan Output Kecamatan .......................... 60 3.6.2 Perancangan Output Desa ................................... 60 3.6.3 Perancangan Output Desa Per Kecamatan .......... 61 3.6.4 Perancangan Output Wisata ................................. 61 3.6.5 Perancangan Output Wisata Per Jenis wisata ...... 61 3.6.6 Perancangan Output Wisata Per Desa ................. 62 3.6.7 Perancangan Output Detail Wisata ....................... 62 3.6.8 Perancangan Output Jenis Hutan ......................... 63 3.6.9 Perancangan Output Hasil Hutan ......................... 63 3.6.10 Perancangan Output Detail Hasil .......................... 63 3.6.11 Perancangan Output Detail Hasil Per Desa .......... 64 3.6.12 Perancangan Output Detail Hasil Per Jenis Hutan 64 3.6.13 Perancangan Output Detail Hasil Pertahun........... 64 3.6.14 Perancangan Output Detail Hasil Hutan ............... 65 3.6.15 Perancangan Output Pegawai .............................. 65 3.6.16 Perancangan Output Pegawai Per Bidang ............ 66 xii BAB IV 3.6.17 Perancangan Output Detail Pegawai .................... 66 3.6.18 Perancangan Output Bidang ................................. 66 3.6.19 Perancangan Output Agenda................................ 67 3.6.20 Perancangan Output Agenda Per Bidang ............. 67 3.6.21 Perancangan Output Agenda Per Pegawai........... 67 3.6.22 Perancangan Output Agenda Per Desa ................ 68 Perancangan Output Detail Agenda.................................. 68 IMPLEMENTASI DAN PEMBAHASAN ...................................... 70 4.1 Spesifikasi dan Pembahasan Program ............................. 70 4.1.1 Halaman Web Untuk Umum ................................. 71 4.1.2 Halaman Web Untuk Admin ................................. 73 Aplikasi Program............................................................... 93 4.2.1 Halaman Web Untuk Umum ................................. 93 4.2.2 Halaman Web Untuk Admin ................................. 108 4.2 BAB V PENUTUP ................................................................................ 137 5.1 Kesimpulan ...................................................................... 137 5.2 Saran ................................................................................ 137 DAFTAR PUSTAKA.................................................................................. 138 LAMPIRAN xiii DAFTAR TABEL Halaman : Tabel 3.1 Kecamatan ................................................................................ 45 Tabel 3.2 Desa ......................................................................................... 46 Tabel 3.3 Wisata ....................................................................................... 47 Tabel 3.4 Jenis Hutan ............................................................................... 47 Tabel 3.5 Hasil ......................................................................................... 48 Tabel 3.6 Detail Hasil ................................................................................ 48 Tabel 3.7 Agenda ..................................................................................... 49 Tabel 3.8 Bidang....................................................................................... 49 Tabel 3.9 Pegawai .................................................................................... 50 Tabel 3.10 Admin...................................................................................... 51 Tabel 3.11 Buku_Tamu............................................................................. 51 xiv DAFTAR GAMBAR Halaman : Gambar 3.1 Diagram Konteks .................................................................. 25 Gambar 3.2 Diagram Alir Data Level 0 ..................................................... 27 Gambar 3.3 Diagram Alir Data Level 1 Proses 1 ..................................... 29 Gambar 3.4 Diagram Alir Data Level 1 Proses 2....................................... 29 Gambar 3.5 Diagram Alir Data Level 1 Proses 3....................................... 30 Gambar 3.6 Diagram Alir Data Level 1 Proses 4....................................... 31 Gambar 3.7 Diagram Alir Data Level 1 Proses 5....................................... 32 Gambar 3.8 Diagram Alir Data Level 1 Proses 6....................................... 32 Gambar 3.9 Diagram Alir Data Level 1 Proses 7....................................... 33 Gambar 3.10 Diagram Alir Data Level 1 Proses 8..................................... 34 Gambar 3.11 Diagram Alir Data Level 1 Proses 9..................................... 35 Gambar 3.12 Diagram Alir Data Level 1 Proses 10................................... 36 Gambar 3.13 Diagram Alir Sistem ............................................................ 38 Gambar 3.14 Relasi Tabel ........................................................................ 52 Gambar 3.15 Input Jenis Wisata ............................................................... 54 Gambar 3.16 Input Wisata ........................................................................ 55 Gambar 3.17 Input Kecamatan ................................................................. 55 Gambar 3.18 Input Desa........................................................................... 56 Gambar 3.19 Input Jenis Hutan ................................................................ 56 Gambar 3.20 Input Hasil Hutan................................................................. 57 Gambar 3.21 Input Detail Hasil Hutan....................................................... 57 Gambar 3.22 Input Pegawai .................................................................... . 58 xv Gambar 3.23 Input Bidang ........................................................................ 58 Gambar 3.24 Input Agenda ...................................................................... 59 Gambar 3.25 Login Admin ....................................................................... 59 Gambar 3.26 Input Buku Tamu ................................................................ 60 Gambar 3.27 Out Kecamatan .................................................................. 60 Gambar 3.28 Output Desa ........................................................................ 60 Gambar 3.29 Output Desa Per Kecamatan............................................... 61 Gambar 3.30 Output Wisata ..................................................................... 61 Gambar 3.31 Output Wisata Per Jenis Wisata .......................................... 62 Gambar 3.32 Output Wisata Per Desa...................................................... 62 Gambar 3.33 Output Detail Wisata ........................................................... 62 Gambar 3.34 Output Jenis Hutan ............................................................. 63 Gambar 3.35 Output Hasil Hutan .............................................................. 63 Gambar 3.36 Output Detail Hasil .............................................................. 63 Gambar 3.37 Output Detail Hasil Per Desa............................................... 64 Gambar 3.38 Output Detail Hasil Per Jenis Hutan .................................... 64 Gambar 3.39 Output Detail Hasil Per Tahun ............................................. 65 Gambar 3.40 Output Detail Hasil Hutan .................................................... 65 Gambar 3.41 Output Pegawai................................................................... 65 Gambar 3.42 Output Pegawai Pegawai Per Bidang.................................. 66 Gambar 3.43 Output Detail Pegawai......................................................... 66 Gambar 3.44 Output Bidang ..................................................................... 67 Gambar 3.45 Output Agenda .................................................................... 67 Gambar 3.46 Output Agenda Per Bidang ................................................. 67 Gambar 3.47 Output Agenda Per Pegawai ............................................... 68 xvi Gambar 3.48 Output Agenda Per Desa .................................................... 68 Gambar 3.49 Output Detail Agenda .......................................................... 69 Gambar 4.1 Halaman Utama ................................................................... 93 Gambar 4.2 Halaman Home ..................................................................... 94 Gambar 4.3 Halaman Wisata .................................................................... 95 Gambar 4.4 Halaman Hasil Hutan ............................................................ 96 Gambar 4.5 Halaman Agenda .................................................................. 97 Gambar 4.6 Halaman Buku Tamu ............................................................ 98 Gambar 4.7 Halaman Wisata Per Kecamatan ......................................... 99 Gambar 4.8 Halaman Detail Wisata .......................................................... 100 Gambar 4.9 Halaman Hasil Hutan Per Kecamatan ................................... 101 Gambar 4.10 Halaman Detail Hasil Hutan ................................................ 102 Gambar 4.11 Halaman Jenis Hasil Hutan Per Desa ................................. 103 Gambar 4.12 Halaman Jenis Hasil Hutan Per Tahun ................................ 104 Gambar 4.13 Halaman Hasil Hutan Pertahun ........................................... 105 Gambar 4.14 Halaman Daftar Agenda Per Pegawai ................................. 106 Gambar 4.15 Halaman Detail Agenda ...................................................... 107 Gambar 4.16 Halaman Daftar Buku Tamu ................................................ 108 Gambar 4.17 Halaman Login Admin ......................................................... 108 Gambar 4.18 Halaman Utama Admin ....................................................... 110 Gambar 4.19 Form Input Data Kecamatan ............................................... 111 Gambar 4.20 Form Input Data Desa ........................................................ 111 Gambar 4.21 Form Input Data Jenis Wisata ............................................. 112 Gambar 4.22 Form Input Data Wisata ...................................................... 113 Gambar 4.23 Form Input Data Jenis Hutan............................................... 113 xvii Gambar 4.24 Form Input Data Hasil Hutan ............................................... 114 Gambar 4.25 Form Input Data Detail Hasil Hutan ..................................... 114 Gambar 4.26 Form Input Data Bidang ...................................................... 115 Gambar 4.27 Form Input Data Pegawai .................................................... 116 Gambar 4.28 Form Input Agenda ............................................................. 116 Gambar 4.29 Halaman Laporan Data Kecamatan .................................... 117 Gambar 4.30 Halaman Ubah Data Kecamatan ......................................... 118 Gambar 4.31 Pesan Konfirmasi Hapus Data Kecamatan.......................... 118 Gambar 4.32 Halaman Laporan Desa ...................................................... 119 Gambar 4.33 Halaman Ubah Data Desa .................................................. 120 Gambar 4.34 Pesan Konfirmasi Hapus Data Desa ................................... 120 Gambar 4.35 Halaman Laporan Data Jenis Data...................................... 121 Gambar 4.36 Halaman Ubah Jenis Wisata ............................................... 121 Gambar 4.37 Pesan Konfirmasi Hapus Data Jenis Wisata ....................... 121 Gambar 4.38 Halaman Laporan Data Wisata ........................................... 122 Gambar 4.39 Halaman Ubah Data Wisata ................................................ 122 Gambar 4.40 Pesan Konfirmasi Hapus Data Wisata................................. 123 Gambar 4.41 Halaman Detail Hasil ........................................................... 123 Gambar 4.42 Halaman Laporan Data Jenis Hutan.................................... 124 Gambar 4.43 Halaman Ubah Jenis Hutan ................................................ 124 Gambar 4.44 Pesan Konfirmasi Hapus Data Jenis Hutan ......................... 125 Gambar 4.45 Halaman Laporan Hasil Hutan ............................................ 125 Gambar 4.46 Halaman Ubah Hasil Hutan ................................................. 126 Gambar 4.47 Pesan Konfirmasi Hapus Data Hasil Hutan ......................... 126 Gambar 4.48 Halaman Laporan Detail Hasil Hutan .................................. 127 xviii Gambar 4.49 Halaman Ubah Detail Hasil Hutan ....................................... 128 Gambar 4.50 Pesan Konfirmasi Hapus Data Detail Hasil Hutan ............... 129 Gambar 4.51 Halaman Laporan Data Bidang ........................................... 129 Gambar 4.52 Halaman Ubah Data Bidang ................................................ 130 Gambar 4.53 Pesan Konfirmasi Hapus Data Bidang ................................ 130 Gambar 4.54 Halaman Laporan Data Pegawai ......................................... 131 Gambar 4.55 Halaman Ubah Data Pegawai ............................................. 131 Gambar 4.56 Pesan Konfirmasi Hapus Data Pegawai .............................. 132 Gambar 4.57 Halaman Laporan Data Agenda .......................................... 132 Gambar 4.58 Halaman Ubah Data Agenda............................................... 133 Gambar 4.59 Pesan Konfirmasi Hapus Data Agenda ............................... 133 Gambar 4.60 Halaman Laporan Statistik Web .......................................... 134 Gambar 4.61 Halaman Laporan Statistik Web Hari Ini .............................. 134 Gambar 4.62 Halaman Populer ................................................................ 135 Gambar 4.63 Halaman Pengunjung Terakhir ............................................ 135 Gambar 4.64 Halaman Pencarian Data .................................................... 136 xix