/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public static function getViewModel() { $years = DB::table('contributions')->select(DB::raw('DISTINCT YEAR(contributions.month_year ) years'))->orderBy('years', 'desc')->get(); $years_list = []; foreach ($years as $item) { $years_list[$item->years] = $item->years; } $months_list = Util::getArrayMonths(); return ['years_list' => $years_list, 'months_list' => $months_list]; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $last_ipc_rate = IpcRate::orderBy('month_year', 'desc')->first(); $data = ['last_ipc_rate' => $last_ipc_rate, 'months' => Util::getArrayMonths()]; return view('ipc_rate.index', $data); }