public function run()
{
$model = new Filter();
$model->city = $this->city;
$model->date_n = $this->date_n;
$model->time_n = $this->time_n;
$model->language = $this->language;
$model->guide = $this->guide;
/*CITY*/
$citys = SegCities::model()->findAll();
/*TIME*/
$times = SegStarttimes::model()->findAll();
/*LANGUAGE*/
$languages = Languages::model()->findAll();
/*GUIDE*/
$criteria = new CDbCriteria();
$criteria->condition = 'cities_id=:cities_id';
$criteria->params = array(':cities_id' => $this->city);
//$criteria->join = 'LEFT JOIN `users` ON (`users`.`id` = `t`.`users_id`)';
$guides_link = SegGuidesCities::model()->findAll($criteria);
$guides = array();
$i = 0;
foreach ($guides_link as $item) {
$criteria_1 = new CDbCriteria();
$criteria_1->condition = 'id=:id';
$criteria_1->params = array(':id' => $item->users_id);
$guides_contact = User::model()->find($criteria_1);
// print_r($guides_contact);
$criteria_2 = new CDbCriteria();
$criteria_2->condition = 'idcontacts=:idcontacts';
$criteria_2->params = array(':idcontacts' => $guides_contact->id_contact);
$guides[$i] = SegContacts::model()->find($criteria_2);
$i++;
}
$this->render('dopMenuFilter', array('citys' => $citys, 'times' => $times, 'languages' => $languages, 'guides' => $guides, 'model' => $model));
}
public function loadContact($id)
{
$model=SegContacts::model()->findByPk($id);
if($model===null)
throw new CHttpException(404,'The requested page does not exist.');
return $model;
}
public function loadGuide()
{
$gdata = SegGuidesdata::model()->findByPk(Yii::app()->user->gid);
$gcontact= SegContacts::model()->findByPk(Yii::app()->user->cid);
$city= SegGuidesCities::model()->with('cities')->find("users_id=:user",array(':user'=>Yii::app()->user->id));
$tel="";
if(!($city==null)) $tel=$city->cities->localPhone;
// if(!($city==null)) $tel=$city;
if(($gdata===null)||($gcontact===null))
throw new CHttpException(404,'The requested user data is missing.');
return array('data'=>$gdata,'contact'=>$gcontact,'tel'=>$tel);
}
