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')); }
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; }
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; }
protected function getOneTravelByPk($id) { $model = Travel::model()->findByPk($id); return $model; }
private function getTravelInfo($id) { $travel = Travel::model()->find(array( 'select'=>'current_audlt_price,current_child_price', 'condition'=>"id=$id", )); return $travel; }
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; }
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');
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">
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; }
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, ); }
public function getProductNameByPk($id) { $model = Travel::model()->find(array('select'=>'title','condition'=>"id=$id")); return $model->title; }
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, )); }
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; }
public function getTravelInfoByPk($id) { $model = Travel::model()->find(array('select'=>'trackcode,title','condition'=>"id=$id")); return $model; }