public function match(Travel $travel)
 {
     $em = $this->getEntityManager();
     $query = $em->createQuery('Select IDENTITY(t.user)
         From SubwayBuddyUserBundle:Travel t
         WHERE t.name = ?1
         AND t.time LIKE ?2
         AND t.user != ?3');
     $query->setParameter(1, $travel->getName());
     $query->setParameter(2, $travel->getTime());
     $query->setParameter(3, $travel->getUser());
     return $query->getResult();
 }
 public function show($id)
 {
     $travel = Travel::where('ID_Travel', '=', $id)->firstOrFail();
     $data['room'] = Rooms::select('roomtype.RoomType_Name', 'roomtype.ID_RoomType', 'roomtype_pic.Picture')->join('roomtype_pic', 'roomtype.ID_RoomType', '=', 'roomtype_pic.ID_RoomType')->where('roomtype_pic.Main_Pic', '=', 'YES')->where('roomtype.Status', '=', 'Active')->take(40)->get()->all();
     $data['offer'] = Offer::where('Status', '=', 'Active')->take(40)->get()->all();
     $data['about'] = About::get()->all();
     $package = TravelPackage::where('ID_Travel', '=', $id)->get();
     return View::make('travels.show', compact('travel'))->with('package', $package)->with('data', $data);
 }
 public function indexTravel()
 {
     $getoff_id = Offer::where('Status', '=', 'Active')->get();
     $offer = Offer::join('detail_offer', 'detail_offer.ID_Offer', '=', 'offer.ID_Offer')->join('roomtype_pic', 'roomtype_pic.ID_RoomType', '=', 'detail_offer.ID_RoomType')->join('roomtype', 'roomtype.ID_RoomType', '=', 'detail_offer.ID_RoomType')->where('offer.Status', '=', 'Active')->where('roomtype_pic.Main_Pic', '=', 'YES')->get();
     $countOffer = Offer::where('Status', '=', 'Active')->count();
     $countDetail = DetailOffer::join('offer', 'offer.ID_Offer', '=', 'detail_offer.ID_Offer')->where('offer.Status', '=', 'Active')->count();
     $rooms = Rooms::join('roomtype_pic', 'roomtype.ID_RoomType', '=', 'roomtype_pic.ID_RoomType')->where('roomtype_pic.Main_Pic', '=', 'YES')->where('roomtype.Status', '=', 'Active')->paginate(5, ['roomtype.RoomType_Name', 'roomtype.Price', 'roomtype_pic.Picture', DB::raw("CONCAT(SUBSTRING(roomtype.Description, 1, 100), '...') as IsiRoom"), 'roomtype.ID_RoomType']);
     $data['about'] = About::get()->all();
     $travel = Travel::where('ID_Travel', '=', Cache::get('travel_session'))->where('Status', '=', 'Active')->get();
     return View::make('Books.Travel.index', compact('rooms'))->with('travel', $travel)->with('data', $data)->with('countOffer', $countOffer)->with('offer', $offer)->with('countDetail', $countDetail);
 }
 /**
  * View: Video Index
  * @return Respanse
  */
 public function getVideoIndex()
 {
     $articles = Article::orderBy('created_at', 'desc')->where('post_status', 'open')->paginate(6);
     $travel = Travel::orderBy('created_at', 'desc')->where('post_status', 'open')->paginate(4);
     $product = Product::orderBy('created_at', 'desc')->where('post_status', 'open')->where('quantity', '>', '0')->paginate(12);
     $productCategories = ProductCategories::orderBy('sort_order')->where('cat_status', 'open')->get();
     $job = Job::orderBy('created_at', 'desc')->where('post_status', 'open')->paginate(4);
     $categories = Category::orderBy('sort_order')->where('cat_status', 'open')->get();
     if (Auth::check()) {
         $timeline = Timeline::orderBy('created_at', 'desc')->where('user_id', Auth::user()->id)->paginate(6);
     } else {
         $timeline = Timeline::orderBy('created_at', 'desc');
     }
     return View::make('home.videoindex')->with(compact('articles', 'categories', 'travel', 'product', 'productCategories', 'job', 'timeline'));
 }
Example #5
0
	public function actionIndex()
	{
		//查询最新的四张首页缩略图
		$focusimgs = $this->getPictureFormImg(10,4);
		//分配 10条热门产品 (即排序最靠前的十条产品)
		$tenhots = Travel::model()->findAll(array(
				'select'=>'id,title,current_audlt_price',
				'condition'=>'enabled=1',
				'order'=>'sort desc',
				'limit'=>10,
		));
		$this->render('index',array(
				'tenhots'=>$tenhots,
				'focusimgs'=>$focusimgs,
				));
	}
 public function match(Travel $travel)
 {
     $em = $this->getEntityManager();
     $query = $em->createQuery('Select IDENTITY(t.user)
         From SubwayBuddyUserBundle:Travel t
         WHERE t.name = ?1
         AND t.user != ?2
         AND YEAR(t.time) = ?3
         AND MONTH(t.time) = ?4
         AND DAY(t.time) = ?5');
     $day = $travel->getTime()->format('d');
     $year = $travel->getTime()->format('Y');
     $month = $travel->getTime()->format('m');
     //        $hour = $travel->getTime()->format('h'); TODO
     $query->setParameter(1, $travel->getName());
     $query->setParameter(2, $travel->getUser());
     $query->setParameter(3, $year);
     $query->setParameter(4, $month);
     $query->setParameter(5, $day);
     //        $query->setParameter(6,$hour); TODO
     $result = $query->getResult();
     $subjects = $travel->getUser()->getSubjects();
     $array = array();
     foreach ($result as $user) {
         $user = $this->find($user[1]);
         $userSubjects = $user->getSubjects();
         $match = false;
         foreach ($userSubjects as $subject) {
             if ($subjects->contains($subject)) {
                 $match = true;
             }
         }
         if ($match) {
             $array[] = $user;
         }
     }
     return $result;
 }
Example #7
0
 public function fee()
 {
     $this->joinWith('schedule.labors.note.ticket', false)->groupBy('schedule_id')->addSelect([Travel::tableName() . '.*', '1 - MIN(' . Ticket::tableName() . '.[[bill_type_id]]) AS [[fee]]']);
     return $this;
 }
Example #8
0
	protected function getOneTravelByPk($id)
	{
		$model = Travel::model()->findByPk($id);
		return $model;
	}
Example #9
0
	private function getTravelInfo($id)
	{
		$travel = Travel::model()->find(array(
				'select'=>'current_audlt_price,current_child_price',
				'condition'=>"id=$id",
		));
		return $travel;
	}
Example #10
0
	private function getTravelMdid()
	{
		$allArr = array();
		$arr = Travel::model()->findAll(array(
				'select'=>'to_addr',
				'condition'=>'enabled<>0',
				));
		foreach($arr as $ar){
			$temparr = explode(';',$ar['to_addr']);
			foreach($temparr as $tempar){
				if(array_key_exists($tempar,$allArr)){
					$allArr[$tempar] += 1;
				}else{
					if(!isset($allArr[$tempar])){
						$allArr[$tempar] = 1;
					}else{
						$allArr[$tempar] += 1;
					}
				}
			}
		}
		
		return $allArr;
	}
Example #11
0
	public function getTravelName($tid)
	{
		$model = Travel::model()->find(array('select'=>'title','condition'=>"id=$tid"));
		return $model->title;
	}
    } else {
        for ($i = 0; $i < $package->count(); $i++) {
            if (File::exists($filename)) {
                File::delete($filename);
            }
            $package->delete();
        }
    }
});
/*---------------------------------------------------*/
//home
Route::get('/', function () {
    $data['room'] = Rooms::select('roomtype.RoomType_Name', 'roomtype.ID_RoomType', 'roomtype_pic.Picture')->join('roomtype_pic', 'roomtype.ID_RoomType', '=', 'roomtype_pic.ID_RoomType')->where('roomtype_pic.Main_Pic', '=', 'YES')->where('roomtype.Status', '=', 'Active')->take(40)->get()->all();
    $data['offer'] = Offer::where('Status', '=', 'Active')->take(40)->get()->all();
    $data['dinas'] = Dinasevents::select(DB::raw("Event_ID, Event_Picture, Event_Date, Event_Title, CONCAT(SUBSTRING(Event_Description,1,100),'...') as IsiEvent"))->orderby('Event_Date', 'DESC')->take(40)->get()->all();
    $data['travel'] = Travel::where('Status', '=', 'Active')->take(40)->get()->all();
    $data['destination'] = Destination::where('Status', '=', 'Active')->take(40)->get()->all();
    $data['gallery'] = Gallery::where("Status", "!=", "Delete")->get()->all();
    $data['about'] = About::get()->all();
    Session::put('key', 'expiry', 1);
    $value = Session::get('key');
    return View::make('home')->with('index', 'active')->with('data', $data);
});
Route::get('post/listing', array('uses' => 'PostController@listing', 'as' => 'get.post.listing'));
Route::get('post/{id}', array('uses' => 'PostController@single', 'as' => 'get.post.single'))->where(array('id' => '[1-9][0-9]*', 'slug' => '[a-zA-Z0-9-_]+'));
Route::post('post/{id}', array('uses' => 'PostController@update', 'as' => 'post.post.update'))->where(array('id' => '[1-9][0-9]*'));
Route::resource('user', 'UserController');
//resource
Route::resource('/tourism', 'DestinationController');
Route::resource('/book', 'BooksController');
Route::resource('/rooms', 'RoomsController');
Example #13
0
	public function getDayRangeCount($index)
	{
		$tempArr = $this->dayRangeList();
		$ceil = $tempArr[$index][1];
		$lower = $tempArr[$index][0];
		$count = 0;
		if($ceil!=0){
			$count = Travel::model()->count(array(
					'condition'=>"daynumber>=$lower and daynumber<=$ceil and enabled<>0",
			));
		}else{
			$count = Travel::model()->count(array(
					'condition'=>"daynumber>=$lower and enabled<>0",
			));
		}
	
		return $count;
	}
                </div>
                <p>
                    暂无站内简讯
                </p>
                @endif
            </div>
            {{-- /Text Widget --}}

            {{-- Recent Posts Widget --}}
            <div class="widget">

                <div class="widget-title">
                    <h4>热门分享</h4>
                </div>
                <?php 
