';
$ModelAgents = new ModelAgents();
$ModelContraventions = new ModelContraventions();
$ModelFines = new ModelFines();
$ModelRanges = new ModelRanges();
$agents = $ModelAgents->getAgentsBySituation();
if (mysql_num_rows($agents) > 0) {
while ($agent = mysql_fetch_assoc($agents)) {
$contraventionsMoney = 0;
$contraventions = $ModelContraventions->getContraventionsByDate($_POST['optMonth'], $_POST['optYear'], $agent['id_agents']);
if (mysql_num_rows($contraventions) > 0) {
while ($contravention = mysql_fetch_assoc($contraventions)) {
$contraventionsMoney += $ModelFines->getPriceFine($contravention['id_fines']);
}
}
$money = $ModelRanges->getMoneyRange($agent['id_ranges']);
$contraventionsMoney = $contraventionsMoney * 0.1;
$total = $money + $contraventionsMoney;
$html .= '
<tr align="left" valign="top">
<td>
<img src="../../data/temp/' . $agent['identify'] . '" width="90">
</td>
<td>
' . $agent['name'] . ' ' . $agent['lname'] . '
</td>
<td>
' . $agent['ced'] . '
</td>
<td>
' . $agent['noAccount'] . '
