Example #1
0
 public function startEdit()
 {
     if ($this->getRole() != "view") {
         throw new Exception("only worksheets with role 'view' can be edited!");
     }
     $currentUser = $GLOBALS["STEAM"]->get_current_steam_user();
     $userWorkroom = $currentUser->get_workroom();
     $newObj = \steam_factory::create_copy($GLOBALS["STEAM"]->get_id(), $this->steamObj);
     $newObj->move($userWorkroom);
     $newWorksheet = new self($newObj->get_id());
     $newWorksheet->setRole("edit");
     $name = $newWorksheet->getName();
     $name = preg_replace('!(\\ )*\\(Vorlage\\)!isU', '', $name);
     $name = preg_replace('!(\\ )*\\(Verteilkopie\\)!isU', '', $name);
     $name = $name . " (Arbeitskopie)";
     $newWorksheet->setName($name);
     $this->addEditCopy($currentUser->get_id(), $newWorksheet->getId());
     return $newWorksheet;
 }
Example #2
0
 public static function createStudentFromId($id)
 {
     $student = new self();
     $query = "SELECT * FROM TUSERS U JOIN TSTUDENTS S ON U.`User ID` = S.`User ID` WHERE U.`User ID` = {$id}";
     $user = db_select($query);
     $student->setUserId($id);
     $student->setFirstName($user[0]['First Name']);
     $student->setSurname($user[0]['Surname']);
     $student->setPrefferedName($user[0]['Preferred Name']);
     $student->setStudentId($user[0]['Student ID']);
     $student->setEmail($user[0]['Email']);
     $student->setRole($user[0]['Role']);
     $student->setGender($user[0]['Gender']);
     $student->setDateOfBirth($user[0]['DOB']);
     $student->setValidation($user[0]['Validation']);
     return $student;
 }