da/de5/class_8ilLPObjectStatisticsTableGUI_8php_source.html

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

 include_once("./Services/Tracking/classes/class.ilLPTableBaseGUI.php");

 class ilLPObjectStatisticsTableGUI extends ilLPTableBaseGUI
 {
         function __construct($a_parent_obj, $a_parent_cmd, array $a_preselect = null, $a_load_items = true)
         {
                 global $ilCtrl, $lng;

                 $this->preselected = $a_preselect;

                 $this->setId("lpobjstattbl");

                 parent::__construct($a_parent_obj, $a_parent_cmd);

                 $this->setShowRowsSelector(true);
                 // $this->setLimit(ilSearchSettings::getInstance()->getMaxHits());
                 $this->initFilter();

                 $this->addColumn("", "", "1", true);
                 $this->addColumn($lng->txt("trac_title"), "title");
                 $this->addColumn($lng->txt("object_id"), "obj_id");
                 if(strpos($this->filter["yearmonth"], "-") === false)
                 {
                         foreach($this->getMonthsYear($this->filter["yearmonth"]) as $num => $caption)
                         {
                                 $this->addColumn($caption, "month_".$num, "", false, "ilRight");
                         }
                 }
                 $this->addColumn($lng->txt("total"), "total", "", false, "ilRight");

                 $this->setTitle($this->lng->txt("trac_object_stat_access"));

                 // $this->setSelectAllCheckbox("item_id");
                 $this->addMultiCommand("showAccessGraph", $lng->txt("trac_show_graph"));
                 $this->setResetCommand("resetAccessFilter");
                 $this->setFilterCommand("applyAccessFilter");

                 $this->setFormAction($ilCtrl->getFormAction($a_parent_obj, $a_parent_cmd));
                 $this->setRowTemplate("tpl.lp_object_statistics_row.html", "Services/Tracking");
                 $this->setEnableHeader(true);
                 $this->setEnableNumInfo(true);
                 $this->setEnableTitle(true);
                 $this->setDefaultOrderField("title");
                 $this->setDefaultOrderDirection("asc");

                 $this->setExportFormats(array(self::EXPORT_EXCEL, self::EXPORT_CSV));

                 if($a_load_items)
                 {
                         $this->getItems();
                 }
         }

         public function numericOrdering($a_field)
         {
                 if($a_field != "title")
                 {
                         return true;
                 }
                 return false;
         }

         public function initFilter()
         {
                 global $lng;

                 $this->setDisableFilterHiding(true);

                 // object type selection
                 include_once("./Services/Form/classes/class.ilSelectInputGUI.php");
                 $si = new ilSelectInputGUI($lng->txt("obj_type"), "type");
                 $si->setOptions($this->getPossibleTypes(true, false, true));
                 $this->addFilterItem($si);
                 $si->readFromSession();
                 if(!$si->getValue())
                 {
                         $si->setValue("crs");
                 }
                 $this->filter["type"] = $si->getValue();

                 // title/description
                 include_once("./Services/Form/classes/class.ilTextInputGUI.php");
                 $ti = new ilTextInputGUI($lng->txt("trac_title_description"), "query");
                 $ti->setMaxLength(64);
                 $ti->setSize(20);
                 $this->addFilterItem($ti);
                 $ti->readFromSession();
                 $this->filter["query"] = $ti->getValue();

                 // read_count/spent_seconds
                 $si = new ilSelectInputGUI($lng->txt("trac_figure"), "figure");
                 $si->setOptions(array("read_count"=>$lng->txt("trac_read_count"),
                         "spent_seconds"=>$lng->txt("trac_spent_seconds"),
                         "users"=>$lng->txt("users")));
                 $this->addFilterItem($si);
                 $si->readFromSession();
                 if(!$si->getValue())
                 {
                         $si->setValue("read_count");
                 }
                 $this->filter["measure"] = $si->getValue();

                 // year/month
                 $si = new ilSelectInputGUI($lng->txt("year")." / ".$lng->txt("month"), "yearmonth");
                 $si->setOptions($this->getMonthsFilter());
                 $this->addFilterItem($si);
                 $si->readFromSession();
                 if(!$si->getValue())
                 {
                         $si->setValue(date("Y-m"));
                 }
                 $this->filter["yearmonth"] = $si->getValue();
         }

         function getItems()
         {
                 $data = array();

                 $objects = $this->searchObjects(
                         $this->getCurrentFilter(true),
                         "read",
                         null,
                         false
                 );
                 if($objects)
                 {
                         include_once "Services/Tracking/classes/class.ilTrQuery.php";

                         $yearmonth = explode("-", $this->filter["yearmonth"]);
                         if(sizeof($yearmonth) == 1)
                         {
                                 foreach(ilTrQuery::getObjectAccessStatistics($objects, $yearmonth[0]) as $obj_id => $months)
                                 {
                                         $data[$obj_id]["obj_id"] = $obj_id;
                                         $data[$obj_id]["title"] = ilObject::_lookupTitle($obj_id);

                                         foreach($months as $month => $values)
                                         {
                                                 $idx = $yearmonth[0]."-".str_pad($month, 2, "0", STR_PAD_LEFT);
                                                 $data[$obj_id]["month_".$idx] = (int)$values[$this->filter["measure"]];
                                                 $data[$obj_id]["total"] += (int)$values[$this->filter["measure"]];
                                         }
                                 }
                         }
                         else
                         {
                                 foreach(ilTrQuery::getObjectAccessStatistics($objects, $yearmonth[0], (int)$yearmonth[1]) as $obj_id => $days)
                                 {
                                         $data[$obj_id]["obj_id"] = $obj_id;
                                         $data[$obj_id]["title"] = ilObject::_lookupTitle($obj_id);

                                         foreach($days as $day => $values)
                                         {
                                                 $data[$obj_id]["day_".$day] = (int)$values[$this->filter["measure"]];
                                                 $data[$obj_id]["total"] += (int)$values[$this->filter["measure"]];
                                         }
                                 }
                         }

                         // add objects with no usage data
                         foreach(array_keys($objects) as $obj_id)
                         {
                                 if(!isset($data[$obj_id]))
                                 {
                                         $data[$obj_id]["obj_id"] = $obj_id;
                                         $data[$obj_id]["title"] = ilObject::_lookupTitle($obj_id);
                                 }
                         }
                 }

                 $this->setData($data);
         }

         protected function fillRow($a_set)
         {
                 global $ilCtrl;

                 $type = ilObject::_lookupType($a_set["obj_id"]);

                 $this->tpl->setVariable("OBJ_ID", $a_set["obj_id"]);
                 $this->tpl->setVariable("ICON_SRC", ilObject::_getIcon("", "tiny", $type));
                 $this->tpl->setVariable("ICON_ALT", $this->lng->txt($type));
                 $this->tpl->setVariable("TITLE_TEXT", $a_set["title"]);

                 if($this->preselected && in_array($a_set["obj_id"], $this->preselected))
                 {
                         $this->tpl->setVariable("CHECKBOX_STATE", " checked=\"checked\"");
                 }

                 $sum = 0;
                 if(strpos($this->filter["yearmonth"], "-") === false)
                 {
                         $this->tpl->setCurrentBlock("month");
                         foreach(array_keys($this->getMonthsYear($this->filter["yearmonth"])) as $num)
                         {
                                 $value = (int)$a_set["month_".$num];
                                 if($this->filter["measure"] != "spent_seconds")
                                 {
                                         $value = $this->anonymizeValue($value);
                                 }
                                 else
                                 {
                                         $value = $this->formatSeconds($value, true);
                                 }
                                 $this->tpl->setVariable("MONTH_VALUE", $value);
                                 $this->tpl->parseCurrentBlock();
                         }
                 }

                 if($this->filter["measure"] == "spent_seconds")
                 {
                         $sum = $this->formatSeconds((int)$a_set["total"], true);
                 }
                 else
                 {
                         $sum = $this->anonymizeValue((int)$a_set["total"]);
                 }
                 $this->tpl->setVariable("TOTAL", $sum);
         }

         function getGraph(array $a_graph_items)
         {
                 global $lng;

                 include_once "Services/Chart/classes/class.ilChart.php";
                 $chart = ilChart::getInstanceByType(ilChart::TYPE_GRID, "objstacc");
                 $chart->setSize(700, 500);

                 $legend = new ilChartLegend();
                 $chart->setLegend($legend);

                 $max_value = 0;
                 foreach($this->getData() as $object)
                 {
                         if(in_array($object["obj_id"], $a_graph_items))
                         {
                                 $series = $chart->getDataInstance(ilChartGrid::DATA_LINES);
                                 $series->setLabel(ilObject::_lookupTitle($object["obj_id"]));

                                 if(strpos($this->filter["yearmonth"], "-") === false)
                                 {
                                         foreach(array_keys($this->getMonthsYear($this->filter["yearmonth"])) as $idx => $num)
                                         {
                                                 $value = (int)$object["month_".$num];
                                                 $max_value = max($max_value, $value);
                                                 if($this->filter["measure"] != "spent_seconds")
                                                 {
                                                         $value = $this->anonymizeValue($value, true);
                                                 }
                                                 $series->addPoint($idx, $value);
                                         }
                                 }
                                 else
                                 {
                                         for($loop = 1; $loop<32; $loop++)
                                         {
                                                 $value = (int)$object["day_".$loop];
                                                 $max_value = max($max_value, $value);
                                                 if($this->filter["measure"] != "spent_seconds")
                                                 {
                                                         $value = $this->anonymizeValue($value, true);
                                                 }
                                                 $series->addPoint($loop, $value);
                                         }
                                 }

                                 $chart->addData($series);
                         }
                 }

                 $value_ticks = $this->buildValueScale($max_value, ($this->filter["measure"] != "spent_seconds"),
                         ($this->filter["measure"] == "spent_seconds"));

                 $labels = array();
                 if(strpos($this->filter["yearmonth"], "-") === false)
                 {
                         foreach(array_values($this->getMonthsYear($this->filter["yearmonth"], true)) as $idx => $caption)
                         {
                                 $labels[$idx] = $caption;
                         }
                 }
                 else
                 {
                         for($loop = 1; $loop<32; $loop++)
                         {
                                 $labels[$loop] = $loop.".";
                         }
                 }
                 $chart->setTicks($labels, $value_ticks, true);

                 return $chart->getHTML();
         }

         protected function fillMetaExcel()
         {

         }

         protected function fillRowExcel($a_worksheet, &$a_row, $a_set)
         {
                 $a_worksheet->write($a_row, 0, ilObject::_lookupTitle($a_set["obj_id"]));
                 $a_worksheet->write($a_row, 1, $a_set["obj_id"]);

                 $col = 1;
                 if(strpos($this->filter["yearmonth"], "-") === false)
                 {
                         foreach(array_keys($this->getMonthsYear($this->filter["yearmonth"])) as $num)
                         {
                                 $value = (int)$a_set["month_".$num];
                                 if($this->filter["measure"] != "spent_seconds")
                                 {
                                         $value = $this->anonymizeValue($value);
                                 }

                                 $col++;
                                 $a_worksheet->write($a_row, $col, $value);
                         }
                 }

                 if($this->filter["measure"] == "spent_seconds")
                 {
                         // keep seconds
                         // $sum = $this->formatSeconds((int)$a_set["total"]);
                         $sum = (int)$a_set["total"];
                 }
                 else
                 {
                         $sum = $this->anonymizeValue((int)$a_set["total"]);
                 }
                 $col++;
                 $a_worksheet->write($a_row, $col, $sum);
         }

         protected function fillMetaCSV()
         {

         }

         protected function fillRowCSV($a_csv, $a_set)
         {
                 $a_csv->addColumn(ilObject::_lookupTitle($a_set["obj_id"]));
                 $a_csv->addColumn($a_set["obj_id"]);

                 if(strpos($this->filter["yearmonth"], "-") === false)
                 {
                         foreach(array_keys($this->getMonthsYear($this->filter["yearmonth"])) as $num)
                         {
                                 $value = (int)$a_set["month_".$num];
                                 if($this->filter["measure"] != "spent_seconds")
                                 {
                                         $value = $this->anonymizeValue($value);
                                 }

                                 $a_csv->addColumn($value);
                         }
                 }

                 if($this->filter["measure"] == "spent_seconds")
                 {
                         // keep seconds
                         // $sum = $this->formatSeconds((int)$a_set["total"]);
                         $sum = (int)$a_set["total"];
                 }
                 else
                 {
                         $sum = $this->anonymizeValue((int)$a_set["total"]);
                 }
                 $a_csv->addColumn($sum);

                 $a_csv->addRow();
         }
 }

 ?>
