class.ilSCORMTrackingItemsTableGUI.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once './Services/Table/classes/class.ilTable2GUI.php';
include_once './Modules/ScormAicc/classes/class.ilSCORMTrackingItems.php';

class ilSCORMTrackingItemsTableGUI extends ilTable2GUI
{
    private $obj_id = 0;
        private $user_id = 0;
        private $bySCO = false;
        private $scosSelected = array();
        private $userSelected = array();
        private $allowExportPrivacy = false;
        private $scoTite = "";

        public function __construct($a_obj_id, $a_parent_obj, $a_parent_cmd, $a_userSelected, $a_scosSelected, $a_report)
        {
        
                global $ilCtrl, $lng, $ilAccess, $lng, $rbacsystem;
                $lng->loadLanguageModule("scormtrac");
        
                $this->obj_id = $a_obj_id;
                $this->report = $a_report;
                $this->scosSelected=$a_scosSelected;
                $this->userSelected=$a_userSelected;
                if ($a_parent_cmd == "showTrackingItemsBySco") $this->bySCO = true;
                $this->lmTitle = $a_parent_obj->object->getTitle();

                $this->setId('AICC'.$this->report);
                parent::__construct($a_parent_obj, $a_parent_cmd);
                $this->setLimit(9999);

                include_once('./Services/PrivacySecurity/classes/class.ilPrivacySettings.php');
                $privacy = ilPrivacySettings::_getInstance();
                $this->allowExportPrivacy = $privacy->enabledExportSCORM();


                // if($a_print_view)
                // {
                        // $this->setPrintMode(true);
                // }


                foreach ($this->getSelectedColumns() as $c)
                {
                        $l = $c;
                        if (in_array($l, array("status", "time", "score"))) {
                                $l = "cont_".$l;
                        // } else {
                                // $l =
                        }
                        $s = $this->lng->txt($l);
                        if (substr($l,0,14) == "interaction_id") $s = $this->lng->txt(substr($l,0,14)).' '.substr($l,14);
                        if (substr($l,0,17) == "interaction_value") $s = sprintf($this->lng->txt(substr($l,0,17)),substr($l,17,(strpos($l,' ')-17))).substr($l,strpos($l,' '));
                        if (substr($l,0,23) == "interaction_description") $s = $this->lng->txt(substr($l,0,23)).' '.substr($l,23);
                        $this->addColumn($s, $c);
                }

                $this->setRowTemplate('tpl.scorm_tracking_items.html', 'Modules/ScormAicc');
                $this->setFormAction($ilCtrl->getFormAction($this->getParentObject()));

                $this->setExternalSorting(true);
//              $this->setExternalSegmentation(true);
                $this->setEnableHeader(true);
                $this->setEnableTitle(true);
//              $this->setDefaultOrderField("cp_node_id, user_id");
                $this->setDefaultOrderField("");
                $this->setDefaultOrderDirection("asc");
                $this->setShowTemplates(true);

                $this->setExportFormats(array(self::EXPORT_CSV, self::EXPORT_EXCEL));
//              $this->initFilter();
                $this->getItems();
        }
        function getSelectableColumns()
        {
                // default fields
                $cols = array();
                
                switch($this->report) {
                        case "exportSelectedCore":
                                $cols=ilSCORMTrackingItems::exportSelectedCoreColumns($this->bySCO, $this->allowExportPrivacy);
                        break;
                        case "exportSelectedRaw":
                                $cols=ilSCORMTrackingItems::exportSelectedRawColumns();
                        break;
                        case "exportSelectedInteractions":
                                $cols=ilSCORMTrackingItems::exportSelectedInteractionsColumns();
                        break;
                        case "exportSelectedObjectives":
                                $cols=ilSCORMTrackingItems::exportSelectedObjectivesColumns();
                        break;
                        case "tracInteractionItem":
                                $cols=ilSCORMTrackingItems::tracInteractionItemColumns($this->bySCO, $this->allowExportPrivacy);
                        break;
                        case "tracInteractionUser":
                                $cols=ilSCORMTrackingItems::tracInteractionUserColumns($this->bySCO, $this->allowExportPrivacy);
                        break;
                        case "tracInteractionUserAnswers":
                                $cols=ilSCORMTrackingItems::tracInteractionUserAnswersColumns($this->userSelected, $this->scosSelected, $this->bySCO, $this->allowExportPrivacy);
                        break;
                        case "exportSelectedSuccess":
                                $cols=ilSCORMTrackingItems::exportSelectedSuccessColumns();
                        break;
                }
                
                return $cols;
        }

        public function getObjId()
        {
                return $this->obj_id;
        }


