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