function capacity_table($table = true)
 {
     /*
      * if id exists, update meta         *
      */
     //epl_log( "debug", "<pre> META FOR DB " . print_r( $meta, true ) . "</pre>" );
     //echo "<pre class='prettyprint'>CAPACITY PER" . print_r( $this->capacity_per(), true ) . "</pre>";
     global $event_details, $capacity, $current_att_count, $multi_time, $multi_price, $available_space_arr;
     if ($this->mode == 'overview') {
         return null;
     }
     $tmpl = array('table_open' => '<table border="0" cellpadding="2" cellspacing="1" class="epl_avail_spaces_table">');
     $this->epl_table->set_template($tmpl);
     $this->epl_table->set_heading('Date', '#');
     $_table = '';
     //get the attendee and money totals
     $_totals = $this->calculate_totals();
     $grand_total = $_totals['money_totals']['grand_total'];
     $grand_total_key = "_grand_total";
     $available_space_arr = array();
     //$this->epl_table->set_heading( 'Available Spaces', '', '' );
     switch ($this->capacity_per()) {
         case 'date':
             //per date
             //need the total attendees
             //need to apply the total attendees to every day.
             $qty_meta_key = "_total_att_" . $event_details['ID'];
             //$total_att = array_sum( ( array ) $meta[$this->regis_id]['_dates']['_att_quantity'][$event_details['ID']] );
             $total_att = $_totals['_att_quantity']['total'][$event_details['ID']];
             $dates = $event_details['_epl_start_date'];
             foreach ($dates as $_date_key => $_date_id) {
                 $_date = $event_details['_epl_start_date'][$_date_key];
                 $_date = epl_dmy_convert($event_details['_epl_start_date'][$_date_key]);
                 if (!epl_compare_dates(EPL_TIME, $_date, '>')) {
                     $qty_meta_key = "_total_att_" . $event_details['ID'] . '_date_' . $_date_key;
                     $cap = $capacity['date'][$_date_key];
                     $num_att = $current_att_count[$qty_meta_key];
                     $avail = $this->avail_spaces($cap, $num_att);
                     if ($avail == 0) {
                         $avail = epl__('Sold Out');
                     }
                     $available_space_arr[$_date_key] = array($event_details['_epl_start_date'][$_date_key], $avail);
                 }
                 //$this->epl_table->add_row( '', $event_details['_epl_start_date'][$_date_key], $avail );
             }
             break;
     }
     if ($table) {
         $data['available_spaces_table'] = $this->epl_table->generate($available_space_arr);
         $this->epl_table->clear();
         return $this->epl->load_view('front/cart/cart-available-spaces', $data, true);
     }
     return $available_space_arr;
 }
