PHP app Tari::join示例

示例#1

文件： functii.php 项目： prodixx/cataloghotelier

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;
}