$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) {