public function render()
{
// execute beforeRender
$this->onBeforeRender();
// call page renderer
return render('page-layout.php', array('title' => $this->title, 'content' => implode('', $this->objects), 'user' => User::logged()));
}
public function onBeforeRender()
{
$user = \User\User::logged();
$queryItems = new \Meta\Query(array('from' => 'items'));
$queryReserves = new \Meta\Query(array('from' => 'reserves'));
$queryUsers = new \Meta\Query(array('from' => 'users'));
$query = new \Meta\Query(array('select' => 'r.id, r.dt_request, r.dt_begin, r.dt_end, r.status, i.name AS item', 'from' => 'reserves r INNER JOIN items i ON i.id = r.item_id', 'order' => 'dt_request DESC', 'limit' => 5));
$myReservesQuery = clone $query;
$myReservesQuery->whereAnd('r.requester_id = ' . \User\User::logged()->id);
$pendingQuery = clone $query;
$pendingQuery->whereAnd("r.status = 'W'");
$this->add(render('dashboard.php', array('myReserves' => $myReservesQuery->executeQuery()->fetchAll(\PDO::FETCH_ASSOC), 'isReservesManager' => $user->allowedToPage('res-reserves') || $user->isAdmin, 'pendingReserves' => $pendingQuery->executeQuery()->fetchAll(\PDO::FETCH_ASSOC), 'countItems' => $queryItems->countRows(), 'countReserves' => $queryReserves->countRows(), 'countUsers' => $queryUsers->countRows())));
}
public function onValidated()
{
$uid = \User\User::logged()->id;
$data = $this->getData();
Db::saveSafe('users', $data);
Flash::success(t('Profile saved'));
// change password
$pass = $data['password_new'];
if (strlen($pass) > 0) {
Db::update('users', array('password' => md5($pass)), array('id' => $uid));
Flash::success(t('Password changed'));
}
redirect(url(current_path()));
}
