Esempio n. 1
0
function getTariByTheme($ThemeID = false)
{
    $oraseByTheme = Tari::join('hoteluri', 'geo_tari.AidaID', '=', 'hoteluri.Country')->select('geo_tari.id', 'geo_tari.Name')->distinct('geo_tari.id')->where('hoteluri.Themes', 'LIKE', '%|' . $ThemeID . '|%')->where('geo_tari.Activ', 1)->orderBy('geo_tari.id', 'asc')->get();
    return $oraseByTheme;
}