File "expense_tracker.php"
Full Path: /home/leadltht/fastlinkinternet.com/administrator/data-provider/admin/expense/expense_tracker.php
File size: 6.18 KB
MIME-type: text/x-php
Charset: utf-8
<?php
require_once('/home/leadltht/fastlinkinternet.com/administrator/data-provider/config.php'); // Ensure the correct path to config.php
session_start();
// Fetch expense data
$todayExpense = 0;
$yesterdayExpense = 0;
$last7DaysExpense = 0;
$last30DaysExpense = 0;
$currentYearExpense = 0;
$totalExpenses = 0;
// SQL queries to fetch expense data
$today = date('Y-m-d');
$yesterday = date('Y-m-d', strtotime('-1 day'));
$last7Days = date('Y-m-d', strtotime('-7 days'));
$last30Days = date('Y-m-d', strtotime('-30 days'));
$currentYear = date('Y');
$sqlToday = "SELECT SUM(total_amount) as total FROM expense_list WHERE DATE(expense_date) = '$today'";
$sqlYesterday = "SELECT SUM(total_amount) as total FROM expense_list WHERE DATE(expense_date) = '$yesterday'";
$sqlLast7Days = "SELECT SUM(total_amount) as total FROM expense_list WHERE DATE(expense_date) >= '$last7Days'";
$sqlLast30Days = "SELECT SUM(total_amount) as total FROM expense_list WHERE DATE(expense_date) >= '$last30Days'";
$sqlCurrentYear = "SELECT SUM(total_amount) as total FROM expense_list WHERE YEAR(expense_date) = '$currentYear'";
$sqlTotalExpenses = "SELECT SUM(total_amount) as total FROM expense_list";
// Execute the queries and fetch the results
$resultToday = $conn->query($sqlToday);
$resultYesterday = $conn->query($sqlYesterday);
$resultLast7Days = $conn->query($sqlLast7Days);
$resultLast30Days = $conn->query($sqlLast30Days);
$resultCurrentYear = $conn->query($sqlCurrentYear);
$resultTotalExpenses = $conn->query($sqlTotalExpenses);
if ($resultToday) {
$todayExpense = $resultToday->fetch_assoc()['total'];
}
if ($resultYesterday) {
$yesterdayExpense = $resultYesterday->fetch_assoc()['total'];
}
if ($resultLast7Days) {
$last7DaysExpense = $resultLast7Days->fetch_assoc()['total'];
}
if ($resultLast30Days) {
$last30DaysExpense = $resultLast30Days->fetch_assoc()['total'];
}
if ($resultCurrentYear) {
$currentYearExpense = $resultCurrentYear->fetch_assoc()['total'];
}
if ($resultTotalExpenses) {
$totalExpenses = $resultTotalExpenses->fetch_assoc()['total'];
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Expense Tracker Dashboard</title>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
<style>
body {
font-size: 14px;
display: flex;
justify-content: center;
align-items: center;
height: 100vh;
background-color: #f8f9fa;
}
.container {
max-width: 900px;
}
.card-title {
font-weight: bold;
font-size: 24px;
}
.card {
margin: 15px;
text-align: center;
padding: 20px;
border-radius: 15px;
}
.card .value {
font-size: 32px;
font-weight: bold;
}
.bg-today {
background-color: #ffdddd;
border-color: #ffaaaa;
}
.bg-yesterday {
background-color: #ffeedd;
border-color: #ffccaa;
}
.bg-last7days {
background-color: #ddffdd;
border-color: #aaffaa;
}
.bg-last30days {
background-color: #ddeeff;
border-color: #aaccee;
}
.bg-currentyear {
background-color: #f0e68c;
border-color: #e0d64c;
}
.bg-total {
background-color: #ddaaff;
border-color: #aa77ff;
}
.row {
display: flex;
justify-content: center;
margin-bottom: 20px;
}
</style>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-4">
<div class="card bg-today mb-3">
<div class="card-body">
<h5 class="card-title">Today's Expense</h5>
<p class="card-text value">₱<?= number_format($todayExpense, 2) ?></p>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card bg-yesterday mb-3">
<div class="card-body">
<h5 class="card-title">Yesterday's Expense</h5>
<p class="card-text value">₱<?= number_format($yesterdayExpense, 2) ?></p>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card bg-last7days mb-3">
<div class="card-body">
<h5 class="card-title">Last 7 Days' Expense</h5>
<p class="card-text value">₱<?= number_format($last7DaysExpense, 2) ?></p>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4">
<div class="card bg-last30days mb-3">
<div class="card-body">
<h5 class="card-title">Last 30 Days' Expense</h5>
<p class="card-text value">₱<?= number_format($last30DaysExpense, 2) ?></p>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card bg-currentyear mb-3">
<div class="card-body">
<h5 class="card-title">Current Year Expenses</h5>
<p class="card-text value">₱<?= number_format($currentYearExpense, 2) ?></p>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card bg-total mb-3">
<div class="card-body">
<h5 class="card-title">Total Expenses</h5>
<p class="card-text value">₱<?= number_format($totalExpenses, 2) ?></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>