/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/TimeZone.php (1037B)
alias('t')
->select([
'time_zone_name',
'CONCAT(country_name, " - ", time_zone_name) AS full_name'
])
->innerJoin(
['C' => Country::tableName()],
'C.country_iso = t.country_code'
)
->innerJoin(['CL' => CountryLang::tableName()], 'CL.country_id = C.country_id AND CL.language_code = "'.\Yii::$app->language.'"')
->where(['C.country_status' => self::ACTIVE])
->asArray()
->All();
if (!empty($responseArray)) {
return ArrayHelper::map($responseArray,'time_zone_name','full_name');
} else {
return [];
}
}
}