gradebook.lib.php 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * This class provides methods for the notebook management.
  5. * Include/require it in your code to use its features.
  6. * @package chamilo.library
  7. */
  8. /**
  9. * Code
  10. */
  11. class Gradebook extends Model
  12. {
  13. public $columns = array('id', 'name', 'description', 'course_code', 'parent_id', 'grade_model_id', 'session_id', 'weight', 'user_id');
  14. public function __construct()
  15. {
  16. $this->table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);
  17. $this->table_skill = Database::get_main_table(TABLE_MAIN_SKILL);
  18. $this->table_skill_rel_gradebook = Database::get_main_table(TABLE_MAIN_SKILL_REL_GRADEBOOK);
  19. }
  20. /**
  21. * Returns true if the gradebook is active and visible in a course, false
  22. * otherwise.
  23. *
  24. * @param int $c_id Course integer id, defaults to the current course
  25. * @return boolean
  26. */
  27. public static function is_active($c_id = null)
  28. {
  29. $name = 'gradebook';
  30. $table = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
  31. $sql = "SELECT * from $table WHERE variable='course_hide_tools' AND subkey='$name' LIMIT 1";
  32. $result = Database::query($sql);
  33. $setting = Database::store_result($result);
  34. $setting = isset($setting[0]) ? $setting[0] : null;
  35. $setting = $setting ? $setting : array();
  36. $inactive = isset($setting['selected_value']) && $setting['selected_value'] == 'true';
  37. if ($inactive) {
  38. return false;
  39. }
  40. $c_id = $c_id ? intval($c_id) : api_get_course_int_id();
  41. $table = Database::get_course_table(TABLE_TOOL_LIST);
  42. $sql = "SELECT * from $table WHERE c_id = $c_id and name='$name' LIMIT 1";
  43. $result = Database::query($sql);
  44. $item = Database::store_result($result, 'ASSOC');
  45. $item = isset($item[0]) ? $item[0] : null;
  46. if (empty($item)) {
  47. return true;
  48. }
  49. return $item['visibility'] == '1';
  50. }
  51. public function get_all($options = array())
  52. {
  53. $gradebooks = parent::get_all($options);
  54. foreach ($gradebooks as &$gradebook) {
  55. if (empty($gradebook['name'])) {
  56. $gradebook['name'] = $gradebook['course_code'];
  57. }
  58. //$gradebook['name'] = $gradebook['course_code'] .' > '.$gradebook['name'];
  59. }
  60. return $gradebooks;
  61. }
  62. public function update($params)
  63. {
  64. return parent::update($params);
  65. }
  66. public function update_skills_to_gradebook($gradebook_id, $skill_list)
  67. {
  68. if (!empty($skill_list)) {
  69. //Cleaning skills
  70. $skill_list = array_map('intval', $skill_list);
  71. $skill_list = array_filter($skill_list);
  72. $skill_gradebook = new SkillRelGradebook();
  73. $skill_gradebooks_source = $skill_gradebook->get_all(array('where'=>array('gradebook_id = ?' =>$gradebook_id)));
  74. $clean_gradebook = array();
  75. if (!empty($skill_gradebooks_source)) {
  76. foreach($skill_gradebooks_source as $source) {
  77. $clean_gradebook[]= $source['skill_id'];
  78. }
  79. }
  80. if (!empty($clean_gradebook)) {
  81. $skill_to_remove = array_diff($clean_gradebook, $skill_list);
  82. }
  83. foreach ($skill_list as $skill_id) {
  84. $params = array();
  85. $params['gradebook_id'] = $gradebook_id;
  86. $params['skill_id'] = $skill_id;
  87. if (!$skill_gradebook->exists_gradebook_skill($gradebook_id, $skill_id)) {
  88. $skill_gradebook->save($params);
  89. }
  90. }
  91. if (!empty($skill_to_remove)) {
  92. foreach($skill_to_remove as $remove) {
  93. $skill_item = $skill_gradebook->get_skill_info($remove, $gradebook_id);
  94. $skill_gradebook->delete($skill_item['id']);
  95. }
  96. }
  97. return true;
  98. }
  99. return false;
  100. }
  101. /**
  102. * Returns a Form validator Obj
  103. * @todo the form should be auto generated
  104. * @param string url
  105. * @param string action add, edit
  106. * @return obj form validator obj
  107. */
  108. public function show_skill_form($gradebook_id, $url, $header = null)
  109. {
  110. $form = new FormValidator('gradebook_add_skill', 'POST', $url);
  111. // Setting the form elements
  112. if (!isset($header)) {
  113. $header = get_lang('Add');
  114. }
  115. $form->addElement('header', '', $header);
  116. $id = isset($_GET['id']) ? intval($_GET['id']) : '';
  117. $form->addElement('hidden', 'id', $id);
  118. $skill = new Skill();
  119. $skills = $skill->get_all();
  120. $clean_skill_list = array();
  121. foreach ($skills as $skill) {
  122. $clean_skill_list[$skill['id']] = $skill['name'];
  123. }
  124. $form->addElement('select', 'skill', get_lang('Skills'), $clean_skill_list, array('width'=>'450px', 'class'=>'chzn-select','multiple' => 'multiple'));
  125. $selected_skills = self::get_skills_by_gradebook($gradebook_id);
  126. $clean_selected_skills = array();
  127. if (!empty($selected_skills)) {
  128. foreach($selected_skills as $skill) {
  129. $clean_selected_skills[] = $skill['id'];
  130. }
  131. }
  132. $form->addElement('style_submit_button', 'submit', get_lang('Add'), 'class="save"');
  133. $form->setDefaults(array('skill'=>$clean_selected_skills));
  134. return $form;
  135. }
  136. /**
  137. * @param int $gradebook_id
  138. * @return array|resource
  139. */
  140. function get_skills_by_gradebook($gradebook_id)
  141. {
  142. $gradebook_id = intval($gradebook_id);
  143. $sql = "SELECT skill.id, skill.name FROM {$this->table_skill} skill INNER JOIN {$this->table_skill_rel_gradebook} skill_rel_gradebook
  144. ON skill.id = skill_rel_gradebook.skill_id
  145. WHERE skill_rel_gradebook.gradebook_id = $gradebook_id";
  146. $result = Database::query($sql);
  147. $result = Database::store_result($result,'ASSOC');
  148. return $result;
  149. }
  150. /**
  151. * Displays the title + grid
  152. */
  153. public function display()
  154. {
  155. // action links
  156. echo Display::grid_html('gradebooks');
  157. }
  158. }