action_diasfestivos_update.php 1.1 KB

12345678910111213141516171819202122232425262728293031
  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. if ($_POST['periodo'] == 0) {
  12. $periodo = null;
  13. } else
  14. $periodo = $_POST['periodo'];
  15. $sql = "SELECT * FROM fs_diasfestivos(null, :dia) WHERE diasfestivos_id != :id";
  16. $params = [':dia' => $_POST['diaFestivo'], ':id' => $_POST['id']];
  17. $dia_general = query($sql, $params, false);
  18. $sql = "SELECT * FROM fs_diasfestivos(null, null, :periodo, :dia) WHERE diasfestivos_id != :id";
  19. $params = [':periodo' => $periodo, ':dia' => $_POST['diaFestivo'], ':id' => $_POST['id']];
  20. $dia = query($sql, $params, false);
  21. if (!$dia && !$dia_general) { //no hay repetidos
  22. $sql = "SELECT fu_update_diasfestivos(:id, :dia, :periodo)";
  23. query($sql, $params, false);
  24. header("Location: ../días_festivos.php");
  25. exit();
  26. } else { //es repetido
  27. header("Location: ../días_festivos.php?error=1");
  28. exit();
  29. }