Contents

module Toolhound

  # Class to parse GitHub repository owner and name from
  # URLs and to generate URLs
  class PurchaseOrder < Base


    # self.table_name   = :rental
    self.primary_key  = "intPOID"

    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

    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

  end
end

Version data entries

32 entries across 32 versions & 1 rubygems

Version	Path
toolhound-ruby-1.0.37	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.36	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.35	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.34	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.33	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.32	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.31	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.30	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.29	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.28	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.27	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.26	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.25	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.24	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.23	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.22	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.21	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.20	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.19	lib/toolhound-ruby/purchase_order.rb
toolhound-ruby-1.0.18	lib/toolhound-ruby/purchase_order.rb