/** * @param EasySCP_TemplateEngine $tpl * @param EasySCP_Database $sql */ function gen_user_list($tpl, $sql) { $cfg = EasySCP_Registry::get('Config'); $start_index = 0; $rows_per_page = $cfg->DOMAIN_ROWS_PER_PAGE; if (isset($_GET['psi'])) { $start_index = $_GET['psi']; } // Search request generated ?! if (isset($_POST['uaction']) && !empty($_POST['uaction'])) { $_SESSION['search_for'] = trim(clean_input($_POST['search_for'])); $_SESSION['search_common'] = $_POST['search_common']; $_SESSION['search_status'] = $_POST['search_status']; $start_index = 0; } elseif (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_admin_domain_query($search_query, $count_query, $start_index, $rows_per_page, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); gen_admin_domain_search_options($tpl, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); $rs = exec_query($sql, $count_query); } else { gen_admin_domain_query($search_query, $count_query, $start_index, $rows_per_page, 'n/a', 'n/a', 'n/a'); gen_admin_domain_search_options($tpl, 'n/a', 'n/a', 'n/a'); $rs = exec_query($sql, $count_query); } $records_count = $rs->fields['cnt']; $rs = execute_query($sql, $search_query); if ($rs->recordCount() == 0) { if (isset($_SESSION['search_for'])) { $tpl->assign(array('USR_MESSAGE' => tr('Not found user records matching the search criteria!'), 'USR_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('view aliases'), 'SHOW_DETAILS' => 'show')); unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } else { $tpl->assign(array('USR_MESSAGE' => tr('Users list is empty!'), 'USR_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('view aliases'), 'SHOW_DETAILS' => 'show')); } } 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)); } $tpl->assign(array('TR_USR_USERNAME' => tr('Username'), 'TR_USR_CREATED_BY' => tr('Created by'), 'TR_USR_OPTIONS' => tr('Options'), 'TR_USER_STATUS' => tr('Status'), 'TR_DETAILS' => tr('Details'), 'TR_EDIT_DOMAIN' => tr('Edit domain'), 'TR_EDIT_USR' => tr('Edit user'))); while (!$rs->EOF) { // user status icon $domain_created_id = $rs->fields['domain_created_id']; $query = "\n\t\t\t\tSELECT\n\t\t\t\t\t`admin_name`\n\t\t\t\tFROM\n\t\t\t\t\t`admin`\n\t\t\t\tWHERE\n\t\t\t\t\t`admin_id` = ?\n\t\t\t\tORDER BY\n\t\t\t\t\t`admin_name`\n\t\t\t\tASC\n\t\t\t\t;\n\t\t\t"; $rs2 = exec_query($sql, $query, $domain_created_id); if (!isset($rs2->fields['admin_name'])) { $created_by_name = tr('N/A'); } else { $created_by_name = $rs2->fields['admin_name']; } // Get disk usage by user $tpl->append(array('USR_DELETE_SHOW' => '', 'DOMAIN_ID' => $rs->fields['domain_id'], 'URL_DELETE_USR' => 'user_delete.php?domain_id=' . $rs->fields['domain_id'], 'URL_CHANGE_INTERFACE' => 'change_user_interface.php?to_id=' . $rs->fields['domain_admin_id'])); if ($rs->fields['status'] == $cfg->ITEM_OK_STATUS) { $status_icon = 'ok'; $status_url = 'domain_status_change.php?domain_id=' . $rs->fields['domain_id']; } elseif ($rs->fields['status'] == $cfg->ITEM_DISABLED_STATUS) { $status_icon = 'disabled'; $status_url = 'domain_status_change.php?domain_id=' . $rs->fields['domain_id']; } elseif ($rs->fields['status'] == $cfg->ITEM_ADD_STATUS || $rs->fields['status'] == $cfg->ITEM_RESTORE_STATUS || $rs->fields['status'] == $cfg->ITEM_CHANGE_STATUS || $rs->fields['status'] == $cfg->ITEM_TOENABLE_STATUS || $rs->fields['status'] == $cfg->ITEM_TODISABLED_STATUS || $rs->fields['status'] == $cfg->ITEM_DELETE_STATUS) { $status_icon = 'reload'; $status_url = '#'; } else { $status_icon = 'error'; $status_url = 'domain_details.php?domain_id=' . $rs->fields['domain_id']; } $tpl->append(array('STATUS_ICON' => $status_icon, 'URL_CHANGE_STATUS' => $status_url)); // end of user status icon $admin_name = decode_idna($rs->fields['domain_name']); $domain_created = $rs->fields['domain_created']; if ($domain_created == 0) { $domain_created = tr('N/A'); } else { $date_formt = $cfg->DATE_FORMAT; $domain_created = date($date_formt, $domain_created); } $domain_expires = $rs->fields['domain_expires']; if ($domain_expires == 0) { $domain_expires = tr('Not Set'); } else { $date_formt = $cfg->DATE_FORMAT; $domain_expires = date($date_formt, $domain_expires); } $tpl->append(array('USR_USERNAME' => tohtml($admin_name), 'USER_CREATED_ON' => tohtml($domain_created), 'USER_EXPIRES_ON' => $domain_expires, 'USR_CREATED_BY' => tohtml($created_by_name), 'USR_OPTIONS' => '', 'URL_EDIT_USR' => 'admin_edit.php?edit_id=' . $rs->fields['domain_admin_id'])); gen_domain_details($tpl, $sql, $rs->fields['domain_id']); $rs->moveNext(); } } }
function gen_user_list(&$tpl, &$sql) { global $cfg; $start_index = 0; $rows_per_page = $cfg['DOMAIN_ROWS_PER_PAGE']; 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_admin_domain_query($search_query, $count_query, $start_index, $rows_per_page, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); gen_admin_domain_search_options($tpl, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); $rs = exec_query($sql, $count_query, array()); } else { gen_admin_domain_query($search_query, $count_query, $start_index, $rows_per_page, 'n/a', 'n/a', 'n/a'); gen_admin_domain_search_options($tpl, 'n/a', 'n/a', 'n/a'); $rs = exec_query($sql, $count_query, array()); } $records_count = $rs->fields['cnt']; // print "records count: ".$records_count."<br>"; $rs = execute_query($sql, $search_query); $i = 0; if ($rs->RecordCount() == 0) { if (isset($_SESSION['search_for'])) { $tpl->assign(array('USR_MESSAGE' => tr('Not found user records matching the search criteria!'), 'USR_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('view aliases'), 'SHOW_DETAILS' => "show")); unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } else { $tpl->assign(array('USR_MESSAGE' => tr('Users list is empty!'), 'USR_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('view aliases'), 'SHOW_DETAILS' => "show")); } $tpl->parse('USR_MESSAGE', 'usr_message'); } 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)); } $tpl->assign(array('TR_USR_USERNAME' => tr('Username'), 'TR_USR_CREATED_BY' => tr('Created by'), 'TR_USR_OPTIONS' => tr('Options'), 'TR_USER_STATUS' => tr('S'), 'TR_D' => tr('D'), 'TR_DETAILS' => tr('Details'))); while (!$rs->EOF) { if ($i % 2 == 0) { $tpl->assign(array('USR_CLASS' => 'content')); } else { $tpl->assign(array('USR_CLASS' => 'content2')); } // user status icon $domain_created_id = $rs->fields['domain_created_id']; $query = <<<SQL_QUERY select admin_id, admin_name from admin where admin_id=? \t\torder by \t\t\tadmin_name \t\tasc SQL_QUERY; $rs2 = exec_query($sql, $query, array($domain_created_id)); if ($rs2->fields['admin_name'] == '') { $tpl->assign(array('TR_DELETE' => tr('Delete'), 'USR_DELETE_LINK' => '')); $tpl->parse('USR_DELETE_SHOW', 'usr_delete_show'); } else { $tpl->assign(array('USR_DELETE_SHOW' => '', 'DOMAIN_ID' => $rs->fields['domain_id'], 'TR_DELETE' => tr('Delete'), 'URL_DELETE_USR' => "delete_user.php?delete_id=" . $rs->fields['domain_admin_id'] . "&delete_username="******"change_user_interface.php?to_id=" . $rs->fields['domain_admin_id'])); $tpl->parse('USR_DELETE_LINK', 'usr_delete_link'); } global $cfg; if ($rs->fields['domain_status'] == $cfg['ITEM_OK_STATUS']) { $status_icon = "ok.gif"; $status_url = "change_status.php?domain_id=" . $rs->fields['domain_id']; } else { if ($rs->fields['domain_status'] == $cfg['ITEM_DISABLED_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_DELETE_STATUS']) { $status_icon = "disabled.gif"; $status_url = "change_status.php?domain_id=" . $rs->fields['domain_id']; } else { if ($rs->fields['domain_status'] == $cfg['ITEM_ADD_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_RESTORE_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_CHANGE_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_TOENABLE_STATUS'] || $rs->fields['domain_status'] == $cfg['ITEM_TODISABLED_STATUS']) { $status_icon = "reload.gif"; $status_url = "#"; } else { $status_icon = "error.gif"; $status_url = "domain_details.php?domain_id=" . $rs->fields['domain_id']; } } } $tpl->assign(array('STATUS_ICON' => $status_icon, 'URL_CHNAGE_STATUS' => $status_url)); // end of user status icon $admin_name = decode_idna($rs->fields['domain_name']); $domain_created = $rs->fields['domain_created']; if ($domain_created == 0) { $domain_created = tr('N/A'); } else { global $cfg; $date_formt = $cfg['DATE_FORMAT']; $domain_created = date($date_formt, $domain_created); } $tpl->assign(array('USR_USERNAME' => $admin_name, 'USER_CREATED_ON' => $domain_created, 'USR_CREATED_BY' => $rs2->fields['admin_name'], 'USR_OPTIONS' => '', 'URL_EDIT_USR' => "edit_user.php?edit_id=" . $rs->fields['domain_admin_id'], 'TR_MESSAGE_CHANGE_STATUS' => tr('Are you sure you want to change the status of domain account?'), 'TR_MESSAGE_DELETE' => tr('Are you sure you want to delete this account?'))); gen_domain_details($tpl, $sql, $rs->fields['domain_id']); $tpl->parse('USR_ITEM', '.usr_item'); $rs->MoveNext(); $i++; } $tpl->parse('USR_LIST', 'usr_list'); $tpl->assign('USR_MESSAGE', ''); } }
/** * 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'); } }
/** * Helper function to generate a user list * * @param iMSCP_pTemplate $tpl iMSCP_pTemplate instance * @return void */ function gen_user_list($tpl) { /** @var $cfg iMSCP_Config_Handler_File */ $cfg = iMSCP_Registry::get('config'); $startIndex = 0; $rowsPerPage = $cfg['DOMAIN_ROWS_PER_PAGE']; if (isset($_GET['psi']) && $_GET['psi'] == 'last') { if (isset($_SESSION['search_page'])) { $_GET['psi'] = $_SESSION['search_page']; } else { unset($_GET['psi']); } } if (isset($_GET['psi'])) { $startIndex = $_GET['psi']; } // Search request generated ? if (isset($_POST['uaction']) && !empty($_POST['uaction'])) { $_SESSION['search_for'] = clean_input($_POST['search_for']); $_SESSION['search_common'] = $_POST['search_common']; $_SESSION['search_status'] = $_POST['search_status']; $startIndex = 0; } elseif (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']); } $searchQuery = $countQuery = ''; if (isset($_SESSION['search_for'])) { gen_admin_domain_query($searchQuery, $countQuery, $startIndex, $rowsPerPage, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); gen_admin_domain_search_options($tpl, $_SESSION['search_for'], $_SESSION['search_common'], $_SESSION['search_status']); $stmt = exec_query($countQuery); } else { gen_admin_domain_query($searchQuery, $countQuery, $startIndex, $rowsPerPage, 'n/a', 'n/a', 'n/a'); gen_admin_domain_search_options($tpl, 'n/a', 'n/a', 'n/a'); $stmt = exec_query($countQuery); } $recordCount = $stmt->fields['cnt']; $stmt = execute_query($searchQuery); if (!$stmt->rowCount()) { if (isset($_SESSION['search_for'])) { $tpl->assign(array('USR_MESSAGE' => tr('No records found matching the search criteria.'), 'USR_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('view aliases'), 'SHOW_DETAILS' => 'show')); unset($_SESSION['search_for']); unset($_SESSION['search_common']); unset($_SESSION['search_status']); } else { $tpl->assign(array('SEARCH_FORM' => '', 'USR_MESSAGE' => tr('No customer accounts found.'), 'USR_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_NEXT' => '', 'TR_VIEW_DETAILS' => tr('view aliases'), 'SHOW_DETAILS' => '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 > $recordCount) { $tpl->assign('SCROLL_NEXT', ''); } else { $tpl->assign(array('SCROLL_NEXT_GRAY' => '', 'NEXT_PSI' => $nextSi)); } $tpl->assign(array('TR_USR_USERNAME' => tr('Username'), 'TR_USR_CREATED_BY' => tr('Created by'), 'TR_USR_ACTIONS' => tr('Actions'), 'TR_USER_STATUS' => tr('Status'), 'TR_DETAILS' => tr('Details'))); while ($row = $stmt->fetchRow(PDO::FETCH_ASSOC)) { // user status icon $domainCreatedBy = $row['created_by']; $stmt2 = exec_query('SELECT admin_name, admin_status FROM admin WHERE admin_id = ?', $domainCreatedBy); if (!isset($stmt2->fields['admin_name'])) { $createdByName = tr('N/A'); } else { $createdByName = $stmt2->fields['admin_name']; } $tpl->assign(array('USR_DELETE_SHOW' => '', 'USER_ID' => $row['admin_id'], 'DOMAIN_ID' => $row['domain_id'], 'TR_DELETE' => tr('Delete'), 'URL_DELETE_USR' => 'user_delete.php?domain_id=' . $row['domain_id'], 'TR_CHANGE_USER_INTERFACE' => tr('Switch to user interface'), 'GO_TO_USER_INTERFACE' => tr('Switch'), 'URL_CHANGE_INTERFACE' => 'change_user_interface.php?to_id=' . $row['domain_admin_id'], 'USR_USERNAME' => tohtml($row['domain_name']), 'TR_EDIT_DOMAIN' => tr('Edit domain'), 'TR_EDIT_USR' => tr('Edit user'))); $tpl->parse('USR_DELETE_LINK', 'usr_delete_link'); if ($row['admin_status'] == 'ok' && $row['domain_status'] == 'ok') { $status = 'ok'; $statusTooltip = tr('Click to deactivate'); $statusTxt = translate_dmn_status($row['domain_status']); $statusBool = true; $canChange = true; } elseif ($row['domain_status'] == 'disabled') { $status = 'disabled'; $statusTooltip = tr('Click to activate'); $statusTxt = translate_dmn_status($row['domain_status']); $statusBool = false; $canChange = true; } elseif ($row['domain_status'] == 'toadd' || $row['domain_status'] == 'torestore' || $row['domain_status'] == 'tochange' || $row['domain_status'] == 'toenable' || $row['domain_status'] == 'todisable' || $row['domain_status'] == 'todelete') { $status = 'reload'; $statusTxt = $statusTooltip = translate_dmn_status($row['admin_status'] != 'ok' ? $row['admin_status'] : $row['domain_status']); $statusBool = false; $canChange = false; } else { $status = 'error'; $statusTooltip = tr('An unexpected error occurred. Go to the debugger interface for more details.'); $statusTxt = translate_dmn_status($row['admin_status'] != 'ok' ? $row['admin_status'] : $row['domain_status']); $statusBool = false; $canChange = false; } $tpl->assign(array('STATUS' => $status, 'STATUS_TOOLTIP' => $statusTooltip, 'TR_STATUS' => $statusTxt)); 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']); $domainCreated = $row['domain_created']; if ($domainCreated == 0) { $domainCreated = tr('N/A'); } else { $date_formt = $cfg['DATE_FORMAT']; $domainCreated = date($date_formt, $domainCreated); } $domainExpires = $row['domain_expires']; if ($domainExpires == 0) { $domainExpires = tr('Not Set'); } else { $date_formt = $cfg['DATE_FORMAT']; $domainExpires = date($date_formt, $domainExpires); } if ($statusBool == false) { // reload $tpl->assign('USR_STATUS_RELOAD_TRUE', ''); $tpl->assign('USR_USERNAME', tohtml($adminName)); $tpl->parse('USR_STATUS_RELOAD_FALSE', 'usr_status_reload_false'); } else { $tpl->assign('USR_STATUS_RELOAD_FALSE', ''); $tpl->assign('USR_USERNAME', tohtml($adminName)); $tpl->parse('USR_STATUS_RELOAD_TRUE', 'usr_status_reload_true'); } $tpl->assign(array('USER_CREATED_ON' => tohtml($domainCreated), 'USER_EXPIRES_ON' => $domainExpires, 'USR_CREATED_BY' => tohtml($createdByName), 'USR_OPTIONS' => '', 'URL_EDIT_USR' => 'admin_edit.php?edit_id=' . $row['domain_admin_id'], 'TR_MESSAGE_DELETE' => tojs(tr('Are you sure you want to delete %s?', '%s')))); gen_domain_details($tpl, $row['domain_id']); $tpl->parse('USR_ITEM', '.usr_item'); } $tpl->parse('USR_LIST', 'usr_list'); $tpl->assign('USR_MESSAGE', ''); } }
/** * @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(); } } }
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'); } }