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 ($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 194 of file class.ilSCORM2004DeleteData.php.

                                                                                        {
                global $ilDB;
                
                $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;
        }

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

Referenced by removeCMIDataForPackage(), and removeCMIDataForUserAndPackage().

Here is the caller graph for this function:

removeCMIDataForNodes()

static ilSCORM2004DeleteData::removeCMIDataForNodes (   $cmi_node_values )

static

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

        {
                global $ilDB;
                
                //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);
 
        }

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

Referenced by removeCMIDataForPackage(), removeCMIDataForUser(), and removeCMIDataForUserAndPackage().

Here is the caller graph for this function:

removeCMIDataForPackage()

static ilSCORM2004DeleteData::removeCMIDataForPackage (   $packageId )

static

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

        {
                global $ilDB;
 
                $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)
                );              
                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)
                        );
                }
        }

References $data, $ilDB, $packageId, $query, $res, getGlobalToSystemObjectiveIdStringForPackage(), and removeCMIDataForNodes().

Referenced by ilSCORM13Package\removeCMIData().

Here is the call graph for this function:

Here is the caller graph for this function:

removeCMIDataForUser()

static ilSCORM2004DeleteData::removeCMIDataForUser (   $user_id )

static

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

        {
                global $ilDB;
 
                //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)
                );              
                
                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)
                );
 
        }

References $data, $ilDB, $res, and removeCMIDataForNodes().

Referenced by ilSCORM13Package\_removeTrackingDataForUser().

Here is the call graph for this function:

Here is the caller graph for this function:

removeCMIDataForUserAndPackage()

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

static

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

        {
                global $ilDB;
 
                //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)
                );              
                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)
                        );
                }
        }

References $data, $ilDB, $packageId, $res, getGlobalToSystemObjectiveIdStringForPackage(), and removeCMIDataForNodes().

Referenced by ilObjSCORM2004LearningModule\deleteTrackingDataOfUsers().

Here is the call graph for this function:

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