Support

May 31, 2013 at 6:07 pm

thanks for the JS docs, would happen to have the object properties for the Event Espresso Event object as well? so I can grab the venue title.

as far as the espresso-calendar.php  i found an apostrophe on line 749 that doesn’t seem to belong, downloaded the latest version today, http://d.pr/i/wXvU

thats what was making my editor freak out

June 3, 2013 at 10:03 am

maybe that happened.

Heres the sql to get venue information passed into the event object in the  calendar

[code]

//Get all events
$type = ‘all’;

$sql = “SELECT e.*, ese.start_time, ese.end_time”;

if (isset($espresso_calendar[‘disable_categories’]) && $espresso_calendar[‘disable_categories’] == false) {
$sql .= “, c.category_meta, c.category_identifier, c.category_name, c.category_desc, c.display_desc “;
}
if ( isset($org_options[‘use_venue_manager’]) && $org_options[‘use_venue_manager’] == ‘Y’ ) {
$sql .= “, v.name venue_name, v.address venue_address, v.address2 venue_address2, v.city venue_city, v.state venue_state, v.zip venue_zip, v.country venue_country, v.meta venue_meta “;
}
$sql .= ” FROM ” . EVENTS_DETAIL_TABLE . ” e “;

if ( isset($org_options[‘use_venue_manager’]) && $org_options[‘use_venue_manager’] == ‘Y’ ) {
$sql .= ” LEFT JOIN ” . EVENTS_VENUE_REL_TABLE . ” vm ON vm.event_id = e.id LEFT JOIN ” . EVENTS_VENUE_TABLE . ” v ON v.id = vm.venue_id “;
}

$sql .= ” LEFT JOIN ” . EVENTS_START_END_TABLE . ” ese ON ese.event_id= e.id “;
if (isset($espresso_calendar[‘disable_categories’]) && $espresso_calendar[‘disable_categories’] == false) {
$sql .= ” LEFT JOIN ” . EVENTS_CATEGORY_REL_TABLE . ” r ON r.event_id = e.id “;
$sql .= ” LEFT JOIN ” . EVENTS_CATEGORY_TABLE . ” c ON c.id = r.cat_id “;
}
if ( function_exists(‘espresso_version’) ) {
if ( espresso_version() >= ‘3.2.P’ ) { // if we’re using ee 3.2+, is_active is true/false
$sql .= ” WHERE e.is_active != false “;
} else {
$sql .= ” WHERE e.is_active != ‘N’ “;
}
}
$sql .= ” AND e.event_status != ‘D’ “;//Deleted
$sql .= ” AND e.event_status != ‘S’ “;//Secondary/Waitlist
$sql .= ” AND e.event_status != ‘P’ “;//Pending
$sql .= ” AND e.event_status != ‘X’ “;
$sql .= ” AND e.event_status != ‘R’ “;//Draft
if ($show_expired == “false”) {
$sql .= ” AND e.start_date >= ‘” . date(‘Y-m-d’) . “‘ “;
$sql .= ” AND e.registration_start <= ‘” . date(‘Y-m-d’) . “‘ “;
$sql .= ” AND e.registration_end >= ‘” . date(‘Y-m-d’) . “‘ “;
}
}
$sql .= ” GROUP BY e.id ORDER BY e.start_date = ‘0000-00-00’ ASC ” . $throttle;

[/code]