/** * @param EasySCP_TemplateEngine $tpl * @param int $admin_id */ function generate_users_list($tpl, $admin_id) { $sql = EasySCP_Registry::get('Db'); $cfg = EasySCP_Registry::get('Config'); $rows_per_page = $cfg->DOMAIN_ROWS_PER_PAGE; if (isset($_POST['details']) && !empty($_POST['details'])) { $_SESSION['details'] = $_POST['details']; } else { if (!isset($_SESSION['details'])) { $_SESSION['details'] = "hide"; } } if (isset($_GET['psi']) && $_GET['psi'] == 'last') { if (isset($_SESSION['search_page'])) { $_GET['psi'] = $_SESSION['search_page']; } else { unset($_GET['psi']); } } // Search request generated? if (isset($_POST['search_for']) && !empty($_POST['search_for'])) { $_SESSION['search_for'] = trim(clean_input($_POST['search_for'])); $_SESSION['search_common'] = $_POST['search_common']; $_SESSION['search_status'] = $_POST['search_status']; $start_index = 0; } else { $start_index = isset($_GET['psi']) ? (int) $_GET['psi'] : 0; if (isset($_SESSION['search_for']) && !isset($_GET['psi'])) { // He have not got scroll through patient records. unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } } $_SESSION['search_page'] = $start_index; $search_query = ''; $count_query = ''; if (isset($_SESSION['search_for'])) { gen_manage_domain_query($search_query, $count_query, $admin_id, $start_index, $rows_per_page, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); gen_manage_domain_search_options($tpl, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); } else { gen_manage_domain_query($search_query, $count_query, $admin_id, $start_index, $rows_per_page, 'n/a', 'n/a', 'n/a'); gen_manage_domain_search_options($tpl, 'n/a', 'n/a', 'n/a'); } $rs = execute_query($sql, $count_query); $records_count = $rs->fields['cnt']; $rs = execute_query($sql, $search_query); if ($records_count == 0) { if (isset($_SESSION['search_for'])) { $tpl->assign(array('USERS_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('View aliases'), 'SHOW_DETAILS' => tr("Show"))); set_page_message(tr('Not found user records matching the search criteria!'), 'info'); unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } else { $tpl->assign(array('USERS_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('View aliases'), 'SHOW_DETAILS' => tr("Show"))); set_page_message(tr('You have no users.'), 'info'); } } else { $prev_si = $start_index - $rows_per_page; if ($start_index == 0) { $tpl->assign('SCROLL_PREV', ''); } else { $tpl->assign(array('SCROLL_PREV_GRAY' => '', 'PREV_PSI' => $prev_si)); } $next_si = $start_index + $rows_per_page; if ($next_si + 1 > $records_count) { $tpl->assign('SCROLL_NEXT', ''); } else { $tpl->assign(array('SCROLL_NEXT_GRAY' => '', 'NEXT_PSI' => $next_si)); } while (!$rs->EOF) { if ($rs->fields['status'] == $cfg->ITEM_OK_STATUS) { $status_icon = "ok"; } else { if ($rs->fields['status'] == $cfg->ITEM_DISABLED_STATUS) { $status_icon = "disabled"; } else { if ($rs->fields['status'] == $cfg->ITEM_ADD_STATUS || $rs->fields['status'] == $cfg->ITEM_CHANGE_STATUS || $rs->fields['status'] == $cfg->ITEM_TOENABLE_STATUS || $rs->fields['status'] == $cfg->ITEM_RESTORE_STATUS || $rs->fields['status'] == $cfg->ITEM_TODISABLED_STATUS || $rs->fields['status'] == $cfg->ITEM_DELETE_STATUS) { $status_icon = "reload"; } else { $status_icon = "error"; } } } $status_url = $rs->fields['domain_id']; $tpl->append(array('STATUS_ICON' => $status_icon, 'URL_CHANGE_STATUS' => $status_url)); $admin_name = decode_idna($rs->fields['domain_name']); $dom_created = $rs->fields['domain_created']; $dom_expires = $rs->fields['domain_expires']; if ($dom_created == 0) { $dom_created = tr('N/A'); } else { $dom_created = date($cfg->DATE_FORMAT, $dom_created); } if ($dom_expires == 0) { $dom_expires = tr('Not Set'); } else { $dom_expires = date($cfg->DATE_FORMAT, $dom_expires); } $tpl->append(array('CREATION_DATE' => $dom_created, 'EXPIRE_DATE' => $dom_expires, 'DOMAIN_ID' => $rs->fields['domain_id'], 'NAME' => tohtml($admin_name), 'USER_ID' => $rs->fields['domain_admin_id'], 'DISK_USAGE' => $rs->fields['domain_disk_limit'] ? tr('%1$s of %2$s MB', round($rs->fields['domain_disk_usage'] / 1024 / 1024, 1), $rs->fields['domain_disk_limit']) : tr('%1$s of <strong>unlimited</strong> MB', round($rs->fields['domain_disk_usage'] / 1024 / 1024, 1)))); gen_domain_details($tpl, $sql, $rs->fields['domain_id']); $rs->moveNext(); } } }
/** * Generates users list. * * @param iMSCP_pTemplate $tpl Template engine * @param int $resellerId Reseller unique identifier * @return void */ function generate_users_list($tpl, $resellerId) { $cfg = iMSCP_Registry::get('config'); $rowsPerPage = $cfg['DOMAIN_ROWS_PER_PAGE']; if (isset($_POST['details']) && !empty($_POST['details'])) { $_SESSION['details'] = $_POST['details']; } else { if (!isset($_SESSION['details'])) { $_SESSION['details'] = 'hide'; } } if (isset($_GET['psi']) && $_GET['psi'] == 'last') { if (isset($_SESSION['search_page'])) { $_GET['psi'] = $_SESSION['search_page']; } else { unset($_GET['psi']); } } // Search request generated? if (isset($_POST['search_for']) && !empty($_POST['search_for'])) { $_SESSION['search_for'] = trim(clean_input($_POST['search_for'])); $_SESSION['search_common'] = $_POST['search_common']; $_SESSION['search_status'] = $_POST['search_status']; $startIndex = 0; } else { $startIndex = isset($_GET['psi']) ? (int) $_GET['psi'] : 0; if (isset($_SESSION['search_for']) && !isset($_GET['psi'])) { // He have not got scroll through patient records. unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } } $_SESSION['search_page'] = $startIndex; $searchQuery = ''; $countQuery = ''; if (isset($_SESSION['search_for'])) { gen_manage_domain_query($searchQuery, $countQuery, $resellerId, $startIndex, $rowsPerPage, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); gen_manage_domain_search_options($tpl, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); } else { gen_manage_domain_query($searchQuery, $countQuery, $resellerId, $startIndex, $rowsPerPage, 'n/a', 'n/a', 'n/a'); gen_manage_domain_search_options($tpl, 'n/a', 'n/a', 'n/a'); } $stmt = execute_query($countQuery); $rowCount = $stmt->fields['cnt']; $stmt = execute_query($searchQuery); if ($rowCount == 0) { if (isset($_SESSION['search_for'])) { $tpl->assign(array('USR_MESSAGE' => tr('No records found matching the search criteria.'), 'USERS_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('View aliases'), 'SHOW_DETAILS' => tr('Show'))); unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } else { $tpl->assign(array('USERS_SEARCH' => '', 'USR_MESSAGE' => tr('No customer accounts found.'), 'USERS_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_PREV_GRAY' => '', 'SCROLL_NEXT' => '', 'SCROLL_NEXT_GRAY' => '', 'TR_VIEW_DETAILS' => tr('View aliases'), 'SHOW_DETAILS' => tr('Show'))); } $tpl->parse('USR_MESSAGE', 'usr_message'); } else { $prevSi = $startIndex - $rowsPerPage; if ($startIndex == 0) { $tpl->assign('SCROLL_PREV', ''); } else { $tpl->assign(array('SCROLL_PREV_GRAY' => '', 'PREV_PSI' => $prevSi)); } $nextSi = $startIndex + $rowsPerPage; if ($nextSi + 1 > $rowCount) { $tpl->assign('SCROLL_NEXT', ''); } else { $tpl->assign(array('SCROLL_NEXT_GRAY' => '', 'NEXT_PSI' => $nextSi)); } while ($row = $stmt->fetchRow(PDO::FETCH_ASSOC)) { if ($row['admin_status'] == 'ok' && $row['domain_status'] == 'ok') { $statusIcon = 'ok'; $statusDomain = translate_dmn_status($row['domain_status']); $domainStatusTooltip = tr('Click to deactivate'); $statusBool = true; $canChange = true; } else { if ($row['domain_status'] == 'disabled') { $statusIcon = 'disabled'; $statusDomain = translate_dmn_status($row['domain_status']); $domainStatusTooltip = tr('Click to activate'); $statusBool = false; $canChange = true; } else { if ($row['domain_status'] == 'toadd' || $row['domain_status'] == 'torestore' || $row['domain_status'] == 'tochange' || $row['domain_status'] == 'toenable' || $row['domain_status'] == 'todisable' || $row['domain_status'] == 'todelete') { $statusIcon = 'reload'; $statusDomain = $domainStatusTooltip = translate_dmn_status($row['admin_status'] != 'ok' ? $row['admin_status'] : $row['domain_status']); $statusBool = false; $canChange = false; } else { $statusIcon = 'error'; $statusDomain = translate_dmn_status($row['admin_status'] != 'ok' ? $row['admin_status'] : $row['domain_status']); $domainStatusTooltip = tr('An unexpected error occurred. Please contact your administrator.'); $statusBool = false; $canChange = false; } } } $domainId = $row['domain_id']; $tpl->assign(array('DOMAIN_STATUS' => $statusDomain, 'DOMAIN_STATUS_TOOLTIP' => $domainStatusTooltip, 'STATUS_ICON' => $statusIcon, 'DOMAIN_ID' => $domainId)); if ($canChange) { $tpl->assign('DOMAIN_STATUS_NOCHANGE', ''); $tpl->parse('DOMAIN_STATUS_CHANGE', 'domain_status_change'); } else { $tpl->assign('DOMAIN_STATUS_CHANGE', ''); $tpl->parse('DOMAIN_STATUS_NOCHANGE', 'domain_status_nochange'); } $adminName = decode_idna($row['domain_name']); if ($statusBool == false) { // reload $tpl->assign('STATUS_RELOAD_TRUE', ''); $tpl->assign('NAME', tohtml($adminName)); $tpl->parse('STATUS_RELOAD_FALSE', 'status_reload_false'); } else { $tpl->assign('STATUS_RELOAD_FALSE', ''); $tpl->assign('NAME', $adminName); $tpl->parse('STATUS_RELOAD_TRUE', 'status_reload_true'); } $domainCreated = $row['domain_created']; if ($domainCreated == 0) { $domainCreated = tr('N/A'); } else { $domainCreated = date($cfg['DATE_FORMAT'], $domainCreated); } $tpl->assign(array('CREATION_DATE' => $domainCreated, 'ACTION' => tr('Delete'), 'USER_ID' => $row['domain_admin_id'], 'CHANGE_INTERFACE' => tr('Switch'), 'DISK_USAGE' => $row['domain_disk_limit'] ? tr('%1$s of %2$s', bytesHuman($row['domain_disk_usage']), mebibyteHuman($row['domain_disk_limit'])) : tr('%1$s of <b>unlimited</b>', bytesHuman($row['domain_disk_usage'])))); gen_domain_details($tpl, $row['domain_id']); $tpl->parse('USER_ENTRY', '.user_entry'); } $tpl->assign('USR_MESSAGE', ''); $tpl->parse('USER_LIST', 'users_list'); } }
function generate_users_list(&$tpl, $admin_id) { global $sql, $externel_event, $cfg; $start_index = 0; $rows_per_page = $cfg['DOMAIN_ROWS_PER_PAGE']; if (isset($_POST['details']) && $_POST['details'] !== '') { $_SESSION['details'] = $_POST['details']; } else { if (!isset($_SESSION['details'])) { $_SESSION['details'] = "hide"; } } if (isset($_GET['psi'])) { $start_index = $_GET['psi']; } // // Search requet generated ?! // if (isset($_POST['uaction']) && $_POST['uaction'] !== '') { $_SESSION['search_for'] = trim($_POST['search_for']); $_SESSION['search_common'] = $_POST['search_common']; $_SESSION['search_status'] = $_POST['search_status']; $start_index = 0; } else { if (isset($_SESSION['search_for']) && !isset($_GET['psi'])) { // // He have not got scroll through patient records. // unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } } $search_query = ''; $count_query = ''; if (isset($_SESSION['search_for'])) { gen_manage_domain_query($search_query, $count_query, $admin_id, $start_index, $rows_per_page, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); gen_manage_domain_search_options($tpl, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); } else { gen_manage_domain_query($search_query, $count_query, $admin_id, $start_index, $rows_per_page, 'n/a', 'n/a', 'n/a'); gen_manage_domain_search_options($tpl, 'n/a', 'n/a', 'n/a'); } $rs = execute_query($sql, $count_query); $records_count = $rs->fields['cnt']; $rs = execute_query($sql, $search_query); if ($records_count == 0) { if (isset($_SESSION['search_for'])) { $tpl->assign(array('USERS_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('view aliases'), 'SHOW_DETAILS' => "show")); set_page_message(tr('Not found user records matching the search criteria!')); unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } else { $tpl->assign(array('USERS_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('view aliases'), 'SHOW_DETAILS' => "show")); set_page_message(tr('You have no users.')); } } else { $prev_si = $start_index - $rows_per_page; if ($start_index == 0) { $tpl->assign('SCROLL_PREV', ''); } else { $tpl->assign(array('SCROLL_PREV_GRAY' => '', 'PREV_PSI' => $prev_si)); } $next_si = $start_index + $rows_per_page; if ($next_si + 1 > $records_count) { $tpl->assign('SCROLL_NEXT', ''); } else { $tpl->assign(array('SCROLL_NEXT_GRAY' => '', 'NEXT_PSI' => $next_si)); } $i = 1; while (!$rs->EOF) { if ($rs->fields['domain_status'] == $cfg['ITEM_OK_STATUS']) { $status_icon = "ok.gif"; } else { if ($rs->fields['domain_status'] == $cfg['ITEM_DISABLED_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_DELETE_STATUS']) { $status_icon = "disabled.gif"; } else { if ($rs->fields['domain_status'] == $cfg['ITEM_ADD_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_CHANGE_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_TOENABLE_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_RESTORE_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_TODISABLED_STATUS']) { $status_icon = "reload.gif"; } else { $status_icon = "error.gif"; } } } $status_url = $rs->fields['domain_id']; $tpl->assign(array('STATUS_ICON' => $status_icon, 'URL_CHNAGE_STATUS' => $status_url)); $admin_name = decode_idna($rs->fields['domain_name']); if ($i % 2 == 0) { $tpl->assign(array('CLASS_TYPE_ROW' => 'content')); } else { $tpl->assign(array('CLASS_TYPE_ROW' => 'content2')); } $dom_created = $rs->fields['domain_created']; if ($dom_created == 0) { $dom_created = tr('N/A'); } else { $date_formt = $cfg['DATE_FORMAT']; $dom_created = date($date_formt, $dom_created); } $tpl->assign(array('CREATION_DATE' => $dom_created, 'DOMAIN_ID' => $rs->fields['domain_id'], 'NAME' => $admin_name, 'ACTION' => tr('Delete'), 'USER_ID' => $rs->fields['domain_admin_id'], 'CHANGE_INTERFACE' => tr('Change'))); gen_domain_details($tpl, $sql, $rs->fields['domain_id']); $tpl->parse('USER_ENTRY', '.user_entry'); $i++; $rs->MoveNext(); } $tpl->parse('USER_LIST', 'users_list'); } }