<?php
/**
* Generate and display reports.
*
* @category Core
* @package My Tickets
* @author Joe Dolson
* @license GPLv2 or later
* @link https://www.joedolson.com/my-tickets/
*/
/* Payments Page; display payment history */
if ( ! defined( 'ABSPATH' ) ) {
exit;
} // Exit if accessed directly.
/**
* Display reports screen.
*/
function mt_reports_page() {
?>
<div class='wrap my-tickets'>
<h1><?php _e( 'My Tickets Reporting', 'my-tickets' ); ?></h1>
<div class="postbox-container jcd-wide">
<div class="metabox-holder">
<div class="ui-sortable meta-box-sortables">
<div class="postbox">
<h2 class="hndle"><?php _e( 'Reports on Ticket Sales and Registrations', 'my-tickets' ); ?></h2>
<div class="inside">
<?php
if ( isset( $_POST['event_id'] ) && is_numeric( $_POST['event_id'] ) ) {
if ( ! ( '' === strip_tags( $_POST['mt_subject'] ) || '' === strip_tags( $_POST['mt_body'] ) ) ) {
$verify = wp_verify_nonce( $_POST['mt-email-nonce'], 'mt-email-purchasers' );
if ( $verify ) {
mt_mass_email();
} else {
wp_die( __( 'My Tickets email security not verified.', 'my-tickets' ) );
}
}
}
if ( ! isset( $_GET['event_id'] ) ) {
mt_generate_report_by_time();
} else {
if ( isset( $_GET['mt-event-report'] ) && 'tickets' === $_GET['mt-event-report'] ) {
mt_generate_tickets_by_event();
} else {
mt_generate_report_by_event();
}
$event_id = (int) $_GET['event_id'];
$report_type = ( isset( $_GET['mt-event-report'] ) && 'tickets' === $_GET['mt-event-report'] ) ? 'tickets' : 'purchases';
if ( isset( $_GET['mt_print'] ) ) {
$print_report_url = 'javascript:window.print()';
} else {
$print_report_url = esc_url( admin_url( 'admin.php?page=mt-reports&event_id=' . $event_id . '&mt-event-report=' . $report_type . '&format=view&mt_print=true' ) );
}
$back_url = admin_url( apply_filters( 'mt_printable_report_back', 'admin.php?page=mt-reports&mt-event-report=' . $report_type . '&event_id=' . $event_id ) );
$return = ( isset( $_GET['mt_print'] ) ) ? '<a class="mt-back button" href="' . esc_url( $back_url ) . '">' . __( 'Return to My Tickets Reports', 'my-tickets' ) . '</a>' : '';
$show = ( isset( $_GET['mt_print'] ) ) ? '<button class="button show-button">' . esc_html( __( 'Show Hidden Columns', 'my-tickets' ) ) . '</button>' : '';
echo '<p><a class="button print-button" href="' . $print_report_url . '">' . __( 'Print this report', 'my-tickets' ) . '</a> ' . $return . ' ' . $show . '</p>';
}
?>
<div class="mt-report-selector">
<?php mt_choose_report_by_date(); ?>
<?php mt_choose_report_by_event(); ?>
<div class='mt-email-purchasers'>
<?php mt_email_purchasers(); ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php mt_show_support_box(); ?>
</div>
<?php
}
/**
* Get the array of headers for a report.
*
* @param string $context Purchases or tickets.
* @param string $type Type of display table or csv. Only used in filters.
*
* @return array
*/
function mt_get_column_headers( $context = 'purchases', $type = 'table' ) {
$tickets_headers = array(
'mt-id' => array(
'label' => __( 'Ticket ID', 'my-tickets' ),
),
'mt-seqid' => array(
'label' => __( 'Sequential ID', 'my-tickets' ),
),
'mt-last' => array(
'label' => __( 'Last Name', 'my-tickets' ),
),
'mt-first' => array(
'label' => __( 'First Name', 'my-tickets' ),
),
'mt-post' => array(
'label' => __( 'Purchase ID', 'my-tickets' ),
),
'mt-type' => array(
'label' => __( 'Ticket Type', 'my-tickets' ),
),
'mt-price' => array(
'label' => __( 'Price', 'my-tickets' ),
),
'mt-status' => array(
'label' => __( 'Status', 'my-tickets' ),
),
'mt-used' => array(
'label' => __( 'Used', 'my-tickets' ),
),
);
$purchases_headers = array(
'mt-last' => array(
'label' => __( 'Last Name', 'my-tickets' ),
),
'mt-first' => array(
'label' => __( 'First Name', 'my-tickets' ),
),
'mt-type' => array(
'label' => __( 'Type', 'my-tickets' ),
),
'mt-tickets' => array(
'label' => __( 'Tickets', 'my-tickets' ),
),
'mt-owed' => array(
'label' => __( 'Owed', 'my-tickets' ),
),
'mt-paid' => array(
'label' => __( 'Paid', 'my-tickets' ),
),
'mt-method' => array(
'label' => __( 'Method', 'my-tickets' ),
),
'mt-date' => array(
'label' => __( 'Date', 'my-tickets' ),
),
'mt-id' => array(
'label' => __( 'ID', 'my-tickets' ),
),
'mt-gateway' => array(
'label' => __( 'Gateway', 'my-tickets' ),
),
'mt-email' => array(
'label' => __( 'Email', 'my-tickets' ),
),
'mt-phone' => array(
'label' => __( 'Phone', 'my-tickets' ),
),
'mt-fee' => array(
'label' => __( 'Fee', 'my-tickets' ),
),
'mt-street' => array(
'label' => __( 'Street', 'my-tickets' ),
),
'mt-street2' => array(
'label' => __( 'Street (2)', 'my-tickets' ),
),
'mt-city' => array(
'label' => __( 'City', 'my-tickets' ),
),
'mt-state' => array(
'label' => __( 'State', 'my-tickets' ),
),
'mt-code' => array(
'label' => __( 'Postcode', 'my-tickets' ),
),
'mt-country' => array(
'label' => __( 'Country', 'my-tickets' ),
),
'mt-notes' => array(
'label' => __( 'Notes', 'my-tickets' ),
),
);
$headers = ( 'purchases' === $context ) ? $purchases_headers : $tickets_headers;
/**
* Filter the column headers.
*
* @hook mt_header_columns
*
* @param {array} $headers Headers with labels and callbacks.
* @param {string} $context Purchases or tickets.
* @param {string} $type Display type table or csv.
*
* @return {array}
*/
$headers = apply_filters( 'mt_header_columns', $headers, $context, $type );
return $headers;
}
/**
* Draw the headers for a given report display.
*
* @param array $headers Array of column headers.
* @param string $type Display type table or csv.
* @param array $custom_headers Custom headers to insert into string.
*
* @return string
*/
function mt_set_column_headers( $headers, $type, $custom_headers = array() ) {
$cols = array();
$count = count( $headers );
foreach ( $headers as $key => $value ) {
--$count;
// Insert custom fields before the last column.
if ( 0 === $count && ! empty( $custom_headers ) ) {
foreach ( $custom_headers as $name => $field ) {
if ( 'table' === $type ) {
$cols[] = "<th scope='col' class='mt_" . sanitize_title( $name ) . "'>" . $field['title'] . '</th>';
} else {
$cols[] = '"' . $field['title'] . '"';
}
}
}
if ( 'table' === $type ) {
$cols[] = '<th scope="col" class="' . $key . '" id="' . $key . '">' . $value['label'] . '</th>';
} else {
$cols[] = '"' . $value['label'] . '"';
}
}
return ( 'csv' === $type ) ? implode( ',', $cols ) : implode( PHP_EOL, $cols );
}
/**
* Generate a report of tickets on a single event.
*
* @param bool|int $event_id Event ID.
* @param bool $display True to return.
*
* @return void|string
*/
function mt_generate_tickets_by_event( $event_id = false, $display = false ) {
if ( current_user_can( 'mt-view-reports' ) || current_user_can( 'manage_options' ) ) {
$event_id = ( isset( $_GET['event_id'] ) ) ? (int) $_GET['event_id'] : $event_id;
if ( $event_id ) {
$ticket_type = isset( $_GET['mt_select_ticket_type'] ) ? sanitize_text_field( $_GET['mt_select_ticket_type'] ) : 'all';
$title = get_the_title( $event_id );
$output = '';
$data = mt_get_tickets( $event_id, $ticket_type );
$report = $data['html'];
$total_tickets = count( $report );
$headers = mt_get_column_headers( 'tickets', 'table' );
$header_html = mt_set_column_headers( $headers, 'table' );
// Translators: name of event.
$table_top = "<table class='widefat striped'><caption>" . sprintf( __( 'Tickets Purchased for “%s”', 'my-tickets' ), $title ) . "</caption>
<thead>
<tr>
$header_html
</tr>
</thead>
<tbody>";
$table_bottom = '</tbody></table>';
foreach ( $report as $row ) {
$table_top .= $row;
}
$table = $table_top . $table_bottom;
$output .= $table;
if ( $display ) {
// Translators: Number of tickets sold.
return "<p class='totals'>" . sprintf( __( '%1$s tickets sold.', 'my-tickets' ), "<strong>$total_tickets</strong>" ) . '</p>' . $output;
} else {
// Translators: Number of tickets sold.
echo wp_kses_post( "<p class='totals'>" . sprintf( __( '%1$s tickets sold.', 'my-tickets' ), "<strong>$total_tickets</strong>" ) . '</p>' . $output );
}
}
} else {
if ( $display ) {
return false;
} else {
echo wp_kses_post( "<div class='updated error'><p>" . __( 'You do not have sufficient permissions to view ticketing reports.', 'my-tickets' ) . '</p></div>' );
}
}
}
/**
* Generate a report of payments on a single event.
*
* @param bool|int $event_id Event ID.
* @param bool $return_type Return or echo.
*
* @return void|string
*/
function mt_generate_report_by_event( $event_id = false, $return_type = false ) {
if ( current_user_can( 'mt-view-reports' ) || current_user_can( 'manage_options' ) ) {
$event_id = ( isset( $_GET['event_id'] ) ) ? (int) $_GET['event_id'] : $event_id;
if ( $event_id ) {
$title = get_the_title( $event_id );
$tabs = '';
$out = '';
$ticket_type = isset( $_GET['mt_select_ticket_type'] ) ? sanitize_text_field( $_GET['mt_select_ticket_type'] ) : 'all';
$options = ( isset( $_GET['options'] ) ) ? map_deep( $_GET['options'], 'sanitize_text_field' ) : array(
'type' => 'html',
'output' => 'payments',
'include_failed' => true,
'ticket_type' => $ticket_type,
);
$status_types = array(
'completed' => __( 'Completed (%Completed)', 'my-tickets' ),
// Translators: percent signs, *not* placeholders.
'failed' => __( 'Failed (%Failed)', 'my-tickets' ),
'refunded' => __( 'Refunded (%Refunded)', 'my-tickets' ),
'pending' => __( 'Pending (%Pending)', 'my-tickets' ),
'reserved' => __( 'Reserved (%Reserved)', 'my-tickets' ),
'turned-back' => __( 'Turned Back (%Turned Back)', 'my-tickets' ),
'waiting-list' => __( 'Waiting List (%Waiting List)', 'my-tickets' ),
);
foreach ( $status_types as $type => $status_type ) {
$tabs .= "<li><a href='#mt_$type'>$status_type</a></li>";
}
$output = "
<div class='mt-tabs mt-reports'>
<ul class='tabs'>
$tabs
</ul>";
$data = mt_purchases( $event_id, $options );
if ( is_array( $data ) ) {
$report = $data['report']['html'];
$total_tickets = $data['tickets'];
$total_sales = count( $data['report']['html']['Completed'] ) + count( $data['report']['html']['Pending'] );
$total_income = $data['income'];
$custom_fields = mt_get_custom_fields( 'reports' );
$header_columns = mt_get_column_headers( 'purchases', 'table' );
$headers = mt_set_column_headers( $header_columns, 'table', $custom_fields );
$table_top = "<table class='widefat striped'><caption>%caption%</caption>
<thead>
<tr>
$headers
</tr>
</thead>
<tbody>";
$table_bottom = '</tbody></table>';
foreach ( $report as $status => $rows ) {
${$status} = '';
$count = count( $rows );
$output = str_replace( "%$status", $count, $output );
foreach ( $rows as $type => $row ) {
${$status} .= $row;
}
$caption = "$title: <em>$status</em>";
$use_table_top = ( 0 !== $count ) ? str_replace( '%caption%', $caption, $table_top ) : '';
$out .= "<div class='wptab wp_" . sanitize_title( $status ) . "' id='mt_" . sanitize_title( $status ) . "'>" . $use_table_top . ${$status} . $table_bottom . '</div>';
}
} else {
$out = '';
}
$output .= $out . '</div>';
// Translators: Number of tickets sold, total number of sales completed, number of purchases transacted.
$total_line = "<p class='totals'>" . sprintf( __( '%1$s tickets sold in %3$s purchases. Total completed sales: %2$s', 'my-tickets' ), "<strong>$total_tickets</strong>", '<strong>' . apply_filters( 'mt_money_format', $total_income ) . '</strong>', "<strong>$total_sales</strong>" ) . '</p>';
$custom_line = apply_filters( 'mt_custom_total_line_event', '', $event_id );
if ( $return_type ) {
return $total_line . $custom_line . $output;
} else {
echo wp_kses_post( $total_line . $custom_line . $output );
}
}
} else {
if ( $return_type ) {
return false;
} else {
echo wp_kses_post( "<div class='updated error'><p>" . __( 'You do not have sufficient permissions to view sales reports.', 'my-tickets' ) . '</p></div>' );
}
}
}
/**
* Produce selector to choose report by event.
*
* @return void
*/
function mt_choose_report_by_event() {
$events = mt_select_events();
$selector = $events['options'];
$types = $events['types'];
$groups = new stdClass();
foreach ( $types as $key => $type ) {
$groups->$key = $type;
}
$groups = wp_json_encode( $groups );
$default_format = mt_get_settings( 'mt_default_format' );
$format = ( isset( $_GET['format'] ) ) ? sanitize_text_field( $_GET['format'] ) : $default_format;
$default_report = mt_get_settings( 'mt_default_report' );
$report = ( isset( $_GET['mt-event-report'] ) ) ? sanitize_text_field( $_GET['mt-event-report'] ) : $default_report;
$form = "
<div class='report-by-event'>
<div id='report-json' class='hidden'>$groups</div>
<h3>" . __( 'Report by Event', 'my-tickets' ) . "</h3>
<form method='GET' action='" . esc_url( admin_url( 'admin.php?page=mt-reports' ) ) . "'>
<div>
<input type='hidden' name='page' value='mt-reports' />
</div>
<p>
<label for='mt_select_event'>" . __( 'Select Event', 'my-tickets' ) . "</label>
<select name='event_id' id='mt_select_event' class='widefat'>
$selector
</select>
</p>
<p class='hidden' id='mt_select_ticket_type'>
<label for='mt_select_ticket_type'>" . __( 'Ticket Group', 'my-tickets' ) . "</label>
<select id='mt_select_ticket_type' name='mt_select_ticket_type' class='widefat'>
<option value='all'>" . __( 'All groups', 'my-tickets' ) . "</option>
</select>
</p>
<p>
<label for='mt_select_report_type'>" . __( 'Select Report Type', 'my-tickets' ) . "</label>
<select name='mt-event-report' id='mt_select_report_type' class='widefat'>
<option value='purchases'" . selected( $report, 'purchases', false ) . '>' . __( 'List of Purchases', 'my-tickets' ) . "</option>
<option value='tickets'" . selected( $report, 'tickets', false ) . '>' . __( 'List of Tickets', 'my-tickets' ) . "</option>
</select>
</p>
<p>
<label for='mt_select_format_event'>" . __( 'Report Format', 'my-tickets' ) . "</label>
<select name='format' id='mt_select_format_event' class='widefat'>
<option value='csv'" . selected( $format, 'csv', false ) . '>' . __( 'Download CSV', 'my-tickets' ) . "</option>
<option value='view'" . selected( $format, 'view', false ) . '>' . __( 'View Report', 'my-tickets' ) . "</option>
</select>
</p>
<p><input type='submit' name='mt-display-report' class='button-primary' value='" . __( 'Get Report by Event', 'my-tickets' ) . "' /></p>
</form>
</div>";
echo wp_kses( $form, mt_kses_elements() );
}
/**
* Display selector to choose report by date.
*
* @return void
*/
function mt_choose_report_by_date() {
$default_format = mt_get_settings( 'mt_default_format' );
$format = ( isset( $_GET['format'] ) ) ? sanitize_text_field( $_GET['format'] ) : $default_format;
$start = ( isset( $_GET['mt_start'] ) ) ? sanitize_text_field( $_GET['mt_start'] ) : mt_date( 'Y-m-d', strtotime( '-1 month' ) );
$end = ( isset( $_GET['mt_end'] ) ) ? sanitize_text_field( $_GET['mt_end'] ) : mt_date( 'Y-m-d' );
$form = "
<div class='report-by-date'>
<h3>" . __( 'Sales Report by Date', 'my-tickets' ) . "</h3>
<form method='GET' action='" . admin_url( 'admin.php?page=mt-reports' ) . "'>
<div>
<input type='hidden' name='page' value='mt-reports' />
</div>
<p>
<label for='mt_start'>" . __( 'Report Start Date', 'my-tickets' ) . "</label>
<input type='date' name='mt_start' id='mt_start' value='$start' class='widefat' />
</p>
<p>
<label for='mt_end'>" . __( 'Report End Date', 'my-tickets' ) . "</label>
<input type='date' name='mt_end' id='mt_end' value='$end' class='widefat' />
</p>
<p>
<label for='mt_select_format_date'>" . __( 'Report Format', 'my-tickets' ) . "</label>
<select name='format' id='mt_select_format_date' class='widefat'>
<option value='view'" . selected( 'view', $format, false ) . '>' . __( 'View Report', 'my-tickets' ) . "</option>
<option value='csv'" . selected( 'csv', $format, false ) . '>' . __( 'Download CSV', 'my-tickets' ) . "</option>
</select>
</p>
<p><input type='submit' name='mt-display-report' class='button-primary' value='" . __( 'Get Report by Date', 'my-tickets' ) . "' /></p>
</form>
</div>";
echo wp_kses( $form, mt_kses_elements() );
}
/**
* Produce form to choose event for mass emailing purchasers.
*/
function mt_email_purchasers() {
$events = mt_select_events();
$selector = $events['options'];
$types = $events['types'];
$nonce = wp_nonce_field( 'mt-email-purchasers', 'mt-email-nonce', true, false );
$event_id = ( isset( $_GET['event_id'] ) ) ? (int) $_GET['event_id'] : false;
$body = ( isset( $_POST['mt_body'] ) ) ? wp_kses_post( $_POST['mt_body'] ) : '';
$subject = ( isset( $_POST['mt_subject'] ) ) ? sanitize_text_field( $_POST['mt_subject'] ) : '';
$email = get_post_meta( $event_id, '_mass_email' );
if ( ! empty( $email ) ) {
if ( isset( $_GET['message'] ) ) {
$strip = intval( $_GET['message'] );
for ( $i = 0; $i < $strip; $i++ ) {
$removed = ( is_array( $email ) ) ? array_pop( $email ) : array();
}
}
if ( ! empty( $email ) ) {
$last_email = end( $email );
$body = $last_email['body'];
$subject = $last_email['subject'];
}
}
$form = '
<h3>' . __( 'Email Purchasers of Tickets by Event', 'my-tickets' ) . "</h3>
<form method='POST' action='" . admin_url( 'admin.php?page=mt-reports' ) . "' id='mt_email_purchasers'>
$nonce
<p>
<label for='mt_select_event_for_email'>" . __( 'Select Event to Message', 'my-tickets' ) . "</label>
<select name='event_id' id='mt_select_event_for_email' class='widefat'>
$selector
</select>
</p>
<p>
<label for='mt_subject'>" . __( 'Email Subject', 'my-tickets' ) . "</label>
<input type='text' name='mt_subject' id='mt_subject' value='" . esc_attr( $subject ) . "' class='widefat' />
</p>
<p>
<label for='mt_body' id='body_label'>" . __( 'Email Body', 'my-tickets' ) . "</label>
<textarea name='mt_body' id='mt_body' cols='60' rows='12' aria-labelledby='body_label body_description' class='widefat'>" . esc_textarea( stripslashes( $body ) ) . "</textarea><br />
<span id='body_description'>" . __( 'Use <code>{name}</code> to insert the recipient\'s name', 'my-tickets' ) . "</span>
</p>
<p><input type='checkbox' name='mt-test-email' value='test' id='mt_test_email'> <label for='mt_test_email'>" . __( 'Send test email', 'my-tickets' ) . "</label></p>
<p><input type='submit' name='mt-email-purchasers' class='button-primary' value='" . __( 'Send Email', 'my-tickets' ) . "' /></p>
</form>";
echo wp_kses( $form, mt_kses_elements() );
}
/**
* Select events with event sales data. (If no sales, not returned.)
*
* @return array
*/
function mt_select_events() {
// fetch posts with meta data for event sales.
$settings = mt_get_settings();
// add time query to this query after timestamp field has been in place for a few months.
// only show limit of 100 events.
$args =
array(
'post_type' => $settings['mt_post_types'],
'posts_per_page' => apply_filters( 'mt_select_events_count', 100 ),
'post_status' => array( 'publish', 'draft', 'private' ),
'meta_query' => array(
'relation' => 'AND',
'queries' => array(
'key' => '_ticket',
'compare' => 'EXISTS',
),
),
);
/**
* Filter the arguments used to select events shown in the reports dropdown.
*
* @hook mt_select_events_args
*
* @param {array} $args WP_Query arguments.
*
* @return {array}
*/
$args = apply_filters( 'mt_select_events_args', $args );
$query = new WP_Query( $args );
$posts = $query->posts;
$ids = wp_list_pluck( $posts, 'ID' );
$empty = '<option value="false"> --- </option>';
if ( isset( $_GET['event_id'] ) && ! in_array( (int) $_GET['event_id'], $ids, true ) ) {
$event_id = absint( $_GET['event_id'] );
$post = get_post( $event_id );
if ( $post ) {
$posts[] = $post;
}
}
$sort_type = $settings['mt_report_order'];
$sort_dir = $settings['mt_report_direction'];
$types = array();
$options = array( '_empty' => $empty );
foreach ( $posts as $post ) {
$tickets = get_post_meta( $post->ID, '_ticket' );
$count = count( $tickets );
$show_event = false;
$selected = ( isset( $_GET['event_id'] ) && absint( $_GET['event_id'] ) === $post->ID ) ? ' selected="selected"' : '';
$event_data = get_post_meta( $post->ID, '_mc_event_data', true );
if ( is_array( $event_data ) ) {
$event_date = strtotime( $event_data['event_begin'] . ' ' . $event_data['event_time'] );
$display_date = date_i18n( get_option( 'date_format' ), $event_date );
// if this event happened more than 2 years ago, don't show in list *unless* it's the currently selected report.
/**
* Filter the event age limit applied for showing events in the reports dropdown.
*
* @hook mt_reports_age_limit
*
* @param {int} $timestamp The current time minus 2 years.
*
* @return {int}
*/
$report_age_limit = apply_filters( 'mt_reports_age_limit', mt_current_time() - ( YEAR_IN_SECONDS * 2 ) );
if ( isset( $event_data['general_admission'] ) && 'on' === $event_data['general_admission'] ) {
$show_event = true;
}
if ( $event_date > $report_age_limit || ' selected="selected"' === $selected || $show_event ) {
$key = sanitize_title( $post->post_title ) . '_' . $post->ID;
if ( 'date' === $sort_type ) {
$key = $event_date;
}
/**
* Filter the event title shown in the My Tickets reports dropdown.
*
* @hook mt_the_title
*
* @param {string} $post_title The Post Title.
* @param {WP_Post} $post Post object.
*
* @return {string}
*/
$title = apply_filters( 'mt_the_title', $post->post_title, $post );
$options[ $key ] = "<option value='$post->ID'$selected>$title ($count); $display_date</option>";
$types[ $post->ID ] = mt_get_prices( $post->ID );
}
}
}
if ( 'desc' === $sort_dir ) {
krsort( $options );
} else {
ksort( $options );
}
$options = implode( PHP_EOL, $options );
return array(
'options' => $options,
'types' => $types,
);
}
/**
* Return array of formatted purchase data for use in reports by event ID.
*
* @param int $event_id Event ID.
* @param array $options Report options.
*
* @return array
*/
function mt_purchases( $event_id, $options = array( 'include_failed' => false ) ) {
if ( false === $event_id ) {
exit;
}
$query = get_post_meta( $event_id, '_purchase' );
if ( ! $query ) {
return false;
}
$report = array(
'html' => array(
'Completed' => array(),
'Pending' => array(),
'Refunded' => array(),
'Failed' => array(),
'Reserved' => array(),
'Turned Back' => array(),
'Waiting List' => array(),
),
'csv' => array(
'Completed' => array(),
'Pending' => array(),
'Refunded' => array(),
'Failed' => array(),
'Reserved' => array(),
'Turned Back' => array(),
'Waiting List' => array(),
),
);
$total_tickets = 0;
$total_income = 0;
foreach ( $query as $payment ) {
foreach ( $payment as $purchase_id => $details ) {
if ( 'publish' !== get_post_status( $purchase_id ) ) {
continue;
}
$mt_id = $purchase_id;
$status = get_post_meta( $purchase_id, '_is_paid', true );
$mt_method = get_post_meta( $purchase_id, '_ticketing_method', true );
$mt_notes = esc_html( get_post_meta( $purchase_id, '_notes', true ) );
if ( false === $options['include_failed'] && ( 'Failed' === $status || 'Refunded' === $status || 'Turned Back' === $status ) ) {
continue;
}
$mt_type = '';
$mt_tickets = 0;
$subtotal = 0;
// get total # tickets on purchase.
// get count of tickets for *this* event on purchase.
// get total paid.
// get total price owed (on purchase).
foreach ( $details as $type => $tickets ) {
$ticket_type = isset( $options['ticket_type'] ) ? $options['ticket_type'] : 'all';
if ( 'all' === $ticket_type || $ticket_type === $type ) {
$count = isset( $details[ $type ]['count'] ) ? $details[ $type ]['count'] : 0;
// THIS results in only getting the details for one type listed; need all types for this to be valid.
if ( $count > 0 ) {
$purchaser = get_the_title( $purchase_id );
$mt_first = get_post_meta( $purchase_id, '_first_name', true );
$mt_last = get_post_meta( $purchase_id, '_last_name', true );
$mt_email = get_post_meta( $purchase_id, '_email', true );
$mt_gateway = get_post_meta( $purchase_id, '_gateway', true );
if ( ! $mt_first || ! $mt_last ) {
$name = explode( ' ', $purchaser );
$mt_first = $name[0];
$mt_last = end( $name );
}
$date = get_the_time( 'Y-m-d', $purchase_id );
$time = get_the_time( get_option( 'time_format' ), $purchase_id );
$transaction = get_post_meta( $purchase_id, '_transaction_data', true );
$address = ( isset( $transaction['shipping'] ) ) ? $transaction['shipping'] : false;
$mt_phone = get_post_meta( $purchase_id, '_phone', true );
$mt_fee = ( isset( $transaction['fee'] ) ) ? $transaction['fee'] : false;
$mt_street = ( isset( $address['street'] ) ) ? $address['street'] : '';
$mt_street2 = ( isset( $address['street2'] ) ) ? $address['street2'] : '';
$mt_city = ( isset( $address['city'] ) ) ? $address['city'] : '';
$mt_state = ( isset( $address['state'] ) ) ? $address['state'] : '';
$mt_code = ( isset( $address['code'] ) ) ? $address['code'] : '';
$mt_country = ( isset( $address['country'] ) ) ? $address['country'] : '';
$mt_date = "$date $time";
$mt_price = $details[ $type ]['price'];
$label = mt_get_label( $type, $event_id );
// Append each type in this purchase with a count of number of items purchased.
$mt_type .= ( '' === $mt_type ) ? mt_format_if_datetime( $label ) . ':' . $count : PHP_EOL . $label . ':' . $count;
$this_total = $count * $mt_price;
$subtotal = $subtotal + ( $this_total );
// "sold" tickets are only in reports as those completed.
if ( 'Completed' === $status ) {
$total_income = $total_income + $this_total;
$total_tickets = $total_tickets + $count;
$mt_paid = $subtotal;
} else {
$mt_paid = 0;
}
// if $mt_tickets == 0, don't show in options.
$mt_tickets = $mt_tickets + $count;
$custom_fields = mt_get_custom_fields( 'reports' );
$custom_cells = '';
$custom_csv = '';
foreach ( $custom_fields as $name => $field ) {
if ( isset( $field['report_callback'] ) ) {
$cstring = call_user_func( $field['report_callback'], $purchase_id );
} else {
$value = get_post_meta( $purchase_id, $name );
$cstring = '';
foreach ( $value as $v ) {
if ( is_array( $v ) ) {
if ( absint( $v['event_id'] ) === absint( $_GET['event_id'] ) ) {
$keys = array_keys( $v );
foreach ( $keys as $val ) {
if ( 'event_id' !== $val ) {
$cstring .= ( '' !== $cstring ) ? '; ' : '';
$cstring .= esc_html( $v[ $val ] );
}
}
}
} elseif ( ! is_object( $v ) ) {
$cstring .= $v;
}
}
}
$value = apply_filters( 'mt_format_report_field', $cstring, get_post_meta( $purchase_id, $name, true ), $purchase_id, $name );
$custom_cells .= "<td class='mt_" . sanitize_title( $name ) . "'>$value</td>\n";
$custom_csv .= ",\"$value\"";
}
}
}
}
if ( $mt_tickets > 0 ) {
$mt_owed = $subtotal - $mt_paid;
$header_columns = mt_get_column_headers( 'purchases', 'csv' );
$count = 0;
$col_count = count( $header_columns );
$row = '<tr>';
$csv_array = array();
foreach ( $header_columns as $key => $column ) {
$val = str_replace( '-', '_', $key );
$column_value = $$val;
if ( $count === $col_count - 1 ) {
$row .= $custom_cells;
}
if ( 0 === $count ) {
$row .= "<th scope='row' id='$key' class='$key'>" . esc_html( $column_value ) . '</th>';
$csv_array[] = "\"$column_value\"";
} else {
$row .= "<td id='$key' class='$key'>" . esc_html( $column_value ) . '</td>';
if ( 'mt-type' === $key ) {
$column_value = str_replace( PHP_EOL, ', ', $mt_type );
}
$csv_array[] = "\"$column_value\"";
}
++$count;
}
$row .= '</tr>';
// add split field to csv headers.
$csv = implode( ',', $csv_array ) . PHP_EOL;
$report['html'][ $status ][] = $row;
$report['csv'][ $status ][] = $csv;
}
}
}
return array(
'report' => $report,
'income' => $total_income,
'tickets' => $total_tickets,
);
}
/**
* Format a ticket type label if it is date/time.
* If the label can be converted to an integer and back to the same label, it's a date.
*
* @param string $label Possible date string.
*
* @return string
*/
function mt_format_if_datetime( $label ) {
$test = explode( '-', $label );
if ( 4 === count( $test ) ) {
// Reformat in a date structure.
$string = $test[0] . '-' . $test[1] . '-' . $test[2] . ' ' . implode( ':', str_split( $test[3], 2 ) );
$formatted = mt_date( 'Y-m-d-His', strtotime( $string ), false );
if ( $label === $formatted ) {
$date_format = get_option( 'date_format' );
$time_format = get_option( 'time_format' );
return mt_date( $date_format . ' ' . $time_format, strtotime( $formatted ) );
}
}
return $label;
}
/**
* Produce a list of tickets for an event.
*
* @param int $event_id Event ID.
* @param string $ticket_type Type of tickets to return.
*
* @return array
*/
function mt_get_tickets( $event_id, $ticket_type = false ) {
$query = get_post_meta( $event_id, '_ticket' );
$report = array(
'html' => array(),
'csv' => array(),
);
$options = mt_get_settings();
foreach ( $query as $ticket_id ) {
$ticket = get_post_meta( $event_id, '_' . $ticket_id, true );
if ( $ticket_type ) {
$include = ( 'all' === $ticket_type || $ticket['type'] === $ticket_type ) ? true : false;
if ( ! $include ) {
continue;
}
}
if ( ! is_array( $ticket ) ) {
continue;
}
$ticket_url = add_query_arg( 'ticket_id', $ticket_id, get_permalink( $options['mt_tickets_page'] ) );
$purchase_id = $ticket['purchase_id'];
$columns = mt_get_column_headers( 'tickets', 'table' );
$i = 0;
$rows = array();
$csvs = array();
foreach ( $columns as $key => $value ) {
if ( 0 === $i ) {
$rows[] = "<th scope='row' class='$key' id='$key'><a href='$ticket_url'>$ticket_id</a></th>";
$csvs[] = $ticket_id;
} else {
if ( isset( $value['display_callback'] ) && function_exists( $value['display_callback'] ) ) {
$callback = $value['display_callback'];
} else {
$callback = 'mt_get_report_data';
}
$contents = call_user_func( $callback, $key, $purchase_id, $ticket_id, $ticket, $event_id );
$rows[] = "<td class='" . esc_attr( $key ) . "' id='" . esc_attr( $key ) . "'>$contents</td>";
$csvs[] = '\"' . wp_strip_all_tags( $contents ) . '\"';
}
++$i;
}
$row = '<tr>' . implode( PHP_EOL, $rows ) . '</tr>';
$csv = implode( ',', $csvs ) . PHP_EOL;
$report['html'][] = $row;
$report['csv'][] = $csv;
}
return $report;
}
/**
* Get data for event purchase reports.
*
* @param string $type Type of data requested.
* @param int $purchase_id Post ID for purchase record.
* @param string $ticket_id ID of the ticket being displayed.
* @param array $ticket Array of ticket information.
* @param int $event_id Post ID for event.
*
* @return string
*/
function mt_get_report_data( $type, $purchase_id, $ticket_id, $ticket, $event_id ) {
$value = '';
switch ( $type ) {
case 'mt-seqid':
$value = mt_get_sequential_id( $ticket_id );
break;
case 'mt-type':
$value = mt_get_label( $ticket['type'], $event_id );
break;
case 'mt-first':
$first = get_post_meta( $purchase_id, '_first_name', true );
if ( ! $first ) {
$name = explode( ' ', get_the_title( $purchase_id ) );
$first = $name[0];
}
$value = $first;
break;
case 'mt-last':
$last = get_post_meta( $purchase_id, '_last_name', true );
if ( ! $last ) {
$name = explode( ' ', get_the_title( $purchase_id ) );
$last = end( $name );
}
$value = $last;
break;
case 'mt-post':
$value = "<a href='" . get_edit_post_link( $purchase_id ) . "'>$purchase_id</a>";
break;
case 'mt-price':
$value = apply_filters( 'mt_money_format', $ticket['price'] );
break;
case 'mt-status':
$value = mt_get_payment_status( $purchase_id );
break;
case 'mt-used':
$used_tickets = get_post_meta( $purchase_id, '_tickets_used' );
$value = ( in_array( $ticket_id, $used_tickets, true ) ) ? '<span class="dashicons dashicons-tickets-alt" aria-hidden="true"></span> ' . __( 'Used', 'my-tickets' ) : '--';
break;
}
return $value;
}
add_action( 'admin_init', 'mt_download_csv_event' );
/**
* Download report of event data as CSV
*/
function mt_download_csv_event() {
if ( current_user_can( 'mt-view-reports' ) || current_user_can( 'manage_options' ) ) {
if (
isset( $_GET['format'] ) && 'csv' === $_GET['format'] &&
isset( $_GET['page'] ) && 'mt-reports' === $_GET['page'] &&
isset( $_GET['event_id'] ) &&
isset( $_GET['mt-event-report'] ) && 'purchases' === $_GET['mt-event-report']
) {
$event_id = intval( $_GET['event_id'] );
$type = isset( $_GET['mt_select_ticket_type'] ) ? sanitize_text_field( $_GET['mt_select_ticket_type'] ) : 'all';
$args = array(
'ticket_type' => $type,
'include_failed' => false,
);
$title = get_the_title( $event_id );
$purchases = mt_purchases( $event_id, $args );
if ( is_array( $purchases ) ) {
$report = $purchases['report']['csv'];
$custom_fields = mt_get_custom_fields( 'reports' );
$header_columns = mt_get_column_headers( 'purchases', 'csv' );
$csv = mt_set_column_headers( $header_columns, 'csv', $custom_fields ) . PHP_EOL;
foreach ( $report as $status => $rows ) {
foreach ( $rows as $type => $row ) {
$csv .= $row;
}
}
} else {
$csv = '';
}
$title = sanitize_title( $title ) . '-' . mt_date( 'Y-m-d' );
header( 'Content-Type: application/csv' );
header( "Content-Disposition: attachment; filename=$title.csv" );
header( 'Pragma: no-cache' );
echo wp_kses_post( $csv );
exit;
}
}
}
add_action( 'admin_init', 'mt_download_csv_tickets' );
/**
* Download report of ticket data for an event as CSV
*/
function mt_download_csv_tickets() {
if ( current_user_can( 'mt-view-reports' ) || current_user_can( 'manage_options' ) ) {
if (
isset( $_GET['format'] ) && 'csv' === $_GET['format'] &&
isset( $_GET['page'] ) && 'mt-reports' === $_GET['page'] &&
isset( $_GET['event_id'] ) &&
isset( $_GET['mt-event-report'] ) && 'tickets' === $_GET['mt-event-report']
) {
$event_id = intval( $_GET['event_id'] );
$title = get_the_title( $event_id ) . ' tickets';
$tickets = mt_get_tickets( $event_id );
$report = $tickets['csv'];
$headers = mt_get_column_headers( 'tickets', 'csv' );
$header_html = mt_set_column_headers( $headers, 'csv' ) . PHP_EOL;
$csv = $header_html . PHP_EOL;
foreach ( $report as $row ) {
$csv .= "$row";
}
$title = sanitize_title( $title ) . '-' . mt_date( 'Y-m-d' );
header( 'Content-Type: application/csv' );
header( "Content-Disposition: attachment; filename=$title.csv" );
header( 'Pragma: no-cache' );
echo wp_kses_post( $csv );
exit;
}
}
}
add_action( 'admin_init', 'mt_download_csv_time' );
/**
* Download report by sales period as CSV.
*/
function mt_download_csv_time() {
if ( current_user_can( 'mt-view-reports' ) || current_user_can( 'manage_options' ) ) {
$output = '';
if ( isset( $_GET['format'] ) && 'csv' === $_GET['format'] && isset( $_GET['page'] ) && 'mt-reports' === $_GET['page'] && isset( $_GET['mt_start'] ) ) {
$report = mt_get_report_data_by_time();
$csv = $report['csv'];
$start = $report['start'];
$end = $report['end'];
foreach ( $csv as $row ) {
$output .= "$row";
}
$title = sanitize_title( $start . '_' . $end ) . '-' . mt_date( 'Y-m-d' );
header( 'Content-Type: application/csv' );
header( "Content-Disposition: attachment; filename=$title.csv" );
header( 'Pragma: no-cache' );
echo wp_kses_post( $output );
exit;
}
}
}
/**
* Get report data for reports by time period.
*
* @param string $start Start date.
* @param string $end End date.
*
* @return array
*/
function mt_get_report_by_time( $start, $end ) {
$posts_per_page = -1;
/**
* Set default report start date for initial view on reports by time.
*
* @hook mt_default_report_start_date
*
* @param {string} $modifier A date modifier string; default '-1 week'.
*
* @return {string}
*/
if ( mt_date( 'Y-m-d', strtotime( apply_filters( 'mt_default_report_start_date', '-1 week' ) ) ) === $start && mt_date( 'Y-m-d' ) === $end ) {
$posts_per_page = 50;
}
$args = array(
'post_type' => 'mt-payments',
'post_status' => array( 'publish' ),
'date_query' => array(
'after' => $start,
'before' => $end,
'inclusive' => true,
),
'posts_per_page' => $posts_per_page,
);
$query = new WP_Query( $args );
$posts = $query->posts;
return $posts;
}
/**
* Return data from report by time.
*
* @return array
*/
function mt_get_report_data_by_time() {
$start = ( isset( $_GET['mt_start'] ) ) ? sanitize_text_field( $_GET['mt_start'] ) : mt_date( 'Y-m-d', strtotime( apply_filters( 'mt_default_report_start_date', '-1 week' ) ) );
$end = ( isset( $_GET['mt_end'] ) ) ? sanitize_text_field( $_GET['mt_end'] ) : mt_date( 'Y-m-d' );
$posts = mt_get_report_by_time( $start, $end );
$total = 0;
$html = array();
$csv = array();
$custom_fields = mt_get_custom_fields( 'reports' );
$custom_headers = '';
foreach ( $custom_fields as $name => $field ) {
$custom_headers .= ',"' . $field['title'] . '"';
}
$csv[] = '"Last Name","First Name","Email","Ticket Type","Purchase Value","Status","Events","Event Dates","Purchase Date"' . $custom_headers . PHP_EOL;
foreach ( $posts as $post ) {
$purchaser = get_the_title( $post->ID );
$first_name = get_post_meta( $post->ID, '_first_name', true );
$last_name = get_post_meta( $post->ID, '_last_name', true );
if ( ! $first_name && ! $last_name ) {
$name = explode( ' ', $purchaser );
$first_name = $name[0];
$last_name = end( $name );
}
$value = floatval( get_post_meta( $post->ID, '_total_paid', true ) );
$format_value = apply_filters( 'mt_money_format', $value );
$total = $total + $value;
$status = get_post_meta( $post->ID, '_is_paid', true );
$email = get_post_meta( $post->ID, '_email', true );
$type = get_post_meta( $post->ID, '_ticketing_method', true );
$purchased = get_post_meta( $post->ID, '_purchased' );
$date = get_the_time( 'Y-m-d', $post->ID );
$time = get_the_time( get_option( 'time_format' ), $post->ID );
$titles = array();
$dates = array();
foreach ( $purchased as $purchase ) {
foreach ( $purchase as $event => $purch ) {
// If, after iterating over an event's tickets, there are none, don't include.
$subtotal = 0;
foreach ( $purch as $values ) {
$count = (int) $values['count'];
$subtotal = $subtotal + $count;
}
if ( 0 === $subtotal ) {
continue;
}
$post_type = get_post_type( $event );
$event_data = get_post_meta( $event, '_mc_event_data', true );
if ( ! is_array( $event_data ) ) {
continue;
}
$event_date = $event_data['event_begin'] . ' ' . $event_data['event_time'];
if ( 'mc-events' === $post_type ) {
$mc_event = get_post_meta( $event, '_mc_event_id', true );
$url = admin_url( 'admin.php?page=my-calendar&mode=edit&event_id=' . $mc_event );
} else {
$url = admin_url( "post.php?post=$event&action=edit" );
}
$titles[] = "<a href='$url'>" . get_the_title( $event ) . '</a>';
$raw_titles[] = get_the_title( $event );
$time_format = ( '23:59:59' === $event_data['event_time'] ) ? '' : ' ' . get_option( 'time_format' );
$dates[] = date_i18n( 'Y-m-d' . $time_format, strtotime( $event_date ) );
}
}
$events = implode( ', ', $titles );
$event_dates = implode( ', ', $dates );
$raw_events = implode( ', ', array_map( 'strip_tags', $titles ) );
$raw_event_dates = implode( ', ', array_map( 'strip_tags', $dates ) );
$custom_fields = mt_get_custom_fields( 'reports' );
$custom_cells = '';
$custom_csv = '';
foreach ( $custom_fields as $name => $field ) {
if ( isset( $field['report_callback'] ) ) {
$cstring = call_user_func( $field['report_callback'], $post->ID );
} else {
$c_value = get_post_meta( $post->ID, $name );
$cstring = '';
foreach ( $c_value as $v ) {
if ( is_array( $v ) ) {
$keys = array_keys( $v );
foreach ( $keys as $val ) {
if ( 'event_id' !== $val ) {
$cstring .= ( '' !== $cstring ) ? '; ' : '';
$cstring .= esc_html( $v[ $val ] );
}
}
} elseif ( ! is_object( $v ) ) {
$cstring .= $v;
}
}
}
/**
* Apply custom formatting on a custom field value in reports.
*
* @hook mt_format_report_field
*
* @param {string} $cstring Custom value as a string.
* @param {string|array} $meta Stored meta value.
* @param {int} $post_id Post ID.
* @param {string} $name Name of custom field.
*
* @return {string}
*/
$c_value = apply_filters( 'mt_format_report_field', $cstring, get_post_meta( $post->ID, $name, true ), $post->ID, $name );
$custom_cells .= "<td class='mt_" . sanitize_title( $name ) . "'>$c_value</td>\n";
$custom_csv .= ",\"$c_value\"";
}
$html[] = "
<tr>
<td class='mt-purchaser'><a href='" . get_edit_post_link( $post->ID ) . "'>$purchaser</a></td>
<td class='mt-value'>$format_value</td>
<td class='mt-type'>$type</td>
<td class='mt-status'>$status</td>
<td class='mt-events'>$events</td>
<td class='mt-event-dates'>$event_dates</td>
<td class='mt-date'>$date $time</td>
$custom_cells
</tr>\n";
$csv[] = '"' . $last_name . '","' . $first_name . '","' . $email . '","' . $type . '","' . $value . '","' . $status . '","' . $raw_events . '","' . $raw_event_dates . '","' . $date . ' ' . $time . '"' . $custom_csv . PHP_EOL;
}
$report['html'] = $html;
$report['csv'] = $csv;
$report['total'] = $total;
$report['start'] = $start;
$report['end'] = $end;
return $report;
}
/**
* Print report by time to screen.
*/
function mt_generate_report_by_time() {
$report = mt_get_report_data_by_time();
$output = '';
if ( is_array( $report ) && ! empty( $report ) ) {
$purchases = $report['html'];
$total = $report['total'];
$start = $report['start'];
$end = $report['end'];
$custom_fields = mt_get_custom_fields( 'reports' );
$custom_headers = '';
foreach ( $custom_fields as $name => $field ) {
$custom_headers .= "<th scope='col' class='mt_" . sanitize_title( $name ) . "'>" . $field['title'] . "</th>\n";
}
// Translators: Starting date, ending date.
$output .= '<h3>' . sprintf( __( 'Sales from %1$s to %2$s', 'my-tickets' ), $start, $end ) . '</h3>';
$output .= "<table class='widefat striped'>
<thead>
<tr>
<th scope='col' class='mt-purchaser'>" . __( 'Purchaser', 'my-tickets' ) . "</th>
<th scope='col' class='mt-value'>" . __( 'Purchase Value', 'my-tickets' ) . "</th>
<th scope='col' class='mt-type'>" . __( 'Type', 'my-tickets' ) . "</th>
<th scope='col' class='mt-status'>" . __( 'Status', 'my-tickets' ) . "</th>
<th scope='col' class='mt-events'>" . __( 'Events', 'my-tickets' ) . "</th>
<th scope='col' class='mt-event-dates'>" . __( 'Event Dates', 'my-tickets' ) . "</th>
<th scope='col' class='mt-date'>" . __( 'Date', 'my-tickets' ) . '</th>' .
$custom_headers .
'</tr>
</thead>
<tbody>';
if ( is_array( $purchases ) && ! empty( $purchases ) ) {
foreach ( $purchases as $row ) {
$output .= $row;
}
}
$output .= '</tbody>
</table>';
// Translators: Time period.
$output .= sprintf( '<p>' . __( 'Total sales in period: %s', 'my-tickets' ) . '</p>', '<strong>' . apply_filters( 'mt_money_format', $total ) . '</strong>' );
$custom_line = apply_filters( 'mt_custom_total_line_time', '', $start, $end );
$output .= $custom_line;
} else {
$output = '<p>' . __( 'No sales in period.', 'my-tickets' ) . '</p>';
}
echo wp_kses_post( $output );
}
/**
* Return a list of purchasers names/emails for use in mass emailing
*
* @param int $event_id Event ID.
*
* @return array
*/
function mt_get_purchasers( $event_id ) {
$purchases = get_post_meta( $event_id, '_purchase' );
$contacts = array();
if ( is_array( $purchases ) ) {
foreach ( $purchases as $payment ) {
foreach ( $payment as $purchase_id => $details ) {
if ( 'publish' !== get_post_status( $purchase_id ) ) {
continue;
}
$status = get_post_meta( $purchase_id, '_is_paid', true );
// only send email to Completed payments.
if ( 'Completed' !== $status ) {
continue;
}
$purchaser = get_the_title( $purchase_id );
$email = get_post_meta( $purchase_id, '_email', true );
$opt_out = get_post_meta( $purchase_id, '_opt_out', true );
$contacts[] = array(
'purchase_id' => $purchase_id,
'opt_out' => $opt_out,
'name' => $purchaser,
'email' => $email,
);
}
}
}
return $contacts;
}
/**
* Send mass email to purchasers of event.
*
* @param bool|int $event_id Event ID.
*/
function mt_mass_email( $event_id = false ) {
if ( ! $event_id ) {
$event_id = ( isset( $_POST['event_id'] ) ) ? (int) $_POST['event_id'] : false;
}
if ( $event_id ) {
$body = ( ! empty( $_POST['mt_body'] ) ) ? wp_kses_post( $_POST['mt_body'] ) : false;
$subject = ( ! empty( $_POST['mt_subject'] ) ) ? wp_kses_post( $_POST['mt_subject'] ) : false;
$orig_subj = stripslashes( $subject );
$orig_body = stripslashes( $body );
$message = '';
// save email message to event post.
add_post_meta(
$event_id,
'_mass_email',
array(
'subject' => $subject,
'body' => $body,
)
);
if ( ! $body || ! $subject ) {
echo wp_kses_post( "<div class='updated error'><p>" . __( 'You must include a message subject and body to send mass email.', 'my-tickets' ) . '</p></div>' );
return;
}
$event = get_the_title( $event_id );
$options = mt_get_settings();
$purchasers = mt_get_purchasers( $event_id );
$count = count( $purchasers );
$emails_sent = 0;
$opt_outs = 0;
$blogname = get_option( 'blogname' );
$headers[] = "From: $blogname Events <" . $options['mt_from'] . '>';
$headers[] = "Reply-to: $options[mt_from]";
foreach ( $purchasers as $purchaser ) {
if ( 'true' !== $purchaser['opt_out'] ) {
$purchase_id = $purchaser['purchase_id'];
$opt_out_url = add_query_arg( 'opt_out', $purchase_id, home_url() );
// Translators: Opt out URL.
$opt_out = PHP_EOL . PHP_EOL . '<p><small>' . sprintf( __( "Don't want to receive email from us? Follow this link: %s", 'my-tickets' ), $opt_out_url ) . '</small></p>';
$opt_out = apply_filters( 'mt_opt_out_text', $opt_out, $opt_out_url, $event_id, 'bulk' );
$to = $purchaser['email'];
$name = $purchaser['name'];
$subject = str_replace( '{name}', $name, $subject );
$body = str_replace( '{name}', $name, $body );
if ( 'true' === $options['mt_html_email'] ) {
add_filter( 'wp_mail_content_type', 'mt_html_type' );
$body = wpautop( $body . $opt_out );
} else {
$body = strip_tags( $body . $opt_out );
}
$body = apply_filters( 'mt_modify_email_body', $body, 'purchaser' );
// Log this message.
add_post_meta(
$purchase_id,
'_mt_send_email',
array(
'body' => $body,
'subject' => $subject,
'date' => mt_current_time(),
)
);
// For test emails, skip sending & reset values.
if ( isset( $_POST['mt-test-email'] ) ) {
++$emails_sent;
$subject = $orig_subj;
$body = $orig_body;
$message = __( 'Test Email Sent', 'my-tickets' );
} else {
$sent = wp_mail( $to, $subject, $body, $headers );
if ( ! $sent ) {
// If mail sends, try without custom headers.
wp_mail( $to, $subject, $body );
}
++$emails_sent;
$subject = $orig_subj;
$body = $orig_body;
}
if ( 'true' === $options['mt_html_email'] ) {
remove_filter( 'wp_mail_content_type', 'mt_html_type' );
}
} else {
++$opt_outs;
}
}
// send copy of message to admin.
if ( 'true' === $options['mt_html_email'] ) {
add_filter( 'wp_mail_content_type', 'mt_html_type' );
}
$sent = wp_mail( $options['mt_to'], $orig_subj, wpautop( $orig_body ), $headers );
if ( ! $sent ) {
// If mail sends, try without custom headers.
wp_mail( $options['mt_to'], $orig_subj, wpautop( $orig_body ) );
}
if ( 'true' === $options['mt_html_email'] ) {
remove_filter( 'wp_mail_content_type', 'mt_html_type' );
}
// Translators: Number of purchasers notified, total number of purchasers, number of purchasers opted out, name of event.
$message = ( '' !== $message ) ? $message : sprintf( __( '%1$d/%2$d purchasers of tickets for "%4$s" have been emailed. %3$d/%2$d purchasers have opted out.', 'my-tickets' ), $emails_sent, $count, $opt_outs, $event );
echo wp_kses_post( "<div class='updated'><p>" . $message . '</p></div>' );
}
}
add_action( 'init', 'mt_record_opt_out' );
/**
* Set a cookie when a user is opting out of emails. Used to prevent users from unsubscribing other users.
*/
function mt_record_opt_out() {
if ( isset( $_GET['opt_out'] ) && ! isset( $_COOKIE['mt_opting_out'] ) ) {
$opt_out = absint( $_GET['opt_out'] );
$opt_out = md5( $opt_out );
if ( version_compare( PHP_VERSION, '7.3.0', '>' ) ) {
// Fix syntax.
$options = array(
'expires' => time() + 60 * 60 * 24 * 7,
'path' => COOKIEPATH,
'domain' => COOKIE_DOMAIN,
'secure' => false,
'httponly' => true,
'samesite' => 'Lax',
);
setcookie( 'mt_opting_out', $opt_out, $options );
} else {
setcookie( 'mt_opting_out', $opt_out, time() + 60 * 60 * 24, COOKIEPATH, COOKIE_DOMAIN, false, true );
}
}
}
add_action( 'template_include', 'mt_opt_out' );
/**
* Receive opt-out data so purchasers can opt out of receiving email.
*
* @param string $template Opt out template name.
*
* @return string
*/
function mt_opt_out( $template ) {
if ( isset( $_GET['opt_out'] ) && is_numeric( $_GET['opt_out'] ) ) {
$post_id = (int) $_GET['opt_out'];
$opting = ( isset( $_COOKIE['mt_opting_out'] ) ) ? sanitize_text_field( $_COOKIE['mt_opting_out'] ) : '';
if ( md5( $post_id ) === $opting ) {
update_post_meta( $post_id, '_opt_out', 'true' );
}
if ( isset( $_GET['oops'] ) && wp_verify_nonce( $_GET['oops'], 'mt_resubscribe' ) && md5( $post_id ) === $opting ) {
delete_post_meta( $post_id, '_opt_out' );
}
$template = locate_template( 'opt_out.php' );
if ( $template ) {
return $template;
} else {
$template = locate_template( 'opt-out.php' );
if ( locate_template( 'opt-out.php' ) ) {
return $template;
} else {
return __DIR__ . '/templates/opt-out.php';
}
}
}
return $template;
}