gradebook.lib.php 6.3 KB

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