$subtotal = 0;
$total = 0;
while ($row = mysql_fetch_assoc($result3)) {
$tax_percent_of_item = $row['item_tax_percent'];
if ($tax_percent == $tax_percent_of_item) {
if ($rowCounter % 2 == 0) {
echo "\n<tr bgcolor={$display->rowcolor1}>\n";
} else {
echo "\n<tr bgcolor={$display->rowcolor2}>\n";
}
$rowCounter++;
for ($k = 0; $k < count($tablefields); $k++) {
$field = $tablefields[$k];
if ($field == 'brand_id' or $field == 'category_id' or $field == 'supplier_id') {
$field_data = $display->idToField("{$cfg_tableprefix}" . 'items', "{$field}", $row['item_id']);
$data = $display->formatData($field, $field_data, $cfg_tableprefix);
} else {
$data = $display->formatData($field, $row[$field], $cfg_tableprefix);
}
echo "\n<td align='center'>\n<font color='{$display->rowcolor_text}' face='{$display->rowfont_face}' size='{$display->rowfont_size}'>{$data}</font>\n</td>\n";
}
@($subtotal += $row['item_total_cost'] - $row['item_total_tax']);
@($total += $row['item_total_cost']);
}
}
echo '</table>' . "\n";
$subtotal = number_format($subtotal, 2, '.', '');
$total = number_format($total, 2, '.', '');
$tax = $total - $subtotal;
$tax = number_format($tax, 2, '.', '');
echo "<br><table align='right' cellspacing='{$display->cellspacing}' cellpadding='{$display->cellpadding}' bgcolor='{$display->table_bgcolor}' width='60%' border=0>";
