Viewing file:  opciones-encuesta.php (11.29 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
$pagina_actual="opciones-encuestas";
$categoria_actual="encuestas";
require_once("includes/config.php");
require_once("includes/funciones.php");
$id=cadena_segura($_GET["id"],11);
$result=$mysqli->query("
SELECT titulo
FROM encuesta
WHERE id = '".$id."'
");
$encuesta=mysqli_fetch_assoc($result);
if (isset($_POST["valor"])){
$id_encuesta=($_POST["id"]);
$valor=utf8_decode($_POST["valor"]);
$result=$mysqli->query("
INSERT INTO opcion_encuesta (id_encuesta, valor) VALUES (
'$id_encuesta',
'$valor'
)
");
header('Location: opciones-encuesta.php?id='.$id_encuesta);
}
if (isset($_GET["eliminar"])){
$eliminar=cadena_segura($_GET["eliminar"],11);
$result=$mysqli->query("
DELETE FROM opcion_encuesta
WHERE id='$eliminar'
");
}
$opciones=$mysqli->query("
SELECT id, valor
FROM opcion_encuesta
WHERE id_encuesta = '".$id."'
ORDER BY orden
");
?><!DOCTYPE html>
<html lang="es">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Panel administrador</title>
<? include('includes/tipografias.php');?>
<!-- Bootstrap Core CSS -->
<link href="bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<!-- MetisMenu CSS -->
<link href="bower_components/metisMenu/dist/metisMenu.min.css" rel="stylesheet">
<!-- Custom CSS -->
<link href="dist/css/sb-admin-2.css" rel="stylesheet">
<link href="css/cds.css" rel="stylesheet" type="text/css">
<!-- Custom Fonts -->
<link href="bower_components/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<div id="wrapper">
<!-- Navigation -->
<? require('includes/nav.php');?>
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">Opciones de <?=utf8_encode($encuesta["titulo"])?></h1>
</div>
<!-- /.col-lg-12 -->
</div>
<div class="row">
<div class="col-lg-12">
<div class="panel panel-default">
<!-- /.panel-heading -->
<div class="panel-body">
<div class="table-responsive">
<? if (isset($_GET["exito"])){?>
<div class="alert alert-success alert-dismissable">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
Cambios realizados con éxito
</div>
<? }?>
<div id="message-box" class="alert alert-success alert-dismissable">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
Arrastre las opciones para ordenarlas.
</div>
<table class="table">
<thead>
<tr>
<th>Opción</th>
<th>Acciones</th>
</tr>
</thead>
<tbody id="sortable-list">
<? $order=array();
while ($item = mysqli_fetch_assoc($opciones)){
$order[] = $item['id'];
?>
<tr title="<?=$item["id"]?>">
<td><?=utf8_encode($item["valor"])?></td>
<td>
<span class="dropdown">
<a class="negro dropdown-toggle" href="" data-toggle="dropdown"><i class="fa fa-minus-circle rojo"> </i> Eliminar</a>
<ul class="dropdown-menu" style="min-width:160px">
<li>
<a href="opciones-encuesta.php?eliminar=<?=$item["id"]?>&id=<?=$id?>" style="display:inline" class="" title="Eliminar"><i class="fa fa-check verde"></i> Sí</a>
<a href="#" style="display:inline" class="" title="Cancelar"><i class="fa fa-times "></i> No</a>
</li>
</ul>
</span>
</td>
</tr>
<? }?>
</tbody>
</table>
<form id="dd-form" action="" method="post">
<input type="hidden" name="sort_order" id="sort_order" value="<?php echo implode(',',$order); ?>" />
</form>
<form method="post">
<fieldset>
<legend>Agregar nueva Opción</legend>
<input type="hidden" name="id" value="<?=$id?>" />
<div class="form-group has-feedback col-lg-12">
<label class="">Valor</label>
<input type="text" class="form-control" name="valor">
</div>
<div class="form-group">
<div class="col-lg-12">
<button type="submit" name="submit" class="btn btn-primary">Agregar</button>
</div>
</div>
</fieldset>
</form>
<br>
<p><a class="btn btn-info" href="administrar-encuestas.php">Volver al listado</a></p>
<!-- Default bootstrap modal example -->
<div class="modal fade" id="modal-acciones" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
</div>
</div>
</div>
</div>
<!-- /.table-responsive -->
</div>
<!-- /.panel-body -->
</div>
<!-- /.panel -->
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
</div>
<!-- /#page-wrapper -->
</div>
<!-- /#wrapper -->
<!-- jQuery -->
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<script src="js/jquery-ui-1.9.2.custom.min.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- Metis Menu Plugin JavaScript -->
<script src="bower_components/metisMenu/dist/metisMenu.min.js"></script>
<!-- Custom Theme JavaScript -->
<script src="dist/js/sb-admin-2.js"></script>
<script>
// Fill modal with content from link href
$("#modal-acciones").on("show.bs.modal", function(e) {
var link = $(e.relatedTarget);
$(this).find(".modal-content").load(link.attr("href"));
});
</script>
<script type="text/javascript">
/* when the DOM is ready */
jQuery(document).ready(function() {
/* grab important elements */
var sortInput = jQuery('#sort_order');
var submit = jQuery('#autoSubmit');
var messageBox = jQuery('#message-box');
var list = jQuery('#sortable-list');
/* create requesting function to avoid duplicate code */
var request = function() {
jQuery.ajax({
beforeSend: function() {
messageBox.text('Actualizando cambios...');
},
complete: function() {
messageBox.html('Cambios guardados con exito.');
//console.log("esto va al guardar: "+sortInput.val());
},
data: 'sort_order=' + sortInput.val() + '&ajax=' + 1 + '&do_submit=1&byajax=1'+'&tabla=opcion_encuesta', //need [0]?
type: 'post',
url: 'guardar_orden.php'
});
};
/* worker function */
var fnSubmit = function(save) {
var sortOrder = [];
list.children('tr').each(function(){
sortOrder.push(jQuery(this).data('id'));
});
sortInput.val(sortOrder.join(','));
console.log(sortInput.val());
if(save) {
request();
}
};
/* store values */
list.children('tr').each(function() {
var li = jQuery(this);
li.data('id',li.attr('title')).attr('title','');
});
/* sortables */
list.sortable({
opacity: 0.7,
update: function() {
fnSubmit(1);//(submit[0].checked);
}
});
list.disableSelection();
/* ajax form submission */
jQuery('#dd-form').bind('submit',function(e) {
if(e) e.preventDefault();
fnSubmit(true);
});
});
</script>
</body>
</html>
|