Portions created by the Initial Developer are Copyright (C) 2023-2024 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ //includes files require_once dirname(__DIR__, 2) . "/resources/require.php"; require_once "resources/check_auth.php"; //require_once "resources/paging.php"; //check permissions if (permission_exists('message_view')) { //access granted } else { echo "access denied"; exit; } //add multi-lingual support $language = new text; $text = $language->get(); //retrieve submitted data if (!empty($_REQUEST)) { $quick_select = $_REQUEST['quick_select']; $message_date_begin = $_REQUEST['message_date_begin']; $message_date_end = $_REQUEST['message_date_end']; } else { $quick_select = 3; //set default } //get the summary $message = new messages; if (!empty($quick_select)) { $message->quick_select = $quick_select; } else { $message->message_date_begin = $message_date_begin ?? ''; $message->message_date_end = $message_date_end ?? ''; } $summary = $message->message_summary(); // view_array($summary); exit; //set the http header if (!empty($_REQUEST['type']) && $_REQUEST['type'] == "csv") { //set the headers header('Content-type: application/octet-binary'); header('Content-Disposition: attachment; filename=message-summary.csv'); //show the column names on the first line $z = 0; if (!empty($summary) && is_array($summary)) { foreach ($summary[0] as $key => $val) { if ($z == 0) { echo '"'.$key.'"'; } else { echo ',"'.$key.'"'; } $z++; } echo "\n"; } //add the values to the csv $x = 0; if (!empty($summary) && is_array($summary)) { foreach ($summary as $users) { $z = 0; foreach ($users as $key => $val) { if ($z == 0) { echo '"'.$summary[$x][$key].'"'; } else { echo ',"'.$summary[$x][$key].'"'; } $z++; } echo "\n"; $x++; } } exit; } //include the header $document['title'] = $text['title-message_summary']; require_once "resources/header.php"; //css grid adjustment echo "\n"; //show the content echo "

\n"; echo "

".$text['title-message_summary']."

\n"; echo "

\n"; if (permission_exists('message_summary_all') && $_GET['show'] != 'all') { echo button::create(['type'=>'button','label'=>$text['button-show_all'],'icon'=>$_SESSION['theme']['button_icon_all'],'collapse'=>'hide-sm-dn','link'=>'message_summary.php?show=all']); } echo button::create(['type'=>'button','label'=>$text['button-download_csv'],'icon'=>$_SESSION['theme']['button_icon_download'],'collapse'=>'hide-sm-dn','link'=>'message_summary.php?'.(!empty($_SERVER["QUERY_STRING"]) ? $_SERVER["QUERY_STRING"].'&' : null).'type=csv']); echo button::create(['type'=>'button','label'=>$text['button-reset'],'icon'=>$_SESSION['theme']['button_icon_reset'],'collapse'=>'hide-xs','style'=>'margin-left: 15px;','link'=>'message_summary.php']); echo button::create(['type'=>'button','label'=>$text['button-update'],'icon'=>$_SESSION['theme']['button_icon_save'],'id'=>'btn_save','collapse'=>'hide-xs','onclick'=>"document.getElementById('frm').submit();"]); echo "

\n"; echo "

\n"; echo "

\n"; if (permission_exists('message_search')) { echo "

\n"; echo "

\n"; echo "

\n"; echo "

\n"; echo "

\n"; echo " ".$text['label-preset']."\n"; echo "

\n"; echo "

\n"; echo " \n"; echo "

\n"; echo "

\n"; echo "

\n"; echo "

\n"; echo " ".$text['label-start_date_time']."\n"; echo "

\n"; echo "

\n"; echo " \n"; echo "

\n"; echo "

\n"; echo "

\n"; echo "

\n"; echo " ".$text['label-end_date_time']."\n"; echo "

\n"; echo "

\n"; echo " \n"; echo "

\n"; echo "

\n"; echo "

\n"; echo "

\n"; if (!empty($_GET['show']) && $_GET['show'] == 'all' && permission_exists('message_summary_all')) { echo ""; } echo "

"; } //show the results echo "

\n"; echo "\n"; echo " \n"; if (!empty($_GET['show']) && $_GET['show'] === "all" && permission_exists('message_summary_all')) { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (!empty($summary) && is_array($summary)) { foreach ($summary as $key => $row) { echo "\n"; if (!empty($_GET['show']) && $_GET['show'] === "all" && permission_exists('message_summary_all')) { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; } } echo "

".$text['label-domain']."	".$text['label-message_destination']."	".$text['label-message_read']."	".$text['label-message_unread']."	".$text['label-message_received']."	".$text['label-message_sent']."	".$text['label-message_description']."
".escape($row['domain_name'])."	".escape($row['destination'])."	".escape($row['message_read'])."	".escape($row['message_unread'])."	".escape($row['message_received'])."	".escape($row['message_sent'])."	".escape($row['destination_description'])."

\n"; echo "

\n"; echo "
\n"; //show the footer require_once "resources/footer.php"; ?>