Okay, let's set up the foundational structure and core functionality for the EviTone Supermarket Inventory System using PHP and MySQL.

This initial setup will include:

1. Basic project structure.
2. Database connection setup.
3. User authentication (Login/Logout).
4. Product listing and adding functionality.
5. Basic templating.

Note: This is a starting point. A fully featured system as described in the documentation requires significant further development.

Next Steps & Setup:

1. Create Project Directory: Create a folder named evitone. Inside it, create the public, src, templates, config directories as used in the file paths above. Place the files accordingly.
2. Database Setup:
   • Make sure you have a MySQL server running.
   • Create a database named evitone_db (or choose another name).
   • Update the database credentials (DB_HOST, DB_NAME, DB_USER, DB_PASS) in evitone/config/database.php.
   • Import the evitone/setup.sql file into your MySQL database. This will create the necessary tables.
3. Composer:
   • Navigate to the evitone directory in your terminal.
   • Run composer install. This will generate the vendor directory and the autoloader based on composer.json.
4. Web Server Setup:
   • Configure your web server (like Apache or Nginx) to point the document root to the evitone/public directory. This is crucial for security, preventing direct web access to files outside public.
   • Ensure mod_rewrite is enabled if using Apache and the .htaccess file for cleaner URLs (optional but recommended).
5. Create Initial User:
   • The setup.sql includes a placeholder comment for adding users. You should create an initial admin user securely. You could temporarily add a script to do this using password_hash() or manually insert into the database after hashing a password. For example, run this PHP code once (e.g., in a temporary script or via phpMyAdmin's SQL tab after connecting):

     <?php
     // --- Temporary script to create admin user ---
     require_once 'config/database.php'; // Adjust path if needed
     require_once 'src/Database.php';   // Adjust path if needed
     require_once 'src/Models/User.php';// Adjust path if needed
     
     use EviTone\src\Models\User;
     
     $username = 'admin';
     $password = 'adminpassword'; // Choose a strong password!
     $role = 'Admin';
     
     $userId = User::create($username, $password, $role);
     
     if ($userId) {
         echo "Admin user '{$username}' created successfully with ID: {$userId}\n";
     } else {
         echo "Failed to create admin user. Does '{$username}' already exist?\n";
     }
     // --- Delete this script after running ---
     ?>
     

     <?php
     // --- Temporary script to create admin user ---
     require_once 'config/database.php'; // Adjust path if needed
     require_once 'src/Database.php';   // Adjust path if needed
     require_once 'src/Models/User.php';// Adjust path if needed
     
     use EviTone\src\Models\User;
     
     $username = 'admin';
     $password = 'adminpassword'; // Choose a strong password!
     $role = 'Admin';
     
     $userId = User::create($username, $password, $role);
     
     if ($userId) {
         echo "Admin user '{$username}' created successfully with ID: {$userId}\n";
     } else {
         echo "Failed to create admin user. Does '{$username}' already exist?\n";
     }
     // --- Delete this script after running ---
     ?>
     
6. Access: Open your web browser and navigate to the URL configured for your project (e.g., http://localhost/ or http://evitone.test/). You should be redirected to the login page. Use the credentials you created (e.g., admin / adminpassword).

This provides the basic framework. You can now incrementally add features like Supplier Management, Sales Recording, Reporting, Stock Alerts, etc., following a similar pattern (Model, View/Template, Controller/Public Script).*