ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilDAVProperties.php
Go to the documentation of this file.
1 <?php
2 // BEGIN WebDAV
3 /*
4  +-----------------------------------------------------------------------------+
5  | ILIAS open source |
6  +-----------------------------------------------------------------------------+
7  | Copyright (c) 1998-2005 ILIAS open source, University of Cologne |
8  | |
9  | This program is free software; you can redistribute it and/or |
10  | modify it under the terms of the GNU General Public License |
11  | as published by the Free Software Foundation; either version 2 |
12  | of the License, or (at your option) any later version. |
13  | |
14  | This program is distributed in the hope that it will be useful, |
15  | but WITHOUT ANY WARRANTY; without even the implied warranty of |
16  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
17  | GNU General Public License for more details. |
18  | |
19  | You should have received a copy of the GNU General Public License |
20  | along with this program; if not, write to the Free Software |
21  | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
22  +-----------------------------------------------------------------------------+
23 */
24 
25 
37 class ilDAVProperties
38 {
39  private $table = 'dav_property';
40 
41 
50  public function put($objDAV, $namespace, $name, $value)
51  {
52  //$this->writelog('put ns='.$namespace.' name='.$name.' value='.$value);
53  global $ilDB;
54 
55  $objId = $objDAV->getObjectId();
56  $nodeId = $objDAV->getNodeId();
57 
58  if(isset($value))
59  {
60  $ilDB->replace($this->table,
61  array(
62  'obj_id' => array('integer',$objId),
63  'node_id' => array('integer',$nodeId),
64  'ns' => array('text',$namespace),
65  'name' => array('text',$name)
66  ),
67  array('value' => array('clob',$value))
68  );
69 
70  /*
71  $q = 'REPLACE INTO '.$this->table
72  .' SET obj_id = '.$ilDB->quote($objId)
73  .', node_id = '.$ilDB->quote($nodeId)
74  .', ns = '.$ilDB->quote($namespace)
75  .', name = '.$ilDB->quote($name)
76  .', value = '.$ilDB->quote($value)
77  ;
78  */
79  }
80  else
81  {
82  $q = 'DELETE FROM '.$this->table
83  .' WHERE obj_id = '.$ilDB->quote($objId,'integer')
84  .' AND node_id = '.$ilDB->quote($nodeId,'integer')
85  .' AND ns = '.$ilDB->quote($namespace,'text')
86  .' AND name = '.$ilDB->quote($name,'text')
87  ;
88  $ilDB->manipulate($q);
89  }
90  //$this->writelog('put query='.$q);
91  #$r = $ilDB->query($q);
92  }
93 
102  public function get($objDAV, $namespace, $name, $value)
103  {
104  global $ilDB;
105 
106  $objId = $objDAV->getObjectId();
107  $nodeId = $objDAV->getNodeId();
108 
109  $q = 'SELECT value FROM '.$this->table
110  .' WHERE obj_id = '.$ilDB->quote($objId,'integer')
111  .' AND node_id ='.$ilDB->quote($nodeId,'integer')
112  .' AND ns = '.$ilDB->quote($namespace,'text')
113  .' AND name = '.$ilDB->quote($name,'text')
114  ;
115  $r = $ilDB->query($q);
116  if ($row = $r->fetchRow(DB_FETCHMODE_ASSOC))
117  {
118  $value = $row['value'];
119  } else {
120  $value = null;
121  }
122  return $value;
123  }
131  public function getAll($objDAV)
132  {
133  global $ilDB;
134 
135  $objId = $objDAV->getObjectId();
136  $nodeId = $objDAV->getNodeId();
137 
138  $q = 'SELECT ns, name, value'
139  .' FROM '.$this->table
140  .' WHERE obj_id = '.$ilDB->quote($objId,'integer')
141  .' AND node_id ='.$ilDB->quote($nodeId,'integer')
142  ;
143  $r = $ilDB->query($q);
144  $result = array();
145  while ($row = $r->fetchRow(DB_FETCHMODE_ASSOC))
146  {
147  $result[] = array(
148  'namespace' => $row['ns'],
149  'name' => $row['name'],
150  'value' => $row['value']
151  );
152  }
153  return $result;
154  }
155 
179  public function copy($fromObjDAV, $toObjDAV)
180  {
181  global $ilDB;
182 
183  $fromObjId = $fromObjDAV->getObjectId();
184  $fromNodeId = $fromObjDAV->getNodeId();
185  $toObjId = $toObjDAV->getObjectId();
186  $toNodeId = $toObjDAV->getNodeId();
187 
188  $q = 'SELECT ns, name, value FROM '.$this->table
189  .' WHERE obj_id = '.$ilDB->quote($objId,'integer')
190  .' AND node_id ='.$ilDB->quote($nodeId,'integer');
191 /* .' FOR UPDATE' */
192  $r = $ilDB->query($q);
193  $result = array();
194  while ($row = $r->fetchRow(DB_FETCHMODE_ASSOC))
195  {
196  $q2 = 'INSERT INTO '.$this->table
197  .' (obj_id, node_id, ns, name, value)'
198  .' VALUES'
199  .'('.$ilDB->quote($row['obj_id'])
200  .', '.$ilDB->quote($row['node_id'])
201  .', '.$ilDB->quote($row['ns'])
202  .', '.$ilDB->quote($row['name'])
203  .', '.$ilDB->quote($row['value'])
204  .')'
205  ;
206  $r2 = $ilDB->manipulate($q2);
207  }
208  }
209 
216  protected function writelog($message)
217  {
218  global $log, $ilias;
219  $log->write(
220  $ilias->account->getLogin()
221  .' DAV ilDAVProperties.'.str_replace("\n",";",$message)
222  );
223  /*
224  if ($this->logFile)
225  {
226  $fh = fopen($this->logFile, 'a');
227  fwrite($fh, date('Y-m-d h:i:s '));
228  fwrite($fh, str_replace("\n",";",$message));
229  fwrite($fh, "\n\n");
230  fclose($fh);
231  }*/
232  }
233 }
234 // END WebDAV
235 ?>
$namespace
if($err=$client->getError()) $namespace
Definition: dummy_client.php:51
ilDAVProperties\writelog
writelog($message)
Writes a message to the logfile.,.
Definition: class.ilDAVProperties.php:216
$result
$result
Definition: CleanUpTest.php:407
ilDAVProperties\getAll
getAll($objDAV)
Gets all properties from the specified DAV object.
Definition: class.ilDAVProperties.php:131
ilDAVProperties\put
put($objDAV, $namespace, $name, $value)
Puts a property for the specified DAV object.
Definition: class.ilDAVProperties.php:50
$r
$r
Definition: example_031.php:79
ilDAVProperties\copy
copy($fromObjDAV, $toObjDAV)
Moves all properties from one dav object to another.
Definition: class.ilDAVProperties.php:179
DB_FETCHMODE_ASSOC
const DB_FETCHMODE_ASSOC
Definition: class.ilDB.php:10
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
$log
$log
Definition: inc.setup_header.php:135