SoundSoftware Code Site

<table style="border-collapse: collapse; border:0;">

  <tr>

    <td style="padding-left:0">

      <%= label_tag "available_columns", l(:description_available_columns) %>

      <br />

      <%= select_tag 'available_columns',

              options_for_select((query.available_columns - query.columns).collect {|column| [column.caption, column.name]}),

              :multiple => true, :size => 10, :style => "width:150px",

              :ondblclick => "moveOptions(this.form.available_columns, this.form.selected_columns);" %>

    </td>

    <td align="center" valign="middle">

      <input type="button" value="&#8594;"

       onclick="moveOptions(this.form.available_columns, this.form.selected_columns);" /><br />

      <input type="button" value="&#8592;"

       onclick="moveOptions(this.form.selected_columns, this.form.available_columns);" />

    </td>

    <td>

      <%= label_tag "selected_columns", l(:description_selected_columns) %>

      <br />

      <%= select_tag 'c[]',

              options_for_select(query.columns.collect {|column| [column.caption, column.name]}),

              :id => 'selected_columns', :multiple => true, :size => 10, :style => "width:150px",

              :ondblclick => "moveOptions(this.form.selected_columns, this.form.available_columns);" %>

    </td>

    <td align="center" valign="middle">

      <input type="button" value="&#8593;" onclick="moveOptionUp(this.form.selected_columns);" /><br />

      <input type="button" value="&#8595;" onclick="moveOptionDown(this.form.selected_columns);" />

    </td>

  </tr>

</table>

<% content_for :header_tags do %>

<%= javascript_include_tag 'select_list_move' %>

<% end %>

<script type="text/javascript">

//<![CDATA[

function add_filter() {

  select = $('add_filter_select');

  field = select.value

  Element.show('tr_' +  field);

  check_box = $('cb_' + field);

  check_box.checked = true;

  toggle_filter(field);

  select.selectedIndex = 0;

  for (i=0; i<select.options.length; i++) {

    if (select.options[i].value == field) {

      select.options[i].disabled = true;

    }

  }

}

function toggle_filter(field) {

  check_box = $('cb_' + field);

  if (check_box.checked) {

    Element.show("operators_" + field);

    Form.Element.enable("operators_" + field);

    toggle_operator(field);

  } else {

    Element.hide("operators_" + field);

    Form.Element.disable("operators_" + field);

    enableValues(field, []);

  }

}

function enableValues(field, indexes) {

  var f = $$(".values_" + field);

  for(var i=0;i<f.length;i++) {

    if (indexes.include(i)) {

      Form.Element.enable(f[i]);

      f[i].up('span').show();

    } else {

      f[i].value = '';

      Form.Element.disable(f[i]);

      f[i].up('span').hide();

    }

  }

  if (indexes.length > 0) {

    Element.show("div_values_" + field);

  } else {

    Element.hide("div_values_" + field);

  }

}

function toggle_operator(field) {

  operator = $("operators_" + field);

  switch (operator.value) {

    case "!*":

    case "*":

    case "t":

    case "w":

    case "o":

    case "c":

      enableValues(field, []);

      break;

    case "><":

      enableValues(field, [0,1]);

      break;

    case "<t+":

    case ">t+":

    case "t+":

    case ">t-":

    case "<t-":

    case "t-":

      enableValues(field, [2]);

      break;

    default:

      enableValues(field, [0]);

      break;

  }

}

function toggle_multi_select(el) {

  var select = $(el);

  if (select.multiple == true) {

    select.multiple = false;

  } else {

    select.multiple = true;

  }

}

function submit_query_form(id) {

  selectAllOptions("selected_columns");

  $(id).submit();

}

function apply_filters_observer() {

  $$("#query_form input[type=text]").invoke("observe", "keypress", function(e){

    if(e.keyCode == Event.KEY_RETURN) {

      submit_query_form("query_form");

    }

  });

}

Event.observe(document,"dom:loaded", apply_filters_observer);

//]]>

</script>

<table width="100%">

<tr>

<td>

<table>

