/**
*
* Show form to edit existing movie
* @param integer $movie_id
* @return Response
*
*/
public function edit($movie_id)
{
if (!$this->isAdmin) {
return view('auth.login');
}
Session::put('movie_id', $movie_id);
$movie = Movies::findorfail($movie_id);
$movie->genres;
$movie->purchased = date("d-m-Y", strtotime($movie->purchased));
$movie->cover = $this->checkImageExists($movie->image, $movie->sort_name, 'covers');
$movie->cover_count = strlen($movie->cover);
$values = json_decode($movie);
$movie->genres = DB::table('categories')->where('movie_id', $movie_id)->lists('genre_id');
$movie->tags = DB::table('tags')->where('movie_id', $movie_id)->lists('keyword_id');
$fields = Forms::getFormFields('create_movie', true);
$app = app();
$options = $app->make('stdClass');
$options->movies = Movies::orderBy('sort_name')->lists('name', 'movie_id')->toArray();
$options->certificates = Certificates::lists('title', 'certificate_id')->toArray();
$options->studios = Studios::orderBy('name', 'asc')->lists('name', 'studio_id')->toArray();
$options->formats = Formats::lists('type', 'format_id')->toArray();
$options->actors = Persons::select(DB::raw("CONCAT(forename, ' ', surname) AS full_name"), 'person_id')->whereNotIn('person_id', function ($query) use($movie_id) {
$query->select('person_id')->from('cast')->where('movie_id', $movie_id);
})->orderBy('forename')->lists('full_name', 'person_id')->all();
$options->crew = Persons::select(DB::raw("CONCAT(forename, ' ', surname) AS full_name"), 'person_id')->orderBy('forename')->lists('full_name', 'person_id')->all();
$options->keywords = Keywords::orderBy('word')->get();
foreach ($options->keywords as $keyword) {
$keyword->selected = in_array($keyword->keyword_id, $movie->tags) ? true : false;
}
$options->genres = Genres::all();
foreach ($options->genres as $genre) {
$genre->selected = in_array($genre->genre_id, $movie->genres) ? true : false;
}
$user = $this->isAdmin;
return view('movies.edit', compact('movie', 'fields', 'values', 'options', 'user'));
}
public function getAvailableCrew()
{
if (Request::ajax()) {
$data = Request::all();
$movie_id = $data['movie'];
$actors = Persons::select(DB::raw("CONCAT(forename, ' ', surname) AS full_name"), 'person_id')->whereNotIn('person_id', function ($query) use($movie_id) {
$query->select('person_id')->from('crew')->where('movie_id', $movie_id);
})->orderBy('forename')->get()->toJson();
return $actors;
}
}
/**
*
* Show all persons whose birthday is today
* @return Response
*
*/
public static function getTodaysBirthdays()
{
return Persons::select('persons.person_id', 'birthday', 'deceased', DB::raw('CONCAT(forename, " ", surname) as name'), 'image')->where(DB::raw('DATE_FORMAT(birthday,"%m-%d")'), DB::raw('DATE_FORMAT(NOW(),"%m-%d")'))->orderBy('forename', 'asc')->orderBy('surname', 'asc')->get();
}