Restaurant Category Controller Documentation

File: /controllers/cateResturantController.php

Purpose: Manages restaurant category configuration and product assignments for restaurant operations

Last Updated: December 20, 2024

Total Functions: 3

Lines of Code: ~315

---

📋 Overview

The Restaurant Category Controller is a specialized module for configuring restaurant product categories and their assignments. It handles:

• • Restaurant category configuration display
• • Product assignment to restaurant categories
• • Category and product data management
• • Restaurant-specific product catalog setup
• • YouTube tutorial link integration
• • Category hierarchy management for restaurant operations

Primary Functions

• ✅ Display restaurant category configuration interface
• ✅ Assign products to restaurant categories (up to 3 categories)
• ✅ Load and display product lists for assignment
• ✅ Category hierarchy management
• ✅ Product catalog integration
• ✅ YouTube tutorial integration
• ✅ Success/error handling for category updates

Related Controllers

• • productCatController.php - Product category management
• • productController.php - Product management
• • restauranthall.php - Restaurant hall management
• • restauranttable.php - Restaurant table management

---

🗄️ Database Tables

Primary Tables (Direct Operations)

🔑 Key Functions

1. show() / Default Action - Restaurant Category Configuration Display

Location: Line 188

Purpose: Display the restaurant category configuration interface with products and categories

Process Flow:

1. Include authentication check

2. Set default date parameters

3. Load category hierarchy via getCategoryChilds()

4. Load all products for assignment

5. Load YouTube tutorial links

6. Display via cateResturantview/show.html template

Template Variables:

• • $catDataReport - Category hierarchy data
• • $products - Available products for assignment
• • $youtubes - Tutorial video links

---

2. add() - Restaurant Category Assignment

Location: Line 276

Purpose: Process restaurant category assignments for up to 3 categories

Function Signature:

function add()

Process Flow:

1. Get current date

2. Process three category/product pairs:

- productCatId1 / productSearchId1

- productCatId2 / productSearchId2

- productCatId3 / productSearchId3

3. For each pair:

- Create new Resturantcategory object

- Set category and product IDs

- Set current date

- Set fixed ID (1, 2, or 3)

- Update via DAO

Assignment Logic:

$resturantCategory = new Resturantcategory();
$resturantCategory->categoryId = $productCatId1;
$resturantCategory->productId = $productSearchId1;
$resturantCategory->date = $startDate;
$resturantCategory->id = 1;
$ResturantCategoryDAO->update($resturantCategory);

---

3. getAllSubCat() - Category Hierarchy Navigation

Location: Line 237

Purpose: Recursively traverse product category hierarchy

Function Signature:

function getAllSubCat($catid, $mode)

Parameters:

• • $catid - Parent category ID
• • $mode - Operation mode:

- 1 - Get all sub-categories

- 2 - Get last level categories only

Process Flow:

1. Query child categories for given parent

2. For each child:

- If mode 1: Add to category ID list and recurse

- If mode 2: Check if leaf node, add to last level list

3. Continue recursively until all levels processed

Global Variables Used:

• • $catsIDS - Comma-separated category ID list
• • $lastLevelCatIDS - Array of leaf category IDs

---

🔄 Workflows

Workflow 1: Restaurant Category Configuration

---

🌐 URL Routes & Actions

Category Configuration Display (do=show):

• • No parameters required
• • Loads all available categories and products

Process Assignments (do=add):

• • productCatId1 - Category ID for first assignment
• • productId1 - Product ID for first assignment
• • productCatId2 - Category ID for second assignment
• • productId2 - Product ID for second assignment
• • productCatId3 - Category ID for third assignment
• • productId3 - Product ID for third assignment

---

🧮 Calculation Methods

Category Assignment Logic

// Process three fixed assignments
for ($i = 1; $i <= 3; $i++) {
    $resturantCategory = new Resturantcategory();
    $resturantCategory->categoryId = $_POST["productCatId{$i}"];
    $resturantCategory->productId = $_REQUEST["productId{$i}"];
    $resturantCategory->date = date('Y-m-d');
    $resturantCategory->id = $i;
    $ResturantCategoryDAO->update($resturantCategory);
}

Category Hierarchy Traversal

function getAllSubCat($catid, $mode) {
    $result = $productCatExt->queryByParentExt($catid);
    if (count($result) > 0) {
        foreach ($result as $data) {
            if ($mode == 1) {
                $catsIDS .= "," . $data->productCatId;
                getAllSubCat($data->productCatId, $mode);
            } elseif ($mode == 2) {
                $childData = $productCatExt->queryByParentExt($data->productCatId);
                if (count($childData) == 0) {
                    array_push($lastLevelCatIDS, $data->productCatId);
                } else {
                    getAllSubCat($data->productCatId, $mode);
                }
            }
        }
    }
}

---

🔒 Security & Permissions

Authentication Requirements

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

Input Sanitization

• • All $_POST and $_REQUEST parameters processed through framework
• • Numeric IDs used for database operations
• • Date validation using PHP date functions

Data Validation

• • Category and product existence verified through DAO queries
• • Fixed assignment IDs (1, 2, 3) prevent ID manipulation
• • Update operations use existing record structure

---

📊 Performance Considerations

Database Optimization Tips

1. Indexes Required:

- resturantcategory(categoryId, productId)

- productcat(parentExt) for hierarchy queries

- product(productCatId) for category filtering

2. Query Optimization:

- Category hierarchy loaded once per page

- Product list cached in template

- Limited to 3 assignments reduces update overhead

3. Memory Management:

- Minimal data processing

- Simple object creation and updates

- No complex calculations or loops

---

🐛 Common Issues & Troubleshooting

1. Category Assignment Failures

Issue: Category assignments not saving properly

Cause: Missing product or category IDs in POST data

Debug:

var_dump($_POST['productCatId1'], $_REQUEST['productId1']);

2. Category Hierarchy Loading Issues

Issue: Categories not displaying in interface

Cause: Recursive function stack overflow or missing parent references

Fix:

// Add depth limit to recursive function
function getAllSubCat($catid, $mode, $depth = 0) {
    if ($depth > 10) return; // Prevent infinite recursion
    // ... existing code
    getAllSubCat($data->productCatId, $mode, $depth + 1);
}

3. Product Loading Performance

Issue: Slow page load when many products exist

Cause: Loading all products without pagination

Solution:

• • Implement product search/filtering
• • Add AJAX-based product selection
• • Use pagination for large product lists

---

🧪 Testing Scenarios

Test Case 1: Basic Category Assignment

1. Access category configuration page
2. Select 3 different categories
3. Assign 3 different products
4. Submit assignments
5. Verify database updates
6. Check success page display

Test Case 2: Category Hierarchy Navigation

1. Load page with multi-level categories
2. Verify hierarchy displays correctly
3. Test category selection from different levels
4. Confirm parent-child relationships maintained

Test Case 3: Error Handling

1. Submit form with missing data
2. Verify error handling
3. Test with invalid category/product IDs
4. Confirm graceful error messages

---

📚 Related Documentation

• • CLAUDE.md - PHP 8.2 migration guide
• • productCatController.md - Product category management
• • productController.md - Product operations
• • Restaurant Module Documentation - Complete restaurant system

---

Documented By: AI Assistant

Review Status: ✅ Complete

Next Review: When restaurant module changes occur