$db = db_connect();
$builder = $db->table('customers')->select('customerNumber, customerName, phone, city, country, postalCode,create_date')->where('create_date',date('Y'));
return DataTable::of($builder)
->filter(function ($builder, $request) {
if ($request->country)
$builder->where('country', $request->country);
})
->postQuery(function($builder){
$builder->groupStart()
->where('customerNumber IS NULL')
->orWhere('YEAR(create_date)', '2024')
->groupEnd();
})
->toJson();