ilObjSCORMTracking Class Reference

Class ilObjSCORMTracking. More...

Collaboration diagram for ilObjSCORMTracking:

Static Public Member Functions
static	storeJsApi ()
static	storeJsApiCmi (int $user_id, int $obj_id, object $data)
static	syncGlobalStatus (int $userId, int $packageId, int $refId, object $data, ?int $new_global_status)
static	_insertTrackData (int $a_sahs_id, string $a_lval, string $a_rval, int $a_obj_id)
static	_getCompleted (object $scorm_item_id, int $a_obj_id)
	like necessary because of Oracle More...
static	_getCollectionStatus (?array $a_scos, int $a_obj_id, int $a_user_id)
static	_countCompleted (?array $a_scos, int $a_obj_id, int $a_user_id)
static	lookupLastAccessTimes (int $a_obj_id)
	Lookup last acccess time for all users of a scorm module. More...
static	_getTrackedUsers (int $a_obj_id)
	Get all tracked users. More...
static	_getFailed (object $scorm_item_id, int $a_obj_id)
	like necessary because of Oracle More...
static	_getCountCompletedPerUser (array $a_scorm_item_ids, int $a_obj_id)
	Get users who have status completed or passed. More...
static	_getProgressInfo (array $sco_item_ids, int $a_obj_id)
	Get info about. More...
static	_getInProgress (array|int $scorm_item_id, int $a_obj_id, ?array $a_blocked_user_ids=null)
static	scorm12PlayerUnload ()
static	checkIfAllowed (int $packageId, int $userId, int $hash)
static	_syncReadEvent (int $a_obj_id, int $a_user_id, string $a_type, int $a_ref_id)

Detailed Description

Class ilObjSCORMTracking.

Author

Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e \

Definition at line 26 of file class.ilObjSCORMTracking.php.

Member Function Documentation

_countCompleted()

static ilObjSCORMTracking::_countCompleted ( ?array  $a_scos, int  $a_obj_id, int  $a_user_id  )

static

Definition at line 345 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, and $res.

Referenced by ilLPStatusSCORM\determinePercentage().

                                                                                         : int
    {
        global $DIC;
        $ilDB = $DIC->database();
        $cnt = 0;

        if (is_array($a_scos)) {
            $in = $ilDB->in('sco_id', $a_scos, false, 'integer');

            $res = $ilDB->queryF(
                'SELECT sco_id, rvalue FROM scorm_tracking 
                        WHERE ' . $in . '
                        AND obj_id = %s
                        AND lvalue = %s
                        AND user_id = %s',
                array('integer', 'text', 'integer'),
                array($a_obj_id, 'cmi.core.lesson_status', $a_user_id)
            );

            while ($rec = $ilDB->fetchAssoc($res)) {
                if ($rec["rvalue"] === "completed" || $rec["rvalue"] === "passed") {
                    $cnt++;
                }
            }
        }
        return $cnt;
    }

Here is the caller graph for this function:

_getCollectionStatus()

static ilObjSCORMTracking::_getCollectionStatus ( ?array  $a_scos, int  $a_obj_id, int  $a_user_id  )

static

Definition at line 300 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, and $res.

Referenced by ilLPStatusSCORM\determineStatus().

                                                                                              : string
    {
        global $DIC;
        $ilDB = $DIC->database();

        $status = "not_attempted";

        if (is_array($a_scos)) {
            $in = $ilDB->in('sco_id', $a_scos, false, 'integer');

            $res = $ilDB->queryF(
                'SELECT sco_id, rvalue FROM scorm_tracking 
                        WHERE ' . $in . '
                        AND obj_id = %s
                        AND lvalue = %s
                        AND user_id = %s',
                array('integer', 'text', 'integer'),
                array($a_obj_id, 'cmi.core.lesson_status', $a_user_id)
            );

            $cnt = 0;
            $completed = true;
            $failed = false;
            while ($rec = $ilDB->fetchAssoc($res)) {
                if ($rec["rvalue"] === "failed") {
                    $failed = true;
                }
                if ($rec["rvalue"] !== "completed" && $rec["rvalue"] !== "passed") {
                    $completed = false;
                }
                $cnt++;
            }
            if ($cnt > 0) {
                $status = "in_progress";
            }
            if ($completed && $cnt == count($a_scos)) {
                $status = "completed";
            }
            if ($failed) {
                $status = "failed";
            }
        }
        return $status;
    }

