<?php
include 'db_connect.php';

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

// Fetch QC sheet data
$query = "SELECT qc_sheets.id, machines.machine_name, users.username AS operator, qc_sheets.qc_date, qc_sheets.status 
          FROM qc_sheets 
          JOIN machines ON qc_sheets.machine_id = machines.id 
          JOIN users ON qc_sheets.operator_id = users.id";
$stmt = $pdo->query($query);
$qc_sheets = $stmt->fetchAll();

// Open output stream
$output = fopen('php://output', 'w');

// Output the column headings
fputcsv($output, array('QC Sheet ID', 'Machine', 'Operator', 'Date', 'Status'));

// Output the rows
foreach ($qc_sheets as $qc_sheet) {
    fputcsv($output, $qc_sheet);
}

fclose($output);
exit;
?>