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']);
}
