function calculate_attendee_financial_Data()
{
global $value_to_display;
// Load the ajax js in header after jquery
wp_enqueue_script('btcg-attendees-finance-data', plugin_dir_url(__FILE__) . 'js/btcg-event-attendees-finance-data.js', array('jquery'), false, false);
// Get Event ID and load the event tickets
$current_event_id = isset($_GET['event_id']) ? intval($_GET['event_id']) : 0;
//$current_event = get_post( $current_event_id );
$current_event_tickets = TribeEventsTickets::get_event_tickets($current_event_id);
// Getting Ticket Ids
$ticket_ids = array();
foreach ($current_event_tickets as $current_event_ticket) {
$ticket_ids[] = $current_event_ticket->ID;
}
// Fetching all orders and searching the ticket id in the orders
$attendees_list = TribeEventsTickets::get_event_attendees($current_event_id);
$amount_sold_online = 0;
$amount_sold_offline = 0;
foreach ($attendees_list as $attendee) {
$current_order_id = $attendee['order_id'];
$order_details = new WC_Order($current_order_id);
// Getting order detail
$current_order_items = $order_details->get_items();
// Getting line items in the order
$current_orderpayment_method = get_post_meta($current_order_id, '_payment_method', true);
// Get payment method
$offline_methods = array('bacs', 'cod', 'cheque');
$online_methods = array('paypal', 'simplify_commerce', 'authorize_net_cim_credit_card', 'authorize_net_cim_echeck');
foreach ($current_order_items as $current_order_item) {
if (in_array($current_order_item['product_id'], $ticket_ids)) {
if (in_array($current_orderpayment_method, $offline_methods)) {
$amount_sold_offline = $amount_sold_offline + $current_order_item['line_total'];
}
if (in_array($current_orderpayment_method, $online_methods)) {
$amount_sold_online = $amount_sold_online + $current_order_item['line_total'];
}
}
}
}
$value_to_display = '<strong>Online Sales:</strong> ' . wc_price($amount_sold_online) . '<br/>';
$value_to_display .= '<strong>Offline Sales:</strong> ' . wc_price($amount_sold_offline) . '<br/>';
$value_to_display .= '<strong>Gross Sales:</strong> ' . wc_price($amount_sold_offline + $amount_sold_online);
// Adding inline javascript
add_action('admin_head', 'attendees_inline_js');
}
<?php
$event_id = isset($_GET["event_id"]) ? intval($_GET["event_id"]) : 0;
$event = get_post($event_id);
$tickets = TribeEventsTickets::get_event_tickets($event_id);
?>
<div class="wrap">
<div id="icon-edit" class="icon32 icon32-tickets-attendees"><br></div>
<h2><?php
_e('Attendees', 'tribe-events-calendar');
?>
</h2>
<h2><?php
echo $event->post_title;
?>
</h2>
<div id="tribe-filters" class="metabox-holder">
<div id="filters-wrap" class="postbox">
<h3 title="Click to toggle"><?php
_e('Event Summary', 'tribe-events-calendar');
?>
</h3>
<table class="eventtable ticket_list">
<tr>
<td width="33%" valign="top">
<?php
/**
* Includes the tickets metabox inside the Event edit screen
*
* @param $post_id
*/
public function do_meta_box($post_id)
{
$startMinuteOptions = TribeEventsViewHelpers::getMinuteOptions(null);
$endMinuteOptions = TribeEventsViewHelpers::getMinuteOptions(null);
$startHourOptions = TribeEventsViewHelpers::getHourOptions(null, true);
$endHourOptions = TribeEventsViewHelpers::getHourOptions(null, false);
$startMeridianOptions = TribeEventsViewHelpers::getMeridianOptions(null, true);
$endMeridianOptions = TribeEventsViewHelpers::getMeridianOptions(null);
$tickets = TribeEventsTickets::get_event_tickets($post_id);
include $this->path . 'admin-views/tickets/meta-box.php';
}
function braintrust_class_attendee_list($post)
{
global $wpdb;
$order_id = $post->ID;
$order = new WC_Order($order_id);
$ordered_items = $order->get_items();
$tickets = TribeEventsTickets::get_event_tickets($event_id);
foreach ($ordered_items as $item_id => $values) {
$_product_id = $values['product_id'];
if (get_post_meta($_product_id, '_tribe_wooticket_for_event', true) > 0) {
$event_id = get_post_meta($_product_id, '_tribe_wooticket_for_event', true);
echo '<h3>' . __(get_the_title($event_id)) . '</h3>';
echo '<table class="wp-list-table widefat fixed attendees">';
echo '<thead>';
echo '<tr>';
echo '<th scope="col" id="btcg_attendee" class="manage-column column-btcg_attendee" style="">First Name</th>';
echo '<th scope="col" id="btcg_attendee" class="manage-column column-btcg_attendee" style="">Last Name</th>';
echo '<th scope="col" id="btcg_attendee" class="manage-column column-btcg_attendee" style="">Email</th>';
echo '<th scope="col" id="btcg_attendee" class="manage-column column-btcg_attendee" style="">Job Title</th>';
echo '<th scope="col" id="btcg_attendee" class="manage-column column-btcg_attendee" style="">Dietary Restrictions</th>';
echo '</tr>';
echo '</thead>';
$attendee_count = $values['qty'];
if ($attendee_count > 0) {
echo '<tbody id="the-list" data-wp-lists="list:attendee">';
$alternate_class = "alternate";
for ($n = 1; $n <= $attendee_count; $n++) {
$alternate_class = $n % 2 == 0 ? "" : "alternate";
echo '<tr class="' . $alternate_class . '">';
echo '<td>';
$first_name = get_post_meta($order_id, 'attendee_first_name_' . $_product_id . '_' . $n, true);
if (empty($first_name)) {
$first_name = get_post_meta($order_id, 'attendee_name_' . $_product_id . '_' . $n, true);
}
echo $first_name;
echo '</td>';
echo '<td>';
echo get_post_meta($order_id, 'attendee_last_name_' . $_product_id . '_' . $n, true);
echo '</td>';
echo '<td>';
echo get_post_meta($order_id, 'attendee_email_' . $_product_id . '_' . $n, true);
echo '</td>';
echo '<td>';
echo get_post_meta($order_id, 'attendee_job_title_' . $_product_id . '_' . $n, true);
echo '</td>';
echo '<td>';
echo get_post_meta($order_id, 'attendee_dietary_restrictions_' . $_product_id . '_' . $n, true);
echo '</td>';
echo '</tr>';
}
echo '</tbody>';
}
echo '</table>';
}
}
}
