public function testGenerate()
{
$data = array(array('id' => 1, 'name' => 'jonathan', 'onclick' => '/'));
$options = array('column_names' => array('id', 'name'), 'id' => 'mytable');
$html = Table::generate($data, $options);
$this->assertEquals('<table id="mytable"><thead><tr><th>id</th><th>name</th></tr></thead><tfoot></tfoot><tbody><tr onclick="document.location=\'/\'"><td>1</td><td>jonathan</td></tr></tbody></table>', $html);
}
protected function table_generator ($tcode) {
$table = Table::generate($tcode);
return $table->html();
}
function page()
{
global $db, $session;
//lets get a user
$db->select('users.id,firstname,lastname,email,department_name');
$db->from('users');
$db->join('user_departments', 'users.department_id=user_departments.id');
$db->order_by('lastname');
$users = $db->fetch();
$searchFields[] = array('type' => 'text', 'label' => 'Last Name', 'value' => '', 'field' => 'lastname');
$db->select('id,department_name');
$db->from('user_departments');
$db->order_by('department_name');
$departments = $db->fetch();
$searchFields[] = array('type' => 'select', 'value' => 0, 'label' => 'Department', 'field' => 'department_id', 'options' => $departments, 'option_field' => 'department_name');
// this is the bare minimum implementation;
$table = new Table();
$table->setRecordActionBase('/pages/user/user.php');
$table->setData($users);
$table->setSearch($searchFields);
$table->setNewButton('New User', '/pages/user/user.php');
$actions[] = array('action' => 'list', 'label' => "Permissions", 'url' => '/pages/user/permissions.php');
$actions[] = array('action' => 'list', 'label' => "Groups", 'url' => '/pages/user/groups.php');
$table->setFormActions($actions);
$table->generate();
$GLOBALS['scripts'] = array_merge($GLOBALS['scripts'], $table->tableScripts);
}
function page()
{
global $db, $session;
//lets get a user
$db->select('id,displayname');
$db->from('core_permission_list');
$db->order_by('displayname');
$permissions = $db->fetch();
$searchFields[] = array('type' => 'text', 'label' => 'Display Name', 'value' => '', 'field' => 'displayname');
// this is the bare minimum implementation;
$table = new Table();
$table->setRecordActionBase('/pages/permissions/permissionEdit.php');
$table->setData($permissions);
$table->setSearch($searchFields);
$table->setNewButton('New Permission', '/pages/permissions/permissionEdit.php');
$table->generate();
$GLOBALS['scripts'] = array_merge($GLOBALS['scripts'], $table->tableScripts);
}
function page()
{
global $db, $session;
//lets get a user
$db->select('id,group_name');
$db->from('core_permission_groups');
$db->order_by('group_name');
$groups = $db->fetch();
$searchFields[] = array('type' => 'text', 'label' => 'Group Name', 'value' => '', 'field' => 'group_name');
// this is the bare minimum implementation;
$table = new Table();
$table->setRecordActionBase('permissions/groupEdit.php');
$actions[] = array('action' => 'selectpermissions', 'label' => "Permissions", 'url' => 'permissions/groupPermissions.php');
$table->setRecordActions($actions);
$table->setData($groups);
$table->setSearch($searchFields);
$table->setNewButton('New Group', 'permissions/groupEdit.php');
$table->generate();
$GLOBALS['scripts'] = array_merge($GLOBALS['scripts'], $table->tableScripts);
}
function page()
{
global $db, $session;
//lets get a user
$db->select('users.id,firstname,lastname,email,department_name');
$db->from('users');
$db->join('user_departments', 'users.department_id=user_departments.id');
$db->order_by('lastname');
$users = $db->fetch();
$searchFields[] = array('type' => 'text', 'label' => 'Last Name', 'value' => '', 'field' => 'lastname');
$searchFields[] = array('type' => 'date', 'label' => 'Start Date', 'value' => '', 'field' => 'last_login');
$db->select('id,department_name');
$db->from('user_departments');
$db->order_by('department_name');
$departments = $db->fetch();
$searchFields[] = array('type' => 'select', 'value' => 0, 'label' => 'Department', 'field' => 'department_id', 'options' => $departments, 'option_field' => 'department_name');
// this is the bare minimum implementation;
$table = new Table();
$table->setData($users);
$table->setSearch($searchFields);
$table->generate();
$GLOBALS['scripts'] = array_merge($GLOBALS['scripts'], $table->tableScripts);
}
<?php
// This is a dynamic version of index.html that generates a randomized
// table every time the page is loaded. index.html was
// created using this file.
function __autoload($class)
{
$parts = explode('\\', $class);
require end($parts) . '.php';
}
$t = new Table();
$table = $t->generate();
?>
<!doctype html>
<html class="" lang="en">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Super Table Demo</title>
<link rel="stylesheet" href="foundation.min.css" />
<link rel="stylesheet" href="all.css">
</head>
<body>
<div class="row">
<div class="column medium-12">
<h1>Super Table Demo</h1>
</div>
</div>
<div class="row">
<div class="column medium-12">
