public function query(Request $request) { $q = $request->input('q'); $results["q"] = $q; $results["movies"] = Movie::where('name', 'like', '%' . $q . '%')->with('casts')->get(); $results["casts"] = Cast::where('name', 'like', '%' . $q . '%')->with('movies')->get(); // return view('results', ['results' => $results]); return $results; }
/** * Execute the console command. * * @return mixed */ public function handle() { $today = date('Y-m-d'); $showtimes = Showtime::where('date', '<', $today)->with('movie')->get(); foreach ($showtimes as $showtime) { $this->removeOldNotifications($showtime); $showtime->delete(); } $movies = Movie::where('release_date', '<', $today)->get(); foreach ($movies as $movie) { $this->removeIfHasNoLongerShowTimes($movie); } }
public function query(Request $request) { $q = $request->input('q'); $results["q"] = $q; $results["movies"] = []; $results["casts"] = []; if (!strcmp($q, "")) { return $results; } $results["movies"] = Movie::where('name', 'like', '%' . $q . '%')->take(3)->get(); $results["casts"] = Cast::where('name', 'like', '%' . $q . '%')->take(3)->get(); return $results; }
public function show($slug) { $movie = Movie::where('slug', $slug)->first(); if (!$movie) { abort(404, 'Movie do not exists, either i messed up or you write poorly'); } $genrerow = ''; foreach ($movie->genres as $genre) { $genrerow .= ucfirst($genre) . ', '; } $genrerow = rtrim($genrerow, ', '); return view('pages.Movie.Movie', ['movie' => $movie, 'genrerow' => $genrerow]); }
public function viewUpdate($id) { // Set logged in user into a variable. $user = Auth::user(); // Find the userlist with the passed through Id // That belongs to the logged in user // And set into a variable. $userlist = Userlist::where('user_id', '=', $user->id)->findOrFail($id); // Find all movies belonging to the logged in user // And set into variable. $movies = Movie::where('user_id', '=', $user->id)->orderBy('title', 'asc')->get(); // Return userlist update view with userlists variable. return view('userlists.viewUpdate')->with('userlist', $userlist)->with('movies', $movies); }
/** * @param Request $request * * @return \Illuminate\Http\RedirectResponse */ public function store(Request $request) { $input = $request->all(); $movie = Movie::where('slug', $input['slug'])->first(); $movie->ticket_datetime = $input['ticket_datetime'] . ':00'; $movie->ticket_price = $input['ticket_price']; $movie->ticket_row = $input['ticket_row']; $movie->ticket_seat = $input['ticket_seat']; $destinationFile = $input['slug'] . '.png'; if (env('APP_ENV', false) == 'local') { $destinationPath = public_path('img\\tickets\\' . $input['year'] . '\\'); } else { $destinationPath = public_path('img/tickets/' . $input['year'] . '/'); } if (!is_dir($destinationPath)) { mkdir($destinationPath, 0777, true); } file_put_contents($destinationPath . $destinationFile, file_get_contents($input['ticket_image'])); $test = getimagesize($destinationPath . $destinationFile); if ($test[0] > 10) { $movie->save(); } return redirect()->action('Admin\\MovieTicketsAdminController@index'); }
|-------------------------------------------------------------------------- | | Here is where you can register all of the routes for an application. | It's a breeze. Simply tell Laravel the URIs it should respond to | and give it the controller to call when that URI is requested. | */ Route::get('/', function () { return view('welcome'); }); Route::get('/about', function () { return view('about'); }); Route::get('/movies', function () { //$movies = \App\Movie::where('title','=','shuga')->get(); $movies = \App\Movie::where('rating', '>', 2)->get(); return $movies; $movie = \App\Movie(); $movie->title = 'Spiderman'; $movie->genre = 'spiders'; $movie->rating = 3; $movie->save(); return \App\Movie::all(); }); //Route::get('/movies','MoviesController@index'); //Route::get('/movies', function () { //$Movies = \App\Movie::where('title','=','shuga')->get(); //$Movies = \App\movie::where('rating','>'2)->get(); //select * from movies where rating > 2 //return $movies; //$movie= new \App\Movie(); //$Movie->title='Akirachix';
public function handle() { return Movie::where('id', $this->id)->delete(); }
public function search(Request $request) { $query = $request->input('q'); $movies = Movie::where('title', 'LIKE', '%' . $query . '%')->get(); return view('movies.search')->with('movies', $movies)->with('query', $query); }
public function getMovieShowings($slug) { return Movie::where('slug', '=', $slug)->get()->first()->showings()->get(); }
public function search() { $searchString = \Input::get('searchString'); $movies = Movie::where('name', 'LIKE', '%' . $searchString . '%')->orwhere('director', 'LIKE', '%' . $searchString . '%')->orwhere('genre', 'LIKE', '%' . $searchString . '%')->get(); return view('movies/index', compact('movies')); }
public function handle() { return Movie::where('id', $this->id)->update(array('id' => $this->id, 'name' => $this->name, 'category_id' => $this->category_id, 'director' => $this->director, 'genre' => $this->genre, 'synopsis' => $this->synopsis, 'price' => $this->price, 'main_image' => $this->main_image, '_image1' => $this->image1, '_image2' => $this->image2, '_image3' => $this->image3, 'quantity' => $this->quantity)); }
public function replyMail($mee, $subject, $film, $review) { $me = User::where('id', $mee)->first(); $user = User::where('id', $subject)->first(); $movie = Movie::where('fl_id', $film)->first(); if ($movie->fl_image) { $filmImage = 'http://www.berdict.com/public/uploads/movie/' . $movie->fl_year . '/' . $movie->fl_image; } else { $filmImage = 'http://www.berdict.com/public/berdict/img/default_poster.jpg'; } $filmUrl = 'http://www.berdict.com/movie/' . $movie->fl_id . '/' . \Helpers\Helper::cleanUrl($movie->fl_name); $subjectEmail = $user->usr_email; $subjectName = $user->usr_fname . ' ' . $user->usr_lname; $emailSubject = 'Hey ' . $user->usr_fname . '! ' . $me->usr_fname . ' ' . $me->usr_lname . ' replied to your review for ' . $movie->fl_name; $data = array('subjectName' => $user->usr_fname, 'filmName' => $movie->fl_name, 'filmYear' => $movie->fl_year, 'filmUrl' => $filmUrl, 'filmImage' => $filmImage, 'filmReview' => $review->fr_review, 'reviewId' => $review->fr_id, 'objectId' => $me->id, 'objectName' => $me->usr_fname . ' ' . $me->usr_lname, 'objectUsername' => $me->username, 'filmName' => $movie->fl_name); Mail::later(10, 'emails.reply', $data, function ($message) use($subjectEmail, $subjectName, $emailSubject) { $message->to($subjectEmail, $subjectName); $message->subject($emailSubject); $message->from('*****@*****.**', 'Berdict'); }); }