176 lines
7.8 KiB
PHP
176 lines
7.8 KiB
PHP
<!DOCTYPE html>
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>Reports - RedSolutions CRM</title>
|
|
<meta name="description" content="RedSolutions CRM - Built with Flatlogic Generator">
|
|
<meta name="keywords" content="crm, redsolutions, business management, proposals, work orders, dispatch, field service, flatlogic">
|
|
<meta property="og:title" content="RedSolutions CRM">
|
|
<meta property="og:description" content="A modern CRM for managing your business operations.">
|
|
<meta property="og:image" content="">
|
|
<meta name="twitter:card" content="summary_large_image">
|
|
<meta name="twitter:image" content="">
|
|
|
|
<!-- Bootstrap 5 CSS -->
|
|
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
|
|
<!-- Bootstrap Icons -->
|
|
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
|
|
<!-- Custom CSS -->
|
|
<link rel="stylesheet" href="assets/css/custom.css?v=<?php echo time(); ?>">
|
|
</head>
|
|
<?php
|
|
require_once 'db/config.php';
|
|
require_once 'includes/functions.php';
|
|
|
|
start_secure_session();
|
|
require_login();
|
|
|
|
$status_counts = get_work_order_counts_by_status();
|
|
$technician_counts = get_work_order_counts_by_technician();
|
|
$avg_completion_time = get_average_completion_time();
|
|
|
|
?>
|
|
<body class="d-flex">
|
|
|
|
<div class="sidebar d-flex flex-column p-3">
|
|
<a href="index.php" class="d-flex align-items-center mb-3 mb-md-0 me-md-auto text-white text-decoration-none">
|
|
<i class="bi bi-buildings me-2"></i>
|
|
<span class="fs-4">Flatlogic</span>
|
|
</a>
|
|
<hr>
|
|
<ul class="nav nav-pills flex-column mb-auto">
|
|
<li class="nav-item">
|
|
<a href="index.php" class="nav-link text-white">
|
|
<i class="bi bi-speedometer2 me-2"></i>
|
|
Dashboard
|
|
</a>
|
|
</li>
|
|
<li class="nav-item">
|
|
<a href="reports.php" class="nav-link text-white active" aria-current="page">
|
|
<i class="bi bi-bar-chart-line me-2"></i>
|
|
Reports
|
|
</a>
|
|
</li>
|
|
<li class="nav-item">
|
|
<a href="inventory.php" class="nav-link text-white">
|
|
<i class="bi bi-box-seam me-2"></i>
|
|
Inventory
|
|
</a>
|
|
</li>
|
|
</ul>
|
|
<hr>
|
|
<div class="dropdown">
|
|
<a href="#" class="d-flex align-items-center text-white text-decoration-none dropdown-toggle" id="dropdownUser1" data-bs-toggle="dropdown" aria-expanded="false">
|
|
<i class="bi bi-person-circle me-2"></i>
|
|
<strong><?php echo htmlspecialchars($_SESSION['username']); ?></strong>
|
|
</a>
|
|
<ul class="dropdown-menu dropdown-menu-dark text-small shadow" aria-labelledby="dropdownUser1">
|
|
<li><a class="dropdown-item" href="logout.php">Sign out</a></li>
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
|
|
<main class="main-content flex-grow-1 p-4">
|
|
<header class="d-flex justify-content-between align-items-center mb-4">
|
|
<h1 class="h3 mb-0">Reports</h1>
|
|
</header>
|
|
|
|
<!-- KPI Cards -->
|
|
<div class="row">
|
|
<div class="col-md-4">
|
|
<div class="card kpi-card">
|
|
<div class="card-body">
|
|
<div class="d-flex align-items-center">
|
|
<div class="kpi-icon bg-primary-soft">
|
|
<i class="bi bi-clock-history"></i>
|
|
</div>
|
|
<div class="ms-3">
|
|
<h3 class="kpi-value"><?php echo $avg_completion_time; ?> Hours</h3>
|
|
<span class="kpi-title">Avg. Completion Time</span>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="row mt-4">
|
|
<!-- Work Orders by Status -->
|
|
<div class="col-md-6">
|
|
<div class="card">
|
|
<div class="card-header">
|
|
<h5 class="card-title mb-0">Work Orders by Status</h5>
|
|
</div>
|
|
<div class="card-body">
|
|
<div class="table-responsive">
|
|
<table class="table table-hover">
|
|
<thead>
|
|
<tr>
|
|
<th>Status</th>
|
|
<th>Count</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php if (empty($status_counts)): ?>
|
|
<tr>
|
|
<td colspan="2" class="text-center">No data available.</td>
|
|
</tr>
|
|
<?php else: ?>
|
|
<?php foreach ($status_counts as $status => $count): ?>
|
|
<tr>
|
|
<td><span class="badge bg-primary-soft text-primary"><?php echo htmlspecialchars($status); ?></span></td>
|
|
<td><?php echo $count; ?></td>
|
|
</tr>
|
|
<?php endforeach; ?>
|
|
<?php endif; ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<!-- Work Orders by Technician -->
|
|
<div class="col-md-6">
|
|
<div class="card">
|
|
<div class="card-header">
|
|
<h5 class="card-title mb-0">Work Orders by Technician</h5>
|
|
</div>
|
|
<div class="card-body">
|
|
<div class="table-responsive">
|
|
<table class="table table-hover">
|
|
<thead>
|
|
<tr>
|
|
<th>Technician</th>
|
|
<th>Assigned Orders</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php if (empty($technician_counts)): ?>
|
|
<tr>
|
|
<td colspan="2" class="text-center">No technicians assigned to orders.</td>
|
|
</tr>
|
|
<?php else: ?>
|
|
<?php foreach ($technician_counts as $technician => $count): ?>
|
|
<tr>
|
|
<td><?php echo htmlspecialchars($technician); ?></td>
|
|
<td><?php echo $count; ?></td>
|
|
</tr>
|
|
<?php endforeach; ?>
|
|
<?php endif; ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</main>
|
|
|
|
<!-- Bootstrap 5 JS -->
|
|
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>
|
|
<!-- Custom JS -->
|
|
<script src="assets/js/main.js?v=<?php echo time(); ?>"></script>
|
|
</body>
|
|
</html>
|