ILIAS  Release_4_2_x_branch Revision 61807
 All Data Structures Namespaces Files Functions Variables Groups Pages
ilCourseItems Class Reference
+ Collaboration diagram for ilCourseItems:

Public Member Functions

 ilCourseItems ($a_course_ref_id, $a_parent=0, $user_id=0)
 cloneDependencies ($a_target_id, $a_copy_id)
 Clone dependencies.
 setItemId ($a_item_id)
 getItemId ()
 getUserId ()
 _hasCollectionTimings ($a_ref_id)
 _hasTimings ($a_ref_id)
 check if there is any active timing
 _hasChangeableTimings ($a_ref_id)
 setParentId ($a_parent=0)
 getParentId ()
 setTimingType ($a_type)
 getTimingType ()
 setTimingStart ($a_start)
 getTimingStart ()
 setTimingEnd ($a_end)
 getTimingEnd ()
 setSuggestionStart ($a_start)
 getSuggestionStart ()
 setSuggestionEnd ($a_end)
 getSuggestionEnd ()
 setEarliestStart ($a_start)
 getEarliestStart ()
 setLatestEnd ($a_end)
 getLatestEnd ()
 toggleVisible ($a_status)
 enabledVisible ()
 toggleChangeable ($a_status)
 enabledChangeable ()
 setPosition ($a_pos)
 getAllItems ()
 getFilteredItems ($a_container_ref_id)
 Get all items.
 getItemsByEvent ($a_event_id)
 getItemsByObjective ($a_objective_id)
 getItems ()
 getItem ($a_item_id)
 validateActivation ()
 save ()
 Save.
 update ($a_item_id)
 moveUp ($item_id)
 moveDown ($item_id)
 deleteAllEntries ()
 __read ()
 __purgeDeleted ()
 __delete ($a_obj_id)
 __getItemData ($a_item)
 createDefaultEntry ($a_item)
 __getLastPosition ()
 __isMovable ($a_ref_id)
 __switchNodes ($node_a, $node_b)
 __sort ()
 __splitByActivation ()
 _isActivated ($a_item_id)
 addAdditionalSubItemInformation (&$a_item)
 Adds information to object/item array needed to be displayed in repository.

Static Public Member Functions

static _sort ($a_sort_mode, $a_items)
 sort items
static _getItem ($a_item_id)
static _readActivationTimes ($a_ref_ids)
 read activation times

Data Fields

 $ilErr
 $ilDB
 $tree
 $lng
 $items
 $parent
 $timing_type
 $timing_start
 $timing_end

Private Attributes

 $course_ref_id

Detailed Description

Definition at line 39 of file class.ilCourseItems.php.

Member Function Documentation

ilCourseItems::__delete (   $a_obj_id)

Definition at line 617 of file class.ilCourseItems.php.

References $ilDB, $query, $res, and getParentId().

Referenced by __purgeDeleted().

