CONCLUSION

Conclusion

General Manager is the one who handles, controls, or directs, especially the one who directs a business or other enterprise or the one who controls resources and expenditures, as of a household. With LPBD Mini Market Management System, General Manager works for his responsibility such as Employee, Shift, Position, Payment, User, Profile, Reports, and Setting by using General Manager System. General Manger can control almost data of Employees who works for LPBD by using Shift for controlling the schedule of working time and Position to manage the difference task of the employees. In addition, General Manager also allow the LPBD’s employees to manager his or her page on logo, banner, and title of his or her page through Setting (contain Role and Shop Config). One more thing is that General Manager can see all report in LPBD, Cashier, Purchase, Inventory, and Inventory. It is such a good thing that General Manger can see all data in LPBD easily because he or she just look on Report by selecting on any products, or any date in Cashier, Purchase, Inventory, and Inventory Pages. Hence, with this system, General Manager can manager for his responsibility well and safely.

Suggestion

LPBD Mini Market Management System is good enough for mange all data in Mini Market. In the future, the author hope that LPBD Mini Market Management System will be more better for all security, attractiveness, fasting speed, more-function given and easiness, for General Manager.

Application Implementation

Application Implementation

In the section above, the author has described about process of system and requirements that used to build it. In this section, you can see how the process work through in the system.

1) First, when the Manager of LPBD goes to the LPBD website The Manager will see the login page of LPBD. The Manger has to enter his user name and password login to see the General Manger Page.

2) After, the Manger has log in, he or she will see the home page of General Manager

3) In home, there many pages such as Employee, Shift, Position, Payment, User, Profile, Report (Cashier, Purchase, Inventory, and Accounting), Setting (Role, Shop Config)

4) The Manager can add, edit, view (one by one, list), delete, and print Employee, Shift, Position, Payment, User, Report and Setting (Role, Shop Config) Pages. The Report Pages can be view and print only.

System Testing

To make the General Manager in LPBD Mini Market Management System Website done, the author had worked through from step to step. The previous sections and chapters are the evidences that make the author complete this system. However, to make the system well-done, the system must be tested carefully.

1. Home Page

Home Page is the page that displayed after logged in by the Manger who managed the system.

2. Employee Page

Employee Page is the page which used to store information about all staffs who work for LPBD. To fully manage all data for the staffs, this page has its function like add, update, delete, view, and print.

3. Shift Page

Shift Page is the page which used to stored schedule for each LPBD’s staffs. The functions for this page are add, update, delete, view, and print.

4. Position Page

Position Page is the page which used to tell the staffs’ roles in LPBD. The staffs’ roles like Manger, Cashier, and Accountant. This page can be add, update, delete, view, and print.

5. Payment Page

Payment Page is the page for paying salary to the staffs. It has functions such as add, update, delete, view, and print.

6. User Page

User Page is the page which used to store user logged. This page can be update, delete, and view.

7. Profile Page

Profile Page is the page for personal information of each employees. Every employer can view or edit his or her information through this page.

8. Report Page

Report Page is the page which used store all data of Cashier, Purchase, Inventory, and Inventory. All the data can be viewed and print as a hardware.

9. Setting Page

In this page, there are two points Role and Shop Config. Role is means that the Manager defines role to the employees who work for LPBD. In addition, Shop Config means that the employee can edit like logo, banner, and title of his or her own page.

testing with video clip 

Data Dictionary

Data Dictionary

• Table employee to store employee information

• Table payroll to store payment information

• Table position to store position information

• Table shift to store shift information

• Table user to store user information for log in system

• Table shop config to store market information

Relation ship

Entity Relationship Diagram

• employee

• payroll 

 

• position 

• shift 

• shift type

• user 

• role

Relationship

System Development Life Cycle (SDLC)

System Development Life Cycle (SDLC)

