Project Outline

This website is considered ERP system for a company to manage and control all its branches, expenses, invoices, sales processing with the ability to export files in 2 formats pdf and csv files

­This website consists of 2 branches (front and admin), front is used as a single branch login page to provide its details about sales, invoices, expenses and ability to print pdf files to include to your documents daily and the second branch is the admin panel for the company administration to control all company branches and search and export files as pdf and csv files.

This website consists of many modules like:

• Admin Dashboard (with the ability to login, edit profile information like name, email and ability to change the password).
• Admin Dashboard home page (that includes all overall statistics like count of branches, suppliers, expenses, users and display all recent sales from relative branches)
• Admin Branches module (in which the admin can add new branch or edit it with all required data like name, address, phone, code of the branch and the ability to edit all of these fields with AJAX technique).
• Codes Module (in which the admin can add codes for every detail or sales that belongs to specific branch and the ability to edit them with all validation techniques and this module using AJAX technique).
• Branch expenses module (in which the admin can add or edit specific branch expenses like rents, salaries, administration expenses, services and insurances and the ability to edit them with all fields and validation rules required with AJAX technique).
• Users module (in which the admin can add users and assign them to specific branch with all the fields required like name, email, phone and admin can add provide specific password that can be later converted to hashed one for security purposes and the ability to edit these fields with AJAX technique).
• Suppliers module (in which admin can add supplier with all its fields required such as name, email, phone, address, code, tax code and purchases code with all validation techniques with the ability to update these data with AJAX technique).
• Expenses types module (in which admin can add expense type with all fields required such as name, code and tax code with the ability to update these data with AJAX technique).
• Reports module (this is the most important and professional module as this module gives admin the ability to search in all types like sales, expenses and invoices of specific branch or for all branches and know latest transactions and records and the ability to export them as csv file with specific formatting based on owner demands, before exporting these data as excel file you could display all wanted records with AJAX and simply export data later as csv files with specific formatting).
• General reporting module (in which the admin can search in all transactions of specific branch or in all branches and the system is automatically display all required date with AJAX with scripts of controlling all dates required then the admin have the ability to export these data as pdf).
• Monthly reporting module (in which the admin can search in all transactions of specific branch or in all branches and the system is automatically display all required date with AJAX with scripts of controlling all dates required then the admin have the ability to export these data as pdf).
• Categories module (in which admin can add categories of files needed with all fields required such as name and code with the ability to update or delete these data with AJAX technique).
• Dual documents module (in which admin can add dual documents related to specific category needed with all fields required such as name , credit and code with the ability to update or delete these data with AJAX technique).
• Triple documents module (in which admin can add triple documents related to specific category needed with all fields required such as name , credit and code with the ability to update or delete these data with AJAX technique).
• Documents reports module (this is the most amazing part of this project, it seem to be as a cashier panel in which the admin can select the wanted category and the system automatically will display all dual and triple documents included with this category, then the admin can select any wanted document and start adding values for these documents in order to export them in excel file with the ability to edit these numbers belongs to documents or delete them, all these requests done by AJAX technique).
• Front logging system (this logging system belongs to the branch and the logging function can be done by using mobile or email).
• Front dashboard page (in which the branch user can display all total transaction statistics done for that branch and have the ability to add daily sales with a lot of scripts to calculate other fields automatically based on owner demands, these processes depends on AJAX technique, and a the same page the user can add expenses daily records with tax or not and provide all required fields such as amount, date, expenses type and invoice number, and at the same page the user can add invoices with all required fields such as amount, supplier, date and invoice number, all these functionalities done with AJAX technique).
• Daily sales module (in which user can list and display all sales transactions done in the branch and the ability to update these records which based also on many scripts to calculate fields automatically when providing them) .
• Daily expenses module (in which user can list and display all expenses transactions done in the branch and the ability to update these records which based also on many scripts to calculate fields automatically when providing them) .
• Daily invoices module (in which user can list and display all invoices done in the branch and the ability to update these records which based also on many scripts to calculate fields automatically when providing them) .
• Front reports module (in which user can search in any types and dates to get all transactions and display them with AJAX technique with the ability to export them in pdf file).
• Front monthly reporting module (in which the user can search in all transactions of the and the system is automatically display all required date with AJAX with scripts of controlling all dates required then the admin have the ability to export these data as pdf).

Used technologies for this website

This website depends on many technologies like :

• Laravel Framework v.8
• PHP
• MySQL
• JavaScript
• Ajax
• JQuery
• Bootstrap 5
• Css 4
• Html 5
• Git
• GitHub

What is special or new about this website?

There are many new things done for this project like:

• Front logging with mobile / phone.
• When deleting branch or supplier the system detects its relations automatically and decide to delete or keep it (to not affect the exported files).
• All excel reports is very special (as it was very complicated to understand and depends on many relationships).
• All pdf files are very special (as it depends on many relationships).
• All scripts for calculating fields were very special (as they were very complicated to understand and execute).
• Document report module in admin panel is very special (this is the most amazing art of this project).