ILIAS  release_5-4 Revision v5.4.26-12-gabc799a52e6
ilSkillTemplateReference Class Reference

Skill Template Reference. More...

+ Inheritance diagram for ilSkillTemplateReference:
+ Collaboration diagram for ilSkillTemplateReference:

Public Member Functions

 __construct ($a_id=0)
 Constructor public. More...
 
 setSkillTemplateId ($a_val)
 Set skill template id. More...
 
 getSkillTemplateId ()
 Get skill template id. More...
 
 read ()
 Read data from database. More...
 
 create ()
 Create skill template reference. More...
 
 update ()
 Update node. More...
 
 delete ()
 Delete skill. More...
 
 copy ()
 Copy basic skill template. More...
 
- Public Member Functions inherited from ilSkillTreeNode
 __construct ($a_id=0)
 
 setTitle ($a_title)
 Set title. More...
 
 getTitle ()
 Get title. More...
 
 setType ($a_type)
 Set type. More...
 
 getType ()
 Get type. More...
 
 setId ($a_id)
 Set Node ID. More...
 
 getId ()
 Get Node ID. More...
 
 setSelfEvaluation ($a_val)
 Set self evaluation. More...
 
 getSelfEvaluation ()
 Get self evaluation. More...
 
 setOrderNr ($a_val)
 Set order nr. More...
 
 getOrderNr ()
 Get order nr. More...
 
 setImportId ($a_val)
 Set import id. More...
 
 getImportId ()
 Get import id. More...
 
 getCreationDate ()
 Get creation date. More...
 
 read ()
 Read Data of Node. More...
 
 setDataRecord ($a_record)
 this method should only be called by class ilSCORM2004NodeFactory More...
 
 setStatus ($a_val)
 Set status. More...
 
 getStatus ()
 Get status. More...
 
 create ()
 Create Node. More...
 
 update ()
 Update Node. More...
 
 delete ()
 Delete Node. More...
 

Static Public Member Functions

static _lookupTemplateId ($a_obj_id)
 Lookup template ID. More...
 
static _lookupTrefIdsForTopTemplateId ($a_template_id)
 Lookup tref ids for template id. More...
 
static _lookupTrefIdsForTemplateId ($a_tid)
 Get all tref ids for a template id. More...
 
- Static Public Member Functions inherited from ilSkillTreeNode
static getAllStatus ()
 Get all status. More...
 
static getStatusInfo ($a_status)
 Get status info. More...
 
static _lookupTitle ($a_obj_id, $a_tref_id=0)
 Lookup Title. More...
 
static _lookupSelfEvaluation ($a_obj_id)
 Lookup self evaluation. More...
 
static _lookupStatus ($a_obj_id)
 Lookup Status. More...
 
static _lookupType ($a_obj_id)
 Lookup Type. More...
 
static _writeTitle ($a_obj_id, $a_title)
 Write Title. More...
 
static _writeOrderNr ($a_obj_id, $a_nr)
 Write Order Nr. More...
 
static putInTree ($a_obj, $a_parent_id="", $a_target_node_id="")
 Put this object into the skill tree. More...
 
static getTree ($a_slm_obj_id)
 Get scorm module editing tree. More...
 
static uniqueTypesCheck ($a_items)
 Check for unique types. More...
 
static clipboardCut ($a_tree_id, $a_ids)
 Cut and copy a set of skills/skill categories into the clipboard. More...
 
static clipboardCopy ($a_tree_id, $a_ids)
 Copy a set of skills/skill categories into the clipboard. More...
 
static insertItemsFromClip ($a_type, $a_obj_id)
 Insert basic skills from clipboard. More...
 
static clearClipboard ()
 Remove all skill items from clipboard. More...
 
static pasteTree ( $a_item_id, $a_parent_id, $a_target, $a_insert_time, &$a_copied_nodes, $a_as_copy=false, $a_add_suffix=false)
 Paste item (tree) from clipboard to skill tree. More...
 
static isInTree ($a_id)
 Is id in tree? More...
 
static getAllSelfEvaluationNodes ()
 Get all self evaluation nodes. More...
 
static getTopTemplates ()
 Get top skill templates and template categories. More...
 
static getSelectableSkills ()
 Get selectable skills. More...
 
static saveChildsOrder ($a_par_id, $a_childs_order, $a_templates=false)
 Save childs order. More...
 
static getIconPath ($a_obj_id, $a_type, $a_size="", $a_status=0)
 Get icon path. More...
 
static findSkills ($a_term)
 Find skills. More...
 
static getAllCSkillIdsForNodeIds (array $a_node_ids)
 Get all possible common skill IDs for node IDs. More...
 

Data Fields

 $id
 
