// Array to assign names to tables
$arr_col_name = array('usr_login_name' => $gL10n->get('SYS_USERNAME'), 'usr_photo' => $gL10n->get('PHO_PHOTO'), 'mem_begin' => $gL10n->get('SYS_START'), 'mem_end' => $gL10n->get('SYS_END'), 'mem_leader' => $gL10n->get('SYS_LEADERS'));
// Array for valid colums visible for current user.
// Needed for PDF export to set the correct colspan for the layout
// Maybe there are hidden fields.
$arrValidColumns = array();
$mainSql = '';
// Main SQL statement for lists
$str_csv = '';
// CSV file as string
$leiter = 0;
// Group has leaders
try {
// create list configuration object and create a sql statement out of it
$list = new ListConfiguration($gDb, $getListId);
$mainSql = $list->getSQL($roleIds, $getShowMembers, $startDateEnglishFormat, $endDateEnglishFormat);
// echo $mainSql; exit();
} catch (AdmException $e) {
$e->showHtml();
}
// determine the number of users in this list
$listStatement = $gDb->query($mainSql);
$numMembers = $listStatement->rowCount();
// get all members and their data of this list in an array
$membersList = $listStatement->fetchAll();
if ($numMembers == 0) {
// Es sind keine Daten vorhanden !
$gMessage->show($gL10n->get('LST_NO_USER_FOUND'));
}
// define title (html) and headline
$title = $gL10n->get('LST_LIST') . ' - ' . $roleName;
default:
break;
}
// Array um den Namen der Tabellen sinnvolle Texte zuzuweisen
$arr_col_name = array('usr_login_name' => $gL10n->get('SYS_USERNAME'), 'usr_photo' => $gL10n->get('PHO_PHOTO'), 'mem_begin' => $gL10n->get('SYS_START'), 'mem_end' => $gL10n->get('SYS_END'), 'mem_leader' => $gL10n->get('SYS_LEADER'));
$mainSql = '';
// enthaelt das Haupt-Sql-Statement fuer die Liste
$str_csv = '';
// enthaelt die komplette CSV-Datei als String
$leiter = 0;
// Gruppe besitzt Leiter
$memberStatus = '';
try {
// create list configuration object and create a sql statement out of it
$list = new ListConfiguration($gDb, $getListId);
$mainSql = $list->getSQL($role_ids, $getShowMembers);
//echo $mainSql; exit();
} catch (AdmException $e) {
$e->showHtml();
}
// determine the number of users in this list
$resultList = $gDb->query($mainSql);
$numMembers = $gDb->num_rows($resultList);
if ($numMembers == 0) {
// Es sind keine Daten vorhanden !
$gMessage->show($gL10n->get('LST_NO_USER_FOUND'));
}
if ($numMembers < $getStart) {
$gMessage->show($gL10n->get('SYS_INVALID_PAGE_VIEW'));
}
// define title (html) and headline
