case 'get':
$res = $objcomisiones->searchDB($_POST['id'], 'id', 1);
if (is_array($res)) {
$res[0]['id_turno'] = $objturno->searchDB($res[0]['id_turno'], 'id', 1);
$res[0]['id_turno'] = $res[0]['id_turno'][0];
$res[0]['id_conductor'] = $objconductor->searchDB($res[0]['id_conductor'], 'id', 1);
$res[0]['id_conductor'] = $res[0]['id_conductor'][0];
$res[0]['id_supervisor'] = $objsupervisor->searchDB($res[0]['id_supervisor'], 'id', 1);
$res[0]['id_supervisor'] = $res[0]['id_supervisor'][0];
echo json_encode($res[0]);
} else {
echo json_encode(0);
}
break;
case 'list':
$res = $objcomisiones->listDB();
if (is_array($res)) {
foreach ($res as &$act) {
$act['id_turno'] = $objturno->searchDB($act['id_turno'], 'id', 1);
$act['id_turno'] = $act['id_turno'][0];
$act['id_conductor'] = $objconductor->searchDB($act['id_conductor'], 'id', 1);
$act['id_conductor'] = $act['id_conductor'][0];
$act['id_supervisor'] = $objsupervisor->searchDB($act['id_supervisor'], 'id', 1);
$act['id_supervisor'] = $act['id_supervisor'][0];
}
echo json_encode($res);
} else {
echo json_encode(0);
}
break;
case 'search':
<?php
require_once 'globales_sistema.php';
if (!isset($_COOKIE['nombre_usuario'])) {
header('Location: index.php');
}
$titulo_pagina = 'Reporte Comisiones';
$titulo_sistema = 'Mamut Peru';
require_once 'recursos/componentes/header.php';
?>
</form>
<hr/>
<?php
include_once 'nucleo/comisiones.php';
$obj = new comisiones();
$objs = $obj->listDB();
include_once 'nucleo/turno.php';
include_once 'nucleo/conductor.php';
include_once 'nucleo/supervisor.php';
?>
<div class='contenedor-tabla'>
<table id='tb' class='display' cellspacing='0' width='100%'>
<thead>
<tr>
<th>Id</th>
<th>Fecha</th>
<th>Turno</th>
<th>Conductor</th>
<th>Vueltas Por Comision</th>
<th>Monto</th>
<th>Motivo</th>