prepare("
SELECT t.*, c.name AS customer_name
FROM transactions t
LEFT JOIN customers c ON c.id = t.customer_id
WHERE t.user_id=?
AND t.trans_date BETWEEN ? AND ?
ORDER BY t.trans_date
");
$stmt->execute([$user_id,$start,$end]);
}
else
{
$stmt = $pdo->prepare("
SELECT t.*, c.name AS customer_name
FROM transactions t
LEFT JOIN customers c ON c.id = t.customer_id
WHERE t.user_id=?
AND t.customer_id=?
AND t.trans_date BETWEEN ? AND ?
ORDER BY t.trans_date
");
$stmt->execute([$user_id,$customer_id,$start,$end]);
}
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$pdf = new TCPDF();
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->AddPage();
$html = "