- Data Fields inherited from ilSkillTreeNode
const STATUS_PUBLISH = 0
 
const STATUS_DRAFT = 1
 
const STATUS_OUTDATED = 2
 
 $type
 
 $id
 
 $title
 

Protected Attributes

 $db
 
- Protected Attributes inherited from ilSkillTreeNode
 $db
 

Additional Inherited Members

- Protected Member Functions inherited from ilSkillTreeNode
 setCreationDate ($a_val)
 Set creation date. More...
 
- Static Protected Member Functions inherited from ilSkillTreeNode
static _lookup ($a_obj_id, $a_field)
 Lookup Title. More...
 

Detailed Description

Skill Template Reference.

Author
Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e
Version
$Id$

Definition at line 15 of file class.ilSkillTemplateReference.php.

Constructor & Destructor Documentation

◆ __construct()

ilSkillTemplateReference::__construct (   $a_id = 0)

Constructor public.

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

References $DIC, and ilSkillTreeNode\setType().

29  {
30  global $DIC;
31 
32  $this->db = $DIC->database();
33  parent::__construct($a_id);
34  $this->setType("sktr");
35  }
setType($a_type)
Set type.
global $DIC
Definition: saml.php:7
+ Here is the call graph for this function:

Member Function Documentation

◆ _lookupTemplateId()

static ilSkillTemplateReference::_lookupTemplateId (   $a_obj_id)
static

Lookup template ID.

Parameters
intnode ID
Returns
string template ID

Definition at line 144 of file class.ilSkillTemplateReference.php.

References $DIC, $ilDB, and $query.

Referenced by ilSkillTreeNode\_lookupTitle(), ilPersonalSkillsGUI\assignMaterials(), ilSurveySkillExplorer\buildTitle(), ilCOPageHTMLExport\collectPageElements(), ilObjSkillManagementGUI\deleteNodes(), ilSkillCatTableGUI\fillRow(), ilSkillTreeNode\findSkills(), ilSkillTreeNode\getAllCSkillIdsForNodeIds(), ilVirtualSkillTree\getChildsOfNode(), ilBasicSkill\getCommonSkillIdForImportId(), ilSkillTreeNode\getIconPath(), ilVirtualSkillTree\getNode(), ilSkillTreeExplorerGUI\getNodeContent(), ilSkillTemplateTreeExplorerGUI\getNodeContent(), ilSkillTree\getSkillTreePath(), ilPersonalSkill\getUsageInfo(), ilPersonalSkillsGUI\renderSkillHTML(), ilPersonalSkillsGUI\selfEvaluation(), and ilSkillTemplateReferenceGUI\setTabs().

145  {
146  global $DIC;
147 
148  $ilDB = $DIC->database();
149 
150  $query = "SELECT templ_id FROM skl_templ_ref WHERE skl_node_id = " .
151  $ilDB->quote($a_obj_id, "integer");
152  $obj_set = $ilDB->query($query);
153  $obj_rec = $ilDB->fetchAssoc($obj_set);
154 
155  return $obj_rec["templ_id"];
156  }
global $DIC
Definition: saml.php:7
$query
global $ilDB
+ Here is the caller graph for this function:

◆ _lookupTrefIdsForTemplateId()

static ilSkillTemplateReference::_lookupTrefIdsForTemplateId (   $a_tid)
static

Get all tref ids for a template id.

Parameters
int$a_tidtemplate node id (node id in template tree)
Returns
array of ids

Definition at line 188 of file class.ilSkillTemplateReference.php.

References $tree.

Referenced by ilObjSkillManagementGUI\deleteNodes(), ilSkillTreeNode\getAllCSkillIdsForNodeIds(), and ilSkillUsage\getAllUsagesOfTemplate().

189  {
190  include_once("./Services/Skill/classes/class.ilSkillTree.php");
191  $tree = new ilSkillTree();
192  $top_template_id = $tree->getTopParentNodeId($a_tid);
193  return self::_lookupTrefIdsForTopTemplateId($top_template_id);
194  }
Skill tree.
+ Here is the caller graph for this function:

◆ _lookupTrefIdsForTopTemplateId()

static ilSkillTemplateReference::_lookupTrefIdsForTopTemplateId (   $a_template_id)
static

Lookup tref ids for template id.

Parameters
$a_template_id(top) template node id
Returns
array array of integer tref ids

Definition at line 164 of file class.ilSkillTemplateReference.php.

References $DIC, and $ilDB.

Referenced by ilSkillTreeNode\findSkills().

