<span class="details">
<?php
echo $ro->selectNow("salesInvoice", "invoiceNo", "siNo", $siNo);
?>
</span>
</td>
<td>
<span class="details">
<?php
echo $ro->selectNow("supplier", "supplierName", "supplierCode", $ro->selectNow("salesInvoice", "supplier", "siNo", $siNo));
?>
</span>
</td>
<td>
<?php
$ro4->total_invoice($siNo) > 0 ? $x = number_format($ro4->total_invoice($siNo), 2) : ($x = "");
echo $x;
?>
</td>
<td>
<?php
echo $ro->selectNow("salesInvoice", "terms", "siNo", $siNo);
?>
</td>
<td>
<?php
$date = $ro->selectNow("salesInvoice", "recievedDate", "siNo", $siNo);
$year = substr($date, 0, 4);
$month = substr($date, 4, 2);
$day = substr($date, 6, 2);
$formatDate = $year . "-" . $month . "-" . $day;
echo $ro->selectNow("salesInvoice", "invoiceNo", "siNo", $siNo);
?>
</td>
<td>
<span class="details<?php
echo $siNo;
?>
">
<?php
echo $ro->selectNow("supplier", "supplierName", "supplierCode", $ro->selectNow("salesInvoice", "supplier", "siNo", $siNo));
?>
</span>
</td>
<td>
<?php
$x = $ro4->total_invoice($siNo);
$x > 0 ? $amount = number_format($x, 2) : ($amount = "");
echo $amount;
$totalPurchase += $x;
?>
</td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<td><h4>Total</h4></td>
<td></td>
<td></td>