<?php require 'lib/Inter.php'; $Y = new Inter(); $accion = $_POST['tipo']; switch ($accion) { case 1: $verdatos = $Y->SeleccionarCitasActivas(); $tabla = "<table class='table table-bordered'>\n <tr>\n <td></td>\n <td>Nombre Doc/Psi</td>\n <td>Paciente</td>\n <td>Numero Cita</td>\n <td>Fecha</td>\n </tr>"; foreach ($verdatos as $us) { $cont++; $userDatos = $Y->BuscarUsuarioId($us['idUsuario']); foreach ($userDatos as $key) { $nombreUsuario = $key['nombre'] . " " . $key['apellido']; $tipoUser = $key['tipoUser']; } switch ($tipoUser) { case '1': $type = 'Doctor'; break; case '2': $type = 'Psicologo'; break; } $pacienData = $Y->SeleccionarPacienteCodigo($us['codigoPaciente']); foreach ($pacienData as $key) { $nombrePacie = $key['nombre'] . " " . $key['apellido']; } $tabla .= "<tr>\n <td>" . utf8_encode($type) . "</td>\n <td>" . utf8_encode($nombreUsuario) . "</td>\n <td>" . utf8_encode($nombrePacie) . "</td>\n <td>" . utf8_encode($us['numeroCita']) . "</td>\n <td>" . utf8_encode($us['fechaCita']) . "</td>\n <td><a href=\"#\" class=\"btn-eliminar\" data-param=" . $us['idCita'] . ">Eliminar</a></td>\n <td><a href=\"#\" class=\"btn-editar\" data-param=" . $us['idCita'] . " data-toggle=\"modal\" data-target=\".bs-example-modal-lg\">Editar</a></td>\n </tr>"; } $tabla .= '</table>';