Jewelry Sales Accounting and Appraisal System User Interface in PHP and MySQL

Jewelry Sales Accounting and Appraisal System User Interface in PHP and MySQL

Objective of the Study

The main purpose of the study is to design and develop an information database system that will manage the transactions in the pawnshops specifically on the accounting and appraisal of jewelry.

System Module and User Interface

1. Jewelry Sales Accounting and Appraisal System Jewelry Item Module

Module Description: this module displays the jewelries available. The user can encode/edit the details of the jewelry.

Table Fields and Entities: id, itemname, amount, description, qty, categoryid

2. Jewelry Sales Accounting and Appraisal System Jewelry Category Module

Module Description: This module allows the user to add/edit categories of jewelry. It also displays the categories saved in the system.

Table Fields and Entities: id, categoryname

3. Jewelry Sales Accounting and Appraisal System Sales Module

Module Description: This module allows the user to add/edit sales when customer buys an item. It helps the user to monitor the products and the sales. Details includes the name of the customer, item/jewelry, quantity, subtotal and total, transaction date, status, and processed by.

Table Fields and Entities: id, customerid, itemid, qty, subtotal, transactiondate, status, userid

4. Jewelry Sales Accounting and Appraisal System Customers Module

Module Description: This module allows the user to manage the customers. The user can add/edit customer information such as username and password, complete name, contact no., address, billing address, email, city, province, and zipcode.

Table Fields and Entities: id, username, password, completename, contact, address, billingaddress, email, city, province, zipcode

5. Jewelry Sales Accounting and Appraisal System User Module

Module Description: This module allows the admin to add/edit users and assign user type. This module also displays the list of user in tabular form.

Table Fields and Entities: id, username, password, completename, contact, address, usertype

Software Requirements for Development

Windows 10 Operating System

Windows 10 is the latest release of Microsoft’s windows operating system and the successor to underwhelming Windows 8 (www.webopedia.com).

Wamp Server

is a mini web server that runs on almost any windows operating system.(www.tech-faq.com).

Internet Connection

sometimes called simply “the Net”, is a worldwide system of computer networks – a network of networks in which users and anyone computer can, if they have permission, get information from any other computer (searchwindevelopment.techtarget.com).

PHP (Hypertext Pre-processor)

is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML (www.php.net).

HTML5

Hypertext Markup Language revision 5 (HTMl5) is markup language for the structure and presentation of World Wide Web contents. (www.techopedia.com).

CSS (Cascading Style Sheet)

are used to format the layout of Web pages. (www.techterms.com).

Bootstrap

is a powerful front-end framework for faster and easier web development. (tutorialrepublic.com).

MySQL

is an open source relational database management system (RDBMS) based on SQL (www.searchoracle.techtarget.com).

Brackets

is an important syntactic element in most major programming languages(www.techopedia.com).

PhpMyAdmin

is a free software tool written in Php, intended to handle the administration of MySQL over the web. (www.phpmyadmin.net).

SMS Notification

SMS (Short Message Service), commonly referred to as a “text messaging”, is a service for sending short messages to mobile devices (searchmobilecomputing.techtarget.com).

Google Chrome

is an open source for accessing the World Wide Web and running Web-based application. (searchmobilecomputing.techtarget.com).

You may visit our facebook page for more information, inquiries and comments.

Hire our team to do the project.

Download