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;
}
}