DAFTAR ISI Halaman Halaman Judul ............................................................................................................................... i Halaman Persetujuan ................................................................................................................... ii Halaman Pengesahan................................................................................................................... iii Halaman Persembahan ............................................................................................................... iv Halaman Motto ..............................................................................................................................v Intisari ........................................................................................................................................... vi Kata Pengantar ........................................................................................................................... vii Daftar Isi ..................................................................................................................................... viii Daftar Gambar .............................................................................................................................xv Daftar Tabel .............................................................................................................................. xvii BAB 1 PENDAHULUAN ..............................................................................................................1 1.1 Latar Belakang Masalah .........................................................................................................1 1.2 Rumusan Masalah ..................................................................................................................2 1.3 Ruang Lingkup .......................................................................................................................2 1.4 Tujuan.....................................................................................................................................2 BAB II TINJAUAN PUSTAKA DAN DASAR TEORI .............................................................4 2.1 Tinjauan Pustaka ....................................................................................................................4
v - xv
2.2 Gambaran Umum Toko Uni Solo ..........................................................................................5 2.3 Dasar Teori .............................................................................................................................5 2.3.1 Sistem Informasi ..............................................................................................................6 2.3.2 Internet dan Web .............................................................................................................6 2.3.3 HTML ..............................................................................................................................6 2.3.4 PHP ..................................................................................................................................7 2.3.5 MySQL ............................................................................................................................7 2.3.6 Basis Data ........................................................................................................................7 BAB III ANALISIS DAN PERANCANGAN SISTEM..............................................................8 3.1 Analisis Sistem .......................................................................................................................8 3.1.1 Analisis Kebutuhan ........................................................................................................8 3.1.2 Perangkat Lunak (Software) ..........................................................................................9 3.1.3 Perangkat Keras (Hardware) ........................................................................................10 3.1.4 Pengguna (user) dan fungsinya ....................................................................................11 3.2 Perancangan Sistem..............................................................................................................11 3.2.1 Perancangan Diagram Alir Data ..................................................................................12 3.2.2 Diagram Konteks .........................................................................................................12 3.2.3 Diagram Alir Data Level 1 ..........................................................................................13 3.2.4 Perancangan Relasi Antar Tabel ..................................................................................15 3.2.5 Diagram Alir Sistem (DAS).........................................................................................16
v - xv
3.3 Perancangan Basis Data .....................................................................................................17 3.3.1 Rancangan Tabel Karyawan .....................................................................................17 3.3.2 Rancangan Tabel Merk ............................................................................................18 3.3.3 Rancangan Tabel Ongkos Kirim ..............................................................................18 3.3.4 Rancangan Tabel Barang .........................................................................................19 3.3.5 Rancangan Tabel Order ............................................................................................20 3.3.6 Rancangan Tabel Konfirmasi ...................................................................................21 3.3.7 Rancangan Tabel Detail Order .................................................................................22 3.3.8 Rancangan Tabel Pelanggan .....................................................................................23 3.3.9 Rancangan Tabel Buku Tamu ..................................................................................24 3.4 Rancangan Antar Muka .....................................................................................................24 3.4.1 Rancangan Login Pelanggan ....................................................................................25 3.4.1 Halaman Home ........................................................................................................25 3.4.2 Halaman Login Karyawan .......................................................................................26 3.4.3 Halaman Home Karyawan ........................................................................................27 3.5 Rancangan Masukan (Input) ................................................................................................27 3.5.1 Rancangan Input Data Pelanggan ............................................................................27 3.5.2 Rancangan Input Data Buku Tamu ...........................................................................28
v - xv
3.5.3 Rancangan Input Data Merk ....................................................................................29 3.5.4 Rancangan Input Data Barang .................................................................................30 3.5.5 Rancangan Input Data Order .....................................................................................30 3.5.6 Rancangan Input Konfirmasi Pembelian .................................................................30 3.5.7 Rancangan Input Data Karyawan .................................................................................. 31 3.5.8 Rancangan Input Data Ongkos Kirim ............................................................................ 31 3.6 Rancangan Keluaran(Output) .............................................................................................31 3.6.1 Rancangan Output Data Merk Barang ............................................................................. 32 3.6.2 Rancangan Output Data Barang Permerk .................................................................32 3.6.3 Rancangan Output Data Ongkos Kirim ....................................................................33 3.6.4 Rancangan Output Data Pelanggan ...........................................................................33 3.6.5 Rancangan Output Laporan Perperiode .....................................................................34 3.6.6 Rancangan Output Laporan Penjualan Terlaris ........................................................34 3.6.7 Rancangan Output Laporan Pernota ..........................................................................35 3.6.8 Rancangan Output Laporan Order Terkirim ............................................................35 3.6.9 Rancangan Output Laporan Order Belum Terkirim ................................................36 3.6.10 Rancangan Output Data Konfirmasi Order ............................................................36 3.6.11 Rancangan Output Laporan Order Belum Terkirim ..............................................36
v - xv
BAB IV IMPLEMENTASI DAN PEMBAHASAN SISTEM .................................................37 4.1 Implementasi Sistem ..........................................................................................................37 4.1.1 Program penghubung Database ................................................................................37 4.1.2 Halaman Pelanggan .................................................................................................38 4.1.2.1 Halaman Beranda .............................................................................................38 4.1.2.2 Halaman Detail Barang ....................................................................................39 4.1.2.3 Halaman Buku Tamu .......................................................................................40 4.1.2.4 Halaman Keranjang Belanja .............................................................................41 4.1.2.5 Halaman Order .................................................................................................42 4.1.2.6 Halaman Detail Order .......................................................................................43 4.1.2.7 Halaman Konfirmasi Pembayaran ...................................................................43 4.1.2.8 Halaman Login .................................................................................................44 4.1.2.9 Halaman Pendaftaran Pelanggan .....................................................................44 4.1.3 Halaman Karyawan .................................................................................................45 4.1.3.1 Halaman Beranda .............................................................................................45 4.1.3.2 Halaman Merk .................................................................................................46 4.1.3.3 Halaman Barang ...............................................................................................47 4.1.3.4 Halaman Ongkos Kirim ....................................................................................48
v - xv
4.1.3.5 Halaman Daftar Pelanggan ..............................................................................49 4.1.3.6 Halaman Daftar Karyawan ...............................................................................50 4.1.3.7 Halaman Laporan Pernota ................................................................................50 4.1.3.8 Halaman Laporan Perperiode ..........................................................................51 4.1.3.9 Halaman Laporan Konfirmasi Order ................................................................52 4.1.3.10 Halaman Laporan Order Terkirim ..................................................................53 4.1.3.11 Halaman Laporan Order Belum Terkirim.......................................................54 4.1.3.12 Halaman Laporan Barang Permerk .................................................................54 4.1.3.13 Halaman Laporan Barang Terlaris ..................................................................55 4.2 Pembahasan ...........................................................................................................................56 4.2.1 Order Barang ..............................................................................................................56 4.2.2 Menu Input Data Merk ..............................................................................................60 4.2.3 Menu Input Data Barang ...........................................................................................62 4.2.4 Menu Input Data Ongkos Kirim ...............................................................................64 4.2.5 Halaman Laporan Pernota .........................................................................................66 4.2.6 Halaman Laporan Perperiode ....................................................................................67 4.2.7 Halaman Laporan Konfirmasi Order .........................................................................68 4.2.8 Halaman Laporan Order Terkirim .............................................................................69
v - xv
4.2.9 Halaman Laporan Order Belum Terkirim..................................................................70 4.2.10 Halaman Laporan Barang Permerk ..........................................................................71 4.2.11 Halaman Laporan Barang Terlaris ...........................................................................72 BAB V PENUTUP .......................................................................................................................74 5.1 Kesimpulan .................................................................................................................74 5.2 Saran ............................................................................................................................75 DAFTAR PUSTAKA
v - xv
DAFTAR GAMBAR Halaman Gambar 3.1 Rancangan Halaman Login Pelanggan ......................................................................25 Gambar 3.2 Rancangan Halaman Home ........................................................................................26 Gambar 3.3 Rancangan Halaman Login Karyawan ......................................................................26 Gambar 3.4 Rancangan Halaman Admin ......................................................................................27 Gambar 3.5 Rancangan Form Masukan Pelanggan .......................................................................28 Gambar 3.6 Rancangan Form Masukan Buku Tamu ....................................................................28 Gambar 3.7 Rancangan Form Masukan Merk ..............................................................................29 Gambar 3.8 Rancangan Form Masukan Buku Tamu ....................................................................29 Gambar 3.9 Rancangan Form Masukan Barang ...........................................................................30 Gambar 3.10 Rancangan Form Masukan Konfirmasi Pembelian ................................................30 Gambar 3.11 Rancangan Form Masukan Karyawan ....................................................................31 Gambar 3.12 Rancangan Form Masukan Ongkos Kirim ..............................................................31 Gambar 4.1 Beranda ......................................................................................................................39 Gambar 4.2 Detail Barang .............................................................................................................40 Gambar 4.3 Buku Tamu .................................................................................................................41 Gambar 4.4 Keranjang Belanja ......................................................................................................42 Gambar 4.5 Order ..........................................................................................................................42 Gambar 4.6 Detail Order................................................................................................................43
v - xv
Gambar 4.7 Konfirmasi Pembayaran .............................................................................................44 Gambar 4.8 Login ..........................................................................................................................44 Gambar 4.9 Pendaftaran.................................................................................................................45 Gambar 4.10 Beranda (Karyawan) ................................................................................................46 Gambar 4.11 Merk .........................................................................................................................47 Gambar 4.12 Barang ......................................................................................................................48 Gambar 4.13 Ongkos Kirim...........................................................................................................49 Gambar 4.14 Pelanggan .................................................................................................................49 Gambar 4.15 Karyawan .................................................................................................................50 Gambar 4.16 Laporan Pernota .......................................................................................................51 Gambar 4.17 Pernota .....................................................................................................................52 Gambar 4.18 Laporan Konfirmasi Order .......................................................................................53 Gambar 4.19 Laporan Order Terkirim ...........................................................................................53 Gambar 4.20 Laporan Order Belum Terkirim ...............................................................................54 Gambar 4.21 Laporan Barang Permerk .........................................................................................55 Gambar 4.22 Laporan Barang Terlaris ..........................................................................................55
v - xv
DAFTAR TABEL Halaman Tabel 3.1 Struktur Tabel Karyawan ...............................................................................................17 Tabel 3.2 Struktur Tabel Merk.......................................................................................................18 Tabel 3.3 Struktur Tabel Ongkos Kirim ........................................................................................19 Tabel 3.4 Struktur Tabel Barang ....................................................................................................19 Tabel 3.5 Struktur Tabel Order ......................................................................................................20 Tabel 3.6 Struktur Tabel Konfirmasi .............................................................................................21 Tabel 3.7 Struktur Tabel Detail Order ...........................................................................................22 Tabel 3.8 Struktur Tabel Pelanggan...............................................................................................23 Tabel 3.9 Struktur Tabel Buku Tamu ............................................................................................24 Tabel 3.10 Rancangan Keluaran Data Merk ..................................................................................32 Tabel 3.11 Rancangan Keluaran Data Barang Bermerk ................................................................32 Tabel 3.12 Rancangan Keluaran Data Ongkos Kirim ...................................................................33 Tabel 3.13 Rancangan Keluaran Data Pelanggan ..........................................................................33 Tabel 3.14 Rancangan Keluaran Laporan Perperiode ...................................................................34 Tabel 3.15 Rancangan Keluaran Laporan Penjualan Terlaris .......................................................34 Tabel 3.16 Rancangan Keluaran Laporan Pernota ........................................................................35 Tabel 3.17 Rancangan Keluaran Laporan Order Terkirim ............................................................35 Tabel 3.18 Rancangan Keluaran Laporan Order Belum Terkirim ................................................36
v - xv
Tabel 3.19 Rancangan Keluaran Konfirmasi Order ......................................................................36
v - xv