ilLPObjectStatisticsTableGUI\fillRow
fillRow($a_set)
Fill table row.
Definition: class.ilLPObjectStatisticsTableGUI.php:195

ilLPTableBaseGUI\anonymizeValue
anonymizeValue($a_value, $a_force_number=false)
Definition: class.ilLPTableBaseGUI.php:796

ilObject\_getIcon
static _getIcon($a_obj_id="", $a_size="big", $a_type="", $a_offline=false)
Get icon for repository item.
Definition: class.ilObject.php:1900

ilTable2GUI\setDefaultOrderField
setDefaultOrderField($a_defaultorderfield)
Set Default order field.
Definition: class.ilTable2GUI.php:1136

ilTable2GUI\setExportFormats
setExportFormats(array $formats)
Set available export formats.
Definition: class.ilTable2GUI.php:3119

ilSelectInputGUI
This class represents a selection list property in a property form.
Definition: class.ilSelectInputGUI.php:17

ilChartLegend
Chart legend.
Definition: class.ilChartLegend.php:11

$legend
$legend
Definition: example_057.php:131

ilTable2GUI\setEnableNumInfo
setEnableNumInfo($a_val)
Set enable num info.
Definition: class.ilTable2GUI.php:490

ilLPTableBaseGUI\getMonthsYear
getMonthsYear($a_year=null, $a_short=false)
Definition: class.ilLPTableBaseGUI.php:884

