/home/panaafpl/panamaroutes.com/app_tours/list_paquetes.php
<?php
session_start();
//echo $_SESSION['userid'];
if(!isset($_SESSION['id']))
{
header("location:iniciar.php");
}
error_reporting(E_ALL ^ E_DEPRECATED);
ini_set('display_errors','On');
date_default_timezone_set('America/Panama');
////////////////////////Librerias Necesarias/////////////////////
include("bases_de_datos.php");
include("query.php");
//////////////////////////////////////////////////////////////////
//////////////Conectando a bases de datos/////////////////////////
$conectar=conectar_base_de_datos();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Panamaroutes | Administracion</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="utf-8">
<meta name="keywords" content="Panamaroutes, panama tours, city tours, turismo panama, alquiler de vehiculos, traslados, transfers, San Blas, Albrook Mall, Colon, Zona libre, Cerro Ancon, Valle Anton." />
<script>
addEventListener("load", function () {
setTimeout(hideURLbar, 0);
}, false);
function hideURLbar() {
window.scrollTo(0, 1);
}
</script>
<!-- css files -->
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' /><!-- bootstrap css -->
<link href="css/style2.css" rel='stylesheet' type='text/css' /><!-- custom css -->
<link href="css/font-awesome.min.css" rel="stylesheet"><!-- fontawesome css -->
<!-- //css files -->
<!-- google fonts -->
<link href="//fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i,800,800i" rel="stylesheet">
<link href="//fonts.googleapis.com/css?family=Raleway:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
<!-- //google fonts -->
<script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.css">
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.js"></script>
<script src="js/table.js"></script>
<!-- Custom functions file -->
<!-- Custom functions file -->
<script src="js/functions.js"></script>
<!-- Sweet Alert Script -->
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<!-- Sweet Alert Script -->
<script>function modificar_registro(registro){
location.href = "ag_mod.php?mod=mod&paq="+registro;
}
</script>
<script>function eliminar_registro(id_registro){
var parametros = {
"id_registro" : id_registro
};
swal({
title: "Esta seguro que quiere eliminar?",
text: "Una vez eliminado el registro no se podra recuperar",
icon: "warning",
buttons: true,
dangerMode: true,
})
.then((willDelete) => {
if (willDelete) {
var url = "eliminar_paquete.php";
$.ajax({
type: "POST",
url: url,
data:"registro="+id_registro+"",
dataType: "script",
success: function (data) {
if (data) {
swal("Registro eliminado con Exito", { icon: "success", })
.then((value) => {
location.reload();
}
);
} else
{
swal("No se pudo eliminar el registro", { icon: "warning", }); }
},
error: function (jqXHR, textStatus, errorThrown) { swal("Safe!"); }
});
}
});
};</script>
<script>function cambiar_estado(id_registro, id_registro1){
var parametros = {
"id_registro" : id_registro
};
swal({
title: "Esta seguro que quiere cambiar el estado?",
text: "Para volver a cambiar recurra al mismo boton",
icon: "warning",
buttons: true,
dangerMode: true,
})
.then((willDelete) => {
if (willDelete) {
var url = "cambiar_estado.php";
var parametros = {
"registro" : id_registro,
"registro1" : id_registro1
};
$.ajax({
type: "POST",
url: url,
data: parametros,
dataType: "script",
success: function (data) {
if (data) {
swal("Estado cambiado con Exito", { icon: "success", })
.then((value) => {
location.reload();
}
);
} else
{
swal("No se pudo cambiar el estado", { icon: "warning", }); }
},
error: function (jqXHR, textStatus, errorThrown) { swal("Safe!"); }
});
}
});
};</script>
</head>
<body>
<script>
window.onload=function(){
var pos=window.name || 0;
window.scrollTo(0,pos);
}
window.onunload=function(){
window.name=self.pageYOffset || (document.documentElement.scrollTop+document.body.scrollTop);
}
</script>
<!-- header -->
<header>
<div class="container">
<!-- nav -->
<nav class="py-md-4 py-3 d-lg-flex">
<div id="logo">
<a href=""> <img src="images/logo1200.png" class="img-fluid abt-image" alt=""> </a>
</div>
<label for="drop" class="toggle"><span class="fa fa-bars"></span></label>
<input type="checkbox" id="drop" />
<ul class="menu ml-auto mt-1">
<li class="booking"><a href="cerrar.php">Cerrar sesion</a></li>
</ul>
</nav>
<!-- //nav -->
</div>
</header>
<!-- //header -->
<!-- banner -->
<section class="banner_inner" id="home">
<div class="banner_inner_overlay">
</div>
</section>
<!-- //banner -->
<!--------Paquetes Turisticos / Consulta----------->
<!-- tour packages -->
<section class="packages pt-5" id="lista_paquetes">
<div class="container py-lg-4 py-sm-3">
<h2 class="heading text-capitalize text-center"> Paquetes turisticos de Panamaroutes</h2>
<p class="text mt-2 mb-5 text-center">Seleccione la opcion que necesita ejecutar.</p>
<table id="table_id" class="display">
<thead>
<tr>
<th>ID</th>
<th>Nombre de Paquete</th>
<th>Estado</th>
<th></th>
</tr>
</thead>
<tfoot>
<tr>
<th>ID</th>
<th>Nombre de Paquete</th>
<th>Estado</th>
<th></th>
</tr>
</tfoot>
<tbody>
<?php
$paquetes=mostrar_paquetes_todos($conectar);
while ($valor_paquetes = mysqli_fetch_array($paquetes))
{
print'<tr>
<td>'.$valor_paquetes['id_paquete'].'</td>
<td>'.$valor_paquetes['nombre_esp'].'</td>';
if ($valor_paquetes['status']=="1")
print'<td>Activo</td>';
else print'<td>Inactivo</td>';
print'<td><a href="#" onclick="cambiar_estado('.$valor_paquetes['id_paquete'].', '.$valor_paquetes['status'].'); return false;" return false;><i class="fa fa-crosshairs fa-2x" title="Cambiar estado"></i></a> <a href="#" onclick="modificar_registro('.$valor_paquetes['id_paquete'].'); return false;" return false;><i class="fa fa-edit fa-2x" title="Modificar paquete"></i></a> <a href="#" onclick="eliminar_registro('.$valor_paquetes['id_paquete'].'); return false;" return false;><i class="fa fa-trash fa-2x" title="Eliminar paquete"></i></a></td>';
print'</tr>';
}
?>
</tbody>
</table>
<br>
<div class="col-lg-3 col-md-3">
<a href="ag_mod.php"><button class="btn btn-block sent-butnn">Nuevo paquete</button></a>
</div>
</div>
</section>
<!-- tour packages -->
<br><br>
<!--footer -->
<footer>
<section class="footer footer_w3layouts_section_1its py-5">
<div class="container py-lg-4 py-3">
<div class="row footer-top">
<div class="col-lg-3 col-sm-6 footer-grid_section_1its_w3">
<div class="footer-title">
<h3>Datos de Contacto</h3>
</div>
<div class="footer-text">
<p>Direccion: Panama</p>
<p>Phone: +507 6093-9947</p>
<p>Correo: <a href="mailto:info@example.com">ventas@panamaroutes.com</a></p>
</div>
</div>
<div class="col-lg-3 col-sm-6 footer-grid_section mt-sm-0 mt-4">
<div class="footer-title">
<h3>Nuestra Redes</h3>
</div>
<div class="footer-text">
<p>Visitanos en nuestras redes sociales y hazte parte de nuestra comunidad.</p>
</div>
<ul class="social_section_1info">
<li class="mb-2 facebook"><a href="https://www.facebook.com/routespanama/"><span class="fa fa-facebook"></span></a></li>
<li class="mb-2 twitter"><a href="https://www.instagram.com/panama.routes/"><span class="fa fa-instagram"></span></a></li>
</ul>
</div>
</div>
</div>
</section>
</footer>
<!-- //footer -->
<!-- copyright -->
<div class="copyright py-3 text-center">
<p>© 2020 Panamaroutes. Todos los derechos reservados | Diseñado por <a href="https://www.danveltec.com" target="=_blank"> Danveltec Latinoamérica</a></p>
</div>
<!-- //copyright -->
<!-- move top -->
<div class="move-top text-right">
<a href="#home" class="move-top">
<span class="fa fa-angle-up mb-3" aria-hidden="true"></span>
</a>
</div>
<!-- move top -->
</body>
</html>