Journal of Business, Social and Technology (Bustechno) http://bustechno.ridwaninstitute.co.id/index.php/jbt/issue/current

TIRE SALES APPLICATION PROGRAM AT LAM JAYA WEB-BASED STORE

Mar'atus Solikhah

Education Development Consultant, Syntax Corporation Indonesia, Cirebon Jawa Barat, Indonesia

Email: [email protected]

Abstract

Article Information: Received Revised Accepted Keywords: sales application program; tires; web-based sinceter store

Along with the development of technology and information at this time, especially the world of computers is growing very rapidly, coupled with the presence of information technology that increasingly plays a role in the world of work. By using the right information technology tools, all human activities in the work can be done easily, efficiency and save time and cost, monitored and represented in accordance with the calculations and rules of the game that have been set. One of the information tools is the Internet, an unlimited global on-line network that provides millions of types of information. Internet is a connection facility of a website that wants to make itself as a social system that can be accepted by users and can be used as a positive thing Is a technique of collecting data, news, facts and information in the field that the process can be done by asking directly to the parties who can provide information about the problem that is being researched or indirectly such as making a phone call, emails and letters (written interviews)..

Introduction

Along with the development of technology and information at this time, especially the world of computers is growing very rapidly, coupled with the presence of information technology that increasingly plays a role in the world of work (Rosa, 2014). By using the right information technology tools, all human activities in the work can be done easily, efficiency and save time and cost, monitored and represented in accordance with the calculations and rules of the game that have been set (Enterprise, 2016). One of the information tools is the Internet, an unlimited global on-line network that provides millions of types of information. Internet is a connection facility of a website that wants to make itself as a social system that is acceptable to users and can be used as a positive thing (Indrajani, 2011). The Era of Information and Communication Technology (ICT) and digital innovation lead to dynamic changes in the business environment, where business transactions continue to shift from cash-based transactions to electronic-based transactions (Rastogi et al., 2018).

As is known also the development of computer-based information technology is more likely to be able to meet the needs of information more quickly and accurately, through cyberspace better known as internet media (Nurkarsa, 2021). In internet media, the term Electronic Commerce or e-commerce is now a broad picture of the scope of technology, processes and practices that can conduct business transactions without using paper as a means of transaction mechanisms. This can be done in various ways, such as using Email, Electronic Data Interchange, or World Wide Web (WWW) involving domestic and international communities (Niranjanamurthy, Kavyashree, Jagannath, & Chahar, 2013).

Lam Jaya shop is one of the distributors of motorcycle tires with the brand Corsa. Lam Jaya shop is located in Lemah Abang-Cikarang precisely in Cikarang Regency (Fatonah, Yulandari, & Wibowo, 2018). This store sells various types of tires with the Corsa brand, but in the sales transactions are still using manual or uncomputerized means, namely by recording the results of sales transactions into books and storing sales receipts (Nugroho, 2015). This is an obstacle dikarnakan often loss of sales receipt data so as to hinder the process of presenting reports of sales transaction results. In addition, the search for goods data at the time of making a sales transaction takes a long time, because in the process of searching only by using the list of goods notebook (Pratama & Putu, 2014).

Based on the description above, the author designed a program for the sale of motorcycle tires at Toko Lam jaya which is expected to be able to help in running its business better and is expected to improve results and better quality, especially in terms of processing data on motorcycle tire sales transactions (Muchlis, 2020).

Based on the problems and description above, the author raised the julul "Tire Sales Application Program At Lam Jaya Web-Based Store".

Method

Data collection techniques are carried out to obtain all information and data related to the need for completion of the final task. As for the things that are done as follows:

1. Field Studies

It is a research design that combines literature searches and surveys based on experience or case studies where researchers attempt to identify important variables and balance between them in a particular sproblem. Field studies can include observations and interviews of the objects studied.

a. Observation

The method is carried out to systematically identify data done either by paying attention directly or indirectly to the objects studied and taking visual data according to research needs so that no data is missed in the development of sales information system in Toko Lam Jaya using PHP and MySql.

b. Interview

Is a technique of collecting data, news, facts and information in the field that the process can be done by asking directly to the parties who can provide information about the problem that is being researched or indirectly such as making telephone, email and letter (written interview).

2. Literature Studies

Efforts made by the author to gather information relevant to topics and issues that will or are being researched. The information can be obtained from scientific books, research reports, scientific papers, thesis and dissertations, regulations, statutes, yearbooks, encyclopedias and written sources both printed and electronic and internet.

Results and Discussion

A. System Design

1. Entity Relationship Diagram/ERD

Figure 1

�Entity Relationship Diagram

2. Normalization

a. 1NF Normal Shape

1) Tire Out

Table 1

Normal Form 1NF(outlet)

