MMCT TEAM
Server IP : 82.112.239.40  /  Your IP : 18.218.129.191
Web Server : LiteSpeed
System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.35.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 4 05:23:43 EDT 2025 x86_64
User : u641149403 ( 641149403)
PHP Version : 7.4.33
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0755) :  /home/u641149403/domains/cabz4you.com/public_html/admin/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/u641149403/domains/cabz4you.com/public_html/admin/index.php
<?php
require_once 'header.php';
require_once 'navbar.php';
require_once 'index_query.php';
?>
<style>
    .raju  {
        margin-left: 120px;
        font-size: 40px !important;
    }
/*.text-xxl  {
    display: flex;
}
*/
    .card-body small  {
        font-size: 18px;
        font-weight: 600;
    /* color: black;
    */
    }
    .ttl_b {
        color: #00b3ff;
        border-color: #00b3ff;
        background-color: transparent;
        background-image: none;
    /*pointer-events: none;
    */
    }
    .card {
        border: 0!important;
    }
   
    .btn-outline-info {
        color: #232325!important;
        border-color: #232325!important;
    }
    .btn-outline-primary {
        color: #232325!important;
        border-color: #232325!important;
    }
    #map  {
        height: 500px;
        width: 100%;
    }
    .dash_text {
        font-weight: bold;
    }
    .socailicons img {
        width: 70px;
        margin-left: 110px;
    }
    .card-body {
        padding: 0.875rem!important;
    }
/*================================*/
#dash .col-xl-3,#dash .col-lg-6{
    margin-bottom: 30px;
}
#dash .card  {
    box-shadow: 0 4px 6px -1px rgb(0 0 0 / 10%), 0 2px 4px -1px rgb(0 0 0 / 6%);
    height: 100%;
}
#dash .card a,#dash .card .card-body{
    height: 100%;
}
/*#dash .card .card-body{
    padding: 0 0.875rem!important;
}*/
#dash p,#dash h2{
    color: #000;
    text-transform: uppercase;
    font-weight: 600;
    font-family: sans-serif;
}
.card-header:first-child  {
    border-radius: 0.75rem 0.75rem 0 0;
}
.border-radius-xl  {
    border-radius: 0.75rem;
}
.icon-lg  {
    width: 64px;
    height: 64px;
}
.bg-gradient-white  {
    background-image: linear-gradient(195deg, #42424a 0%, #191919 100%);
}
.shadow-dark  {
    box-shadow: 0 4px 20px 0 rgb(0 0 0 / 14%), 0 7px 10px -5px rgb(64 64 64 / 40%) !important;
}
.material-icons  {
    font-family: 'Material Icons Round';
    font-weight: normal;
    font-style: normal;
    font-size: 20px;
    display: inline-block;
    line-height: 1;
    text-transform: none;
    letter-spacing: normal;
    word-wrap: normal;
    white-space: nowrap;
    direction: ltr;
    -webkit-font-smoothing: antialiased;
    text-rendering: optimizeLegibility;
    -moz-osx-font-smoothing: grayscale;
    font-feature-settings: 'liga';
}
hr.horizontal.dark  {
    background-color: #7b809a33;
}
.card .card-footer  {
    padding: 1.5rem;
    background-color: transparent;
}
.card-footer:last-child  {
    border-radius: 0 0 0.75rem 0.75rem;
}
.text-sm  {
    font-size: 0.875rem !important;
}
.text-sm  {
    line-height: 1.5;
}
.card > hr  {
    margin-right: 0;
    margin-left: 0;
}
.card .card-footer  {
    padding: 1.5rem;
    background-color: transparent;
}
.card-footer:last-child  {
    border-radius: 0 0 0.75rem 0.75rem;
}
.card-footer  {
    padding: 0.5rem 1rem;
    background-color: #fff;
    border-top: 0 solid rgba(0, 0, 0, 0.125);
}
.mt-n4  {
    margin-top: -1.5rem !important;
    margin-left: -10px;
}
#flaticon_img {
    width: 47px;
}
.text-end  {
    text-align: right !important;
}
#dash .card-footer p {
    line-height: 22px;
    color: #999999;
    font-size: 12px;
}

