AutocompleteLinesController: Include company name in filter

The `#display_name` used in the drop-down on
`ReferentialVehicleJourneys#index` includes the line's company name.
Include this as a field to filter lines by.

Additionally, use `%query%` filtering everywhere. It's going to be
slower, but will produce the same behaviour for all fields for
consistency and is easier for searching by company name when you might
want to filter by a term in the middle of the name.

Refs #5889

1 files changed, 5 insertions, 3 deletions

diff --git a/app/controllers/autocomplete_lines_controller.rb b/app/controllers/autocomplete_lines_controller.rb
index 945736ab9..0202ea054 100644
--- a/app/controllers/autocomplete_lines_controller.rb
+++ b/app/controllers/autocomplete_lines_controller.rb
@@ -9,13 +9,15 @@ class AutocompleteLinesController < ChouetteController
     @lines = referential.line_referential.lines
 
     filter = <<~SQL
-      number LIKE ?
-      OR name LIKE ?
+      lines.number LIKE ?
+      OR lines.name LIKE ?
+      OR companies.name ILIKE ?
     SQL
     @lines = @lines
+      .joins(:company)
       .where(
         filter,
-        *Array.new(2, "#{params[:q]}%")
+        *Array.new(3, "%#{params[:q]}%")
       )
       .search(params[:q])
       .result