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
