示例#1
0
 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));
 }
示例#2
0
<?
$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';
		}
示例#3
0
	public function loadStarttime($id)
	{
		$model=SegStarttimes::model()->findByPk($id);
		if($model===null)
			throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}
示例#4
0
文件: _select.php 项目: emisdb/cherry
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'));
?>
		</div>
		</div>
	<div class="row-filter">
				<?php 
echo $form->dropDownList($model, 'language_id', CHtml::listData(Languages::model()->findAll(), 'id_languages', 'germanname'), array('empty' => 'Sprache', 'id' => 'picklang'));
?>
	</div>
	<div class="row-filter">
				<?php 
$gui = new User('search_gn');
echo $form->dropDownList($model, 'guide1_id', CHtml::listData($gui->search_gn(), 'id', 'guidename'), array('empty' => 'Guide', 'id' => 'pickguide'));
?>
	</div>
示例#5
0
                        echo "Total scheduled tours:".$data->getTotalItemCount();
                        foreach ($data->getData() as $value) {
                        $arr[$value->guidename][]=array($value->date,$value->starttime,$value->original_starttime);
                         
                     }
                     ?>
                     <table class='table shorttable' >
                        <thead>
                    <tr>
                    <td>Zeitintervall</td>
                    <?php foreach($arr as $key => $value){ echo "<td>".$key."</td>";} ?>
                     </tr>
                        </thead>
                        <tbody>
                         <?php
                   $start_times_tour =SegStarttimes::model()->findAll(); 
                   $carr=count($arr);

                    $dt =date_create($model->from_date);
                    $interval=new DateInterval( "P1D" );

                    for($inx=0;$inx<7;$inx++){

                        $date_format=date_timestamp_get($dt);
                        $curdate=Yii::app()->dateFormatter->format('EEEE, dd-MMMM-yyyy',$date_format);	
                        date_add($dt,$interval);
                        echo "<tr><td class='daterow' colspan='".($carr+1)."'>".$curdate."</td></tr>";
                              foreach($start_times_tour as $item){
                               echo "<tr><td>".Yii::app()->dateFormatter->format('HH:mm',strtotime($item->timevalue))."</td>";
                               $classp="even";
                               foreach($arr as $value){
示例#6
0
文件: _select.php 项目: emisdb/cherry
					),
					'htmlOptions'=>array(
						'class'=>'form-control-date-filter',
 					),				
//				  'fontSize'=>'0.8em'
				 )
			  );	
	
//			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(),/*'idseg_starttimes'*/'timevalue', 'timevalue'),
					array('empty'=>'Uhrzeit','id'=>'picktime'));
			?>
		</div>
		</div>
	<div class="row-filter">
				<?php
				echo $form->dropDownList($model,'language_id', CHtml::listData (Languages::model()->findAll(),'id_languages', 'germanname'),
					array('empty'=>'Sprache','id'=>'picklang'));
			?>
	</div>
	<div class="row-filter">
				<?php
					$gui=new User('search_gn');
					echo $form->dropDownList($model,'guide1_id',CHtml::listData($gui->search_gn(),'id','guidename'),
					array('empty'=>'Guide','id'=>'pickguide'));
 public function actionWeeks($date)
 {
     $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";
     }
     //city work
     $criteria_city = new CDbCriteria();
     $criteria_city->condition = 'users_id=:users_id';
     $criteria_city->params = array(':users_id' => $id_control);
     $id_city = SegGuidesCities::model()->find($criteria_city)->cities_id;
     $model_week = array();
     $i = 0;
     $status_old = '';
     $start_times_tour = SegStarttimes::model()->findAll();
     foreach ($start_times_tour as $item) {
         $day = new DayResult();
         $day->time = $item->timevalue;
         $date_format = strtotime($date);
         $criteria = new CDbCriteria();
         $criteria->condition = 'original_starttime=:original_starttime AND date_now=:date_now AND city_id=:city_id';
         $criteria->params = array(':original_starttime' => $item->timevalue, ':date_now' => $date_format, ':city_id' => $id_city);
         $scheduled_item = SegScheduledTours::model()->find($criteria);
         if (isset($scheduled_item)) {
             $day->id = $scheduled_item->idseg_scheduled_tours;
             $day->starttime = $scheduled_item->starttime;
             if ($scheduled_item->guide1_id == $id_control) {
                 //if($scheduled_item->current_subscribers>0){
                 //    $day->status ='Belegt, braucht aber einen Guide';
                 //}else{
                 $day->status = 'Belegt, Deine Tour!';
                 //}
             } else {
                 $day->status = 'Belegt';
             }
         } else {
             $day->id = 0;
             $day->status = 'frei!';
         }
         if ($status_old == 'Belegt, Deine Tour!') {
             $day->status = 'Block';
         }
         $status_old = $day->status;
         if ($day->status == 'Belegt, Deine Tour!') {
             if ($i != 0) {
                 $model_week[$i - 1]->status = 'Block';
             }
         }
         //$day_id_old1 = $day->id;
         //$day_id_old2 = $day->id;
         // $day->status = 1;
         $model_week[$i] = $day;
         $i++;
     }
     // $model=new CActiveDataProvider($model_week);
     //  $date_format = date('Y-m-d', strtotime($date));
     $this->render('weeks', array('date' => $date, 'model' => $model_week));
 }
