/** * Show the application dashboard to the user. * * @return Response */ public function index() { $articles = Article::with('author')->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get(); // TODO: abstract to model $sliders = Photo::join('photo_albums', 'photo_albums.id', '=', 'photos.photo_album_id')->where('photos.slider', 1)->orderBy('photos.position', 'DESC')->orderBy('photos.created_at', 'DESC')->select('photos.filename', 'photos.name', 'photos.description', 'photo_albums.folder_id')->get(); $photoAlbums = PhotoAlbum::select(array('photo_albums.id', 'photo_albums.name', 'photo_albums.description', 'photo_albums.folder_id', DB::raw('(select filename from ' . DB::getTablePrefix() . 'photos WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'photos.photo_album_id=' . DB::getTablePrefix() . 'photo_albums.id LIMIT 1) AS album_image'), DB::raw('(select filename from ' . DB::getTablePrefix() . 'photos WHERE ' . DB::getTablePrefix() . 'photos.photo_album_id=' . DB::getTablePrefix() . 'photo_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $videoAlbums = VideoAlbum::select(array('video_albums.id', 'video_albums.name', 'video_albums.description', 'video_albums.folder_id', DB::raw('(select youtube from ' . DB::getTablePrefix() . 'videos WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'videos.video_album_id=' . DB::getTablePrefix() . 'video_albums.id LIMIT 1) AS album_image'), DB::raw('(select youtube from ' . DB::getTablePrefix() . 'videos WHERE ' . DB::getTablePrefix() . 'videos.video_album_id=' . DB::getTablePrefix() . 'video_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $categoriesArray = Object::where('type', 'category')->get(); $categories = array(); foreach ($categoriesArray as $category) { $categories[] = array($category->title); } $categories = Object::where('type', 'category')->get(); global $types; $types = Object::getTypes()->select(array('id', DB::raw("REPLACE(name, '_object_type_', '') as name"), DB::raw("REPLACE(title, 'Object Type: ', '') as title"), 'created_at'))->get(); return view('pages.home', compact('articles', 'sliders', 'videoAlbums', 'photoAlbums', 'categories', 'types')); //return view('pages.welcome'); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { // $albums = PhotoAlbum::where('user_id', $id)->where('type', 'album')->get(); $business = Business::findOrFail($id); return view('photoAlbum.show')->withAlbums($albums)->withBusiness($business); }
/** * Show the application dashboard to the user. * * @return Response */ public function index() { $articles = Article::with('author')->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get(); $photoAlbums = PhotoAlbum::select(array('photo_albums.id', 'photo_albums.name', 'photo_albums.description', 'photo_albums.folder_id', DB::raw('(select filename from photos WHERE album_cover=TRUE and photos.photo_album_id=photo_albums.id LIMIT 1) AS album_image'), DB::raw('(select filename from photos WHERE photos.photo_album_id=photo_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $videoAlbums = VideoAlbum::select(array('video_albums.id', 'video_albums.name', 'video_albums.description', 'video_albums.folder_id', DB::raw('(select youtube from videos WHERE album_cover=TRUE and videos.video_album_id=video_albums.id LIMIT 1) AS album_image'), DB::raw('(select youtube from videos WHERE videos.video_album_id=video_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); return view('pages.home', compact('articles', 'videoAlbums', 'photoAlbums')); }
public function index() { $news = $this->news->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get(); $sliders = Photo::join('photo_album', 'photo_album.id', '=', 'photo.photo_album_id')->where('photo.slider', 1)->orderBy('photo.position', 'DESC')->orderBy('photo.created_at', 'DESC')->select('photo.filename', 'photo.name', 'photo.description', 'photo_album.folderid')->get(); $photoalbums = PhotoAlbum::select(array('photo_album.id', 'photo_album.name', 'photo_album.description', 'photo_album.folderid', DB::raw('(select filename from ' . DB::getTablePrefix() . 'photo WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'photo.photo_album_id=' . DB::getTablePrefix() . 'photo_album.id) AS album_image'), DB::raw('(select filename from ' . DB::getTablePrefix() . 'photo WHERE ' . DB::getTablePrefix() . 'photo.photo_album_id=' . DB::getTablePrefix() . 'photo_album.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $videoalbums = VideoAlbum::select(array('video_album.id', 'video_album.name', 'video_album.description', 'video_album.folderid', DB::raw('(select youtube from ' . DB::getTablePrefix() . 'video as v WHERE album_cover=TRUE and v.video_album_id=' . DB::getTablePrefix() . 'video_album.id) AS album_image'), DB::raw('(select youtube from ' . DB::getTablePrefix() . 'video WHERE ' . DB::getTablePrefix() . 'video.video_album_id=' . DB::getTablePrefix() . 'video_album.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); return view('site.home.index', compact('news', 'sliders', 'videoalbums', 'photoalbums')); }
/** * Handle the event. * * @param UserWasDeleted $event * @return void */ public function handle(UserWasDeleted $event) { // Delete everything the user created Article::where('user_id', $event->user_id)->delete(); Photo::where('user_id', $event->user_id)->delete(); PhotoAlbum::where('user_id', $event->user_id)->delete(); Video::where('user_id', $event->user_id)->delete(); VideoAlbum::where('user_id', $event->user_id)->delete(); }
public function index() { $title = "Dashboard"; $article = Article::count(); $articlecategory = ArticleCategory::count(); $users = User::count(); $photo = Photo::count(); $photoalbum = PhotoAlbum::count(); return view('admin.dashboard.index', compact('title', 'article', 'articlecategory', 'photo', 'photoalbum', 'users')); }
/** * Show the application dashboard to the user. * * @return Response */ public function index() { $articles = Article::with('author')->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get(); // TODO: abstract to model $sliders = Photo::join('photo_albums', 'photo_albums.id', '=', 'photos.photo_album_id')->where('photos.slider', 1)->orderBy('photos.position', 'DESC')->orderBy('photos.created_at', 'DESC')->select('photos.filename', 'photos.name', 'photos.description', 'photo_albums.folder_id')->get(); $photoAlbums = PhotoAlbum::select(array('photo_albums.id', 'photo_albums.name', 'photo_albums.description', 'photo_albums.folder_id', DB::raw('(select filename from ' . DB::getTablePrefix() . 'photos WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'photos.photo_album_id=' . DB::getTablePrefix() . 'photo_albums.id LIMIT 1) AS album_image'), DB::raw('(select filename from ' . DB::getTablePrefix() . 'photos WHERE ' . DB::getTablePrefix() . 'photos.photo_album_id=' . DB::getTablePrefix() . 'photo_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $videoAlbums = VideoAlbum::select(array('video_albums.id', 'video_albums.name', 'video_albums.description', 'video_albums.folder_id', DB::raw('(select youtube from ' . DB::getTablePrefix() . 'videos WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'videos.video_album_id=' . DB::getTablePrefix() . 'video_albums.id LIMIT 1) AS album_image'), DB::raw('(select youtube from ' . DB::getTablePrefix() . 'videos WHERE ' . DB::getTablePrefix() . 'videos.video_album_id=' . DB::getTablePrefix() . 'video_albums.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); return view('pages.home', compact('articles', 'sliders', 'videoAlbums', 'photoAlbums')); //return view('pages.welcome'); }
public function index() { $title = "Dashboard"; $news = News::count(); $newscategory = NewsCategory::count(); $users = User::count(); $photo = Photo::count(); $photoalbum = PhotoAlbum::count(); $video = Video::count(); $videoalbum = VideoAlbum::count(); return view('admin.dashboard.index', compact('title', 'news', 'newscategory', 'video', 'videoalbum', 'photo', 'photoalbum', 'users')); }
/** * Display a loggedin user's business albums. * * @return Response */ public function photos($id) { //all users $user = User::where('userName', $id)->first(); if (empty($user)) { return redirect()->back(); } $userDetail = UserDetail::where('userId', $user->id)->first(); $business = Business::find($userDetail->businessId); if (empty($business)) { return redirect('/user/' . $user->userName . '/profile'); } $business = (object) array_merge($user->toArray(), $userDetail->toArray(), $business->toArray()); $albums = PhotoAlbum::where('user_id', $business->userId)->where('type', 'album')->get(); return view('business.photos')->withBusiness($business)->withAlbums($albums); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(PhotoRequest $request, Photo $photo) { $photo->user_id_edited = Auth::id(); $picture = $photo->filename; if ($request->hasFile('image')) { $file = $request->file('image'); $filename = $file->getClientOriginalName(); $extension = $file->getClientOriginalExtension(); $picture = sha1($filename . time()) . '.' . $extension; } $photo->filename = $picture; $photo->update($request->except('image')); if ($request->hasFile('image')) { $photoalbum = PhotoAlbum::find($request->photo_album_id); $destinationPath = public_path() . '/appfiles/photoalbum/' . $photoalbum->folder_id . '/'; $request->file('image')->move($destinationPath, $picture); } }
/** * Show a list of all the languages posts formatted for Datatables. * * @return Datatables JSON */ public function data() { $photo_category = PhotoAlbum::join('languages', 'languages.id', '=', 'photo_albums.language_id')->select(array('photo_albums.id', 'photo_albums.name', 'languages.name as language', 'photo_albums.id as images_count', 'photo_albums.created_at')); return Datatables::of($photo_category)->edit_column('images_count', '<a class="btn btn-primary btn-sm" >{{ \\App\\Photo::where(\'photo_album_id\', \'=\', $id)->count() }}</a>')->add_column('actions', '<a href="{{{ URL::to(\'admin/photoalbum/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm iframe" >{{ trans("admin/modal.edit") }}</a> <a href="{{{ URL::to(\'admin/photoalbum/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger iframe">{{ trans("admin/modal.delete") }}</a> <input type="hidden" name="row" value="{{$id}}" id="row">')->make(); }
public function show($id) { $photo_album = PhotoAlbum::find($id); $photos = Photo::where('photo_album_id', $id)->get(); return view('photo.view_album', compact('photos', 'photo_album')); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function postEdit(PhotoRequest $request, $id) { $photo = Photo::find($id); $photo->user_id = Auth::id(); $photo->language_id = $request->language_id; $photo->name = $request->name; $photo->photo_album_id = $request->photo_album_id; $photo->description = $request->description; $photo->slider = $request->slider; $photo->album_cover = $request->album_cover; $picture = $photo->filename; if ($request->hasFile('image')) { $file = $request->file('image'); $filename = $file->getClientOriginalName(); $extension = $file->getClientOriginalExtension(); $picture = sha1($filename . time()) . '.' . $extension; } $photo->filename = $picture; $photo->save(); if ($request->hasFile('image')) { $photoalbum = PhotoAlbum::find($request->photo_album_id); $destinationPath = public_path() . '/appfiles/photoalbum/' . $photoalbum->folder_id . '/'; $request->file('image')->move($destinationPath, $picture); $path2 = public_path() . '/appfiles/photoalbum/' . $photoalbum->folder_id . '/thumbs/'; Thumbnail::generate_image_thumbnail($destinationPath . $picture, $path2 . $picture); } }
/** * Reorder items * * @param items list * @return items from @param */ public function getReorder(ReorderRequest $request) { $list = $request->list; $items = explode(",", $list); $order = 1; foreach ($items as $value) { if ($value != '') { PhotoAlbum::where('id', '=', $value)->update(array('position' => $order)); $order++; } } return $list; }
/** * Display a loggedin user's business albums. * * @return Response */ public function photos() { $user = User::find(Auth::user()->id); $userDetail = UserDetail::where('userId', $user->id)->first(); $business = Business::find($userDetail->businessId); if (empty($business)) { $business = (object) array_merge($user->toArray(), $userDetail->toArray()); } else { $business = (object) array_merge($user->toArray(), $userDetail->toArray(), $business->toArray()); } $albums = PhotoAlbum::where('user_id', Auth::user()->id)->where('type', 'album')->get(); return view('home.photos')->withBusiness($business)->withAlbums($albums); }