crm_integration

function flightdeck_event_created_email($params) {
  global $wpdb;
  $event_id = $params['event_id'];
  $sql = "SELECT evt.id, evt.event_name, evt.start_date, evt.end_date, se.start_time, se.end_time, v.name as venue_name, v.address, v.address2, v.city, v.state, v.zip FROM " . EVENTS_DETAIL_TABLE . " evt ";
  $sql .= "LEFT JOIN " . EVENTS_VENUE_REL_TABLE . " r ON r.event_id = evt.id LEFT JOIN " . EVENTS_VENUE_TABLE . " v ON v.id=r.venue_id ";
  $sql .= "LEFT JOIN " . EVENTS_START_END_TABLE . " se ON se.event_id = evt.id ";
  $sql .= "WHERE evt.id=" . $event_id;
  $event = array_shift($wpdb->get_results($sql));
  
  $body = "";
  $body .= "<p>";
  $body .= "EventId: " . $event->id . "<br/>";
  $body .= "EventName: " . $event->event_name . "<br/>";
  $body .= "StartDate: " . $event->start_date . "<br/>";
  $body .= "EndDate: " . $event->end_date . "<br/>";
  $body .= "StartTime: " . $event->start_time . "<br/>";
  $body .= "EndTime: " .  $event->end_time . "<br/>";
  $body .= "</p>";
  
  $body .= "<p>";
  $body .= "VenueName: " . $event->venue_name . "<br/>";
  $body .= "Address: " . $event->address . "<br/>";
  $body .= "Address2: " . $event->address2 . "<br/>";
  $body .= "City: " . $event->city . "<br/>";
  $body .= "County: " . $event->state . "<br/>";
  $body .= "Postcode: " . $event->zip . "<br/>";
  $body .= "</p>";
  
  $headers = "Content-Type: text/html; charset=utf-8\r\n";
  
  wp_mail('email@example.com', "New event created", $body, $headers);
}
add_action("action_hook_espresso_insert_event_success", "flightdeck_event_created_email");

function flightdeck_event_update_email($params) {
  global $wpdb;
  $event_id = $params['event_id'];
  $sql = "SELECT evt.id, evt.event_name, evt.start_date, evt.end_date, se.start_time, se.end_time, v.name as venue_name, v.address, v.address2, v.city, v.state, v.zip FROM " . EVENTS_DETAIL_TABLE . " evt ";
  $sql .= "LEFT JOIN " . EVENTS_VENUE_REL_TABLE . " r ON r.event_id = evt.id LEFT JOIN " . EVENTS_VENUE_TABLE . " v ON v.id=r.venue_id ";
  $sql .= "LEFT JOIN " . EVENTS_START_END_TABLE . " se ON se.event_id = evt.id ";
  $sql .= "WHERE evt.id=" . $event_id;
  $event = array_shift($wpdb->get_results($sql));
  
  $body = "";
  $body .= "<p>";
  $body .= "EventId: " . $event->id . "<br/>";
  $body .= "EventName: " . $event->event_name . "<br/>";
  $body .= "StartDate: " . $event->start_date . "<br/>";
  $body .= "EndDate: " . $event->end_date . "<br/>";
  $body .= "StartTime: " . $event->start_time . "<br/>";
  $body .= "EndTime: " .  $event->end_time . "<br/>";
  $body .= "</p>";
  
  $body .= "<p>";
  $body .= "VenueName: " . $event->venue_name . "<br/>";
  $body .= "Address: " . $event->address . "<br/>";
  $body .= "Address2: " . $event->address2 . "<br/>";
  $body .= "City: " . $event->city . "<br/>";
  $body .= "County: " . $event->state . "<br/>";
  $body .= "Postcode: " . $event->zip . "<br/>";
  $body .= "</p>";
  
  $headers = "Content-Type: text/html; charset=utf-8\r\n";
  
  wp_mail('email@example.com', "Event updated", $body, $headers);
}
add_action("action_hook_espresso_update_event_success", "flightdeck_event_update_email");