Here is the caller graph for this function:

_getCompleted()

static ilObjSCORMTracking::_getCompleted ( object  $scorm_item_id, int  $a_obj_id  )

static

like necessary because of Oracle

Definition at line 255 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, and $res.

                                                                              : array
    {
        global $DIC;
        $ilDB = $DIC->database();

        $user_ids = [];

        if (is_array($scorm_item_id)) {
            $in = $ilDB->in('sco_id', $scorm_item_id, false, 'integer');

            $res = $ilDB->queryF(
                'SELECT DISTINCT(user_id) FROM scorm_tracking 
                        WHERE ' . $in . '
                        AND obj_id = %s
                        AND lvalue = %s 
                        AND (' . $ilDB->like('rvalue', 'clob', 'completed') . ' OR ' . $ilDB->like(
                    'rvalue',
                    'clob',
                    'passed'
                ) . ')',
                array('integer', 'text'),
                array($a_obj_id, 'cmi.core.lesson_status')
            );
        } else {
            $res = $ilDB->queryF(
                'SELECT DISTINCT(user_id) FROM scorm_tracking 
                        WHERE sco_id = %s
                        AND obj_id = %s
                        AND lvalue = %s 
                        AND (' . $ilDB->like('rvalue', 'clob', 'completed') . ' OR ' . $ilDB->like(
                    'rvalue',
                    'clob',
                    'passed'
                ) . ')',
                array('integer', 'integer', 'text'),
                array($scorm_item_id, $a_obj_id, 'cmi.core.lesson_status')
            );
        }

        while ($row = $ilDB->fetchObject($res)) {
            $user_ids[] = $row->user_id;
        }
        return $user_ids;
    }

_getCountCompletedPerUser()

static ilObjSCORMTracking::_getCountCompletedPerUser ( array  $a_scorm_item_ids, int  $a_obj_id  )

static

Get users who have status completed or passed.

Returns

array<int|string, mixed>

Definition at line 464 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, and $res.

Referenced by ilLPStatusSCORM\_getStatusInfo().

                                                                                            : array
    {
        global $DIC;
        $ilDB = $DIC->database();
        $users = [];

        $in = $ilDB->in('sco_id', $a_scorm_item_ids, false, 'integer');

        // Why does this query use a like search against "passed" and "failed"
        //because it's clob and we support Oracle
        $res = $ilDB->queryF(
            '
                        SELECT user_id, COUNT(user_id) completed FROM scorm_tracking
                        WHERE ' . $in . '
                        AND obj_id = %s
                        AND lvalue = %s 
                        AND (' . $ilDB->like('rvalue', 'clob', 'completed') . ' OR ' . $ilDB->like('rvalue', 'clob', 'passed') . ')
                        GROUP BY user_id',
            array('integer', 'text'),
            array($a_obj_id, 'cmi.core.lesson_status')
        );
        while ($row = $ilDB->fetchObject($res)) {
            $users[$row->user_id] = $row->completed;
        }
        return $users;
    }

Here is the caller graph for this function:

_getFailed()

static ilObjSCORMTracking::_getFailed ( object  $scorm_item_id, int  $a_obj_id  )

static

like necessary because of Oracle

