class Toolhound::RentalItem
Public Instance Methods
default_joins()
click to toggle source
# File lib/toolhound-ruby/rental_item.rb, line 23 def default_joins arr = [] # arr << "INNER JOIN tblRentalItemDetail ON (tblRentalItemDetail.intRentalItemID = tblRentalItem.intRentalItemID)" arr << "INNER JOIN tblRentalDetail ON (tblRentalDetail.intRentalDetailID = tblRentalItem.intRentalDetailID)" # arr << "INNER JOIN tblRental ON (tblRental.intRentalID = tblRentalDetail.intRentalID)" # arr << "INNER JOIN tblLocationText ON (tblLocationText.intLocationID = tblLocation.intLocationID)" arr end
default_selects()
click to toggle source
self.table_name = :rental self.primary_key = :int_rental_id
# File lib/toolhound-ruby/rental_item.rb, line 10 def default_selects #{ }"SELECT tblEntity.intEntityID, tblEntity.varEntityID AS job_no, tblLocation.intLocationID, tblLocationText.varLocationName FROM tblEntity INNER JOIN tblLocation ON tblLocation.intEntityID = tblEntity.intEntityID INNER JOIN tblLocationText ON tblLocationText.intLocationID = tblLocation.intLocationID WHERE varEntityID LIKE '%10526.00%'" { rental_item: [:int_rental_detail_id, :int_inventory_id_id ], # rental_item_detail: [:var_status, :status_date, ], rental_detail: [:int_rental_id, :int_inventory_id, :int_quantity, :dec_daily, :dec_weekly, :dec_monthly, :dec_selling_price], # rental: [ # :int_rental_id, :var_rental_number, :int_from_location_id, :int_entity_id, :dte_required_date, :int_rate_sheet_id, # :int_job_id, :dte_created_date, :dte_modified_date # ], } end
find_by_entity_id(id)
click to toggle source
# File lib/toolhound-ruby/rental_item.rb, line 34 def find_by_entity_id(id) all(limit: 1, where: [{int_entity_id: id}]).first end
find_by_rental_id(id)
click to toggle source
# File lib/toolhound-ruby/rental_item.rb, line 38 def find_by_rental_id(id) all(where: [{"rental_detail.int_rental_id" => id}]) end
total_charges_for_entity(id)
click to toggle source
# File lib/toolhound-ruby/rental_item.rb, line 42 def total_charges_for_entity(id) build_and_query(selects: selects, where: wheres, joins: joins) end