action_diasfestivos_insert.php 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  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 (!isset($_POST['periodo']) || count($_POST["periodo"])==0) {
  13. header("Location: ../días_festivos.php?error=0");
  14. exit();
  15. }
  16. $periodoArr = $_POST['periodo'];
  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. foreach($periodoArr as $periodo){
  24. $db->querySingle('SELECT fi_diasfestivos(:periodo, :dia)', [':periodo' => $periodo, ':dia' => $date]);
  25. /*$sql = "SELECT fi_diasfestivos(:periodo, :dia)";
  26. $params = [':periodo' => $periodo, ':dia' => $date];
  27. query($sql, $params, false);*/
  28. }
  29. $date = date("Y-m-d", strtotime($date . "+ 1 days"));
  30. }
  31. header("Location: ../días_festivos.php");
  32. exit();
  33. } else {
  34. /*$sql = "SELECT * FROM fs_diasfestivos(null, :dia)";
  35. $params = [':dia' => $_POST['diaFestivo']];
  36. $dia_general = query($sql, $params, false);
  37. $sql = "SELECT * FROM fs_diasfestivos(null, null, :periodo, :dia)";
  38. $params = [':periodo' => $periodo, ":dia" => $_POST['diaFestivo']];
  39. $dia = query($sql, $params, false);*/
  40. //if (!$dia && !$dia_general) { //no hay repetidos
  41. foreach($periodoArr as $periodo){
  42. $db->querySingle('SELECT fi_diasfestivos(:periodo, :dia)', [':periodo' => $periodo, ':dia' => $_POST['diaFestivo']]);
  43. /*$sql = "SELECT fi_diasfestivos(:periodo, :dia)";
  44. $params = [':periodo' => $periodo, ":dia" => $_POST['diaFestivo']];
  45. $id = query($sql, $params, false);*/
  46. }
  47. header("Location: ../días_festivos.php");
  48. exit();
  49. /*} else {
  50. header("Location: ../días_festivos.php?error=1");
  51. exit();
  52. }*/
  53. }