ilSCORM2004DeleteData Class Reference

Class ilSCORM2004DeleteData. More...

Collaboration diagram for ilSCORM2004DeleteData:

Public Member Functions
	removeCMIDataForPackage ($packageId)
	removeCMIDataForUser ($user_id)
	removeCMIDataForUserAndPackage ($user_id, $packageId)
	removeCMIDataForNodes ($cmi_node_values)
	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

ilSCORM2004DeleteData::getGlobalToSystemObjectiveIdStringForPackage

(

$packageId

)

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

References $res.

Referenced by removeCMIDataForPackage(), and removeCMIDataForUserAndPackage().

                                                                                 {
                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;
        }

Here is the caller graph for this function:

ilSCORM2004DeleteData::removeCMIDataForNodes

(

$cmi_node_values

)

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

References $query, and $res.

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

        {
                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);

        }

Here is the caller graph for this function:

ilSCORM2004DeleteData::removeCMIDataForPackage

(

$packageId

)

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

References $query, $res, getGlobalToSystemObjectiveIdStringForPackage(), and removeCMIDataForNodes().

Referenced by ilSCORM13Package\removeCMIData().

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

Here is the call graph for this function:

Here is the caller graph for this function:

ilSCORM2004DeleteData::removeCMIDataForUser

(

$user_id

)

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

References $res, and removeCMIDataForNodes().

Referenced by ilSCORM13Package\_removeTrackingDataForUser().

        {
                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)
                );

        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilSCORM2004DeleteData::removeCMIDataForUserAndPackage	(		$user_id,
			$packageId
	)

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

References $res, getGlobalToSystemObjectiveIdStringForPackage(), and removeCMIDataForNodes().

Referenced by ilObjSCORM2004LearningModuleGUI\confirmedDeleteTracking(), and ilObjSCORM2004LearningModule\deleteTrackingDataOfUsers().

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

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