<% query.available_filters.sort{|a,b| a[1][:order]<=>b[1][:order]}.each do |filter| %>

    <% field = filter[0]

       options = filter[1] %>

    <tr <%= 'style="display:none;"' unless query.has_filter?(field) %> id="tr_<%= field %>" class="filter">

    <td class="field">

        <%= check_box_tag 'f[]', field, query.has_filter?(field), :onclick => "toggle_filter('#{field}');", :id => "cb_#{field}" %>

        <label for="cb_<%= field %>"><%= filter[1][:name] || l(("field_"+field.to_s.gsub(/\_id$/, "")).to_sym) %></label>

    </td>

    <td class="operator">

        <%= label_tag "op_#{field}", l(:description_filter), :class => "hidden-for-sighted" %>

        <%= select_tag "op[#{field}]", options_for_select(operators_for_select(options[:type]),

                        query.operator_for(field)), :id => "operators_#{field}",

                        :onchange => "toggle_operator('#{field}');" %>

    </td>

    <td class="values">

    <div id="div_values_<%= field %>" style="display:none;">

    <% case options[:type]

    when :list, :list_optional, :list_status, :list_subprojects %>

        <span class="span_values_<%= field %>">

          <%= select_tag "v[#{field}][]", options_for_select(options[:values], query.values_for(field)), :class => "values_#{field}", :id => "values_#{field}_1", :multiple => (query.values_for(field) && query.values_for(field).length > 1) %>

          <%= link_to_function image_tag('bullet_toggle_plus.png'), "toggle_multi_select('values_#{field}_1');" %>

        </span>

    <% when :date, :date_past %>

        <span class="span_values_<%= field %>"><%= text_field_tag "v[#{field}][]", query.value_for(field), :size => 10, :class => "values_#{field}", :id => "values_#{field}_1" %> <%= calendar_for "values_#{field}_1" %></span>

        <span class="span_values_<%= field %>"><%= text_field_tag "v[#{field}][]", query.value_for(field, 1), :size => 10, :class => "values_#{field}", :id => "values_#{field}_2" %> <%= calendar_for "values_#{field}_2" %></span>

        <span class="span_values_<%= field %>"><%= text_field_tag "v[#{field}][]", query.value_for(field), :size => 3, :class => "values_#{field}" %> <%= l(:label_day_plural) %></span>

    <% when :string, :text %>

        <span class="span_values_<%= field %>"><%= text_field_tag "v[#{field}][]", query.value_for(field), :class => "values_#{field}", :id => "values_#{field}", :size => 30 %></span>

    <% when :integer, :float %>

        <span class="span_values_<%= field %>"><%= text_field_tag "v[#{field}][]", query.value_for(field), :class => "values_#{field}", :id => "values_#{field}_1", :size => 6 %></span>

        <span class="span_values_<%= field %>"><%= text_field_tag "v[#{field}][]", query.value_for(field, 1), :class => "values_#{field}", :id => "values_#{field}_2", :size => 6 %></span>

    <% end %>

    </div>

    <script type="text/javascript">toggle_filter('<%= field %>');</script>

    </td>

    </tr>

<% end %>

</table>

</td>

<td class="add-filter">

<%= label_tag('add_filter_select', l(:label_filter_add)) %>

<%= select_tag 'add_filter_select', options_for_select([["",""]] + query.available_filters.sort{|a,b| a[1][:order]<=>b[1][:order]}.collect{|field| [ field[1][:name] || l(("field_"+field[0].to_s.gsub(/_id$/, "")).to_sym), field[0]] unless query.has_filter?(field[0])}.compact),

                                    :onchange => "add_filter();",

                                    :name => nil %>

</td>

</tr>

</table>

<%= hidden_field_tag 'f[]', '' %>

<%= error_messages_for 'query' %>

<div class="box">

<div class="tabular">

<p><label for="query_name"><%=l(:field_name)%></label>

<%= text_field 'query', 'name', :size => 80 %></p>

<% if User.current.admin? || User.current.allowed_to?(:manage_public_queries, @project) %>

<p><label for="query_is_public"><%=l(:field_is_public)%></label>

<%= check_box 'query', 'is_public',

      :onchange => (User.current.admin? ? nil : 'if (this.checked) {$("query_is_for_all").checked = false; $("query_is_for_all").disabled = true;} else {$("query_is_for_all").disabled = false;}') %></p>

<% end %>

