Mur */ public function murs() { return $this->hasMany(\App\Models\Mur::class, 'mur_contactId', 'contact_id'); } /** * OneToMany * Contact -> Panier */ public function paniers() { return $this->hasMany(\App\Models\Panier::class, 'panier_contactId', 'contact_id'); } /** * ManyToOne * Contact -> Site */ public function site() { return $this->belongsTo(\App\Models\Site::class, 'contact_siteId'); } /** * @param \Illuminate\Database\Eloquent\Builder $query */ protected function scopeSearchName($query, $name) { if ($name) { $query->where('contact_nom', 'like', '%' . $name . '%'); } } /** * @param \Illuminate\Database\Eloquent\Builder $query */ protected function scopeSearchFirstname($query, $firstname) { if ($firstname) { $query->where('contact_prenom', 'like', '%' . $firstname . '%'); } } /** * @param \Illuminate\Database\Eloquent\Builder $query */ protected function scopeSearchEmail($query, $email) { if ($email) { $query->where('contact_email', 'like', '%' . $email . '%'); } } /** * @param \Illuminate\Database\Eloquent\Builder $query */ protected function scopeSearchVille($query, $ville) { if ($ville) { $query->where('contact_ville', 'like', '%' . $ville . '%'); } } /** * @param \Illuminate\Database\Eloquent\Builder $query */ protected function scopeSearchCp($query, $cp) { if ($cp) { $query->where('contact_cp', 'like', '%' . $cp . '%'); } } /** * @param \Illuminate\Database\Eloquent\Builder $query */ protected function scopeSearchCountry($query, $country) { if ($country) { $query->where('contact_country', $country); } } /** * log relation * * @return HasMany */ public function logs() { return $this->hasMany(Log::class, 'log_contactId', 'contact_id'); } }