PHP obtenerSelect Examples

Example #1

File: testselect.php Project: halvgud/scproject

<?php

require_once 'core.php';
require_once "Roles.php";
require_once "PrivilegiosUsuario.php";
$data = json_decode(file_get_contents('php://input'));
if (isset($data) && isset($data->idTransaccion)) {
    $resultado = array();
    $resultado = obtenerSelect($data);
    print json_encode($resultado);
}
function obtenerSelect($data)
{
    if ($data->idTransaccion == '1') {
        $db = new Conexion();
        $db->abrirConexion();
        $db->seleccion('descripcion', 'id_descripcion,descripcion', null, 'estado="A"  and tipo="' . $data->tipo . '" ', 'id_descripcion asc', null);
        return $db->obtenerResultado();
    } else {
        if ($data->idTransaccion == '2') {
            $db = new Conexion();
            $db->abrirConexion();
            $db->seleccion('medicamento', 'id_medicamento,descripcion', null, 'estado="A"', 'id_medicamento asc', null);
            return $db->obtenerResultado();
        } else {
            if ($data->idTransaccion == '3') {
                $db = new Conexion();
                $db->abrirConexion();
                $db->seleccion('presentacion_medicamento', 'id_presentacion,presentacion_medicamento.descripcion', "medicamento md on (md.id_presentacion_salida=presentacion_medicamento.id_presentacion)", "md.estado='A' and md.id_medicamento='" . $data->idBusqueda . "'", 'id_presentacion asc', null);
                return $db->obtenerResultado();
            } else {

Example #2

File: pdf_visita_rango_fecha.php Project: halvgud/scproject

<?php

require_once 'data/testselect.php';
$data = new ArrayObject();
$data->idTransaccion = '14';
$data->fecha_inicio = $_POST['fecha_inicio'];
$data->fecha_fin = $_POST['fecha_fin'];
$visitas = obtenerSelect($data);
//var_dump($visitas );
$tabla = '';
foreach ($visitas as &$visita) {
    $tabla .= '<tr><td>' . $visita['id_empleado'] . '</td>' . '<td>' . $visita['nombre'] . '</td>' . '<td>' . $visita['turno'] . '</td>' . '<td>' . $visita['area'] . '</td>' . '<td>' . $visita['departamento'] . '</td><td>';
    foreach ($visita['medicamentos'] as $medicamento) {
        $tabla .= $medicamento['descripcion'] . '<br>';
    }
    $tabla .= '</td><td>' . $visita['fecha'] . '</td><td>' . $visita['proceso'] . '</td></tr>';
}
$tabla = '<table class="bpmTopnTail" border="1" style="margin:0 auto;"><thead><tr class="headerrow"><th>ID EMPLEADO</th><th>NOMBRE</th>
<th>TURNO</th>
<th>AREA</th>
<th>DEPARTAMENTO</th>
<th>MEDICAMENTO(S)</th>
<th>FECHA</th><th>PROCESO</th></tr></thead><tbody>' . $tabla . '</tbody></table>';
$html = $tabla;
//==============================================================
//==============================================================
//==============================================================
define('_MPDF_URI', 'data/lib/mpdf60/');
include "data/lib/mpdf60/mpdf.php";
$mpdf = new mPDF('utf-8', 'Leter-L', 0, '', 15, 15, 40, 16, 5, 9);
$mpdf->SetDisplayMode('fullpage');

Example #3

File: pdf_consulta_rango_fecha.php Project: halvgud/scproject

<?php

require_once 'data/testselect.php';
$data = new ArrayObject();
$data->idTransaccion = '26';
$data->fecha_inicio = $_POST['fecha_inicio'];
$data->fecha_fin = $_POST['fecha_fin'];
$consultas = obtenerSelect($data);
//var_dump($visitas );
$tabla = '';
foreach ($consultas as &$consulta) {
    $tabla .= '<tr><td>' . $consulta['id_empleado'] . '</td>' . '<td>' . $consulta['nombre'] . '</td>' . '<td>' . $consulta['turno'] . '</td>' . '<td>' . $consulta['area'] . '</td>' . '<td>' . $consulta['departamento'] . '</td><td>';
    foreach ($consulta['medicamentos'] as $medicamento) {
        $tabla .= $medicamento['descripcion'] . '<br>';
    }
    $tabla .= '</td><td>' . $consulta['fecha'] . '</td><td>' . $consulta['proceso'] . '</td></tr>';
}
$tabla = '<table class="bpmTopnTail" border="1" style="margin:0 auto;"><thead><tr class="headerrow">
<th>ID EMPLEADO</th>
<th>NOMBRE</th>
<th>TURNO</th>
<th>AREA</th>
<th>DEPARTAMENTO</th>
<th>MEDICAMENTO(S)</th>
<th>FECHA</th>
<th>PROCESO</th></tr></thead><tbody>' . $tabla . '</tbody></table>';
$html = $tabla;
//==============================================================
//==============================================================
//==============================================================
define('_MPDF_URI', 'data/lib/mpdf60/');