コード例 #1
0
 public function buenFinGRM()
 {
     /* consulto las promos vigentes del hotel para mostrarlas como opciones si la promo está no vigente */
     $offer = Offer::active()->range()->whereHas('resorts', function ($q) {
         $q->whereIn('id', [6]);
     })->with(['websites' => function ($q) {
         $q->where('id', '7');
     }])->with(['contents' => function ($query) {
         $query->where('lang_id', '=', '1');
     }])->where('mobile_only', 0)->where('main', 1)->orderBy('priority', 'desc')->first();
     return View("pages.offer-buenfin16-grm", compact('offer'));
 }
コード例 #2
0
 public function offerShow($offer)
 {
     if (Agent::isMobile()) {
         $offer = Offer::active()->identifier($offer)->whereHas('websites', function ($q) {
             $q->where('id', $this->website_id);
         })->with(['contents' => function ($query) {
             $query->where('lang_id', '=', $this->langId);
         }])->orderBy('priority', 'desc')->first();
     } else {
         $offer = Offer::active()->identifier($offer)->whereHas('websites', function ($q) {
             $q->where('id', $this->website_id);
         })->with(['contents' => function ($query) {
             $query->where('lang_id', '=', $this->langId);
         }])->where('mobile_only', 0)->orderBy('priority', 'desc')->first();
     }
     if ($offer) {
         $travel_window = App\OfferTravelWindow::where('offer_id', $offer->id)->orderBy('start_date', 'asc')->get();
         $resorts = Resort::active()->whereHas('offers', function ($q) use($offer) {
             $q->where('id', $offer->id);
         })->with(['contents' => function ($query) {
             $query->where('lang_id', '=', $this->langId);
         }])->get();
         $offer_resort = App\OfferResort::where('offer_id', $offer->id)->get();
         $i = 0;
         foreach ($resorts as $key => $value) {
             //offer_resort2 almacena los datos necesarios en un solo vector para llevar al formulario.
             for ($k = 0; $k < count($offer_resort); $k++) {
                 if ($value->id == $offer_resort[$k]['resort_id']) {
                     $offer_resort2[$i]['ihotelier_rate_id'] = $offer_resort[$k]['ihotelier_rate_id'];
                     $offer_resort2[$i]['minimum'] = $offer_resort[$k]['minimum'];
                     $offer_resort2[$i]['id'] = $value->id;
                     $offer_resort2[$i]['name'] = $value->name;
                     $offer_resort2[$i]['ihotelier_id'] = $value->ihotelier_id;
                     $offer_resort2[$i]['area'] = $value->area;
                 }
             }
             $i++;
         }
         $all_offers = Offer::active()->range()->whereHas('resorts', function ($q) use($resorts) {
             $q->where('id', $resorts[0]->id);
         })->whereHas('websites', function ($q) {
             $q->where('id', $this->website_id);
         })->with(['contents' => function ($query) {
             $query->where('lang_id', '=', $this->langId);
         }])->where('mobile_only', 0)->orderBy('priority', 'desc')->get()->take(3);
         return View('pages.offer ', compact('offer', 'resorts', 'all_offers', 'offer_resort2', 'travel_window'));
     } else {
         abort(404);
     }
 }
コード例 #3
0
 public function offerShow($offer)
 {
     if (Agent::isMobile()) {
         $offer = Offer::active()->identifier($offer)->whereHas('websites', function ($q) {
             $q->where('id', $this->website_id);
         })->with(['contents' => function ($query) {
             $query->where('lang_id', '=', $this->langId);
         }])->orderBy('priority', 'desc')->first();
     } else {
         $offer = Offer::active()->identifier($offer)->whereHas('websites', function ($q) {
             $q->where('id', $this->website_id);
         })->with(['contents' => function ($query) {
             $query->where('lang_id', '=', $this->langId);
         }])->where('mobile_only', 0)->first();
     }
     if ($offer) {
         $resorts = Resort::active()->whereHas('offers', function ($q) use($offer) {
             $q->where('id', $offer->id);
         })->with(['contents' => function ($query) {
             $query->where('lang_id', '=', $this->langId);
         }])->get();
         $all_offers = Offer::active()->range()->whereHas('resorts', function ($q) use($resorts) {
             $q->where('id', $resorts[0]->id);
         })->whereHas('websites', function ($q) {
             $q->where('id', $this->website_id);
         })->with(['contents' => function ($query) {
             $query->where('lang_id', '=', $this->langId);
         }])->where('mobile_only', 0)->orderBy('priority', 'desc')->get()->take(3);
         return View('pages.offer ', compact('offer', 'all_offers'));
     } else {
         abort(404);
     }
 }