Example #1
0
				</td>
				<td width="100">	
					Salario base
				</td>
				<td width="100">	
					Comisi&oacute;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&eacute;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({