<?php

global $wpdb;

if (! current_user_can( 'administrator' ) ) {
die("NotAdmin");/* Your code */
}

require_once $_SERVER['DOCUMENT_ROOT'] . "/wp-content/themes/badaxe/am/bootstrap/amm.php";

$start = $_GET['start'];
$len   = $_GET['length'];

if ( $start == '' ) $start = 0;
if ( $len == '' ) $len = 2500;

$columns[0] = "`am_users`.first_name";
$columns[1] = "`am_users`.last_name";
$columns[2] = "age";
$columns[3] = "`wp_waivers`.dob";
$columns[4] = "`am_users`.email";
$columns[5] = "`wp_waivers`.location";
$columns[6] = "`wp_waivers`.location2";
$columns[7] = "`wp_waivers`.notifications";
$columns[8] = "`wp_waivers`.member";
$columns[9] = "`wp_waivers`.date_created";
$columns[10] = "`wp_waivers`.blacklist";

$columnOrder = !empty($_GET['order'][0]['column']) ? $columns[$_GET['order'][0]['column']] : '`wp_waivers`.id';
$orderDir    = !empty($_GET['order'][0]['dir']) ? $_GET['order'][0]['dir'] : 'DESC';

$searchV = trim($_GET['search']['value']);
$search  = !empty($_GET['search']['value']) ? "WHERE `am_users`.first_name LIKE '%" . $searchV . "%' OR `am_users`.last_name LIKE '%" . $searchV . "%' OR `am_users`.email LIKE '%" . $searchV . "%' OR wp_waivers.location LIKE '%". $searchV . "%' OR wp_waivers.date_created LIKE '%" . $searchV . "%'" : '';

// ...Formulate the query
$query = "SELECT `am_users`.first_name, `am_users`.last_name,TIMESTAMPDIFF(YEAR, dob, CURDATE()) AS age,`wp_waivers`.dob, `am_users`.email,`wp_waivers`.location,`wp_waivers`.location2,`wp_waivers`.notifications,`wp_waivers`.member,`wp_waivers`.date_created,`wp_waivers`.blacklist FROM `wp_waivers` LEFT JOIN `am_users` ON `wp_waivers`.uid = `am_users`.id $search ORDER BY $columnOrder $orderDir LIMIT $start,$len";
// print $query;

// ...Perform the query
$result = $wpdb->get_results($query, OBJECT);

$query_count = "SELECT COUNT(*) as count FROM `wp_waivers` LEFT JOIN `am_users` ON `wp_waivers`.uid = `am_users`.id $search";
$rcount = $wpdb->get_results($query_count, OBJECT);

$query_total = "SELECT COUNT(*) as count FROM `wp_waivers`";
$tcount = $wpdb->get_results($query_total, OBJECT);

$export = array();
$export['data'] = array();
$export['recordsFiltered'] = $rcount[0]->count;
$export['recordsTotal'] = $tcount[0]->count;
$export['draw'] = $_GET['draw'] + 1;

foreach ($result as $row) {
	$r = array();
	$r[] = $row->first_name;
	$r[] = $row->last_name;
	$r[] = $row->age;
	$r[] = $row->dob;
	$r[] = $row->email;
	$r[] = $row->location;
	$r[] = $row->location2;
	$r[] = $row->notifications;
	$r[] = $row->member;
	$r[] = $row->date_created;
	$r[] = $row->blacklist;
	$export['data'][] = $r;
}


print json_encode($export);

?>