public function getListeGen($filtre = ' 1 = 1 ', $format = 'resultquery') { $requete = new XhamRequete($this->getBDD(), $this->nomTable, '', $this->getHost(), $this->getUser(), $this->getPass()); return $requete->getGen($filtre, $format); }
function genListeTodo() { $req = new XhamRequete(BASEXHAM, 'todo', array(), MYSQL_HOST, MYSQL_USER, MYSQL_PASS); switch ($this->xham->getr('Categorie')) { case 'all': $filtreCates = "1=1"; break; case '#': $filtreCates = "categorie=''"; break; default: $filtreCates = "categorie='" . utf8_decode($this->xham->getr('Categorie')) . "'"; break; } switch ($this->xham->getr('idUser')) { case 'all': $filtreUsers = "(idUser='******' OR public=1)"; break; case '#': $filtreUsers = "idUser='******'"; break; default: $filtreUsers = "idUser='******'idUser') . "'"; break; } switch ($this->xham->getr('Mode')) { default: $filtreModes = "etat like '" . $this->xham->getr('Mode') . "'"; break; } $filtre = " {$filtreCates} and {$filtreUsers} and {$filtreModes} "; $res = $req->getGen("{$filtre} order by etat, date", "resultQuery"); $ras = $req->getGen("{$filtreCates} and {$filtreUsers} and etat='afaire' order by etat", "resultQuery", 'sum(importance) nbHeures'); $rus = $req->getGen("{$filtreCates} and {$filtreUsers} and etat='encours' order by etat", "resultQuery", 'sum(importance) nbHeures'); $ris = $req->getGen("{$filtreCates} and {$filtreUsers} and etat='termines' order by etat", "resultQuery", 'sum(importance) nbHeures'); //print affTab ( $ras['INDIC_SVC'] ) ; $mod = new ModeliXe("TodoListe.html"); $mod->SetModeliXe(); $mod->MxText('recap', 'A faire : ' . ($ras['nbHeures'][0] ? $ras['nbHeures'][0] : '0') . 'h - En cours : ' . ($rus['nbHeures'][0] ? $rus['nbHeures'][0] : '0') . 'h - Terminés : ' . ($ris['nbHeures'][0] ? $ris['nbHeures'][0] : '0') . 'h'); $date = new clDate(); if ($res['INDIC_SVC'][2] == 0) { $mod->MxBloc('todo', 'replace', '<td colspan="6">Aucun todo.</td>'); } else { for ($i = 0; isset($res['idTodo'][$i]); $i++) { $js = XhamTools::genAjax('onClick', 'refreshTodo', 'ajax=changeStatus&idTodo=' . $res['idTodo'][$i] . '&navi=' . $this->xham->genNaviFull()); /* if ( $res['etat'][$i] != 'termines' ) $mod -> MxText ( 'todo.js', $js ) ; else $mod -> MxText ( 'todo.js', '' ) ; */ $mod->MxText('todo.js', $js); $mod->MxText('todo.class', $res['etat'][$i]); $mod->MxText('todo.idUser', $res['idUser'][$i]); $mod->MxText('todo.categorie', $res['categorie'][$i]); $mod->MxText('todo.nom', $res['nom'][$i]); $date->setDate($res['date'][$i]); $mod->MxText('todo.date', $date->getDate('Y-m-d H:i:s')); if ($res['dateLimite'][$i] != '0000-00-00 00:00:00') { $date->setDate($res['dateLimite'][$i]); $mod->MxText('todo.dateLimite', $date->getDate('Y-m-d')); } else { $mod->MxText('todo.dateLimite', VIDEDEFAUT); } $mod->MxText('todo.importance', $res['importance'][$i]); $mod->MxBloc('todo', 'loop'); } } $af = $mod->MxWrite("1"); if ($this->ajax) { $this->af .= $af; } else { return $af; } }