ilSCORM2004DeleteData Class Reference

Class ilSCORM2004DeleteData. More...

Collaboration diagram for ilSCORM2004DeleteData:

Static Public Member Functions
static	removeCMIDataForPackage ($packageId)
static	removeCMIDataForUser ($user_id)
static	removeCMIDataForUserAndPackage ($user_id, $packageId)
static	removeCMIDataForNodes (array $cmi_node_values)
static	getGlobalToSystemObjectiveIdStringForPackage ($packageId)

Detailed Description

Class ilSCORM2004DeleteData.

Author

Uwe Kohnle kohnl.nosp@m.e@in.nosp@m.terne.nosp@m.tleh.nosp@m.rer-g.nosp@m.mbh..nosp@m.de

Definition at line 12 of file class.ilSCORM2004DeleteData.php.

Member Function Documentation

getGlobalToSystemObjectiveIdStringForPackage()

static ilSCORM2004DeleteData::getGlobalToSystemObjectiveIdStringForPackage (   $packageId )

static

Definition at line 205 of file class.ilSCORM2004DeleteData.php.

References $data, $DIC, $ilDB, $packageId, and $res.

    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $existing_key_template = "";
        $global_to_system = 1;

        $res = $ilDB->queryF(
            'SELECT global_to_system FROM cp_package WHERE obj_id = %s',
            array('integer'),
            array($packageId)
        );
        while ($data = $ilDB->fetchAssoc($res)) {
            $global_to_system = $data['global_to_system'];
        }
        if ($global_to_system == 0) {
            return "";
        }

        $res = $ilDB->queryF(
            '
                        SELECT targetobjectiveid 
                        FROM cp_mapinfo, cp_node 
                        WHERE cp_node.slm_id = %s 
                        AND cp_node.nodename = %s
                        AND cp_mapinfo.cp_node_id = cp_node.cp_node_id',
            array('integer', 'text'),
            array($packageId, 'mapInfo')
        );
        while ($data = $ilDB->fetchAssoc($res)) {
            $existing_key_template .= "'" . $data['targetobjectiveid'] . "',";
        }
        //remove trailing ','
        $existing_key_template = substr($existing_key_template, 0, strlen($existing_key_template) - 1);

        return $existing_key_template;
    }

removeCMIDataForNodes()

static ilSCORM2004DeleteData::removeCMIDataForNodes ( array  $cmi_node_values )

static

Parameters

array

$cmi_node_values

Definition at line 158 of file class.ilSCORM2004DeleteData.php.

References $data, $DIC, $ilDB, $query, and $res.

    {
        global $DIC;

        $ilDB = $DIC->database();
        
        //cmi interaction nodes
        $cmi_inode_values = array();
        
        $query = 'SELECT cmi_interaction_id FROM cmi_interaction WHERE '
            . $ilDB->in('cmi_interaction.cmi_node_id', $cmi_node_values, false, 'integer');
        $res = $ilDB->query($query);
        while ($data = $ilDB->fetchAssoc($res)) {
            $cmi_inode_values[] = $data['cmi_interaction_id'];
        }

        //response
        $query = 'DELETE FROM cmi_correct_response WHERE '
               . $ilDB->in('cmi_correct_response.cmi_interaction_id', $cmi_inode_values, false, 'integer');
        $ilDB->manipulate($query);
            
        //objective interaction
        $query = 'DELETE FROM cmi_objective WHERE '
               . $ilDB->in('cmi_objective.cmi_interaction_id', $cmi_inode_values, false, 'integer');
        $ilDB->manipulate($query);
            
        //objective
        $query = 'DELETE FROM cmi_objective WHERE '
               . $ilDB->in('cmi_objective.cmi_node_id', $cmi_node_values, false, 'integer');
        $ilDB->manipulate($query);
                
        //interaction
        $query = 'DELETE FROM cmi_interaction WHERE '
               . $ilDB->in('cmi_interaction.cmi_node_id', $cmi_node_values, false, 'integer');
        $ilDB->manipulate($query);
            
        //comment
        $query = 'DELETE FROM cmi_comment WHERE '
               . $ilDB->in('cmi_comment.cmi_node_id', $cmi_node_values, false, 'integer');
        $ilDB->manipulate($query);
                    
        //node
        $query = 'DELETE FROM cmi_node WHERE '
               . $ilDB->in('cmi_node.cmi_node_id', $cmi_node_values, false, 'integer');
        $ilDB->manipulate($query);
    }

removeCMIDataForPackage()

static ilSCORM2004DeleteData::removeCMIDataForPackage (   $packageId )

static

Definition at line 14 of file class.ilSCORM2004DeleteData.php.

References $data, $DIC, $ilDB, $packageId, $query, and $res.

