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