'publish', 'post_type' => 'erp_event', 'orderby' => 'ASC', 'posts_per_page' => -1, ); $res = new WP_Query( $args ); $total_publish_cnt = count($res->posts); $archive_post=$wpdb->get_results(' SELECT * FROM '.$wpdb->posts.' WHERE post_status="archive" AND post_type="erp_event"'); $total_archive_cnt = count($archive_post); $total_event_cnt=$wpdb->get_results(' SELECT * FROM '.$wpdb->posts.' WHERE (post_status="publish" OR post_status="archive") AND post_type="erp_event"'); $total_event_cnt = count($total_event_cnt); $args = array( 'post_status' => 'publish', 'post_type' => 'register_events', 'orderby' => 'post_date', 'order' => 'ASC', 'posts_per_page' => -1, ); $res = new WP_Query( $args ); //echo '
';print_r($res);echo '
'; $j=0; $todays_price=0; //$total_price_income=0; $month_reg=array(); $daily_price=array(); while( $res->have_posts() ) : $res->the_post(); $meta =get_post_meta($post->ID); if(!empty($meta['event_name'][0])){ if($stat_chart_period==3){ $event_month= date('Y', strtotime($post->post_date)); if($event_month==date(Y)){ $month_reg[]= date($dateformat, strtotime($post->post_date)); $price2 = get_post_meta($meta['post_id'][0],'erp_event_price_'.$meta['ticket_id'][0],true); $daily_price[]= $price2; } } else{ $event_month= date('M', strtotime($post->post_date)); if($event_month==date(M)){ $month_reg[]= date($dateformat, strtotime($post->post_date)); $price2 = get_post_meta($meta['post_id'][0],'erp_event_price_'.$meta['ticket_id'][0],true); $daily_price[]= $price2; } } $event_date_publish= date($dateformat, strtotime($post->post_date)); //$price1 = get_post_meta($meta['post_id'][0],'erp_event_price_'.$meta['ticket_id'][0],true); //$total_price_income=$total_price_income+$price1; if(strtotime($event_date_publish)==strtotime($todays_date)){ $j++; $price = get_post_meta($meta['post_id'][0],'erp_event_price_'.$meta['ticket_id'][0],true); if($price != '') { $todays_price = $todays_price+$price; } } } endwhile; $todays_reg=$j; $e_date=array(); $final_arr=array(); $sum = 0; $j = 0; foreach($month_reg as $key=>$val) { if (in_array($val, $e_date)) { if($daily_price[$key] != '') $sum = $sum + $daily_price[$key]; } else { if($sum != 0) { $final_arr[$e_date[$j]] = $sum; $j++; } $sum = 0; array_push($e_date,$val); if($daily_price[$key] != '') $sum = $sum + $daily_price[$key]; } } $final_arr[$e_date[$j]] = $sum; $monthchart=array_count_values($month_reg); $arr = array(); $total_s=0; foreach($final_arr as $key=>$val){ $total_s=$total_s+$val; $arr[] = '["'.date($dateformat, strtotime($key)).'", 0, 0,'.$val.', '.$monthchart[$key].', '.$total_s.']'; } ?>

Event Registration Pro - Dashboard

'; } ?>
No records found

Total Events in System

Published Events

Archived Events

Today's Registrants

Today's Income

Last 10 Transactions

'publish', 'post_type' => 'register_events', 'orderby' => 'post_date', 'order' => 'DESC', 'posts_per_page' => -1, ); $res = new WP_Query( $args ); //echo '
';print_r($res);echo '
'; $i=1; while( $res->have_posts() ) : $res->the_post(); $meta =get_post_meta($post->ID); $price = get_post_meta($meta['post_id'][0],'erp_event_price_'.$meta['ticket_id'][0],true); $ticket_name = get_post_meta($meta['post_id'][0],'erp_event_ticket_name_'.$meta['ticket_id'][0],true); if(empty($ticket_name)){ $tkt_name='Free Admission'; //$tkt_price='$0.00'; } else{ $tkt_name=$ticket_name; //$tkt_price=do_action('get_ticket_add_on_setting_event_registration_pro_ticket_standard',$price); } if($i<=10){ if(!empty($meta['event_name'][0])){ $i++ ?>
Date/Time Registrant Name Event Ticket Name Payment Status Price
post_date));?> post_date));?> post_title);?>

Next 10 Upcoming Events

'publish', 'post_type' => 'erp_event', 'posts_per_page' => -1, 'orderby' => 'erp_event_date', 'order' => 'DESC',*/ 'post_status' => 'publish', 'post_type' => 'erp_event', 'meta_key' => 'erp_event_date', 'orderby' => array( 'date' =>'ASC', ), ); $todays_date_up=date($dateformat, strtotime($todays_date)); $res = new WP_Query( $args ); $n=1; while( $res->have_posts() ) : $res->the_post(); global $post; $meta = get_post_meta($post->ID); $max_attends=$meta['erp_event_max_attendance'][0]; $post_title=$post->post_title; //$query='select * from '.$wpdb->posts.' where '; echo $up_id=$post->ID; if($n<=10){ $event_date_publish= date($dateformat, strtotime($meta['erp_event_date'][0])); if(strtotime($event_date_publish) > strtotime($todays_date_up)){ $n++; $args1 = array( 'post_type' => 'register_events', 'posts_per_page' => '-1', 'meta_query' => array( array ( 'key' => 'accepted', 'value' =>1, 'compare' => '=', ), array ( 'key' => 'post_id', 'value' =>$up_id, 'compare' => '=', ) ), ); $res1 = new WP_Query( $args1 ); $register_count1= $res1->post_count; $reg_total_price=0; while( $res1->have_posts() ) : $res1->the_post(); $regmeta =get_post_meta($post->ID); $regprice = get_post_meta($regmeta['post_id'][0],'erp_event_price_'.$regmeta['ticket_id'][0],true); $reg_total_price=$reg_total_price+$regprice; endwhile; $args2 = array( 'post_type' => 'register_events', 'posts_per_page' => '-1', 'meta_query' => array( array ( 'key' => 'pending', 'value' =>1, 'compare' => '=', ), array ( 'key' => 'post_id', 'value' =>$up_id, 'compare' => '=', ) ), ); $res2 = new WP_Query( $args2 ); $pending_count1= $res2->post_count; ?> ID,'post_id');?>
Event ID # Event Title Event Dates Registrations
- ID,'post_id'); if(empty($max_attends)){$max_attends='∞';} do_action('get_ticket_add_on_setting_event_registration_pro_ticket_standard',$reg_total_price); echo 'Total: '. $final_price.'
';?> Accepted:".$register_count1;}?>
Total: No Registrations Yet';} ?>

Event Registration Pro: Event registration software for Wordpress!
© Copyright - All Rights Reserved. www.eventregistrationpro.com
Installed Version: 1.0.0
Minimum Required PHP Version: (5.5 +) (Your PHP Version # is: )