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>