123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595 |
- <?php
- /* For licensing terms, see license.txt */
- /**
- * Script
- * @package chamilo.gradebook
- */
- /**
- * Init
- */
- require_once dirname(__FILE__).'/../../../inc/global.inc.php';
- require_once dirname(__FILE__).'/../be.inc.php';
- /**
- * Table to display categories, evaluations and links
- * @author Stijn Konings
- * @author Bert Steppé (refactored, optimised)
- * @package chamilo.gradebook
- */
- class GradebookTable extends SortableTable {
- private $currentcat;
- private $datagen;
- private $evals_links;
- public $cats;
- /**
- * Constructor
- */
- function GradebookTable ($currentcat, $cats = array(), $evals = array(), $links = array(), $addparams = null) {
- //$status = CourseManager::get_user_in_course_status(api_get_user_id(), api_get_course_id());
- parent :: __construct ('gradebooklist', null, null, (api_is_allowed_to_edit()?1:0));
- $this->evals_links = array_merge($evals, $links);
- $this->currentcat = $currentcat;
- $this->cats = $cats;
- $this->datagen = new GradebookDataGenerator($cats, $evals, $links);
- if (isset($addparams)) {
- $this->set_additional_parameters($addparams);
- }
- $column= 0;
- if (api_is_allowed_to_edit(null, true)) {
- $this->set_header($column++,'','','width="25px"');
- }
- $this->set_header($column++, get_lang('Type'),'','width="35px"');
- $this->set_header($column++, get_lang('Name'), false);
- $this->set_header($column++, get_lang('Description'), false);
- if (api_is_allowed_to_edit(null, true)) {
- $this->set_header($column++, get_lang('Weight'),'','width="100px"');
- } else {
- $this->set_header($column++, get_lang('Weight'), false);
- $this->set_header($column++, get_lang('Result'), false);
- if (!empty($cats)) {
- $this->set_header($column++, get_lang('Actions'), false);
- }
- }
- //Desactivates the odd/even alt rows in order that the +/- buttons work see #4047
- $this->odd_even_rows_enabled = false;
- /*if (api_is_allowed_to_edit(null, true)) {
- //$this->set_header($column++, get_lang('CreationDate'),true, 'width="100px"');
- } elseif (($status<>1) && !api_is_allowed_to_edit() && (!isset($_GET['selectcat']) || $_GET['selectcat']==0)) {
- //$this->set_header($column++, get_lang('Date'),true, 'width="100px"');
- }*/
- //admins get an edit column
- if (api_is_allowed_to_edit(null, true)) {
- $this->set_header($column++, get_lang('Modify'), false, 'width="195px"');
- //actions on multiple selected documents
- $this->set_form_actions(array (
- 'setvisible' => get_lang('SetVisible'),
- 'setinvisible' => get_lang('SetInvisible'),
- 'deleted' => get_lang('DeleteSelected')
- ));
- } else {
- if (empty($_GET['selectcat']) && !api_is_allowed_to_edit()) {
- $this->set_header($column++, get_lang('Certificates'),false);
- } else {
- //$evals_links = array_merge($evals, $links);
- //if (count($evals_links)>0) {
- //$this->set_header($column++, get_lang('Results'), false);
- //}
- }
- }
- }
- function get_data() {
- return $this->datagen;
- }
- /**
- * Function used by SortableTable to get total number of items in the table
- */
- function get_total_number_of_items() {
- return $this->datagen->get_total_items_count();
- }
- /**
- * Function used by SortableTable to generate the data to display
- */
- function get_table_data($from = 1, $per_page = null, $column = null, $direction = null, $sort = null) {
- //variables load in index.php
- global $my_score_in_gradebook, $certificate_min_score;
- $scoretotal = 0;
- // determine sorting type
- $col_adjust = (api_is_allowed_to_edit() ? 1 : 0);
- // By id
- $this->column = 5;
- switch ($this->column) {
- // Type
- case (0 + $col_adjust) :
- $sorting = GradebookDataGenerator :: GDG_SORT_TYPE;
- break;
- case (1 + $col_adjust) :
- $sorting = GradebookDataGenerator :: GDG_SORT_NAME;
- break;
- case (2 + $col_adjust) :
- $sorting = GradebookDataGenerator :: GDG_SORT_DESCRIPTION;
- break;
- case (3 + $col_adjust) :
- $sorting = GradebookDataGenerator :: GDG_SORT_WEIGHT;
- break;
- case (4 + $col_adjust) :
- $sorting = GradebookDataGenerator :: GDG_SORT_DATE;
- case (5 + $col_adjust) :
- $sorting = GradebookDataGenerator :: GDG_SORT_ID;
- break;
- }
- if ($this->direction == 'DESC') {
- $sorting |= GradebookDataGenerator :: GDG_SORT_DESC;
- } else {
- $sorting |= GradebookDataGenerator :: GDG_SORT_ASC;
- }
- //status of user in course
- $user_id = api_get_user_id();
- $course_code = api_get_course_id();
- $courseId = api_get_course_int_id();
- $session_id = api_get_session_id();
- $status_user = api_get_status_of_user_in_course($user_id, $courseId);
- $data_array = $this->datagen->get_data($sorting, $from, $this->per_page);
- // generate the data to display
- $sortable_data = array();
- $weight_total_links = 0;
- $main_categories = array();
- $main_cat = Category :: load(null, null, $course_code, null, null, $session_id, false);
- $total_categories_weight = 0;
- $scoredisplay = ScoreDisplay :: instance();
- //Categories
- foreach ($data_array as $data) {
- // list of items inside the gradebook (exercises, lps, forums, etc)
- $row = array();
- $item = $item_category = $data[0];
- $id = $item->get_id();
- //if the item is invisible, wrap it in a span with class invisible
- $invisibility_span_open = (api_is_allowed_to_edit() && $item->is_visible() == '0') ? '<span class="invisible">' : '';
- $invisibility_span_close = (api_is_allowed_to_edit() && $item->is_visible() == '0') ? '</span>' : '';
- if (api_is_allowed_to_edit(null, true)) {
- //id
- $row[] = $this->build_id_column($item);
- }
- //Type
- $row[] = $this->build_type_column($item);
- //Name
- if (get_class($item) == 'Category') {
- $row[] = $invisibility_span_open.'<h3>'.$item->get_name().'</h3>'.$invisibility_span_close;
- $main_categories[$item->get_id()]['name'] = $item->get_name();
- } else {
- $row[] = $invisibility_span_open.$this->build_name_link($item) . $invisibility_span_close;
- $main_categories[$item->get_id()]['name'] = $this->build_name_link($item);
- }
- $main_categories[$item->get_id()]['weight']= $item->get_weight();
- $total_categories_weight += $item->get_weight();
- //Description
- $row[] = $invisibility_span_open.$data[2].$invisibility_span_close;
- //Weight
- //$row[] = $invisibility_span_open .Display::tag('h4', $data['3'] .' / '.$this->currentcat->get_weight()).$invisibility_span_close;
- //$average = $data['3']/$this->currentcat->get_weight()*100;
- $average = $scoredisplay->display_score(array($data['3'], $this->currentcat->get_weight()), SCORE_SIMPLE, SCORE_BOTH, true);
- if (api_is_allowed_to_edit(null, true)) {
- $row[] = $invisibility_span_open .Display::tag('h4', $average).$invisibility_span_close;
- } else {
- $row[] = $invisibility_span_open .$average.$invisibility_span_close;
- }
- $category_weight = $item->get_weight();
- if (api_is_allowed_to_edit(null, true)) {
- $weight_total_links += $data[3];
- } else {
- $cattotal = Category :: load($_GET['selectcat']);
- $scoretotal = $cattotal[0]->calc_score(api_get_user_id());
- $item_value = $scoredisplay->display_score($scoretotal, SCORE_SIMPLE);
- }
- //Date
- //$row[] = $invisibility_span_open.$data[4].$invisibility_span_close;
- //Edit (for admins)
- if (api_is_allowed_to_edit(null, true)) {
- $cat = new Category();
- $show_message = $cat->show_message_resource_delete($item->get_course_code());
- if ($show_message === false) {
- $row[] = $this->build_edit_column($item);
- }
- } else {
- //students get the results and certificates columns
- if (count($this->evals_links) > 0 && $status_user != 1) {
- $value_data = isset($data[4]) ? $data[4] : null;
- if (!is_null($value_data)) {
- $row[] = Display::tag('h4', $value_data);
- } else {
- $row[] = $this->build_edit_column($item);
- }
- } else {
- $score = $item->calc_score(api_get_user_id());
- if (!empty($score[1])) {
- $complete_score = $scoredisplay->display_score($score, SCORE_DIV_PERCENT);
- $score = $score[0]/$score[1]*$item->get_weight();
- $score = $scoredisplay->display_score(array($score, null), SCORE_SIMPLE);
- $row[] = Display::tip($score, $complete_score);
- } else {
- $row[] = '-';
- }
- if (!empty($this->cats)) {
- $row[] = $this->build_edit_column($item);
- }
- }
- }
- //Category added
- $sortable_data[] = $row;
- // Loading childrens
- if (get_class($item) == 'Category') {
- $stud_id = api_get_user_id();
- $course_code = api_get_course_id();
- $session_id = api_get_session_id();
- $parent_id = $item->get_id();
- $cats = Category :: load ($parent_id, null, null, null, null, null);
- $allcat = $cats[0]->get_subcategories($stud_id, $course_code, $session_id);
- $alleval = $cats[0]->get_evaluations($stud_id);
- $alllink = $cats[0]->get_links($stud_id);
- $sub_cat_info = new GradebookDataGenerator($allcat, $alleval, $alllink);
- $data_array = $sub_cat_info->get_data($sorting, $from, $this->per_page);
- $total_weight = 0;
- //Links
- foreach ($data_array as $data) {
- $row = array();
- $item = $data[0];
- $id = $item->get_id();
- //if the item is invisible, wrap it in a span with class invisible
- $invisibility_span_open = (api_is_allowed_to_edit() && $item->is_visible() == '0') ? '<span class="invisible">' : '';
- $invisibility_span_close = (api_is_allowed_to_edit() && $item->is_visible() == '0') ? '</span>' : '';
- $main_categories[$parent_id]['children'][$item->get_id()]['name'] = $item->get_name();
- $main_categories[$parent_id]['children'][$item->get_id()]['weight'] = $item->get_weight();
- if (api_is_allowed_to_edit(null, true)) {
- $row[] = $this->build_id_column($item);
- }
- $row[] = $this->build_type_column($item, array('style' => 'padding-left:5px'));
- //Name
- $row[] = $invisibility_span_open." ".$this->build_name_link($item) . $invisibility_span_close;
- //Description
- $row[] = $invisibility_span_open.$data[2].$invisibility_span_close;
- //Weight
- //$weight = $data[3]/$category_weight*$main_cat[0]->get_weight();
- /*$weight = $category_weight * $data[3] / $main_cat[0]->get_weight();
- $weight = $main_cat[0]->get_weight()*$weight/$category_weight;*/
- $weight = $data[3];
- //$extra = " - $data[3] $category_weight -".$main_cat[0]->get_weight();
- $total_weight += $weight;
- $row[] = $invisibility_span_open.$weight.$extra.$invisibility_span_close;
- if (api_is_allowed_to_edit(null, true)) {
- //$weight_total_links += intval($data[3]);
- } else {
- $cattotal = Category :: load($_GET['selectcat']);
- $scoretotal = $cattotal[0]->calc_score(api_get_user_id());
- $item_value = $scoretotal[0];
- }
- //Date
- //$row[] = $invisibility_span_open.$data[4].$invisibility_span_close;
- //Admins get an edit column
- if (api_is_allowed_to_edit(null, true)) {
- $cat = new Category();
- $show_message = $cat->show_message_resource_delete($item->get_course_code());
- if ($show_message === false) {
- $row[] = $this->build_edit_column($item);
- }
- } else {
- //students get the results and certificates columns
- $eval_n_links = array_merge($alleval, $alllink);
- if (count($eval_n_links)> 0 && $status_user!=1 ) {
- $value_data = isset($data[4]) ? $data[4] : null;
- if (!is_null($value_data)) {
- $score = $item->calc_score(api_get_user_id());
- $new_score = $data[3]* $score[0] / $score[1];
- $row[] = Display::tip($new_score, $data[4]);
- }
- }
- if (!empty($cats)) {
- $row[] = null;
- }
- }
- $row['child_of'] = $parent_id;
- $sortable_data[] = $row;
- }
- //"Warning row"
- if (!empty($data_array)) {
- if (api_is_allowed_to_edit()) {
- // Compare the category weight to the sum of all weights inside the category
- if (intval($total_weight) == $category_weight) {
- $label = null;
- $total = score_badges(array($total_weight.' / '.$category_weight, '100'));
- } else {
- $label = Display::return_icon('warning.png', sprintf(get_lang('TotalWeightMustBeX'), $category_weight) );
- $total = Display::badge($total_weight.' / '.$category_weight, 'warning');
- }
- $row = array(null, null, " <h5>".get_lang('SubTotal').'</h5>',null, $total.' '.$label, 'child_of' =>$parent_id);
- $sortable_data[] = $row;
- }
- }
- }
- } //end looping categories
- if (api_is_allowed_to_edit()) {
- if (count($main_cat) > 1) {
- $main_weight = intval($main_cat[0]->get_weight());
- if (intval($total_categories_weight) == $main_weight) {
- $total = score_badges(array($total_categories_weight.' / '.$main_weight, '100'));
- } else {
- $total = Display::badge($total_categories_weight.' / '.$main_weight, 'warning');
- }
- $row = array(null, null, '<h3>'.get_lang('Total').'</h3>', null, $total);
- $sortable_data[] = $row;
- }
- }
- // warning messages
- $view = isset($_GET['view']) ? $_GET['view']: null;
- if (api_is_allowed_to_edit()) {
- if (isset($_GET['selectcat']) && $_GET['selectcat'] > 0 && $view <> 'presence') {
- $id_cat = intval($_GET['selectcat']);
- $category = Category :: load($id_cat);
- //$weight_category = intval($this->build_weight($category[0]));
- $weight_category = intval($this->build_weight($category[0]));
- $course_code = $this->build_course_code($category[0]);
- $weight_total_links = round($weight_total_links);
- if ($weight_total_links > $weight_category || $weight_total_links < $weight_category || $weight_total_links > $weight_category) {
- $warning_message = sprintf(get_lang('TotalWeightMustBeX'), $weight_category);
- $modify_icons = '<a class="right_link" href="gradebook_edit_cat.php?editcat='.$id_cat.'&cidReq='.$course_code.'">'.Display::return_icon('edit.png', $warning_message, array(), ICON_SIZE_SMALL).'</a>';
- $warning_message .= $modify_icons;
- Display::display_warning_message($warning_message,false);
- }
- $content_html = DocumentManager::replace_user_info_into_html(api_get_user_id(), $course_code);
- if (!empty($content_html)) {
- $new_content = explode('</head>',$content_html['content']);
- }
- if (empty($new_content[0])) {
- $warning_message = get_lang('ThereIsNotACertificateAvailableByDefault');
- $cert_icon = '<a class="right_link" href="../document/document.php?curdirpath=/certificates&'.$course_code.'&origin=gradebook&selectcat=' . $id_cat . '">'.Display::return_icon('certificate.png', get_lang('AttachCertificate'), array(), ICON_SIZE_SMALL).'</a>';
- Display::display_warning_message($warning_message.$cert_icon,false);
- }
- }
- if (empty($_GET['selectcat'])) {
- $categories = Category :: load();
- $weight_categories = $certificate_min_scores = $course_codes = array();
- foreach ($categories as $category) {
- $course_code_category = $this->build_course_code($category);
- if (!empty($course_code)) {
- if ($course_code_category == $course_code) {
- $weight_categories[] = intval($this->build_weight($category));
- $certificate_min_scores[] = intval($this->build_certificate_min_score($category));
- $course_codes[] = $course_code;
- break;
- }
- } else {
- $weight_categories[] = intval($this->build_weight($category));
- $certificate_min_scores[] = intval($this->build_certificate_min_score($category));
- $course_codes[] = $course_code_category;
- }
- }
- if (is_array($weight_categories) && is_array($certificate_min_scores) && is_array($course_codes)) {
- $warning_message = '';
- for ($x = 0; $x<count($weight_categories);$x++) {
- $weight_category = intval($weight_categories[$x]);
- $certificate_min_score = intval($certificate_min_scores[$x]);
- $course_code = $course_codes[$x];
- if (empty($certificate_min_score) || ($certificate_min_score > $weight_category)) {
- $warning_message .= $course_code .' - '.get_lang('CertificateMinimunScoreIsRequiredAndMustNotBeMoreThan').' '.$weight_category.'<br />';
- }
- }
- if (!empty($warning_message)) {
- Display::display_warning_message($warning_message,false);
- }
- }
- }
- }
- return $sortable_data;
- }
- // Other functions
- private function build_certificate_min_score ($item) {
- return $item->get_certificate_min_score();
- }
- private function build_weight ($item) {
- return $item->get_weight();
- }
- private function build_course_code ($item) {
- return $item->get_course_code();
- }
- private function build_id_column ($item) {
- switch ($item->get_item_type()) {
- // category
- case 'C' :
- return 'CATE' . $item->get_id();
- // evaluation
- case 'E' :
- return 'EVAL' . $item->get_id();
- // link
- case 'L' :
- return 'LINK' . $item->get_id();
- }
- }
- private function build_type_column ($item, $attributes = array()) {
- return build_type_icon_tag($item->get_icon_name(), $attributes);
- }
- /**
- *
- * Generate name column
- * @param unknown_type $item
- * @return string
- */
- private function build_name_link ($item) {
- //$session_id = api_get_session_id();
- switch ($item->get_item_type()) {
- // category
- case 'C' :
- $prms_uri='?selectcat=' . $item->get_id() . '&view='.Security::remove_XSS($_GET['view']);
- if (isset($_GET['isStudentView'])) {
- if ( isset($is_student) || ( isset($_SESSION['studentview']) && $_SESSION['studentview']=='studentview') ) {
- $prms_uri=$prms_uri.'&isStudentView='.Security::remove_XSS($_GET['isStudentView']);
- }
- }
- $cat = new Category();
- $show_message=$cat->show_message_resource_delete($item->get_course_code());
- return ' <a href="'.Security::remove_XSS($_SESSION['gradebook_dest']).$prms_uri.'">'
- . $item->get_name()
- . '</a>'
- . ($item->is_course() ? ' [' . $item->get_course_code() . ']'.$show_message : '');
- // evaluation
- case 'E' :
- $cat = new Category();
- $course_id = CourseManager::get_course_by_category($_GET['selectcat']);
- $show_message = $cat->show_message_resource_delete($course_id);
- // course/platform admin can go to the view_results page
- if (api_is_allowed_to_edit() && $show_message===false) {
- if ($item->get_type() == 'presence') {
- return ' '
- . '<a href="gradebook_view_result.php?cidReq='.$course_id.'&selecteval=' . $item->get_id() . '">'
- . $item->get_name()
- . '</a>';
- } else {
- return ' '
- . '<a href="gradebook_view_result.php?cidReq='.$course_id.'&selecteval=' . $item->get_id() . '">'
- . $item->get_name()
- . '</a> '.Display::label(get_lang('Evaluation'));
- }
- } elseif (ScoreDisplay :: instance()->is_custom() && $show_message===false) {
- // students can go to the statistics page (if custom display enabled)
- return ' '
- . '<a href="gradebook_statistics.php?selecteval=' . $item->get_id() . '">'
- . $item->get_name()
- . '</a>';
- } elseif ($show_message===false && !api_is_allowed_to_edit() && !(ScoreDisplay :: instance()->is_custom())) {
- return ' '
- . '<a href="gradebook_statistics.php?selecteval=' . $item->get_id() . '">'
- . $item->get_name()
- . '</a>';
- } else {
- return '['.get_lang('Evaluation').'] '.$item->get_name().$show_message;
- }
- // link
- case 'L' :
- $cat = new Category();
- $course_id = CourseManager::get_course_by_category($_GET['selectcat']);
- $show_message = $cat->show_message_resource_delete($course_id);
- $url = $item->get_link();
- if (isset($url) && $show_message===false) {
- $text = ' <a href="' . $item->get_link() . '">'
- . $item->get_name()
- . '</a>';
- } else {
- $text = $item->get_name();
- }
- $text .= " ".Display::label($item->get_type_name(), 'info').$show_message;
- $cc = $this->currentcat->get_course_code();
- if (empty($cc)) {
- $text .= ' [<a href="'.api_get_path(REL_COURSE_PATH).$item->get_course_code().'/">'.$item->get_course_code().'</a>]';
- }
- return $text;
- }
- }
- private function build_edit_column($item) {
- switch ($item->get_item_type()) {
- // category
- case 'C' :
- return build_edit_icons_cat($item, $this->currentcat);
- // evaluation
- case 'E' :
- return build_edit_icons_eval($item, $this->currentcat->get_id());
- // link
- case 'L' :
- return build_edit_icons_link($item, $this->currentcat->get_id());
- }
- }
- }
|