$table->setDatatablesRowsPerPage($gPreferences['lists_members_per_page']);
} else {
$table = new HtmlTable('adm_lists_table', $page, $hoverRows, $datatable, $classTable);
}
}
// initialize array parameters for table and set the first column for the counter
if ($getMode === 'html') {
// in html mode we group leaders. Therefore we need a special hidden column.
$columnAlign = array('left', 'left');
$columnValues = array($gL10n->get('SYS_ABR_NO'), $gL10n->get('INS_GROUPS'));
} else {
$columnAlign = array('left');
$columnValues = array($gL10n->get('SYS_ABR_NO'));
}
// headlines for columns
for ($columnNumber = 1; $columnNumber <= $list->countColumns(); ++$columnNumber) {
$column = $list->getColumnObject($columnNumber);
// Find name of the field
if ($column->getValue('lsc_usf_id') > 0) {
// customs field
$usf_id = $column->getValue('lsc_usf_id');
$columnHeader = $gProfileFields->getPropertyById($usf_id, 'usf_name');
if ($gProfileFields->getPropertyById($usf_id, 'usf_type') === 'CHECKBOX' || $gProfileFields->getPropertyById($usf_id, 'usf_name_intern') === 'GENDER') {
$columnAlign[] = 'center';
} elseif ($gProfileFields->getPropertyById($usf_id, 'usf_type') === 'NUMBER' || $gProfileFields->getPropertyById($usf_id, 'usf_type') === 'DECIMAL') {
$columnAlign[] = 'right';
} else {
$columnAlign[] = 'left';
}
} else {
$usf_id = 0;
$list = new ListConfiguration($gDb, $getListId);
if (isset($_SESSION['mylist_request'])) {
$form_values = strStripSlashesDeep($_SESSION['mylist_request']);
unset($_SESSION['mylist_request']);
$getRoleId = $form_values['rol_id'];
// falls vorher schon Zeilen fuer Spalten manuell hinzugefuegt wurden,
// muessen diese nun direkt angelegt werden
for ($i = $default_column_rows + 1; $i > 0; $i++) {
if (isset($form_values['column' . $i])) {
$default_column_rows++;
} else {
$i = -1;
}
}
} elseif ($getListId > 0) {
$default_column_rows = $list->countColumns();
}
// create html page object
$page = new HtmlPage($headline);
$javascriptCode = '
var listId = ' . $getListId . ';
var fieldNumberIntern = 0;
var arr_user_fields = createProfileFieldsArray();
var arr_default_fields = createColumnsArray();
// Funktion fuegt eine neue Zeile zum Zuordnen von Spalten fuer die Liste hinzu
function addColumn()
{
// MySQL erlaubt nur 61 gejointe Tabellen
if(fieldNumberIntern >= 57)
{
// muessen diese nun direkt angelegt werden
for ($i = $defaultColumnRows + 1; $i > 0; ++$i) {
if (isset($formValues['column' . $i])) {
++$defaultColumnRows;
} else {
$i = -1;
}
}
} else {
$formValues['sel_select_configuation'] = $getListId;
$formValues['cbx_global_configuration'] = $list->getValue('lst_global');
$formValues['sel_roles_ids'] = $getRoleId;
$formValues['sel_show_members'] = $getShowMembers;
// if a saved configuration was loaded then add columns to formValues array
if ($getListId > 0) {
$defaultColumnRows = $list->countColumns();
for ($number = 1; $number <= $list->countColumns(); ++$number) {
$column = $list->getColumnObject($number);
if ($column->getValue('lsc_usf_id') > 0) {
$column_content = $column->getValue('lsc_usf_id');
} else {
$column_content = $column->getValue('lsc_special_field');
}
$formValues['column' . $number] = $column_content;
$formValues['sort' . $number] = $column->getValue('lsc_sort');
$formValues['condition' . $number] = $column->getValue('lsc_filter');
}
}
}
// create html page object
$page = new HtmlPage($headline);
$pdf->SetMargins(10, 20, 10);
$pdf->SetHeaderMargin(10);
$pdf->SetFooterMargin(0);
//headline for PDF
$pdf->SetHeaderData('', '', $headline, '');
// set font
$pdf->SetFont('times', '', 10);
// add a page
$pdf->AddPage();
// Create table object for display
$table = new HtmlTable('adm_lists_table', $pdf, $hoverRows, $datatable, $classTable);
$table->addAttribute('border', '1');
$table->addTableHeader();
$table->addRow();
$table->addAttribute('align', 'center');
$table->addColumn($headline, array('colspan' => $list->countColumns() + 1));
$table->addRow();
} elseif ($getMode == 'html') {
$datatable = true;
$hoverRows = true;
// create html page object
$page = new HtmlPage();
if ($getFullScreen == true) {
$page->hideThemeHtml();
}
$page->setTitle($title);
$page->addHeadline($headline);
$page->addHtml('<h5>' . $role->getValue('cat_name') . ' - ' . $memberStatus . '</h5>');
$page->addJavascript('
$("#export_list_to").change(function () {
if($(this).val().length > 1) {
