|
Chris@0
|
1 <%= error_messages_for 'query' %>
|
|
Chris@0
|
2
|
|
Chris@0
|
3 <div class="box">
|
|
Chris@0
|
4 <div class="tabular">
|
|
Chris@0
|
5 <p><label for="query_name"><%=l(:field_name)%></label>
|
|
Chris@0
|
6 <%= text_field 'query', 'name', :size => 80 %></p>
|
|
Chris@0
|
7
|
|
Chris@0
|
8 <% if User.current.admin? || User.current.allowed_to?(:manage_public_queries, @project) %>
|
|
Chris@0
|
9 <p><label for="query_is_public"><%=l(:field_is_public)%></label>
|
|
Chris@0
|
10 <%= check_box 'query', 'is_public',
|
|
Chris@1115
|
11 :onchange => (User.current.admin? ? nil : 'if (this.checked) {$("#query_is_for_all").removeAttr("checked"); $("#query_is_for_all").attr("disabled", true);} else {$("#query_is_for_all").removeAttr("disabled");}') %></p>
|
|
Chris@0
|
12 <% end %>
|
|
Chris@0
|
13
|
|
Chris@0
|
14 <p><label for="query_is_for_all"><%=l(:field_is_for_all)%></label>
|
|
Chris@0
|
15 <%= check_box_tag 'query_is_for_all', 1, @query.project.nil?,
|
|
Chris@0
|
16 :disabled => (!@query.new_record? && (@query.project.nil? || (@query.is_public? && !User.current.admin?))) %></p>
|
|
Chris@0
|
17
|
|
Chris@0
|
18 <p><label for="query_default_columns"><%=l(:label_default_columns)%></label>
|
|
Chris@0
|
19 <%= check_box_tag 'default_columns', 1, @query.has_default_columns?, :id => 'query_default_columns',
|
|
Chris@1115
|
20 :onclick => 'if (this.checked) {$("#columns").hide();} else {$("#columns").show();}' %></p>
|
|
Chris@0
|
21
|
|
Chris@0
|
22 <p><label for="query_group_by"><%= l(:field_group_by) %></label>
|
|
Chris@0
|
23 <%= select 'query', 'group_by', @query.groupable_columns.collect {|c| [c.caption, c.name.to_s]}, :include_blank => true %></p>
|
|
Chris@1115
|
24
|
|
Chris@1115
|
25 <p><label><%= l(:button_show) %></label>
|
|
Chris@1115
|
26 <%= available_block_columns_tags(@query) %></p>
|
|
Chris@0
|
27 </div>
|
|
Chris@0
|
28
|
|
Chris@1115
|
29 <fieldset id="filters"><legend><%= l(:label_filter_plural) %></legend>
|
|
Chris@0
|
30 <%= render :partial => 'queries/filters', :locals => {:query => query}%>
|
|
Chris@0
|
31 </fieldset>
|
|
Chris@0
|
32
|
|
Chris@0
|
33 <fieldset><legend><%= l(:label_sort) %></legend>
|
|
Chris@0
|
34 <% 3.times do |i| %>
|
|
Chris@909
|
35 <%= i+1 %>:
|
|
Chris@909
|
36 <%= label_tag "query_sort_criteria_attribute_" + i.to_s,
|
|
Chris@909
|
37 l(:description_query_sort_criteria_attribute), :class => "hidden-for-sighted" %>
|
|
Chris@909
|
38 <%= select_tag("query[sort_criteria][#{i}][]",
|
|
Chris@909
|
39 options_for_select([[]] + query.available_columns.select(&:sortable?).collect {|column| [column.caption, column.name.to_s]}, @query.sort_criteria_key(i)),
|
|
Chris@909
|
40 :id => "query_sort_criteria_attribute_" + i.to_s)%>
|
|
Chris@909
|
41 <%= label_tag "query_sort_criteria_direction_" + i.to_s,
|
|
Chris@909
|
42 l(:description_query_sort_criteria_direction), :class => "hidden-for-sighted" %>
|
|
Chris@909
|
43 <%= select_tag("query[sort_criteria][#{i}][]",
|
|
Chris@909
|
44 options_for_select([[], [l(:label_ascending), 'asc'], [l(:label_descending), 'desc']], @query.sort_criteria_order(i)),
|
|
Chris@909
|
45 :id => "query_sort_criteria_direction_" + i.to_s) %>
|
|
Chris@909
|
46 <br />
|
|
Chris@0
|
47 <% end %>
|
|
Chris@0
|
48 </fieldset>
|
|
Chris@0
|
49
|
|
Chris@1115
|
50 <%= content_tag 'fieldset', :id => 'columns', :style => (query.has_default_columns? ? 'display:none;' : nil) do %>
|
|
Chris@0
|
51 <legend><%= l(:field_column_names) %></legend>
|
|
Chris@0
|
52 <%= render :partial => 'queries/columns', :locals => {:query => query}%>
|
|
Chris@0
|
53 <% end %>
|
|
Chris@0
|
54
|
|
Chris@0
|
55 </div>
|