.bg-gradient-secondary {
    background: linear-gradient(to right, #a032ed, #bc65fa);
}
.ecommerce-icon img{
    width: 50px;
    position: relative;
    top: -9px;
    left: -10px;
}
.ecommerce-icon {
    position: relative;
    display: inline-block;
    width: 5rem;
    height: 5rem;
    vertical-align: middle;
    border-radius: 50px;
    border: 3px solid rgba(255, 255, 255, 0.2);
    padding: 22px;
}
.img-card .img-card-circle {
    position: absolute;
    top: 0;
    margin-right: -38px;
    text-align: right;
    right: 0;
    opacity: 0.6;
    height: 100%;
}
.bg-gradient-success {
    background-image: linear-gradient(to right, #028758, #1bb26f);
}
.bg-gradient-danger {
    background-image: linear-gradient(to right, #f4401b, #ec9c67);
}
.bg-gradient-info {
    background-image: linear-gradient(to right, #354cf0, #88b7ed);
}
.font-weight-semibold{
    position: relative;
    left: 0px;
    text-align: right;
}
#dash .card,#chart-section .card{
    margin-bottom: 30px;
    border: 3px solid #000!important;
}
#dash .card .d-flex{
    justify-content: space-between;
    height: 100%;
    align-items: center;
}
#dash,#chart-section{
    padding: 10px 20px;
    padding-left: 30px;
}

.text-red {
    color: #ff0000 !important;
}
.text-success {
    color: #28a745 !important;
}
.text-info {
    color: #17a2b8!important;
}
#dash .card h5{
    position: absolute;
    color: #000;
    font-weight: bold;
    top: 0;
    right: 15px;
    font-size: 16px;
    font-family: sans-serif;
}

#chart-section .col-lg-6{
    margin-bottom: 30px;
}
#chart-section .card  {
    box-shadow: 0 4px 6px -1px rgb(0 0 0 / 10%), 0 2px 4px -1px rgb(0 0 0 / 6%);
    height: 100%;
}
#chart-section .card a,#chart-section .card .card-body{
    height: 100%;
}
</style>
<div class="container-fluid pt-8"></div>
<div class="row my-3" id="dash">
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="list_booking?type=profit">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/profit.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Profit</p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $total_profit['total_profit']; ?></h2> 
                            <h5><?=$total_profit['total_profit_booking'];?></h5>
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>
    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="list_booking?type=loss">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/loss.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Loss </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right">
                                <?php if(!empty($total_loss['total_loss'])){ 
                                    echo $total_loss['total_loss'];
                                }else{
                                    echo 0;
                                }
                                ?>
                                </h2> 
                                <h5><?=$total_loss['total_loss_booking'];?></h5>
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>
    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="recent_search_booking">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/recent.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Recent Booking </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $recent_booking->num_rows; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>
    </div>

    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="vendor">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/team.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Vendors </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $vendor['vendors']; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>

    </div>

    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="other_vendor">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/team.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Other Vendors </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $other_vendor->num_rows; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>

    </div>

    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="other_customers">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/customers.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Other Customers </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $other_user->num_rows; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>

    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="cabs_list">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/cabs.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Cabs </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $cabs['cabs']; ?></h2> 
                        </div> 
                    </div> 
                </div> 
                <img src="images/circle.png" alt="img" class="img-card-circle">
            </a> 
        </div>

    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="drivers">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/driver.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Drivers </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $drivers['drivers']; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>
    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="customers">
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/customers.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Customers </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $users['users']; ?></h2> 
                        </div> 
                    </div> 
                </div> 
                <img src="images/circle.png" alt="img" class="img-card-circle">
            </a> 
        </div>

    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden">
            <a href="list_booking.php?type=all"> 
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/all.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Booking </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $one['total_booking']; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>


    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden">
            <a href="list_booking.php?type=pending">  
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/expired.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Pending Booking </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $pending['total_booking']; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>

    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="list_booking.php?type=processing"> 
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-1"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/hourglass.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14 title"> Processing Booking </p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $processing['total_booking']; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>

    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="list_booking.php?type=completed"> 
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/check.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Complete Booking</p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $done['total_booking']; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>

    </div>

    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="list_booking.php?type=vendor_pass"> 
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/expired.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Not Assigned Booking</p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?=$not_assigned_booking->num_rows?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>

    </div>

    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="list_booking.php?type=expired"> 
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/expired-booking.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Expired Assigned Booking</p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?php echo $expired_assigned_booking->num_rows;?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>

    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden">
            <a href="list_booking.php?type=cancelled">  
                <div class="card-body"> 
                    <div class="d-flex"> 
                        <div class="mr-2"> 
                            <div class="ecommerce-icon"> 
                                <img src="images/flaticon/cancelled.png" alt="img"> 
                            </div> 
                        </div> 
                        <div class="text-white mt-3"> 
                            <p class="mb-1 font-weight-semibold fs-14"> Total Cancelled Booking</p>
                            <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $cancel; ?></h2> 
                        </div> 
                    </div> 
                </div> 
            </a>
        </div>


    </div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="vendor?type=wallet">
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/money.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14"> Vendor Wallet Amount</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?=$wallet_vendor['amounts']?></h2> 
                        <h5><?=$wallet_vendor['vendors']?></h5>
                </div> 
            </div> 
        </div>
        </a> 
        
    </div>

