</tr>
</thead>
<?php
$date_specifc_time = epl_get_element('_epl_date_specific_time', $event_details, array());
//echo "<pre class='prettyprint'>" . __LINE__ . "> " . print_r($event_regis_data, true). "</pre>";
foreach ($event_regis_data as $date_id => $date_data) {
if ($date_data['date']['timestamp'] < 1364083200) {
continue;
}
$date = $date_data['date']['disp'];
$date_capacity = epl_get_element_m($date_id, '_epl_date_capacity', $event_details);
$times = $date_data['time'];
foreach ($times as $time_id => $time_data) {
if (epl_is_date_level_time() && !epl_is_empty_array($date_specifc_time) && (!isset($date_specifc_time[$time_id]) || !isset($date_specifc_time[$time_id][$date_id]))) {
continue;
}
$time_capacity = epl_get_element_m($time_id, '_epl_time_capacity', $event_details);
$capacity = $time_capacity ? $time_capacity : ($date_capacity ? $date_capacity : epl_get_element_m($date_id, '_epl_date_per_time_capacity', $event_details));
?>
<tr class="epl_date_time">
<td style="padding-left:38px;"><?php
echo date_i18n('D', epl_get_element($date_id, $event_details['_epl_start_date']));
?>
</td>
<td><?php
echo date_i18n('M d, Y', epl_get_element($date_id, $event_details['_epl_start_date']));
?>
</td>
/**
* This function will create a global variable called $event_snapshot, which holds all the following information about the event
* -Availability for each date, each time inside each date, each price inside each date and time.
* -Availability errors
*
* Uses global vars $event_details, $current_att_count
*
* @since 1.0.0
* @param event_id
* @param refresh
* @return Sets the global $event_snapshot variable
*/
function event_snapshot($event_id = null, $refresh = false)
{
global $event_details, $capacity, $current_att_count, $event_snapshot, $epl_error, $event_totals;
$event_id = is_null($event_id) ? $this->get_current_event_id() : $event_id;
setup_event_details($event_id);
$meta = $this->current_data[$this->regis_id];
$cart_selected_dates = epl_get_element($event_id, epl_get_element('_epl_start_date', $this->get_cart_values('_dates')));
$cart_selected_times = (array) epl_get_element($event_id, epl_get_element('_epl_start_time', $this->get_cart_values('_dates')));
$cart_selected_quantities = (array) epl_get_element($event_id, epl_get_element('_att_quantity', $this->get_cart_values('_dates')));
static $_cache = array();
$_is_cached = epl_get_element($event_id, $_cache);
if ($_is_cached) {
return $_cache[$event_id];
}
if (empty($cart_selected_dates) && epl_get_element('cart_action', $_REQUEST) != 'add') {
$epl_error[] = array('', epl__('Please select at least one date.'));
}
$current_att_count = EPL_report_model::get_instance()->get_attendee_counts($event_id, true);
$sold_out_text = apply_filters('merm__event_snapshot__sold_out_text', epl__('Sold Out.'));
//get the attendee and money totals
//$_totals = $this->calculate_cart_totals();
setup_event_details($event_id);
$grand_total = epl_get_element_m('grand_total', 'money_totals', $event_totals);
$grand_total_key = "_grand_total";
//this will hold the snapshot
$event_snapshot = array();
$qty_meta_key = "_total_att_" . $event_id;
//$total_att = array_sum( ( array ) $meta[$this->regis_id]['_dates']['_att_quantity'][$event_details['ID']] );
$total_att = epl_get_element_m($event_id, 'total', epl_get_element('_att_quantity', $event_totals));
//event dates, times and prices
$dates = epl_get_element('_epl_start_date', $event_details);
$times = epl_get_element('_epl_start_time', $event_details);
$prices = epl_get_element('_epl_price_name', $event_details);
$rolling_regis = epl_get_element('_epl_rolling_regis', $event_details) == 10;
if (epl_is_empty_array($dates)) {
return;
}
//foreach event date
foreach ($dates as $_date_key => $date_timestamp) {
$date_timestamp = epl_get_date_timestamp($date_timestamp);
//number registered for the date
$date_total_att = 0;
$_date = epl_formatted_date($event_details['_epl_start_date'][$_date_key], 'Y-m-d', 'date');
//the date to display
$_displ_date = epl_formatted_date($_date);
$qty_meta_key = "_total_att_" . $event_details['ID'] . '_date_' . $_date_key;
//find the capacity for this date.
$cap = $event_details['_epl_date_capacity'][$_date_key];
//find the number of people regitered for this date
$num_att = epl_get_element($qty_meta_key, $current_att_count, 0);
//find the available spcaes. If there is no capacity, always available
$date_avail = $this->avail_spaces($cap, $num_att);
$_past = epl_compare_dates(EPL_TIME, $_date . ' 23:59:59', ">");
$_date_avail_display = epl_is_ok_to_register($event_details, $_date_key);
$_date_avail_display = $_date_avail_display === true ? epl__('Available') : $_date_avail_display;
//snapshot template
$_t = array('timestamp' => $date_timestamp, 'disp' => $_displ_date, 'avail' => $date_avail, 'avail_display' => $_date_avail_display, 'regis' => $num_att, 'db_key' => $qty_meta_key, 'cart' => 0, 'past' => $_past, 'hide' => $date_avail != '' && $date_avail <= 0);
//Set the snapshot for this date
$event_snapshot[$event_id][$_date_key]['date'] = $_t;
$rolling_regis_time_avail = 0;
//foreach time available for the event
foreach ($times as $_time_key => $_time_id) {
$time_total_att = 0;
$_time = $event_details['_epl_start_time'][$_time_key];
$qty_meta_key = "_total_att_" . $event_details['ID'] . '_time_' . $_date_key . '_' . $_time_key;
//$cap = $capacity['time'][$_time_key];
$cap = epl_get_element($_time_key, epl_get_element('_epl_time_capacity', $event_details), '');
if ($rolling_regis && $cap == '') {
$cap = epl_get_element_m($_date_key, '_epl_date_per_time_capacity', $event_details);
}
$num_att = epl_nz(epl_get_element($qty_meta_key, $current_att_count), 0);
$time_avail = $this->avail_spaces($cap, $num_att);
$rolling_regis_time_avail += $cap == '' ? 999 : epl_nz($time_avail, 0);
$_comp_time = epl_get_element($_time_key, $event_details['_epl_regis_endtime']);
$_comp_time = !$_comp_time ? $_time : $_comp_time;
//Is this time for this date in the past and not available any more?
$_past = epl_compare_dates(EPL_TIME, $_date . ' ' . $_comp_time, ">");
if ($rolling_regis && $_past) {
$event_snapshot[$event_id][$_date_key]['date']['hide'] = true;
}
$_t = array('timestamp' => strtotime($times[$_time_key], $date_timestamp), 'disp' => $times[$_time_key], 'avail' => $time_avail, 'avail_display' => $_date_avail_display, 'regis' => $num_att, 'db_key' => $qty_meta_key, 'past' => $_past);
//Set the snapsot for this time for this date
$event_snapshot[$event_id][$_date_key]['time'][$_time_key] = $_t;
foreach ($prices as $_price_key => $_price_id) {
$_price = $event_details['_epl_price_name'][$_price_key];
$price_avail = 0;
$do_count = true;
$price_att = 0;
$price_type = epl_get_element($_price_key, epl_get_element('_epl_price_type', $event_details), 'att');
if (isset($meta['_dates']['_att_quantity'][$event_details['ID']])) {
if (is_array(epl_get_element($_price_key, $meta['_dates']['_att_quantity'][$event_details['ID']]))) {
$price_att = array_sum((array) epl_get_element($_price_key, $meta['_dates']['_att_quantity'][$event_details['ID']]));
} else {
$price_att = epl_get_element($_price_key, $meta['_dates']['_att_quantity'][$event_details['ID']]);
}
}
$qty_meta_key = "_total_att_" . $event_details['ID'] . '_price_' . $_date_key . '_' . $_time_key . '_' . $_price_key;
if (epl_is_date_level_price()) {
$price_att = epl_get_element_m($_date_key, $_price_key, $cart_selected_quantities);
}
$cap = epl_get_element($_price_key, epl_get_element('_epl_price_capacity', $event_details), '');
$num_att = epl_nz(epl_get_element($qty_meta_key, $current_att_count), 0);
$price_avail = $this->avail_spaces($cap, $num_att);
if (!epl_is_empty_array($offset = $this->is_offsetter_price($_price_key)) && $cap !== '' && $price_avail > 0) {
//check to make sure users are not using the price as offset against itself
if ($offset['offset_key'] != $_price_key) {
// see if available count of the offseter is > capacity for this price
$offset_avail = $event_snapshot[$event_id][$_date_key]['time'][$_time_key]['price'][$offset['offset_key']]['avail'];
$offset_count = $offset['offset_count'];
if ((int) $offset_count > (int) $offset_avail) {
$price_avail = 0;
} elseif ($offset_avail >= $offset_count) {
$price_avail = intval($offset_avail / $offset_count);
}
}
}
//echo "<pre class='prettyprint'>" . __LINE__ . "> $event_id >>>> " . print_r($price_avail, true). "</pre>";
$time_total_att += $price_att;
$_t = array('disp' => $prices[$_price_key], 'avail' => $price_avail, 'avail_display' => $_date_avail_display, 'regis' => $num_att, 'db_key' => $qty_meta_key, 'cart' => $price_att, 'past' => $_past);
$event_snapshot[$event_id][$_date_key]['time'][$_time_key]['price'][$_price_key] = $_t;
if (epl_is_date_level_time() && epl_get_element($_date_key, $cart_selected_times) != $_time_key) {
$do_count = false;
}
if (epl_is_date_level_price() && !in_array($_date_key, (array) $cart_selected_dates)) {
//if ( $_date_key != $_price_key ) {
$do_count = false;
//}
}
if (epl_is_time_specific_price($_price_key)) {
if ($event_details['_epl_price_parent_time_id'][$_price_key] != $_time_key) {
unset($event_snapshot[$event_id][$_date_key]['time'][$_time_key]['price'][$_price_key]);
$do_count = false;
}
}
if (!epl_is_time_optonal() && !in_array($_time_key, $cart_selected_times) || !in_array($_date_key, (array) $cart_selected_dates)) {
$do_count = false;
}
if (!$do_count || $price_type != 'att') {
$time_total_att -= $price_att;
if (isset($event_snapshot[$event_id][$_date_key]['time'][$_time_key]['price'][$_price_key]['cart'])) {
$event_snapshot[$event_id][$_date_key]['time'][$_time_key]['price'][$_price_key]['cart'] = 0;
}
} else {
//check for a price availability for each date/time
if ($price_att > 0 && $price_avail !== '') {
$_error = array();
if ($price_avail === 0 || $price_avail < 0) {
$_error = array($_displ_date . '<br />' . $_time . '<br />' . $_price, $sold_out_text);
} elseif ($price_att > epl_nz($price_avail, 1000)) {
$_error = array($_displ_date . '<br />' . $_time . '<br />' . $_price, sprintf(epl__(' Only %d spaces left.'), $price_avail));
}
if (!empty($_error)) {
$epl_error[] = $_error;
$event_snapshot[$event_id]['error'][] = $_error;
}
$event_snapshot[$event_id][$_date_key]['time'][$_time_key]['price'][$_price_key]['avail_display'] = epl_get_element(1, $_error);
}
}
/* if( $price_type != 'att' )
$time_total_att -= $price_att; */
}
$date_total_att += $time_total_att;
$event_snapshot[$event_id][$_date_key]['time'][$_time_key]['cart'] = $time_total_att;
//echo "<pre class='prettyprint'>" . __LINE__ . "> $_date " . print_r($time_total_att, true). "</pre>";
//check for time availablility for each date
if ($this->flow_mode == 'n' && !epl_is_time_optonal() && $time_total_att > 0 && ($time_avail !== '' || $event_snapshot[$event_id][$_date_key]['time'][$_time_key]['past'] === true)) {
$_error = array();
if (!epl_is_ongoing_event() && $event_snapshot[$event_id][$_date_key]['time'][$_time_key]['past'] == 1) {
$_error = array($_displ_date . '<br />' . $_time, epl__('This time has passed.'));
}
if ($time_avail === 0 || $time_avail < 0) {
$_error = array($_displ_date . '<br />' . $_time, $sold_out_text);
} elseif ($time_total_att > epl_nz($time_avail, 1000)) {
$_error = array($_displ_date . '<br />' . $_time, sprintf(epl__('Only %d spaces left.'), $time_avail));
}
if (!empty($_error)) {
$epl_error[] = $_error;
$event_snapshot[$event_id]['error'][] = $_error;
}
$event_snapshot[$event_id][$_date_key]['time'][$_time_key]['avail_display'] = epl_get_element(1, $_error);
}
}
if ($rolling_regis && $rolling_regis_time_avail == 0 && $event_snapshot[$event_id][$_date_key]['date'] == '') {
$event_snapshot[$event_id][$_date_key]['date']['hide'] = true;
}
//check for the date availability
$event_snapshot[$event_id][$_date_key]['date']['cart'] = $date_total_att;
if ($date_total_att > 0 && ($date_avail !== '' || $event_snapshot[$event_id][$_date_key]['date']['past'] === true) && (!epl_is_waitlist_approved() && !epl_is_waitlist_session_approved())) {
$_error = array();
if ($this->flow_mode == 'n' && ($date_avail === 0 || $date_avail < 0)) {
$_error = array($_displ_date, $sold_out_text);
if (epl_is_ok_for_waitlist() && ($wl_spaces_left = epl_waitlist_spaces_open()) !== false) {
$_error[1] .= '<br />' . epl__('If you would like to be added to the waiting list, please click on the button below. You will not be charged at this time.');
if ($wl_spaces_left !== true) {
$_error[1] .= '<br />' . sprintf('Spaces available on the waiting list: %d', $wl_spaces_left);
}
if (epl_waitlist_enough_spaces($event_id) == false) {
$_error[1] .= '<br />' . sprintf('To continue, please select only %d.', $wl_spaces_left);
} else {
$_error[1] .= '<br />' . epl_anchor('#', epl__('Click here to add your name to the waitlist'), null, " class='open_add_to_waitlist_form epl_button' data-event_id='{$event_id}'");
}
$this->epl->epl_util->set_response_param('waitlist_form', '');
}
} elseif ($this->flow_mode == 'n' && !epl_is_ongoing_event() && $event_snapshot[$event_id][$_date_key]['date']['past'] == 1) {
$_error = array($_displ_date, epl__('This date has passed.'));
} elseif ($this->flow_mode == 'n' && $date_total_att > epl_nz($date_avail, 1000)) {
$_error = array($_displ_date, sprintf(epl__('Only %d spaces left.'), $date_avail));
}
$event_snapshot[$event_id][$_date_key]['date']['avail_display'] = epl_get_element(1, $_error);
if (!empty($_error)) {
$event_snapshot[$event_id]['error'][] = $_error;
$epl_error[] = $_error;
}
}
//$this->epl_table->add_row( '', $event_details['_epl_start_date'][$_date_key], $avail );
}
$_cache[$event_id] = $event_snapshot;
return $event_snapshot;
}
function form_data($regis_id, $_regis_key, $event_id, $tickets_to_show = null)
{
global $event_details, $regis_details, $wpdb;
$attendee_info = $regis_details['__epl'][$_regis_key]['_attendee_info'];
if ($this->debug) {
echo "<pre class='prettyprint'>" . __LINE__ . "> " . basename(__FILE__) . " > " . print_r($attendee_info, true) . "</pre>";
}
$event_ticket_buyer_forms = array_flip(epl_get_element('_epl_primary_regis_forms', $event_details, array()));
$event_addit_forms = epl_get_element('_epl_addit_regis_forms', $event_details) ? array_flip($event_details['_epl_addit_regis_forms']) : array();
if (version_compare(epl_regis_plugin_version(), '1.4', '>=') && epl_sc_is_enabled() && epl_get_setting('epl_sc_options', 'epl_sc_forms_to_use') == 1) {
$sc_event_ticket_buyer_forms = array_flip(epl_get_setting('epl_sc_options', 'epl_sc_primary_regis_forms', array()));
$event_ticket_buyer_forms = $sc_event_ticket_buyer_forms;
// + $event_ticket_buyer_forms;
$event_addit_forms = array_flip(epl_get_setting('epl_sc_options', 'epl_sc_addit_regis_forms', array()));
}
if (empty($event_ticket_buyer_forms)) {
$event_ticket_buyer_forms = array('4e8b3920c839b' => 1);
}
/*
* find price forms if any.
*/
$price_forms = epl_get_element('_epl_price_forms', $event_details, array());
$_price_forms = array();
foreach ($price_forms as $k => $v) {
$_price_forms += $v;
}
//find the list of all forms
$available_forms = $this->ecm->get_list_of_available_forms();
$available_fields = $this->ecm->get_list_of_available_fields();
//isolate the ticket buyer forms that are selected inside the event
$ticket_buyer_forms = array_intersect_key($available_forms, $event_ticket_buyer_forms);
//isolate the additional forms for attendees.
$addit_forms = array_intersect_key($available_forms, array_merge($event_addit_forms, $_price_forms));
//This will combine all the fields in all the forms so that we can construct a header row.
$tickey_buyer_fields = array();
foreach ($ticket_buyer_forms as $_form_id => $_form_info) {
$tickey_buyer_fields = array_merge($tickey_buyer_fields, $_form_info['epl_form_fields']);
}
//combine all the fields from the attendee forms
$event_addit_fields = array();
foreach ($addit_forms as $_form_id => $_form_info) {
//$event_addit_fields += $_form_info['epl_form_fields'];
$event_addit_fields = array_merge($event_addit_fields, $_form_info['epl_form_fields']);
}
$epl_fields_inside_form = array_flip($tickey_buyer_fields);
//get the field ids inside the form
$epl_addit_fields_inside_form = array_flip($event_addit_fields);
//get the field ids inside the form
//when creating a form in form manager, the user may rearrange fields. Find their desired order
$epl_fields_to_display = $this->epl_util->sort_array_by_array($available_fields, $epl_fields_inside_form);
$epl_addit_fields_to_display = $this->epl_util->sort_array_by_array($available_fields, $epl_addit_fields_inside_form);
//final list of all the fields to display
//$epl_fields_to_display = $epl_fields_to_display + $epl_addit_fields_to_display;
$ins = array();
$ins['regis_id'] = $regis_id;
$ins['event_id'] = $event_id;
$ins['field_id'] = array();
$ins['input_slug'] = array();
$ins['value'] = array();
if (!$this->primary_pulled) {
//################################### Ticket buyer form data ############################################
if ($this->debug) {
echo "<pre class='prettyprint'>" . __LINE__ . "> " . basename(__FILE__) . " > " . print_r($epl_fields_to_display, true) . "</pre>";
}
$form_data_array_tmp = array();
foreach ($epl_fields_to_display as $field_id => $field_atts) {
//1.3 stores in [field id][event id][0]
//2.0 stores in [field id][0]
//if ( epl_sc_is_enabled() && isset( $attendee_info[$field_id][0] ) ) {
if (isset($attendee_info[$field_id][0])) {
$value = epl_get_element(0, $attendee_info[$field_id]);
} else {
$value = isset($attendee_info[$field_id]) ? epl_get_element(0, $attendee_info[$field_id][$event_id]) : '';
}
$raw_value = $value;
if ($field_atts['input_slug'] == 'email') {
$email_list[$regis_post_id] = $value;
if ($regis_post_id && $regis_post_id != $this_regis_post_id) {
unset($email_list[$regis_post_id]);
}
}
if ($field_atts['input_type'] == 'select' || $field_atts['input_type'] == 'radio') {
$value = $raw_value;
//(isset( $field_atts['epl_field_choice_text'][$value] ) && $field_atts['epl_field_choice_text'][$value] !== '') ? $field_atts['epl_field_choice_text'][$value] : $value;
} elseif ($field_atts['input_type'] == 'checkbox') {
if (!epl_is_empty_array($field_atts['epl_field_choice_value'])) {
$value = implode(',', (array) $raw_value);
} elseif (is_array($value)) {
$value = implode(',', $raw_value);
}
}
//if ( $value != '' ) {
$ins['field_id'][] = $field_id;
$ins['input_slug'][] = $field_atts['input_slug'];
$ins['form_no'] = $this->form_no;
$ins['value'][] = str_replace($this->delim, " ", $value);
//$wpdb->insert( $wpdb->epl_regis_form_data, $ins );
//}
}
$ins['field_id'] = implode($this->delim, $ins['field_id']);
$ins['input_slug'] = implode($this->delim, $ins['input_slug']);
$ins['form_no'] = $this->form_no;
$ins['value'] = implode($this->delim, $ins['value']);
if ($this->debug) {
echo "<pre class='prettyprint'>" . __LINE__ . "> " . basename(__FILE__) . " > " . print_r($ins, true) . "</pre>";
}
$wpdb->insert($wpdb->epl_regis_form_data, $ins);
//################### End Ticket Buyer Data #########################################
}
//$this->primary_pulled = true;
$ins['event_id'] = $event_id;
$ins['field_id'] = array();
$ins['input_slug'] = array();
$ins['value'] = array();
$counter = 0;
$att_counter = 1;
foreach ($tickets_to_show as $ticket_id => $ticket_quantities) {
if (is_array($ticket_quantities)) {
$tmp_price_inner_keys = array_keys($ticket_quantities);
$ticket_qty = array_sum($ticket_quantities);
}
if ($ticket_qty == 0) {
continue;
}
if (epl_is_empty_array($price_forms)) {
}
if ($this->debug) {
echo "<pre class='prettyprint'>" . __LINE__ . "> " . basename(__FILE__) . " > " . print_r($epl_addit_fields_to_display, true) . "</pre>";
}
foreach ($ticket_quantities as $ticket_qty_id => $quantities) {
if (version_compare($version, '1.2.9', '<')) {
$counter = 1;
}
for ($i = 0; $i < $quantities; $i++) {
$this->form_no++;
//not good, runs every time in the loop
/* if ( $pack_regis && $attendance_dates = epl_get_element( "_pack_attendance_dates_{$event_id}_{$ticket_id}_" . ($i + 1), $regis_data, null ) ) {
$pack_count = count( $attendance_dates );
$attendance_date_number = array_search( $date_id, array_keys( $attendance_dates ) ) + 1;
}
if ( $pack_regis && $date_id && !isset( $attendance_dates[$date_id] ) ) {
break;
continue;
} */
$ticket_label = epl_escape_csv_val(epl_get_element($ticket_id, $event_details['_epl_price_name']));
if (epl_is_date_level_price()) {
$reserved_date_key = $ticket_qty_id;
$reserved_dates = epl_get_element_m($ticket_qty_id, '_epl_start_date', $event_details);
}
if (epl_is_date_level_time()) {
$reserved_time_key = $reserved_times[$ticket_qty_id];
$reserved_times_display = epl_get_element_m($reserved_time_key, '_epl_start_time', $event_details);
}
$ins['field_id'] = array();
$ins['input_slug'] = array();
$ins['value'] = array();
foreach ($epl_addit_fields_to_display as $field_id => $field_atts) {
$value = '';
//if ( $this->debug )
// echo "<pre class='prettyprint'>" . __LINE__ . "> " . basename( __FILE__ ) . " > " . print_r( epl_get_num_events_in_cart(), true ) . "</pre>";
//new v1.2.b9+
//if ( epl_sc_is_enabled() || isset( $attendee_info[$field_id][0] ) ) { //if this, price specific forms will get the primary form vals also
if (epl_sc_is_enabled()) {
$value = epl_get_element(0, $attendee_info[$field_id]);
} else {
$value = isset($attendee_info[$field_id]) ? epl_get_element(0, $attendee_info[$field_id][$event_id]) : '';
}
if (isset($attendee_info[$field_id][$event_id][$ticket_id])) {
$value = epl_get_element($counter, $attendee_info[$field_id][$event_id][$ticket_id]);
} elseif (isset($attendee_info[$field_id][$event_id][$counter])) {
$value = $attendee_info[$field_id][$event_id][$counter];
}
$raw_value = $value;
if ($field_atts['input_type'] == 'select' || $field_atts['input_type'] == 'radio') {
$value = $raw_value;
//(isset( $field_atts['epl_field_choice_text'][$value] ) && $field_atts['epl_field_choice_text'][$value] !== '') ? $field_atts['epl_field_choice_text'][$value] : $value;
} elseif ($field_atts['input_type'] == 'checkbox') {
if (!epl_is_empty_array($field_atts['epl_field_choice_value'])) {
$value = implode(',', (array) $raw_value);
} elseif (!epl_is_empty_array($value)) {
$value = implode(',', $raw_value);
} else {
$value = html_entity_decode(htmlspecialchars_decode($value));
}
}
/* else {
$value = html_entity_decode( htmlspecialchars_decode( $value ) );
} */
// if ( $value != '' ) { //FOR NOW, WILL ENTER EMPTY ROW IN THE TABLE, WILL HELP TRACK COUNTS
$ins['field_id'][] = $field_id;
$ins['input_slug'][] = $field_atts['input_slug'];
$ins['form_no'] = $this->form_no;
$ins['value'][] = str_replace($this->delim, " ", $value);
//$wpdb->insert( $wpdb->epl_regis_form_data, $ins );
//}
}
//if ( !epl_is_empty_array( $ins['field_id'] ) ) {
// echo "<pre class='prettyprint'>" . __LINE__ . "> " . print_r($ins, true). "</pre>";
$ins['field_id'] = implode($this->delim, $ins['field_id']);
$ins['input_slug'] = implode($this->delim, $ins['input_slug']);
$ins['form_no'] = $this->form_no;
$ins['value'] = implode($this->delim, $ins['value']);
if ($this->debug) {
echo "<pre class='prettyprint'>" . __LINE__ . "> " . basename(__FILE__) . " >counter:{$counter} , ticket_id: {$ticket_id} " . print_r($ins, true) . "</pre>";
}
$wpdb->insert($wpdb->epl_regis_form_data, $ins);
//}
$counter++;
$att_counter++;
}
}
}
}
function epl_column_data($column_name, $post_ID)
{
global $epl_fields, $event_details, $event_snapshot;
$this->ecm->setup_event_details($post_ID);
$this->erm->event_snapshot($post_ID);
switch ($column_name) {
case 'id':
echo $post_ID;
break;
case 'location':
echo get_the_location_name();
break;
case 'status':
$s = epl_get_event_status(true);
$class = 'status_' . key($s);
echo "<span class='status {$class}'>" . current($s) . '</span>';
break;
/* case 'epl_categories':
foreach ( wp_get_object_terms( $id, 'epl_categories' ) as $tax )
$r[] = $tax->name;
echo!is_array( $r ) ? '' : implode( ", ", $r );
break; */
/* case 'epl_categories':
foreach ( wp_get_object_terms( $id, 'epl_categories' ) as $tax )
$r[] = $tax->name;
echo!is_array( $r ) ? '' : implode( ", ", $r );
break; */
case 'start_date':
$base_url = epl_get_url();
$event_regis_data = current($event_snapshot);
$table_link_arr = array('epl_action' => 'view_names', 'epl_download_trigger' => 1, 'table_view' => 1, 'epl_controller' => 'epl_report_manager', 'event_id' => $event_id);
$csv_link_arr = array('epl_action' => 'epl_attendee_list', 'epl_download_trigger' => 1, 'epl_controller' => 'epl_registration', 'event_id' => $event_id);
if (epl_is_empty_array($event_regis_data)) {
break;
}
$counter = 1;
foreach ($event_regis_data as $date_id => $date_data) {
$last_day = end($event_details['_epl_start_date']);
if ($last_day > EPL_DATE && ($event_details['_epl_event_status'] == 1 && $date_data['date']['timestamp'] < EPL_DATE) || $counter > 1) {
continue;
}
$counter++;
$date = $date_data['date']['disp'];
$date_capacity = epl_get_element_m($date_id, '_epl_date_capacity', $event_details);
$times = $date_data['time'];
?>
<table id="event_snapshot_table" class="event_snapshot_sorting">
<thead>
<tr>
<th><?php
epl_e('Date');
?>
</th>
<th><?php
epl_e('Time');
?>
</th>
<th><?php
epl_e('Attendees');
?>
</th>
<th></th>
</tr>
</thead>
<?php
foreach ($times as $time_id => $time_data) {
if (epl_is_date_level_time() && !epl_is_empty_array($date_specifc_time) && (!isset($date_specifc_time[$time_id]) || !isset($date_specifc_time[$time_id][$date_id]))) {
continue;
}
$time_capacity = epl_get_element_m($time_id, '_epl_time_capacity', $event_details);
$capacity = $time_capacity ? $time_capacity : ($date_capacity ? $date_capacity : epl_get_element_m($date_id, '_epl_date_per_time_capacity', $event_details));
$dt_array = array('date_id' => $date_id, 'time_id' => $time_id, 'event_id' => $post_ID);
$table_link_arr = array_merge($table_link_arr, $dt_array);
$csv_link_arr += $dt_array;
?>
<tr class="epl_date_time">
<td><?php
echo date_i18n('D M d, Y', epl_get_date_timestamp(epl_get_element($date_id, $event_details['_epl_start_date'])));
?>
</td>
<?php
if (epl_is_time_optonal()) {
?>
<td colspan="1"> - </td>
<?php
} else {
?>
<td><?php
echo $time_data['disp'];
?>
</td>
<?php
}
?>
<td><?php
echo $time_data['regis'];
?>
/ <?php
echo $capacity ? $capacity : '∞';
?>
</td>
<td>
<?php
echo epl_anchor(add_query_arg(array_merge($table_link_arr, $dt_array) + array('names_only' => 1), $base_url), epl__('View Attendees'), null, 'class="epl_view_attendee_list_table button-secondary"');
$table_link_arr['epl_action'] = 'epl_attendee_list';
$table_link_arr['epl_controller'] = 'epl_registration';
echo epl_anchor(add_query_arg($table_link_arr, $base_url), epl__('View Full Data'), null, 'class="epl_view_attendee_list_table button-secondary"');
echo epl_anchor(add_query_arg(array_merge($csv_link_arr, $dt_array), $base_url), epl__('Export CSV'), null, 'class="button-secondary"');
//echo epl_anchor( $_SERVER['PHP_SELF'] . '&epl_action=epl_event_snapshot&event_id=' . $post->ID, epl__( 'Snapshot' ), '_blank', "class='epl_event_snapshot' data-event_id = '" . $post->ID . "'" );
?>
</td>
</tr>
<?php
}
}
?>
</table>
<?php
break;
default:
break;
case 'actions':
$url_vars = array('epl_action' => 'duplicate_event', 'event_id' => $post_ID);
$url = add_query_arg($url_vars, epl_get_url());
echo " <a href='epl_action=duplicate_event&event_id={$post_ID}'><img src='" . EPL_FULL_URL . "images/status_online.png' title='" . epl__('Attendees') . "' alt='" . epl__('Attendees') . "' /></a>";
echo " <a href='epl_action=duplicate_event&event_id={$post_ID}'><img src='" . EPL_FULL_URL . "images/doc_excel_csv.png' title='" . epl__('Attendees') . "' alt='" . epl__('Attendees') . "' /></a>";
break;
}
// end switch
}
echo $date . epl_prefix(' - ', $_note) . epl_prefix(' - ', $_location);
?>
</td>
<td></td>
<td><?php
echo $show_avail_spaces ? $data['date']['avail'] : '';
?>
</td>
</tr>
<?php
foreach ($times as $time_id => $time_data) {
//if ( $time_data['avail'] !== '' ):
if (epl_get_element($time_id, epl_get_element('_epl_time_hide', $event_details)) == 0) {
if (!epl_is_date_level_time() || epl_is_date_level_time() && !epl_is_empty_array($date_specifc_time) && (array_key_exists($time_id, $date_specifc_time) && array_key_exists($date_id, $date_specifc_time[$time_id]))) {
$prices = $time_data['price'];
if (!epl_is_time_optonal()) {
?>
<tr class="epl_time">
<td><?php
echo $time_data['disp'] . epl_prefix(' - ', $event_details['_epl_end_time'][$time_id]) . epl_prefix(' - ', epl_get_element_m($time_id, '_epl_time_note', $event_details));
?>
</td>
<td></td>
<td><?php
echo $show_avail_spaces ? $time_data['avail'] : '';
?>
</td>
</tr>
<?php
function epl_daily_schedule($table = false, $email_only = false, $regis_post_id = null)
{
global $epl_fields;
$event_id = (int) $_REQUEST['event_id'];
$date_id = epl_get_element('date_id', $_REQUEST);
$time_id = epl_get_element('time_id', $_REQUEST);
$names_only = epl_get_element('names_only', $_REQUEST, 0) == 1;
$email_list = array();
//$regis_post_id = epl_get_element( 'post_ID', $_REQUEST, null );
$this->setup_event_details($event_id);
$_totals = $this->get_event_regis_snapshot($event_id);
$this->set_event_regis_post_ids($event_id, $regis_post_id);
global $event_details;
$event_title = $event_details['post_title'];
if (!$table) {
$filename = str_replace(" ", "-", $event_title) . "_" . date_i18n("m-d-Y");
//header( "Content-type: application/x-msdownload", true, 200 );
/* header( 'Content-Type: application/csv' );
header( "Content-Disposition: attachment; filename={$filename}.csv" );
header( "Pragma: no-cache" );
header( "Expires: 0" ); */
} else {
}
//$this->setup_event_details( $event_id );
//echo "<pre class='prettyprint'>" . print_r($event_details, true). "</pre>";
//find the forms that the user has selected for this event
$event_ticket_buyer_forms = array_flip((array) $event_details['_epl_primary_regis_forms']);
$event_addit_forms = epl_get_element('_epl_addit_regis_forms', $event_details) ? array_flip($event_details['_epl_addit_regis_forms']) : array();
/*
* find price forms if any.
*/
$price_forms = epl_get_element('_epl_price_forms', $event_details, array());
$_price_forms = array();
foreach ($price_forms as $k => $v) {
$_price_forms += $v;
}
//find the list of all forms
$available_forms = $this->get_list_of_available_forms();
$available_fields = $this->get_list_of_available_fields();
//isolate the ticket buyer forms that are selected inside the event
$ticket_buyer_forms = array_intersect_key($available_forms, $event_ticket_buyer_forms);
//isolate the additional forms for attendees.
$addit_forms = array_intersect_key($available_forms, array_merge($event_addit_forms, $_price_forms));
//This will combine all the fields in all the forms so that we can construct a header row.
$tickey_buyer_fields = array();
foreach ($ticket_buyer_forms as $_form_id => $_form_info) {
$tickey_buyer_fields += $_form_info['epl_form_fields'];
}
//combine all the fields from the attendee forms
$event_addit_fields = array();
foreach ($addit_forms as $_form_id => $_form_info) {
//$event_addit_fields += $_form_info['epl_form_fields'];
$event_addit_fields = array_merge($event_addit_fields, $_form_info['epl_form_fields']);
}
$epl_fields_inside_form = array_flip($tickey_buyer_fields);
//get the field ids inside the form
$epl_addit_fields_inside_form = array_flip($event_addit_fields);
//get the field ids inside the form
//when creating a form in form manager, the user may rearrange fields. Find their desired order
$epl_fields_to_display = $this->epl_util->sort_array_by_array($available_fields, $epl_fields_inside_form);
$epl_addit_fields_to_display = $this->epl_util->sort_array_by_array($available_fields, $epl_addit_fields_inside_form);
//final list of all the fields to display
$epl_fields_to_display = $epl_fields_to_display + $epl_addit_fields_to_display;
$csv_row = '';
$header_row = array();
$header_pulled = false;
$row = array();
$form_data_header = array();
$form_data = array();
//$header_row[] = '';
$header_row[] = epl__('Regis ID');
$header_row[] = epl__('Regis Date');
$header_row[] = epl__('Status');
$header_row[] = epl__('Payment Method');
$header_row[] = epl__('Total');
$header_row[] = epl__('Amount Paid');
$header_row[] = epl__('Discount Code');
$form_data_header[] = epl__('Event Date');
$form_data_header[] = epl__('Time');
$form_data_header[] = epl__('Ticket');
//get all the registration post ids for this event
$regis_ids = $this->get_event_regis_post_ids(false, $regis_post_id);
//as of 1.1, the dates are stored as timestamps.
//This will format the date for display based on the settings admin date format.
foreach ($event_details['_epl_start_date'] as $k => &$v) {
//if ( $v >= EPL_DATE )
// $v = epl_admin_date_display( $v );
//else
// unset( $event_details['_epl_start_date'][$k] );
}
$has_addit_att_forms = !epl_is_empty_array($event_details['_epl_addit_regis_forms']);
$zebra = 'odd';
//for each registration
foreach ($regis_ids as $regis_id => $att_count) {
//setup the registration details
$regis_data = $this->setup_regis_details($regis_id);
//echo "<pre class='prettyprint'>" . __LINE__ . "> " . print_r($regis_data, true). "</pre>";
//Sometime there may be incomplete db records. These will cause issues below.
//In those cases, skip and move to the next item
if (!isset($regis_data['_epl_dates']['_epl_start_date'][$event_id])) {
continue;
}
if (get_the_regis_status(null, true) <= 1) {
continue;
}
$zebra = $zebra == 'odd' ? 'even' : 'odd';
//event times and prices
//$event_times = $regis_data['_epl_dates']['_epl_start_time'][$event_id];
//$event_prices = $regis_data['_epl_dates']['_epl_start_time'][$event_id];
$disc_code_id = epl_get_element('discount_code_id', $regis_data['_epl_events'][$event_id]['money_totals']);
$disc_code = epl_get_element_m($disc_code_id, '_epl_discount_code', $event_details);
$reserved_dates = epl_get_element_m($event_id, '_epl_start_date', $regis_data['_epl_dates'], array());
$reserved_times = epl_get_element_m($event_id, '_epl_start_time', $regis_data['_epl_dates'], array());
if ($date_id && !in_array($date_id, $reserved_dates)) {
continue;
}
if ($time_id && !in_array($time_id, $reserved_times)) {
continue;
}
//this isolates the dates and times that the user has registered for
//$reserved_dates = implode( ' & ', array_intersect_key( $event_details['_epl_start_date'], array_flip( $reserved_dates ) ) );
$reserved_times_display = implode(' & ', array_intersect_key($event_details['_epl_start_time'], array_flip($reserved_times)));
//init vars
$date_labels = array();
$date_labels[0] = '';
$time_labels = array();
$time_labels[0] = '';
$ticket_labels = array();
$ticket_labels[0] = $att_count;
$purchased_tickets = (array) $regis_data['_epl_dates']['_att_quantity'][$event_id];
//?????????
$start = 1;
foreach ($purchased_tickets as $price_id => $qty) {
$_qty = is_array($qty) ? array_sum($qty) : $qty;
//current( $qty );
if ($_qty > 0) {
$date_label[] = current((array) $regis_data['_epl_dates']['_epl_start_date'][$event_id]);
if (epl_get_element('_epl_pricing_type', $event_details) == 10) {
if (in_array($event_details['_epl_price_parent_time_id'][$price_id], (array) $regis_data['_epl_dates']['_epl_start_time'][$event_id])) {
$time_labels = array_pad($time_labels, $start + $_qty, epl_get_element($event_details['_epl_price_parent_time_id'][$price_id], $event_details['_epl_start_time']));
} else {
$time_labels = array_pad($time_labels, $start + $_qty, '');
}
}
$ticket_labels = array_pad($ticket_labels, $start + $_qty, $event_details['_epl_price_name'][$price_id]);
$start += $_qty;
}
}
$_r = array();
$regis_status = isset($regis_data['_epl_regis_status']) ? $epl_fields['epl_regis_payment_fields']['_epl_regis_status']['options'][$regis_data['_epl_regis_status']] : '';
$_pm_id = EPL_Registration_model::get_instance()->setup_current_data($regis_data)->get_payment_profile_id();
$payment_method = isset($regis_data['_epl_payment_method']) && $regis_data['_epl_payment_method'] != '' ? $epl_fields['epl_regis_payment_fields']['_epl_payment_method']['options'][$_pm_id] : '';
$grand_total = epl_get_formatted_curr(epl_nz($regis_data['_epl_grand_total'], 0.0));
$amount_paid = epl_get_formatted_curr(epl_nz($regis_data['_epl_payment_amount'], 0.0));
$attendee_info = $regis_data['_epl_attendee_info'];
//################################### Ticket buyer Data ############################################
//$row[] = epl__( 'Registrant' );
if (!$has_addit_att_forms) {
$form_data[] = '';
//epl_escape_csv_val( $regis_date );
$form_data[] = '';
//$regis_time; //(epl_is_date_level_time ( ))?$regis_time:$time_labels[$i]; //
$form_data[] = '';
//epl_escape_csv_val( epl_get_element( $ticket_id, $event_details['_epl_price_name'] ) ); //$regis_price;
foreach ($epl_fields_to_display as $field_id => $field_atts) {
$value = isset($attendee_info[$field_id]) ? epl_get_element(0, $attendee_info[$field_id][$event_id]) : '';
if ($field_atts['input_slug'] == 'email') {
$email_list[$regis_id] = $value;
if ($regis_post_id && $regis_post_id != $regis_id) {
unset($email_list[$regis_id]);
}
}
if ($field_atts['input_type'] == 'select' || $field_atts['input_type'] == 'radio') {
$value = isset($field_atts['epl_field_choice_text'][$value]) && $field_atts['epl_field_choice_text'][$value] !== '' ? $field_atts['epl_field_choice_text'][$value] : $value;
} elseif ($field_atts['input_type'] == 'checkbox') {
if (!epl_is_empty_array($field_atts['epl_field_choice_value'])) {
$value = implode(',', (array) $value);
} else {
if (is_array($value)) {
$value = implode(',', array_intersect_key($field_atts['epl_field_choice_text'], array_flip((array) $value)));
}
}
}
$form_data[] = epl_escape_csv_val(html_entity_decode(htmlspecialchars_decode($value, ENT_QUOTES)));
}
$row = !$names_only ? array_merge($row, $form_data) : $form_data;
if ($table) {
$this->epl->epl_table->add_row($row, $zebra);
}
$csv_row .= implode(",", $row) . "\r\n";
$row = array();
}
//################### End Ticket Buyer Data #########################################
$tickets_to_show = array_intersect_key($purchased_tickets, $event_details['_epl_price_name']);
$counter = 1;
$att_counter = 1;
foreach ($tickets_to_show as $ticket_id => $ticket_qty) {
if (is_array($ticket_qty)) {
$tmp_price_inner_keys = array_keys($ticket_qty);
$ticket_qty = array_sum($ticket_qty);
}
if ($ticket_qty == 0) {
continue;
}
for ($i = 0; $i < $ticket_qty; $i++) {
//$row[] = ''; //epl_get_element( '_epl_addit_regis_form_counter_label', $event_details, epl__( 'Attendee' ) ) . ' ' . $att_counter;
$grand_total = '';
$amount_paid = '';
$regis_status = get_the_regis_status();
$payment_method = '';
$ticket_label = epl_escape_csv_val(epl_get_element($ticket_id, $event_details['_epl_price_name']));
if (epl_is_date_level_price()) {
$reserved_date_key = $tmp_price_inner_keys[$i];
//echo "<pre class='prettyprint'>" . __LINE__ . "> " . print_r($reserved_date_key, true). "</pre>";
//$reserved_dates = epl_get_element_m( $reserved_date_key, '_epl_start_date', $event_details );
}
if (epl_is_date_level_time()) {
$reserved_time_key = $reserved_times[$reserved_date_key];
$reserved_times_display = epl_get_element_m($reserved_time_key, '_epl_start_time', $event_details);
}
$key = $regis_id . '_' . $counter;
$form_data[$key]['att_dates'] = array_flip($reserved_dates);
$form_data[$key]['att_times'] = $reserved_times_display;
//(epl_is_date_level_time ( ))?$regis_time:$time_labels[$i]; //
$form_data[$key]['ticket'] = $ticket_label;
//$regis_price;
$form_data[$key]['regis_status'] = $regis_status;
//$regis_price;
$form_data[$key]['regis_status_id'] = get_the_regis_status(null, true);
//$regis_price;
//$form_data[] = epl_get_element('_pack_attendance_dates_2035_' . $ticket_id . '_' . ($i+1) ); //$regis_price;
$pack_dates = epl_get_element("_pack_attendance_dates_{$event_id}_{$ticket_id}_" . ($i + 1), $regis_data);
//$regis_price;
if (!epl_is_empty_array($pack_dates)) {
$form_data[$key]['att_dates'] = $pack_dates;
}
$form_data[$key]['pack_size'] = epl_get_element_m($ticket_id, '_epl_price_pack_size', $event_details);
//$regis_price;
/* form data, if any */
foreach ($epl_fields_to_display as $field_id => $field_atts) {
if (!$header_pulled) {
$form_data_header[] = epl_escape_csv_val(html_entity_decode(htmlspecialchars_decode($field_atts['label'], ENT_QUOTES)));
}
$value = '';
if (isset($attendee_info[$field_id][$event_id][$ticket_id])) {
$value = epl_get_element($counter, $attendee_info[$field_id][$event_id][$ticket_id]);
} elseif (isset($attendee_info[$field_id][$event_id][$counter])) {
$value = $attendee_info[$field_id][$event_id][$counter];
}
if ($field_atts['input_slug'] == 'first_name' || $field_atts['input_slug'] == 'last_name') {
$form_data[$key][$field_atts['input_slug']] = epl_escape_csv_val(html_entity_decode(htmlspecialchars_decode($value, ENT_QUOTES)));
}
}
$header_pulled = true;
//decode special chars (Swedish, Nordic)
$row = !$names_only ? array_merge($row, $form_data) : $form_data;
array_walk($row, create_function('&$item', 'if(!is_array($item))$item = utf8_decode($item);'));
$csv_row .= implode(",", $row) . "\r\n";
$row = array();
//$form_data = array( );
$counter++;
$att_counter++;
}
}
}
$header_row = !$names_only ? array_merge($header_row, $form_data_header) : $form_data_header;
array_walk($header_row, create_function('&$item', '$item = utf8_decode($item);'));
$header_row = array();
$header_row_pulled = false;
//placeholders
$header_row[] = '<div style="width:100px;"> </div>';
$header_row[] = '';
$header_row[] = '';
$header_row[] = '';
$header_row[] = 'Status';
if ($table) {
$tmpl = array('table_open' => '<table border="1" cellpadding="0" cellspacing="0" class="" id="epl_daily_schedule_table">');
$this->epl->epl_table->set_template($tmpl);
//$this->epl->epl_table->set_heading( $header_row );
$footer = array();
$footer[] = 'Totals';
$footer[] = '';
$footer[] = '';
$footer[] = '';
$footer[] = '';
$day_total = 0;
foreach ($form_data as $regis_id => $reg_data) {
$pack_counter = count($reg_data['att_dates']);
$start_date_key = key($reg_data['att_dates']);
$this_ticket_is_ok = false;
$display_row = array();
$display_row[] = $reg_data['ticket'];
$display_row[] = $reg_data['att_times'];
$display_row[] = $reg_data['first_name'];
$display_row[] = $reg_data['last_name'];
$display_row[] = $reg_data['regis_status'];
$counter = 1;
//if( $reg_data['regis_status'] == )
foreach ($event_details['_epl_start_date'] as $date_key => $timestamp) {
if (!isset($footer[$date_key])) {
$footer[$date_key] = 0;
}
//if ( isset( $reg_data['att_dates'][$date_key] ) ) {
if (($date_key == $start_date_key || $this_ticket_is_ok == true) && $pack_counter > 0) {
if ($reg_data['regis_status_id'] == 5) {
$footer[$date_key] += 1;
}
if ($reg_data['pack_size'] != '') {
$this_ticket_is_ok = true;
//$display_row[] = "<img src='" . EPL_FULL_URL . "images/accept.png' /><br />" . $counter . '/' . $reg_data['pack_size'];
$renew = '';
if ($reg_data['pack_size'] - $counter == 1) {
$renew = "<img src='" . EPL_FULL_URL . "images/error.png' />";
}
$display_row[] = $counter . '/' . $reg_data['pack_size'] . $renew;
$counter++;
$pack_counter--;
} else {
$display_row[] = "<img src='" . EPL_FULL_URL . "images/accept.png' />";
$this_ticket_is_ok = false;
}
} else {
$display_row[] = '';
$this_ticket_is_ok = false;
}
if (!$header_row_pulled) {
$_d = epl_admin_date_display($timestamp);
if ($timestamp < EPL_DATE) {
$header_row[] = "<span style='color:#bbb'>{$_d}</span>";
} else {
$header_row[] = $_d;
}
}
}
//$footer[] = $day_total;
//$day_total = 0;
$header_row_pulled = true;
$zebra = $reg_data['regis_status_id'] == 1 ? 'epl_incomplete' : '';
$zebra_style = $reg_data['regis_status_id'] == 1 ? 'background-color: #feffd4;' : '';
$this->epl->epl_table->add_row($display_row, $zebra, $zebra_style);
}
$this->epl->epl_table->add_row($footer);
$this->epl->epl_table->set_heading($header_row);
$t = $this->epl->epl_table->generate();
$url = admin_url("edit.php?post_type=epl_event&epl_action=epl_daily_schedule&table_view=1&epl_controller=epl_registration&event_id={$event_id}&print=1");
$print_icon = !isset($_REQUEST['print']) ? '<div><a href="' . $url . '" target="_blank"><img src="' . EPL_FULL_URL . 'images/printer.png" /></a></div>' : '';
return $print_icon . $t;
} elseif ($email_only) {
return $email_list;
} else {
echo implode(",", $header_row) . "\r\n";
echo $csv_row;
exit;
}
}
//echo epl_anchor( add_query_arg( $table_link_arr + array( 'names_only' => 1 ), $base_url ), epl__( 'View Names' ), null, 'class="epl_view_attendee_list_table button-secondary"' );
echo epl_anchor(add_query_arg($table_link_arr + array('names_only' => 1), $base_url), epl__('View All Attendees'), null, 'class="epl_view_attendee_list_table button-secondary"');
echo epl_anchor(add_query_arg($table_link_arr, $base_url), epl__('View Full Data'), null, 'class="epl_view_attendee_list_table button-secondary"');
echo epl_anchor(add_query_arg($csv_link_arr, $base_url), epl__('Export Full CSV'), null, 'class="button-secondary"');
?>
</th>
</tr>
</thead>
<tbody>
<?php
foreach ($dates as $date_id => $date) {
$date_capacity = epl_get_element_m($date_id, '_epl_date_capacity', $event_details);
foreach ($times as $time_id => $time) {
if (epl_is_date_level_time() && $date_specifc_time && (!isset($date_specifc_time[$time_id]) || !isset($date_specifc_time[$time_id][$date_id]))) {
continue;
}
$time_capacity = epl_get_element_m($time_id, '_epl_time_capacity', $event_details);
$capacity = $time_capacity ? $time_capacity : ($date_capacity ? $date_capacity : epl_get_element_m($date_id, '_epl_date_per_time_capacity', $event_details, '∞'));
$num_regis = epl_get_element("_total_att_{$event_id}_time_{$date_id}_{$time_id}", $counts, 0);
$links = '';
if ($num_regis > 0) {
$dt_array = array('date_id' => $date_id, 'time_id' => $time_id);
$table_link_arr = array_merge($table_link_arr, $dt_array);
$csv_link_arr += $dt_array;
$send_email_arr = array('epl_action' => 'get_the_email_form', 'epl_controller' => 'epl_registration', 'event_id' => $event_id, 'post_type' => false);
$links = epl_anchor(add_query_arg(array_merge($table_link_arr, $dt_array) + array('names_only' => 1), $base_url), epl__('View Attendees'), null, 'class="epl_view_attendee_list_table button-secondary"');
// $table_link_arr['epl_action'] = 'epl_attendee_list';
// $table_link_arr['epl_controller'] = 'epl_registration';
$links .= epl_anchor(add_query_arg($table_link_arr, $base_url), epl__('View Full Data'), null, 'class="epl_view_attendee_list_table button-secondary"');
function get_days_for_fc($args = array())
{
global $post;
//page specific caching
if (!epl_user_is_admin() && epl_get_setting('epl_fullcalendar_options', 'epl_fullcalendar_enable_cache', 10) == 10 && false !== ($fc_dates = get_transient('epl_transient__get_days_for_fc__' . $post->ID))) {
// return $fc_dates;
}
$show_att_counts = intval(epl_get_setting('epl_fullcalendar_options', 'epl_fullcalendar_show_att_count', 0));
if ($show_att_counts === 0) {
$show_att_counts = epl_get_element('show_att_counts', $args) === true ? true : $show_att_counts;
}
if ($show_att_counts === 1 && !epl_user_is_admin()) {
$show_att_counts = false;
}
if ($show_att_counts === 2 && !is_user_logged_in()) {
$show_att_counts = false;
}
global $event_details;
$events = $this->get_days_for_widget(3, $args);
$show_first_date_only = apply_filters('epl__get_days_for_fc__', false);
$event_bcg_color = epl_get_setting('epl_fullcalendar_options', 'epl_fullcalendar_tax_bcg_color');
$event_font_color = epl_get_setting('epl_fullcalendar_options', 'epl_fullcalendar_tax_font_color');
$r = array();
$counter = 0;
$date_sel_mode = false;
//(epl_get_element( 'date_selector', $args, 0 ) == 1);
foreach ($events as $date => $event_data) {
$data['_event'] = $event_data;
setup_event_details($event_data['event_id']);
$c = $this->epl->load_view('front/tooltip/template-1', $data, true);
$_t = explode(',', $event_data['term_list']);
$bc = epl_get_element(current($_t), $event_bcg_color, '#ffffff');
$tc = epl_get_element(current($_t), $event_font_color, 'blue');
$_r = array('title' => $date_sel_mode ? 'Select' : $event_data['title'], 'raw_title' => $event_data['title'], 'description' => $date_sel_mode ? $this->erm->get_the_dates($event_data['date_id']) : $c, 'term_list' => $event_data['term_list'], 'start_timestamp' => $event_data['date'], 'start' => epl_formatted_date($event_data['date'], 'Y-m-d'), 'end_timestamp' => $event_data['end'], 'end' => epl_formatted_date($event_data['end'], 'Y-m-d'), 'url' => $date_sel_mode ? '' : $event_data['register_link'], 'edit_url' => get_edit_post_link(), 'backgroundColor' => $bc, 'borderColor' => $bc, 'textColor' => $tc, 'className' => $event_data['register_link_type'] == 1 ? 'epl-no-modal' : '', 'id' => $event_data['event_id']);
$weekday = date('N', $event_data['date']);
//if multiple times, display the event for each time.
if (count($event_data['times']['start']) > 1 && !$date_sel_mode) {
$_tmp_title = $_r['title'];
$_tmp_url = $_r['url'];
foreach ($event_data['times']['start'] as $time_id => $time) {
if ($time == '') {
continue;
}
if (epl_is_date_level_time()) {
if (epl_is_date_specific_time($time_id) && !isset($event_details['_epl_date_specific_time'][$time_id][$event_data['date_id']])) {
continue;
}
}
$weekday_specific = epl_get_element_m($time_id, '_epl_weekday_specific_time', $event_details, array());
if (!epl_is_empty_array($weekday_specific) && !isset($weekday_specific[$weekday])) {
continue;
}
//$_r['title'] = '<span class="epl_fc_title_time"> ' . $time . '</span>' . $_tmp_title;
$_r['title'] = $_tmp_title;
$_r['raw_title'] = $_tmp_title;
if ($show_att_counts) {
$_r['title'] .= ' ' . '<span style="background-color:red;color:#fff;padding:0 4px;white-space: nowrap;"> ' . epl_get_att_count(array('for' => 'time', 'date_id' => $event_data['date_id'], 'time_id' => $time_id, 'default' => 0));
$_r['title'] .= (epl_get_time_capacity($time_id) != '' ? ' / ' . epl_get_time_capacity($time_id) : '') . '</span>';
$_r['att_counts'] = epl_get_att_count(array('for' => 'time', 'date_id' => $event_data['date_id'], 'time_id' => $time_id, 'default' => 0));
$_r['att_counts'] .= epl_get_time_capacity($time_id) != '' ? ' / ' . epl_get_time_capacity($time_id) : '';
}
$_r['url'] = $date_sel_mode ? '' : add_query_arg(array('_time_id' => $time_id), $event_data['register_link']);
$tmp_key_for_sorting = strtotime($time, $event_data['date']);
if (isset($r[$tmp_key_for_sorting])) {
$tmp_key_for_sorting .= '.' . $counter;
$counter++;
}
$_r['start'] = epl_formatted_date(strtotime($time, $event_data['date']), 'Y-m-d H:i:s');
$_r['end'] = epl_formatted_date(strtotime($event_data['times']['end'][$time_id], $show_first_date_only ? $event_data['start'] : $event_data['end']), 'Y-m-d H:i:s');
//$_r['allDay'] = false;
$r[$tmp_key_for_sorting] = $_r;
//$r[] = $_r;
$counter++;
}
continue;
} else {
$time = current($event_data['times']['start']);
//$_r['title'] = ($time != '' ? '<span class="epl_fc_title_time"> ' . $time . '</span>' : '') . $_r['title'];
$_r['title'] = $_r['title'];
if (epl_is_empty_array($event_data['times']['start'])) {
$_r['start'] = epl_formatted_date($event_data['date'] + 25200, 'Y-m-d H:i:s');
} else {
$_r['start'] = epl_formatted_date(strtotime(current($event_data['times']['start']) . ' ', $event_data['date']), 'Y-m-d H:i:s');
}
if (epl_is_empty_array($event_data['times']['end'])) {
$_r['end'] = epl_formatted_date($event_data['end'] + 86399, 'Y-m-d H:i:s');
} else {
$_r['end'] = epl_formatted_date(strtotime(current($event_data['times']['end']) . ' ', $show_first_date_only ? $event_data['start'] : $event_data['end']), 'Y-m-d H:i:s');
}
if ($show_att_counts) {
$_r['title'] .= ' ' . '<span style="background-color:red;color:#fff;padding:0 4px;white-space: nowrap;"> ' . epl_get_att_count(array('for' => 'date', 'date_id' => $event_data['date_id'], 'default' => 0));
$_r['title'] .= (epl_get_date_capacity($event_data['date_id']) != '' ? ' / ' . epl_get_date_capacity($event_data['date_id']) : '') . '</span>';
$_r['att_counts'] = epl_get_att_count(array('for' => 'date', 'date_id' => $event_data['date_id'], 'default' => 0));
$_r['att_counts'] .= epl_get_date_capacity($event_data['date_id']) != '' ? ' / ' . epl_get_date_capacity($event_data['date_id']) : '';
}
}
$tmp_key_for_sorting = strtotime(current($event_data['times']['start']) . ' ', $event_data['date']);
if (isset($r[$tmp_key_for_sorting])) {
$tmp_key_for_sorting .= '.' . $counter;
$counter++;
}
$_r['sort_time'] = $tmp_key_for_sorting;
$r[$tmp_key_for_sorting] = $_r;
//$_r = apply_filters( 'epl_get_cal_dates_response_loop', $r );
$counter++;
}
$raw = apply_filters('epl_get_cal_dates_response', $r);
ksort($raw);
//@TODO - temp solution for showing cal in the month of first avail. event
global $first_event_date;
$first_event_date = key($raw);
if (isset($args['raw'])) {
return $raw;
}
//using array_values to get rid of temp keys, fullcalendar doesn't seem to like them :)
$r = json_encode(array_values($r));
if (!epl_user_is_admin()) {
set_transient('epl_transient__get_days_for_fc__' . $post->ID, base64_encode($r), 60 * 60 * 4);
}
return $r;
}
