Contents

class FlightLogExpense

  many_to_one :trip_leg, :class=>:TripLeg, :key=>:trip_leg_id

  def airport_fuel_lookup
    if is_departure_expense?
      date1, date2 =  trip_leg.dept_date_act_local, trip_leg.depart_date_local
      fbo_id = trip_leg.fueler_id
    else
      date1, date2 = trip_leg.arr_date_act_local, trip_leg.arrival_date_local
      fbo_id = trip_leg.fbo_id
    end

    # I would prefer to this filter{ (effective_date <= date1) | (effective_date <= date2) }
    # for filter, but does not work if date is nil
    ap = AirportFuel.
        filter('`effective date` <= ? or `effective date` <= ?', date1, date2).
        filter(:vendor_id=>vendor_id).filter(:fbo_id=> fbo_id).order(:effective_date).
        last
    ap ? ap.values : {}
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
fossil-0.5.50	lib/dbr_models/flight_log_expense.rb
fossil-0.5.49	lib/dbr_models/flight_log_expense.rb
fossil-0.5.48	lib/dbr_models/flight_log_expense.rb
fossil-0.5.47	lib/dbr_models/flight_log_expense.rb
fossil-0.5.46	lib/dbr_models/flight_log_expense.rb
fossil-0.5.45	lib/dbr_models/flight_log_expense.rb
fossil-0.5.44	lib/dbr_models/flight_log_expense.rb
fossil-0.5.43	lib/dbr_models/flight_log_expense.rb
fossil-0.5.42	lib/dbr_models/flight_log_expense.rb
fossil-0.5.41	lib/dbr_models/flight_log_expense.rb
fossil-0.5.40	lib/dbr_models/flight_log_expense.rb
fossil-0.5.39	lib/dbr_models/flight_log_expense.rb
fossil-0.5.38	lib/dbr_models/flight_log_expense.rb