Back"); } $message = ""; $isSystemLocked = isSystemLocked(); // Fetch current announcement settings $announcement = getSystemAnnouncement(); // --- HANDLE ACTIONS --- if ($_SERVER['REQUEST_METHOD'] === 'POST') { // ACTION: TOGGLE SYSTEM LOCKDOWN if (isset($_POST['action']) && $_POST['action'] === 'toggle_maintenance') { $newStatus = $_POST['maintenance_status']; db_query("UPDATE ipgmm_system_settings SET setting_value = ? WHERE setting_key = 'maintenance_mode'", 's', [$newStatus]); $isSystemLocked = ($newStatus === '1'); $message = "System status updated."; } // ACTION: SAVE ANNOUNCEMENT if (isset($_POST['action']) && $_POST['action'] === 'save_announcement') { $msg = trim($_POST['ann_msg']); $type = $_POST['ann_type']; $active = isset($_POST['ann_active']) ? '1' : '0'; // Update all 3 keys using separate queries db_query("INSERT INTO ipgmm_system_settings (setting_key, setting_value) VALUES ('announcement_msg', ?) ON DUPLICATE KEY UPDATE setting_value = ?", 'ss', [$msg, $msg]); db_query("INSERT INTO ipgmm_system_settings (setting_key, setting_value) VALUES ('announcement_type', ?) ON DUPLICATE KEY UPDATE setting_value = ?", 'ss', [$type, $type]); db_query("INSERT INTO ipgmm_system_settings (setting_key, setting_value) VALUES ('announcement_active', ?) ON DUPLICATE KEY UPDATE setting_value = ?", 'ss', [$active, $active]); $message = "Announcement updated."; $announcement = getSystemAnnouncement(); // Refresh } // ACTION: SAVE DEPARTMENT if (isset($_POST['action']) && $_POST['action'] === 'save_dept') { $deptName = trim($_POST['dept_name']); $deptDesc = trim($_POST['dept_desc']); if (empty($deptName)) { $message = "Error: Department Name cannot be empty."; } else { $checkResult = db_query("SELECT department_name FROM ipgmm_departments WHERE department_name = ?", 's', [$deptName]); if ($checkResult && $checkResult->num_rows > 0) { db_query("UPDATE ipgmm_departments SET description = ? WHERE department_name = ?", 'ss', [$deptDesc, $deptName]); $message = "Department '$deptName' updated."; } else { db_query("INSERT INTO ipgmm_departments (department_name, description) VALUES (?, ?)", 'ss', [$deptName, $deptDesc]); $message = "New Department '$deptName' created."; } } } // ACTION: DELETE DEPARTMENT if (isset($_POST['action']) && $_POST['action'] === 'delete_dept') { $deptName = $_POST['dept_name']; try { db_query("DELETE FROM ipgmm_departments WHERE department_name = ?", 's', [$deptName]); $message = "Department '$deptName' deleted successfully."; } catch (Exception $e) { $message = "Error: Cannot delete department. It is likely linked to existing Users or Parts."; } } } // --- FETCH DATA --- $departments = []; $deptResult = db_query("SELECT department_name, description FROM ipgmm_departments ORDER BY department_name ASC"); if ($deptResult) { while ($row = $deptResult->fetch_assoc()) $departments[] = $row; } ?> System & Dept Master - IPG-SCM

⚙️ System & Department Master

🚨 System Maintenance Mode

Status:

📢 System Announcement

Create or Update Department

Department Name	Description	Action