DAFTAR ISI Halaman Halaman Judul ......................................................................................................i Halaman Pengesahan...........................................................................................ii Halaman Pernyataan ..........................................................................................iii Halaman Moto Dan Persembahan ....................................................................iv Kata Pengantar .................................................................................................... v Abstrak.................................................................................................................vi Abstract...............................................................................................................vii Daftar Isi ............................................................................................................viii Daftar Gambar...................................................................................................xii Daftar Tabel ......................................................................................................xiv BAB 1 PENDAHULUAN .................................................................................... 1 1.1 Latar Belakang ..................................................................................... 1 1.2 Rumusan Masalah ................................................................................ 2 1.3 Ruang Lingkup..................................................................................... 2 1.4 Tujuan Penelitian ................................................................................. 2 1.5 Manfaaat Penelitian ............................................................................. 3 1.6 Sistematika Penulisan .......................................................................... 3 BAB 2 TINJAUAN PUSTAKA DAN DASAR TEORI .................................... 5 2.1 Tinjauan Pustaka .................................................................................. 5 2.2 Dasar Teori............................................................................... 7 2.2.1 Sistem Informasi ................................................................... 7 2.2.2 Basis Data ............................................................................. 8 2.2.3 PHP (PHP Hypertext Preprocessor)..................................... 8 2.2.4 Database MySQL.................................................................. 9
viii
2.2.5 Internet .................................................................................. 9 2.2.6 Persediaan Metode Rata-Rata ............................................. 10 BAB 3 METODE PENELITIAN...................................................................... 12 3.1 Data .................................................................................................... 12 3.2 Peralatan............................................................................................. 13 3.2.1 Perangkat Lunak (Software) ............................................... 13 3.2.2 Perangkat Keras (Hardware) .............................................. 13 3.3 Prosedur dan Pengumpulan Data ....................................................... 14 3.3.1 Sumber Data Primer............................................................ 14 3.3.2 Sumber Data Sekunder ....................................................... 15 3.4 Analisis dan Rancangan Sistem ......................................................... 15 3.4.1 Kebutuhan Fungsional ........................................................ 16 3.4.2 Kebutuhan Non Fungsional ................................................ 16 3.4.3 Diagram Konteks ................................................................ 16 3.4.4 Diagram Arus Data Level 1 ................................................ 17 3.4.5 Rancangan Diagram Alir Sistem......................................... 19 3.4.6 Relasi Antar Tabel .............................................................. 20 3.4.7 Rancangan Struktur Tabel................................................... 21 1.Tabel Kategori .............................................................. 21 2.Tabel Barang ................................................................. 21 3. Tabel Admin ................................................................ 22 4. Tabel Supplier .............................................................. 23 5. Tabel Penjualan............................................................ 23 6. Tabel Detail Penjualan ................................................. 24
ix
7. Tabel Pembelian........................................................... 24 8. Tabel Detail Pembelian................................................ 25 9. Tabel Persediaan .......................................................... 26 3.4.8 Rancangan Masukan (Input) ............................................... 27 1. Form Merk ................................................................... 27 2. Form Barang ................................................................ 27 3. Form Penjualan ............................................................ 28 4. Form Detail Penjualan ................................................. 29 5. Form Supplier .............................................................. 29 6. Form Pembelian ........................................................... 30 7. Form Detail Pembelian ................................................ 31 3.4.9 Rancangan Keluaran (Output) ............................................ 32 1. Daftar Barang............................................................... 32 2. Laporan Penjualan Per Periode .................................... 32 3. Laporan Pembelian Per Priode..................................... 33 4. Kartu Gudang............................................................... 34 5. Kartu Persediaan .......................................................... 34 BAB 4 IMPLEMENTASI DAN PEMBAHASAN .......................................... 35 4.1 Implementasi dan Uji Coba Sistem.................................................... 35 4.1.1 Program Penghubung Database .......................................... 35 4.1.2 Index ................................................................................... 36 4.1.3Input Kategori ...................................................................... 37 4.1.4Input Barang......................................................................... 38 4.1.5Input Penjualan .................................................................... 39
x
4.1.6Input Detail Penjualan.......................................................... 40 4.1.7Input Supplier....................................................................... 42 4.1.8 Fungsi Pembelian................................................................ 42 4.1.9Input Detail Pembelian......................................................... 43 4.1.10Input Barang....................................................................... 45 4.1.11 Laporan Penjualan Per Periode ......................................... 46 4.1.12 Laporan Supplier............................................................... 48 4.1.13 Laporan Pembelian Per Periode........................................ 49 4.1.14 Kartu Gudang.................................................................... 50 4.1.15 Kartu Persediaan ............................................................... 51 4.1.16 Uji Coba Form Login........................................................ 52 4.1.17 Uji Coba Form Barang...................................................... 54 4.1.18 Uji Coba Form Penjualan.................................................. 55 4.1.19 Uji Coba Form Detail Penjualan....................................... 56 4.1.20 Hasil Output Daftar Barang ............................................. 59 4.1.21 Hasil Output Laporan Supplier ......................................... 59 4.1.22 Hasil Output Laporan Penjualan Per Periode ................... 60 4.1.23 Hasil Output Kartu Persediaan.......................................... 6o 4.1.24 Hasil Output Kartu Persediaan.......................................... 61 4.2 Pembahasan........................................................................................ 62 BAB 5 PENUTUP .............................................................................................. 63 5.1 Kesimpulan ........................................................................................ 63 5.2 Saran .................................................................................................. 64 DAFTAR PUSTAKA......................................................................................... 65
xi
DAFTAR GAMBAR Halaman Gambar 3.1 Arsitektur Persediaan barang ............................................................ 15 Gambar 3.2 Rancangan Diagram ArusData Level 0 ............................................. 17 Gambar 3.3 Rancangan Diagram Arus Data Level 1 ............................................ 18 Gambar 3.4 Diagram Alir Sistem ......................................................................... 19 Gambar 3.5 Relasi Antar Tabel ............................................................................ 20 Gambar 3.6 Rancangan Form Kategori ................................................................ 27 Gambar 3.7 Rancangan Form Barang................................................................... 28 Gambar 3.8 Rancangan Form Penjualan............................................................... 28 Gambar 3.9 Rancangan Form Detail Penjualan.................................................... 29 Gambar 3.10 Rancangan Form Supplier............................................................... 30 Gambar 3.11 Rancangan Form Pembelian ........................................................... 30 Gambar 3.12 Rancangan Form Detail Pembelian................................................. 31 Gambar 3.13 Rancangan Form Daftar Barang...................................................... 32 Gambar 3.14 Rancangan Laporan Penjualan Per Periode .................................... 33 Gambar 3.15 Rancangan Laporan Pembelian Per Periode ................................... 33 Gambar 3.16 Rancangan Kartu Gudang ............................................................... 34 Gambar 3.17 Rancangan Kartu Persediaan........................................................... 34 Gambar 4.1 Program Penghubung ........................................................................ 35 Gambar 4.2 Index.................................................................................................. 36 Gambar 4.3 Program Input Kategori .................................................................... 37 Gambar 4.4 Program Input Barang ....................................................................... 38 Gambar 4.5 Program Input Penjualan................................................................... 39
xii
Gambar 4.6 Program Input Detail Penjualan ........................................................ 40 Gambar 4.7 Program Input Supplier ..................................................................... 42 Gambar 4.8 Fungsi Input Pembelian .................................................................... 43 Gambar 4.9 Program Input Detail Pembelian....................................................... 44 Gambar 4.10 Program Daftar Barang ................................................................... 45 Gambar 4.11 Program Laporan Penjualan............................................................ 47 Gambar 4.12 Program Laporan Supplier .............................................................. 48 Gambar 4.13 Program Laporan Pembelian........................................................... 49 Gambar 4.14 Program Kartu Gudang ................................................................... 50 Gambar 4.15 Program Kartu Persediaan .............................................................. 51 Gambar 4.16 Form Login ..................................................................................... 52 Gambar 4.17 Pesan Kesalahan Login .................................................................. 53 Gambar 4.18 Input Data Barang Berhasil............................................................. 54 Gambar 4.19 Data Barang Tidak Diproses ........................................................... 55 Gambar 4.20 Input Data Penjualan Berhasil......................................................... 56 Gambar 4.21 Data Penjualan Tidak Diproses ....................................................... 56 Gambar 4.22 Input Data Detail Penjualan Berhasil............................................ 57 Gambar 4.23 Penjualan Melebihi Stok ................................................................. 57 Gambar 4.24 Data Detail Penjualan Tidak Diproses ............................................ 57 Gambar 4.25 Hasil Output Daftar Barang ............................................................ 59 Gambar 4.26 Hasil Output Laporan Supplier ...................................................... 59 Gambar 4.27 Hasil Output Laporan Penjualan Per Periode.................................. 60 Gambar 4.28 Hasil Output Kartu persediaan ........................................................ 60 Gambar 4.29 Hasil Output Kartu Gudang ............................................................ 61
xiii
DAFTAR TABEL Halaman Tabel 2.1 Perbedaaan Penelitian Sebelumnya ........................................................ 7 Tabel 2.2 Kartu Persediaan ................................................................................... 11 Tabel 3.1 Rancangan Struktur Tabel Kategori ..................................................... 21 Tabel 3.2 Rancangan Struktur Tabel Barang ........................................................ 22 Tabel 3.3 Rancangan Struktur Admin .................................................................. 22 Tabel 3.4 Rancangan Struktur Supplier ................................................................ 23 Tabel 3.5 Rancangan Struktur Tabel Penjualan.................................................... 23 Tabel 3.6 Rancangan Struktur Tabel Detail Penjualan ......................................... 24 Tabel 3.7 Rancangan Struktur Tabel Pembelian................................................... 25 Tabel 3.8 Rancangan Struktur Tabel Detail Pembelian....................................... 25 Tabel 3.9 Rancangan Struktur Tabel Kartu Gudang............................................ 26 Tabel 4.1 Data User .............................................................................................. 53 Tabel 4.2 Uji Coba Form Login............................................................................ 53 Tabel 4.3 Uji Coba Form Barang.......................................................................... 54 Tabel 4.4 Uji Coba Form Penjualan...................................................................... 55 Tabel 4.5 Data Penjualan ...................................................................................... 55 Tabel 4.6 Uji Coba Detail Penjualan .................................................................... 57 Tabel 4.7 Data Detail Penjualan ........................................................................... 57 Tabel 4.8 Penyelesaian Kartu Persediaan ............................................................. 62
xiv
LAMPIRAN
Lampiran 1. Manual Penggunaan aplikasi. Lampiran 2. Copy Surat Pengantar Survey/pengambilan data dan surat keterangan hasil uji coba tempat penelitian. .
xv