@@ -36,6 +36,7 class Query < ActiveRecord::Base | |||||
36 | ">t+" => :label_in_more_than, |
|
36 | ">t+" => :label_in_more_than, | |
37 | "t+" => :label_in, |
|
37 | "t+" => :label_in, | |
38 | "t" => :label_today, |
|
38 | "t" => :label_today, | |
|
39 | "w" => :label_this_week, | |||
39 | ">t-" => :label_less_than_ago, |
|
40 | ">t-" => :label_less_than_ago, | |
40 | "<t-" => :label_more_than_ago, |
|
41 | "<t-" => :label_more_than_ago, | |
41 | "t-" => :label_ago, |
|
42 | "t-" => :label_ago, | |
@@ -48,8 +49,8 class Query < ActiveRecord::Base | |||||
48 | :list_status => [ "o", "=", "!", "c", "*" ], |
|
49 | :list_status => [ "o", "=", "!", "c", "*" ], | |
49 | :list_optional => [ "=", "!", "!*", "*" ], |
|
50 | :list_optional => [ "=", "!", "!*", "*" ], | |
50 | :list_one_or_more => [ "*", "=" ], |
|
51 | :list_one_or_more => [ "*", "=" ], | |
51 | :date => [ "<t+", ">t+", "t+", "t", ">t-", "<t-", "t-" ], |
|
52 | :date => [ "<t+", ">t+", "t+", "t", "w", ">t-", "<t-", "t-" ], | |
52 | :date_past => [ ">t-", "<t-", "t-", "t" ], |
|
53 | :date_past => [ ">t-", "<t-", "t-", "t", "w" ], | |
53 | :string => [ "=", "~", "!", "!~" ], |
|
54 | :string => [ "=", "~", "!", "!~" ], | |
54 | :text => [ "~", "!~" ] } |
|
55 | :text => [ "~", "!~" ] } | |
55 |
|
56 | |||
@@ -71,7 +72,7 class Query < ActiveRecord::Base | |||||
71 | # filter requires one or more values |
|
72 | # filter requires one or more values | |
72 | (values_for(field) and !values_for(field).first.empty?) or |
|
73 | (values_for(field) and !values_for(field).first.empty?) or | |
73 | # filter doesn't require any value |
|
74 | # filter doesn't require any value | |
74 | ["o", "c", "!*", "*", "t"].include? operator_for(field) |
|
75 | ["o", "c", "!*", "*", "t", "w"].include? operator_for(field) | |
75 | end if filters |
|
76 | end if filters | |
76 | end |
|
77 | end | |
77 |
|
78 | |||
@@ -238,6 +239,8 class Query < ActiveRecord::Base | |||||
238 | sql = sql + "#{db_table}.#{db_field} BETWEEN '%s' AND '%s'" % [connection.quoted_date((Date.today + v.first.to_i).to_time), connection.quoted_date((Date.today + v.first.to_i + 1).to_time)] |
|
239 | sql = sql + "#{db_table}.#{db_field} BETWEEN '%s' AND '%s'" % [connection.quoted_date((Date.today + v.first.to_i).to_time), connection.quoted_date((Date.today + v.first.to_i + 1).to_time)] | |
239 | when "t" |
|
240 | when "t" | |
240 | sql = sql + "#{db_table}.#{db_field} BETWEEN '%s' AND '%s'" % [connection.quoted_date(Date.today.to_time), connection.quoted_date((Date.today+1).to_time)] |
|
241 | sql = sql + "#{db_table}.#{db_field} BETWEEN '%s' AND '%s'" % [connection.quoted_date(Date.today.to_time), connection.quoted_date((Date.today+1).to_time)] | |
|
242 | when "w" | |||
|
243 | sql = sql + "#{db_table}.#{db_field} BETWEEN '%s' AND '%s'" % [connection.quoted_date(Time.now.at_beginning_of_week), connection.quoted_date(Time.now.next_week)] | |||
241 | when "~" |
|
244 | when "~" | |
242 | sql = sql + "#{db_table}.#{db_field} LIKE '%#{connection.quote_string(v.first)}%'" |
|
245 | sql = sql + "#{db_table}.#{db_field} LIKE '%#{connection.quote_string(v.first)}%'" | |
243 | when "!~" |
|
246 | when "!~" |
@@ -34,6 +34,7 function toggle_operator(field) { | |||||
34 | case "!*": |
|
34 | case "!*": | |
35 | case "*": |
|
35 | case "*": | |
36 | case "t": |
|
36 | case "t": | |
|
37 | case "w": | |||
37 | case "o": |
|
38 | case "o": | |
38 | case "c": |
|
39 | case "c": | |
39 | Element.hide("div_values_" + field); |
|
40 | Element.hide("div_values_" + field); |
@@ -318,6 +318,7 label_in_less_than: по-малко от | |||||
318 | label_in_more_than: повече от |
|
318 | label_in_more_than: повече от | |
319 | label_in: в следващите |
|
319 | label_in: в следващите | |
320 | label_today: днес |
|
320 | label_today: днес | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: преди по-малко от |
|
322 | label_less_than_ago: преди по-малко от | |
322 | label_more_than_ago: преди повече от |
|
323 | label_more_than_ago: преди повече от | |
323 | label_ago: преди дни |
|
324 | label_ago: преди дни |
@@ -318,6 +318,7 label_in_less_than: in weniger als | |||||
318 | label_in_more_than: in mehr als |
|
318 | label_in_more_than: in mehr als | |
319 | label_in: an |
|
319 | label_in: an | |
320 | label_today: heute |
|
320 | label_today: heute | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: vor weniger als |
|
322 | label_less_than_ago: vor weniger als | |
322 | label_more_than_ago: vor mehr als |
|
323 | label_more_than_ago: vor mehr als | |
323 | label_ago: vor |
|
324 | label_ago: vor |
@@ -318,6 +318,7 label_in_less_than: in less than | |||||
318 | label_in_more_than: in more than |
|
318 | label_in_more_than: in more than | |
319 | label_in: in |
|
319 | label_in: in | |
320 | label_today: today |
|
320 | label_today: today | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: less than days ago |
|
322 | label_less_than_ago: less than days ago | |
322 | label_more_than_ago: more than days ago |
|
323 | label_more_than_ago: more than days ago | |
323 | label_ago: days ago |
|
324 | label_ago: days ago |
@@ -318,6 +318,7 label_in_less_than: en menos que | |||||
318 | label_in_more_than: en más que |
|
318 | label_in_more_than: en más que | |
319 | label_in: en |
|
319 | label_in: en | |
320 | label_today: hoy |
|
320 | label_today: hoy | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: hace menos de |
|
322 | label_less_than_ago: hace menos de | |
322 | label_more_than_ago: hace más de |
|
323 | label_more_than_ago: hace más de | |
323 | label_ago: hace |
|
324 | label_ago: hace |
@@ -318,6 +318,7 label_in_less_than: dans moins de | |||||
318 | label_in_more_than: dans plus de |
|
318 | label_in_more_than: dans plus de | |
319 | label_in: dans |
|
319 | label_in: dans | |
320 | label_today: aujourd'hui |
|
320 | label_today: aujourd'hui | |
|
321 | label_this_week: cette semaine | |||
321 | label_less_than_ago: il y a moins de |
|
322 | label_less_than_ago: il y a moins de | |
322 | label_more_than_ago: il y a plus de |
|
323 | label_more_than_ago: il y a plus de | |
323 | label_ago: il y a |
|
324 | label_ago: il y a |
@@ -318,6 +318,7 label_in_less_than: è minore di | |||||
318 | label_in_more_than: è maggiore di |
|
318 | label_in_more_than: è maggiore di | |
319 | label_in: in |
|
319 | label_in: in | |
320 | label_today: oggi |
|
320 | label_today: oggi | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: meno di giorni fa |
|
322 | label_less_than_ago: meno di giorni fa | |
322 | label_more_than_ago: più di giorni fa |
|
323 | label_more_than_ago: più di giorni fa | |
323 | label_ago: giorni fa |
|
324 | label_ago: giorni fa |
@@ -319,6 +319,7 label_in_less_than: 残日数がこれより多い | |||||
319 | label_in_more_than: 残日数がこれより少ない |
|
319 | label_in_more_than: 残日数がこれより少ない | |
320 | label_in: 残日数 |
|
320 | label_in: 残日数 | |
321 | label_today: 今日 |
|
321 | label_today: 今日 | |
|
322 | label_this_week: this week | |||
322 | label_less_than_ago: 経過日数がこれより少ない |
|
323 | label_less_than_ago: 経過日数がこれより少ない | |
323 | label_more_than_ago: 経過日数がこれより多い |
|
324 | label_more_than_ago: 経過日数がこれより多い | |
324 | label_ago: 日前 |
|
325 | label_ago: 日前 |
@@ -318,6 +318,7 label_in_less_than: in minder dan | |||||
318 | label_in_more_than: in meer dan |
|
318 | label_in_more_than: in meer dan | |
319 | label_in: in |
|
319 | label_in: in | |
320 | label_today: vandaag |
|
320 | label_today: vandaag | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: minder dan dagen geleden |
|
322 | label_less_than_ago: minder dan dagen geleden | |
322 | label_more_than_ago: meer dan dagen geleden |
|
323 | label_more_than_ago: meer dan dagen geleden | |
323 | label_ago: dagen geleden |
|
324 | label_ago: dagen geleden |
@@ -318,6 +318,7 label_in_less_than: e maior que | |||||
318 | label_in_more_than: e menor que |
|
318 | label_in_more_than: e menor que | |
319 | label_in: em |
|
319 | label_in: em | |
320 | label_today: hoje |
|
320 | label_today: hoje | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: faz menos de |
|
322 | label_less_than_ago: faz menos de | |
322 | label_more_than_ago: faz mais de |
|
323 | label_more_than_ago: faz mais de | |
323 | label_ago: dias atras |
|
324 | label_ago: dias atras |
@@ -318,6 +318,7 label_in_less_than: é maior que | |||||
318 | label_in_more_than: é menor que |
|
318 | label_in_more_than: é menor que | |
319 | label_in: em |
|
319 | label_in: em | |
320 | label_today: hoje |
|
320 | label_today: hoje | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: faz menos de |
|
322 | label_less_than_ago: faz menos de | |
322 | label_more_than_ago: faz mais de |
|
323 | label_more_than_ago: faz mais de | |
323 | label_ago: dias atrás |
|
324 | label_ago: dias atrás |
@@ -318,6 +318,7 label_in_less_than: i mindre än | |||||
318 | label_in_more_than: i mer än |
|
318 | label_in_more_than: i mer än | |
319 | label_in: i |
|
319 | label_in: i | |
320 | label_today: idag |
|
320 | label_today: idag | |
|
321 | label_this_week: this week | |||
321 | label_less_than_ago: mindre än dagar sedan |
|
322 | label_less_than_ago: mindre än dagar sedan | |
322 | label_more_than_ago: mer än dagar sedan |
|
323 | label_more_than_ago: mer än dagar sedan | |
323 | label_ago: dagar sedan |
|
324 | label_ago: dagar sedan |
@@ -321,6 +321,7 label_in_less_than: 剩余天数小于 | |||||
321 | label_in_more_than: 剩余天数大于 |
|
321 | label_in_more_than: 剩余天数大于 | |
322 | label_in: 剩余天数 |
|
322 | label_in: 剩余天数 | |
323 | label_today: 今天 |
|
323 | label_today: 今天 | |
|
324 | label_this_week: this week | |||
324 | label_less_than_ago: 之前天数少于 |
|
325 | label_less_than_ago: 之前天数少于 | |
325 | label_more_than_ago: 之前天数大于 |
|
326 | label_more_than_ago: 之前天数大于 | |
326 | label_ago: 之前天数 |
|
327 | label_ago: 之前天数 |
General Comments 0
You need to be logged in to leave comments.
Login now