Table name: subtrades
id :integer not null, primary key trade_id :integer name :string(255) number :string(255) description :text created_at :datetime updated_at :datetime company_id :integer mini_description :string(255)
Returns query condition for customers who had not joined the subtrades.
# File app/models/subtrade.rb, line 63 def self.not_joined_by_customer(customer, query) where(" name like ? AND id NOT IN ( SELECT subtrade_id FROM subtrades_customers WHERE customer_id = ? ) ", "%#{query}%", customer.id) end
Sets pagination per page.
# File app/models/subtrade.rb, line 58 def self.paginate(options = {}) page(options[:page]).per(options[:per_page]) end
Returns alternate name for subtrade(i.e. its trade name followed by its id).
# File app/models/subtrade.rb, line 44 def alternate_name subtrade_number = self.name.scan(/\d+\s/).first self.trade.name + (subtrade_number.present? ? " #{subtrade_number}" : "") end
Returns trade name of subtrade.
# File app/models/subtrade.rb, line 50 def trade_name self.trade.name end