BUILDING APPLICATIONS ONLINE BOOKING ON THE WEB-BASED CV DHISAL AMANAH Nianti Pratidina Dewi 10106147 Universitas Komputer Indonesia (UNIKOM) Jl. Dipati Ukur No. 112-116, Bandung 40132 Email :
[email protected]
ABSTRACT CV. Dhisal Amanah is a company engaged in the sale of slippers with a variety of unique shapes and styles. The company issued a 17 characters sandals with a variety of categories. That is the reason why many people looking for this product. In the process of product sales, the company still needs updating in terms of access to promotion. The development of e-commerce is currently providing the changes to the sector of business activity during this run in the real world into the virtual world. CV. Dhisal Amanah will try to update how the dissemination of information about products using the Internet media. To overcome the above problems, it will build an online booking application in CV. Dhisal Amanah using structured methods. The application is web based so that the agents can make transactions 24 hours spending wherever and whenever they want, with data security and secure networking applications and offline payment options by selecting the appropriate bank with the wishes or online payment using a payment gateway such as paypal. Based on the research and after doing an alpha test and betha on Online Booking Application in CV. Dhisal Amanah, the conclusion can be drawn is known that on the Application Online Booking. CV Dhisal Amanah can assist in the process of distributing information both product promotion and sales of products quickly and accurately, and be able to automate the transaction process, so that the process of promotion and sale of products became more optimal that will affect the development of business CV. Dhisal Amanah. Keywords: E-commerce, promotion, product sales. 1. INTRODUCTION 1.1 Background CV. Dhisal Amanah is a company engaged in the sale of slippers with a variety of unique shapes and styles. Slippers are sold, designed a very simple, so comfortable to be brought anywhere. Made of high quality sponge eva. Elastic material which makes this slipper feels comfortable when used. In addition to its unique sandals and the style, size of the issue is very unique. CV. Dhisal Amanah just making sandals with a size 26, 30, 34, 38, 40, 42 so that in addition to small children, even adults can use these slippers. Characters that use any variety of companies like sandals with a shape of pandas, frogs, beetles, dolphins, whales, grapes, strawberries, apples, hearts, and basketball. Because that's the reason why many consumers are looking for this product. Until recently CV. Dhisal Amanah already has several agents, sub agents, and retailers in various cities in Indonesia, which served to promote and sell their products. In the process of promotion is needed flexibility in its distribution of products ranging from distance coverage, timeliness, or the ease offered. It became the main support in a sales process. But in its
implementation in CV. Dhisal Amanah still need a renewal in terms of access to promotion and sales, as it is still difficult in the process of distributing information on product promotion and sales of products with a limited ability to reach their destination, whose implementation is still waiting for customers. The development of e-commerce is currently providing the changes to the sector of business activity during this run in the real world to the virtual world. Many companies and individuals who explore business because of the speed of accessing the internet anytime and anywhere, the validity of the data, promotions and product purchasing process is relatively convenient, and secure transaction processing is an attractive offer in a process of sale system. CV. Dhisal Amanah including one company that tried to widen the area of sales and marketing via the Internet so that their products become better known by many people. CV. Dhisal Amanah already have a website for consumers, but the website does not provide detailed information about the products sold, there's only contact person and an explanation how to join the
agency, but for those who want to become agents still have to come to the store to pick up the catalog so that all forms of booking and how to become an agent is still done manually (offline). This is still one problem in the sales process is, the less easy it is in all aspects of the sale of media products ranging from automation of transactions until the information delivery of goods to agents, sub agents, and retailers that are beyond the island of Java. Therefore, it would require an application form ecommerce website that can provide detailed information about products to agents, sub agents, and retailers to quickly and easily through the Internet. In addition, the presence of e-commerce website customers can make purchases and reservations online without having to go to the store. With all that there is readiness on the agents, sub agents, and retailers ranging from Internet access to everything that has been computerized, it is to overcome these obstacles need to build an application, namely "Building Applications Online Booking on the Web-Based CV. Dhisal Amanah ". 1.2 Problem Formulation From the background was found several problems that are formulated in a formulation of the problem of how to build Application Online Booking on the Web-Based CV. Dhisal Amanah. 1.3 Purpose and Objectives 1.3.1 Purpose Building Applications Online Booking on the WebBased CV. Dhisal Amanah.
contained in the waterfall model based on figure 1.1 is as follows : a. System 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 analysis 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 language understood by the machine computer using a particular programming language. e. Testing 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 Dealing with the finished software to run smoothly and avoid the disturbances that can cause damage. System Engineering Requirements Analysis
Design
Coding
1.3.2 Objectives The goal of this research are : 1. Build an online booking website which can be a media sales to improve service to consumers. 2. Easing the dissemination of information on product promotions and product sales in its implementation are still waiting for customers. 3. Ease in all aspects of sales process automation products ranging from transaction processing. 4. Agents can download the catalog without having to come to the store. 5. Provide information up-to-date on the products owned by CV. Dhisal Amanah to consumers. 6. Changing the way manuals (offline) in the process of ordering and purchasing products online. 2.
MODELS, ANALYSIS, DESIGN AND IMPLEMENTATION 2.1 Models Software development model is the making of this application using the waterfall model. The stages
Testing
Maintenance
Feedback
Image 1.1 Waterfall Method
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]. 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 it can be proposed its 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.
Pembayaran
B. Functional Analysis When will build an application program, the first step to do that is by studying and analyzing the running system. Analysis of the online booking web based applications on the CV Dhisal Amanah current operation will be described in flowmap.
Bagian Penerima Order
Agen
Staff Gudang
Staff Administrasi
Manager
Bon permintaan barang yang disetujui
Laporan pembayaran
Bon permintaan barang yang disetujui
Diisi
Kwitansi pembayaran yang telah diisi
Kwitansi pembayaran yang telah disetujui
Kwitansi pembayaran yang telah diisi Catat
Disetujui
Pemesanan Agen
Data pembayaran
Bagian Penerimaan Order
Staf Gudang
Formulir permintaan barang yang kosong
Formulir permintaan barang yang kosong
Data order barang yang belum disetujui
Pengisian formulir
Formulir permintaan barang yang telah diisi
pengecek akan
Kwitansi pembayaran yang telah disetujui
Staf Administrasi
Buat laporan pembayaran
Order barang disetujui Laporan pembayaran
Formulir permintaan barang yang telah diisi
Diperiksa
pencat atan
Order barang jadi disetujui
Buku catatan pemesanan barang tercatat
No
Order barang tidak disetujui
Image 2.2 Flowmap Payments
Yes
Pengiriman
Mengisi bon permintaan barang
Order barang disetujui
Staf Administrasi
Dijadikan
Staf Gudang
Bon permintaan barang (faktur) yang telah disetujui
Bon permintaan barang (faktur) yang kosong
Bag. Pengiriman
Bon daftar barang yang telah diisi
Agen
Daftar barang yang dikirim
Data order barang yang belum disetujui
Memperbai ki isian formulir order
Formulir permintaan barang yang telah diperbaiki
Menyiapkan barang yang akan dikirim
Diisi
Di isi Formulir permintaan barang yang belum disetujui
Order barang tidak disetujui
Bon permintaan barang (faktur) yang telah diisi
Mengambil formulir data order barang yang belum disetujui
Formulir permintaan barang yang belum disetujui
Barang yang siap dikirimkan
Disetujui Membuat daftar barang yang dikirim
Bon daftar barang yang telah diisi
Formulir permintaan barang yang telah diperbaiki
Membuat bon tanda bukti pengiriman & penerimaan barang
B
Mengko reksi buku catatan
Daftar barang yang dikirim
Bon pengiriman & penerimaan barang yang belum ditanda tangani
Bon pengiriman & penerimaan barang yang belum ditanda tangani
Buku catatan yg telah dikoreksi Bon pengiriman & penerimaan barang yang belum ditanda tangani
A
Image 2.1 Flowmap Booking
Ditanda tangani
Bon pengiriman & penerimaan barang yang sudah ditanda tangani
Bon pengiriman & penerimaan barang yang sudah ditanda tangani
Bon pengiriman & penerimaan barang yang sudah ditanda tangani
Pemesanan Agen
Bag. Penerimaan Order
Staf Gudang
Staf Administrasi
Image 2.3 Shipping Flowmap
A
Mengoreksi isian pada buku catatan
Buku catatan yang sudah dikoreksi
Mengoreksi data order
Bon permintaan barang (faktur) yang telah disetujui
Data order barang yang sudah dikoreksi
B
Bon permintaan barang (faktur) yang telah disetujui
Bon permintaan barang (faktur) yang telah disetujui
Image 2.1 Flowmap Booking
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. Id_pembayara Id_pemesanan n
menentukan
Id_pengiriman _barang
Id_rekening
1
1
Id_pembayara n
1
1
Pembayaran
Pengiriman Barang
menentukan
Status_pengiri man
email Id_ongkir
nama_jenis pengiriman 1
nama_kota
1
Ongkos_kirim
memiliki
1
1 menentukan
Jenis pengiriman id_jenis pengiriman
harga 1
1
Alamat_pengiri man
memiliki
Agen
username
N
1
1
memiliki
username
email
1 Dikelola
Pemesanan
1 memiliki
User
1 Id_produk
Id_pemesanan
password
email
1
Jabatan 1
1 menentukan
Id_kota Kota
Tanggal_akhir
Tanggal_awal
memiliki
nama_kota
Nama_jabatan
Id_produk History harga
N
1
Id_propinsi
harga N
Detail Pemesanan
memiliki
Id_pemesanan memiliki
1
jumlah
1
1
Id_produk
N
Id_propinsi memiliki
Propinsi
Produk
Id_produk
nama_propinsi harga
nama_produk
Image 2.5 ERD on CV Dhisal Amanah
Kd_jabatan
D. Analysis of Non-Functional Requirements 1. Context Diagram
3.
Relation Scheme detail_pesanan agen PK
Data email dan password Data detail pemesanan Data pembayaran Data pemesanan Data agen
Data Pemesanan
Info email dan password Info produk Info history harga Info jabatan Info user Info ongkos kirim Info pengiriman barang Info kota Info propinsi
Data email dan password Data produk Data history harga Data jabatan Data user Data ongkos kirim Data pengiriman barang Data kota Data propinsi
pemesanan PK
password nama alamat nama_kota nama_propinsi
Paypal
Administrator
PK
email
tanggal_pesan jam_pesan email metode pembayaran status_pesanan username
Staff Administrasi
PK
kode_jabatan nama_jabatan
pengiriman barang
id_propinsi
ongkos_kirim
kota PK
PK
id_kota
id_pengiriman kode_pesanan alamat_pengiriman kota propinsi status_pengiriman
Data produk
Aplikasi Pemesanan Online Pada CV. Dhisal Amanaha
Staff Gudang
Image 2.8 Relation Scheme
Pengunjung
Info produk Info produk terlaris
Info email dan password Info produk Data email dan password Data produk Data pemesanan Data detail_pesanan Data pembayaran Data ongkos kirim Data pengiriman barang Data kota Data propinsi
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 :
Data email dan password Data agen Data pemesanan Data detail_pesanan Data pembayaran
Info Produk
Info Password baru Info pemesanan Info pembayaran Kode verifikasi
Manager
Info email dan password invalid Info produk Info pemesanan Info detail_pesanan Info pembayaran Info ongkos kirim Info pengiriman barang Info kota Info propinsi Info produk terlaris
Social Network
Info email dan password invalid Info agen Info pemesanan Info detail_pesanan Info pembayaran Info produk terlaris
Email
Image 2.6 Context Diagram
1.
DFD Level 0
Visitor Menu Structure
Data agen Info agen Info email dan password invalid Data email dan password Info email dan password invalid Data email dan password Info email dan password invalid Data email dan password Info email dan password invalid Data email dan password Info email dan password invalid Data email dan password
User 1 Login
Pengunjung
Pemesanan Detail pemesanan Produk Pembayaran
Data user Info user
History Harga Ongkos Kirim Kota Propinsi
Info email dan password valid
2.
PK
id_ongkir nama_paket kota_tujuan tarif
nama_kota nama_propinsi
Agen
id_history kode_produk harga tanggal_awal tanggal_akhir
jabatan PK
propinsi PK
nama_propinsi
Data email dan password Data produk
history harga PK
id_user
kode_produk nama harga stok berat gambar
id_pembayaran tanggal_pembayaran kode_pesanan nilai_pembayaran id_ongkir
kode_jabatan username password email
Data email dan password Data detail pemesanan Data pembayaran Data pemesanan Data agen
produk PK
pembayaran
user PK
id_detail_pesanan kode_pesanan kode_produk ukuran qty
kode_pesanan
Jabatan Agen Pembelian
Administrator
Data Produk Data jabatan Data produk Data history harga Data user Data ongkos kirim Data kota Data propinsi Info produk Info history harga Info user Info ongkos kirim Info kota Info propinsi Info jabatan
2 Pengolahan data master
Data user Data user Data produk Data produk Data history harga Data history harga Data ongkos kirim Data ongkos kirim Data kota Data kota Data propinsi Data propinsi Data jabatan Data jabatan
Lihat
Staff Administrasi
Data agen
3 Pengolahan data agen
Info agen
Data agen Data agen
Info email dan password valid
Manager
Image 2.9 Visitor Menu Structure Data produk Info produk
Staff Gudang
4 Pengolahan Staff Gudang
Data produk
Info produk Info email dan password valid
Data produk Info produk Data produk Info produk
Pengunjung
Data produk
2.
Agent Menu Structure
5 Mencari Produk Info produk
Agen
Agen Data produk Info produk Data produk Info produk
Data produk Info produk
6 Lihat Produk
Login
7 Register Data register Agen Info register
Data register Agen Info register invalid
Info register valid
Data Agen
Data Agen Data pemesanan Data detail pemesanan Data pembayaran Data produk Data Kota Data Propinsi Info Propinsi Info Kota Info produk Info pembayaran Info detail pemesanan Info pemesanan Info Agen Info email dan password valid
8 Pemesanan
Data pembelian Data pembelian
Data Produk
Data detail pemesanan Data produk Data produk Data pembayaran Data pembayaran Data kota Data kota Data propinsi Data propinsi Data jabatan Data jabatan
Data Kota
Data Propinsi
Data Pembayaran
Tampil
Hapus
Ubah
Tambah
Gambar III.28 Struktur Menu Agen
Data pembelian
9 Keranjang Belanja
Data Detail Pemesanan
Data Pemesanan
Data pemesanan Data pemesanan Data detail pemesanan
Data pembelian
Image 2.10 Agent Menu Structure Email
Data detail pemesanan Data detail pemesanan
Info pembayaran
10 Pembayaran
3.
Data pembayaran Status pembayaran
Paypal
Administrator Menu Structure
Data detail pemesanan Info pembayaran Info pembayaran Info pembayaran
11 Penyajian Informasi Produk Terlaris
Data detail pemesanan Data pembayaran Data pembayaran
Administrator
Info produk terbaru Info produk terbaru
12 Penyajian Informasi Produk Terbaru
Data produk Data produk
Login
Data pembayaran Info pembayaran Info email dan password valid
13 Penyajian Informasi Manager
Data pemesanan Data pemesanan Data detail pemesanan Data detail pemesanan Data pembayaran Data pembayaran Data agen Data agen
Data User
Data Jabatan
Data Produk
Data History Harga
Data Ongkos Kirim
Data Propinsi
Image 2.7 Level 0 DFD
Tambah
Ubah
Hapus
Gambar III.24 Struktur Menu Administrator
Image 2.11 Administrator Menu Structure
Data Kota
4.
Administration of Staff Menu Structure
C02
Klik login menuju C02 Klik akun saya menuju C03 Klik user menuju C04 Klik jabatan menuju C06 Klik produk menuju C08 Klik history harga menuju C10 Klik propinsi menuju C12 Klik kota menuju C14 Klik ongkos kirim menuju C16 Klik logout menuju C01
Header
Staff Administrasi
Main Menu
Anda login sebagai administrator
Home Akun saya
Login
User Jabatan Produk History harga Propinsi
Data Agen
Data Pemesanan
Data Pembayaran
Kota Ongkos kirim Logout
Image 2.16 Display Main Menu Staff Tambah
Edit
Hapus
Image 2.12 Administration of Staff Menu Structure
5.
Warehouse Staff Menu Structure Staff Gudang
Login
Data Produk
Tambah
Image 2.13 Warehouse Staff Menu Structure
6.
Manager Menu Structure Manager
Login
Data Agen
Data Pemesanan
Data Transaksi
Lihat
Image 2.14 Manager Menu Structure
B. Main Menu Design Applications Here is a picture design of the main menu for users and 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 speed 1.8 GHz 2. At least 40 GB of hard drive capacity 3. At least 256 MB RAM 4. At least 256 MB VGA Card 5. Monitor 6. Free hard disk capacity 7. At least 64 kbps Internet connection 8. Mouse 9. Keyboard B. Software Implementation The software used to implement the system are as follows : 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.sandaldhiifs-online.com C. Interface Implementation Interface implementation carried out to find every page program. Here is the implementation of the interface created.
A01
Table 2.1 Implementation of the interface
Header
Main Menu
Daftar jadi agen?
Login
Keranjang Belanja (0)
Batal Belanja
Produk Terlaris
Home About
Text
Klik home menuju B01 Klik about menuju B03 Klik registrasi menuju A03 Klik produk menuju A04 Klik login menuju A03
Menu
Deskripsi
Nama File
User login
Used as a user login page.
index.php/agen/logf orm.html
Home
Used as the home page employee.
index.php/cpel.html
Change passwor
Used as a page to change user
index.php/agen/gan pass.html
Registrasi Produk Konfirmasi Pembayaran FAQ
Informasi
Hubungi kami Login
Gambar produk
Follow Us facebook Produk Terbaru
Yahoo Messenger
Image 2.15 Display Main Menu Users
d
passwords
Province s Data
Used as a page to process Provinces data
index.php/propinsi. html
District Data / City
Used as a page to process the district / city
index.php/kota.html
Data position
Used as a page to process the position data
index.php/jabatan.ht ml
Data users
Used as a page to process user data
index.php/user.html
Price history data
Used as a page to perform data processing price history
index.php/history.ht ml
Data products
Used as a page for processing product
index.php/produk.ht ml
Booking
Used as a page to perform data processing reservations Used as a page to perform data processing payments Used as a page to perform data processing preexisting agent Used as a page to perform data processing postage
index.php/pesanan.h tml
Used as a page to perform data processing report Used as a page to perform data processing delivery
index.php/laporan.h tml
Data transacti on
Used as a page to perform data processing transactions
index.php/transaksi. html
My profile
Used as a page for processing user profiles
index.php/user.html
Logout
Used by the user when going out of the system
index.php/user/logo ut.html
Payment
Data agent
Data postage
Report
Data delivery
Home
Used as the home page of the application
index.php/#.html
About Us
Used as the company's profile page
index.php/cpel/abou t.html
Sign become agents
Used as a notifications page how to register to become agents
index.php/cpel/regf orm.html
Registrat ion
Used as a page for the registration agent
index.php/cpel/regf orm.html
Products
Used as a page to display all products sold Used as a page to make payment
paket-pelatihan.html
FAQ
Used as a page for visitors who want to ask about company
index.php/cpel/faq.h tml
index.php/pembayar an.html
Login
Used as a page for agents to enter into the system
index.php/agen/logf orm.html
index.php/agen.html
Contact us
Contact person and company address
index.php/cpel/cont act.html
Logout
Used by agents to exit the system
index.php/agen/logo ut.html
Cancel Shoppin g
Used as a page to cancel all the expenditure
index.php/agen/bata l.html
Note reservati ons
Used as a page to display booking agent records
index.php/agen/myo rder.html
Downlo ad catalog
Used as a page to download catalogs
index.php/agen/dow nload.html
Confirm ation of payment
index.php/ongkos_k irim.html
index.php/pengirim an.html
3.
index.php/cpel/confi rm.html
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 :
Image 3.1 Form Home User
Image 3.2 Form Home Administrator
4. CONCLUSIONS AND SUGGESTIONS 4.1 Conclusions After going through the online booking application development process at CV. Dhisal Amanah and based on research results on the ground before any additional payment confirmation and shipping status on the transactions that have been accepted can be concluded as follows : 1. The availability of an online sales media that will improve service to its agents, and CV. Dhisal Amanah no longer need to wait for customers in the implementation of the sale of products already available for this application. 2. All customers will be able to shop wherever they want without a time limit and not to worry because all the data related to the agency, booking, payment is stored in the database, so the risk is very little scattered documents. 3. According to the perceptions of agencies involved in the testing, this application provides ease of distributing information on product promotion.
4.2 Suggestions After going through the online booking application development process at CV. Dhisal Amanah it is recommended that this application be reviewed again to see the response to the end because there's been some additions to the application. Therefore need to be evaluated further to develop more robust applications with the expectation that the system needs not yet been reached at this time can be functionally complete for its software to meet system needs to be achieved at a time when that would come and always follow the latest technological developments so as not to lag by other similar companies. And hopefully in the future that develops not only the applications that have been built at this time, but also the company is expected to grow with updated company programs that are too long. For example, the addition of a courier service, the addition of workers so as to increase the amount of production, and the addition of new products. 5.
REFERENCES
[1] Jogiyanto HM,Akt MBA.(2005). Analisis dan desain Sistem Informasi: pendekatan terstruktur teori dan praktek aplikasi bisnis ,Andi,Yogyakarta. [2] Ilham Perdana, 2007, Hand Out Metodologi Penelitian, Petunjuk Tata Tulis Ilmiah, Universitas Komputer Indonesia, Bandung. [3] Bunafit Nugroho, Membuat Sistem Informasi Penjualan Berbasis Web dengan PHP dan MySQL, Gava Media, Yogyakarta, 2008. [4] Jonathan Sarwono (2008), Teori E-Commerce Kunci Sukses Perdagangan di Internet, Gava Media, Yogyakarta. [5] Kadir,Abdul (2002). ”Dasar Pemrograman Web Dinamis Menggunakan PHP”, Yogyakarta, ANDI. [6] http://people.redhat.com/mingo/TUX-patches/ 20 Oktober 2010 [7] http://www.sejarah-internet.com/ 3 September 2010 [8] http://www.surga-online.com/upload.html/31 Desember 2010