<?php
require("includes/check_auth_user.php");
require("includes/dbconnect.php");
include('includes/function.php');

$admin = $_SESSION["admin_" . $dbname];
$usertype = $_SESSION["usertype"];
$complogo = $_SESSION["complogo"];
$menutype = $_SESSION["menutype"];
$username = $_SESSION["username"];

$nstartdate = $_REQUEST['startdate'];
$nenddate = $_REQUEST['enddate'];

$startdate = date("Y-m-d", strtotime($nstartdate));
$enddate = date("Y-m-d", strtotime($nenddate));
$actstartDate = date("Y-m-d", strtotime($startdate . ' +1 day'));
$zroot = $_SESSION["zdir"];
$tdate = date("Y-m-d");
$zdb = $_SESSION["zdbyear_" . $dbname];
mysqli_select_db($conn, $zdb);

$maindb = 'pax';

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="apple-touch-icon" sizes="76x76" href="../assets/img/apple-icon.png">
    <title>
        HUTFIT
    </title>
    <!--     Fonts and icons     -->
    <link rel="stylesheet" type="text/css"
        href="https://fonts.googleapis.com/css?family=Inter:300,400,500,600,700,900" />
    <!-- Nucleo Icons -->
    <link href="../assets/css/nucleo-icons.css" rel="stylesheet" />
    <link href="../assets/css/nucleo-svg.css" rel="stylesheet" />
    <!-- Font Awesome Icons -->

    <!-- link for date range picker -->
    <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />

    <!-- Material Icons -->
    <link rel="stylesheet"
        href="https://fonts.googleapis.com/css2?family=Material+Symbols+Rounded:opsz,wght,FILL,GRAD@24,400,0,0" />

    <!-- BOOTSTRAP LINK FOR BOOTSTRAP ICON BY OBAID -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons/font/bootstrap-icons.css" rel="stylesheet">

    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/css/bootstrap.min.css"
        integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">

    <!-- CSS Files -->
    <link id="pagestyle" href="../assets/css/material-dashboard.css?v=3.2.0" rel="stylesheet" />

    <!-- calendar  -->
    <link href="https://fonts.googleapis.com/css?family=Roboto:100,100i,300,300i,400,400i,500,500i,700,700i,900,900i"
        rel="stylesheet">

    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.4/Chart.js"></script>

    <!-- JQUERY LIBRARY -->
    <script type="text/javascript" src="assets/js/core/libraries/jquery.min.js"></script>
    <link href="https://code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css" rel="stylesheet" />
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.1.1/jquery.min.js"></script>
    <script src="https://code.jquery.com/ui/1.11.4/jquery-ui.js"></script>

    <script src="MyScript/get_Dashboard.js?A=<?= mt_rand(); ?>" type="text/javascript"></script>

</head>
<style>
    /* css for carousel */
    .owl-carousel .item {
        margin: 3px;
    }

    .owl-carousel .item img {
        display: block;
        width: 100%;
        height: auto;
    }

    .owl-carousel .item {
        margin: 3px;
    }

    .owl-carousel {
        margin-bottom: 15px;
    }

    .mt-new {
        margin-top: 3%;
    }

    .carousel-image {
        cursor: pointer;
    }

    /* css for carousel ends here */
    .button {
        background-color: #04AA6D;
        border: none;
        border-radius: 200px;
        color: white;
        padding: 3px 8px;
        text-align: center;
        text-decoration: none;
        display: inline-block;
        margin: 4px 2px;
        cursor: pointer;
    }

    /* .button:hover{
        box-shadow: 2px 2px  #888888 ;
      } */
    .icon {
        color: #FFFFFF !important;
    }

    .boots-icon {
        font-size: larger !important;
    }

    .card {
        /* border-radius: 18px; */
        /* border: none; */
        backdrop-filter: blur(10px);
        transition: .3s;
    }

    .card:hover {
        transform: translateY(-6px);
        box-shadow: 0 15px 30px rgba(0, 0, 0, 0.08);
    }
</style>

