# coding: utf-8
class ReqZakaz  < ActiveRecord::Base
 class << self
    def instance_method_already_implemented?(method_name)
      return true if method_name == 'connection'
      super
    end
  end

  establish_connection :request
  set_table_name "zakaz_data"
 

  def self.ordered_materials(login)
    #rent - флаг аренды (1 - есть, 0 - нет)
    #asset - id оборудования на складе
    #count - кол-во заказанного
    self.find_by_sql("SELECT * FROM  zakaz_data WHERE zakaz = (SELECT z.id from requestbase as oi
                                JOIN zakaz as z ON z.request = oi.id
                                WHERE oi.ulogin = '#{login}'  order by z.date_created desc limit 1)")
    
  end
end