/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//
$total_trusts = Trusts::count();
$definitions = Definitions::all();
$years = Trusts::select('year')->groupBy('year')->lists('year');
return view('watsonv2', ['total' => $total_trusts, 'years' => $years, 'definitions' => $definitions]);
}
public function index()
{
$categories = ['branch', 'type', 'scope', 'theme', 'unit', 'settlor', 'fiduciary'];
$definitions = Definitions::all();
$trusts = Trusts::select('id', 'registry', 'income', 'yield', 'expenses', 'availability', 'year', 'initial_date')->get();
$registries = Trusts::select("id", "registry", "designation")->groupBy("registry")->get();
return view('data', ['trusts' => $trusts, 'categories' => $categories, 'definitions' => $definitions, 'registries' => $registries]);
}
public function index()
{
$main_article = Article::all()->first();
$articles = Article::all();
$categories = ['branch', 'type', 'scope', 'theme', 'unit', 'settlor', 'fiduciary'];
$year_max = max(Trusts::select("year")->groupBy("year")->get()->toArray());
$year = $year_max["year"];
$definitions = Definitions::all();
$category = $definitions->where("name", "branch")->first();
$trusts = Trusts::groupBy("registry")->select("id", "branch", "type", "scope", "theme", "unit", "settlor", "fiduciary", 'income', 'yield', 'expenses', 'availability', 'initial_amount', 'year')->where("year", $year)->get();
return view('home')->with(['main_article' => $main_article, 'articles' => $articles, 'file_url' => '/images/articles/', 'months' => $this->months, 'trusts' => $trusts, 'categories' => $categories, 'category' => $category, 'definitions' => $definitions, 'year' => $year]);
}