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 getCitiesList() { $usersArray = CHtml::listData(SegCities::model()->findAll(), 'idseg_cities', 'seg_cityname'); return $usersArray; }
public function run() { $citys = SegCities::model()->findAll(); $model = new Searchmain(); $this->render('formMain2', array('citys' => $citys, 'model' => $model)); }
<? $citys = SegCities::model()->findAll(); $last_search = Yii::app()->session->get('last_search'); if($last_search !='') $arr = json_decode($last_search); $opt_city = ''; foreach($citys as $val){ $sel=''; if($model->city_ob->webadress_en == $val->webadress_en) $sel = 'selected'; $opt_city .= '<option value="'.$val->idseg_cities.'" data-city="'.$val->webadress_en.'" '.$sel.'>'.$val->seg_cityname.'</option>'; }; $times = SegStarttimes::model()->findAll(); $opt_time=''; foreach($times as $val){ $tm = str_replace("00:00","00",$val->timevalue); $sel=''; if(isset($_POST['SegScheduledTours']['starttime']) || !empty($arr->starttime)){ if(!empty($arr->starttime) && $arr->starttime == $val->timevalue) $sel = 'selected'; if(@$_POST['SegScheduledTours']['starttime'] == $val->timevalue) $sel = 'selected'; } $opt_time .= '<option value="'.$val->timevalue.'" '.$sel.'>'.$tm.'</option>'; }; $lang = Languages::model()->findAll(); $opt_lang=''; foreach($lang as $val){ $sel=''; if(isset($_POST['SegScheduledTours']['language_id']) || !empty($arr->language_id)){ if(!empty($arr->language_id) && $arr->language_id == $val->id_languages) $sel = 'selected'; if(isset($_POST['SegScheduledTours']['language_id'])){ if($_POST['SegScheduledTours']['language_id'] == $val->id_languages) $sel = 'selected'; }
public function loadCity($id) { $model=SegCities::model()->findByPk($id); if($model===null) throw new CHttpException(404,'The requested page does not exist.'); return $model; }
<?php $form=$this->beginWidget('CActiveForm', array( 'id'=>'seg-tourroutes-form', // Please note: When you enable ajax validation, make sure the corresponding // controller action is handling ajax validation correctly. // There is a call to performAjaxValidation() commented in generated controller code. // See class documentation of CActiveForm for details on this. 'enableAjaxValidation'=>false, 'htmlOptions'=>array('enctype'=>'multipart/form-data'), )); ?> <?php echo $form->errorSummary($model); ?> <div class="row"> <?php echo $form->labelEx($model,'city'); ?> <?php $list = CHtml::listData(SegCities::model()->findAll(), 'idseg_cities', 'seg_cityname'); ?> <?php echo $form->dropDownList($model,'city',$list,array('empty' => '')); ?> <?php echo $form->error($model,'city'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'tour_categories'); ?> <?php $list = CHtml::listData(TourCategories::model()->findAll(), 'id_tour_categories', 'name'); ?> <?php echo $form->dropDownList($model,'tour_categories',$list,array('empty' => '')); ?> <?php echo $form->error($model,'tour_categories'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'name'); ?> <?php echo $form->textField($model,'name',array('size'=>45,'maxlength'=>45)); ?> <?php echo $form->error($model,'name'); ?>
<?php /* @var $this SegScheduledToursController */ /* @var $model SegScheduledTours */ /* @var $form CActiveForm */ ?> <div class="wide-form"> <?php $form = $this->beginWidget('CActiveForm', array('id' => 'search-form', 'action' => array("dispatch"), 'method' => 'post')); ?> <div class="row-filter"> <div class="form-group"> <?php echo $form->dropDownList($model, 'city_id', CHtml::listData(SegCities::model()->findAll(), 'idseg_cities', 'seg_cityname'), array('id' => 'pickcity', 'onChange' => 'do_city(value,0)')); ?> </div> </div> <div class="row-filter"> <div class="form-group"> <?php $this->widget('zii.widgets.jui.CJuiDatePicker', array('name' => 'SegScheduledTours[date]', 'attribute' => 'date', 'model' => $model, 'options' => array('showAnim' => 'fold', 'dateFormat' => 'dd.mm.yy'), 'htmlOptions' => array('class' => 'form-control-date-filter'))); // echo $form->textField($model,'date'); ?> </div> </div> <div class="row-filter"> <div class="form-group"> <?php echo $form->dropDownList($model, 'starttime', CHtml::listData(SegStarttimes::model()->findAll(), 'timevalue', 'timevalue'), array('empty' => 'Uhrzeit', 'id' => 'picktime'));
public function actionIndex($cont = 'index', $act = '', $id = '', $nn = '') { ////change language /// language files protected/massages $host = str_replace("www.", "", $_SERVER['HTTP_HOST']); switch ($host) { case Yii::app()->params['site_de']: Yii::app()->language = 'de'; break; case Yii::app()->params['site_en']: Yii::app()->language = 'en'; break; } if (Yii::app()->user->isGuest) { $this->redirect(array('/admin')); } ///// if ($cont == 'index') { list($site) = Yii::app()->createController('SegScheduledTours'); $site->actionIndex(); } else { if ($cont == 'ajaxSearchTours') { list($site) = Yii::app()->createController('SegScheduledTours'); $site->actionAjaxSearchTours(); } else { if ($act === 'book') { $sp = ''; if (isset($_POST["search-params"])) { $sp = $_POST["search-params"]; } $bp = ''; if (isset($_POST["book-params"])) { $bp = $_POST["book-params"]; } Yii::app()->user->setState('city_data', $sp); Yii::app()->user->setState('book_data', $bp); $model_city = SegCities::model()->find('webadress_en=:webadress_en', array(':webadress_en' => $cont)); $id_city = $model_city->idseg_cities; list($site) = Yii::app()->createController('SegScheduledTours'); $site->actionBook($id_city); } else { if ($act === 'thankyousend') { list($site) = Yii::app()->createController('Thankyousend'); $site->actionIndex(); } else { $model_city = SegCities::model()->find('webadress_en=:webadress_en', array(':webadress_en' => $cont)); if ($model_city) { $id_city = $model_city->idseg_cities; if ($id_city > 0) { list($site) = Yii::app()->createController('SegScheduledTours'); $site->actionCity($id_city); } else { $this->redirect(array('')); } } else { $this->redirect(array('')); } } } } } }
<h1>Week Schedule</h1> </section> <!-- Main content --> <section class="content"> <?php $form=$this->beginWidget('CActiveForm', array( 'id'=>'date-form', 'htmlOptions'=>array( 'name'=>'date-form', ), 'enableAjaxValidation'=>true, )); ?> <div class="create" style="text-align: left;">Timetable for the city of <?php echo $form->dropDownList($model,'city_id', CHtml::listData (SegCities::model()->findAll(), 'idseg_cities', 'seg_cityname'),array("style"=>"margin:0 5px;")); // echo CHtml::link("show","javascript:void(0);",array('onclick'=>'newtourist();','style'=>'background-color:##FFE495;')); echo $form->labelEx($model,'from_date',array('style'=>'margin-right:5px;')); $this->widget('zii.widgets.jui.CJuiDatePicker', array( 'name'=>'SegScheduledTours[from_date]', 'attribute'=>'from_date', // Model attribute filed which hold user input 'model'=>$model, // Model name 'language'=>'de', 'options'=>array( 'showAnim'=>'fold', 'dateFormat'=>'yy-mm-dd', ), 'htmlOptions'=>array( 'class'=>'form-control-date-filter', ), ));
/* @var $this SegScheduledToursController */ /* @var $model SegScheduledTours */ /* @var $form CActiveForm */ ?> <div class="wide-form"> <?php $form=$this->beginWidget('CActiveForm', array( 'id'=>'search-form', 'action'=>array("dispatch"), 'method'=>'post', )); ?> <div class="row-filter"> <div class="form-group"> <?php echo $form->dropDownList($model,'city_id', CHtml::listData (SegCities::model()->findAll(),'idseg_cities', 'seg_cityname'), array('id'=>'pickcity','onChange'=>'do_city(value,0)')); ?> </div> </div> <div class="row-filter"> <div class="form-group"> <?php $this->widget('zii.widgets.jui.CJuiDatePicker', array( 'name'=>'SegScheduledTours[date]', 'attribute'=>'date', // Model attribute filed which hold user input 'model'=>$model, // Model name // 'value'=>$model->isNewRecord ? date('dd.mm.yy') : '', // 'value'=>$model->isNewRecord ? date('dd-mm-yy') : '', 'options'=>array(
public function actionShow($id) { $id_control = Yii::app()->user->id; // $update_user = User::model()->findByPk($id_user); $role_control = User::model()->findByPk($id_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 = $this->loadModel($id); //city //$citie->seg_cityname = ''; $j = 0; $criteria_city = new CDbCriteria(); $criteria_city->condition = 'users_id=:users_id'; $criteria_city->params = array(':users_id' => $model->guide1_id); $city = SegGuidesCities::model()->find($criteria_city); if (isset($city)) { $criteria_c = new CDbCriteria(); $criteria_c->condition = 'idseg_cities=:idseg_cities'; $criteria_c->params = array(':idseg_cities' => $city->cities_id); $citie = SegCities::model()->find($criteria_c); $model->city_id_all = $citie->seg_cityname; $j = $citie->idseg_cities; } else { $model->city_id_all = 'no element'; } //language if ($model->language_id == NULL) { $i = 0; $criteria_language = new CDbCriteria(); $criteria_language->condition = 'users_id=:users_id'; $criteria_language->params = array(':users_id' => $model->guide1_id); $language = SegLanguagesGuides::model()->findAll($criteria_language); if (isset($language)) { foreach ($language as $item) { $criteria_i = new CDbCriteria(); $criteria_i->condition = 'id_languages=:id_languages'; $criteria_i->params = array(':id_languages' => $item->languages_id); $languages = Languages::model()->findAll($criteria_i); $model->language_id_all[$i] = $languages; $i++; } } else { $model->language_id_all[0] = 'no element'; } } else { $criteria_i = new CDbCriteria(); $criteria_i->condition = 'id_languages=:id_languages'; $criteria_i->params = array(':id_languages' => $model->language_id); $language = Languages::model()->find($criteria_i); $model->language_id_all[0] = $language; } //tour canegories + tourroute //$tourroute_id_all; $z = 0; $criteria_tour = new CDbCriteria(); $criteria_tour->condition = 'usersid=:usersid'; $criteria_tour->params = array(':usersid' => $model->guide1_id); $tourcats = SegGuidesTourroutes::model()->findAll($criteria_tour); if (isset($tourcats)) { foreach ($tourcats as $tourroute) { $criteria_t = new CDbCriteria(); $criteria_t->condition = 'id_tour_categories=:id_tour_categories AND cityid=:cityid'; $criteria_t->params = array(':id_tour_categories' => $tourroute->tourroutes_id, ':cityid' => $j); $tourroutes = SegTourroutes::model()->find($criteria_t); $model->tourroute_id_all[$z] = $tourroutes->name; $z++; } } else { $model->tourroute_id_all[0] = 'no element'; } $this->render('show', array('model' => $model)); }
</section> <!-- Main content --> <section class="content"> <?php $this->widget('zii.widgets.grid.CGridView', array( 'id'=>'seg-tourroutes-grid', 'dataProvider'=>$model->search(), 'filter'=>$model, 'columns'=>array( // 'idseg_tourroutes', array( 'name'=>'city', 'value'=>'$data->city->seg_cityname', 'filter'=>CHtml::listData(SegCities::model()->findAll(), 'idseg_cities', 'seg_cityname'), ), array( 'name'=>'tour_categories', 'value'=>'$data->tour_categories->name', 'filter'=>CHtml::listData(TourCategories::model()->findAll(), 'id_tour_categories', 'name'), ), 'name', 'base_price', 'standard_duration', // 'maintext', // 'shorttext', // 'TNmin', // 'TNmax', /* 'inDevelopment',
public function actionAjax_Show() { if (!Yii::app()->request->isAjaxRequest) { echo "No data"; exit; } $id= $_POST['id']; $model=$this->loadST($id); //city //$citie->seg_cityname = ''; $j=0; $criteria_city = new CDbCriteria; $criteria_city->condition = 'users_id=:users_id'; $criteria_city->params = array(':users_id' => $model->guide1_id); $city = SegGuidesCities::model()->find($criteria_city); if(isset($city)){ $criteria_c = new CDbCriteria; $criteria_c->condition = 'idseg_cities=:idseg_cities'; $criteria_c->params = array(':idseg_cities' => $city->cities_id); $citie = SegCities::model()->find($criteria_c); $model->city_id_all = $citie->seg_cityname; $j = $citie->idseg_cities; }else{ $model->city_id_all = 'no element'; } //language if($model->language_id==NULL){ $i=0; $criteria_language = new CDbCriteria; $criteria_language->condition = 'users_id=:users_id'; $criteria_language->params = array(':users_id' => $model->guide1_id); $language = SegLanguagesGuides::model()->findAll($criteria_language); if(isset($language)){ foreach($language as $item){ $criteria_i = new CDbCriteria; $criteria_i->condition = 'id_languages=:id_languages'; $criteria_i->params = array(':id_languages' => $item->languages_id); $languages = Languages::model()->findAll($criteria_i); $model->language_id_all[$i] = $languages; $i++; } }else{ $model->language_id_all[0] = 'no element'; } }else{ $criteria_i = new CDbCriteria; $criteria_i->condition = 'id_languages=:id_languages'; $criteria_i->params = array(':id_languages' => $model->language_id); $language = Languages::model()->find($criteria_i); $model->language_id_all[0] = $language; } //tour canegories + tourroute //$tourroute_id_all; $z=0; $criteria_tour = new CDbCriteria; $criteria_tour->condition = 'usersid=:usersid'; $criteria_tour->params = array(':usersid' => $model->guide1_id); $tourcats = SegGuidesTourroutes::model()->findAll($criteria_tour); if(isset($tourcats)){ foreach($tourcats as $tourroute){ $criteria_t = new CDbCriteria; $criteria_t->condition = 'id_tour_categories=:id_tour_categories AND cityid=:cityid'; $criteria_t->params = array(':id_tour_categories' => $tourroute->tourroutes_id, ':cityid'=>$j); $tourroutes = SegTourroutes::model()->find($criteria_t); $model->tourroute_id_all[$z] = $tourroutes->name; $z++; } }else{ $model->tourroute_id_all[0] = 'no element'; } $result=$this->renderPartial('ajaxshow',array('model'=>$model)); }
<div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <h1>Tourplan</h1> </section> <?php $this->beginWidget('CActiveForm', array( 'id'=>'current-subscriber-form', 'enableAjaxValidation'=>false, )); ?> <input type="hidden" name="newrecord" id="newrecord" value="0"> <div class="create" style="text-align: left;">Neue Tour anlege <?php echo CHtml::dropDownList('new_city',0, CHtml::listData (SegCities::model()->findAll(), 'idseg_cities', 'seg_cityname'),array("style"=>"margin:0 5px;")); echo CHtml::link("erstellen","javascript:void(0);",array('onclick'=>'newtourist();','style'=>'background-color:##FFE495;')); $this->endWidget(); ?> </div> <!-- Main content --> <section class="content"> <?php $form=$this->beginWidget('CActiveForm', array( 'id'=>'date-form', 'htmlOptions'=>array( 'name'=>'date-form', ), 'enableAjaxValidation'=>true, )); ?> <div class="row">
<?php /* @var $this SegScheduledToursController */ /* @var $model SegScheduledTours */ /* @var $form CActiveForm */ //echo chtml::link("Go", $this->createUrl("city",array('city'=>'munchen'))); ?> <div class="wide-form"> <?php $form = $this->beginWidget('CActiveForm', array('action' => array("dispatch"), 'id' => 'front-form', 'method' => 'post')); ?> <div class="row-filter"> <?php $cities = SegCities::model()->findAll(array('select' => 'idseg_cities,seg_cityname,webadress_en')); echo $form->dropDownList($model, 'city_id', CHtml::listData($cities, 'idseg_cities', 'seg_cityname'), array('empty' => 'Wo geht es hin?', 'id' => 'pickcity', 'onChange' => 'do_city(value,0)')); ?> <?php $this->widget('zii.widgets.jui.CJuiDatePicker', array('name' => 'SegScheduledTours[date]', 'attribute' => 'date', 'model' => $model, 'options' => array('showAnim' => 'fold', 'dateFormat' => 'dd.mm.yy'), 'htmlOptions' => array('class' => 'form-control-date-filter'))); // echo $form->textField($model,'date'); // ?> <button class="but-filter" type="submit" style="width:160px;"><?php echo 'SUCHE'; ?> </button> <?php // echo CHtml::submitButton('SUCHE',array('class'=>'but-filter','type'=>'submit')); ?> <?php