</div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="vendor?type=minus wallet">
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/money.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14"> Minus Wallet Vendor Amount</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $minus_wallet['wallet']; ?></h2> 
                        <h5><?=$minus_wallet['minus_vendor']?></h5>
                </div> 
            </div> 
        </div> 
    </a>
        
    </div>
</div>
    <div class="col-xl-3 col-sm-6">
        <div class="card bg-gradient-white img-card overflow-hidden"> 
            <a href="vendor?type=null">
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/money.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14"> Zero Wallet Vendor Amount</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $zero_wallet['zero_vendor']; ?></h2> 
                </div> 
            </div> 
        </div> 
    </a>
        
    </div>
</div>

<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="list_booking.php?type=new"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/new.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14"> Total New <br>Booking</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $new_booking['new_booking'];?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>

<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="prime_vendor"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/members.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14"> Total Membership <br>Vendor</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $membership;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="not_attached.php?type=driver"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/driver.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14"> Total Driver <br>Not Attached</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $not_attached_driver->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="not_attached.php?type=cab"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/cabs.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14"> Total Cab <br>Not Attached</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $not_attached_cab->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="not_attached.php?type=both"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/license.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14"> Total Driver & Cab Not Attached</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $not_attached_driver_cab->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>

<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="verify_vendor"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/team.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total Pending Vendor</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $pending_vendor->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="vendors?type=Active"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/team.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total Active Vendor</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $active_vendor->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="vendors?type=Inactive"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/team.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total In-active Vendor</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $inactive_vendor->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="prime_vendor?type=active"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/members.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total Active Prime Vendor</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $active_prime_vendor->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="prime_vendor?type=expired"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/members.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total Expired Prime Vendor</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $expired_prime_vendor->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="prime_vendor?type=not"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/members.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total Not Prime Vendor</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $not_prime_vendor->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="available-cabs"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/cabs.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total Available Cabs</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $available_cabs->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="prime_vendor?type=renewal"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/members.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total Renewal Prime Vendor</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $renewel_prime_vendor->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="vendor_app_version.php"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/app_update.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total App Update</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $vendor_app_updated->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
<div class="col-xl-3 col-sm-6">
    <div class="card bg-gradient-white img-card overflow-hidden"> 
        <a href="vendor_app_not_updated.php"> 
            <div class="card-body"> 
                <div class="d-flex"> 
                    <div class="mr-2"> 
                        <div class="ecommerce-icon"> 
                            <img src="images/flaticon/app_update.png" alt="img"> 
                        </div> 
                    </div> 
                    <div class="text-white mt-3"> 
                        <p class="mb-1 font-weight-semibold fs-14">Total App Not Updated</p>
                        <h2 class="mt-1 mb-0 fs-30 font-weight-bold text-right"><?= $vendor_app_not_updated->num_rows;?></h2> 
                    </div> 
                </div> 
            </div> 
            
        </a>
    </div>
