예제 #1
0
 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;
     }
 }