165  {
166  global $DIC;
167 
168  $ilDB = $DIC->database();
169 
170  $set = $ilDB->query(
171  "SELECT * FROM skl_templ_ref " .
172  " WHERE templ_id = " . $ilDB->quote($a_template_id, "integer")
173  );
174  $trefs = array();
175  while ($rec = $ilDB->fetchAssoc($set)) {
176  $trefs[] = $rec["skl_node_id"];
177  }
178  return $trefs;
179  }
global $DIC
Definition: saml.php:7
global $ilDB
+ Here is the caller graph for this function:

◆ copy()

ilSkillTemplateReference::copy ( )

Copy basic skill template.

Definition at line 125 of file class.ilSkillTemplateReference.php.

References ilSkillTreeNode\getOrderNr(), ilSkillTreeNode\getSelfEvaluation(), getSkillTemplateId(), ilSkillTreeNode\getTitle(), and ilSkillTreeNode\getType().

126  {
127  $sktr = new ilSkillTemplateReference();
128  $sktr->setTitle($this->getTitle());
129  $sktr->setType($this->getType());
130  $sktr->setSkillTemplateId($this->getSkillTemplateId());
131  $sktr->setSelfEvaluation($this->getSelfEvaluation());
132  $sktr->setOrderNr($this->getOrderNr());
133  $sktr->create();
134 
135  return $sktr;
136  }
getSkillTemplateId()
Get skill template id.
getSelfEvaluation()
Get self evaluation.
getOrderNr()
Get order nr.
+ Here is the call graph for this function:

◆ create()

ilSkillTemplateReference::create ( )

Create skill template reference.

Definition at line 77 of file class.ilSkillTemplateReference.php.

References $db, and $ilDB.

78  {
79  $ilDB = $this->db;
80 
81  parent::create();
82 
83  $ilDB->manipulate("INSERT INTO skl_templ_ref " .
84  "(skl_node_id, templ_id) VALUES (" .
85  $ilDB->quote($this->getId(), "integer") . "," .
86  $ilDB->quote($this->getSkillTemplateId(), "integer") .
87  ")");
88  }
global $ilDB

◆ delete()

ilSkillTemplateReference::delete ( )

Delete skill.

Definition at line 110 of file class.ilSkillTemplateReference.php.

References $db, and $ilDB.

111  {
112  $ilDB = $this->db;
113 
114  $ilDB->manipulate(
115  "DELETE FROM skl_templ_ref WHERE "
116  . " skl_node_id = " . $ilDB->quote($this->getId(), "integer")
117  );
118 
119  parent::delete();
120  }
global $ilDB

◆ getSkillTemplateId()

ilSkillTemplateReference::getSkillTemplateId ( )

Get skill template id.

Returns
int skill template id

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

Referenced by copy().

53  {
54  return $this->skill_template_id;
55  }
+ Here is the caller graph for this function:

◆ read()

ilSkillTemplateReference::read ( )

Read data from database.

Definition at line 60 of file class.ilSkillTemplateReference.php.

References $db, $ilDB, and setSkillTemplateId().

61  {
62  $ilDB = $this->db;
63 
64  parent::read();
65 
66  $set = $ilDB->query(
67  "SELECT * FROM skl_templ_ref " .
68  " WHERE skl_node_id = " . $ilDB->quote($this->getId(), "integer")
69  );
70  $rec = $ilDB->fetchAssoc($set);
71  $this->setSkillTemplateId((int) $rec["templ_id"]);
72  }
setSkillTemplateId($a_val)
Set skill template id.
global $ilDB
+ Here is the call graph for this function:

◆ setSkillTemplateId()

ilSkillTemplateReference::setSkillTemplateId (   $a_val)

Set skill template id.

Parameters
int$a_valskill template id

Definition at line 42 of file class.ilSkillTemplateReference.php.

Referenced by read().

43  {
44  $this->skill_template_id = $a_val;
45  }
+ Here is the caller graph for this function:

◆ update()

ilSkillTemplateReference::update ( )

Update node.

Definition at line 93 of file class.ilSkillTemplateReference.php.

References $db, $ilDB, and League\Flysystem\Adapter\Polyfill\update().

94  {
95  $ilDB = $this->db;
96 
98 
99  $ilDB->manipulate(
100  "UPDATE skl_templ_ref SET " .
101  " templ_id = " . $ilDB->quote($this->getSkillTemplateId(), "integer") .
102  " WHERE skl_node_id = " . $ilDB->quote($this->getId(), "integer")
103  );
104  }
update($pash, $contents, Config $config)
global $ilDB
+ Here is the call graph for this function:

Field Documentation

◆ $db

ilSkillTemplateReference::$db
protected

Definition at line 20 of file class.ilSkillTemplateReference.php.

Referenced by create(), delete(), read(), and update().

◆ $id

ilSkillTemplateReference::$id

Definition at line 22 of file class.ilSkillTemplateReference.php.


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