</div>
</div>
<div class="row" id="chart-section">
<div class="col-lg-6">
    <div class="card">
        <div class="card-header">
            <h2 class="card-title mb-0">Memebership</h2>
        </div>
        <div class="card-header border-transparent">
            <div class="card-body">
                <div class="d-flex">
                    <p class="d-flex flex-column">
                    </p>
                    <p class="ml-auto d-flex flex-column text-right">
                        <span class="text-success">
                        </span>
                    </p>
                </div>
                <div class="position-relative mb-4">
                    <div class="chartjs-size-monitor">
                        <div class="chartjs-size-monitor-expand">
                            <div class=""></div>
                        </div>
                        <div class="chartjs-size-monitor-shrink">
                            <div class=""></div>
                        </div>
                    </div>
                    <canvas id="ie-chart" height="200" width="487" class="chartjs-render-monitor" style="display: block; width: 487px; height: 200px;"></canvas>
                </div>
                <div class="d-flex flex-row justify-content-end">
                    <span class="mr-2">
                        <i class="fas fa-square text-info"></i> Membership
                    </span>
                    <span class="mr-2">
                        <i class="fas fa-square text-success"></i> Membership Amount
                    </span>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="col-lg-6">
    <div class="card">
        <div class="card-header">
            <h2 class="card-title mb-0">Vendor</h2>
        </div>
        <div class="card-header border-transparent">
            <div class="card-body">
                <div class="d-flex">
                    <p class="d-flex flex-column">
                    </p>
                    <p class="ml-auto d-flex flex-column text-right">
                        <span class="text-success">
                        </span>
                    </p>
                </div>
                <div class="position-relative mb-4">
                    <div class="chartjs-size-monitor">
                        <div class="chartjs-size-monitor-expand">
                            <div class=""></div>
                        </div>
                        <div class="chartjs-size-monitor-shrink">
                            <div class=""></div>
                        </div>
                    </div>
                    <canvas id="vendor-chart" height="200" width="487" class="chartjs-render-monitor" style="display: block; width: 487px; height: 200px;"></canvas>
                </div>
                <div class="d-flex flex-row justify-content-end">
                    <span class="mr-2">
                        <i class="fas fa-square text-success"></i> Active Vendor
                    </span>
                    <span class="mr-2">
                        <i class="fas fa-square text-red"></i> In Active Vendor
                    </span>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="col-lg-6">
    <div class="card">
        <div class="card-header">
            <h2 class="card-title mb-0">Vendor Wallet</h2>
        </div>
        <div class="card-header border-transparent">
            <div class="card-body">
                <div class="d-flex">
                    <p class="d-flex flex-column">
                    </p>
                    <p class="ml-auto d-flex flex-column text-right">
                        <span class="text-success">
                        </span>
                    </p>
                </div>
                <div class="position-relative mb-4">
                    <div class="chartjs-size-monitor">
                        <div class="chartjs-size-monitor-expand">
                            <div class=""></div>
                        </div>
                        <div class="chartjs-size-monitor-shrink">
                            <div class=""></div>
                        </div>
                    </div>
                    <canvas id="vendor-wallet-chart" height="200" width="487" class="chartjs-render-monitor" style="display: block; width: 487px; height: 200px;"></canvas>
                </div>
                <div class="d-flex flex-row justify-content-end">
                    <span class="mr-2">
                        <i class="fas fa-square text-success"></i> Add Amount
                    </span>
                    <span class="mr-2">
                        <i class="fas fa-square text-red"></i> Refund Amount
                    </span>
                </div>
            </div>
        </div>
    </div>
</div>


