public function findBySponsorId($sponsorId)
{
$sql = 'select u.* from users u, sponsor_user su' . ' where su.sponsor_id = :sponsorId and u.id = su.user_id';
$results = $this->fetch($sql, ['sponsorId' => $sponsorId]);
foreach ($results as $result) {
$user = new \Conftrack\Model\User($this->getDb());
$user->load($result, false);
$this->add($user);
}
}
$app->get('/logout', function ($request, $response, $args) {
// Clear out the session
$this->getContainer()->get('session')->clear();
// Redirect to the main page
return $response->withRedirect('/');
});
$app->get('/register', function ($request, $response, $args) {
$data = [];
$this->view->render($response, 'user/register.twig', $data);
});
$app->post('/register', function ($request, $response, $args) {
$data = [];
$body = $request->getParsedBody();
$user = new \Conftrack\Model\User($this->getContainer()->get('db'));
$data = ['success' => false];
$user->load(['password' => $body['password'], 'username' => $body['username'], 'name' => $body['full_name'], 'email' => $body['email'], 'status' => 'active']);
try {
$user->verify();
$user->save();
// $this->flash->addMessage('success', 'User created successfully!');
$message = 'User created successfully!';
$data['success'] = true;
} catch (\Exception $e) {
$message = "Error: " . implode("\n", $user->getMessages());
}
$type = $data['success'] == false ? 'danger' : 'success';
$this->flash->addMessage($type, $message);
$this->view->render($response, 'user/register.twig', $data);
});
$app->get('/dashboard', function ($request, $response, $args) {
$data = [];
