function eme_people_search_ajax() {
$persons = eme_get_persons();
$return = array();
if (!isset($_GET["q"])) {
echo json_encode($return);
return;
}
foreach($persons as $item) {
$record = array();
$record['lastname'] = eme_trans_sanitize_html($item['lastname']);
$record['firstname'] = eme_trans_sanitize_html($item['firstname']);
$record['address1'] = eme_trans_sanitize_html($item['address1']);
$record['address2'] = eme_trans_sanitize_html($item['address2']);
$record['city'] = eme_trans_sanitize_html($item['city']);
$record['state'] = eme_trans_sanitize_html($item['state']);
$record['zip'] = eme_trans_sanitize_html($item['zip']);
$record['country'] = eme_trans_sanitize_html($item['country']);
$record['email'] = eme_trans_sanitize_html($item['email']);
$record['phone'] = eme_trans_sanitize_html($item['phone']);
$return[] = $record;
}
$q = strtolower($_GET["q"]);
if (!$q) return;
$result=array();
foreach($return as $row) {
if (strpos(strtolower($row['lastname']), $q) !== false)
$result[]=$row;
}
echo json_encode($result);
}
function eme_get_attendees_for($event_id, $pending_approved = 0, $only_unpayed = 0)
{
global $wpdb;
$bookings_table = $wpdb->prefix . BOOKINGS_TBNAME;
$sql = $wpdb->prepare("SELECT DISTINCT person_id FROM {$bookings_table} WHERE event_id = %s", $event_id);
if ($pending_approved == 1) {
$sql .= " AND booking_approved=0";
} elseif ($pending_approved == 2) {
$sql .= " AND booking_approved=1";
}
if ($only_unpayed) {
$sql .= " AND booking_payed=0";
}
$person_ids = $wpdb->get_col($sql);
if ($person_ids) {
$attendees = eme_get_persons($person_ids);
} else {
$attendees = array();
}
return $attendees;
}
