Sha256: dd0c966b7f4ea119679203d30d79ebf5020170f5a1c2ea4f702b68a5bff9d6ca
Contents?: true
Size: 1.41 KB
Versions: 32
Compression:
Stored size: 1.41 KB
Contents
module Toolhound
# Class to parse GitHub repository owner and name from
# URLs and to generate URLs
class PurchaseOrderItem < Base
self.table_name = :purchase_order_detail
self.primary_key = "intPODetailID"
def default_selects
{
purchase_order_detail: [
"intPOID", :int_inventory_id, :dec_cost, :int_qty_ordered, :int_qty_received, :int_qty_rejected,
:int_manufacturer_id, :bol_rent, :int_purchase_uof_m, :int_qty_required, :int_qty_returned,
:dte_expected
]
}
# {
# purchase_order: [
# "intPOID", "varPONO", :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
def for_po(po_id)
end
end
end
Version data entries
32 entries across 32 versions & 1 rubygems