Viewing file:  asignar-farmacias.php (12.09 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
$pagina_actual="asignar-farmacias";
$categoria_actual="farmacias";
require_once("includes/config.php");
require_once("includes/funciones.php");
if (isset($_GET["mes"])){
$mes=$_GET["mes"];
} else {
$mes=date("m");
}
if (isset($_GET["anio"])){
$anio=$_GET["anio"];
} else {
$anio=date("Y");
}
if (isset($_POST["mes"])){
extract($_POST, EXTR_SKIP);
$fecha_inicio=$anio."-".str_pad($mes,2,'0',STR_PAD_LEFT)."-01";
if ($mes=="12"){
$fecha_fin=($anio+1)."-"."01"."-01";
} else {
$fecha_fin=$anio."-".str_pad($mes+1,2,'0',STR_PAD_LEFT)."-01";
}
$result=$mysqli->query("
DELETE FROM renglon_fecha_grupo_farmacias
WHERE fecha BETWEEN '".$fecha_inicio."' AND '".$fecha_fin."'
");
foreach ($_POST as $clave=>$valor){
if ($clave!='mes' && $clave!='anio'){
$result=$mysqli->query("
INSERT INTO renglon_fecha_grupo_farmacias (fecha, grupo) VALUES (
'".$clave."',
'".$valor."'
)
");
}
}
header('Location: asignar-farmacias.php?mes='.$mes.'&anio='.$anio.'&exito=si');
}
$fecha_inicio=$anio."-".str_pad($mes,2,'0',STR_PAD_LEFT)."-01";
if ($mes=="12"){
$fecha_fin=($anio+1)."-"."01"."-01";
} else {
$fecha_fin=$anio."-".(str_pad($mes+1,2,'0',STR_PAD_LEFT))."-01";
}
$farmacias_asignadas=array();
$iterador_fecha=$fecha_inicio;
while ($iterador_fecha<=$fecha_fin){
$farmacias_asignadas[$iterador_fecha]="";
$iterador_fecha=date('Y-m-d',strtotime($iterador_fecha . "+1 days"));
}
$grupos_asignados=$mysqli->query("
SELECT fecha, grupo
FROM renglon_fecha_grupo_farmacias
WHERE fecha BETWEEN '".$fecha_inicio."' AND '".$fecha_fin."'
");
while ($item = mysqli_fetch_assoc($grupos_asignados)){
$farmacias_asignadas[$item["fecha"]]=$item["grupo"];
}
$farmacias=$mysqli->query("
SELECT nombre, grupo
FROM farmacia
");
$grupos=array();
while ($item = mysqli_fetch_assoc($farmacias)){
if (!isset($grupos[$item["grupo"]])){
$grupos[$item["grupo"]]=$item["grupo"]." - ".utf8_encode($item["nombre"]);
} else {
$grupos[$item["grupo"]].=" - ".utf8_encode($item["nombre"]);
}
}
//print_r($grupos);
?><!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">
<!-- include codemirror (codemirror.css, codemirror.js, xml.js, formatting.js)-->
<link rel="stylesheet" type="text/css" href="summernote-master/css/codemirror.min.css" />
<link rel="stylesheet" href="summernote-master/css/blackboard.min.css">
<link rel="stylesheet" href="summernote-master/css/monokai.min.css">
<!-- 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"><?=capitalizar($categoria_actual)?></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="">
<? 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 class="the-box full no-border">
<form role="form" action="">
<div class="row">
<div class="col-lg-4">
<div class="form-group has-feedback no-label">
<select name="mes" class="form-control">
<? foreach ($months as $clave=>$valor){?>
<option <?=$mes==$clave+1?"selected":""?> value="<?=str_pad((int) ($clave+1),2,0,STR_PAD_LEFT);?>"><?=$valor?></option>
<? }?>
</select>
</div>
</div>
<div class="col-lg-4">
<div class="form-group has-feedback no-label">
<select name="anio" class="form-control">
<? for ($i=date("Y")+1;$i>=date("Y")-5;$i-- ){?>
<option <?=$anio==$i?"selected":""?> value="<?=$i?>"><?=$i?></option>
<? }?>
</select>
</div>
</div>
<div class="col-lg-4">
<div class="form-group has-feedback no-label">
<input type="submit" class="btn btn-success" value="Ir">
</div>
</div>
</div>
</form>
</div>
<form action="" method="post">
<input type="hidden" name="mes" value="<?=$mes?>">
<input type="hidden" name="anio" value="<?=$anio?>">
<table class="table">
<thead>
<tr>
<th>Fecha</th>
<th>Grupo</th>
</tr>
</thead>
<tbody>
<? foreach ($farmacias_asignadas as $clave=>$valor){?>
<tr>
<td><?=ver_fecha_mysql_lindo($clave)?></td>
<td>
<select name="<?=$clave?>" class="form-control">
<option value="">-</option>
<? foreach ($grupos as $clave2=>$value2){?>
<option <?=$clave2==$valor?"selected":""?> value="<?=$clave2?>"><?=$value2?></option>
<? }?>
</select>
</td>
</tr>
<? }?>
</tbody>
</table>
<div class="form-group has-feedback no-label">
<input type="submit" class="btn btn-success" value="Guardar cambios">
</div>
</form>
<!-- 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>
<!-- 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"), function() {
/*
$('.summernote').summernote({
height: 200,
tabsize: 2,
codemirror: {
theme: 'monokai'
}
});
*/
$('.summernote').summernote({
height: 200,
tabsize: 2,
codemirror: {
theme: 'monokai'
},
toolbar: [
//[groupname, [button list]]
['style', ['bold', 'italic', 'underline', 'clear']],
['font', ['strikethrough']],
['color', ['color']],
['para', ['ul', 'ol', 'paragraph']],
['insert', ['link']],
['misc', ['undo','redo','fullscreen']],
]
});
});
});
</script>
<!-- include codemirror (codemirror.css, codemirror.js, xml.js, formatting.js)-->
<script type="text/javascript" src="summernote-master/js/codemirror.js"></script>
<script src="summernote-master/js/xml.min.js"></script>
<script src="summernote-master/js/formatting.min.js"></script>
<!-- include summernote -->
<link rel="stylesheet" href="summernote-master/dist/summernote.css">
<script type="text/javascript" src="summernote-master/dist/summernote.js"></script>
</body>
</html>
|