/**
  * Affiche la liste des instances de la class du modèle associé $model
  * @see BaseController::index()
  */
 public function index($message = null)
 {
     global $config;
     $baseHref = get_class($this);
     if (isset($message)) {
         if (is_string($message)) {
             $message = new DisplayedMessage($message);
         }
         $message->setTimerInterval($this->messageTimerInterval);
         $this->_showDisplayedMessage($message);
     }
     $objects = DAO::getAll($this->model);
     echo "<table class='table table-striped'>";
     echo "<thead><tr><th>" . $this->model . "</th></tr></thead>";
     echo "<tbody>";
     foreach ($objects as $object) {
         echo "<tr>";
         echo "<td>" . $object->toString() . "</td>";
         echo "<td class='td-center'><a class='btn btn-primary btn-xs' href='" . $baseHref . "/frm/" . $object->getId() . "'><span class='glyphicon glyphicon-edit' aria-hidden='true'></span></a></td>" . "<td class='td-center'><a class='btn btn-warning btn-xs' href='" . $baseHref . "/delete/" . $object->getId() . "'><span class='glyphicon glyphicon-remove' aria-hidden='true'></span></a></td>";
         echo "</tr>";
     }
     echo "</tbody>";
     echo "</table>";
     echo "<a class='btn btn-primary' href='" . $config["siteUrl"] . $baseHref . "/frm'>Ajouter...</a>";
 }
 public function testNouveauxTickets()
 {
     $this->get("DefaultC/asAdmin");
     $this->waitFor(5);
     $this->assertPageContainsText("Nouveaux Tickets");
     $this->waitFor(5);
     $notif = sizeof(DAO::getAll("Ticket", "idStatut='1'"));
     $this->assertEquals($notif, 1);
     $this->get("TicketsNouveau");
     $this->waitFor(5);
     $bt = $this->getElementBySelector(".glyphicon.glyphicon-edit");
     $this->assertNotNull($bt);
     $bt->click();
     $add = $this->getElementById("elementdemande");
     $this->assertNotNull($add);
     $add->click();
     $this->waitFor(5);
     $add2 = $this->getElementById("element1");
     $this->assertNotNull($add2);
     $add2->click();
     $titre = $this->getElementById("titre");
     $titre->sendKeys("test ticket nouveau");
     $add2 = $this->getElementBySelector(".statut #element3");
     $this->assertNotNull($add2);
     $add2->click();
     $this->waitFor(5);
     $submit = $this->getElementBySelector(".valider");
     $this->assertNotNull($submit);
     $submit->click();
     $this->waitFor(5);
 }
 public function frm($id = NULL)
 {
     $ticket = $this->getInstance($id);
     $categories = DAO::getAll("Categorie");
     $statut = DAO::getAll("Statut");
     if ($ticket->getCategorie() == null) {
         $cat = -1;
         $stat = -1;
     } else {
         $cat = $ticket->getCategorie()->getId();
         $stat = $ticket->getStatut()->getId();
     }
     $listCat = Gui::select($categories, $cat, "Sélectionner une catégorie ...");
     $listStatut = Gui::select($statut, $stat, "Sélectionner un statut ...");
     $listType = Gui::select(array("demande", "intervention"), $ticket->getType(), "Sélectionner un type ...");
     if (Auth::isAdmin() == false) {
         //$selectclass = '<select disabled class="form-control" name="idStatut"> '.statutNow.'</select>';
         $this->loadView("ticket/vAdd", array("ticket" => $ticket, "listCat" => $listCat, "listType" => $listType, "listStatut" => $listStatut));
         echo Jquery::execute("CKEDITOR.replace( 'description');");
         //statutupdate
         //$statutUpdate= 'coucou';
         /* '<div class="form-control" disabled name="idStatut"><br>
         				<input type="hidden" name="idStatut" value=" echo $ticket->getStatut()->getId()"><br>$ticket->getStatut();<br></div>';
         		 */
     }
     if (Auth::isAdmin()) {
         $stat = $ticket->getStatut()->getId();
         $this->loadView("ticket/vAdd", array("ticket" => $ticket, "listCat" => $listCat, "listType" => $listType, "statut" => $statut, "listStatut" => $listStatut));
         echo Jquery::execute("CKEDITOR.replace( 'description');");
         //updteticket
         //s$statutUpdate='coucou1';
         /* '<select class="form-control" class="idStatut" name="idStatut"><br>$listStatut<br></select>'; */
     }
 }
