class Toolhound::PurchaseOrder

Class to parse GitHub repository owner and name from URLs and to generate URLs

Public Instance Methods

default_joins() click to toggle source
# File lib/toolhound-ruby/purchase_order.rb, line 24
def default_joins
  arr = []
  arr << "INNER JOIN tblPurchaseOrderText ON (tblPurchaseOrderText.intPOID = tblPurchaseOrder.intPOID AND varLocaleID = '#{locale}')"
  # arr << "INNER JOIN tblRentalDetail ON (tblRentalDetail.intRentalDetailID = tblRentalItem.intRentalDetailID)"

  arr
end
default_selects() click to toggle source
# File lib/toolhound-ruby/purchase_order.rb, line 11
def default_selects
  {
    purchase_order:   [
      "intPOID", {"varPONO" => :po_no}, :int_vendor_id, :int_location_id, :int_payment_term_id, :bol_closed, :bol_approved,
      :dte_created_date, :dte_modified_date, :dte_cancelled_date, :bol_cancelled, :var_revision_no
    ],
    purchase_order_text: [:txt_notes]

    # 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],
  }
end