/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return CitySitePhone the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = CitySitePhone::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function actionSYNInfo()
{
//$models = CitySitePhone::model()->findAllByAttributes(array('active'=>1, 'main_center'=>1));
$criteria = new CDbCriteria();
$criteria->with = array('city', 'site');
$criteria->together = true;
//$criteria->compare('city.main_city',1);
$criteria->compare('t.active', 1);
$models = CitySitePhone::model()->findAll($criteria);
if ($models) {
$json = array();
$city = '';
foreach ($models as $model) {
//$json[] = array('phone'=>$model->phone, 'city'=>$model->city->city, 'site'=>$model->site->site);
//если город основной тогда выводим его название, если нет тогда выводим название рег. центра
if ($model->city->main_city == 1) {
$json[] = array('phone' => $model->phone, 'city' => $model->city->city, 'site' => $model->site->site, 'direct_phone' => $model->direct_phone, 'google_phone' => $model->google_phone);
} else {
$json[] = array('phone' => $model->phone, 'city' => $model->city->region->city, 'site' => $model->site->site, 'direct_phone' => $model->direct_phone, 'google_phone' => $model->google_phone);
}
}
echo json_encode($json);
}
}
