public function search(Request $request)
{
$search = trim($request->input("search")["value"] ?: "", " ,");
$start = $request->input("start") ?: 0;
$length = $request->input("length") ?: 25;
$columns = $request->input("columns");
$order = $request->input("order");
$affiliations = Affiliation::query()->where("type", "LIKE", "{$search}%")->orWhere("name", "LIKE", "{$search}%")->orderBy($columns[$order[0]["column"]]["name"], $order[0]["dir"]);
$count = $affiliations->count();
$affiliations = $affiliations->take($length)->skip($start)->get()->toArray();
return $this->dtResponse($request, $affiliations, $count);
}
public function schools()
{
return \App\Affiliation::query()->cms()->get();
}
