$pdf = new fpdf('P', 'mm', 'Letter');
$pdf->setFont('Times', 'B', 20);
$pdf->addPage();
$pdf->setY(20);
$pdf->cell(0, 12, 'Bills from ' . $header, 0, 1, 'C');
$pdf->setY(40);
$total = 0.0;
while ($row = mysqli_fetch_array($billR, MYSQLI_NUM)) {
$payer[$row[1]] = $row[0];
$total += $row[0];
}
$num = mysqli_num_rows($payersR);
$avg = $total / $num;
$pdf->setFont('Times', 'B', 16);
// 216 mm total, 203 writable
$pdf->setX(7.5);
$pdf->cell(75, 10, 'Name', 1, 0, 'C');
$pdf->cell(42, 10, 'Amount Paid', 1, 0, 'C');
$pdf->cell(42, 10, '', 1, 0, 'C');
$pdf->cell(42, 10, 'Amount', 1, 1, 'C');
$pdf->setFont('Times', '', 14);
foreach ($payer as $name => $amount) {
// 216 mm total, 203 writable
$pdf->setX(7.5);
$pdf->cell(75, 10, $name, 1, 0, 'L');
$pdf->cell(42, 10, "\$" . number_format($amount, 2), 1, 0, 'C');
$pdf->cell(42, 10, $amount - $avg > 0 ? 'Is Owed' : 'Owes', 1, 0, 'C');
$pdf->cell(42, 10, "\$" . number_format(abs($amount - $avg), 2), 1, 1, 'C');
}
$pdf->setFont('Times', 'B', 14);
// 216 mm total, 203 writable
