Exemple #1
0
 public function loadEvent($id)
 {
     $squeeb = Eventsq::where('id', '=', $id)->first();
     View::share('squeeb', $squeeb);
     view::share('model', 'Event');
     //detect device
     $detect = new Mobile_Detect();
     $deviceType = $detect->isMobile() ? $detect->isTablet() ? 'tablet' : 'phone' : 'computer';
     View::share('deviceType', $deviceType);
     //update the squeeb table
     $this->sqFactor($squeeb);
     if (Auth::user()) {
         return View::make('member.squeeb');
     }
     return View::make('guest.squeeb');
 }
 public function getMoreEventsPage($lastid)
 {
     $last_id = 0;
     $campusid = $this->getDevice();
     $obj = new BaseController();
     $campusid = $this->getDevice();
     if ($campusid == 0) {
         $countryname = $obj->getCountryName();
         if ($countryname == 'NONE') {
             return Redirect::route('selectcampus-get');
         } else {
             //check whether the country name exists inthe db
             $locationcountry = Country::where('name', '=', $countryname);
             if ($locationcountry->count()) {
                 $locationcountrycode = $locationcountry->first()->code;
                 $locationcountrycode = strtolower($locationcountrycode);
                 return Redirect::route('selectcountryid', $locationcountrycode);
             } else {
                 return Redirect::route('selectcampus-get');
             }
         }
     }
     $college = Institution::whereHas('Branch', function ($query) use($campusid) {
         $query->where('id', '=', $campusid);
     })->first();
     $collegeid = $college->id;
     $countryid = Country::where('id', '=', $college->country_id)->first()->id;
     $more = true;
     $squeebs = Eventsq::whereHas('Squeeb', function ($query) use($campusid, $lastid) {
         $query->where('branch_id', '=', $campusid)->where('id', '<', $lastid)->where('active', '=', TRUE);
     })->orwhereHas('Squeeb', function ($query) use($lastid) {
         $query->where('branch_id', '=', 0)->where('world', '=', TRUE)->where('id', '<', $lastid)->where('active', '=', TRUE);
     })->orwhereHas('Squeeb', function ($query) use($lastid, $countryid) {
         $query->where('branch_id', '=', 0)->where('country', '=', $countryid)->where('id', '<', $lastid)->where('active', '=', TRUE);
     })->orwhereHas('Squeeb', function ($query) use($lastid, $collegeid) {
         $query->where('branch_id', '=', 0)->where('college', '=', $collegeid)->where('id', '<', $lastid)->where('active', '=', TRUE);
     });
     $last = $squeebs;
     $squeebs = $squeebs->orderBy('id', 'DESC')->take(self::SQUEEB_LIMIT)->get();
     if ($squeebs->count()) {
         $last_id = $last->orderBy('id', 'DESC')->take(self::SQUEEB_LIMIT)->get()->last()->Squeeb()->first()->id;
     }
     View::share('last_id', $last_id);
     View::share('squeebs', $squeebs);
     //get the top squeeb to display
     $topsqueebs = Squeeb::where('active', '=', TRUE)->where('model', '=', 'Eventsq')->where('branch_id', '=', $campusid)->orderBy('views', 'DESC')->take(self::TOP_SQUEEB_LIMIT)->get();
     View::share('topsqueebs', $topsqueebs);
     if ($lastid <= 0 or $squeebs->count() != self::SQUEEB_LIMIT) {
         $more = false;
     }
     $college = Institution::whereHas('Branch', function ($query) use($campusid) {
         $query->where('id', '=', $campusid);
     })->first();
     View::share('college', $college);
     View::share('more', $more);
     $mycampus = Branch::where('id', '=', $campusid)->first();
     View::share('mycampus', $mycampus);
     if (Auth::user()) {
         return View::make('member.event');
     }
     return View::make('guest.event');
 }