Viewing file:  export.php (10.58 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/*
* GoSMTP Export Logs
* https://gosmtp.net
* (c) Softaculous Team
*/
if(!defined('ABSPATH')){
die('Hacking Attempt!');
}
// Filter HTML data
function gosmtp_filterData(&$str){
$str = preg_replace("/\t/", "\\t", $str);
$str = preg_replace("/\r?\n/", "\\n", $str);
if(strstr($str, '"')){
$str = '"' . str_replace('"', '""', $str) . '"';
}
}
// Export CSV files
function gosmtp_export_csv($data){
$fileName = "gosmtp_export_".date('Y_m_d') . ".csv";
header('Content-Type: text/csv; charset=utf-8');
header("Content-Disposition: attachment; filename=$fileName");
header("Content-Description: File Transfer");
$file = fopen('php://output', 'w');
// We have all the field sequences in the first line
// Get the key of attachments form the sequences
$attachment_key = array_search('attachments', $data[0], true);
foreach($data as $kk => $val){
// Skip attachment explode for first row
if( $kk != 0 && $attachment_key !== false && !empty($val[$attachment_key]) ){
$attachment = explode(',', $val[$attachment_key]);
$attach = '';
foreach($attachment as $attach_val){
$attach .= explode('*', $attach_val)[2].', ';
}
$val[$attachment_key] = rtrim($attach, ', ');
}
fputcsv($file, array_values($val));
}
fclose($file);
wp_die();
}
// Export XML files
function gosmtp_export_xls($data){
$filename = "gosmtp_export_".date('Ymd') . ".xls";
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"$filename\"");
// We have all the field sequences in the first line
// Get the key of attachments form the sequences
$attachment_key = array_search('attachments', $data[0], true);
foreach($data as $kk => $val) {
array_walk($val, 'gosmtp_filterData');
// Skip attachment explode for first row
if( $kk != 0 && $attachment_key !== false && !empty($val[$attachment_key]) ){
$attachment = explode(',', $val[$attachment_key]);
$attach ="";
foreach($attachment as $attach_val){
$attach .= explode('*', $attach_val)[2].', ';
}
$val[$attachment_key] = rtrim($attach, ", ");
}
echo esc_html(implode("\t", array_values($val)) . "\n");
}
wp_die();
}
// Export EML files
function gosmtp_export_eml($data){
$files = array();
$first_row = $data[0];
// Replace key with value
$fields = array_flip($data[0]);
$attachment_key = $fields['attachments'];
foreach($data as $key => $value){
// Skip for first row
if($key == 0){
continue;
}
$files[$key] = "gosmtp_export_".$key."_".date('Ymd') . ".eml";
header("Content-Type: application/application/eml");
header("Content-Disposition: attachment; filename=\"$files[$key]\"");
$output_buffer = fopen('php://output', 'w');
$boundary = md5(uniqid(mt_rand()));
$output_buffer =
'MIME-Version: 1.0
Date: '.date_format( date_create( $value[$fields['created_at']] ), 'd-m-y H:i:s').' +0100
From: '.$value[$fields['from']].'
To: '.$value[$fields['to']].'
Cc: '.$value[$fields['cc']].'
Ccc: '.$value[$fields['bcc']].'
Subject: '.$value[$fields['subject']].'
Content-Type: multipart/mixed; boundary="'.$boundary.'"
This is a message with multiple parts in MIME format.
--'.$boundary.'
Content-Type: '.$value[$fields['content-type']].'
'.$value[$fields['body']];
// Added attachment if any
if(isset($value[$attachment_key]) && !empty($value[$attachment_key])){
$attachment = explode(',', $value[$attachment_key]);
foreach($attachment as $attach){
$all_attach = explode('*', $attach);
$attachment_file = file_get_contents(trim($all_attach[0]));
if(empty($attachment_file)){
continue;
}
$encoded_attach = base64_encode($attachment_file);
$type = $all_attach[4];
$base_name = $all_attach[2];
$output_buffer .=
'
--'.$boundary.'
Content-Type: '.$type.';name="'.$base_name.'"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;filename="'.$base_name.'"
'.$encoded_attach;
}
}
file_put_contents($files[$key], $output_buffer);
}
$zipname = "gosmtp_export_".date('Ymd') . ".zip";
$zip = new ZipArchive;
$zip->open($zipname, ZipArchive::CREATE);
foreach($files as $file){
$zip->addFile($file);
}
$zip->close();
header('Content-Type: application/zip');
header('Content-disposition: attachment; filename='.$zipname);
header('Content-Length: ' . filesize($zipname));
readfile($zipname);
unlink($zipname);
wp_die();
}
// Export page HTML
function gosmtp_export_page(){
// Styles and Scripts
wp_enqueue_style( 'gosmtp-admin' );
wp_enqueue_script( 'gosmtp-admin' );
$common_field = array(
'to' => __('To Address'),
'from' => __('From Address'),
'subject' => __('Subject'),
'body' => __('Body'),
'created_at' => __('Created At'),
'attachments' => __('Attachments'),
);
$addtition_field = array(
'status' => __('Status'),
'reply-to' => __('Reply To'),
'cc' => __('Carbon Copy (CC)'),
'bcc' => __('Blind Carbon Copy (BCC)'),
'provider' => __('Provider'),
'response' => __('Response'),
'source' => __('Source'),
'content-type' => __('Content Type')
);
$search_field = array(
'from' => __('from'),
'to' => __('To'),
'subject' => __('Subject'),
'body' => __('Body'),
);
$all_field = array_merge(array_keys($common_field), array_keys($addtition_field));
?>
<div class="gosmtp-row gosmtp-export-container">
<form action="" method="post" id="gosmtp_export">
<input type="hidden" name="page" value="export">
<input type="hidden" name="all_field" value="<?php echo implode(',', $all_field)?>">
<div class="gosmtp-row">
<div class="gosmtp-col-12">
<h1> <span class="dashicons dashicons-media-archive"></span><?php _e('Export Settings'); ?></h1>
</div>
</div>
<hr>
<div class="gosmtp-row">
<div class="gosmtp-col-3">
<h3><?php _e('Format'); ?></h3>
</div>
<div class="gosmtp-col-6">
<div class="gosmtp-radio-list">
<input type="radio" name="format" value="csv" id="csv" checked> <label for="csv" class="active_radio_tab"><?php echo __('CSV').'(.csv)'; ?></label>
<input type="radio" name="format" value="xls" id ="xls"> <label for="xls"><?php echo __('Microsoft Excel').'(.xls)'; ?></label>
<input type="radio" name="format" value="eml" id="eml"> <label for="eml"><?php echo __('EML').'(.eml)'; ?> </label>
</div>
</div>
</div>
<div class="gosmtp-row ">
<div class="gosmtp-col-3">
<h3><?php _e('Export Custom Field'); ?></h3>
</div>
<div class="gosmtp-col-9">
<label class="gosmtp-switch">
<input type="checkbox" name="custom-field" id="custom-field" checked>
<span class="gosmtp-slider gosmtp-round"></span>
</label>
</div>
</div>
<div class="gosmtp-row can-hidden">
<div class="gosmtp-col-3">
<h3><?php _e('Common Information'); ?></h3>
</div>
<div class="gosmtp-col-6">
<div class="gosmtp-fiter-container">
<span class="multiselect"><?php _e('Select common field'); ?></span>
<ul class="multiselect-options">
<li><input type="checkbox" class="multiselect-checkbox" id="all" value="all" checked><label for="all"><?php _e('All'); ?></label></li>
<?php
foreach($common_field as $key => $val){
echo"<li><input type='checkbox' checked class='multiselect-checkbox' name ='common_information[]' id='$key' value='$key'><label for='$key'>$val</label></li>";
}
?>
</ul>
<span class="dropdown dashicons dashicons-arrow-down-alt2"></span>
</div>
</div>
</div>
<div class="gosmtp-row can-hidden">
<div class="gosmtp-col-3">
<h3><?php _e('Additional Information'); ?></h3>
</div>
<div class="gosmtp-col-6">
<div class="gosmtp-fiter-container">
<span class="multiselect"><?php _e('Select common field'); ?></span>
<ul class="multiselect-options">
<li><input type="checkbox" class="multiselect-checkbox" id="all" value="all"><label for="all"><?php _e('All'); ?></label></li>
<?php
foreach($addtition_field as $key => $val){
echo "<li><input type='checkbox' name='addtional_information[]' class='multiselect-checkbox' id='$key' value='$key'><label for='$key' checked>$val</label></li>";
}
?>
</ul>
<span class="dropdown dashicons dashicons-arrow-down-alt2"></span>
</div>
</div>
</div>
<div class="gosmtp-row ">
<div class="gosmtp-col-3">
<h3><?php _e('Custom Date Range'); ?></h3>
</div>
<div class="gosmtp-col-6">
<div class="gosmtp-date-container">
<input type="date" name="start-date" id="gosmtp-start-date" placeholder="Start date" />
<input type="date" name="end-date" id="gosmtp-end-date" placeholder="End date" />
</div>
</div>
</div>
<div class="gosmtp-row ">
<div class="gosmtp-col-3">
<h3><?php _e('Search In'); ?></h3>
</div>
<div class="gosmtp-col-6">
<div class="gosmtp-inner-row ">
<div class="gosmtp-col-8">
<div class="gosmtp-fiter-container ">
<span class="multiselect"><?php _e('Select addtitional field'); ?></span>
<ul class="multiselect-options">
<li><input type="checkbox" class="multiselect-checkbox" id="all" value="all" ><label for="all"><?php _e('All'); ?></label></li>
<?php
foreach($search_field as $key => $val){
echo "<li><input type='checkbox' name='search_type[]' class='multiselect-checkbox' id='$key' value='$key'><label for='$key'>$val</label></li>";
}
?>
</ul>
<span class="dropdown dashicons dashicons-arrow-down-alt2"></span>
</div>
</div>
<div class="gosmtp-col-4">
<div class="gosmtp-search-report-list-icon">
<span class="dashicons dashicons-search"></span>
<input type="search" id="gosmtp-search_email" placeholder="Search" name="search">
</div>
</div>
</div>
</div>
</div>
<div class="gosmtp-row ">
<div class="gosmtp-col-3">
<button class="button button-primary gosmtp-loading-button">
<span class="dashicons dashicons-image-rotate"></span>
<input type="submit" name="export" value="Export" >
</button>
</div>
</div>
</form>
</div>
<script>
var gosmtp_ajaxurl="<?php echo admin_url( 'admin-ajax.php' ) ?>?";
var gosmtp_ajax_nonce="<?php echo wp_create_nonce('gosmtp_ajax') ?>";
</script>
<?php
}
|