messagesPending.php

<?php
/**
 * Display pending requests for logged in users.
 *
 * @author Gergely Nagy <gna@r-us.hu>
 * @version 2021-11-08
 * @package mailzu-ng
 *
 * Copyright (C) 2021 mailzu-ng
 * License: GPL, see LICENSE
 */

/**
 * Include autoloader
 */
include_once('lib/autoload.php');
/**
 * Include common output functions
 */
include_once('templates/common.template.php');
/**
 * Include quarantine-specific output functions
 */
include_once('templates/quarantine.template.php');

if (!Auth::is_logged_in()) {
    (new Auth())->print_login_msg();    // Check if user is logged in
}

// grab the display size limit set in config.php
$sizeLimit = isset ($conf['app']['displaySizeLimit']) && is_numeric($conf['app']['displaySizeLimit']) ?
    $conf['app']['displaySizeLimit'] : 50;

//Get content type
$content_type = (CmnFns::get_ctype() ?: 'A');

$order = array('msgs.time_num', 'from_addr', 'msgs.subject', 'spam_level', 'recip.email', 'msgs.content', 'mail_id');
// Get current page number
$requestedPage = CmnFns::getGlobalVar('page', GET);

$_SESSION['sessionNav'] = "My Pending Requests";
$t = new Template(translate('My Pending Requests'));

$db = new DBEngine();

$t->printHTMLHeader();
$t->printWelcome();
$t->startMain();

// Break table into 2 columns, put quick links on left side and all other tables on the right
startQuickLinksCol();
showQuickLinks();        // Print out My Quick Links
startDataDisplayCol();

// Draw search engine
printSearchEngine($content_type, $_SERVER['PHP_SELF'], (count($_SESSION['sessionMail']) > 1));
echo '<br>';

if (CmnFns::getGlobalVar('search_action', GET) == translate('Clear search results')) CmnFns::redirect_js($_SERVER['PHP_SELF']);

$search_array1 = $db->convertSearch2SQL('msgs.from_addr', CmnFns::getGlobalVar('f_criterion', GET), CmnFns::getGlobalVar('f_string', GET));
$search_array2 = $db->convertSearch2SQL('msgs.subject', CmnFns::getGlobalVar('s_criterion', GET), CmnFns::getGlobalVar('s_string', GET));
$search_array3 = $db->convertSearch2SQL('recip.email', CmnFns::getGlobalVar('t_criterion', GET), CmnFns::getGlobalVar('t_string', GET));
$search_array4 = $db->convertSearch2SQL('msgs.mail_id', CmnFns::getGlobalVar('m_criterion', GET), CmnFns::getGlobalVar('m_string', GET));
$search_array = array_merge($search_array1, $search_array2, $search_array3, $search_array4);

// Print a loading message until database returns...
printMessage(translate('Retrieving Messages...'));

$messages = $db->get_user_messages($content_type, $_SESSION['sessionMail'], CmnFns::get_value_order($order), CmnFns::get_vert_order(), $search_array, false, 1, $requestedPage);

// Compute maximum number of pages
$maxPage = (ceil($db->numRows / $sizeLimit) - 1);

// If $requestedPage > $maxPage, then redirect to $maxPage instead of $requestedPage
if ($requestedPage > $maxPage) {
    $query_string = CmnFns::array_to_query_string($_GET, array('page'));
    $query_string = str_replace('&amp;', '&', $query_string);
    CmnFns::redirect_js($_SERVER['PHP_SELF'] . '?' . $query_string . '&page=' . $maxPage);
}

showMessagesTable($content_type, $messages, $requestedPage, CmnFns::get_value_order($order), CmnFns::get_vert_order());

// Hide the message after the table loads.
hideMessage(translate('Retrieving Messages...'));

endDataDisplayCol();
$t->endMain();
$t->printHTMLFooter();
?>