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