ABSTRAK “Aplikasi Desktop dan WAP Price Competitor Survey Pada Salah Satu Perusahaan Retail di Bandung” merupakan aplikasi yang dibangun untuk memberikan kemudahan kepada pihak perusahaan dalam melakukan proses survey harga barang terhadap kompetitor yang dimiliki. Pembuatan aplikasi ini memberikan adanya suatu proses survey harga barang kompetitor yang lebih efektif dan efisien. Pelaku survey dapat secara langsung melakukan survey terhadap setiap produk yang akan disurvey hanya dengan menggunakan perangkat wireless.
“Aplikasi Desktop dan WAP Price Competitor Survey Pada Salah Satu Perusahaan Retail di Bandung” is the application which build for giving an ease for the company when they need a survey process through they competitor. This Application will give an effectiveness and efficient process for the people who will notes every product price in the survey process only by using the wireless application.
iii
DAFTAR ISI PRAKATA .................................................................................................................. i PERNYATAAN ORISINALITAS LAPORAN PENELITIAN...................................... ii ABSTRAK ................................................................................................................ iii DAFTAR ISI............................................................................................................. iv DAFTAR GAMBAR ................................................................................................. vi DAFTAR TABEL....................................................................................................... x BAB I PENDAHULUAN ........................................................................................1 I.1 Latar Belakang ...........................................................................................1 I.2 Rumusan Masalah .....................................................................................2 I.3 Tujuan Pembahasan ..................................................................................2 I.4 Ruang Lingkup Kajian................................................................................3 I.5 Sistematika Penyajian................................................................................4 BAB II KAJIAN TEORI...........................................................................................5 II.1 Sistem Informasi ........................................................................................5 II.2 Wireless Application Protocol ....................................................................6 II.3 WAP Architecture.......................................................................................7 II.4 GPRS (General Packet Radio Services)...................................................8 II.5 Metode Pendekatan WEB Menggunakan PHP.........................................8 II.6 Definisi PHP ...............................................................................................9 II.6.1 Sejarah PHP ...............................................................................9 II.6.2 Variabel PHP.............................................................................10 II.7 SQL (Structured Query Language)..........................................................11 II.8 DFD (Data Flow Diagram) .......................................................................13 II.9 ERD (Entity Relational Diagram) .............................................................14 II.9.1 Entitas (Entity) dan Himpunan Entitas (Entity Set) ..................14 II.9.2 Atribut ........................................................................................14 II.9.3 Relasi (relationship) ..................................................................14 II.9.4 Kardinalitas ...............................................................................15 II.10 Fastwork ..............................................................................................17 II.11 WML (Wireless Markup Language) ....................................................18 II.12 Notepad ++..........................................................................................19 II.13 Flow Chart ...........................................................................................21 II.14 PSPEC ( Proses Specification )..........................................................21 BAB III ANALISIS DAN RANCANGAN SISTEM .................................................22 III.1 Proses Bisnis ...........................................................................................22 III.2 ERD (Entity Relational Diagram) .............................................................24 III.3 Transformasi Tabel ..................................................................................25 III.4 Kamus Data .............................................................................................31 III.5 DFD ..........................................................................................................35 III.6 PSPEC (Process Specification)...............................................................44 III.7 Desain Antar Muka ..................................................................................58 BAB IV HASIL PENELITIAN.................................................................................73 IV.1 Aplikasi Desktop.......................................................................................73 IV.1.1 Fasilitas Search.........................................................................73 IV.1.2 Fasilitas Paging.........................................................................73 IV.1.3 Halaman Login Admin...............................................................74
iv
IV.1.4 Halaman Home / Halaman Utama............................................74 IV.1.5 Halaman List User ....................................................................75 IV.1.6 Halaman Tambah User.............................................................75 IV.1.7 Halaman Edit User ....................................................................76 IV.1.8 Halaman List Role.....................................................................76 IV.1.9 Halaman Tambah Role .............................................................77 IV.1.10 Halaman Edit Role ...................................................................77 IV.1.11 Halaman List Wilayah ..............................................................78 IV.1.12 Halaman Tambah Wilayah .......................................................78 IV.1.13 Halaman Edit Wilayah ..............................................................79 IV.1.14 Halaman List Cabang ..............................................................79 IV.1.15 Halaman Tambah Cabang .......................................................80 IV.1.16 Halaman Edit Cabang ..............................................................80 IV.1.17 Halaman List Barang ...............................................................81 IV.1.18 Halaman Tambah Barang ........................................................81 IV.1.19 Halaman Edit Barang................................................................82 IV.1.20 Halaman List Kompetitor ..........................................................82 IV.1.21 Halaman Tambah Kompetitor ..................................................83 IV.1.22 Halaman Edit Kompetitor..........................................................83 IV.1.23 Halaman List Survey.................................................................84 IV.1.24 Halaman Survey .......................................................................84 IV.2 Aplikasi Mobile .........................................................................................88 IV.2.1 Halaman Login ..........................................................................88 IV.2.2 Halaman Home .........................................................................89 IV.2.3 Halaman Profile.........................................................................89 IV.2.4 Halaman Survey........................................................................90 IV.2.5 Halaman Insert Survey Barang ................................................91 BAB V PEMBAHASAN DAN UJI COBA HASIL PENELITIAN ...........................92 V.1 Error Handling ..........................................................................................92 V.1.1 Error Handling Pada Aplikasi Desktop .....................................92 V.1.2 Error Handling Pada Aplikasi Wireless....................................97 V.2 Test Case Aplikasi Desktop ...................................................................100 V.3 Test Case WAP:.....................................................................................112 BAB VI SIMPULAN DAN SARAN ......................................................................115 VI.1 Simpulan ................................................................................................115 VI.2 Saran ......................................................................................................116 DAFTAR PUSTAKA ............................................................................................... xii
v
DAFTAR GAMBAR Gambar II.1 Proses input data melalui Dokumen Dasar
6
Gambar II.2 WAP Architecture
7
Gambar II.3 Lambang Entitas
14
Gambar II.4 Lambang Atribut
14
Gambar II.5 Lambang Relasi
15
Gambar II.6 Relasi Satu ke Satu (One to One)
15
Gambar II.7 Relasi Satu ke Banyak (One to Many)
16
Gambar II.8 Relasi Banyak ke Satu (Many to One)
16
Gambar II.9 Relasi Banyak ke Banyak (Many to Many)
16
Gambar III.1 Flowchart Proses Bisnis
23
Gambar III.2 Entity Relationship Diagram (ERD)
24
Gambar III.3 Relasi Antar Tabel
31
Gambar III.4 DFD Level 0
36
Gambar III.5 DFD Level 1
37
Gambar III.6 DFD Level 2 Login
38
Gambar III.7 DFD Level 2 Proses Pengelolaan Data Role
39
Gambar III.8 DFD Level 2 Proses Pengelolaan Data User
40
Gambar III.9 DFD Level 2 Pengelolaan Data Barang
41
Gambar III.10 DFD Level 2 Pengelolaan Data Cabang
42
Gambar III.11 DFD Level 2 Pengelolaan Data Wilayah
43
Gambar III.12 DFD Level 2 Pengelolaan Data Competitor
44
Gambar III.13 Login
58
Gambar III.14 UID Searh Data Role
58
Gambar III.15 UID View Data Role
59
Gambar III.16 UID Insert Data Role
59
Gambar III.17 UID Edit Role
60
Gambar III.18 UID Searh Data User
60
Gambar III.19 UID View Data User
61
Gambar III.20 UID Insert Data User
61
vi
Gambar III.21 UID Edit Data User
62
Gambar III.22 UID Searh Data Barang
62
Gambar III.23 UID View Data Barang
63
Gambar III.24 UID Insert Data Barang
63
Gambar III.25 UID Edit Data Barang
64
Gambar III.26 UID Create Survey
64
Gambar III.27 UID Insert Data Survey
65
Gambar III.28 UID View Data Survey
65
Gambar III.29 UID Edit Data Survey
66
Gambar III.30 UID Search Data Cabang
66
Gambar III.31 UID View Data Cabang
67
Gambar III.32 UID Insert Data Cabang
67
Gambar III.33 UID Edit Data Cabang
68
Gambar III.34 UID Search Data Wilayah
68
Gambar III.35 UID View Data Wilayah
69
Gambar III.36 UID Insert Data Wilayah
69
Gambar III.37 UID Edit Data Wilayah
70
Gambar III.38 UID Search Data Competitor
70
Gambar III.39 UID View Data Competitor
71
Gambar III.40 UID Insert Data Competitor
71
Gambar III.41 UID Edit Data Competitor
72
Gambar IV.1 Halaman Login Admin
74
Gambar IV.2 Halaman Home
74
Gambar IV.3 Halaman List User
75
Gambar IV.4 Halaman Tambah User
75
Gambar IV.5 Halaman Edit User
76
Gambar IV.6 Halaman List Role
76
Gambar IV.7 Halaman Tambah Role
77
Gambar IV.8 Halaman Edit Role
77
Gambar IV.9 Halaman List Wilayah
78
Gambar IV.10 Halaman Tambah Wilayah
78
Gambar IV.11 Halaman Edit Wilayah
79
vii
Gambar IV.12 Halaman List Cabang
79
Gambar IV.13 Halaman Tambah Cabang
80
Gambar IV.14 Halaman Edit Cabang
80
Gambar IV.15 Halaman List Barang
81
Gambar IV.16 Halaman Tambah Barang
81
Gambar IV.17 Halaman Edit Barang
82
Gambar IV.18 Halaman List Kompetitor
82
Gambar IV.19 Halaman Tambah Kompetitor
83
Gambar IV.20 Halaman Edit Kompetitor
83
Gambar IV.21 Halaman List Survey
84
Gambar IV.22 Halaman Survey
84
Gambar IV.23 Halaman Pilih Barang Survey
85
Gambar IV.24 Halaman Lihat Data Barang Survey
85
Gambar IV.25 Halaman List Barang Cabang
86
Gambar IV.26 Halaman Tambah Barang Cabang
86
Gambar IV.27 Halaman Cabang Barang
87
Gambar IV.28 Halaman Tambah Cabang Kompetitor
87
Gambar IV.29 Halaman Login WAP
88
Gambar IV.30 Halaman Home WAP
89
Gambar IV.31 Halaman Profile WAP
89
Gambar IV.32 Halaman Survey WAP
90
Gambar IV.33 Halaman Insert Survey Barang
91
Gambar V.1 Error handling Kesalahan Login
92
Gambar V.2 Error handling Data Kosong
93
Gambar V.3 Error handling Data Berupa Angka
93
Gambar V.4 Error handling Data Sudah Tersedia
94
Gambar V.5 Error handling Minimal Karakter Kode Cabang
94
Gambar V.6 Error handling Penggunaan Spasi
95
Gambar V.7 Error handling Tidak Ada Perubahan Data
95
Gambar V.8 Informasi Berhasil Melakukan Perubahan Data
96
Gambar V.9 Informasi Berhasil Melakukan Penambahan Data
96
Gambar V.10 Error Handling Data Barang Cabang Sudah Tersedia
96
viii
Gambar V.11 Error Handling Data Cabang Kompetitor Sudah Tersedia 97 Gambar V.12 Error Handling WAP Kesalahan Login
97
Gambar V.13 Error handling WAP Data Kosong
98
Gambar V.14 Error handling WAP Penggunaan Spasi
98
Gambar V.15 Error handling WAP Data Berupa Angka
99
Gambar V.16 Error handling WAP Konfirmasi Password
99
Gambar V.17 Error handling WAP Survey Tidak Tersedia
ix
100
DAFTAR TABEL Tabel II.1 Tabel Tag PHP
11
Tabel II.2 Notasi Dasar DFD
13
Tabel II.3 Tabel Tag WML
18
Tabel III.1 Transposisi Tabel t_role
25
Tabel III.2 Transposisi Tabel t_user
25
Tabel III.3 Transposisi Tabel Melakukan_survey
26
Tabel III.4 Transposisi Tabel t_survey_hdr
26
Tabel III.5 Transposisi Tabel t_survey_det
27
Tabel III.6 Transposisi t_barang
27
Tabel III.7 Transposisi Tabel Memiliki_brg
28
Tabel III.8 Transposisi Tabel t_cabang
28
Tabel III.9 Transposisi Tabel mempunyai_cpt
29
Tabel III.10 Transposisi Tabel t_competitor
29
Tabel III.11 Transposisi Tabel temp_barang
29
Tabel III.12 Transposisi Tabel t_wilayah
30
Tabel III.13 Kamus Data t_role
31
Tabel III.14 Kamus t_user
31
Tabel III.15 Kamus Data Melakukan_survey
32
Tabel III.16 Kamus Data t_survey_hdr
32
Tabel III.17 Kamus Data t_survey_det
33
Tabel III.18 Kamus Data t_barang
33
Tabel III.19 Kamus Data memiliki_brg
34
Tabel III.20 Kamus Data t_cabang
34
Tabel III.21 Kamus Data mempunyai_cpt
34
Tabel III.22 Kamus Data t_competitor
34
Tabel III.23 Kamus Data t_wilayah
35
Tabel III.24 Kamus Data temp_barang
35
Tabel III.25 PSPEC Input Login
44
Tabel III.26 PSPEC Proses Validasi Login
45
x
Tabel III.27 PSPEC Proses Search Data Role
45
Tabel III.28 PSEPEC Proses View Data Role
45
Tabel III.29 PSEPEC Proses Insert Data Role
46
Tabel III.30 PSPEC Proses Edit Data Role
46
Tabel III.31 PSPEC Search Data User
46
Tabel III.32 PSPEC View Data User
47
Tabel III.33 PSPEC Insert Data User
47
Tabel III.34 PSPEC Edit Data User
48
Tabel III.35 PSPEC Search Data Barang
48
Tabel III.36 PSPEC View Data Barang
49
Tabel III.37 PSPEC Insert Data Barang
49
Tabel III.38 PSPEC Edit Data Barang
50
Tabel III.39 PSPEC Search Data Cabang
50
Tabel III.40 PSPEC View Data Cabang
51
Tabel III.41 PSPEC Insert Data Cabang
51
Tabel III.42 PSPEC Edit Data Cabang
51
Tabel III.43 PSPEC Search Data Wilayah
52
Tabel III.44 PSPEC View Data Wilayah
52
Tabel III.45 PSPEC Insert Data wilayah
52
Tabel III.46 PSPEC Edit Data Wilayah
53
Tabel III.47 PSPEC Search Data Competitor
53
Tabel III.48 PSPEC View Data Competitor
54
Tabel III.49 PSPEC Insert Data Competitor
54
Tabel III.50 PSPEC Edit Data Competitor
54
Tabel III.51 PSPEC Create Survey
55
Tabel III.52 PSPEC Insert Data Survey Barang
55
Tabel III.53 PSPEC View Data Survey
56
Tabel III.54 PSPEC Edit Data Survey
57
Tabel V.1 Test Case Login
100
Tabel V.2 Test Case Form Tambah User
101
Tabel V.3 Test Case Edit User
102
Tabel V.4 Test Case Form Tambah Role
103
xi
Tabel V.5 Test Case Form Edit Role
104
Tabel V.6 Test Case Form Tambah Wilayah
105
Tabel V.7 Test Case Form Edit Wilayah
105
Tabel V.8 Test Case Form Tambah Cabang
106
Tabel V.9 Test Case Form Edit Cabang
107
Tabel V.10 Test Case Form Tambah Barang
108
Tabel V.11 Test Case Form Edit Barang
109
Tabel V.12 Test Case Form Tambah Kompetitor
111
Tabel V.13 Test Case Form Edit Kompetitor
111
Tabel V.14 Test Case Form Login WAP
112
Tabel V.15 Test Case Form Ganti Profile
113
xii