File "dashboard.php"

Full Path: /home/sasslijg/public_html/admin/users/dashboard.php
File size: 7.9 KB
MIME-type: text/x-php
Charset: utf-8

<?php
include("header.php");

$status = "";
if(isset($_GET['status']))
{
    $status = $_GET['status'];
}
?>

<script type="text/javascript">

    var status = "<?php echo $status; ?>";
    if(status==1)
    {
        swal({
            title: "Congratulations!",
            text: "You Successfully Login ",
            //   text: "Please Complete 2nd Step !",

            timer: 3000,
            showConfirmButton: true
            showConfirmButton: true
        });
    }

</script>

<section >

    <div class="row match-height">

        <!-- Greetings Card starts -->
        <div class="col-lg-12 col-md-12 col-sm-12">
            <div class="card card-congratulations">
                <div class="card-body text-center">
                    <img
                         src="app-assets/images/elements/decore-left.png"
                         class="congratulations-img-left"
                         alt="card-img-left"
                         />
                    <img
                         src="app-assets/images/elements/decore-right.png"
                         class="congratulations-img-right"
                         alt="card-img-right"
                         />
                    <div class="avatar avatar-xl bg-primary shadow">
                        <div class="avatar-content">
                            <i class=" mdi mdi-trophy-award font-large-1 "></i>
                        </div>
                    </div>
                    <div class="text-center">
                        <h1 class="mb-1 text-white">Welcome <span class="text-uppercase">
<!--                            <?php echo $user_data['user_name'];?>-->
                            Admin
                            </span></h1>
                        <p class="card-text m-auto w-75">
                            <!--              You have done <strong>57.6%</strong> more sales today. Check your new badge in your profile.-->
                        </p>
                    </div>
                </div>
            </div>
        </div>
        <!-- Greetings Card ends -->
    </div>

    <?php


    $query = "SELECT * from product";
    $products = db::getRecords($query);
  
    $query = "SELECT * from rental";
    $rentals = db::getRecords($query);
  
    $query = "SELECT * from orders where payment_status='unpaid'";
    $pending_orders = db::getRecords($query);

    $query = "SELECT * from orders where payment_status='paid'";
    $paid_orders = db::getRecords($query);

    $query = "SELECT * from orders where payment_status='complete'";
    $completed_orders = db::getRecords($query);

    $query = "SELECT * from blog";
    $blogs = db::getRecords($query);

 

    if($products!=null)
    {        $products_size=sizeof($products);
    }
    else{
        $products_size=0;
    }
    if($rentals!=null)
    {       $rentals_size=sizeof($rentals);
    }
    else{
        $rentals_size=0;
    }
    if($blogs!=null)
    {
        $blogs_size=sizeof($blogs);
    }
    else{
        $blogs_size=0;
    }

    if($pending_orders!=null)
    {
        $pending_orders_size=sizeof($pending_orders);
    }
    else{
        $pending_orders_size=0;
    }

    if($paid_orders!=null)
    {
        $paid_orders_size=sizeof($paid_orders);
    }
    else{
        $paid_orders_size=0;
    }

    if($completed_orders!=null)
    {
        $completed_orders_size=sizeof($completed_orders);
    }
    else{
        $completed_orders_size=0;
    }

    ?>


    <!-- Stats Horizontal Card -->
    <div class="row my-3 ">
        <div class="col-sm-12 ">
            <div class="card bg-dark ">
                <div class="card-body text-center bg-light-info bg-darken-2 bg-gradient-info">
                    <h2 class="font-weight-bolder mb-0 text-center text-white">Statistics</h2>

                </div>
            </div>
        </div>
    </div>
    <!--/ Stats Horizontal Card -->

    
    <div class="row my-2 justify-content-center">

        <div class="col-xl-4 col-md-4 col-sm-6">
            <div class="card text-center bg-primary">
                <div class="card-body  ">
                    <div class="avatar bg-warning p-50 m-0">
                        <div class="avatar-content">
                            <i class="mdi mdi-cart-off font-medium-5"></i>
                        </div>
                    </div>
                    <h2 class="font-weight-bolder text-white mt-2"><?php echo $pending_orders_size;?></h2>
                    <h4 class="card-text text-white ">Pending Orders</h4>
                </div>
            </div>
        </div>

        <div class="col-xl-4 col-md-4 col-sm-6">
            <div class="card text-center bg-success bg-darken-1">
                <div class="card-body ">
                    <div class="avatar bg-success bg-darken-4 p-50 m-0">
                        <div class="avatar-content">
                            <i class="ion ion-md-cart  font-medium-5"></i>
                        </div>
                    </div>
                    <h2 class="font-weight-bolder text-white mt-2"><?php echo $paid_orders_size;?></h2>
                    <h4 class="card-text text-white ">Paid Orders</h4>

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

        <div class="col-xl-4 col-md-4 col-sm-6">
            <div class="card text-center bg-warning ">
                <div class="card-body ">
                    <div class="avatar bg-white text-primary p-50 m-0">
                        <div class="avatar-content">
                            <i class="fas fa-cart-arrow-down  font-medium-5"></i>
                        </div>
                    </div>
                    <h2 class="font-weight-bolder text-primary mt-2"><?php echo $completed_orders_size;?></h2>
                    <h4 class="card-text text-white ">Completed orders</h4>
                </div>
            </div>
        </div>

        <div class="col-xl-4 col-md-4 col-sm-6">
            <div class="card text-center bg-dark bg-darken-1">
                <div class="card-body ">
                    <div class="avatar bg-info p-50 m-0">
                        <div class="avatar-content">
                            <i class="bx bx-box font-medium-5"></i>
                        </div>
                    </div>
                    <h2 class="font-weight-bolder text-white mt-2"><?php echo $products_size;?></h2>
                    <h4 class="card-text text-white ">Total Products</h4>
                </div>
            </div>
        </div>
        <div class="col-xl-4 col-md-4 col-sm-6">
            <div class="card text-center bg-gradient-primary">
                <div class="card-body  ">
                    <div class="avatar bg-success p-50 m-0">
                        <div class="avatar-content">
                            <i class="bx bx-cast font-medium-5"></i>
                        </div>
                    </div>
                    <h2 class="font-weight-bolder text-white mt-2"><?php echo $blogs_size;?></h2>
                    <h4 class="card-text text-white ">Total Blogs</h4>
                </div>
            </div>
        </div>
        <div class="col-xl-4 col-md-4 col-sm-6">
            <div class="card text-center bg-info bg-darken-1">
                <div class="card-body ">
                    <div class="avatar bg-darken p-50 m-0">
                        <div class="avatar-content">
                            <i class="fas fa-boxes font-medium-5"></i>
                        </div>
                    </div>
                    <h2 class="font-weight-bolder text-white mt-2"><?php echo $rentals_size;?></h2>
                    <h4 class="card-text text-white ">Total Rental Products</h4>
                </div>
            </div>
        </div>

    
    </div>


</section>


<?php

include("footer.php");

?>