123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337 |
- <?php // $Id: $
- /* For licensing terms, see /license.txt */
- $language_file = 'gradebook';
- //$cidReset= true;
- require_once '../inc/global.inc.php';
- require_once 'lib/be.inc.php';
- require_once 'lib/gradebook_functions.inc.php';
- require_once 'lib/fe/dataform.class.php';
- require_once 'lib/fe/userform.class.php';
- require_once 'lib/flatview_data_generator.class.php';
- require_once 'lib/fe/flatviewtable.class.php';
- require_once 'lib/fe/displaygradebook.php';
- require_once 'lib/fe/exportgradebook.php';
- require_once 'lib/scoredisplay.class.php';
- //require_once api_get_path(LIBRARY_PATH).'ezpdf/class.ezpdf.php'; // This is the old library for pdf-export (non UTF-8 compatible).
- define('_MPDF_PATH', api_get_path(LIBRARY_PATH).'mpdf/');
- require_once _MPDF_PATH.'mpdf.php';
- if (!class_exists('HTML_Table')) { require_once api_get_path(LIBRARY_PATH).'pear/HTML/Table.php'; }
- api_block_anonymous_users();
- block_students();
- if (isset ($_POST['submit']) && isset ($_POST['keyword'])) {
- header('Location: '.api_get_self().'?selectcat='.Security::remove_XSS($_GET['selectcat']).'&search='.Security::remove_XSS($_POST['keyword']));
- exit;
- }
- $htmlHeadXtra[] = '<script src="../inc/lib/javascript/jquery.js" type="text/javascript" language="javascript"></script>'; //jQuery
- $interbreadcrumb[] = array (
- 'url' => $_SESSION['gradebook_dest'],
- 'name' => get_lang('Gradebook')
- );
- $showeval = isset($_POST['showeval']) ? '1' : '0';
- $showlink = isset($_POST['showlink']) ? '1' : '0';
- if (($showlink == '0') && ($showeval == '0')) {
- $showlink = '1';
- $showeval = '1';
- }
- $cat = Category::load($_REQUEST['selectcat']);
- if (isset($_GET['userid'])) {
- $userid = Security::remove_XSS($_GET['userid']);
- } else {
- $userid = '';
- }
- if ($showeval) {
- $alleval = $cat[0]->get_evaluations($userid, true);
- } else {
- $alleval = null;
- }
- if ($showlink) {
- $alllinks = $cat[0]->get_links($userid, true);
- } else {
- $alllinks = null;
- }
- if (isset($export_flatview_form) && (!$file_type == 'pdf')) {
- Display :: display_normal_message($export_flatview_form->toHtml(), false);
- }
- if (isset($_GET['selectcat'])) {
- $category_id = Security::remove_XSS($_GET['selectcat']);
- } else {
- $category_id = '';
- }
- $simple_search_form = new UserForm(UserForm :: TYPE_SIMPLE_SEARCH, null, 'simple_search_form', null, api_get_self() . '?selectcat=' . $category_id);
- $values = $simple_search_form->exportValues();
- $keyword = '';
- if (isset($_GET['search']) && !empty($_GET['search'])) {
- $keyword = Security::remove_XSS($_GET['search']);
- }
- if ($simple_search_form->validate() && (empty($keyword))) {
- $keyword = $values['keyword'];
- }
- if (!empty($keyword)) {
- $users = find_students($keyword);
- } else {
- if (isset($alleval) && isset($alllinks)) {
- $users = get_all_users($alleval, $alllinks);
- } else {
- $users = null;
- }
- }
- if (isset ($_GET['exportpdf'])) {
- $interbreadcrumb[] = array (
- 'url' => api_get_self().'?selectcat=' . Security::remove_XSS($_GET['selectcat']),
- 'name' => get_lang('FlatView')
- );
- $export_pdf_form = new DataForm(DataForm :: TYPE_EXPORT_PDF, 'export_pdf_form', null, api_get_self().'?exportpdf=&offset='.$_GET['offset'].'&selectcat='.$_GET['selectcat'], '_blank');
- if ($export_pdf_form->validate()) {
- // Beginning of PDF report creation
- $printable_data = get_printable_data($users, $alleval, $alllinks);
- $export = $export_pdf_form->exportValues();
- // Reading report's CSS
- //$css_file = api_get_path(TO_SYS, WEB_CSS_PATH).api_get_setting('stylesheets').'/print.css';
- $css_file = api_get_path(SYS_CODE_PATH).'gradebook/print.css';
- $css = file_exists($css_file) ? @file_get_contents($css_file) : '';
- // HTML report creation first
- $time = time();
- $cat_name = trim($cat[0]->get_name());
- $course_code = trim($cat[0]->get_course_code());
- $report_name = $course_code;
- if (!empty($cat_name) && $report_name != $cat_name) {
- $report_name .= ' - '.$cat_name;
- }
- $organization = api_get_setting('Institution');
- $creator = api_get_person_name($GLOBALS['_user']['firstName'], $GLOBALS['_user']['lastName']);
- $html = '';
- if (!empty($organization)) {
- $html .= '<h2 align="center">'.$organization.'</h2>';
- }
- $html .= '<h1 align="center">'.get_lang('FlatView').'</h1>';
- $html .= '<p><strong>'.$report_name.'</strong></p>';
- $html .= '<p><strong>'.api_format_date(DATE_TIME_FORMAT_LONG, $time).'</strong></p>';
- $html .= '<p><strong>'.get_lang('By').': '.$creator.'</strong></p>';
- $columns = count($printable_data[0]);
- $has_data = is_array($printable_data[1]) && count($printable_data[1]) > 0;
- if (api_is_western_name_order()) {
- // Choosing the right person name order according to the current language.
- list($printable_data[0][0], $printable_data[0][1]) = array($printable_data[0][1], $printable_data[0][0]);
- if ($has_data) {
- foreach ($printable_data[1] as &$printable_data_row) {
- list($printable_data_row[0], $printable_data_row[1]) = array($printable_data_row[1], $printable_data_row[0]);
- }
- }
- }
- $table = new HTML_Table(array('class' => 'data_table'));
- $row = 0;
- $column = 0;
- foreach ($printable_data[0] as $printable_data_cell) {
- $table->setHeaderContents($row, $column, $printable_data_cell);
- $column++;
- }
- $row++;
- if ($has_data) {
- foreach ($printable_data[1] as &$printable_data_row) {
- $column = 0;
- foreach ($printable_data_row as &$printable_data_cell) {
- $table->setCellContents($row, $column, $printable_data_cell);
- $table->updateCellAttributes($row, $column, 'align="center"');
- $column++;
- }
- $table->updateRowAttributes($row, $row % 2 ? 'class="row_even"' : 'class="row_odd"', true);
- $row++;
- }
- } else {
- $column = 0;
- $table->setCellContents($row, $column, get_lang('NoResults'));
- $table->updateCellAttributes($row, $column, 'colspan="'.$columns.'" align="center" class="row_odd"');
- }
- $html .= $table->toHtml();
- $html .= '<pagefooter name="myFooter1" content-left="My Book Title" content-center="myFooter1" content-right="{PAGENO}" footer-style="font-family:sans-serif; font-size:8pt; font-weight:bold; color:#008800;" footer-style-left="" line="on" />';
- // Memory release
- unset($printable_data);
- unset($table);
- // Conversion of the created HTML report to a PDF report
- $html = api_utf8_encode($html);
- $creator_pdf = api_utf8_encode($creator);
- $title_pdf = api_utf8_encode($report_name);
- $subject_pdf = api_utf8_encode(get_lang('FlatView'));
- $keywods_pdf = api_utf8_encode($course_code);
- $pdf = new mPDF('UTF-8', 'A4', '', '', 32, 25, 27, 25, 16, 13, $export['orientation']);
- $pdf->directionality = api_get_text_direction();
- $pdf->useOnlyCoreFonts = true;
- $pdf->SetFooter('{PAGENO}');
- $pdf->SetAuthor($creator_pdf);
- $pdf->SetTitle($title_pdf);
- $pdf->SetSubject($subject_pdf);
- $pdf->SetKeywords($keywods_pdf);
- if (!empty($css)) {
- $pdf->WriteHTML($css, 1);
- $pdf->WriteHTML($html, 2);
- } else {
- $pdf->WriteHTML($html);
- }
- // Sending the created PDF report to the client
- $file_name = date('YmdHi_', $time);
- if (!empty($course_code)) {
- $file_name .= $course_code.'_';
- }
- $file_name .= get_lang('FlatView').'.pdf';
- $file_name = replace_dangerous_char($file_name);
- $pdf->Output($file_name, 'D');
- /*
- // This is the old pdf-exporting routine that uses ezpdf library.
- //
- $format = $export['orientation']; //format is 'portrait' or 'landscape'
- $pdf =& new Cezpdf('a4',$format); //format is 'portrait' or 'landscape'
- $clear_printable_data=array();
- $clear_send_printable_data=array();
- //var_dump(count($printable_data[1]));
- for ($i=0;$i<count($printable_data[1]);$i++) {
- for ($k=0;$k<count($printable_data[1][$i]);$k++) {
- $clear_printable_data[]=strip_tags($printable_data[1][$i][$k]);
- }
- $clear_send_printable_data[]=$clear_printable_data;
- $clear_printable_data=array();
- }
- export_pdf($pdf,$clear_send_printable_data,$printable_data[0],$format);
- */
- exit;
- } else {
- Display :: display_header(get_lang('ExportPDF'));
- }
- }
- if (isset ($_GET['print'])) {
- $printable_data = get_printable_data ($users,$alleval, $alllinks);
- echo print_table($printable_data[1],$printable_data[0], get_lang('FlatView'), $cat[0]->get_name());
- exit;
- }
- if (!empty($_POST['export_report']) && $_POST['export_report'] == 'export_report') {
- if (api_is_platform_admin() || api_is_course_admin() || api_is_course_coach()) {
- $user_id = null;
- if (empty($_SESSION['export_user_fields'])) {
- $_SESSION['export_user_fields'] = false;
- }
- if (!api_is_allowed_to_edit(false, false) and !api_is_course_tutor()) {
- $user_id = api_get_user_id();
- }
- require_once 'gradebook_result.class.php';
- $printable_data = get_printable_data($users, $alleval, $alllinks);
- switch($_POST['export_format']) {
- case 'xls':
- $export = new GradeBookResult();
- $export->exportCompleteReportXLS($printable_data);
- exit;
- break;
- case 'csv':
- default:
- $export = new GradeBookResult();
- $export->exportCompleteReportCSV($printable_data);
- exit;
- break;
- }
- } else {
- api_not_allowed(true);
- }
- }
- $addparams = array ('selectcat' => $cat[0]->get_id());
- if (isset($_GET['search'])) {
- $addparams['search'] = $keyword;
- }
- $offset = isset($_GET['offset']) ? $_GET['offset'] : '0';
- $flatviewtable = new FlatViewTable($cat[0], $users, $alleval, $alllinks, true, $offset, $addparams);
- if (isset($_GET['exportpdf'])) {
- echo '<div class="normal-message">';
- $export_pdf_form->display();
- echo '</div>';
- } else {
- Display :: display_header(get_lang('FlatView'));
- }
- if (isset($_GET['isStudentView']) && $_GET['isStudentView'] == 'false') {
- DisplayGradebook :: display_header_reduce_flatview($cat[0], $showeval, $showlink, $simple_search_form);
- $flatviewtable->display();
- } elseif (isset($_GET['selectcat']) && ($_SESSION['studentview'] == 'teacherview')) {
- DisplayGradebook :: display_header_reduce_flatview($cat[0], $showeval, $showlink, $simple_search_form);
- /*echo '<div id="contentLoading" class="contentLoading">';
- echo Display::display_icon('loader.gif');
- echo '</div>';*/
- // main graph
- //@todo load images with jquery
- echo '<div id="contentArea" style="text-align:center;" >';
- $image_file = $flatviewtable->display_graph();
- $my_info_path_img = array();
- $my_info_path_img = explode('/', $image_file);
- if (strlen($my_info_path_img[5]) == 32) {
- echo '<img src="'.$image_file.'">';
- }
- $flatviewtable->display();
- $flatviewtable->display_graph_by_resource();
- echo '</div>';
- }
- Display :: display_footer();
- function get_printable_data($users,$alleval, $alllinks) {
- $datagen = new FlatViewDataGenerator ($users, $alleval, $alllinks);
- $offset = isset($_GET['offset']) ? $_GET['offset'] : '0';
- $count = (($offset + 10) > $datagen->get_total_items_count()) ? ($datagen->get_total_items_count() - $offset) : 10;
- $header_names = $datagen->get_header_names($offset, $count);
- $data_array = $datagen->get_data(FlatViewDataGenerator :: FVDG_SORT_LASTNAME, 0, null, $offset, $count, true);
- $newarray = array();
- foreach ($data_array as $data) {
- $newarray[] = array_slice($data, 1);
- }
- return array ($header_names, $newarray);
- }
|