public function getTable($res, $rows)
{
// Get parameters
$hits = isset($_GET['hits']) ? $_GET['hits'] : 8;
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$id = isset($_GET['id']) ? $_GET['id'] : null;
// Check that incoming parameters are valid
is_numeric($hits) or die('Check: Hits must be numeric.');
is_numeric($page) or die('Check: Page must be numeric.');
if ($id !== null) {
return $this->getDetails($res[0]);
exit;
}
// Prepare the table, firt the header row
$admin = CUser::isUser() ? '<th>Admin</th>' : NULL;
$tr = "<tr>\n <th>Id</th>\n <th>Akronym " . CFunc::orderby('acronym') . "</th>\n <th>Namn " . CFunc::orderby('name') . "</th>\n <th>Roll</th>\n {$admin}\n </tr>";
// Prepare the data rows
foreach ($res as $key => $val) {
$admin = CUser::isCurrentUser($val->id) ? "<a href='user_regedit.php?id={$val->id}'>Edit</a> <a href='user_delete.php?id={$val->id}'>Delete</a>" : NULL;
$admin = CUser::isUser($val->id) ? "<td>{$admin}</td>" : NULL;
$admin = CUser::isAuthenticated() ? "<td><a href='user_edit.php?id={$val->id}'>Edit</a> <a href='user_delete.php?id={$val->id}'>Delete</a></td>" : $admin;
// $synopsys = CTextFilter::nl2br($val->synopsys);
$href = CFunc::getQueryString(array('id' => $val->id));
$tr .= "<tr>\n </a></td>\n <td>{$val->id}</td>\n <td><a href='{$href}'>{$val->acronym}</a></td>\n <td>{$val->name}</td>\n <td>{$val->role}</td>\n {$admin}\n </tr>";
}
// Prepare navigation bars and admin information
$max = ceil($rows / $hits);
$hitsPerPage = CFunc::getHitsPerPage(array(4, 8, 16), $hits);
$navigatePage = CFunc::getPageNavigation($hits, $page, $max);
$adminAnchors = CUser::isAuthenticated() ? "<p><a href='user_create.php'>Skapa ny användare</a> <a href='user_reset.php'>Återställ användardatabasen</a></p>" : null;
// Put rows in HTML-table with navigation bars
$htmlTable = <<<EOD
<div class='dbtable'>
<div class='rows'>{$rows} träffar. {$hitsPerPage}</div>
<table>
{$tr}
</table>
<div class='pages'>{$navigatePage}</div>
{$adminAnchors}
</div>
EOD;
return $htmlTable;
}
<?php
/**
* This is a Branax pagecontroller.
*
*/
// Include the essential config-file which also creates the $branax variable with its defaults.
include __DIR__ . '/config.php';
// Create the user object
$user = new CUser($branax['database']);
// Check if logged in user
$admin = $user->isAdmin() ? 'med administratörsrättigheter' : null;
$output = $user->isUser() ? "Du är inloggad som {$user->getAcronym()} ({$user->getName()}) {$admin}" : "Du är INTE inloggad.";
// Do it and store it all in variables in the Anax container.
$branax['title'] = "User status";
$branax['main'] = <<<EOD
<h1>{$branax['title']}</h1>
<form method=post>
<fieldset>
<legend>Login status</legend>
<output><b>{$output}</b></output>
<p><a href='user_login.php'>Login</a></p>
<p><a href='user_logout.php'>Logout</a></p>
</fieldset>
</form>
EOD;
// Finally, leave it all to the rendering phase of Branax.
include BRANAX_THEME_PATH;
$branax['database']['cmd'] = "/usr/bin/mysql -hblu-ray.student.bth.se -u{$branax['database']['username']} -p'{$branax['database']['password']}'";
}
$branax['database']['driver_options'] = array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'");
/**
* The navbar
*
*/
//$anax['navbar'] = null; // To skip the navbar
// $content = new CContent($branax['database']);
// $blogItems = $content->getBlogItems();
// $pageItems = $content->getPageItems();
// $content = null;
$userId = CUser::isUser() ? '?id=' . CUser::isUser() : null;
$blogSubMenuItems = CUser::isAuthenticated() ? array('items' => array('view' => array('text' => 'Ändra', 'url' => 'content_view.php', 'title' => 'Ändra innehåll'), 'create' => array('text' => 'Lägg till', 'url' => 'content_create.php', 'title' => 'Nytt innehåll'), 'reset' => array('text' => 'Återställ', 'url' => 'content_reset.php', 'title' => 'Återställ innehåll'))) : null;
$movieSubMenuItems = CUser::isAuthenticated() ? array('items' => array('create' => array('text' => 'Lägg till', 'url' => 'movie_create.php', 'title' => 'Nytt innehåll'), 'reset' => array('text' => 'Återställ', 'url' => 'movie_reset.php', 'title' => 'Återställ innehåll'))) : null;
$userSubMenuItems = CUser::isUser() ? array('logout' => array('text' => 'Logout', 'url' => 'user_logout.php', 'title' => 'Utloggning')) : array();
$userSubMenuItems += array('login' => array('text' => 'Login', 'url' => 'user_login.php', 'title' => 'Inloggning'), 'status' => array('text' => 'Status', 'url' => 'user_status.php', 'title' => 'Inloggningsstatus'));
$userSubMenuItems += CUser::isAuthenticated() ? array('create' => array('text' => 'Lägg till', 'url' => 'user_create.php', 'title' => 'Nytt innehåll'), 'reset' => array('text' => 'Återställ', 'url' => 'user_reset.php', 'title' => 'Återställ')) : array();
$searchForm = CMovieSearch::getTitleForm('movies.php');
$branax['navbar'] = array('class' => 'navbar', 'items' => array('hem' => array('text' => 'Hem', 'url' => 'home.php', 'title' => 'RM Rental Movies'), 'filmer' => array('text' => 'Filmer', 'url' => 'movies.php', 'title' => 'Våra filmer', 'submenu' => $movieSubMenuItems), 'nyheter' => array('text' => 'Nyheter', 'url' => 'content_blog.php', 'title' => 'Blogg', 'submenu' => $blogSubMenuItems), 'dice' => array('text' => 'Tävling', 'url' => 'dice100.php', 'title' => 'Spela och vinn en film'), 'user' => array('text' => 'Användare', 'url' => "user_view.php{$userId}", 'title' => 'Användarprofiler', 'submenu' => array('items' => $userSubMenuItems)), 'about' => array('text' => 'Om RM', 'url' => 'about.php', 'title' => 'Om företaget')), 'callback' => function ($url) {
if (basename($_SERVER['SCRIPT_NAME']) == $url) {
return true;
}
if (in_array(basename($_SERVER['SCRIPT_NAME']), ['content_edit.php', 'content_delete.php', 'content_view.php']) && in_array($url, ['content_edit.php', 'content_delete.php', 'content_view.php'])) {
return true;
}
if (in_array(basename($_SERVER['SCRIPT_NAME']), ['movie_view.php', 'movie_edit.php', 'movie_delete.php']) && in_array($url, ['movies.php'])) {
return true;
}
if (in_array(basename($_SERVER['SCRIPT_NAME']), ['user_view.php', 'user_register.php', 'user_regedit.php', 'user_edit.php', 'user_delete.php']) && in_array(parse_url($url, PHP_URL_PATH), ['user_view.php'])) {
return true;
