123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- <?php
- $ruta = "../";
- require_once "../class/c_login.php";
- // check if the session is started
- if (!isset($_SESSION['user']))
- die(json_encode(['error' => 'No se ha iniciado sesión']));
- $user = unserialize($_SESSION['user']);
- $ruta = "../";
- require_once "../include/bd_pdo.php";
- global $pdo;
- print_r($_POST);
- if ($_POST['periodo'] == 0) {
- $periodo = null;
- } else {
- $periodo = $_POST['periodo'];
- }
- if (isset($_POST['rango'])) {
- $diaInicio = new DateTime(date("Y-m-d", strtotime(str_replace("/", "-", $_POST['diaFestivo']))));
- $diaFin = new DateTime(date("Y-m-d", strtotime(str_replace("/", "-", $_POST['diaFestivoFin']))));
- $cantidad = $diaFin->diff($diaInicio);
- $date = date("Y-m-d", strtotime(str_replace("/", "-", $_POST['diaFestivo'])));
- for ($dias = 0; $dias <= $cantidad->days; $dias++) {
- $sql = "SELECT fi_diasfestivos(:periodo, :dia)";
- $params = [':periodo' => $periodo, ':dia' => $date];
- query($sql, $params, false);
- $date = date("Y-m-d", strtotime($date . "+ 1 days"));
- }
- header("Location: ../días_festivos.php");
- exit();
- } else {
- $sql = "SELECT * FROM fs_diasfestivos(null, :dia)";
- $params = [':dia' => $_POST['diaFestivo']];
- $dia_general = query($sql, $params, false);
- $sql = "SELECT * FROM fs_diasfestivos(null, null, :periodo, :dia)";
- $params = [':periodo' => $periodo, ":dia" => $_POST['diaFestivo']];
- $dia = query($sql, $params, false);
- if (!$dia && !$dia_general) { //no hay repetidos
- $sql = "SELECT fi_diasfestivos(:periodo, :dia)";
- $id = query($sql, $params, false);
- header("Location: ../días_festivos.php");
- exit();
- } else {
- header("Location: ../días_festivos.php?error=1");
- exit();
- }
- }
|