123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529 |
- <?php
- /* For licensing terms, see /license.txt */
- /**
- * This file contains class used like controller, it should be included inside a dispatcher file (e.g: index.php)
- *
- * !!! WARNING !!! : ALL DATES IN THIS MODULE ARE STORED IN UTC ! DO NOT CONVERT DURING THE TRANSITION FROM CHAMILO 1.8.x TO 2.0
- *
- * @author Christian Fasanando <christian1827@gmail.com>
- * @author Julio Montoya <gugli100@gmail.com> lot of bugfixes + improvements
- * @package chamilo.attendance
- */
- /**
- * Controller script. Prepares the common background variables to give to the scripts corresponding to
- * the requested action
- * @package chamilo.attendance
- */
-
- class AttendanceController
- {
-
- /**
- * Constructor
- */
- public function __construct() {
- $this->toolname = 'attendance';
- $this->view = new View($this->toolname);
- }
-
- /**
- * It's used for listing attendace,
- * render to attendance_list view
- * @param boolean true for listing history (optional)
- * @param array message for showing by action['edit','add','delete'] (optional)
- */
- public function attendance_list($history=false,$messages=array()) {
-
- $attendance = new Attendance();
- $data = array();
-
- // render to the view
- $this->view->set_data($data);
- $this->view->set_layout('layout');
- $this->view->set_template('attendance_list');
- $this->view->render();
- }
-
- /**
- * It's used for adding attendace,
- * render to attendance_add or attendance_list view
- */
- public function attendance_add() {
-
- $attendance = new Attendance();
- $data = array();
- if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
-
- if (!empty($_POST['title'])) {
- $check = Security::check_token();
- if ($check) {
- $attendance->set_name($_POST['title']);
- $attendance->set_description($_POST['description']);
- $attendance->set_attendance_qualify_title($_POST['attendance_qualify_title']);
- $attendance->set_attendance_weight($_POST['attendance_weight']);
- $link_to_gradebook = false;
- if ( isset($_POST['attendance_qualify_gradebook']) && $_POST['attendance_qualify_gradebook'] == 1 ) {
- $link_to_gradebook = true;
- }
- $last_id = $attendance->attendance_add($link_to_gradebook);
- Security::clear_token();
- }
- $param_gradebook = '';
- if (isset($_SESSION['gradebook'])) {
- $param_gradebook = '&gradebook='.Security::remove_XSS($_SESSION['gradebook']);
- }
- header('location:index.php?action=attendance_sheet_list&attendance_id='.$last_id.'&'.api_get_cidreq().$param_gradebook);
- exit;
- } else {
- $data['error'] = true;
- $this->view->set_data($data);
- $this->view->set_layout('layout');
- $this->view->set_template('attendance_add');
- $this->view->render();
- }
- } else {
- $this->view->set_data($data);
- $this->view->set_layout('layout');
- $this->view->set_template('attendance_add');
- $this->view->render();
- }
- }
-
- /**
- * It's used for editing attendace,
- * render to attendance_edit or attendance_list view
- * @param int attendance id
- */
- public function attendance_edit($attendance_id) {
- $attendance = new Attendance();
- $data = array();
- $attendance_id = intval($attendance_id);
-
- if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
-
- if (!empty($_POST['title'])) {
- $check = Security::check_token();
- if ($check) {
- $attendance->set_name($_POST['title']);
- $attendance->set_description($_POST['description']);
- $attendance->set_attendance_qualify_title($_POST['attendance_qualify_title']);
- $attendance->set_attendance_weight($_POST['attendance_weight']);
-
- $link_to_gradebook = false;
- if ( isset($_POST['attendance_qualify_gradebook']) && $_POST['attendance_qualify_gradebook'] == 1 ) {
- $link_to_gradebook = true;
- }
- $last_id = $attendance->attendance_edit($attendance_id,$link_to_gradebook);
- Security::clear_token();
-
- $param_gradebook = '';
- if (isset($_SESSION['gradebook'])) {
- $param_gradebook = '&gradebook='.Security::remove_XSS($_SESSION['gradebook']);
- }
- header('location:index.php?action=attendance_list&'.api_get_cidreq().$param_gradebook);
- exit;
- }
- } else {
- $data['attendance_id'] = $_POST['attendance_id'];
- $data['error'] = true;
- $this->view->set_data($data);
- $this->view->set_layout('layout');
- $this->view->set_template('attendance_edit');
- $this->view->render();
- }
-
-
- } else {
-
- // default values
- $attendance_data = $attendance->get_attendance_by_id($attendance_id);
- $data['attendance_id'] = $attendance_data['id'];
- $data['title'] = $attendance_data['name'];
- $data['description'] = $attendance_data['description'];
- $data['attendance_qualify_title'] = $attendance_data['attendance_qualify_title'];
- $data['attendance_weight'] = $attendance_data['attendance_weight'];
- $this->view->set_data($data);
- $this->view->set_layout('layout');
- $this->view->set_template('attendance_edit');
- $this->view->render();
-
- }
- }
-
- /**
- * It's used for delete attendaces
- * render to attendance_list view
- * @param int attendance id
- */
- public function attendance_delete($attendance_id) {
- $attendance = new Attendance();
- //$attendance_id = intval($attendance_id);
- if (!empty($attendance_id)) {
- $affected_rows = $attendance->attendance_delete($attendance_id);
- }
- if ($affected_rows) {
- $message['message_attendance_delete'] = true;
- }
- $this->attendance_list();
- }
- /**
- * Restores an attendance entry and fallback to attendances rendering
- * @param int attendance id
- */
- public function attendance_restore($attendance_id) {
- $attendance = new Attendance();
- //$attendance_id = intval($attendance_id);
- if (!empty($attendance_id)) {
- $affected_rows = $attendance->attendance_restore($attendance_id);
- }
- if ($affected_rows) {
- $message['message_attendance_restore'] = true;
- }
- $this->attendance_list();
- }
- /**
- * Lock or unlock an attendance
- * render to attendance_list view
- * @param string action (lock_attendance or unlock_attendance)
- * @param int attendance id
- * render to attendance_list view
- */
- public function lock_attendance($action, $attendance_id) {
- $attendance = new Attendance();
- $attendance_id = intval($attendance_id);
- if ($action == 'lock_attendance') {
- $result = $attendance->lock_attendance($attendance_id);
- } else {
- $result = $attendance->lock_attendance($attendance_id, false);
- }
- if ($result) {
- $message['message_locked_attendance'] = true;
- }
- $this->attendance_list();
- }
- /**
- * It's used for controlling attendace sheet (list, add),
- * render to attendance_sheet view
- * @param string action
- * @param int attendance id
- */
- public function attendance_sheet($action, $attendance_id, $student_id = 0) {
- $attendance = new Attendance();
- $data = array();
- $data['attendance_id'] = $attendance_id;
- $data['users_in_course'] = $attendance->get_users_rel_course($attendance_id);
-
- $filter_type = 'all';
- if (!empty($_REQUEST['filter'])) {
- $filter_type = $_REQUEST['filter'];
- }
- if (api_is_allowed_to_edit(null, true)) {
- $data['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id);
- } else {
- if (!empty($student_id)) {
- $user_id = intval($student_id);
- } else {
- $user_id = api_get_user_id();
- }
- $data['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id, $user_id);
- $data['faults'] = $attendance->get_faults_of_user($user_id, $attendance_id);
-
- $data['user_id'] = $user_id;
- }
-
- $data['next_attendance_calendar_id'] = $attendance->get_next_attendance_calendar_id($attendance_id);
- $data['next_attendance_calendar_datetime'] = $attendance->get_next_attendance_calendar_datetime($attendance_id);
-
- if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
- if (isset($_POST['hidden_input'])) {
- foreach ($_POST['hidden_input'] as $cal_id) {
- $users_present = array();
- if (isset($_POST['check_presence'][$cal_id])) {
- $users_present = $_POST['check_presence'][$cal_id];
- }
- $affected_rows = $attendance->attendance_sheet_add($cal_id,$users_present,$attendance_id);
- }
- }
- $data['users_in_course'] = $attendance->get_users_rel_course($attendance_id);
- $my_calendar_id = null;
-
- if (is_numeric($filter_type)) {
- $my_calendar_id = $filter_type;
- $filter_type = 'calendar_id';
- }
- $data['attendant_calendar'] = $attendance->get_attendance_calendar($attendance_id, $filter_type, $my_calendar_id);
- $data['attendant_calendar_all'] = $attendance->get_attendance_calendar($attendance_id);
- $data['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id);
- $data['next_attendance_calendar_id'] = $attendance->get_next_attendance_calendar_id($attendance_id);
- $data['next_attendance_calendar_datetime'] = $attendance->get_next_attendance_calendar_datetime($attendance_id);
- } else {
- $data['attendant_calendar_all'] = $attendance->get_attendance_calendar($attendance_id);
- $data['attendant_calendar'] = $attendance->get_attendance_calendar($attendance_id, $filter_type);
- }
- $data['is_locked_attendance'] = $attendance->is_locked_attendance($attendance_id);
- $this->view->set_data($data);
- $this->view->set_layout('layout');
- $this->view->set_template('attendance_sheet');
- $this->view->render();
- }
- /**
- * It's used for controlling attendace calendar (list, add, edit, delete),
- * render to attendance_calendar view
- * @param string action (optional, by default 'calendar_list')
- * @param int attendance id (optional)
- * @param int calendar id (optional)
- */
- public function attendance_calendar($action = 'calendar_list',$attendance_id = 0, $calendar_id = 0) {
- $attendance = new Attendance();
- $calendar_id = intval($calendar_id);
- $data = array();
- $data['attendance_id'] = $attendance_id;
- $attendance_id = intval($attendance_id);
- if ($action == 'calendar_add') {
- if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
- if (!isset($_POST['cancel'])) {
- if (isset($_POST['repeat'])) {
- //@todo check this error_logs
- $start_datetime = api_strtotime(api_get_utc_datetime($attendance->build_datetime_from_array($_POST['date_time'])),'UTC');
- //error_log('$start_datetime '.$start_datetime);
-
- $_POST['end_date_time']['H'] = $_POST['date_time']['H'];
- $_POST['end_date_time']['i'] = $_POST['date_time']['i'];
- //error_log($attendance->build_datetime_from_array($_POST['end_date_time']));
-
- $end_datetime = api_strtotime(api_get_utc_datetime($attendance->build_datetime_from_array($_POST['end_date_time'])),'UTC');
- //error_log('$end_datetime '.$end_datetime);
- $checkdate = checkdate($_POST['end_date_time']['F'], $_POST['end_date_time']['d'], $_POST['end_date_time']['Y']);
- $repeat_type = $_POST['repeat_type'];
- if (($end_datetime > $start_datetime) && $checkdate) {
- $affected_rows = $attendance->attendance_repeat_calendar_add($attendance_id, $start_datetime, $end_datetime, $repeat_type);
- $action = 'calendar_list';
- } else {
- if (!$checkdate) {
- $data['error_checkdate'] = true;
- } else {
- $data['error_repeat_date'] = true;
- }
- $data['repeat'] = true;
- $action = 'calendar_add';
- }
- } else {
- $datetime = $attendance->build_datetime_from_array($_POST['date_time']);
- $datetimezone = api_get_utc_datetime($datetime);
- if (!empty($datetime)) {
- $attendance->set_date_time($datetimezone);
- $affected_rows = $attendance->attendance_calendar_add($attendance_id);
- $action = 'calendar_list';
- } else {
- $data['error_date'] = true;
- $action = 'calendar_add';
- }
- }
- } else {
- $action = 'calendar_list';
- }
- }
- } else if ($action == 'calendar_edit') {
- $data['calendar_id'] = $calendar_id;
- if (strtoupper($_SERVER['REQUEST_METHOD']) == "POST") {
- if (!isset($_POST['cancel'])) {
- $datetime = $attendance->build_datetime_from_array($_POST['date_time']);
- $datetimezone = api_get_utc_datetime($datetime);
- $attendance->set_date_time($datetimezone);
- $affected_rows = $attendance->attendance_calendar_edit($calendar_id, $attendance_id);
- $data['calendar_id'] = 0;
- $action = 'calendar_list';
- } else {
- $action = 'calendar_list';
- }
- }
- } else if ($action == 'calendar_delete') {
- $affected_rows = $attendance->attendance_calendar_delete($calendar_id, $attendance_id);
- $action = 'calendar_list';
- } else if ($action == 'calendar_all_delete') {
- $affected_rows = $attendance->attendance_calendar_delete(0, $attendance_id, true);
- $action = 'calendar_list';
- }
- $data['action'] = $action;
- $data['attendance_calendar'] = $attendance->get_attendance_calendar($attendance_id);
- $data['is_locked_attendance'] = $attendance->is_locked_attendance($attendance_id);
- // render to the view
- $this->view->set_data($data);
- $this->view->set_layout('layout');
- $this->view->set_template('attendance_calendar');
- $this->view->render();
- }
-
- /**
- * It's used to print attendance sheet
- * @param string action
- * @param int attendance id
- */
- public function attendance_sheet_print($action, $attendance_id, $student_id = 0, $course_id = '') {
- $attendance = new Attendance();
- $courseInfo = CourseManager::get_course_information($course_id);
- $attendance->set_course_id($courseInfo['code']);
- $data_array = array();
- $data_array['attendance_id'] = $attendance_id;
- $data_array['users_in_course'] = $attendance->get_users_rel_course($attendance_id);
-
- $data_array['attendant_calendar'] = $attendance->get_attendance_calendar($attendance_id);
- if (api_is_allowed_to_edit(null, true) || api_is_drh()) {
- $data_array['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id);
- } else {
- if (!empty($student_id)) {
- $user_id = intval($student_id);
- } else {
- $user_id = api_get_user_id();
- }
- $data_array['users_presence'] = $attendance->get_users_attendance_sheet($attendance_id, $user_id);
- $data_array['faults'] = $attendance->get_faults_of_user($user_id, $attendance_id);
- $data_array['user_id'] = $user_id;
- }
- $data_array['next_attendance_calendar_id'] = $attendance->get_next_attendance_calendar_id($attendance_id);
- // set headers pdf
- !empty($_user['official_code'])? $officialcode=$_user['official_code'].' - ':'';
- $courseCategory = CourseManager::get_course_category($courseInfo['category_code']);
- $teacherInfo = CourseManager::get_teacher_list_from_course_code($courseInfo['code']);
- $teacherName = null;
- foreach($teacherInfo as $dados) {
- if($teacherName != null)
- $teacherName = $teacherName . " / ";
- $teacherName.= $dados['firstname']." ".$dados['lastname'];
- }
- $h1 = array(get_lang('Category'), $courseCategory['name']);
- $h3 = array(get_lang("Title"), $courseInfo['title']);
- $h4 = array(get_lang('Teacher'), $teacherName);
- $h5 = array("", "");
- $date = date('d-m-Y H:i:s', time());
- $h6 = array(get_lang('DateTime'),api_convert_and_format_date($date, "%d/%m/%Y %H:%M"));
- $header_pdf = array($h4, $h1, $h5, $h5, $h6);
- // set footer pdf
- $f1 = '<hr />'.get_lang('Responsable');
- $f2 = '<hr />'.get_lang('Teacher');
- $f3 = '<hr />'.get_lang('Date');
- $footer_pdf = array($f1, $f2, $f3);
- // set title pdf
- $title_pdf = $h3[1];
- // set headers data table
- $head_ape_name = get_lang('Name');
- // get data table
- // Marco - ordenacao fixa - just fullname
- $data_table = array();
- $dataClass = array();
- $data_attendant_calendar = array();
- $data_users_presence = array();
- $data_attendant_calendar = $data_array['attendant_calendar'];
- $data_users_presence = $data_array['users_presence'];
- foreach ($data_array['users_in_course'] as $user) {
- $result = array();
- $user_info = api_get_user_info($user['id']);
- // $result['official_code'] = $user['official_code'];
- $result['fullname'] = $user['firstname']." ".$user['lastname'];
- foreach ($data_array['attendant_calendar'] as $class_day) {
- if($class_day['done_attendance'] == 1) {
- if($data_users_presence[$user['user_id']][$class_day['id']]['presence'] == 1)
- $result[$class_day['id']] = " . ";
- else
- $result[$class_day['id']] = " F ";
- } else {
- $result[$class_day['id']] = " \ ";
- }
- }
- $data_table[] = $result;
- }
- $head_table = array(
- array(get_lang('#'),5),
- // array(get_lang('langOfficialCode'),15),
- array(get_lang('Name'), 40),
- );
- foreach ($data_array['attendant_calendar'] as $class_day) {
- $dataClass[] = array($class_day['date'], 2);
- }
- $head_table = array_merge($head_table, $dataClass);
- // split page
- /*
- $array_nome = array();
- $array_p1 = array(); // page 1
- $array_p2 = array(); // page 2
- foreach ($data_table as $frequencia)
- {
- $array_nome[] = array_slice($frequencia, 0, 2, true);
- $array_p1[] = array_slice($frequencia, 2, 36, true);
- $array_p2[] = array_slice($frequencia, 38, count($frequencia), true);
- }
- $narray1 = array();
- $narray2 = array();
- for($i = 0; $i < count($array_nome); $i++)
- {
- $narray1[] = $array_nome[$i]+$array_p1[$i];
- $narray2[] = $array_nome[$i]+$array_p2[$i];
- }
- $data_table = array_merge($narray1, $narray2);
-
- unset($narray1); unset($narray2); unset($array_p1); unset($array_p2); unset($array_nome);
- $array_nome = array();
- $array_p1 = array();
- $array_p2 = array();
- foreach($head_table as $head)
- {
- $array_nome = array_slice($head_table, 0, 3, true);
- $array_p1 = array_slice($head_table, 3, 36, true);
- $array_p2 = array_slice($head_table, 39, count($head_table), true);
- }
- $array_p1 = array_merge($array_nome, $array_p1);
- $array_p2 = array_merge($array_nome, $array_p2);
- unset($head_table); $head_table = array();
- $head_table[] = $array_p1;
- $head_table[] = $array_p2;
- */
- //echo "<pre>"; print_r($head_table); echo "</pre>"; exit();
- export_pdf_attendance(&$head_table, &$data_table, &$header_pdf, $footer_pdf, $title_pdf);
- }
- }
|