📄 File: export_items.php

Path: /home2/outerorb/assetradar.outerorbittech.com/export_samples/export_items.php

Size: 1.36 KB

Permissions: 0666

<?php
require_once __DIR__ . '/../config.php';
if (!file_exists(__DIR__ . '/../vendor/autoload.php')) {
    echo 'PhpSpreadsheet not installed. Install with composer require phpoffice/phpspreadsheet';
    exit;
}
require __DIR__ . '/../vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spread = new Spreadsheet();
$sheet = $spread->getActiveSheet();
$sheet->fromArray(['ID','Asset Tag','Name','Category','Brand','Serial','Condition','Assigned'], NULL, 'A1');
$res = $mysqli->query('SELECT i.*, c.name as cat, u.name as assigned FROM items i LEFT JOIN categories c ON i.category_id=c.id LEFT JOIN users u ON i.assigned_to=u.id');
$row=2;
while($r = $res->fetch_assoc()) {
    $sheet->setCellValue('A'.$row, $r['id']);
    $sheet->setCellValue('B'.$row, $r['asset_tag']);
    $sheet->setCellValue('C'.$row, $r['item_name']);
    $sheet->setCellValue('D'.$row, $r['cat']);
    $sheet->setCellValue('E'.$row, $r['brand_model']);
    $sheet->setCellValue('F'.$row, $r['serial_number']);
    $sheet->setCellValue('G'.$row, $r['condition_status']);
    $sheet->setCellValue('H'.$row, $r['assigned']);
    $row++;
}
$writer = new Xlsx($spread);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="items_export.xlsx"');
$writer->save('php://output');

← Back to Directory Edit File 🔒 Chmod