|  | @@ 500-507 (lines=8) @@ | 
                                                            
                                    | 497 |  |      * | 
                                                            
                                    | 498 |  |      * @return \Illuminate\Database\Eloquent\Builder|static | 
                                                            
                                    | 499 |  |      */ | 
                                                            
                                    | 500 |  |     public function scopeTranslatedIn(Builder $query, $locale = null) | 
                                                            
                                    | 501 |  |     { | 
                                                            
                                    | 502 |  |         $locale = $locale ?: $this->locale(); | 
                                                            
                                    | 503 |  |  | 
                                                            
                                    | 504 |  |         return $query->whereHas('translations', function (Builder $q) use ($locale) { | 
                                                            
                                    | 505 |  |             $q->where($this->getLocaleKey(), '=', $locale); | 
                                                            
                                    | 506 |  |         }); | 
                                                            
                                    | 507 |  |     } | 
                                                            
                                    | 508 |  |  | 
                                                            
                                    | 509 |  |     /** | 
                                                            
                                    | 510 |  |      * @param \Illuminate\Database\Eloquent\Builder $query | 
                                                                                
                                |  | @@ 515-522 (lines=8) @@ | 
                                                            
                                    | 512 |  |      * | 
                                                            
                                    | 513 |  |      * @return \Illuminate\Database\Eloquent\Builder|static | 
                                                            
                                    | 514 |  |      */ | 
                                                            
                                    | 515 |  |     public function scopeNotTranslatedIn(Builder $query, $locale = null) | 
                                                            
                                    | 516 |  |     { | 
                                                            
                                    | 517 |  |         $locale = $locale ?: $this->locale(); | 
                                                            
                                    | 518 |  |  | 
                                                            
                                    | 519 |  |         return $query->whereDoesntHave('translations', function (Builder $q) use ($locale) { | 
                                                            
                                    | 520 |  |             $q->where($this->getLocaleKey(), '=', $locale); | 
                                                            
                                    | 521 |  |         }); | 
                                                            
                                    | 522 |  |     } | 
                                                            
                                    | 523 |  |  | 
                                                            
                                    | 524 |  |     /** | 
                                                            
                                    | 525 |  |      * @param \Illuminate\Database\Eloquent\Builder $query |