function regis_list_page()
{
global $wpdb, $event_details, $regis_details;
global $event_details;
$this->eum = $this->epl->load_model('epl-user-model');
$this->epl->load_model('epl-report-model');
$data['user_bookings'] = $this->eum->user_bookings($args);
$data['content'] = $this->epl->load_view('user-regis-manager/user-bookings', $data, true);
$this->epl->load_view('admin/user-regis-manager/admin-urm-page', $data);
return null;
$registrations = $wpdb->get_results("\n SELECT umeta_id,user_id,meta_key,meta_value\n FROM {$wpdb->usermeta}\n WHERE meta_key like '_epl_regis_post_id%'\n\t\tAND user_id = {$this->user_id}");
$r = array();
$this->erm->dest = 'admin';
$this->erm->on_admin = true;
$this->erm->set_mode('overview');
$data['registrations'] = '';
foreach ($registrations as $registration) {
$r_id = str_replace('_epl_regis_post_id_', '', $registration->meta_key);
//$this->ecm->get_registration_details($r_id);
$regis_data = $this->ecm->setup_regis_details($r_id, true);
if ($regis_data['post_status'] != 'publish') {
continue;
}
$d = epl_get_element('__epl', $regis_data);
$data['regis_post_id'] = $r_id;
$data['regis_id'] = esc_attr($regis_data['post_title']);
$data['regis_date'] = epl_formatted_date($regis_data['post_title']);
$data['regis_status'] = get_the_regis_status();
foreach ($d as $k => $v) {
$_regis_id = $d['_regis_id'];
$_events = $d[$_regis_id]['_events'];
$_dates = $d[$_regis_id]['_dates']['_epl_start_date'];
$event_id = key($_events);
$this->ecm->setup_event_details($event_id);
$data['event_title'] = esc_attr($event_details['post_title']);
$data['regis_dates'] = array_intersect_key($event_details['_epl_start_date'], array_flip($_dates[$event_id]));
$data['list'] = $this->epl->load_view('admin/user-regis-manager/user-regis-dates', $data, true);
}
$this->erm->setup_current_data($regis_data);
$data['regis_form'] = $this->erm->regis_form(null);
$data['registrations'] .= $this->epl->load_view('admin/user-regis-manager/user-regis-list-page', $data, true);
}
return $this->epl->load_view('admin/user-regis-manager/user-regis-list-page-wrapper', $data, true);
}
<?php
global $event_details, $session_signed_in_counts, $user_session_signed_in_counts, $user_ticket_use_counts;
$erptm = EPL_report_model::get_instance();
$avail_fields = epl_get_list_of_available_fields();
$default_row = array_fill_keys(array_keys($avail_fields), null);
$tmpl = array('table_open' => '<table border="1" cellpadding="0" cellspacing="0" class="epl_standard_table" id="epl_daily_session_registrants">');
$this->epl->epl_table->set_template($tmpl);
$header = array(epl__('Regis ID'), epl__('Status'), epl__('Purchase'), epl__('Package'), epl__('Use Count'));
foreach ($registrants as $row) {
setup_event_details($row->event_id);
$time_optional = epl_is_time_optonal();
$time_id = $time_optional ? '' : $row->time_id;
$session_time_id = $time_optional ? epl_get_element('time_id', $_POST, '') : $row->time_id;
$_r = array();
$_r['regis_key'] = epl_anchor(admin_url('post.php?post=' . $row->regis_id . '&action=edit'), $row->regis_key);
$_r['status'] = get_the_regis_status($row->status);
$_r['ticket'] = $event_details['_epl_price_name'][$row->price_id];
$_r['package'] = '-';
$user_ticket_use_count_key = "{$row->regis_id}-{$row->event_id}-{$row->date_id}-{$time_id}-{$row->price_id}-{$row->user_id}";
$_r['use_count'] = epl_get_element($user_ticket_use_count_key, $user_ticket_use_counts, 0);
$user_session_use_count_key = "{$row->regis_id}-{$row->event_id}-{$row->date_id}-{$_POST['date_ts']}-{$_POST['time_id']}-{$row->price_id}-{$row->user_id}";
$user_alredy_checked_in = epl_get_element($user_session_use_count_key, $user_session_signed_in_counts, false);
if (epl_is_pack_regis()) {
$pack_size = epl_get_element_m($row->price_id, '_epl_price_pack_size', $event_details, 1);
$exp = '';
if (epl_get_element_m($row->price_id, '_epl_price_pack_type', $event_details) == 'time') {
$mem_l = epl_get_element_m($row->price_id, '_epl_price_pack_time_length', $event_details);
$mem_lt = epl_get_element_m($row->price_id, '_epl_price_pack_time_length_type', $event_details);
$start = strtotime($row->regis_date);
$until = strtotime("+ {$mem_l} {$mem_lt}", $start);
if ($until < EPL_DATE) {
function epl_is_waitlist_record()
{
global $epl_is_waitlist_flow, $regis_details;
return get_the_regis_status(null, true) == 20;
}
if (!epl_is_empty_array($show_only)) {
$default_row = $show_only;
$limited = true;
}
$tmp_regis_id = '';
//echo "<pre class='prettyprint'>" . __LINE__ . "> " . print_r($list, true). "</pre>";
//using while so we can move internal pointer
//while ( list($key, $row) = each( $list ) ) {
foreach ($list as $row) {
setup_event_details($row->event_id, true);
$_combned = array();
$_p = array();
$_a = array();
$_combned['regis_key'] = epl_anchor(admin_url('post.php?post=' . $row->regis_id . '&action=edit'), $row->regis_key);
$_combned['regis_date'] = date('m/d/Y', strtotime($row->regis_date));
$_combned['status'] = get_the_regis_status($row->status);
$_p['event_name'] = '';
$_p['ticket'] = '';
$_p['discount_code'] = $row->discount_code;
$_p['price'] = $row->grand_total;
$_p['paid'] = $row->payment_amount == 0 ? 0 : $row->payment_amount > $row->event_total ? $row->event_total : $row->payment_amount;
$_p['date'] = '';
$_p['time'] = '';
$_a['event_name'] = $event_details['post_title'];
$_a['ticket'] = $event_details['_epl_price_name'][$row->price_id] . ' ' . $row->price;
$_a['discount_code'] = '';
$_a['price'] = '';
$_a['paid'] = '';
$_a['date'] = epl_formatted_date($event_details['_epl_start_date'][$row->date_id]);
$_a['time'] = $event_details['_epl_start_time'][$row->time_id];
if ($tmp_regis_id == '' || $tmp_regis_id != $row->regis_id) {
?>
</td>
<td><?php
echo $payment_method . ' ' . epl_get_element('_epl_cc_type', $regis_details);
?>
</td>
<td><?php
echo $regis_details['_epl_transaction_id'];
?>
</td>
<td class="epl_status_<?php
echo $regis_details['_epl_regis_status'];
?>
"><?php
echo get_the_regis_status();
?>
</td>
</tr>
<?php
}
}
?>
<tfoot>
<tr>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
function attendee_list_table($args = array())
{
$defaults = array('event_id' => epl_get_element('event_id', $_REQUEST));
$args = wp_parse_args($args, $defaults);
extract($args);
global $event_details;
$this->ecm->set_event_regis_post_ids($event_id);
//$event_id = ( int ) (!isset( $args['event_id'] ) ? $_REQUEST['event_id'] : $event_id);
$_totals = $this->ecm->get_event_regis_snapshot($event_id);
//if ( epl_is_empty_array( $event_details ) )
$this->ecm->setup_event_details($event_id);
$display = epl_get_element('_epl_show_attendee_list_template', $event_details, 'attendee-list-1');
if (epl_get_element('_epl_show_attendee_list_link', $event_details, 0) == 0 && !current_user_can('manage_options')) {
return null;
}
$event_ticket_buyer_forms = array_flip((array) $event_details['_epl_primary_regis_forms']);
$event_addit_forms = isset($event_details['_epl_addit_regis_forms']) && $event_details['_epl_addit_regis_forms'] != '' ? array_flip($event_details['_epl_addit_regis_forms']) : array();
//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 forms that are selected inside the event
$ticket_buyer_forms = array_intersect_key($available_forms, $event_ticket_buyer_forms);
$addit_forms = array_intersect_key($available_forms, $event_addit_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'];
}
$event_addit_fields = array();
foreach ($addit_forms as $_form_id => $_form_info) {
$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, $event_details['_epl_attendee_list_field']);
$epl_addit_fields_to_display = $this->epl_util->sort_array_by_array($available_fields, $event_details['_epl_attendee_list_field']);
$epl_fields_to_display = $epl_fields_to_display + $epl_addit_fields_to_display;
$csv_row = '';
$list = array();
$header_row = array();
$header_pulled = false;
$row = array();
//$header_row[] = '';
//$header_row[] = epl__( 'Regis Date' );
//$header_row[] = epl__( 'Event Date' );
//$header_row[] = epl__( 'Time' );
$regis_ids = $this->ecm->get_event_regis_post_ids(false);
//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 )
// $v = epl_admin_date_display( $v );
foreach ($regis_ids as $regis_id => $att_count) {
//$regis_data = $this->ecm->get_post_meta_all( $regis_id );
$regis_data = $this->ecm->setup_regis_details($regis_id, true);
//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 (($startus = get_the_regis_status(null, true)) && $startus <= 1 || $startus > 5) {
continue;
}
$event_times = $regis_data['_epl_dates']['_epl_start_time'][$event_id];
//$event_prices = $regis_data['_epl_dates']['_epl_start_time'][$event_id];
$regis_date = implode(' & ', array_intersect_key(epl_get_element('_epl_start_date', $event_details, array()), array_flip((array) $regis_data['_epl_dates']['_epl_start_date'][$event_id])));
$regis_time = implode(' & ', array_intersect_key(epl_get_element('_epl_start_time', $event_details, array()), array_flip((array) $regis_data['_epl_dates']['_epl_start_time'][$event_id])));
$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];
$attendee_info = $regis_data['_epl_attendee_info'];
$start = 1;
foreach ($purchased_tickets as $price_id => $qty) {
if ($event_details['_epl_price_type'][$price_id] != 'att') {
continue;
}
$_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();
$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));
$tickets_to_show = array_intersect_key($purchased_tickets, $event_details['_epl_price_name']);
$att_counter = 1;
$counter = 0;
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++) {
if ($i == 0 && !epl_is_empty_array($event_addit_forms)) {
//continue;
//$row[] = epl__( 'Registrant' );
} else {
//$row[] = epl__( 'Attendee' );
$grand_total = '';
$amount_paid = '';
$regis_status = '';
$payment_method = '';
}
foreach ($epl_fields_to_display as $field_id => $field_atts) {
if (!$header_pulled) {
$header_row[] = html_entity_decode(htmlspecialchars_decode($field_atts['label'], ENT_QUOTES));
}
$value = '';
//new v1.2.b9+
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_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);
} elseif (!epl_is_empty_array($value)) {
$value = implode(',', array_intersect_key($field_atts['epl_field_choice_text'], array_flip($value)));
} else {
$value = html_entity_decode(htmlspecialchars_decode($value));
}
}
/* else {
$value = html_entity_decode( htmlspecialchars_decode( $value ) );
} */
$row[] = html_entity_decode(htmlspecialchars_decode($value, ENT_QUOTES));
}
$header_pulled = true;
//decode special chars (Swedish, Nordic)
//array_walk( $row, create_function( '&$item', '$item = utf8_decode($item);' ) );
if (!epl_is_empty_array($row)) {
$list[$regis_id]['att_count'] = $att_count;
$list[$regis_id]['attendees'][] = $row;
//$this->epl->epl_table->add_row( $row );
}
//$csv_row .= implode( ",", $row ) . "\r\n";
$row = array();
$counter++;
$att_counter++;
}
}
$counter = 0;
}
//$tmpl = array( 'table_open' => '<table cellpadding="2" cellspacing="0" border="1" class="event_attendee_list_table">' );
$data['event_title'] = epl_format_string($event_details['post_title']);
$data['header_row'] = $header_row;
$data['list'] = $list;
return $this->epl->load_view('front/attendee-list/' . $display, $data, true);
}
<?php
global $event_details;
$epl = EPL_Base::get_instance();
//echo "<pre class='prettyprint'>" . __LINE__ . "> " . print_r($list, true). "</pre>";
foreach ($list as $k => $v) {
setup_event_details($v->event_id);
$arr = array($v->regis_key, get_the_regis_status($v->status), $event_details['post_title'], epl_formatted_date($event_details['_epl_start_date'][$v->date_id]), $event_details['_epl_start_time'][$v->time_id], $event_details['_epl_price_name'][$v->price_id], $v->quantity);
$epl->epl_table->add_row($arr);
}
echo $epl->epl_table->generate();
$date_capacity = epl_get_element_m($regis->date_id, '_epl_date_capacity', $event_details, '∞');
//if there is time capacity, grab that or default to date capacity
$capacity = epl_get_element_m($regis->time_id, '_epl_time_capacity', $event_details, $date_capacity);
//get counts for this event, cached
$counts = $erptm->get_attendee_counts($event_id);
//count date specific key
$counts_day_key = $event_id . "_time_{$regis->date_id}";
//counts time specific key
$counts_time_key = $event_id . "_time_{$regis->date_id}_{$regis->time_id}";
//if count for that time exists, get num regis, defaults to 0
$num_regis = epl_get_element('_total_att_' . $counts_time_key, $counts, 0);
$url_params['epl_token'] = epl_get_token($regis->regis_id . $regis->regis_date);
$regis_summary_url = add_query_arg($url_params, get_permalink($regis->regis_id));
$pdf_url = array('epl_action' => 'invoice', 'regis_id' => $regis->regis_id, 'epl_token' => epl_get_token($regis->regis_id . $regis->regis_date));
$pdf_url = add_query_arg($pdf_url, home_url());
$arr = array($regis->regis_key, epl_formatted_date($regis->regis_date), epl_formatted_date($event_details['_epl_start_date'][$regis->date_id], 'D'), epl_formatted_date($event_details['_epl_start_date'][$regis->date_id]), $event_details['_epl_start_time'][$regis->time_id], $event_details['post_title'], $regis->ticket_count, get_the_regis_status($regis->status), epl_anchor($regis_summary_url, epl__('Details')) . ' ' . (!$attach_pdf || epl_get_element('_epl_attach_invoice', $event_details, 10) == 0 ? '' : epl_anchor($pdf_url, epl__('PDF'))));
echo '<tr><td>' . implode('</td><td>', $arr) . '</td></tr>';
}
?>
</tbody>
</table>
<?php
} else {
?>
<div><?php
epl_e('No Registrations');
?>
</div>
<?php
function wildcard_lookup($lookup, $limit = 5)
{
global $wpdb, $regis_details;
$lookup = $wpdb->escape($lookup);
$s_key = explode('-', epl_get_element('s_key', $_REQUEST, false));
$filter_event_id = $s_key[0];
$q = $wpdb->get_results("SELECT p.ID, p.post_title,p.post_date, pm.meta_key, pm.meta_value \n FROM {$wpdb->postmeta} pm \n JOIN {$wpdb->posts} p \n ON p.ID = pm.post_id \n WHERE meta_key='__epl' \n AND p.post_status ='publish' \n AND meta_value like '%{$lookup}%' \n ORDER BY meta_id DESC LIMIT {$limit}");
$_r = array();
$data = array();
$r = '';
$available_fields = $this->get_list_of_available_fields();
foreach ($q as $row) {
setup_regis_details($row->ID);
$regis_data = maybe_unserialize($row->meta_value);
$regis_id = $regis_data['_regis_id'];
if ($filter_event_id && !isset($regis_data[$regis_id]['_events'][$filter_event_id])) {
continue;
}
$event_id = $filter_event_id;
setup_event_details($filter_event_id);
$form_data = maybe_unserialize($regis_data[$regis_id]['_attendee_info']);
$first_name = $this->get_attendee_form_value('ticket_buyer', 'first_name', $form_data, true);
$last_name = $this->get_attendee_form_value('ticket_buyer', 'last_name', $form_data);
$email = $this->get_attendee_form_value('ticket_buyer', 'email', $form_data);
$found = false;
switch ($lookup) {
case stripos($first_name, $lookup) !== false:
$found = true;
break;
case stripos($last_name, $lookup) !== false:
$found = true;
break;
case stripos($email, $lookup) !== false:
$found = true;
break;
}
//if (!$found) continue;
$t = $this->get_purchased_tickets($regis_id, $event_id);
$data['r'] = array('regis_date' => $row->post_date, 'regis_post_id' => $row->ID, 'event_id' => $event_id, 'regis_id' => $regis_id, 'first_name' => $first_name, 'last_name' => $last_name, 'email' => $email, 'form_data' => $form_data, 'available_fields' => $available_fields, 'tickets' => $t, 'regis_status' => get_the_regis_status(), 'regis_user_id' => $regis_details['_epl_regis_user_id']);
$r .= $this->epl->load_view('admin/user-regis-manager/regis-name-lookup-result-rows', $data, true);
}
$data['r'] = $r;
$r = $this->epl->load_view('admin/user-regis-manager/regis-name-lookup-result-response', $data, true);
return $r;
return $this->epl_util->epl_response(array('html' => $r));
}
function get_the_email_addresses($filter = null, $regis_id = null)
{
global $wpdb, $event_details;
$this->WHERE = ' AND r.status between 2 and 5 ';
$arr = array('regis_id' => !is_null($regis_id) ? $regis_id : epl_get_element('post_ID', $_REQUEST, false), 'event_id' => $_REQUEST['event_id'], 'date_id' => epl_get_element('date_id', $_REQUEST, null), 'time_id' => epl_get_element('time_id', $_REQUEST, null), 'names_only' => epl_get_element('names_only', $_REQUEST, 0));
setup_event_details($arr['event_id']);
$data['pack_regis'] = epl_get_element('_epl_pack_regis', $event_details, 0) == 10;
$_filter = array();
if ($data['pack_regis']) {
//find all the registrations for this event
//for each one, find out if package
//for each one that is pack, find the pack * X days
//contstruct array
$event_date_keys = array_keys($event_details['_epl_start_date']);
$pack_counts = epl_get_element('_epl_price_pack_size', $event_details, array());
$registrations = $wpdb->get_results("SELECT * FROM {$wpdb->epl_regis_data} WHERE event_id = " . intval($event_details['ID']));
if ($registrations) {
foreach ($registrations as $regis) {
$regis_weekday = date('N', $event_details['_epl_start_date'][$regis->date_id]);
if (isset($pack_counts[$regis->price_id])) {
$pack_counter = epl_get_element($regis->price_id, $pack_counts, 1);
$start = false;
foreach ($event_details['_epl_start_date'] as $date_id => $date) {
if (!$start && $date_id != $regis->date_id) {
continue;
}
$start = true;
$_weekday = date('N', $date);
if ($regis_weekday != $_weekday || $pack_counter == 0) {
continue;
}
$pack_counter--;
$attendance_dates[$regis->id][$date_id] = $date;
$_filter[$regis->id] = $regis->id;
}
if ($arr['date_id'] && !isset($attendance_dates[$regis->id][$arr['date_id']]) || $arr['time_id'] && $arr['time_id'] != $regis->time_id) {
unset($_filter[$regis->id]);
unset($attendance_dates[$regis->id]);
}
//$offset = array_search( $regis->date_id, $event_date_keys );
//$attendance_dates[$regis->id] = array_slice( $event_details['_epl_start_date'], $offset, $pack_counts[$regis->price_id] );
}
}
}
}
$_filter = implode(',', $_filter);
if ($_filter != '') {
$_filter = " AND rd.id IN ({$_filter})";
}
if (($regis_id = epl_get_element('post_ID', $_REQUEST, $arr['regis_id'])) !== false) {
$this->WHERE = ' AND r.status between 1 and 5 ';
$this->WHERE .= ' AND r.regis_id =' . $wpdb->escape($regis_id);
}
if (($_event_id = epl_get_element('event_id', $_REQUEST, false)) !== false) {
$this->WHERE .= ' AND rd.event_id =' . $wpdb->escape($_event_id);
}
if (!$_filter && ($_date_id = epl_get_element('date_id', $_REQUEST, false)) !== false) {
$this->WHERE .= ' AND rd.date_id ="' . $wpdb->escape($_date_id) . '"';
}
if (!$_filter && ($_time_id = epl_get_element('time_id', $_REQUEST, false)) !== false) {
$this->WHERE .= ' AND rd.time_id ="' . $wpdb->escape($_time_id) . '"';
}
$form_to_look_at = 'AND rf.form_no = 0';
$who_to_email = epl_get_setting('epl_registration_options', 'epl_send_customer_confirm_message_to', 1);
if ($who_to_email == 2 || !epl_has_primary_forms()) {
$form_to_look_at = '';
}
$q = $wpdb->get_results("SELECT\r\n r.regis_id, r.status, r.regis_key, rd.event_id, rf.field_id, rf.form_no, rf.input_slug, rf.value\r\n \r\n FROM {$wpdb->epl_regis_data} rd\r\n INNER JOIN {$wpdb->epl_registration} r\r\n ON r.regis_id = rd.regis_id\r\n INNER JOIN {$wpdb->epl_regis_form_data} rf\r\n ON (rd.regis_id = rf.regis_id AND rd.event_id = rf.event_id)\r\n WHERE 1=1 \r\n {$this->WHERE} {$form_to_look_at} {$_filter}\r\n GROUP BY rf.value\r\n ORDER BY r.regis_date, rd.id\r\n ");
$email_list = array('raw_list' => array(), 'display_list' => '');
$num_emails = 0;
if ($q) {
foreach ($q as $row) {
setup_event_details($row->event_id);
//Redundant. But on line 280, from the registration list individual email, event id is not available.
if ($who_to_email == 1 && (epl_has_primary_forms() && $row->form_no > 0)) {
continue;
}
$d = $this->get_form_data_array($row->input_slug, $row->value);
if ($d['email'] == '') {
continue;
}
//if ( !is_array( $email_list['display_list'][$row->regis_id] ) )
// $email_list['display_list'][$row->regis_id] = array();
$this->epl_table->add_row('<input type="checkbox" id="" name="to_emails[' . $row->regis_id . '][]" class="regis_status_' . $row->status . '" style="" value="' . $d['email'] . '" checked="checked">', $d['email'], $d['first_name'] . ' ' . $d['last_name'], epl_anchor(admin_url('post.php?post=' . $row->regis_id . '&action=edit'), $row->regis_key), get_the_regis_status($row->status));
$num_emails++;
//$email_list['display_list'][$row->regis_id] = $d['email'] . epl_prefix( ', ', $d['first_name'] . ' ' . $d['last_name'] ) . ', ' . epl_anchor( admin_url( 'post.php?post=' . $row->regis_id . '&action=edit' ), $row->regis_key ) . ', ' . get_the_regis_status( $row->status );
$email_list['raw_list'][] = $d['email'];
}
}
$tmpl = array('table_open' => '<table cellpadding="0" cellspacing="0" class="epl_email_to_list" style="">');
$this->epl_table->set_template($tmpl);
$email_list['display_list'] = $this->epl_table->generate();
$email_list['display_list'] = $this->epl->load_view('admin/registration/regis-email-form-regis-list', $email_list, true);
$email_list['num_emails'] = $num_emails;
// echo "<pre class='prettyprint'>" . __LINE__ . "> " . basename(__FILE__) . " > " . print_r($email_list['display_list'], true) . "</pre>";
return $email_list;
}
function user_schedule_old()
{
global $wpdb, $event_details, $epl_fields;
if (!is_user_logged_in()) {
return login_with_ajax();
}
$event_type = epl_get_element('_epl_event_type', $event_details);
$registrations = $this->get_current_registrations($this->user_id);
$r = array();
$data['absentees'] = $this->get_user_absentee_data();
//echo "<pre class='prettyprint'>" . __LINE__ . "> " . print_r($registrations, true). "</pre>";
foreach ($registrations as $registration) {
$r_id = str_replace('_epl_regis_post_id_', '', $registration->meta_key);
$regis_data = $this->ecm->setup_regis_details($r_id);
if (epl_is_empty_array($regis_data) || !($d = epl_get_element('__epl', $regis_data, false))) {
continue;
}
if ($regis_data['_epl_regis_status'] < 1) {
continue;
}
$data['regis_id'] = esc_attr($regis_data['post_title']);
$data['regis_date'] = epl_formatted_date($regis_data['post_date']);
//echo "<pre class='prettyprint'>" . __LINE__ . "> " . print_r( $regis_data, true ) . "</pre>";
$_regis_id = $d['_regis_id'];
$_events = $d[$_regis_id]['_events'];
$_dates = $d[$_regis_id]['_dates']['_epl_start_date'];
$event_id = key($_events);
$this->ecm->setup_event_details($event_id);
$data['event_id'] = $event_id;
$data['event_title'] = esc_attr($event_details['post_title']);
$data['event_start_date'] = $event_details['_epl_start_date'];
$data['event_end_date'] = $event_details['_epl_end_date'];
$data['class_dates'] = $event_details['_epl_class_session_date'];
$data['class_start_times'] = $event_details['_epl_class_session_start_time'];
$class_end_times = $event_details['_epl_class_session_end_time'];
$class_session_name = $event_details['_epl_class_session_name'];
$class_session_note = $event_details['_epl_class_session_note'];
$data['fc_event_dates'] = $this->epl->epl_util->get_sess_days_for_fc();
$data['class_end_times'] = $class_end_times;
$data['regis_status'] = get_the_regis_status();
$data['regis_dates_cal'] = $this->eutil->construct_calendar($this->ercm->make_cal_dates_array($data['class_dates']));
$data['list'][$_regis_id] = $this->epl->load_view('front/user-regis-manager/user-regis-dates', $data, true);
}
return $this->epl->load_view('front/user-regis-manager/user-regis-list-page', $data, true);
}
?>
</td>
<td><?php
echo $epl_fields['epl_regis_payment_fields']['_epl_payment_method']['options'][$t->payment_method_id];
?>
</td>
<td><?php
echo $t->transaction_id;
?>
</td>
<td class="epl_status_<?php
echo $t->status;
?>
"><?php
echo get_the_regis_status($t->status);
?>
</td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
<?php
$regis_status_id = get_the_regis_status(null, true);
?>
<?php
if ($regis_status_id <= 2) {
//pending and below
?>
<tr>
<td><?php
epl_e('Payment Method');
?>
</td>
<td><?php
echo htmlspecialchars_decode($gateway_info['_epl_pay_display']);
?>
</td>
</tr>
<?php
}
?>
<?php
if ($inst = epl_get_element('_epl_instructions', $gateway_info)) {
?>
<tr>
<td><?php
epl_e('Payment Instructions');
?>