Definition at line 422 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, and $res.

                                                                           : array
    {
        global $DIC;
        $ilDB = $DIC->database();
        $user_ids = [];

        if (is_array($scorm_item_id)) {
            $in = $ilDB->in('sco_id', $scorm_item_id, false, 'integer');

            $res = $ilDB->queryF(
                '
                                SELECT DISTINCT(user_id) FROM scorm_tracking 
                                WHERE ' . $in . '
                                AND obj_id = %s
                                AND lvalue =  %s
                                AND ' . $ilDB->like('rvalue', 'clob', 'failed') . ' ',
                array('integer', 'text'),
                array($a_obj_id, 'cmi.core.lesson_status')
            );
        } else {
            $res = $ilDB->queryF(
                '
                                SELECT DISTINCT(user_id) FROM scorm_tracking 
                                WHERE sco_id = %s
                                AND obj_id = %s
                                AND lvalue =  %s
                                AND ' . $ilDB->like('rvalue', 'clob', 'failed') . ' ',
                array('integer', 'integer', 'text'),
                array($scorm_item_id, $a_obj_id, 'cmi.core.lesson_status')
            );
        }

        while ($row = $ilDB->fetchObject($res)) {
            $user_ids[] = $row->user_id;
        }
        return $user_ids;
    }

_getInProgress()

static ilObjSCORMTracking::_getInProgress ( array|int  $scorm_item_id, int  $a_obj_id, ?array  $a_blocked_user_ids = null  )

static

Returns

array<int|string, mixed[]>

Definition at line 538 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, and $res.

Referenced by _getProgressInfo().

                                                                                                                     : array
    {
        global $DIC;
        $ilDB = $DIC->database();

        if (is_array($scorm_item_id)) {
            $in = $ilDB->in('sco_id', $scorm_item_id, false, 'integer');

            $res = $ilDB->queryF(
                'SELECT user_id,sco_id FROM scorm_tracking
                        WHERE ' . $in . '
                        AND obj_id = %s 
                        GROUP BY user_id, sco_id',
                array('integer'),
                array($a_obj_id)
            );
        } else {
            $res = $ilDB->queryF(
                'SELECT user_id,sco_id FROM scorm_tracking                      
                        WHERE sco_id = %s 
                        AND obj_id = %s',
                array('integer', 'integer'),
                array($scorm_item_id, $a_obj_id)
            );
        }

        $in_progress = array();

        while ($row = $ilDB->fetchObject($res)) {
            // #15061 - see _getProgressInfo()
            if (!($a_blocked_user_ids &&
                isset($a_blocked_user_ids[$row->sco_id]) &&
                is_array($a_blocked_user_ids[$row->sco_id]) &&
                in_array($row->user_id, $a_blocked_user_ids[$row->sco_id]))) {
                $in_progress[$row->sco_id][] = $row->user_id;
            }
        }
        return $in_progress;
    }

Here is the caller graph for this function:

_getProgressInfo()

static ilObjSCORMTracking::_getProgressInfo ( array  $sco_item_ids, int  $a_obj_id  )

static

Get info about.

Returns

array<string, array>

Definition at line 495 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, $res, and _getInProgress().

