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_id = $info['company_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;
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$rating = (int)($_POST['rating'] ?? 0);
$comment = $_POST['comment'] ?? '';
if ($rating < 1 || $rating > 5) {
$error = __('provide_valid_rating');
} else {
$stmt = db()->prepare("INSERT INTO ratings (branch_id, company_id, rating_type, rating_value, comment) VALUES (?, ?, 'service', ?, ?)");
if ($stmt->execute([$branch_id, $company_id, $rating, $comment])) {
$success = true;
} else {
$error = __('error_saving_rating');
}
}
}
?>
<?= __('service_rating') ?>