lib/ofac/models/ofac_sdn.rb in ofac-1.3.2 vs lib/ofac/models/ofac_sdn.rb in ofac-2.0.0

@@ -1,5 +1,25 @@
 require 'active_record'
 
 class OfacSdn < ActiveRecord::Base
 
+  def self.possible_sdns(name_array, use_ors = false)
+    name_conditions = []
+    alt_name_conditions = []
+    values = []
+    name_array.each do |partial_name|
+      name_conditions << '(lower(name) like ?)'
+      alt_name_conditions << '(lower(alternate_identity_name) like ?)'
+      values << "%#{partial_name.downcase}%"
+    end
+    if use_ors
+      conditions = (name_conditions + alt_name_conditions).join(' or ')
+    else
+      name_conditions = name_conditions.join(' and ')
+      alt_name_conditions = alt_name_conditions.join(' and ')
+      conditions = "(#{name_conditions}) or (#{alt_name_conditions})"
+    end
+    # we need the values in there twice, once for the names and once for the alt_names
+    OfacSdn.select(:name, :alternate_identity_name, :address, :city).where(sdn_type: 'individual').where(conditions, *(values * 2))
+  end
+
 end