attendancelink.class.php 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Gradebook link to attendance item
  5. * @author Christian Fasanando (christian1827@gmail.com)
  6. * @package chamilo.gradebook
  7. */
  8. class AttendanceLink extends AbstractLink
  9. {
  10. private $attendance_table = null;
  11. private $itemprop_table = null;
  12. /**
  13. * Constructor
  14. */
  15. public function __construct()
  16. {
  17. parent::__construct();
  18. $this->set_type(LINK_ATTENDANCE);
  19. }
  20. /**
  21. * @return string
  22. */
  23. public function get_type_name()
  24. {
  25. return get_lang('Attendance');
  26. }
  27. /**
  28. * @return bool
  29. */
  30. public function is_allowed_to_change_name()
  31. {
  32. return false;
  33. }
  34. /**
  35. * Generate an array of attendances that a teacher hasn't created a link for.
  36. * @return array 2-dimensional array - every element contains 2 subelements (id, name)
  37. * @todo seems to be depracated
  38. */
  39. public function get_not_created_links()
  40. {
  41. return false;
  42. if (empty($this->course_code)) {
  43. die('Error in get_not_created_links() : course code not set');
  44. }
  45. $tbl_grade_links = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_LINK);
  46. $sql = 'SELECT att.id, att.name, att.attendance_qualify_title
  47. FROM '.$this->get_attendance_table().' att
  48. WHERE att.c_id = '.$this->course_id.' AND att.id NOT IN (SELECT ref_id FROM '.$tbl_grade_links.' WHERE type = '.LINK_ATTENDANCE.' AND course_code = "'.Database::escape_string($this->get_course_code()).'")
  49. AND att.session_id='.api_get_session_id().'';
  50. $result = Database::query($sql);
  51. $cats=array();
  52. while ($data=Database::fetch_array($result)) {
  53. if ( isset($data['attendance_qualify_title']) && $data['attendance_qualify_title'] != ''){
  54. $cats[] = array ($data['id'], $data['attendance_qualify_title']);
  55. } else {
  56. $cats[] = array ($data['id'], $data['name']);
  57. }
  58. }
  59. return $cats;
  60. }
  61. /**
  62. * Generate an array of all attendances available.
  63. * @return array 2-dimensional array - every element contains 2 subelements (id, name)
  64. */
  65. public function get_all_links()
  66. {
  67. if (empty($this->course_code)) {
  68. die('Error in get_not_created_links() : course code not set');
  69. }
  70. $tbl_attendance = $this->get_attendance_table();
  71. $session_id = api_get_session_id();
  72. /*
  73. if (empty($session_id)) {
  74. $session_condition = api_get_session_condition(0, true);
  75. } else {
  76. $session_condition = api_get_session_condition($session_id, true, true);
  77. }
  78. $sql = 'SELECT att.id, att.name, att.attendance_qualify_title
  79. FROM '.$tbl_attendance.' att
  80. WHERE att.c_id = '.$this->course_id.' AND att.active = 1 '.$session_condition;*/
  81. $sql = 'SELECT att.id, att.name, att.attendance_qualify_title
  82. FROM '.$tbl_attendance.' att
  83. WHERE att.c_id = '.$this->course_id.' AND att.active = 1 AND att.session_id = '.$session_id;
  84. $result = Database::query($sql);
  85. while ($data=Database::fetch_array($result)) {
  86. if (isset($data['attendance_qualify_title']) && $data['attendance_qualify_title'] != ''){
  87. $cats[] = array ($data['id'], $data['attendance_qualify_title']);
  88. } else {
  89. $cats[] = array ($data['id'], $data['name']);
  90. }
  91. }
  92. $my_cats = isset($cats)?$cats:null;
  93. return $my_cats;
  94. }
  95. /**
  96. * Has anyone done this exercise yet ?
  97. */
  98. public function has_results()
  99. {
  100. $tbl_attendance_result = Database :: get_course_table(TABLE_ATTENDANCE_RESULT);
  101. $session_id = api_get_session_id();
  102. $sql = 'SELECT count(*) AS number FROM '.$tbl_attendance_result."
  103. WHERE session_id = $session_id AND c_id = '.$this->course_id.' AND attendance_id = '".intval($this->get_ref_id())."'";
  104. $result = Database::query($sql);
  105. $number = Database::fetch_row($result);
  106. return ($number[0] != 0);
  107. }
  108. /**
  109. * @param int $stud_id
  110. * @return array|null
  111. */
  112. public function calc_score($stud_id = null, $type = null)
  113. {
  114. $tbl_attendance_result = Database::get_course_table(TABLE_ATTENDANCE_RESULT);
  115. $session_id = api_get_session_id();
  116. // get attendance qualify max
  117. $sql = 'SELECT att.attendance_qualify_max FROM '.$this->get_attendance_table().' att
  118. WHERE
  119. att.c_id = '.$this->course_id.' AND
  120. att.id = '.intval($this->get_ref_id()).' AND
  121. att.session_id='.intval($session_id).'';
  122. $query = Database::query($sql);
  123. $attendance = Database::fetch_array($query);
  124. // get results
  125. $sql = 'SELECT * FROM '.$tbl_attendance_result.'
  126. WHERE c_id = '.$this->course_id.' AND attendance_id = '.intval($this->get_ref_id());
  127. if (isset($stud_id)) {
  128. $sql .= ' AND user_id = '.intval($stud_id);
  129. }
  130. $scores = Database::query($sql);
  131. // for 1 student
  132. if (isset($stud_id)) {
  133. if ($data = Database::fetch_array($scores)) {
  134. return array ($data['score'], $attendance['attendance_qualify_max']);
  135. } else {
  136. //We sent the 0/attendance_qualify_max instead of null for correct calculations
  137. return array (0, $attendance['attendance_qualify_max']);
  138. }
  139. } else {// all students -> get average
  140. $students = array(); // user list, needed to make sure we only
  141. // take first attempts into account
  142. $rescount = 0;
  143. $sum = 0;
  144. $sumResult = 0;
  145. $bestResult = 0;
  146. while ($data = Database::fetch_array($scores)) {
  147. if (!(array_key_exists($data['user_id'], $students))) {
  148. if ($attendance['attendance_qualify_max'] != 0) {
  149. $students[$data['user_id']] = $data['score'];
  150. $rescount++;
  151. $sum += $data['score'] / $attendance['attendance_qualify_max'];
  152. $sumResult += $data['score'];
  153. if ($data['score'] > $bestResult) {
  154. $bestResult = $data['score'];
  155. }
  156. $weight = $attendance['attendance_qualify_max'];
  157. }
  158. }
  159. }
  160. if ($rescount == 0) {
  161. return null;
  162. } else {
  163. switch ($type) {
  164. case 'best':
  165. return array($bestResult, $weight);
  166. break;
  167. case 'average':
  168. return array($sumResult / $rescount, $weight);
  169. break;
  170. case 'ranking':
  171. return AbstractLink::getCurrentUserRanking($students);
  172. break;
  173. default:
  174. return array($sum, $rescount);
  175. break;
  176. }
  177. }
  178. }
  179. }
  180. /**
  181. * Lazy load function to get the database table of the student publications
  182. */
  183. private function get_attendance_table()
  184. {
  185. $this->attendance_table = Database :: get_course_table(TABLE_ATTENDANCE);
  186. return $this->attendance_table;
  187. }
  188. /**
  189. * Lazy load function to get the database table of the item properties
  190. */
  191. private function get_itemprop_table()
  192. {
  193. $this->itemprop_table = Database :: get_course_table(TABLE_ITEM_PROPERTY);
  194. return $this->itemprop_table;
  195. }
  196. public function needs_name_and_description()
  197. {
  198. return false;
  199. }
  200. public function needs_max()
  201. {
  202. return false;
  203. }
  204. public function needs_results()
  205. {
  206. return false;
  207. }
  208. public function get_name()
  209. {
  210. $this->get_attendance_data();
  211. $attendance_title = isset($this->attendance_data['name']) ? $this->attendance_data['name'] : '';
  212. $attendance_qualify_title = isset($this->attendance_data['attendance_qualify_title']) ? $this->attendance_data['attendance_qualify_title'] : '';
  213. if ( isset($attendance_qualify_title) && $attendance_qualify_title != '') {
  214. return $this->attendance_data['attendance_qualify_title'];
  215. } else {
  216. return $attendance_title;
  217. }
  218. }
  219. public function get_description()
  220. {
  221. return '';
  222. }
  223. /**
  224. * Check if this still links to an exercise
  225. */
  226. public function is_valid_link()
  227. {
  228. $session_id = api_get_session_id();
  229. $sql = 'SELECT count(att.id) FROM '.$this->get_attendance_table().' att
  230. WHERE att.c_id = '.$this->course_id.' AND att.id = '.intval($this->get_ref_id()).' ';
  231. $result = Database::query($sql);
  232. $number = Database::fetch_row($result);
  233. return ($number[0] != 0);
  234. }
  235. public function get_test_id()
  236. {
  237. return 'DEBUG:ID';
  238. }
  239. public function get_link()
  240. {
  241. //it was extracts the attendance id
  242. $session_id = api_get_session_id();
  243. $sql = 'SELECT * FROM '.$this->get_attendance_table().' att
  244. WHERE att.c_id = '.$this->course_id.' AND att.id = '.intval($this->get_ref_id()).' ';
  245. $result = Database::query($sql);
  246. $row = Database::fetch_array($result,'ASSOC');
  247. $attendance_id = $row['id'];
  248. $url = api_get_path(WEB_PATH).'main/attendance/index.php?action=attendance_sheet_list&gradebook=view&attendance_id='.$attendance_id.'&session_id='.$session_id.'&cidReq='.$this->get_course_code();
  249. return $url;
  250. }
  251. private function get_attendance_data()
  252. {
  253. $tbl_name = $this->get_attendance_table();
  254. $session_id = api_get_session_id();
  255. if ($tbl_name == '') {
  256. return false;
  257. } elseif (!isset($this->attendance_data)) {
  258. $sql = 'SELECT * FROM '.$this->get_attendance_table().' att
  259. WHERE att.c_id = '.$this->course_id.' AND att.id = '.intval($this->get_ref_id()).' ';
  260. $query = Database::query($sql);
  261. $this->attendance_data = Database::fetch_array($query);
  262. }
  263. return $this->attendance_data;
  264. }
  265. public function get_icon_name()
  266. {
  267. return 'attendance';
  268. }
  269. }