<div class="col-lg-6">
    <div class="card">
        <div class="card-header">
            <h2 class="card-title mb-0">Created Bookings</h2>
        </div>
        <div class="card-header border-transparent">
            <div class="card-body">
                <div class="d-flex">
                    <p class="d-flex flex-column">
                    </p>
                    <p class="ml-auto d-flex flex-column text-right">
                        <span class="text-success">
                        </span>
                    </p>
                </div>
                <div class="position-relative mb-4">
                    <div class="chartjs-size-monitor">
                        <div class="chartjs-size-monitor-expand">
                            <div class=""></div>
                        </div>
                        <div class="chartjs-size-monitor-shrink">
                            <div class=""></div>
                        </div>
                    </div>
                    <canvas id="pending-booking-chart" height="200" width="487" class="chartjs-render-monitor" style="display: block; width: 487px; height: 200px;"></canvas>
                </div>
                <div class="d-flex flex-row justify-content-end">
                    <span class="mr-2">
                        <i class="fas fa-square text-warning"></i> Vendor Booking
                    </span>
                    <span class="mr-2">
                        <i class="fas fa-square text-info"></i> Admin Booking
                    </span>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="col-lg-6">
    <div class="card">
        <div class="card-header">
            <h2 class="card-title mb-0">Processing Bookings</h2>
        </div>
        <div class="card-header border-transparent">
            <div class="card-body">
                <div class="d-flex">
                    <p class="d-flex flex-column">
                    </p>
                    <p class="ml-auto d-flex flex-column text-right">
                        <span class="text-success">
                        </span>
                    </p>
                </div>
                <div class="position-relative mb-4">
                    <div class="chartjs-size-monitor">
                        <div class="chartjs-size-monitor-expand">
                            <div class=""></div>
                        </div>
                        <div class="chartjs-size-monitor-shrink">
                            <div class=""></div>
                        </div>
                    </div>
                    <canvas id="processing-booking-chart" height="200" width="487" class="chartjs-render-monitor" style="display: block; width: 487px; height: 200px;"></canvas>
                </div>
                <div class="d-flex flex-row justify-content-end">
                    <span class="mr-2">
                        <i class="fas fa-square text-success"></i> Vendor Booking
                    </span>
                    <span class="mr-2">
                        <i class="fas fa-square text-info"></i> Admin Booking
                    </span>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="col-lg-6">
    <div class="card">
        <div class="card-header">
            <h2 class="card-title mb-0">Confirmed Bookings</h2>
        </div>
        <div class="card-header border-transparent">
            <div class="card-body">
                <div class="d-flex">
                    <p class="d-flex flex-column">
                    </p>
                    <p class="ml-auto d-flex flex-column text-right">
                        <span class="text-success">
                        </span>
                    </p>
                </div>
                <div class="position-relative mb-4">
                    <div class="chartjs-size-monitor">
                        <div class="chartjs-size-monitor-expand">
                            <div class=""></div>
                        </div>
                        <div class="chartjs-size-monitor-shrink">
                            <div class=""></div>
                        </div>
                    </div>
                    <canvas id="confirmed-booking-chart" height="200" width="487" class="chartjs-render-monitor" style="display: block; width: 487px; height: 200px;"></canvas>
                </div>
                <div class="d-flex flex-row justify-content-end">
                    <span class="mr-2">
                        <i class="fas fa-square text-success"></i> Vendor Booking
                    </span>
                    <span class="mr-2">
                        <i class="fas fa-square text-info"></i> Admin Booking
                    </span>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="col-lg-6">
    <div class="card">
        <div class="card-header">
            <h2 class="card-title mb-0">Completed Bookings</h2>
        </div>
        <div class="card-header border-transparent">
            <div class="card-body">
                <div class="d-flex">
                    <p class="d-flex flex-column">
                    </p>
                    <p class="ml-auto d-flex flex-column text-right">
                        <span class="text-success">
                        </span>
                    </p>
                </div>
                <div class="position-relative mb-4">
                    <div class="chartjs-size-monitor">
                        <div class="chartjs-size-monitor-expand">
                            <div class=""></div>
                        </div>
                        <div class="chartjs-size-monitor-shrink">
                            <div class=""></div>
                        </div>
                    </div>
                    <canvas id="completed-booking-chart" height="200" width="487" class="chartjs-render-monitor" style="display: block; width: 487px; height: 200px;"></canvas>
                </div>
                <div class="d-flex flex-row justify-content-end">
                    <span class="mr-2">
                        <i class="fas fa-square text-success"></i> Vendor Booking
                    </span>
                    <span class="mr-2">
                        <i class="fas fa-square text-info"></i> Admin Booking
                    </span>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="col-lg-6">
    <div class="card">
        <div class="card-header">
            <h2 class="card-title mb-0">Cancelled Bookings</h2>
        </div>
        <div class="card-header border-transparent">
            <div class="card-body">
                <div class="d-flex">
                    <p class="d-flex flex-column">
                    </p>
                    <p class="ml-auto d-flex flex-column text-right">
                        <span class="text-success">
                        </span>
                    </p>
                </div>
                <div class="position-relative mb-4">
                    <div class="chartjs-size-monitor">
                        <div class="chartjs-size-monitor-expand">
                            <div class=""></div>
                        </div>
                        <div class="chartjs-size-monitor-shrink">
                            <div class=""></div>
                        </div>
                    </div>
                    <canvas id="cancelled-booking-chart" height="200" width="487" class="chartjs-render-monitor" style="display: block; width: 487px; height: 200px;"></canvas>
                </div>
                <div class="d-flex flex-row justify-content-end">
                    <span class="mr-2">
                        <i class="fas fa-square text-red"></i> Vendor Booking
                    </span>
                    <span class="mr-2">
                        <i class="fas fa-square text-primary"></i> Admin Booking
                    </span>
                </div>
            </div>
        </div>
    </div>
