</td>
<td width="110">
# cuenta de banco
</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;
<table border="0" cellspacing="5" cellpadding="0" width="100%" class="pdfContentStyle">
<tr>
<td width="60">
</td>
<td width="120">
Nombre
</td>
<td width="90">
Fecha de nacimiento
</td>
<td width="110">
Edad
</td>
</tr>
';
$ModelAgents = new ModelAgents();
$agents = $ModelAgents->getBirthsByDate($_POST['optMonth']);
if (mysql_num_rows($agents) > 0) {
while ($agent = mysql_fetch_assoc($agents)) {
$yearsOld = date('Y') - $agent['birthYear'];
$html .= '
<tr align="left" valign="top">
<td>
<img src="../../data/temp/' . $agent['identify'] . '" width="90">
</td>
<td>
' . $agent['name'] . ' ' . $agent['lname'] . '
</td>
<td>
' . $agent['birthDay'] . '
</td>
<?php
require_once '../models/ModelAgents.php';
$ModelAgents = new ModelAgents();
$agents = $ModelAgents->getAgents();
while ($first = mysql_fetch_assoc($agents)) {
$firstArray[] = $first['name'] . ' ' . $first['lname'];
}
$agents = $ModelAgents->getAgents();
while ($second = mysql_fetch_assoc($agents)) {
$secondArray[] = $second['id_agents'];
}
$q = strtolower($_GET["term"]);
if (!$q) {
return;
}
$items = array_combine($firstArray, $secondArray);
// $items = array
// (
// "Great Bittern"=>"Botaurus stellaris",
// );
function array_to_json($array)
{
if (!is_array($array)) {
return false;
}
$associative = count(array_diff(array_keys($array), array_keys(array_keys($array))));
if ($associative) {
$construct = array();
foreach ($array as $key => $value) {
// We first copy each key/value pair into a staging array,
