class.ilUserLPTableGUI.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once("./Services/Table/classes/class.ilTable2GUI.php");
 
class ilUserLPTableGUI extends ilTable2GUI
{
        function __construct($a_parent_obj, $a_parent_cmd, $a_ref_id)
        {
                global $ilCtrl, $lng, $ilAccess, $lng, $rbacsystem;
                
                $this->ref_id = $a_ref_id;
                $this->setId("admusrlp");
                
                parent::__construct($a_parent_obj, $a_parent_cmd);
                // $this->setTitle($this->lng->txt("obj_usr"));
                
                $this->addColumn($this->lng->txt("login"), "login");
                $this->addColumn($this->lng->txt("firstname"), "firstname");
                $this->addColumn($this->lng->txt("lastname"), "lastname");
                $this->addColumn($this->lng->txt("online_time"), "online_time");
                $this->addColumn($this->lng->txt("last_login"), "last_login");
                $this->setExternalSorting(true);
                $this->setExternalSegmentation(true);
        
                $this->setFormAction($ilCtrl->getFormAction($this->parent_obj));
                
                $this->setRowTemplate("tpl.user_list_lp_row.html", "Services/User");
                
                $this->setDefaultOrderField("login");
                $this->setDefaultOrderDirection("asc");
                
                $this->setExportFormats(array(self::EXPORT_EXCEL));
 
                $this->getItems();
        }
        
        function getItems()
        {
                $this->determineOffsetAndOrder();
                        
                include_once("./Services/User/classes/class.ilUserQuery.php");
                $usr_data = ilUserQuery::getUserListData(
                        ilUtil::stripSlashes($this->getOrderField()),
                        ilUtil::stripSlashes($this->getOrderDirection()),
                        ilUtil::stripSlashes($this->getOffset()),
                        ilUtil::stripSlashes($this->getLimit()),
                        null,
                        null,
                        null,
                        null,
                        null,
                        null,
                        null,
                        null,
                        array("online_time"),
                        null,
                        null
                        );
                        
                if (count($usr_data["set"]) == 0 && $this->getOffset() > 0)
                {
                        $this->resetOffset();
                        $usr_data = ilUserQuery::getUserListData(
                                ilUtil::stripSlashes($this->getOrderField()),
                                ilUtil::stripSlashes($this->getOrderDirection()),
                                ilUtil::stripSlashes($this->getOffset()),
                                ilUtil::stripSlashes($this->getLimit()),
                                null,
                                null,
                                null,
                                null,
                                null,
                                null,
                                null,
                                null,
                                array("online_time"),
                                null,
                                null
                                );
                }
 
                $this->setMaxCount($usr_data["cnt"]);
                $this->setData($usr_data["set"]);
                
                include_once 'Services/Tracking/classes/class.ilObjUserTracking.php';
                $this->lp_active = ilObjUserTracking::_enabledLearningProgress();
        }
        
        protected function fillRow($user)
        {
                global $ilCtrl;
                
                if ($this->lp_active)
                {
                        $ilCtrl->setParameterByClass("illearningprogressgui", "ref_id", $this->ref_id);
                        $ilCtrl->setParameterByClass("illearningprogressgui", "obj_id", $user["usr_id"]);
                        $link = $ilCtrl->getLinkTargetByClass(array("ilobjusergui",'illearningprogressgui'), "");
 
                        $this->tpl->setCurrentBlock("login_link");
                        $this->tpl->setVariable("HREF_LOGIN", $link);
                        $this->tpl->setVariable("VAL_LOGIN", $user["login"]);
                        $this->tpl->parseCurrentBlock();
 
                }
                else
                {
                        $this->tpl->setCurrentBlock("login_plain");
                        $this->tpl->setVariable("VAL_LOGIN_PLAIN", $user["login"]);
                        $this->tpl->parseCurrentBlock();
                }
                
                $this->tpl->setVariable("VAL_FIRSTNAME", $user["firstname"]);
                $this->tpl->setVariable("VAL_LASTNAME", $user["lastname"]);
                $this->tpl->setVariable("VAL_ONLINE_TIME",
                        self::secondsToShortString($user["online_time"]));
                $this->tpl->setVariable("VAL_LAST_LOGIN", 
                        ilDatePresentation::formatDate(new ilDateTime($user["last_login"], IL_CAL_DATETIME)));          
        }
        
        protected function fillRowExcel(ilExcel $a_excel, &$a_row, $a_set)
        {
                $a_excel->setCell($a_row, 0, $a_set["login"]);
                $a_excel->setCell($a_row, 1, $a_set["firstname"]);
                $a_excel->setCell($a_row, 2, $a_set["lastname"]);
                $a_excel->setCell($a_row, 3, 
                        self::secondsToShortString($a_set["online_time"]));
                $a_excel->setCell($a_row, 4, new ilDateTime($a_set["last_login"], IL_CAL_DATETIME));            
        }
        
        protected static function secondsToShortString($seconds)
        {
                global $lng;
 
                $seconds = $seconds ? $seconds : 0;
 
                global $lng;
 
                $days = floor($seconds / 86400);
                $rest = $seconds % 86400;
 
                $hours = floor($rest / 3600);
                $rest = $rest % 3600;
 
                $minutes = floor($rest / 60);
                $rest = $rest % 60;
 
                return sprintf("%02d:%02d:%02d:%02d",$days,$hours,$minutes,$rest);
 
        }
}
 
?>