</div>
</div>

<?php
require_once 'footer.php';
require_once 'jslinks.php';
?>
<script src="assets/js/chart.min.js"></script>

<script>
    var ticksStyle = {
        fontColor: '#495057',
        fontStyle: 'bold'
    }
    var mode      = 'index';
    var intersect = true;
    var $visitorsChart = $('#ie-chart')
    var visitorsChart  = new Chart($visitorsChart, {
        data   : {
            labels : <?= "['" . implode ( "', '", $sevenDays) . "']" ?>,
            datasets: [{
                type                : 'line',
                data                : <?= "['" . implode ( "', '", $membership_date). "']" ?>,
                backgroundColor     : 'transparent',
                borderColor         : '#17a2b8',
                pointBorderColor    : '#17a2b8',
                pointBackgroundColor: '#17a2b8',
                fill                : false
        // pointHoverBackgroundColor: '#007bff',
        // pointHoverBorderColor    : '#007bff'
            },
            {
                type                : 'line',
                data                : <?= "['" . implode ( "', '", $membership_total_amount). "']" ?>,
                backgroundColor     : 'tansparent',
                borderColor         : '#28a745',
                pointBorderColor    : '#28a745',
                pointBackgroundColor: '#28a745',
                fill                : false
          // pointHoverBackgroundColor: '#ced4da',
          // pointHoverBorderColor    : '#ced4da'
            }]
        },
        options: {
            maintainAspectRatio: false,
            tooltips           : {
                mode     : mode,
                intersect: false
            },
            hover              : {
                mode     : 'nearest',
                intersect: false
            },
            legend             : {
                display: false
            },
            scales: {
                xAxes: [{
                        // display: true,
                        // scaleLabel: {
                        //  display: true,
                        // }
                }],
                yAxes: [{
                        // display: true,
                        // scaleLabel: {
                        //  display: true,
                        // },

                }]
            }
        }
    })


    // VENDOR CHART
    var ticksStyle = {
        fontColor: '#495057',
        fontStyle: 'bold'
    }

    var mode      = 'index';
    var intersect = true;
    var $visitorsChart = $('#vendor-chart')
    var visitorsChart  = new Chart($visitorsChart, {
        data   : {
            labels : <?= "['" . implode ( "', '", $sevenDays) . "']" ?>,
            datasets: [{
                type                : 'bar',
                data                : <?= "['" . implode ( "', '", $vendor_date). "']" ?>,
                backgroundColor     : '#28a745',
            },
            {
                type                : 'bar',
                data                : <?= "['" . implode ( "', '", $vendor_date2). "']" ?>,
                backgroundColor     : '#ff0000',
            }]
        },
        options: {
            tooltips           : {
                mode     : mode,
                intersect: false
            },
            hover              : {
                mode     : mode,
                intersect: false
            },
            legend             : {
                display: false
            },
            scales             : {
                yAxes: [{
          // display: false,
                    gridLines: {
                        offsetGridLines: true,
                    },
                }],
                xAxes: [{
                    offset: true,
                    gridLines: {
                        offsetGridLines: true,
                    },
                    ticks    : ticksStyle
                }]
            }
        }
    })


    // VENDOR WALLET CHART
    var ticksStyle = {
        fontColor: '#495057',
        fontStyle: 'bold'
    }

    var mode      = 'index';
    var intersect = true;
    var $visitorsChart = $('#vendor-wallet-chart')
    var visitorsChart  = new Chart($visitorsChart, {
        data   : {
            labels : <?= "['" . implode ( "', '", $sevenDays) . "']" ?>,
            datasets: [{
                type                : 'bar',
                label: "Vendor Wallet",
                data                : <?= "['" . implode ( "', '", $vendor_wallet_amounts). "']" ?>,
                backgroundColor     : '#28a745',
            },
            {
                type : 'bar',
                label: "Vendor Wallet",
                data                : <?= "['" . implode ( "', '", $refund_wallet_amounts). "']" ?>,
                backgroundColor     : '#ff0000',
            }]
        },
        options: {
            tooltips           : {
                mode     : mode,
                intersect: false
            },
            hover              : {
                mode     : mode,
                intersect: false
            },
            legend             : {
                display: false,
            },
            scales             : {
                yAxes: [{
          // display: false,
                    gridLines: {
                        offsetGridLines: true,
                    },
                }],
                xAxes: [{
                    offset: true,
                    gridLines: {
                        offsetGridLines: true,
                    },
                    ticks    : ticksStyle
                }]
            }
        }
    })


