Class: C80Yax::PriceProp

Inherits:
ActiveRecord::Base
  • Object
show all
Includes:
Concerns::Props::Parsable
Defined in:
app/models/c80_yax/price_prop.rb

Class Method Summary collapse

Methods included from Concerns::Props::Parsable

included

Class Method Details

.gget_sort_pprop_for_strsubcat(strsubcat_id) ⇒ Object

выдать id Имени Свойства типа “цена”, по которому будет происходить “сортировка по цене”



35
36
37
38
39
40
41
42
43
44
 
# File 'app/models/c80_yax/price_prop.rb', line 35

def self.gget_sort_pprop_for_strsubcat(strsubcat_id)
  rows = self.select_props_sql(strsubcat_id)
  if rows.count > 0
    rows.each(:as => :hash) do |row|
      return row["prop_name_id"]
    end
  else
    return ""
  end
end

.select_props_sql(strsubcat_id) ⇒ Object

выдать таблицу, которая описывает список ценовых свойств, которые выводятся под картинкой ---------------————–---------------------———–--------- | price_prop_id | prop_name_id | title | uom_title | related | ---------------————–---------------------———–--------- | 1 | 18 | Цена за шт. | руб | 19 | | 2 | 20 | Цена за м² | руб | 21 | ---------------————–---------------------———–---------



17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
# File 'app/models/c80_yax/price_prop.rb', line 17

def self.select_props_sql(strsubcat_id)
  sql = "
SELECT
  c80_yax_price_props_prop_names.*,
  c80_yax_prop_names.title,
  c80_yax_uoms.title as uom_title,
  c80_yax_prop_names.related_id
FROM c80_yax_price_props
  LEFT JOIN c80_yax_price_props_prop_names ON c80_yax_price_props.id = c80_yax_price_props_prop_names.price_prop_id
  LEFT JOIN c80_yax_prop_names ON c80_yax_price_props_prop_names.prop_name_id = c80_yax_prop_names.id
  LEFT JOIN c80_yax_uoms ON c80_yax_prop_names.uom_id = c80_yax_uoms.id
WHERE c80_yax_price_props.strsubcat_id = #{strsubcat_id};
"
  rows = ActiveRecord::Base.connection.execute(sql)
  rows
end