##// END OF EJS Templates
Added a new value for date filters: 'this week'...
Jean-Philippe Lang -
r693:c27106d8595c
parent child
Show More
@@ -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