TAKARIR
Auto increment
: penomoran naik secara otomatis
Browser
: pencari
Coding
: membuat kode
Customize
: merancang
Delete
: hapus
Data flow diagram
: diagram alur data
Edit
: ubah
Event
: peristiwa
Field
: lahan
Hardware
: perangkat keras
Input
: nilai masukan
Layout
: susunan/tata ruang
Library
: kumpulan pustaka
Member
: anggota
Moment
: saat/momen
Output
: keluaran
Password
: sandi
Project
: proyek
Print file
: cetak data
Primary key
: kunci pokok
Record
: rekam
Reminder
: pengingat
Save file
: simpan data
Script
: naskah
Server
: pelayan
Software
: perangkat lunak
User
: pengguna
Username
: nama pengguna
viii
Web server
: layanan web
Wedding organizer
: Perancang pernikahan
ix
DAFTAR ISI
LEMBAR PENGESAHAN PEMBIMBING ....................................................... i LEMBAR PENGESAHAN PENGUJI................................................................ ii HALAMAN PERSEMBAHAN .......................................................................... iii HALAMAN MOTTO .......................................................................................... iv KATA PENGANTAR............................................................................................v ABSTRAKSI........................................................................................................ vii TAKARIR........................................................................................................... viii DAFTAR ISI...........................................................................................................x DAFTAR TABEL ............................................................................................. xvii DAFTAR GAMBAR........................................................................................ xviii
BAB I ...................................................................................................................... 1 PENDAHULUAN.................................................................................................. 1 1.1 Latar Belakang ............................................................................................ 1 1.2 Rumusan Masalah ....................................................................................... 2 1.3 Batasan Masalah.......................................................................................... 2 1.4 Tujuan Penelitian......................................................................................... 3 1.5 Manfaat Penelitian....................................................................................... 3 1.6 Metodologi Penelitian ................................................................................. 3 1.6.1 Pengumpulan data .............................................................................. 3 1.6.2 Metode pengembangan sistem .......................................................... 4 1.7 Sistematika Penulisan.................................................................................. 5
x
BAB II .................................................................................................................... 7 LANDASAN TEORI............................................................................................. 7 2.1 Sistem Informasi ........................................................................................... 7 2.2 Wedding Organizer ....................................................................................... 8 2.2.1 Perincian Detail Kebutuhan ....................................................................... 8 2.2.2 Desain Layout .......................................................................................... 11 2.2.3 Anggaran .................................................................................................. 11 2.3 Konsep Basis Data ...................................................................................... 12 2.3.1 Konsep Dasar Basis Data .................................................................... 12 2.3.2 Pengembangan Basis Data .................................................................. 12 2.4 Teknik Perncangan Sistem.......................................................................... 12 2.4.1Data Flow Diagram .............................................................................. 13 2.5 PHP ............................................................................................................. 17 2.6 MySQL........................................................................................................ 18 BAB III................................................................................................................. 21 METODOLOGI .................................................................................................. 21 3.1 Analisis Kebutuhan Perangkat Lunak ....................................................... 21 3.1.1 Metode Analisis ............................................................................... 21 3.1.2 Hasil Analisis ................................................................................... 21 3.1.2.1 Analisis Kebutuhan Input......................................................... 21 3.1.2.2 Analisis Kebutuhan Proses....................................................... 22 3.1.2.3 Analisis Kebutuhan Output ...................................................... 23 3.1.3 Kebutuhan Perangkat Lunak ............................................................ 23 3.1.4 Kebutuhan Perangkat Keras............................................................. 24 3.1.5 Kebutuhan Antarmuka ..................................................................... 24
xi
3.2 Perancangan Perangkat Lunak .................................................................... 25 3.2.1 Diagram Konteks ............................................................................. 25 3.2.2 Data Flow Diagram Level 1............................................................. 25 3.2.3 Dfd level 2 About Us ....................................................................... 26 3.2.4 DFD level 2 Manajemen Sistem ...................................................... 27 3.2.5 Dfd level 2 Perancangan Wedding................................................... 28 3.2.6 DFD level 3 Print Modul ................................................................. 29 3.3 Rancangan Basis Data................................................................................. 30 3.3.1 Rancangan Tabel.............................................................................. 30 3.3.2 Rancangan Relasi Antartabel ........................................................... 39 3.3.3 Rancangan Antarmuka ..................................................................... 40 3.3.3.1 Perancangan Antarmuka User Umum........................................ 40 3.3.3.1 Halaman Index Sistem ............................................................ 40 3.3.3.1.2 Halaman Profil Wedding Organizer..................................... 41 3.3.3.1.3 Halaman Galery ................................................................... 41 3.3.3.1.4 Halaman Event ..................................................................... 42 3.3.3.2 Perancangan Antarmuka Member.............................................. 43 3.3.3.2.1 Halaman Login Member ...................................................... 43 3.3.3.2.2 Halaman Pengisian Identitas Pelanggan .............................. 44 3.3.3.2.3 Halaman Pemesanan Acara.................................................. 45 3.3.3.2.4 Halaman Daftar Barang........................................................ 46 3.3.3.2.5 Halaman Pemesanan Barang................................................ 46 3.3.3.2.6 Halaman Otentifikasi Harga................................................. 47 3.3.3.2.7 Halaman Input Jadwal.......................................................... 48 3.3.3.2.8 Halaman Susunan Jadwal..................................................... 48
xii
3.3.3.2.9 Halaman Input Panitia.......................................................... 49 3.3.3.2.10 Halaman Susunan Panitia................................................... 50 3.3.3.2.11 Halaman Modul.................................................................. 51 3.3.3.2.12 Halaman Edit Password Member....................................... 51 3.3.3.3 Perancangan Antarmuka Administrator........................................ 52 3.3.3.3.1 Halaman Edit Anggota.......................................................... 52 3.3.3.3.2 Halaman Submit Anggota ..................................................... 53 3.3.3.3.3 Halaman Daftar Barang......................................................... 53 3.3.3.3.4 Halaman Submit Barang ....................................................... 54 3.3.3.3.5 Halaman Edit Barang ............................................................ 55 3.3.3.3.6 Halaman Submit Atribut ....................................................... 55 3.3.3.3.7 Halaman Edit Jenis Barang ................................................... 56 3.3.3.3.8 Halaman Submit Jenis Barang .............................................. 57 3.3.3.3.9 Halaman Edit Detail Barang ................................................. 57 3.3.3.3.10 Halaman Submit Detail Barang .......................................... 58 3.3.3.3.11 Halaman Daftar Pelanggan ................................................. 59 3.3.3.3.12 Halaman Edit Jenis Acara ................................................... 59 3.3.3.3.13 Halaman Submit Jenis Acara .............................................. 60 3.3.3.3.14 Halaman Edit Kategori Panitia ........................................... 61 3.3.3.3.15 Halaman Submit Kategori Panitia....................................... 61 3.3.3.3.16 Halaman Profile .................................................................. 62 3.3.3.3.17 Halaman Edit Profile........................................................... 63 3.3.3.3.18 Halaman Edit Event ............................................................ 63 3.3.3.3.19 Halaman Submit Event ....................................................... 64 3.3.3.3.20 Halaman Edit Modul ........................................................... 65
xiii
BAB IV ................................................................................................................. 67 HASIL DAN PEMBAHASAN ........................................................................... 67 4.1 Implementasi ............................................................................................. 67 4.1.1 Implementasi Antarmuka ....................................................................... 67 4.1.1.1 Halaman Utama Sistem.................................................................... 66 4.1.1.2 Halaman About Us........................................................................... 68 4.1.1.2.2 Halaman Profil Wedding Oganizer............................................ 69 4.1.1.2.3 Halaman Galery ......................................................................... 70 4.1.1.2.4 Halaman Event ........................................................................... 70 4.1.1.3 Halaman Antarmuka Member.......................................................... 71 4.1.1.3.1 Halaman Login Member ............................................................ 71 4.1.1.3.2 Halaman Index Member............................................................. 72 4.1.1.3.3 Halaman Pengisian Identitas Pelanggan .................................... 72 4.1.1.3.4 Halaman Pemesanan Acara........................................................ 73 4.1.1.3.5 Halaman Daftar Barang.............................................................. 74 4.1.1.3.6 Halaman Pemesanan Barang...................................................... 74 4.1.1.2.7 Halaman Otentifikasi Harga....................................................... 75 4.1.1.2.8 Halaman Form Input Jadwal ...................................................... 75 4.1.1.2.9Halaman Susunan Jadwal............................................................ 76 4.1.1.2.10 Halaman Form Input Panitia .................................................... 76 4.1.1.2.11 Halaman Susunan Panitia......................................................... 77 4.1.1.2.12 Halaman Modul........................................................................ 78 4.1.1.2.13 Halaman Edit Password Member............................................. 79 4.1.1.4 Halaman Manajemen Administrator .................................................. 80
xiv
4.1.1.4.1 Halaman Edit Anggota............................................................... 80 4.1.1.4.2 Halaman Submit Anggota .......................................................... 80 4.1.1.4.3 Halaman daftar barang ............................................................... 81 4.1.1.4.4 Halaman submit barang ............................................................. 82 4.1.1.4.5 Halaman Edit Barang ................................................................. 82 4.1.1.4.6 Halaman Submit Atribut ............................................................ 83 4.1.1.4.7 Halaman Edit Jenis Barang ........................................................ 83 4.1.1.4.8 Halaman Submit Jenis Barang ................................................... 84 4.1.1.4.9 Halaman Edit Detail Barang ...................................................... 84 4.1.1.4.10 Halaman Submit Detail Barang ............................................... 85 4.1.1.4.11 Halaman Daftar Pelanggan ...................................................... 85 4.1.1.4.12 Halaman Edit Jenis Acara ........................................................ 86 4.1.1.4.13 Halaman Submit Jenis Acara ................................................... 87 4.1.1.4.14 Halaman Edit Kategori Panitia ................................................ 87 4.1.1.4.15 Halaman Submit Kategori Panitia............................................ 88 4.1.1.4.16 Halaman Profile........................................................................ 88 4.1.1.4.17 Halaman Edit Profile................................................................ 88 4.1.1.4.18 Halaman Edit Event ................................................................. 89 4.1.1.4.19 Halaman Submit Event............................................................. 90 4.1.1.4.20 Halaman Edit Modul ................................................................ 90 4.1.1.4.21 Halaman Submit Modul ........................................................... 91 4.1.2 Implementasi Basis Data...................................................................... 91 4.1.3 Implementasi Prosedural...................................................................... 93 4.1.3.1 SQL pemangilan pemesanan barang.............................................. 93 4.1.3.2 SQL Penghitungan total biaya ....................................................... 95
xv
4.1.3.3 Pengubahan Format ke PDF .......................................................... 96 4.2 Analisis Kerja Sistem................................................................................. 96 4.2.1 Penanganan Kesalahan.......................................................................... 96 4.2.1.1 Penanganan Kesalahan Input ........................................................ 96 4.2.1.1.1 Kesalahan Input Proses login..................................................... 96 4.2.1.1.2 Kesalahan Input Ganti Password Member dan Administrator... 97 4.2.1.1.3 Kesalahan Input Data Kosong.................................................... 98 4.2.1.2 Penanganan Kesalahan Format Data................................................ 98 4.2.1.2.1 Kesalahan Format Email ............................................................ 98 4.2.1.2.2 Kesalahan Format Waktu........................................................... 99 4.2.1.3 Penanganan Kesalahan Range Data ............................................... 100 4.2.1.3.1 Kesalahan Range Data Minus .................................................. 100 4.2.1.4 Penanganan Penghapusan Data...................................................... 101 4.2.2 Pengujian Sistem................................................................................... 101 4.2.3 Hasil Analisis ....................................................................................... 102
BAB V................................................................................................................. 103 SIMPULAN DAN SARAN ............................................................................... 103 5.1 Simpulan.................................................................................................. 103 5.2 Saran........................................................................................................ 103
xvi
DAFTAR TABEL
Tabel 3.1 Tabel Anggota........................................................................................31 Tabel 3.2 Tabel Atribut ..........................................................................................31 Tabel 3.3 Tabel barang...........................................................................................32 Tabel 3.4 Tabel event............................................................................................32 Tabel 3.5 Tabel jadwal...........................................................................................33 Tabel 3.6 Tabel Jenis_acara ...................................................................................33 Tabel 3.7 Tabel kateg_pan .....................................................................................33 Tabel 3.8 Tabel kategdetail ....................................................................................34 Tabel 3.9 Tabel kategori ........................................................................................34 Tabel 3.10 Tabel Layout ........................................................................................35 Tabel 3.11 Tabel Modul.........................................................................................35 Tabel 3.12 Tabel panitia.........................................................................................36 Tabel 3.13 Tabel pelanggan ...................................................................................36 Tabel 3.14 Tabel pemesanan..................................................................................37 Tabel 3.15 Tabel Pesanbarang ...............................................................................37 Tabel 3.16 Tabel Pesanlayout ................................................................................38 Tabel 3.17 Tabel Profile.........................................................................................38 Tabel 3.18 Tabel ukuran ........................................................................................39
xvii
DAFTAR GAMBAR
Gambar 3.1 Diagram konteks ................................................................................26 Gambar 3.2 DFD level 1 ........................................................................................27 Gambar 3.3 DFD level 2 about us..........................................................................28 Gambar 3.4 DFD Level 2 Manajemen Sistem .......................................................29 Gambar 3.5 DFD Level 2 Perancangan Wedding ..................................................30 Gambar 3.6 DFD Level 3 Print Modul..................................................................31 Gambar 3.7 Rancangan halaman index sistem.......................................................41 Gambar 3.8 Rancangan halaman profil wedding organizer...................................42 Gambar 3.9 Rancangan halaman index sistem.......................................................43 Gambar 3.10 Rancangan halaman index sistem.....................................................44 Gambar 3.11 Rancangan Login Member ...............................................................45 Gambar 3.12 Rancangan Halaman Identitas Pelanggan ........................................46 Gambar 3.13 Rancangan Halaman Pemesanan Acara ...........................................46 Gambar 3.14 Rancangan Halaman Daftar Barang.................................................47 Gambar 3.15 Rancangan Pemesanan Barang.........................................................48 Gambar 3.16 Rancangan Halaman Otentifikasi Harga ..........................................48 Gambar 3.17 Rancangan Halaman Masukkan Jadwal...........................................49 Gambar 3.18 Rancangan Halaman Susunan Jadwal ..............................................50 Gambar 3.19 Rancangan Halaman Masukkan Panitia...........................................51 Gambar 3.20 Rancangan Halaman Susunan Panitia ..............................................52 Gambar 3.21 Rancangan Halaman Modul .............................................................52 Gambar 3.22 Rancangan Halaman Edit Password Member ..................................53 Gambar 3.23 Rancangan Halaman Edit Anggota ..................................................53 Gambar 3.24 Rancangan Halaman Submit Anggota .............................................54 Gambar 3.25 Rancangan halaman edit barang.......................................................55 Gambar 3.26 Rancangan Halaman Submit Barang................................................55 Gambar 3.27 Rancangan Halaman Edit Barang ....................................................55 Gambar 3.28 Rancangan Halaman Submit Atribut................................................57
xviii
Gambar 3.29 Rancangan Halaman Edit Jenis Barang ...........................................57 Gambar 3.30 Rancangan Halaman Submit Jenis Barang.......................................58 Gambar 3.31 Rancangan Halaman Edit Detail Barang..........................................59 Gambar 3.32 Rancangan Halaman Submit Detail Barang.....................................59 Gambar 3.33 Rancangan Halaman Daftar Pelanggan............................................60 Gambar 3.34 Rancangan Halaman Edit Jenis Acara .............................................61 Gambar 3.35 Rancangan Halaman Submit Jenis Acara.........................................61 Gambar 3.36 Rancangan Halaman Edit Kategori Panitia......................................62 Gambar 3.37 Rancangan Halaman Submit Kategori Panitia .................................62 Gambar 3.38 Rancangan Halaman Profile .............................................................63 Gambar 3.39 Rancangan Halaman Edit Profile .....................................................64 Gambar 3.40 Rancangan Halaman Edit Event.......................................................65 Gambar 3.41 Rancangan Halaman Submit Event ..................................................65 Gambar 3.42 Rancangan Halaman Edit Modul .....................................................66 Gambar 4.1 Halaman index sistem ........................................................................68 Gambar 4.2 Halaman index about us .....................................................................69 Gambar 4.3 Halaman profil wedding organizer.....................................................69 Gambar 4.4 Halaman galery ..................................................................................70 Gambar 4.5 Halaman event....................................................................................71 Gambar 4.6 Halaman login member ......................................................................72 Gambar 4.7 Halaman index member .....................................................................72 Gambar 4.8 Halaman pengisian identitas pelanggan .............................................73 Gambar 4.9 Halaman pemesanan acara .................................................................73 Gambar 4.10 Halaman daftar barang .....................................................................74 Gambar 4.11 Halaman pemesanan barang.............................................................75 Gambar 4.12 Halaman otentifikasi harga...............................................................75 Gambar 4.13 Halaman masukkan jadwal...............................................................76 Gambar 4.14 Halaman susunan jadwal..................................................................76 Gambar 4.15 Halaman form input panitia..............................................................77 Gambar 4.16 Halaman susunan panitia..................................................................77 Gambar 4.17 Halaman modul I..............................................................................78
xix
Gambar 4.18 Halaman modul II.............................................................................79 Gambar 4.19 Halaman edit password ....................................................................80 Gambar 4.20 Halaman edit anggota.......................................................................80 Gambar 4.21 Halaman submit anggota..................................................................81 Gambar 4.22 Halaman daftar barang .....................................................................81 Gambar 4.23 Halaman submit barang....................................................................82 Gambar 4.24 Halaman edit barang.........................................................................82 Gambar 4.25 Halaman submit atribut ....................................................................83 Gambar 4.26 Halaman edit jenis barang ................................................................84 Gambar 4.27 Halaman submit jenis barang ...........................................................84 Gambar 4.28 Halaman edit detail barang...............................................................85 Gambar 4.29 Halaman submit detail barang..........................................................85 Gambar 4.30 Halaman daftar pelanggan................................................................86 Gambar 4.31 Halaman jenis acara .........................................................................86 Gambar 4.32 Halaman submit jenis acara..............................................................87 Gambar 4.33 Halaman edit kategori panitia ..........................................................87 Gambar 4.34 Halaman submit kategori panitia......................................................88 Gambar 4.35 Halaman profile................................................................................88 Gambar 4.36 Halaman edit profile.........................................................................89 Gambar 4.37 Halaman edit event...........................................................................89 Gambar 4.38 Halaman submit event......................................................................90 Gambar 4.39 Halaman edit modul ........................................................................90 Gambar 4.40 Halaman submit modul ....................................................................90 Gambar 4.41 Tabel weddingku ..............................................................................92 Gambar 4.42 Tabel pesanbarang............................................................................93 Gambar 4.43 Sintaks SQL Modul pemesanan .......................................................94 Gambar 4.44 Sintaks SQL Penghitungan biaya.....................................................95 Gambar 4.45 kesalahan pengisian username atau password..................................97 Gambar 4.46 Pengisian password baru tidak valid ................................................97 Gambar 4.47 Kesalahan pengisian password baru (kosong) .................................97 Gambar 4.48 Kesalahan pengisian password baru (kosong) .................................98
xx
Gambar 4.49 Kekosongan field..............................................................................98 Gambar 4.50 Kesalahan pengisian email ...............................................................99 Gambar 4.51 Kesalahan format waktu...................................................................99 Gambar 4.52 Kesalahan Jam................................................................................100 Gambar 4.53 Kesalahan Menit.............................................................................100 Gambar 4.54 Kesalahan Menit.............................................................................100 Gambar 4.55 Penghapusan Data..........................................................................101
xxi