sgi/navidad/action/participantes_estado.php

<?php
/* 
 * Asigna pareja a participantes activos
 */
require_once("../../include/constantes.php");
require_once("../../include/bd_pdo.php");

session_start();
if(!isset($_SESSION["n_usuario_id"])){
    session_destroy();
    $pag = "../salir.php?expired=1";
    header("Location: ".$pag);
    exit();
}

$session_life = 1*60*60;//convertido a segundos
if (isset($_SESSION["n_timeout"])) {
// calculate the session's "time to live"
    $sessionTTL = time() - $_SESSION["n_timeout"];
    if ($sessionTTL > $session_life) {
        $_SESSION = array();
        session_destroy();
        $pag = $_SERVER['SERVER_NAME']."/navidad/salir.php?expired=1";
        header("Location: http://".$pag);
        exit();
    }
}else{
    $_SESSION = array();
    session_destroy();
    $pag = $_SERVER['SERVER_NAME']."/navidad/salir.php?expired=1";
    header("Location: http://".$pag);
    exit();
}
$_SESSION["n_timeout"] = time();


if(!isset($_SESSION["n_sgi_administrador"]) || !$_SESSION["n_sgi_administrador"]){
    header("Location: ../main.php?error=0");
    exit();
}

$pag = "../participantes.php";

try {
    $pdo->beginTransaction();
    $activosArr = $_POST["activos"];
    
    //obtiene navidad
    $stmt = $pdo->prepare('Select * from fs_navidad()');
    if(!$stmt->execute()){
        header("Location: ../index.php?error=5");
        exit();
    }
    $navidad_rs = $stmt->fetch();//$navidad_rs["Navidad_activa"] || $navidad_rs["Navidad_id"]
    $stmt->closeCursor();
    
    //desactiva a todos    
    $stmt = $pdo->prepare('Select * from fu_navidadusuario(:nav, NULL, false)');
    $stmt->bindParam(":nav", $navidad_rs["Navidad_id"]);
    if(!$stmt->execute()){
        $pdo->rollback();
        header("Location: ".$pag."?error=1");
        exit();
    }
    $stmt->closeCursor();

    //Inserta activos
    $stmt = $pdo->prepare('Select * from fu_navidadusuario(:nav, :usr, true)');
    $stmt->bindParam(":nav", $navidad_rs["Navidad_id"]);
    foreach($activosArr as $usr){
        $stmt->bindParam(":usr", $usr);
        if(!$stmt->execute()){
            $pdo->rollback();
            header("Location: ".$pag."?error=1");
            exit();
        }
    }
    $stmt->closeCursor();
    $pdo->commit();
    header("Location: ".$pag."?ok=1");
    
} catch(PDOException $e) {
    $pdo->rollBack();
    header("Location:".$pag."?error=1");
    //print_r($e);
}
?>