|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home2/imyrqtmy/public_html/thesmarthands/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("inc/config.php");
?>
<!DOCTYPE html>
<html lang="en">
<?php require "inc/head.php"; ?>
<body>
<!-- header-->
<?php require "inc/header.php"; ?>
<!-- End header-->
<!-- Main-content Top bar-->
<!-- End Main-content Top bar-->
<!-- main-content-->
<div class="wrapper">
<?php require "inc/sidebar.php"; ?>
<div id="content">
<div class="row">
<div class="col-sm-12">
<!-- <div class="row mb-xl-4 mb-0">
<?php
// Fetch the count of pending projects
$pending_query = "SELECT COUNT(*) AS pending_count FROM projects WHERE project_status = 'Pending'";
$pending_result = mysqli_query($conn, $pending_query);
$pending_row = mysqli_fetch_assoc($pending_result);
// Get the count or default to 0 if no pending projects
$pending_count = $pending_row['pending_count'] ?? 0;
?>
<div class="col-12 col-sm-6 col-xl-3 mb-4 mb-xl-0">
<div class="card redial-border-primary redial-shadow redial-bg-primary text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3 spark10"></div>
<div class="media-body">
<div class=" text-center text-sm-right">
<h2 class="mb-1 redial-font-weight-400 text-white" style="padding-right: 17px;"><?php echo $pending_count; ?></h2>
<p class="mb-2" style="padding-right: 17px;">Pending Project</p>
<div class="chart sparkline spark5"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
// Fetch the count of pending projects
$pending_query = "SELECT COUNT(*) AS pending_count FROM projects WHERE project_status = 'Complete'";
$pending_result = mysqli_query($conn, $pending_query);
$pending_row = mysqli_fetch_assoc($pending_result);
// Get the count or default to 0 if no pending projects
$pending_count = $pending_row['pending_count'] ?? 0;
?>
<div class="col-12 col-sm-6 col-xl-3 mb-4 mb-xl-0">
<div class="card redial-bg-pink redial-border-pink redial-shadow text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3 spark10"></div>
<div class="media-body">
<div class="text-center text-sm-right">
<h2 class=" mb-1 redial-font-weight-400 text-white" style="padding-right: 17px;"><?php echo $pending_count; ?> </h2>
<p class="mb-2" style="padding-right: 17px;">Complete Project</p>
<div class="chart sparkline spark5"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
// Fetch the count of pending projects
$pending_query = "SELECT COUNT(*) AS pending_count FROM projects WHERE project_status = 'In Progress'";
$pending_result = mysqli_query($conn, $pending_query);
$pending_row = mysqli_fetch_assoc($pending_result);
// Get the count or default to 0 if no pending projects
$pending_count = $pending_row['pending_count'] ?? 0;
?>
<div class="col-12 col-sm-6 col-xl-3 mb-4 mb-xl-0">
<div class="card redial-bg-success redial-border-success redial-shadow text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3 spark10"></div>
<div class="media-body">
<div class="text-center text-sm-right">
<h2 class=" mb-1 redial-font-weight-400 text-white" style="padding-right: 17px;"><?php echo $pending_count; ?> </h2>
<p class="mb-2" style="padding-right: 17px;">In Progress Project</p>
<div class="chart sparkline spark5"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
// Fetch the count of completed tasks
$complete_query = "SELECT COUNT(*) AS complete_count FROM tasks WHERE status = 'active'";
$complete_result = mysqli_query($conn, $complete_query);
$complete_row = mysqli_fetch_assoc($complete_result);
// Get the count or default to 0 if no completed tasks
$complete_count = $complete_row['complete_count'] ?? 0;
?>
<div class="col-12 col-sm-6 col-xl-3">
<div class="card redial-bg-info redial-border-info redial-shadow text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3 spark10"></div>
<div class="media-body">
<div class="text-center text-sm-right">
<h2 class=" mb-1 redial-font-weight-400 text-white" style="padding-right: 17px;"><?php echo $complete_count; ?> </h2>
<p class="mb-2" style="padding-right: 17px;">Complete Task</p>
<div class="chart sparkline spark5"></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div> -->
<?php
// Fetch stored monthly profit data (Ensuring no duplication)
$profit_query = "SELECT YEAR(start_date) AS year,
MONTH(start_date) AS month,
SUM(DISTINCT total_task_price) AS total_task_price,
SUM(DISTINCT total_invoice_price) AS total_invoice_price,
SUM(DISTINCT total_invoice_price - total_task_price) AS total_profit
FROM profits
GROUP BY YEAR(start_date), MONTH(start_date)
ORDER BY YEAR(start_date) ASC, MONTH(start_date) ASC";
$profit_result = mysqli_query($conn, $profit_query);
?>
<div class="row mb-xl-4 mb-0 mb-5">
<?php while ($row = mysqli_fetch_assoc($profit_result)) { ?>
<div class="col-12 col-sm-6 col-xl-4 mb-4 mb-xl-0">
<div class="card redial-border-primary redial-shadow redial-bg-primary text-white mb-4">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="media-body">
<div class="text-center text-sm-right">
<h4 class="mb-1 redial-font-weight-400 text-white">
<?php echo date('F', mktime(0, 0, 0, $row['month'], 1)) . " " . $row['year']; ?>
</h4>
<p class="mb-2">Total Task Amount: ₹<?php echo number_format($row['total_task_price'], 2); ?></p>
<p class="mb-2">Total Invoice Amount: ₹<?php echo number_format($row['total_invoice_price'], 2); ?></p>
<p class="mb-2">Profit: ₹<?php echo number_format($row['total_profit'], 2); ?></p>
</div>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
<!-- <div class="row mb-4">
<div class="col-12 col-sm-12">
<div class="row">
<div class="col-12 col-md-6 mb-4">
<div class="card redial-border-light redial-shadow">
<div class="card-body">
<h6 class="header-title pl-3 redial-relative">Donut Chart</h6>
<div id="donut"></div>
</div>
</div>
</div>
<div class="col-12 col-md-6 mb-4">
<div class="card redial-border-light redial-shadow">
<div class="card-body">
<h6 class="header-title pl-3 redial-relative">Timeline</h6>
<div id="demo1"></div>
</div>
</div>
</div>
<div class="col-12 col-md-6 mb-4">
<div class="card redial-border-light redial-shadow">
<div class="card-body">
<h6 class="header-title pl-3 redial-relative">Timeseries Chart</h6>
<div id="columnchart_material"></div>
</div>
</div>
</div>
<div class="col-12 col-md-6 mb-4">
<div class="card redial-border-light redial-shadow">
<div class="card-body">
<h6 class="header-title pl-3 redial-relative">Spline Chart</h6>
<div id="spline"></div>
</div>
</div>
</div>
<?php
$projectQuery = "SELECT COUNT(*) FROM projects";
$taskQuery = "SELECT COUNT(*) FROM tasks WHERE status = 'completed'";
$projectResult = mysqli_query($conn, $projectQuery);
$taskResult = mysqli_query($conn, $taskQuery);
$projectCount = mysqli_fetch_array($projectResult)[0];
$completedTaskCount = mysqli_fetch_array($taskResult)[0];
?>
<script type="text/javascript">
var projectCount = <?php echo $projectCount; ?>;
var completedTaskCount = <?php echo $completedTaskCount; ?>;
</script>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', { packages: ['corechart', 'bar'] });
google.charts.setOnLoadCallback(drawCombinationChart);
function drawCombinationChart() {
var data = google.visualization.arrayToDataTable([
['Month', 'Projects', 'Completed Tasks'],
['January', projectCount, completedTaskCount],
['February', projectCount + 5, completedTaskCount + 3],
['March', projectCount + 10, completedTaskCount + 7]
]);
var options = {
title: 'Profile Data Overview',
vAxis: { title: 'Count' },
hAxis: { title: 'Month' },
seriesType: 'bars',
series: {
1: { type: 'line' }
}
};
var chart = new google.visualization.ComboChart(document.getElementById('combination'));
chart.draw(data, options);
}
</script>
<div class="col-12 col-md-12">
<div class="card redial-border-light redial-shadow">
<div class="card-body">
<h6 class="header-title pl-3 redial-relative">Profile Data Overview</h6>
<div id="combination" style="width: 100%; height: 400px;"></div>
</div>
</div>
</div>
</div>
</div>
</div> -->
</div>
</div>
</div>
</div>
<!-- End main-content-->
<!-- Top To Bottom-->
<a href="#" class="scrollup text-center redial-bg-primary redial-rounded-circle-50 ">
<h4 class="text-white mb-0"><i class="icofont icofont-long-arrow-up"></i></h4>
</a>
<script src="dist/js/plugins.min.js"></script>
<script src="dist/js/common.js"></script>
</body>
</html>