Inventory Control System for Building Construction

This inventory control system developed using PHP and MySQL for a building construction company. Our customer "Acme Constructions" is a medium scale home construction company that undertakes project from all over the country. The basically build houses and small scale commercial buildings. They have 15 - 25 projects (sites) running all the time and managing these sites manually becomes a difficult task.

So they ask us to develop a system to manage mainly their raw material consumption and keep a track of stock movements. Before start construction of a building, they create a BOQ (Bill of Quantities) that accurately measures the amount of materials for each part of the building and as a whole. Issuing of material need to match with the BOQ values. There can be excess issues or less issues. The management want to see excess issues and get a report for each site and as a whole.

There are other reports management want to get such as stock issues, low stocks, boq and purchasing, etc. Our client want this system to run online and their customers to log in to the system and see the progress of construction. Therefore the system should be able to upload daily photos of sites. There should be a separate login to customers to view their site's progress online.

This system is having following operations and features:

• System users with restricted access - we need to create a user login system with privileges for users to perform each task in the system. So, only the given tasks can be execute in the system.
• Inventory control system
• Categorized inventory of products - raw materials need to categorized in to sections such as Paint, Electrical, Steel and Other Raw Materials.
• Stock control system - We need to develop a stock control system with stocks intakes (add stocks to the system / GRN), stock issues, return of stocks, editing of stocks and creating purchase orders.
• Supplier management also need to include in the system.
• Customer management system - We need to record customer details and create a login for customers to the system to view site progress.
• Reports - We need to create different reports according to the management requirements.

Following video explains the operations of the final system.


This project is entirely based on virtual details (clients and dummy data presented in the system) and not represent any real organization or party. This is never tested in a real organization. This system is entirely created for educational purposes only. You are free to use this project and source code for your education and do improvements to the codes. You can share your codes here with other students by sending them to me for publish here. Please take cautions if you submit this project as your own IT project for college or university. Since this is publicly open and available you will be caught by plagiarism checks. Therefore if you submit this as your own project you will need to significantly change your codes and do improvements.