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