No	No.Keluar	Tanggal	Untuk	Ket.	Kode	Kategori	Nama Ban	Qly	Prince	Amount	Total
1	BKB06	05-11-2016	RENDI	CORSA S33	B006	TUBBLESS	CORSA S33	2	237.000	474.000	474.000
2	BKB07	07-11-2016	DANI	CORSA S123	B006	TUBBLESS	CORSA S123	3	465.000	1.395.000	1.395.000

2) Incoming Tires

Table 2

Normal Form 1NF(Inlet)

No

No.Masuk

Tanggal

Pembawa

Pemilik

Ket.

Kode

Kategori

Nama Ban

Qly

Prince

Amount

Total

1

BMB07

05-11-2016

HERU

YOPI

CORSA S33

B006

TUBBLESS

CORSA S33

11

237.000

474.000

474.000

2

BMB08

06-11-2016

HERU

YOPI

CORSA S123

B006

TUBBLESS

CORSA S123

18

465.000

465.000

1.395.000

b. Normal Form 2NF

�Tire Out

Figure 2

�Exit Tires (2NF)

�Incoming Tires

Figure 3

Incoming Tires (2NF)

c. Normal Shape 3NF

Figure 4

Exit Tires (3NF)

�Incoming Tires

Figure 5

�Incoming Tires (3NF)

3. Program View Design

a. �Login Menu View Design

Login Menu View Design

b. Main Menu Screen Design

Figure 6

Main Menu Form Design

c. �Incoming Tire Design

Figure 7

�Design Of Incoming Tire Form

d. �Exit Tire Design

Figure 8

Out Tire Form Design

a. �Draft Incoming Tire Report

Figure 9

Draft Report Form Of Incoming Tires

e. �Draft Exit Tire Report

Figure 10

Draft Report Form Tire Out

f. �Tire Design

Figure 11

Tire Form Design

B. Implementation

1. Relationships Between Tables

Figure 12

Relationships Between Tables

2. Database Structure

a. User Table

Table Name����� : User

Media ������������� : Harddisk

Key field �������� : id

Organisasi file� : Xampp

Table 3

User Table Structure

No	Nama Field	Type	Size	Keterangan
1	Id	Int	11	Primery Key
2	Username	Varchar	150
3	Password	Varchar	12
4	Level	Varchar	8
5	Namauser	Varchar	150
6	Alamat	Text
7	Tanggalrubah	Varchar	10
8	Jamrubah	Time

a. Masterban table

Table Name ����������� : Master ban

Media �������������������� : Harddisk

Key field ��������������� : kodeban

Organisasi file �������� : Xampp

Table 4

Masterban Table Structure

No	Nama Field	Type	Size	Keterangan
1	Kodeban	Varchar	5	Primery key
2	Namaban	Varchar	75
3	Ukuran	Varchar	10
4	Harga	Int	12
5	Keterangan	Text
6	Kodekelompok	Varchar	3
7	Kodeuser	Varchar	10
8	Tanggalrubah	Varchar	10
9	Jamrubah	Time

a. Group Table

Table Name ����������� : Kelompok ban

Media �������� ����������� : Harddisk

Key field ��� ����������� : Kode kelompok

Organisasi file�������� : Xampp

Table 5

�Group Structure

No	Nama Field	Type	Size	Keterangan
1	Kodekelompok	Varchar	3	Primery Key
2	Namakelompok	Varchar	50
3	Kodeuser	Varchar	10
4	Tanggalrubah	Varchar	10
5	Jamrubah	Time

b.Table Masukban

NameTable��� : Masukban

Media ���������������������� : Harddisk

Key field ������ : Nomor masuk ban

Organisasi file ���������� : Xampp

Table 6

�Table Structure Masukban

No	Nama Field	Type	Size	Keterangan
1	Nomor masuk ban	Varchar	5	Primery Key
2	Tanggal masuk ban	Varchar	10
3	Pembawa	Varchar	50
4	Pemilik	Varchar	50
5	Keterangan	Text
6	Kodeuser	Varchar	10
7	Tanggalrubah	Varchar	10
8	Jamrubah	Time

c. ��Exit Table

Name Table�� : Keluar ban

Media����������� : Harddisk

Key field������ : Nomor keluar ban

Organisasi file : Xampp

Table 7

�Exit Table Structure

No	Nama Field	Type	Size	Keterangan
1	Nomor keluar ban	Varchar	5	Primery Key
2	Tanggal keluar ban	Varchar	10
3	Untuk	Varchar	50
4	Keterangan	Text
5	Kodeuser	Varchar	10
6	Tanggalrubah	Varchar	10
	Jamrubah	Time

d.Table Masukbandetail

Name Table�� : Masukbandetail

Media����������� : Harddisk

Key field������ : id

Organisasi file : Xampp

Table 8

�Table Structure Masukbandetail

