📄 File: team_audit.php

Path: /home2/outerorb/assetradar.outerorbittech.com/admin/team_audit.php

Size: 1.28 KB

Permissions: 0666

<?php
require_once __DIR__ . '/../inc/auth.php';
require_login();
$u = current_user();
require_admin();
define('ADMIN_PAGE', true);
include __DIR__ . '/../inc/header.php';
include __DIR__ . '/admin_menu.php';

// team summary
$teams = $mysqli->query('SELECT t.id,t.name, COUNT(i.id) as total_items, SUM(i.assigned_to IS NOT NULL) as issued FROM teams t LEFT JOIN users u ON u.team_id=t.id LEFT JOIN items i ON i.assigned_to=u.id GROUP BY t.id');
?>
<div class="card p-3 card-hero">
  <h5>Team Audit Report</h5>
  <table class="table">
    <thead><tr><th>Team</th><th>Total Items</th><th>Issued to Team</th><th>Damaged</th><th>Missing</th></tr></thead>
    <tbody>
    <?php while($t = $teams->fetch_assoc()): 
      $dam = $mysqli->query('SELECT COUNT(*) c FROM items i JOIN users u ON i.assigned_to=u.id WHERE u.team_id='.(int)$t['id'].' AND i.condition_status="Damaged"')->fetch_assoc()['c'];
      $missing = 0; // placeholder - requires audit flag logic
    ?>
      <tr>
        <td><?php echo esc($t['name']); ?></td>
        <td><?php echo $t['total_items']; ?></td>
        <td><?php echo $t['issued']; ?></td>
        <td><?php echo $dam; ?></td>
        <td><?php echo $missing; ?></td>
      </tr>
    <?php endwhile; ?>
    </tbody>
  </table>
</div>
<?php include __DIR__ . '/../inc/footer.php'; ?>

← Back to Directory Edit File 🔒 Chmod