function epl_is_ok_to_register($event_data, $current_key)
{
    /*
     * the event is marked as open for registration
     * registration start date is <= today -done
     * registration end date is >= today
     * there are available spaces
     *
     */
    global $event_details, $capacity, $current_att_count, $available_space_arr;
    $event_status = epl_get_element('_epl_event_status', $event_details);
    //echo "<pre class='prettyprint'>$current_key" . print_r( $current_att_count, true ) . "</pre>";
    $today = date_i18n('Y-m-d H:i:s', EPL_TIME);
    $regis_start_date = epl_get_date_timestamp(epl_admin_dmy_convert(epl_get_element_m($current_key, '_epl_regis_start_date', $event_details, $today)));
    $regis_end_date = epl_get_date_timestamp(epl_admin_dmy_convert(epl_get_element_m($current_key, '_epl_regis_end_date', $event_details, $today)));
    $ok = epl_compare_dates($today, $regis_start_date, ">=");
    if (!$ok) {
        return epl__("Available for registration on") . ' ' . epl_formatted_date($event_details['_epl_regis_start_date'][$current_key]);
    }
    $ok = epl_compare_dates($today, strtotime('23:59:59', $regis_end_date), "<=");
    if (!$ok) {
        return epl__(' Registration Closed');
    }
    $avail_spaces = 0;
    if (is_array($available_space_arr) && !epl_is_empty_array($available_space_arr)) {
        if (array_key_exists($current_key, $available_space_arr) && $available_space_arr[$current_key][1]) {
            $avail_spaces = $available_space_arr[$current_key][1];
            $ok = is_numeric($avail_spaces);
        }
    }
    if (!$ok) {
        return epl__('Sold Out');
    }
    return true;
}
 /**
  * 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 epl_is_ok_to_register($event_data, $current_key)
{
    global $event_details;
    /*
     * the event is marked as open for registration 
     * registration start date is <= today -done
     * registration end date is >= today
     * there are available spaces
     *
     */
    global $event_details, $capacity, $current_att_count, $available_space_arr;
    //echo "<pre class='prettyprint'>$current_key" . print_r( $current_att_count, true ) . "</pre>";
    $today = date('m/d/Y H:i:s', EPL_TIME);
    $regis_start_date = $event_details['_epl_regis_start_date'][$current_key];
    $regis_end_date = $event_details['_epl_regis_end_date'][$current_key];
    $regis_start_date = epl_dmy_convert($regis_start_date);
    $regis_end_date = epl_dmy_convert($regis_end_date);
    $ok = epl_compare_dates($today, $regis_start_date, ">=");
    if (!$ok) {
        return epl__("Available for registration on ") . $event_details['_epl_regis_start_date'][$current_key];
    }
    $ok = epl_compare_dates($today, $regis_end_date, "<=");
    if (!$ok) {
        return epl__(' Registration Closed');
    }
    $avail_spaces = 0;
    if (is_array($available_space_arr) && !empty($available_space_arr)) {
        if (array_key_exists($current_key, $available_space_arr) && $available_space_arr[$current_key][1]) {
            $avail_spaces = $available_space_arr[$current_key][1];
            $ok = is_numeric($avail_spaces);
        }
    }
    if (!$ok) {
        return epl__('Sold Out');
    }
    /*
     $erm = EPL_Base::get_instance()->load_model( 'EPL_registration_model' );
     $totals = $erm->calculate_totals();
    
     echo "<pre class='prettyprint'>" . print_r( $totals, true ) . "</pre>";
    
     if ( is_array( $totals ) && !empty( $totals ) ) {
     $total_att = $_totals['_att_quantity']['total'][$event_details['ID']];
    
     if ( $total_att > $avail_spaces ) {
     return epl__('Sorry, the number of attendees selected exceeds number of avaialable spaces.  Available spaces:' . $avail_spaces);
     }
     }
    */
    return true;
}
function epl_get_regis_status($date_key = null)
{
    global $event_details, $capacity, $current_att_count, $available_space_arr;
    $today = date_i18n('m/d/Y H:i:s', EPL_TIME);
    $regis_start_date = epl_get_date_timestamp(epl_admin_dmy_convert(epl_get_element($date_key, $event_details['_epl_regis_start_date'], $today)));
    $regis_end_date = epl_get_date_timestamp(epl_admin_dmy_convert(epl_get_element($date_key, $event_details['_epl_regis_end_date'], $today)));
    $ok = epl_compare_dates($today, $regis_start_date, ">=");
    if (!$ok) {
        return epl__("Opens on") . ' ' . epl_formatted_date($event_details['_epl_regis_start_date'][$date_key]);
    }
    $ok = epl_compare_dates($today, strtotime('23:59:59', $regis_end_date), "<=");
    if (!$ok) {
        return epl__('Closed');
    }
    return epl__('Open');
}
Example #6
0
 $go = true;
 if ($_from_date && epl_compare_dates($date, $_from_date, '<')) {
     $go = false;
 }
 if ($_to_date && epl_compare_dates($date, $_to_date, '>')) {
     $go = false;
 }
 if (!$go) {
     continue;
 }
 foreach ($event_details['_epl_start_time'] as $time_id => $time) {
     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;
     }
     $regis_end_time = epl_get_element_m($time_id, '_epl_regis_endtime', $event_details, null);
     if ($regis_end_time && epl_compare_dates(strtotime($regis_end_time, $date), EPL_TIME, '<')) {
         continue;
     }
     $register_button = get_the_register_button(null, false, $register_button_url + array('_time_id' => $time_id));
     $event_link = '';
     if (isset($event_details['_epl_link']) && $event_details['_epl_link'] != '') {
         $event_link = epl_anchor($event_details['_epl_link'], 'Learn More', '_self', 'class="event_link"') . ' ' . $register_button;
     } else {
         $event_link = $register_button;
     }
     //removed per Jessi
     //if (!$regis_end_time && epl_compare_dates( strtotime($time, $date), EPL_TIME, '<' ))
     //continue;
     $event_id = get_the_ID();
     $event_excerpt = get_the_excerpt();
     $event_tooltip = '';
 function is_code_expired($_code)
 {
     global $event_details;
     $_code_expiration_date = epl_get_element($_code, epl_get_element('_epl_discount_end_date', $this->discount_configs), null);
     if (!$_code_expiration_date) {
         return false;
     }
     $_code_expiration_date = epl_formatted_date($_code_expiration_date, 'Y-m-d', 'date');
     $_expired = epl_compare_dates(EPL_TIME, $_code_expiration_date . ' 23:59:59', ">");
     if ($_expired) {
         return true;
     }
     return false;
 }