public function getWatchedRecords()
{
if ([] == $this->watchedRecords) {
$this->watchedRecords = Watchlist::query()->leftJoin('Episodes', 'Episodes.id = Watchlist.currentEpisode_id')->where('Watchlist.movie_id = :movie:', ['movie' => $this->id])->andWhere('Watchlist.status = "done"')->columns(['Watchlist.*', 'Episodes.*'])->execute();
}
return $this->watchedRecords;
}
public function getMyWatchListMovies()
{
if ([] == $this->watchListMovies) {
$auth = \Phalcon\Di::getDefault()->get('auth');
$this->watchListMovies = Watchlist::query()->leftJoin('Movies', 'Movies.id = Watchlist.movie_id')->leftJoin('Episodes', 'Episodes.id = Watchlist.currentEpisode_id')->where('Watchlist.user_id = :user:'******'user' => $auth->id])->andWhere('Watchlist.status != "done" ')->orderBy('Watchlist.updated_at DESC')->columns(['Watchlist.*', 'Movies.*', 'Episodes.*'])->execute();
}
return $this->watchListMovies;
}