Beispiel #4
0
	/**
	 * Affiche la page par défaut du site
	 * @see BaseController::index()
	 */
	public function index() {
		$this->loadView("main/vHeader",array("infoUser"=>Auth::getInfoUser()));
		$message = null;
		if (isset($_SESSION['logStatus'])){
			switch ($_SESSION['logStatus']) {
				case 'fail':
					$message=new DisplayedMessage("ERREUR : Couple identifiant/mot de passe inconnu.", "danger");
					break;
				case 'disconnected':
					$message=new DisplayedMessage("Vous avez été correctement déconnecté. <b>Au revoir...</b>", "success");
					break;
				case 'success':
					$message=new DisplayedMessage("Bienvenue ".Auth::getUser()->getLogin().".", "success");
					break;
				default:
					$message = null;
					break;
			}
			$_SESSION['logStatus'] = null;
		}

		if(Auth::isAuth()){
			$notifs = DAO::getAll("Notification", "idUser = "******"main/vDefault", array("notifs" => $notifs, "message" => $message));
		}else{
			$this->loadView("main/vLogin");
		}
		$this->loadView("main/vFooter");
	}
 public function liste()
 {
     $faqs = DAO::getAll("Faq");
     echo "<ul class='list-group'>";
     foreach ($faqs as $faq) {
         echo "<li class='list-group-item' id='" . $faq->getId() . "'>" . $faq . "</li>";
     }
     echo "</ul>";
     echo Jquery::getOn("click", ".list-group-item", "sample/frmTitre", "#responseFaq");
 }
Beispiel #6
0
	public function frm($id=NULL){
		$object=$this->getInstance($id);
		$categories=DAO::getAll("Categorie");
		$idParent=-1;
		if(null!==$object->getCategorie()){
			$idParent=$object->getCategorie()->getId();
		}
		$list=Gui::select($categories,$idParent,"Sélectionner une catégorie parente...");
		$this->loadView("categorie/vAdd",array("select"=>$list,"categorie"=>$object));
	}
Beispiel #7
0
 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;
 }
Beispiel #8
0
	public function frm($id=NULL){
		if(Auth::isAdmin() || ($id == Auth::getUser()->getId())){
			$user=$this->getInstance($id);
			$groups = DAO::getAll("Groupe");
			$listGrp=Gui::select($groups,$user->getGroupe()->getId(),"Sélectionner un Groupe ...");
			$this->loadView("user/vAdd",array("user"=>$user, "groups"=>$listGrp));
		}else{
			$this->forward("users");
		}
	}
Beispiel #9
0
 public function frmUpdate($id = NULL)
 {
     $message = $this->getInstance($id);
     if (isset($id)) {
         $idTicket = $message->getTicket()->getId();
     } else {
         $idTicket = -1;
     }
     $tickets = DAO::getAll("Ticket");
     $this->loadView("message/vUpdate", array("message" => $message, "tickets" => $tickets));
 }
	public function index($id=NULL){
		$select=$this->getInstance($id);
		$genericFields=DAO::getAll("GenericField");
		if($select->getLibelle()==null){
			$champ=-1;
		}else{
			$champ=$select->getLibelle()->getId();
		}
		$listGenericField=Gui::select($genericFields,$champ,"Sélectionner un champ ...");
		// $this->loadView("genericField/vSelect", array("genericFields"=>$genericFields));
		// if(){};
	}
