Class: Requirement

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
app/models/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 



36
37
38
 
# File 'app/models/requirement.rb', line 36

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

.sql_type_options ⇒ Object 



32
33
34
 
# File 'app/models/requirement.rb', line 32

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

Instance Method Details

#dict_options ⇒ Object 



52
53
54
 
# File 'app/models/requirement.rb', line 52

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

#form_type_name ⇒ Object

enum sql_type: SqlType



21
22
23
24
25
 
# File 'app/models/requirement.rb', line 21

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 



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

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 



48
49
50
 
# File 'app/models/requirement.rb', line 48

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

#sql_type_name ⇒ Object 



27
28
29
30
 
# File 'app/models/requirement.rb', line 27

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