// PENDING BOOKING
    var $visitorsChart = $('#pending-booking-chart')
    var visitorsChart  = new Chart($visitorsChart, {
        data   : {
            labels : <?= "['" . implode ( "', '", $sevenDays) . "']" ?>,
            datasets: [{
                type                : 'bar',
                label: "Vendor Booking",
                data                : <?= "['" . implode ( "', '", $created_booking_vendor). "']" ?>,
                backgroundColor     : '#f94920',
            },
            {
                type                : 'bar',
                label: "Admin Booking",
                data                : <?= "['" . implode ( "', '", $created_booking_admin). "']" ?>,
                backgroundColor     : '#17a2b8',
            }]
        },
        options: {
            tooltips           : {
                mode     : mode,
                intersect: false
            },
            hover              : {
                mode     : mode,
                intersect: false
            },
            legend             : {
                display: false
            },
            scales             : {
                yAxes: [{
          // display: false,
                    gridLines: {
                        offsetGridLines: true,
                    },
                }],
                xAxes: [{
                    offset: true,
                    gridLines: {
                        offsetGridLines: true,
                    },
                    ticks    : ticksStyle
                }]
            }
        }
    })

// PROCESSING BOOKING
    var $visitorsChart = $('#processing-booking-chart')
    var visitorsChart  = new Chart($visitorsChart, {
        data   : {
            labels : <?= "['" . implode ( "', '", $sevenDays) . "']" ?>,
            datasets: [{
                type                : 'bar',
                label: "Vendor Booking",
                data                : <?= "['" . implode ( "', '", $processing_booking_vendor). "']" ?>,
                backgroundColor     : '#28a745',
            },
            {
                type                : 'bar',
                label: "Admin Booking",
                data                : <?= "['" . implode ( "', '", $processing_booking_admin). "']" ?>,
                backgroundColor     : '#17a2b8',
            }]
        },
        options: {
            tooltips           : {
                mode     : mode,
                intersect: false
            },
            hover              : {
                mode     : mode,
                intersect: false
            },
            legend             : {
                display: false
            },
            scales             : {
                yAxes: [{
          // display: false,
                    gridLines: {
                        offsetGridLines: true,
                    },
                }],
                xAxes: [{
                    offset: true,
                    gridLines: {
                        offsetGridLines: true,
                    },
                    ticks    : ticksStyle
                }]
            }
        }
    })

