View Code - 20260721

expense_report_manage_print.php | 20260721_154032.php Initial Bulk Import

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

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

function h($s){
    return htmlspecialchars((string)$s,ENT_QUOTES,'UTF-8');
}

$month = (int)($_GET['month'] ?? date('m'));
$year  = (int)($_GET['year'] ?? date('Y'));

$display_month = date('F Y', mktime(0,0,0,$month,1,$year));

$start = "$year-$month-01";
$end   = date("Y-m-t", strtotime($start));

$q = $pdo->prepare("
SELECT transaction_date,transaction_remarks,withdrawal_amt,remark,rapier_share
FROM expense_report
WHERE company_id=? 
AND transaction_date BETWEEN ? AND ?
ORDER BY transaction_date
");

$q->execute([$company_id,$start,$end]);
$data = $q->fetchAll(PDO::FETCH_ASSOC);

$total=0;
$totalRapier=0;

foreach($data as $r){
$total+=(float)$r['withdrawal_amt'];
$totalRapier+=(float)$r['rapier_share'];
}
?>

<!DOCTYPE html>
<html>
<head>
<title>Expense Report</title>
</head>

<div style="text-align:center; margin-bottom:25px;">
<h2 style="margin:0;">Expense Report</h2>
<div style="font-weight:bold;"><?=h($display_month)?></div>
</div>

Month:

<?php for($m=1;$m<=12;$m++): ?>

<?php endfor; ?>

</select>

Year:

<?php for($y=date('Y')-2;$y<=date('Y');$y++): ?>

<?php endfor; ?>

</select>

<button type="submit">Filter</button>

<button type="button" onclick="window.print()">Print</button>

</form>

<th style="border:1px solid #000;padding:6px;">Date</th>
<th style="border:1px solid #000;padding:6px;">Description</th>
<th style="border:1px solid #000;padding:6px;text-align:right;">Amount</th>
<th style="border:1px solid #000;padding:6px;">Remark</th>
<th style="border:1px solid #000;padding:6px;text-align:right;">Rapier Share</th>

</tr>

<?php foreach($data as $r): ?>

<tr>

</tr>

<?php endforeach; ?>

<td colspan="2" style="border:1px solid #000;padding:6px;text-align:right;">
Total
</td>

<td style="border:1px solid #000;padding:6px;text-align:right;">
Rapier Total
</td>

</tr>

</table>

</body>
</html>