$table = new pSimpleTable("100%", 'grid'); $table->checkImage(false); $table->addSimpleField(!isset($hdr['Name']) ? _('Nome') : $hdr['Name'], 'do_name', 'CALCULATED', null, array('visible' => true, 'sortable' => true, 'order_fields' => 'do_name, do_auth_type')); $table->addSimpleField(!isset($hdr['Alias']) ? _('Alias') : $hdr['Alias'], 'do_alais', 'CALCULATED', null, array('visible' => true)); $table->addSimpleField(!isset($hdr['Applications']) ? _('Applicativi') : $hdr['Applications'], 'do_applications', 'CALCULATED', null, array('visible' => true)); $table->addSimpleField(!isset($hdr['action']) ? _('Azione') : $hdr['action'], '', 'LINK', 100); $limit = max(10, $auth->getConfigValue('SETTINGS', 'ROW_COUNT', 10)); $pg = max(1, PageVar('pg', 1, isset($_REQUEST['reset']))); $st = ($pg - 1) * $limit; /** Get the users list */ $list = $auth->getDomainsList(array('fields' => 'dn_name as do_name, do_auth_type', 'order' => $table->getSQLOrder($order), 'offset' => $st, 'limit' => $limit), $tot); $table_html = $table->CreateTableHeader($order); foreach ($list as $value) { // Get the lockup data $data = $auth->getDomainData($value['do_name'], true); $table->addCalcValue('do_name', $data['names'][0]); /** The 1st element is the name, the others are alias) */ // Alias $alias = array(); for ($i = 1; $i < count($data['names']); $i++) { $alias[] = $data['names'][$i]; } $s = implode(', ', $alias); $table->addCalcValue('do_alais', $s, $s); // Applications $apps = array(); foreach ($data['applications'] as $val) { $apps[] = $val; } $s = implode(', ', $apps); $table->addCalcValue('do_applications', $s, $s);
$table->checkImage(false); $table->addSimpleField(!isset($hdr['CODE']) ? _('Codice') : $hdr['CODE'], 'app_name', 'STRING', 150, array('visible' => true, 'sortable' => true)); $table->addSimpleField(!isset($hdr['Name']) ? _('Nome') : $hdr['Name'], 'gr_name', 'STRING', 150, array('visible' => true, 'sortable' => true, 'sort_field' => 'app_name, gr_name')); $table->addSimpleField(!isset($hdr['Privato']) ? _('Privato') : $hdr['Privato'], 'private', 'CALCULATED', 50, array('visible' => true, 'sortable' => true)); $table->addSimpleField(!isset($hdr['Description']) ? _('Descrizione') : $hdr['Description'], 'gr_descr', 'STRING', null, array('visible' => true, 'sortable' => true)); $table->addSimpleField(!isset($hdr['action']) ? _('Azione') : $hdr['action'], '', 'LINK', 100); $limit = max(10, $auth->getConfigValue('SETTINGS', 'ROW_COUNT', 10)); $pg = max(1, PageVar('pg', 1, isset($_REQUEST['reset']))); $st = ($pg - 1) * $limit; //SS: Prende campi di altre tabelle $sql2 = "SELECT user_manager.*, COUNT(ugt.gr_id) AS us_tot \n" . "FROM <SQL> \n" . "LEFT JOIN " . $auth_options['users_groups_table'] . " ugt ON user_manager.gr_id=ugt.gr_id \n" . "GROUP BY user_manager.gr_id, gr_name, gr_descr, do_id, app_code, app_name, dn_name \n" . "ORDER BY " . $table->getSQLOrder(); /** Get the groups list */ $list = $auth->getGroupsList($fltapp_code, array('fields' => 'gr_id, gr_name, gr_descr, ' . $auth_options['groups_table'] . '.do_id, ' . 'app_code, app_name, dn_name', 'offset' => $st, 'limit' => $limit, 'sql' => $sql2), $tot); $table_html = $table->CreateTableHeader($order); foreach ($list as $value) { $table->addCalcValue('private', $value['do_id'] == '' ? '' : (!isset($hdr['Si']) ? _('Si') : $hdr['Si'])); $links = array(); $canMod = $auth->hasPerm('MOD', 'GROUP') || $auth->hasPerm('MOD', 'ALL_GROUP'); $canDel = $auth->hasPerm('DEL', 'GROUP') || $auth->hasPerm('DEL', 'ALL_GROUP'); $param = "code={$value['app_code']}&name={$value['gr_name']}&"; $defAct = "groups_edit.php?act=show&{$param}"; $links[] = $table->AddLinkCell(!isset($hdr['visualizza']) ? _('Visualizza') : $hdr['visualizza'], $defAct, '', R3_ICONS_URL . 'ico_view.gif'); if ($canMod) { $defAct = "groups_edit.php?act=mod&{$param}"; $links[] = $table->AddLinkCell(!isset($hnt['edit']) ? _('Modifica') : $hnt['edit'], $defAct, '', R3_ICONS_URL . 'ico_edit.gif'); } else { $links[] = $table->AddLinkCell('', '', '', R3_ICONS_URL . 'ico_spacer.gif'); } if ($canDel) { $links[] = $table->AddLinkCell(!isset($hnt['delete']) ? _('Cancella') : $hnt['delete'], "JavaScript:askDel('" . $value['app_code'] . "', '" . $value['gr_name'] . "')", '', R3_ICONS_URL . 'ico_del.gif'); } else {