protected function setValuesToObject(&$object) { parent::setValuesToObject($object); $ticket = DAO::getOne("Ticket", $_POST['idTicket']); $object->setTicket($ticket); $object->setUser($_SESSION["user"]); }
protected function setValuesToObject(&$object) { parent::setValuesToObject($object); if(isset($_POST["idCategorie"])){ $parent=DAO::getOne("Categorie", $_POST["idCategorie"]); $object->setCategorie($parent); } }
protected function setValuesToObject(&$object) { parent::setValuesToObject($object); $object->setAdmin(isset($_POST["admin"])); $object->setGroupe(DAO::getOne("Groupe", "id=".$_POST['idGroupe'])); if (isset($_POST["password"]) && isset($_POST["password2"])) { if ($_POST['password'] == $_POST['password2']) { $object->setPassword(password_hash($_POST['password'], PASSWORD_BCRYPT)); } } }
public function test() { $faqs = DAO::getAll("Faq", "1=1 order by dateCreation limit 1,1"); foreach ($faqs as $faq) { echo $faq . "<br>"; } echo DAO::$db->query("SELECT max(id) FROM Faq")->fetchColumn(); $ArticleMax = DAO::getOne("Faq", "id=(SELECT max(id) FROM Faq)"); echo $ArticleMax; }
public function updateTitre() { if (RequestUtils::isPost()) { $faq = DAO::getOne("Faq", $_POST["id"]); $faq->setTitre($_POST["titre"]); if (DAO::update($faq)) { $this->messageInfo($faq . " modifié", "5000"); Jquery::get("sample/liste", "#liste"); Jquery::doJquery(".alert", "hide", "3000"); echo Jquery::compile(); } } }
public function nouveauMess() { $contenu = $_POST['newMess']; $user = $_POST['idUser']; $ticket = $_POST['idTicket']; DAO::$db->execute("INSERT INTO message(id,contenu,idUser,idTicket) VALUES('','" . $contenu . "'," . $user . "," . $ticket . ")"); if (Auth::isAdmin()) { $obj = DAO::getOne("ticket", "id=" . $ticket); $obj->setIdAdmin(Auth::getUser()->getId()); DAO::update($obj); } $this->forward("Tickets", "frm2", $ticket); }
public function updatePass(){ $user = DAO::getOne("User", "id = ".$_SESSION['resetPass']['idUser']); if ($_POST['pass'] == $_POST['pass']) { $user->setPassword(password_hash($_POST['pass'], PASSWORD_BCRYPT)); DAO::update($user); $token = DAO::getOne('Token', $_SESSION['resetPass']['token']); DAO::delete($token); $_SESSION['resetPass'] = null; return $this->_showMessage("Votre mot de passe a été correctement modifié. ".Auth::getInfoUser(), 'success'); }else{ return $this->_showMessage("Mots de passe différents !", 'warning'); } }
/** * Retourne l'utilisateur actuellement connecté<br> * ou NULL si personne ne l'est * @return User */ public static function getUser(){ global $config; $user=null; if(array_key_exists("user", $_SESSION)){ $user=$_SESSION["user"]; }else if (isset($_COOKIE) && isset($_SESSION['logStatus'])) { if (array_key_exists("user", $_COOKIE) && $_COOKIE['user'] != null && $_SESSION['logStatus'] != 'disconnected') { $_SESSION["user"] = DAO::getOne('User', 'id='.$_COOKIE['user']); $user=$_SESSION["user"]; setcookie('user', $_COOKIE['user'], $config['cookies']['user']['lifetime']); } } return $user; }
public function connect() { $email = $_POST["email"]; $password = $_POST["pwd"]; if ($email && $password) { $_SESSION["user"] = DAO::getOne("User", "mail='" . $email . "' and password='******'"); $_SESSION['KCFINDER'] = array('mail' => $email, 'disabled' => true); $this->index(); } else { $info['error'] = 'Erreur d\'identification, Veuillez réessayer s\'il vous plaît !'; $this->loadView("main/vHeader", array("infoUser" => Auth::getInfoUser())); $this->loadView("main/frm_log", $info); $this->loadView("main/vFooter"); } }
public function getInstance($id = NULL) { $obj = parent::getInstance($id); if (null == $obj->getType()) { $obj->setType("intervention"); } if ($obj->getStatut() === NULL) { $statut = DAO::getOne("Statut", 1); $obj->setStatut($statut); } if ($obj->getUser() === NULL) { $obj->setUser(Auth::getUser()); } if ($obj->getDateCreation() === NULL) { $obj->setdateCreation(date('Y-m-d H:i:s')); } return $obj; }
public function testConnexion() { $login = $_POST["login"]; //echo $login; $mdp = $_POST["mdp"]; //echo $mdp; $resultat = DAO::getOne("user", "login='******' AND password='******'"); if ($resultat != null) { $_SESSION["user"] = $resultat; $_SESSION['KCFINDER'] = array('disabled' => false); $this->header(); $notif = sizeof(DAO::getAll("Ticket", "idStatut='1'")); $this->loadView("main/vDefault", array("notif" => $notif)); //$this->loadView("connexion/vConnexion", array("notif"=>$notif)); } else { $this->header(); echo "<span> Votre mot de passe ou login est incorrecte. </span>"; } }
public function update(){ if(RequestUtils::isPost()){ parent::updateNotForward(); $ticket = DAO::getOne("Ticket",$_POST['idTicket']); $messages = DAO::getAll("Message", 'idTicket = '.$_POST['idTicket']); $users = array(); foreach ($messages as $message) { $user = $message->getUser()->getId(); if (!in_array($user, $users) && $user != Auth::getUser()->getId() ) { array_push($users, $message->getUser()->getId()); } $message->setUser(DAO::getAll("User", "id=".$message->getUser()->getId())[0]); } $message = DAO::getOne("Message", "idUser="******" ORDER BY date DESC"); foreach ($users as $user) { if (DAO::getOne("Notification", 'idUser = '******' AND idTicket = '.$ticket->getId()) == null) { $user = DAO::getOne("User", $user); $notif = new Notification(); $notif->setUser($user); $notif->setTicket($ticket); $notif->setMessage($message); DAO::insert($notif); } } $this->loadView("ticket/vMessage",array("messages"=>$messages, "ticket" => $ticket)); Jquery::execute("CKEDITOR.replace('contenu');"); Jquery::executeOn('.submitMessage', "click", " for ( instance in CKEDITOR.instances ) CKEDITOR.instances[instance].updateElement(); "); Jquery::postFormOn("click",".submitMessage","messages/update","frm",".contentMessages"); echo Jquery::compile(); } }
public function signin_with_hybridauth($provider) { global $config; $authConfig=ROOT."configHybrid.php"; include ROOT."./../vendor/hybridauth/hybridauth/hybridauth/Hybrid/Auth.php"; $hybridauth=new Hybrid_Auth($authConfig); $adapter=$hybridauth->authenticate($provider[0]); $user_profile=$adapter->getUserProfile(); $dbProvider=DAO::getOne("AuthProvider", array ( "name" => $provider[0] )); if ($dbProvider!=NULL) { $user=DAO::getOne("User", array ( "login" => $user_profile->displayName,"idAuthProvider" => $dbProvider->getId() )); if ($user===null) { $user=new User(); $user->setLogin($user_profile->displayName); $user->setMail($user_profile->email); $user->setGroupe(DAO::getOne("Groupe", "id=2")); $user->setAuthProvider($dbProvider); $user->setKey($user_profile->identifier); DAO::insert($user); } $_SESSION["user"]=$user; setcookie("autoConnect", $provider[0], time()+3600, "/"); if (array_key_exists("action", $_SESSION)) { Startup::runAction($_SESSION["action"], false, false); unset($_SESSION["action"]); } else { echo '<h3>Connecté à '.$dbProvider->getName().'</h3>'; echo '<h4>'.$user->getLogin().'</h4>'; echo '<div class="row"><div class="col-xs-6 col-md-3"><img style="width: 230px;height:230px;border-radius: 6px;" src="'.$user_profile->photoURL.'&s=460" alt="avatar" width="230" height="230"></div></div>'; } echo "<div id='divInfoUser'></div>"; echo Jquery::get("Indexx/getInfoUser/", "#divInfoUser"); header("Location: ".$config['siteUrl']."/Indexx"); } }
protected function setValuesToObject(&$object){ parent::setValuesToObject($object); $object->setUser(DAO::getOne("User", $_POST['idUser'])); if(isset($_POST['enabled'])){ if (isset($_POST['frequence'])){ $i = 0; $array = array(); $freq= $_POST['frequence']; foreach ($freq as $f){ array_push($array, array("day" => $f, "time"=>$_POST['time'])); $i++; } $object->setFrequence(json_encode($array)); } $object->setEnabled(1); }else{ $object->setEnabled(0); } if(isset($_POST['instant'])) $object->setInstant(1); else $object->setInstant(0); }
public function test_Disable() { $this->get("DefaultC/asAdmin"); $this->waitFor(2); $this->get("Faqs"); $this->waitFor(2); $this->assertPageContainsText("Foire aux questions"); $bt = $this->getElementBySelector(".glyphicon.glyphicon-pause"); $this->assertNotNull($bt); $bt->click(); $faqElt = DAO::getOne("Faq", "1=1 order by dateCreation DESC LIMIT 0,1"); $this->assertEquals($faqElt->getDisable(), "1"); $bt = $this->getElementBySelector(".glyphicon.glyphicon-play"); $this->assertNotNull($bt); $bt->click(); $faqElt = DAO::getOne("Faq", "1=1 order by dateCreation DESC LIMIT 0,1"); $this->assertEquals($faqElt->getDisable(), "0"); }
/** * Affecte/charge les enregistrements fils dans le membre $member de $instance. * Si $array est null, les fils sont chargés depuis la base de données * @param Classe $instance * @param string $member Membre sur lequel doit être présent une annotation OneToMany * @param array $array paramètre facultatif contenant la liste des fils possibles */ public static function getManyToMany($instance, $member, $array = null) { $ret = array(); $class = get_class($instance); $parser = new ManyToManyParser($instance, $member); if ($parser->init()) { $joinTableCursor = DAO::getSQLForJoinTable($instance, $parser); if (is_null($array)) { foreach ($joinTableCursor as $row) { $fkv = $row[$parser->getFkField()]; $tmp = DAO::getOne($parser->getTargetEntity(), "`" . $parser->getPk() . "`='" . $fkv . "'"); array_push($ret, $tmp); } } else { $continue = true; $accessorToMember = "get" . ucfirst($parser->getInversedBy()); $myPkAccessor = "get" . ucfirst($parser->getMyPk()); if (!method_exists($instance, $myPkAccessor)) { \Logger::warn("ManyToMany", "L'accesseur au membre clé primaire " . $myPkAccessor . " est manquant pour " . $class); } if (count($array) > 0) { $continue = method_exists($array[0], $accessorToMember); } if ($continue) { foreach ($joinTableCursor as $row) { $fkv = $row[$parser->getFkField()]; foreach ($array as $targetEntityInstance) { $instances = $targetEntityInstance->{$accessorToMember}(); if (is_array($instances)) { foreach ($instances as $inst) { if ($inst->{$myPkAccessor} == $instance->{$myPkAccessor}) { array_push($array, $targetEntityInstance); } } } } } } else { \Logger::warn("ManyToMany", "L'accesseur au membre " . $parser->getInversedBy() . " est manquant pour " . $parser->getTargetEntity()); } } $accessor = "set" . ucfirst($member); if (method_exists($instance, $accessor)) { \Logger::log("getManyToMany", "Chargement de " . $member . " pour l'objet " . $class); $instance->{$accessor}($ret); } else { \Logger::warn("getManyToMany", "L'accesseur " . $accessor . " est manquant pour " . $class); } } return $ret; }
public function activate($id = NULL) { try { $object = DAO::getOne($this->model, $id[0]); if ($object !== NULL) { $object->setDisable("0"); DAO::update($object); $msg = new DisplayedMessage("Article activé"); } else { $msg = new DisplayedMessage($this->model . " introuvable", "warning"); } } catch (\Exception $e) { $msg = new DisplayedMessage("Impossible d'activer l'instance de " . $this->model, "danger"); } $this->forward(get_class($this), "index", $msg); }
"port" => 587, "secure"=>"tls" ], "cookies"=>[ "user"=>[ "lifetime"=>time()+60*60*24*7 ] ], "test"=>false, "onStartup"=>function($action){ if(!Auth::isAuth() && $action[0]!=="UserAuth" && @$action[1]!=="disconnect"){ if(array_key_exists("autoConnect", $_COOKIE)){ $_SESSION["action"]=$action; $ctrl=new UserAuth(); $ctrl->initialize(); $ctrl->signin_with_hybridauth(array($_COOKIE["autoConnect"])); $ctrl->finalize(); die(); }else if(array_key_exists("user", $_COOKIE)){ $user = DAO::getOne("User", $_COOKIE['user']); $_SESSION["user"] = $user; $_SESSION['KCFINDER'] = array( 'disabled' => true ); $_SESSION['logStatus'] = 'success'; } } }, "templateEngine"=>'micro\views\engine\Twig', );
public function index() { //en tant qu'admin je peux ecrire un article if ($_SESSION["admin"] == "1") { $this->loadView("faq/vAdmin"); // en tant qu'admin je peux voir mes articles et les modifier $db = DAO::$db; $mesAtricles = $db->query("select faq.id from faq where faq.idUser="******"<table class='table table-striped'>"; foreach ($mesAtricles as $m) { $monArticle = DAO::getOne("Faq", $m[0]); echo "<tr><td><a class='' href='faqs/contenu/" . $monArticle->getId() . "'>" . $monArticle->getTitre() . "<br></a></td>"; echo "<td class='td-center'><a class='btn btn-primary btn-xs' href='faqs/modifierArticle/" . $monArticle->getId() . "'>Modifier</a></td>"; $x = $monArticle->getSuspendre(); if ($x == 0) { echo "<td class='td-center'><a class='btn btn-primary btn-xs' href='faqs/suspendre/" . $monArticle->getId() . "'>Suspendre</a></td>"; } else { echo "<td class='td-center'><a class='btn btn-primary btn-xs' href='faqs/Rsuspendre/" . $monArticle->getId() . "'>Activer</a></td>"; } echo "<td class='td-center'><a class='btn btn-warning btn-xs' href='faqs/delete/" . $monArticle->getId() . "'>Supprimer</a></td>"; echo "</tr>"; } echo "</table>"; } //recherche if (isset($_POST["recherche"]) && $_POST["recherche"] != "" && $_POST["recherche"] != "votre recherche...") { $recherch = $_POST["recherche"]; $faqs = DAO::getAll("Faq", "titre LIKE '%" . $recherch . "%'"); $this->loadView("faq/vResultat", array("faqs" => $faqs, "title" => "Resultat de votre recherche : ")); } else { $this->loadView("faq/vRecherche"); //sujet les plus populaire $faqs = DAO::getAll("Faq", "1=1 order by popularity limit 10"); $this->loadView("faq/vPopulaire", array("faqs" => $faqs, "title" => "Sujets les plus populaires")); //sujet les plus r�cents $faqs = DAO::getAll("Faq", "1=1 order by dateCreation limit 10"); $this->loadView("faq/vFaqs", array("faqs" => $faqs, "title" => "Sujets les plus recents")); //sujet par cat�gorie $this->loadView("faq/vCate", array("faqs" => $faqs)); } }
/** * Supprime l'instance dont l'id est $id dans la BDD * @param int $id */ public function delete($id) { try { $object = DAO::getOne($this->model, $id[0]); if ($object !== NULL) { DAO::delete($object); $msg = new DisplayedMessage($this->model . " `{$object->toString()}` supprimé(e)"); } else { $msg = new DisplayedMessage($this->model . " introuvable", "warning"); } } catch (Exception $e) { $msg = new DisplayedMessage("Impossible de supprimer l'instance de " . $this->model, "danger"); } $this->forward(get_class($this), "index", $msg); }
/** * Connecte le premier utilisateur (non admin) trouvé dans la BDD */ public function asUser(){ global $config; $_SESSION["user"]=DAO::getOne("User", "admin=0"); $_SESSION['KCFINDER'] = array( 'disabled' => true ); $_SESSION['logStatus'] = 'success'; setcookie('user', $_SESSION["user"]->getId(), $config['cookies']['user']['lifetime'], '/', '', 0, 0); $this->index(); }
protected function setValuesToObject(&$object) { parent::setValuesToObject($object); $categorie = DAO::getOne("Categorie", $_POST["idCategorie"]); $object->setCategorie($categorie); $statut = DAO::getOne("Statut", $_POST["idStatut"]); $object->setStatut($statut); $user = DAO::getOne("User", $_POST["idUser"]); $object->setUser($user); }
/** * Connecte le premier utilisateur (non admin) trouvé dans la BDD */ public function asUser() { $_SESSION["user"] = DAO::getOne("User", "admin=0"); $_SESSION['KCFINDER'] = array('disabled' => true); $this->index(); }
public function updateStatut($params){ $params = explode(";", $params[0]); $statut = DAO::getOne("Statut", $params[0]); $ticket = DAO::getOne("Ticket", $params[1]); if ($statut->getId() == 2) { $ticket->setAdmin(DAO::getOne("User", "id=".$params[2])); } $ticket->setStatut($statut); if (DAO::update($ticket)) { $this->listTickets(); } }
<?php use micro\orm\DAO; //le premier $faqMin = DAO::getOne("Faq", "1=1 limit 1"); $min = $faqMin->getId(); //le dernier $faqMax = DAO::getOne("Faq", "1=1 order by id DESC limit 1"); $max = $faqMax->getId(); $c = $faqs->getId(); if ($c <= $min) { $a = $c; } else { $faqPre = DAO::getAll("Faq", " id<{$c} order by id DESC limit 1"); $a = $faqPre[0]->getId(); } if ($c >= $max) { $b = $c; } else { $faqSui = DAO::getAll("Faq", "id>{$c} limit 1"); $b = $faqSui[0]->getId(); } ?> <div class="container"> <div class="table"> <table> <tr><td colspan="2"><a class="btn btn-primary" href=<?php echo "faqs/contenu/" . $a; ?> >Precedent</a> <a class="btn btn-primary" href=<?php echo "faqs/contenu/" . $b;
public function testTicket() { $ticket = DAO::getOne("ticket", 1); $this->assertNotNull($ticket); $this->assertEquals($ticket->getId(), 1); }
public function suspend($params){ $params = explode(";", $params[0]); $faq = DAO::getOne($this->model, $params[0]); $faq->setPublished($params[1]); DAO::update($faq); echo "<div class='test'></div>"; echo Jquery::postForm('Faqs/filter', 'searchForm', '.list'); }