public static function DeadLineFinished()
{
date_default_timezone_set(config::$timezone);
$today = date("Y-m-d");
$orders = Order::where('to', '<', $today)->where('status', '=', 1)->orderBy('id', 'desc')->get();
$info = array();
$x = 0;
foreach ($orders as $order) {
$single = array();
$single['email'] = User::where('details_id', '=', $order->member->id)->where('user_level', '=', 'member')->get()->first()->email;
$single['movie name'] = Movie::where("id", '=', $order->movie_id)->get()->first()->name;
$single['first name'] = Member::where("id", '=', $order->member_id)->get()->first()->first_name;
$single['last name'] = Member::where("id", '=', $order->member_id)->get()->first()->last_name;
$info[$x++] = $single;
}
foreach ($info as $member) {
Mail::send('emails.deadlinefinishedorder', array('first_name' => $member['first name'], 'last_name' => $member['last name'], 'movie' => $member['movie name']), function ($message) use($member) {
$message->to($member['email'], $member['first name'])->subject('DVD Rental Notification');
});
}
return "Email has been successfully sent.";
}
public function getDeleteMovie($id)
{
$movie = Movie::where('id', '=', $id)->first();
if ($movie) {
$movie->delete();
return Redirect::to('/browse-movies')->with('flash_message', 'Delete successfuly!');
} else {
return Redirect::to('/browse-movies')->with('flash_message', 'Delete failed! Try again...!');
}
}
public function newReviewMail($film, $review)
{
//Get All Followers of the loggedn in user
$users = new UsersController();
$followers = $users->getFollower(Auth::user()->id);
$movie = Movie::where('fl_id', $film)->first();
foreach ($followers as $subject) {
// if the subject is 1 or greater than 200 to avoid spam mail
if ($subject->id > 200 || $subject->id == 1) {
//The follower to whom this email will be sent
$user = User::where('id', $subject->id)->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 . '/' . Common::cleanUrl($movie->fl_name);
$subjectEmail = $user->usr_email;
$subjectName = $user->usr_fname . ' ' . $user->usr_lname;
$emailSubject = 'Hey ' . $user->usr_fname . '! Your friend ' . Auth::user()->usr_fname . ' ' . Auth::user()->usr_lname . ' wrote a 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' => Auth::user()->id, 'objectName' => Auth::user()->usr_fname . ' ' . Auth::user()->usr_lname, 'objectUsername' => Auth::user()->username, 'filmName' => $movie->fl_name);
Mail::send('emails.newReview', $data, function ($message) use($subjectEmail, $subjectName, $emailSubject) {
$message->to($subjectEmail, $subjectName);
$message->subject($emailSubject);
$message->from('*****@*****.**', 'Berdict');
});
}
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function genre($genre)
{
$query = '%' . $genre . '%';
$movies = Movie::where('fl_genre', 'LIKE', $query)->orderBy('fl_rating', 'desc')->paginate(20);
$this->layout->content = View::make('movies.genre', compact('movies', 'genre'));
}
public function countryUpdate()
{
$star = Input::get('star');
$country = Input::get('country');
$start = Input::get('start');
$end = Input::get('end');
if ($star == "" || ($country = "")) {
return Redirect::to('/country')->with('flash_error', 'Please enter all the details.')->withInput();
}
$movie = Movie::where('fl_stars', 'LIKE', '%' . $star . '%')->whereBetween('fl_id', array($start, $end))->get();
foreach ($movie as $film) {
if ($film->fl_country == "" || $film->fl_country == null) {
DB::table('film')->where('fl_id', $film->fl_id)->update(array('fl_country' => $country));
}
}
return Redirect::to('/country')->with('flash_success', 'Country updated.')->withInput();
}
public function newLikeMail($subject, $film, $review, $random)
{
$user = User::where('id', $subject)->first();
$Ruser = User::where('id', $random)->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 . '/' . Common::cleanUrl($movie->fl_name);
$subjectEmail = $user->usr_email;
$subjectName = $user->usr_fname . ' ' . $user->usr_lname;
$emailSubject = '' . $user->usr_fname . '! ' . $Ruser->usr_fname . ' ' . $Ruser->usr_lname . ' agreed with 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' => $Ruser->id, 'objectName' => $Ruser->usr_fname . ' ' . $Ruser->usr_lname, 'objectUsername' => $Ruser->username, 'filmName' => $movie->fl_name);
Mail::send('emails.agree', $data, function ($message) use($subjectEmail, $subjectName, $emailSubject) {
$message->to($subjectEmail, $subjectName);
$message->subject($emailSubject);
$message->from('*****@*****.**', 'Berdict');
});
}
