</ul> <ul class="subsubsub"> <li><strong> <?php _e('Attendees', 'event_espresso'); ?> : </strong> </li> <li><a <?php echo isset($_REQUEST['all_a']) && $_REQUEST['all_a'] == 'true' ? ' class="current" ' : ''; ?> href="admin.php?page=events&event_admin_reports=event_list_attendees&all_a=true"> <?php _e('All Attendees', 'event_espresso'); ?> <span class="count">(<?php echo espresso_total_all_attendees(); ?> )</span></a> | </li> <li><a <?php echo isset($_REQUEST['today_a']) && $_REQUEST['today_a'] == 'true' ? ' class="current" ' : ''; ?> href="admin.php?page=events&event_admin_reports=event_list_attendees&today_a=true"> <?php _e('Today', 'event_espresso'); ?> <span class="count">(<?php echo espresso_total_attendees_today(); ?> )</span></a> |</li> <li><a <?php echo isset($_REQUEST['this_month_a']) && $_REQUEST['this_month_a'] == 'true' ? ' class="current" ' : '';
function espresso_display_admin_reports_filters($total = 0) { $event_admin_reports = isset($_REQUEST['event_admin_reports']) ? wp_strip_all_tags($_REQUEST['event_admin_reports']) : FALSE; $event_id = isset($_REQUEST['event_id']) && $_REQUEST['event_id'] != '' ? absint($_REQUEST['event_id']) : FALSE; $category_id = isset($_REQUEST['category_id']) ? absint($_REQUEST['category_id']) : FALSE; $payment_status = isset($_REQUEST['payment_status']) ? wp_strip_all_tags($_REQUEST['payment_status']) : ''; $event_status = isset($_REQUEST['event_status']) ? wp_strip_all_tags($_REQUEST['event_status']) : ''; $month_range = isset($_REQUEST['month_range']) ? wp_strip_all_tags($_REQUEST['month_range']) : ''; // then figure out the current "view" $view = isset($_REQUEST['all']) && $_REQUEST['all'] == 'true' ? 'all' : ''; $view = isset($_REQUEST['this_month']) && $_REQUEST['this_month'] == 'true' ? 'this_month' : $view; $view = isset($_REQUEST['today']) && $_REQUEST['today'] == 'true' ? 'today' : $view; $view = isset($_REQUEST['all_a']) && $_REQUEST['all_a'] == 'true' ? 'all_a' : $view; $view = isset($_REQUEST['this_month_a']) && $_REQUEST['this_month_a'] == 'true' ? 'this_month_a' : $view; $view = isset($_REQUEST['today_a']) && $_REQUEST['today_a'] == 'true' ? 'today_a' : $view; // query params we need to remove $remove = array($view, 'event_admin_reports', 'event_id'); // if a specific date period has been clicked if (!empty($view)) { $remove[] = 'month_range'; $month_range = ''; } // then remove the current view from the query args so that the view can be changed $query_args = espresso_remove_filter_from_query_args($remove); //printr( $query_args, '$query_args <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); // EVT_ADMIN_URL ?> <h3 style="margin-bottom: -8px;"> <?php echo __('Filters', 'event_espresso'); ?> </h3> <ul class="subsubsub"> <li> <strong> <?php _e('Events', 'event_espresso'); ?> : </strong> </li> <li> <a <?php echo $view == 'all' ? ' class="current" ' : ''; ?> href="<?php echo add_query_arg(array_merge(array('all' => 'true', 'max_rows' => 100000), $query_args), EVT_ADMIN_URL); ?> "> <?php _e('All Events', 'event_espresso'); ?> <span class="count">(<?php echo espresso_total_events(); ?> )</span> </a> | </li> <li> <a <?php echo $view == 'this_month' ? ' class="current" ' : ''; ?> href="<?php echo add_query_arg(array_merge(array('this_month' => 'true'), $query_args), EVT_ADMIN_URL); ?> "> <?php _e('This Month', 'event_espresso'); ?> <span class="count">(<?php echo espresso_total_events_this_month(); ?> )</span> </a> </li> <li>| <a <?php echo $view == 'today' ? ' class="current" ' : ''; ?> href="<?php echo add_query_arg(array_merge(array('today' => 'true'), $query_args), EVT_ADMIN_URL); ?> "> <?php _e('Today', 'event_espresso'); ?> <span class="count">(<?php echo espresso_total_events_today(); ?> )</span> </a> </li> </ul> <ul class="subsubsub"> <li> <strong> <?php _e('Attendees', 'event_espresso'); ?> : </strong> </li> <li> <a <?php echo $view == 'all_a' ? ' class="current" ' : ''; ?> href="<?php echo add_query_arg(array_merge(array('event_admin_reports' => 'event_list_attendees', 'all_a' => 'true', 'max_rows' => 100000), $query_args), EVT_ADMIN_URL); ?> "> <?php _e('All Attendees', 'event_espresso'); ?> <span class="count"> (<?php echo espresso_total_all_attendees(); ?> ) </span> </a> | </li> <li> <a <?php echo $view == 'this_month_a' ? ' class="current" ' : ''; ?> href="<?php echo add_query_arg(array_merge(array('event_admin_reports' => 'event_list_attendees', 'this_month_a' => 'true'), $query_args), EVT_ADMIN_URL); ?> "> <?php _e('This Month', 'event_espresso'); ?> <span class="count"> (<?php echo espresso_total_attendees_this_month(); ?> ) </span> </a> </li> <li> | <a <?php echo $view == 'today_a' ? ' class="current" ' : ''; ?> href="<?php echo add_query_arg(array_merge(array('event_admin_reports' => 'event_list_attendees', 'today_a' => 'true'), $query_args), EVT_ADMIN_URL); ?> "> <?php _e('Today', 'event_espresso'); ?> <span class="count"> (<?php echo espresso_total_attendees_today(); ?> ) </span> </a> </li> <?php if ($event_id && (!$event_admin_reports || $event_admin_reports != 'charts')) { ?> <li> | <a href="<?php echo add_query_arg(array_merge(array('event_admin_reports' => 'charts', 'event_id' => $event_id), $query_args), EVT_ADMIN_URL); ?> "> <?php _e('View Report', 'event_espresso'); ?> </a> </li> <?php } ?> </ul> <div style="clear:both"></div> <div class="ee_tablenav tablenav"> <div class="actions"> <form id="ee_tablenav" name="ee_tablenav" method="get" action="<?php echo EVT_ADMIN_URL; ?> "> <?php // what page are we doing filtering for ? if ($event_admin_reports) { // add event_admin_reports back into query args $query_args['event_admin_reports'] = $event_admin_reports; // Filter Month espresso_attendees_by_month_dropdown($month_range); ?> <input type="submit" class="button-secondary" value="Filter Month" id="post-query-month"/> <?php // Filter Category // when viewing the attendee list for a specific event we no longer need or would want the category filter if (!$event_id) { if (espresso_category_dropdown($category_id)) { ?> <input type="submit" class="button-secondary" value="Filter Category" id="post-query-category"/> <?php } } // Filter Payment Status $status = array(array('id' => '', 'text' => __('Show All Completed/Incomplete', 'event_espresso')), array('id' => 'Completed', 'text' => __('Completed', 'event_espresso')), array('id' => 'Pending', 'text' => __('Pending', 'event_espresso')), array('id' => 'Incomplete', 'text' => __('Incomplete', 'event_espresso')), array('id' => 'Payment Declined', 'text' => __('Payment Declined', 'event_espresso')), array('id' => 'Refund', 'text' => __('Refund', 'event_espresso'))); echo select_input('payment_status', $status, $payment_status); ?> <input type="submit" class="button-secondary" value="Filter Status" id="post-query-payment"/> <a class="button-secondary" href="admin.php?page=events&event_admin_reports=event_list_attendees"> <?php _e('Reset Filters', 'event_espresso'); ?> </a> <?php } else { espresso_event_months_dropdown($month_range); ?> <input type="submit" class="button-secondary" value="Filter Month" id="post-query-submit-month"/> <?php if (espresso_category_dropdown($category_id)) { ?> <input type="submit" class="button-secondary" value="Filter Category" id="post-query-submit-category"/> <?php } ?> <?php $status = array(array('id' => 'A', 'text' => __('Active / Ongoing', 'event_espresso')), array('id' => 'L', 'text' => __('ALL ( Active / Inactive )', 'event_espresso')), array('id' => 'IA', 'text' => __('Inactive', 'event_espresso')), array('id' => 'P', 'text' => __('Pending', 'event_espresso')), array('id' => 'R', 'text' => __('Draft', 'event_espresso')), array('id' => 'S', 'text' => __('Waitlist', 'event_espresso')), array('id' => 'O', 'text' => __('Ongoing', 'event_espresso')), array('id' => 'X', 'text' => __('Denied', 'event_espresso')), array('id' => 'D', 'text' => __('Deleted', 'event_espresso'))); echo select_input('event_status', $status, $event_status); ?> <input type="submit" class="button-secondary" value="Filter Status" id="post-query-submit-event-status"/> <a class="button-secondary" href="admin.php?page=events"> <?php _e('Reset Filters', 'event_espresso'); ?> </a> <?php } // query params we need to remove now $remove = array('month_range', 'category_id', 'event_status', 'payment_status'); // then remove the current view from the query args so that the view can be changed $query_args = espresso_remove_filter_from_query_args($remove); // add view back into query args if (!empty($view)) { $query_args[$view] = 'true'; } //because we're doing a get request, we'll need to explicitly preserve the old GET querystring foreach ($query_args as $query_arg => $value) { echo espresso_hidden_form_input($query_arg, $value); } $max_rows = isset($_REQUEST['max_rows']) ? absint($_REQUEST['max_rows']) : 50; $max_rows = min($max_rows, 100000); $start_rec = isset($_REQUEST['start_rec']) && !empty($_REQUEST['start_rec']) ? absint($_REQUEST['start_rec']) : 0; $rows = array(5 => 5, 50 => 50, 100 => 100, 250 => 250, 500 => 500, 100000 => 'all'); $prev_start_rec = $start_rec - $max_rows; $next_start_rec = $start_rec + $max_rows; ?> <div id='ee_table_pagination'> <button class='button-secondary'><?php _e("Retrieve", 'event_espresso'); ?> </button> <select name="max_rows" size="1"> <?php foreach ($rows as $key => $value) { ?> <?php $selected = $key == $max_rows ? ' selected="selected"' : ''; ?> <option value="<?php echo $key; ?> "<?php echo $selected; ?> ><?php echo $value; ?> </option> <?php } ?> </select> <?php _e('rows from the Database at a time', 'event_espresso'); ?> <input name="start_rec" id='event-list-start-rec' value="<?php echo $start_rec; ?> " class="textfield" type="hidden"> <?php //show db-level pagination buttons if ($prev_start_rec >= 0) { ?> <a id="event-admin-load-prev-rows-btn" title="load prev rows" class="event-pagination-button button-secondary"> <?php echo __('Previous', 'event_espresso') . ' ' . $max_rows . ' ' . __('rows', 'event_espresso'); ?> </a> <?php } if ($total >= $max_rows) { ?> <a id="event-admin-load-next-rows-btn" title="load next rows" class="event-pagination-button button-secondary"> <?php echo __('Next', 'event_espresso') . ' ' . $max_rows . ' ' . __('rows', 'event_espresso'); ?> </a> <?php } ?> </div> </form> </div> </div> <?php // echo '<h4>$max_rows : ' . $max_rows . ' <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span></h4>'; // echo '<h4>$total : ' . $total . ' <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span></h4>'; //setup jquery for previous and next buttons, //but don't output them here. //we actually don't know if we want them both yet anyways //because don't know how many records are in the curren tquery, because //the query hasn't been run yet. (Hence why its nice to setup all your variables FIRST and then start outputting //although sometimes it requires some work and discipline //anyways, to output the previous/next buttons, just have some HTML like //<a id='event-admin-load-prev-rows-btn'>Previous</a> //<a id='event-admin-load-next-rows-btn'>Previous</a> //and it can be placed anywher ein the page ?> <script> jQuery(document).ready(function( $ ){ $('#event-admin-load-prev-rows-btn').click(function(e){ e.preventDefault(); event_set_start_rec_and_send_form(<?php echo $prev_start_rec; ?> ); }); $('#event-admin-load-next-rows-btn').click(function(e){ e.preventDefault(); event_set_start_rec_and_send_form(<?php echo $next_start_rec; ?> ); }); $('#ee_tablenav input').click(function(){ event_reset_start_rec(); }); $('#ee_table_pagination button').click(function(){ event_reset_start_rec(); }); function event_set_start_rec_and_send_form(value){ event_reset_view(); $('#event-list-start-rec').val(value); $('#ee_tablenav').submit(); } function event_reset_start_rec(){ event_reset_view(); $('#event-list-start-rec').val(0); } function event_reset_view(){ var month_range = $('select[name="month_range"]').val(); if( month_range != '' ) { $('input[name="<?php echo $view; ?> "]').val(''); $('input[name="<?php echo $view; ?> "]').remove(); } } }); </script> <?php }