<body class="g-sidenav-show  bg-gray-100">
    <main class="main-content position-relative max-height-vh-100 h-100 border-radius-lg ">
        <div class="container-fluid py-2">

            <!-- <br> -->

            <div <?= $revenue; ?> class="row" style="margin-top: 10px !important;">

                <div class="col-xl-2 col-sm-6 mb-xl-0 mb-4">
                    <div class="card">
                        <div class="card-header p-2 ps-3"
                            style="border: 1.5px solid rgba(255, 99, 132); border-bottom: transparent;">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <p class="text-sm mb-0 text-capitalize">Total Fit Invoices&nbsp;<i
                                            class="bi bi-receipt"></i></p>
                                    <hr class="dark horizontal my-0">

                                    <?php
                                    $inv = 0;

                                    $getinv = mysqli_query($conn, "SELECT  COUNT(*) AS invno FROM $maindb") or die(mysqli_error($conn));
                                    $fetinvno = mysqli_num_rows($getinv);
                                    $fetinv = mysqli_fetch_array($getinv);

                                    if ($fetinvno > 0) {
                                        $inv = $fetinv['invno'];
                                    } else {
                                        $inv = 0;
                                    }
                                    echo "<h4 class='mb-01'>$inv</h4>";
                                    ?>
                                </div>
                            </div>
                        </div>
                        <!-- <hr class="dark horizontal my-0"> -->
                        <div class="card-footer p-2 ps-3"
                            style="border: 1.5px solid rgba(255, 99, 132); border-top: transparent;">
                        </div>
                    </div>
                </div>


                <div class="col-xl-2 col-sm-6">
                    <div class="card">
                        <div class="card-header p-2 ps-3" style="border: 1.5px solid rgba(160, 32, 240); border-bottom: transparent;">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <p class="text-sm mb-0 text-capitalize">Total Hajj/Umrah&nbsp;<i class="bi bi-file-earmark-check"></i></p>
                                    <hr class="dark horizontal my-0">
                                    <?php

                                    $gethajj = mysqli_query($conn, "SELECT COUNT(*) AS regnno FROM bookform") or die(mysqli_error($conn));
                                    $fethajjno = mysqli_num_rows($getinv);
                                    $fethajj = mysqli_fetch_array($gethajj);

                                    if ($fethajjno > 0) {
                                        $hajj = $fethajj['regnno'];
                                    } else {
                                        $hajj = 0;
                                    }
                                    echo "<h4 class='mb-01'>$hajj</h4>";
                                    ?>
                                </div>
                            </div>
                        </div>
                        <hr class="dark horizontal my-0">
                        <div class="card-footer p-2 ps-3" style="border: 1.5px solid rgba(160, 32, 240); border-top: transparent;">
                        </div>
                    </div>
                </div>

                <div class="col-xl-2 col-sm-6 mb-xl-0 mb-4">
                    <div class="card">
                        <div class="card-header p-2 ps-3"
                            style="border: 1.5px solid rgba(54, 162, 235); border-bottom: transparent;">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <p class="text-sm mb-0 text-capitalize">Ticket & Airline &nbsp;&nbsp;<i
                                            class="bi bi-airplane"></i></p>
                                    <hr class="dark horizontal my-0">

                                    <?php

                                    $gettkt = mysqli_query($conn, "SELECT SUM(tiktamt) AS tiktamt FROM $maindb") or die(mysqli_error($conn));
                                    $fettkt = mysqli_fetch_array($gettkt);
                                    if ($gettktno < 6972589) {
                                        $tkt = $fettkt['tiktamt'];
                                    } else {
                                        $tkt = 0;
                                    }
                                    echo "<h4 class='mb-01'>₹ $tkt</h4>";
                                    ?>
                                </div>
                            </div>
                        </div>
                        <hr class="dark horizontal my-0">
                        <div class="card-footer p-2 ps-3"
                            style="border: 1.5px solid rgba(54, 162, 235); border-top: transparent;">
                        </div>
                    </div>
                </div>

                <div class="col-xl-2 col-sm-6 mb-xl-0 mb-4">
                    <div class="card">
                        <div class="card-header p-2 ps-3"
                            style="border: 1.5px solid rgba(255, 206, 86); border-bottom: transparent;">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <p class="text-sm mb-0 text-capitalize">Hotel &nbsp;&nbsp;<i
                                            class="bi bi-building"></i></p>
                                    <hr class="dark horizontal my-0">

                                    <?php

                                    $hotel = 0;

                                    $gethotel = mysqli_query($conn, "SELECT SUM(hotelinramt) AS hotelinramt FROM $maindb") or die(mysqli_error($conn));
                                    $fethotel = mysqli_fetch_array($gethotel);

                                    if ($fethotel > 0) {
                                        $hotel = $fethotel['hotelinramt'];
                                    } else {
                                        $hotel = 0;
                                    }
                                    echo "<h4 class='mb-01'>₹ $hotel</h4>";
                                    ?>
                                </div>
                            </div>
                        </div>
                        <hr class="dark horizontal my-0">
                        <div class="card-footer p-2 ps-3"
                            style="border: 1.5px solid rgba(255, 206, 86); border-top: transparent;">
                        </div>
                    </div>
                </div>

                <div class="col-xl-2 col-sm-6 mb-xl-0 mb-4">
                    <div class="card">
                        <div class="card-header p-2 ps-3"
                            style="border: 1.5px solid rgba(75, 192, 192); border-bottom: transparent;">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <p class="text-sm mb-0 text-capitalize">Food &nbsp;&nbsp;<i class="bi bi-cake"></i>
                                    </p>
                                    <hr class="dark horizontal my-0">

                                    <?php

                                    $getfood = mysqli_query($conn, "SELECT SUM(foodinramt) AS foodinramt FROM $maindb") or die(mysqli_error($conn));
                                    $fetfood = mysqli_fetch_array($getfood);

                                    if ($fetfood > 0) {
                                        $food = $fetfood['foodinramt'];
                                    } else {
                                        $food = 0;
                                    }

                                    echo "<h4 class='mb-01'>₹ $food</h4>";
                                    ?>
                                </div>
                            </div>
                        </div>
                        <hr class="dark horizontal my-0">
                        <div class="card-footer p-2 ps-3"
                            style="border: 1.5px solid rgba(75, 192, 192); border-top: transparent;">
                        </div>
                    </div>
                </div>

                <div class="col-xl-2 col-sm-6 mb-xl-0 mb-4">
                    <div class="card">
                        <div class="card-header p-2 ps-3"
                            style="border: 1.5px solid rgba(153, 102, 255); border-bottom: transparent;">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <p class="text-sm mb-0 text-capitalize">Laundry &nbsp;&nbsp;<i
                                            class="bi bi-basket"></i></p>
                                    <hr class="dark horizontal my-0">
                                    <?php

                                    $getlaund = mysqli_query($conn, "SELECT SUM(laundinramt) AS laundinramt FROM $maindb") or die(mysqli_error($conn));
                                    $fetlaund = mysqli_fetch_array($getlaund);

                                    if ($fetlaund > 0) {
                                        $laundry = $fetlaund['laundinramt'];
                                    } else {
                                        $laundry = 0;
                                    }

                                    echo "<h4 class='mb-01'>₹ $laundry</h4>";
                                    ?>
                                </div>
                            </div>
                        </div>
                        <hr class="dark horizontal my-0">
                        <div class="card-footer p-2 ps-3"
                            style="border: 1.5px solid rgba(153, 102, 255); border-top: transparent;">
                        </div>
                    </div>
                </div>


                <div class="col-xl-2 col-sm-6 mb-xl-0 mb-4">
                    <div class="card">
                        <div class="card-header p-2 ps-3"
                            style="border: 1.5px solid rgba(255, 159, 64); border-bottom: transparent;">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <p class="text-sm mb-0 text-capitalize">Transportation &nbsp;&nbsp;<i
                                            class="bi bi-car-front"></i></p>
                                    <hr class="dark horizontal my-0">
                                    <?php

                                    $gettransp = mysqli_query($conn, "SELECT SUM(transinramt) AS transinramt FROM $maindb") or die(mysqli_error($conn));
                                    $fettransp = mysqli_fetch_array($gettransp);

                                    if ($fettransp > 0) {
                                        $transportation = $fettransp['transinramt'];
                                    } else {
                                        $transportation = 0;
                                    }

                                    echo "<h4 class='mb-01'>₹ $transportation</h4>";
                                    ?>
                                </div>
                            </div>
                        </div>
                        <hr class="dark horizontal my-0">
                        <div class="card-footer p-2 ps-3"
                            style="border: 1.5px solid rgba(255, 159, 64); border-top: transparent;">
                        </div>
                    </div>
                </div>

                <div class="col-xl-2 col-sm-6">
                    <div class="card">
                        <div class="card-header p-2 ps-3"
                            style="border: 1.5px solid rgba(255, 99, 132); border-bottom: transparent;">
                            <div class="d-flex justify-content-between">
                                <div>
                                    <p class="text-sm mb-0 text-capitalize">Visa &nbsp;&nbsp;<i
                                            class="bi bi-passport"></i></p>
                                    <hr class="dark horizontal my-0">
                                    <?php

                                    $getvisa = mysqli_query($conn, "SELECT SUM(visaamt) AS visaamt FROM $maindb") or die(mysqli_error($conn));
                                    $fetvisa = mysqli_fetch_array($getvisa);

                                    if ($fetvisa > 0) {
                                        $visa = $fetvisa['visaamt'];
                                    } else {
                                        $visa = 0;
                                    }

                                    echo "<h4 class='mb-01'>₹ $visa</h4>";
                                    ?>
                                </div>
                            </div>
                        </div>
                        <hr class="dark horizontal my-0">
                        <div class="card-footer p-2 ps-3"
                            style="border: 1.5px solid rgba(255, 99, 132); border-top: transparent;">
                        </div>
                    </div>
                </div>


            </div>

            <!-- <br> -->

            <div class="row mb-4" style="margin-top: 10px;">
                <div class="col-lg-6 col-md-6 mb-md-0 mb-4">
                    <div class="card" style="border: 1px solid #008000;">
                        <div class="card-header pb-0">
                            <div class="row">
                                <div class="col-lg-6 col-7">
                                    <h6>Annual Sale / Annual Revenue</h6>
                                </div>
                                <!-- SELECT FOR A YEAR -->
                                <div class="col-lg-2 col-7 select">
                                    <!-- <select name="year" class="year form-conttrol select2 form">
                                        <?php
                                        $getusercode = mysqli_query($conn, "SELECT code,user FROM $zroot.`passmain` WHERE user = '$username' ") or die(mysqli_error($conn));
                                        $gusercode = mysqli_fetch_array($getusercode);

                                        for ($k = 3; $k <= 6; $k++) {
                                            $year = 202 . $k;
                                            echo "<option class='year' value='$year'>$year</option>";
                                        }
                                        ?>
                                    </select> -->
                                </div>
                                <div class="col-lg-4 col-7">
                                    <div class="dropdown float-lg-end pe-4">
                                        <?php
                                        $date = date("F j, Y");
                                        echo "<h6>$date</h6>";
                                        ?>
                                    </div>
                                </div>
                                <hr style="border-bottom: 1px solid black;">
                            </div>
                        </div>

                        <!-- BAR GRAPH FOR FIT AND HAJJ/UMRAH SALES STARTS FROM HERE -->
                        <div class="card-body px-0 pb-2 ">
                            <div class="table-responsive chart-container">

                                <canvas id="myChart" style="width:100%;max-width:730px;height:28rem;"></canvas>
                                <?php


                                //////////////////////// DATA OF FIT FOR BAR GRAPH /////////////////////////
                                $fitmonth = $fitjan = $fitfeb = $fitmarch = $fitapril = $fitmay = $fitjune = $fitjuly = $fitaug = $fitsept = $fitoct = $fitnov = $fitdec = 0;
                                for ($j = 1; $j <= 12; $j++) {
                                    $getfit = mysqli_query($conn, "SELECT SUM(tiktamt)+SUM(hotelinramt)+SUM(foodinramt)+SUM(laundinramt)+SUM(transinramt)+SUM(visaamt) AS grossamt,
                                    DATE_FORMAT(`date`,'%d-%m-%Y') AS invdt FROM pax WHERE MONTH(date) = '$j' ") or die(mysqli_error($conn));
                                    $fetfit = mysqli_fetch_array($getfit);
                                    $fitmonth = $fetfit['grossamt'];
                                    $zero = 0;
                                    switch ($j) {
                                        case 1:
                                            if ($fitmonth > 0) {
                                                $fitjan = $fitmonth;
                                            } else {
                                                $fitjan = $zero;
                                            }
                                            break;

                                        case 2:
                                            if ($fitmonth > 0) {
                                                $fitfeb = $fitmonth;
                                            } else {
                                                $fitfeb = $zero;
                                            }
                                            break;

                                        case 3:
                                            if ($fitmonth > 0) {
                                                $fitmarch = $fitmonth;
                                            } else {
                                                $fitmarch = $zero;
                                            }
                                            break;
                                        case 4:
                                            if ($fitmonth > 0) {
                                                $fitapril = $fitmonth;
                                            } else {
                                                $fitapril = $zero;
                                            }
                                            break;
                                        case 5:
                                            if ($fitmonth > 0) {
                                                $fitmay = $fitmonth;
                                            } else {
                                                $fitmay = $zero;
                                            }
                                            break;
                                        case 6:
                                            if ($fitmonth > 0) {
                                                $fitjune = $fitmonth;
                                            } else {
                                                $fitjune = $zero;
                                            }
                                            break;
                                        case 7:
                                            if ($fitmonth > 0) {
                                                $fitjuly = $fitmonth;
                                            } else {
                                                $fitjuly = $zero;
                                            }
                                            break;
                                        case 8:
                                            if ($fitmonth > 0) {
                                                $fitaug = $fitmonth;
                                            } else {
                                                $fitaug = $zero;
                                            }
                                            break;
                                        case 9:
                                            if ($fitmonth > 0) {
                                                $fitsept = $fitmonth;
                                            } else {
                                                $fitsept = $zero;
                                            }
                                            break;
                                        case 10:
                                            if ($fitmonth > 0) {
                                                $fitoct = $fitmonth;
                                            } else {
                                                $fitoct = $zero;
                                            }
                                            break;
                                        case 11:
                                            if ($fitmonth > 0) {
                                                $fitnov = $fitmonth;
                                            } else {
                                                $fitnov = $zero;
                                            }
                                            break;
                                        case 12:
                                            if ($fitmonth > 0) {
                                                $fitdec = $fitmonth;
                                            } else {
                                                $fitdec = $zero;
                                            }
                                            break;
                                        default:
                                    }
                                }

                                //////////////////////// DATA OF HAJJ AND UMRAH FOR BAR GRAPH /////////////////////////
                                $month = $january = $february = $march = $april = $may = $june = $july = $august = $september = $october = $november = $december = 0;
                                for ($i = 1; $i <= 12; $i++) {
                                    $getmonth = mysqli_query($conn, "SELECT SUM(netamt) AS amt FROM bookform WHERE MONTH(vouchdt) = '$i' AND YEAR(vouchdt) = 2024") or die(mysqli_error($conn));
                                    // print table($getmonth);
                                    $fetmonth = mysqli_fetch_array($getmonth);
                                    $month = $fetmonth['amt'];
                                    $zero = 0;
                                    switch ($i) {
                                        case 1:
                                            if ($month > 0) {
                                                $january = $month;
                                            } else {
                                                $january = $zero;
                                            }
                                            break;

                                        case 2:
                                            if ($month > 0) {
                                                $february = $month;
                                            } else {
                                                $february = $zero;
                                            }
                                            break;

                                        case 3:
                                            if ($month > 0) {
                                                $march = $month;
                                            } else {
                                                $march = $zero;
                                            }
                                            break;
                                        case 4:
                                            if ($month > 0) {
                                                $april = $month;
                                            } else {
                                                $april = $zero;
                                            }
                                            break;
                                        case 5:
                                            if ($month > 0) {
                                                $may = $month;
                                            } else {
                                                $may = $zero;
                                            }
                                            break;
                                        case 6:
                                            if ($month > 0) {
                                                $june = $month;
                                            } else {
                                                $june = $zero;
                                            }
                                            break;
                                        case 7:
                                            if ($month > 0) {
                                                $july = $month;
                                            } else {
                                                $july = $zero;
                                            }
                                            break;
                                        case 8:
                                            if ($month > 0) {
                                                $august = $month;
                                            } else {
                                                $august = $zero;
                                            }
                                            break;
                                        case 9:
                                            if ($month > 0) {
                                                $september = $month;
                                            } else {
                                                $september = $zero;
                                            }
                                            break;
                                        case 10:
                                            if ($month > 0) {
                                                $october = $month;
                                            } else {
                                                $october = $zero;
                                            }
                                            break;
                                        case 11:
                                            if ($month > 0) {
                                                $november = $month;
                                            } else {
                                                $november = $zero;
                                            }
                                            break;
                                        case 12:
                                            if ($month > 0) {
                                                $december = $month;
                                            } else {
                                                $december = $zero;
                                            }
                                            break;
                                        default:
                                    }
                                }


                                ?>

                                <script>
                                    // HAJJ UMRAH DATA
                                    var January = <?= $january; ?>,
                                        February = <?= $february; ?>,
                                        March = <?= $march; ?>,
                                        April = <?= $april; ?>,
                                        May = <?= $may; ?>,
                                        June = <?= $june; ?>,
                                        July = <?= $july; ?>,
                                        August = <?= $august; ?>,
                                        September = <?= $september; ?>,
                                        October = <?= $october; ?>,
                                        November = <?= $november; ?>,
                                        December = <?= $december; ?>;
                                    // FIT DATA    
                                    var fitjan = <?= $fitjan; ?>,
                                        fitfeb = <?= $fitfeb; ?>,
                                        fitmarch = <?= $fitmarch; ?>,
                                        fitapril = <?= $fitapril; ?>,
                                        fitmay = <?= $fitmay; ?>,
                                        fitjune = <?= $fitjune; ?>,
                                        fitjuly = <?= $fitjuly; ?>,
                                        fitaug = <?= $fitaug; ?>,
                                        fitsept = <?= $fitsept; ?>,
                                        fitoct = <?= $fitoct; ?>,
                                        fitnov = <?= $fitnov; ?>,
                                        fitdec = <?= $fitdec; ?>;

                                    const ctx = document.getElementById('myChart').getContext('2d');
                                    new Chart(ctx, {
                                        type: 'bar',
                                        data: {
                                            labels: ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"],
                                            datasets: [{
                                                label: 'FIT',
                                                data: [fitjan, fitfeb, fitmarch, fitapril, fitmay, fitjune, fitjuly, fitaug, fitsept, fitoct, fitnov, fitdec],
                                                backgroundColor: 'rgba(255, 99, 132, 0.2)',
                                                borderColor: 'rgba(255, 99, 132, 1)',
                                                borderWidth: 1.5
                                            },
                                            {
                                                label: 'Hajj / Umrah',
                                                data: [January, February, March, April, May, June, July, August, September, October, November, December],
                                                backgroundColor: 'rgba(54, 162, 235, 0.2)',
                                                borderColor: 'rgba(54, 162, 235, 1)',
                                                borderWidth: 1.5
                                            }
                                            ]
                                        },
                                        options: {
                                            plugins: {
                                                legend: {
                                                    display: true,
                                                    labels: {
                                                        color: 'black',
                                                        font: {
                                                            size: 14
                                                        }
                                                    }
                                                },
                                                tooltip: {
                                                    callbacks: {
                                                        label: function (context) {
                                                            return `${context.dataset.label}: $${context.raw}`;
                                                        }
                                                    }
                                                }
                                            },
                                            scales: {
                                                x: {
                                                    ticks: {
                                                        color: 'blue',
                                                        font: {
                                                            size: 16
                                                        }
                                                    },
                                                    title: {
                                                        display: true,
                                                        text: 'Months',
                                                        color: 'blue',
                                                        font: {
                                                            size: 18
                                                        }
                                                    },
                                                    stacked: false // Bars will be displayed side by side
                                                },
                                                y: {
                                                    ticks: {
                                                        color: 'green',
                                                        font: {
                                                            size: 14
                                                        },
                                                        stepSize: 500000, // Controls the interval between grid lines
                                                        callback: function (value) {
                                                            return `$${value}`; // Adds a $ sign before each tick value
                                                        }
                                                    },
                                                    min: 0, // Sets the minimum value on the Y-axis
                                                    max: 5000000, // Sets the maximum value on the Y-axis
                                                    title: {
                                                        display: true,
                                                        text: 'Revenue (USD)',
                                                        color: 'green',
                                                        font: {
                                                            size: 18
                                                        }
                                                    }
                                                }
                                            }
                                        }
                                    });
                                </script>

                            </div>
                        </div>
                    </div>
                </div>



                <div class="col-lg-6 col-md-6 mb-md-0 mb-4">
                    <div class="card" style="border: 1px solid #008000;">
                        <div class="card-header pb-0">
                            <div class="row">
                                <div class="col-lg-6 col-7">
                                    <h6>Today's Booking</h6>
                                </div>
                                <div class="col-lg-6 col-7 select">
                                </div>
                                <hr style="border-bottom: 1px solid black;">
                            </div>
                        </div>
                        <div class="card-body px-0 pb-2 ">
                            <div class="table-responsive chart-container">
                                <div class="d-flex justify-content-center">
                                    <div>
                                        <!-- CODE TO EXECUTE -->
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>



                </div>
            </div>
    </main>

    <script>
        var win = navigator.platform.indexOf('Win') > -1;
        if (win && document.querySelector('#sidenav-scrollbar')) {
            var options = {
                damping: '0.5'
            }
            Scrollbar.init(document.querySelector('#sidenav-scrollbar'), options);
        }
    </script>
</body>

</html>