</td> <td width="100"> Salario base </td> <td width="100"> Comisión(10%) </td> <td width="100"> Salario total </td> </tr> '; $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">
<?php require_once '../models/ModelAgents.php'; require_once '../models/ModelRanges.php'; $ModelAgents = new ModelAgents(); $ModelRanges = new ModelRanges(); $agents = $ModelAgents->getAgentsBySituation(); ?> <script type="text/javascript"> var departaments = [ <?php while ($agent = mysql_fetch_assoc($agents)) { $range = mysql_fetch_assoc($ModelRanges->getRangeById($agent['id_ranges'])); echo '[\'<div style="width:300px;"><div style="float:left;padding-right:5px;"><img src="data/temp/' . $agent['identify'] . '" width="80" style="border:1px #494949 solid;"/></div><div style="text-align:left;">Nombre: ' . $agent['name'] . ' ' . $agent['lname'] . '<br/>Cédula: ' . $agent['ced'] . '<br/>Rango: ' . $range['title'] . '<br/>Asignado en: ' . $agent['placeAssig'] . '</div></div>\', ' . $agent['latitude'] . ',' . $agent['longitude'] . ', 4],'; } ?> ]; var map = new google.maps.Map(document.getElementById('map'), { zoom: 8, center: new google.maps.LatLng(18.812718, -70.298767), mapTypeId: google.maps.MapTypeId.ROADMAP }); var infowindow = new google.maps.InfoWindow(); var marker, i; for (i = 0; i < departaments.length; i++) { marker = new google.maps.Marker({