ilLPTableBaseGUI\searchObjects
searchObjects(array $filter, $permission, array $preset_obj_ids=null, $a_check_lp_activation=true)
Search objects that match current filters.
Definition: class.ilLPTableBaseGUI.php:174

ilTable2GUI\addFilterItem
addFilterItem($a_input_item, $a_optional=false)
Add filter item.
Definition: class.ilTable2GUI.php:611

ilObject\_lookupTitle
static _lookupTitle($a_id)
lookup object title
Definition: class.ilObject.php:944

ilLPObjectStatisticsTableGUI\numericOrdering
numericOrdering($a_field)
Definition: class.ilLPObjectStatisticsTableGUI.php:69

ilLPObjectStatisticsTableGUI
TableGUI class for learning progress.
Definition: class.ilLPObjectStatisticsTableGUI.php:15

ilLPTableBaseGUI\getPossibleTypes
getPossibleTypes($a_split_learning_resources=false, $a_include_digilib=false, $a_allow_undefined_lp=false)
Get possible subtypes.
Definition: class.ilLPTableBaseGUI.php:399

ilTable2GUI\setId
setId($a_val)
Set id.
Definition: class.ilTable2GUI.php:976

$ilCtrl
global $ilCtrl
Definition: ilias.php:18

ilLPObjectStatisticsTableGUI\fillRowCSV
fillRowCSV($a_csv, $a_set)
Definition: class.ilLPObjectStatisticsTableGUI.php:360

