gradebook.lib.php 6.8 KB

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