Merge branch 'production' into iman/switch-account

# Conflicts:
#	indoteknik_api/controllers/api_v1/user.py
#	indoteknik_custom/models/user_company_request.py

1 files changed, 33 insertions, 0 deletions

diff --git a/indoteknik_custom/models/user_company_request.py b/indoteknik_custom/models/user_company_request.py
index f86f3872..86e66934 100644
--- a/indoteknik_custom/models/user_company_request.py
+++ b/indoteknik_custom/models/user_company_request.py
@@ -13,6 +13,39 @@ class UserCompanyRequest(models.Model):
         ('approved', 'Approve'),
         ('rejected', 'Reject'),
     ], string='Approval')
+    similar_company_ids = fields.Many2many('res.partner', compute="_compute_similar_companies", string="Similar Companies")
+
+    @api.depends('user_input')
+    def _compute_similar_companies(self):
+        for record in self:
+            if record.user_input:
+                record.similar_company_ids = [(6, 0, self.get_similar_companies(record.user_input))]
+            else:
+                record.similar_company_ids = [(6, 0, [])]
+
+    # def get_similar_companies(self, user_input):
+    #     query = """
+    #         SELECT id
+    #         FROM res_partner
+    #         WHERE levenshtein(name::text, %s) < 3
+    #         ORDER BY levenshtein(name::text, %s) ASC
+    #     """
+    #     self.env.cr.execute(query, (user_input, user_input))
+    #     return [row[0] for row in self.env.cr.fetchall()]
+
+    def get_similar_companies(self, user_input):
+        query = """
+            SELECT id
+            FROM res_partner
+            WHERE (name ILIKE %s OR levenshtein(name::text, %s) < 3)
+            AND active = TRUE AND is_company = TRUE
+            ORDER BY levenshtein(name::text, %s) ASC
+        """
+        # Menggunakan '%' untuk mencocokkan nama perusahaan sebagian
+        self.env.cr.execute(query, ('%' + user_input + '%', user_input, user_input))
+        company_ids = [row[0] for row in self.env.cr.fetchall()]
+        return company_ids
+
     internal_input = fields.Char(string='Internal Input')
     company_type = fields.Char(string='Company Type', compute='_compute_company_type')