class.ilLPStatusCollectionManual.php

Go to the documentation of this file.

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

include_once './Services/Tracking/classes/class.ilLPStatus.php';

class ilLPStatusCollectionManual extends ilLPStatus
{
    public static function _getInProgress($a_obj_id)
    {
        $status_info = ilLPStatusWrapper::_getStatusInfo($a_obj_id);
        
        // find any completed item
        $users = array();
        if (is_array($status_info['completed'])) {
            foreach ($status_info['completed'] as $in_progress) {
                $users = array_merge($users, $in_progress);
            }
            $users = array_unique($users);
        }
        
        // remove all users which have completed ALL items
        $users = array_diff($users, ilLPStatusWrapper::_getCompleted($a_obj_id));
        
        return $users;
    }
    
    public static function _getCompleted($a_obj_id)
    {
        $status_info = ilLPStatusWrapper::_getStatusInfo($a_obj_id);

        $counter = 0;
        $users = array();
        foreach ($status_info['items'] as $item_id) {
            $tmp_users = $status_info['completed'][$item_id];

            if (!$counter++) {
                $users = $tmp_users;
            } else {
                $users = array_intersect($users, $tmp_users);
            }
        }
        $users = array_unique($users);
        
        return $users;
    }
    
    public static function _getStatusInfo($a_obj_id)
    {
        $status_info = array();
                                        
        include_once "Services/Object/classes/class.ilObjectLP.php";
        $olp = ilObjectLP::getInstance($a_obj_id);
        $collection = $olp->getCollectionInstance();
        if ($collection) {
            $status_info["items"] = $collection->getItems($a_obj_id);
                        
            foreach ($status_info["items"] as $item_id) {
                $status_info["completed"][$item_id] = array();
            }
            
            $ref_ids = ilObject::_getAllReferences($a_obj_id);
            $ref_id = end($ref_ids);
            $possible_items = $collection->getPossibleItems($ref_id);
            $chapter_ids = array_intersect(
                array_keys($possible_items),
                $status_info["items"]
            );

            // fix order (adapt from possible items)
            $status_info["items"] = $chapter_ids;

            if ($chapter_ids) {
                $status = self::_getObjectStatus($a_obj_id);

                foreach ($chapter_ids as $item_id) {
                    $status_info["item_titles"][$item_id] = $possible_items[$item_id]["title"];

                    if (isset($status[$item_id])) {
                        foreach ($status[$item_id] as $user_id => $user_status) {
                            if ($user_status) {
                                $status_info["completed"][$item_id][] = $user_id;
                            }
                        }
                    }
                }
            }
        }
        
        return $status_info;
    }
    
    public function determineStatus($a_obj_id, $a_user_id, $a_obj = null)
    {
        $info = self::_getStatusInfo($a_obj_id);
                    
        if (is_array($info["completed"])) {
            $completed = true;
            $in_progress = false;
            foreach ($info["completed"] as $user_ids) {
                // has completed at least 1 item
                if (in_array($a_user_id, $user_ids)) {
                    $in_progress = true;
                }
                // must have completed all items to complete collection
                else {
                    $completed = false;
                }
            }
            if ($completed) {
                return self::LP_STATUS_COMPLETED_NUM;
            }
            if ($in_progress) {
                return self::LP_STATUS_IN_PROGRESS_NUM;
            }
        }
        
        return self::LP_STATUS_NOT_ATTEMPTED_NUM;
    }
    
    public static function _getObjectStatus($a_obj_id, $a_user_id = null)
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $res = array();
        
        $sql = "SELECT subitem_id, completed, usr_id, last_change" .
            " FROM ut_lp_coll_manual" .
            " WHERE obj_id = " . $ilDB->quote($a_obj_id, "integer");
        if ($a_user_id) {
            $sql .= " AND usr_id = " . $ilDB->quote($a_user_id, "integer");
        }
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            if (!$a_user_id) {
                $res[$row["subitem_id"]][$row["usr_id"]] = $row["completed"];
            } else {
                $res[$row["subitem_id"]] = array($row["completed"], $row["last_change"]);
            }
        }
        
        return $res;
    }
    
    public static function _setObjectStatus($a_obj_id, $a_user_id, array $a_completed = null)
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $now = time();
        
        if (!$a_completed) {
            $a_completed = array();
        }
        
        include_once './Services/Object/classes/class.ilObjectLP.php';
        $olp = ilObjectLP::getInstance($a_obj_id);
        $collection = $olp->getCollectionInstance();
        if ($collection) {
            $existing = self::_getObjectStatus($a_obj_id, $a_user_id);
            
            foreach ($collection->getItems() as $item_id) {
                if (isset($existing[$item_id])) {
                    // value changed
                    if ((!$existing[$item_id][0] && in_array($item_id, $a_completed)) ||
                        ($existing[$item_id][0] && !in_array($item_id, $a_completed))) {
                        $ilDB->manipulate("UPDATE ut_lp_coll_manual SET " .
                            " completed = " . $ilDB->quote(in_array($item_id, $a_completed), "integer") .
                            " , last_change = " . $ilDB->quote($now, "integer") .
                            " WHERE obj_id = " . $ilDB->quote($a_obj_id, "integer") .
                            " AND usr_id = " . $ilDB->quote($a_user_id, "integer") .
                            " AND subitem_id = " . $ilDB->quote($item_id, "integer"));
                    }
                } elseif (in_array($item_id, $a_completed)) {
                    $ilDB->manipulate("INSERT INTO ut_lp_coll_manual" .
                        "(obj_id,usr_id,subitem_id,completed,last_change)" .
                        " VALUES (" . $ilDB->quote($a_obj_id, "integer") .
                        " , " . $ilDB->quote($a_user_id, "integer") .
                        " , " . $ilDB->quote($item_id, "integer") .
                        " , " . $ilDB->quote(1, "integer") .
                        " , " . $ilDB->quote($now, "integer") . ")");
                }
            }
        }
        
        include_once "Services/Tracking/classes/class.ilLPStatusWrapper.php";
        ilLPStatusWrapper::_updateStatus($a_obj_id, $a_user_id);
    }
}