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); }