SKRIPSI SISTEM INFORMASI PENJUALAN ALAT MUSIK BERBASIS WEB DENGAN DUKUNGAN SMS GATEWAY (Studi Kasus: Toko Zakkzakk Yogyakarta)
Diajukan Sebagai Syarat Untuk Menyelesaikan Pendidikan Program Strata-1 Pada Program Studi Sistem Informasi
Oleh :
AGUSTINUS TAMO AMA NIM : 08230031
PROGRAM STUDI SISTEM INFORMASI FAKULTAS SAINS DAN TEKNOLOGI UNIVERSITAS RESPATI YOGYAKARTA 2014
i
UNIVERSITAS RESPATI YOGYAKARTA Fakultas Sains dan Teknologi Program Studi Sistem Informasi Skripsi Sarjana Komputer Semester XII 2013/2014 Sistem Informasi Penjualan Alat Musik Berbasis Web Dengan Dukungan SMS Gateway 1 Oleh : Agustinus Tamo Ama , Herison Surbakti, S.Kom., MM., MT 2 , Ir. Ajie Wibowo Soejono3 xvii+102/ 12 Tabel/ 52 Gambar/ 5 Lampiran/ 9 Pustaka ABSTRAKSI Penjualan online atau e-commerce merupakan mekanisme bisnis tersendiri yang usianya masih seumur jagung. namun disinilah sisi keistimewaanya. untuk pertama kalinya seluru manusia dimuka bumi memiliki kesempatan yang sama agar dapat berhasil dalam dunia bisnis di dalam dunia maya Tujuan penelitian ini adalah membuat aplikasi penjualan alat musik yang terhubung lansung ke website secara lengkap dengan informasi toko alat musik beserta harga dan cara pembeliannya sehingga dapat mempermudah user mencari alat musik tertentu. Metode penelitian yang digunakan dalam perancangan dan pembuatan aplikasi ini adalah metode Waterfall, bahasa pemrograman yang digunakan sebagai server-side scripting adalah PHP, HTML, Gammu dan Macromedia Dreamweaver 8 sebagai desain web, MySQL sebagai penyimpanan database. Hasil dari penelitian ini adalah sebuah aplikasi penjualan berbasis web dengan dukungan SMS gateway yang bisa digunakan untuk berbelanja alat musik lebih mudah karena menampilkan gambar, harga dan tata cara pembelian. Kata Kunci : Web, Alat Musik, Gammu dan SMS Gateway 1
Mahasiswa Universitas Respati Yogyakarta Pembimbing I 3 Pembimbing II 2
vii
UNIVERSITAS RESPATI YOGYAKARTA Faculty of Science and Technology Information System Study Program Bachelor of Computer Undergraduate Thesis Semester XII 2013/2014 Web-based Musical Instruments Sales Information using SMS Gateway Support By : Agustinus Tamo Ama1 , Herison Surbakti, S.Kom., MM., MT 2 , Ir. Ajie Wibowo Soejono3 xvii+102/ 12 Tables/ 52 Figures/ 5 Appendices/ 9 Bibliography ABSTRACT Onlien sales or e-commerce is a relatively new distinct business mechanism. However, this makes it special because for the first time everyone on earth has the same chance to success in the business world in the virtual world. The purpose of this study is to make a musical instruments sales application connected directly to a website, complete with information of music stores, prices and purchasing method to help users find certain musical instruments. The research method used in designing and making this application method was Waterfall method, programming languages used as server-side scripting were PHP, HTML, Gammu and Macromedia Dreamweaver 8 as web design, MySQL as database storage. The result of this study was a web-based sales application using SMS gateway support which could be used to shop musical instruments easily because it displayed images, prices, and purchasing methods. Keywords : Web, Musical Instrument, Gammu and SMS Gateway 1
Student of Universitas Respati Yogyakarta Supervisor I 3 Supervisor II 2
viii
Motto : Kegagalan bukan berarti kita tidak mampu yang penting kita telah berbuat untuk mencoba. kegagalan bukan berarti kita telah kehilangan segalanya mungkin belum saatnya kita mendapatkan apa yang kita cari. Tapi kegagalan hanyalah kesuksesan yang tertunda. Kegagalan bukan berarti Tuhan mengabaikan kita melainkan Tuhan punya rencana lain yang lebih indah untuk kita.Karena hidup adalah perjuangan. Maka setiap perjuangan membutuhkan
pengorbanan
dan
akhir
dari
pengorbanan
adalah
kebahagiaanYang akan kita gapai.
Kupersembahkan karya tulis ini kepada :
Ayah dan Ibu Tercinta yang tak pernah
lelah
memberikan saran, dukungan, materi dan doa kepada saya.
Nenek, Kakak, Adik dan Keluarga besarku yang selalu memberi dukungan dan motivasi.
Teman-Teman Prodi Sistem Informasi yang selalu memberikan dukungannya.
Kekasihku tercinta yang selalu setia menemaniku dalam suka dan duka .
ix
KATA PENGANTAR
Puji syukur kehadirat Tuhan Yang Maha Esa yang telah melimpahkan kasih dan karunia-Nya, sehingga penulis dapat menyelesaikan laporan Skripsi ini dengan judul “SISTEM INFORMASI PENJUALAN ALAT MUSIK BERBASIS WEB DENGAN DUKUNGAN SMS GATEWAY”. Untuk selanjutnya penyusun mengucapkan banyak terima kasih kepada pihakpihak yang telah membantu dalam penyelesaian Skripsi ini, yaitu : 1. Ibu Sri Hasta Mulyani, S.Kom., M.Kom. selaku Dekan Fakultas Sains dan Teknologi Universitas Respati Yogyakarta. 2. Bapak Ir. Ajie Wibowo Soejono, selaku Ketua Program Studi Sistem Informasi Universitas Respati Yogyakarta, sekaligus sebagai pembimbing II. 3. Bapak Herison Surbakti, S.Kom., MM., MT, selaku Pembimbing I yang telah dengan sabar membimbing penulis. 4. Pengelola Toko Zakkzakk Yogyakarta yang telah memberikan saya kesempatan untuk melakukan penelitian. 5. Seluruh Staf dan Karyawan Fakultas Sains dan Teknologi Universitas Respati Yogyakarta. 6. Kedua Orang tuaku, Nenekku, Kakaku, adik-adikku dan keluarga besarku di sumba serta sahabat-sahabatku yang selalu memberi bimbingan, motivasi dan doa. 7. Buat kekasihku tersayang Yani Seran terima kasih atas doanya dan selalu menemaniku dalam suka dan duka.
x
8. Teman-teman Prodi Sistem Informasi angkatan 2008, ada Melky, Ridwan, Monik, Jiron Ariel, Riki, Sitha, Arief, zulkifli, dan teman-teman kos A25 Kledokan yang tidak bisa saya sebutkan satu per satu, Terima Kasih atas bantuannya, candaan dan semangatnya. 9. Dan semua teman – teman yang namanya tidak bisa saya sebutkan satu persatu, terima kasih atas bantuan dan doa kalian.
Yogyakarta, 18 Februari 2014
Agustinus Tamo ama
xi
DAFTAR ISI
Halaman HALAMAN JUDUL ............................................................................................... i HALAMAN PERNYATAAN KESIAPAN UJIAN PENDADARAN ................... ii HALAMAN PENGESAHAN ................................................................................. iii HALAMAN SURAT PERNYATAAN KEASLIAN SKRIPSI .............................. iv HALAMAN PERSETUJUAN DEMO PROGRAM ............................................... v HALAMAN TANDA LULUS UJIAN PENDADARAN SKRIPSI .............. ........ vi ABSTRAKSI .......................................................................................................... vii ABSTRACT ............................................................................................................ viii HALAMAN MOTTO DAN PERSEMBAHAN ...................................................... ix KATA PENGANTAR ..............................................................................................x DAFTAR ISI .......................................................................................................... xii DAFTAR TABEL ................................................................................................... xiv DAFTAR GAMBAR ...............................................................................................xv DAFTAR LAMPIRAN .......................................................................................... xvii BAB I PENDAHULUAN 1.1 Latar Belakang Masalah ......................................................................1 1.2 Rumusan Masalah ................................................................................3 1.3 Batasan Masalah ..................................................................................3 1.4 Tujuan Penelitian dan Manfaat Penelitian ...........................................4 1.4.1 Tujuan Penelitian……………………………………………….4 1.4.2 Manfaat Penelitian ......................................................................5 1.5 Metode Penelitian ................................................................................5 1.6 Sistematika Penulisan ..........................................................................6 BAB II LANDASAN TEORI 2.1 Alat Musik............................................................................................8 2.1.1 Pengertian Alat ............................................................................8 2.1.2 Pengertian Musik ........................................................................8 2.1.3 Pengertian Alat Musik ................................................................9 2.1.4 Koleksi Alat Musik .....................................................................9 2.2 Pengertian e-Commerce ......................................................................10 2.2.1 Jenis e-Commerce ......................................................................10 2.2.2 Keuntungan e-Commerce...........................................................13 2.2.3 Kerugian e-Commerce ...............................................................13 2.2.4 Sistem Pembayaran ....................................................................14 2.3 Pengertian Sistem Informasi ...............................................................17 xii
2.4
2.5
2.6 2.7 2.8
2.9
2.10 2.11
2.12
2.12
2.3.1 Data ............................................................................................17 2.3.2 Informasi ....................................................................................17 2.3.3 Sistem Informasi ........................................................................18 Pengenalan SMS Gateway ..................................................................18 2.4.1 Pengertian SMS Gateway ..........................................................18 2.4.2 Topologi SMS Gateway.............................................................19 Pengenalan SMS .................................................................................20 2.5.1 Pengertian SMS .........................................................................20 2.5.2 Keunggulan SMS .......................................................................20 2.5.3 Cara Kerja SMS .........................................................................21 2.5.4 Jenis- jenis Aplikasi SMS ..........................................................21 Konsep Basis Data ..............................................................................22 Pengertia Basis Data ...........................................................................23 Flowchart ............................................................................................24 2.8.1 Pengertian Flowchart .................................................................24 2.8.2 Jenis-Jenis Flowchart .................................................................24 Defenisi DAD......................................................................................27 2.9.1 Fungsi DAD ...............................................................................27 2.9.2 Komponen-Komponen DAD .....................................................28 Entity Relationship Diagram(ER_D) ..................................................30 PHP………………………………………………………………….34 2.11.1 Defenisi PHP............................................................................34 2.11.2 Kelebihan dan kelemahan PHP................................................35 2.11.3 Peran PHP Dalam Sistem ........................................................37 Gammu................................................................................................37 2.12.1 Kelebihan Gammu ...................................................................37 2.12.2 Peran Gammu dalam sistem ....................................................38 MySQL ...............................................................................................38
BAB III ANALISA DAN PERANCANGAN 3.1 Obyek Penelitian .................................................................................44 3.1.1 Sekilas Tentang Toko Zakkzakk .............................................44 3.1.2 Denah Lokasi Toko Zakkzakk ................................................45 3.1.3 Struktur Organisasi Toko Zakkzakk .......................................46 3.1.4 Visi dan Misi ...........................................................................47 3.2 Analisa Perangkat Lunak ....................................................................48 3.2.1 Analisis Sistem ..........................................................................48 3.3 Perancangan Perangkat Lunak ............................................................48 3.3.1 Diagram Alir Data(DAD) .......................................................48 3.3.1.1 Diagram Konteks ........................................................48 3.3.1.2 Diagram Berjenjang ....................................................51 3.3.1.3 Diagram Overview (Level 0) ......................................52 3.3.1.4 Diagram Level 1 Proses 1 Pendataan ..........................54 xiii
3.4
3.3.1.5 Diagram Level 1 Proses 2 Transaksi...........................55 3.3.1.6 Diagram Level 1 Proses 3 Laporan .............................56 3.3.2 Entity Relationship Diagram (ERD) .......................................57 3.3.3 Entity Relationship Tabel (ER Tabel) .....................................58 3.3.4 Flowchart Program ..................................................................59 3.3.5 Struktur Tabel .........................................................................60 Desain Input, Proses dan Output.........................................................66 3.4.1 Desain Halaman Utama Web ...................................................66 3.4.2 Desain Halaman Data Pribadi Pelanggan ................................67 3.4.3 Desain Form Login Petugas .....................................................68 3.4.4 Desain Halaman Utama Petugas ..............................................68 3.4.5 Desain Tampilan Koleksi Alat Musik .....................................69 3.4.6 Desain Tampilan Daftar Pelanggan .........................................70 3.4.7 Desain Form Data Pemesanan Barang.....................................71 3.4.8 Desain Form Data SMS ...........................................................72 3.4.9 Desain Form Petugas ...............................................................73 3.4.10 Desain Form Laporan Stok Barang .........................................74 3.4.11 Desain Laporan Penjualan .......................................................75 3.4.12 Desain Laporan Pelanggan ......................................................76 3.4.13 Desain Laporan Pesanan ..........................................................77 3.4.14 Desain Laporan Data Pembayaran ...........................................78
BAB IV IMPLEMENTASI DAN PENGUJIAN 4.1 Spesifikasi Perangkat Keras (Hardware) ...........................................79 4.2 Spesifikasi Perangkat Lunak (Software) .............................................80 4.3 Implementasi Antar muka ...................................................................80 4.3.1 Antar Muka Petugas..................................................................80 4.3.1.1 Halaman Login Petugas ................................................80 4.3.1.2 Halaman Utama Petugas ...............................................82 4.3.1.3 Halaman Input Data Alat Musik ...................................83 4.3.1.4 Halaman Input Data Petugas.........................................86 4.3.1.5 Halaman Daftar Pelanggan ...........................................88 4.3.1.6 Halaman Daftar Pemesan..............................................90 4.3.1.7 Halaman Input Data SMS .............................................92 4.3.1.8 Laporan Daftar Koleksi Barang ....................................93 4.3.1.9 Laporan Daftar Barang Terjual .....................................95 4.3.1.10 Laporan Data Pembayaran ............................................97 4.3.1.11 Laporan Data Pelanggan ...............................................99 4.3.2 Antar Muka Halaman Utama Web ...........................................100 4.3.2.1 Halaman Utama Web ...................................................100 4.3.2.2 Halaman Pelanggan .....................................................102 4.3.2.3 Halaman Tata Cara Pembelian ....................................104 4.3.2.4 Halaman Profil .............................................................106 xiv
4.4 4.5
4.3.2.5 Halaman Kontak Kami ................................................107 4.3.2.6 Halaman Buku Tamu ...................................................108 Pembahasan Hasil Pengujian Sistem .................................................110 Kelebihan dan Kelemahan Sistem .....................................................112 4.5.1 Kelebihan Sistem…. ...........................................................112 4.5.2 Kekurangan Sistem…. ....................................................... .113
BAB V PENUTUP 5.1 Kesimpulan ........................................................................................114 5.2 Saran ..................................................................................................115 DAFTAR PUSTAKA LAMPIRAN
xv
DAFTAR TABEL Halaman 2.1. Tabel Simbol-simbol Flowchart Program ........................................................26 2.2. Tabel Simbol-Simbol ER_D .............................................................................31 2.3. Tabel Perintah-Perintah Dasar MySQL ............................................................42 3.1. Tabel Petugas ....................................................................................................60 3.2. Tabel Pelanggan ................................................................................................61 3.3. Tabel Koleksi Alat Musik .................................................................................62 3.4. Tabel Keranjang Belanja ...................................................................................62 3.5. Tabel Pemesanan ...............................................................................................63 3.6. Tabel Pemesanan Detail ....................................................................................64 3.7. Tabel Buku Tamu ..............................................................................................64 3.8. Tabel Pembayaran .............................................................................................65 4.1. Tabel Perhitungan Hasil Kuisioner ..................................................................111
xvi
DAFTAR GAMBAR Halaman 2.1. Gambar Ilustrasi Topologi Sistem ....................................................................19 2.2. Gambar Skema cara kerja SMS ........................................................................21 2.3. Gambar Simbol Entity ......................................................................................28 2.4. Gambar Simbol Proses ......................................................................................28 2.5. Gambar Simbol data Store ................................................................................29 2.6. Gambar Simbol Data Flow................................................................................29 2.7. Gambar Contoh Diagram Konteks ....................................................................29 2.8. Gambar One To One Relationship ....................................................................32 2.9. Gambar One To Many Relationship..................................................................32 2.10. Gambar Many To Many Relationship .............................................................33 3.1. Gambar Denah Lokasi Toko Zakkzakk ............................................................45 3.2. Gambar Struktur Organisasi ..............................................................................46 3.3. Gambar Diagram Konteks.................................................................................49 3.4. Gambar Diagram Berjenjang ............................................................................51 3.5. Gambar DAD Overview ....................................................................................53 3.6. Gambar DAD Level 1 Proses 1 Pendataaan .....................................................54 3.7. Gambar DAD Level 1 Proses 2 Transaksi ........................................................55 3.8. Gambar DAD Level 1 Proses 3 Laporan ..........................................................56 3.9. Gambar Entity Relationship Diagram ...............................................................57 3.10. Gambar Entity Relationship Tabel ..................................................................58 3.11. Gambar Flowchart Program ...........................................................................59 3.12. Gambar Halaman Utama Web ........................................................................66 3.13. Gambar Halaman Data Pribadi Pelanggan ......................................................67 3.14. Gambar Desain Form Login Petugas ..............................................................68 3.15. Gambar Desain Halaman Utama Petugas .......................................................68 3.16. Gambar Desain Halaman Koleksi Alat Musik ................................................69 3.17. Gambar Desain Halaman Utama Pelanggan ...................................................70 3.18. Gambar Desain Halaman Pemesanan .............................................................71 3.19. Gambar Desain Halaman Data Sms ................................................................72 3.20. Gambar Desain Halaman Input Data Petugas .................................................73 3.21. Gambar Desain Halaman Laporan stok barang ..............................................74 3.22. Gambar Desain Halaman Daftar Barang Terjual ............................................75 3.23. Gambar Desain Halaman Laporan Pelanggan ................................................76 3.24. Gambar Desain Halaman Laporan Pesanan ....................................................77 3.25. Gambar Desain Halaman Laporan Data Pembayaran .....................................78 4.1. Gambar Halaman Login Petugas .......................................................................80 4.2. Gambar Halaman Utama petugas......................................................................82 4.3. Gambar Halaman Input Data Alat Musik .........................................................84 4.4. Gambar Halaman Input Data Petugas ...............................................................86 xvii
4.5. Gambar Daftar Pelanggan .................................................................................88 4.6. Gambar Halaman Daftar Pemesanan ................................................................90 4.7. Gambar Input data SMS Baru ...........................................................................92 4.8. Gambar Laporan Daftar Koleksi Barang ..........................................................94 4.9. Gambar Halaman Laporan Daftar Barang Terjual ............................................95 4.10. Gambar Laporan Data Pembayaran ................................................................97 4.11. Gambar Laporan Data Pelanggan ...................................................................99 4.12. Gambar Halaman Utama Web .......................................................................101 4.13. Gambar Halaman Data Pelanggan .................................................................103 4.14. Gambar Halaman Tata Cara Pembelian .........................................................105 4.15. Gambar Halaman Profil .................................................................................106 4.16. Gambar Halaman Kontak Toko Zakkzakk ....................................................108 4.17. Gambar Halaman Buku Tamu .......................................................................109
xviii
DAFTAR LAMPIRAN
1. Biodata penulis 2. Surat persetujuan revisi seminar Skripsi 3. Kartu Bimbingan Skripsi 4. Kuesioner 5. Source Kode Program
xix
