ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilECSCourseAttribute.php
Go to the documentation of this file.
1<?php
2
3/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
4
11{
12 private $id = 0;
13 private $server_id = 0;
14 private $mid = 0;
15 private $name = '';
16
21 public function __construct($a_id = 0)
22 {
23 $this->id = $a_id;
24
25 $this->read();
26 }
27
32 public function getId()
33 {
34 return $this->id;
35 }
36
37 public function setServerId($a_server_id)
38 {
39 $this->server_id = $a_server_id;
40 }
41
42 public function getServerId()
43 {
44 return $this->server_id;
45 }
46
47 public function setMid($a_mid)
48 {
49 $this->mid = $a_mid;
50 }
51
52 public function getMid()
53 {
54 return $this->mid;
55 }
56
57
58 public function setName($a_name)
59 {
60 $this->name = $a_name;
61 }
62
67 public function getName()
68 {
69 return $this->name;
70 }
71
77 public function delete()
78 {
79 global $ilDB;
80
81 $query = "DELETE FROM ecs_crs_mapping_atts ".
82 'WHERE id = '.$ilDB->quote($this->getId(),'integer');
83 $ilDB->manipulate($query);
84 return true;
85 }
86
92 public function save()
93 {
94 global $ilDB;
95
96 $this->id = $ilDB->nextId('ecs_crs_mapping_atts');
97
98 $query = 'INSERT INTO ecs_crs_mapping_atts (id,sid,mid,name) '.
99 'VALUES ( '.
100 $ilDB->quote($this->getId(),'integer').', '.
101 $ilDB->quote($this->getServerId(),'integer').', '.
102 $ilDB->quote($this->getMid(),'integer').', '.
103 $ilDB->quote($this->getName(),'text').' '.
104 ') ';
105 $ilDB->manipulate($query);
106 return true;
107 }
108
109
110
114 protected function read()
115 {
116 global $ilDB;
117
118 if(!$this->getId())
119 {
120 return true;
121 }
122
123
124 $query = 'SELECT * FROM ecs_crs_mapping_atts '.
125 'WHERE id = '.$ilDB->quote($this->getId(),'integer');
126 $res = $ilDB->query($query);
127 while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
128 {
129 $this->setName($row->name);
130 }
131 return true;
132 }
133}
134?>
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
Storage of course attributes for assignment rules.
save()
Save a new entry @global type $ilDB.
read()
read active attributes
__construct($a_id=0)
Constructor.
global $ilDB