📄 File: sample_inventory.php

Path: /home2/outerorb/assetradar.outerorbittech.com/admin/export_samples/sample_inventory.php

Size: 1.27 KB

Permissions: 0666

<?php
ini_set('display_errors', 0);
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);

// config.php now safely starts session when needed
ob_start();
require_once __DIR__ . '/../../config.php';
require_once __DIR__ . '/../../inc/auth.php';
require_login();
$u = current_user();
if ($u['role_slug'] !== 'admin') {
    header('Location: ' . BASE_URL . 'index.php');
    exit;
}

header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="sample_inventory.csv"');

$out = fopen('php://output', 'w');
fputcsv($out, ['ID', 'Asset Tag', 'Name', 'Category', 'Brand/Model', 'Serial', 'Condition', 'Assigned To']);

// Fetch one existing inventory item
$res = $mysqli->query('SELECT i.id, i.asset_tag, i.item_name, c.name as category_name, i.brand_model, i.serial_number, i.condition_status, u.name as assigned_name FROM items i LEFT JOIN categories c ON i.category_id=c.id LEFT JOIN users u ON i.assigned_to=u.id LIMIT 1');
if ($res && $row = $res->fetch_assoc()) {
    fputcsv($out, [
        $row['id'],
        $row['asset_tag'],
        $row['item_name'],
        $row['category_name'],
        $row['brand_model'],
        $row['serial_number'],
        $row['condition_status'],
        $row['assigned_name']
    ]);
}

fclose($out);
exit;

← Back to Directory Edit File 🔒 Chmod