} } else { $url = R3_DOMAIN_URL . $_SERVER['REQUEST_URI']; } $url .= (strpos($url, '?') === false ? '?' : '&') . 'proxytime=' . md5(time()); $objAjax = new xajax($url); $objAjax->registerExternalFunction('submitForm', 'domains_edit_ajax.php'); $objAjax->processRequests(); $smarty->assign('xajax_js_include', $objAjax->getJavascript(R3_JS_URL)); $order = pageVar('order', '1A', isset($_REQUEST['reset'])); /** filters */ $filter_where = ''; /** List table */ $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
$fltac_type = null; } $acTypeList = array(); try { $acTypeList = $auth->getACNamesTypeList(); foreach ($acTypeList as $key => $val) { $acTypeList[$key] = $authText["user_manager_acname_type_{$key}"]; } } catch (EPermissionDenied $e) { $acTypeList = null; } $smarty->assign('ac_type_list', $acTypeList); /** List table */ $table = new pSimpleTable("100%", 'grid'); $table->checkImage(false); $table->addSimpleField(!isset($hdr['Applicatione']) ? _('Applicativo') : $hdr['Applicatione'], 'app_name', 'STRING', 150, array('visible' => true, 'sortable' => true, 'order_fields' => 'app_name, ac_verb, ac_name')); $table->addSimpleField(!isset($hdr['Verbo']) ? _('Verbo') : $hdr['Verbo'], 'ac_verb', 'STRING', 150, array('visible' => true, 'sortable' => true, 'order_fields' => 'ac_verb, ac_name, app_name')); $table->addSimpleField(!isset($hdr['Oggetto']) ? _('Oggetto') : $hdr['Oggetto'], 'ac_name', 'STRING', 150, array('visible' => true, 'sortable' => true, 'order_fields' => 'ac_name, app_name, ac_verb')); $table->addSimpleField(!isset($hdr['Descrizione']) ? _('Descrizione') : $hdr['Descrizione'], 'ac_descr', 'STRING', null, array('visible' => true, 'sortable' => true, 'order_fields' => 'ac_descr, app_name, ac_verb, ac_name')); $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(gat.ac_id) AS gr_tot, COUNT(uat.ac_id) AS us_tot \n" . "FROM <SQL> \n" . "LEFT JOIN " . $auth_options['groups_acl_table'] . " gat ON user_manager.ac_id=gat.ac_id \n" . "LEFT JOIN " . $auth_options['users_acl_table'] . " uat ON user_manager.ac_id=uat.ac_id \n" . "GROUP BY user_manager.ac_id, app_name, app_code, ac_verb, ac_name, ac_type, ac_active, ac_descr \n" . "ORDER BY " . $table->getSQLOrder(); $list = $auth->getACNamesList($fltapp_code, array('fields' => 'ac_id, app_name, app_code, ac_verb, ac_name, ac_type, ac_active, ac_descr', 'offset' => $st, 'limit' => $limit, 'sql' => $sql2, 'where' => $filter_where), $tot); $table_html = $table->CreateTableHeader($order); foreach ($list as $value) { $links = array(); $canMod = $auth->hasPerm('MOD', 'ACNAME') || $auth->hasPerm('MOD', 'ALL_ACNAME'); $canDel = $auth->hasPerm('DEL', 'ACNAME') || $auth->hasPerm('DEL', 'ALL_ACNAME');
$filter_where = ' 1=1 '; /** login_name filter */ if ($login_name != '') { $filter_where .= ' AND us_login ilike ' . $auth->quote('%' . $login_name . '%') . ' or us_name ilike ' . $auth->quote('%' . $login_name . '%'); $smarty->assign('login_name', $login_name); } if ($us_status != '') { $filter_where .= ' AND us_status ilike ' . $auth->quote($us_status); $smarty->assign('us_status', $us_status); } /** List table */ $styleName = $auth->getConfigValue('USER_MANAGER', 'TABLE_STYLE', 'grid_wrap'); $table = new pSimpleTable("100%", $styleName); $table->checkImage(false); if ($auth->getConfigValue('USER_MANAGER', 'SHOW_UID') != 'F') { $table->addSimpleField('UID', 'us_id', 'INTEGER', 40, array('visible' => true, 'align' => 'right', 'sortable' => true)); } $table->addSimpleField(!isset($hdr['Login']) ? _('Login') : $hdr['Login'], 'us_login', 'STRING', 150, array('visible' => true, 'align' => 'left', 'sortable' => true)); $table->addSimpleField(!isset($hdr['Nome']) ? _('Nome') : $hdr['Nome'], 'us_name', 'STRING', null, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'us_name, us_login, us_id asc')); if ($canShowDomains && $auth->getConfigValue('USER_MANAGER', 'SHOW_DOMAIN') != 'F') { //SS: verificare permission $table->addSimpleField(!isset($hdr['Domain']) ? _('Dominio') : $hdr['Domain'], 'dn_name', 'STRING', 100, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'dn_name, us_name, us_login, us_id asc')); } if ($auth->getConfigValue('USER_MANAGER', 'SHOW_GROUPS') != 'F') { //SS: verificare permission $table->addSimpleField(!isset($hdr['Groups']) ? _('Gruppo') : $hdr['Groups'], 'groups', 'CALCULATED', 200, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'us_name, us_login, us_id asc')); } if ($canShowUserApplications && $auth->getConfigValue('USER_MANAGER', 'SHOW_APPLICATIONS') != 'F') { //SS: verificare permission $table->addSimpleField(!isset($hdr['Applications']) ? _('Applicazioni') : $hdr['Applications'], 'applications', 'CALCULATED', 200, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'us_name, us_login, us_id asc')); }
$data[$val['app_code']][$val['app_code'] . '|' . $val['gr_name']] = $val['gr_name']; } $smarty->assign('export_gr_name_list', $data); } else { $smarty->assign('export_gr_name_list', $auth->mkAssociativeArray($auth->getGroupsList($fltapp_code), 'GROUP')); } } catch (EPermissionDenied $e) { } catch (EDatabaseError $e) { echo "Database error: " . $e->getMessage() . "\n"; } catch (Exception $e) { echo "Generic error: " . $e->getMessage() . "\n"; } /** List table */ $table = new pSimpleTable("100%", 'grid'); $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();
$smarty->assign('fltdebug', $fltdebug); $smarty->assign('fltauth', $fltauth); $smarty->assign('fltnavigation', $fltnavigation); /** limit filter */ $limit_list = array(10 => 10, 25 => 25, 50 => 50, 100 => 100, 250 => 250, 500 => 500, 1000 => 1000); if (!in_array($auth->getConfigValue('SETTINGS', 'ROW_COUNT', 10), $limit_list)) { $limit_list[$auth->getConfigValue('SETTINGS', 'ROW_COUNT', 10)] = $auth->getConfigValue('SETTINGS', 'ROW_COUNT', 10); asort($limit_list); } $smarty->assign('fltlimit', $fltlimit); $smarty->assign('limit_list', $limit_list); /** List table */ $table = new pSimpleTable("100%", 'grid'); $table->checkImage(false); //$table->addSimpleField('log_id', 'log_id', 'INTEGER', 60, array('visible'=>true,'align'=>'right', 'sortable'=>true));// $table->addSimpleField(!isset($hdr['logs_date']) ? _('Data/ora') : $hdr['logs_date'], 'log_time', 'DATETIME', 140, array('align' => 'center', 'sortable' => true, 'order_fields' => 'log_time, log_id')); $table->addSimpleField(_('Tipo'), 'log_type', 'TEXT', 40, array('align' => 'center', 'sortable' => true, 'order_fields' => 'log_type, log_id')); $table->addSimpleField(!isset($hdr["logs_login"]) ? _('Login') : $hdr["logs_login"], 'us_login', 'STRING', 100, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'us_login, log_id')); //$table->addSimpleField('Nome', 'us_name', 'STRING', null, array('visible'=>true,'align'=>'left', 'sortable'=>true, 'order_fields'=>'us_name, us_login, log_id'));// if ($fltdn_name == '' && $canShowDomains && $auth->getConfigValue('USER_MANAGER', 'SHOW_DOMAIN') != 'F') { $table->addSimpleField(!isset($hdr["logs_domain"]) ? _('Dominio') : $hdr["logs_domain"], 'dn_name', 'STRING', 150, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'dn_name, log_time, log_id')); } if ($fltapp_code == '' && $canShowApplications && $auth->getConfigValue('USER_MANAGER', 'SHOW_APPLICATION') != 'F') { $table->addSimpleField(!isset($hdr["logs_application"]) ? _('Applicazione') : $hdr["logs_application"], 'app_name', 'STRING', 150, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'app_name, log_time, log_id')); } $table->addSimpleField(!isset($hdr["logs_ip"]) ? _('IP') : $hdr["logs_ip"], 'log_ip', 'STRING', 100, array('visible' => true, 'align' => 'center', 'sortable' => true, 'order_fields' => 'log_ip, us_name, us_login, log_ip')); $table->addSimpleField(!isset($hdr["logs_page"]) ? _('Pagina') : $hdr["logs_page"], 'log_page', 'STRING', null, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'log_page, us_name, us_login, log_ip')); $table->addSimpleField(!isset($hdr["logs_note"]) ? _('Note') : $hdr["logs_note"], 'log_text', 'STRING'); $table_html = $table->CreateTableHeader($order); $list = $auth->getLogList($fltdn_name, $fltapp_code, array('order' => $table->getSQLOrder($order), 'offset' => $st, 'where' => $filter_where, 'limit' => $fltlimit), $tot); foreach ($list as $value) {
$objAjax = new xajax($url); $objAjax->registerExternalFunction('disconnectUser', 'applications_edit_ajax.php'); $objAjax->processRequests(); $smarty->assign('xajax_js_include', $objAjax->getJavascript(R3_JS_URL)); $order = pageVar('order', '1A', isset($_REQUEST['reset'])); $limit = max(10, $auth->getConfigValue('SETTINGS', 'ROW_COUNT', 10)); $pg = max(1, PageVar('pg', 1, isset($_REQUEST['reset']))); $st = ($pg - 1) * $limit; /** filters */ $filter_where = ''; $canShowDomains = $auth->hasPerm('SHOW', 'DOMAIN') || $auth->hasPerm('SHOW', 'ALL_DOMAINS'); /** List table */ $table = new pSimpleTable("100%", 'grid'); $table->checkImage(false); if ($auth->getConfigValue('USER_MANAGER', 'SHOW_UID') != 'F') { $table->addSimpleField('UID', 'us_id', 'INTEGER', 60, array('visible' => true, 'align' => 'right', 'sortable' => true)); } $table->addSimpleField(!isset($hdr['Login']) ? _('Login') : $hdr['Login'], 'us_login', 'STRING', 150, array('visible' => true, 'align' => 'left', 'sortable' => true)); $table->addSimpleField(!isset($hdr['Nome']) ? _('Nome') : $hdr['Nome'], 'us_name', 'STRING', null, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'us_name, us_login, us_id asc')); if ($canShowDomains && $auth->getConfigValue('USER_MANAGER', 'SHOW_DOMAIN') != 'F') { //SS: verificare permission $table->addSimpleField(!isset($hdr['Domain']) ? _('Dominio') : $hdr['Domain'], 'dn_name', 'STRING', 100, array('visible' => true, 'align' => 'left', 'sortable' => true, 'order_fields' => 'us_name, us_login, us_id asc')); } $table->addSimpleField('IP', 'us_last_ip', 'STRING', 100, array('visible' => true, 'align' => 'center', 'sortable' => true, 'order_fields' => 'us_last_ip, us_name, us_login, us_id asc')); $table->addSimpleField(!isset($hdr['login_time']) ? _('Ora login') : $hdr['login_time'], 'us_last_login', 'DATETIME', 150, array('visible' => true, 'align' => 'center', 'sortable' => true, 'order_fields' => 'us_last_login, us_name, us_login, us_id asc')); $table->addSimpleField(!isset($hdr['last_login_time']) ? _('Ora ultima azione') : $hdr['last_login_time'], 'us_last_action', 'DATETIME', 150, array('visible' => true, 'align' => 'center', 'sortable' => true, 'order_fields' => 'us_last_action, us_last_login, us_name, us_login, us_id asc')); if ($auth->hasPerm('DISCONNECT', 'USER')) { $table->addSimpleField(!isset($hdr['action']) ? _('Azione') : $hdr['action'], '', 'LINK', 20); } /** Get the users list */ $list = $auth->getConnectedUsersList(null, null, array('order' => $table->getSQLOrder(), 'offset' => $st, 'limit' => $limit), $tot);