php
session_start();
include("include/security.php");
require_login();
secure_session();
include("lang.php");
include("include/connected.php");
// الحصول على معرف البائع من الرابط
$seller_id = isset($_GET['id']) ? intval($_GET['id']) : 0;
if($seller_id == 0) {
echo '' . ($lang['خطأ_لم_يتم_تحديد_البائع'] ?? 'خطأ: لم يتم تحديد البائع') . '
';
include("file/footer.php");
exit;
}
// جلب بيانات البائع
$seller_query = "SELECT username, logo_profil FROM users WHERE id = ?";
$stmt = mysqli_prepare($conn, $seller_query);
mysqli_stmt_bind_param($stmt, "i", $seller_id);
mysqli_stmt_execute($stmt);
$result_seller = mysqli_stmt_get_result($stmt);
$seller = mysqli_fetch_assoc($result_seller);
if(!$seller) {
echo '' . ($lang['البائع_غير_موجود'] ?? 'البائع غير موجود') . '
';
include("file/footer.php");
exit;
}
// جلب متوسط تقييمات البائع
$rating_query = "SELECT AVG(rating_stars) as avg_rating, COUNT(*) as total_ratings FROM ratings WHERE seller_id = ?";
$stmt_rate = mysqli_prepare($conn, $rating_query);
mysqli_stmt_bind_param($stmt_rate, "i", $seller_id);
mysqli_stmt_execute($stmt_rate);
$result_rate = mysqli_stmt_get_result($stmt_rate);
$rating_data = mysqli_fetch_assoc($result_rate);
$avg_rating = round($rating_data['avg_rating'] ?? 0, 1);
$total_ratings = $rating_data['total_ratings'] ?? 0;
// جلب جميع تقييمات البائع
$reviews_query = "SELECT r.*, u.username AS buyer_name, u.logo_profil AS buyer_logo
FROM ratings r
JOIN users u ON r.buyer_id = u.id
WHERE r.seller_id = ?
ORDER BY r.created_at DESC";
$stmt_reviews = mysqli_prepare($conn, $reviews_query);
mysqli_stmt_bind_param($stmt_reviews, "i", $seller_id);
mysqli_stmt_execute($stmt_reviews);
$result_reviews = mysqli_stmt_get_result($stmt_reviews);
include("file/header.php");
?>
تقييمات البائع | MetaMarket
