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 ] |
---|
<?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>