1 SISTEM INFORMASI PENJUALAN DAN SERVICE KOMPUTER ( STUDI KASUS JAYA KOMPUTER ) Tugas Akhir Oleh: Agung Setiawan PROGRAM STUDI SISTEM INFORMASI FAKULT...
SISTEM INFORMASI PENJUALAN DAN SERVICE KOMPUTER ( STUDI KASUS JAYA KOMPUTER )
Tugas Akhir
Oleh: Agung Setiawan 41813010023
PROGRAM STUDI SISTEM INFORMASI FAKULTAS ILMU KOMPUTER UNIVERSITAS MERCU BUANA JAKARTA 2017
http://digilib.mercubuana.ac.id/
SISTEM INFORMASI PENJUALAN DAN SERVICE KOMPUTER ( STUDI KASUS JAYA KOMPUTER )
Laporan Tugas Akhir Diajukan Untuk Melengkapi Salah Satu Syarat Memperoleh Gelar Sarjana Komputer
Oleh: Agung Setiawan 41813010023
PROGRAM STUDI SISTEM INFORMASI FAKULTAS ILMU KOMPUTER UNIVERSITAS MERCU BUANA JAKARTA 2017
http://digilib.mercubuana.ac.id/
i http://digilib.mercubuana.ac.id/
ii http://digilib.mercubuana.ac.id/
iii http://digilib.mercubuana.ac.id/
KATA PENGANTAR Puji dan syukur penulis panjatkan atas kehadirat Allah SWT yang telah memberikan karunia-Nya sehingga dengan rahmat dan karunia-Nya penulis dapat menyelesaikan tugas akhir dengan judul “Sistem Informasi Penjualan Dan Service Komputer ( Studi Kasus Jaya Komputer )” Penulis menyadari bahwa penulisan tugas akhir ini sulit untuk terwujud tanpa adanya bantuan dari berbagai pihak. Oleh karena itu dalam kesempatan ini penulis ingin mengucapkan banyak terima kasih kepada semua pihak yang memberikan kontribusinya baik material maupun spiritual khususnya kepada: 1. Bapak Ardiansyah, M.T.I selaku dosen pembimbing tugas akhir yang telah memberikan bimbingan dan masukan serta saran sehingga penulis dapat menyelesaikan skripsi ini. 2. Ibu Nur Ani, ST., MMSI selaku Kepala Program Studi (Ka. Prodi) Sistem Informasi. 3. Ibu Inge Handriani, M.Ak M.MSI selaku koordinator tugas akhir program studi sistem informasi. 4. Bapak Andi Nugroho, S.T., M.Kom selaku dosen pembimbing akademik pada program studi sistem informasi. 5. Orang tua serta keluarga tercinta yang tanpa henti mengalirkan doa untuk keselamatan dan keberhasilan penulis serta memberikan semangat baik spiritual, moril dan materil. 6. Seluruh teman-teman jurusan Sistem Informasi angkatan 2013 yang saling membantu, saling berbagi dan saling menolong satu sama lain demi keberhasilan bersama. 7. Semua pihak yang tidak bisa penulis sebutkan satu persatu yang telah mendukung baik secara langsung maupun tidak langsung dalam penulisan tugas akhir ini. Semoga Allah SWT memberikan dan melimpahkan rahmat dan karuniaNya atas segala bantuan yang telah diberikan kepada penulis.
iv http://digilib.mercubuana.ac.id/
Akhir kata penulis mohon maaf apabila dalam penyusunan tugas akhir ini terdapat kata-kata yang kurang berkenan. Semoga tugas akhir ini dapat memberikan manfaat bagi kita semua. aamiin Jakarta,
Juni 2017
Agung Setiawan
v http://digilib.mercubuana.ac.id/
Daftar Isi LEMBAR PERNYATAAN ................................................................................... i LEMBAR PERSETUJUAN SIDANG ................................................................ ii LEMBAR PENGESAHAN ................................................................................. iii KATA PENGANTAR .......................................................................................... iv ABSTRACT .......................................................................................................... vi ABSTRAK ........................................................................................................... vii DAFTAR GAMBAR ........................................................................................... xii DAFTAR TABEL .............................................................................................. xiv BAB I ...................................................................................................................... 1 PENDAHULUAN .................................................................................................. 1 1.1
Latar Belakang .................................................................................................. 1
1.2
Rumusan Masalah ............................................................................................ 1
1.3
Batasan Masalah ............................................................................................... 2
1.4
Tujuan dan Manfaat ......................................................................................... 2
1.5
Metode Penelitian.............................................................................................. 2
1.6
Metode Perncangan Sistem Informasi ............................................................ 2
MySQL ..................................................................................................... 19
2.7.4
Tipe Data MySQL ................................................................................... 20
2.7.5
Fungsi Php MySQL ................................................................................ 23
2.7.6
HTML (Hypertext Markup Language) ................................................ 24
2.7.7
Adobe Dreamweaver CC ........................................................................ 25
BAB III .................................................................................................................26 ANALISA DAN PERANCANGAN SISTEM....................................................26 Objek Penelitian .............................................................................................. 26
3.1
3.1.1
Sejarah Perusahaan ................................................................................ 26
3.1.2
Visi dan Misi ............................................................................................ 26
3.1.3
Struktur Organisasi ................................................................................ 27
3.2
Analisa Proses Bisnis Berjalan....................................................................... 28 Use Case Proses Bisnis ............................................................................ 29
Class Diagram .......................................................................................... 52
3.4.6
Rancangan Database ............................................................................... 52
3.5
Struktur Menu ................................................................................................ 53
3.6
Rancangan Antar Muka ................................................................................. 54
3.6.1
Rancangan Halaman Utama .................................................................. 54
3.6.3
Rancangan Halaman Login.................................................................... 57
3.6.4
Rancangan Halaman Home User .......................................................... 57
3.6.5
Rancangan Halaman Produk ................................................................. 59
ix http://digilib.mercubuana.ac.id/
3.6.6
Rancangan Halaman Konsultasi ........................................................... 60
3.6.7
Rancangan Halaman Lokasi .................................................................. 61
3.6.8
Rancangan Halaman Keranjang ........................................................... 62
3.6.9
Rancangan Halaman Profile .................................................................. 63
3.6.10
Rancangan Halaman Home Admin....................................................... 64
3.6.11
Rancangan Halaman Admin Data Master ........................................... 65
3.6.12
Rancangan Halaman Admin Data Asset............................................... 67
3.6.13
Rancangan Halaman Admin Data Operasional ................................... 67
BAB IV ................................................................................................................ 69 IMPLEMENTASI DAN PENGUJIAN ............................................................. 69 4.1
Daftar Pustaka .................................................................................................... 87 LAMPIRAN ......................................................................................................... 88
xi http://digilib.mercubuana.ac.id/
DAFTAR GAMBAR Gambar 2.1 Metode Waterfall (Pressman, 2010).......................................................... 12 Gambar 2.2 XAMPP ....................................................................................................... 19 Gambar 3.1 Struktur Organisasi Jaya Komputer ....................................................... 27 Gambar 3.2 Use Case Diagram proses bisnis yang sedang berjalan .......................... 29 Gambar 3.3 Use case Diagram Usulan Proses System Konsultasi ............................. 32 Gambar 3.4 Use Case Diagram Usulan Proses Pemesanan Barang ........................... 33 Gambar 3.5 Activity Diagram Login............................................................................. 38 Gambar 3.6 Activity Diagram Melakukan Konsultasi Kerusakan ............................ 39 Gambar 3.7 Activity Diagram Merespon Data Konsultasi ......................................... 40 Gambar 3.8 Activity Diagram Hasil Laporan .............................................................. 41 Gambar 3.9 Activity Diagram Menu Barang ............................................................... 42 Gambar 3.10 Activity Diagram Stock Barang ............................................................. 43 Gambar 3.11 Activity Diagram Pemesanan Barang.................................................... 44 Gambar 3.12 Sequence Diagram Daftar ....................................................................... 45 Gambar 3.13 Sequence Diagram User Login ............................................................... 46 Gambar 3.14 Sequence Diagram Menu Pemesanan .................................................... 47 Gambar 3.15 Sequence Diagram Menu Konsultasi ..................................................... 48 Gambar 3.16 Sequence Diagram Admin Login ........................................................... 49 Gambar 3.17 Sequence Diagram Admin Stock Barang .............................................. 50 Gambar 3.18 Sequence Diagram Admin Konsultasi ................................................... 51 Gambar 3.19 Class Diagram Website Jaya Komputer................................................ 52 Gambar 3.20 Struktur Menu ......................................................................................... 54 Gambar 3.21 Rancangan Halaman Index .................................................................... 54 Gambar 3.22 Rancangan Halaman Daftar ................................................................... 56 Gambar 3.23 Rancangan Halaman Login .................................................................... 57 Gambar 3.24 Rancangan Halaman Home User ........................................................... 58 Gambar 3.25 Rancangan Halaman Produk ................................................................. 59 Gambar 3.26 Rancangan Halaman Konsultasi ............................................................ 60 Gambar 3.27 Rancangan Halaman Lokasi................................................................... 62 Gambar 3.28 Rancangan Halaman Keranjang ............................................................ 63 Gambar 3. 29 Rancangan Halaman Profile.................................................................. 64 Gambar 3.30 Rancangan Halaman Home Admin ....................................................... 65 Gambar 3.31 Rancangan Halaman Admin Data Master ............................................ 66 Gambar 3.32 Rancangan Halaman Admin Data Asset ............................................... 67 Gambar 3.33 Rancangan Halaman Admin Data Operasional ................................... 68 Gambar 4.1 Tabel Struktur User .................................................................................. 70 Gambar 4.2 Tabel Struktur Barang.............................................................................. 70 Gambar 4.3 Tabel Struktur Konsultasi ........................................................................ 71 Gambar 4.4 Tabel Struktur Keranjang ........................................................................ 71 Gambar 4.5 Tabel Struktur Kategori ........................................................................... 71 Gambar 4.6 Tabel Struktur Kota .................................................................................. 72 Gambar 4.7 Tabel Struktur Pesan ................................................................................ 72 Gambar 4.8 Tabel Struktur Konfirmasi ....................................................................... 72 Gambar 4.9 Tabel Struktur Transaksi ......................................................................... 73 Gambar 4.10 Tabel Struktur Detail Transaksi ............................................................ 73
xii http://digilib.mercubuana.ac.id/
Gambar 4.11 Tabel Struktur Komentar Konsultasi.................................................... 73 Gambar 4.12 Tampilan Halaman Utama ..................................................................... 74 Gambar 4.13 Tampilan Halaman Utama ..................................................................... 74 Gambar 4.14 Tampilan Halaman Produk .................................................................... 75 Gambar 4.15 Tampilan Halaman Konsultasi............................................................... 75 Gambar 4.16 Tampilan Halaman Lokasi ..................................................................... 75 Gambar 4.17 Tampilan Halaman Login ....................................................................... 76 Gambar 4.18 Tampilan Halaman Daftar ..................................................................... 76 Gambar 4.19 Tampilan Halaman Daftar ..................................................................... 77 Gambar 4.20 Tampilan Halaman Admin Data Pesanan............................................. 77 Gambar 4.21 Tampilan Halaman Admin Data Pesanan............................................. 78 Gambar 4.22 Tampilan Halaman Admin Data Konfirmasi Pembayaran ................. 78 Gambar 4.23 Tampilan Halaman Admin Data User ................................................... 79 Gambar 4.24 Tampilan Halaman Admin Data Produk .............................................. 79 Gambar 4.25 Tampilan Halaman Admin Data Kategori ............................................ 80 Gambar 4.26 Tampilan Halaman Admin Data Kota .................................................. 80
xiii http://digilib.mercubuana.ac.id/
DAFTAR TABEL Tabel 2.1 Simbol Use Case Diagram ............................................................................. 13 Tabel 2.2 Simbol Activity Diagram ............................................................................... 14 Tabel 2.3 Simbol sequence diagram .............................................................................. 16 Tabel 2.4 Simbol sequence diagram .............................................................................. 20 Tabel 2.5 Tipe Data Date and Time............................................................................... 21 Tabel 2.6 Tipe Data Date and Time............................................................................... 21 Tabel 2.7 Atrribut Mysql connect ................................................................................. 22 Tabel 2.8 Atribut mysql_select_db ................................................................................ 23 Tabel 3.1 Use Case Menceritakan Permasalahan Komputer ..................................... 28 Tabel 3.2 Use Case Memeriksa Letak Kerusakan ....................................................... 28 Tabel 3.3 Use Case Memeriksa Stok Barang ................................................................ 29 Tabel 3.4 Use Case Memperbaiki Kerusakan .............................................................. 29 Tabel 3.5 Deskripsi Use Case Registrasi ....................................................................... 31 Tabel 3.6 Deskripsi Use Case Login .............................................................................. 31 Tabel 3.7 Deskripsi Use Case Melakukan Konsultasi Pemeriksaan .......................... 32 Tabel 3.8 Deskripsi Use Case Merespon Data Permasalahan..................................... 32 Tabel 3.9 Deskripsi Use Case Hasil Laporan Analisa .................................................. 32 Tabel 3.10 Deskripsi Use Case Memilih Barang .......................................................... 33 Tabel 3.11 Deskripsi Use Case Memeriksa Stok Barang............................................. 33 Tabel 3.12 Deskripsi Use Case Pesan Barang............................................................... 34 Tabel 3.13 Tabel User ..................................................................................................... 49 Tabel 3.14 Tabel Konsultasi ........................................................................................... 50 Tabel 3.15 Tabel Admin ................................................................................................. 50 Tabel 3.16 Tabel Pemesanan .......................................................................................... 50 Tabel 4.1 Skenario Pengujian User ............................................................................... 81 Tabel 4.2 Skenario Pengujian Bagian Admin .............................................................. 82 Tabel 4.3 Hasil Pengujian Bagian User ......................................................................... 82 Tabel 4.4 Skenario Pengujian Bagian Admin .............................................................. 84