$i = 0;
$sum_row = 0;
$sum_all = 0;
$sum_oil = 0;
$sum_gas = 0;
$sum_allowance_driver = 0;
$sum_expense = 0;
$sum_expense_etc = 0;
$total = 0;
foreach ($result as $rs) {
$i++;
$allowance_driver = (int) trim(substr($rs['allowance_driver1'], 6, 10)) + (int) trim(substr($rs['allowance_driver1'], 6, 10));
//เบี้ยเลี้ยง
$expense = $assign->sum_expense_truck_in_assignid($rs['assign_id']);
//ค่าใช้จ่ายเกี่ยวกับรถ
$expense_etc = $outgoing->sum_expense_in_assignid($rs['assign_id']);
//ค่าใช้จ่ายอื่น ๆ
$sum_row = $rs['oil_price'] + $rs['gas_price'] + (int) $expense + $allowance_driver + (int) $expense_etc;
$sum_all = $sum_all + $sum_row;
$sum_oil = $sum_oil + $rs['oil_price'];
$sum_gas = $sum_gas + $rs['gas_price'];
$sum_allowance_driver = $sum_allowance_driver + $allowance_driver;
$sum_expense = $sum_expense + $expense;
$sum_expense_etc = $sum_expense_etc + $expense_etc;
?>
<tr>
<th><?php
echo $rs['assign_id'];
?>
</th>
<th><?php
