A comprehensive inventory and production management system built with PHP using a Model-View-Controller (MVC) architecture. The system provides robust features for managing inventory, production, purchase orders, and low stock alerts with automated email notifications. The front-end is styled with Bootstrap 5 and uses jQuery and DataTables for dynamic table interactions.

• Secure User Authentication: Username-based login and logout functionality with password hashing and session management
• User Management (CRUD): Add, view, edit, and delete users with role-based permissions
• Dashboard Overview: Home page with quick access to all system modules

• Complete CRUD Operations: Create, read, update, and delete inventory items
• Detailed Item Tracking: Track item name, barcode, quantity, unit, price, purchase date, maximum quantity, and category
• Real-time Inventory Updates: Automatic inventory adjustments based on production and purchase orders
• Data Visualization: Dynamic tables with sorting, searching, and pagination using DataTables

• Physical Count Tracking: Dedicated system for inventory physical counting operations
• Variance Analysis: Automatic calculation of differences between system count and physical count
• Percentage Variance: Calculate variance percentages for accuracy assessment
• Value Impact Analysis: Calculate financial impact of inventory discrepancies
• Pending Entries Management: Track and manage pending physical count entries before applying to inventory
• Batch Processing: Save multiple physical count entries to inventory in batches

• Comprehensive Barcode Support: Full barcode scanning functionality across all modules
• Barcode Physical Count: Use barcode scanners for physical inventory counting
• Barcode Production Management: Scan barcodes for production operations
• Barcode Menu Actions: Barcode integration with menu item operations
• Production Updates via Barcode: Update sold quantities and wastage using barcode scanning
• Multi-Entity Barcode Support: Barcodes for inventory items, menu items, and production batches
• Flashlight Toggle: Built-in flashlight button for improved barcode scanning in low-light conditions
• Barcode Selection Interface: Choose between inventory, production, or menu actions after scanning a barcode

• Menu-Based Production Tracking: Manage production based on menu items with ingredient requirements
• Advanced Batch Processing: Track quantity produced, available, sold, and wastage with detailed analytics
• Automatic Ingredient Deduction: FIFO-based ingredient deduction from inventory when production is recorded
• Cost and Profit Analysis: Calculate unit costs, total costs, sales revenue, waste costs, and profit margins
• Sales and Wastage Tracking: FIFO-based updates for sold quantities and wastage across production batches
• Production Capacity Planning: Real-time calculation of maximum production based on available ingredients
• Barcode Integration: Full barcode support for production tracking and updates

• Multi-Item Purchase Orders: Create purchase orders with multiple inventory items
• Order Status Tracking: Track purchase orders with statuses (Pending, Received, Cancelled)
• Delivery Date Management: Record expected delivery dates for purchase orders
• Automatic Inventory Updates: Automatically update inventory when purchase orders are marked as received
• Price and Quantity Tracking: Maintain records of unit prices and quantities for purchasing history

• Intelligent Detection: Automatic identification of low stock items (below 20% of maximum quantity)
• Rich Email Notifications: Professional HTML email alerts to administrators with modern responsive design
• Smart Alert Management: Prevents duplicate alerts with transaction-level locking
• Auto-Resolution System: Automatically resolves alerts when inventory levels are restored
• Alert History Tracking: Complete history of all low stock alerts with detailed resolution status
• Manual Alert Processing: On-demand checking and sending of low stock alerts
• SMTP Integration: Email notifications via SMTP with support for major email providers

• Menu Item Creation: Define menu items with names, barcodes, and pricing
• Advanced Ingredient Mapping: Associate inventory items as ingredients with precise required quantities
• Recipe Cost Analysis: Automatic calculation of menu item costs based on ingredient prices
• Recipe Management: Maintain detailed ingredient recipes for consistent production planning
• Barcode Support: Full barcode integration for menu items

• Database Backup & Restore: Export database to SQL files and import from backups
• Email Configuration: SMTP integration with support for Gmail, Outlook, Yahoo, and custom SMTP servers
• Email Testing Tools: Built-in email testing and configuration debugging
• Responsive UI: Mobile-friendly interface built with Bootstrap 5
• MVC Architecture: Clean separation of business logic, data, and presentation layers

• XAMPP latest
• MySQL / Workbench

1. Clone the repository:

   • Download this repository
   • Extract the contents to htdocs directory in your XAMPP installation

2. Create the Database:

   • Create a new database in MySQL named luna
   • Import the provided SQL backup file (luna_backup_2025-09-17_19-33-56.sql) to create tables and initial data
   • Or create the database schema manually if no backup file is available

3. Configure Database Connection:

   • Copy .env sample to .env (remove the space in the filename)
   • The default configuration should work with standard XAMPP setup:

     DB_HOST=localhost
     DB_NAME=luna
     DB_USERNAME=root
     DB_PASSWORD=rootroot
     DB_PORT=3306
     

   • Update the database credentials if your MySQL setup differs from the defaults

