Product Settings Controller Documentation

File: /controllers/productsettingController.php

Purpose: Manages store-specific product inventory thresholds and minimum value settings

Last Updated: December 20, 2024

Total Functions: 3+

Lines of Code: ~137

---

📋 Overview

Simple controller for managing store-specific product settings, particularly minimum inventory values. Features:

• • Store-specific minimum value settings
• • Simple CRUD operations
• • Store selection interface
• • YouTube tutorial integration

Primary Functions

• ✅ Edit store product settings
• ✅ Store selection interface
• ✅ Minimum value configuration
• ✅ Tutorial integration

---

🗄️ Database Tables

Primary Tables

🔑 Key Functions

1. update() - Save Settings

Location: Line 118

Purpose: Insert or update store product settings

function update() {
    $productsettingid = (int)$_POST['productsettingid'];
    $storeid = $_POST['storeid'];
    $leastValueAtStore = $_POST['leastValueAtStore'];
    
    if ($productsettingid == 0) {
        // Insert new record
        $productSetting->leastValueAtStore = $leastValueAtStore;
        $productSetting->storeid = $storeid;
        $productSettingDAO->insert($productSetting);
    } else {
        // Update existing record
        $productSetting->leastValueAtStore = $leastValueAtStore;
        $productSetting->storeid = $storeid; 
        $productSetting->productsettingid = $productsettingid;
        $productSettingDAO->update($productSetting);
    }
}

2. getStores() - Load Store Data

Location: Line 111

Purpose: Load active stores for dropdown selection

function getStores() {
    $storeData = $storeDAO->queryByConditions(0);
    return $storeData;
}

---

🔄 Workflows

Workflow: Settings Management

---

🌐 URL Routes & Actions

Update Settings (do=update):

• • productsettingid - Setting ID (0 for new)
• • storeid - Store ID
• • leastValueAtStore - Minimum value threshold

---

🧮 Calculation Methods

Insert vs Update Logic

if ($productsettingid == 0) {
    // New record - INSERT
} else {
    // Existing record - UPDATE
}

---

🔒 Security & Permissions

Authentication

include_once("../public/authentication.php");

Input Validation

$productsettingid = (int)$_POST['productsettingid'];  // Integer casting

---

Documented By: AI Assistant

Review Status: ✅ Complete - Simple, well-structured controller

Next Review: When major changes occur