BUILDING APPLICATION SYSTEM CAR RENTAL RESERVATION AND PAYMENT ONLINE WEB-BASED (CASE STUDY IN THE RENTAL DARAS CORPORATION) Deffi Rosdiana Sari 10107844 Universitas Komputer Indonesia (UNIKOM) Jl. Dipati Ukur No. 112-116, Bandung 40132 Email :
[email protected]
ABSTRACT Daras Rental Corporation is a car rental that is in Jl. Merkuri Selatan II No. 17 Margahayu Raya Bandung - West Java 40286. Daras Rental provides car rental services in the form of daily, weekly and monthly. The different types of cars based on type, price, and existing facilities in every car. In the process of promoting the company has done many ways, that is by exchanging information through one customer to another customer and advertising in a newspaper column, it turns out the way it felt less effective because companies cannot provide information about the cars that will be leased in a complete and detailed so the customer cannot getting complete and accurate information about the cars rented by the Rental Daras. During this time car rental booking transactions are performed by the customer in the rental in question via phone or come directly to the rental. The Problems also appear on car rental reservations using the phone will require a long time to obtain information about a car that has not been rented. In other side, problems arise in the process of recording car rental reservations are a lot of time because it is still fed through a desktop application. As well as ordering by telephone because of unsatisfactory customer could not see the pictures of cars that will be rented. To overcome these obstacles then built a reservation system application and payment webbased online car rental in Daras Rental Corporation, the modeling software used is structured method. The system is web-based, with data security and networking applications is assured, as well as automatic payment process using a third party is Paypal account and transfer. Based on the research and after do an alpha test and betha of booking and payment system online web-based car rental at Rental Daras, the results to be achieved in the booking and payment system online web-based car rental at Rental Daras can assist in increasing the rental car, can help in the promotion and introducing Rental car leased by Daras, and also can assist in disseminating the marketing and leasing Rental car Daras
1. INTRODUCTION 1.1 Background Daras Rental Corporation is a rental car that is in Jl.Merkuri Selatan II No. 17 Margahayu Raya Bandung - West Java 40286. Daras Rental Corporation provides car rental services in the form of daily, weekly and monthly. Different types of cars based on type, price, and existing facilities in every cars. The work done to promote cars that will be leased as well as provide information about Daras Rental Corporation to customers, the company has done various ways, namely by exchanging information through a single
customer to another customer and advertising in a newspaper column. After promotion to the second company this way was the way it felt less effective because companies can not provide information about the cars that will be leased and analyzed in detail so the customer lack of complete and accurate information about the cars supplied and leased by the Rental Daras Corporation. During this time car rental booking transactions performed by the customer in the rental in question via phone or come directly to the rental. The problems also appear on car rental reservations using the phone will require a long time to obtain information
Deffi Rosdiana Sari Jurnal TA/SKRIPSI
1
about a car that has not been rented. In addition, problems arise in the process of recording car rental reservations are a lot of time because it is still fed through a desktop application. As well as ordering by telephone because of unsatisfactory customer could not see the pictures of cars that will be rented. Data processing and report preparation occurring at Daras Rental Corporation at the moment using the data processing is recorded in the form of bookkeeping. All proof of payment transactions per day are collected and made into a ledger recording the transaction to facilitate the processing of transaction data. Each car is taken and recorded in the book is returned the car with the aim of facilitating enterprise data searching cars when there are customers who will make a reservation or ask the amount of product inventory. 1.2 Problem Formulation Based on the background that have been raised, then the formulation of problems in the booking and payment systems based online car rental web at Daras Rental Corporation was how to build a reservation system and payment of a web-based online car rental in Daras Rental Corporation. 1.3 Purpose and Objectives 1.3.1 Purpose The purpose to be achieved from this research is to build a reservation system application and payment web-based online car rental in Daras Rental Corporation. 1.3.2 Objectives The goal of this research are: 1. Facilitate the company in providing complete and detailed information to customers about the cars that will be leased by Daras Rental Corporation, so that customers can get a complete and accurate information about the cars along with pictures of cars that will be leased. 2. Will facilitate the customer at the time of booking car rental without having to come directly to the Rental Daras Corporation to find a car that has not been rented. 3. Facilitate staff in the process of recording and reporting booking car rental will not take much time.
2. MODELS, ANALYSIS, DESIGN AND IMPLEMENTATION 2.1 Models Software development model in the making of this application using the waterfall model. The stages contained in the waterfall model based on figure 1.1 is as follows: a. System engineering (Software Engineering) The first stage is done is to formulate a system that we are building. It is intended that the developer really understood that we are building systems and measures as well as any policy relating to the development of the system. b. Requirement analiysis Conducting an analysis of the problems faced and set the software requirements. c. Design Produce designs that meet the requirements specified during the requirements analysis phase. The end result of a very detailed design specifications, so easy to be realized at the time of programming. d. Coding (implementation) Coding that implements the design into a code or machine language understood by the computer using a particular programming language. e. Testing (testing) The testing program that produces truth. The testing process focuses on the internal logic of the software, ensure that all statements have been tested and determine whether desired results have been achieved or not. f. Maintenance (Maintenance) Dealing with the finished software to run smoothly and avoid the disturbances that can cause damage. System Engineering Requirements Analysis
Design
Coding
Testing
Maintenance
Feedback
Figure 1.1 Waterfall Metode
Deffi Rosdiana Sari Jurnal TA/SKRIPSI
2
2.2 Analysis A. Analysis System A system is a network of procedures that are interconnected, gathered together to perform an activity or solve a particular target [9]. While system analysis is the decomposition of a whole system into its component parts in order to identify and evaluate problems, constraints resulting from the requirement so that it can be proposed and hopefully its make reforms. The things done at the stage of system analysis is the analysis of the problem, the procedure is running, the documents involved, coding analysis, analysis of functional requirements and nonfunctional requirements include the analysis of hardware, software analysis and analysis of the user.
Sekretaris
Customer
Formulir kwitansi pembayaran
Formulir kwitansi pembayaran
Pembayaran uang sewa
Uang sewa
Uang sewa
Pemeriksaan uang sewa
Sesuai ?
Tidak
Pembayaran uang sewa tidak sesuai
Pembayaran uang sewa tidak sesuai
Ya Pembayaran ulang uang sewa
Pembayaran uang sewa sesuai
Pembuatan kwitansi pembayaran
2 1 Kwitansi
pembayaran
Pengesahan kwitansi pembayaran 1
2
Kwitansi
pembayaran ACC
1 Kwitansi
sekretaris
pembayaran ACC sekretaris
a2
a2 : arsip kwitansi pemesanan ACC Sekretaris pada sekretaris
Gambar 2.2 Flowmap Pembayaran Sewa Mobil Sekretaris
Customer
Supir
1 1
Kwitansi Kwitansi
pembayaran ACC
pembayaran ACC
B. Fungtional Analysis When will build an application program, the first step to do that is by studying and analyzing the running system. Analysis of booking and payment system online webbased car rental at Rental Daras the current operation will be described in flowmap.
sekretaris
sekretaris
Pengecekan kwitansi pembayaran
Kwitansi pembayaran tidak sesuai Kwitansi pembayaran tidak sesuai
Tidak
Sesuai ?
Ya
Kwitansi pembayaran yang sesuai
Pengecekan penggunaan jasa supir
Ada ?
Jasa supir ada
Ya
Jasa supir ada
tidak Jasa supir tidak ada
Customer
Pengambilan mobil
Mobil di bawa
Pengambilan mobil
Sekretaris
Formulir Pemesanan
Formulir Pemesanan
Pemilihan mobil yang akan disewa
Mobil yang akan disewa terpilih
Mobil di bawa
Mobil di bawa
Pengesahan kwitansi
1
Mobil yang akan disewa telah dipesan
Mobil yang akan disewa telah dipesan
Ya
pembayaran ACC customer
Telah disewa ?
a3
Tidak
a3 : arsip kwitansi pemesanan ACC customer pada customer
Mobil yang akan disewa ada
Pemilihan ulang mobil yang akan disewa Mobil yang akan disewa ada
Gambar 2.3 Flowmap Car Rental Payment Pemeriksaan status supir
supir terpilih
Pemilihan penggunaan jasa supir Ya Tidak
Kwitansi
Pemeriksaan mobil yang akan disewa
Mobil yang akan disewa terpilih
Jasa supir terpilih Tidak
Supir ?
Jasa supir tidak terpilih
Pemilihan supir
Ada ?
Sekretaris
Ya
Status supir tidak ada
Customer
Supir
2
Pengisian formulir pemesanan
supir terpilih
Formulir pemesanan terisi
Status supir tidak ada
Status supir ada
pembayaran di
pembayaran di
ACC customer
ACC customer
Pengecekan kwitansi pembayaran
Lengkap ? Formulir pemesanan tidak lengkap
Tidak
2 Kwitansi pembayaran tidak sesuai 2
Pemeriksaan kelengkapan formulir pemesanan
Status supir ada
Pengisian ulang formulir pemesanan
Kwitansi Kwitansi
Formulir pemesanan terisi
Pemilihan ulang supir
Formulir pemesanan tidak lengkap
2
Sesuai ?
Tidak
Kwitansi pembayaran tidak sesuai
Ya
Ya
Formulir pemesanan terisi lengkap
Kwitansi pembayaran yang sesuai
a1
Pengecekan penggunaan jasa supir
a1 : arsip formulir pemesanan pada sekretaris Ada ?
Gambar 2.1 Flowmap Car Rental Booking
Ya
Jasa supir ada
Jasa supir ada
tidak Jasa supir tidak ada
Jasa supir tidak ada
Pengembalian mobil
Pengembalian mobil
Mobil di kembalikan
Mobil di kembalikan Mobil di kembalikan
Pembuatan kwitansi order
2 1
1 Kwitansi order
Kwitansi order
a4
a4 : arsip kwitansi order pada sekretaris
Gambar 2.4 Decision Flowmap Car Rental
Deffi Rosdiana Sari Jurnal TA/SKRIPSI
3
C.
Database Analysis The database is a collection of data that can be described as the activity of one or more organizations that are related. This phase is used to analyze any data that are related and are involved in the manufacturing system. Entity Relationship Diagram (ERD) is a modeling tool that is used to describe relationships between entities that happen, which contains the components of entities and relationships are each equipped with attributes that represent all the facts from some of the real world. Entity Relationship of booking and payment system in the car rental Rental Daras is a network model that uses the order data stored in the system in the abstract.
2.
DFD Level 0 Info login valid, invalid Data login staff Info daftar member Data daftar member
Data member
Data member
Aktifasi registrasi data
1.0 Daftar
Info staff staff
Data login staff Info login valid, invalid Data staff Data member Info login valid, invalid Data login member
fasilitas
Full_nama
deskripsi
Tgl_lahir
kapasitas
Jenis_identitas
bagasi
No_identitas
Request data mobil Request data produsen
Member
Request data mobil Request data produsen
Info member
Data order Data detail order Data konfirmasi
Staff
Info mobil Info produsen
Info mobil Info produsen
Info order Info detail order Info konfirmasi
Info mobil
Id_order
pintu
kota
Id_member
harga
Data mobil Data produsen Data order
Request data pembayaran
Paypal
Info mobil Data mobil
6.0 Order
Info detail_order Data detail_order Data staff Info produsen Data produsen
Info produsen
Status pembayaran
Data produsen
Kode_pos
Status_order
img
negara
Time_order
status
No_tlp
Time_back
view
No_hp
Payment
vots
status
Id_staff
Data detail_order
Info produsen
Produsen
Mobil
Member
mengorder
Data report
Info report
Figure 2.7 DFD Level 0
Relation Scheme
PK FK 1
N mobil
1
1 Id_report
1
Mempunyai
Id_order
mempunyai Staff
Nama_produk Id_order
1
Id_thx
status
Id_produk
N
Email_byr_pp
1
Id_order Id_produk Jumlah Time_boking Jam_boking Lama_sewa Lama_sewa2 Jenis_service supir
Order
Report
Id_order PK FK 1 Id_member Status_order Time_order Time_back Payment FK 2 Id_staff
PK Id_report FK 1 Id_order Nama_produk Id-thx Email_byr_pp Nama_byr_pp Total_Buy Time_byr Via FK 2 Id_staff
Member
password email
jumlah
1
Mobil Id_produk Id_produsen Nama_produk Fasilitas Deskripsi Kapasitas Bagasi Transmisi Ac Pintu Harga Img Status View Vots
Id_member Email Password Title Full_nama Tgl_lahir Jenis_identitas No_identitas Pekerjaan Alamat Kota Kode_pos Negara No_tlp No_hp status
Time_boking
N
Mengolah
Jam_boking
Report
Detail order
Time_byr Lama_sewa
Produsen
via Lama_sewa2 Id_staff
PK
Jenis_service supir Id_berita
Staff PK
Id_Staff Username Password Email Nama Jabatan status
Berita Id_Berita PK FK 1 Id_staff judul Tgl Isi_berita
Nama_byr_pp Total_buy
Info order Data order
Id_staff
nama
Order
Info report Report
username
jabatan
Detail_order
Data report
PK
N
N
N
Mengolah
Info staff
Data mobil
1
Mempunyai
4.0 Pengolahan data master
Info mobil
Info detail_order
Id_produsen
produsen
info mobil info produsen info order info detai order
Info mobil Info produsen
Info order
Nama_produsen
AC
alamat
Data mobil Data produsen Data order Data detai order
Data status order 5.0 Cari Mobil
transmisi
pekerjaan
Info staff Info member
Data member Pengunjung
Id_produk Id_produsen nama_produk
title
Data staff
2.0 Login
Detail_ order
email
3.0 Pengolahan data member
Info registrasi data Info member
FK 1 FK 2
password
Info member
Email
3. Id_member
Member
Info login valid, invalid Data login member
Id_produsen Nama_produsen
Id_staff Judul
N
Mengolah
Berita
Tgl Isi_berita
Figure 2.8 Relation Scheme
Figure 2.5 ERD at Daras Rental Corporation
D.
Analysis of Requirements Context Diagram
1.
Non-Functional
Pengunjung
Data login member Request list mobil Request sewa sekarang Request syarat & ketentuan sewa Request hubungi kami Data client area Request data tagihan Request berita Data keranjang belanja
info daftar info list mobil info sewa sekarang Info syarat & ketentuan sewa info hubungi kami info mobil terlaku Info mobil terpopuler info mobil terbaru Info berita
Request daftar Request list mobil Request sewa sekarang Request syarat & ketentuan sewa Request hubungi kami Request mobil terlaku Request mobil terpopuler Request mobil terbaru Request berita
Data login Sekretaris Data setting Data restore Data backup Data pengelolaan mobil Data produsen Data mobil terbaru Data transaksi Data berita Data Daftar member Data laporan
Sistem pemesanan dan pembayaran sewa mobil online berbasis web di Rental Daras Corporation
Member
Info login member Info list mobil Info sewa sekarang Info syarat & ketentuan sewa Info hubungi kami Info client area Info data tagihan Info berita Info keranjang belanja
Info Pembayaran Data Pembayaran
Paypal
2.3 Design A. Menu Structure Design In designing an application that contains the menu structure required menus and submenus that serves to facilitate users in using the application. Here are described on the menu structure in this application: 1. Visitor Menu Structure home
Staff
Info registrasi data berhasil
Aktifasi registrasi data
Info login Sekretaris Info setting Info restore Info backup Info pengelolaan mobil Info produsen Info mobil terbaru Info transaksi Info berita Info daftar member Info laporan
Registrasi member
Kategori Produk
view
Cara belanja
Cara membayar
pengiriman
tambah
Figure 2.9 Menu Structure of Visitors
Email
Figure 2.6 Context Diagram
Deffi Rosdiana Sari Jurnal TA/SKRIPSI
4
2.
3. 4. 5. 6. 7. 8. 9.
Member Menu Structure home
login
Kategori Produk
Ubah profil
Cara belanja
Cara membayar
Pengiriman
Belanja anda
view
tambah
Keranjang belanja
Logout
edit
Figure 2.10 Structure Menber Menu
3.
Staff Menu Structure login
home
Restore
setting
Edit profil
Backup
view
Pengelolaan mobil
produsen
tambah
edit
Figure 2.11 Structure
transaksi
berita
Daftar member
Laporan
Logout
hapus
of Staff Menu
B. Home Design Applications Here is a picture design of the main menu for users and staff. P01
Navigasi :
Keranjang Belanja
Login
Daftar
BANNER Home
List mobil
Sewa Sekarang
Hubungi Kami
RESERVATION Support
:
Biling
:
YM YM
Penyewaan :
YM
Image
Pilih Mobil :
1. Klik tombol home menuju ke form P01 2. Klik tombol list mobil menuju ke form P02 3. Klik tombol sewa sekarang menuju ke form P03 4. Klik tombol hubungi kami ke form P04 5. Klik tombol keranjang belanja menuju ke form P05 6. Klik tombol login menuju ke form P06 7. Klik tombol daftar menuju ke form P07
Nama Produk Nama Produk Nama Produk Nama Produk Nama Produk
Home
List mobil
Sewa mobil
Konfirmasi Pembayaran
kontak
Figure 2.12 Display Home Users A02
At least 256 MB RAM At least 64 MB VGA Card Monitor Lan Card 10/100Mbps At least 64 kbps Internet connection Mouse Keyboard
B. Software Implementation The software used to implement the system are as follows: 1. 1. WAMP as a Web Server 2. PHP 3. Macromedia Dreamweaver 8 as PHP editor. 4. MySQL as DBMS 5. Interface design tool Microsoft Visio 2007 6. Mozilla Firefox and Microsoft Internet Explorer as your browser 7. Domain address www.darasrental.com C. Implementation Form Implementation of the form carried out to find every page program.Here is the form that made implementation. Table 2.1 Implementation Form
Navigasi :
HOME
EDIT PROFIL
SETTING
RESTORE DATA
BACKUP DATA
LOGOUT
Produsen Banner Pengelolaan Mobil Transaksi
Teks
Lihat
Berita
Teks
Lihat
Daftar Member
Teks
Lihat
Laporan
Teks
Lihat
1. Klik tombol login menuju ke form A02 2. Klik tombol home menuju ke form A02 3. Klik tombol edit profil menuju ke form A03 4. Klik tombol setting menuju ke form A04 5. Klik tombol restore menuju ke form A23 6. Klik tombol backup data menuju ke form A24 7. Klik tombol produsen ke form A05 8. Klik tombol pengelolaan mobil menuju ke form A06 9. Klik tombol transaksi menuju ke form A07 10. Klik tombol berita menuju ke form A08 11. Klik tombol daftar member menuju ke form A09 12. Klik tombol laporan menuju ke form A10 13. Klik tombol logout menuju ke form A01
Figure 2.13 Display Home Staff
2.4 Implementation This stage is the stage where the system is ready for operation, which consists of a description of the implementation environment, and program implementation. A. Hardware Implementation The hardware used to implement the system are as follows: 1. Processor with a speed of at least 1 GHz + Motherboard 2. At least 40 GB of hard drive capacity
Menu
Description Used as Staff Login Staff Login Used as the main Home page staff Used if staff want Edit Profil to change the profile Used for setting discount, the Setting price drivers, and currency Used to restore Restore database Used to backup Backup database Used to add, edit, Manufactur and delete the ers manufacturer Used Cars to add Car Mana data car with a genement car description
File Name login.php home.php edit_profil. php
setup.php
restore.php backup.ph p add_manuf actures.php add_produ ct.php
Deffi Rosdiana Sari Jurnal TA/SKRIPSI
5
Used to see all the car rental Transaction transaction, s cancel the transaction, and the car back Used to view and News add news Member Used to view the List data member Used to view Reports transaction reports Used staff to exit Logout the application List of used to register members the members Used as login member login Login page and forgotten passwords Used to change Edit Profil the profile member Used for data bill Data orders that have Collection been paid or not The way Used to see how shopping to do shopping Used to fill the Rent Now orders data Used to view the Contact Us view the company profile Used to view Shopping detailed rental car Cart ever made
Figure 3.1 Form Home User
tansaction. php
news.php member.ph p
Figure 3.2 Form Home Admin
reports.php
4. CONCLUSIONS AND SUGGESTIONS
logout.php
4.1 Conclusions Based on research conducted by the authors regarding the development of ecommerce applications on the Rental Daras, then some conclusions can be drawn as follows: 1. This application can provide detailed and accurate information on rental cars Rental Daras prospective tenants online, so the company helped in promoting the car and expand the network to effectively and efficiently. 2. This application is easier for companies in transaction processing and data management that occurs in Rental Daras. 3. This application helps companies become more nimble in making the report because the staff concerned should not find the data that has been previously archived.
register_m ember.php
login.php
edit_profil. Php my_order. php service.vie w.php process.ph p contact_us. php cart.php
4.2 Suggestion The author proposes some suggestions that can be considered against the use of systems that have been made, namely: 1.
3. RESULTS AND DISCUSSION From analysis and design that has been done, the results of the application that was built to look like the following view:
2. 3.
At least need also to open branches in major cities in addition to Bandung, for more developed and more and more customers. The interface can be made more attractive. It is necessary to develop the credit card payment system, so that when the customer does not have a paypal account customers can pay with credit cards.
5. REFERENCES [1] Jogiyanto HM, Akt MBA. (2005). Information Systems Analysis
Deffi Rosdiana Sari Jurnal TA/SKRIPSI
6
[2]
[3]
[4] [5]
[6]
[7] [8]
[9] [10] [11] [12] [13]
and Design: a structured approach to the theory and practice of business applications, Andi, Yogyakarta. Ilham Perdana, 2007, Hand Out Research Methodology, Scientific Writing Procedures Directive, the University Computer Indonesia, Bandung. Marcus, T., (2007), Software Engineering, Elex Media Komputindo, Jakarta, 212-235. Arbie, Database Management with MySQL, Andi, Yogyakarta, 2003 Bunafit Nugroho, Creating Web-Based Sales Information System with PHP and MySQL, Gava Media, Yogyakarta, 2008. Jonathan Sarwono (2008), Theory of ECommerce Success in Internet Commerce, Gava Media, Yogyakarta. Kurniawan, Rulianto, 2007, 54 Hidden Tricks PHP, Maxikom, Kilkenny .. Kadir, Abdul (2002). "Basic Dynamic Web Programming Using PHP", Yogyakarta, ANDI. Information system, the foundation of ebussinnes, steven alter, Prentice Hall. http://people.redhat.com/mingo/TUXpatches/ October 20, 2010 http://www.fenrus.demon.nl/ October 20, 2010 http://www.boa.org/ October 25, 2010 http://www.sejarah-internet.com/ 3 September 2010
Deffi Rosdiana Sari Jurnal TA/SKRIPSI
7
