Exemple #1
0
        echo $o['apellidos'];
        ?>
</td><td><?php 
        echo $o['dni'];
        ?>
</td><td><?php 
        echo $o['numero_licencia'];
        ?>
</td><td><?php 
        echo $o['tipo_licencia'];
        ?>
</td><td>
                            <?php 
        $objgrupo_conductor = new grupo_conductor();
        $objgrupo_conductor->setVar('id', $o['id_grupo_conductor']);
        $objgrupo_conductor->getDB();
        echo $objgrupo_conductor->getVar($gl_conductor_id_grupo_conductor);
        ?>
</td>
                        <td><a href='#' onclick='sel(<?php 
        echo $o['id'];
        ?>
)'>MOD</a> - <a href='#' onclick='del(<?php 
        echo $o['id'];
        ?>
)'>DEL</a></td>
                    </tr>
                    <?php 
    }
}
?>
if (isset($_GET["nfac"])) {
    if ($_GET["nfac"] !== "") {
        $sql_where .= " AND r.numero_facturacion = '" . $_GET["nfac"] . "'";
    }
}
$objconductor = new conductor();
$cons = $objconductor->listDB();
if (is_array($cons)) {
    foreach ($cons as $co) {
        $total = 0;
        echo "<tr>";
        echo "<td>" . $co["codigo"] . "</td>";
        echo "<td>" . $co["nombres"] . " " . $co["apellidos"] . "</td>";
        $objgc = new grupo_conductor();
        $objgc->setId($co["id_grupo_conductor"]);
        $objgc->getDB();
        echo "<td>" . $objgc->getNombre() . "</td>";
        if (isset($_GET["fi"])) {
            if ($_GET["fi"] !== "" && $_GET["ff"] !== "") {
                $fecha1 = $_GET["fi"];
                $fecha2 = $_GET["ff"];
                for ($i = $fecha1; $i <= $fecha2; $i = date("Y-m-d", strtotime($i . "+ 1 days"))) {
                    $objreg = new registro();
                    $conteo = $objreg->consulta_arreglo("Select count(id) as cnt from registro WHERE id_conductor = '" . $co["id"] . "' AND fecha = '" . $i . "'");
                    echo "<td>" . intval($conteo["cnt"]) . "</td>";
                    $total = $total + intval($conteo["cnt"]);
                }
            }
        }
        echo "<td>" . $total . "</td>";
        echo "</tr>";