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