public function reportSqueeb($id)
{
//update the number of reported times
$squeeb = Squeeb::where('id', '=', $id);
if ($squeeb->count()) {
$squeeb = $squeeb->first();
$squeeb->reports = $squeeb->reports + 1;
if ($squeeb->save()) {
return Redirect::back()->with('global', 'Your Complaint has been received. This squeeb will be reviewed in a short while and necessary actions taken.');
}
}
}
public function getMoreHomePageSqueeb($lastid)
{
$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');
}
}
}
$more = true;
$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;
//get the top squeeb to display
$newsqueebs = Squeeb::where('active', '=', TRUE)->where('branch_id', '=', $campusid)->orderBy('id', 'DESC')->take(self::TOP_SQUEEB_LIMIT)->get();
View::share('newsqueebs', $newsqueebs);
$squeebs = Notice::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', '=', 'Notice')->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);
return View::make('guest.home');
}
private function sqFactor($squeeb)
{
//update the squeeb table
$sqfactor = Squeeb::where('id', '=', $squeeb->squeebs_id);
if ($sqfactor->count()) {
$sqfactor = $sqfactor->first();
$sqfactor->views = $sqfactor->views + 1;
$saved = $sqfactor->save();
}
}