PHP Cisterna::buscar_cisternas примеры использования

Пример #1

Файл: certificacion.php Проект: hlrd93/PDVSA-ENT

<?php

include_once "../config/init.php";
$resultado_listado = Cisterna::buscar_cisternas($_POST['placa'], $_POST['serial'], "", "", "", "");
if ($resultado_listado == true) {
    foreach ($resultado_listado as $row) {
        echo "<div class='table-responsive'>";
        echo "<table class='table table-hover table-condensed'>";
        echo "<thead>";
        echo "<tr>\n                <th class='text-center'>Ficha</th>\n                <th class='text-center'>#</th>\n                <th class='text-center'>Placa</th>\n                <th class='text-center'>Placa Nueva</th>\n                <th class='text-center'>Serial de Carroceria</th>\n                <th class='text-center'>Marca</th>\n                <th class='text-center'>Tipo</th>\n            </tr>";
        echo "</thead>";
        echo "<tbody>";
        echo "<tr>";
        echo '<td class="text-center">
                        <a rel=' . $row->id_cisterna . ' href="./reporte.php?id=' . $row->id_cisterna . '" class="btn btn-danger btn-xs btn-block" target="_blank">PDF</a></td>';
        echo '<th class="text-center" scope="row">' . $row->id_cisterna . '</th>';
        echo "<td class='text-center'>" . $row->placa_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->placa_nueva_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->serial_carroceria_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->marca_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->tipo_cisterna . "</td>";
        echo "</tr>";
        echo "</tbody>";
        echo "<thead>";
        echo "<tr>\n                <th class='text-center'>Modelo</th>\n                <th class='text-center'>Año</th>\n                <th class='text-center'>Color</th>\n                <th class='text-center'>Observacion</th>\n                <th class='text-center'>Fecha Modificacion</th>\n                <th class='text-center'>Sede</th>\n                <th class='text-center'>Estatus</th>\n            </tr>";
        echo "</thead>";
        echo "<tbody>";
        echo "<tr>";
        echo "<td class='text-center'>" . $row->modelo_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->a_o_cisterna . "</td>";
        echo '<td class="text-center borde" style="background-color:' . $row->color_cisterna_1 . ';"><b>' . $row->nombre_color_cisterna . '</b></td>';

Пример #2

Файл: listar.php Проект: hlrd93/PDVSA-ENT

<?php

include_once "../config/init.php";
$resultado_listado = Cisterna::buscar_cisternas("", "", "", "", "", "");
echo "<div class='table-responsive'>";
echo "<table class='table table-hover table-condensed'>";
echo "<thead>";
echo "<tr>\n        <th class='text-center'>Actualizar</th>\n        <th class='text-center'>#</th>\n        <th class='text-center'>Placa</th>\n        <th class='text-center'>Placa Nueva</th>\n        <th class='text-center'>Serial de Carroceria</th>\n        <th class='text-center'>Marca</th>\n        <th class='text-center'>Tipo</th>\n        <th class='text-center'>Modelo</th>\n        <th class='text-center'>Año</th>\n        <th class='text-center'>Color 1</th>\n        <th class='text-center'>Color 2</th>\n        <th class='text-center'>Nro. Ejes</th>\n        <th class='text-center'>1er Compartimiento <small>(lts)</small></th>\n        <th class='text-center'>2do Compartimiento <small>(lts)</small></th>\n        <th class='text-center'>3er Compartimiento <small>(lts)</small></th>\n        <th class='text-center'>Total Compartimientos <small>(lts)</small></th>\n        <th class='text-center'>Observacion</th>\n        <th class='text-center'>Fecha Modificacion</th>\n        <th class='text-center'>Sede</th>\n        <th class='text-center'>Estatus</th>\n        </tr>";
echo "</thead>";
foreach ($resultado_listado as $row) {
    echo "<tbody>";
    echo "<tr>";
    echo '<td class="text-center">
            <button type="submit" rel=' . $row->id_cisterna . ' class="actualizar btn btn-success btn-xs btn-block" data-toggle="modal" data-target="#myModal">Actualizar</button>
        </td>';
    echo '<th scope="row" class="text-center">' . $row->id_cisterna . '</th>';
    echo "<td class='text-center'>" . $row->placa_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->placa_nueva_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->serial_carroceria_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->marca_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->tipo_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->modelo_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->a_o_cisterna . "</td>";
    echo '<td class="borde text-center" style="background-color:' . $row->color_cisterna_1 . ';"><b>' . $row->nombre_color_cisterna . '</b></td>';
    echo '<td class="borde text-center" style="background-color:' . $row->color_cisterna_2 . ';"><b>' . $row->nombre_color_cisterna . '</b></td>';
    echo "<td class='text-center'>" . $row->nro_ejes_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->capacidad_1erc_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->capacidad_2doc_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->capacidad_3erc_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->capacidad_totalc_cisterna . "</td>";
    echo "<td class='text-center'>" . $row->observacion_cisterna_estado . "</td>";

Пример #3

Файл: buscar.php Проект: hlrd93/PDVSA-ENT

<?php

include_once "../config/init.php";
$resultado_listado = Cisterna::buscar_cisternas($_POST['placa'], $_POST['serial'], $_POST['sede'], $_POST['estatus'], $_POST['tipo'], $_POST['a_o']);
if ($resultado_listado == true) {
    //echo "<div class='table-responsive'>";
    echo "<table class='table table-hover table-condensed'>";
    echo "<thead>";
    echo "<tr>\n            <th class='text-center'>#</th>\n            <th class='text-center'>Placa</th>\n            <th class='text-center'>Placa Nueva</th>\n            <th class='text-center'>Serial de Carroceria</th>\n            <th class='text-center'>Marca</th>\n            <th class='text-center'>Tipo</th>\n            <th class='text-center'>Modelo</th>\n            <th class='text-center'>Año</th>\n            <th class='text-center'>Color 1</th>\n            <th class='text-center'>Color 2</th>\n            <th class='text-center'>Nro. Ejes</th>\n            <th class='text-center'>1er Compartimiento <small>(lts)</small></th>\n            <th class='text-center'>2do Compartimiento <small>(lts)</small></th>\n            <th class='text-center'>3er Compartimiento <small>(lts)</small></th>\n            <th class='text-center'>Total Compartimientos <small>(lts)</small></th>\n            <th class='text-center'>Observacion</th>\n            <th class='text-center'>Fecha Modificacion</th>\n            <th class='text-center'>Sede</th>\n            <th class='text-center'>Estatus</th>\n        </tr>";
    echo "</thead>";
    foreach ($resultado_listado as $row) {
        echo "<tbody>";
        echo "<tr>";
        echo '<th class="text-center" scope="row">' . $row->id_cisterna . '</th>';
        echo "<td class='text-center'>" . $row->placa_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->placa_nueva_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->serial_carroceria_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->marca_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->tipo_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->modelo_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->a_o_cisterna . "</td>";
        echo '<td class="text-center borde" style="background-color:' . $row->color_cisterna_1 . ';"><b>' . $row->nombre_color_cisterna . '</b></td>';
        echo '<td class="text-center borde" style="background-color:' . $row->color_cisterna_2 . ';"><b>' . $row->nombre_color_cisterna . '</b></td>';
        echo "<td class='text-center'>" . $row->nro_ejes_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->capacidad_1erc_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->capacidad_2doc_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->capacidad_3erc_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->capacidad_totalc_cisterna . "</td>";
        echo "<td class='text-center'>" . $row->observacion_cisterna_estado . "</td>";
        echo "<td class='text-center'>" . $row->fecha_cisterna_estado . "</td>";
        echo "<td class='text-center'>" . $row->nombre_sede . "</td>";