public function showMember(Request $r) { $member = Member::where("id", $r->input('id'))->get(); $hc = new HomeController(); $vars = $hc->getVars(); return view('member', ['member' => $member[0], "lang" => "fa", "vars" => $vars]); }
public function showGallery(Request $r) { $gal = Content::find($r->input('id')); $hc = new HomeController(); $vars = $hc->getVars(); $lang = $r->session()->get("lang", "fa"); return view('gallery', ["lang" => $lang, "gallery" => $gal, "vars" => $vars]); }
public function showContent(Request $r) { $content = Content::find($r->input("id")); $lang = $r->session()->get("lang", "fa"); $rels = $this->getRelatedBlog($content->id); $hc = new HomeController(); $vars = $hc->getVars(); return view('content', ['content' => $content, 'related' => $rels, 'lang' => $lang, 'vars' => $vars]); }
/** * [landscape description] * @param [type] $id [description] * @return [type] [description] */ public function landscape($id) { $tours = Tour::getTourByLandScape($id); foreach ($tours as $key => $value) { $tours[$key]->periodNature = HomeController::periodNature($value->period); } $destinationsData = Destination::all(); $departuresData = Departure::all(); $landScapeAbroad = Tour::getLandScapeAbroad(); $landScapeNotAbroad = Tour::getLandScapeNotAbroad(); return view('home.searchtour', compact('tours', 'destinationsData', 'departuresData', 'landScapeAbroad', 'landScapeNotAbroad')); }
/** * [tour description] * @return [type] [description] */ public function tour() { $featuretours = Tour::getFeatureTour(); foreach ($featuretours as $key => $value) { $featuretours[$key]->periodNature = HomeController::periodNature($value->period); } $newtours = Tour::getNewTour(); foreach ($newtours as $key => $value) { $newtours[$key]->periodNature = HomeController::periodNature($value->period); } $destinations = Destination::all(); $departures = Departure::all(); return view('home.tour', compact('featuretours', 'newtours', 'destinations', 'departures')); }
public function actualitzarLlistat() { $llistat = HomeController::llistarCamps(UserProfile::perfilId(Auth::user()->id)); $info = UserProfile::informacioPersonal(Auth::user()->id); $numCamps = Camp::contaCampsUsuari(UserProfile::perfilId(Auth::user()->id)); $camps = Camp::idCampsUsuari(UserProfile::perfilId(Auth::user()->id)); foreach ($camps as $item) { $resultatcultius[] = Cultiu::idCultiusCamp($item['id']); } $numCultius = (count($resultatcultius, COUNT_RECURSIVE) - count($resultatcultius)) / 4; //foreach ($resultatcultius as $in_ar) {$res+=getArrCount($in_ar, 1);} $info['numCamps'] = $numCamps; $info['numCultius'] = $numCultius; $dades = ['llistat' => $llistat, 'info' => $info]; //dd($dades); return view('homellistat')->with('dades', $dades); }
/** * [getDetailAndInfoAround description] * @param [type] $id [description] * @return [type] [description] */ public static function getDetailAndInfoAround($id) { $tour = Tour::find($id); $tour->departure = Departure::find($tour->departure_id); $tour_relevant = DB::table('tours')->where('departure_id', $tour->departure_id)->take(4)->get(); foreach ($tour_relevant as $key => $value) { $image = TourImage::where('tour_id', $value->id)->first(); $tour_relevant[$key]->image = $image; $tour_relevant[$key]->periodNature = HomeController::periodNature($value->period); } $tour->tour_relevant = $tour_relevant; $tour->destinations = DB::table('destinations')->join('tour_destinations', 'destinations.id', '=', 'tour_destinations.destination_id')->where('tour_destinations.tour_id', $id)->get(); return $tour; }
public function getChildrenOfTaxaGroup(Request $request) { $taxaGroupIDs = $request->input('taxaGroupIDs'); // $specimenSegregationTaxaGroups = TaxaGroup::where('parentTaxaGroupID', '=', $taxaGroupIDs)->where('taxaThumbnailFilePath', '=', '')->get(); // // foreach ($specimenSegregationTaxaGroups as $taxaGroup) { // $taxaGroup->childrenSpecimens->toArray(); // } $hierachy = []; $parentTaxaGroupID = $taxaGroupIDs; while (TaxaGroup::find($parentTaxaGroupID)->tier > 1) { $taxaGroupName = TaxaGroup::find($parentTaxaGroupID)->TaxaGroupName; array_unshift($hierachy, ['taxaGroupID' => $parentTaxaGroupID, 'TaxaGroupName' => $taxaGroupName]); $parentTaxaGroupID = TaxaGroup::find($parentTaxaGroupID)->parentTaxaGroupID; } // $speciesDirectlyUnderTaxaGroup = TaxaGroup::find($taxaGroupIDs)->childrenSpecimens; $childrenTaxaGroups = TaxaGroup::find($taxaGroupIDs)->childrenTaxaGroups()->where('taxaThumbnailFilePath', '!=', '')->where('uploadToWeb', '=', 1)->get(); $speciesDirectlyUnderTaxaGroup = []; $specimenSegregationTaxaGroups = []; HomeController::recursivelyGetSpecies(TaxaGroup::find($taxaGroupIDs), $specimenSegregationTaxaGroups, $speciesDirectlyUnderTaxaGroup); return response()->json(['TaxaGroupName' => TaxaGroup::find($taxaGroupIDs)->TaxaGroupName, 'childrenSpecies' => $speciesDirectlyUnderTaxaGroup, 'taxaGroupIDs' => $hierachy, 'specimenSegregationTaxaGroups' => $specimenSegregationTaxaGroups, 'childrenTaxaGroups' => $childrenTaxaGroups]); }
Route::get('/blogs', ['as' => 'blogs', 'uses' => 'BlogController@showBlogs']); Route::get('/morecontents', ['as' => 'morecontents', 'uses' => 'ContentController@moreContents']); Route::get('/galleries', ['as' => 'galleries', 'uses' => 'GalleryController@showGalleries']); Route::get('/gallery', ['as' => 'gallery', 'uses' => 'GalleryController@showGallery']); Route::get('/about', ['as' => 'gallery', 'uses' => 'HomeController@showAbout']); Route::get('/scroll', ['as' => 'gallery', 'uses' => 'AboutController@autoScroll']); Route::get('/cat', ['as' => 'cat', 'uses' => 'CategoryController@test']); Route::get('/member', ['as' => 'member', 'uses' => 'MemberController@showMember']); Route::post('/insert', ['as' => 'insert', 'uses' => 'AdminController@insertQuery']); Route::get('/edit', ['as' => 'edit', 'uses' => 'AdminController@showEditForm']); Route::get('/delete', ['as' => 'edit', 'uses' => 'AdminController@delete']); Route::get('/adminlogin', ['as' => 'adminlogin', 'uses' => 'AdminController@showLogin']); Route::post('/adminlogin', ['uses' => 'AdminController@doLogin']); Route::get('/logout', ['uses' => 'AdminController@doLogout']); Route::get('/contents', ['uses' => 'ContentController@showContents']); Route::get('/content', ['uses' => 'ContentController@showContent']); Route::get('/lang', ['uses' => 'HomeController@setLang']); Route::get('/search', ['uses' => 'HomeController@search']); Route::get('sendemail', function () { $hc = new HomeController(); $vars = $hc->getVars(); $data = array('vars' => $vars); Mail::send('newsletterbody', $data, function ($message) { $message->from('*****@*****.**', 'Learning Laravel'); $message->to('*****@*****.**')->subject('Learning Laravel test email'); }); return "Your email has been sent successfully"; }); Route::get('mail', function () { return view("newsletterbody"); });
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $movie = DB::table('film')->where('fl_id', $id)->first(); $movieRating = $this->betterRating($id, $movie->fl_rating); if (Auth::check()) { $ser = new UsersController(); $following = $ser->getFollowing(Auth::user()->id); $myReview = $this->myReview($id); if ($following) { $column = array(); foreach ($following as $following) { $column[] = $following->id; } $reviewCount = DB::table('film_review')->join('users', 'users.id', '=', 'film_review.fr_usr_id')->where('fr_fl_id', $id)->whereNotIn('fr_usr_id', $column)->WhereNotIn('fr_usr_id', array(Auth::user()->id))->count(); $frreviews = DB::table('film_review')->join('users', 'users.id', '=', 'film_review.fr_usr_id')->where('fr_fl_id', $id)->wherein('fr_usr_id', $column)->take(10)->get(); $reviews = DB::table('film_review')->join('users', 'users.id', '=', 'film_review.fr_usr_id')->where('fr_fl_id', $id)->whereNotIn('fr_usr_id', $column)->WhereNotIn('fr_usr_id', array(Auth::user()->id))->take(5)->orderBy('fr_date')->get(); } else { $frreviews = array(); $reviews = DB::table('film_review')->join('users', 'users.id', '=', 'film_review.fr_usr_id')->where('fr_fl_id', $id)->take(10)->orderBy('fr_date')->get(); $reviewCount = DB::table('film_review')->join('users', 'users.id', '=', 'film_review.fr_usr_id')->where('fr_fl_id', $id)->count(); } } else { $reviewCount = DB::table('film_review')->join('users', 'users.id', '=', 'film_review.fr_usr_id')->where('fr_fl_id', $id)->count(); $myReview = ""; $frreviews = array(); $reviews = DB::table('film_review')->join('users', 'users.id', '=', 'film_review.fr_usr_id')->where('fr_fl_id', $id)->take(10)->orderBy('fr_date')->get(); } foreach ($reviews as $view) { $views = ++$view->fr_views; DB::table('film_review')->where('fr_id', $view->fr_id)->update(array('fr_views' => $views)); } foreach ($frreviews as $view) { $views = ++$view->fr_views; DB::table('film_review')->where('fr_id', $view->fr_id)->update(array('fr_views' => $views)); } if (Auth::check()) { $critics = $this->getCritics(Auth::user()->id); } else { $critics; } if (Auth::check()) { $commonFav = $this->getCommonFav($id); } else { $commonFav; } $rate = '0'; if (Auth::check()) { $user = Auth::user()->id; $watch = DB::table('user_watchlist')->where('uw_fl_id', $id)->where('uw_usr_id', Auth::user()->id)->first(); $rating = DB::table('rating')->where('rt_fl_id', $id)->where('rt_usr_id', Auth::user()->id)->first(); if ($rating) { $rate = $rating->rt_vote; } if ($watch) { $watch = '1'; } else { $watch = '0'; } $watchModel = new WatchedController(); $watched = $watchModel->watchCheck($id, Auth::user()->id); if ($watched) { $watched = '1'; } else { $watched = '0'; } $fav = DB::table('user_fav')->where('fav_fl_id', $id)->where('fav_usr_id', Auth::user()->id)->first(); if ($fav) { $fav = '1'; } else { $fav = '0'; } } else { $watch = '3'; $fav = '3'; $user = ''; } // Invoking that non-static method. $home = new HomeController(); $recent = $home->RecentMovies(7); if ($movie->fl_stars) { $count = substr_count($movie->fl_stars, ","); $first = ""; $second = ""; $third = ""; if ($count == 0) { $comma = explode(", ", $movie->fl_stars); $first = '%' . $comma[0] . '%'; $second = ""; $third = ""; } else { if ($count == 1) { $comma = explode(", ", $movie->fl_stars); $first = '%' . $comma[0] . '%'; $second = '%' . $comma[1] . '%'; $third = ""; } else { if ($count == 2) { $comma = explode(", ", $movie->fl_stars); $first = '%' . $comma[0] . '%'; $second = '%' . $comma[1] . '%'; $third = '%' . $comma[2] . '%'; } } } $sugg = DB::table('film')->orWhere('fl_stars', 'LIKE', $first)->orWhere('fl_stars', 'LIKE', $second)->orWhere('fl_stars', 'LIKE', $third)->where('fl_rating', '>', 6)->take(6)->orderBy(DB::raw('RAND()'))->get(); } else { $sugg = array(); } return view('movies.show', compact('myReview', 'frreviews', 'watchCount', 'favCount', 'commonFav', 'critics', 'movie', 'movieRating', 'sugg', 'reviews', 'reviewCount', 'recent', 'watch', 'fav', 'user', 'rate', 'watched')); }
public function activity() { $user = \Auth::user(); $person = Person::all()->Where('id', $user->person_id)->first(); $notes_added = HomeController::get_notes_added_by_person($person); $updates_suggested = HomeController::get_updates_from_user($user); return view('pages.activity', compact('user', 'notes_added', 'updates_suggested')); }
static function dibuixarMapa($id, $tipus) { $llistat = ""; $centre = ""; $coordenades = null; $items = null; switch ($tipus) { case 0: //usuari $info['poble'] = UserProfile::poblacio($id); $llistat = HomeController::llistarCamps($id); $items = Camp::campsUsuari($id); $ubicacio_centre = 'no_valor'; break; case 1: //camp $info = Camp::infoCamp($id); $ubicacio = Camp::coordenades($id); $llistat = CampController::llistarCultius($id); if (!is_null($ubicacio['ubicacio'])) { $coordenades[] = ['punts' => GoogleMapsController::formarPoligon($ubicacio['ubicacio']), 'color' => '#FF0000', 'info' => GoogleMapsController::crearInfowindow($id, UserProfile::perfilId(Auth::user()->id))]; $ubicacio_centre['y'] = $ubicacio['centrey']; $ubicacio_centre['x'] = $ubicacio['centrex']; $items = Camp::campsVeins($id); } else { $ubicacio_centre = 'no_valor'; } break; default: return false; break; } foreach ($items as $item) { if (!is_null($temp = Camp::coordenades($item->id))) { $coordenades[] = ['punts' => GoogleMapsController::formarPoligon($temp['ubicacio']), 'color' => GoogleMapsController::getColor($item->id, UserProfile::perfilId(Auth::user()->id)), 'info' => GoogleMapsController::crearInfowindow($item->id, UserProfile::perfilId(Auth::user()->id))]; } } $dades = ['ubicacio' => $info['poble'], 'ubicacio_centre' => $ubicacio_centre, 'info' => $info, 'id' => $id, 'cultius' => $llistat, 'coordenades' => $coordenades]; return $dades; }
public function issuer() { if (Request::ajax()) { $data = Request::get('data'); $sort = Request::get('sort'); $list = Request::get('list'); switch ($data) { case 'pp': $source = Issuer::find($list); $source_book = Book::where('author_id', $list)->get(); return view('front.partials.list_item_pp_issuer', ['data' => $source, 'author_book' => $source_book]); case 'word': $source = Issuer::where('name', 'LIKE', $list . '%'); return view('front.partials.list_item_word', ['data' => $source->paginate(9), 'word' => $list]); default: $sources = DB::table('Issuers'); $source = HomeController::sort($sources, $sort); return view('front.partials.list_item_all', ['data' => $source->paginate(9)]); } } $source_list = Issuer::orderBy('name', 'ASC')->paginate(9); $source_word = Issuer::select(DB::raw('substr(name,1,1) as alpha'))->groupBy(DB::raw('substr(name,1,1)'))->get(); return view('front.tacgia', ['author_word' => $source_word, 'data' => $source_list, 'name_page' => 'Nhà phát hành', 'table_name' => 'Issuers']); }