+ if (isset($validatedData['after'])) {
+ $episodes = $episodes->where(
+ DB::raw('DATE_ADD(`episodes`.`start`, INTERVAL COALESCE(`episodes`.`estimate`, 0) SECOND)'),
+ '>=', $validatedData['after']);
+ }
+ if (isset($validatedData['before'])) {
+ $episodes = $episodes->where('episodes.start', '<=', $validatedData['before']);
+ }