Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $users = DB::table('serins')
- ->join('nomina_user', 'nomina_user.id', 'serins.nominau_id')
- ->where('nomina_user.user_id', Auth::id())
- ->selectRaw('COUNT(*) as count')
- ->whereYear('fecha', date('Y'))
- ->groupBy(DB::raw("MONTH(fecha)"))
- ->pluck('count');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement