chamilo-lms2/main/gradebook/lib/fe/gradebooktable.class.php

<?php
/* For licensing terms, see license.txt */

use ChamiloSession as Session;
use CpChart\Chart\Cache as pCache;
use CpChart\Chart\Data as pData;
use CpChart\Chart\Image as pImage;

/**
 * GradebookTable Class
 * 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;
    private $dataForGraph;
    public $cats;
    public $exportToPdf;
    public $teacherView;
    public $userId;
    public $studentList;

    /**
     * GradebookTable constructor.
     * @param Category $currentcat
     * @param array $cats
     * @param array $evals
     * @param array $links
     * @param null $addparams
     * @param bool $exportToPdf
     * @param null $showTeacherView
     * @param int $userId
     * @param array $studentList
     */
    public function __construct(
        $currentcat,
        $cats = array(),
        $evals = array(),
        $links = array(),
        $addparams = null,
        $exportToPdf = false,
        $showTeacherView = null,
        $userId = null,
        $studentList = array()
    ) {
        $this->teacherView = is_null($showTeacherView) ? api_is_allowed_to_edit(null, true) : $showTeacherView;
        $this->userId = is_null($userId) ? api_get_user_id() : $userId;
        $this->exportToPdf = $exportToPdf;

        parent::__construct(
            'gradebooklist',
            null,
            null,
            api_is_allowed_to_edit() ? 1 : 0,
            20,
            'ASC',
            'gradebook_list'
        );

        $this->evals_links = array_merge($evals, $links);
        $this->currentcat = $currentcat;
        $this->cats = $cats;
        $this->datagen = new GradebookDataGenerator($cats, $evals, $links);

        if (!empty($userId)) {
            $this->datagen->userId = $userId;
        }

        if (isset($addparams)) {
            $this->set_additional_parameters($addparams);
        }

        $column = 0;
        if ($this->teacherView) {
            if ($this->exportToPdf == false) {
                $this->set_header($column++, '', '', 'width="25px"');
            }
        }

        $this->set_header($column++, get_lang('Type'), '', 'width="35px"');
        $this->set_header($column++, get_lang('Name'), false);

        if ($this->exportToPdf == false) {
            $this->set_header($column++, get_lang('Description'), false);
        }

        if ($this->teacherView) {
            $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);
            $this->set_header($column++, get_lang('Ranking'), false);
            $this->set_header($column++, get_lang('BestScore'), false);
            $this->set_header($column++, get_lang('Average'), false);

            if (!empty($cats)) {
                if ($this->exportToPdf == false) {
                    $this->set_header($column++, get_lang('Actions'), false);
                }
            }
        }

        // Deactivates the odd/even alt rows in order that the +/- buttons work see #4047
        $this->odd_even_rows_enabled = false;

        // Admins get an edit column.
        if ($this->teacherView) {
            $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']) && !$this->teacherView) {
                if ($this->exportToPdf == false) {
                    $this->set_header(
                        $column++,
                        get_lang('Certificates'),
                        false
                    );
                }
            }
        }
    }

    /**
     * @return GradebookDataGenerator
     */
    public function get_data()
    {
        return $this->datagen;
    }

    /**
     * Function used by SortableTable to get total number of items in the table
     * @return int
     */
    public function get_total_number_of_items()
    {
        return $this->datagen->get_total_items_count();
    }

    /**
     * Function used by SortableTable to generate the data to display
     * @param int $from
     * @param int $per_page
     * @param int $column
     * @param string $direction
     * @param int $sort
     * @return array|mixed
     */
    public function get_table_data($from = 1, $per_page = null, $column = null, $direction = null, $sort = null)
    {
        //variables load in index.php
        global $certificate_min_score;
        // 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;
                break;
            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 = $this->userId;
        $course_code = api_get_course_id();
        $session_id = api_get_session_id();

        if (empty($session_id)) {
            $statusToFilter = STUDENT;
        } else {
            $statusToFilter = 0;
        }

        if (empty($this->studentList)) {
            $studentList = CourseManager::get_user_list_from_course_code(
                $course_code,
                $session_id,
                null,
                null,
                $statusToFilter
            );
            $this->studentList = $studentList;
        }

        $this->datagen->userId = $this->userId;

        $data_array = $this->datagen->get_data(
            $sorting,
            $from,
            $this->per_page,
            false,
            $this->studentList
        );

        // generate the data to display
        $sortable_data = array();
        $weight_total_links = 0;
        $main_cat = Category::load(
            null,
            null,
            $course_code,
            null,
            null,
            $session_id,
            'ORDER BY id'
        );

        $total_categories_weight = 0;
        $scoredisplay = ScoreDisplay::instance();

        $totalResult = [0, 0];
        $totalBest = [0, 0];
        $totalAverage = [0, 0];

        $type = 'detail';
        if ($this->exportToPdf) {
            $type = 'simple';
        }

        // Categories.
        if (!empty($data_array)) {
            foreach ($data_array as $data) {
                // list of items inside the gradebook (exercises, lps, forums, etc)
                $row = array();

                /** @var AbstractLink $item */
                $item = $mainCategory = $data[0];

                //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="text-muted">' : '';
                $invisibility_span_close = api_is_allowed_to_edit() && $item->is_visible() == '0' ? '</span>' : '';

                // Id
                if ($this->teacherView) {
                    if ($this->exportToPdf == false) {
                        $row[] = $this->build_id_column($item);
                    }
                }

                // Type.
                $row[] = $this->build_type_column($item);

                // Name.
                if (get_class($item) == 'Category') {
                    $row[] = $invisibility_span_open.'<strong>'.$item->get_name().'</strong>'.$invisibility_span_close;
                    $main_categories[$item->get_id()]['name'] = $item->get_name();
                } else {
                    $name = $this->build_name_link($item, $type);
                    $row[] = $invisibility_span_open.$name.$invisibility_span_close;
                    $main_categories[$item->get_id()]['name'] = $name;
                }

                $this->dataForGraph['categories'][] = $item->get_name();

                $main_categories[$item->get_id()]['weight'] = $item->get_weight();
                $total_categories_weight += $item->get_weight();

                // Description.
                if ($this->exportToPdf == false) {
                    $row[] = $invisibility_span_open.$data[2].$invisibility_span_close;
                }

                // Weight.
                $weight = $scoredisplay->display_score(
                    array(
                        $data['3'],
                        $this->currentcat->get_weight()
                    ),
                    SCORE_SIMPLE,
                    SCORE_BOTH,
                    true
                );

                if ($this->teacherView) {
                    $row[] = $invisibility_span_open.Display::tag('p', $weight,
                            array('class' => 'score')).$invisibility_span_close;
                } else {
                    $row[] = $invisibility_span_open.$weight.$invisibility_span_close;
                }

                $category_weight = $item->get_weight();
                $mainCategoryWeight = $main_cat[0]->get_weight();

                if ($this->teacherView) {
                    $weight_total_links += $data[3];
                } else {
                    $cattotal = Category::load($_GET['selectcat']);
                    $scoretotal = $cattotal[0]->calc_score($this->userId);
                    $item_value = $scoredisplay->display_score($scoretotal, SCORE_SIMPLE);
                }

                // Edit (for admins).
                if ($this->teacherView) {
                    $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 {
                    $score = $item->calc_score($this->userId);

                    if (!empty($score[1])) {
                        $completeScore = $scoredisplay->display_score($score, SCORE_DIV_PERCENT);
                        $score = $score[0] / $score[1] * $item->get_weight();
                        $score = $scoredisplay->display_score(array($score, null), SCORE_SIMPLE);
                        $scoreToDisplay = Display::tip($score, $completeScore);
                    } else {
                        $scoreToDisplay = '-';
                        $categoryScore = null;
                    }

                    // Students get the results and certificates columns
                    //if (count($this->evals_links) > 0 && $status_user != 1) {
                    if (1) {
                        $value_data = isset($data[4]) ? $data[4] : null;
                        $best = isset($data['best']) ? $data['best'] : null;
                        $average = isset($data['average']) ? $data['average'] : null;
                        $ranking = isset($data['ranking']) ? $data['ranking'] : null;

                        $totalResult = [
                            $data['result_score'][0],
                            $data['result_score'][1],
                        ];

                        $totalBest = [
                            $totalBest[0] + $data['best_score'][0],
                            $totalBest[1] + $data['best_score'][1],
                        ];

                        $totalAverage = [
                            $data['average_score'][0],
                            $data['average_score'][1],
                        ];

                        // Student result
                        $row[] = $value_data;
                        $totalResultAverageValue = strip_tags(
                            $scoredisplay->display_score(
                                $totalResult,
                                SCORE_AVERAGE
                            )
                        );
                        $this->dataForGraph['my_result'][] = floatval($totalResultAverageValue);
                        $totalAverageValue = strip_tags($scoredisplay->display_score($totalAverage, SCORE_AVERAGE));
                        $this->dataForGraph['average'][] = floatval($totalAverageValue);
                        // Ranking
                        $row[] = $ranking;
                        // Best
                        $row[] = $best;
                        // Average
                        $row[] = $average;

                        if (get_class($item) == 'Category') {
                            if ($this->exportToPdf == false) {
                                $row[] = $this->build_edit_column($item);
                            }
                        }
                    } else {
                        $row[] = $scoreToDisplay;

                        if (!empty($this->cats)) {
                            if ($this->exportToPdf == false) {
                                $row[] = $this->build_edit_column($item);
                            }
                        }
                    }
                }

                // Category added.
                $sortable_data[] = $row;

                // Loading children
                if (get_class($item) == 'Category') {
                    $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
                    );

                    if (isset($cats[0])) {
                        $allcat = $cats[0]->get_subcategories($this->userId, $course_code, $session_id);
                        $alleval = $cats[0]->get_evaluations($this->userId);
                        $alllink = $cats[0]->get_links($this->userId);

                        $sub_cat_info = new GradebookDataGenerator($allcat, $alleval, $alllink);
                        $sub_cat_info->userId = $user_id;

                        $data_array2 = $sub_cat_info->get_data(
                            $sorting,
                            $from,
                            $this->per_page,
                            false,
                            $this->studentList
                        );
                        $total_weight = 0;

                        // Links.
                        foreach ($data_array2 as $data) {
                            $row = array();
                            $item = $data[0];

                            //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="text-muted">' : '';
                            $invisibility_span_close = api_is_allowed_to_edit() && $item->is_visible() == '0' ? '</span>' : '';

                            if (isset($item)) {
                                $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 ($this->teacherView) {
                                if ($this->exportToPdf == false) {
                                    $row[] = $this->build_id_column($item);
                                }
                            }

                            // Type
                            $row[] = $this->build_type_column($item, array('style' => 'padding-left:5px'));

                            // Name.
                            $row[] = $invisibility_span_open."&nbsp;&nbsp;&nbsp;  ".
                                $this->build_name_link($item, $type).$invisibility_span_close;

                            // Description.
                            if ($this->exportToPdf == false) {
                                $row[] = $invisibility_span_open.$data[2].$invisibility_span_close;
                            }

                            $weight = $data[3];
                            $total_weight += $weight;

                            // Weight
                            $row[] = $invisibility_span_open.$weight.$invisibility_span_close;

                            if ($this->teacherView) {
                                //$weight_total_links += intval($data[3]);
                            } else {
                                $cattotal = Category::load($_GET['selectcat']);
                                $scoretotal = $cattotal[0]->calc_score($this->userId);
                                $item_value = $scoretotal[0];
                            }

                            // Admins get an edit column.
                            if (api_is_allowed_to_edit(null, true) &&
                                isset($_GET['user_id']) == false &&
                                (isset($_GET['action']) && $_GET['action'] != 'export_all' || !isset($_GET['action'])
                                )
                            ) {
                                $cat = new Category();
                                $show_message = $cat->show_message_resource_delete($item->get_course_code());
                                if ($show_message === false) {
                                    if ($this->exportToPdf == 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) {
                                    $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];
                                        //$new_score = floatval(number_format($new_score, api_get_setting('gradebook_number_decimals')));

                                        // Result
                                        $row[] = $value_data;
                                        $best = isset($data['best']) ? $data['best'] : null;
                                        $average = isset($data['average']) ? $data['average'] : null;
                                        $ranking = isset($data['ranking']) ? $data['ranking'] : null;

                                        // Ranking
                                        $row[] = $ranking;
                                        // Best
                                        $row[] = $best;
                                        // Average
                                        $row[] = $average;
                                    }
                                }

                                if (!empty($cats)) {
                                    if ($this->exportToPdf == false) {
                                        $row[] = null;
                                    }
                                }
                            }

                            if ($this->exportToPdf == false) {
                                $row['child_of'] = $parent_id;
                            }
                            $sortable_data[] = $row;
                        }

                        // "Warning row"
                        if (!empty($data_array)) {
                            if ($this->teacherView) {
                                // Compare the category weight to the sum of all weights inside the category
                                if (intval($total_weight) == $category_weight) {
                                    $label = null;
                                    $total = GradebookUtils::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,
                                    "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<h5>".get_lang('SubTotal').'</h5>',
                                    null,
                                    $total.' '.$label,
                                    'child_of' => $parent_id
                                );
                                $sortable_data[] = $row;
                            }
                        }
                    }
                }
            }
        } //end looping categories

        $main_weight = 0;
        if (count($main_cat) > 1) {
            /** @var Category $myCat */
            foreach ($main_cat as $myCat) {
                $myParentId = $myCat->get_parent_id();
                if ($myParentId == 0) {
                    $main_weight = intval($myCat->get_weight());
                }
            }
        }

        if ($this->teacherView) {
            // Total for teacher.
            if (count($main_cat) > 1) {
                if (intval($total_categories_weight) == $main_weight) {
                    $total = GradebookUtils::score_badges(
                        array(
                            $total_categories_weight.' / '.$main_weight,
                            '100'
                        )
                    );
                } else {
                    $total = Display::badge($total_categories_weight.' / '.$main_weight, 'warning');
                }
                $row = array(
                    null,
                    null,
                    '<strong>'.get_lang('Total').'</strong>',
                    null,
                    $total
                );
                $sortable_data[] = $row;
            }
        } else {
            // Total for student.
            if (count($main_cat) > 1) {
                $main_weight = intval($main_cat[0]->get_weight());

                $global = null;
                $average = null;
                // Overwrite main weight
                $totalResult[1] = $main_weight;

                $totalResult = $scoredisplay->display_score(
                    $totalResult,
                    SCORE_DIV
                );

                $totalRanking = array();
                $invalidateRanking = true;
                $average = 0;
                foreach ($this->studentList as $student) {
                    $score = $main_cat[0]->calc_score($student['user_id']);
                    if (!empty($score[0])) {
                        $invalidateRanking = false;
                    }
                    $totalRanking[$student['user_id']] = $score[0];
                    $average += $score[0];
                }

                $totalRanking = AbstractLink::getCurrentUserRanking($user_id, $totalRanking);

                $totalRanking = $scoredisplay->display_score(
                    $totalRanking,
                    SCORE_DIV,
                    SCORE_BOTH,
                    true
                );

                if ($invalidateRanking) {
                    $totalRanking = null;
                }

                // Overwrite main weight
                $totalBest[1] = $main_weight;

                $totalBest = $scoredisplay->display_score(
                    $totalBest,
                    SCORE_DIV,
                    SCORE_BOTH,
                    true
                );

                // Overwrite main weight
                $totalAverage[0] = $average / count($this->studentList);
                $totalAverage[1] = $main_weight;

                $totalAverage = $scoredisplay->display_score(
                    $totalAverage,
                    SCORE_DIV,
                    SCORE_BOTH,
                    true
                );

                if ($this->exportToPdf) {
                    $row = array(
                        null,
                        '<h3>'.get_lang('Total').'</h3>',
                        $main_weight,
                        $totalResult,
                        $totalRanking,
                        $totalBest,
                        $totalAverage
                    );
                } else {
                    $row = array(
                        null,
                        '<h3>'.get_lang('Total').'</h3>',
                        null,
                        $main_weight,
                        $totalResult,
                        $totalRanking,
                        $totalBest,
                        $totalAverage
                    );
                }

                $sortable_data[] = $row;
            }
        }

        // Warning messages
        $view = isset($_GET['view']) ? $_GET['view'] : null;

        if ($this->teacherView) {
            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]));
                $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 href="gradebook_edit_cat.php?editcat='.$id_cat.'&cidReq='.$course_code.'&id_session='.api_get_session_id().'">'.
                        Display::return_icon('edit.png', $warning_message, array(), ICON_SIZE_SMALL).'</a>';
                    $warning_message .= $modify_icons;
                    echo Display::return_message($warning_message, 'warning', false);
                }

                $content_html = DocumentManager::replace_user_info_into_html(
                    api_get_user_id(),
                    $course_code,
                    api_get_session_id()
                );

                if (!empty($content_html)) {
                    $new_content = explode('</head>', $content_html['content']);
                }

                if (empty($new_content[0])) {
                    // Set default certificate
                    $courseData = api_get_course_info($course_code);
                    DocumentManager::generateDefaultCertificate($courseData);
                }
            }

            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.'&nbsp;-&nbsp;'.get_lang('CertificateMinimunScoreIsRequiredAndMustNotBeMoreThan').'&nbsp;'.$weight_category.'<br />';
                        }
                    }

                    if (!empty($warning_message)) {
                        echo Display::return_message($warning_message, 'warning', false);
                    }
                }
            }
        }

        return $sortable_data;
    }


    /**
     * @return array
     */
    private function getDataForGraph()
    {
        return $this->dataForGraph;
    }

    /**
     * @return string
     */
    public function getGraph()
    {
        $data = $this->getDataForGraph();
        if (!empty($data) &&
            isset($data['categories']) &&
            isset($data['my_result']) &&
            isset($data['average'])
        ) {
            $dataSet = new pData();
            $dataSet->addPoints($data['my_result'], get_lang('Me'));
            // In order to generate random values
            // $data['average'] = array(rand(0,50), rand(0,50));
            $dataSet->addPoints($data['average'], get_lang('Average'));
            $dataSet->addPoints($data['categories'], 'categories');

            $dataSet->setAbscissa("categories");
            $xSize = 600;
            $ySize = 400;
            $pChart = new pImage($xSize, $ySize, $dataSet);
            /* Turn of Antialiasing */
            $pChart->Antialias = false;

            /* Add a border to the picture */
            $pChart->drawRectangle(
                0,
                0,
                $xSize - 1,
                $ySize - 1,
                array("R" => 0, "G" => 0, "B" => 0)
            );
            $pChart->drawText(
                10,
                16,
                get_lang('Results'),
                array("FontSize" => 11, "Align" => TEXT_ALIGN_BOTTOMMIDDLE)
            );
            $pChart->setGraphArea(50, 30, $xSize - 50, $ySize - 70);
            $pChart->setFontProperties(
                array(
                    'FontName' => api_get_path(SYS_FONTS_PATH).'opensans/OpenSans-Regular.ttf',
                    'FontSize' => 10,
                )
            );

            /* Draw the scale */
            $scaleSettings = array(
                "XMargin" => AUTO,
                "YMargin" => 10,
                "Floating" => true,
                "GridR" => 200,
                "GridG" => 200,
                "GridB" => 200,
                "DrawSubTicks" => true,
                "CycleBackground" => true,
                'LabelRotation' => 10
            );
            $pChart->drawScale($scaleSettings);

            /* Draw the line chart */
            $pChart->drawLineChart();
            $pChart->drawPlotChart(
                array(
                    "DisplayValues" => true,
                    "PlotBorder" => true,
                    "BorderSize" => 2,
                    "Surrounding" => -60,
                    "BorderAlpha" => 80,
                )
            );

            /* Write the chart legend */
            $pChart->drawLegend(
                $xSize - 180,
                9,
                array(
                    "Style" => LEGEND_NOBORDER,
                    "Mode" => LEGEND_HORIZONTAL,
                    "FontR" => 0,
                    "FontG" => 0,
                    "FontB" => 0,
                )
            );

            $cachePath = api_get_path(SYS_ARCHIVE_PATH);
            $myCache = new pCache(array('CacheFolder' => substr($cachePath, 0, strlen($cachePath) - 1)));
            $chartHash = $myCache->getHash($dataSet);

            $myCache->writeToCache($chartHash, $pChart);
            $imgSysPath = api_get_path(SYS_ARCHIVE_PATH).$chartHash;
            $myCache->saveFromCache($chartHash, $imgSysPath);
            $imgWebPath = api_get_path(WEB_ARCHIVE_PATH).$chartHash;

            if (file_exists($imgSysPath)) {
                $result = '<div id="contentArea" style="text-align: center;" >';
                $result .= '<img src="'.$imgWebPath.'" >';
                $result .= '</div>';

                return $result;
            }
        }

        return '';
    }

    /**
     * @param $item
     * @return mixed
     */
    private function build_certificate_min_score($item)
    {
        return $item->get_certificate_min_score();
    }

    /**
     * @param $item
     * @return mixed
     */
    private function build_weight($item)
    {
        return $item->get_weight();
    }

    /**
     * @param $item
     * @return mixed
     */
    private function build_course_code($item)
    {
        return $item->get_course_code();
    }

    /**
     * @param $item
     * @return string
     */
    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();
        }
    }

    /**
     * @param $item
     * @param array $attributes
     * @return string
     */
    private function build_type_column($item, $attributes = array())
    {
        return GradebookUtils::build_type_icon_tag($item->get_icon_name(), $attributes);
    }

    /**
     * Generate name column
     * @param GradebookItem $item
     * @param string $type simple|detail
     * @return string
     */
    private function build_name_link($item, $type = 'detail')
    {
        $view = isset($_GET['view']) ? Security::remove_XSS($_GET['view']) : null;
        $categoryId = $item->getCategory()->get_id();

        switch ($item->get_item_type()) {
            // category
            case 'C':
                $prms_uri = '?selectcat='.$item->get_id().'&amp;view='.$view;
                if (isset($_GET['isStudentView'])) {
                    if (isset($is_student) || (isset($_SESSION['studentview']) && $_SESSION['studentview'] == 'studentview')) {
                        $prms_uri = $prms_uri.'&amp;isStudentView='.Security::remove_XSS($_GET['isStudentView']);
                    }
                }

                $cat = new Category();
                $show_message = $cat->show_message_resource_delete($item->get_course_code());

                return '&nbsp;<a href="'.Security::remove_XSS($_SESSION['gradebook_dest']).$prms_uri.'">'
                    .$item->get_name()
                    .'</a>'
                    .($item->is_course() ? ' &nbsp;['.$item->get_course_code().']'.$show_message : '');
                // evaluation
                //no break because of return
            case 'E':
                $cat = new Category();
                $course_id = CourseManager::get_course_by_category($categoryId);
                $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 '&nbsp;'
                            .'<a href="gradebook_view_result.php?cidReq='.$course_id.'&amp;selecteval='.$item->get_id().'">'
                            .$item->get_name()
                            .'</a>';
                    } else {
                        $extra = Display::label(get_lang('Evaluation'));
                        if ($type == 'simple') {
                            $extra = '';
                        }

                        return '&nbsp;'
                            .'<a href="gradebook_view_result.php?'.api_get_cidreq().'&selecteval='.$item->get_id().'">'
                            .$item->get_name()
                            .'</a>&nbsp;'.$extra;
                    }
                } elseif (ScoreDisplay::instance()->is_custom() && $show_message === false) {
                    // students can go to the statistics page (if custom display enabled)
                    return '&nbsp;'
                        .'<a href="gradebook_statistics.php?'.api_get_cidreq().'&selecteval='.$item->get_id().'">'
                        .$item->get_name()
                        .'</a>';

                } elseif ($show_message === false && !api_is_allowed_to_edit() && !ScoreDisplay::instance()->is_custom()) {
                    return '&nbsp;'
                        .'<a href="gradebook_statistics.php?'.api_get_cidreq().'&selecteval='.$item->get_id().'">'
                        .$item->get_name()
                        .'</a>';
                } else {
                    return '['.get_lang('Evaluation').']&nbsp;&nbsp;'.$item->get_name().$show_message;
                }
                // no break because of return
            case 'L':
                // link
                $cat = new Category();
                $course_id = CourseManager::get_course_by_category($categoryId);
                $show_message = $cat->show_message_resource_delete($course_id);

                $url = $item->get_link();

                if (isset($url) && $show_message === false) {
                    $text = '&nbsp;<a href="'.$item->get_link().'">'
                        .$item->get_name()
                        .'</a>';
                } else {
                    $text = $item->get_name();
                }

                $extra = Display::label($item->get_type_name(), 'info');
                if ($type == 'simple') {
                    $extra = '';
                }

                $text .= "&nbsp;".$extra.$show_message;
                $cc = $this->currentcat->get_course_code();
                if (empty($cc)) {
                    $text .= '&nbsp;[<a href="'.api_get_path(REL_COURSE_PATH).$item->get_course_code().'/">'.$item->get_course_code().'</a>]';
                }

                return $text;
        }
    }

    /**
     * @param AbstractLink $item
     * @return null|string
     */
    private function build_edit_column($item)
    {
        switch ($item->get_item_type()) {
            // category
            case 'C':
                return GradebookUtils::build_edit_icons_cat($item, $this->currentcat);
            // evaluation
            case 'E':
                return GradebookUtils::build_edit_icons_eval($item, $this->currentcat->get_id());
            // link
            case 'L':
                return GradebookUtils::build_edit_icons_link($item, $this->currentcat->get_id());
        }
    }
}