<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; } } }