{
global $ilDB;
// DELETE ENTRY
$query = "DELETE FROM crs_items ".
"WHERE parent_id = ".$ilDB->quote($this->getParentId(),'integer')." ".
"AND obj_id = ".$ilDB->quote($a_obj_id,'integer')." ";
$res = $ilDB->manipulate($query);
return true;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::__getItemData (   $a_item)

Definition at line 630 of file class.ilCourseItems.php.

References $data, $ilBench, $ilDB, $query, $res, $row, ilTimingPlaned\_getPlanedTimings(), ilSessionAppointment\_lookupAppointment(), createDefaultEntry(), DB_FETCHMODE_OBJECT, getUserId(), IL_CRS_TIMINGS_ACTIVATION, IL_CRS_TIMINGS_FIXED, IL_CRS_TIMINGS_PRESETTING, and ilDB\query().

Referenced by __read(), getItemsByEvent(), and getItemsByObjective().

{
global $ilDB,$ilUser,$ilObjDataCache, $ilBench;
$ilBench->start("Course", "ilCourseItems_getItemData - 1");
$query = "SELECT * FROM crs_items ".
"WHERE obj_id = ".$ilDB->quote($a_item['child'],'integer')." ".
"AND parent_id = ".$ilDB->quote($a_item['parent'],'integer')." ";
$res = $this->ilDB->query($query);
$ilBench->stop("Course", "ilCourseItems_getItemData - 1");
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$ilBench->start("Course", "ilCourseItems_getItemData - 2");
$a_item["timing_type"] = $row->timing_type;
$a_item["timing_start"] = $row->timing_start;
$a_item["timing_end"] = $row->timing_end;
$a_item["suggestion_start"] = $row->suggestion_start ? $row->suggestion_start :
mktime(0,0,1,date('n',time()),date('j',time()),date('Y',time()));
$a_item["suggestion_end"] = $row->suggestion_end ? $row->suggestion_end :
mktime(23,55,00,date('n',time()),date('j',time()),date('Y',time()));
$a_item['changeable'] = $row->changeable;
$a_item['earliest_start'] = $row->earliest_start ? $row->earliest_start :
mktime(0,0,1,date('n',time()),date('j',time()),date('Y',time()));
$a_item['latest_end'] = $row->latest_end ? $row->latest_end :
mktime(23,55,00,date('n',time()),date('j',time()),date('Y',time()));
$a_item['visible'] = $row->visible;
include_once 'Modules/Course/classes/Timings/class.ilTimingPlaned.php';
$data = ilTimingPlaned::_getPlanedTimings($this->getUserId(),$a_item['child']);
$ilBench->stop("Course", "ilCourseItems_getItemData - 2");
$ilBench->start("Course", "ilCourseItems_getItemData - 3");
// changed for performance reasons
$obj_id = ($a_item['obj_id'] > 0)
? $a_item['obj_id']
: $ilObjDataCache->lookupObjId($row->obj_id);
$obj_type = ($a_item['type'] != "")
? $a_item['type']
: $ilObjDataCache->lookupType($obj_id);
$ilBench->stop("Course", "ilCourseItems_getItemData - 3");
//if($ilObjDataCache->lookupType($obj_id = $ilObjDataCache->lookupObjId($row->obj_id)) == 'sess')
// Check for user entry
$ilBench->start("Course", "ilCourseItems_getItemData - 4");
if($a_item['changeable'] and
$a_item['timing_type'] == IL_CRS_TIMINGS_PRESETTING)
{
if($data['planed_start'])
{
$a_item['start'] = $data['planed_start'];
$a_item['end'] = $data['planed_end'];
$a_item['activation_info'] = 'crs_timings_planed_info';
}
else
{
$a_item['start'] = $row->suggestion_start;
$a_item['end'] = $row->suggestion_end;
$a_item['activation_info'] = 'crs_timings_suggested_info';
}
}
elseif($a_item['timing_type'] == IL_CRS_TIMINGS_PRESETTING)
{
$a_item['start'] = $row->suggestion_start;
$a_item['end'] = $row->suggestion_end;
$a_item['activation_info'] = 'crs_timings_suggested_info';
}
elseif($a_item['timing_type'] == IL_CRS_TIMINGS_ACTIVATION)
{
$a_item['start'] = $row->timing_start;
$a_item['end'] = $row->timing_end;
$a_item['activation_info'] = 'activation';
}
elseif($obj_type == 'sess')
{
include_once('./Modules/Session/classes/class.ilSessionAppointment.php');
$ilBench->start("Course", "ilCourseItems_getItemData - lookupAppointment");
$ilBench->stop("Course", "ilCourseItems_getItemData - lookupAppointment");
$a_item['timing_type'] = IL_CRS_TIMINGS_FIXED;
$a_item['start'] = $info['start'];
$a_item['end'] = $info['end'];
$a_item['fullday'] = $info['fullday'];
$a_item['activation_info'] = 'crs_timings_suggested_info';
}
else
{
$a_item['start'] = 999999999;
}
$ilBench->stop("Course", "ilCourseItems_getItemData - 4");
}
$ilBench->start("Course", "ilCourseItems_getItemData - 5");
if(!isset($a_item["timing_start"]))
{
$a_item = $this->createDefaultEntry($a_item);
}
$ilBench->stop("Course", "ilCourseItems_getItemData - 5");
return $a_item;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::__getLastPosition ( )

Definition at line 776 of file class.ilCourseItems.php.

References $ilDB, $query, $res, $row, DB_FETCHMODE_OBJECT, getParentId(), and ilDB\query().

{
global $ilDB;
$query = "SELECT MAX(position) last_position FROM crs_items ".
"WHERE parent_id = ".$ilDB->quote($this->getParentId(),'integer')." ";
$res = $this->ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$max = $row->last_position;
}
return $max ? $max : 0;
}

+ Here is the call graph for this function:

ilCourseItems::__isMovable (   $a_ref_id)

Definition at line 793 of file class.ilCourseItems.php.

References ilEventItems\_isAssigned().

{
include_once 'Modules/Session/classes/class.ilEventItems.php';
global $ilObjDataCache;
if($ilObjDataCache->lookupType($ilObjDataCache->lookupObjId($a_ref_id)) != 'crs')
{
return true;
}
{
return false;
}
return true;
}

+ Here is the call graph for this function:

ilCourseItems::__purgeDeleted ( )

Definition at line 598 of file class.ilCourseItems.php.

References $ilDB, $query, $res, $row, $tree, __delete(), DB_FETCHMODE_OBJECT, getParentId(), and ilDB\query().

Referenced by __read().

{
global $tree,$ilDB;
$all = array();
$query = "SELECT obj_id FROM crs_items ".
"WHERE parent_id = ".$ilDB->quote($this->getParentId(),'integer')." ";
$res = $this->ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if($tree->getParentId($row->obj_id) != $this->getParentId())
{
$this->__delete($row->obj_id);
}
}
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::__read ( )

Definition at line 554 of file class.ilCourseItems.php.

References $ilBench, $test, __getItemData(), __purgeDeleted(), and __sort().

Referenced by moveDown(), moveUp(), setParentId(), and update().

