public function listerOne(Peripherique $obj)
{
$sql = "SELECT * FROM " . $this->table_name . " WHERE `id` = :id";
$stmt = $this->connection->prepare($sql);
$stmt->bindValue("id", $obj->getId());
$stmt->execute();
$result = $stmt->fetch();
return $result;
}
public function modifierAction(Request $request)
{
AuthentificationController::isConnected();
if ($this->get('request')->getMethod() == "POST") {
$session = new Session();
$dao = new PeripheriqueDAO($this->getDoctrine()->getConnection());
$obj = new Peripherique();
$obj->setId($request->get("id"));
//test anti cheat
if (!$session->get("admin")) {
$cheat = $dao->anticheat($session->get('username'), $obj);
if ($cheat) {
CustomError::showMessage("Vous n'avez pas les droits (noob!) 403");
return $this->redirect($this->generateUrl("glpmr_peripherique_gestion"));
}
}
$dao->supprimer($obj);
$obj->setHostname($request->get("hostname"));
// Calcul Automatique de l'IP
$session = new Session();
$obj->setAdd_ip($obj->ConstruireIP($session->get("promotion"), $request->get("ip"), $this->getDoctrine()->getConnection()));
$obj->setAdd_mac($request->get("adresse"));
$obj->setType($request->get("type"));
$obj->setDescription($request->get("description"));
$obj->setProprietaire($session->get("username"));
$obj->setProprietaire_classe($session->get("promotion"));
$dao->ajouter($obj);
$dao->exportToJson();
$title = "Success!";
$message = "Le peripherique a bien ete modifie!";
return $this->render("GlpmrPeripheriqueBundle:Default:modifier_valider_peripherique.html.twig", array("title" => $title, "message" => $message));
} else {
try {
$id = $request->query->get('id');
$peripherique = new Peripherique();
$peripherique->setId($id);
$dao = new PeripheriqueDAO($this->getDoctrine()->getConnection());
$obj = $dao->listerOne($peripherique);
$session = new Session();
$ips = $dao->getIps($session->get('username'));
//test anti cheat
if (!$session->get("admin")) {
$p = new Peripherique();
$p->setId($obj['id']);
$cheat = $dao->anticheat($session->get('username'), $p);
if ($cheat) {
CustomError::showMessage("Vous n'avez pas les droits (noob!) 403");
return $this->redirect($this->generateUrl("glpmr_peripherique_gestion"));
}
}
return $this->render("@GlpmrPeripherique/Default/modifier_peripherique.html.twig", array("peripherique" => $obj, "tableau_ip" => $ips));
} catch (Exception $e) {
}
}
}
