Name : Chhorn Bros
NIM : 49012076
TMD : Technology Media Digital
Cashier Management
1. Background
1. Background
Cashiers in a store are employees who specialize in determining a
customer’s bill and taking payment. In most modern stores, this job involves
entering items into a computerized register system through either scanning bar
codes or entering product codes. These computerized systems add up the amount
owed after applying the appropriate taxes, and also tell the Cashier what
change to give when payment is received. A few stores do not use these modern
systems, relying on the math skills of their employees to properly add up the
bill, apply applicable taxes, take payment, and make change. Moreover, Cashier must be able to accurately count money and other forms of
currency. A Cashier who accidentally takes too much or too little payment from
a customer creates a serious problem for the business, and may be responsible
for making up any losses
Almost in
the 21st century, technology has become very important to our society.
Computers are becoming more affordable and are depended upon by many people to
help them in their daily lives, what benefits do our business receive from
technology? There are many ways that technology can benefit business, and other
ways such as for Students, Medical, Army, etc... They need the new technology
to help for working faster. So after researching, we decided to make an
application to sell in Mini Mart. Because so many people in west
Java at Indonesia, they need to live faster as well as working, we respected
that it will be help for employees to work faster in a short moment of time in
the Mini Market when they use this application.
Currently, we saw many companies, they use many applications
to store the Data by Offline Server, but is not on the Web Hosting
that is more secure. On another hand when the users or manger want
to see the Data, and make reports, it can’t do, because it is stores by Offline
Server, it is not by the World Wide Web. So, we hope that
this application, it will be help users very well in their field of work.
Moreover, it will be more secure of data, and it will be not lost of the record
by other ways. Because it is store by the server of Web Hosting.
2.
Requirement of Software
Program is the comprehensive process that leads from an
original formulation of a computing problem to executable programs.
1. JQuery
4. FileZilla used
to Uploading File to the Server of Web Hosting
5. Databases:
Wampserver Apache 2.2.6
3. Requirement of Hardware
Hardware and software specifications
that can be used in this system are as follows.
1. CPU:
1.87GHz
2. Windows 7
3. RAM:
2GB
4. Storage:
500 MB Storage
4. Diagram of DFD
The block
diagram is a concise statement of the image, from the combined cause and effect
between the Insert and the Output of a system. The block diagram depicted with
boxes to indicate the name of the element or process, and the arrows indicate
flow the direction of information. The following block diagram illustrating a
data storage system in isolated storage database.
Figure
1: Data Flow diagram of Cashier.
Figure 2: Data Flow diagram of Level 1.3.1
5. Description of Flow
Chart
Flowchart is a series of
symbols that describe the flow of data and processes that exist in a computer
program. Flowchart begins with the acceptance of the input and output ends with
the appearance. Here's a picture that represents the flowchart in isolated
storage database system. Also this flow charting explain about our processing.
- After the first time
we have to login correctly it will be loading the home page, if we login Data
can’t correct, it will be loading to login again.
- After loading home
page has four menus (Home, Sell, Report and Search) and get users one by one.
5.1 Selling Menu
We clicked on menu sell,
it will include home page sell, and then user scan record will be check the record
in the Data has or does not has. If doesn’t have it will be refresh the home
page sell again, but if it has the record it will be check quantity again, if
quantity have only one value or multiple values, it is going to the next step
then it will be check duplication in table sell reserve and then if
check equal null it will be insert to database, but we have duplicate record it
will be loading to page sell again, and the next step if we click print will
print invoice then end statement.
5.2 Reporting Menu
We clicked on menu
Report, it will be include home page report, and then user want to print report
just search by Day, Month and Year click print report then It will be check
print report if it doesn’t report it will be loading to page report, but it has
record it will be print the report.
5.3 Searching Menu
We clicked on menu
Search, it will be include search page, and then if user want to search report,
they just input product name or barcode or ID then click on search button, then it will be check. If it has
recode it will be does but if doesn’t have, it will be loading searching page
again.
Figure
3: Flow Chart of Cashier.
6.
Uploading File to Server
FileZilla Server is a server that supports FTP and FTP
over SSL/TLS which provides secure encrypted connections to the
server.
FileZilla supports SSL, the same level of
encryption supported by your web browser, to protect your data. When using SSL
your data is encrypted so that prying eyes cannot see it, and your confidential
information is protected. It also supports on-the-fly data compression, which
can improve the transfer rates.
Unfortunately, the compression setting can have
mixed results, so it is advised to use it with care. It is possible for files
that are already compressed to be transferred over the network using more than
their original data size.
Figure
4: Uploading File by Filezilla
7. Backup Database to Server
SQLyog has an ability to format the SQL displayed in the
active QUERY tab. We may format a single query only or the complete content of
a QUERY tab. Formatting will help us to understand the structure of a complex
query. If we have been working on a query (editing and copying) it will not
always be well-formed. That we can correct with a single click. This is also
useful if we want to save a query (as file or 'favorite') or if we want to use
the query in an application.
Figure 5: Connected
Database by SQLyog
8.
Testing System
In
our system we have login system, when Cashier login it will be log one by one.
8.1 Login
System
Display when the
application first runs, to update the database that begins by entering
longitude and value then the application
will make the process of downloading the data from the database server.
Figure 6: Login System.
8.2 Home Page
The first time after login, it will be loading this page and it will catch user Username that have been login the system. Also it will be show time, menus and total money all day then show on the menu.
The first time after login, it will be loading this page and it will catch user Username that have been login the system. Also it will be show time, menus and total money all day then show on the menu.
8.3 Selling Page
Cashier can sell products just typed ID or Barcode into the Text Box then click button scan it will be query from table stock to add and total automatically. Moreover, if Cashier typed Character It will be show the Message (You add Number). It can save after Cashier scanned products on button click save or prints invoice.
Cashier can sell products just typed ID or Barcode into the Text Box then click button scan it will be query from table stock to add and total automatically. Moreover, if Cashier typed Character It will be show the Message (You add Number). It can save after Cashier scanned products on button click save or prints invoice.
Figure 8: Selling Products System.
8.4 Printing Recipe
When cashier click button print, it will
be loading this page then converted to file .PDF and also it will count, select
and total products automatically for costumers then it will be print invoice
automatically.
Figure 9: Print
Invoice.
8.5 Searching Report
Cashier can click on Combo box and
selected on Day, Month and Year, then we can click on button search or print,
it will be search or print and total report automatically
Figure 10:
Searching Report
8.6 Selling Report
When Cashier click button print it will
be loading this page and selected from Database to make the report then convert
file to .PDF and total report by Daily
or Monthly and Yearly.
This page just type Id, Barcode
or products name, it will be searching automatically from stock then will be
show on the form.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.