prepare("SELECT b.id AS branch_id, b.name_en AS branch_name_en, b.name_ar AS branch_name_ar, c.id AS company_id, c.name_en AS comp_name_en, c.name_ar AS comp_name_ar, c.logo FROM branches b JOIN companies c ON b.company_id = c.id WHERE b.id = ?");
$stmt->execute([$branch_id_get]);
$info = $stmt->fetch(PDO::FETCH_ASSOC);
}
if (empty($info)) {
$stmt = db()->query("SELECT b.id AS branch_id, b.name_en AS branch_name_en, b.name_ar AS branch_name_ar, c.id AS company_id, c.name_en AS comp_name_en, c.name_ar AS comp_name_ar, c.logo FROM branches b JOIN companies c ON b.company_id = c.id LIMIT 1");
$info = $stmt->fetch(PDO::FETCH_ASSOC);
}
$branch_id = $info['branch_id'] ?? null;
$company_name = $_SESSION['lang'] === 'ar' ? ($info['comp_name_ar'] ?? '') : ($info['comp_name_en'] ?? '');
$branch_name = $_SESSION['lang'] === 'ar' ? ($info['branch_name_ar'] ?? '') : ($info['branch_name_en'] ?? '');
$logo = $info['logo'] ?? null;
$branch_query = $branch_id ? '?branch_id=' . $branch_id : '';
?>
<?= __('rate_us') ?>