skidooer fucked around with this message at 17:50 on Nov 20, 2007

skidooer fucked around with this message at 20:08 on Nov 20, 2007

# File active_record/base.rb, line 2021
def create_or_update
  raise ReadOnlyRecord if readonly?
  result = new_record? ? create : update
  result != false
end

hmm yes fucked around with this message at 20:58 on Nov 20, 2007

sql = "SELECT p.* FROM payment AS p \
	LEFT JOIN school AS s ON p.schoolID = s.schoolID \
	LEFT JOIN cost AS c ON p.costID = c.costID \
	LEFT JOIN databaseInformation AS d on c.databaseID = d.databaseID
	WHERE s.schoolName LIKE '%school redacted%' && library NOT LIKE '%library also redacted%' \
	&& c.subscriptionStart >= '" + @dateStart.to_formatted_s(:db) + "' \
	&& c.subscriptionEnd <= '" + @dateEnd.to_formatted_s(:db) + "' \
	ORDER BY s.schoolName, s.library, d.databaseName"
					
@payments = Payment.find_by_sql(sql)

zigb fucked around with this message at 22:47 on Nov 20, 2007

class Payment < ActiveRecord::Base
  def self.find_subscriptions(start_date, end_date, options = {})
    options.reverse_merge!(
      :select     => 'payments.*',
      :joins      => construct_subscription_joins
      :conditions => construct_subscription_conditions(start_date, end_date)
    )
    
    find(:all, options)
  end
  
  def self.contruct_subscription_joins
    %(
      LEFT JOIN schools ON payments.school_id = schools.id
      LEFT JOIN costs ON payments.cost_id = costs.id
      LEFT JOIN database_informations ON costs.database_information_id 
         = database_informations.id
    )
  end
  
  def self.construct_subscription_conditions(start_date, end_date)
    statement = %(
      schools.school_name LIKE '% school redacted' AND
      library NOT LIKE '%library also redacted%' AND
      costs.subscription_start >= ? AND costs.subscription_end <= ?
    )
                  
    [ statement, range.first, range.last ]
  end
end

@payments = Payment.find_subscriptions(@start_date, @end_date,
      :order => 'school_name, library, database_name')

class MyController < ApplicationController
  before_filter :require_admin
  before_filter :initialize_some_object, :only => [ :index, :show ]

  private
    def require_admin
      redirect_to login_url unless current_user.admin?
    end

    def initialize_some_object
      @some_object = SomeObject.find(params[:some_object_id]
    end
end

skidooer fucked around with this message at 23:35 on Nov 20, 2007

<%= f.collection_select [b]:category_id[/b], @categories, :id, :name %>

class Event < ActiveRecord::Base
  belongs_to :category
  
  def category_with_id_assignment=(category_id)
    category = case category_id
    when String, Fixnum
      Category.find(category_id)
    else
      category_id
    end
    
    self.category_without_id_assignment = category
  end
  alias_method :category_without_id_assignment=, :category=
  alias_method :category=, :category_with_id_assignment=
end

skidooer fucked around with this message at 19:20 on Nov 21, 2007

<% form_for :event, :builder=>EventFormBuilder, ..... do |f|  %>

  <% f.inside_table do %>
       
       <%= f.text_field... %>

  <% end>

<% end %>

def inside_table
  puts "<table ...>"
  yield
  puts "</table>"
end

Hop Pocket fucked around with this message at 16:10 on Nov 22, 2007

Hop Pocket fucked around with this message at 17:53 on Nov 22, 2007