Nexus Intranet – Multi-Module Inventory Management Application

A server-rendered intranet application built with procedural PHP, MySQL/PDO, and Bootstrap 5.3.2. Manages products, materials, orders, and Bills of Materials (BOMs).

Requirements

• PHP 7.4+
• MySQL 5.7+
• Apache (e.g. XAMPP)

Setup

1. Create a MySQL database and import the schema:

   source sql/init.sql

2. Configure database credentials in includes/db.php or via environment variables:
   • DB_HOST (default: localhost)
   • DB_NAME (default: aegisnet)
   • DB_USER (default: root)
   • DB_PASS (default: empty)
3. Place the files in your web server's document root.
4. Open login.php in your browser.

Modules

Products

• Full CRUD interface for finished goods with typed specification columns
• CSV export and import
• Accessible via products.php

Materials

• Manage raw materials with stock levels, supplier info, and warehouse locations
• CSV export and import (minimum 9 fields required)
• Accessible via materials.php

Orders

• Customer order tracking with status columns: versendet, verpackt, in_produktion, offen
• Row color coding: green = fully shipped, brown = fully packed
• CSV export and import
• Accessible via orders.php

Bill of Materials (BOM)

• Versioned BOMs linking products to materials with quantities
• Accessible via the Products module

Authentication

• Session-based login with role support (user, admin)
• All mutating endpoints are protected by CSRF token validation
• To create the first admin user, insert directly via SQL:

  INSERT INTO users (username, password_hash, role)
  VALUES ('admin', '<bcrypt_hash>', 'admin');

Security

• All database queries use PDO prepared statements
• Passwords hashed with password_hash / password_verify
• Output escaped with htmlspecialchars() throughout