ilLPObjectStatisticsTableGUI\fillRowExcel
fillRowExcel($a_worksheet, &$a_row, $a_set)
Definition: class.ilLPObjectStatisticsTableGUI.php:320

ilTable2GUI\setDefaultOrderDirection
setDefaultOrderDirection($a_defaultorderdirection)
Set Default order direction.
Definition: class.ilTable2GUI.php:1156

ilTable2GUI\setTitle
setTitle($a_title, $a_icon=0, $a_icon_alt=0)
Set title and title icon.
Definition: class.ilTable2GUI.php:508

ilLPObjectStatisticsTableGUI\fillMetaCSV
fillMetaCSV()
Definition: class.ilLPObjectStatisticsTableGUI.php:355

ilLPObjectStatisticsTableGUI\fillMetaExcel
fillMetaExcel()
Definition: class.ilLPObjectStatisticsTableGUI.php:315

ilChartGrid\DATA_LINES
const DATA_LINES
Definition: class.ilChartGrid.php:18

ilTable2GUI\setResetCommand
setResetCommand($a_val, $a_caption=null)
Set reset filter command.
Definition: class.ilTable2GUI.php:1083

ilLPTableBaseGUI
TableGUI class for learning progress.
Definition: class.ilLPTableBaseGUI.php:15

