Search payments by categories explicitely

It was already possible to search by categories in the full text input,
but it could have matched other fields as well.

Explicitely add a select to search by categories.

Also put the search form in a left aside. The mobile view is not done
for the moment.

1 files changed, 1 insertions, 4 deletions

diff --git a/src/db/payments.rs b/src/db/payments.rs
index 624ba9f..3b85dab 100644
--- a/src/db/payments.rs
+++ b/src/db/payments.rs
@@ -133,7 +133,6 @@ OFFSET ?
 fn search_query(search: String) -> String {
     let payments_name = utils::format_key_for_search("payments.name");
     let users_name = utils::format_key_for_search("users.name");
-    let categories_name = utils::format_key_for_search("categories.name");
 
     search
         .split_ascii_whitespace()
@@ -144,11 +143,10 @@ AND (
     {} LIKE ?
     OR payments.cost LIKE ?
     OR {} LIKE ?
-    OR {} LIKE ?
     OR strftime('%d/%m/%Y', date) LIKE ?
 )
         "#,
-                payments_name, users_name, categories_name
+                payments_name, users_name
             )
         })
         .collect::<Vec<String>>()
@@ -165,7 +163,6 @@ fn bind_search<'a, Row: FromRow<'a, SqliteRow>>(
             .bind(s.clone())
             .bind(s.clone())
             .bind(s.clone())
-            .bind(s.clone())
     })
 }