Simple Manufacture Settings Controller Documentation

File: /controllers/simpleManufactureSettingsController.php

Purpose: Manages manufacturing configuration, system settings, and production parameters

Last Updated: December 19, 2024

Total Functions: 4

Lines of Code: ~217

---

📋 Overview

The Simple Manufacture Settings Controller manages core manufacturing configuration and system settings. It handles:

• • Manufacturing system configuration
• • Production warehouse settings
• • Inventory reduction policies
• • Manufacturing equation settings
• • Order client configuration
• • Pricing alert thresholds
• • Task order naming conventions
• • Database column precision for manufacturing quantities
• • Menu property updates based on settings
• • Production system parameters

Primary Functions

• ✅ Configure default manufacturing warehouse
• ✅ Set inventory reduction policies
• ✅ Enable/disable manufacturing equations
• ✅ Configure order client settings
• ✅ Set price alert thresholds
• ✅ Customize task order terminology
• ✅ Adjust database precision for quantities
• ✅ Update system menu properties
• ✅ Manage production parameters

Related Controllers

• • productionExecutionController.php - Manufacturing execution
• • productionOrderController.php - Production orders
• • taskOrderController.php - Task order management
• • storeController.php - Warehouse management
• • productController.php - Product configuration
• • programsettingsController.php - General system settings
• • propertiesController.php - System properties management

---

🗄️ Database Tables

Primary Tables (Direct Operations)

🔧 Key Functions

1. Default Display - Show Settings Form

Line: 116

Purpose: Displays the manufacturing settings configuration form

Process Flow:

---

2. update() - Save Manufacturing Settings

Line: 131

Purpose: Updates manufacturing settings and applies database changes

Parameters:

• • $_POST['storeid'] - Default manufacturing warehouse
• • $_POST['reducestoreamount'] - Allow inventory reduction (0/1)
• • $_POST['manufacturing'] - Enable production equations (0/1)
• • $_POST['orderclient'] - Order client setting
• • $_POST['lowOutPriceAlert'] - Low price alert threshold
• • $_POST['taskOrderName'] - Task order terminology (1=Order, 0=Work Order)
• • $_POST['holePartNoOfDigits'] - Whole number digits for precision
• • $_POST['fractionPartNoOfDigits'] - Decimal digits for precision

Process Flow:

Code Example:

// Update task order terminology
if ($simplesetting->taskOrderName != $taskOrderName) {
    $myProperities = $myProperitiesRecord->load(309);
    switch ($taskOrderName) {
        case 1:
            $myProperities->propertyname = "طلبية";  // Order
            break;
        default:
            $myProperities->propertyname = "أمر شغل";  // Work Order
            break;
    }
    $myProperitiesRecord->update($myProperities);
    
    // Clear cached header
    $fh = fopen('../temp__cashedheader/cashedheader_' . $_SESSION['dbname'] . '_' . $_SESSION['userid'] . '.html', 'w');
    fclose($fh);
}

---

3. Database Precision Update

Line: 172-198

Purpose: Updates database column precision for manufacturing quantities

Process Flow:

SQL Examples:

-- Example with 8 whole digits, 2 fraction digits = DECIMAL(10,2)
ALTER TABLE `productionrateproduct` CHANGE `quantity` `quantity` DECIMAL(10,2) NOT NULL;
ALTER TABLE `storedetail` CHANGE `productquantity` `productquantity` DECIMAL(10,2) NOT NULL;
ALTER TABLE `productionexecution` CHANGE `num` `num` DECIMAL(10,2) NOT NULL;

---

4. Menu Property Management

Line: 143-156

Purpose: Updates system menu properties based on manufacturing settings

Process Flow:

---

🔄 Business Logic Flow

Manufacturing Configuration Workflow

Configuration Dependencies

---

⚠️ Common Issues

1. Database Precision Changes Fail

Symptoms: ALTER TABLE statements fail during precision update

Causes:

• • Existing data exceeds new precision limits
• • Database permissions insufficient
• • Concurrent transactions in progress

Solutions:

• • Validate existing data before precision changes
• • Ensure adequate database privileges
• • Perform changes during maintenance windows

2. Menu Cache Not Clearing

Symptoms: Menu terminology doesn't update after settings change

Causes:

• • Cache file permissions
• • Web server write access issues
• • Session-specific cache conflicts

Solutions:

• • Verify cache directory permissions
• • Clear all user cache files
• • Restart web server if needed

3. Settings Not Saving

Symptoms: Configuration changes don't persist

Causes:

• • Database connection issues
• • Missing required fields
• • Validation errors

Solutions:

• • Check database connectivity
• • Validate all required parameters
• • Add error logging for diagnostics

---

🔗 Dependencies

Required Files

• • ../public/impOpreation.php - Core operations
• • ../public/config.php - Database configuration
• • ../public/include_dao.php - Data access objects

Required DAOs

• • SimplemanufacturesettingDAO - Settings data access
• • PropertiesDAO - Menu properties management
• • StoreDAO - Warehouse information

File System Dependencies

• • Cache directory: ../temp__cashedheader/
• • Cache file pattern: cashedheader_{dbname}_{userid}.html
• • Write permissions required for cache management

Session Variables

• • $_SESSION['dbname'] - Database name for cache file naming
• • $_SESSION['userid'] - User ID for personalized cache

---

⚙️ Configuration Options

Manufacturing Settings

Precision Setting: 8,2 → DECIMAL(10,2)
- Maximum value: 99999999.99
- Storage: 5 bytes per value
- Calculation accuracy: 2 decimal places

Precision Setting: 10,4 → DECIMAL(14,4)  
- Maximum value: 9999999999.9999
- Storage: 7 bytes per value
- Calculation accuracy: 4 decimal places

---

🎛️ System Integration Points

Menu System Integration

• • Property ID 309: Task order menu text
• • Dynamic menu generation based on settings
• • Localized terminology support
• • User-specific cache management

Manufacturing System Integration

• • Default warehouse for production orders
• • Inventory policy enforcement
• • Production equation availability
• • Quantity precision standardization

Database Schema Management

• • Dynamic column specification updates
• • Cross-table precision consistency
• • Storage optimization based on business needs
• • Backwards compatibility maintenance

---

Manufacturing Concepts Covered: Manufacturing Configuration, System Settings Management, Database Precision Control, Menu Customization, Inventory Policy Configuration, Production Parameter Management, User Interface Customization, Schema Optimization