function displayWithSumRow($business, $loai, $monthFrom, $monthTo, $year)
{
$str = null;
$str .= '<table width="70%" border="0" align="center" cellspacing="0" cellpadding="0" id="tblist">';
$str .= '<tr class="title">';
$str .= '<td width="30px" align="center">#</td>';
$str .= '<td width="30px" align="center">';
$str .= '<input type="checkbox" name="cbAll" id="cbAll" onclick="checkALL()"/></td>';
$str .= '<td width="70px" align="center">Ngày thu</td>';
$str .= '<td align="center">Công việc</td>';
$str .= '<td width="20%">Nhân viên thu</td>';
$str .= '<td align="right" width="100px">Số tiền</td>';
$str .= '</tr>';
for ($i = 0; $i < count($business); $i++) {
$user = UsersBUS::GetUserByID($business[$i]['nhanvien']);
$dvTien = DonViTienBUS::selectId($business[$i]['donvi']);
$str .= '<tr>';
$str .= '<td align="center">' . ($i + 1) . '</td>';
$str .= '<td align="center"><input type="checkbox" name="cbId[]" id="cbId[]" value="' . $business[$i]['id'] . '"></td>';
$str .= '<td align="center">' . $business[$i]["ngay"] . '</td>';
$str .= '<td>' . $business[$i]["congviec"] . '</td>';
$str .= '<td>' . $user['hoten'] . '</td>';
$str .= '<td align="right">' . number_format($business[$i]["sotien"]) . ' ' . $dvTien['ten'] . '</td>';
$str .= '</tr>';
}
$str .= '<tr>';
$str .= '<td align="right" colspan="5"><b>Tổng thu:</b></td>';
$sumRow = null;
if ($monthTo == null && $monthFrom == null && $year == null) {
$sumRow = ThuChiBUS::SumTongTien($loai);
} else {
$sumRow = ThuChiBUS::SumTongTienByMonth($loai, $monthFrom, $monthTo, $year);
}
$str .= '<td align="right"><b>' . $sumRow[0] . ' vnd</b></td>';
$str .= '</tr>';
$str .= '</table>';
$str .= "<script>\$(\"table[id='tblist'] tr:even\").css('background-color', '#EFEFEF');</script>";
return $str;
}
break;
case 4:
$thu = ThuChiBUS::SumTongTienByMonth(0, 10, 12, $nam);
$chi = ThuChiBUS::SumTongTienByMonth(1, 10, 12, $nam);
$thu = $thu == null ? 0 : $thu;
$chi = $chi == null ? 0 : $chi;
echo ProfitProcessor::display('Thống kê quý ' . $quy . '/' . $nam, $chi, $thu, $thu - $chi);
break;
default:
$thu = ThuChiBUS::SumTongTienByMonth(0, 1, 12, $nam);
$chi = ThuChiBUS::SumTongTienByMonth(1, 1, 12, $nam);
$thu = $thu == null ? 0 : $thu;
$chi = $chi == null ? 0 : $chi;
echo ProfitProcessor::display('Thống kê năm ' . $nam, $chi, $thu, $thu - $chi);
break;
}
} else {
$thu = ThuChiBUS::SumTongTienByMonth(0, 1, 12, $nam);
$chi = ThuChiBUS::SumTongTienByMonth(1, 1, 12, $nam);
$thu = $thu == null ? 0 : $thu;
$chi = $chi == null ? 0 : $chi;
echo ProfitProcessor::display('Thống kê năm ' . $nam, $chi, $thu, $thu - $chi);
}
} else {
$thu = ThuChiBUS::SumTongTienByMonth(0, 1, 12, date("Y"));
$chi = ThuChiBUS::SumTongTienByMonth(1, 1, 12, date("Y"));
$thu = $thu == null ? 0 : $thu;
$chi = $chi == null ? 0 : $chi;
echo ProfitProcessor::display('Thống kê năm ' . date("Y"), $chi, $thu, $thu - $chi);
}
}