{
global $ilBench, $test;
$this->items = array();
$ilBench->start("Course", "ilCouseItems_read - getChilds");
$all_items = $this->tree->getChilds($this->parent);
$ilBench->stop("Course", "ilCouseItems_read - getChilds");
foreach($all_items as $item)
{
if($item["type"] != 'rolf')
{
$this->items[] = $item;
}
}
$ilBench->start("Course", "ilCouseItems_read - getItemData");
for($i = 0;$i < count($this->items); ++$i)
{
if($this->items[$i]["type"] == 'rolf')
{
unset($this->items[$i]);
continue;
}
$this->items[$i] = $this->__getItemData($this->items[$i]);
}
$ilBench->stop("Course", "ilCouseItems_read - getItemData");
$ilBench->start("Course", "ilCouseItems_read - purge and sort");
$this->__purgeDeleted();
$this->__sort();
$ilBench->stop("Course", "ilCouseItems_read - purge and sort");
// one array for items per child id
$this->items_per_child = array();
foreach($this->items as $item)
{
$this->items_per_child[$item["child"]] = $item;
}
return true;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::__sort ( )

Definition at line 875 of file class.ilCourseItems.php.

References __splitByActivation(), ilObject\_lookupObjId(), ilContainerSortingSettings\_lookupSortMode(), ilContainer\SORT_ACTIVATION, and ilUtil\sortArray().

Referenced by __read().

{
include_once './Services/Container/classes/class.ilContainerSortingSettings.php';
switch($sort)
{
// Sort by starting time. If mode is IL_CRS_TIMINGS_DEACTIVATED then sort these items by title and append
// them to the array.
list($active,$inactive) = $this->__splitByActivation();
$sorted_active = ilUtil::sortArray($active,"start","asc");
$sorted_inactive = ilUtil::sortArray($inactive,'title','asc');
$this->items = array_merge($sorted_active,$sorted_inactive);
break;
default:
return true;
}
return true;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::__splitByActivation ( )

Definition at line 898 of file class.ilCourseItems.php.

References IL_CRS_TIMINGS_DEACTIVATED.

Referenced by __sort().

{
$inactive = $active = array();
foreach($this->items as $item)
{
if($item['timing_type'] == IL_CRS_TIMINGS_DEACTIVATED)
{
$inactive[] = $item;
}
else
{
$active[] = $item;
}
}
return array($active,$inactive);
}

+ Here is the caller graph for this function:

ilCourseItems::__switchNodes (   $node_a,
  $node_b 
)

Definition at line 810 of file class.ilCourseItems.php.

References $ilDB, $query, $res, and getParentId().

{
global $ilDB;
if(!$node_b["obj_id"])
{
return false;
}
$query = "UPDATE crs_items SET ".
"position = ".$ilDB->quote($node_a["position"],'integer')." ".
"WHERE obj_id = ".$ilDB->quote($node_b["obj_id"],'integer')." ".
"AND parent_id = ".$ilDB->quote($this->getParentId(),'integer')."";
$res = $ilDB->manipulate($query);
$query = "UPDATE crs_items SET ".
"position = ".$ilDB->quote($node_b["position"],'integer')." ".
"WHERE obj_id = ".$ilDB->quote($node_a["obj_id"],'integer')." ".
"AND parent_id = ".$ilDB->quote($this->getParentId(),'integer')."";
$res = $ilDB->manipulate($query);
return true;
}

+ Here is the call graph for this function:

static ilCourseItems::_getItem (   $a_item_id)
static
Parameters
int$a_item_idreference id of object in question
Returns
array array of item data

Definition at line 919 of file class.ilCourseItems.php.

References $data, $ilDB, $query, $res, $row, ilTimingPlaned\_getPlanedTimings(), ilSessionAppointment\_lookupAppointment(), ilObject\_lookupType(), DB_FETCHMODE_OBJECT, IL_CRS_TIMINGS_ACTIVATION, and IL_CRS_TIMINGS_PRESETTING.

Referenced by ilObjectXMLWriter\__appendTimeTargets(), ilTimingCache\_getTimings(), ilObjSessionGUI\infoScreen(), ilTimingPlaned\validate(), and ilContainerXmlWriter\writeCourseItemInformation().

{
include_once 'Modules/Course/classes/class.ilObjCourse.php';
global $ilDB,$ilUser;
$query = "SELECT * FROM crs_items ".
"WHERE obj_id = ".$ilDB->quote($a_item_id,'integer');
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$data['parent_id'] = $row->parent_id;
$data['obj_id'] = $row->obj_id;
$data['ref_id'] = $row->obj_id;
$data['child'] = $row->obj_id;
$data['timing_type'] = $row->timing_type;
$data['timing_start'] = $row->timing_start;
$data['timing_end'] = $row->timing_end;
$data["suggestion_start"] = $row->suggestion_start ? $row->suggestion_start :
mktime(0,0,1,date('n',time()),date('j',time()),date('Y',time()));
$data["suggestion_end"] = $row->suggestion_end ? $row->suggestion_end :
mktime(23,55,00,date('n',time()),date('j',time()),date('Y',time()));
$data['changeable'] = $row->changeable;
$data['earliest_start'] = $row->earliest_start ? $row->earliest_start :
mktime(0,0,1,date('n',time()),date('j',time()),date('Y',time()));
$data['latest_end'] = $row->latest_end ? $row->latest_end :
mktime(23,55,00,date('n',time()),date('j',time()),date('Y',time()));
$data['visible'] = $row->visible;
include_once 'Modules/Course/classes/Timings/class.ilTimingPlaned.php';
$user_data = ilTimingPlaned::_getPlanedTimings($ilUser->getId(),$data['child']);
// #7359 - session sorting should always base on appointment date
if(ilObject::_lookupType($a_item_id) == 'sess')
{
include_once('./Modules/Session/classes/class.ilSessionAppointment.php');
$data['start'] = $info['start'];
$data['end'] = $info['end'];
$data['activation_info'] = 'crs_timings_suggested_info';
}
// Check for user entry
else if($data['changeable'] and
$data['timing_type'] == IL_CRS_TIMINGS_PRESETTING)
{
if($user_data['planed_start'])
{
$data['start'] = $user_data['planed_start'];
$data['end'] = $user_data['planed_end'];
$data['activation_info'] = 'crs_timings_planed_info';
}
else
{
$data['start'] = $row->suggestion_start;
$data['end'] = $row->suggestion_end;
$data['activation_info'] = 'crs_timings_suggested_info';
}
}
elseif($data['timing_type'] == IL_CRS_TIMINGS_PRESETTING)
{
$data['start'] = $row->suggestion_start;
$data['end'] = $row->suggestion_end;
$data['activation_info'] = 'crs_timings_suggested_info';
}
elseif($data['timing_type'] == IL_CRS_TIMINGS_ACTIVATION)
{
$data['start'] = $row->timing_start;
$data['end'] = $row->timing_end;
$data['activation_info'] = 'activation';
}
else
{
$data['start'] = 999999999;
}
}
return $data ? $data : array();
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::_hasChangeableTimings (   $a_ref_id)

Definition at line 217 of file class.ilCourseItems.php.

References $ilDB, $query, $res, $tree, and IL_CRS_TIMINGS_PRESETTING.

Referenced by ilCourseContentGUI\__renderUserItem(), ilCourseContentGUI\editUserTimings(), and ilCourseContentGUI\showUserTimings().

{
global $tree,$ilDB;
$subtree = $tree->getSubTree($tree->getNodeData($a_ref_id));
foreach($subtree as $node)
{
$ref_ids[] = $node['ref_id'];
}
$query = "SELECT * FROM crs_items ".
"WHERE timing_type = ".$ilDB->quote(IL_CRS_TIMINGS_PRESETTING,'integer')." ".
"AND changeable = ".$ilDB->quote(1,'integer')." ".
"AND ".$ilDB->in('obj_id',$ref_ids,false,'integer')." ".
"AND ".$ilDB->in('parent_id',$ref_ids,false,'integer')." ";
$res = $ilDB->query($query);
return $res->numRows() ? true :false;
}

+ Here is the caller graph for this function:

ilCourseItems::_hasCollectionTimings (   $a_ref_id)

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

References $ilDB, $query, $res, $tree, ilLPCollectionCache\_getItems(), ilLPObjSettings\_lookupMode(), IL_CRS_TIMINGS_PRESETTING, LP_MODE_COLLECTION, and LP_MODE_MANUAL_BY_TUTOR.

Referenced by ilPDFPresentation\__showItems().

{
global $tree,$ilDB,$ilObjDataCache;
// get all collections
include_once 'Services/Tracking/classes/class.ilLPObjSettings.php';
$obj_id = $ilObjDataCache->lookupObjId($a_ref_id);
{
include_once 'Services/Tracking/classes/class.ilLPCollectionCache.php';
break;
default:
$ids = array($a_ref_id);
break;
}
if(!$ids)
{
return false;
}
$query = "SELECT * FROM crs_items ".
"WHERE timing_type = ".$ilDB->quote(IL_CRS_TIMINGS_PRESETTING,'integer')." ".
"AND ".$ilDB->in('obj_id',$ids,false,'integer');
$res = $ilDB->query($query);
return $res->numRows() ? true :false;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::_hasTimings (   $a_ref_id)

check if there is any active timing

public

Parameters
intref_id
Returns

Definition at line 197 of file class.ilCourseItems.php.

References $ilDB, $query, $res, $tree, and IL_CRS_TIMINGS_PRESETTING.

Referenced by ilObjCourseGUI\membersObject().

{
global $tree,$ilDB;
$subtree = $tree->getSubTree($tree->getNodeData($a_ref_id));
foreach($subtree as $node)
{
$ref_ids[] = $node['ref_id'];
}
$query = "SELECT * FROM crs_items ".
"WHERE timing_type = ".$ilDB->quote(IL_CRS_TIMINGS_PRESETTING,'integer')." ".
"AND ".$ilDB->in('obj_id',$ref_ids,false,'integer')." ".
"AND ".$ilDB->in('parent_id',$ref_ids,false,'integer')." ";
$res = $ilDB->query($query);
return $res->numRows() ? true :false;
}

+ Here is the caller graph for this function:

ilCourseItems::_isActivated (   $a_item_id)

Definition at line 998 of file class.ilCourseItems.php.

References $ilDB, $query, $res, $row, and DB_FETCHMODE_OBJECT.

Referenced by ilShopRepositoryExplorer\isVisible(), ilRepositoryExplorer\isVisible(), and ilObjectGUI\isVisible().

{
global $ilDB;
$query = "SELECT * FROM crs_items ".
"WHERE obj_id = ".$ilDB->quote($a_item_id,'integer')." ";
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if($row->activation_unlimited)
{
return true;
}
if(time() > $row->activation_start and time() < $row->activation_end)
{
return true;
}
}
return true;
}

+ Here is the caller graph for this function:

static ilCourseItems::_readActivationTimes (   $a_ref_ids)
static

read activation times

public

Parameters
arrayarray(int) ref_ids

Definition at line 1027 of file class.ilCourseItems.php.

References $ilDB, $query, $res, $row, and DB_FETCHMODE_OBJECT.

Referenced by ilAccessHandler\doActivationCheck(), and ilAccessHandler\preloadActivationTimes().

{
global $ilDB;
if(!is_array($a_ref_ids) or !$a_ref_ids)
{
return array();
}
$query = "SELECT obj_id,timing_type,timing_start,timing_end,visible FROM crs_items ".
"WHERE ".$ilDB->in('obj_id',$a_ref_ids,false,'integer');
$res = $ilDB->query($query);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
$ac_times[(string) $row->obj_id]['obj_id'] = $row->obj_id;
$ac_times[(string) $row->obj_id]['timing_type'] = $row->timing_type;
$ac_times[(string) $row->obj_id]['timing_start'] = $row->timing_start;
$ac_times[(string) $row->obj_id]['timing_end'] = $row->timing_end;
$ac_times[(string) $row->obj_id]['visible'] = $row->visible;
}
return $ac_times ? $ac_times : array();
}

+ Here is the caller graph for this function:

static ilCourseItems::_sort (   $a_sort_mode,
  $a_items 
)
static

sort items

public

Parameters
@return

Definition at line 842 of file class.ilCourseItems.php.

References IL_CRS_TIMINGS_DEACTIVATED, ilContainer\SORT_ACTIVATION, and ilUtil\sortArray().

Referenced by ilCourseContentGUI\__showMaterials().

{
switch($a_sort_mode)
{
// Sort by starting time. If mode is IL_CRS_TIMINGS_DEACTIVATED then sort these items by title and append
// them to the array.
$inactive = $active = array();
foreach($a_items as $item)
{
if($item['timing_type'] == IL_CRS_TIMINGS_DEACTIVATED)
{
$inactive[] = $item;
}
else
{
$active[] = $item;
}
}
$sorted_active = ilUtil::sortArray($active,"start","asc");
$sorted_inactive = ilUtil::sortArray($inactive,'title','asc');
return array_merge($sorted_active,$sorted_inactive);
break;
default:
return $a_items;
}
return true;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::addAdditionalSubItemInformation ( $a_item)

Adds information to object/item array needed to be displayed in repository.

Definition at line 1055 of file class.ilCourseItems.php.

Referenced by ilObjWorkspaceFolder\addAdditionalSubItemInformation(), ilObjFolder\addAdditionalSubItemInformation(), and ilObjGroup\addAdditionalSubItemInformation().

{
if (is_array($this->items_per_child[$a_item["child"]]))
{
$a_item = array_merge($a_item, $this->items_per_child[$a_item["child"]]);
}
}

+ Here is the caller graph for this function:

ilCourseItems::cloneDependencies (   $a_target_id,
  $a_copy_id 
)

Clone dependencies.

public

Parameters
inttarget ref_id
intcopy id

Definition at line 81 of file class.ilCourseItems.php.

References $ilLog, $query, $res, $row, ilCopyWizardOptions\_getInstance(), DB_FETCHMODE_OBJECT, ilObjectFactory\getInstanceByRefId(), getParentId(), ilCourseItems(), and ilDB\query().

Referenced by ilObjWorkspaceFolder\cloneDependencies(), ilObjFolder\cloneDependencies(), and ilObjGroup\cloneDependencies().

{
global $ilObjDataCache,$ilLog;
$ilLog->write(__METHOD__.': Begin course items...');
$target_obj_id = $ilObjDataCache->lookupObjId($a_target_id);
include_once('Services/CopyWizard/classes/class.ilCopyWizardOptions.php');
$cp_options = ilCopyWizardOptions::_getInstance($a_copy_id);
$mappings = $cp_options->getMappings();
$query = "SELECT * FROM crs_items WHERE ".
"parent_id = ".$this->ilDB->quote($this->getParentId(),'integer')." ";
$res = $this->ilDB->query($query);
if(!$res->numRows())
{
$ilLog->write(__METHOD__.': No course items found.');
return true;
}
// new course item object
if(!is_object($new_container = ilObjectFactory::getInstanceByRefId($a_target_id,false)))
{
$ilLog->write(__METHOD__.': Cannot create target object.');
return false;
}
$new_items = new ilCourseItems($this->course_ref_id,$a_target_id);
while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
{
if(!isset($mappings[$row->parent_id]) or !$mappings[$row->parent_id])
{
$ilLog->write(__METHOD__.': No mapping for parent nr. '.$row->parent_id);
continue;
}
if(!isset($mappings[$row->obj_id]) or !$mappings[$row->obj_id])
{
$ilLog->write(__METHOD__.': No mapping for item nr. '.$row->obj_id);
continue;
}
$new_item_id = $mappings[$row->obj_id];
$new_parent = $mappings[$row->parent_id];
$new_items->setItemId($new_item_id);
$new_items->setParentId($new_parent);
$new_items->setTimingType($row->timing_type);
$new_items->setTimingStart($row->timing_start);
$new_items->setTimingEnd($row->timing_end);
$new_items->setSuggestionStart($row->suggestion_start);
$new_items->setSuggestionEnd($row->suggestion_end);
$new_items->toggleChangeable($row->changeable);
$new_items->setEarliestStart($row->earliest_start);
$new_items->setLatestEnd($row->latest_end);
$new_items->toggleVisible($row->visible);
$new_items->update($new_item_id);
$ilLog->write(__METHOD__.': Added new entry for item nr. '.$row->obj_id);
}
$ilLog->write(__METHOD__.': Finished course items.');
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::createDefaultEntry (   $a_item)

Definition at line 737 of file class.ilCourseItems.php.

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

Referenced by __getItemData().

{
global $ilDB, $objDefinition;
$a_item["timing_type"] = IL_CRS_TIMINGS_DEACTIVATED;
$a_item["timing_start"] = time();
$a_item["timing_end"] = time();
$a_item["suggestion_start"] = time();
$a_item["suggestion_end"] = time();
$a_item['visible'] = 0;
$a_item['changeable'] = 0;
$a_item['earliest_start'] = time();
$a_item['latest_end'] = mktime(23,55,00,date('n',time()),date('j',time()),date('Y',time()));
$a_item['visible'] = 0;
$a_item['changeable'] = 0;
$query = "INSERT INTO crs_items (parent_id,obj_id,timing_type,timing_start,timing_end," .
"suggestion_start,suggestion_end, ".
"changeable,earliest_start,latest_end,visible,position) ".
"VALUES( ".
$ilDB->quote($a_item['parent'],'integer').",".
$ilDB->quote($a_item["child"],'integer').",".
$ilDB->quote($a_item["timing_type"],'integer').",".
$ilDB->quote($a_item["timing_start"],'integer').",".
$ilDB->quote($a_item["timing_end"],'integer').",".
$ilDB->quote($a_item["suggestion_start"],'integer').",".
$ilDB->quote($a_item["suggestion_end"],'integer').",".
$ilDB->quote($a_item["changeable"],'integer').",".
$ilDB->quote($a_item['earliest_start'],'integer').", ".
$ilDB->quote($a_item['latest_end'],'integer').", ".
$ilDB->quote($a_item["visible"],'integer').", ".
$ilDB->quote(0,'integer').")";
$res = $ilDB->manipulate($query);
return $a_item;
}

+ Here is the caller graph for this function:

ilCourseItems::deleteAllEntries ( )

Definition at line 534 of file class.ilCourseItems.php.

References $ilDB, $query, and $res.

{
global $ilDB;
$all_items = $this->tree->getChilds($this->parent);
foreach($all_items as $item)
{
$query = "DELETE FROM crs_items ".
"WHERE parent_id = ".$ilDB->quote($item["child"],'integer')."";
$res = $ilDB->manipulate($query);
}
$query = "DELETE FROM crs_items ".
"WHERE parent_id = ".$ilDB->quote($this->course_ref_id,'integer')." ";
$res = $ilDB->manipulate($query);
return true;
}
ilCourseItems::enabledChangeable ( )

Definition at line 319 of file class.ilCourseItems.php.

Referenced by save(), and update().

{
return (bool) $this->changeable;
}

+ Here is the caller graph for this function:

ilCourseItems::enabledVisible ( )

Definition at line 311 of file class.ilCourseItems.php.

Referenced by save(), and update().

{
return (bool) $this->visible;
}

+ Here is the caller graph for this function:

ilCourseItems::getAllItems ( )

Definition at line 329 of file class.ilCourseItems.php.

{
return $this->items ? $this->items : array();
}
ilCourseItems::getEarliestStart ( )

Definition at line 295 of file class.ilCourseItems.php.

Referenced by save(), and update().

{
return $this->earliest_start ? $this->earliest_start : mktime(0,0,1,date('n',time()),date('j',time()),date('Y',time()));
}

+ Here is the caller graph for this function:

ilCourseItems::getFilteredItems (   $a_container_ref_id)

Get all items.

(No events, no side blocks)

Definition at line 337 of file class.ilCourseItems.php.

References ilEventItems\_getItemsOfContainer().

Referenced by ilCourseContentGUI\__editUserTimings().

{
global $objDefinition;
include_once 'Modules/Session/classes/class.ilEventItems.php';
$event_items = ilEventItems::_getItemsOfContainer($a_container_ref_id);
foreach($this->items as $item)
{
if(!in_array($item['ref_id'],$event_items) &&
!$objDefinition->isSideBlock($item['type']))
{
$filtered[] = $item;
}
}
return $filtered ? $filtered : array();
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::getItem (   $a_item_id)

Definition at line 416 of file class.ilCourseItems.php.

Referenced by ilSoapObjectAdministration\updateReferences(), and ilCourseContentGUI\updateTimings().

{
foreach($this->items as $item)
{
if($item["child"] == $a_item_id)
{
return $item;
}
}
return array();
}

+ Here is the caller graph for this function:

ilCourseItems::getItemId ( )

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

Referenced by save().

{
return $this->item_id;
}

+ Here is the caller graph for this function:

ilCourseItems::getItems ( )

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

Referenced by ilCourseContentGUI\__editAdvancedUserTimings(), and ilCourseContentGUI\showUserTimings().

{
global $rbacsystem;
foreach($this->items as $item)
{
if($item["type"] != "rolf" and
($item["timing_type"] or
($item["timing_start"] <= time() and $item["timing_end"] >= time())))
{
if($rbacsystem->checkAccess('visible',$item['ref_id']))
{
$filtered[] = $item;
}
}
}
return $filtered ? $filtered : array();
}

+ Here is the caller graph for this function:

ilCourseItems::getItemsByEvent (   $a_event_id)

Definition at line 355 of file class.ilCourseItems.php.

References $items, and __getItemData().

{
include_once 'Modules/Session/classes/class.ilEventItems.php';
$event_items_obj = new ilEventItems($a_event_id);
$event_items = $event_items_obj->getItems();
foreach($event_items as $item)
{
if($this->tree->isDeleted($item))
{
continue;
}
// #7571: when node is removed from system, e.g. inactive trashcan, an empty array is returned
$node = $this->tree->getNodeData($item);
if($node["ref_id"] == $item)
{
$items[] = $this->__getItemData($node);
}
}
return $items ? $items : array();
}

+ Here is the call graph for this function:

ilCourseItems::getItemsByObjective (   $a_objective_id)

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

References $items, $ref_id, __getItemData(), and ilCourseObjectiveMaterials\_getAssignedMaterials().

{
include_once('./Modules/Course/classes/class.ilCourseObjectiveMaterials.php');
{
if($this->tree->isDeleted($ref_id))
{
continue;
}
// #7571: when node is removed from system, e.g. inactive trashcan, an empty array is returned
$node = $this->tree->getNodeData($ref_id);
if($node["ref_id"] == $ref_id)
{
$items[] = $this->__getItemData($node);
}
}
return $items ? $items : array();
}

+ Here is the call graph for this function:

ilCourseItems::getLatestEnd ( )

Definition at line 303 of file class.ilCourseItems.php.

Referenced by save(), and update().

{
return $this->latest_end ? $this->latest_end : mktime(23,55,00,date('n',time()),date('j',time()),date('Y',time()));
}

+ Here is the caller graph for this function:

ilCourseItems::getParentId ( )

Definition at line 245 of file class.ilCourseItems.php.

References $parent.

Referenced by __delete(), __getLastPosition(), __purgeDeleted(), __switchNodes(), cloneDependencies(), save(), and update().

{
return $this->parent;
}

+ Here is the caller graph for this function:

ilCourseItems::getSuggestionEnd ( )

Definition at line 287 of file class.ilCourseItems.php.

Referenced by save(), update(), and validateActivation().

{
return $this->suggestion_end ? $this->suggestion_end : mktime(23,55,00,date('n',time()),date('j',time()),date('Y',time()));
}

+ Here is the caller graph for this function:

ilCourseItems::getSuggestionStart ( )

Definition at line 279 of file class.ilCourseItems.php.

Referenced by save(), update(), and validateActivation().

{
return $this->suggestion_start ? $this->suggestion_start : mktime(0,0,1,date('n',time()),date('j',time()),date('Y',time()));
}

+ Here is the caller graph for this function:

ilCourseItems::getTimingEnd ( )

Definition at line 271 of file class.ilCourseItems.php.

References $timing_end.

Referenced by save(), update(), and validateActivation().

{
}

+ Here is the caller graph for this function:

ilCourseItems::getTimingStart ( )

Definition at line 263 of file class.ilCourseItems.php.

References $timing_start.

Referenced by save(), update(), and validateActivation().

{
}

+ Here is the caller graph for this function:

ilCourseItems::getTimingType ( )

Definition at line 254 of file class.ilCourseItems.php.

References $timing_type.

Referenced by save(), update(), and validateActivation().

{
}

+ Here is the caller graph for this function:

ilCourseItems::getUserId ( )

Definition at line 151 of file class.ilCourseItems.php.

Referenced by __getItemData().

{
global $ilUser;
return $this->user_id ? $this->user_id : $ilUser->getId();
}

+ Here is the caller graph for this function:

ilCourseItems::ilCourseItems (   $a_course_ref_id,
  $a_parent = 0,
  $user_id = 0 
)

Definition at line 56 of file class.ilCourseItems.php.

References $ilDB, $ilErr, $lng, $tree, and setParentId().

Referenced by cloneDependencies().

{
$this->ilErr =& $ilErr;
$this->ilDB =& $ilDB;
$this->lng =& $lng;
$this->tree =& $tree;
$this->course_ref_id = $a_course_ref_id;
$this->user_id = $user_id;
$this->setParentId($a_parent); // this implicitly calls __read
//$this->__read();
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::moveDown (   $item_id)

Definition at line 527 of file class.ilCourseItems.php.

References __read().

{
$this->__read();
return true;
}

+ Here is the call graph for this function:

ilCourseItems::moveUp (   $item_id)

Definition at line 521 of file class.ilCourseItems.php.

References __read().

{
$this->__read();
return true;
}

+ Here is the call graph for this function:

ilCourseItems::save ( )

Save.

public

Definition at line 474 of file class.ilCourseItems.php.

References $ilDB, $ilLog, $query, $res, enabledChangeable(), enabledVisible(), getEarliestStart(), getItemId(), getLatestEnd(), getParentId(), getSuggestionEnd(), getSuggestionStart(), getTimingEnd(), getTimingStart(), and getTimingType().

{
global $ilLog,$ilDB;
$query = "INSERT INTO crs_items (timing_type,timing_start,timing_end,".
"suggestion_start,suggestion_end, ".
"changeable,earliest_start,latest_end,visible,parent_id,obj_id) ".
"VALUES( ".
$ilDB->quote($this->getTimingType(),'integer').", ".
$ilDB->quote($this->getTimingStart(),'integer').", ".
$ilDB->quote($this->getTimingEnd(),'integer').", ".
$ilDB->quote($this->getSuggestionStart(),'integer').", ".
$ilDB->quote($this->getSuggestionEnd(),'integer').", ".
$ilDB->quote($this->enabledChangeable(),'integer').", ".
$ilDB->quote($this->getEarliestStart(),'integer').", ".
$ilDB->quote($this->getLatestEnd(),'integer').", ".
$ilDB->quote($this->enabledVisible(),'integer').", ".
$ilDB->quote($this->getParentId(),'integer').", ".
$ilDB->quote($this->getItemId(),'integer')." ".
")";
$res = $ilDB->manipulate($query);
}

+ Here is the call graph for this function:

ilCourseItems::setEarliestStart (   $a_start)

Definition at line 291 of file class.ilCourseItems.php.

{
$this->earliest_start = $a_start;
}
ilCourseItems::setItemId (   $a_item_id)

Definition at line 142 of file class.ilCourseItems.php.

{
$this->item_id = $a_item_id;
}
ilCourseItems::setLatestEnd (   $a_end)

Definition at line 299 of file class.ilCourseItems.php.

{
$this->latest_end = $a_end;
}
ilCourseItems::setParentId (   $a_parent = 0)

Definition at line 238 of file class.ilCourseItems.php.

References $course_ref_id, and __read().

Referenced by ilCourseItems().

{
$this->parent = $a_parent ? $a_parent : $this->course_ref_id;
$this->__read();
return true;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilCourseItems::setPosition (   $a_pos)

Definition at line 324 of file class.ilCourseItems.php.

{
$this->position = $a_pos;
}
ilCourseItems::setSuggestionEnd (   $a_end)

Definition at line 283 of file class.ilCourseItems.php.

{
$this->suggestion_end = $a_end;
}
ilCourseItems::setSuggestionStart (   $a_start)

Definition at line 275 of file class.ilCourseItems.php.

{
$this->suggestion_start = $a_start;
}
ilCourseItems::setTimingEnd (   $a_end)

Definition at line 267 of file class.ilCourseItems.php.

{
$this->timing_end = $a_end;
}
ilCourseItems::setTimingStart (   $a_start)

Definition at line 259 of file class.ilCourseItems.php.

{
$this->timing_start = $a_start;
}
ilCourseItems::setTimingType (   $a_type)

Definition at line 250 of file class.ilCourseItems.php.

{
$this->timing_type = $a_type;
}
ilCourseItems::toggleChangeable (   $a_status)

Definition at line 315 of file class.ilCourseItems.php.

{
$this->changeable = (int) $a_status;
}
ilCourseItems::toggleVisible (   $a_status)

Definition at line 307 of file class.ilCourseItems.php.

{
$this->visible = (int) $a_status;
}
ilCourseItems::update (   $a_item_id)

Definition at line 498 of file class.ilCourseItems.php.

References $ilDB, $query, $res, __read(), enabledChangeable(), enabledVisible(), getEarliestStart(), getLatestEnd(), getParentId(), getSuggestionEnd(), getSuggestionStart(), getTimingEnd(), getTimingStart(), and getTimingType().

{
global $ilDB;
$query = "UPDATE crs_items SET ".
"timing_type = ".$ilDB->quote($this->getTimingType(),'integer').", ".
"timing_start = ".$ilDB->quote($this->getTimingStart(),'integer').", ".
"timing_end = ".$ilDB->quote($this->getTimingEnd(),'integer').", ".
"suggestion_start = ".$ilDB->quote($this->getSuggestionStart(),'integer').", ".
"suggestion_end = ".$ilDB->quote($this->getSuggestionEnd(),'integer').", ".
"changeable = ".$ilDB->quote($this->enabledChangeable(),'integer').", ".
"earliest_start = ".$ilDB->quote($this->getEarliestStart(),'integer').", ".
"latest_end = ".$ilDB->quote($this->getLatestEnd(),'integer').", ".
"visible = ".$ilDB->quote($this->enabledVisible(),'integer')." ".
"WHERE parent_id = ".$ilDB->quote($this->getParentId(),'integer')." ".
"AND obj_id = ".$ilDB->quote($a_item_id,'integer')."";
$res = $ilDB->manipulate($query);
$this->__read();
return true;
}

+ Here is the call graph for this function:

ilCourseItems::validateActivation ( )

Definition at line 428 of file class.ilCourseItems.php.

References $ilErr, getSuggestionEnd(), getSuggestionStart(), getTimingEnd(), getTimingStart(), getTimingType(), IL_CRS_TIMINGS_ACTIVATION, and IL_CRS_TIMINGS_PRESETTING.

{
global $ilErr;
$ilErr->setMessage('');
{
if($this->getTimingStart() > $this->getTimingEnd())
{
$ilErr->appendMessage($this->lng->txt("crs_activation_start_invalid"));
}
}
{
if($this->getSuggestionStart() > $this->getSuggestionEnd())
{
$ilErr->appendMessage($this->lng->txt('crs_latest_end_not_valid'));
}
}
// Disabled
#if($this->getTimingType() == IL_CRS_TIMINGS_PRESETTING and
# $this->enabledChangeable())
#{
# if($this->getSuggestionStart() < $this->getEarliestStart() or
# $this->getSuggestionEnd() > $this->getLatestEnd() or
# $this->getSuggestionStart() > $this->getLatestEnd() or
# $this->getSuggestionEnd() < $this->getEarliestStart())
# {
# $ilErr->appendMessage($this->lng->txt("crs_suggestion_not_within_activation"));
# }
#}
if($ilErr->getMessage())
{
return false;
}
return true;
}

+ Here is the call graph for this function:

Field Documentation

ilCourseItems::$course_ref_id
private

Definition at line 41 of file class.ilCourseItems.php.

Referenced by setParentId().

ilCourseItems::$ilErr

Definition at line 43 of file class.ilCourseItems.php.

Referenced by ilCourseItems(), and validateActivation().

ilCourseItems::$items

Definition at line 48 of file class.ilCourseItems.php.

Referenced by getItemsByEvent(), and getItemsByObjective().

ilCourseItems::$lng

Definition at line 46 of file class.ilCourseItems.php.

Referenced by ilCourseItems().

ilCourseItems::$parent

Definition at line 49 of file class.ilCourseItems.php.

Referenced by getParentId().

ilCourseItems::$timing_end

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

Referenced by getTimingEnd().

ilCourseItems::$timing_start

Definition at line 52 of file class.ilCourseItems.php.

Referenced by getTimingStart().

ilCourseItems::$timing_type

Definition at line 51 of file class.ilCourseItems.php.

Referenced by getTimingType().

ilCourseItems::$tree

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