CRUD - Sales System

Project    |    Features    |    Technologies    |    How to Use    |    Database Relationship View    |    Project vision

💻 Project

This project was built to support the study of how to develop web applications using HTML, CSS and PHP. The main concepts applied are CRUD, responsive web design, relational database and access control.

🔨 Features

1. Register Product

2. Register Sales

3. Stock Control

Salesmen can get an overview of the stock and administrators are also able to delete products.

4. Sales Control

Administrators have access to charts showing current month and year sales. They are also able to view the most sold products of the current month and year.
Salesmen have access to the same charts but they can only view their own sales data.

🚀 Technologies

• HTML5
• CSS
• Bootstrap
• PHP
• SQL
• Ajax
• Javascript

❓ How to use

In order to use this application, you will need a local web server having interpreters for PHP scripts and database connection such as XAMPP. After downloading this repository, the tables structure can be found in the folder database_crud_sales_system so that they are imported to the database.

Database Relationship View

• 'Usuarios': Users informations. This table stores id, name, email, password and role (Administrator or Salesman) of users.
• 'Vendas': Sales informations. The foreign keys are product id, that represents the id of the product that was sold, and salesman id, that represents the user who sold the product. The other informations stored by this table are id, sale date, sold amount, product name and value.
• 'Produtos': Products informations. The foreign key is salesman id, that represents the user who registered the product. The other informations stored by this table are product id, product name, registration date, supplier, cost, sales value, quantity in stock.

👁️ Project Vision

Signup Page

Login as Administrator

Login as Salesman

Made by Romulo Pinheiro and Yasmim Barros