public function ajaxCustomerDiscounts($id)
{
$cpage = 'customers';
$i = Input::all();
$arr = [];
$arr = getallheaders();
$count = null;
if (isset($arr['Range'])) {
$response_array = array();
$response_array['Accept-Ranges'] = 'items';
$response_array['Range-Unit'] = 'items';
$response_array['Content-Ranges'] = 'items ' . $arr['Range'] . '/' . $count;
$arr = explode('-', $arr['Range']);
$items = $arr[1] - $arr[0] + 1;
$skip = $arr[0];
$skip = $skip < 0 ? 0 : $skip;
$c = null;
if (isset($_GET['query']) && $_GET['query'] != '') {
$query = $_GET['query'];
$count = $c = CustomerDiscount::join('customers', 'customers.membership_id', '=', 'discounts_customers.customer_id')->where(function ($customer) use($query) {
$customer->where('customers.membership_id', 'LIKE', "%{$query}%")->orWhereRaw("concat_ws(' ',customers.firstname,customers.lastname) LIKE '%{$query}%'")->orWhere('customers.firstname', 'LIKE', "%{$query}")->orWhere('customers.lastname', 'LIKE', "%{$query}%");
})->where('discount_id', $id)->get()->count();
$c = CustomerDiscount::join('customers', 'customers.membership_id', '=', 'discounts_customers.customer_id')->where(function ($customer) use($query) {
$customer->where('customers.membership_id', 'LIKE', "%{$query}%")->orWhereRaw("concat_ws(' ',customers.firstname,customers.lastname) LIKE '%{$query}%'")->orWhere('customers.firstname', 'LIKE', "%{$query}")->orWhere('customers.lastname', 'LIKE', "%{$query}%");
})->where('discount_id', $id)->skip($skip)->take($items)->get();
} else {
$count = CustomerDiscount::where('discount_id', $id)->get()->count();
$c = CustomerDiscount::where('discount_id', $id)->join('customers', 'customers.membership_id', '=', 'discounts_customers.customer_id')->skip($skip)->take($items)->get();
}
$response = Response::make($c, 200);
$response->header('Content-Range', $response_array['Content-Ranges'])->header('Accept-Ranges', 'items')->header('Range-Unit', 'items')->header('Total-Items', $count)->header('Flash-Message', 'Now showing pages ' . $arr[0] . '-' . $arr[1] . ' out of ' . $count);
return $response;
}
$c = Customer::all();
$response = Response::make($c, 200);
$response->header('Content-Ranges', 'test');
return $response;
/* $c = Customer::all();
return $c;*/
}