Beispiel #11
0
 public function frm($id = NULL)
 {
     $ticket = $this->getInstance($id);
     $categories = DAO::getAll("Categorie");
     if ($ticket->getCategorie() == null) {
         $cat = -1;
     } else {
         $cat = $ticket->getCategorie()->getId();
     }
     $listCat = Gui::select($categories, $cat, "Sélectionner une catégorie ...");
     $listType = Gui::select(array("demande", "intervention"), $ticket->getType(), "Sélectionner un type ...");
     $this->loadView("ticket/vAdd", array("ticket" => $ticket, "listCat" => $listCat, "listType" => $listType));
     echo Jquery::execute("CKEDITOR.replace( 'description');");
 }
Beispiel #12
0
 public function ajaxSample()
 {
     $users = DAO::getAll("User");
     echo '<ul class="list-group">';
     foreach ($users as $u) {
         echo '<li class="list-group-item" id="' . $u->getId() . '"><input type="checkbox" class="ck">&nbsp;' . $u->toString() . "</li>";
     }
     echo "</ul>";
     echo "<button id='btClose' class='btn btn-primary'>Fermer</button>";
     Jquery::bindMethods(true, false);
     Jquery::getOn("click", ".list-group-item", "users/frm", "#response");
     Jquery::doJqueryOn(".ck", "click", "\$(event.target).parent()", "toggleClass", array("disabled", "\$(event.target).prop('checked')"));
     Jquery::doJqueryOn(".list-group-item", "mouseenter", "this", "addClass", array("active"));
     Jquery::doJqueryOn(".list-group-item", "mouseout", "this", "removeClass", "active");
     Jquery::doJqueryOn("#btClose", "click", "#response", "html", "");
     Jquery::doJqueryOn("#btClose", "click", "#main", "show");
     Jquery::doJquery("#main", "hide");
     echo Jquery::compile();
 }
 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>";
     }
 }
Beispiel #14
0
	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 frm($id = NULL)
 {
     $ticket = $this->getInstance($id);
     $categories = DAO::getAll("Categorie");
     $statut = DAO::getAll("Statut");
     if ($ticket->getCategorie() == null) {
         $cat = -1;
         $stat = -1;
     } else {
         $cat = $ticket->getCategorie()->getId();
         $stat = $ticket->getStatut()->getId();
     }
     $listCat = Gui::select($categories, $cat, "Sélectionner une catégorie ...");
     $listStatut = Gui::select($statut, $stat, "Sélectionner un statut ...");
     $listType = Gui::select(array("demande", "intervention"), $ticket->getType(), "Sélectionner un type ...");
     $stat = $ticket->getStatut()->getId();
     $this->loadView("ticket/vAdd", array("ticket" => $ticket, "listCat" => $listCat, "listType" => $listType, "statut" => $statut, "listStatut" => $listStatut));
     echo Jquery::execute("CKEDITOR.replace( 'description');");
     //updteticket
     //s$statutUpdate='coucou1';
     /* '<select class="form-control" class="idStatut" name="idStatut"><br>$listStatut<br></select>'; */
 }
Beispiel #16
0
 public function ajaxSample()
 {
     echo $this->messageInfo("Cocher la case pour désactiver un utilisateur.<br>Cliquer sur une ligne pour modifier l'utilisateur associé." . "<div><label>Utilisateurs à désactiver : <input type='number' class='form-control' id='nb' value='0'></label></div>");
     echo $this->_showMessage("La condition de sortie n'est pas satisfaite !", "danger", 0, false, false);
     $users = DAO::getAll("User");
     echo '<form id="frmUsers"><ul class="list-group">';
     foreach ($users as $u) {
         echo '<li class="list-group-item" id="' . $u->getId() . '"><input type="checkbox" class="ck" name="user[]" id="user-' . $u->getId() . '">&nbsp;' . $u->toString() . "</li>";
     }
     echo "<li class='list-group-item list-group-item-info' id='divCount'><input type='hidden' id='res' value='0'>Aucun utilisateur désactivé</li>";
     echo "</ul></form>";
     echo "<button id='btClose' class='btn btn-primary'>Fermer</button>";
     Jquery::bindMethods(true, false);
     Jquery::getOn("click", ".list-group-item", "users/frm", "#response");
     Jquery::doJqueryOn(".ck", "click", "\$(event.target).parent()", "toggleClass", array("disabled", "\$(event.target).prop('checked')"));
     Jquery::postFormOn("click", ".ck", "sample/ajaxCount", "frmUsers", "#divCount");
     Jquery::doJqueryOn(".list-group-item", "mouseenter", "this", "addClass", array("active"));
     Jquery::doJqueryOn(".list-group-item", "mouseout", "this", "removeClass", "active");
     Jquery::startCondition("\$('#nb').val()==\$('#res').val()", "\$('.alert-danger').show();");
     Jquery::doJqueryOn("#btClose", "click", "#response", "html", "", Jquery::_doJquery("#main", "show"));
     Jquery::doJquery("#main", "hide");
     echo Jquery::compile();
 }
