app/Http/Controllers/ReportEnterpriseController.php
/**
	 * Generate reports by soccer team
	 *
	 * @return Response
	 */
Generate reports by soccer team
@return Response
Generate reports by soccer team @return Response
public function generateSoccerTeamReport($start, $end)
	{
		$soccerTeamReport = User::select('soccerTeam', \DB::raw("count(users.soccerTeam) as thanks"))->whereBetween('thanksDateTime', array(new Carbon($start), new Carbon($end)))->join('enterprise_thanks', 'enterprise_thanks.user_id', '=', 'users.id')->groupBy('users.soccerTeam')->get();
		return $soccerTeamReport;
	}
public function generateSoccerTeamReport ( $ start , $ end ) { $ soccerTeamReport = User :: select ( 'soccerTeam' , \ DB :: raw ( " count(users.soccerTeam) as thanks " ) ) -> whereBetween ( 'thanksDateTime' , array ( new Carbon ( $ start ) , new Carbon ( $ end ) ) ) -> join ( 'enterprise_thanks' , 'enterprise_thanks.user_id' , '=' , 'users.id' ) -> groupBy ( 'users.soccerTeam' ) -> get ( ) ; return $ soccerTeamReport ; }
Generate reports by soccer team
 @return Response
Generate reports by soccer team @return Response