STUDI DAN IMPLEMENTASI PEMBAYARAN PPOB (PAYMENT POINT ONLINE BANK) STUDI KASUS REKENING PDAM TIRTAWENING KOTA BANDUNG
TUGAS AKHIR
Disusun sebagai salah satu syarat untuk kelulusan Program Strata 1, di Program Studi Teknik Informatika, Universitas Pasundan Bandung
oleh : Arif Dwi Purwanto NRP : 14.304.0277
PROGRAM STUDI TEKNIK INFORMATIKA FAKULTAS TEKNIK UNIVERSITAS PASUNDAN BANDUNG JULI 2016
DAFTAR ISI ABSTRAK ..................................................................................................................................
i
ABSTRACT..................................................................................................................................
ii
KATA PENGANTAR ................................................................................................................
iii
DAFTAR ISI...............................................................................................................................
iv
DAFTAR TABEL.......................................................................................................................
vi
DAFTAR GAMBAR ..................................................................................................................
viii
DAFTAR LAMPIRAN ...............................................................................................................
x
BAB 1 PENDAHULUAN ..........................................................................................................
1-1
1.1 Latar Belakang ............................................................................................................
1-1
1.2 Identifikasi Masalah Tugas Akhir...............................................................................
1-3
1.3 Tujuan Tugas Akhir ....................................................................................................
1-3
1.4 Ruang Lingkup Tugas Akhir ......................................................................................
1-3
1.5 Metodologi Penelitian Tugas Akhir ............................................................................
1-4
1.6 Sistematika Penulisan .................................................................................................
1-6
BAB 2 TINJAUAN PUSTAKA .................................................................................................
2-1
2.1 Payment Point Online Bank (PPOB) ..........................................................................
2-1
2.1.1 Konseptual System Payment Point Online Bank (PPOB) .....................................
2-1
2.1.2 Ruang Lingkup PPOB (Payment Point Online Bank) ..........................................
2-3
2.1.3 Payment Gateway .................................................................................................
2-4
2.2 Rekonsiliasi.................................................................................................................
2-6
2.2.1 Prosedur Rekonsiliasi............................................................................................
2-7
2.3 Rekayasa Perangkat Lunak (RPL) ..............................................................................
2-7
2.3.1 Pengertian Rekayasa Perangkat Lunak .................................................................
2-8
2.3.2 Lapisan Dalam RPL ..............................................................................................
2-8
2.3.3 Analisis dan Perancangan Berorientasi Objek (Object-Oriented Analysis and Design/OOAD) ..................................................
2-9
2.3.4 Model Pembangunan Perangkat Lunak (Waterfall)..............................................
2-10
2.3.5 Basis Data (Database) ..........................................................................................
2-10
2.4 Teknologi Yang Digunakan ........................................................................................
2-10
2.4.1 Client-Server .........................................................................................................
2-10
2.4.2 Virtual Private Network (VPN) ............................................................................
2-12
2.4.3 Socket ....................................................................................................................
2-13
2.4.4 ISO (International Standart Organization)-8583 .................................................
2-16
2.5 Tools Pendukung ........................................................................................................
2-17
2.5.1 Database Managament System (DBMS) ..............................................................
2-17
2.5.2 VB.NET ................................................................................................................
2-18
2.5.3 Unified Modeling Language (UML) .....................................................................
2-19
2.6 Penelitian Terdahulu ...................................................................................................
2-20
BAB 3 ANALISIS DAN PERANCANGAN SISTEM ..............................................................
3-1
3.1 Kerangka Tugas Akhir ................................................................................................
3-1
3.2 Requirement Gathering...............................................................................................
3-3
3.2.1 Aspek PPOB (Payment Point Online Bank) .........................................................
3-3
3.2.2 Definisi Sistem ......................................................................................................
3-3
3.2.3 Analisis Proses Bisnis ...........................................................................................
3-4
3.2.4 Analisis Pengguna .................................................................................................
3-7
3.2.5 Diagram Bisnis Use Case .....................................................................................
3-8
3.2.6 Spesifikasi ISO-8583 ............................................................................................
3-8
3.2.7 Analisis Kebutuhan ...............................................................................................
3-14
3.2.8 Deskripsi Perangkat Lunak ..................................................................................
3-15
3.2.9 Deskripsi Data Rekonsiliasi ..................................................................................
3-15
3.3 Modeling .....................................................................................................................
3-16
3.3.1 Analisis Perangkat Lunak ....................................................................................
3-16
3.3.2 Desain Perangkat Lunak .....................................................................................
3-28
BAB 4 IMPLEMENTASI SISTEM ...........................................................................................
4-1
4.1 Construction .................................................................................................................
4-1
4.1.1 Kebutuhan Pembangunan Aplikasi .......................................................................
4-1
4.1.2 Fungsional Aplikasi ..............................................................................................
4-2
4.1.3 Struktur File Project Sistem PPOB (Payment Point Online Bank) ......................
4-2
4.1.4 Interface Aplikasi..................................................................................................
4-4
4.1.5 Database Aplikasi .................................................................................................
4-9
4.1.6 Testing ...................................................................................................................
4-13
4.1.7 Implementasi Aplikasi ..........................................................................................
4-19
BAB 5 KESIMPULAN DAN SARAN ......................................................................................
5-1
5.1 Kesimpulan ...................................................................................................................
5-1
5.2 Saran .............................................................................................................................
5-1
DAFTAR PUSTAKA LAMPIRAN
DAFTAR TABEL
Tabel 1.1 Data Pelanggan PDAM Tirtawening Kota Bandung ....................................................
1-1
Tabel 2.1 Perbandingan antara Socket dan Web Service ............................................................... 2-14 Tabel 2.2 Perbandingan Hasil Penelitian Terdahulu ..................................................................... 2-21 Tabel 3.1 Kerangka Tugas Akhir Tahap 1 dan 2 ..........................................................................
3-1
Tabel 3.2 Kerangka Tugas Akhir Tahap 3, 4, 5 dan 6 ..................................................................
3-2
Tabel 3.3 Tugas Yang Dimiliki Oleh Masing-Masing Pengguna .................................................
3-7
Tabel 3.4 Analisis Pengguna.........................................................................................................
3-7
Tabel 3.5 Use Case Bussines ........................................................................................................
3-8
Tabel 3.6 Message 0200 Inquiry/Payment ....................................................................................
3-9
Tabel 3.7 Message 0210 Inquiry/Payment ....................................................................................
3-9
Tabel 3.8 Penjelasan PAN (Primary Account Number)................................................................ 3-10 Tabel 3.9 Processing Code ........................................................................................................... 3-11 Tabel 3.10 Kode Merchant ........................................................................................................... 3-12 Tabel 3.11 Daftar Response Code ................................................................................................. 3-13 Tabel 3.12 Kebutuhan Fungsional ................................................................................................ 3-14 Tabel 3.13 Kebutuhan Non Fungsional......................................................................................... 3-15 Tabel 3-14 Data Rekonsiliasi Harian ............................................................................................ 3-16 Tabel 3-15 Data Rekonsiliasi Bulanan.......................................................................................... 3-16 Tabel 3-16 Definisi Aktor ............................................................................................................. 3-20 Tabel 3.17 Diagram Use Case Sistem PPOB (Payment Point Online Bank) PDAM Tirtawening Kota Bandung ............................................................................ 3-21 Tabel 3.18 Definisi Use Case ....................................................................................................... 3-21 Tabel 3.19 Skenario Transaksi Inquiry ......................................................................................... 3-22 Tabel 3.20 Skenario Transaksi Payment ....................................................................................... 3-23 Tabel 3.21 Skenario Cetak Resi .................................................................................................... 3-23 Tabel 3.22 Skenario Kelola Rekonsiliasi ...................................................................................... 3-23 Tabel 3.23 Skenario ISO-8583 ..................................................................................................... 3-24 Tabel 3.24 Daftar Menu Skenario ................................................................................................. 3-24 Tabel 3.25 Sequence Diagram Transaksi Inquiry ......................................................................... 3-25 Tabel 3.26 Sequence Diagram Transaksi Payment ....................................................................... 3-25 Tabel 3.27 Sequence Diagram Cetak Resi .................................................................................... 3-26 Tabel 3.28 Sequence Diagram Kelola Rekonsiliasi ...................................................................... 3-26 Tabel 3.29 Data Boundary Sequence Diagram ............................................................................. 3-27 Tabel 3.30 Data Control Sequence Diagram ................................................................................ 3-27 Tabel 3.31 Data Entity Sequence Diagram ................................................................................... 3-27
Tabel 3.32 Format Data Rekonsiliasi Harian ................................................................................ 3-27 Tabel 3.33 Format Data Rekonsiliasi Bulanan ............................................................................. 3-28 Tabel 3.34 View Class Diagram .................................................................................................... 3-30 Tabel 3.35 Controller Class Diagram ........................................................................................... 3-30 Tabel 3.36 Model Class Diagram ................................................................................................. 3-31 Tabel 3.37 Class Diagram Sistem PPOB (Payment Point Online Bank) PDAM Tirtawening Kota Bandung ............................................................................ 3-31 Tabel 3.38 Keterangan Class Diagram View ................................................................................ 3-32 Tabel 3.39 Keterangan Class Diagram Controller ....................................................................... 3-32 Tabel 3.40 Keterangan Class Diagram Model .............................................................................. 3-32 Tabel 3.41 Mapping Class Diagram Keseluruhan ........................................................................ 3-33 Tabel 3.42 Data Tabel Yang Digunakan ....................................................................................... 3-33 Tabel 3.43 Tabel Relasi Sistem PPOB (Payment Poin Online Bank) PDAM Tirtawening Kota Bandung ............................................................................ 3-34 Tabel 3.44 Keterangan Rancangan Tampilan Menu Loket .......................................................... 3-38 Tabel 3.45 Keterangan Rancangan Tampilan Menu Rekonsiliasi ................................................ 3-39 Tabel 3.46 Keterangan Rancangan Tampilan Menu Setting......................................................... 3-39 Tabel 3.47 Keterangan Rancangan Tampilan Laporan Rekonsiliasi Harian ................................ 3-40 Tabel 3.48 Keterangan Rancangan Tampilan Laporan Rekonsiliasi Bulanan .............................. 3-41 Tabel 3.49 Keterangan Rancangan Gateway PPOB ..................................................................... 3-41 Tabel 3.50 Matrik Keterunutan ..................................................................................................... 3-42 Tabel 4.1 Kebutuhan Perangkat Lunak .........................................................................................
4-1
Tabel 4.2 Kebutuhan Perangkat Keras ..........................................................................................
4-2
Tabel 4.3 Modul Fungsional Aplikasi...........................................................................................
4-2
Tabel 4.4 File Forms.....................................................................................................................
4-3
Tabel 4.5 File Modules ................................................................................................................
4-3
Tabel 4.6 Scenario Test Case........................................................................................................ 4-14 Tabel 4.7 Keterangan Kode .......................................................................................................... 4-18
DAFTAR GAMBAR
Gambar 1.1 Metodologi Tugas Akhir ........................................................................................... 1-5 Gambar 2.1 Alur Transaksi Keuangan Melalui PPOB (Payment Point Online Bank) ................. 2-2 Gambar 2.2 Alur Pengelolaan Rekening Dalam PPOB (Payment Point Online Bank) ................ 2-3 Gambar 2.3 Relasi Pada Internet Payment System ....................................................................... 2-4 Gambar 2.4 Relasi Pada Transaksi Online System ....................................................................... 2-6 Gambar 2.5 Lapisan Rekayasan Perangkat Lunak........................................................................ 2-8 Gambar 2.6 Client-Server ............................................................................................................. 2-11 Gambar 2.7 Komunikasi Client-Server ......................................................................................... 2-12 Gambar 2.8 Aplikasi Jaringan ....................................................................................................... 2-12 Gambar 2.9 Ilustrasi Interface Socket ........................................................................................... 2-16 Gambar 3.1 Gambaran Sistem PPOB (Payment Point Online Bank) PDAM Tirtawening Kota Bandung .......................................................................... 3-4 Gambar 3.2 Activity Diagram Kelola Transaksi Pembayaran ....................................................... 3-5 Gambar 3.3 Activity Diagram Pencatatan Laporan Keuangan ...................................................... 3-6 Gambar 3.4 Diagram Bisnis Use Case.......................................................................................... 3-8 Gambar 3.5 Activity Diagram Transaksi Inquiry .......................................................................... 3-17 Gambar 3.6 Activity Diagram Proses Transaksi Payment ............................................................. 3-18 Gambar 3.7 Activity Diagram Cetak Bukti Pembayaran ............................................................... 3-19 Gambar 3.8 Activity Diagram Kelola Rekonsiliasi ....................................................................... 3-20 Gambar 3.9 Diagram Use Case Sistem PPOB (Payment Point Online Bank) PDAM Tirtawening Kota Bandung .......................................................................... 3-21 Gambar 3.10 Sequence Diagram Transaksi Inquiry ..................................................................... 3-25 Gambar 3.11 Sequence Diagram Transaksi Payment ................................................................... 3-25 Gambar 3.12 Sequence Diagram Cetak Resi ................................................................................ 3-26 Gambar 3.13 Sequence Diagram Kelola Rekonsiliasi .................................................................. 3-26 Gambar 3.14 Arsitektur Infrastruktur Sistem Keseluruhan .......................................................... 3-29 Gambar 3.15 Arsitektur Infrastruktur Sistam Yang Dibangun ..................................................... 3-30 Gambar 3.16 Class Diagram Sistem PPOB (Payment Point Online Bank) PDAM Tirtawening Kota Bandung ........................................................................ 3-31 Gambar 3.17 Relasi Tabel Sistem PPOB (Payment Point Online Bank) PDAM Tirtawening Kota Bandung ........................................................................ 3-34 Gambar 3.18 Struktur Tabel Tbl_User ......................................................................................... 3-34 Gambar 3.19 Struktur Tabel Tbl_Route ....................................................................................... 3-35 Gambar 3.20 Struktur Tabel Tbl_RouteHost ................................................................................ 3-35 Gambar 3.21 Struktur Tabel Tbl_HakAkses ................................................................................. 3-35
Gambar 3.22 Struktur Tabel Tbl_Mess200................................................................................... 3-36 Gambar 3.23 Struktur Tabel Tbl_Mess210................................................................................... 3-37 Gambar 3.24 Rancangan Tampilan Menu Loket .......................................................................... 3-38 Gambar 3.25 Rancangan Tampilan Menu Rekonsiliasi ................................................................ 3-38 Gambar 3.26 Rancangan Tampilan Menu Setting ........................................................................ 3-39 Gambar 3.27 Rancangan Laporan Rekonsiliasi Harian ................................................................ 3-40 Gambar 3.28 Rancangan Laporan Rekonsiliasi Bulanan .............................................................. 3-40 Gambar 3.29 Rancangan Sistem Gateway PPOB ......................................................................... 3-41 Gambar 4.1 Struktur File Project Sistem Loket PPOB (Payment Point Online Bank) ................ 4-2 Gambar 4.2 Tampilan Login ......................................................................................................... 4-4 Gambar 4.3 Tampilan Loket ......................................................................................................... 4-5 Gambar 4.4 Tampilan Setting Parameter ..................................................................................... 4-5 Gambar 4.5 Tampilan Generate Data Rekonsiliasi ...................................................................... 4-6 Gambar 4.6 Tampilan Ganti Password ......................................................................................... 4-6 Gambar 4.7 Tampilan Form Help ................................................................................................. 4-7 Gambar 4.8 Tampilan Gateway .................................................................................................... 4-7 Gambar 4.9 Laporan Rekonsiliasi Harian ..................................................................................... 4-8 Gambar 4.10 Laporan Rekonsiliasi Bulanan ................................................................................ 4-9 Gambar 4.11 Design Tabel User................................................................................................... 4-9 Gambar 4.12 Tabel RouteTbl........................................................................................................ 4-10 Gambar 4.13 Tabel RouteHost...................................................................................................... 4-10 Gambar 4.14 Tabel HakAkses ...................................................................................................... 4-10 Gambar 4.15 Tabel Mess200 ........................................................................................................ 4-11 Gambar 4.16 Tabel Mess210 ........................................................................................................ 4-12 Gambar 4.17 Tahap 1 Proses Inquiry............................................................................................ 4-19 Gambar 4.18 Tahap 2 Proses Inquiry............................................................................................ 4-19 Gambar 4.19 Tahap 1 Proses Payment ......................................................................................... 4-20 Gambar 4.20 Tahap 2 Proses Payment ......................................................................................... 4-20 Gambar 4.21 Tahap 1 Proses Rekonsiliasi Harian ........................................................................ 4-21 Gambar 4.22 Hasil Rekonsiliasi Harian ........................................................................................ 4-21 Gambar 4.23 Tahap 1 Proses Rekonsiliasi Bulanan ..................................................................... 4-22 Gambar 4.24 Hasil Rekonsiliasi Bulanan ..................................................................................... 4-22
DAFTAR LAMPIRAN
Lampiran A-1
Tabel Daftar Bit Pada Data Element
Lampiran A-2
Tabel Penjelasan Representation Pada Data Element
Lampiran A-3
Tabel Penjelasan Format Pada Data Element
Lampiran A-4
Gambar Resi Pembayaran PDAM Tirtawening Kota
Bandung Lampiran A-5
Gambar Resi Pembayaran PPOB
