action_diasfestivos_insert.php 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. $ruta = "../";
  3. require_once "../class/c_login.php";
  4. // check if the session is started
  5. if (!isset($_SESSION['user']))
  6. die(json_encode(['error' => 'No se ha iniciado sesión']));
  7. $user = unserialize($_SESSION['user']);
  8. $ruta = "../";
  9. require_once "../include/bd_pdo.php";
  10. global $pdo;
  11. print_r($_POST);
  12. if ($_POST['periodo'] == 0) {
  13. $periodo = null;
  14. } else {
  15. $periodo = $_POST['periodo'];
  16. }
  17. if (isset($_POST['rango'])) {
  18. $diaInicio = new DateTime(date("Y-m-d", strtotime(str_replace("/", "-", $_POST['diaFestivo']))));
  19. $diaFin = new DateTime(date("Y-m-d", strtotime(str_replace("/", "-", $_POST['diaFestivoFin']))));
  20. $cantidad = $diaFin->diff($diaInicio);
  21. $date = date("Y-m-d", strtotime(str_replace("/", "-", $_POST['diaFestivo'])));
  22. for ($dias = 0; $dias <= $cantidad->days; $dias++) {
  23. $sql = "SELECT fi_diasfestivos(:periodo, :dia)";
  24. $params = [':periodo' => $periodo, ':dia' => $date];
  25. query($sql, $params, false);
  26. $date = date("Y-m-d", strtotime($date . "+ 1 days"));
  27. }
  28. header("Location: ../días_festivos.php");
  29. exit();
  30. } else {
  31. $sql = "SELECT * FROM fs_diasfestivos(null, :dia)";
  32. $params = [':dia' => $_POST['diaFestivo']];
  33. $dia_general = query($sql, $params, false);
  34. $sql = "SELECT * FROM fs_diasfestivos(null, null, :periodo, :dia)";
  35. $params = [':periodo' => $periodo, ":dia" => $_POST['diaFestivo']];
  36. $dia = query($sql, $params, false);
  37. if (!$dia && !$dia_general) { //no hay repetidos
  38. $sql = "SELECT fi_diasfestivos(:periodo, :dia)";
  39. $id = query($sql, $params, false);
  40. header("Location: ../días_festivos.php");
  41. exit();
  42. } else {
  43. header("Location: ../días_festivos.php?error=1");
  44. exit();
  45. }
  46. }