Class: C80Estate::Atype

Inherits:
ActiveRecord::Base
  • Object
show all
Extended by:
FriendlyId
Defined in:
app/models/c80_estate/atype.rb

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.get_propnames(atype_id) ⇒ Object

выдать все характеристики, присущие данной категории, вместе с единицами измерений



48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
 
# File 'app/models/c80_estate/atype.rb', line 48

def self.get_propnames(atype_id)

=begin
      >> stdh_get_atype_propnames(1)
  <stdh_get_atype_propnames> BEGIN
     (0.2ms)
      SELECT
        `prop_names`.`id`,
        `prop_names`.`title`,
        `prop_names`.`is_excluded_from_filtering`,
        `uoms`.`title` as uom_title
      FROM `prop_names`
        INNER JOIN `prop_names_atypes` ON `prop_names`.`id` = `prop_names_atypes`.`prop_name_id`
        LEFT OUTER JOIN uoms ON uoms.id = prop_names.uom_id
      WHERE `prop_names_atypes`.`atype_id` = 1;

  {"id"=>18, "title"=>"Цена за шт.", "is_excluded_from_filtering"=>1, "uom_title"=>"руб"}
  {"id"=>19, "title"=>"Цена за шт. (старая)", "is_excluded_from_filtering"=>1, "uom_title"=>"руб"}
  {"id"=>20, "title"=>"Цена за м²", "is_excluded_from_filtering"=>1, "uom_title"=>"руб"}
  {"id"=>21, "title"=>"Цена за м² (старая)", "is_excluded_from_filtering"=>1, "uom_title"=>"руб"}
  {"id"=>23, "title"=>"Размер", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>24, "title"=>"Страна", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>25, "title"=>"Прочность на сжатие", "is_excluded_from_filtering"=>0, "uom_title"=>"кгс/см²"}
  {"id"=>26, "title"=>"Коэффициент теплопроводности", "is_excluded_from_filtering"=>0, "uom_title"=>"Вт/м×°C"}
  {"id"=>27, "title"=>"Марка по морозостойкости", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>28, "title"=>"Водопоглощение", "is_excluded_from_filtering"=>0, "uom_title"=>"%"}
  {"id"=>29, "title"=>"Цвет", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>30, "title"=>"Пустотность", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>31, "title"=>"Формовка", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>32, "title"=>"Поверхность", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>33, "title"=>"Вес", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>34, "title"=>"Количество на поддоне", "is_excluded_from_filtering"=>1, "uom_title"=>"шт"}
  {"id"=>35, "title"=>"Тип кирпича", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>36, "title"=>"Производитель", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  {"id"=>37, "title"=>"Артикул", "is_excluded_from_filtering"=>1, "uom_title"=>nil}
  {"id"=>38, "title"=>"Формат", "is_excluded_from_filtering"=>0, "uom_title"=>nil}
  <stdh_get_atype_propnames> END
=end

  Rails.logger.debug "<Atype.get_propnames> BEGIN"
  sql = "
SELECT
  `c80_estate_prop_names`.`id`,
  `c80_estate_prop_names`.`title`,
  `c80_estate_prop_names`.`is_excluded_from_filtering`,
  `c80_estate_uoms`.`title` as uom_title
FROM `c80_estate_prop_names`
  INNER JOIN `c80_estate_atypes_prop_names` ON `c80_estate_prop_names`.`id` = `c80_estate_atypes_prop_names`.`prop_name_id`
  LEFT OUTER JOIN `c80_estate_uoms` ON `c80_estate_uoms`.`id` = `c80_estate_prop_names`.`uom_id`
WHERE `c80_estate_atypes_prop_names`.`atype_id` = #{atype_id};
"

  result = []
  rows = ActiveRecord::Base.connection.execute(sql)
  rows.each(:as => :hash) do |row|
    result << row
  end

  Rails.logger.debug "<Atype.get_propnames> END"
  result

end

Instance Method Details

#get_list_removed_props ⇒ Object 



40
41
42
43
44
45
 
# File 'app/models/c80_estate/atype.rb', line 40

def get_list_removed_props
  @list_removed_props = [] unless @list_removed_props.present?
  res = @list_removed_props
  @list_removed_props = []
  res
end

#normalize_friendly_id(input) ⇒ Object 



28
29
30
 
# File 'app/models/c80_estate/atype.rb', line 28

def normalize_friendly_id(input)
  input.to_s.to_slug.normalize(transliterations: :russian).to_s
end

#prop_names_changed? ⇒ Boolean

• этот метод дёргает только StrsubcatSweeper • после вызова метода - значение сбрасывается в false

Returns:

  • (Boolean) 


34
35
36
37
38
 
# File 'app/models/c80_estate/atype.rb', line 34

def prop_names_changed?
  res = @mark_prop_names_changed
  @mark_prop_names_changed = false
  res
end

#slug_candidates ⇒ Object 



24
25
26
 
# File 'app/models/c80_estate/atype.rb', line 24

def slug_candidates
  [:title] + Array.new(6) {|index| [:title, index+2]}
end