Settings

Configure Tanks

query("tanks", "SELECT t.*, c.name as client_name FROM tanks t LEFT JOIN clients c ON t.client_id = c.record_id ORDER BY t.name ASC"); while ($tank = $tanks_res->fetch_assoc()) { ?>
Tank Name Actions

System Users

query("users", "SELECT * FROM users ORDER BY username ASC"); while ($user = $users_res->fetch_assoc()) { // Logic to determine display type $is_client = ($user['client_id'] > 0); $type_label = $is_client ? "Client User" : "System User"; $type_class = $is_client ? "badge-secondary" : "badge-primary"; if ($user['status'] == 'ACTIVE') { $status = 'ACTIVE'; } else { $status = 'INACTIVE'; } ?>
Username Email Type Status Actions
ADMIN

Notification Setups

query("notification_setup", "SELECT * FROM notification_setup ORDER BY record_id DESC"); while ($row = $notif_res->fetch_assoc()) { $type_label = ($row['notification_type'] == '1') ? 'Low Level' : 'Offline'; $condition = ($row['notification_type'] == '1') ? $row['min_threshold'] . "%" : $row['offline_for'] . " mins"; if ($row['status'] == 'ACTIVE') { $status = 'ACTIVE'; } else { $status = 'INACTIVE'; } ?>
Type Tanks Users Notified Condition Status Actions
getNamesFromIds('tanks', "{$row['tank_ids']}"); ?> getNamesFromIds('users', "{$row['user_ids']}"); ?>

Automated Emails

query("automated_emails", "SELECT * FROM automated_emails ORDER BY record_id DESC"); while ($automated = $automated_res->fetch_assoc()) { if ($automated['status'] == 'ACTIVE') { $status = 'ACTIVE'; } else { $status = 'INACTIVE'; } ?>
Name Users Notified Tanks Involved Send Every On Status Actions
getNamesFromIds('users', $automated['user_ids']); ?> getNamesFromIds('tanks', $automated['tank_ids']); ?>