prepare($sql); $stmt->execute($params); $branches = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $_SESSION['error'] = "Error fetching branches: " . h($e->getMessage()); $branches = []; } // ---- Count totals for filter labels ---- try { // All branches count for current owner $stmt = $pdo->prepare("SELECT COUNT(*) FROM branches WHERE owner_id = ?"); $stmt->execute([$owner_id]); $count_all = $stmt->fetchColumn(); // Own branches count (non-third-party) $stmt = $pdo->prepare("SELECT COUNT(*) FROM branches WHERE owner_id = ? AND third_party = 0"); $stmt->execute([$owner_id]); $count_own = $stmt->fetchColumn(); // Third-party branches count $stmt = $pdo->prepare("SELECT COUNT(*) FROM branches WHERE owner_id = ? AND third_party = 1"); $stmt->execute([$owner_id]); $count_third_party = $stmt->fetchColumn(); $counts = [ 'all' => $count_all, 'own' => $count_own, 'third_party' => $count_third_party, ]; } catch (PDOException $e) { $counts = ['all' => 0, 'own' => 0, 'third_party' => 0]; } // ---- Check if user can create branches ---- $can_create_branch = in_array($role, ['super_admin', 'admin']); // ---- DataTable init script ---- $script = ' '; ?>
My Branches
My Branches ()
Create New Branch
$branch): $is_my_branch = ($branch['owner_id'] ?? 0) == $owner_id; $can_edit = $is_my_branch && in_array($role, ['super_admin', 'admin']); $can_delete = $is_my_branch && in_array($role, ['super_admin', 'admin']); ?>
Branch Name Address City State Country Image Type Created Actions
<?= h($branch['branch_name']); ?> 3rd Party Own
No branches found
$branch): $is_my_branch = ($branch['owner_id'] ?? 0) == $owner_id; $can_edit = $is_my_branch && in_array($role, ['super_admin', 'admin']); $can_delete = $is_my_branch && in_array($role, ['super_admin', 'admin']); ?>
3rd Party Own

Address:

City:

State:

Country:

Created:

<?= h($branch['branch_name']); ?>

No Image

View Edit