attendance_controller.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * This file contains class used like controller, it should be included inside a dispatcher file (e.g: index.php)
  5. *
  6. * !!! WARNING !!! : ALL DATES IN THIS MODULE ARE STORED IN UTC ! DO NOT CONVERT DURING THE TRANSITION FROM CHAMILO 1.8.x TO 2.0
  7. *
  8. * @author Christian Fasanando <christian1827@gmail.com>
  9. * @author Julio Montoya <gugli100@gmail.com> lot of bugfixes + improvements
  10. * @package chamilo.attendance
  11. */
  12. /**
  13. * Controller script. Prepares the common background variables to give to the scripts corresponding to
  14. * the requested action
  15. * @package chamilo.attendance
  16. */
  17. class AttendanceController
  18. {
  19. /**
  20. * Constructor
  21. */
  22. public function __construct() {
  23. $this->toolname = 'attendance';
  24. $this->view = new View($this->toolname);
  25. }
  26. /**
  27. * It's used for listing attendace,
  28. * render to attendance_list view
  29. * @param boolean true for listing history (optional)
  30. * @param array message for showing by action['edit','add','delete'] (optional)
  31. */
  32. public function attendance_list($history=false,$messages=array()) {
  33. $attendance = new Attendance();
  34. $data = array();
  35. // render to the view
  36. $this->view->set_data($data);
  37. $this->view->set_layout('layout');
  38. $this->view->set_template('attendance_list');
  39. $this->view->render();
  40. }
  41. /**
  42. * It's used for adding attendace,
  43. * render to attendance_add or attendance_list view
  44. */
  45. public function attendance_add() {
  46. $attendance = new Attendance();
  47. $data = array();
  48. if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
  49. if (!empty($_POST['title'])) {
  50. $check = Security::check_token();
  51. if ($check) {
  52. $attendance->set_name($_POST['title']);
  53. $attendance->set_description($_POST['description']);
  54. $attendance->set_attendance_qualify_title($_POST['attendance_qualify_title']);
  55. $attendance->set_attendance_weight($_POST['attendance_weight']);
  56. $link_to_gradebook = false;
  57. if ( isset($_POST['attendance_qualify_gradebook']) && $_POST['attendance_qualify_gradebook'] == 1 ) {
  58. $link_to_gradebook = true;
  59. }
  60. $last_id = $attendance->attendance_add($link_to_gradebook);
  61. Security::clear_token();
  62. }
  63. $param_gradebook = '';
  64. if (isset($_SESSION['gradebook'])) {
  65. $param_gradebook = '&gradebook='.Security::remove_XSS($_SESSION['gradebook']);
  66. }
  67. header('location:index.php?action=attendance_sheet_list&attendance_id='.$last_id.'&'.api_get_cidreq().$param_gradebook);
  68. exit;
  69. } else {
  70. $data['error'] = true;
  71. $this->view->set_data($data);
  72. $this->view->set_layout('layout');
  73. $this->view->set_template('attendance_add');
  74. $this->view->render();
  75. }
  76. } else {
  77. $this->view->set_data($data);
  78. $this->view->set_layout('layout');
  79. $this->view->set_template('attendance_add');
  80. $this->view->render();
  81. }
  82. }
  83. /**
  84. * It's used for editing attendace,
  85. * render to attendance_edit or attendance_list view
  86. * @param int attendance id
  87. */
  88. public function attendance_edit($attendance_id) {
  89. $attendance = new Attendance();
  90. $data = array();
  91. $attendance_id = intval($attendance_id);
  92. if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
  93. if (!empty($_POST['title'])) {
  94. $check = Security::check_token();
  95. if ($check) {
  96. $attendance->set_name($_POST['title']);
  97. $attendance->set_description($_POST['description']);
  98. $attendance->set_attendance_qualify_title($_POST['attendance_qualify_title']);
  99. $attendance->set_attendance_weight($_POST['attendance_weight']);
  100. $link_to_gradebook = false;
  101. if ( isset($_POST['attendance_qualify_gradebook']) && $_POST['attendance_qualify_gradebook'] == 1 ) {
  102. $link_to_gradebook = true;
  103. }
  104. $last_id = $attendance->attendance_edit($attendance_id,$link_to_gradebook);
  105. Security::clear_token();
  106. $param_gradebook = '';
  107. if (isset($_SESSION['gradebook'])) {
  108. $param_gradebook = '&gradebook='.Security::remove_XSS($_SESSION['gradebook']);
  109. }
  110. header('location:index.php?action=attendance_list&'.api_get_cidreq().$param_gradebook);
  111. exit;
  112. }
  113. } else {
  114. $data['attendance_id'] = $_POST['attendance_id'];
  115. $data['error'] = true;
  116. $this->view->set_data($data);
  117. $this->view->set_layout('layout');
  118. $this->view->set_template('attendance_edit');
  119. $this->view->render();
  120. }
  121. } else {
  122. // default values
  123. $attendance_data = $attendance->get_attendance_by_id($attendance_id);
  124. $data['attendance_id'] = $attendance_data['id'];
  125. $data['title'] = $attendance_data['name'];
  126. $data['description'] = $attendance_data['description'];
  127. $data['attendance_qualify_title'] = $attendance_data['attendance_qualify_title'];
  128. $data['attendance_weight'] = $attendance_data['attendance_weight'];
  129. $this->view->set_data($data);
  130. $this->view->set_layout('layout');
  131. $this->view->set_template('attendance_edit');
  132. $this->view->render();
  133. }
  134. }
  135. /**
  136. * It's used for delete attendace,
  137. * render to attendance_list view
  138. * @param int attendance id
  139. */
  140. public function attendance_delete($attendance_id) {
  141. $attendance = new Attendance();
  142. //$attendance_id = intval($attendance_id);
  143. if (!empty($attendance_id)) {
  144. $affected_rows = $attendance->attendance_delete($attendance_id);
  145. }
  146. if ($affected_rows) {
  147. $message['message_attendance_delete'] = true;
  148. }
  149. $this->attendance_list();
  150. }
  151. /**
  152. * Lock or unlock an attendance
  153. * render to attendance_list view
  154. * @param string action (lock_attendance or unlock_attendance)
  155. * @param int attendance id
  156. * render to attendance_list view
  157. */
  158. public function lock_attendance($action, $attendance_id) {
  159. $attendance = new Attendance();
  160. $attendance_id = intval($attendance_id);
  161. if ($action == 'lock_attendance') {
  162. $result = $attendance->lock_attendance($attendance_id);
  163. } else {
  164. $result = $attendance->lock_attendance($attendance_id, false);
  165. }
  166. if ($affected_rows) {
  167. $message['message_locked_attendance'] = true;
  168. }
  169. $this->attendance_list();
  170. }
  171. /**
  172. * It's used for controlling attendace sheet (list, add),
  173. * render to attendance_sheet view
  174. * @param string action
  175. * @param int attendance id
  176. */
  177. public function attendance_sheet($action, $attendance_id, $student_id = 0) {
  178. $attendance = new Attendance();
  179. $data = array();
  180. $data['attendance_id'] = $attendance_id;
  181. $data['users_in_course'] = $attendance->get_users_rel_course($attendance_id);
  182. $filter_type = 'today';
  183. if (!empty($_REQUEST['filter'])) {
  184. $filter_type = $_REQUEST['filter'];
  185. }
  186. if (api_is_allowed_to_edit(null, true)) {
  187. $data['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id);
  188. } else {
  189. if (!empty($student_id)) {
  190. $user_id = intval($student_id);
  191. } else {
  192. $user_id = api_get_user_id();
  193. }
  194. $data['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id, $user_id);
  195. $data['faults'] = $attendance->get_faults_of_user($user_id, $attendance_id);
  196. $data['user_id'] = $user_id;
  197. }
  198. $data['next_attendance_calendar_id'] = $attendance->get_next_attendance_calendar_id($attendance_id);
  199. $data['next_attendance_calendar_datetime'] = $attendance->get_next_attendance_calendar_datetime($attendance_id);
  200. if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
  201. if (isset($_POST['hidden_input'])) {
  202. foreach ($_POST['hidden_input'] as $cal_id) {
  203. $users_present = array();
  204. if (isset($_POST['check_presence'][$cal_id])) {
  205. $users_present = $_POST['check_presence'][$cal_id];
  206. }
  207. $affected_rows = $attendance->attendance_sheet_add($cal_id,$users_present,$attendance_id);
  208. }
  209. }
  210. $data['users_in_course'] = $attendance->get_users_rel_course($attendance_id);
  211. $my_calendar_id = null;
  212. if (is_numeric($filter_type)) {
  213. $my_calendar_id = $filter_type;
  214. $filter_type = 'calendar_id';
  215. }
  216. $data['attendant_calendar'] = $attendance->get_attendance_calendar($attendance_id, $filter_type, $my_calendar_id);
  217. $data['attendant_calendar_all'] = $attendance->get_attendance_calendar($attendance_id);
  218. $data['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id);
  219. $data['next_attendance_calendar_id'] = $attendance->get_next_attendance_calendar_id($attendance_id);
  220. $data['next_attendance_calendar_datetime'] = $attendance->get_next_attendance_calendar_datetime($attendance_id);
  221. } else {
  222. $data['attendant_calendar_all'] = $attendance->get_attendance_calendar($attendance_id);
  223. $data['attendant_calendar'] = $attendance->get_attendance_calendar($attendance_id, $filter_type);
  224. }
  225. $data['is_locked_attendance'] = $attendance->is_locked_attendance($attendance_id);
  226. $this->view->set_data($data);
  227. $this->view->set_layout('layout');
  228. $this->view->set_template('attendance_sheet');
  229. $this->view->render();
  230. }
  231. /**
  232. * It's used for controlling attendace calendar (list, add, edit, delete),
  233. * render to attendance_calendar view
  234. * @param string action (optional, by default 'calendar_list')
  235. * @param int attendance id (optional)
  236. * @param int calendar id (optional)
  237. */
  238. public function attendance_calendar($action = 'calendar_list',$attendance_id = 0, $calendar_id = 0) {
  239. $attendance = new Attendance();
  240. $calendar_id = intval($calendar_id);
  241. $data = array();
  242. $data['attendance_id'] = $attendance_id;
  243. $attendance_id = intval($attendance_id);
  244. if ($action == 'calendar_add') {
  245. if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
  246. if (!isset($_POST['cancel'])) {
  247. if (isset($_POST['repeat'])) {
  248. error_log($attendance->build_datetime_from_array($_POST['date_time']));
  249. //$start_datetime = api_strtotime($attendance->build_datetime_from_array($_POST['date_time']));
  250. $start_datetime = api_strtotime(api_get_utc_datetime($attendance->build_datetime_from_array($_POST['date_time'])),'UTC');
  251. error_log('$start_datetime '.$start_datetime);
  252. $_POST['end_date_time']['H'] = $_POST['date_time']['H'];
  253. $_POST['end_date_time']['i'] = $_POST['date_time']['i'];
  254. error_log($attendance->build_datetime_from_array($_POST['end_date_time']));
  255. $end_datetime = api_strtotime(api_get_utc_datetime($attendance->build_datetime_from_array($_POST['end_date_time'])),'UTC');
  256. error_log('$end_datetime '.$end_datetime);
  257. $checkdate = checkdate($_POST['end_date_time']['F'], $_POST['end_date_time']['d'], $_POST['end_date_time']['Y']);
  258. $repeat_type = $_POST['repeat_type'];
  259. if (($end_datetime > $start_datetime) && $checkdate) {
  260. $affected_rows = $attendance->attendance_repeat_calendar_add($attendance_id, $start_datetime, $end_datetime, $repeat_type);
  261. $action = 'calendar_list';
  262. } else {
  263. if (!$checkdate) {
  264. $data['error_checkdate'] = true;
  265. } else {
  266. $data['error_repeat_date'] = true;
  267. }
  268. $data['repeat'] = true;
  269. $action = 'calendar_add';
  270. }
  271. } else {
  272. $datetime = $attendance->build_datetime_from_array($_POST['date_time']);
  273. $datetimezone = api_get_utc_datetime($datetime);
  274. if (!empty($datetime)) {
  275. $attendance->set_date_time($datetimezone);
  276. $affected_rows = $attendance->attendance_calendar_add($attendance_id);
  277. $action = 'calendar_list';
  278. } else {
  279. $data['error_date'] = true;
  280. $action = 'calendar_add';
  281. }
  282. }
  283. } else {
  284. $action = 'calendar_list';
  285. }
  286. }
  287. } else if ($action == 'calendar_edit') {
  288. $data['calendar_id'] = $calendar_id;
  289. if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
  290. if (!isset($_POST['cancel'])) {
  291. $datetime = $attendance->build_datetime_from_array($_POST['date_time']);
  292. $datetimezone = api_get_utc_datetime($datetime);
  293. $attendance->set_date_time($datetimezone);
  294. $affected_rows = $attendance->attendance_calendar_edit($calendar_id, $attendance_id);
  295. $data['calendar_id'] = 0;
  296. $action = 'calendar_list';
  297. } else {
  298. $action = 'calendar_list';
  299. }
  300. }
  301. } else if ($action == 'calendar_delete') {
  302. $affected_rows = $attendance->attendance_calendar_delete($calendar_id, $attendance_id);
  303. $action = 'calendar_list';
  304. } else if ($action == 'calendar_all_delete') {
  305. $affected_rows = $attendance->attendance_calendar_delete(0, $attendance_id, true);
  306. $action = 'calendar_list';
  307. }
  308. $data['action'] = $action;
  309. $data['attendance_calendar'] = $attendance->get_attendance_calendar($attendance_id);
  310. $data['is_locked_attendance'] = $attendance->is_locked_attendance($attendance_id);
  311. // render to the view
  312. $this->view->set_data($data);
  313. $this->view->set_layout('layout');
  314. $this->view->set_template('attendance_calendar');
  315. $this->view->render();
  316. }
  317. /**
  318. * It's used to print attendance sheet
  319. * @param string action
  320. * @param int attendance id
  321. */
  322. public function attendance_sheet_print($action, $attendance_id, $student_id = 0, $course_id = '') {
  323. $attendance = new Attendance();
  324. $courseInfo = CourseManager::get_course_information($course_id);
  325. $attendance->set_course_id($courseInfo['code']);
  326. $data_array = array();
  327. $data_array['attendance_id'] = $attendance_id;
  328. $data_array['users_in_course'] = $attendance->get_users_rel_course($attendance_id);
  329. $data_array['attendant_calendar'] = $attendance->get_attendance_calendar($attendance_id);
  330. if (api_is_allowed_to_edit(null, true) || api_is_drh()) {
  331. $data_array['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id);
  332. } else {
  333. if (!empty($student_id)) {
  334. $user_id = intval($student_id);
  335. } else {
  336. $user_id = api_get_user_id();
  337. }
  338. $data_array['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id, $user_id);
  339. $data_array['faults'] = $attendance->get_faults_of_user($user_id, $attendance_id);
  340. $data_array['user_id'] = $user_id;
  341. }
  342. $data_array['next_attendance_calendar_id'] = $attendance->get_next_attendance_calendar_id($attendance_id);
  343. // set headers pdf
  344. !empty($_user['official_code'])? $officialcode=$_user['official_code'].' - ':'';
  345. $courseCategory = CourseManager::get_course_category($courseInfo['category_code']);
  346. $teacherInfo = CourseManager::get_teacher_list_from_course_code($courseInfo['code']);
  347. $teacherName = null;
  348. foreach($teacherInfo as $dados) {
  349. if($teacherName != null)
  350. $teacherName = $teacherName . " / ";
  351. $teacherName.= $dados['firstname']." ".$dados['lastname'];
  352. }
  353. $h1 = array(get_lang('Category'), $courseCategory['name']);
  354. $h3 = array(get_lang("Title"), $courseInfo['title']);
  355. $h4 = array(get_lang('Teacher'), $teacherName);
  356. $h5 = array("", "");
  357. $date = date('d-m-Y H:i:s', time());
  358. $h6 = array(get_lang('DateTime'),api_convert_and_format_date($date, "%d/%m/%Y %H:%M"));
  359. $header_pdf = array($h4, $h1, $h5, $h5, $h6);
  360. // set footer pdf
  361. $f1 = '<hr />'.get_lang('Responsable');
  362. $f2 = '<hr />'.get_lang('Teacher');
  363. $f3 = '<hr />'.get_lang('Date');
  364. $footer_pdf = array($f1, $f2, $f3);
  365. // set title pdf
  366. $title_pdf = $h3[1];
  367. // set headers data table
  368. $head_ape_name = get_lang('Name');
  369. // get data table
  370. // Marco - ordenacao fixa - just fullname
  371. $data_table = array();
  372. $dataClass = array();
  373. $data_attendant_calendar = array();
  374. $data_users_presence = array();
  375. $data_attendant_calendar = $data_array['attendant_calendar'];
  376. $data_users_presence = $data_array['users_presence'];
  377. foreach ($data_array['users_in_course'] as $user) {
  378. $result = array();
  379. $user_info = api_get_user_info($user['id']);
  380. // $result['official_code'] = $user['official_code'];
  381. $result['fullname'] = $user['firstname']." ".$user['lastname'];
  382. foreach ($data_array['attendant_calendar'] as $class_day) {
  383. if($class_day['done_attendance'] == 1) {
  384. if($data_users_presence[$user['user_id']][$class_day['id']]['presence'] == 1)
  385. $result[$class_day['id']] = " . ";
  386. else
  387. $result[$class_day['id']] = " F ";
  388. } else {
  389. $result[$class_day['id']] = " \ ";
  390. }
  391. }
  392. $data_table[] = $result;
  393. }
  394. $head_table = array(
  395. array(get_lang('#'),5),
  396. // array(get_lang('langOfficialCode'),15),
  397. array(get_lang('Name'), 40),
  398. );
  399. foreach ($data_array['attendant_calendar'] as $class_day) {
  400. $dataClass[] = array($class_day['date'], 2);
  401. }
  402. $head_table = array_merge($head_table, $dataClass);
  403. // split page
  404. /*
  405. $array_nome = array();
  406. $array_p1 = array(); // page 1
  407. $array_p2 = array(); // page 2
  408. foreach ($data_table as $frequencia)
  409. {
  410. $array_nome[] = array_slice($frequencia, 0, 2, true);
  411. $array_p1[] = array_slice($frequencia, 2, 36, true);
  412. $array_p2[] = array_slice($frequencia, 38, count($frequencia), true);
  413. }
  414. $narray1 = array();
  415. $narray2 = array();
  416. for($i = 0; $i < count($array_nome); $i++)
  417. {
  418. $narray1[] = $array_nome[$i]+$array_p1[$i];
  419. $narray2[] = $array_nome[$i]+$array_p2[$i];
  420. }
  421. $data_table = array_merge($narray1, $narray2);
  422. unset($narray1); unset($narray2); unset($array_p1); unset($array_p2); unset($array_nome);
  423. $array_nome = array();
  424. $array_p1 = array();
  425. $array_p2 = array();
  426. foreach($head_table as $head)
  427. {
  428. $array_nome = array_slice($head_table, 0, 3, true);
  429. $array_p1 = array_slice($head_table, 3, 36, true);
  430. $array_p2 = array_slice($head_table, 39, count($head_table), true);
  431. }
  432. $array_p1 = array_merge($array_nome, $array_p1);
  433. $array_p2 = array_merge($array_nome, $array_p2);
  434. unset($head_table); $head_table = array();
  435. $head_table[] = $array_p1;
  436. $head_table[] = $array_p2;
  437. */
  438. //echo "<pre>"; print_r($head_table); echo "</pre>"; exit();
  439. export_pdf_attendance(&$head_table, &$data_table, &$header_pdf, $footer_pdf, $title_pdf);
  440. }
  441. }