/**
* Load user by a particular field
* @param string $field The field to find by
* @param string $value The field value
* @return UserModel
*/
public static function loadBy($field, $value)
{
global $wpdb;
$UserModel = new UserModel();
switch ($field) {
case 'id':
$memberData = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}{$UserModel->_tableName} WHERE user_id = %d AND status != 'deleted'", $value), ARRAY_A);
break;
case 'verification_code':
$memberData = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}{$UserModel->_tableName} WHERE verification_code = %s AND status != 'deleted'", $value), ARRAY_A);
break;
case 'reset_password_code':
$memberData = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}{$UserModel->_tableName} WHERE reset_password_code = %s AND status != 'deleted'", $value), ARRAY_A);
break;
case 'email_address':
$memberData = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}{$UserModel->_tableName} WHERE email_address = %s AND status != 'deleted'", $value), ARRAY_A);
break;
}
if ($memberData) {
$UserModel->setId($memberData['user_id']);
$UserModel->populateFromArray($memberData);
if ($UserModel->getStatus() == 'deleted') {
return new UserModel();
}
}
return $UserModel;
}
public function findById($id)
{
$data = $this->storage->findById($id);
$user = new UserModel();
$user->setId($data['id']);
$user->setName($data['name']);
$user->setEmail($data['email']);
$user->setActive($data['active']);
return $user;
}
public static function fromObject($o)
{
$user = new UserModel();
$user->setId($o->id);
$user->setEmail($o->email);
$user->setPassword($o->password);
$user->setName($o->name);
$user->setSurname($o->surname);
$user->setOrganisation($o->organisation);
return $user;
}
/**
* @param string $whereClause
* @see ControllerBase::getSome()
*/
public function getSome($whereClause = '1 = 1')
{
$sql = <<<SQL
SELECT id
, username
, password
, psalt
, created
, updated
FROM user
WHERE {$whereClause}
ORDER
BY updated
SQL;
$stmt = $this->_dbh->prepare($sql);
if (!$stmt) {
throw new ControllerException('Failed to prepare SELECT statement. (' . $this->_dbh->error . ') from this SQL: ' . $sql);
}
if (!$stmt->execute()) {
throw new ControllerException('Failed to execute SELECT statement. (' . $this->_dbh->error . ')');
}
$id = $userName = $password = $psalt = $created = $updated = null;
$stmt->bind_result($id, $userName, $password, $psalt, $created, $updated);
$models = array();
while ($stmt->fetch()) {
$model = new UserModel();
$model->setId($id);
$model->setUserName($userName);
$model->setPassword($password);
$model->setPSalt($psalt);
$model->setCreated($created);
$model->setUpdated($updated);
$models[] = $model;
}
return $models;
}
$app->get('/general/statistics', function () {
$cra = new CesRestAPI();
print $cra->getStatistics();
})->setName('general statistics');
// logout
$app->get('/general/backup', function () {
$cra = new CesRestAPI();
print $cra->saveBackup();
})->setName('general backup');
//user post (update)
$app->post('/user/:id', function ($id) use($app) {
$body = $app->request()->getBody();
parse_str($body, $data);
//die(var_dump($data));
$user = new UserModel();
$user->setId($id);
$user->setCesUid($data['ces_uid']);
$user->setPassword($data['password']);
$user->setFirstname($data['firstname']);
$user->setSurname($data['surname']);
$user->setOrgname($data['orgname']);
$user->setAddress1($data['address1']);
$user->setAddress2($data['address2']);
$user->setAddress3($data['address3']);
$user->setPostcode($data['postcode']);
$user->setSubareaId($data['subareaId']);
$user->setSubarea($data['subarea']);
$user->setPhoneh($data['phoneh']);
$user->setPhonew($data['phonew']);
$user->setPhonef($data['phonef']);
$user->setPhonem($data['phonem']);
