:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/tdrbazaar.com/crm/**
:: Editing File: dashboard.php
<?php include "header.php"; ?> <!-- ======================== Start Page Content ========================= --> <div class="page-wrapper"> <!-- Start Content --> <div class="content pb-0"> <!-- Page Header --> <div class="d-flex align-items-center justify-content-between gap-2 mb-4 flex-wrap"> <div> <h4 class="mb-0">Dashboard</h4> </div> <!-- <div class="gap-2 d-flex align-items-center flex-wrap"> <div class="avatar-list-stacked me-2"> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-09.svg" alt="img"> </a> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-10.svg" alt="img"> </a> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-01.svg" alt="img"> </a> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-02.svg" alt="img"> </a> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-11.svg" alt="img"> </a> <a class="avatar bg-primary border text-white fs-24 avatar-rounded" href="#"> + </a> </div> <div class="daterangepick form-control w-auto d-flex align-items-center me-2"> <i class="ti ti-calendar text-dark me-2"></i> <span class="reportrange-picker-field text-dark">23 May 2025 - 30 May 2025</span> </div> <a href="javascript:void(0);" class="btn btn-icon btn-outline-light shadow" data-bs-toggle="tooltip" data-bs-placement="top" aria-label="Download" data-bs-original-title="Download"><i class="ti ti-download"></i></a> <a href="javascript:void(0);" class="btn btn-icon btn-outline-light shadow" data-bs-toggle="tooltip" data-bs-placement="top" aria-label="Refresh" data-bs-original-title="Refresh"><i class="ti ti-refresh"></i></a> <a href="javascript:void(0);" class="btn btn-icon btn-outline-light shadow" data-bs-toggle="tooltip" data-bs-placement="top" aria-label="Collapse" data-bs-original-title="Collapse" id="collapse-header"><i class="ti ti-transition-top"></i></a> </div> --> </div> <!-- End Page Header --> <!-- start row --> <?php // 1. Fetch metric values dynamically from your leads and stages infrastructure // Total Leads Count $tot_q = mysqli_query($conn, "SELECT COUNT(*) AS total FROM leads"); $tot_r = mysqli_fetch_assoc($tot_q); $total_leads_count = intval($tot_r['total'] ?? 0); // Follow Ups Leads Count: Stage status IS NOT EQUAL to 'New Enquiry' and IS NOT EQUAL to 'Converted' / 'Lost' $follow_q = mysqli_query($conn, "SELECT COUNT(*) AS total FROM leads l LEFT JOIN lead_stages s ON l.stage_id = s.id WHERE s.name != 'New Enquiry'"); $follow_r = mysqli_fetch_assoc($follow_q); $follow_ups_count = intval($follow_r['total'] ?? 0); // Converted Leads Count: Stage status EQUAL to 'Converted' $conv_q = mysqli_query($conn, "SELECT COUNT(*) AS total FROM leads l LEFT JOIN lead_stages s ON l.stage_id = s.id WHERE s.name = 'Converted'"); $conv_r = mysqli_fetch_assoc($conv_q); $converted_count = intval($conv_q ? ($conv_r['total'] ?? 0) : 0); // Calculate Conversion Percentage safely to avoid division by zero errors $conversion_percentage = 0; if ($total_leads_count > 0) { $conversion_percentage = round(($converted_count / $total_leads_count) * 100, 1); } ?> <!-- start row --> <div class="row"> <div class="col-xl-3 col-sm-6 d-flex"> <div class="card flex-fill"> <div class="card-body position-relative"> <a href="lead_list.php" class=""><p class="fw-medium mb-1">Total Leads</p></a> <a href="lead_list.php" class=""><h4 class="mb-3"><?php echo $total_leads_count; ?></h4></a> <div class="d-flex align-items-center gap-2 flex-wrap"> <a href="lead_list.php"><span class="d-inline-flex align-items-center badge rounded-pill badge-soft-success border-0">+2.5%</span></a> <a href="lead_list.php" class=""><p class="text-dark mb-0">From Last Week</p></a> </div> <div class="custom-card-icon"> <div class="avatar avatar-rounded avatar-lg bg-primary-gradient-100 position-absolute top-0 end-0"> <a href="lead_list.php" class=""><img src="assets/img/icons/revenue-icon.svg" alt="icon" class="img-fluid w-auto h-auto"></a> </div> </div> </div> </div> </div> <!-- end col --> <div class="col-xl-3 col-sm-6 d-flex"> <div class="card flex-fill"> <div class="card-body position-relative"> <a href="lead_list.php" class=""><p class="fw-medium mb-1">Follow Ups Leads</p></a> <a href="lead_list.php" class=""><h4 class="mb-3"><?php echo $follow_ups_count; ?></h4></a> <div class="d-flex align-items-center gap-2 flex-wrap"> <a href="lead_list.php" class=""><span class="d-inline-flex align-items-center badge rounded-pill badge-soft-success border-0">+21.15%</span></a> <a href="lead_list.php" class=""><p class="text-dark mb-0">From Last Week</p></a> </div> <div class="custom-card-icon"> <div class="avatar avatar-rounded avatar-lg bg-info-gradient-100 position-absolute top-0 end-0"> <a href="lead_list.php" class=""><img src="assets/img/icons/deal-icon.svg" alt="icon" class="img-fluid w-auto h-auto"></a> </div> </div> </div> </div> </div> <!-- end col -- <div class="col-xl-3 col-sm-6 d-flex"> <div class="card flex-fill"> <div class="card-body position-relative"> <p class="fw-medium mb-1">Converted</p> <h4 class="mb-3">3</h4> <div class="d-flex align-items-center gap-2 flex-wrap"> <span class="d-inline-flex align-items-center badge rounded-pill badge-soft-success border-0">+15.5%</span> <p class="text-dark mb-0">From Last Week</p> </div> <div class="custom-card-icon"> <div class="avatar avatar-rounded avatar-lg bg-pink-gradient-100 position-absolute top-0 end-0"> <img src="assets/img/icons/conversion-icon.svg" alt="icon" class="img-fluid w-auto h-auto"> </div> </div> </div> </div> </div> <!-- end col --> <div class="col-xl-3 col-sm-6 d-flex"> <div class="card flex-fill"> <div class="card-body position-relative"> <a href="lead_list.php" class=""><p class="fw-medium mb-1">Converted</p></a> <a href="lead_list.php" class=""><h4 class="mb-3"><?php echo $converted_count; ?></h4></a> <div class="d-flex align-items-center gap-2 flex-wrap"> <a href="lead_list.php" class=""><span class="d-inline-flex align-items-center badge rounded-pill badge-soft-success border-0">+15.5%</span></a> <a href="lead_list.php" class=""><p class="text-dark mb-0">From Last Week</p></a> </div> <div class="custom-card-icon"> <div class="avatar avatar-rounded avatar-lg bg-pink-gradient-100 position-absolute top-0 end-0"> <a href="lead_list.php" class=""><img src="assets/img/icons/conversion-icon.svg" alt="icon" class="img-fluid w-auto h-auto"></a> </div> </div> </div> </div> </div> <!-- end col --> <div class="col-xl-3 col-sm-6 d-flex"> <div class="card flex-fill"> <div class="card-body position-relative"> <div class="d-flex align-items-center justify-content-between gap-2 flex-wrap mb-3"> <div> <div class="d-flex align-items-center gap-1"> <a href="lead_list.php" class=""><h4 class="mb-0"><?php echo $conversion_percentage; ?></h4></a> <!--<span class="d-inline-flex align-items-center badge rounded-pill badge-soft-success border-0">+2.5%</span>--> </div> <a href="lead_list.php" class=""><p class="fw-medium mb-1">Conversion Percentage</p></a> </div> <div id="contact-chart"></div> </div> <div class="d-flex alig-items-center gap-2"> <div class="avatar-list-stacked avatar-group-sm d-flex align-items-center gap-2 flex-wrap"> <a href="lead_list.php" class=""><span class="d-inline-flex align-items-center badge rounded-pill badge-soft-success border-0">+2.5%</span></a> <a href="lead_list.php" class=""><p class="text-dark mb-0">From Last Week</p></a> </div> </div> </div> <!-- end card --> </div> <!-- end col --> </div> <!-- end row --> <!-- start row -- <div class="row"> <div class="col-xxl-4 col-xl-12 d-flex"> <div class="card flex-fill"> <div class="card-body"> <div class="d-flex align-items-center justify-content-between flex-wrap gap-2 mb-3"> <h5 class="mb-0 fs-16 fw-bold d-inline-flex items-center"><span class="line-title d-block me-2"></span>Top Deals</h5> <div class="dropdown"> <a class="dropdown-toggle btn btn-outline-light shadow" data-bs-toggle="dropdown" href="javascript:void(0);"> Last 30 Days </a> <div class="dropdown-menu dropdown-menu-end"> <a href="javascript:void(0);" class="dropdown-item"> Last 30 Days </a> <a href="javascript:void(0);" class="dropdown-item"> Last 6 months </a> <a href="javascript:void(0);" class="dropdown-item"> Last 12 months </a> </div> </div> </div> <div class="d-flex align-items-sm-center justify-content-between gap-2 flex-sm-row flex-column mb-3"> <div class="d-flex align-items-center"> <a href="company-details.html" class="avatar avatar-md border rounded-circle flex-shrink-0"> <img src="assets/img/icons/company-icon-01.svg" class="img-fluid w-auto h-auto" alt="img"> </a> <div class="ms-2 flex-fill"> <p class="fw-medium text-truncate mb-1 fs-14"><a href="company-details.html">NovaWave LLC</a></p> <p class="fs-13 mb-0">Germany</p> </div> </div> <div class="text-sm-end mb-0"> <p class="fw-semibold mb-0 text-dark">$19,94,938</p> </div> </div> <div class="d-flex align-items-sm-center justify-content-between gap-2 flex-sm-row flex-column mb-3"> <div class="d-flex align-items-center"> <a href="company-details.html" class="avatar avatar-md border rounded-circle flex-shrink-0"> <img src="assets/img/icons/company-icon-03.svg" class="img-fluid w-auto h-auto" alt="img"> </a> <div class="ms-2 flex-fill"> <h6 class="fw-medium text-truncate mb-1 fs-14"><a href="company-details.html">Silver Hawk</a></h6> <p class="fs-13 mb-0">Australia</p> </div> </div> <div class="text-sm-end mb-0"> <p class="fw-semibold mb-0 text-dark">$15,44,540</p> </div> </div> <!-- Item-4 -- <div class="d-flex align-items-sm-center justify-content-between gap-2 flex-sm-row flex-column mb-3"> <div class="d-flex align-items-center"> <a href="company-details.html" class="avatar avatar-md border rounded-circle flex-shrink-0"> <img src="assets/img/icons/company-icon-04.svg" class="img-fluid w-auto h-auto" alt="img"> </a> <div class="ms-2 flex-fill"> <h6 class="fw-medium text-truncate mb-1 fs-14"><a href="company-details.html">Summit LLC</a></h6> <p class="fs-13 mb-0">Italy</p> </div> </div> <div class="text-sm-end mb-0"> <p class="fw-semibold mb-0 text-dark">$10,36,390</p> </div> </div> <!-- Item-2 -- <div class="d-flex align-items-sm-center justify-content-between gap-2 flex-sm-row flex-column mb-3"> <div class="d-flex align-items-center"> <a href="company-details.html" class="avatar avatar-md border rounded-circle flex-shrink-0"> <img src="assets/img/icons/company-icon-02.svg" class="img-fluid w-auto h-auto" alt="img"> </a> <div class="ms-2 flex-fill"> <h6 class="fw-medium text-truncate mb-1 fs-14"><a href="company-details.html">Bluesky Industries</a></h6> <p class="fs-13 mb-0">Canada</p> </div> </div> <div class="text-sm-end mb-0"> <p class="fw-semibold mb-0 text-dark">$10,15,280</p> </div> </div> <!-- Item-5 -- <div class="d-flex align-items-sm-center justify-content-between gap-2 flex-sm-row flex-column mb-3"> <div class="d-flex align-items-center"> <a href="company-details.html" class="avatar avatar-md border rounded-circle flex-shrink-0"> <img src="assets/img/icons/company-icon-05.svg" class="img-fluid w-auto h-auto" alt="img"> </a> <div class="ms-2 flex-fill"> <h6 class="fw-medium text-truncate mb-1 fs-14"><a href="company-details.html">HealthTech Innovations</a></h6> <p class="fs-13 mb-0">UK</p> </div> </div> <div class="text-sm-end mb-0"> <p class="fw-semibold mb-0 text-dark">$10,14,112</p> </div> </div> <a class="btn btn-sm btn-light d-flex align-items-center" href="deals.html"> View All<i class="ti ti-chevron-right ms-1"></i> </a> </div> </div> <!-- end card -- </div> <!-- end col -- <div class="col-xxl-4 col-xl-6 d-flex flex-column"> <div class="card flex-fill"> <div class="card-body"> <div class="d-flex align-items-center justify-content-between flex-wrap gap-2 mb-3"> <h5 class="mb-0 fs-16 fw-bold d-inline-flex items-center"><span class="line-title d-block me-2"></span>Pipeline Statistics</h5> <div class="dropdown"> <a class="dropdown-toggle btn btn-outline-light shadow" data-bs-toggle="dropdown" href="javascript:void(0);"> Weekly </a> <div class="dropdown-menu dropdown-menu-end"> <a href="javascript:void(0);" class="dropdown-item"> Monthly </a> <a href="javascript:void(0);" class="dropdown-item"> Weekly </a> <a href="javascript:void(0);" class="dropdown-item"> Last 12 months </a> </div> </div> </div> <div class="row g-3 mb-3"> <div class="col-6 col-sm-3"> <div> <p class="mb-1">Lead</p> <p class="text-dark fw-medium mb-1">$20010</p> <p class="mb-0">80 Deals</p> </div> </div> <div class="col-6 col-sm-3"> <div> <p class="mb-1">Proposal</p> <p class="text-dark fw-medium mb-1">$17210</p> <p class="mb-0">23 Deals</p> </div> </div> <div class="col-6 col-sm-3"> <div> <p class="mb-1">Sales</p> <p class="text-dark fw-medium mb-1">$9210</p> <p class="mb-0">12 Deals</p> </div> </div> <div class="col-6 col-sm-3"> <div> <p class="mb-1">Won</p> <p class="text-dark fw-medium mb-1">$8210</p> <p class="mb-0">21 Deals</p> </div> </div> </div> <div id="pipelineChart"></div> </div> </div> <div class="card flex-fill"> <div class="card-body"> <div class="d-flex align-items-center justify-content-between flex-wrap gap-2 mb-3"> <h5 class="mb-0 fw-bold d-inline-flex align-items-center gap-1"><span class="fw-normal fs-14 text-body">Profit Earned</span> $85K </h5> <div class="dropdown"> <a class="dropdown-toggle btn btn-outline-light shadow" data-bs-toggle="dropdown" href="javascript:void(0);"> 2025 </a> <div class="dropdown-menu dropdown-menu-end"> <a href="javascript:void(0);" class="dropdown-item"> 2025 </a> <a href="javascript:void(0);" class="dropdown-item"> 2024 </a> <a href="javascript:void(0);" class="dropdown-item"> 2023 </a> </div> </div> </div> <div id="profit-chart"></div> </div> </div> <!-- end card -- </div> <!-- end col -- <div class="col-xxl-4 col-xl-6 d-flex"> <div class="card flex-fill"> <div class="card-body"> <div class="d-flex align-items-center justify-content-between flex-wrap gap-2 mb-3"> <h5 class="mb-0 fs-16 fw-bold d-inline-flex items-center"><span class="line-title d-block me-2"></span>Deals Overview</h5> <a href="deals.html" class="btn btn-sm btn-icon btn-outline-light"><i class="ti ti-arrow-right"></i></a> </div> <div class="progress-stacked progress-md bg-white gap-1 mb-3"> <div class="progress-bar bg-success rounded overflow-hidden" role="progressbar" style="width: 30%" aria-valuenow="10" aria-valuemin="0" aria-valuemax="100"> </div> <div class="progress-bar bg-secondary rounded overflow-hidden" role="progressbar" style="width: 35%" aria-valuenow="15" aria-valuemin="0" aria-valuemax="100"> </div> <div class="progress-bar bg-purple rounded overflow-hidden" role="progressbar" style="width: 25%" aria-valuenow="15" aria-valuemin="0" aria-valuemax="100"> </div> <div class="progress-bar bg-danger rounded overflow-hidden" role="progressbar" style="width: 10%" aria-valuenow="20" aria-valuemin="0" aria-valuemax="100"> </div> </div> <div class="mb-4"> <div class="d-flex align-items-center gap-2 flex-wrap mb-3"> <h4 class="mb-0">2656</h4> <span class="d-inline-flex align-items-center badge rounded-pill badge-soft-success border-0">+12.5%</span> <p class="mb-0">compared to last week</p> </div> <div class="p-2 d-flex align-items-center justify-content-between border-bottom"> <p class="text-dark d-flex align-items-center mb-0"><i class="ti ti-circle-filled text-teal fs-8 me-1"></i>Successful Deals</p> <p class="text-dark mb-0">1000 Deals</p> </div> <div class="p-2 d-flex align-items-center justify-content-between border-bottom"> <p class="text-dark d-flex align-items-center mb-0"><i class="ti ti-circle-filled text-secondary fs-8 me-1"></i>Pending Deals </p> <p class="text-dark mb-0">1056 Deals</p> </div> <div class="p-2 d-flex align-items-center justify-content-between border-bottom"> <p class="text-dark d-flex align-items-center mb-0"><i class="ti ti-circle-filled text-purple fs-8 me-1"></i>Rejected Deals</p> <p class="text-dark mb-0">500 Deals</p> </div> <div class="p-2 d-flex align-items-center justify-content-between"> <p class="text-dark d-flex align-items-center mb-0"><i class="ti ti-circle-filled text-danger fs-8 me-1"></i>Upcoming Deals</p> <p class="text-dark mb-0">100 Deals</p> </div> </div> <div class="p-3 border rounded bg-light d-flex align-items-center justify-content-between"> <div> <p class="mb-1">Deals Won</p> <h4 class="mb-0">689</h4> </div> <div class="avatar-group avatar-group-sm"> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-09.svg" alt="img"> </a> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-10.svg" alt="img"> </a> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-01.svg" alt="img"> </a> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-02.svg" alt="img"> </a> <a href="#" class="avatar avatar-rounded border bg-white p-1 d-inline-flex align-items-center justify-content-center"> <img class="w-auto h-auto img-fluid" src="assets/img/company/company-11.svg" alt="img"> </a> </div> </div> </div> </div> <!-- end card -- </div> <!-- end col -- </div> <!-- end row --> <!-- start row --> <div class="row"> <div class="col-md-12 d-flex"> <div class="card flex-fill"> <div class="card-body"> <div class="d-flex align-items-center justify-content-between flex-wrap row-gap-3 mb-3"> <h5 class="mb-0 fs-16 fw-bold d-inline-flex items-center"><span class="line-title d-block me-2"></span>Recent Leads</h5> <a class="btn btn-sm btn-light d-inline-flex align-items-center" href="lead_list.php"> View All<i class="ti ti-chevron-right ms-1"></i> </a> </div> <style> #leadTabale .table tbody tr{ border: 1px solid #010101 !important; } #leadTabale .table tbody tr td { border: 1px solid #010101; } #leadTabale .table thead tr th { border: 1px solid #010101; } </style> <div class="table-responsive custom-table" id="leadTabale"> <table id="manage-leads-list" class="table table-hover align-middle nowrap" style="width:100%"> <thead class="table-light"> <tr> <th>Deal Name</th> <th>Contact Profile</th> <th>Party Category</th> <th>Authority/Location</th> <th>Reg TDR / Slum TDR</th> <th>Sub-Pipeline</th> <th>Priority</th> <th>Closing Date</th> <th>Current Stage</th> </tr> </thead> <tbody> <?php //$query = mysqli_query($conn, "SELECT l.*, s.name as stage_name FROM leads l LEFT JOIN lead_stages s ON l.stage_id = s.id ORDER BY l.id DESC"); $query = mysqli_query($conn, " SELECT l.*, s.name AS stage_name FROM leads l LEFT JOIN lead_stages s ON l.stage_id = s.id ORDER BY l.id DESC LIMIT 5 "); while($row = mysqli_fetch_assoc($query)) { $closing_f = (!empty($row['closing_date']) && $row['closing_date'] != '0000-00-00') ? date("d/m/Y", strtotime($row['closing_date'])) : 'Not Set'; $p_badge = 'bg-secondary'; if($row['deal_priority'] == 'Hot – High probability, serious buyer') $p_badge = 'bg-danger'; if($row['deal_priority'] == 'Warm – Interested but still exploring') $p_badge = 'bg-warning text-dark'; ?> <tr> <!-- <td><strong><?php echo htmlspecialchars($row['deal_name'] ?? 'N/A'); ?></strong></td> --> <!-- Replace the static deal name cell in your lead_list.php table with an active anchor link --> <td> <a href="lead_details.php?id=<?php echo $row['id']; ?>" class="text-decoration-none fw-bold text-primary"> <?php echo htmlspecialchars($row['name'] ?? 'N/A'); ?> </a> </td> <td> <div class="small fw-bold text-dark"><?php echo htmlspecialchars($row['contact_name']); ?></div> <div class="text-muted xx-small"><i class="ti ti-phone me-1"></i><?php echo htmlspecialchars($row['contact_no']); ?></div> </td> <td><span class="badge bg-soft-secondary text-dark"><?php echo htmlspecialchars($row['party_type']); ?></span></td> <td> <span class="fw-semibold text-primary"><?php echo htmlspecialchars($row['authority']); ?></span> <div class="text-muted small"><?php echo htmlspecialchars($row['location'] ?? 'N/A'); ?></div> </td> <td> <div class="small text-dark">A: <strong><?php echo htmlspecialchars($row['reg_tdr_area'] ?? '0'); ?></strong> sq.m</div> <div class="small text-muted">R: <strong><?php echo htmlspecialchars($row['rr_rate'] ?? '0'); ?></strong> </div> <div class="small text-muted">S: <strong><?php echo htmlspecialchars($row['slum_tdr_area'] ?? '0'); ?></strong> </div> </td> <td><span class="badge bg-light text-dark border"><?php echo htmlspecialchars($row['sub_pipeline']); ?></span></td> <td><span class="badge <?php echo $p_badge; ?>"><?php echo explode(' – ', $row['deal_priority'])[0]; ?></span></td> <td data-sort="<?php echo $row['closing_date']; ?>"><?php echo $closing_f; ?></td> <!--<td> <select class="form-select form-select-sm fw-semibold border-primary dynamic-stage-updater" data-lead-id="<?php echo $row['id']; ?>" style="width:150px;"> <?php $stages_q = mysqli_query($conn, "SELECT * FROM lead_stages ORDER BY id ASC"); while($stg = mysqli_fetch_assoc($stages_q)) { $sel = ($stg['id'] == $row['stage_id']) ? 'selected' : ''; echo "<option value='{$stg['id']}' {$sel}>".htmlspecialchars($stg['name'])."</option>"; } ?> </select> </td> --> <td> <?php // Define unique styling maps for all 10 stages // Combining crisp background utilities with custom styling rules $stage_styles = [ 1 => ['bg' => '#e3f2fd', 'text' => '#0d6efd', 'border' => '#b3e5fc'], // New Enquiry (Soft Light Blue) 2 => ['bg' => '#f3e5f5', 'text' => '#9c27b0', 'border' => '#e1bee7'], // Verification (Soft Purple) 3 => ['bg' => '#fff3e0', 'text' => '#ef6c00', 'border' => '#ffe0b2'], // Qualified (Soft Orange) 4 => ['bg' => '#e8f5e9', 'text' => '#2e7d32', 'border' => '#c8e6c9'], // Interested (Soft Emerald Green) 5 => ['bg' => '#e0f2f1', 'text' => '#00695c', 'border' => '#b2dfdb'], // Meeting (Teal Cyan) 6 => ['bg' => '#efebe9', 'text' => '#4e342e', 'border' => '#d7ccc8'], // Quotation (Warm Brown) 7 => ['bg' => '#fffde7', 'text' => '#f57f17', 'border' => '#fff9c4'], // Negotiation (Deep Gold Yellow) 8 => ['bg' => '#e0f7fa', 'text' => '#00838f', 'border' => '#b2ebf2'], // Advance Received (Soft Sea Green) 9 => ['bg' => '#d4edda', 'text' => '#155724', 'border' => '#c3e6cb'], // Converted (Solid Forest Green) 10 => ['bg' => '#f8d7da', 'text' => '#721c24', 'border' => '#f5c6cb'] // Lost (Soft Crimson Red) ]; // Fetch matching stage attributes from the loop row $current_stage_id = intval($row['stage_id']); // Assign style parameters or fallback gracefully to basic grey if unassigned $style = $stage_styles[$current_stage_id] ?? ['bg' => '#f8f9fa', 'text' => '#6c757d', 'border' => '#dee2e6']; // Fetch the text name dynamically from your query layout data join context // (Ensure your main table SQL joins lead_stages as 'stage_name', e.g., s.name as stage_name) $display_stage_name = htmlspecialchars($row['stage_name'] ?? 'Unknown'); ?> <span class="badge fw-bold px-3 py-2 text-uppercase tracking-wider rounded-2 shadow-sm d-inline-block text-center" style="background-color: <?php echo $style['bg']; ?>; color: <?php echo $style['text']; ?>; border: 1px solid <?php echo $style['border']; ?>; font-size: 11px; min-width: 130px; letter-spacing: 0.5px;"> <i class="bi bi-circle-fill me-1" style="font-size: 8px; vertical-align: middle;"></i> <?php echo $display_stage_name; ?> </span> </td> </tr> <?php } ?> </tbody> </table> </div> </div> <!-- end card body --> </div> <!-- end card --> </div> <!-- end col --> </div> <!-- end row --> <div class="row"> <div class="col-xxl-8 col-xl-7 d-flex"> <div class="card flex-fill"> <div class="card-body pb-0"> <div class="d-flex align-items-center justify-content-between flex-wrap gap-2 mb-3"> <h5 class="mb-0 fs-16 fw-bold d-inline-flex items-center"><span class="line-title d-block me-2"></span>Revenue Analytics</h5> <ul class="nav nav-tabs nav-solid-danger border rounded gap-2 p-1"> <li class="nav-item"><a class="nav-link py-1 px-2 rounded active" href="#wekly" data-bs-toggle="tab">Weekly</a></li> <li class="nav-item"><a class="nav-link py-1 px-2 rounded" href="#monthly" data-bs-toggle="tab">Monthly</a></li> <li class="nav-item"><a class="nav-link py-1 px-2 rounded" href="#yearly" data-bs-toggle="tab">Yearly</a></li> </ul> </div> <div class="d-flex align-items-center justify-content-between flex-wrap gap-2"> <div class="d-flex align-items-center flex-wrap gap-2"> <h4 class="mb-0">495K</h4> <p class="mb-0">Revenue with Sales (USD)</p> </div> <div class="d-flex align-items-center flex-wrap gap-2"> <div class="d-flex align-items-center border rounded px-2 py-1"> <p class="d-flex align-items-center mb-0"><i class="ti ti-circle-filled fs-8 text-primary me-1"></i>Revenue</p> </div> <div class="d-flex align-items-center border rounded px-2 py-1"> <p class="d-flex align-items-center mb-0"><i class="ti ti-circle-filled fs-8 text-light-500 me-1"></i>Sales</p> </div> </div> </div> <div id="performance-stats"></div> </div> </div> <!-- end card --> </div> <!-- end col --> <div class="col-xxl-4 col-xl-5 d-flex"> <div class="card flex-fill"> <div class="card-body"> <div class="d-flex align-items-center justify-content-between flex-wrap gap-2 mb-0"> <h5 class="mb-0 fs-16 fw-bold d-inline-flex items-center"><span class="line-title d-block me-2"></span>Traffic Sources</h5> <a href="deals.html" class="btn btn-sm btn-icon btn-outline-light"><i class="ti ti-arrow-right"></i></a> </div> <div id="traffic-sources-chart"></div> </div> <div class="mb-1"> <div class="px-3 py-2 d-flex align-items-center justify-content-between border-bottom"> <p class="text-dark d-flex align-items-center mb-0"><i class="ti ti-circle-filled text-success fs-8 me-1"></i>Organic Search</p> <p class="text-dark fw-semibold mb-0">6598</p> </div> <div class="px-3 py-2 d-flex align-items-center justify-content-between border-bottom"> <p class="text-dark d-flex align-items-center mb-0"><i class="ti ti-circle-filled text-info fs-8 me-1"></i>Direct Traffic</p> <p class="text-dark fw-semibold mb-0">2458</p> </div> <div class="px-3 py-2 d-flex align-items-center justify-content-between border-bottom"> <p class="text-dark d-flex align-items-center mb-0"><i class="ti ti-circle-filled text-warning fs-8 me-1"></i>Referral Traffic</p> <p class="text-dark fw-semibold mb-0">1456</p> </div> <div class="px-3 pt-2 pb-3 d-flex align-items-center justify-content-between"> <p class="text-dark d-flex align-items-center mb-0"><i class="ti ti-circle-filled text-purple fs-8 me-1"></i>Social Media</p> <p class="text-dark fw-semibold mb-0">845</p> </div> </div> </div> <!-- end card --> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- End Content --> <!-- Start Footer --> <?php include "footer-heading.php" ?> <!-- End Footer --> </div> <!-- ======================== End Page Content ========================= --> </div> <!-- End Wrapper --> <!-- jQuery --> <script src="assets/js/jquery-3.7.1.min.js"></script> <!-- Simplebar JS --> <script src="assets/plugins/simplebar/simplebar.min.js"></script> <!-- Datatable JS --> <script src="assets/plugins/datatables/js/jquery.dataTables.min.js"></script> <script src="assets/plugins/datatables/js/dataTables.bootstrap5.min.js"></script> <!-- Daterangepicker JS --> <script src="assets/js/moment.min.js"></script> <script src="assets/plugins/daterangepicker/daterangepicker.js"></script> <!-- Apexchart JS --> <script src="assets/plugins/apexchart/apexcharts.min.js"></script> <script src="assets/plugins/apexchart/chart-data.js"></script> <!-- Custom Json Js --> <script src="assets/json/dashboard.js"></script> <?php include"footer.php"?>