KATA PENGANTAR Alhamdulillah Puji syukur penulis panjatkan atas ke hadirat Allah SWT atas kehendak-Nya penelitian berjudul “SISTEM INFORMASI PENGOLAHAN DATA PENJUALAN TANAH KAVLING BERBASIS WEB PADA CV ANAQU PUTRA KARYA” ini dapat terselesaikan tepat waktu.
Pada penelitian ini penulis membahas mengenai aplikasi yang menangani pengolahan data pada CV ANAQU PUTRA KARYA. Berdasarkan analisis kebutuhan yang dilaksanakan pada CV ANAQU PUTRA KARYA, maka dibuatlah sistem informasi tersebut. Aplikasi ini dirancang menggunakan php dan MySQL dengan alasan proses pengembangan aplikasi lebih mudah dilakukan. Penelitian proyek akhir ini dapat selesai dan terwujud berkat bantuan serta dorongan dari berbagai pihak. Untuk itu pada kesempatan ini Penulis mengucapkan banyak terima kasih kepada: 1. Bapak Irwan Sutirman dan Bapak C. Ruddi Kusnadi yang telah dengan sabar membimbing dan mengajari Penulis dalam menyelesaikan karya ilmiah ini. 2. CV ANAQU PUTRA KARYA yang telah bersedia memberikan data untuk menjadi bahan studi kasus proyek akhir ini. 3. Kedua orang tua dan keluarga yang senantiasa mendukung dan memberikan doa demi kelancaran penyelesaian proyek akhir ini. 4. Teman – teman kelas PCA0903 yang senantiasa memberikan dukungan dan semangat kerjasamanya demi penyelesaian laporan ini. Penulis menyadari bahwa laporan penelitian proyek akhir ini masih jauh dari kesempurnaan. Oleh Karena itu kritik dan saran diperlukan Penulis demi sempurnanya laporan ini. Penulis juga berharap proyek akhir ini dapat memberikan manfaat umumnya kepada pembaca, khususnya kepada CV ANAQU PUTRA KARYA.
v
Semoga proyek akhir ini dapat menjadi acuan untuk pelaksanaan penelitian yang akan datang. Bandung, 9 Agustus 2012
Penulis
vi
DAFTAR ISI KATA PENGANTAR ....................................................................................................................... v ABSTRAK .................................................................................................................................... vii ABSTRACT ................................................................................................................................. viii DAFTAR ISI .................................................................................................................................. ix DAFTAR GAMBAR ..................................................................................................................... xiii DAFTAR TABEL ........................................................................................................................... xv DAFTAR LAMPIRAN.................................................................................................................. xvii BAB 1 PENDAHULUAN ..............................................................................................................19 1.1
Latar Belakang .................................................................................................................19
1.2
Rumusan Masalah............................................................................................................20
1.3
Tujuan ..............................................................................................................................21
1.4
Batasan Masalah ..............................................................................................................21
1.5
Definisi Operasional .........................................................................................................21
1.6
Metode Pengerjaan .........................................................................................................22
1.7
Jadwal Pengerjaan ...........................................................................................................23
BAB 2 TINJAUAN PUSTAKA .......................................................................................................24 2.1
Waterfall ..........................................................................................................................24 2.1.1
Analisis Kebutuhan .......................................................................................25
2.1.2
Desain ...........................................................................................................25
2.1.3
Pembuatan Kode Program (Coding).............................................................25
2.1.4
Pengujian ......................................................................................................26
2.1.5
Implementasi ...............................................................................................26
2.1.6
Perawatan ....................................................................................................26
2.2
Sistem Informasi ..............................................................................................................26
2.3
Akuntansi .........................................................................................................................27
2.4
Pembelian ........................................................................................................................29
2.5
Penjualan .........................................................................................................................29 2.5.1
Penjualan Tunai ............................................................................................29
ix
2.5.2
Penjualan Kredit ...........................................................................................29
2.6
Jurnal................................................................................................................................29
2.7
Buku Besar .......................................................................................................................32
2.8
Php ...................................................................................................................................32
2.9
Web ..................................................................................................................................32
2.10 Xampp ..............................................................................................................................33 2.11 MySQL ..............................................................................................................................34 2.12 Alat Bantu Perancangan Sistem.......................................................................................34 2.12.1
Data Flow Diagram (DFD) atau Diagram Aliran Data (DAD) ........................34
2.12.2
Flowmap .......................................................................................................36
2.12.3
Entity Relationship Diagram (ERD)...............................................................38
BAB 3 ANALISIS DAN PERANCANGAN.......................................................................................39 3.1
3.2
3.3
Analisis Sistem Berjalan ...................................................................................................39 3.1.1
Proses Bisnis Sistem Berjalan Pembelian .....................................................39
3.1.2
Proses Bisnis Sistem Berjalan Penjualan Tunai ............................................40
3.1.3
Proses Bisnis Sistem Berjalan Penjualan Kredit ...........................................42
3.1.4
Proses Bisnis Sistem Berjalan Angsuran Kredit ............................................44
Analisis Sistem Usulan .....................................................................................................46 3.2.1
Proses Bisnis Sistem Usulan Pembelian .......................................................46
3.2.2
Proses Bisnis Sistem Usulan Penjualan ........................................................48
3.2.3
Proses Bisnis Sistem Usulan Angsuran Kredit ..............................................50
Analisis Kebutuhan Sistem (Produk) ................................................................................52 3.3.1
Analisis Proses ..............................................................................................52
3.3.2
Analisis Kebutuhan Fungsional.....................................................................52
3.3.3
Analisis Masukan dan Keluaran....................................................................53
3.3.4
Analisis Pengguna.........................................................................................57
3.3.5
Kebutuhan Antarmuka Eksternal .................................................................58
3.3.5.1 Kebutuhan Perangkat Keras...................................................................... 58 3.3.5.2 Kebutuhan Perangkat Lunak ..................................................................... 58 3.4
Perancangan ....................................................................................................................59 3.4.1
Perancangan Sistem .....................................................................................59
3.4.1.1 Diagram Konteks ....................................................................................... 59
x
3.4.1.2 DFD Level 1 ............................................................................................... 60 3.4.1.3 DFD Level 1 Proses 1 Kelola Data .............................................................. 61 3.4.1.4 DFD Level 1 Proses 3 Kelola Penjualan ..................................................... 62 3.4.1.5 DFD Level 1 Proses 4 Kelola Angsuran ...................................................... 62 3.4.1.6 DFD Level 1 Proses 5 Kelola Akuntansi ..................................................... 63 3.4.1.7 DFD Level 1 Proses 6 Cetak Laporan ......................................................... 63 3.4.1.8 Kamus Data ............................................................................................... 64 3.4.1.9 Spesifikasi Proses ...................................................................................... 72 3.4.2
Perancangan Basis Data ...............................................................................83
3.4.2.1 ER Diagram ................................................................................................ 83 3.4.2.2 Struktur Tabel ........................................................................................... 83 3.4.2.3 Diagram Relasi Antar Tabel ....................................................................... 32 3.4.3
Perancangan Struktur Menu ........................................................................86
3.4.4
Perancangan Antarmuka ..............................................................................87
BAB 4 IMPLEMENTASI DAN PENGUJIAN...................................................................................99 4.1
4.2
Implementasi ...................................................................................................................99 4.1.1
Implementasi File Sistem .............................................................................99
4.1.2
Implementasi File Basis Data......................................................................100
4.1.3
Implementasi Antarmuka...........................................................................101
Pengujian .......................................................................................................................110 4.2.1
Pengujian Proses Manual ...........................................................................110
4.2.2
Pengujian Proses Aplikasi ...........................................................................112
4.2.3
Pengujian Fungsionalitas............................................................................114
4.2.3.1 Pengujian Fungsionalitas Proses Login ................................................... 114 4.2.3.2 Pengujian Fungsionalitas Proses Input Supplier...................................... 114 4.2.3.3 Pengujian Fungsionalitas Proses Input Customer ................................... 116 4.2.3.4 Pengujian Fungsionalitas Proses Input Pembelian ................................. 118 4.2.3.5 Pengujian Fungsionalitas Proses Input Kavling ....................................... 119 4.2.3.6 Pengujian Fungsionalitas Input Penjualan .............................................. 120 4.2.3.7 Pengujian Fungsionalitas Proses Input Angsuran ................................... 121 4.2.3.8 Pengujian Fungsionalitas Proses Jurnal .................................................. 122 4.2.3.9 Pengujian Fungsionalitas Proses Buku Besar .......................................... 122
xi
4.2.3.10 Pengujian Fungsionalitas Proses Laporan Pembelian ............................. 123 4.2.3.11 Pengujian Fungsionalitas Proses Laporan Persediaan ............................ 123 4.2.3.12 Pengujian Fungsionalitas Proses Laporan Penjualan .............................. 124 BAB 5 PENUTUP ......................................................................................................................125 4.3
Kesimpulan ....................................................................................................................125
4.4
Saran ..............................................................................................................................125
DAFTAR REFERENSI..................................................................................................................126 LAMPIRAN................................................................................................................................127
xii
DAFTAR GAMBAR Gambar 2. 1 Model Waterfall ............................................................................................................... 24 Gambar 3. 1 Proses Bisnis Sistem Berjalan Pembelian ......................................................................... 39 Gambar 3. 2 Proses Bisnis Sistem Berjalan Penjualan Tunai ................................................................ 40 Gambar 3. 3 Proses Bisnis Sistem Berjalan Penjualan Kredit ............................................................... 42 Gambar 3. 4 Proses Bisnis Sistem Berjalan Angsuran Kredit ................................................................ 44 Gambar 3. 5 Proses Bisnis Sistem Usulan Pembelian ........................................................................... 46 Gambar 3. 6 Proses Bisnis Sistem Usulan Penjualan ............................................................................ 48 Gambar 3. 7 Proses Bisnis Sistem Usulan Angsuran Kredit .................................................................. 50 Gambar 3. 8 Analisis Masukan dan Keluaran........................................................................................ 53 Gambar 3. 9 Diagram Konteks .............................................................................................................. 59 Gambar 3. 10 DFD Level 1 ..................................................................................................................... 60 Gambar 3. 11 DFD Level 1 Proses 1 Kelola Data ................................................................................... 61 Gambar 3. 12 DFD Level 1 Proses 3 Kelola Penjualan........................................................................... 62 Gambar 3. 13 DFD Level 1 Proses 4 Kelola Angsuran ........................................................................... 62 Gambar 3. 14 DFD Level 1 Proses 5 Kelola Akuntansi .......................................................................... 63 Gambar 3. 15 DFD Level 1 Proses 6 Cetak Laporan .............................................................................. 63 Gambar 3. 16 ER Diagram ..................................................................................................................... 83 Gambar 3. 17 Skema Relasi................................................................................................................... 86 Gambar 3. 18 Struktur menu Admin..................................................................................................... 86 Gambar 3. 19 Struktur Menu Keuangan ............................................................................................... 87 Gambar 3. 20 Perancangan Antarmuka Login ...................................................................................... 87 Gambar 3. 21 Perancangan Antarmuka Home ..................................................................................... 87 Gambar 3. 22 Perancangan Antarmuka User ....................................................................................... 88 Gambar 3. 23 Perancangan Antarmuka Tambah User ......................................................................... 88 Gambar 3. 24 Perancangan Antarmuka Edit User ................................................................................ 89 Gambar 3. 25 Perancangan Antarmuka Supplier .................................................................................. 89 Gambar 3. 26 Perancangan Antarmuka Tambah Supplier .................................................................... 90 Gambar 3. 27 Perancangan Antarmuka Edit Supplier........................................................................... 90 Gambar 3. 28 Perancangan Antarmuka Customer ............................................................................... 91 Gambar 3. 29 Perancangan Antarmuka Tambah Customer ................................................................. 91 Gambar 3. 30 Perancangan Antarmuka Edit Customer ........................................................................ 92 Gambar 4. 1 Implementasi File Basis Data.......................................................................................... 100 Gambar 4. 2 Implementasi Login ........................................................................................................ 101 Gambar 4. 3 Implementasi Menu Admin........................................................................................... 101 Gambar 4. 4 Implementasi User ......................................................................................................... 102 Gambar 4. 5 Implementasi Tambah User ........................................................................................... 102 Gambar 4. 6 Implementasi Edit User .................................................................................................. 102
xiii
Gambar 4. 7 Implementasi Supplier.................................................................................................... 103 Gambar 4. 8 Implementasi Tambah Supplier...................................................................................... 103 Gambar 4. 9 Implementasi Edit Supplier ............................................................................................ 103 Gambar 4. 10 Implementasi Customer ............................................................................................... 104 Gambar 4. 11 Implementasi Tambah Customer ................................................................................. 104 Gambar 4. 12 Implementasi Edit Customer ........................................................................................ 105 Gambar 4. 13 Implementasi Pembelian ............................................................................................. 105 Gambar 4. 14 Implementasi Tambah Pembelian ............................................................................... 106 Gambar 4. 15 Implementasi Kavling ................................................................................................... 106 Gambar 4. 16 Implementasi Tambah Kavling ..................................................................................... 107 Gambar 4. 17 Implementasi Edit Kavling ............................................................................................ 107 Gambar 4. 18 Implementasi Penjualan............................................................................................... 107 Gambar 4. 19 Implementasi Tambah Penjualan................................................................................. 108 Gambar 4. 20 Implementasi Jurnal ..................................................................................................... 108 Gambar 4. 21 Implementasi Buku Besar............................................................................................. 109 Gambar 4. 22 Implementasi Laporan Pembelian ............................................................................... 109 Gambar 4. 23 Implementasi Laporan Persediaan............................................................................... 109 Gambar 4. 24 Implementasi Laporan Penjualan................................................................................. 110 Gambar 4. 25 Transaksi Pembelian..................................................................................................... 112 Gambar 4. 26 Jurnal Pembelian .......................................................................................................... 112 Gambar 4. 27 Transaksi Penjualan ...................................................................................................... 112 Gambar 4. 28 Jurnal Penjualan ........................................................................................................... 112 Gambar 4. 29 Transaksi Penjualan ...................................................................................................... 113 Gambar 4. 30 Jurnal Penjualan ........................................................................................................... 113 Gambar 4. 31 Transaksi Angsuran ...................................................................................................... 113 Gambar 4. 32 Jurnal Angsuran ............................................................................................................ 113
xiv
DAFTAR TABEL Tabel 1. 1 Jadwal Pengerjaan ................................................................................................................23 Tabel 2. 1 Jurnal Pembelian .................................................................................................................. 31 Tabel 2. 2 Jurnal Penjualan Tunai ......................................................................................................... 31 Tabel 2. 3 Jurnal Penjualan Kredit......................................................................................................... 31 Tabel 2. 4 Jurnal Pembayaran Uang Muka ........................................................................................... 32 Tabel 2. 5 Formulir Buku Besar Akun Baris dan Kolom ......................................................................... 32 Tabel 2. 6 Notasi Pada DFD (Edward Yourdan dan Tom DeMarco) ...................................................... 34 Tabel 2. 7 Simbol – Simbol Dalam Bagan Alir Dokumen ....................................................................... 36 Tabel 2. 8 Notasi ERD ............................................................................................................................38 Tabel 3. 1 Analisis Pengguna ................................................................................................................. 57 Tabel 3. 2 Kamus Data Tambah Supplier............................................................................................... 64 Tabel 3. 3 Kamus Data Rekam Supplier................................................................................................. 64 Tabel 3. 4 Kamus Data Tambah Customer ........................................................................................... 65 Tabel 3. 5 Kamus Data Rekam Customer .............................................................................................. 65 Tabel 3. 6 Kamus Data Kavling ............................................................................................................. 66 Tabel 3. 7 Kamus Data Rekam Kavling .................................................................................................. 66 Tabel 3. 8 Kamus Data Rekam Pembelian............................................................................................ 67 Tabel 3. 9 Kamus Data Rekam Penjualan ............................................................................................. 67 Tabel 3. 10 Kamus Data Penjualan........................................................................................................ 68 Tabel 3. 11 Kwitansi Penjualan ............................................................................................................. 68 Tabel 3. 12 Kamus Data Rekam Angsuran ............................................................................................ 69 Tabel 3. 13 Kamus Data Angsuran ....................................................................................................... 69 Tabel 3. 14 Kamus Data Kwitansi Angsuran .......................................................................................... 69 Tabel 3. 15 Kamus Data Jurnal .............................................................................................................. 70 Tabel 3. 16 Kamus Data Buku Besar...................................................................................................... 70 Tabel 3. 17 Kamus Data Laporan Pembelian ........................................................................................ 71 Tabel 3. 18 Kamus Data Laporan Persediaan........................................................................................ 71 Tabel 3. 19 Kamus Data Laporan Penjualan ......................................................................................... 72 Tabel 3. 20 Spesifikasi Proses 1.1 Input Supplier .................................................................................. 72 Tabel 3. 21 Spesifikasi Proses 1.2 Update Supplier ............................................................................... 73 Tabel 3. 22 Spesifikasi Proses 1.3 Detele Supplier ................................................................................ 73 Tabel 3. 23 Spesifikasi Proses 1.4 Input Kavling .................................................................................... 74 Tabel 3. 24 Spesifikasi Proses 1.5 Update Kavling ................................................................................ 74 Tabel 3. 25 Spesifikasi Proses 1.6 Detele Kavling .................................................................................. 75 Tabel 3. 26 Spesifikasi Proses 1.7 Input Customer ................................................................................ 75 Tabel 3. 27 Spesifikasi Proses 1.8 Update Customer ............................................................................ 76
xv
Tabel 3. 28 Spesifikasi Proses 1.9 Detele Customer .............................................................................. 77 Tabel 3. 29 Spesifikasi Proses 2 Kelola Pembelian ................................................................................ 70 Tabel 3. 30 Spesifikasi Proses 3.1 Input Penjualan ............................................................................... 70 Tabel 3. 31 Spesifikasi Proses 3.2 Cetak Kwitansi ................................................................................. 78 Tabel 3. 32 Spesifikasi Proses 4.1 Input Angsuran ................................................................................ 79 Tabel 3. 33 Spesifikasi Proses 4.2 Cetak Kwitansi ................................................................................. 80 Tabel 3. 34 Spesifikasi Proses 5.1 Membuat Jurnal .............................................................................. 80 Tabel 3. 35 Spesifikasi Proses 5.2 Membuat Buku Besar ...................................................................... 81 Tabel 3. 36 Spesifikasi Proses 6.1 Cetak Laporan Pembelian ............................................................... 81 Tabel 3. 37 Spesifikasi Proses 6.2 Cetak Laporan Persediaan ............................................................... 82 Tabel 3. 38 Spesifikasi Proses 6.3 Cetak Laporan Penjualan................................................................. 82 Tabel 3. 39 Struktur Tabel Supplier ....................................................................................................... 83 Tabel 3. 40 Struktur Tabel Pembelian ................................................................................................... 84 Tabel 3. 41 Struktur Tabel Kavling ........................................................................................................ 84 Tabel 3. 42 Struktur Tabel Customer .................................................................................................... 84 Tabel 3. 43 Struktur Tabel Penjualan .................................................................................................... 85 Tabel 3. 44 Struktur Tabel Angsuran..................................................................................................... 85 Tabel 4. 1 Implementasi File Sistem...................................................................................................... 99 Tabel 4. 2 Fungsionalitas Proses Login................................................................................................ 114 Tabel 4. 3 Fungsionalitas Proses Input Supplier .................................................................................. 114 Tabel 4. 4 Fungsionalitas Proses Input Customer ............................................................................... 116 Tabel 4. 5 Fungsionaliats Proses Input Pembelian .............................................................................. 118 Tabel 4. 6 Fungsionalitas Proses Input Kavling ................................................................................... 119 Tabel 4. 7 Fungsionalitas Proses Input Penjualan ............................................................................... 120 Tabel 4. 8 Fungsionalitas Proses Input Angsuran................................................................................ 121 Tabel 4. 9 Fungsionalitas Jurnal .......................................................................................................... 122 Tabel 4. 10 Fungsionalitas Proses Buku Besar .................................................................................... 122 Tabel 4. 11 Fungsionalitas Proses Laporan Pembelian ....................................................................... 123 Tabel 4. 12 Fungsionalitas Proses Laporan Persediaan ...................................................................... 123 Tabel 4. 13 Fungsionalitas Proses Laporan Penjualan ........................................................................ 124
xvi
DAFTAR LAMPIRAN Lampiran 1 .......................................................................................................................................... 127 Lampiran 2 .......................................................................................................................................... 127 Lampiran 3 .......................................................................................................................................... 128 Lampiran 4 .......................................................................................................................................... 128 Lampiran 5 .......................................................................................................................................... 129 Lampiran 6 .......................................................................................................................................... 129 Lampiran 7 .......................................................................................................................................... 130 Lampiran 8 .......................................................................................................................................... 130 Lampiran 9 .......................................................................................................................................... 130
xvii
xviii
