📄 File: inventory.php

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

Size: 3.71 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';

// basic list
$res = $mysqli->query('SELECT i.*, u.name as assigned_name, c.name as category_name, v.name as vendor_name, i.ownership_type FROM items i LEFT JOIN users u ON i.assigned_to=u.id LEFT JOIN categories c ON i.category_id=c.id LEFT JOIN vendors v ON i.vendor_id=v.id ORDER BY i.id DESC');

?>
<div class="card p-3 card-hero">
  <div class="d-flex justify-content-between">
    <h5>Inventory</h5>
    <div>
      <a class="btn btn-primary btn-sm" href="add_item.php">Add New Item</a>
      <a class="btn btn-outline-secondary btn-sm ms-2" href="export_samples/sample_inventory.php">Download Sample Data</a>
      <a class="btn btn-outline-success btn-sm ms-2" href="bulk_upload.php">Bulk Upload</a>
    </div>
  </div>
  <table class="table table-striped mt-3">
    <thead><tr><th>#</th><th>Asset Tag</th><th>Name</th><th>Category</th><th>Brand/Model</th><th>Serial</th><th>Condition</th><th>Ownership</th><th>Vendor</th><th>Assigned To</th><th>Action</th></tr></thead>
    <tbody>
    <?php
    if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['edit_id'])) {
      $id = (int)$_POST['edit_id'];
      if (isset($_POST['condition_status'])) {
        $cond = $mysqli->real_escape_string($_POST['condition_status']);
        $mysqli->query("UPDATE items SET condition_status='$cond' WHERE id=$id");
      }
      if (isset($_POST['ownership_type'])) {
        $own = $mysqli->real_escape_string($_POST['ownership_type']);
        $mysqli->query("UPDATE items SET ownership_type='$own' WHERE id=$id");
      }
      header('Location: inventory.php');
      exit;
    }
    while($r = $res->fetch_assoc()): ?>
      <tr>
        <td><?php echo $r['id']; ?></td>
        <td><?php echo esc($r['asset_tag']); ?></td>
        <td><?php echo esc($r['item_name']); ?></td>
        <td><?php echo esc($r['category_name']); ?></td>
        <td><?php echo esc($r['brand_model']); ?></td>
        <td><?php echo esc($r['serial_number']); ?></td>
        <td>
          <form method="post" style="display:inline;">
            <input type="hidden" name="edit_id" value="<?php echo $r['id']; ?>">
            <select name="condition_status" class="form-select form-select-sm d-inline w-auto" onchange="this.form.submit()">
              <option value="Working" <?php if($r['condition_status']==='Working')echo'selected'; ?>>Working</option>
              <option value="Damaged" <?php if($r['condition_status']==='Damaged')echo'selected'; ?>>Damaged</option>
              <option value="Missing" <?php if($r['condition_status']==='Missing')echo'selected'; ?>>Missing</option>
            </select>
          </form>
        </td>
        <td>
          <form method="post" style="display:inline;">
            <input type="hidden" name="edit_id" value="<?php echo $r['id']; ?>">
            <select name="ownership_type" class="form-select form-select-sm d-inline w-auto" onchange="this.form.submit()">
              <option value="owned" <?php if($r['ownership_type']==='owned')echo'selected'; ?>>Owned</option>
              <option value="rented" <?php if($r['ownership_type']==='rented')echo'selected'; ?>>Rented</option>
            </select>
          </form>
        </td>
        <td><?php echo esc($r['vendor_name'] ?? '—'); ?></td>
        <td><?php echo esc($r['assigned_name'] ?? '—'); ?></td>
        <td>
          <a class="btn btn-sm btn-outline-success" href="assign_item.php?item_id=<?php echo $r['id']; ?>">Assign/Transfer</a>
        </td>
      </tr>
    <?php endwhile; ?>
    </tbody>
  </table>
</div>
<?php include __DIR__ . '/../inc/footer.php'; ?>

← Back to Directory Edit File 🔒 Chmod