connect_error) {
die("Database connection failed. Please contact support.
");
}
$artist_id = $_SESSION['user_id'];
// 1. Fetch Artist's First Name
$artistFirstName = "Artist"; // Default value
$stmt_name = $conn->prepare("SELECT first_name FROM artist_profiles WHERE user_id = ?");
if ($stmt_name === false) { die("SQL Prepare Error (artist_name): " . htmlspecialchars($conn->error)); }
$stmt_name->bind_param("i", $artist_id);
if ($stmt_name->execute()) {
$result_name = $stmt_name->get_result();
if ($row_name = $result_name->fetch_assoc()) {
$artistFirstName = !empty($row_name['first_name']) ? $row_name['first_name'] : "Artist";
}
} else {
die("SQL Execute Error (artist_name): " . htmlspecialchars($stmt_name->error));
}
$stmt_name->close();
// 2. Fetch Total Paintings
$totalPaintings = 0;
$stmt_paintings = $conn->prepare("SELECT COUNT(id) as painting_count FROM paintings WHERE artist_id = ?");
if ($stmt_paintings === false) { die("SQL Prepare Error (paintings_count): " . htmlspecialchars($conn->error)); }
$stmt_paintings->bind_param("i", $artist_id);
if ($stmt_paintings->execute()) {
$result_paintings = $stmt_paintings->get_result();
if ($row_paintings = $result_paintings->fetch_assoc()) {
$totalPaintings = $row_paintings['painting_count'];
}
} else {
die("SQL Execute Error (paintings_count): " . htmlspecialchars($stmt_paintings->error));
}
$stmt_paintings->close();
// 3. Fetch Total Sales
$totalSales = 0;
$stmt_sales = $conn->prepare("
SELECT SUM(oi.price_at_purchase) as total_revenue
FROM order_items oi
JOIN paintings p ON oi.painting_id = p.id
JOIN orders o ON oi.order_id = o.id
WHERE p.artist_id = ? AND o.payment_status = 'completed'
");
if ($stmt_sales === false) { die("SQL Prepare Error (total_sales): " . htmlspecialchars($conn->error)); }
$stmt_sales->bind_param("i", $artist_id);
if ($stmt_sales->execute()) {
$result_sales = $stmt_sales->get_result();
if ($row_sales = $result_sales->fetch_assoc()) {
$totalSales = $row_sales['total_revenue'] ?? 0;
}
} else {
die("SQL Execute Error (total_sales): " . htmlspecialchars($stmt_sales->error));
}
$stmt_sales->close();
// 4. Calculate Profile Completion
$profileCompletion = 0;
$stmt_profile = $conn->prepare("SELECT first_name, last_name, phone, address, profile_image_path, bank_name, bank_account_iban FROM artist_profiles WHERE user_id = ?");
if ($stmt_profile === false) { die("SQL Prepare Error (profile_completion): " . htmlspecialchars($conn->error)); }
$stmt_profile->bind_param("i", $artist_id);
if ($stmt_profile->execute()) {
$result_profile = $stmt_profile->get_result();
if ($profile_data = $result_profile->fetch_assoc()) {
$total_fields = 7;
$filled_fields = 0;
if (!empty($profile_data['first_name'])) $filled_fields++;
if (!empty($profile_data['last_name'])) $filled_fields++;
if (!empty($profile_data['phone'])) $filled_fields++;
if (!empty($profile_data['address'])) $filled_fields++;
if (isset($profile_data['profile_image_path']) && $profile_data['profile_image_path'] !== 'default_avatar.png') $filled_fields++;
if (!empty($profile_data['bank_name'])) $filled_fields++;
if (!empty($profile_data['bank_account_iban'])) $filled_fields++;
if ($total_fields > 0) {
$profileCompletion = round(($filled_fields / $total_fields) * 100);
}
}
} else {
die("SQL Execute Error (profile_completion): " . htmlspecialchars($stmt_profile->error));
}
$stmt_profile->close();
// 5. Fetch Subscription Expiry Date
$subscriptionExpires = "N/A";
$stmt_sub = $conn->prepare("SELECT end_date FROM artist_subscriptions WHERE user_id = ? ORDER BY end_date DESC LIMIT 1");
if ($stmt_sub === false) { die("SQL Prepare Error (subscription): " . htmlspecialchars($conn->error)); }
$stmt_sub->bind_param("i", $artist_id);
if ($stmt_sub->execute()) {
$result_sub = $stmt_sub->get_result();
if ($row_sub = $result_sub->fetch_assoc()) {
$subscriptionExpires = date("M d, Y", strtotime($row_sub['end_date']));
}
} else {
die("SQL Execute Error (subscription): " . htmlspecialchars($stmt_sub->error));
}
$stmt_sub->close();
?>
Dashboard
Welcome back, !
Recent Activity
-
New Sale: "Sunset Over the Lake" was sold for ₹2,500.
2 hours ago
-
You uploaded a new painting: "City at Night".
1 day ago
-
Your painting "Mountain Majesty" received a new favorite.
3 days ago