Class: MapRequirement

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
app/models/map_requirement.rb

Constant Summary collapse

FormType =

搜索类型

{
    form_select: 1,   #下拉
    form_datetime: 2, #时间
    form_text: 3      #输入
}
SqlType =

下拉数据来源类型

{
    sql_null: 0,          #自定义下拉
    sql_dict: 1,          #字典
    sql_query: 2          #sql查询所得
}

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.form_type_options ⇒ Object 



35
36
37
 
# File 'app/models/map_requirement.rb', line 35

def self.form_type_options
  [["输入", FormType[:form_text]],["时间", FormType[:form_datetime]],["下拉", FormType[:form_select]]]
end

.sql_type_options ⇒ Object 



31
32
33
 
# File 'app/models/map_requirement.rb', line 31

def self.sql_type_options
  [["", 0],["字典", SqlType[:sql_dict]],["sql查询所得", SqlType[:sql_query]]]
end

Instance Method Details

#dict_options ⇒ Object 



51
52
53
 
# File 'app/models/map_requirement.rb', line 51

def dict_options
  eval(self.dictionary || "{}").collect{|k, v| [k, v] }
end

#form_type_name ⇒ Object

enum sql_type: SqlType



20
21
22
23
24
 
# File 'app/models/map_requirement.rb', line 20

def form_type_name
  return "输入" if self.form_type == FormType[:form_text]
  return "时间" if self.form_type == FormType[:form_datetime]
  return "下拉" if self.form_type == FormType[:form_select]
end

#select_options ⇒ Object 



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

def select_options
  if self.sql_type == SqlType[:sql_dict]
    self.dict_options
  elsif self.sql_type == SqlType[:sql_query]
    self.sql_options
  end
end

#sql_options ⇒ Object 



47
48
49
 
# File 'app/models/map_requirement.rb', line 47

def sql_options
  self.report.connect.exec(self.sql_str).collect{|s|[s["name"], s["value"]]}
end

#sql_type_name ⇒ Object 



26
27
28
29
 
# File 'app/models/map_requirement.rb', line 26

def sql_type_name
  return "字典" if self.sql_type == SqlType[:sql_dict]
  return "sql查询所得" if self.sql_type == SqlType[:sql_query]
end