Aplikasi Yahoo Messenger, Aplikasi Multi Level Marketing, MySQL

ABSTRAK
Aplikasi Voucher Book Report Portable adalah sebuah perangkat lunak yang
mengintegrasikan Yahoo Messenger dengan aplikasi penjualan voucher game, bahasa
pemograman yang digunakan adalah java menggunakan platform netbeans. Barang yang
diterima admin dari pembelian voucher adalah file excell.xls. File tersebut dapat dikonversi
langsung kedalam database mySQL, sehingga memudahkan staff/admin mempersiapkan kode
yang akan dijual. Para member dapat melakukan pembelian melalui messenger yahoo, baik
melalui gadget / yahoo messenger desktop /browser. Terdapat enkripsi kode voucher di dalam
database, dengan tujuan menjaga keamanan data. Terdapat juga fitur Multi Level Marketing
yang membedakan bonus saldo para member dari levelnya.
Kata kunci: Aplikasi Yahoo Messenger, Aplikasi Multi Level Marketing, MySQL, Java,
Netbeans
iv
ABSTRACT
Voucher Book Report Portable is a software that integrates with Yahoo Messenger for
gaming voucher sales, programming language used is java using netbeans platform. Goods
received by the admin of purchase vouchers are excell.xls file. These files can be converted
directly into mySQL database, making it easier for staff / admin preparing the code that will be
sold. The members can make purchases through yahoo messenger, both through the gadget /
yahoo messenger desktop / browser. There is a voucher code encryption in the database, in
order to maintain data security. There are also features of the Multi Level Marketing which
distinguishes the members of bonus balance level.
Keywords: Yahoo Messenger Application, Applications Multi Level Marketing, MySQL, Java,
Netbeans
v
Daftar Isi
SURAT PERNYATAAN ORISINALITAS KARYA ............................................................................i
PERSETUJUAN PUBLIKASI KARYA ILMIAH ................................................................................ ii
KATA PENGANTAR ....................................................................................................................... iii
ABSTRAK ....................................................................................................................................... iv
ABSTRACT ......................................................................................................................................v
Daftar Isi .......................................................................................................................................... vi
Daftar Gambar ................................................................................................................................ xi
Daftar Tabel .................................................................................................................................. xiv
BAB I ............................................................................................................................................... 1
1.1 Latar Belakang ...................................................................................................................... 1
1.2 Rumusan masalah ................................................................................................................ 2
1.3 Tujuan Pembahasan ............................................................................................................. 2
1.4 Batasan Masalah .................................................................................................................. 2
1.5 Sistematika Penyajian ........................................................................................................... 2
BAB II .............................................................................................................................................. 4
2.1 Unified Modelling Language (UML) ...................................................................................... 4
2.1.2 Konsep Dasar UML ........................................................................................................ 4
2.1.3 Use Case ........................................................................................................................ 5
2.1.4 Activity Diagram.............................................................................................................. 6
2.1.5 Class Diagram ................................................................................................................ 7
2.2 Entity Relationship Diagram (ERD) ...................................................................................... 9
2.2.1 Komponen ERD............................................................................................................. 9
2.3 Netbeans ............................................................................................................................ 12
2.3.1 Bahasa Pemrograman Java......................................................................................... 13
vi
2.3.1.1 Macam-macam Java 2 Software Developer Kit (J2SDK) antara lain : .................... 14
2.3.1.2 Java juga mempunyai platform yaitu : ...................................................................... 15
2.3.1.3 Struktur program java yaitu : ..................................................................................... 15
2.3.1.4 Contoh Program 1 (HelloWorld.java) yaitu : ............................................................. 15
2.3.1.5 Tipe data .................................................................................................................... 16
2.3.1.6 Logika ........................................................................................................................ 18
2.3.1.7 Tabel true & false adalah sebagai berikut : .............................................................. 18
3.2.3 Regular Expression (Regex) ............................................................................................ 18
2.4 MYSQL ................................................................................................................................ 19
2.4.1 Query MYSQL .............................................................................................................. 19
2.5 Java excel API .................................................................................................................... 20
2.5.1 Fitur java excel API adalah : ........................................................................................ 20
2.6 Java JYMsg ......................................................................................................................... 21
2.6.1 Fitur yang dimiliki java JYMSG adalah : ...................................................................... 21
2.7 Multi Level Marketing .......................................................................................................... 22
2.7.1 Perhitungan Bonus........................................................................................................... 23
2.8 Enkripsi ................................................................................................................................ 23
2.9 Reporting With JasperReport And iReport (Java) .............................................................. 23
2.9.1 Penjelasan mengenai fungsi-fungsi tiap library yang digunakan: ............................... 24
BAB III ........................................................................................................................................... 25
3.1 Deskripsi umum Sistem Voucher Book Report Portable ................................................... 25
3.1.1 Command/perintah yang dimengerti oleh sistem, diantaranya : ................................. 25
3.2 Proses Bisnis....................................................................................................................... 26
3.3 Arsitektur Sistem Voucher Book Report Portable .............................................................. 27
3.3.1 Entity Relationship Diagram (ERD).............................................................................. 28
3.3.2 Use Case Diagram ....................................................................................................... 28
3.3.2.1 Use Case Diagram Admin......................................................................................... 29
vii
3.3.2.2 Use Case Diagram Staff ........................................................................................... 30
3.3.3 Activity Diagram............................................................................................................ 30
3.3.3.1 Activity Login ............................................................................................................. 31
3.3.3.2 Activity Tambah Member .......................................................................................... 31
3.3.3.3 Activity Ubah Member ............................................................................................... 32
3.3.3.4 Activity Tambah Agen ............................................................................................... 33
3.3.3.5 Activity Ubah Agen .................................................................................................... 34
3.3.3.6 Activity Tambah Kategori Voucher............................................................................ 35
3.3.3.7 Activity Ubah Kategori Voucher ................................................................................ 36
3.3.3.8 Activity Data Bonus ................................................................................................... 37
3.3.3.9 Activity Ubah Data Bonus ......................................................................................... 38
3.3.3.10 Activity Lihat Pesan ................................................................................................. 39
3.3.3.11 Activity set harga jual .............................................................................................. 40
3.3.3.12 Activity Bonus Member ........................................................................................... 41
3.3.3.13 Activity Lihat Data Komplain ................................................................................... 42
3.3.3.14 Activity Pengisian Saldo .......................................................................................... 43
3.3.4 Class Diagram .............................................................................................................. 44
3.3.4.1 Class Diagram Admin................................................................................................ 44
3.3.4.2 Class Diagram Staff .................................................................................................. 45
3.3.5 Mockup ......................................................................................................................... 46
3.3.5.1 Mockup Member........................................................................................................ 46
3.3.5.2 Mockup Agen............................................................................................................. 47
3.3.5.3 Mockup Kategori Voucher ......................................................................................... 49
3.3.5.4 Mockup Voucher ....................................................................................................... 51
3.3.5.5 Mockup Penjualan ..................................................................................................... 52
3.3.5.6 Mockup Data Bonus .................................................................................................. 53
3.3.5.7 Mockup Data Bonus Member ................................................................................... 55
viii
3.3.5.8 Mockup Katalog ......................................................................................................... 56
3.3.5.9 Mockup Katalog Pembelian ...................................................................................... 58
3.3.5.10 Mockup Pesan ......................................................................................................... 59
3.3.5.11 Mockup Set Harga jual ............................................................................................ 60
3.3.5.12 Mockup Lihat Data Komplain .................................................................................. 61
3.3.5.13 Mockup Lihat Laba Rugi ......................................................................................... 62
3.3.5.14 Mockup Pengisian saldo ......................................................................................... 63
3.3.5.15 Mockup Login Sistem .............................................................................................. 64
3.3.5.16 Mockup YM engine.................................................................................................. 64
BAB IV ........................................................................................................................................... 66
4.1 Kumpulan ScreenShot ........................................................................................................ 66
4.1.1 Screenshot Login YM engine ....................................................................................... 66
4.1.2 Screenshot Login YM engine ....................................................................................... 66
4.1.3 Screenshot Loading Login ........................................................................................... 67
4.1.4 Screenshot Sukses Login YM Staff ............................................................................. 67
4.1.5 Screenshot Sukses Login ............................................................................................ 68
4.1.6 Screenshot Login System ............................................................................................ 69
4.1.7 Screenshot Menu Admin .............................................................................................. 70
4.1.8 Screenshot Menu Admin .............................................................................................. 71
4.1.9 Screenshot Ubah Member ........................................................................................... 71
4.1.10 Screenshot Tambah Agen ......................................................................................... 72
4.1.11 Screenshot Ubah Agen .............................................................................................. 73
4.1.12 Screenshot Tambah Kategori Voucher...................................................................... 74
4.1.13 Screenshot Ubah Kategori Voucher .......................................................................... 75
4.1.14 Screenshot Set Voucher ............................................................................................ 76
4.1.15 Screenshot Lihat Penjualan ....................................................................................... 77
4.1.16 Screenshot Lihat Pembelian ...................................................................................... 78
ix
4.1.17 Screenshot Lihat Pesan ............................................................................................. 79
4.1.18 Screenshot Tambah Bonus........................................................................................ 80
4.1.19 Screenshot Ubah Bonus ............................................................................................ 81
4.1.20 Screenshot Lihat Pesan Komplain ............................................................................. 82
4.1.21 Screenshot Profit Loss ............................................................................................... 83
4.1.22 Screenshot Report ..................................................................................................... 84
4.1.23 Screenshot Add Purchase ......................................................................................... 85
4.1.24 Screenshot Confirm Deposit Member ........................................................................ 86
4.2 Pseudocode ........................................................................................................................ 87
4.2.1 Multi Level Marketing ................................................................................................... 87
4.2.2 Fungsi Cek Pesan Member.......................................................................................... 88
4.2.3 Enkripsi ......................................................................................................................... 89
BAB V ............................................................................................................................................ 90
V.1 Evaluasi Form Login ........................................................................................................... 90
V.2 Evaluasi Form Ubah Member............................................................................................ 90
V.3 Evaluasi Form Tambah Agen ............................................................................................. 90
V.4 Evaluasi Form Ubah Agen.................................................................................................. 91
V.5 Evaluasi Form Tambah Kategori Voucher ......................................................................... 91
V.6 Evaluasi Form Ubah Kategori Voucher .............................................................................. 91
V.7 Evaluasi Form Set Voucher ................................................................................................ 91
V.8 Evaluasi Form Tambah Bonus ........................................................................................... 92
V.9 Evaluasi Form Ubah Bonus ................................................................................................ 92
V.10 Evaluasi Form YM-Engine ................................................................................................ 92
BAB VI ........................................................................................................................................... 95
VI.1 Kesimpulan ........................................................................................................................ 95
VI.2 Saran.................................................................................................................................. 95
Daftar Pustaka .............................................................................................................................. 96
x
Daftar Gambar
Gambar 2. 1 Actors ......................................................................................................................... 5
Gambar 2. 2 Use Cases ................................................................................................................. 5
Gambar 2. 3 Relationship ............................................................................................................... 6
Gambar 2. 4 Activities ..................................................................................................................... 6
Gambar 2. 5 States ......................................................................................................................... 6
Gambar 2. 6 Transitions ................................................................................................................. 6
Gambar 2. 7 Swimming Lines ........................................................................................................ 7
Gambar 2. 8 Area Pokok Class ...................................................................................................... 8
Gambar 2. 9 Contoh Class Diagram .............................................................................................. 8
Gambar 2. 10 Komponen ERD....................................................................................................... 9
Gambar 2. 11 Contoh ERD satu ke satu ...................................................................................... 10
Gambar 2. 12 Contoh ERD satu ke banyak ................................................................................. 11
Gambar 2. 13 Contoh ERD banyak ke satu ................................................................................. 11
Gambar 2. 14 Contoh ERD banyak ke banyak ............................................................................ 11
Gambar 2. 15 Contoh ERD entitas lemah .................................................................................... 12
Gambar 2. 16 Hasil output Cth.Program 1 (HelloWorld.java) ...................................................... 16
Gambar 3. 1 Flowchart Voucher Book Report Portable .............................................................. 27
Gambar 3. 2 Entity Relationship Diagram .................................................................................... 28
Gambar 3. 3 Use Case Diagram Admin ....................................................................................... 29
Gambar 3. 4 Use Case Diagram Staff.......................................................................................... 30
Gambar 3. 5 Activity Login............................................................................................................ 31
Gambar 3. 6 Activity Tambah Member......................................................................................... 32
Gambar 3. 7 Activity Ubah Member ............................................................................................. 33
Gambar 3. 8 Activity Tambah Agen ............................................................................................. 34
Gambar 3. 9 Activity Ubah Agen .................................................................................................. 35
Gambar 3. 10 Activity Tambah Kategori Voucher ........................................................................ 36
Gambar 3. 11 Activity Ubah Kategori Voucher ........................................................................... 37
Gambar 3. 12 Activity Data Bonus .............................................................................................. 38
Gambar 3. 13 Activity Ubah Data Bonus...................................................................................... 39
Gambar 3. 14 Activity Lihat Pesan ............................................................................................... 40
xi
Gambar 3. 15 Activity Set Harga Jual .......................................................................................... 41
Gambar 3. 16 Activity Bonus Member.......................................................................................... 42
Gambar 3. 17 Activity Lihat Data Komplain ................................................................................. 43
Gambar 3. 18 Activity Pengisian Saldo ........................................................................................ 44
Gambar 3. 19 Class Diagram Admin ............................................................................................ 45
Gambar 3. 20 Class Diagram Staff .............................................................................................. 45
Gambar 3. 21 Mockup Ubah Member .......................................................................................... 46
Gambar 3. 22 Mockup Tambah Agen .......................................................................................... 47
Gambar 3. 23 Mockup Ubah Agen ............................................................................................... 48
Gambar 3. 24 Mockup Tambah Voucher ..................................................................................... 49
Gambar 3. 25 Mockup Ubah Kategori Voucher ........................................................................... 50
Gambar 3. 26 Mockup Lihat Voucher........................................................................................... 51
Gambar 3. 27 Mockup Penjualan ................................................................................................. 52
Gambar 3. 28 Mockup Tambah Data Bonus................................................................................ 53
Gambar 3. 29 Mockup Ubah Data Bonus .................................................................................... 54
Gambar 3. 30 Mockup Bonus Member ........................................................................................ 55
Gambar 3. 31 Mockup Tambah Katalog ...................................................................................... 56
Gambar 3. 32 Mockup Ubah Katalog ........................................................................................... 57
Gambar 3. 33 Mockup Katalog Pembelian .................................................................................. 58
Gambar 3. 34 Mockup Pesan ....................................................................................................... 59
Gambar 3. 35 Mockup Pilih File & set Harga Jual ....................................................................... 60
Gambar 3. 36 Mockup Lihat Data Komplain ................................................................................ 61
Gambar 3. 37 Mockup Lihat Laba Rugi........................................................................................ 62
Gambar 3. 38 Mockup Pengisian Saldo ....................................................................................... 63
Gambar 3. 39 Mockup Login Sistem ............................................................................................ 64
Gambar 3. 40 Mockup Login YM engine ...................................................................................... 64
Gambar 3. 41 Mockup Proses Login YM engine ......................................................................... 65
Gambar 3. 42 Mockup Sukses Login YM engine ......................................................................... 65
Gambar 4. 1 Login YM Staff ......................................................................................................... 66
Gambar 4. 2 Tampilan Awal Login YM-Engine ............................................................................ 66
Gambar 4. 3 Tampilan Loading YM-Engine ................................................................................. 67
Gambar 4. 4 Tampilan Sukses Login YM staff............................................................................. 68
Gambar 4. 5 Tampilan YM-Engine Sukses Login ........................................................................ 69
Gambar 4. 6 Tampilan Login System Vocershop ........................................................................ 70
xii
Gambar 4. 7 Tampilan Menu Admin ............................................................................................ 70
Gambar 4. 8 Tampilan Menu Staff ............................................................................................... 71
Gambar 4. 9 Tampuilan Ubah Member ........................................................................................ 72
Gambar 4. 10 Tampilan Tambah Agen ........................................................................................ 73
Gambar 4. 11 Tampilan Ubah Agen ............................................................................................. 74
Gambar 4. 12 Tampilan Tambah Kategori Voucher .................................................................... 75
Gambar 4. 13 Tampilan Ubah Kategori Voucher ......................................................................... 76
Gambar 4. 14 Tampilan Set Kode Voucher (set Voucher) .......................................................... 77
Gambar 4. 15 Tampilan Lihat Data Penjualan ............................................................................. 78
Gambar 4. 16 Tampilan Lihat Data Pembelian ............................................................................ 79
Gambar 4. 17 Tampilan Lihat Pesan (inbox/outbox) ................................................................... 80
Gambar 4. 18 Tampilan Tambah Bonus ...................................................................................... 81
Gambar 4. 19 Tampilan Ubah Bonus ........................................................................................... 82
Gambar 4. 20 Tampilan Lihat Pesan Komplain ........................................................................... 83
Gambar 4. 21 Tampilan Lihat Profit Loss ..................................................................................... 84
Gambar 4. 22 Tampilan Contoh Report (Message Report) ......................................................... 85
Gambar 4. 23 Tampilan Add Purchase ........................................................................................ 85
Gambar 4. 24 Tampilan Konfirmasi Deposit Member .................................................................. 86
xiii
Daftar Tabel
Tabel 2. 1 Tabel Integer................................................................................................................ 16
Tabel 2. 2 Tabel Floating point ..................................................................................................... 16
Tabel 2. 3 Tabel Char ................................................................................................................... 17
Tabel 2. 4 Tabel Boolean.............................................................................................................. 17
Tabel 2. 5 Tabel Logika ................................................................................................................ 18
Tabel 2. 6 Tabel Kebenaran ......................................................................................................... 18
Tabel 2. 7 Tabel Jasper Library (Java)......................................................................................... 24
Tabel 5. 1 Login ............................................................................................................................ 90
Tabel 5. 2 Member ........................................................................................................................ 90
Tabel 5. 3 Tambah Agen .............................................................................................................. 90
Tabel 5. 4 Ubah Agen ................................................................................................................... 91
Tabel 5. 5 Tambah Kategori Voucher .......................................................................................... 91
Tabel 5. 6 Ubah Kategori Voucher ............................................................................................... 91
Tabel 5. 7 Set Voucher ................................................................................................................. 91
Tabel 5. 8 Tambah Bonus ............................................................................................................ 92
Tabel 5. 9 Ubah Bonus ................................................................................................................. 92
Tabel 5. 10 Yahoo Engine ............................................................................................................ 92
xiv