hjkhhrtertererrrdfbdfbdfbdfbdfgdrtertertertrt
bnmbertertertertertertertertertertertertertertertertertertertertdfg
/
home
/
u365652112
/
domains
/
flavorzfusion.com
/
public_html
/
billing
/
Upload FileeE
HOME
<?php session_start(); error_reporting(0); include('includes/dbconnection.php'); if (strlen($_SESSION['detsuid']==0)) { header('location:logout.php'); } else{ ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Daily Expense Tracker - Dashboard</title> <link href="css/bootstrap.min.css" rel="stylesheet"> <link href="css/font-awesome.min.css" rel="stylesheet"> <link href="css/datepicker3.css" rel="stylesheet"> <link href="css/styles.css" rel="stylesheet"> <!--Custom Font--> <link href="https://fonts.googleapis.com/css?family=Montserrat:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet"> <!--[if lt IE 9]> <script src="js/html5shiv.js"></script> <script src="js/respond.min.js"></script> <![endif]--> </head> <body> <?php include_once('includes/header.php');?> <?php include_once('includes/sidebar.php');?> <div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main"> <div class="row"> <ol class="breadcrumb"> <li><a href="#"> <em class="fa fa-home"></em> </a></li> <li class="active">Dashboard</li> </ol> </div><!--/.row--> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Dashboard</h1> </div> </div><!--/.row--> <div class="row"> <div class="col-xs-6 col-md-3"> <div class="panel panel-default"> <div class="panel-body easypiechart-panel"> <?php //Today Expense $userid=$_SESSION['detsuid']; $tdate=date('Y-m-d'); $query=mysqli_query($con,"select sum(ExpenseCost) as todaysexpense from tblexpense where date(ExpenseDate)='$tdate' && (UserId='$userid');"); $result=mysqli_fetch_array($query); $sum_today_expense=$result['todaysexpense']; ?> <h4>Today's Expense</h4> <div class="easypiechart" id="easypiechart-blue" data-percent="<?php echo $sum_today_expense;?>" ><span class="percent"><?php if($sum_today_expense==""){ echo "0"; } else { echo $sum_today_expense; } ?></span></div> </div> </div> </div> <div class="col-xs-6 col-md-3"> <div class="panel panel-default"> <?php //Yestreday Expense $userid=$_SESSION['detsuid']; $ydate=date('Y-m-d',strtotime("-1 days")); $query1=mysqli_query($con,"select sum(ExpenseCost) as yesterdayexpense from tblexpense where (ExpenseDate)='$ydate' && (UserId='$userid');"); $result1=mysqli_fetch_array($query1); $sum_yesterday_expense=$result1['yesterdayexpense']; ?> <div class="panel-body easypiechart-panel"> <h4>Yesterday's Expense</h4> <div class="easypiechart" id="easypiechart-orange" data-percent="<?php echo $sum_yesterday_expense;?>" ><span class="percent"><?php if($sum_yesterday_expense==""){ echo "0"; } else { echo $sum_yesterday_expense; } ?></span></div> </div> </div> </div> <div class="col-xs-6 col-md-3"> <div class="panel panel-default"> <?php //Weekly Expense $userid=$_SESSION['detsuid']; $pastdate= date("Y-m-d", strtotime("-1 week")); $crrntdte=date("Y-m-d"); $query2=mysqli_query($con,"select sum(ExpenseCost) as weeklyexpense from tblexpense where ((ExpenseDate) between '$pastdate' and '$crrntdte') && (UserId='$userid');"); $result2=mysqli_fetch_array($query2); $sum_weekly_expense=$result2['weeklyexpense']; ?> <div class="panel-body easypiechart-panel"> <h4>Last 7day's Expense</h4> <div class="easypiechart" id="easypiechart-teal" data-percent="<?php echo $sum_weekly_expense;?>"><span class="percent"><?php if($sum_weekly_expense==""){ echo "0"; } else { echo $sum_weekly_expense; } ?></span></div> </div> </div> </div> <div class="col-xs-6 col-md-3"> <div class="panel panel-default"> <?php //Monthly Expense $userid=$_SESSION['detsuid']; $monthdate= date("Y-m-d", strtotime("-1 month")); $crrntdte=date("Y-m-d"); $query3=mysqli_query($con,"select sum(ExpenseCost) as monthlyexpense from tblexpense where ((ExpenseDate) between '$monthdate' and '$crrntdte') && (UserId='$userid');"); $result3=mysqli_fetch_array($query3); $sum_monthly_expense=$result3['monthlyexpense']; ?> <div class="panel-body easypiechart-panel"> <h4>Last 30day's Expenses</h4> <div class="easypiechart" id="easypiechart-red" data-percent="<?php echo $sum_monthly_expense;?>" ><span class="percent"><?php if($sum_monthly_expense==""){ echo "0"; } else { echo $sum_monthly_expense; } ?></span></div> </div> </div> </div> </div><!--/.row--> <div class="row"> <div class="col-xs-6 col-md-3"> <div class="panel panel-default"> <?php //Yearly Expense $userid=$_SESSION['detsuid']; $cyear= date("Y"); $query4=mysqli_query($con,"select sum(ExpenseCost) as yearlyexpense from tblexpense where (year(ExpenseDate)='$cyear') && (UserId='$userid');"); $result4=mysqli_fetch_array($query4); $sum_yearly_expense=$result4['yearlyexpense']; ?> <div class="panel-body easypiechart-panel"> <h4>Current Year Expenses</h4> <div class="easypiechart" id="easypiechart-red" data-percent="<?php echo $sum_yearly_expense;?>" ><span class="percent"><?php if($sum_yearly_expense==""){ echo "0"; } else { echo $sum_yearly_expense; } ?></span></div> </div> </div> </div> <div class="col-xs-6 col-md-3"> <div class="panel panel-default"> <?php //Yearly Expense $userid=$_SESSION['detsuid']; $query5=mysqli_query($con,"select sum(ExpenseCost) as totalexpense from tblexpense where UserId='$userid';"); $result5=mysqli_fetch_array($query5); $sum_total_expense=$result5['totalexpense']; ?> <div class="panel-body easypiechart-panel"> <h4>Total Expenses</h4> <div class="easypiechart" id="easypiechart-red" data-percent="<?php echo $sum_total_expense;?>" ><span class="percent"><?php if($sum_total_expense==""){ echo "0"; } else { echo $sum_total_expense; } ?></span></div> </div> </div> </div> </div> <!--/.row--> </div> <!--/.main--> <?php include_once('includes/footer.php');?> <script src="js/jquery-1.11.1.min.js"></script> <script src="js/bootstrap.min.js"></script> <script src="js/chart.min.js"></script> <script src="js/chart-data.js"></script> <script src="js/easypiechart.js"></script> <script src="js/easypiechart-data.js"></script> <script src="js/bootstrap-datepicker.js"></script> <script src="js/custom.js"></script> <script> window.onload = function () { var chart1 = document.getElementById("line-chart").getContext("2d"); window.myLine = new Chart(chart1).Line(lineChartData, { responsive: true, scaleLineColor: "rgba(0,0,0,.2)", scaleGridLineColor: "rgba(0,0,0,.05)", scaleFontColor: "#c5c7cc" }); }; </script> </body> </html> <?php } ?>