/var/www/vhosts/nabawater/backend/models
Edit: /var/www/vhosts/nabawater/backend/models/Country.php (1988B)
alias('C')
->select([
'C.country_id',
'CL.country_name',
'C.country_code'
])
->leftJoin(['CL' => CountryLang::tableName()], 'CL.country_id = C.country_id')
->where(['C.country_status' => Country::ACTIVE])
->asArray()
->all();
if (!empty($countryDataArray)) {
return ArrayHelper::map($countryDataArray, 'country_id', 'country_name');
} else {
return [];
}
}
/**
*
* @return array
*/
public function attributeLabels()
{
return [
'country_name' => yii::t('backend','Country Name'),
'country_code' => Yii::t('backend', 'Country Code'),
'country_status' => Yii::t('backend', 'Country Status')
];
}
public function getcountry()
{
$country = Country::find()
->alias('C')
->select([
'CL.country_id',
'CL.country_name'
])
->leftJoin(['CL' => CountryLang::tableName()], 'CL.country_id = C.country_id')
->where(['C.country_status' => 1])
->asArray()
->all();
$country = ArrayHelper::map($country, 'country_id', 'country_name');
if (!empty($country)) {
return $country;
} else {
return [];
}
}
}