Finished chapter 11

[depot.git] / app / models / product.rb

diff --git a/app/models/product.rb b/app/models/product.rb
index 05ac26e38d4bc58dc371a9f3c5c649cab0bdebea..27fbdabe21bba36592467e18883ed7556e0f039f 100644 (file)
--- a/app/models/product.rb
+++ b/app/models/product.rb
@@ -5,7 +5,13 @@ class Product < ActiveRecord::Base
   validates_uniqueness_of :title
   validates_format_of :image_url,
                       :with    => %r{\.(gif|jpg|png)$}i,
-                      :message => 'must be a URL for a GIF, JPG, or PNG image.'
+                      :message => "must be a URL for GIF, JPG, or PNG image."
+  
+  def self.find_products_for_sale
+    find(:all, 
+      :conditions => "date_available <= now() and (date_available_until is null or date_available_until >= now())",
+      :order => :title)
+  end
   
 protected
   def price_must_be_at_least_a_penny