$posts = Travel::where('post_status', 'open')->orderBy('comments_count', 'desc')->paginate(4);
?>
                @foreach($posts as $post)
                <div class="post-box">
                    <a href="{{ route('timeline.getTimeline', $post->user->id) }}"> <img class="img-rounded" src="{{ $post->user->portrait_large }}" width="50" height="50" alt=""> </a>
                    <div>
                        <h5><a href="{{ route('travel.show', $post->slug) }}">{{ $post->title }}</a></h5>
                        <small>{{ date("M d, Y",strtotime($post->created_at)) }}</small>
                    </div>
                </div>
                @endforeach
            </div>
            {{-- /Recent Posts Widget --}}

            {{-- Tags Widget --}}
            <div class="widget">
Example #15
0
	private function loadModel($id)
	{
		$model=Travel::model()->findByPk($id);
		if($model===null){
			$this->render('404',array('msg'=>'抱歉,暂时还没有该团!'));
			exit;
		}
		//throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}
Example #16
0
	private function getTravelByPk($id)
	{
		$model = Travel::model()->find(array(
				'select'=>'aduit_price,childen_price',
				'condition'=>"id=$id",
				));
		return array(
				'audit_price'=>$model->aduit_price,
				'child_price'=>$model->childen_price,
				);
	}
Example #17
0
	public function getProductNameByPk($id)
	{
		$model = Travel::model()->find(array('select'=>'title','condition'=>"id=$id"));
		return $model->title;
	}
Example #18
0
	public function actionCanelgo()
	{
		$CModel = new Travelcalendar;
		$criteria=new CDbCriteria;
		
		if(isset($_POST['number']) && !empty($_POST['number'])){
			$criteria->compare('trackcode',$_POST['number'],true);
		}
		
		if(isset($_POST['name']) && !empty($_POST['name'])){
			$name = $_POST['name'];
			$travelarr = Travel::model()->findAll(array('select'=>'id','condition'=>"title like '%$name%'"));
			if(empty($travelarr)){
				$criteria->addCondition("tid=0");
			}else{
				foreach($travelarr as $ar){
					$criteria->addCondition("tid=".$ar->id,'OR');
				}
			}
		}
		
		if(isset($_POST['start']) && !empty($_POST['start'])){
			$start = strtotime($_POST['start']);
			$criteria->addCondition("date>=$start");
		}
		
		if(isset($_POST['stop']) && !empty($_POST['stop'])){
			$start = strtotime($_POST['stop']);
			$criteria->addCondition("date<=$start");
		}
		
		$criteria->addCondition('enabled=0');
		//$criteria->addCondition("date<=$now");
		
		//$criteria->condition = "enabled=0";
		$count=$CModel->count($criteria);
		$pages=new CPagination($count);
		$pages->pageSize=15;
		$pages->applyLimit($criteria);
		
		$calArr = $CModel->findAll($criteria);
		
		$this->render('canelgo',array(
				'calArr'=>$calArr,
				'pages'=>$pages,
		));
	}
Example #19
0
	public function getTravelSome($tid)
	{
		$model = Travel::model()->findByPk($tid,array('select'=>'id,title,to_addr,daynumber,thumb,current_audlt_price','condition'=>'enabled=1'));
		return $model;
	}
Example #20
0
	public function getTravelInfoByPk($id)
	{
		$model = Travel::model()->find(array('select'=>'trackcode,title','condition'=>"id=$id"));
		return $model;
	}