Referenced by ilSCORM13Package\removeCMIData().

    {
        global $DIC;

        $ilDB = $DIC->database();

        $res = $ilDB->queryF(
            '
                        SELECT cmi_node.cmi_node_id 
                        FROM cmi_node, cp_node 
                        WHERE cp_node.slm_id = %s AND cmi_node.cp_node_id = cp_node.cp_node_id',
            array('integer'),
            array($packageId)
        );
        $cmi_node_values = [];
        while ($data = $ilDB->fetchAssoc($res)) {
            $cmi_node_values[] = $data['cmi_node_id'];
        }
        self::removeCMIDataForNodes($cmi_node_values);

        //custom
        //TODO: delete cmi_custom
        $query = 'DELETE FROM cmi_custom WHERE obj_id = %s';
        $ilDB->manipulateF($query, array('integer'), array($packageId));

        //sahs_user
        $query = 'DELETE FROM sahs_user WHERE obj_id = %s';
        $ilDB->manipulateF($query, array('integer'), array($packageId));

        //g_objective
        $query = 'DELETE FROM cmi_gobjective WHERE scope_id = %s';
        $ilDB->manipulateF($query, array('integer'), array($packageId));

        $s_globalObjectiveId = self::getGlobalToSystemObjectiveIdStringForPackage($packageId);
        if ($s_globalObjectiveId != "") {
            $ilDB->manipulateF(
                'DELETE FROM cmi_gobjective WHERE scope_id = %s AND objective_id in (' . $s_globalObjectiveId . ')',
                array('integer'),
                array(0)
            );
        }
    }

Here is the caller graph for this function:

removeCMIDataForUser()

static ilSCORM2004DeleteData::removeCMIDataForUser (   $user_id )

static

Definition at line 57 of file class.ilSCORM2004DeleteData.php.

References $data, $DIC, $ilDB, and $res.

Referenced by ilSCORM13Package\_removeTrackingDataForUser().

    {
        global $DIC;

        $ilDB = $DIC->database();

        //get all cmi_nodes to delete
        $res = $ilDB->queryF(
            '
                        SELECT cmi_node.cmi_node_id 
                        FROM cmi_node, cp_node 
                        WHERE cmi_node.user_id = %s AND cmi_node.cp_node_id = cp_node.cp_node_id',
            array('integer'),
            array($user_id)
        );
        
        $cmi_node_values = [];
        while ($data = $ilDB->fetchAssoc($res)) {
            $cmi_node_values[] = $data['cmi_node_id'];
        }
        self::removeCMIDataForNodes($cmi_node_values);

        //custom
        //TODO: delete cmi_custom
        $ilDB->manipulateF(
            'DELETE FROM cmi_custom WHERE user_id = %s',
            array('integer'),
            array($user_id)
        );
        
        //sahs_user
        $ilDB->manipulateF(
            'DELETE FROM sahs_user WHERE user_id = %s',
            array('integer'),
            array($user_id)
        );

        //gobjective
        $ilDB->manipulateF(
            'DELETE FROM cmi_gobjective WHERE user_id = %s',
            array('integer'),
            array($user_id)
        );
    }

Here is the caller graph for this function:

removeCMIDataForUserAndPackage()

static ilSCORM2004DeleteData::removeCMIDataForUserAndPackage (   $user_id,   $packageId  )

static

Definition at line 102 of file class.ilSCORM2004DeleteData.php.

References $data, $DIC, $ilDB, $packageId, and $res.

Referenced by ilObjSCORM2004LearningModule\deleteTrackingDataOfUsers().

    {
        global $DIC;

        $ilDB = $DIC->database();

        //get all cmi_nodes to delete
        $res = $ilDB->queryF(
            '
                        SELECT cmi_node.cmi_node_id 
                        FROM cmi_node, cp_node 
                        WHERE cmi_node.user_id = %s AND cmi_node.cp_node_id = cp_node.cp_node_id AND cp_node.slm_id = %s',
            array('integer','integer'),
            array($user_id,$packageId)
        );
        $cmi_node_values = [];
        while ($data = $ilDB->fetchAssoc($res)) {
            $cmi_node_values[] = $data['cmi_node_id'];
        }
        self::removeCMIDataForNodes($cmi_node_values);

        //custom
        //TODO: delete cmi_custom
        $ilDB->manipulateF(
            'DELETE FROM cmi_custom WHERE user_id = %s AND obj_id = %s',
            array('integer','integer'),
            array($user_id,$packageId)
        );
        
        //sahs_user
        $ilDB->manipulateF(
            'DELETE FROM sahs_user WHERE user_id = %s AND obj_id = %s',
            array('integer','integer'),
            array($user_id,$packageId)
        );

        //gobjective
        $ilDB->manipulateF(
            'DELETE FROM cmi_gobjective WHERE user_id = %s AND scope_id = %s',
            array('integer','integer'),
            array($user_id,$packageId)
        );

        $s_globalObjectiveId = self::getGlobalToSystemObjectiveIdStringForPackage($packageId);
        if ($s_globalObjectiveId != "") {
            $ilDB->manipulateF(
                'DELETE FROM cmi_gobjective WHERE user_id = %s AND scope_id = %s AND objective_id in (' . $s_globalObjectiveId . ')',
                array('integer','integer'),
                array($user_id,0)
            );
        }
    }

Here is the caller graph for this function:

---

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

• Modules/Scorm2004/classes/class.ilSCORM2004DeleteData.php