According to e-book SYSTEMS ANALYSIS and DESIGN EIGHTHE DITION KENNETH E. KENDALL Rutgers University School of Business–Camden Camden, New Jersey JULIE E. KENDALL Rutgers University School of Business–Camden Camden, New Jersey chapter I page 8: The SDLC is a phased approach to analysis and de- sign that holds that systems are best developed through the use of a specific cycle of analyst and user activities. Analysts disagree on exactly how many phases there are in the SDLC, but they generally laud its organized approach. Here we have divided the cycle into seven phases, as shown in Figure 2.6. Although each phase is presented discretely, it is never accomplished as a 16 separate step. Instead, several activities can occur simultaneously, and activities may be repeated.

Figure 2.6 System development life cycle(SDLC)

Identifying Problems, Opportunities, and Objectives

In this first phase of the systems development life cycle, the analyst is concerned with correctly identifying problems, opportunities, and objectives. This stage is critical to the success of the rest of the project, because no one wants to waste subsequent time addressing the wrong problem. The first phase requires that the analyst look honestly at what is occurring in a business. Then, together with other organizational members, the analyst pinpoints problems.

Determining Human Information Requirements

The next phase the analyst enters is that of determining the human needs of the users involved, using a variety of tools to understand how users interact in the work context with their current information systems. The analyst will use interactive methods such as interviewing, sampling and investigating hard data, and questionnaires, along with unobtrusive methods, such as observing decision makers’ behavior and their office environments, and all-encompassing methods, such as prototyping.

Analyzing System Needs

The next phase that the systems analyst undertakes involves analyzing system needs. Again, special tools and techniques help the analyst make requirement determinations. Tools such as data flow diagrams (DFD) to chart the input, processes, and output of the business’s functions, or activity diagrams or sequence diagrams to show the sequence of events, illustrate systems in a structured, graphical form. From data flow, sequence, or other diagrams, a data dictionary is developed that lists all the data items used in the system, as well as their specifications.

Designing the Recommended System

In the design phase of the SDLC, the systems analyst uses the information collected earlier to accomplish the logical design of the information system. The analyst designs procedures for users to help them accurately enter data so that data going into the information system are correct.

Developing and Documenting Software

In the fifth phase of the SDLC, the analyst works with programmers to develop any original software that is needed. During this phase the analyst works with users to develop effective documentation for software, including procedure manuals, online help, and Web sites featuring Frequently Asked Questions (FAQs), on Read Me files shipped with new software. What happens during the rest of the software's life: changes, correction, additions, move to a different computing platform and more. This is often the longest of the stages.

Testing and Maintaining the System

Before the information system can be used, it must be tested. It is much less costly to catch problems before the system is signed over to users. Some of the testing is completed by programmers alone, some of it by systems analysts in conjunction with programmers. A series of tests to pinpoint problems is run first with sample data and eventually with actual data from the current system. Often test plans are created early in the SDLC and are refined as the project progresses.

Implementing and Evaluating the System

In this last phase of systems development, the analyst helps implement the information system. This phase involves training users to handle the system. Vendors do some training, but oversight of training is the responsibility of the systems analyst. In addition, the analyst needs to plan for a smooth con- version from the old system to the new one. This process includes converting files from old formats to new ones, or building a database, installing equipment, and bringing the new system into production.

Final Process of Cashier Management

Name      : Chhorn Bros

NIM        : 49012076

TMD      : Technology Media Digital 

                                                 

                                                                  Cashier Management

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

        2. Adobe Dreamweaver CS4,

        3. JavaScript

        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

  5. Web Hosting of ITB, Domain name (minimartms.lskk.ee.itb.ac.id)

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.

                                

                                                                                          Figure 7: Home Page Cashier.

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.
                        

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.

                                         

Figure 11: Report for Daily or Monthly

8.7 Searching Product

This page just type Id, Barcode or products name, it will be searching automatically from stock then will be show on the form.
                                                    

Figure 12: Searching products page

9. Video

This video that talking about my hold project (Cashier Management).