public function create($email, $name, $surname, $password, $password2)
{
$user = new User($this->db);
try {
$user->setEmail($email);
$user->setName($name);
$user->setSurname($surname);
$user->setHash($password, $password2);
} catch (Exception $e) {
$err = $e->getmessage();
}
if (!isset($err)) {
$email = $this->db->quote($user->getEmail());
$name = $this->db->quote($user->getName());
$surname = $this->db->quote($user->getSurname());
$hash = $user->getHash();
$query = ' INSERT INTO user (email, name, surname, hash)
VALUES (' . $email . ',' . $name . ',' . $surname . ',"' . $hash . '")';
$res = $this->db->exec($query);
if ($res) {
$id = $this->db->lastInsertId();
if ($id) {
return $this->readById($id);
} else {
throw new Exception('Database error');
}
} else {
throw new Exception('User already exist');
}
} else {
throw new Exception($err);
}
}
public static function createSampleUser($forename, $surname, $dn)
{
$u = new User();
$u->setForename($forename);
$u->setSurname($surname);
$u->setCertificateDn($dn);
$u->setAdmin(FALSE);
return $u;
}
public function create($login, $password1, $password2, $email, $name, $surname, $date_birth)
{
$errors = array();
$user = new User($this->db);
try {
$user->setLogin($login);
$user->setPassword($password1, $password2);
$user->setEmail($email);
$user->setName($name);
$user->setSurname($surname);
$user->setDateBirth($date_birth);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
// $user = new User();
// $errors[] = $user->setLogin($login);
// $errors[] = $user->setPassword($password1, $password2);
// $errors[] = $user->setEmail($email);
// $errors[] = $user->setAvatar($avatar);
$errors = array_filter($errors, function ($val) {
return $val !== true;
});
if (count($errors) == 0) {
// $login = mysqli_real_escape_string($this->db, $user->getLogin());
$login = $this->db->quote($user->getLogin());
// $email = mysqli_real_escape_string($this->db, $user->getEmail());
$email = $this->db->quote($user->getEmail());
// $password = $user->getHash();
$password = $user->getHash();
// $name = mysqli_real_escape_string($this->db, $user->getName());
$name = $this->db->quote($user->getName());
$surname = $this->db->quote($user->getSurname());
$date_birth = $this->db->quote($user->getDateBirth());
$query = "INSERT INTO user (login, password, email, name, surname, date_birth) VALUES(" . $login . ", '" . $password . "', " . $email . ", " . $name . ", " . $surname . ", " . $date_birth . ")";
// $res = mysqli_query($this->db, $query);
$res = $this->db->exec($query);
if ($res) {
$id = $this->db->lastInsertId();
if ($id) {
return $this->findById($id);
} else {
return "Internal server error";
}
}
} else {
return $errors;
}
}
public function import($adminUserId)
{
$count = 0;
$add_method = $this->getValue('add_method');
$file = $this->getValue('file');
$delimiter = $this->getValue('delimiter');
$skipHeader = $this->getValue('skipHeader');
$fp = fopen($file->getTempName(), 'r');
if ($fp) {
if ($add_method == self::REPLACE) {
$c = new Criteria();
$c->add(UserPeer::ID, $adminUserId, Criteria::NOT_EQUAL);
UserPeer::doDelete($c);
}
while ($data = fgetcsv($fp, 0, $delimiter)) {
if (empty($data[0]) || count($data) < 7) {
continue;
}
if ($skipHeader) {
$skipHeader = false;
continue;
}
try {
$user = new User();
$user->setFamilyName($data[0]);
$user->setSurname($data[1]);
$user->setBirthdate($data[2]);
$user->setCardNumber($data[3]);
$user->setEmailAddress($data[4]);
$user->setAddress($data[5]);
$user->setPhoneNumber($data[6]);
$user->autoCorrectNames();
$user->autoSetLogin();
$user->save();
++$count;
} catch (Exception $ex) {
}
}
fclose($fp);
return $count;
}
return false;
}
continue;
}
$userDNs[$dn] = true;
/* Record the number of DNs
* that are identical apart from
* right hand whitespace
*/
// if(isset($rightWhiteDNs[rtrim($dn)])) {
// echo "Identical DN inserted apart from right hand whitespace: "
// . $dn . "-----------\r\n";
// continue;
// }
// $rightWhiteDNs[rtrim($dn)] = true;
$doctrineUser = new User();
$doctrineUser->setForename((string) $user->FORENAME);
$doctrineUser->setSurname((string) $user->SURNAME);
$doctrineUser->setTitle((string) $user->TITLE);
$doctrineUser->setEmail((string) $user->EMAIL);
$doctrineUser->setTelephone((string) $user->TEL);
$doctrineUser->setWorkingHoursStart((string) $user->WORKING_HOURS_START);
$doctrineUser->setWorkingHoursEnd((string) $user->WORKING_HOURS_END);
//$doctrineUser->setCertificateDn((string) $user->CERTDN);
$doctrineUser->setCertificateDn($dn);
$doctrineUser->setAdmin(false);
// echo "DN is " . (string) $doctrineUser->getCertificateDn() . ".\r\n";
// Roughly half of users don't have a home site set
if ($user->HOMESITE != "" && !isBad($user->HOMESITE)) {
// get the home site entity
$dql = "SELECT s from Site s WHERE s.shortName = ?1";
$homeSites = $entityManager->createQuery($dql)->setParameter(1, (string) $user->HOMESITE)->getResult();
/* Error checking: ensure each "home site" refers to exactly
/**
* Array
* (
* [TITLE] => Mr
* [FORENAME] => Testing
* [SURNAME] => TestFace
* [EMAIL] => JCasson@gmail.com
* [TELEPHONE] => 01235 44 5010
* [CERTIFICATE_DN] => /C=UK/O=eScience/OU=CLRC/L=RAL/CN=claire devereuxxxx
* )
* @param array $values User details, defined above
*/
public function register($values)
{
// validate the input fields for the user
$this->validateUser($values);
// Check the DN isn't already registered
$user = $this->getUserByPrinciple($values['CERTIFICATE_DN']);
if (!is_null($user)) {
throw new \Exception("DN is already registered in GOCDB");
}
//Explicity demarcate our tx boundary
$this->em->getConnection()->beginTransaction();
$user = new \User();
try {
$user->setTitle($values['TITLE']);
$user->setForename($values['FORENAME']);
$user->setSurname($values['SURNAME']);
$user->setEmail($values['EMAIL']);
$user->setTelephone($values['TELEPHONE']);
$user->setCertificateDn($values['CERTIFICATE_DN']);
$user->setAdmin(false);
$this->em->persist($user);
$this->em->flush();
$this->em->getConnection()->commit();
} catch (\Exception $ex) {
$this->em->getConnection()->rollback();
$this->em->close();
throw $ex;
}
return $user;
}
<?php
session_start();
require 'config.php';
if (Authentication::get_user() != -1) {
// send user to the dashboard
header("Location: //" . APP_ROOT_URL);
die;
} else {
if (isset($_POST['username'])) {
try {
$user = new User();
$user->setUsername($_POST['username']);
$user->setForename($_POST['firstname']);
$user->setSurname($_POST['surname']);
$user->setEmail($_POST['email']);
$user->setPassword($_POST['password']);
$user->setGroupId(1);
$user->save();
} catch (Exception $e) {
die($e->getMessage());
}
header("Location: //" . APP_ROOT_URL);
die;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php require_once "bootstrap.php"; require_once "src/User.php"; $login = $argv[1]; $name = $argv[2]; $surname = $argv[3]; $team = $argv[4]; $company = $argv[5]; echo "Created User with login " . $login . "\n"; echo "Created User with name " . $name . "\n"; echo "Created User with surname " . $surname . "\n"; echo "Created User with team " . $team . "\n"; echo "Created User with company " . $company . "\n"; $user = new User($login); $user->setName($name); $user->setSurname($surname); $user->setTeam($team); $user->setCompany($company); $entityManager->persist($user); $entityManager->flush(); echo "Created User with ID " . $user->getId() . "\n";