示例#8
0
	public function actionWeeks($date,$err=null)
	{
	    $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;
         
 
        //city work
        $criteria_city = new CDbCriteria;
        $criteria_city->condition = 'users_id=:users_id';
        $criteria_city->params = array(':users_id' => $id_control);
        $city = SegGuidesCities::model()->with('cities')->find($criteria_city);
		 
		$dt =date_create($date);

        $model_week = array();
        $start_times_tour =SegStarttimes::model()->findAll(); 
		$interval=new DateInterval( "P1D" );
//		setlocale(LC_TIME, array("de_de","de_DE", "de", "ge", "de-DE",  "de-de","DE", "ge_GE"));
			Yii::app()->setLanguage("de_de");
		for($inx=0;$inx<7;$inx++){
         $model_day = array(); $i=0;$status_old ='';
		$date_format=date_timestamp_get($dt);
//		$curdate=strftime("%A, %d-%B-%Y",$date_format);	
		$curdate=Yii::app()->dateFormatter->format('EEEE, dd-MMMM-yyyy',$date_format);	
		date_add($dt,$interval);
		 
       foreach($start_times_tour as $item){
            $day = new DayResult;
            $day->time =Yii::app()->dateFormatter->format('HH:mm',strtotime($item->timevalue)); 
            $day->date = Yii::app()->dateFormatter->format('dd.MM.yyyy',$date_format);
            
 //           $date_format =  strtotime($date);
            $criteria = new CDbCriteria;
            $criteria->condition = 'original_starttime=:original_starttime AND date_now=:date_now AND city_id=:city_id AND isCanceled=0';
            $criteria->params = array(':original_starttime' => $item->timevalue,':date_now'=>$date_format,':city_id'=>$city->cities->idseg_cities);
            $scheduled_item = SegScheduledTours::model()->find($criteria);
             if(isset($scheduled_item)){
                $day->id = $scheduled_item->idseg_scheduled_tours;
                $day->owner = $scheduled_item->guide1_id;
                $day->starttime = Yii::app()->dateFormatter->format('HH:mm',strtotime($scheduled_item->starttime));
                if($scheduled_item->guide1_id == $id_control){
                    //if($scheduled_item->current_subscribers>0){
                    //    $day->status ='Belegt, braucht aber einen Guide';
                    //}else{
                        $day->status ='Belegt, Deine Tour!';
                    //}
                }else{
                    $day->status ='Belegt';
                }
            }else{
                $day->id = 0;
                $day->status = 'frei!';
            }
            if(($status_old=='Belegt, Deine Tour!')&&($day->status == 'frei!')){
                $day->status ='Keine Aktion';
             }
            if($day->status == 'Belegt, Deine Tour!'){
                if($i!=0){
					if($status_old=='frei!')
					$model_day[$i-1]->status = 'Keine Aktion';
				}

            }
 			  $status_old = $day->status;
			  //$day_id_old1 = $day->id;
            //$day_id_old2 = $day->id;
            
            
           // $day->status = 1;
            $model_day[$i] = $day;
            $i++;
       }
           $model_week[$inx]['day'] = $model_day;
          $model_week[$inx]['label'] = $curdate;
  		}
      // $model=new CActiveDataProvider($model_week);
      //  $date_format = date('Y-m-d', strtotime($date));
  		$test=array('guide'=>$this->loadGuide(),'tours'=>$this->loadTours(),'todo'=>$this->loadUnreported());
       
		$this->render('weeks',array(
			'date'=>$date, 
			'model'=>$model_week,
 			'info'=>$test,
 			'city'=>$city,
 			'err'=>$err,
				));
	}