/**
* @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');
}
}
