'index.php', 'name' => get_lang('PlatformAdmin')); $interbreadcrumb[] = array('url' => 'usergroups.php', 'name' => get_lang('Classes')); // Database Table Definitions // setting the name of the tool $tool_name = get_lang('SubscribeUsersToClass'); $id = intval($_GET['id']); $relation = isset($_REQUEST['relation']) ? intval($_REQUEST['relation']) : ''; $htmlHeadXtra[] = ' '; $form_sent = 0; $extra_field_list = UserManager::get_extra_fields(); $new_field_list = array(); if (is_array($extra_field_list)) { foreach ($extra_field_list as $extra_field) { //if is enabled to filter and is a "" field type if ($extra_field[8] == 1 && $extra_field[2] == 4) { $new_field_list[] = array( 'name'=> $extra_field[3], 'variable' => $extra_field[1], 'data'=> $extra_field[9] ); } } } $usergroup = new UserGroup(); if (empty($id)) { api_not_allowed(true); } $first_letter_user = ''; if (isset($_POST['form_sent']) && $_POST['form_sent']) { $form_sent = $_POST['form_sent']; $elements_posted = isset($_POST['elements_in_name']) ? $_POST['elements_in_name'] : null; $first_letter_user = $_POST['firstLetterUser']; if (!is_array($elements_posted)) { $elements_posted = array(); } if ($form_sent == 1) { //added a parameter to send emails when registering a user $usergroup->subscribe_users_to_usergroup( $id, $elements_posted, true, $relation ); header('Location: usergroups.php'); exit; } } if (isset($_GET['action']) && $_GET['action'] == 'export') { $groupInfo = $usergroup->get($id); $users = $usergroup->getUserListByUserGroup($id); if (!empty($users)) { $data = array( array('UserName', 'ClassName') ); foreach ($users as $user) { $data[] = array($user['username'], $groupInfo['name']); } $filename = 'export_user_class_'.api_get_local_time(); Export::arrayToCsv($data, $filename); exit; } } // Filter by Extra Fields $use_extra_fields = false; if (is_array($extra_field_list)) { if (is_array($new_field_list) && count($new_field_list) > 0) { foreach ($new_field_list as $new_field) { $varname = 'field_'.$new_field['variable']; if (UserManager::is_extra_field_available($new_field['variable'])) { if (isset($_POST[$varname]) && $_POST[$varname] != '0') { $use_extra_fields = true; $extra_field_result[] = UserManager::get_extra_user_data_by_value( $new_field['variable'], $_POST[$varname] ); } } } } } if ($use_extra_fields) { $final_result = array(); if (count($extra_field_result) > 1) { for ($i = 0; $i < count($extra_field_result) - 1; $i++) { if (is_array($extra_field_result[$i + 1])) { $final_result = array_intersect($extra_field_result[$i], $extra_field_result[$i + 1]); } } } else { $final_result = $extra_field_result[0]; } } // Filters $filters = array( array('type' => 'text', 'name' => 'username', 'label' => get_lang('Username')), array('type' => 'text', 'name' => 'firstname', 'label' => get_lang('FirstName')), array('type' => 'text', 'name' => 'lastname', 'label' => get_lang('LastName')), array('type' => 'text', 'name' => 'official_code', 'label' => get_lang('OfficialCode')), array('type' => 'text', 'name' => 'email', 'label' => get_lang('Email')) ); $searchForm = new FormValidator('search', 'get', api_get_self().'?id='.$id); $searchForm->addHeader(get_lang('AdvancedSearch')); $renderer = & $searchForm->defaultRenderer(); $searchForm->addElement('hidden', 'id', $id); foreach ($filters as $param) { $searchForm->addElement($param['type'], $param['name'], $param['label']); } $searchForm->addButtonSearch(); $filterData = array(); if ($searchForm->validate()) { $filterData = $searchForm->getSubmitValues(); } $data = $usergroup->get($id); $list_in = $usergroup->getUsersByUsergroupAndRelation($id, $relation); $list_all = $usergroup->get_users_by_usergroup(); $order = array('lastname'); if (api_is_western_name_order()) { $order = array('firstname'); } $orderListByOfficialCode = api_get_setting('order_user_list_by_official_code'); if ($orderListByOfficialCode === 'true') { $order = array('official_code', 'lastname'); } $conditions = array(); if (!empty($first_letter_user)) { $conditions['lastname'] = $first_letter_user; } if (!empty($filters) && !empty($filterData)) { foreach ($filters as $filter) { if (isset($filter['name']) && isset($filterData[$filter['name']])) { $value = $filterData[$filter['name']]; if (!empty($value)) { $conditions[$filter['name']] = $value; } } } } $elements_not_in = $elements_in = array(); $complete_user_list = UserManager::get_user_list_like(array(), $order); if (!empty($complete_user_list)) { foreach ($complete_user_list as $item) { if ($use_extra_fields) { if (!in_array($item['user_id'], $final_result)) { continue; } } // Avoid anonymous users if ($item['status'] == 6) { continue; } if (in_array($item['user_id'], $list_in)) { $officialCode = !empty($item['official_code']) ? ' - '.$item['official_code'] : null; $person_name = api_get_person_name( $item['firstname'], $item['lastname'] ).' ('.$item['username'].') '.$officialCode; $orderListByOfficialCode = api_get_setting('order_user_list_by_official_code'); if ($orderListByOfficialCode === 'true') { $officialCode = !empty($item['official_code']) ? $item['official_code'].' - ' : '? - '; $person_name = $officialCode.api_get_person_name( $item['firstname'], $item['lastname'] ).' ('.$item['username'].') '; } $elements_in[$item['user_id']] = $person_name; } } } $user_with_any_group = isset($_REQUEST['user_with_any_group']) && !empty($_REQUEST['user_with_any_group']) ? true : false; if ($user_with_any_group) { $user_list = UserManager::get_user_list_like($conditions, $order, true); $new_user_list = array(); foreach ($user_list as $item) { if (!in_array($item['user_id'], $list_all)) { $new_user_list[] = $item; } } $user_list = $new_user_list; } else { $user_list = UserManager::get_user_list_like($conditions, $order, true); } if (!empty($user_list)) { foreach ($user_list as $item) { if ($use_extra_fields) { if (!in_array($item['user_id'], $final_result)) { continue; } } // Avoid anonymous users if ($item['status'] == 6) { continue; } $officialCode = !empty($item['official_code']) ? ' - '.$item['official_code'] : null; $person_name = api_get_person_name( $item['firstname'], $item['lastname'] ).' ('.$item['username'].') '.$officialCode; $orderListByOfficialCode = api_get_setting('order_user_list_by_official_code'); if ($orderListByOfficialCode === 'true') { $officialCode = !empty($item['official_code']) ? $item['official_code'].' - ' : '? - '; $person_name = $officialCode.api_get_person_name( $item['firstname'], $item['lastname'] ).' ('.$item['username'].') '; } if (!in_array($item['user_id'], $list_in)) { $elements_not_in[$item['user_id']] = $person_name; } } } Display::display_header($tool_name); echo ''; echo ''. Display::return_icon('back.png', get_lang('Back'), array(), ICON_SIZE_MEDIUM).''; echo Display::url(get_lang('AdvancedSearch'), '#', array('class' => 'advanced_options', 'id' => 'advanced_search')); echo ''. Display::return_icon('import_csv.png', get_lang('Import'), array(), ICON_SIZE_MEDIUM).''; echo ''. Display::return_icon('export_csv.png', get_lang('Export'), array(), ICON_SIZE_MEDIUM).''; echo ''; echo ''; $searchForm->display(); echo ''; ?> '.$tool_name.': '.$data['name'].''; if (is_array($extra_field_list)) { if (is_array($new_field_list) && count($new_field_list) > 0) { echo ''.get_lang('FilterByUser').''; foreach ($new_field_list as $new_field) { echo $new_field['name']; $varname = 'field_'.$new_field['variable']; echo ' '; echo '--'.get_lang('Select').'--'; foreach ($new_field['data'] as $option) { $checked = ''; if (isset($_POST[$varname])) { if ($_POST[$varname] == $option[1]) { $checked = 'selected="true"'; } } echo ''.$option[1].''; } echo ''; echo ' '; } echo ''; echo ''; } } echo Display::input('hidden', 'id', $id); echo Display::input('hidden', 'form_sent', '1'); echo Display::input('hidden', 'add_type', null); ?> > > > > > : : -- 'form-control', 'multiple' => 'multiple', 'id' => 'elements_not_in', 'size' => '15px', ), false ); ?> onchange="checked_in_no_group(this.checked);" name="user_with_any_group" id="user_with_any_group_id"> : 'form-control', 'multiple' => 'multiple', 'id' => 'elements_in', 'size' => '15px' ), false ); unset($sessionUsersList); ?> '. get_lang('SubscribeUsersToClass').''; ?>