<?php require dirname(__DIR__).'/app/core.php';require_roles(['admin','standard']);audit('export','ASSET_EXPORT');header('Content-Type:text/csv');header('Content-Disposition:attachment;filename="AFGTracv5-assets.csv"');$o=fopen('php://output','w');fputcsv($o,['serial_number','owned_by','owner_client','country_code','model','condition','designation','current_location','recertification_expiration_date','notes']);foreach($pdo->query("SELECT a.serial_number,a.owned_by,c.name,c.country_code,a.model,a.asset_condition,a.designation,a.current_location,a.recertification_expiration_date,a.notes FROM afguards a LEFT JOIN clients c ON c.id=a.owner_client_id") as $x)fputcsv($o,array_values($x));