<?php

// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);

include_once("include/head.php");


$branchSql = "SELECT branch_id, branch_name FROM branches";
$branchResult = $conn->query($branchSql);

$branches = [];


if ($branchResult->num_rows > 0) {
    while ($row = $branchResult->fetch_assoc()) {
        $branches[$row['branch_id']] = $row['branch_name'];
    }
} else {
    echo "No branches found";
}
// echo'<pre>';
// print_r($branches);

$employeeSql = "SELECT branch_id, COUNT(*) as count FROM employees GROUP BY branch_id";
$employeeResult = $conn->query($employeeSql);

$empCounts = [];

if ($employeeResult->num_rows > 0) {
    while ($row = $employeeResult->fetch_assoc()) {
        $empCounts[$row['branch_id']] = $row['count'];
    }
} else {
    echo "No employee data found";
}

// echo'<pre>';
// print_r($empCounts);

// $employeeSql = "SELECT branch_id FROM employees";
// $employeeResult = $conn->query($employeeSql);

// $branchCounts = [];

// if ($employeeResult->num_rows > 0) {
//     while ($row = $employeeResult->fetch_assoc()) {
//         $branchIds = explode(',', $row['branch_id']);
//          foreach ($branchIds as $branchId) {
//             $branchId = trim($branchId);  
//             if (isset($branchCounts[$branchId])) {
//                 $branchCounts[$branchId]++;
//             } else {
//                 $branchCounts[$branchId] = 1;
//             }
//         }
//     }
// } else {
//     echo "No employee data found";
// }


$vendorSql = "SELECT branch_id, COUNT(id) as count FROM vendors GROUP BY branch_id";
$vendorResult = $conn->query($vendorSql);

$vendorCounts = [];

if ($vendorResult->num_rows > 0) {
    while ($row = $vendorResult->fetch_assoc()) {
        $vendorCounts[$row['branch_id']] = $row['count'];
    }
} else {
    echo "No Vendor data found";
}
// echo'<pre>';
// print_r($vendorCounts);

$clientSql = "SELECT branch_id, COUNT(id) as count FROM clients GROUP BY branch_id";
$clientResult = $conn->query($clientSql);

$clientCounts = [];

if ($clientResult->num_rows > 0) {
    while ($row = $clientResult->fetch_assoc()) {
        $clientCounts[$row['branch_id']] = $row['count'];
    }
} else {
    echo "No Vendor data found";
}

