February 2015 – Max's Development Blog

For a project I’m working on, I really needed to do a groupwise max in Laravel. If you’re here, you likely don’t need an explanation of what that is, so much as how to actually bloody do it, so without further delay;

Let’s say that we have Actions, and we have an ActionLog, and you want to get the latest ActionLog entry for a series of Actions – determined by their “timestamp” field. You would write this:

    $query = DB::raw('select * from ('
        . ActionLog::whereIn('action_id', [1, 2, 3])->orderBy('timestamp', 'desc')->toSql() .
    ') group by `action_id`');

$query = DB::raw('select * from ('

. ActionLog::whereIn('action_id', [1, 2, 3])->orderBy('timestamp', 'desc')->toSql() .

') group by `action_id`');

Unfortunately there’s no way to do it without the dreaded DB::raw, but otherwise it turns out to be pretty simple.

Just attended Phunconf 5.0 yesterday. It was a great event with lots of very interesting discussions, however probably the most salient point I want to draw attention to is the following image.

To provide some context, at Phunconf events our tradition is to open the floor to the community to suggest topics for circle discussions. This year, all attendees were given two red circles, which they could put on any topic of their choice, in order for everyone to democratically pick the most popular topics which we would then discuss. The outcome was as follows:

The two post-it notes with so many circles on them that you can’t see what’s written there, are of course Angular and Laravel.

Month: February 2015

Laravel Groupwise Max

Phunconf 5.0