ABSTRACT
Sekar Mawar is one of batik companies which is located in Bayat, Klaten. In this current age, internet has expanded rapidly so that there is no limitation on time and location. However, there was still a problem in Sekar Mawar batik company where the media of product marketing, time order and marketing range were still limited. According to that problem, e-Commerce application with CRM (Customer Relationship Management) basis is made in order to solve it. Customer Relationship Management is a marketing strategy that is supposed to build a good relationship with the customer and decrease some possibilities of customer movement into other products. Waterfall is a method that is used in operating system. On the other hand, the result of software arrangement is a data context diagram and flow diagram. Moreover, there is some facilities that are found in this application such as the information about the detail of the product, how to order the product and the management of data customer. E-Commerce application with CRM basis is built using PHP and MySQL mathematic language as the database. The result of this application is expected to keep a good relationship with the customer or to get new customer, and finally it brings many profits for Sekar Mawar batik company itself. Keywords : Application, E-Commerce, Customer Relationship Management
ix
ABSTRAK
Usaha batik Sekar Mawar merupakan salah satu usaha batik yang berada di wilayah Bayat, Klaten. Perkembangan teknologi internet yang telah berkembang dengan pesat sehinggga memungkinkan tidak adanya batasan waktu dan tempat. Permasalahan yang terdapat pada usaha batik Sekar Mawar adalah terbatasnya media pemasaran produkproduk, waktu pemesanan dan jangkauan pemasaran. Dengan adanya permasalahan ini maka akan dibuat aplikasi e-Commerce berbasis CRM(Customer Relationship Management). Customer Relationship Management merupakan strategi pemasaran untuk menciptakan dan mempertahankan suatu hubungan yang baik dengan pelanggan dan mengurangi kemungkinan pelanggan berpindah ke produk pesaing. Metode yang digunakan dalam pengembangan sistem adalah metode waterfall. Hasil dari perancangan perangkat lunak yaitu diagram konteks dan diagram alir data dari seluruh proses yang terjadi. Fasilitas dari aplikasi ini meliputi informasi detail produk, pemesanan produk dan pengelolaan data pelanggan. Aplikasi e-Commerce berbasis CRM ini dibangun menggunakan bahasa pemrograman PHP dan MySQL sebagai databasenya. Hasil dari aplikasi yang dibuat ini diharapkan dapat menjaga hubungan baik dengan pelanggan maupun mendapatkan pelanggan baru, yang akhirnya membawa keuntungan bagi usaha batik Sekar Mawar. Kata kunci : Aplikasi, E-commerce, Customer Relationship Management
x
DAFTAR ISI
HALAMAN JUDUL ................................................................................................ HALAMAN PENGESAHAN PEMBIMBING ........................................................ HALAMAN PENGESAHAN PENGUJI ................................................................. SURAT PERNYATAAN KARYA ASLI TUGAS AKHIR ..................................... HALAMAN PERSEMBAHAN ................................................................................ HALAMAN MOTTO................................................................................................ KATA PENGANTAR .............................................................................................. ABSTRACT .............................................................................................................. ABSTRAK ................................................................................................................ DAFTAR ISI ............................................................................................................ DAFTAR GAMBAR ................................................................................................ DAFTAR TABEL .................................................................................................... DAFTAR MODUL PROGRAM ..............................................................................
i ii iii iv v vi vii ix x xi xiv xvi xvii
BAB I PENDAHULUAN ....................................................................................... 1.1 Latar Belakang Masalah ............................................................................. 1.2 Perumusan Masalah .................................................................................... 1.3 Batasan Masalah ......................................................................................... 1.4 Tujuan Penelitian......................................................................................... 1.5 Manfaat Penelitian ...................................................................................... 1.6 Metodologi Penelitian ................................................................................ 1.7 Sistematika Penulisan .................................................................................
1 1 2 2 2 3 3 4
BAB II LANDASAN TEORI ................................................................................. 2.1 Konsep Dasar Sistem................................................................................... 2.2 Konsep Dasar Informasi ............................................................................. 2.3 Konsep Dasar Sistem Informasi ................................................................. 2.3.1 Jenis-Jenis Sistem Informasi ...................................................................... 2.3.2 Komponen Sistem Informasi ...................................................................... 2.4 Diagram Alir Data (DAD) / Data Flow Diagram (DFD) .......................... 2.5 Metode Waterfall ........................................................................................ 2.6 Aplikasi ...................................................................................................... 2.7 e-Commerce (Electronic Commerce) ......................................................... 2.8 Konsep Customer Relationship Management (CRM) ................................ 2.8.1 Pengertian Customer Relationship Management (CRM) ........................... 2.8.2 Komponen Customer Relationship Management (CRM) .......................... 2.8.3 Tujuan Customer Relationship Management (CRM) ................................ 2.8.4 Manfaat Customer Relationship Management (CRM) .............................. 2.9 Perancangan Basis Data ............................................................................. 2.9.1 Konsep Dasar Entity Relationship Diagram (ERD) ................................... 2.9.2 Komponen Entity Relationship Diagram (ERD) ....................................... 2.9.3 Kardinalitas Dalam Relationship ................................................................ 2.9.4 Derajat (Tingkat) Relationship ................................................................... 2.10 MySQL ....................................................................................................... 2.11 Internet dan World Wide Web .................................................................... 2.11.1 Internet ........................................................................................................
6 6 7 7 8 8 10 12 14 14 15 15 15 17 18 19 20 20 21 22 23 23 24
xi
2.11.2 2.11.3 2.11.4 2.12 2.13 2.14 2.15 2.16 2.17 2.18
World Wide Web ......................................................................................... Web ............................................................................................................. Web Server ................................................................................................. Hypertext Preprocessor (PHP) ................................................................... Hyper Text Markup Language (HTML) ..................................................... JQuery ........................................................................................................ Ajax ............................................................................................................ Adobe Dreamweaver .................................................................................. Adobe Photoshop ....................................................................................... Studi Pustaka ..............................................................................................
24 25 25 25 26 27 27 28 28 29
BAB III GAMBARAN UMUM ............................................................................. 3.1 Sejarah Perushaan ....................................................................................... 3.2 Visi Perusahaan .......................................................................................... 3.3 Misi Perusahaan ......................................................................................... 3.4 Sistem Pengelolaan dan Bentuk Perusahaan .............................................. 3.5 Batik ........................................................................................................... 3.6 Struktur Organisasi .....................................................................................
30 30 30 30 31 31 32
BAB IV ANALISIS DAN PERANCANGAN ....................................................... 4.1 Analisis Sistem ............................................................................................. 4.2 Analisis Kebutuhan Sistem ......................................................................... 4.3 Perancangan Sistem .................................................................................... 4.3.1 Perancangan Proses ..................................................................................... 4.3.1.1 Diagram Konteks atau DFD Level 0 ............................................................ 4.3.1.2 DFD Level 1 ................................................................................................. 4.3.1.3 DFD Level 2 Proses Layanan Admin ........................................................... 4.3.1.4 DFD Level 2 Proses Layanan Member......................................................... 4.3.1.5 DFD Level 2 Proses Layanan Visitor .......................................................... 4.3.2 Perancangan Basis Data .............................................................................. 4.3.2.1 Entity Relationship Diagram (ERD) ........................................................... 4.3.2.2 Rancangan Tabel ......................................................................................... 4.3.2.3 Relasi Antar Tabel (RAT) ........................................................................... 4.3.3 Perancangan Struktur Menu ........................................................................ 4.3.4 Perancangan Antar Muka ............................................................................ 4.3.4.1 Rancangan Halaman Utama Aplikasi (Visitor) ........................................... 4.3.4.2 Rancang Halaman Member ......................................................................... 4.3.4.3 Rancang Halaman Admin ............................................................................
33 33 33 34 35 35 36 41 43 45 47 48 50 56 56 58 58 67 74
BAB V IMPLEMENTASI ..................................................................................... 5.1 Implementasi Sistem .................................................................................... 5.2 Kebutuhan Perangkat Keras (Hardware) .................................................... 5.3 Kebutuhan Perangkat Lunak (Software) ...................................................... 5.4 Koneksi Database ........................................................................................ 5.5 Pembahasan Sistem ..................................................................................... 5.5.1 Halaman Utama Aplikasi (Visitor) .............................................................. 5.5.1.1 Halaman Home Visitor ................................................................................ 5.5.1.2 Halaman Semua Produk................................................................................ 5.5.1.3 Halaman Berita ............................................................................................
90 90 90 90 91 91 91 91 93 94
xii
5.5.1.4 5.5.1.5 5.5.1.6 5.5.1.7 5.5.2 5.5.2.1 5.5.2.2 5.5.2.3 5.5.2.4 5.5.2.5 5.5.2.6 5.5.2.7 5.5.3 5.5.3.1 5.5.3.2 5.5.3.3 5.5.3.4 5.5.3.5 5.5.3.6 5.5.3.7 5.5.3.8 5.5.3.9
Halaman Kontak .......................................................................................... Halaman Keranjang Belanja ........................................................................ Halaman Daftar Member .............................................................................. Halaman Login Member .............................................................................. Halaman Member ......................................................................................... Halaman Home Member .............................................................................. Halaman Ubah Password ............................................................................. Halaman Biodata .......................................................................................... Halaman Pesanan Lama ............................................................................... Halaman Konfirmasi Pembayaran ............................................................... Halaman Testimoni ....................................................................................... Halaman Kritik Saran ................................................................................... Halaman Admin ........................................................................................... Halaman Login Admin ................................................................................. Halaman Home Admin ................................................................................ Halaman Edit Profil ..................................................................................... Halaman Kategori Produk ........................................................................... Halaman Produk .......................................................................................... Halaman Pesanan ......................................................................................... Halaman Konfirmasi .................................................................................... Halaman Laporan ......................................................................................... Halaman Email Member ..............................................................................
95 97 98 100 102 102 103 106 108 109 111 113 115 115 116 116 118 120 122 124 126 128
BAB VI PENUTUP .................................................................................................. 6.1 Kesimpulan ................................................................................................ 6.2 Saran ............................................................................................................
129 129 129
DAFTAR PUSTAKA ..............................................................................................
130
xiii
DAFTAR GAMBAR
Gambar 2.1 Gambar 2.2 Gambar 2.3 Gambar 2.4 Gambar 2.5 Gambar 4.1 Gambar 4.2 Gambar 4.3 Gambar 4.4 Gambar 4.5 Gambar 4.6 Gambar 4.7 Gambar 4.8 Gambar 4.9 Gambar 4.10 Gambar 4.11 Gambar 4.12 Gambar 4.13 Gambar 4.14 Gambar 4.15 Gambar 4.16 Gambar 4.17 Gambar 4.18 Gambar 4.19 Gambar 4.20 Gambar 4.21 Gambar 4.22 Gambar 4.23 Gambar 4.24 Gambar 4.25 Gambar 4.26 Gambar 4.27 Gambar 4.28 Gambar 4.29 Gambar 4.30 Gambar 4.31 Gambar 4.32 Gambar 4.33 Gambar 4.34 Gambar 4.35 Gambar 4.36 Gambar 4.37 Gambar 4.38 Gambar 4.39 Gambar 4.40 Gambar 4.41
Komponen Sistem Informasi ............................................................... Diagram Waterfall ............................................................................... Relasi One to One (1:1) ....................................................................... Relasi One to Many (1:M) ................................................................... Relasi Many to Many (M:N) ................................................................ Diagram Konteks atau DFD Level 0 .................................................... DFD Level 1 ........................................................................................ DFD Level 2 Proses Layanan Admin .................................................. DFD Level 2 Proses Layanan Member ................................................ DFD Level 2 Proses Layanan Visitor .................................................. ERD (Entity Relationship Diagram) .................................................... Relasi Antar Tabel (RAT) .................................................................... Struktur Menu Utama .......................................................................... Struktur Menu Admin .......................................................................... Struktur Menu Member ........................................................................ Rancangan Halaman Home Visitor ...................................................... Rancangan Halaman Semua Produk .................................................... Rancangan Halaman Cara Pembelian .................................................. Rancangan Halaman Berita .................................................................. Rancangan Halaman Kontak ................................................................ Rancangan Halaman Tentang Kami .................................................... Rancangan Halaman Daftar Member ................................................... Rancangan Halaman Login Member .................................................... Rancangan Halaman Home Member ................................................... Rancangan Halaman Ubah Password .................................................. Rancangan Halaman Biodata ............................................................... Rancangan Halaman Pesanan Lama .................................................... Rancangan Halaman Konfirmasi Pembayaran .................................... Rancangan Halaman Testimoni ........................................................... Rancangan Halaman Kritik Saran ......................................................... Rancangan Halaman Login Admin ...................................................... Rancangan Halaman Home Admin ...................................................... Rancangan Halaman Edit Profil ........................................................... Rancangan Halaman Kategori Produk ................................................. Rancangan Halaman Produk ................................................................ Rancangan Halaman Member .............................................................. Rancangan Halaman Berita .................................................................. Rancangan Halaman Halaman ............................................................. Rancangan Halaman Pesanan .............................................................. Rancangan Halaman Konfirmasi ......................................................... Rancangan Halaman Laporan .............................................................. Rancangan Halaman Testimoni ........................................................... Rancangan Halaman Kritik Saran ........................................................ Rancangan Halaman Poling ................................................................. Rancangan Halaman FAQ .................................................................... Rancangan Halaman Email Promosi .................................................... xiv
10 13 21 22 22 36 40 44 46 47 49 57 57 58 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89
Gambar 5.1 Gambar 5.2 Gambar 5.3 Gambar 5.4 Gambar 5.5 Gambar 5.6 Gambar 5.7 Gambar 5.8 Gambar 5.9 Gambar 5.10 Gambar 5.11 Gambar 5.12 Gambar 5.13 Gambar 5.14 Gambar 5.15 Gambar 5.16 Gambar 5.17 Gambar 5.18 Gambar 5.19 Gambar 5.20 Gambar 5.21 Gambar 5.22 Gambar 5.23
Tampilan Halaman Home Visitor ........................................................ Tampilan Halaman Semua Produk ...................................................... Tampilan Halaman Berita .................................................................... Tampilan Halaman Kontak .................................................................. Tampilan Halaman Keranjang Belanja ................................................ Tampilan Halaman Daftar Member .................................................... Tampilan Halaman Login Member ...................................................... Tampilan Halaman Home Member ....................................................... Tampilan Halaman Ubah Password ..................................................... Tampilan Halaman Biodata ................................................................. Tampilan Halaman Pesanan Lama ....................................................... Tampilan Halaman Konfirmasi Pembayaran ....................................... Tampilan Halaman Testimoni .............................................................. Tampilan Halaman Kritik Saran ........................................................... Tampilan Halaman Login Admin ......................................................... Tampilan Halaman Home Admin ........................................................ Tampilan Halaman Edit Profil ............................................................. Tampilan Halaman Kategori Produk ................................................... Tampilan Halaman Produk ................................................................... Tampilan Halaman Pesanan .................................................................. Tampilan Halaman Konfirmasi ............................................................ Tampilan Halaman Laporan ................................................................. Tampilan Halaman Email Promosi .......................................................
xv
92 93 94 95 97 99 101 102 104 106 108 109 112 113 115 116 117 118 120 122 124 126 128
DAFTAR TABEL
Tabel 2.1 Tabel 2.2 Tabel 4.1 Tabel 4.2 Tabel 4.3 Tabel 4.4 Tabel 4.5 Tabel 4.6 Tabel 4.7 Tabel 4.8 Tabel 4.9 Tabel 4.10 Tabel 4.11 Tabel 4.12 Tabel 4.13 Tabel 4.14 Tabel 4.15 Tabel 4.16
Notasi Dasar DFD (Data Flow Diagram) ............................................ Simbol-Simbol ERD (Entity Relationship Diagram) ........................... Struktur Tabel Admin .......................................................................... Struktur Tabel Kategori ....................................................................... Struktur Tabel Produk .......................................................................... Struktur Tabel Member ........................................................................ Struktur Tabel Produk Atribut ............................................................. Struktur Tabel Produk Diskon ............................................................. Struktur Tabel Pesanan ........................................................................ Struktur Tabel Pesanan Detail .............................................................. Struktur Tabel Konfirmasi ................................................................... Struktur Tabel Poling ........................................................................... Struktur Tabel Pilihan Poling ............................................................... Struktur Tabel Halaman ....................................................................... Struktur Tabel Faq ............................................................................... Struktur Tabel Kritik ............................................................................. Struktur Tabel Testimoni ...................................................................... Struktur Tabel Berita ............................................................................
xvi
12 21 50 50 51 51 52 52 53 53 54 53 54 54 55 55 56 56
DAFTAR MODUL PROGRAM
Modul Program 5.1 Modul Program 5.2 Modul Program 5.3 Modul Program 5.4 Modul Program 5.5 Modul Program 5.6 Modul Program 5.7 Modul Program 5.8 Modul Program 5.9 Modul Program 5.10 Modul Program 5.11 Modul Program 5.12 Modul Program 5.13 Modul Program 5.14 Modul Program 5.15 Modul Program 5.16 Modul Program 5.17 Modul Program 5.18 Modul Program 5.19 Modul Program 5.20 Modul Program 5.21 Modul Program 5.22 Modul Program 5.23 Modul Program 5.24 Modul Program 5.25 Modul Program 5.26 Modul Program 5.27 Modul Program 5.28 Modul Program 5.29 Modul Program 5.30 Modul Program 5.31 Modul Program 5.32 Modul Program 5.33 Modul Program 5.34 Modul Program 5.35 Modul Program 5.36 Modul Program 5.37
Koneksi Database ..................................................................... Source Code Halaman Home Visitor ....................................... Source Code Halaman Semua Produk ..................................... Source Code Halaman Berita ................................................... Source Code Halaman Kontak ................................................. Lanjutan Source Code Halaman Kontak .................................. Source Code Halaman Keranjang Belanja ............................... Lanjutan Source Code Halaman Keranjang Belanja ................ Source Code Halaman Daftar Member .................................... Lanjutan Source Code Halaman Daftar Member ..................... Source Code Halaman Login Member ..................................... Source Code Halaman Home Member...................................... Source Code Halaman Ubah Password ..................................... Lanjutan Source Code Halaman Ubah password ...................... Source Code Halaman Biodata ................................................. Lanjutan Source Code Halaman Biodata .................................. Source Code Halaman Pesanan Lama....................................... Lanjutan Source Code Halaman Pesanan Lama ....................... Source Code Halaman Konfirmasi Pembayaran ...................... Lanjutan Source Code Halaman Konfirmasi Pembayaran ....... Source Code Halaman Testimoni ............................................. Source Code Halaman Kritik Saran .......................................... Lanjutan Source Code Halaman Kritik Saran ........................... Source Code Halaman Login Admin ........................................ Source Code Halaman Home Admin ........................................ Source Code Halaman Edit Profil ............................................. Source Code Halaman Kategori Produk .................................. Lanjutan Source Code Halaman Kategori Produk .................... Source Code Halaman Produk .................................................. Lanjutan Source Code Halaman Produk ................................... Source Code Halaman Pesanan ................................................ Lanjutan Source Code Halaman Pesanan ................................ Source Code Halaman Konfirmasi............................................ Lanjutan Source Code Halaman Konfirmasi ............................ Source Code Halaman Laporan ................................................ Lanjutan Source Code Halaman Laporan ................................. Source Code Halaman Email Promosi ......................................
xvii
91 92 93 94 95 96 97 98 99 100 101 102 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128
