function _admin_view_mail_log_row_data($key = '', $data = '')
{
if (!empty($key)) {
$value = $data[$key];
if ($key == 'created') {
return date('d-m-Y', strtotime($value));
} elseif ($key == 'mail_sent_on') {
return date('H:i:s d-m-Y', strtotime($value));
} elseif ($key == 'user_read_on') {
if (is_null($value) || $value == '0000-00-00 00:00:00') {
return 'N/A';
}
return date('H:i:s d-m-Y', strtotime($value));
} elseif ($key == 'send_mail_duration_in_minutes') {
return $value . ' mins';
} elseif ($key == 'template_id') {
$names = getTemplateNames($value);
if (isset($names[$value])) {
return $names[$value];
} else {
return ' - ';
}
} elseif ($key == 'mail_status') {
$mail_status = array(0 => 'Not sent', 1 => 'Terminiated', 2 => 'In-Queue', 3 => 'Sent');
if (isset($mail_status[$value])) {
return $mail_status[$value];
} else {
return " - ";
}
} else {
if ($key == 'is_user_read') {
if ($value == 0) {
return 'Unread';
} else {
return 'Read';
}
}
}
}
return $data[$key];
}
if (checkdate($th_month, $th_date, $th_year)) {
//Valid date
$th_dt = $th_year . "-" . $th_month . "-" . $th_date . " 23:59:59";
$filters[] = " AND `mail_sent_on` <= '" . $th_dt . "'";
}
}
}
$q_filters = !empty($filters) ? implode(' ', $filters) : '';
$order_by = ' ORDER BY `id` DESC ';
global $wpdb;
$query = "SELECT * FROM `" . $wpdb->prefix . "wps_wcafr_mail_log` WHERE `is_deleted`='0' " . $q_filters . $order_by;
$query_count = "SELECT count(*) FROM `" . $wpdb->prefix . "wps_wcafr_mail_log` WHERE `is_deleted`='0' " . $q_filters . $order_by;
$display_coloumns = array('id' => 'ID', 'template_id' => 'Template', 'subject' => 'Subject', 'send_to_email' => 'Email', 'mail_status' => 'Email Status', 'mail_sent_on' => 'Email Sent On', 'is_user_read' => 'User Read', 'user_read_on' => 'User Read On');
$mail_status = array(-1 => 'All', 0 => 'Not sent', 1 => 'Terminiated', 2 => 'In-Queue', 3 => 'Sent');
$user_read = array(-1 => 'All', 0 => 'Unread', 1 => 'Read');
$filter_coloumns = array('template_id' => array('label' => 'Template', 'default_value' => '0', 'type' => 'select', 'options' => array_merge(array('0' => 'All'), getTemplateNames())), 'send_to_email' => array('label' => 'Email', 'default_value' => '', 'type' => 'text'), 'mail_status' => array('label' => 'Email Status', 'default_value' => -1, 'type' => 'select', 'options' => $mail_status), 'is_user_read' => array('label' => 'User Read', 'default_value' => -1, 'type' => 'select', 'options' => $user_read), 'mail_sent_from' => array('label' => 'Email Sent From', 'default_value' => '', 'type' => 'text'), 'mail_sent_to' => array('label' => 'Email Sent To', 'default_value' => '', 'type' => 'text'));
$js_datepicker = '<script>
jQuery(document).ready(function(){
jQuery( "#inp_id_wps_wc_afr_mail_sent_from" ).datepicker({
changeMonth: false,
numberOfMonths: 1,
maxDate: 0,
onClose: function( selectedDate ) {
jQuery( "#inp_id_wps_wc_afr_mail_sent_to" ).datepicker( "option", "minDate", selectedDate );
}
});
jQuery( "#inp_id_wps_wc_afr_mail_sent_to" ).datepicker({
changeMonth: false,
numberOfMonths: 1,
maxDate: 0,
onClose: function( selectedDate ) {
