class Abacos::Price

Public Class Methods

find_by_sku_and_table(sku, table) click to toggle source
# File lib/abacos/price.rb, line 6
def self.find_by_sku_and_table(sku, table)
  execute("select list_value = prol_val_pre, sell_value = prol_val_prepro from abacos..tcom_proser pro with (nolock) join abacos..tcom_prolis lis with (nolock) on pro.pros_cod = lis.pros_cod and lis.lisp_cod = #{table} where pro.pros_ext_cod = '#{sku}'").first
end