<h3 class="hndle"><span><?php
_e('Attendee List (PDF Export)', 'tc');
?>
</span></h3>
<div class="inside">
<table class="form-table">
<tbody>
<tr valign="top">
<th scope="row"><label for="tc_export_event_data"><?php
_e('Event', 'tc');
?>
</label></th>
<td>
<?php
$wp_events_search = new TC_Events_Search('', '', -1);
?>
<select name="tc_export_event_data">
<?php
foreach ($wp_events_search->get_results() as $event) {
$event_obj = new TC_Event($event->ID);
$event_object = $event_obj->details;
?>
<option value="<?php
echo $event_object->ID;
?>
"><?php
echo $event_object->post_title;
?>
</option>
<?php
public function show_event_tickets_left_attributes()
{
global $post;
?>
<table id="event-tickets-left-shortcode" class="shortcode-table" style="display:none">
<?php
if ($post->post_type !== 'tc_events') {
?>
<tr>
<th scope="row"><?php
_e('Event', 'tc');
?>
</th>
<td>
<select name="event_id">
<?php
$wp_events_search = new TC_Events_Search('', '', -1);
foreach ($wp_events_search->get_results() as $event) {
$event = new TC_Event($event->ID);
?>
<option value="<?php
echo esc_attr($event->details->ID);
?>
"><?php
echo $event->details->post_title;
?>
</option>
<?php
}
?>
</select>
</td>
</tr>
<?php
} else {
?>
<tr>
<th scope="row"><?php
_e('Event', 'tc');
?>
</th>
<td><?php
_e('Current Event', 'tc');
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
function tickets_info($echo = true)
{
if ($this->get_api_key_id()) {
global $wpdb;
/* $event_id = $this->get_api_event();
$query = apply_filters( 'tc_tickets_info_query', "SELECT tcp.ID, tcp.post_type, tco.post_status
FROM $wpdb->posts tcp
LEFT JOIN $wpdb->posts tco ON tcp.post_parent = tco.ID
WHERE tcp.post_type = 'tc_tickets_instances'
AND (tco.post_status = 'order_paid')
ORDER BY tco.post_date
DESC LIMIT %d
OFFSET %d
" );
$results = $wpdb->get_results(
$wpdb->prepare( $query, $this->results_per_page, (( $this->page_number - 1 ) * $this->results_per_page ) )
, OBJECT ); */
/* START OF THE NEW API */
$event_id = $this->get_api_event();
$event_ticket_types = array();
if ($event_id == 'all') {
$wp_events_search = new TC_Events_Search('', '', '', 'publish');
foreach ($wp_events_search->get_results() as $event) {
$event_obj = new TC_Event($event->ID);
$event_ticket_types = array_merge($event_ticket_types, $event_obj->get_event_ticket_types());
}
} else {
$event = new TC_Event($event_id);
$event_ticket_types = $event->get_event_ticket_types();
}
$meta_query = array('relation' => 'OR');
foreach ($event_ticket_types as $event_ticket_type) {
$meta_query[] = array('key' => 'ticket_type_id', 'value' => (string) $event_ticket_type);
}
$orders_args = array('posts_per_page' => -1, 'post_type' => apply_filters('tc_order_post_type_name', array('tc_orders')), 'post_status' => apply_filters('tc_paid_post_statuses', array('order_paid')), 'fields' => 'ids', 'cache_results' => false);
$query = new WP_Query($orders_args);
$paid_orders_ids = $query->get_posts();
$args = array('post_type' => 'tc_tickets_instances', 'post_status' => 'publish', 'meta_query' => $meta_query, 'posts_per_page' => $this->results_per_page, 'offset' => ($this->page_number - 1) * $this->results_per_page, 'post_parent__in' => $paid_orders_ids);
$results = get_posts($args);
/* END OF THE NEW API */
$results_count = 0;
foreach ($results as $result) {
$ticket_instance = new TC_Ticket_Instance($result->ID);
$ticket_type = new TC_Ticket($ticket_instance->details->ticket_type_id);
//$ticket_type_event_id = get_post_meta( apply_filters( 'tc_ticket_type_id', $ticket_type->details->ID ), apply_filters( 'tc_event_name_field_name', 'event_name' ), true );
$order = new TC_Order($ticket_instance->details->post_parent);
$continue = false;
if (in_array($order->details->post_status, apply_filters('tc_paid_post_statuses', array('order_paid')))) {
$order_is_paid = true;
} else {
$order_is_paid = false;
}
$order_is_paid = apply_filters('tc_order_is_paid', $order_is_paid, $order->details->ID);
if ($order_is_paid) {
/* OLD */
$check_ins = get_post_meta($ticket_instance->details->ID, 'tc_checkins', true);
$checkin_date = '';
if (!empty($check_ins)) {
foreach ($check_ins as $check_in) {
$checkin_date = tc_format_date($check_in['date_checked']);
}
}
$r['date_checked'] = $checkin_date;
$r['payment_date'] = tc_format_date(strtotime($order->details->post_modified));
//date_i18n( get_option( 'date_format' ) . ' ' . get_option( 'time_format' ), strtotime( $order->details->post_modified ), false )
$r['transaction_id'] = $ticket_instance->details->ticket_code;
$r['checksum'] = $ticket_instance->details->ticket_code;
$buyer_full_name = isset($order->details->tc_cart_info['buyer_data']['first_name_post_meta']) ? $order->details->tc_cart_info['buyer_data']['first_name_post_meta'] . ' ' . $order->details->tc_cart_info['buyer_data']['last_name_post_meta'] : '';
$buyer_email = isset($order->details->tc_cart_info['buyer_data']['email_post_meta']) ? $order->details->tc_cart_info['buyer_data']['email_post_meta'] : '';
if (!empty($ticket_instance->details->first_name) && !empty($ticket_instance->details->last_name)) {
$r['buyer_first'] = $ticket_instance->details->first_name;
$r['buyer_last'] = $ticket_instance->details->last_name;
} else {
$r['buyer_first'] = apply_filters('tc_ticket_checkin_buyer_first_name', $order->details->tc_cart_info['buyer_data']['first_name_post_meta'], $order->details->ID);
$r['buyer_last'] = apply_filters('tc_ticket_checkin_buyer_last_name', $order->details->tc_cart_info['buyer_data']['last_name_post_meta'], $order->details->ID);
}
$r['custom_fields'] = array(array(apply_filters('tc_ticket_checkin_custom_field_title', 'Ticket Type'), apply_filters('tc_checkout_owner_info_ticket_title', $ticket_type->details->post_title, $ticket_type->details->ID)), array(apply_filters('tc_ticket_checkin_custom_field_title', 'Buyer Name'), apply_filters('tc_ticket_checkin_buyer_full_name', $buyer_full_name, $order->details->ID)), array(apply_filters('tc_ticket_checkin_custom_field_title', 'Buyer E-mail'), apply_filters('tc_ticket_checkin_buyer_email', $buyer_email, $order->details->ID)));
$r['custom_fields'] = apply_filters('tc_checkin_custom_fields', $r['custom_fields'], $result->ID, $event_id, $order, $ticket_type);
$r['custom_field_count'] = count($r['custom_fields']);
$r['address'] = '';
if ($r['address'] == '') {
$r['address'] = 'N/A';
}
$r['city'] = '';
if ($r['city'] == '') {
$r['city'] = 'N/A';
}
$r['state'] = '';
if ($r['state'] == '') {
$r['state'] = 'N/A';
}
$r['country'] = '';
if ($r['country'] == '') {
$r['country'] = 'N/A';
}
$rows[] = array('data' => $r);
/* END OLD */
$results_count++;
}
}
$additional['results_count'] = $results_count;
$rows[] = array('additional' => $additional);
echo json_encode($rows);
exit;
}
}
} else {
$message = __('You do not have required persmissions for this action.', 'tc');
}
}
}
if (isset($_GET['page_num'])) {
$page_num = (int) $_GET['page_num'];
} else {
$page_num = 1;
}
if (isset($_GET['s'])) {
$eventssearch = $_GET['s'];
} else {
$eventssearch = '';
}
$wp_events_search = new TC_Events_Search($eventssearch, $page_num, '', isset($_GET['post_status']) ? $_GET['post_status'] : 'any');
$fields = $events->get_event_fields();
$columns = $events->get_columns();
?>
<div class="wrap tc_wrap">
<h2><?php
echo $events->form_title;
if (isset($_GET['action']) && $_GET['action'] == 'edit') {
?>
<a href="admin.php?page=<?php
echo $_GET['page'];
?>
" class="add-new-h2"><?php
_e('Add New', 'tc');
?>
</a><?php
function tc_get_events($field_name = '', $post_id = '')
{
$wp_events_search = new TC_Events_Search('', '', '-1');
if ($post_id !== '') {
$currently_selected = get_post_meta($post_id, $field_name, true);
} else {
$currently_selected = '';
}
?>
<select name="<?php
echo $field_name;
?>
_post_meta">
<?php
foreach ($wp_events_search->get_results() as $event) {
$event_obj = new TC_Event($event->ID);
$event_object = $event_obj->details;
?>
<option value="<?php
echo $event_object->ID;
?>
" <?php
selected($currently_selected, $event_object->ID, true);
?>
><?php
echo apply_filters('tc_event_select_name', $event_object->post_title, $event_object->ID);
?>
</option>
<?php
}
?>
</select>
<?php
}
function get_event_essentials($echo = true)
{
if ($this->get_api_key_id()) {
$event_id = $this->get_api_event();
$event_ticket_types = array();
if ($event_id == 'all') {
$wp_events_search = new TC_Events_Search('', '', '', 'publish');
foreach ($wp_events_search->get_results() as $event) {
$event_obj = new TC_Event($event->ID);
$event_ticket_types = array_merge($event_ticket_types, $event_obj->get_event_ticket_types());
}
} else {
$event = new TC_Event($event_id);
$event_ticket_types = $event->get_event_ticket_types();
}
$event_tickets_total = 0;
$event_checkedin_tickets = 0;
$meta_query = array('relation' => 'OR');
foreach ($event_ticket_types as $event_ticket_type) {
$meta_query[] = array('key' => 'ticket_type_id', 'value' => (string) $event_ticket_type);
}
$args = array('post_type' => 'tc_tickets_instances', 'post_status' => 'any', 'posts_per_page' => -1, 'meta_query' => $meta_query);
$ticket_instances = get_posts($args);
$tickets_sold = 0;
foreach ($ticket_instances as $ticket_instance) {
$order = new TC_Order($ticket_instance->post_parent);
if ($order->details->post_status == 'order_paid') {
$tickets_sold++;
}
$checkins = get_post_meta($ticket_instance->ID, 'tc_checkins', true);
if (isset($checkins) && is_array($checkins)) {
$event_checkedin_tickets++;
}
}
$event_tickets_total = $tickets_sold;
$data = array('event_name' => $event_id == 'all' ? __('Multiple Events', 'tc') : stripslashes($event->details->post_title), 'event_date_time' => $event_id == 'all' ? __('N/A', 'tc') : date_i18n(get_option('date_format') . ' ' . get_option('time_format'), strtotime($event->details->event_date_time), false), 'event_location' => $event_id == 'all' ? __('N/A', 'tc') : stripslashes($event->details->event_location), 'event_logo' => $event_id == 'all' ? __('N/A', 'tc') : stripslashes($event->details->event_logo_file_url), 'event_sponsors_logos' => $event_id == 'all' ? __('N/A', 'tc') : stripslashes($event->details->sponsors_logo_file_url), 'sold_tickets' => $event_tickets_total, 'checked_tickets' => $event_checkedin_tickets, 'pass' => true);
$json = json_encode(apply_filters('tc_get_event_essentials_data_output', $data, $event_id));
if ($echo) {
echo $json;
exit;
} else {
return $json;
}
}
}
