Example #1
0
 public function loadNotifiers()
 {
     $id = $this->userid;
     try {
         $conn = Connector::getConn();
         Client::loadIntoArray($this->category, $conn->query("SELECT * FROM category WHERE user_id = {$id}")->fetchAll());
         Client::loadIntoArray($this->dailynots, $conn->query("SELECT t.*, c.name as category_name FROM task_daily t " . "INNER JOIN category c ON t.category_id = c.id WHERE t.user_id = {$id} ORDER BY category_name, id")->fetchAll());
         Client::loadIntoArray($this->weeklynots, $conn->query("SELECT w.*, c.name as category_name FROM task_weekly w " . "INNER JOIN category c ON w.category_id = c.id WHERE w.user_id = {$id} ORDER BY category_name, id")->fetchAll());
         Client::loadIntoArray($this->yearlynots, $conn->query("SELECT y.*, c.name as category_name FROM task_yearly y " . "INNER JOIN category c ON y.category_id = c.id WHERE y.user_id = {$id} ORDER BY category_name, id")->fetchAll());
     } catch (Exception $e) {
         Client::log("Client > loadNotifiers() > Error : " . $e);
     }
 }