Skip to main content

admin

Glamour Beauty Salon - Admin Panel

Admin Panel

Dashboard

Welcome to Glamour Beauty Salon Admin Panel

0, 'team_members' => 0, 'services_count' => 0, 'today_revenue' => 0 ]; // Get today's date $today = date('Y-m-d'); try { // Query 1: Count today's appointments $query1 = "SELECT COUNT(*) as count FROM appointments WHERE appointment_date = ? AND status != 'cancelled'"; $stmt1 = mysqli_prepare($conn, $query1); mysqli_stmt_bind_param($stmt1, "s", $today); mysqli_stmt_execute($stmt1); $result1 = mysqli_stmt_get_result($stmt1); if ($row1 = mysqli_fetch_assoc($result1)) { $stats['today_appointments'] = $row1['count']; } mysqli_stmt_close($stmt1); // Query 2: Count active team members $query2 = "SELECT COUNT(*) as count FROM team_members WHERE is_active = 1"; $result2 = mysqli_query($conn, $query2); if ($result2 && $row2 = mysqli_fetch_assoc($result2)) { $stats['team_members'] = $row2['count']; } // Query 3: Count active services $query3 = "SELECT COUNT(*) as count FROM services WHERE is_active = 1"; $result3 = mysqli_query($conn, $query3); if ($result3 && $row3 = mysqli_fetch_assoc($result3)) { $stats['services_count'] = $row3['count']; } // Query 4: Calculate today's revenue $query4 = "SELECT COALESCE(SUM(s.price_from), 0) as revenue FROM appointments a JOIN services s ON a.service = s.name WHERE a.appointment_date = ? AND a.status != 'cancelled'"; $stmt4 = mysqli_prepare($conn, $query4); mysqli_stmt_bind_param($stmt4, "s", $today); mysqli_stmt_execute($stmt4); $result4 = mysqli_stmt_get_result($stmt4); if ($row4 = mysqli_fetch_assoc($result4)) { $stats['today_revenue'] = number_format($row4['revenue']); } mysqli_stmt_close($stmt4); } catch (Exception $e) { error_log("Dashboard stats error: " . $e->getMessage()); } ?>

Today's Appointments

Team Members

Services

$

Revenue (Today)

Recent Appointments
0) { while ($appointment = mysqli_fetch_assoc($appointments_result)) { // Format date and time $appointment_date = date('M j, Y', strtotime($appointment['appointment_date'])); $appointment_time = date('g:i A', strtotime($appointment['appointment_time'])); // Determine badge class based on status $badge_class = ''; switch ($appointment['status']) { case 'confirmed': $badge_class = 'badge-confirmed'; break; case 'cancelled': $badge_class = 'badge-cancelled'; break; default: $badge_class = 'badge-pending'; } ?>
Client Service Date & Time Status Actions
No appointments found
Quick Actions
Service Popularity
0) { while ($stat = mysqli_fetch_assoc($service_stats_result)) { $services[] = $stat['service']; $counts[] = $stat['count']; } } ?>

Appointments

All Appointments
0) { ?>
ID Client Name Email Phone Service Date & Time Status Actions
No appointments found.
'; } ?>

Services

0) { echo '
'; while ($service = mysqli_fetch_assoc($result)) { echo '
' . htmlspecialchars($service['name']) . '

' . htmlspecialchars($service['description']) . '

Starting from: $' . number_format($service['price_from'], 2) . '

'; } echo '
'; } else { echo '
No services found.
'; } ?>

Team Members

Sarah Johnson
Sarah Johnson

Head Stylist

Testimonials

Jennifer Lopez
Jennifer Lopez
Regular Client

"I've been coming to Glamour Beauty for over two years now, and I'm always impressed with the quality of service. Sarah always knows exactly what I want and delivers beyond my expectations!"

Comments

Post a Comment

Popular Posts

The Best Mini Smart Phone in 2025: A Pakistan-Focused Buyer's Guide

Image
The quest for the  best mini smart phone in 2025  is more relevant than ever. As mainstream phones become increasingly large and expensive, many users in Pakistan are seeking a powerful, pocket-friendly device that delivers essential features without the bulk. Whether you need a reliable primary communication tool or a minimalist secondary device, finding the right compact phone can be a challenge. This guide compares three top contenders—the DOOV R77C, the UNIWA A3502, and the SOYES XS18 Pro—to help you make an informed decision, specifically considering network compatibility in Pakistan and ranking them  on the basis of size  and performance. [Before we dive in, it's crucial to understand the core appeal of these devices. While offering unparalleled portability, their small displays (under 4 inches) are not ideal for prolonged video watching or gaming. They excel as efficient communication tools, minimalist daily drivers, or ultra-portable companions.]{.mark} 1. Th...
Read more

Samsung Galaxy S24 in 2025: The Definitive Review – Is It Still Worth Buying?

ChatGPT said: Creating a website can be broken down into a clear series of steps — from planning and design to deployment and maintenance. Below is a complete guide (for beginners or professionals), covering both technical and non-technical aspects. 🧭 1. Planning Your Website Before writing any code, define your goals. Steps: Decide purpose: Portfolio, blog, e-commerce, business site, etc. Define audience: Who will use it? What do they expect? Plan content: Pages (Home, About, Services, Contact, etc.). Sketch layout: Use tools like Figma, Canva, or even paper sketches. Choose domain name: Something short, relevant, and easy to remember. Example: yourname.com , yourbrand.io ⚙️ 2. Setting Up the Technical Environment You’ll need some tools and technologies. Choose your approach: Type Tools / Languages Notes No-code Wix, Squarespace, WordPress.com Fast, no coding needed Low-code Webflow, Framer, Bubble Good balance between control and ease Full-code...
Read more

gigousource

The Core Philosophy: Why Market Research is Non-Negotiable Avoid Guessing:  Offering a service without market research is just guessing, which usually leads to failure. Prevent Wasted Time:  Without research, you can waste weeks or months building a gig that was never going to work due to no demand. It's About Approach, Not You:  Failure to get orders is often due to a poor approach (no research), not a lack of skill or that freelancing "isn't for you." The Key to Scaling:  Proper market research is the difference between a flop and a business that scales to $10K+ per month. Your First Job:  Market research is the first and most critical job of a freelancer. If you get this wrong, no amount of gig optimization can save you. The Step-by-Step Market Research Process Step 1: Define Your Service & Analyze the Main Category Start with a Broad Search:  Type your general service (e.g., "website design") into Fiverr's search bar to see the total number of re...
Read more