ILIAS  release_4-3 Revision
 All Data Structures Namespaces Files Functions Variables Groups Pages
class.ilObjUserFolder.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
3 
4 
14 require_once "./Services/Object/classes/class.ilObject.php";
15 
16 define('USER_FOLDER_ID',7);
17 
18 class ilObjUserFolder extends ilObject
19 {
26  function ilObjUserFolder($a_id,$a_call_by_reference = true)
27  {
28  $this->type = "usrf";
29  $this->ilObject($a_id,$a_call_by_reference);
30  }
31 
32 
39  function delete()
40  {
41  // DISABLED
42  return false;
43 
44  // always call parent delete function first!!
45  if (!parent::delete())
46  {
47  return false;
48  }
49  // put here userfolder specific stuff
50 
51  // always call parent delete function at the end!!
52  return true;
53  }
54 
55 
56  function getExportFilename($a_mode = "userfolder_export_excel_x86")
57  {
58  $filename = "";
59  //$settings = $this->ilias->getAllSettings();
60  //$this->inst_id = $settings["inst_id"];
61  $inst_id = IL_INST_ID;
62 
63  $date = time();
64 
65  switch($a_mode)
66  {
67  case "userfolder_export_excel_x86":
68  $filename = $date."__".$inst_id."__xls_usrf.xls";
69  break;
70  case "userfolder_export_csv":
71  $filename = $date."__".$inst_id."__csv_usrf.csv";
72  break;
73  case "userfolder_export_xml":
74  $filename = $date."__".$inst_id."__xml_usrf.xml";
75  break;
76  }
77  return $filename;
78  }
79 
80 
88  function getExportDirectory()
89  {
90  $export_dir = ilUtil::getDataDir()."/usrf_data/export";
91 
92  return $export_dir;
93  }
94 
103  function getExportFiles()
104  {
105  $dir = $this->getExportDirectory();
106 
107  // quit if export dir not available
108  if (!@is_dir($dir) or
109  !is_writeable($dir))
110  {
111  return array();
112  }
113 
114  // open directory
115  $dir = dir($dir);
116 
117  // initialize array
118  $file = array();
119 
120  // get files and save the in the array
121  while ($entry = $dir->read())
122  {
123  if ($entry != "." and
124  $entry != ".." and
125  preg_match("/^[0-9]{10}_{2}[0-9]+_{2}([a-z0-9]{3})_usrf\.[a-z]{1,3}\$/", $entry, $matches))
126  {
127  $filearray["filename"] = $entry;
128  $filearray["filesize"] = filesize($this->getExportDirectory()."/".$entry);
129  array_push($file, $filearray);
130  }
131  }
132 
133  // close import directory
134  $dir->close();
135 
136  // sort files
137  sort ($file);
138  reset ($file);
139 
140  return $file;
141  }
142 
143  function escapeXML($value)
144  {
145  $value = str_replace("&", "&amp;", $value);
146  $value = str_replace("<", "&lt;", $value);
147  $value = str_replace(">", "&gt;", $value);
148  return $value;
149  }
150 
151  function createXMLExport(&$settings, &$data, $filename)
152  {
153  include_once './Services/User/classes/class.ilUserDefinedData.php';
154  include_once './Services/User/classes/class.ilObjUser.php';
155 
156  global $rbacreview;
157  global $ilDB;
158  global $log;
159 
160  $file = fopen($filename, "w");
161 
162  if (is_array($data))
163  {
164  include_once './Services/User/classes/class.ilUserXMLWriter.php';
165 
166  $xmlWriter = new ilUserXMLWriter();
167  $xmlWriter->setObjects($data);
168  $xmlWriter->setSettings($settings);
169  $xmlWriter->setAttachRoles (true);
170 
171  if($xmlWriter->start())
172  {
173  fwrite($file, $xmlWriter->getXML());
174  }
175  }
176 
177 /*
178  fwrite($file, "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");
179  fwrite($file, "<!DOCTYPE Users SYSTEM \"".ILIAS_HTTP_PATH."/xml/ilias_user_3_8.dtd\">\n");
180  fwrite($file, "<Users>");
181  foreach ($data as $row)
182  {
183  //$log->write(date("[y-m-d H:i:s] ")."User data export: processing user " . $row["login"]);
184  foreach ($row as $key => $value)
185  {
186  $row[$key] = $this->escapeXML($value);
187  }
188  $userline = "";
189  // TODO: Define combobox for "Action" ???
190  if (strlen($row["language"]) == 0) $row["language"] = "en";
191  $userline .= "<User Id=\"il_".IL_INST_ID."_usr_".$row["usr_id"]."\" Language=\"".$row["language"]."\" Action=\"Insert\">";
192  if (array_search("login", $settings) !== FALSE)
193  {
194  $userline .= "<Login>".$row["login"]."</Login>";
195  }
196  // Alternative way to get the roles of a user?
197  $query = sprintf("SELECT object_data.title, rbac_fa.* FROM object_data, rbac_ua, rbac_fa WHERE rbac_ua.usr_id = %s AND rbac_ua.rol_id = rbac_fa.rol_id AND object_data.obj_id = rbac_fa.rol_id",
198  $ilDB->quote($row["usr_id"])
199  );
200  $rbacresult = $ilDB->query($query);
201  while ($rbacrow = $rbacresult->fetchRow(DB_FETCHMODE_ASSOC))
202  {
203  $type = "";
204  if ($rbacrow["assign"] == "y")
205  {
206  if ($rbacrow["parent"] == ROLE_FOLDER_ID)
207  {
208  $type = "Global";
209  }
210  else
211  {
212  $type = "Local";
213  }
214  if (strlen($type))
215  {
216  $userline .= "<Role Id=\"il_".IL_INST_ID."_role_".$rbacrow["rol_id"]."\" Type=\"".$type."\">".$rbacrow["title"]."</Role>";
217  }
218  }
219  }
220  //$log->write(date("[y-m-d H:i:s] ")."User data export: get all roles");
221  /* the export of roles is to expensive. on a system with 6000 users the following
222  section needs 37 seconds
223 
224  $roles = $rbacreview->getRolesByFilter(1, $row["usr_id"]);
225  $ass_roles = $rbacreview->assignedRoles($row["usr_id"]);
226  foreach ($roles as $role)
227  {
228  if (array_search($role["obj_id"], $ass_roles) !== FALSE)
229  {
230  $type = "";
231  switch ($role["role_type"])
232  {
233  case "global":
234  $type = "Global";
235  break;
236  case "local":
237  $type = "Local";
238  break;
239  }
240  if (strlen($type))
241  {
242  $userline .= "<Role Id=\"".$role["obj_id"]."\" Type=\"".$type."\">".$role["title"]."</Role>";
243  }
244  }
245  }
246  */
247 /* //$log->write(date("[y-m-d H:i:s] ")."User data export: got all roles");
248  $i2passwd = FALSE;
249  if (array_search("i2passwd", $settings) !== FALSE)
250  {
251  if (strlen($row["i2passwd"])) $i2passwd = TRUE;
252  if ($i2passwd) $userline .= "<Password Type=\"ILIAS2\">".$row["i2passwd"]."</Password>";
253  }
254  if ((!$i2passwd) && (array_search("passwd", $settings) !== FALSE))
255  {
256  if (strlen($row["passwd"])) $userline .= "<Password Type=\"ILIAS3\">".$row["passwd"]."</Password>";
257  }
258  if (array_search("firstname", $settings) !== FALSE)
259  {
260  if (strlen($row["firstname"])) $userline .= "<Firstname>".$row["firstname"]."</Firstname>";
261  }
262  if (array_search("lastname", $settings) !== FALSE)
263  {
264  if (strlen($row["lastname"])) $userline .= "<Lastname>".$row["lastname"]."</Lastname>";
265  }
266  if (array_search("title", $settings) !== FALSE)
267  {
268  if (strlen($row["title"])) $userline .= "<Title>".$row["title"]."</Title>";
269  }
270  if (array_search("upload", $settings) !== FALSE)
271  {
272  // personal picture
273  $q = sprintf("SELECT value FROM usr_pref WHERE usr_id=%s AND keyword='profile_image'", $ilDB->quote($row["usr_id"] . ""));
274  $r = $ilDB->query($q);
275  if ($r->numRows() == 1)
276  {
277  $personal_picture_data = $r->fetchRow(DB_FETCHMODE_ASSOC);
278  $personal_picture = $personal_picture_data["value"];
279  $webspace_dir = ilUtil::getWebspaceDir();
280  $image_file = $webspace_dir."/usr_images/".$personal_picture;
281  if (@is_file($image_file))
282  {
283  $fh = fopen($image_file, "rb");
284  if ($fh)
285  {
286  $image_data = fread($fh, filesize($image_file));
287  fclose($fh);
288  $base64 = base64_encode($image_data);
289  $imagetype = "image/jpeg";
290  if (preg_match("/.*\.(png|gif)$/", $personal_picture, $matches))
291  {
292  $imagetype = "image/".$matches[1];
293  }
294  $userline .= "<PersonalPicture imagetype=\"$imagetype\" encoding=\"Base64\">$base64</PersonalPicture>";
295  }
296  }
297  }
298  }
299  if (array_search("gender", $settings) !== FALSE)
300  {
301  if (strlen($row["gender"])) $userline .= "<Gender>".$row["gender"]."</Gender>";
302  }
303  if (array_search("email", $settings) !== FALSE)
304  {
305  if (strlen($row["email"])) $userline .= "<Email>".$row["email"]."</Email>";
306  }
307  if (array_search("institution", $settings) !== FALSE)
308  {
309  if (strlen($row["institution"])) $userline .= "<Institution>".$row["institution"]."</Institution>";
310  }
311  if (array_search("street", $settings) !== FALSE)
312  {
313  if (strlen($row["street"])) $userline .= "<Street>".$row["street"]."</Street>";
314  }
315  if (array_search("city", $settings) !== FALSE)
316  {
317  if (strlen($row["city"])) $userline .= "<City>".$row["city"]."</City>";
318  }
319  if (array_search("zipcode", $settings) !== FALSE)
320  {
321  if (strlen($row["zipcode"])) $userline .= "<PostalCode>".$row["zipcode"]."</PostalCode>";
322  }
323  if (array_search("country", $settings) !== FALSE)
324  {
325  if (strlen($row["country"])) $userline .= "<Country>".$row["country"]."</Country>";
326  }
327  if (array_search("phone_office", $settings) !== FALSE)
328  {
329  if (strlen($row["phone_office"])) $userline .= "<PhoneOffice>".$row["phone_office"]."</PhoneOffice>";
330  }
331  if (array_search("phone_home", $settings) !== FALSE)
332  {
333  if (strlen($row["phone_home"])) $userline .= "<PhoneHome>".$row["phone_home"]."</PhoneHome>";
334  }
335  if (array_search("phone_mobile", $settings) !== FALSE)
336  {
337  if (strlen($row["phone_mobile"])) $userline .= "<PhoneMobile>".$row["phone_mobile"]."</PhoneMobile>";
338  }
339  if (array_search("fax", $settings) !== FALSE)
340  {
341  if (strlen($row["fax"])) $userline .= "<Fax>".$row["fax"]."</Fax>";
342  }
343  if (strlen($row["hobby"])) if (array_search("hobby", $settings) !== FALSE)
344  {
345  $userline .= "<Hobby>".$row["hobby"]."</Hobby>";
346  }
347  if (array_search("department", $settings) !== FALSE)
348  {
349  if (strlen($row["department"])) $userline .= "<Department>".$row["department"]."</Department>";
350  }
351  if (array_search("referral_comment", $settings) !== FALSE)
352  {
353  if (strlen($row["referral_comment"])) $userline .= "<Comment>".$row["referral_comment"]."</Comment>";
354  }
355  if (array_search("matriculation", $settings) !== FALSE)
356  {
357  if (strlen($row["matriculation"])) $userline .= "<Matriculation>".$row["matriculation"]."</Matriculation>";
358  }
359  if (array_search("active", $settings) !== FALSE)
360  {
361  if ($row["active"])
362  {
363  $userline .= "<Active>true</Active>";
364  }
365  else
366  {
367  $userline .= "<Active>false</Active>";
368  }
369  }
370  if (array_search("client_ip", $settings) !== FALSE)
371  {
372  if (strlen($row["client_ip"])) $userline .= "<ClientIP>".$row["client_ip"]."</ClientIP>";
373  }
374  if (array_search("time_limit_owner", $settings) !== FALSE)
375  {
376  if (strlen($row["time_limit_owner"])) $userline .= "<TimeLimitOwner>".$row["time_limit_owner"]."</TimeLimitOwner>";
377  }
378  if (array_search("time_limit_unlimited", $settings) !== FALSE)
379  {
380  if (strlen($row["time_limit_unlimited"])) $userline .= "<TimeLimitUnlimited>".$row["time_limit_unlimited"]."</TimeLimitUnlimited>";
381  }
382  if (array_search("time_limit_from", $settings) !== FALSE)
383  {
384  if (strlen($row["time_limit_from"])) $userline .= "<TimeLimitFrom>".$row["time_limit_from"]."</TimeLimitFrom>";
385  }
386  if (array_search("time_limit_until", $settings) !== FALSE)
387  {
388  if (strlen($row["time_limit_until"])) $userline .= "<TimeLimitUntil>".$row["time_limit_until"]."</TimeLimitUntil>";
389  }
390  if (array_search("time_limit_message", $settings) !== FALSE)
391  {
392  if (strlen($row["time_limit_message"])) $userline .= "<TimeLimitMessage>".$row["time_limit_message"]."</TimeLimitMessage>";
393  }
394  if (array_search("approve_date", $settings) !== FALSE)
395  {
396  if (strlen($row["approve_date"])) $userline .= "<ApproveDate>".$row["approve_date"]."</ApproveDate>";
397  }
398  if (array_search("agree_date", $settings) !== FALSE)
399  {
400  if (strlen($row["agree_date"])) $userline .= "<AgreeDate>".$row["agree_date"]."</AgreeDate>";
401  }
402  if ((int) $row["ilinc_id"] !=0) {
403  if (array_search("ilinc_id", $settings) !== FALSE)
404  {
405  if (strlen($row["ilinc_id"])) $userline .= "<iLincID>".$row["ilinc_id"]."</iLincID>";
406  }
407  if (array_search("ilinc_login", $settings) !== FALSE)
408  {
409  if (strlen($row["ilinc_login"])) $userline .= "<iLincLogin>".$row["ilinc_login"]."</iLincLogin>";
410  }
411  if (array_search("ilinc_passwd", $settings) !== FALSE)
412  {
413  if (strlen($row["ilinc_passwd"])) $userline .= "<iLincPasswd>".$row["ilinc_passwd"]."</iLincPasswd>";
414  }
415  }
416  if (array_search("auth_mode", $settings) !== FALSE)
417  {
418  if (strlen($row["auth_mode"])) $userline .= "<AuthMode type=\"".$row["auth_mode"]."\"></AuthMode>";
419  }
420  if (array_search("skin_style", $settings) !== FALSE)
421  {
422  $userline .=
423  "<Look Skin=\"" . ilObjUser::_lookupPref($row["usr_id"], "skin") . "\" " .
424  "Style=\"" . ilObjUser::_lookupPref($row["usr_id"], "style") . "\"></Look>";
425  }
426 
427  if (array_search("last_update", $settings) !== FALSE)
428  {
429  if (strlen($row["last_update"])) $userline .= "<LastUpdate>".$row["last_update"]."</LastUpdate>";
430  }
431 
432  if (array_search("last_login", $settings) !== FALSE)
433  {
434  if (strlen($row["last_login"])) $userline .= "<LastLogin>".$row["last_login"]."</LastLogin>";
435  }
436 
437  // Append User defined field data
438  $udf_data = new ilUserDefinedData($row['usr_id']);
439  $userline .= $udf_data->toXML();
440 
441  $userline .= "</User>";
442  fwrite($file, $userline);
443  }
444  fwrite($file, "</Users>");
445  fclose($file);*/
446  }
447 
448 
452  function getUserDefinedExportFields()
453  {
454  include_once './Services/User/classes/class.ilUserDefinedFields.php';
455  $udf_obj =& ilUserDefinedFields::_getInstance();
456 
457  $udf_ex_fields = array();
458  foreach($udf_obj->getDefinitions() as $definition)
459  {
460  if ($definition["export"] != FALSE)
461  {
462  $udf_ex_fields[] = array("name" => $definition["field_name"],
463  "id" => $definition["field_id"]);
464  }
465  }
466 
467  return $udf_ex_fields;
468  }
469 
470  function createCSVExport(&$settings, &$data, $filename)
471  {
472 
473  // header
474  $headerrow = array();
475  $udf_ex_fields = $this->getUserDefinedExportFields();
476  foreach ($settings as $value) // standard fields
477  {
478  array_push($headerrow, $this->lng->txt($value));
479  }
480  foreach ($udf_ex_fields as $f) // custom fields
481  {
482  array_push($headerrow, $f["name"]);
483  }
484 
485  $separator = ";";
486  $file = fopen($filename, "w");
487  $formattedrow =& ilUtil::processCSVRow($headerrow, TRUE, $separator);
488  fwrite($file, join ($separator, $formattedrow) ."\n");
489  foreach ($data as $row)
490  {
491  $csvrow = array();
492  foreach ($settings as $header) // standard fields
493  {
494  array_push($csvrow, $row[$header]);
495  }
496 
497  // custom fields
498  reset($udf_ex_fields);
499  if (count($udf_ex_fields) > 0)
500  {
501  include_once("./Services/User/classes/class.ilUserDefinedData.php");
502  $udf = new ilUserDefinedData($row["usr_id"]);
503  foreach ($udf_ex_fields as $f) // custom fields
504  {
505  array_push($csvrow, $udf->get("f_".$f["id"]));
506  }
507  }
508 
509  $formattedrow =& ilUtil::processCSVRow($csvrow, TRUE, $separator);
510  fwrite($file, join ($separator, $formattedrow) ."\n");
511  }
512  fclose($file);
513  }
514 
515  function createExcelExport(&$settings, &$data, $filename, $a_mode)
516  {
517  include_once "./Services/Excel/classes/class.ilExcelUtils.php";
518  include_once "./Services/Excel/classes/class.ilExcelWriterAdapter.php";
519  $adapter = new ilExcelWriterAdapter($filename, FALSE);
520  $workbook = $adapter->getWorkbook();
521  // Creating a worksheet
522  $format_bold =& $workbook->addFormat();
523  $format_bold->setBold();
524  $format_percent =& $workbook->addFormat();
525  $format_percent->setNumFormat("0.00%");
526  $format_datetime =& $workbook->addFormat();
527  $format_datetime->setNumFormat("DD/MM/YYYY hh:mm:ss");
528  $format_title =& $workbook->addFormat();
529  $format_title->setBold();
530  $format_title->setColor('black');
531  $format_title->setPattern(1);
532  $format_title->setFgColor('silver');
533  $worksheet =& $workbook->addWorksheet();
534  $row = 0;
535  $col = 0;
536 
537  $udf_ex_fields = $this->getUserDefinedExportFields();
538 
539  // title row
540  foreach ($settings as $value) // standard fields
541  {
542  $worksheet->write($row, $col, ilExcelUtils::_convert_text($this->lng->txt($value), $a_mode), $format_title);
543  $col++;
544  }
545  foreach ($udf_ex_fields as $f) // custom fields
546  {
547  $worksheet->write($row, $col, ilExcelUtils::_convert_text($f["name"], $a_mode), $format_title);
548  $col++;
549  }
550 
551  $this->lng->loadLanguageModule("meta");
552  foreach ($data as $index => $rowdata)
553  {
554  $row++;
555  $col = 0;
556 
557  // standard fields
558  foreach ($settings as $fieldname)
559  {
560  $value = $rowdata[$fieldname];
561  switch ($fieldname)
562  {
563  case "language":
564  $worksheet->write($row, $col, ilExcelUtils::_convert_text($this->lng->txt("meta_l_".$value), $a_mode));
565  break;
566  case "time_limit_from":
567  case "time_limit_until":
568  $date = strftime("%Y-%m-%d %H:%M:%S", $value);
569  if (preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $date, $matches))
570  {
571  $worksheet->write($row, $col, ilUtil::excelTime($matches[1],$matches[2],$matches[3],$matches[4],$matches[5],$matches[6]), $format_datetime);
572  }
573  break;
574  case "last_login":
575  case "last_update":
576  case "create_date":
577  case "approve_date":
578  case "agree_date":
579  if (preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $value, $matches))
580  {
581  $worksheet->write($row, $col, ilUtil::excelTime($matches[1],$matches[2],$matches[3],$matches[4],$matches[5],$matches[6]), $format_datetime);
582  }
583  break;
584  default:
585  $worksheet->write($row, $col, ilExcelUtils::_convert_text($value, $a_mode));
586  break;
587  }
588  $col++;
589  }
590 
591  // custom fields
592  reset($udf_ex_fields);
593  if (count($udf_ex_fields) > 0)
594  {
595  include_once("./Services/User/classes/class.ilUserDefinedData.php");
596  $udf = new ilUserDefinedData($rowdata["usr_id"]);
597  foreach ($udf_ex_fields as $f) // custom fields
598  {
599  $worksheet->write($row, $col, ilExcelUtils::_convert_text($udf->get("f_".$f["id"]), $a_mode));
600  $col++;
601  }
602  }
603  }
604  $workbook->close();
605  }
606 
612  static function getExportSettings()
613  {
614  global $ilDB;
615 
616  $db_settings = array();
617 
618  include_once("./Services/User/classes/class.ilUserProfile.php");
619  $up = new ilUserProfile();
620  $up->skipField("roles");
621  $profile_fields = $up->getStandardFields();
622 
623  /*$profile_fields =& ilObjUserFolder::getProfileFields();
624  $profile_fields[] = "preferences";*/
625 
626  $query = "SELECT * FROM settings WHERE ".
627  $ilDB->like("keyword", "text", '%usr_settings_export_%');
628  $result = $ilDB->query($query);
629  while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
630  {
631  if ($row["value"] == "1")
632  {
633  if (preg_match("/usr_settings_export_(.*)/", $row["keyword"], $setting))
634  {
635  array_push($db_settings, $setting[1]);
636  }
637  }
638  }
639  $export_settings = array();
640  foreach ($profile_fields as $key => $value)
641  {
642  if (in_array($key, $db_settings))
643  {
644  if (strcmp($key, "password") == 0)
645  {
646  array_push($export_settings, "passwd");
647  }
648  else
649  {
650  array_push($export_settings, $key);
651  }
652  }
653  }
654  array_push($export_settings, "login");
655  array_push($export_settings, "last_login");
656  array_push($export_settings, "last_update");
657  array_push($export_settings, "create_date");
658  array_push($export_settings, "i2passwd");
659  array_push($export_settings, "time_limit_owner");
660  array_push($export_settings, "time_limit_unlimited");
661  array_push($export_settings, "time_limit_from");
662  array_push($export_settings, "time_limit_until");
663  array_push($export_settings, "time_limit_message");
664  array_push($export_settings, "active");
665  array_push($export_settings, "approve_date");
666  array_push($export_settings, "agree_date");
667  array_push($export_settings, "ilinc_id");
668  array_push($export_settings, "ilinc_login");
669  array_push($export_settings, "ilinc_passwd");
670  array_push($export_settings, "client_ip");
671  array_push($export_settings, "auth_mode");
672  array_push($export_settings, "ext_account");
673  array_push($export_settings, "feedhash");
674 
675  return $export_settings;
676  }
677 
681  function buildExportFile($a_mode = "userfolder_export_excel_x86", $user_data_filter = FALSE)
682  {
683  global $ilBench;
684  global $log;
685  global $ilDB;
686  global $ilias;
687  global $lng;
688 
689  //get Log File
690  $expDir = $this->getExportDirectory();
691  //$expLog = &$log;
692  //$expLog->delete();
693  //$expLog->setLogFormat("");
694  //$expLog->write(date("[y-m-d H:i:s] ")."Start export of user data");
695 
696  // create export directory if needed
697  $this->createExportDirectory();
698 
699  //get data
700  //$expLog->write(date("[y-m-d H:i:s] ")."User data export: build an array of all user data entries");
701  $settings =& $this->getExportSettings();
702 
703  // user languages
704  $query = "SELECT * FROM usr_pref WHERE keyword = ".$ilDB->quote('language','text');
705  $res = $ilDB->query($query);
706  $languages = array();
707  while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
708  {
709  $languages[$row['usr_id']] = $row['value'];
710  }
711 
712 
713  $data = array();
714  $query = "SELECT usr_data.* FROM usr_data ".
715  " ORDER BY usr_data.lastname, usr_data.firstname";
716  $result = $ilDB->query($query);
717  while ($row = $ilDB->fetchAssoc($result))
718  {
719  if(isset($languages[$row['usr_id']]))
720  {
721  $row['language'] = $languages[$row['usr_id']];
722  }
723  else
724  {
725  $row['language'] = $lng->getDefaultLanguage();
726  }
727 
728  if (is_array($user_data_filter))
729  {
730  if (in_array($row["usr_id"], $user_data_filter)) array_push($data, $row);
731  }
732  else
733  {
734  array_push($data, $row);
735  }
736  }
737  //$expLog->write(date("[y-m-d H:i:s] ")."User data export: build an array of all user data entries");
738 
739  $fullname = $expDir."/".$this->getExportFilename($a_mode);
740  switch ($a_mode)
741  {
742  case "userfolder_export_excel_x86":
743  $this->createExcelExport($settings, $data, $fullname, "latin1");
744  break;
745  case "userfolder_export_csv":
746  $this->createCSVExport($settings, $data, $fullname);
747  break;
748  case "userfolder_export_xml":
749  $this->createXMLExport($settings, $data, $fullname);
750  break;
751  }
752  //$expLog->write(date("[y-m-d H:i:s] ")."Finished export of user data");
753 
754  return $fullname;
755  }
756 
757 
763  function createExportDirectory()
764  {
765  if (!@is_dir($this->getExportDirectory()))
766  {
767  $usrf_data_dir = ilUtil::getDataDir()."/usrf_data";
768  ilUtil::makeDir($usrf_data_dir);
769  if(!is_writable($usrf_data_dir))
770  {
771  $this->ilias->raiseError("Userfolder data directory (".$usrf_data_dir
772  .") not writeable.",$this->ilias->error_obj->MESSAGE);
773  }
774 
775  // create Export subdirectory (data_dir/lm_data/lm_<id>/Export)
776  $export_dir = $usrf_data_dir."/export";
777  ilUtil::makeDir($export_dir);
778  if(!@is_dir($export_dir))
779  {
780  $this->ilias->raiseError("Creation of Userfolder Export Directory failed.",$this->ilias->error_obj->MESSAGE);
781  }
782  }
783  }
784 
785 
791  static function &getProfileFields()
792  {
793  include_once("./Services/User/classes/class.ilUserProfile.php");
794  $up = new ilUserProfile();
795  $up->skipField("username");
796  $up->skipField("roles");
797  $up->skipGroup("preferences");
798  $fds = $up->getStandardFields();
799  foreach ($fds as $k => $f)
800  {
801  $profile_fields[] = $k;
802  }
803 
804  return $profile_fields;
805  }
806 
807  function _writeNewAccountMail($a_lang, $a_subject, $a_sal_g, $a_sal_f, $a_sal_m, $a_body)
808  {
809  global $ilDB;
810 
811  if(self::_lookupNewAccountMail($a_lang))
812  {
813  $values = array(
814  'subject' => array('text',$a_subject),
815  'body' => array('clob',$a_body),
816  'sal_g' => array('text',$a_sal_g),
817  'sal_f' => array('text',$a_sal_f),
818  'sal_m' => array('text',$a_sal_m)
819  );
820  $ilDB->update('mail_template',
821  $values,
822  array('lang' => array('text',$a_lang), 'type' => array('text','nacc'))
823  );
824  }
825  else
826  {
827  $values = array(
828  'subject' => array('text',$a_subject),
829  'body' => array('clob',$a_body),
830  'sal_g' => array('text',$a_sal_g),
831  'sal_f' => array('text',$a_sal_f),
832  'sal_m' => array('text',$a_sal_m),
833  'lang' => array('text',$a_lang),
834  'type' => array('text','nacc')
835  );
836  $ilDB->insert('mail_template',$values);
837  }
838  }
839 
840  function _updateAccountMailAttachment($a_lang, $a_tmp_name, $a_name)
841  {
842  global $ilDB;
843 
844  include_once "Services/User/classes/class.ilFSStorageUserFolder.php";
845  $fs = new ilFSStorageUserFolder($this->getId());
846  $fs->create();
847  $path = $fs->getAbsolutePath()."/";
848 
849  move_uploaded_file($a_tmp_name, $path.$a_lang);
850 
851  $ilDB->update('mail_template',
852  array('att_file' => array('text', $a_name)),
853  array('lang' => array('text',$a_lang), 'type' => array('text','nacc')));
854  }
855 
856  function _deleteAccountMailAttachment($a_lang)
857  {
858  global $ilDB;
859 
860  include_once "Services/User/classes/class.ilFSStorageUserFolder.php";
861  $fs = new ilFSStorageUserFolder($this->getId());
862  $path = $fs->getAbsolutePath()."/";
863 
864  @unlink($path.$a_lang);
865 
866  $ilDB->update('mail_template',
867  array('att_file' => array('text', '')),
868  array('lang' => array('text',$a_lang), 'type' => array('text','nacc')));
869  }
870 
871  function _lookupNewAccountMail($a_lang)
872  {
873  global $ilDB;
874 
875  $set = $ilDB->query("SELECT * FROM mail_template ".
876  " WHERE type='nacc' AND lang = ".$ilDB->quote($a_lang,'text'));
877 
878  if ($rec = $set->fetchRow(DB_FETCHMODE_ASSOC))
879  {
880  return $rec;
881  }
882  return array();
883  }
884 
896  public static function _updateUserFolderAssignment($a_old_id,$a_new_id)
897  {
898  global $ilDB;
899 
900  $query = "UPDATE usr_data SET time_limit_owner = ".$ilDB->quote($a_new_id, "integer")." ".
901  "WHERE time_limit_owner = ".$ilDB->quote($a_old_id, "integer")." ";
902  $ilDB->manipulate($query);
903 
904  return true;
905  }
906 
907 
908 } // END class.ilObjUserFolder
909 ?>