123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259 |
- <?php
- class LearnpathLink extends AbstractLink
- {
- private $course_info;
- private $learnpath_table;
- private $learnpath_data;
-
- public function __construct()
- {
- parent::__construct();
- $this->set_type(LINK_LEARNPATH);
- }
-
- public function get_all_links()
- {
- if (empty($this->course_code)) {
- return [];
- }
- $session_id = $this->get_session_id();
- if (empty($session_id)) {
- $session_condition = api_get_session_condition(0, true);
- } else {
- $session_condition = api_get_session_condition($session_id, true, true);
- }
- $sql = 'SELECT id, name FROM '.$this->get_learnpath_table().'
- WHERE c_id = '.$this->course_id.' '.$session_condition.' ';
- $result = Database::query($sql);
- $cats = [];
- while ($data = Database::fetch_array($result)) {
- $cats[] = [$data['id'], $data['name']];
- }
- return $cats;
- }
-
- public function has_results()
- {
- $tbl_stats = Database::get_course_table(TABLE_LP_VIEW);
- $sql = "SELECT count(id) AS number FROM $tbl_stats
- WHERE c_id = ".$this->course_id." AND lp_id = ".$this->get_ref_id();
- $result = Database::query($sql);
- $number = Database::fetch_array($result, 'NUM');
- return $number[0] != 0;
- }
-
- public function calc_score($stud_id = null, $type = null)
- {
- $tbl_stats = Database::get_course_table(TABLE_LP_VIEW);
- $session_id = $this->get_session_id();
- if (empty($session_id)) {
- $session_id = api_get_session_id();
- }
- $sql = "SELECT * FROM $tbl_stats
- WHERE
- c_id = ".$this->course_id." AND
- lp_id = ".$this->get_ref_id()." AND
- session_id = $session_id ";
- if (isset($stud_id)) {
- $sql .= ' AND user_id = '.intval($stud_id);
- }
-
- $sql .= ' ORDER BY view_count DESC';
- $scores = Database::query($sql);
-
- if (isset($stud_id)) {
- if ($data = Database::fetch_assoc($scores)) {
- return [$data['progress'], 100];
- } else {
- return null;
- }
- } else {
-
- $students = [];
-
- $rescount = 0;
- $sum = 0;
- $bestResult = 0;
- $sumResult = 0;
- while ($data = Database::fetch_array($scores)) {
- if (!(array_key_exists($data['user_id'], $students))) {
- $students[$data['user_id']] = $data['progress'];
- $rescount++;
- $sum += $data['progress'] / 100;
- $sumResult += $data['progress'];
- if ($data['progress'] > $bestResult) {
- $bestResult = $data['progress'];
- }
- }
- }
- if ($rescount == 0) {
- return [null, null];
- } else {
- switch ($type) {
- case 'best':
- return [$bestResult, 100];
- break;
- case 'average':
- return [$sumResult / $rescount, 100];
- break;
- case 'ranking':
- return AbstractLink::getCurrentUserRanking($stud_id, $students);
- break;
- default:
- return [$sum, $rescount];
- break;
- }
- }
- }
- }
-
- public function get_link()
- {
- $session_id = $this->get_session_id();
- $url = api_get_path(WEB_CODE_PATH).'lp/lp_controller.php?'.api_get_cidreq_params(
- $this->get_course_code(),
- $session_id
- ).'&gradebook=view';
- if (!api_is_allowed_to_edit() || $this->calc_score(api_get_user_id()) == null) {
- $url .= '&action=view&lp_id='.$this->get_ref_id();
- } else {
- $url .= '&action=build&lp_id='.$this->get_ref_id();
- }
- return $url;
- }
-
- public function get_name()
- {
- $data = $this->get_learnpath_data();
- return $data['name'];
- }
-
- public function get_description()
- {
- $data = $this->get_learnpath_data();
- return $data['description'];
- }
-
- public function is_valid_link()
- {
- $sql = 'SELECT count(id) FROM '.$this->get_learnpath_table().'
- WHERE c_id = '.$this->course_id.' AND id = '.$this->get_ref_id().' ';
- $result = Database::query($sql);
- $number = Database::fetch_row($result, 'NUM');
- return $number[0] != 0;
- }
- public function get_type_name()
- {
- return get_lang('Learning paths');
- }
- public function needs_name_and_description()
- {
- return false;
- }
- public function needs_max()
- {
- return false;
- }
- public function needs_results()
- {
- return false;
- }
- public function is_allowed_to_change_name()
- {
- return false;
- }
- public function get_icon_name()
- {
- return 'learnpath';
- }
-
- private function get_learnpath_table()
- {
- $this->learnpath_table = Database::get_course_table(TABLE_LP_MAIN);
- return $this->learnpath_table;
- }
-
- private function get_learnpath_data()
- {
- if (!isset($this->learnpath_data)) {
- $sql = 'SELECT * FROM '.$this->get_learnpath_table().'
- WHERE c_id = '.$this->course_id.' AND id = '.$this->get_ref_id().' ';
- $result = Database::query($sql);
- $this->learnpath_data = Database::fetch_array($result);
- }
- return $this->learnpath_data;
- }
- }
|