<?php if (isset($_GET["action"])) { $action = $_GET["action"]; } else { $res = array("NO ACTION SET"); echo json_encode($res); exit; } require "functions_ade.php"; $db = PDO(); switch ($action) { case "updateALL": $res = updateRessources($db, ressources2update($db)); break; case "getEvents": $ressources = isset($_GET["ressource"]) && !empty($_GET["ressource"]) ? $_GET["ressource"] : "1"; if ($ressources != '1') { $ressources = "'" . implode("','", explode(",", $ressources)) . "'"; } $req = $db->prepare("select * from events where ressource in ({$ressources}) or 1=?"); $req->execute(array($ressources)); $res = $req->fetchAll(PDO::FETCH_ASSOC); break; case "getEventsJson": $ressources = isset($_GET["ressource"]) && !empty($_GET["ressource"]) ? $_GET["ressource"] : "1"; if ($ressources != '1') { $ressources = "'" . implode("','", explode(",", $ressources)) . "'"; } $req = $db->prepare("select UID as id, StartDate,EndDate,StartTime,EndTime,Title as title,location from events where ressource in ({$ressources}) or 1=?"); $req->execute(array($ressources));
if (!$ressource_titre) { $msg .= "<p class='text-red'><i class='fa fa-long-arrow-right'></i> Titre obligatoire</p>"; } if (!$ressource_url_href) { $msg .= "<p class='text-red'><i class='fa fa-long-arrow-right'></i> URL obligatoire</p>"; } if (!$ressource_url_title) { $msg .= "<p class='text-red'><i class='fa fa-long-arrow-right'></i> Title obligatoire</p>"; } if (!$ressource_img_alt) { $msg .= "<p class='text-red'><i class='fa fa-long-arrow-right'></i> ALT obligatoire</p>"; } } $page = "admin_ressources_update"; } else { $update = updateRessources($sous_categ_id, $ressource_titre, $ressource_url_href, $ressource_url_title, $ressource_img_alt, $get_id); if ($update) { $msg .= "<div class='box-body'><div class='alert alert-success alert-dismissable'><button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button><h4><i class='icon fa fa-check'></i> Alert!</h4>Ressource modifiée avec succès</div></div>\n"; } else { $msg .= "<div class='box-body'><div class='alert alert-danger alert-dismissable'><button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button><h4><i class='icon fa fa-ban'></i> Alert!</h4>Oupsss... problème lors de la modification de la ressource</div></div>\n"; } $page = "admin_ressources_update"; } break; case "delete": $delete = deleteRessources($get_id); if ($delete) { $msg .= "<div class='box-body'><div class='alert alert-success alert-dismissable'><button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button><h4><i class='icon fa fa-check'></i> Alert!</h4>Ressource supprimée avec succès</div></div>\n"; } else { $msg .= "<div class='box-body'><div class='alert alert-danger alert-dismissable'><button type='button' class='close' data-dismiss='alert' aria-hidden='true'>×</button><h4><i class='icon fa fa-ban'></i> Alert!</h4>Oupsss... problème lors de la suppression de la ressource</div></div>\n"; }