function epl_process_fields_for_display($fields, $avail_fields = null) { if (is_null($avail_fields)) { $avail_fields = epl_get_list_of_available_fields(); } foreach ($fields as $field_id => &$value) { if ($avail_fields[$field_id]['input_type'] == 'select' || $avail_fields[$field_id]['input_type'] == 'radio') { $value = isset($avail_fields[$field_id]['epl_field_choice_text'][$value]) && $avail_fields[$field_id]['epl_field_choice_text'][$value] !== '' ? $avail_fields[$field_id]['epl_field_choice_text'][$value] : $value; } elseif ($avail_fields[$field_id]['input_type'] == 'checkbox') { $value = epl_make_array_from_string($value); if (!epl_is_empty_array($value)) { if (!epl_is_empty_array($avail_fields[$field_id]['epl_field_choice_value'])) { $value = implode(',', array_intersect_key($avail_fields[$field_id]['epl_field_choice_value'], array_flip($value))); } else { $value = implode(',', array_intersect_key($avail_fields[$field_id]['epl_field_choice_text'], array_flip($value))); } } } else { $value = html_entity_decode(htmlspecialchars_decode($value)); } } return $fields; }
<?php if (!$registrants) { epl_e('No registrants found for this session'); return null; } ?> <h3><?php epl_e('All Purchases'); ?> </h3> <?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);
function view_names2() { if (!is_user_logged_in()) { exit; } global $event_details, $wpdb; $registrations = $wpdb->get_results("\n SELECT rf.* \n FROM {$wpdb->epl_regis_form_data} rf\n INNER JOIN {$wpdb->epl_registration} r\n ON r.regis_id=rf.regis_id\n WHERE 1=1 AND (r.status = 2 OR r.status = 5) \n AND field_id <> ''\n GROUP BY value\n ORDER BY id\n "); $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_daily_schedule_table dataTable" id="">'); $this->epl->epl_table->set_template($tmpl); foreach ($registrations as $r) { if (strpos($r->field_id, EPL_PLUGIN_DB_DELIM)) { $fields = explode(EPL_PLUGIN_DB_DELIM, $r->field_id); $values = explode(EPL_PLUGIN_DB_DELIM, $r->value); } else { $fields = array($r->field_id); $values = array($r->value); } $full = array_combine($fields, $values); if (!$limited) { $_row = array_merge($default_row, $full); } else { $_row = array_intersect_key($full, $default_row); } $this->epl->epl_table->add_row(array_values($_row)); //echo "<pre class='prettyprint'>" . __LINE__ . "> " . basename( __FILE__ ) . " > " . print_r( $_row, true ) . "</pre>"; } $header = epl_get_field_labels(array_intersect_key($avail_fields, $default_row)); $this->epl->epl_table->set_heading($header); echo $this->epl->epl_table->generate(); }