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 = [];