public function loadTC($id)
{
$model=TourCategories::model()->findByPk($id);
if($model===null)
throw new CHttpException(404,'The requested page does not exist.');
return $model;
}
<?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',
'route_bigpic',
'route_pic',
'pic_icon',
'pdf_path',
'base_price',
'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'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'shorttext'); ?>
<?php echo $form->textField($model,'shorttext',array('size'=>60,'maxlength'=>100)); ?>
<?php echo $form->error($model,'shorttext'); ?>
</div>
<div class="row">
public function actionProfile()
{
$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;
$id = Yii::app()->user->id;
$model=$this->loadUser($id);
/*CASH*/
if($role_control==5){
//guidesdata
$user = User::model()->findByPk($id);
$guidesdata = SegGuidesdata::model()->findByPk($user->id_guide);
//segguidestourroutes
$criteria_t=new CDbCriteria;
$criteria_t->condition='usersid=:usersid';
$criteria_t->params=array(':usersid'=>$id);
$link_tourroutes = SegGuidesTourroutes::model()->findAll($criteria_t);
$array_tour = array();
$array_tour_link = array();
if(isset($link_tourroutes)) {
$criteria_a=new CDbCriteria;
$criteria_a->condition='users_id=:users_id';
$criteria_a->params=array(':users_id'=>$id);
$a = SegGuidesCities::model()->find($criteria_a)->cities_id;
$i=0;
foreach($link_tourroutes as $item) {
$b = $item->tourroutes_id;
$criteria_tour=new CDbCriteria;
$criteria_tour->condition='id_tour_categories=:id_tour_categories AND cityid=:cityid';
$criteria_tour->params=array(':id_tour_categories'=>$b,'cityid'=>$a);
$tourroute = SegTourroutes::model()->find($criteria_tour);
$array_tour[$i] = $tourroute;
$array_tour_link[$i] = $item;
if($i==0) {
$array_tour_link[$i]->base_provision0 = $item->base_provision;
$array_tour_link[$i]->guest_variable0 = $item->guest_variable;
$array_tour_link[$i]->guestsMinforVariable0 = $item->guestsMinforVariable;
$array_tour_link[$i]->voucher_provision0 = $item->voucher_provision;
}
if($i==1) {
$array_tour_link[$i]->base_provision1 = $item->base_provision;
$array_tour_link[$i]->guest_variable1 = $item->guest_variable;
$array_tour_link[$i]->guestsMinforVariable1 = $item->guestsMinforVariable;
$array_tour_link[$i]->voucher_provision1 = $item->voucher_provision;
}
if($i==2) {
$array_tour_link[$i]->base_provision2 = $item->base_provision;
$array_tour_link[$i]->guest_variable2 = $item->guest_variable;
$array_tour_link[$i]->guestsMinforVariable2 = $item->guestsMinforVariable;
$array_tour_link[$i]->voucher_provision2 = $item->voucher_provision;
}
$i++;
}
}
}
/*CITY*/
$criteria_city = new CDbCriteria;
$criteria_city->condition = 'users_id=:users_id';
$criteria_city->params = array(':users_id' => $id);
$city_link = SegGuidesCities::model()->find($criteria_city);
$city='';
if(isset($city_link))$city = SegCities::model()->findByPk($city_link->cities_id);
/*TOUR*/
$criteria = new CDbCriteria;
$criteria->condition = 'usersid=:usersid';
$criteria->params = array(':usersid' => $id);
$tourcat = SegGuidesTourroutes::model()->findAll($criteria);
$tour_categories_user='';
if(isset($tourcat)){
$j=0;
foreach($tourcat as $tourcat_item){
$model_tour = new TourUser;
$criteria_tourcat = new CDbCriteria;
$criteria_tourcat->condition = 'id_tour_categories=:id_tour_categories';
$criteria_tourcat->params = array(':id_tour_categories' => $tourcat_item->tourroutes_id);
$name_tourcat = TourCategories::model()->find($criteria_tourcat);
$model_tour->cat = $name_tourcat->name;
$criteria_tour = new CDbCriteria;
$criteria_tour->condition = 'id_tour_categories=:id_tour_categories AND cityid=:cityid';
$criteria_tour->params = array(':id_tour_categories' => $tourcat_item->tourroutes_id, ':cityid' => $city->idseg_cities);
$tour = SegTourroutes::model()->find($criteria_tour);
$model_tour->tourname = $tour->name;
$tour_categories_user[$j]=$model_tour;
$j++;
}
}else{$tourcat='';}
/*LANGUADGE*/
$criteria_lan = new CDbCriteria;
$criteria_lan->condition = 'users_id=:users_id';
$criteria_lan->params = array(':users_id' => $id);
$lancat = SegLanguagesGuides::model()->findAll($criteria_lan);
$lan_ob_user='';
if(isset($lancat)){
$i=0;
foreach($lancat as $lancat_item){
$criteria_lani = new CDbCriteria;
$criteria_lani->condition = 'id_languages=:id_languages';
$criteria_lani->params = array(':id_languages' => $lancat_item->languages_id);
$lan_ob = Languages::model()->find($criteria_lani);
$lan_ob_user[$i]=$lan_ob;
$i++;
}
}else{$lancat='';}
$test=array('guide'=>$this->loadGuide(),'tours'=>$this->loadTours(),'todo'=>$this->loadUnreported());
if($role_control==5){
$this->render('profile',array(
'model'=>$model,
'tourcat'=>$tour_categories_user,
'lan_obs'=>$lan_ob_user,
'city'=>$city,
/*cash*/
'link_tourroutes'=>$link_tourroutes,
'guidesdata'=>$guidesdata,
'user'=>$user,
'array_tour' => $array_tour,
'array_tour_link' => $array_tour_link,
'info'=>$test,
));
} else{
$this->render('profile',array(
'model'=>$model,
'tourcat'=>$tour_categories_user,
'lan_obs'=>$lan_ob_user,
'city'=>$city,
'info'=>$test,
));
}
}
