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 actionSpontan()
{
$id_control = Yii::app()->user->id;
// $update_user = User::model()->findByPk($id_user);
$user_control = User::model()->findByPk($id_control);
$role_control = $user_control->id_usergroups;
// $id_guide = SegGuidesdata::model()->findByPk($update_user->id_guide)->idseg_guidesdata;
if ($role_control == 1) {
$this->layout = "root";
}
if ($role_control == 2) {
$this->layout = "admin";
}
if ($role_control == 3) {
$this->layout = "office";
}
if ($role_control == 5) {
$this->layout = "guide";
}
$model = new SegScheduledTours();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['SegScheduledTours'])) {
//$model->attributes=$_POST['SegScheduledTours'];
$datetime = strtotime($_POST['SegScheduledTours']['date_time']);
$date_bd = date('Y-m-d', $datetime);
//starttime
$model->starttime = date('H:i:s', $datetime);
//date_now
$model->date_now = strtotime(date('d.m.Y', $datetime));
$model->date = $date_bd;
//guide1_id
$model->guide1_id = $id_control;
//original_starttime
$model->original_starttime = '00:00:00';
//visibility
$model->visibility = 1;
//city_id
$criteria = new CDbCriteria();
$criteria->condition = 'users_id=:users_id';
$criteria->params = array(':users_id' => $id_control);
$model->city_id = SegGuidesCities::model()->find($criteria)->cities_id;
if ($model->save()) {
$this->redirect(array('admin'));
}
}
$this->render('spontan', array('model' => $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);
}