<p><label for="query_is_for_all"><%=l(:field_is_for_all)%></label>

<%= check_box_tag 'query_is_for_all', 1, @query.project.nil?,

      :disabled => (!@query.new_record? && (@query.project.nil? || (@query.is_public? && !User.current.admin?))) %></p>

<p><label for="query_default_columns"><%=l(:label_default_columns)%></label>

<%= check_box_tag 'default_columns', 1, @query.has_default_columns?, :id => 'query_default_columns',

      :onclick => 'if (this.checked) {Element.hide("columns")} else {Element.show("columns")}' %></p>

<p><label for="query_group_by"><%= l(:field_group_by) %></label>

<%= select 'query', 'group_by', @query.groupable_columns.collect {|c| [c.caption, c.name.to_s]}, :include_blank => true %></p>

</div>

<fieldset><legend><%= l(:label_filter_plural) %></legend>

<%= render :partial => 'queries/filters', :locals => {:query => query}%>

</fieldset>

<fieldset><legend><%= l(:label_sort) %></legend>

<% 3.times do |i| %>

<%= i+1 %>: 

<%= label_tag "query_sort_criteria_attribute_" + i.to_s,

              l(:description_query_sort_criteria_attribute), :class => "hidden-for-sighted" %>

<%= select_tag("query[sort_criteria][#{i}][]",

               options_for_select([[]] + query.available_columns.select(&:sortable?).collect {|column| [column.caption, column.name.to_s]}, @query.sort_criteria_key(i)),

               :id => "query_sort_criteria_attribute_" + i.to_s)%>

<%= label_tag "query_sort_criteria_direction_" + i.to_s,

              l(:description_query_sort_criteria_direction), :class => "hidden-for-sighted" %>

<%= select_tag("query[sort_criteria][#{i}][]",

                options_for_select([[], [l(:label_ascending), 'asc'], [l(:label_descending), 'desc']], @query.sort_criteria_order(i)),

                :id => "query_sort_criteria_direction_" + i.to_s) %>

<br />

<% end %>

</fieldset>

<% content_tag 'fieldset', :id => 'columns', :style => (query.has_default_columns? ? 'display:none;' : nil) do %>

<legend><%= l(:field_column_names) %></legend>

<%= render :partial => 'queries/columns', :locals => {:query => query}%>

<% end %>

</div>

<h2><%= l(:label_query) %></h2>

<% form_tag(query_path(@query), :onsubmit => 'selectAllOptions("selected_columns");', :method => :put) do %>

  <%= render :partial => 'form', :locals => {:query => @query} %>

  <%= submit_tag l(:button_save) %>

<% end %>

api.array :queries, api_meta(:total_count => @query_count, :offset => @offset, :limit => @limit) do

  @queries.each do |query|

    api.query do

      api.id          query.id

      api.name        query.name

      api.is_public   query.is_public

      api.project_id  query.project_id

    end

  end

end

<div class="contextual">

<%= link_to_if_authorized l(:label_query_new), new_project_query_path(:project_id => @project), :class => 'icon icon-add' %>

</div>

<h2><%= l(:label_query_plural) %></h2>

<% if @queries.empty? %>

  <p><i><%=l(:label_no_data)%></i></p>

<% else %>

  <table class="list">

  <% @queries.each do |query| %>

    <tr class="<%= cycle('odd', 'even') %>">

      <td>

        <%= link_to h(query.name), :controller => 'issues', :action => 'index', :project_id => @project, :query_id => query %>

      </td>

      <td align="right">

        <small>

        <% if query.editable_by?(User.current) %>

        <%= link_to l(:button_edit), edit_query_path(query), :class => 'icon icon-edit' %>

        <%= link_to l(:button_delete), query_path(query), :confirm => l(:text_are_you_sure), :method => :delete, :class => 'icon icon-del' %>

        </small>

      <% end %>

      </td>

    </tr>

  <% end %>

  </table>

<% end %>

<h2><%= l(:label_query_new) %></h2>

<% form_tag(@project ? project_queries_path : queries_path, :onsubmit => 'selectAllOptions("selected_columns");') do %>

  <%= render :partial => 'form', :locals => {:query => @query} %>

  <%= submit_tag l(:button_save) %>

<% end %>