Beispiel #17
0
<?php

use micro\orm\DAO;
$faqs = DAO::getAll("Faq", "1=1 order by idCategorie limit 10");
?>
<div class="container">
	<h2>Classe par categorie</h2>	
	<table class="table table-striped">
	<?php 
foreach ($faqs as $c) {
    ?>
		<?php 
    echo "<thead><tr><th><h3><i>" . $c->getCategorie() . "</i></h3></th></tr></thead>";
    $tpx = $c->getCategorie();
    foreach ($faqs as $f) {
        $x = $f->getSuspendre();
        if ($f->getCategorie() == $tpx && $x == 0) {
            $test = $f->getTitre();
            echo "<tr><td><a class='' href='faqs/contenu/" . $f->getId() . "'>" . $test . "<br></a></td></tr>";
        }
    }
}
?>
	</table>
</div>
Beispiel #18
0
 public function frmUstat($id = NULL)
 {
     $ticket = $this->getInstance($id);
     $statuts = DAO::getAll("statut");
     if ($ticket->getStatut() == null) {
         $stt = -1;
     } else {
         $stt = $ticket->getStatut()->getId();
     }
     $listStatut = Gui::select($statuts, $stt, "Modifier le statut ...");
     $this->loadView("ticket/vUstat", array("ticket" => $ticket, "listStatut" => $listStatut));
 }
Beispiel #19
0
 public function updateStatut($id = NULL)
 {
     $ticket = $this->getInstance($id);
     $statut = DAO::getAll("Statut");
     if ($ticket->getStatut() == null) {
         $stat = -1;
     } else {
         $stat = $ticket->getStatut()->getId();
     }
     $listStatut = Gui::select($statut, $stat, "Sélectionner un statut ...");
     $statuts = DAO::getAll("Statut", "1=1");
     $this->loadView("ticket/vStatut", array("ticket" => $ticket, "listStatut" => $statuts));
 }
Beispiel #20
0
 /**
  * Met à jour le membre $member de $instance annoté par un ManyToMany
  * @param Object $instance
  * @param String $member
  */
 public static function insertOrUpdateManyToMany($instance, $member)
 {
     $parser = new ManyToManyParser($instance, $member);
     if ($parser->init()) {
         $myField = $parser->getMyFkField();
         $field = $parser->getFkField();
         $sql = "INSERT INTO `" . $parser->getJoinTable() . "`(`" . $myField . "`,`" . $field . "`) VALUES (:" . $myField . ",:" . $field . ");";
         $memberAccessor = "get" . ucfirst($member);
         $memberValues = $instance->{$memberAccessor}();
         $myKey = $parser->getMyPk();
         $myAccessorId = "get" . ucfirst($myKey);
         $accessorId = "get" . ucfirst($parser->getPk());
         $id = $instance->{$myAccessorId}();
         if (!is_null($memberValues)) {
             DAO::$db->execute("DELETE FROM `" . $parser->getJoinTable() . "` WHERE `" . $myField . "`='" . $id . "'");
             $statement = DAO::$db->prepareStatement($sql);
             foreach ($memberValues as $k => $targetInstance) {
                 $foreignId = $targetInstance->{$accessorId}();
                 $foreignInstances = DAO::getAll($parser->getTargetEntity(), "`" . $parser->getPk() . "`" . "='" . $foreignId . "'");
                 if (!OrmUtils::exists($targetInstance, $parser->getPk(), $foreignInstances)) {
                     DAO::insert($targetInstance, false);
                     $foreignId = $targetInstance->{$accessorId}();
                     \Logger::log("InsertMany", "Insertion d'une instance de " . get_class($instance));
                 }
                 DAO::$db->bindValueFromStatement($statement, $myField, $id);
                 DAO::$db->bindValueFromStatement($statement, $field, $foreignId);
                 $result = $statement->execute();
                 \Logger::log("InsertMany", "Insertion des valeurs dans la table association '" . $parser->getJoinTable() . "'");
             }
         }
     }
 }