4. Configure Email Settings (Optional):

   • Update email configuration in .env for low stock alert notifications via SMTP:

     # SMTP Configuration
     SMTP_HOST=smtp.gmail.com
     SMTP_PORT=587
     [email protected]
     SMTP_PASSWORD=your-app-password
     SMTP_SECURITY=tls
     [email protected]
     FROM_NAME=LUNA Inventory System
     

   • Supported Email Providers:
     • Gmail: Use app passwords for authentication
     • Outlook/Hotmail: Use regular credentials with TLS
     • Yahoo Mail: Use app passwords for authentication
     • Custom SMTP: Configure your own SMTP server
   • Email configuration is optional - the system will work without it, but low stock alerts won't be sent

5. Run the Application:

   • Start Apache and MySQL services in XAMPP Control Panel
   • Open your web browser and navigate to http://localhost/your-folder-name
   • You should see the login page
   • Use the default login credentials below to access the system

6. Post-Installation Setup:

   • After first login, consider changing the default admin password
   • Configure email settings if you want to receive low stock alerts
   • Test email functionality using the built-in email testing tools (Users → Test Email)

• Username: admin
• Password: admin

The system supports six user types with finely-grained role-based access control:

Full System Access

• Dashboard: View all charts including Daily Cost vs Profit
• User Management: Create, edit, delete, and manage all user accounts
• Inventory Management: Full CRUD operations including item deletion
• Production Management: Full control including production addition, sales/wastage updates, export, and deletion
• Menu Management: Create, edit, and delete menu items
• Purchase Orders: Complete management of purchase orders and Actions column visible
• Physical Count: Full access to inventory counting operations
• Low Stock Alerts: View alerts, configure email settings, and test SMTP
• Backup & Restore: Database backup and restore operations
• Barcode System: Full access to all barcode operations
• Email Testing: Send test emails and debug SMTP configuration

Strategic Oversight Access

• Dashboard: View all charts including Daily Cost vs Profit
• Menu Management: Create, edit, and delete menu items with full recipe management
• Production Management: View production records and tracking
• Barcode System: Full access to barcode operations
• No Access: User management, inventory operations, purchase orders, physical count, low stock alerts, backup/restore, email testing

Operational Management Access

• Dashboard: View all charts including Daily Cost vs Profit
• Inventory Management: View, add, edit, and delete inventory items
• Production Management: View and manage production batches, add new production, update sales/wastage, export reports
• Menu Management: View menu items (cannot edit or delete)
• Purchase Orders: Full management of purchase orders and Actions column visible
• Physical Count: Full access to inventory counting operations
• Low Stock Alerts: View low stock alerts
• Barcode System: Full access to barcode operations
• No Access: User management, backup/restore, email testing

Inventory-Focused Access

• Inventory Management: Full CRUD operations on inventory items
• Purchase Orders: Full management and Actions column visible
• Physical Count: Full access to inventory counting operations
• Low Stock Alerts: View alerts
• Barcode System: Full access to barcode operations except scanning
• No Access: Dashboard, user management, production management, menu management, backup/restore, email testing

Sales Processing Access

• Production Management: Add new production, update sold quantities and wastage
• Menu Management: View menu items only
• Barcode System: Full access to barcode operations
• No Access: Dashboard, inventory operations, purchase orders, physical count, user management, low stock alerts, backup/restore, email testing

Production Operations Access

• Production Management: Add new production batches
• Menu Management: View menu items only
• Barcode System: Full access to barcode operations
• No Access: Dashboard, inventory operations, purchase orders, physical count, user management, production updates, low stock alerts, backup/restore, email testing

• Provides an overview of the system
• Quick navigation to all modules

• View all inventory items in a searchable table with barcode support
• Add new inventory items with category and barcode fields
• Edit existing inventory details
• Delete inventory items (Admin only)
• Real-time low stock indicators

• Barcode-enabled physical inventory counting
• Variance analysis with percentage calculations
• Value impact assessment for discrepancies
• Pending entries management before inventory updates
• Batch processing of physical count results

• Menu-based production tracking with barcode integration
• Advanced batch processing with cost and profit analysis
• FIFO-based ingredient deduction and sales tracking
• Production capacity planning based on available ingredients
• Real-time updates for sold quantities and wastage
• Production deletion (Admin only)

• Create and manage purchase orders
• Track order status (Pending, Received, Cancelled)
• Record expected delivery dates
• Multi-item purchase orders with automatic inventory updates

• Intelligent alert detection with duplicate prevention
• Professional HTML email notifications via SMTP
• Auto-resolution system when stock is replenished
• Alert history tracking with detailed status information
• Manual alert processing and email testing tools (Admin only)

• Comprehensive menu item management with barcode support
• Advanced ingredient mapping with cost analysis
• Recipe management for consistent production planning
• Automatic cost calculation based on ingredient prices
• Menu editing and deletion (Admin only)

• Universal barcode scanning across all modules
• Barcode-enabled physical counting operations
• Production management via barcode scanning
• Menu item operations with barcode integration
• Support for inventory, menu, and production item barcodes

• Username-based authentication system
• Add, edit, and delete users with role-based permissions
• Secure password hashing and session management
• Email testing and SMTP configuration debugging (Admin only)

• Download database backups
• Upload and restore from backup files
• Complete data protection solution