/**
* Fetch datas
*
*/
public function fetch_datas()
{
global $dbh;
if ($this->id) {
$query = "select category_title, category_num_parent from docwatch_categories where id_category=" . $this->id;
$result = pmb_mysql_query($query, $dbh);
if ($row = pmb_mysql_fetch_object($result)) {
$this->title = $row->category_title;
$this->num_parent = $row->category_num_parent;
}
} else {
$this->title = "Racine";
$this->num_parent = -1;
}
$query = "select id_watch from docwatch_watches where watch_num_category=" . $this->id;
$result = pmb_mysql_query($query, $dbh);
while ($row = pmb_mysql_fetch_object($result)) {
$docwatch_watch = new docwatch_watch($row->id_watch);
//Gestion des droits utilisateurs (on affiche uniquement les veilles paramétrées pour le current user)
if (in_array(SESSuserid, $docwatch_watch->get_allowed_users())) {
$this->watches[] = $docwatch_watch->get_informations();
}
}
$query = "select id_category from docwatch_categories where category_num_parent=" . $this->id;
$result = pmb_mysql_query($query, $dbh);
while ($row = pmb_mysql_fetch_object($result)) {
$this->children[] = new docwatch_watches($row->id_category);
}
}