ilTrQuery\getObjectAccessStatistics
static getObjectAccessStatistics(array $a_ref_ids, $a_year, $a_month=null)
Definition: class.ilTrQuery.php:1699

ilTable2GUI\setDisableFilterHiding
setDisableFilterHiding($a_val=true)
Set disable filter hiding.
Definition: class.ilTable2GUI.php:812

ilLPTableBaseGUI\buildValueScale
buildValueScale($a_max_value, $a_anonymize=false, $a_format_seconds=false)
Definition: class.ilLPTableBaseGUI.php:820

ilTable2GUI\addMultiCommand
addMultiCommand($a_cmd, $a_text)
Add Command button.
Definition: class.ilTable2GUI.php:1253

ilTable2GUI\setData
setData($a_data)
Definition: class.ilTable2GUI.php:548

ilTextInputGUI
This class represents a text property in a property form.
Definition: class.ilTextInputGUI.php:16

ilTextInputGUI\setMaxLength
setMaxLength($a_maxlength)
Set Max Length.
Definition: class.ilTextInputGUI.php:117

ilTable2GUI\setRowTemplate
setRowTemplate($a_template, $a_template_dir="")
Set row template.
Definition: class.ilTable2GUI.php:1125

ilObject\_lookupType
static _lookupType($a_id, $a_reference=false)
lookup object type
Definition: class.ilObject.php:1196

ilChart\TYPE_GRID
const TYPE_GRID
Definition: class.ilChart.php:24

ilTable2GUI\getData
getData()
Definition: class.ilTable2GUI.php:580

ilTable2GUI\setFormAction
setFormAction($a_form_action, $a_multipart=false)
Set Form action parameter.
Definition: class.ilTable2GUI.php:935

$si
$si
Definition: il_securimage_play.php:7

ilLPTableBaseGUI\getMonthsFilter
getMonthsFilter($a_short=false)
Definition: class.ilLPTableBaseGUI.php:855

ilLPTableBaseGUI\formatSeconds
formatSeconds($seconds, $a_shorten_zero=false)
Definition: class.ilLPTableBaseGUI.php:774

$lng
global $lng
Definition: privfeed.php:40

ilTable2GUI\setShowRowsSelector
setShowRowsSelector($a_value)
Toggle rows-per-page selector.
Definition: class.ilTable2GUI.php:2966

ilTable2GUI\setEnableHeader
setEnableHeader($a_enableheader)
Set Enable Header.
Definition: class.ilTable2GUI.php:470

ilLPTableBaseGUI\getCurrentFilter
getCurrentFilter($as_query=false)
Definition: class.ilLPTableBaseGUI.php:548

ilTableGUI\$data
$data
Definition: class.ilTableGUI.php:32

ilTable2GUI\setEnableTitle
setEnableTitle($a_enabletitle)
Set Enable Title.
Definition: class.ilTable2GUI.php:450

ilLPObjectStatisticsTableGUI\initFilter
initFilter()
Init filter.
Definition: class.ilLPObjectStatisticsTableGUI.php:81

ilLPObjectStatisticsTableGUI\__construct
__construct($a_parent_obj, $a_parent_cmd, array $a_preselect=null, $a_load_items=true)
Constructor.
Definition: class.ilLPObjectStatisticsTableGUI.php:20

ilLPObjectStatisticsTableGUI\getGraph
getGraph(array $a_graph_items)
Definition: class.ilLPObjectStatisticsTableGUI.php:242

ilTable2GUI\addColumn
addColumn($a_text, $a_sort_field="", $a_width="", $a_is_checkbox_action_column=false, $a_class="", $a_tooltip="", $a_tooltip_with_html=false)
Add a column to the header.
Definition: class.ilTable2GUI.php:1308

ilChart\getInstanceByType
static getInstanceByType($a_type, $a_id)
Get type instance.
Definition: class.ilChart.php:48

ilLPObjectStatisticsTableGUI\getItems
getItems()
Definition: class.ilLPObjectStatisticsTableGUI.php:133

ilTable2GUI\setFilterCommand
setFilterCommand($a_val, $a_caption=null)
Set filter command.
Definition: class.ilTable2GUI.php:1061