// CONFIRMED BOOKING
    var $visitorsChart = $('#confirmed-booking-chart')
    var visitorsChart  = new Chart($visitorsChart, {
        data   : {
            labels : <?= "['" . implode ( "', '", $sevenDays) . "']" ?>,
            datasets: [{
                type                : 'bar',
                label: "Vendor Booking",
                data                : <?= "['" . implode ( "', '", $confirmed_booking_vendor). "']" ?>,
                backgroundColor     : '#28a745',
            },
            {
                type                : 'bar',
                label: "Admin Booking",
                data                : <?= "['" . implode ( "', '", $confirmed_booking_admin). "']" ?>,
                backgroundColor     : '#17a2b8',
            }]
        },
        options: {
            tooltips           : {
                mode     : mode,
                intersect: false
            },
            hover              : {
                mode     : mode,
                intersect: false
            },
            legend             : {
                display: false
            },
            scales             : {
                yAxes: [{
          // display: false,
                    gridLines: {
                        offsetGridLines: true,
                    },
                }],
                xAxes: [{
                    offset: true,
                    gridLines: {
                        offsetGridLines: true,
                    },
                    ticks    : ticksStyle
                }]
            }
        }
    })

// COMPLETED BOOKING
    var $visitorsChart = $('#completed-booking-chart')
    var visitorsChart  = new Chart($visitorsChart, {
        data   : {
            labels : <?= "['" . implode ( "', '", $sevenDays) . "']" ?>,
            datasets: [{
                type                : 'bar',
                label: "Vendor Booking",
                data                : <?= "['" . implode ( "', '", $completed_booking_vendor). "']" ?>,
                backgroundColor     : '#28a745',
            },
            {
                type                : 'bar',
                label: "Admin Booking",
                data                : <?= "['" . implode ( "', '", $completed_booking_admin). "']" ?>,
                backgroundColor     : '#17a2b8',
            }]
        },
        options: {
            tooltips           : {
                mode     : mode,
                intersect: false
            },
            hover              : {
                mode     : mode,
                intersect: false
            },
            legend             : {
                display: false
            },
            scales             : {
                yAxes: [{
          // display: false,
                    gridLines: {
                        offsetGridLines: true,
                    },
                }],
                xAxes: [{
                    offset: true,
                    gridLines: {
                        offsetGridLines: true,
                    },
                    ticks    : ticksStyle
                }]
            }
        }
    })

// CANCELED BOOKING
    var $visitorsChart = $('#cancelled-booking-chart')
    var visitorsChart  = new Chart($visitorsChart, {
        data   : {
            labels : <?= "['" . implode ( "', '", $sevenDays) . "']" ?>,
            datasets: [{
                type                : 'bar',
                label: "Vendor Booking",
                data                : <?= "['" . implode ( "', '", $cancelled_booking_vendor). "']" ?>,
                backgroundColor     : '#ff0000',
            },
            {
                type                : 'bar',
                label: "Admin Booking",
                data                : <?= "['" . implode ( "', '", $cancelled_booking_admin). "']" ?>,
                backgroundColor     : '#00b3ff',
            }]
        },
        options: {
            tooltips           : {
                mode     : mode,
                intersect: false
            },
            hover              : {
                mode     : mode,
                intersect: false
            },
            legend             : {
                display: false
            },
            scales             : {
                yAxes: [{
          // display: false,
                    gridLines: {
                        offsetGridLines: true,
                    },
                }],
                xAxes: [{
                    offset: true,
                    gridLines: {
                        offsetGridLines: true,
                    },
                    ticks    : ticksStyle
                }]
            }
        }
    })
</script>

MMCT - 2023