Referenced by ilLPStatusSCORM\_getStatusInfo().

                                                                               : array
    {
        global $DIC;
        $ilDB = $DIC->database();

        $in = $ilDB->in('sco_id', $sco_item_ids, false, 'integer');

        $res = $ilDB->queryF(
            '
                SELECT * FROM scorm_tracking 
                WHERE ' . $in . '
                AND obj_id = %s 
                AND lvalue = %s ',
            array('integer', 'text'),
            array($a_obj_id, 'cmi.core.lesson_status')
        );

        $info['completed'] = array();
        $info['failed'] = array();

        $user_ids = array();
        while ($row = $ilDB->fetchObject($res)) {
            switch ($row->rvalue) {
                case 'completed':
                case 'passed':
                    $info['completed'][$row->sco_id][] = $row->user_id;
                    $user_ids[$row->sco_id][] = $row->user_id;
                    break;

                case 'failed':
                    $info['failed'][$row->sco_id][] = $row->user_id;
                    $user_ids[$row->sco_id][] = $row->user_id;
                    break;
            }
        }
        $info['in_progress'] = ilObjSCORMTracking::_getInProgress($sco_item_ids, $a_obj_id, $user_ids);

        return $info;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_getTrackedUsers()

static ilObjSCORMTracking::_getTrackedUsers ( int  $a_obj_id )

static

Get all tracked users.

Definition at line 398 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, and $res.

Referenced by ilTrQuery\getParticipantsForObject(), and ilLPStatusSCORM\refreshStatus().

                                                          : array
    {
        global $DIC;
        $ilDB = $DIC->database();
        //        $ilLog = ilLoggerFactory::getLogger('sahs');

        $res = $ilDB->queryF(
            'SELECT DISTINCT user_id FROM scorm_tracking 
                        WHERE obj_id = %s
                        AND lvalue = %s',
            array('integer', 'text'),
            array($a_obj_id, 'cmi.core.lesson_status')
        );

        $users = array();
        while ($row = $ilDB->fetchAssoc($res)) {
            $users[] = $row["user_id"];
        }
        return $users;
    }

Here is the caller graph for this function:

_insertTrackData()

static ilObjSCORMTracking::_insertTrackData ( int  $a_sahs_id, string  $a_lval, string  $a_rval, int  $a_obj_id  )

static

Definition at line 231 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, ilLPStatusWrapper\_updateStatus(), and ilUtil\now().

Referenced by ilSCORMItem\insertTrackData().

                                                                                                          : void
    {
        global $DIC;
        $ilDB = $DIC->database();
        $ilUser = $DIC->user();

        $ilDB->insert('scorm_tracking', array(
            'obj_id' => array('integer', $a_obj_id),
            'user_id' => array('integer', $ilUser->getId()),
            'sco_id' => array('integer', $a_sahs_id),
            'lvalue' => array('text', $a_lval),
            'rvalue' => array('clob', $a_rval),
            'c_timestamp' => array('timestamp', ilUtil::now())
        ));

        if ($a_lval === "cmi.core.lesson_status") {
            ilLPStatusWrapper::_updateStatus($a_obj_id, $ilUser->getId());
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_syncReadEvent()

static ilObjSCORMTracking::_syncReadEvent ( int  $a_obj_id, int  $a_user_id, string  $a_type, int  $a_ref_id  )

static

Definition at line 628 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, ilChangeEvent\_recordReadEvent(), ilLoggerFactory\getLogger(), ILIAS\Repository\int(), and null.

Referenced by scorm12PlayerUnload().

                                                                                                       : void
    {
        global $DIC;
        $ilDB = $DIC->database();
        $ilLog = ilLoggerFactory::getLogger('sahs');
        $val_set = $ilDB->queryF(
            'SELECT package_attempts, total_time_sec, sco_total_time_sec, time_from_lms FROM sahs_user, sahs_lm '
            . 'WHERE sahs_user.obj_id = %s AND sahs_user.user_id = %s AND sahs_user.obj_id = sahs_lm.id',
            array('integer', 'integer'),
            array($a_obj_id, $a_user_id)
        );

        $val_rec = $ilDB->fetchAssoc($val_set);

        if ($val_rec["package_attempts"] == null) {
            $val_rec["package_attempts"] = "";
        }
        $attempts = $val_rec["package_attempts"];

        $time = (int) $val_rec["sco_total_time_sec"];

        // get learning time for old ILIAS-Versions
        if ($time == 0) {
            $sco_set = $ilDB->queryF(
                '
                        SELECT sco_id, rvalue FROM scorm_tracking 
                        WHERE obj_id = %s
                        AND user_id = %s
                        AND lvalue = %s
                        AND sco_id <> %s',
                array('integer', 'integer', 'text', 'integer'),
                array($a_obj_id, $a_user_id, 'cmi.core.total_time', 0)
            );

            while ($sco_rec = $ilDB->fetchAssoc($sco_set)) {
                $tarr = explode(":", $sco_rec["rvalue"]);
                $sec = (int) $tarr[2] + (int) $tarr[1] * 60 +
                    (int) substr($tarr[0], strlen($tarr[0]) - 3) * 60 * 60;
                $time += $sec;
            }
        }
        ilChangeEvent::_recordReadEvent($a_type, $a_ref_id, $a_obj_id, $a_user_id, false, $attempts, $time);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

checkIfAllowed()

static ilObjSCORMTracking::checkIfAllowed ( int  $packageId, int  $userId, int  $hash  )

static

Definition at line 612 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, and $res.

                                                                                 : void
    {
        global $DIC;
        $ilDB = $DIC->database();
        $res = $ilDB->queryF(
            'select hash from sahs_user where obj_id=%s AND user_id=%s AND hash_end>%s',
            array('integer', 'integer', 'timestamp'),
            array($packageId, $userId, date('Y-m-d H:i:s'))
        );
        $rowtmp = $ilDB->fetchAssoc($res);
        if (! ($rowtmp && $rowtmp['hash'] == $hash)) {
            //output used by api
            die("not allowed");
        }
    }

lookupLastAccessTimes()

static ilObjSCORMTracking::lookupLastAccessTimes ( int  $a_obj_id )

static

Lookup last acccess time for all users of a scorm module.

Returns

array<int|string, mixed>

Definition at line 377 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, $res, and ilDBConstants\FETCHMODE_OBJECT.

                                                               : array
    {
        global $DIC;
        $ilDB = $DIC->database();
        $users = array();

        $query = 'SELECT user_id, MAX(c_timestamp) tst ' .
            'FROM scorm_tracking ' .
            'WHERE obj_id = ' . $ilDB->quote($a_obj_id, 'integer') . ' ' .
            'GROUP BY user_id';
        $res = $ilDB->query($query);

        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $users[$row->user_id] = $row->tst;
        }
        return $users;
    }

scorm12PlayerUnload()

static ilObjSCORMTracking::scorm12PlayerUnload ( )

static

Definition at line 578 of file class.ilObjSCORMTracking.php.

References $DIC, $GLOBALS, $ilDB, $ref_id, $user_id, _syncReadEvent(), and ILIAS\UI\examples\Symbol\Glyph\Header\header().

                                                : void
    {
        global $DIC;
        $ilDB = $DIC->database();
        $user_id = $DIC->http()->wrapper()->query()->retrieve('p', $DIC->refinery()->kindlyTo()->int());
        $ref_id = $DIC->http()->wrapper()->query()->retrieve('ref_id', $DIC->refinery()->kindlyTo()->int());
        $obj_id = $DIC->http()->wrapper()->query()->retrieve('package_id', $DIC->refinery()->kindlyTo()->int());
        if ($obj_id <= 1) {
            $GLOBALS['DIC']['ilLog']->write(__METHOD__ . ' no valid obj_id');
        } else {
            $last_visited = "";
            if ($DIC->http()->wrapper()->query()->has('last_visited')) {
                $last_visited = $DIC->http()->wrapper()->query()->retrieve('last_visited', $DIC->refinery()->kindlyTo()->string());
            }

            $endDate = date(
                'Y-m-d H:i:s',
                mktime((int) date('H'), (int) date('i') + 5, (int) date('s'), (int) date('m'), (int) date('d'), (int) date('Y'))
            );
            $ilDB->manipulateF(
                'UPDATE sahs_user 
                                SET last_visited = %s, hash_end =%s, last_access = %s
                                WHERE obj_id = %s AND user_id = %s',
                array('text', 'timestamp', 'timestamp', 'integer', 'integer'),
                array($last_visited, $endDate, date('Y-m-d H:i:s'), $obj_id, $user_id)
            );
            // update time and numbers of attempts in change event
            //NOTE: here it is correct (not count of commit with changed values); be careful to performance issues
            ilObjSCORMTracking::_syncReadEvent($obj_id, $user_id, "sahs", $ref_id);
        }
        header('Content-Type: text/plain; charset=UTF-8');
        print("");
    }

Here is the call graph for this function:

storeJsApi()

static ilObjSCORMTracking::storeJsApi ( )

static

Definition at line 28 of file class.ilObjSCORMTracking.php.

References $data, $DIC, $refId, $user_id, ILIAS\UI\examples\Symbol\Glyph\Header\header(), and ILIAS\Repository\int().

                                       : void
    {
        global $DIC;
        $obj_id = $DIC->http()->wrapper()->query()->retrieve('package_id', $DIC->refinery()->kindlyTo()->int());
        $refId = $DIC->http()->wrapper()->query()->retrieve('ref_id', $DIC->refinery()->kindlyTo()->int());
        $in = file_get_contents("php://input");
        $data = json_decode($in);
        $user_id = (int) $data->p;

        header('Content-Type: text/plain; charset=UTF-8');

        $rval = self::storeJsApiCmi($user_id, $obj_id, $data);
        if ($rval != true) {
            print("storeJsApiCmi failed");
        } else {
            $rval = self::syncGlobalStatus($user_id, $obj_id, $refId, $data, $data->now_global_status);
            if ($rval != true) {
                print("syncGlobalStatus failed");
            }
        }
        if ($rval == true) {
            print("ok");
        }
    }

Here is the call graph for this function:

storeJsApiCmi()

static ilObjSCORMTracking::storeJsApiCmi ( int  $user_id, int  $obj_id, object  $data  )

static

Definition at line 53 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, ilSCORMObject\_lookupPresentableItems(), ilLoggerFactory\getLogger(), ilLTIAppEventListener\handleOutcomeWithoutLP(), and ilUtil\now().

                                                                                 : bool
    {
        global $DIC;
        $ilLog = ilLoggerFactory::getLogger('sahs');
        $ilDB = $DIC->database();

        $b_updateStatus = false;
        $i_score_max = 0;
        $i_score_raw = 0;

        $aa_data = array();
        // if (is_array($_POST["S"])) {
        // foreach($_POST["S"] as $key => $value) {
        // $aa_data[] = array("sco_id" => $value, "left" => $_POST["L"][$key], "right" => $_POST["R"][$key]);
        // }
        // }
        foreach ($data->cmi as $value) {
            $aa_data[] = array("sco_id" => (int) $value[0],
                               "left" => $value[1],
                               "right" => $value[2]
            );
            //                  $aa_data[] = array("sco_id" => (int) $data->cmi[$i][0], "left" => $data->cmi[$i][1], "right" => rawurldecode($data->cmi[$i][2]));
        }

        if ($obj_id <= 1) {
            $ilLog->write("ScormAicc: storeJsApi: Error: No valid obj_id given.");
        } else {
            foreach ($aa_data as $a_data) {
                $set = $ilDB->queryF(
                    '
                                SELECT rvalue FROM scorm_tracking 
                                WHERE user_id = %s
                                AND sco_id =  %s
                                AND lvalue =  %s
                                AND obj_id = %s',
                    array('integer', 'integer', 'text', 'integer'),
                    array($user_id, $a_data["sco_id"], $a_data["left"], $obj_id)
                );
                if ($rec = $ilDB->fetchAssoc($set)) {
                    if ($a_data["left"] === 'cmi.core.lesson_status' && $a_data["right"] != $rec["rvalue"]) {
                        $b_updateStatus = true;
                    }
                    $ilDB->update(
                        'scorm_tracking',
                        array(
                            'rvalue' => array('clob', $a_data["right"]),
                            'c_timestamp' => array('timestamp', ilUtil::now())
                        ),
                        array(
                            'user_id' => array('integer', $user_id),
                            'sco_id' => array('integer', $a_data["sco_id"]),
                            'lvalue' => array('text', $a_data["left"]),
                            'obj_id' => array('integer', $obj_id)
                        )
                    );
                    $ilLog->debug("ScormAicc: storeJsApi Updated - L:" . $a_data["left"] . ",R:" .
                        $a_data["right"] . " for obj_id:" . $obj_id . ",sco_id:" . $a_data["sco_id"] . ",user_id:" . $user_id);
                } else {
                    if ($a_data["left"] === 'cmi.core.lesson_status') {
                        $b_updateStatus = true;
                    }
                    $ilDB->insert('scorm_tracking', array(
                        'obj_id' => array('integer', $obj_id),
                        'user_id' => array('integer', $user_id),
                        'sco_id' => array('integer', $a_data["sco_id"]),
                        'lvalue' => array('text', $a_data["left"]),
                        'rvalue' => array('clob', $a_data["right"]),
                        'c_timestamp' => array('timestamp', ilUtil::now())
                    ));
                    $ilLog->debug("ScormAicc: storeJsApi Inserted - L:" . $a_data["left"] . ",R:" .
                        $a_data["right"] . " for obj_id:" . $obj_id . ",sco_id:" . $a_data["sco_id"] . ",user_id:" . $user_id);
                }
                if ($a_data["left"] === 'cmi.core.score.max') {
                    $i_score_max = $a_data["right"];
                }
                if ($a_data["left"] === 'cmi.core.score.raw') {
                    $i_score_raw = $a_data["right"];
                }
            }
            // mantis #30293
            if ($i_score_max > 0 && $i_score_raw > 0) {
                if (count(ilSCORMObject::_lookupPresentableItems($obj_id)) == 1) {
                    ilLTIAppEventListener::handleOutcomeWithoutLP(
                        $obj_id,
                        $user_id,
                        ($i_score_raw / $i_score_max) * 100
                    );
                }
            }
        }

        // update status
        // if ($b_updateStatus == true) {
        // include_once("../components/ILIAS/Tracking/classes/class.ilLPStatusWrapper.php");
        // ilLPStatusWrapper::_updateStatus($obj_id, $user_id);
        // }

        return true;
    }

Here is the call graph for this function:

syncGlobalStatus()

static ilObjSCORMTracking::syncGlobalStatus ( int  $userId, int  $packageId, int  $refId, object  $data, ?int  $new_global_status  )

static

Definition at line 153 of file class.ilObjSCORMTracking.php.

References $DIC, $ilDB, ilChangeEvent\_recordReadEvent(), ilLoggerFactory\getLogger(), ILIAS\Repository\int(), null, and ilLPStatus\writeStatus().

                                                                                                                           : bool
    {
        global $DIC;
        $ilDB = $DIC->database();
        $ilLog = ilLoggerFactory::getLogger('sahs');
        $saved_global_status = $data->saved_global_status;
        $ilLog->write("saved_global_status=" . $saved_global_status);

        // get attempts
        if (!isset($data->packageAttempts)) {
            $val_set = $ilDB->queryF(
                'SELECT package_attempts FROM sahs_user WHERE obj_id = %s AND user_id = %s',
                array('integer', 'integer'),
                array($packageId, $userId)
            );
            $val_rec = $ilDB->fetchAssoc($val_set);
            $attempts = $val_rec["package_attempts"];
        } else {
            $attempts = $data->packageAttempts;
        }
        if ($attempts == null) {
            $attempts = 1;
        }

        //update percentage_completed, sco_total_time_sec,status in sahs_user
        $totalTime = (int) $data->totalTimeCentisec;
        $totalTime = round($totalTime / 100);
        $ilDB->queryF(
            'UPDATE sahs_user SET last_visited=%s, last_access = %s, sco_total_time_sec=%s, status=%s, percentage_completed=%s, package_attempts=%s WHERE obj_id = %s AND user_id = %s',
            array('text', 'timestamp', 'integer', 'integer', 'integer', 'integer', 'integer', 'integer'),
            array($data->last_visited,
                  date('Y-m-d H:i:s'),
                  $totalTime,
                  $new_global_status,
                  $data->percentageCompleted,
                  $attempts,
                  $packageId,
                  $userId
            )
        );

        //              self::ensureObjectDataCacheExistence();
        global $DIC;
        $ilObjDataCache = $DIC['ilObjDataCache'];
        //workaround if $row->read_count == null TODO ERASE
        try {
            ilChangeEvent::_recordReadEvent(
                "sahs",
                $refId,
                $packageId,
                $userId,
                false,
                $attempts,
                $totalTime
            );
        } catch (\Exception $exception) {
            ilChangeEvent::_recordReadEvent(
                "sahs",
                $refId,
                $packageId,
                $userId,
                false,
                null,
                $totalTime
            );
        }

        //end sync access number and time in read event table

        // update learning progress
        if ($new_global_status != null) {
            ilLPStatus::writeStatus($packageId, $userId, $new_global_status, (int) $data->percentageCompleted);

            //                  here put code for soap to MaxCMS e.g. when if($saved_global_status != $new_global_status)
        }
        return true;
    }

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• components/ILIAS/ScormAicc/classes/SCORM/class.ilObjSCORMTracking.php