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