forumthreadlink.class.php 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Gradebook link to student publication item
  5. * @author Bert Steppé
  6. * @package chamilo.gradebook
  7. */
  8. /**
  9. * Class
  10. * @package chamilo.gradebook
  11. */
  12. class ForumThreadLink extends AbstractLink
  13. {
  14. // INTERNAL VARIABLES
  15. private $forum_thread_table = null;
  16. private $itemprop_table = null;
  17. // CONSTRUCTORS
  18. function ForumThreadLink() {
  19. $this->set_type(LINK_FORUM_THREAD);
  20. }
  21. public function get_type_name() {
  22. return get_lang('ForumThreads');
  23. }
  24. public function is_allowed_to_change_name() {
  25. return false;
  26. }
  27. // FUNCTIONS IMPLEMENTING ABSTRACTLINK
  28. /**
  29. * Generate an array of exercises that a teacher hasn't created a link for.
  30. * @return array 2-dimensional array - every element contains 2 subelements (id, name)
  31. */
  32. public function get_not_created_links() {
  33. if (empty($this->course_code)) {
  34. die('Error in get_not_created_links() : course code not set');
  35. }
  36. $tbl_grade_links = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_LINK);
  37. $sql = 'SELECT thread_id,thread_title,thread_title_qualify from '.$this->get_forum_thread_table()
  38. .' forum_thread WHERE thread_id NOT IN'
  39. .' (SELECT ref_id FROM '.$tbl_grade_links
  40. .' WHERE type = '.LINK_FORUM_THREAD
  41. ." AND course_code = '".Database::escape_string($this->get_course_code())."'"
  42. .') AND forum_thread.session_id='.api_get_session_id().'';
  43. $result = Database::query($sql);
  44. $cats=array();
  45. while ($data=Database::fetch_array($result)) {
  46. if ( isset($data['thread_title_qualify']) and $data['thread_title_qualify']!=""){
  47. $cats[] = array ($data['thread_id'], $data['thread_title_qualify']);
  48. } else {
  49. $cats[] = array ($data['thread_id'], $data['thread_title']);
  50. }
  51. }
  52. return $cats;
  53. }
  54. /**
  55. * Generate an array of all exercises available.
  56. * @return array 2-dimensional array - every element contains 2 subelements (id, name)
  57. */
  58. public function get_all_links() {
  59. if (empty($this->course_code)) {
  60. die('Error in get_not_created_links() : course code not set');
  61. }
  62. $course_info = api_get_course_info($this->course_code);
  63. $tbl_grade_links = Database :: get_course_table(TABLE_FORUM_THREAD,$course_info['dbName']);
  64. $tbl_item_property = Database :: get_course_table(TABLE_ITEM_PROPERTY,$course_info['dbName']);
  65. $sql = 'SELECT tl.thread_id, tl.thread_title, tl.thread_title_qualify
  66. FROM '.$tbl_grade_links.' tl ,'.$tbl_item_property.' ip
  67. WHERE tl.c_id = '.$course_info['real_id'].' AND
  68. ip.c_id = '.$course_info['real_id'].' AND
  69. tl.thread_id = ip.ref AND
  70. ip.tool = "forum_thread" AND
  71. ip.visibility<>2 AND tl.session_id='.api_get_session_id().' GROUP BY ip.ref ';
  72. $result = Database::query($sql);
  73. while ($data=Database::fetch_array($result)) {
  74. if ( isset($data['thread_title_qualify']) and $data['thread_title_qualify']!=""){
  75. $cats[] = array ($data['thread_id'], $data['thread_title_qualify']);
  76. } else {
  77. $cats[] = array ($data['thread_id'], $data['thread_title']);
  78. }
  79. }
  80. $my_cats=isset($cats)?$cats:null;
  81. return $my_cats;
  82. }
  83. /**
  84. * Has anyone done this exercise yet ?
  85. */
  86. public function has_results() {
  87. $course_info = api_get_course_info($this->course_code);
  88. $tbl_grade_links = Database :: get_course_table(TABLE_FORUM_POST,$course_info['dbName']);
  89. $sql = 'SELECT count(*) AS number FROM '.$tbl_grade_links."
  90. WHERE c_id = ".$course_info['real_id']." AND thread_id = '".$this->get_ref_id()."'";
  91. $result = Database::query($sql);
  92. $number=Database::fetch_row($result);
  93. return ($number[0] != 0);
  94. }
  95. public function calc_score($stud_id = null) {
  96. $course_info = Database :: get_course_info($this->get_course_code());
  97. $database_name = (empty($course_info['db_name']))?$course_info['dbName']:$course_info['db_name'];
  98. if (!empty($database_name)) {
  99. $thread_qualify = Database :: get_course_table(TABLE_FORUM_THREAD_QUALIFY, $database_name);
  100. $sql = 'SELECT thread_qualify_max FROM '.Database :: get_course_table(TABLE_FORUM_THREAD, $database_name)."
  101. WHERE c_id = ".$course_info['real_id']." AND thread_id = '".$this->get_ref_id()."'";
  102. $query = Database::query($sql);
  103. $assignment = Database::fetch_array($query);
  104. $sql = "SELECT * FROM $thread_qualify WHERE c_id = ".$course_info['real_id']." AND thread_id = ".$this->get_ref_id();
  105. if (isset($stud_id)) {
  106. $sql .= ' AND user_id = '."'".intval($stud_id)."'";
  107. }
  108. // order by id, that way the student's first attempt is accessed first
  109. $sql .= ' ORDER BY qualify_time DESC';
  110. $scores = Database::query($sql);
  111. // for 1 student
  112. if (isset($stud_id)) {
  113. if ($data = Database::fetch_array($scores)) {
  114. return array ($data['qualify'], $assignment['thread_qualify_max']);
  115. } else {
  116. //We sent the 0/thread_qualify_max instead of null for correct calculations
  117. //return null;
  118. return array (0, $assignment['thread_qualify_max']);
  119. }
  120. } else {
  121. // all students -> get average
  122. $students=array(); // user list, needed to make sure we only
  123. // take first attempts into account
  124. $rescount = 0;
  125. $sum = 0;
  126. while ($data=Database::fetch_array($scores)) {
  127. if (!(array_key_exists($data['user_id'],$students))) {
  128. if ($assignment['thread_qualify_max'] != 0) {
  129. $students[$data['user_id']] = $data['qualify'];
  130. $rescount++;
  131. $sum += ($data['qualify'] / $assignment['thread_qualify_max']);
  132. }
  133. }
  134. }
  135. if ($rescount == 0) {
  136. return null;
  137. } else {
  138. return array ($sum , $rescount);
  139. }
  140. }
  141. }
  142. }
  143. // INTERNAL FUNCTIONS
  144. /**
  145. * Lazy load function to get the database table of the student publications
  146. */
  147. private function get_forum_thread_table () {
  148. $course_info = Database :: get_course_info($this->get_course_code());
  149. $database_name = isset($course_info['db_name']) ? $course_info['db_name'] : '';
  150. if ($database_name!='') {
  151. if (!isset($this->forum_thread_table)) {
  152. $this->forum_thread_table = Database :: get_course_table(TABLE_FORUM_THREAD, $database_name);
  153. }
  154. return $this->forum_thread_table;
  155. } else {
  156. return '';
  157. }
  158. }
  159. /**
  160. * Lazy load function to get the database table of the item properties
  161. */
  162. private function get_itemprop_table () {
  163. if (!isset($this->itemprop_table)) {
  164. $course_info = Database :: get_course_info($this->get_course_code());
  165. $database_name = $course_info['db_name'];
  166. $this->itemprop_table = Database :: get_course_table(TABLE_ITEM_PROPERTY, $database_name);
  167. }
  168. return $this->itemprop_table;
  169. }
  170. public function needs_name_and_description() {
  171. return false;
  172. }
  173. public function needs_max() {
  174. return false;
  175. }
  176. public function needs_results() {
  177. return false;
  178. }
  179. public function get_name() {
  180. $this->get_exercise_data();
  181. $thread_title=isset($this->exercise_data['thread_title']) ? $this->exercise_data['thread_title'] : '';
  182. $thread_title_qualify=isset($this->exercise_data['thread_title_qualify']) ? $this->exercise_data['thread_title_qualify'] : '';
  183. if ( isset($thread_title_qualify) && $thread_title_qualify!="") {
  184. return $this->exercise_data['thread_title_qualify'];
  185. } else {
  186. return $thread_title;
  187. }
  188. }
  189. public function get_description() {
  190. return '';//$this->exercise_data['description'];
  191. }
  192. /**
  193. * Check if this still links to an exercise
  194. */
  195. public function is_valid_link() {
  196. $sql = 'SELECT count(id) from '.$this->get_forum_thread_table()
  197. .' WHERE thread_id = '.$this->get_ref_id().' AND session_id='.api_get_session_id().'';
  198. $result = Database::query($sql);
  199. $number=Database::fetch_row($result);
  200. return ($number[0] != 0);
  201. }
  202. public function get_test_id() {
  203. return 'DEBUG:ID';
  204. }
  205. public function get_link() {
  206. //it was extracts the forum id
  207. $tbl_name=$this->get_forum_thread_table();
  208. if ($tbl_name!="") {
  209. $sql = 'SELECT * FROM '.$this->get_forum_thread_table()." WHERE thread_id = '".$this->get_ref_id()."' AND session_id = ".api_get_session_id()."";
  210. $result = Database::query($sql);
  211. $row = Database::fetch_array($result,'ASSOC');
  212. $forum_id=$row['forum_id'];
  213. $url = api_get_path(WEB_PATH)
  214. .'main/forum/viewthread.php?cidReq='.$this->get_course_code().'&thread='.$this->get_ref_id().'&gradebook=view&forum='.$forum_id;
  215. return $url;
  216. }
  217. }
  218. private function get_exercise_data() {
  219. $tbl_name=$this->get_forum_thread_table();
  220. if ($tbl_name=='') {
  221. return false;
  222. }elseif (!isset($this->exercise_data)) {
  223. $sql = 'SELECT * FROM '.$this->get_forum_thread_table()." WHERE thread_id = '".$this->get_ref_id()."' AND session_id=".api_get_session_id()."";
  224. $query = Database::query($sql);
  225. $this->exercise_data = Database::fetch_array($query);
  226. }
  227. return $this->exercise_data;
  228. }
  229. public function get_icon_name() {
  230. return 'forum';
  231. }
  232. }