public function getCourseObjectivesMobile() { global $db; if ($this->getCourseID()) { $objectives = array("required" => array(), "logged" => array(), "disabled" => array()); $required_objectives = Models_Logbook::getAllRequiredObjectivesMobile($this->getCourseID()); foreach ($required_objectives as $required_objective) { $query = "SELECT a.`objective_id` FROM `logbook_entry_objectives` AS a\n JOIN `logbook_entries` AS b\n ON a.`lentry_id` = b.`lentry_id`\n WHERE b.`entry_active` = 1\n AND b.`course_id` = " . $db->qstr($this->getCourseID()) . "\n AND a.`objective_id` = " . $db->qstr($required_objective["objective_id"]) . "\n AND a.`objective_active` = 1\n LIMIT 0, 1"; $objective_found = $db->getOne($query) ? true : false; $objectives[$this->attachedObjectiveIsDuplicate($required_objective["objective_id"]) ? "disabled" : ($objective_found ? "logged" : "required")][] = $required_objective; } return $objectives; } else { return false; } }