public static function usersReport() { $conn = new Connect(); $query = 'SELECT * FROM ' . self::DB_TBL_USUARIOS; $consult = $conn->prepare($query); $consult->execute(); if ($consult->rowCount() > 0) { header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;filename="Reporte de usuarios.xlsx"'); header('Cache-Control: max-age=0'); $reportName = "Reporte de usuarios"; $reportNameTitles = array("Id", "Cédula", "Nombres", "Apellidos", "Email", "Teléfono", "Extensión", "Usuario", "Contrasena", "Rol"); $styleColumnsTitle = array('font' => array('name' => 'Arial', 'bold' => true)); $generarReporteXLSX = new PHPExcel(); $generarReporteXLSX->getProperties()->setCreator("VideoConferencias UTPL")->setLastModifiedBy("VideoConferencias UTPL")->setTitle("Reporte de usuarios")->setSubject("Reporte de usuarios")->setDescription("Reporte de usuarios")->setKeywords("Reporte de usuarios")->setCategory("Reportes"); $generarReporteXLSX->setActiveSheetIndex(0)->mergeCells('A1:J1'); $generarReporteXLSX->setActiveSheetIndex(0)->setCellValue('A1', $reportName)->setCellValue('A3', $reportNameTitles[0])->setCellValue('B3', $reportNameTitles[1])->setCellValue('C3', $reportNameTitles[2])->setCellValue('D3', $reportNameTitles[3])->setCellValue('E3', $reportNameTitles[4])->setCellValue('F3', $reportNameTitles[5])->setCellValue('G3', $reportNameTitles[6])->setCellValue('H3', $reportNameTitles[7])->setCellValue('I3', $reportNameTitles[8])->setCellValue('J3', $reportNameTitles[9]); $i = 4; while ($row = $consult->fetch()) { $generarReporteXLSX->setActiveSheetIndex(0)->setCellValue('A' . $i, $row['id'])->setCellValue('B' . $i, $row['cedula'])->setCellValue('C' . $i, $row['nombres'])->setCellValue('D' . $i, $row['apellidos'])->setCellValue('E' . $i, $row['email'])->setCellValue('F' . $i, $row['telefono'])->setCellValue('G' . $i, $row['telefono_ext'])->setCellValue('H' . $i, $row['usuario'])->setCellValue('I' . $i, $row['contrasena'])->setCellValue('J' . $i, $row['id_rol']); $i++; } $generarReporteXLSX->getActiveSheet()->getStyle('A3:J3')->applyFromArray($styleColumnsTitle); $generarReporteXLSX->getActiveSheet()->setTitle('Usuarios'); $generarReporteXLSX->setActiveSheetIndex(0); $generarReporteXLSX->getActiveSheet(0)->freezePaneByColumnAndRow(0, 4); $objWriter = PHPExcel_IOFactory::createWriter($generarReporteXLSX, 'Excel2007'); $objWriter->save('php://output'); exit; } }
public static function login($usu_usuario, $usu_contrasena) { $conn = new Connect(); $u = new Utils(); $query = 'SELECT * FROM ' . self::DB_TBL_USUARIO . ' WHERE usu_usuario = :usu_usuario'; $consult = $conn->prepare($query); $consult->bindParam(':usu_usuario', $usu_usuario); $consult->execute(); $row = $consult->fetch(); if ($consult->rowCount() > 0) { $passValidate = $u->passValidate($usu_contrasena, $row['usu_contrasena']); if ($passValidate == true) { if ($row['usu_id_rol'] == 1) { session_start(); $_SESSION['session'] = $row['usu_usuario']; echo "<script>location.href='../../mod_admin/vista/administrador.php'</script>"; } else { session_start(); $_SESSION['session'] = $row['usu_usuario']; echo "<script>location.href='../../mod_admin/vista/tecnico.php'</script>"; } } else { echo "<script>alert('Error de autenticación. Por favor verifique sus credenciales de acceso.')</script>"; echo "<script>location.href = '../vista/form_login.php' </script>"; return false; } } else { echo "<script>alert('Error de autenticación.')</script>"; echo "<script>location.href = '../vista/form_login.php' </script>"; return false; } }
public function __construct() { $db = new Connect(); $act = $db->query("SELECT ultima_act FROM generales LIMIT 1;"); $actualizacion = $db->recorrer($act); if (time() >= $actualizacion[0]) { $tops = $db->query("SELECT id,puntos FROM usuarios ORDER by puntos DESC;"); $tope = 1; $psql = "UPDATE usuarios SET top = ? WHERE id = ? LIMIT 1;"; $prepare_query = $db->prepare($psql); $prepare_query->bind_param('ii', $nuevo_top, $id_user); while ($top = $db->recorrer($tops)) { $nuevo_top = $tope++; $id_user = $top['id']; $prepare_query->execute(); } $timer = time() + 30; $query = $db->query("UPDATE generales SET ultima_act='{$timer}' LIMIT 1;"); $prepare_query->close(); unset($actualizar, $tops, $timer, $tope, $query); } else { unset($actualizacion); } $db->liberar($act); $db->close(); }
public static function getAllConfirmReserves() { $conn = new Connect(); $query = 'SELECT * ' . 'FROM reserva RE, res_fecha FE, confirmacion_reserva CON, con_imagen IMA, con_canal CAN ' . 'WHERE RE.res_estado = 1 ' . 'AND FE.fe_id_reserva = RE.res_id ' . 'AND con.con_id_reserva = RE.res_id ' . 'AND IMA.con_id = CON.con_id_imagen ' . 'AND CAN.can_id = CON.con_id_canal ' . 'ORDER BY FE.start ASC ' . 'LIMIT 4'; $consult = $conn->prepare($query); $consult->execute(); $row = $consult->fetchAll(PDO::FETCH_ASSOC); return json_encode($row, JSON_UNESCAPED_UNICODE); }
public static function getAllUsersById($id) { $conn = new Connect(); $query = 'SELECT * FROM usuarios WHERE id=:id'; $consult = $conn->prepare($query); $consult->bindParam(":id", $id); $consult->execute(); $row = $consult->fetchAll(PDO::FETCH_ASSOC); return json_encode($row, JSON_UNESCAPED_UNICODE); }
public static function elimina($con_id) { $conexion = new Connect(); $query = 'DELETE FROM ' . self::DB_TBL_CONFIRMACION . ' WHERE con_id = ' . $con_id; $consulta = $conexion->prepare($query); if ($consulta->execute()) { // $this->con_id = $conexion->lastInsertId(); //echo "<script>alert('Datos actualizados correctamente')</script>"; return 1; } else { //echo $consulta->errorCode(); //echo "<script>alert('Error al actualizar datos')</script>"; echo $consulta->errorCode(); return 0; } }
public static function borrarCentro($map_id) { $conn = new Connect(); $query = "DELETE FROM " . self::DB_TBL_CENTROS_MAP . " WHERE map_id=" . $map_id; $consult = $conn->prepare($query); if ($consult->execute()) { echo "<script>alert('Usuario eliminado correctamente')</script>"; echo "<script>location.href='../vista/ges_centros.php'</script>"; } else { echo "<script>alert('Ha ocurrido un error')</script>"; } }
public static function presentar_Eventos() { $conn = new Connect(); $query = "SELECT * FROM con_tipo_evento"; $consult = $conn->prepare($query); $consult->execute(); $row = $consult->fetchAll(PDO::FETCH_ASSOC); foreach ($row as $i) { echo "<tr>"; echo "<td>" . $i['tip_nombre'] . "</td>"; echo "<td><a href='../controlador/eliminar_reserva.php?id=" . $i['tip_id'] . "' onclick='return confirm(\"¿Realmente desea eliminar la reserva?\");'><span class='glyphicon glyphicon-remove' aria-hidden='true'></span></a></td>"; echo "</tr>"; } }
private function __construct() { require 'core/models/class.User.php'; require 'core/models/implement.Menu.php'; require 'core/models/class.Planet.php'; require 'core/models/implement.Topnav.php'; global $id_user, $id_planet; $lng = new Lang(); $menu = new Menu($id_user); $topnav = new Topnav($id_planet, $id_user); $user = new User($id_user); $db = new Connect(); $sql = $db->query("SELECT sistema FROM planetas WHERE id_planeta='{$id_planet}' LIMIT 1;"); $system = $db->recorrer($sql); $db->liberar($sql); if (isset($_GET['sistema']) and is_numeric($_GET['sistema']) and $_GET['sistema'] > 0 and $_GET['sistema'] <= 700) { $this->system_id = intval($_GET['sistema']); } else { $this->system_id = intval($system['sistema']); } unset($system, $sql); $x = 1; $psql = "SELECT SQL_BIG_RESULT DISTINCT id_planeta, pos, nombre, imagen, usuario, id_dueno \n FROM planetas JOIN usuarios \n ON planetas.id_dueno=usuarios.id WHERE sistema=? \n AND pos=? ORDER BY pos ASC LIMIT 1;"; $prepare_sql = $db->prepare($psql); $prepare_sql->bind_param('ii', $orbit, $system_id); while ($x < 16) { $orbit = $x; $system_id = $this->system_id; $prepare_sql->execute(); $id_planeta = ''; $pos = ''; $nombre = ''; $imagen = ''; $usuario = ''; $id_dueno = ''; $prepare_sql->bind_result($id_planeta, $pos, $nombre, $imagen, $usuario, $id_dueno); $prepare_sql->fetch(); $o_s = "&o={$x}&s={$this->system_id}"; if ($x != $pos) { if ($x == 1 or $x == 5 or $x == 9 or $x == 13) { $universe[] = array('posicion' => $x, 'nombre' => 'Brecha', 'imagen' => 'brecha_espacio', 'usuario' => 'Agujero de gusano', 'escombros' => 'no_in', 'luna' => 'no_in', 'habitado' => 'deshabitado', 'accion' => '<a href=\'?core=fleets&mision=saltar' . $o_s . '\'>' . $lng->x_saltar . '</a>'); } else { $universe[] = array('posicion' => $x, 'nombre' => 'Planeta Habitable', 'imagen' => 'planeta_desconocido', 'usuario' => 'La atmósfera es apta para colonizar', 'escombros' => 'no_in', 'luna' => 'no_in', 'habitado' => 'deshabitado', 'accion' => '<a href=\'?view=flotas&mision=colonizar' . $o_s . '\'>' . $lng->x_colonizar . '</a>'); } } else { if ($id_dueno == $id_user and $id_planeta != $id_planet) { $universe[] = array('posicion' => $pos, 'nombre' => $nombre, 'imagen' => $imagen, 'usuario' => $usuario, 'escombros' => 'no_es', 'luna' => 'no_es', 'habitado' => 'habitado', 'accion' => '<a href=\'?view=flotas&mision=transportar' . $o_s . '\'>' . $lng->x_transportar . '</a> | <a href=\'?view=flotas&mision=desplegar' . $o_s . '\'>' . $lng->x_desplegar . '</a>'); } else { if ($id_planeta == $id_planet and $id_dueno == $id_user) { $universe[] = array('posicion' => $pos, 'nombre' => $nombre, 'imagen' => $imagen, 'usuario' => $usuario, 'escombros' => 'no_es', 'luna' => 'no_es', 'habitado' => 'habitado', 'accion' => '<br />' . $lng->x_no_hay . ''); } else { $universe[] = array('posicion' => $pos, 'nombre' => $nombre, 'imagen' => $imagen, 'usuario' => $usuario, 'escombros' => 'no_es', 'luna' => 'no_es', 'habitado' => 'habitado', 'accion' => '<a href=\'?view=flotas&mision=transportar' . $o_s . '\'>' . $lng->x_transportar . '</a> | <a href=\'?view=flotas&mision=desplegar' . $o_s . '\'>' . $lng->x_desplegar . '</a> | <br /> <a href=\'?view=flotas&mision=tomar_recursos' . $o_s . '\'>' . $lng->x_tomar_recursos . '</a> | <a href=\'?view=flotas&mision=defender' . $o_s . '\'>' . $lng->x_defender . '</a> <br /> <a href=\'?view=flotas&mision=espiar' . $o_s . '\'>' . $lng->x_espiar . '</a> | <a href=\'?view=flotas&mision=atacar' . $o_s . '\'>' . $lng->x_atacar . '</a> | <a href=\'?view=flotas&mision=sac' . $o_s . '\'>' . $lng->x_sac . '</a>'); } } } $x++; //bucle increment } $prepare_sql->close(); $db->close(); $template = new Smarty(); $template->assign(array('sistema' => $this->system_id, 'x_ir' => $lng->x_ir, 'x_anterior' => $lng->x_anterior, 'x_siguiente' => $lng->x_siguiente, 'x_orbita' => $lng->x_orbita, 'x_planeta' => $lng->x_planeta, 'x_emperador' => $lng->x_emperador, 'x_accion' => $lng->x_accion, 'universe' => $universe)); $template->display('universe/universe.xnv'); unset($x, $template); }
public static function mostrar_ReservasNoConfirmadas() { $conn = new Connect(); $query = 'SELECT * FROM ' . self::DB_TBL_RESERVA . " WHERE res_estado='0'"; $consult = $conn->prepare($query); $consult->execute(); $row = $consult->fetchAll(PDO::FETCH_ASSOC); foreach ($row as $i) { echo "<tr>"; echo "<td>" . $i['res_cedula'] . "</td>"; echo "<td>" . $i['res_nombres'] . "</td>"; echo "<td>" . $i['res_apellidos'] . "</td>"; echo "<td>" . $i['res_email'] . "</td>"; echo "<td>" . $i['res_telefono'] . "</td>"; echo "<td>" . $i['res_pais'] . "</td>"; echo "<td>" . $i['res_organizador'] . "</td>"; echo "<td>" . $i['res_expositor'] . "</td>"; echo "<td>" . $i['res_informacion'] . "</td>"; echo "<td>" . $i['title'] . "</td>"; echo "<td><a href='../../mod_confirmacion/vista/confirmar_reserva.php?id=" . $i['res_id'] . "'><span class='glyphicon glyphicon-ok' aria-hidden='true'></span></a></td>"; echo "<td><a href='../controlador/eliminar_reserva.php?id=" . $i['res_id'] . "' onclick='return confirm(\"¿Realmente desea eliminar la reserva?\");'><span class='glyphicon glyphicon-remove' aria-hidden='true'></span></a></td>"; echo "</tr>"; } }