public function index($tName = '')
{
if (($tableName = Request::get('tblName', $tName)) == '') {
return '';
}
$crud = CRUD::factory($tableName, ['topPager' => false])->copyVarsFromRequest('tblName');
if (preg_match('/^tblMod([A-Z]+[a-z]+)/', $tableName, $matches)) {
foreach (Cfg::get('modules', []) as $moduleClass) {
eval($moduleClass . '::' . Module::CRUD_MOD . '($crud);');
}
} else {
switch ($tableName) {
case 'tblNextNumber':
$crud->setColDisplay('fldTable', [CRUD::SELECT, DBMaintenance::getTableList(), true]);
break;
case 'tblSecPrivUserMap':
$userSql = DB::driver() == DB::MYSQL ? Admin::USER_SQL_MYSQL : Admin::USER_SQL_MYSQL;
$crud->setColDisplay('fldUserID', [CRUD::SELECT, $userSql, true]);
$crud->setColDisplay('fldGroupID', [CRUD::SELECT, Admin::GROUP_SQL, true]);
$crud->setColDisplay('fldPrivilegeID', [CRUD::SELECT, Admin::PRIV_SQL, true]);
$crud->setColDisplay('fldLevelID', [CRUD::SELECT, Admin::LEVEL_SQL]);
break;
case 'tblUserGroupMap':
$userSql = DB::driver() == DB::MYSQL ? Admin::USER_SQL_MYSQL : Admin::USER_SQL_SQLITE;
$crud->setColDisplay('fldUserID', [CRUD::SELECT, $userSql, true]);
$crud->setColDisplay('fldGroupID', [CRUD::SELECT, Admin::GROUP_SQL, true]);
break;
case 'tblUser':
$crud->setColDisplay('fldLevel', [CRUD::SELECT, Admin::LEVEL_SQL]);
$crud->setColDisplay('fldTimeZone', [CRUD::SELECT, Admin::TZ_SQL]);
break;
}
}
$resp = Response::factory()->set('tblName', $tableName);
return Tag::hTag('b') . 'Editing Table: ' . $tableName . Tag::_hTag('b') . ' ' . Tag::hRef('ajax.php?' . $resp->action(__CLASS__ . '->csv()'), 'CSV') . ' ' . Tag::hRef('ajax.php?' . $resp->action(__CLASS__ . '->xls()'), 'XLS') . $crud->index();
}
public function manageUsersToGroups()
{
$key = Request::get('KEY');
if ($key == '') {
return 'KEY missing';
}
$userSql = DB::driver() == DB::MYSQL ? self::USER_SQL_MYSQL : self::USER_SQL_SQLITE;
$row = DB::oneRow(DB::DEF, 'SELECT * FROM tblGroup WHERE fldGroupID=?', $key);
return Tag::hTag('h4') . Tag::e('Editing Users in ' . $row['fldName'] . '(' . $row['fldLongName'] . ')') . Tag::_hTag('h4') . CRUD::factory('tblUserGroupMap', ['topPager' => false, 'where' => ['fldGroupID' => $key]])->setColDisplay('fldUserID', [CRUD::SELECT, $userSql, true])->setColDisplay('fldGroupID', CRUD::DISPLAY)->copyVarsFromRequest('KEY')->index();
}