*/ $cidReset = true; require_once __DIR__.'/../inc/global.inc.php'; $this_section = SECTION_PLATFORM_ADMIN; api_protect_global_admin_script(); if (!api_get_multiple_access_url()) { header('Location: index.php'); exit; } $first_letter_user = ''; $url_list = []; $users = []; $tbl_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL); $tbl_user = Database::get_main_table(TABLE_MAIN_USER); /* Header */ $tool_name = get_lang('Add users to an URL'); $interbreadcrumb[] = ['url' => 'index.php', 'name' => get_lang('Administration')]; $interbreadcrumb[] = ['url' => 'access_urls.php', 'name' => get_lang('Multiple access URL / Branding')]; Display :: display_header($tool_name); echo '
'; echo Display::url( Display::return_icon('edit.png', get_lang('Edit users and URLs'), ''), api_get_path(WEB_CODE_PATH).'admin/access_url_edit_users_to_url.php' ); echo '
'; api_display_tool_title($tool_name); if ($_POST['form_sent']) { $form_sent = $_POST['form_sent']; $users = is_array($_POST['user_list']) ? $_POST['user_list'] : []; $url_list = is_array($_POST['url_list']) ? $_POST['url_list'] : []; $first_letter_user = $_POST['first_letter_user']; foreach ($users as $key => $value) { $users[$key] = intval($value); } if ($form_sent == 1) { if (count($users) == 0 || count($url_list) == 0) { echo Display::return_message( get_lang('You must select at least one user and one URL'), 'error' ); } else { UrlManager::add_users_to_urls($users, $url_list); echo Display::return_message(get_lang('The user accounts are now attached to the URL'), 'confirm'); } } } /* Display GUI */ if (empty($first_letter_user)) { $sql = "SELECT count(*) as nb_users FROM $tbl_user"; $result = Database::query($sql); $num_row = Database::fetch_array($result); if ($num_row['nb_users'] > 1000) { //if there are too much users to gracefully handle with the HTML select list, // assign a default filter on users names $first_letter_user = 'A'; } unset($result); } $first_letter_user_lower = Database::escape_string(api_strtolower($first_letter_user)); $target_name = api_sort_by_first_name() ? 'firstname' : 'lastname'; $target_name = 'lastname'; $sql = "SELECT user_id,lastname,firstname,username FROM $tbl_user WHERE ".$target_name." LIKE '".$first_letter_user_lower."%' OR ".$target_name." LIKE '".$first_letter_user_lower."%' ORDER BY ".(count($users) > 0 ? "(user_id IN(".implode(',', $users).")) DESC," : "")." ".$target_name; $result = Database::query($sql); $db_users = Database::store_result($result); unset($result); $sql = "SELECT id, url FROM $tbl_access_url WHERE active=1 ORDER BY url"; $result = Database::query($sql); $db_urls = Database::store_result($result); unset($result); ?>


  :