class.ilLPCronObjectStatistics.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once "Services/Cron/classes/class.ilCronJob.php";
 
class ilLPCronObjectStatistics extends ilCronJob
{               
        protected $date; // [string]
        
        public function getId()
        {
                return "lp_object_statistics";
        }
        
        public function getTitle()
        {
                global $lng;
                
                $lng->loadLanguageModule("trac");
                return $lng->txt("trac_object_statistics");
        }
        
        public function getDescription()
        {
                global $lng;
                
                $lng->loadLanguageModule("trac");
                return $lng->txt("trac_object_statistics_info");
        }
        
        public function getDefaultScheduleType()
        {
                return self::SCHEDULE_TYPE_DAILY;
        }
        
        public function getDefaultScheduleValue()
        {
                return;
        }
        
        public function hasAutoActivation()
        {
                return true;
        }
        
        public function hasFlexibleSchedule()
        {
                return false;
        }
        
        public function run()
        {               
                // all date related operations are based on this timestamp
                // should be midnight of yesterday (see gatherUserData()) to always have full day
                $this->date = strtotime("yesterday");
                
                $status = ilCronJobResult::STATUS_NO_ACTION;
                $message = array();
                
                $count = 0;
                $count += $this->gatherCourseLPData();
                $count += $this->gatherTypesData();
                $count += $this->gatherUserData();      
                
                if($count)
                {
                        $status = ilCronJobResult::STATUS_OK;
                }
                
                $result = new ilCronJobResult();
                $result->setStatus($status);
                
                return $result;
        }       
        
        protected function gatherCourseLPData()
        {
                global $tree, $ilDB;
                
                $count = 0;
                                
                // process all courses
                $all_courses = array_keys(ilObject::_getObjectsByType("crs"));  
                if($all_courses)
                {
                        // gather objects in trash
                        $trashed_objects = $tree->getSavedNodeObjIds($all_courses);
                        
                        include_once 'Services/Object/classes/class.ilObjectLP.php';
                        include_once "Modules/Course/classes/class.ilCourseParticipants.php";
                        include_once "Services/Tracking/classes/class.ilLPStatusWrapper.php";                           
                        foreach($all_courses as $crs_id)
                        {                               
                                // trashed objects will not change
                                if(!in_array($crs_id, $trashed_objects))
                                {
                                        // only if LP is active
                                        $olp = ilObjectLP::getInstance($crs_id);                                                                                
                                        if(!$olp->isActive())
                                        {
                                                continue;
                                        }
                                                                        
                                        // only save once per day
                                        $ilDB->manipulate("DELETE FROM obj_lp_stat WHERE".
                                                " obj_id = ".$ilDB->quote($crs_id, "integer").
                                                " AND fulldate = ".$ilDB->quote(date("Ymd", $this->date), "integer"));
                                        
                                        $members = new ilCourseParticipants($crs_id);
                                        $members = $members->getMembers();      
                                        
                                        $in_progress = count(ilLPStatusWrapper::_lookupInProgressForObject($crs_id, $members));
                                        $completed = count(ilLPStatusWrapper::_lookupCompletedForObject($crs_id, $members));
                                        $failed = count(ilLPStatusWrapper::_lookupFailedForObject($crs_id, $members));
                                        
                                        // calculate with other values - there is not direct method
                                        $not_attempted = count($members) - $in_progress - $completed - $failed;
                                        
                                        $set = array(
                                                "type" => array("text", "crs"),
                                                "obj_id" => array("integer", $crs_id),
                                                "yyyy" => array("integer", date("Y", $this->date)),
                                                "mm" => array("integer", date("m", $this->date)),
                                                "dd" => array("integer", date("d", $this->date)),
                                                "fulldate" => array("integer", date("Ymd", $this->date)),
                                                "mem_cnt" => array("integer", count($members)),
                                                "in_progress" => array("integer", $in_progress),
                                                "completed" => array("integer", $completed),
                                                "failed" => array("integer", $failed),
                                                "not_attempted" => array("integer", $not_attempted)                                                                                             
                                                );      
                                        
                                        $ilDB->insert("obj_lp_stat", $set);
                                        
                                        $count++;
                                        
                                        // #17928
                                        ilCronManager::ping($this->getId());
                                }                                               
                        }
                }
                
                return $count;
        }
        
        protected function gatherTypesData()
        {
                global $ilDB;
                
                $count = 0;
                
                include_once "Services/Tracking/classes/class.ilTrQuery.php";
                $data = ilTrQuery::getObjectTypeStatistics();           
                foreach($data as $type => $item)
                {                       
                        // only save once per day
                        $ilDB->manipulate("DELETE FROM obj_type_stat WHERE".
                                " type = ".$ilDB->quote($type, "text").
                                " AND fulldate = ".$ilDB->quote(date("Ymd", $this->date), "integer"));
                        
                        $set = array(
                                "type" => array("text", $type),
                                "yyyy" => array("integer", date("Y", $this->date)),
                                "mm" => array("integer", date("m", $this->date)),
                                "dd" => array("integer", date("d", $this->date)),
                                "fulldate" => array("integer", date("Ymd", $this->date)),
                                "cnt_references" => array("integer", (int)$item["references"]),
                                "cnt_objects" => array("integer", (int)$item["objects"]),
                                "cnt_deleted" => array("integer", (int)$item["deleted"])                                                                                
                                );      
 
                        $ilDB->insert("obj_type_stat", $set);
                        
                        $count++;
                        
                        // #17928
                        ilCronManager::ping($this->getId());
                }
                
                return $count;
        }
        
        protected function gatherUserData()
        {
                global $ilDB;
                
                $count = 0;
                
                $to = mktime(23, 59, 59, date("m", $this->date), date("d", $this->date), date("Y", $this->date));
                                        
                $sql = "SELECT COUNT(DISTINCT(usr_id)) counter,obj_id FROM read_event".
                        " WHERE last_access >= ".$ilDB->quote($this->date, "integer").
                        " AND last_access <= ".$ilDB->quote($to, "integer").
                        " GROUP BY obj_id";
                $set = $ilDB->query($sql);
                while($row = $ilDB->fetchAssoc($set))
                {               
                        // only save once per day
                        $ilDB->manipulate("DELETE FROM obj_user_stat".
                                " WHERE fulldate = ".$ilDB->quote(date("Ymd", $this->date), "integer").
                                " AND obj_id = ".$ilDB->quote($row["obj_id"], "integer"));
 
                        $iset = array(
                                "obj_id" => array("integer", $row["obj_id"]),
                                "yyyy" => array("integer", date("Y", $this->date)),
                                "mm" => array("integer", date("m", $this->date)),
                                "dd" => array("integer", date("d", $this->date)),
                                "fulldate" => array("integer", date("Ymd", $this->date)),       
                                "counter" => array("integer", $row["counter"])
                                );      
 
                        $ilDB->insert("obj_user_stat", $iset);  
                        
                        $count++;
                        
                        // #17928
                        ilCronManager::ping($this->getId());
                }
                
                return $count;
        }
}
 
?>