Beispiel #21
0
 public function frmUpdate($id = NULL)
 {
     $faq = $this->getInstance($id);
     $categories = DAO::getAll("Categorie");
     if ($faq->getCategorie() == null) {
         $cat = -1;
     } else {
         $cat = $faq->getCategorie()->getId();
     }
     $listCat = Gui::select($categories, $cat, "Sélectionner une catégorie ...");
     $this->loadView("faq/vUpdate", array("faq" => $faq, "listCat" => $listCat));
 }
Beispiel #22
0
	public function getButtonGroup($ticket){
		$buttonGroup = "";
		$statutsSuivant = $ticket->getStatut()->getStatutsSuivant();
		$listStatutsSuivant = explode(",", $statutsSuivant);
		foreach ( $listStatutsSuivant as $statut) {
			if ($statut == 2 && Auth::getUser()->getGroupe()->getId() == 1) {
				$statut = DAO::getOne("Statut", $statut);
				$buttonGroup .= '<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
								    '.$statut->getAction().' <span class="caret"></span>
								  </button>
								  <ul class="dropdown-menu">
								    <li class="dropdown-header">TECHNICIENS</li>';
				$techs = DAO::getAll("User", "idGroupe = 3");
				foreach ($techs as $tech) {
					$buttonGroup .= '<li class="updateStatut" id="'.$statut->getId().';'.$ticket->getId().';'.$tech->getId().'"><a>'.$tech->getLogin().'</a></li>';
				}
				$admins = DAO::getAll("User", "idGroupe = 1");
				$buttonGroup .= '<li class="dropdown-header">ADMINISTRATEURS</li>';
				foreach ($admins as $admin) {
					$buttonGroup .= '<li class="updateStatut" id="'.$statut->getId().';'.$ticket->getId().';'.$admin->getId().'"><a>'.$admin->getLogin().'</a></li>';
				}
			}elseif($statut > 2) {
				$statut = DAO::getOne("Statut", $statut);
				$buttonGroup .= "<button type='button' class='updateStatut btn btn-".$statut->getCssClass()."' id='".$statut->getId().";".$ticket->getId()."'>".$statut->getAction()."</button>";
			}
		}
		return $buttonGroup;
	}
Beispiel #23
0
 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));
     }
 }
Beispiel #24
0
	public function filter(){
		$sql = "";
		if(isset($_POST['titre'])){
			$sql = "titre LIKE '%".$_POST['titre']."%'";
		}
		if (isset($_POST['idCategorie']) && $_POST['idCategorie'] !="Sélectionner une catégorie ...") {
			if ($sql != "") {
				$sql .= " AND ";
			}
			$sql .= "idCategorie = ".$_POST['idCategorie'];
		}
		if (isset($_POST['idUser']) && $_POST['idUser'] != "Sélectionner l'auteur...") {
			if ($sql != "") {
				$sql .= " AND ";
			}
				$sql .= "idUser = "******"faq/vList", array("faqs"=>$faqs, "sql"=> $sql));
		echo JQuery::execute("$('[data-toggle=\"tooltip\"]').tooltip()");
		echo Jquery::getOn('click', '.suspend', 'Faqs/suspend', '.list');
	}
Beispiel #25
0
$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>&nbsp;<a class="btn btn-primary" href=<?php 
echo "faqs/contenu/" . $b;
?>
>Suivant</a><td></tr>
			<tr><td colspan="2">&nbsp;</td></tr>
			<tr><td colspan="2" class="bg-info"><h2><?php 
