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), 23602370.

 

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

 

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

 

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, 18761907. Clinical Medicine & Research, 16(34), 8391.

 

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: