📁 File Manager
Editing:
/home/wedigitalindia/public_html/manralsolar.com/admin/index.php
<?php require_once('header.php'); ?> <section class="content-header"> <h1>Dashboard</h1> </section> <?php date_default_timezone_set('Asia/Kolkata'); // Set the time zone to India $currentDate = date('Y-m-d'); $statement = $pdo->prepare("SELECT * FROM tbl_top_category"); $statement->execute(); $total_top_category = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_mid_category"); $statement->execute(); $total_mid_category = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_end_category"); $statement->execute(); $total_end_category = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_product"); $statement->execute(); $total_product = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_customer WHERE cust_status='1'"); $statement->execute(); $total_customers = $statement->rowCount(); // $statement = $pdo->prepare("SELECT * FROM tbl_subscriber WHERE subs_active='1'"); // $statement->execute(); // $total_subscriber = $statement->rowCount(); // $statement = $pdo->prepare("SELECT * FROM tbl_shipping_cost"); // $statement->execute(); // $available_shipping = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_order WHERE OrderStatus=?"); $statement->execute(array('1')); $total_order_completed = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_payment WHERE shipping_status=?"); $statement->execute(array('Completed')); $total_shipping_completed = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_order WHERE OrderStatus=?"); $statement->execute(array('0')); $total_order_pending = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_payment WHERE payment_status=? AND shipping_status=?"); $statement->execute(array('Completed','Pending')); $total_order_complete_shipping_pending = $statement->rowCount(); $statement = $pdo->prepare("SELECT * FROM tbl_order WHERE orderDate=?"); $statement->execute(array($currentDate)); $todayorder = $statement->rowCount(); ?> <section class="content"> <div class="row"> <!--./col --> <div class="col-lg-3 col-xs-6"> <!-- small box --> <div class="small-box bg-blue"> <div class="inner"> <h3><?php echo $todayorder; ?></h3> <p>Today Orders</p> </div> <div class="icon"> <i class="ionicons ion-android-menu"></i> </div> </div> </div> <div class="col-lg-3 col-xs-6"> <!--small box --> <div class="small-box bg-maroon"> <div class="inner"> <h3><?php echo $total_order_pending; ?></h3> <p>Pending Orders</p> </div> <div class="icon"> <i class="ionicons ion-clipboard"></i> </div> </div> </div> <!--./col --> <div class="col-lg-3 col-xs-6"> <!--small box --> <div class="small-box bg-green"> <div class="inner"> <h3><?php echo $total_order_completed; ?></h3> <p>Completed Orders</p> </div> <div class="icon"> <i class="ionicons ion-android-checkbox-outline"></i> </div> </div> </div> <!--./col --> <div class="col-lg-3 col-xs-6"> <!--small box --> <div class="small-box bg-aqua"> <div class="inner"> <h3><?php echo $total_shipping_completed; ?></h3> <p>Completed Shipping</p> </div> <div class="icon"> <i class="ionicons ion-checkmark-circled"></i> </div> </div> </div> <!--./col --> <div class="col-lg-3 col-xs-6"> <!--small box --> <div class="small-box bg-orange"> <div class="inner"> <h3><?php echo $total_order_complete_shipping_pending; ?></h3> <p>Pending Shippings</p> </div> <div class="icon"> <i class="ionicons ion-load-a"></i> </div> </div> </div> <div class="col-lg-3 col-xs-6"> <!--small box --> <div class="small-box bg-red"> <div class="inner"> <h3><?php echo $total_customers; ?></h3> <p>Active Customers</p> </div> <div class="icon"> <i class="ionicons ion-person-stalker"></i> </div> </div> </div> <div class="col-lg-3 col-xs-6"> <!-- small box --> <div class="small-box bg-primary"> <div class="inner"> <h3><?php echo $total_product; ?></h3> <p>Products</p> </div> <div class="icon"> <i class="ionicons ion-android-cart"></i> </div> </div> </div> <div class="col-lg-3 col-xs-6"> <!-- small box --> <div class="small-box bg-olive"> <div class="inner"> <h3><?php echo $total_top_category; ?></h3> <p>Top Categories</p> </div> <div class="icon"> <i class="ionicons ion-arrow-up-b"></i> </div> </div> </div> <div class="col-lg-3 col-xs-6"> <!-- small box --> <div class="small-box bg-blue"> <div class="inner"> <h3><?php echo $total_mid_category; ?></h3> <p>Mid Categories</p> </div> <div class="icon"> <i class="ionicons ion-android-menu"></i> </div> </div> </div> <!-- <div class="col-lg-3 col-xs-6">--> <!-- small box --> <!--<div class="small-box bg-maroon">--> <!-- <div class="inner">--> <!-- <h3><?php echo $total_end_category; ?></h3>--> <!-- <p>End Categories</p>--> <!-- </div>--> <!-- <div class="icon">--> <!-- <i class="ionicons ion-arrow-down-b"></i>--> <!-- </div>--> <!--</div>--> <!-- </div>--> </div> </section> <?php require_once('footer.php'); ?>
Save
Cancel