Posted on August 3, 2025 | Category: Maintenance Tools | Tags: PHP, MySQL, Preventive Maintenance
🔍 Overview
The Preventive Maintenance Logging Tool is a web-based application built using PHP, MySQL, AJAX, and Bootstrap, designed for engineers and maintenance departments to track scheduled maintenance and part replacements. It ensures reliability, accountability, and traceability for preventive tasks.
🔧 Key Features
- ✅ Machine-wise maintenance log entry
- ✅ Date, time-in, time-out, and description fields
- ✅ Multi-part replacement with quantity and auto-cost calculation
- ✅ Auto-deduction from part stock
- ✅ Responsive UI with Bootstrap
- ✅ Export logs to Excel
- ✅ AJAX-based submission (no page reload)
- ✅ Optional approval system for admin-level review
📸 Screenshot Preview
💻 Tech Stack Used
| Component | Technology |
|---|---|
| Frontend | HTML5, CSS3, Bootstrap 5, jQuery |
| Backend | PHP (Core, No Framework) |
| Database | MySQL |
| Communication | AJAX |
🧠 How It Works
- Select a machine, enter date and PM description.
- Select one or more parts with quantity.
- On submission:
- Logs data to
pm_logstable - Saves part changes to
pm_part_changestable - Calculates total part cost
- Optionally deducts stock from parts
- Logs data to
📁 Project Structure
pm_logging_tool/
├── index.php
├── pm_form.php
├── ajax/
│ └── save_pm.php
├── db.php
├── css/
│ └── style.css
├── js/
│ └── pm_form.js
├── sql/
│ └── pm_tool_tables.sql
⬇️ Download Project
👉 Download Full Project (ZIP)
🔐 Includes SQL file, PHP source code, and example data
📈 Future Improvements
- PM scheduling calendar view
- Email or WhatsApp reminders for due PM
- MTTR/MTBF reporting
- User roles: Technician, Supervisor, Admin
- Image uploads for parts/machine condition
💬 Want to Customize This Tool?
Feel free to contact me or leave a comment if you’d like to:
- Add new features
- Link it with your ERP/SAP system
- Deploy it on local or cloud hosting
🛠️ Built with ❤️ by Dipesh Jamsudkar
🔗 Visit more projects at DynamicDev.xyz