Skip to content

Instantly share code, notes, and snippets.

@lazychaser

lazychaser/Categories with lang.php

Last active April 3, 2016 10:27
Show Gist options
  • Save lazychaser/aff4855668ec86da4017266c15e66282 to your computer and use it in GitHub Desktop.
Save lazychaser/aff4855668ec86da4017266c15e66282 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Categories with lang.php
$lang = 'de';
$rootId = 1;
$categories = Category::whereDescendantOf($rootId)
->leftJoin('category_translations as tr', 'tr.category_id', '=', 'categories.id')
->where('tr.code', '=', $lang)
->get([ 'categories.*', 'tr.name' ])
->toTree();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment