. /** * Activity progress reports * * @package report * @subpackage progress * @copyright 2008 Sam Marshall * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ require('../../config.php'); require_once($CFG->libdir . '/completionlib.php'); define('COMPLETION_REPORT_PAGE', 50); // Get course $id = required_param('course',PARAM_INT); $course = $DB->get_record('course',array('id'=>$id)); if (!$course) { print_error('invalidcourseid'); } $context = context_course::instance($course->id); // Sort (default lastname, optionally firstname) $sort = optional_param('sort','',PARAM_ALPHA); $firstnamesort = $sort == 'firstname'; // CSV format $format = optional_param('format','',PARAM_ALPHA); $excel = $format == 'excelcsv'; $csv = $format == 'csv' || $excel; // Paging $start = optional_param('start', 0, PARAM_INT); $sifirst = optional_param('sifirst', 'all', PARAM_NOTAGS); $silast = optional_param('silast', 'all', PARAM_NOTAGS); $start = optional_param('start', 0, PARAM_INT); // Whether to show extra user identity information $extrafields = get_extra_user_fields($context); $leftcols = 1 + count($extrafields); function csv_quote($value) { global $excel; if ($excel) { return core_text::convert('"'.str_replace('"',"'",$value).'"','UTF-8','UTF-16LE'); } else { return '"'.str_replace('"',"'",$value).'"'; } } $url = new moodle_url('/report/progress/index.php', array('course'=>$id)); if ($sort !== '') { $url->param('sort', $sort); } if ($format !== '') { $url->param('format', $format); } if ($start !== 0) { $url->param('start', $start); } if ($sifirst !== 'all') { $url->param('sifirst', $sifirst); } if ($silast !== 'all') { $url->param('silast', $silast); } $PAGE->set_url($url); $PAGE->set_pagelayout('report'); require_login($course); // Check basic permission require_capability('report/progress:view',$context); // Get group mode $group = groups_get_course_group($course,true); // Supposed to verify group if ($group===0 && $course->groupmode==SEPARATEGROUPS) { require_capability('moodle/site:accessallgroups',$context); } // Get data on activities and progress of all users, and give error if we've // nothing to display (no users or no activities) $reportsurl = $CFG->wwwroot.'/course/report.php?id='.$course->id; $completion = new completion_info($course); $activities = $completion->get_activities(); if ($sifirst !== 'all') { set_user_preference('ifirst', $sifirst); } if ($silast !== 'all') { set_user_preference('ilast', $silast); } if (!empty($USER->preference['ifirst'])) { $sifirst = $USER->preference['ifirst']; } else { $sifirst = 'all'; } if (!empty($USER->preference['ilast'])) { $silast = $USER->preference['ilast']; } else { $silast = 'all'; } // Generate where clause $where = array(); $where_params = array(); if ($sifirst !== 'all') { $where[] = $DB->sql_like('u.firstname', ':sifirst', false); $where_params['sifirst'] = $sifirst.'%'; } if ($silast !== 'all') { $where[] = $DB->sql_like('u.lastname', ':silast', false); $where_params['silast'] = $silast.'%'; } // Get user match count $total = $completion->get_num_tracked_users(implode(' AND ', $where), $where_params, $group); // Total user count $grandtotal = $completion->get_num_tracked_users('', array(), $group); // Get user data $progress = array(); if ($total) { $progress = $completion->get_progress_all( implode(' AND ', $where), $where_params, $group, $firstnamesort ? 'u.firstname ASC, u.lastname ASC' : 'u.lastname ASC, u.firstname ASC', $csv ? 0 : COMPLETION_REPORT_PAGE, $csv ? 0 : $start, $context ); } if ($csv && $grandtotal && count($activities)>0) { // Only show CSV if there are some users/actvs $shortname = format_string($course->shortname, true, array('context' => $context)); header('Content-Disposition: attachment; filename=progress.'. preg_replace('/[^a-z0-9-]/','_',core_text::strtolower(strip_tags($shortname))).'.csv'); // Unicode byte-order mark for Excel if ($excel) { header('Content-Type: text/csv; charset=UTF-16LE'); print chr(0xFF).chr(0xFE); $sep="\t".chr(0); $line="\n".chr(0); } else { header('Content-Type: text/csv; charset=UTF-8'); $sep=","; $line="\n"; } } else { // Navigation and header $strreports = get_string("reports"); $strcompletion = get_string('activitycompletion', 'completion'); $PAGE->set_title($strcompletion); $PAGE->set_heading($course->fullname); echo $OUTPUT->header(); $PAGE->requires->js_call_amd('report_progress/completion_override', 'init', [fullname($USER)]); // Handle groups (if enabled) groups_print_course_menu($course,$CFG->wwwroot.'/report/progress/?course='.$course->id); } if (count($activities)==0) { echo $OUTPUT->container(get_string('err_noactivities', 'completion'), 'errorbox errorboxcontent'); echo $OUTPUT->footer(); exit; } // If no users in this course what-so-ever if (!$grandtotal) { echo $OUTPUT->container(get_string('err_nousers', 'completion'), 'errorbox errorboxcontent'); echo $OUTPUT->footer(); exit; } // Build link for paging $link = $CFG->wwwroot.'/report/progress/?course='.$course->id; if (strlen($sort)) { $link .= '&sort='.$sort; } $link .= '&start='; $pagingbar = ''; // Initials bar. $prefixfirst = 'sifirst'; $prefixlast = 'silast'; $pagingbar .= $OUTPUT->initials_bar($sifirst, 'firstinitial', get_string('firstname'), $prefixfirst, $url); $pagingbar .= $OUTPUT->initials_bar($silast, 'lastinitial', get_string('lastname'), $prefixlast, $url); // Do we need a paging bar? if ($total > COMPLETION_REPORT_PAGE) { // Paging bar $pagingbar .= '
'; $pagingbar .= get_string('page').': '; $sistrings = array(); if ($sifirst != 'all') { $sistrings[] = "sifirst={$sifirst}"; } if ($silast != 'all') { $sistrings[] = "silast={$silast}"; } $sistring = !empty($sistrings) ? '&'.implode('&', $sistrings) : ''; // Display previous link if ($start > 0) { $pstart = max($start - COMPLETION_REPORT_PAGE, 0); $pagingbar .= "(".get_string('previous').') '; } // Create page links $curstart = 0; $curpage = 0; while ($curstart < $total) { $curpage++; if ($curstart == $start) { $pagingbar .= ' '.$curpage.' '; } else { $pagingbar .= " $curpage "; } $curstart += COMPLETION_REPORT_PAGE; } // Display next link $nstart = $start + COMPLETION_REPORT_PAGE; if ($nstart < $total) { $pagingbar .= " (".get_string('next').')'; } $pagingbar .= '
'; } // Okay, let's draw the table of progress info, // Start of table if (!$csv) { // print '
'; // ugh print $pagingbar; if (!$total) { echo $OUTPUT->heading(get_string('nothingtodisplay')); echo $OUTPUT->footer(); exit; } print '
'; print ''; print '

Relatório de conclusão de atividades - '.$course->fullname.'


'; // User heading / sort option print ''; // Print user identity columns /* foreach ($extrafields as $field) { echo ''; }*/ } else { foreach ($extrafields as $field) { echo $sep . csv_quote(get_user_field_name($field)); } } // Activities $formattedactivities = array(); foreach($activities as $activity) { $datepassed = $activity->completionexpected && $activity->completionexpected <= time(); $datepassedclass = $datepassed ? 'completion-expired' : ''; if ($activity->completionexpected) { $datetext=userdate($activity->completionexpected,get_string('strftimedate','langconfig')); } else { $datetext=''; } // Some names (labels) come URL-encoded and can be very long, so shorten them $displayname = format_string($activity->name, true, array('context' => $activity->context)); if ($csv) { print $sep.csv_quote($displayname).$sep.csv_quote($datetext); } else { $shortenedname = shorten_text($displayname); print ''; } $formattedactivities[$activity->id] = (object)array( 'datepassedclass' => $datepassedclass, 'displayname' => $displayname, ); } if ($csv) { print $line; } else { print ''; } // Row for each user foreach($progress as $user) { // User name if ($csv) { print csv_quote(fullname($user)); foreach ($extrafields as $field) { echo $sep . csv_quote($user->{$field}); } } else { print ''; /* foreach ($extrafields as $field) { echo ''; }*/ } // Progress for each activity foreach($activities as $activity) { // Get progress information and state if (array_key_exists($activity->id, $user->progress)) { $thisprogress = $user->progress[$activity->id]; $state = $thisprogress->completionstate; $overrideby = $thisprogress->overrideby; $date = userdate($thisprogress->timemodified); } else { $state = COMPLETION_INCOMPLETE; $overrideby = 0; $date = ''; } // Work out how it corresponds to an icon switch($state) { case COMPLETION_INCOMPLETE : $completiontype = 'n'.($overrideby ? '-override' : ''); break; case COMPLETION_COMPLETE : $completiontype = 'y'.($overrideby ? '-override' : ''); break; case COMPLETION_COMPLETE_PASS : $completiontype = 'pass'; break; case COMPLETION_COMPLETE_FAIL : $completiontype = 'fail'; break; } $completiontrackingstring = $activity->completion == COMPLETION_TRACKING_AUTOMATIC ? 'auto' : 'manual'; $completionicon = 'completion-' . $completiontrackingstring. '-' . $completiontype; if ($overrideby) { $overridebyuser = \core_user::get_user($overrideby, '*', MUST_EXIST); $describe = get_string('completion-' . $completiontype, 'completion', fullname($overridebyuser)); } else { $describe = get_string('completion-' . $completiontype, 'completion'); } $a=new StdClass; $a->state=$describe; $a->date=$date; $a->user=fullname($user); $a->activity = $formattedactivities[$activity->id]->displayname; $fulldescribe=get_string('progress-title','completion',$a); if ($csv) { print $sep.csv_quote($describe).$sep.csv_quote($date); } else { $celltext = $OUTPUT->pix_icon('i/' . $completionicon, s($fulldescribe)); if (has_capability('moodle/course:overridecompletion', $context) && $state != COMPLETION_COMPLETE_PASS && $state != COMPLETION_COMPLETE_FAIL) { $newstate = ($state == COMPLETION_COMPLETE) ? COMPLETION_INCOMPLETE : COMPLETION_COMPLETE; $changecompl = $user->id . '-' . $activity->id . '-' . $newstate; $url = new moodle_url($PAGE->url, ['sesskey' => sesskey()]); $celltext = html_writer::link($url, $celltext, array('class' => 'changecompl', 'data-changecompl' => $changecompl, 'data-activityname' => $a->activity, 'data-userfullname' => $a->user, 'data-completiontracking' => $completiontrackingstring, 'aria-role' => 'button')); } print ''; } } if ($csv) { print $line; } else { print ''; } } if ($csv) { exit; } print '
'; $sistring = "&silast={$silast}&sifirst={$sifirst}"; if ($firstnamesort) { print get_string('firstname')." / id}{$sistring}\">". get_string('lastname').''; } else { print "id}&sort=firstname{$sistring}\">". get_string('firstname').' / '. get_string('lastname'); } print '' . get_user_field_name($field) . ''. ''. '
'.$shortenedname.'
'. '
'. // $OUTPUT->image_icon('icon', get_string('modulename', $activity->modname), $activity->modname) . '
'. '
'; if ($activity->completionexpected) { print '
'.$datetext.'
'; } print '
'.fullname($user).'' . s($user->{$field}). ''. $celltext . '
'; print '
'; print $pagingbar; print ' '; echo $OUTPUT->footer();