public function getTasksByKeyword($keyword, $type)
{
$tasks = array();
$keyid = Keywords::getKeyID($keyword, $type);
#FB::info('Type '.$type.' Keyword '.$keyword.' Keyid '.$keyid, 'getTasksByKeyword');
$sql = "SELECT `tasks`.`id`, `tasks`.`text`, `tasks`.`raw_string`, `tasks`.`desc`, `tasks`.`date`, `tasks`.`done`,`tasks`.`date_created`,`tasks`.`date_updated`, `tasks`.`priority`,`tasks`.`hidden`,`tasks`.`replyto`\n\t\t\t\tFROM `key_relations` \n\t\t\t\tINNER JOIN `tasks`\n\t\t\t\tON `tasks`.`id` = `key_relations`.`task`\n\t\t\t\tWHERE `key_relations`.`keyword` = " . $keyid . " AND `key_relations`.`user` = " . Site::$user . "\n\t\t\t\tORDER BY `key_relations`.`id` DESC;";
$result = Site::$db->query($sql);
#FB::error($result->num_rows, 'SQL');
if ($result->num_rows > 0) {
while ($task = $result->fetch_object()) {
$item = TaskerHelper::getTaskArray($task);
#FB::info($item, 'ListsHelper');
$tasks[] = $item;
}
}
$this->lists[$keyid]['list'] = array('id' => $keyid, 'name' => $keyword);
$this->lists[$keyid]['tasks'] = $tasks;
}
