/** * @param int $userId task owner's id * @param int $listId list * @param bool $asArrays whether function should return data as array of arrays of array of objects * * @return TaskModel[]|array[] user's tasks sorted by id desc * @author Karol */ public function getTasks(ListModel $list, $asArrays = false) { $tasks = $list->getTasks(); if (!count($tasks)) { return array(); } $tasksT = array_flip($tasks); $this->dump($tasks); $sql = sprintf("SELECT * FROM task WHERE id IN (%s)", implode(',', $tasks)); $db = FLite::getInstance()->getDB(); $res = $db->getResults($sql); if (!is_array($res)) { return null; } foreach ($res as $row) { $task = new TaskModel($row); $tasksT[$task->getId()] = $asArrays ? $task->toArray() : $task; } return $tasksT; }