        function getItems() {
                global $lng;

                $this->determineOffsetAndOrder();
                $ilSCORMTrackingItems = new ilSCORMTrackingItems();
                switch($this->report) {
                        case "exportSelectedCore":
                                $tr_data = $ilSCORMTrackingItems->exportSelectedCore($this->userSelected, $this->scosSelected, $this->bySCO, $this->allowExportPrivacy, $this->getObjId());
                        break;
                        case "exportSelectedRaw":
                                $tr_data = $ilSCORMTrackingItems->exportSelectedRaw($this->userSelected, $this->scosSelected, $this->bySCO, $this->allowExportPrivacy, $this->getObjId());
                        break;
                        case "exportSelectedInteractions":
                                $tr_data = $ilSCORMTrackingItems->exportSelectedInteractions($this->userSelected, $this->scosSelected, $this->bySCO, $this->allowExportPrivacy, $this->getObjId());
                        break;
                        case "exportSelectedObjectives":
                                $tr_data = $ilSCORMTrackingItems->exportSelectedObjectives($this->userSelected, $this->scosSelected, $this->bySCO, $this->allowExportPrivacy, $this->getObjId());
                        break;
                        case "tracInteractionItem":
                                $tr_data = $ilSCORMTrackingItems->tracInteractionItem($this->userSelected, $this->scosSelected, $this->bySCO, $this->allowExportPrivacy, $this->getObjId());
                        break;
                        case "tracInteractionUser":
                                $tr_data = $ilSCORMTrackingItems->tracInteractionUser($this->userSelected, $this->scosSelected, $this->bySCO, $this->allowExportPrivacy, $this->getObjId());
                        break;
                        case "tracInteractionUserAnswers":
                                $tr_data = $ilSCORMTrackingItems->tracInteractionUserAnswers($this->userSelected, $this->scosSelected, $this->bySCO, $this->allowExportPrivacy, $this->getObjId());
                        break;
                        case "exportSelectedSuccess":
                                $tr_data = $ilSCORMTrackingItems->exportSelectedSuccess($this->userSelected, $this->allowExportPrivacy, $this->getObjId());
                        break;
                }
                $this->setMaxCount($tr_data["cnt"]);
                if (ilUtil::stripSlashes($this->getOrderField()) !="") {
                        include_once "Services/Utilities/classes/class.ilStr.php";
                        $tr_data = ilUtil::stableSortArray($tr_data, ilUtil::stripSlashes($this->getOrderField()), ilUtil::stripSlashes($this->getOrderDirection()) );
                }

                $this->setData($tr_data);
        }
        protected function parseValue($id, $value, $type)
        {
                global $lng;
                $lng->loadLanguageModule("trac");
                switch($id)
                {
                        case "status":
                                include_once("./Services/Tracking/classes/class.ilLearningProgressBaseGUI.php");
                                $path = ilLearningProgressBaseGUI::_getImagePathForStatus($value);
                                $text = ilLearningProgressBaseGUI::_getStatusText($value);
                                $value = ilUtil::img($path, $text);
                                break;
                }
                //BLUM round
                if ($id=="launch_data" || $id=="suspend_data") return $value;
                if (is_numeric($value)) return round($value,2);
                return $value;
        }
        protected function fillRow($data)
        {
                global $ilCtrl, $lng;
                foreach ($this->getSelectedColumns() as $c)
                {
                        $this->tpl->setCurrentBlock("user_field");
                        $val = $this->parseValue($c, $data[$c], "scormtrac");
                        $this->tpl->setVariable("VAL_UF", $val);
                        $this->tpl->parseCurrentBlock();
                }
                
        }

        protected function fillHeaderExcel(ilExcel $worksheet, &$a_row)
        {
                $labels = $this->getSelectableColumns();
                $cnt = 0;
                foreach ($this->getSelectedColumns() as $c)
                {
                        $worksheet->setCell($a_row, $cnt, $labels[$c]["txt"]);
                        $cnt++;
                }
        }

        protected function fillRowExcel(ilExcel $worksheet, &$a_row, $a_set)
        {
                global $lng;
                $lng->loadLanguageModule("trac");
                include_once("./Services/Tracking/classes/class.ilLearningProgressBaseGUI.php");
                $cnt = 0;
                foreach ($this->getSelectedColumns() as $c)
                {
                        if($c != 'status')
                        {
                                $val = $this->parseValue($c, $a_set[$c], "user");
                        }
                        else
                        {
                                $val = ilLearningProgressBaseGUI::_getStatusText((int)$a_set[$c]);
                        }
                        $worksheet->setCell($a_row, $cnt, $val);
                        $cnt++;
                }
        }

        protected function fillHeaderCSV($a_csv)
        {
                $labels = $this->getSelectableColumns();
                foreach ($this->getSelectedColumns() as $c)
                {
                        $a_csv->addColumn($labels[$c]["txt"]);
                }

                $a_csv->addRow();
        }

        protected function fillRowCSV($a_csv, $a_set)
        {
                global $lng;
                $lng->loadLanguageModule("trac");
                include_once("./Services/Tracking/classes/class.ilLearningProgressBaseGUI.php");
                foreach ($this->getSelectedColumns() as $c)
                {
                        if($c != 'status')
                        {
                                $val = $this->parseValue($c, $a_set[$c], "user");
                        }
                        else
                        {
                                $val = ilLearningProgressBaseGUI::_getStatusText((int)$a_set[$c]);
                        }
                        $a_csv->addColumn($val);
                }
                
                $a_csv->addRow();
        }

}
?>