?>

  <div class="main-panel">
    <div class="content-wrapper">
        <?php
        foreach ($branches as $branchId => $branchName) {
            $employeeCount = isset($empCounts[$branchId]) ? $empCounts[$branchId] : 0;

            $vendorCount = isset($vendorCounts[$branchId]) ? $vendorCounts[$branchId] : 0;

            $clientCount = isset($clientCounts[$branchId]) ? $clientCounts[$branchId] : 0;
            ?>
            <h4 class="text-capitalize"><?php echo $branchName . ' Branch'; ?></h4>
            <div class="row">
                <div class="col-md-3 grid-margin stretch-card">
                    <div class="card">
                        <div class="card-body">
                            <a href="employee-list.php?branch-id=<?php echo $branchId ?>">
                                <p class="card-title text-md-center text-xl-left">Number of Employees</p>
                                <div class="d-flex flex-wrap justify-content-between justify-content-md-center justify-content-xl-between align-items-center">
                                    <h3 class="mb-0 mb-md-2 mb-xl-0 order-md-1 order-xl-0"><?php echo $employeeCount; ?></h3>
                                    <i class="ti-calendar icon-md text-muted mb-0 mb-md-3 mb-xl-0"></i>
                                </div>  
                            </a>
                        </div>
                    </div>
                </div>
                <div class="col-md-3 grid-margin stretch-card">
                    <div class="card">
                        <div class="card-body">
                            <a href="vendor.php?branch-id=<?php echo $branchId ?>">
                                <p class="card-title text-md-center text-xl-left">Number of Vendors</p>
                                <div class="d-flex flex-wrap justify-content-between justify-content-md-center justify-content-xl-between align-items-center">
                                    <h3 class="mb-0 mb-md-2 mb-xl-0 order-md-1 order-xl-0"><?php echo $vendorCount; ?></h3>
                                    <i class="ti-calendar icon-md text-muted mb-0 mb-md-3 mb-xl-0"></i>
                                </div>  
                            </a>
                        </div>
                    </div>
                </div>
                <div class="col-md-3 grid-margin stretch-card">
                    <div class="card">
                        <div class="card-body">
                            <a href="client.php?branch-id=<?php echo $branchId ?>">
                                <p class="card-title text-md-center text-xl-left">Number of Clients</p>
                                <div class="d-flex flex-wrap justify-content-between justify-content-md-center justify-content-xl-between align-items-center">
                                    <h3 class="mb-0 mb-md-2 mb-xl-0 order-md-1 order-xl-0"><?php echo $clientCount; ?></h3>
                                    <i class="ti-calendar icon-md text-muted mb-0 mb-md-3 mb-xl-0"></i>
                                </div>  
                            </a>
                        </div>
                    </div>
                </div>
            </div>
            <?php
        }
        ?>
        
        <h4 class="text-capitalize">Upcoming Birthdays</h4>
        
            <?php
                $today = date('Y-m-d');
                $endDate = date('Y-m-d', strtotime('+7 days'));
            
                $dobSql = "
                        SELECT e.first_name, e.last_name, e.contact_no, e.date_of_birth, e.branch_id, b.branch_name
                        FROM employees e
                        JOIN branches b ON e.branch_id = b.branch_id
                        WHERE 
                            (DATE_FORMAT(e.date_of_birth, '%m-%d') BETWEEN DATE_FORMAT('$today', '%m-%d') 
                            AND DATE_FORMAT('$endDate', '%m-%d'))
                        OR
                            (DATE_FORMAT(e.date_of_birth, '%m-%d') BETWEEN '01-01' AND DATE_FORMAT('$endDate', '%m-%d') 
                            AND DATE_FORMAT('$today', '%m-%d') > '12-25')
                        GROUP BY e.branch_id, e.first_name, e.last_name, e.contact_no, e.date_of_birth, b.branch_name
                        LIMIT 5"; 
            
                $dobResult = $conn->query($dobSql);
            ?>

            <div class="row">
                <div class="col-md-12 grid-margin stretch-card">
                    <div class="card">
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-striped table-borderless">
                                    <thead>
                                        <tr>
                                            <th>Name</th>
                                            <th>Date Of Birth</th>
                                            <th>Contact Number</th>
                                            <th>Branch</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        if ($dobResult->num_rows > 0) {
                                            while ($row = $dobResult->fetch_assoc()) {
                                                $name = $row['first_name'] . ' ' . $row['last_name'];
                                                $dob = date('d M Y', strtotime($row['date_of_birth']));
                                                $contactNo = $row['contact_no'];
                                                $branchId = $row['branch_id'];
                                                
                                                $branchName = $row['branch_name']; 
            
                                                echo "<tr>
                                                    <td>{$name}</td>
                                                    <td>{$dob}</td>
                                                    <td>{$contactNo}</td>
                                                    <td class='text-capitalize'>{$branchName}</td>
                                                    <td><a href='#' class='btn-sm btn-primary'>Send Wishes</a></td>
                                                </tr>";
                                            }
                                        } else {
                                            echo "<tr><td colspan='5'>No upcoming birthdays within the next 7 days</td></tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

                 
              <!--<div class="row">-->
              <!--  <div class="col-md-6 grid-margin stretch-card">-->
              <!--    <div class="card">-->
              <!--      <div class="card-body">-->
              <!--        <p class="card-title">Order and Downloads</p>-->
              <!--        <p class="text-muted font-weight-light">The total number of sessions within the date range. It is the period time a user is actively engaged with your website, page or app, etc</p>-->
              <!--        <div class="d-flex flex-wrap mb-5">-->
              <!--          <div class="mr-5 mt-3">-->
              <!--            <p class="text-muted">Order value</p>-->
              <!--            <h3>12.3k</h3>-->
              <!--          </div>-->
              <!--          <div class="mr-5 mt-3">-->
              <!--            <p class="text-muted">Orders</p>-->
              <!--            <h3>14k</h3>-->
              <!--          </div>-->
              <!--          <div class="mr-5 mt-3">-->
              <!--            <p class="text-muted">Users</p>-->
              <!--            <h3>71.56%</h3>-->
              <!--          </div>-->
              <!--          <div class="mt-3">-->
              <!--            <p class="text-muted">Downloads</p>-->
              <!--            <h3>34040</h3>-->
              <!--          </div> -->
              <!--        </div>-->
              <!--        <canvas id="order-chart"></canvas>-->
              <!--      </div>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--  <div class="col-md-6 grid-margin stretch-card">-->
              <!--    <div class="card">-->
              <!--      <div class="card-body">-->
              <!--        <p class="card-title">Sales Report</p>-->
              <!--        <p class="text-muted font-weight-light">The total number of sessions within the date range. It is the period time a user is actively engaged with your website, page or app, etc</p>-->
              <!--        <div id="sales-legend" class="chartjs-legend mt-4 mb-2"></div>-->
              <!--        <canvas id="sales-chart"></canvas>-->
              <!--      </div>-->
              <!--      <div class="card border-right-0 border-left-0 border-bottom-0">-->
              <!--        <div class="d-flex justify-content-center justify-content-md-end">-->
              <!--          <div class="dropdown flex-md-grow-1 flex-xl-grow-0">-->
              <!--            <button class="btn btn-lg btn-outline-light dropdown-toggle rounded-0 border-top-0 border-bottom-0" type="button" id="dropdownMenuDate2" data-toggle="dropdown" aria-haspopup="true" aria-expanded="true">-->
              <!--              Today-->
              <!--            </button>-->
              <!--            <div class="dropdown-menu dropdown-menu-right" aria-labelledby="dropdownMenuDate2">-->
              <!--              <a class="dropdown-item" href="#">January - March</a>-->
              <!--              <a class="dropdown-item" href="#">March - June</a>-->
              <!--              <a class="dropdown-item" href="#">June - August</a>-->
              <!--              <a class="dropdown-item" href="#">August - November</a>-->
              <!--            </div>-->
              <!--          </div>-->
              <!--          <button class="btn btn-lg btn-outline-light text-primary rounded-0 border-0 d-none d-md-block" type="button"> View all </button>-->
              <!--        </div>-->
              <!--      </div>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--</div>-->
              <!--<div class="row">-->
              <!--  <div class="col-md-7 grid-margin stretch-card">-->
              <!--    <div class="card">-->
              <!--      <div class="card-body">-->
              <!--        <p class="card-title mb-0">Top Products</p>-->
              <!--        <div class="table-responsive">-->
              <!--          <table class="table table-striped table-borderless">-->
              <!--            <thead>-->
              <!--              <tr>-->
              <!--                <th>Product</th>-->
              <!--                <th>Price</th>-->
              <!--                <th>Date</th>-->
              <!--                <th>Status</th>-->
              <!--              </tr>  -->
              <!--            </thead>-->
              <!--            <tbody>-->
              <!--              <tr>-->
              <!--                <td>Search Engine Marketing</td>-->
              <!--                <td class="font-weight-bold">Rs 362</td>-->
              <!--                <td>21 Sep 2018</td>-->
              <!--                <td class="font-weight-medium text-success">Completed</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td>Search Engine Optimization</td>-->
              <!--                <td class="font-weight-bold">Rs 116</td>-->
              <!--                <td>13 Jun 2018</td>-->
              <!--                <td class="font-weight-medium text-success">Completed</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td>Display Advertising</td>-->
              <!--                <td class="font-weight-bold">Rs 551</td>-->
              <!--                <td>28 Sep 2018</td>-->
              <!--                <td class="font-weight-medium text-warning">Pending</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td>Pay Per Click Advertising</td>-->
              <!--                <td class="font-weight-bold">Rs 523</td>-->
              <!--                <td>30 Jun 2018</td>-->
              <!--                <td class="font-weight-medium text-warning">Pending</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td>E-Mail Marketing</td>-->
              <!--                <td class="font-weight-bold">Rs 781</td>-->
              <!--                <td>01 Nov 2018</td>-->
              <!--                <td class="font-weight-medium text-danger">Cancelled</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td>Referral Marketing</td>-->
              <!--                <td class="font-weight-bold">Rs 283</td>-->
              <!--                <td>20 Mar 2018</td>-->
              <!--                <td class="font-weight-medium text-warning">Pending</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td>Social media marketing</td>-->
              <!--                <td class="font-weight-bold">Rs 897</td>-->
              <!--                <td>26 Oct 2018</td>-->
              <!--                <td class="font-weight-medium text-success">Completed</td>-->
              <!--              </tr>-->
              <!--            </tbody>-->
              <!--          </table>-->
              <!--        </div>-->
              <!--      </div>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--  <div class="col-md-5 grid-margin stretch-card">-->
              <!--    <div class="card">-->
              <!--      <div class="card-body">-->
              <!--        <h4 class="card-title">To Do Lists</h4>-->
              <!--        <div class="list-wrapper pt-2">-->
              <!--          <ul class="d-flex flex-column-reverse todo-list todo-list-custom">-->
              <!--            <li>-->
              <!--              <div class="form-check form-check-flat">-->
              <!--                <label class="form-check-label">-->
              <!--                  <input class="checkbox" type="checkbox">-->
              <!--                  Meeting with Urban Team-->
              <!--                </label>-->
              <!--              </div>-->
              <!--              <i class="remove ti-close"></i>-->
              <!--            </li>-->
              <!--            <li class="completed">-->
              <!--              <div class="form-check form-check-flat">-->
              <!--                <label class="form-check-label">-->
              <!--                  <input class="checkbox" type="checkbox" checked>-->
              <!--                  Duplicate a project for new customer-->
              <!--                </label>-->
              <!--              </div>-->
              <!--              <i class="remove ti-close"></i>-->
              <!--            </li>-->
              <!--            <li>-->
              <!--              <div class="form-check form-check-flat">-->
              <!--                <label class="form-check-label">-->
              <!--                  <input class="checkbox" type="checkbox">-->
              <!--                  Project meeting with CEO-->
              <!--                </label>-->
              <!--              </div>-->
              <!--              <i class="remove ti-close"></i>-->
              <!--            </li>-->
              <!--            <li class="completed">-->
              <!--              <div class="form-check form-check-flat">-->
              <!--                <label class="form-check-label">-->
              <!--                  <input class="checkbox" type="checkbox" checked>-->
              <!--                  Follow up of team zilla-->
              <!--                </label>-->
              <!--              </div>-->
              <!--              <i class="remove ti-close"></i>-->
              <!--            </li>-->
              <!--            <li>-->
              <!--              <div class="form-check form-check-flat">-->
              <!--                <label class="form-check-label">-->
              <!--                  <input class="checkbox" type="checkbox">-->
              <!--                  Level up for Antony-->
              <!--                </label>-->
              <!--              </div>-->
              <!--              <i class="remove ti-close"></i>-->
              <!--            </li>-->
              <!--          </ul>-->
              <!--        </div>-->
              <!--        <div class="add-items d-flex mb-0 mt-2">-->
              <!--          <input type="text" class="form-control todo-list-input"  placeholder="Add new task">-->
              <!--          <button class="add btn btn-icon text-primary todo-list-add-btn bg-transparent"><i class="ti-location-arrow"></i></button>-->
              <!--        </div>-->
              <!--      </div>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--</div>-->
              <!--<div class="row">-->
              <!--  <div class="col-md-12 grid-margin stretch-card">-->
              <!--    <div class="card position-relative">-->
              <!--      <div class="card-body">-->
              <!--        <p class="card-title">Detailed Reports</p>-->
              <!--        <div id="detailedReports" class="carousel slide detailed-report-carousel position-static pt-2" data-ride="carousel">-->
              <!--          <div class="carousel-inner">-->
              <!--            <div class="carousel-item active">-->
              <!--              <div class="row">-->
              <!--                <div class="col-md-12 col-xl-3 d-flex flex-column justify-content-center">-->
              <!--                  <div class="ml-xl-4">-->
              <!--                    <h1>Rs 34040</h1>-->
              <!--                    <h3 class="font-weight-light mb-xl-4">North India</h3>-->
              <!--                    <p class="text-muted mb-2 mb-xl-0">The total number of sessions within the date range. It is the period time a user is actively engaged with your website, page or app, etc</p>-->
              <!--                  </div>  -->
              <!--                  </div>-->
              <!--                <div class="col-md-12 col-xl-9">-->
              <!--                  <div class="row">-->
              <!--                    <div class="col-md-6">-->
              <!--                      <div class="table-responsive mb-3 mb-md-0">-->
              <!--                        <table class="table table-borderless report-table">-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Delhi</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-success" role="progressbar" style="width: 70%" aria-valuenow="70" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">713</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Noida</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-warning" role="progressbar" style="width: 30%" aria-valuenow="30" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">583</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Gurugram</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-danger" role="progressbar" style="width: 95%" aria-valuenow="95" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">924</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Bihar</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-primary" role="progressbar" style="width: 60%" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">664</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Maharashtra</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-success" role="progressbar" style="width: 40%" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">560</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Pune</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-danger" role="progressbar" style="width: 75%" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">793</h5></td>-->
              <!--                          </tr>-->
              <!--                        </table>-->
              <!--                      </div>-->
              <!--                    </div>-->
              <!--                    <div class="col-md-6 mt-3">-->
              <!--                      <canvas id="north-India-chart"></canvas>-->
              <!--                      <div id="north-India-legend"></div>-->
              <!--                    </div>-->
              <!--                  </div>-->
              <!--                </div>-->
              <!--              </div>-->
              <!--            </div>-->
              <!--            <div class="carousel-item">-->
              <!--              <div class="row">-->
              <!--                <div class="col-md-12 col-xl-3 d-flex flex-column justify-content-center">-->
              <!--                  <div class="ml-xl-4">-->
              <!--                    <h1>Rs 61321</h1>-->
              <!--                    <h3 class="font-weight-light mb-xl-4">South India</h3>-->
              <!--                    <p class="text-muted mb-2 mb-xl-0">It is the period time a user is actively engaged with your website, page or app, etc. The total number of sessions within the date range. </p>-->
              <!--                  </div>-->
              <!--                </div>-->
              <!--                <div class="col-md-12 col-xl-9">-->
              <!--                  <div class="row">-->
              <!--                    <div class="col-md-6">-->
              <!--                      <div class="table-responsive mb-3 mb-md-0">-->
              <!--                        <table class="table table-borderless report-table">-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Pune</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-success" role="progressbar" style="width: 70%" aria-valuenow="70" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">613</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Andhra</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-warning" role="progressbar" style="width: 30%" aria-valuenow="30" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">483</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Pune</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-danger" role="progressbar" style="width: 95%" aria-valuenow="95" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">824</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Kerla</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-primary" role="progressbar" style="width: 60%" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">564</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Tamilnadu</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-success" role="progressbar" style="width: 40%" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">460</h5></td>-->
              <!--                          </tr>-->
              <!--                          <tr>-->
              <!--                            <td class="text-muted">Telangana</td>-->
              <!--                            <td class="w-100 px-0">-->
              <!--                              <div class="progress progress-md mx-4">-->
              <!--                                <div class="progress-bar bg-danger" role="progressbar" style="width: 75%" aria-valuenow="75" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                              </div>-->
              <!--                            </td>-->
              <!--                            <td><h5 class="font-weight-bold mb-0">693</h5></td>-->
              <!--                          </tr>-->
              <!--                        </table>-->
              <!--                      </div>-->
              <!--                    </div>-->
              <!--                    <div class="col-md-6 mt-3">-->
              <!--                      <canvas id="south-India-chart"></canvas>-->
              <!--                      <div id="south-India-legend"></div>-->
              <!--                    </div>-->
              <!--                  </div>-->
              <!--                </div>-->
              <!--              </div>-->
              <!--            </div>-->
              <!--          </div>-->
              <!--          <a class="carousel-control-prev" href="#detailedReports" role="button" data-slide="prev">-->
              <!--            <span class="carousel-control-prev-icon" aria-hidden="true"></span>-->
              <!--            <span class="sr-only">Previous</span>-->
              <!--          </a>-->
              <!--          <a class="carousel-control-next" href="#detailedReports" role="button" data-slide="next">-->
              <!--            <span class="carousel-control-next-icon" aria-hidden="true"></span>-->
              <!--            <span class="sr-only">Next</span>-->
              <!--          </a>-->
              <!--        </div>-->
              <!--      </div>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--</div>-->
              <!--<div class="row">-->
              <!--  <div class="col-md-4 stretch-card grid-margin grid-margin-md-0">-->
              <!--    <div class="card">-->
              <!--      <div class="card-body">-->
              <!--        <p class="card-title mb-0">Projects</p>-->
              <!--        <div class="table-responsive">-->
              <!--          <table class="table table-borderless">-->
              <!--            <thead>-->
              <!--              <tr>-->
              <!--                <th class="pl-0 border-bottom">Places</th>-->
              <!--                <th class="border-bottom">Orders</th>-->
              <!--                <th class="border-bottom">Users</th>-->
              <!--              </tr>-->
              <!--            </thead>-->
              <!--            <tbody>-->
              <!--              <tr>-->
              <!--                <td class="text-muted pl-0">Kentucky</td>-->
              <!--                <td><p class="mb-0"><span class="font-weight-bold mr-2">65</span>(2.15%)</p></td>-->
              <!--                <td class="text-muted">65</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td class="text-muted pl-0">Ohio</td>-->
              <!--                <td><p class="mb-0"><span class="font-weight-bold mr-2">54</span>(3.25%)</p></td>-->
              <!--                <td class="text-muted">51</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td class="text-muted pl-0">Nevada</td>-->
              <!--                <td><p class="mb-0"><span class="font-weight-bold mr-2">22</span>(2.22%)</p></td>-->
              <!--                <td class="text-muted">32</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td class="text-muted pl-0">North Carolina</td>-->
              <!--                <td><p class="mb-0"><span class="font-weight-bold mr-2">46</span>(3.27%)</p></td>-->
              <!--                <td class="text-muted">15</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td class="text-muted pl-0">Montana</td>-->
              <!--                <td><p class="mb-0"><span class="font-weight-bold mr-2">17</span>(1.25%)</p></td>-->
              <!--                <td class="text-muted">25</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td class="text-muted pl-0">Nevada</td>-->
              <!--                <td><p class="mb-0"><span class="font-weight-bold mr-2">52</span>(3.11%)</p></td>-->
              <!--                <td class="text-muted">71</td>-->
              <!--              </tr>-->
              <!--              <tr>-->
              <!--                <td class="text-muted pl-0 pb-0">Louisiana</td>-->
              <!--                <td class="pb-0"><p class="mb-0"><span class="font-weight-bold mr-2">25</span>(1.32%)</p></td>-->
              <!--                <td class="text-muted pb-0">14</td>-->
              <!--              </tr>-->
              <!--            </tbody>-->
              <!--          </table>-->
              <!--        </div>-->
              <!--      </div>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--  <div class="col-md-4 stretch-card">-->
              <!--    <div class="row">-->
              <!--      <div class="col-md-12 grid-margin stretch-card">-->
              <!--        <div class="card">-->
              <!--          <div class="card-body">-->
              <!--            <p class="card-title">Charts</p>-->
              <!--            <div class="charts-data">-->
              <!--              <div class="mt-3">-->
              <!--                <p class="text-muted mb-0">Orders</p>-->
              <!--                <div class="d-flex justify-content-between align-items-center">-->
              <!--                  <div class="progress progress-md flex-grow-1 mr-4">-->
              <!--                    <div class="progress-bar bg-success" role="progressbar" style="width: 95%" aria-valuenow="95" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                  </div>-->
              <!--                  <p class="text-muted mb-0">5k</p>-->
              <!--                </div>-->
              <!--              </div>-->
              <!--              <div class="mt-3">-->
              <!--                <p class="text-muted mb-0">Users</p>-->
              <!--                <div class="d-flex justify-content-between align-items-center">-->
              <!--                  <div class="progress progress-md flex-grow-1 mr-4">-->
              <!--                    <div class="progress-bar bg-success" role="progressbar" style="width: 35%" aria-valuenow="35" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                  </div>-->
              <!--                  <p class="text-muted mb-0">3k</p>-->
              <!--                </div>-->
              <!--              </div>-->
              <!--              <div class="mt-3">-->
              <!--                <p class="text-muted mb-0">Downloads</p>-->
              <!--                <div class="d-flex justify-content-between align-items-center">-->
              <!--                  <div class="progress progress-md flex-grow-1 mr-4">-->
              <!--                    <div class="progress-bar bg-success" role="progressbar" style="width: 48%" aria-valuenow="48" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                  </div>-->
              <!--                  <p class="text-muted mb-0">992</p>-->
              <!--                </div>-->
              <!--              </div>-->
              <!--              <div class="mt-3">-->
              <!--                <p class="text-muted mb-0">Visitors</p>-->
              <!--                <div class="d-flex justify-content-between align-items-center">-->
              <!--                  <div class="progress progress-md flex-grow-1 mr-4">-->
              <!--                    <div class="progress-bar bg-success" role="progressbar" style="width: 25%" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>-->
              <!--                  </div>-->
              <!--                  <p class="text-muted mb-0">687</p>-->
              <!--                </div>-->
              <!--              </div>-->
              <!--            </div>  -->
              <!--          </div>-->
              <!--        </div>-->
              <!--      </div>-->
              <!--      <div class="col-md-12 stretch-card grid-margin grid-margin-md-0">-->
              <!--        <div class="card data-icon-card-primary">-->
              <!--          <div class="card-body">-->
              <!--            <p class="card-title text-white">Number of Meetings</p>                      -->
              <!--            <div class="row">-->
              <!--              <div class="col-8 text-white">-->
              <!--                <h3>3404</h3>-->
              <!--                <p class="text-white font-weight-light mb-0">The total number of sessions within the date range. It is the period time</p>-->
              <!--              </div>-->
              <!--              <div class="col-4 background-icon">-->
              <!--                <i class="ti-calendar"></i>-->
              <!--              </div>-->
              <!--            </div>-->
              <!--          </div>-->
              <!--        </div>-->
              <!--      </div>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--  <div class="col-md-4 stretch-card">-->
              <!--    <div class="card">-->
              <!--      <div class="card-body">-->
              <!--        <p class="card-title">Notifications</p>-->
              <!--        <ul class="icon-data-list">-->
              <!--          <li>-->
              <!--            <p class="text-primary mb-1">Isabella Becker</p>-->
              <!--            <p class="text-muted">Sales dashboard have been created</p>-->
              <!--            <small class="text-muted">9:30 am</small>-->
              <!--          </li>-->
              <!--          <li>-->
              <!--            <p class="text-primary mb-1">Adam Warren</p>-->
              <!--            <p class="text-muted">You have done a great job #TW11109872</p>-->
              <!--            <small class="text-muted">10:30 am</small>-->
              <!--          </li>-->
              <!--          <li>-->
              <!--            <p class="text-primary mb-1">Leonard Thornton</p>-->
              <!--            <p class="text-muted">Sales dashboard have been created</p>-->
              <!--            <small class="text-muted">11:30 am</small>-->
              <!--          </li>-->
              <!--          <li>-->
              <!--            <p class="text-primary mb-1">George Morrison</p>-->
              <!--            <p class="text-muted">Sales dashboard have been created</p>-->
              <!--            <small class="text-muted">8:50 am</small>-->
              <!--          </li>-->
              <!--          <li>-->
              <!--            <p class="text-primary mb-1">Ryan Cortez</p>-->
              <!--            <p class="text-muted">Herbs are fun and easy to grow.</p>-->
              <!--            <small class="text-muted">9:00 am</small>-->
              <!--          </li>-->
                        
              <!--        </ul>-->
              <!--      </div>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--</div>-->
              
              
            </div>
        </div>
    </div>
    </div>
  </div>

  <?php include_once("include/footer.php"); ?>
</body>

</html>