/**
* Registers a user.
*
* @param RegisterUserBinding $user The RegisterUserBinding, containing all the register information.
*/
public function save(RegisterUserBinding $user)
{
if (!Validator::validateRegistrationInformation($user)) {
return;
}
$query = "INSERT INTO users(username, password, email, role_id) VALUES(:username, :password, :email, :role_id)";
$stmt = $this->db()->prepare($query);
$stmt->execute([':username' => $user->username, ':password' => Hash::password($user->password), ':email' => $user->email, ':role_id' => UserFactory::DEFAULT_USER_ROLE]);
$id = $this->db()->lastInsertId();
$persistedUser = $this->find(['id' => $id]);
return $persistedUser;
}
public static function validateRegistrationInformation(RegisterUserBinding $user)
{
$valid = true;
if (!Validator::stringLength($user->username, 3, 60)) {
Session::flash('flash_messages', Communicator::INVALID_USERNAME);
$valid = false;
}
if (!Validator::password($user->password)) {
Session::flash('flash_messages', Communicator::INVALID_PASSWORD);
$valid = false;
}
if (!Validator::stringLength($user->email, 5, 255)) {
Session::flash('flash_messages', Communicator::INVALID_EMAIL);
$valid = false;
}
return $valid;
}
public function update($info)
{
if (!Validator::validateSettingsUpdateInformation($info)) {
return false;
}
$_info = (array) $info;
// ddd($info, $_info);
foreach ($_info as $title => $value) {
$query = 'UPDATE options ';
$query .= 'SET value = :value';
$query .= " WHERE name = '" . $title . "'";
// ddd($query);
$stmt = $this->db()->prepare($query);
$stmt->execute([':value' => $value]);
}
Session::flash('flash_messages', Communicator::SETTINGS_SUCCESSFULLY_EDITED);
return true;
}
public function update($id, $block)
{
if (!Validator::validateBlockCreationInformation($block)) {
return;
}
$query = "UPDATE blocks" . " SET title = :title, description = :description, content = :content, page_id = :page_id, region = :region, active = :active" . " WHERE id = :id";
$stmt = $this->db()->prepare($query);
$result = $stmt->execute([':title' => $block->title, ':description' => $block->description, ':content' => $block->content, ':page_id' => $block->pageId, ':region' => $block->region, ':active' => $block->active, ':id' => $id]);
if ($result) {
Session::flash('flash_messages', Communicator::BLOCK_SUCCESSFULLY_EDITED);
return true;
}
Session::flash('flash_messages', Communicator::BLOCK_EDITIN_FAIL);
return false;
}
public function update($id, PageBinding $page)
{
if (!Validator::validatePageCreationInformation($page)) {
return;
}
// TODO: validatePageUpdateInformation().
$query = "UPDATE pages" . " SET title = :title, content = :content, active = :active" . " WHERE id = :id";
$stmt = $this->db()->prepare($query);
$result = $stmt->execute([':title' => $page->title, ':content' => $page->content, ':active' => $page->active, ':id' => $id]);
if ($result) {
Session::flash('flash_messages', Communicator::PAGE_SUCCESSFULLY_EDITED);
return true;
}
Session::flash('flash_messages', Communicator::PAGE_EDITING_FAIL);
return false;
}
