search_option.rb in caboose-rets-0.1.19

- old
+ new

@@ -8,18 +8,18 @@
     # Flag all for delete
     self.update_all(:flag_for_delete => true)
     
     names = {
       'City'          => ['city'],
-      'County'        => ['county'],
-      'Zip Code'      => ['zip'],
-      'Schools'       => ['elem_school', 'middle_school', 'high_school'],
+      'County'        => ['county_or_parish'],
+      'Zip Code'      => ['postal_code'],
+      'Schools'       => ['elementary_school', 'middle_school', 'high_school'],
       'MLS Area'      => ['area'],
       'Neighborhood'  => ['subdivision'],
       'Street Name'   => ['street_name'],
-      'Property Type' => ['prop_type'],      
-      'MLS Number'    => ['mls_acct']      
+      'Property Type' => ['property_type'],      
+      'MLS Number'    => ['mls_number']      
       #'feature',            
       #'location',
     }
     names.each do |name, fields|
       fields.each do |field|
@@ -30,10 +30,10 @@
     # Delete all flagged
     self.where(:flag_for_delete => true).delete_all        
   end
   
   def self.update_search_options_for_field(name, field)
-    q = ["select distinct(#{field}) from rets_residential where (status = ? or status = ?)", 'Pending', 'Active']
+    q = ["select distinct(#{field}) from rets_properties where (status = ? or status = ?)", 'Pending', 'Active']
     rows = ActiveRecord::Base.connection.select_rows(ActiveRecord::Base.send(:sanitize_sql_array, q))
     rows.each do |row|
       so = self.where(:name => name, :field => field, :value => row[0]).first
       if so.nil?
         self.create(:name => name, :field => field, :value => row[0])