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
- 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
- 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
- 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
- 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
- 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).
is a mini web server that runs on almost any windows operating system.(www.tech-faq.com).
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).
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).
is a powerful front-end framework for faster and easier web development. (tutorialrepublic.com).
is an open source relational database management system (RDBMS) based on SQL (www.searchoracle.techtarget.com).
is an important syntactic element in most major programming languages(www.techopedia.com).
is a free software tool written in Php, intended to handle the administration of MySQL over the web. (www.phpmyadmin.net).
SMS (Short Message Service), commonly referred to as a “text messaging”, is a service for sending short messages to mobile devices (searchmobilecomputing.techtarget.com).
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.