No	Nama Field	Type	Size	Keterangan
1	Id	Int	5	Primery Key
2	Nomormasukban	Varchar	5
3	Kodeban	Varchar	15
4	Banyak	Int	12

e. Table Out Tires detail

Name Table � : Keluar ban detail

Media ���������������������� : Harddisk

Key field ������ : id

Organisasi file ���������� : Xampp

Tabel 9

�Struktur Tabel Keluarbandetail

No	Nama Field	Type	Size	Keterangan
1	Id	Int	5	Primery Key
2	Nomorkeluarban	Varchar	5
3	Kodeban	Varchar	15
4	Banyak	Int	12

3. Main Menu View, Program Input and Output

a. View Login

Figure 13

�Menu Login

b. View Main Menu

Figure 14

�Main Menu

c. Category Menu View

Figure 15

�Menu Categories

d. �Tire Menu Display

Figure 16

�Menu Ban

e. �Entrance Ban Menu View

Figure 17

�Incoming Tire Menu

f. �Tire Out Menu View

Figure 18

Exit Tire Menu

g. Tire Report Menu View

Figure 19

Tire Report Menu

h. Incoming Ban Report Menu View

Figure 20

Incoming Tire Report Menu

i. �Exit Ban Report Menu View

Figure 21

�Exit Tire Report Menu

j. �Gant Password Menu View

Figure 22

Menu Change Password

4. Program Compile / Program End Result

a. Database steps used

1) Start with the star menu on the taskbar, select the all program menu

2) Type : localhost

b. Select phpmyadmin

1) Select a database

2) Type the db_dbms in the create database field

3) Type create

c. Create a table

1) Select create table

2) Type the table name in the table name column

3) Type the name of the field in the name field

4) Choose the data type

5) Fill in the length of the characters in the column leght / values

6) Specify primery key in index column

7. Select save

d. Steps to run the corsa sales application program

1) Select the star menu in the taskbar column select all programs

2) Choose google chrome

3) Type localhost/corsa

4) Enter username and password

e. Main Menu

1) Home

2) User List

3) Category

4) Tires

5) In-House Ban

6) Tire Out

7) Ban Report

8) Incoming Tire Report

9) Exit Tire Report

10) Change Password

11) Sign out

Conclusion

Based on the discussion about the sales application program in Toko Lam Jaya, the author can conclude as follows: 1) The process of recording sales and reports that are still manual resulting in data errors and also scattered so that data appears in the store often the occurrence of data loss. 2) With the sales system in Toko Lam Jaya, the business process carried out can be well organized.

REFERENCES

Enterprise, Jubilee. (2016). Belajar Sendiri Desain Web Dengan Dreamweaver. Elex Media Komputindo.

Fatonah, S., Yulandari, A., & Wibowo, Ferry Wahyu. (2018). A Review Of E-Payment System In E-Commerce. Journal Of Physics: Conference Series, 1140(1), 12033. Iop Publishing.

Indrajani, S. M. (2011). Pengantar Dan Sistem Basis Data. Jakarta: Pt Elex Media Komputindo.

Muchlis, Vidya Asnita. (2020). Pengaruh Dimensi Kualitas Layanan Terhadap Tingkat Kepuasan Nasabah Pada Pt. Bank Rakyat Indonesia (Persero) Tbk, Cabang Ahmad Yani Makassar.

Niranjanamurthy, M., Kavyashree, N., Jagannath, S., & Chahar, Dharmendra. (2013). Analysis Of E-Commerce And M-Commerce: Advantages, Limitations And Security Issues. International Journal Of Advanced Research In Computer And Communication Engineering, 2(6), 2360�2370.

Nugroho, Bunafit. (2015). Panduan Membuat Aplikasi Program Toko Berbasis Web Dengan Php�Mysql Dan Dreamweaver. Penerbit Gava Media, Yogyakarta.

Nurkarsa, Aldo Adit Hermaya. (2021). Program Aplikasi Penjualan Ban Pada Toko Y Berbasis Web. Equivalent, 1(1), 1�4.

Pratama, Agus Eka, & Putu, I. (2014). Sistem Informasi Dan Implementasinya, Informatika. Bandung.

Rastogi, Vaibhav, Singh, Devina, Tekiner, Halil, Ye, Fan, Kirchenko, Nataliya, Mazza, Joseph J., & Yale, Steven H. (2018). Abdominal Physical Signs And Medical Eponyms: Physical Examination Of Palpation Part 1, 1876�1907. Clinical Medicine & Research, 16(3�4), 83�91.

Rosa, A. S. (2014). Sm, Rekayasa Perangkat Lunak Terstruktur Dan Berorientasi Objek. Informatika Bandung.

Copyright holder :

Mar'atus Solikhah (2020)

First publication right :

Journal of Business, Social and Technology (Bustechno)

This article is licensed under: