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; }
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; }