/**
* @param \Sofa\Eloquence\Builder $query
* @return mixed
*/
public function scopeBuilder($query)
{
return $query->join('007_171_hotel_lang', '007_170_hotel.id_170', '=', '007_171_hotel_lang.id_171')->join('001_001_lang', '007_171_hotel_lang.lang_id_171', '=', '001_001_lang.id_001')->join('001_002_country', function ($join) {
$join->on('007_170_hotel.country_id_170', '=', '001_002_country.id_002')->on('001_002_country.lang_id_002', '=', '001_001_lang.id_001');
})->leftJoin('001_003_territorial_area_1', '007_170_hotel.territorial_area_1_id_170', '=', '001_003_territorial_area_1.id_003')->leftJoin('001_004_territorial_area_2', '007_170_hotel.territorial_area_2_id_170', '=', '001_004_territorial_area_2.id_004')->leftJoin('007_150_environment', function ($join) {
$join->on('007_170_hotel.environment_170', '=', '007_150_environment.id_150')->on('007_150_environment.lang_id_150', '=', '007_171_hotel_lang.lang_id_171');
})->leftJoin('007_151_decoration', function ($join) {
$join->on('007_170_hotel.decoration_170', '=', '007_151_decoration.id_151')->on('007_151_decoration.lang_id_151', '=', '007_171_hotel_lang.lang_id_171');
})->leftJoin('007_152_relationship', function ($join) {
$join->on('007_170_hotel.relationship_170', '=', '007_152_relationship.id_152')->on('007_152_relationship.lang_id_152', '=', '007_171_hotel_lang.lang_id_171');
});
}
/**
* @param \Sofa\Eloquence\Builder $query
* @return mixed
*/
public function scopeBuilder($query)
{
return $query->join('014_181_spa_lang', '014_180_spa.id_180', '=', '014_181_spa_lang.id_181')->join('001_001_lang', '014_181_spa_lang.lang_id_181', '=', '001_001_lang.id_001')->join('001_002_country', function ($join) {
$join->on('014_180_spa.country_id_180', '=', '001_002_country.id_002')->on('001_002_country.lang_id_002', '=', '001_001_lang.id_001');
})->leftJoin('001_003_territorial_area_1', '014_180_spa.territorial_area_1_id_180', '=', '001_003_territorial_area_1.id_003')->leftJoin('001_004_territorial_area_2', '014_180_spa.territorial_area_2_id_180', '=', '001_004_territorial_area_2.id_004');
}