</p>
		<label for="categorie"><h4>Emetteur : </h4></label>
		<p id="categorie" name="categorie"><?php 
echo $ticket->getUser();
?>
</p>
		<label for="categorie"><h4>Date de creation : </h4></label>
		<p id="categorie" name="categorie"><?php 
echo $ticket->getDateCreation();
?>
</p>
	</div>
</form>
<?php 
$idTicket = $ticket->getId();
$msg = DAO::getAll("message", "idTicket='" . $idTicket . "'");
$user = $_SESSION["user"]->getId();
foreach ($msg as $oklm) {
    ?>

	<div class="form-group" style="background-color:<?php 
    if ($oklm->getUser()->getAdmin() == True) {
        echo '#FFC3C3;';
    } else {
        echo '#D4F8F9;';
    }
    ?>
padding:20px; margin-top:10px; margin-<?php 
    if ($oklm->getUser()->getAdmin() == True) {
        echo 'right:200px;';
    } else {
 public function mesArticles($param = NULL)
 {
     global $config;
     $this->orderBy = "order by idCategorie";
     $baseHref = get_class($this);
     $objects = DAO::getAll($this->model, $this->where . " " . $this->orderBy);
     echo "<a class='btn btn-primary'  style='margin-right:10px;' href='" . $config["siteUrl"] . $baseHref . "/mesArticles'>Mes articles</a>";
     echo "<a class='btn btn-info' href='" . $config["siteUrl"] . $baseHref . "'>Tous les articles</a>";
     echo "<br><br><table class='table table-striped'><tbody>";
     foreach ($objects as $object) {
         if (Auth::getUser() == $object->getUser()) {
             echo "<tr>";
             echo "<td class='titre-faq' style='width:80%'><a href='" . $baseHref . "/frm2/" . $object->getId() . "' style='color:#253939'><b>" . $object->getTitre() . "</b></a></td>";
             echo "<td class='td-center'><a class='btn btn-success btn-xs' href='" . $baseHref . "/frm2/" . $object->getId() . "'><span class='glyphicon glyphicon-eye-open' aria-hidden='true'></span></a></td>";
             echo "<td class='td-center'><a class='btn btn-primary btn-xs' href='" . $baseHref . "/frm/" . $object->getId() . "'><span class='glyphicon glyphicon-edit' aria-hidden='true'></span></a></td>";
             if ($object->getDisable() == "0") {
                 echo "<td class='td-center'><a class='btn btn-warning btn-xs' href='" . $baseHref . "/disable/" . $object->getId() . "'><span class='glyphicon glyphicon-pause' aria-hidden='true'></span></a></td>";
             } else {
                 echo "<td class='td-center'><a class='btn btn-info btn-xs' href='" . $baseHref . "/activate/" . $object->getId() . "'><span class='glyphicon glyphicon-play' aria-hidden='true'></span></a></td>";
             }
             echo "<td class='td-center'><a class='btn btn-danger btn-xs' href='" . $baseHref . "/delete/" . $object->getId() . "'><span class='glyphicon glyphicon-remove' aria-hidden='true'></span></a></td>";
         }
     }
     echo "</tr>";
     echo "</tbody>";
     echo "</table>";
     if (Auth::isAdmin()) {
         echo "<a class='btn btn-primary' href='" . $config["siteUrl"] . $baseHref . "/frm'>Ajouter...</a>";
     }
 }
 public function test_Modif_Disable_Delete_SES_ARTICLES()
 {
     $this->get("DefaultC/asAdmin");
     $this->waitFor(2);
     $this->get("Faqs");
     $this->waitFor(2);
     $this->assertPageContainsText("Foire aux questions");
     $oklm = DAO::getAll("Faq", "iduser=1");
     $this->assertEquals(count($this->getElementsBySelector("td.x")), 3 * count($oklm));
 }
Beispiel #29
0
	public static function count($className,$condition='',$loadManyToOne=true){
		$objects = DAO::getAll($className,$condition,$loadManyToOne);
		return count($objects);
	}