<?php
include_once('header.php');
$todayDate = date('Y-m-d');
$thisMonth = date('m-d');

$todayCol1 = $wpdb->get_var("select SUM(amount) from `wp_sb_online_transaction` where payment_status='S' and date(payment_date)='$todayDate'");

$todayCol = $todayCol1!='' ? $todayCol1 : 0;

$monthCol1 = $wpdb->get_var("select SUM(amount) from `wp_sb_online_transaction` where payment_status='S' and MONTH(payment_date) = MONTH(CURRENT_DATE())
AND YEAR(payment_date) = YEAR(CURRENT_DATE())");

$monthCol = $monthCol1!='' ? $monthCol1 : 0;

$totalCol = $wpdb->get_var("select SUM(amount) from `wp_sb_online_transaction` where payment_status='S'");

?>


<div class="page-inner">
                <div class="page-title">
                    <h3>Dashboard</h3>
                    <div class="page-breadcrumb">
                        <ol class="breadcrumb">
                            <li><a href="dashboard">Home</a></li>
                            <li class="active">Dashboard</li>
                        </ol>
                    </div>
                </div>
                <div id="main-wrapper">
                    <div class="row">
                        <div class="col-lg-3 col-md-6">
                            <div class="panel info-box panel-white">
                                <div class="panel-body">
                                    <div class="info-box-stats">
                                        <p class="counters"><?php echo $todayCol; ?></p>
                                        <span class="info-box-title">Today's Collection</span>
                                    </div>
                                    <div class="info-box-icon">
                                        <i class="icon-users"></i>
                                    </div>
                                    <div class="info-box-progress">
                                        <div class="progress progress-xs progress-squared bs-n">
                                            <div class="progress-bar progress-bar-success" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: 40%">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-3 col-md-6">
                            <div class="panel info-box panel-white">
                                <div class="panel-body">
                                    <div class="info-box-stats">
                                        <p class="counters"><?php echo $monthCol; ?></p>
                                        <span class="info-box-title">This Month's Collection</span>
                                    </div>
                                    <div class="info-box-icon">
                                        <i class="icon-eye"></i>
                                    </div>
                                    <div class="info-box-progress">
                                        <div class="progress progress-xs progress-squared bs-n">
                                            <div class="progress-bar progress-bar-info" role="progressbar" aria-valuenow="80" aria-valuemin="0" aria-valuemax="100" style="width: 80%">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-3 col-md-6">
                            <div class="panel info-box panel-white">
                                <div class="panel-body">
                                    <div class="info-box-stats">
                                        <p class="counters"><?php echo $totalCol; ?></p>
                                        <span class="info-box-title">Total Collection</span>
                                    </div>
                                    <div class="info-box-icon">
                                        <i class="icon-envelope"></i>
                                    </div>
                                    <div class="info-box-progress">
                                        <div class="progress progress-xs progress-squared bs-n">
                                            <div class="progress-bar progress-bar-warning" role="progressbar" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100" style="width: 60%">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
              
                    </div><!-- Row -->
                
                </div><!-- Main Wrapper -->
                <div class="page-footer">
                    <p class="no-s">https://santabrigade.in/</p>
                </div>
            </div><!-- Page Inner -->






<?php
include_once('footer.php');
?>