View Code - 20260722

purchase_report_pdf.php | 20260722_120325.php Initial Domain Snapshot

<?php

require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('purchase_entry');

$pdo        = $ctx['pdo'];
$company_id = (int)$ctx['company_id'];

require_once __DIR__ . '/lib/dompdf/autoload.inc.php';

use Dompdf\Dompdf;

$from   = $_GET['from']   ?? '';
$to     = $_GET['to']     ?? '';
$party  = $_GET['party']  ?? '';
$status = $_GET['status'] ?? '';

$sql = "SELECT * FROM purchase_entry WHERE company_id=?";
$params = [$company_id];

if($from!=''){
$sql.=" AND purchase_date>=?";
$params[]=$from;
}

if($to!=''){
$sql.=" AND purchase_date<=?";
$params[]=$to;
}

if($party!=''){
$sql.=" AND party_name=?";
$params[]=$party;
}

if($status!=''){
$sql.=" AND verification_status=?";
$params[]=$status;
}

$sql.=" ORDER BY purchase_date DESC";

$stm=$pdo->prepare($sql);
$stm->execute($params);
$data=$stm->fetchAll();

$html='
<h2>Purchase Report</h2>

<tr>
<th>ID</th>
<th>Date</th>
<th>Party</th>
<th>Challan</th>
<th>Bill</th>
<th>Item</th>
<th>Qty</th>
<th>Amount</th>
<th>Status</th>
</tr>';

foreach($data as $r){

$status = $r['verification_status']=='verified' ? 'Verified' : 'Unverified';

$html.='
<tr>

<td>'.$r['purchase_id'].'</td>
<td>'.$r['purchase_date'].'</td>
<td>'.$r['party_name'].'</td>
<td>'.$r['challan_no'].'</td>
<td>'.$r['bill_no'].'</td>
<td>'.$r['item_name'].'</td>
<td>'.$r['quantity'].'</td>
<td>'.number_format($r['total_amount'],2).'</td>
<td>'.$status.'</td>

</tr>';

}

$html.='</table>';

$dompdf=new Dompdf();

$dompdf->loadHtml($html);

$dompdf->setPaper('A4','landscape');

$dompdf->render();

$dompdf->stream("purchase_report.pdf",["Attachment"=>0]);