WiceGrid 3.6.0.pre4 examples

CSV export and external filters

CSV export works with define_grid and external filters, too.

  • # encoding: utf-8
    class CsvAndDetachedFiltersController < ApplicationController
      def index
        @tasks_grid = initialize_grid(Task,
          name: 'grid',
          enable_export_to_csv: true,
          csv_field_separator: ';',
          csv_file_name: 'tasks'
        )
    
        export_grid_if_requested('grid' => 'grid')
      end
    end
    
  • .well
      %h2= current_page_title
      %p
        CSV export works with
        %code define_grid
        and external filters, too.
    
    = show_code
    
    = render   'grid'
    
    
    .row
      .col-md-2
        ID:
      .col-md-10
        = grid_filter @tasks_grid, :id_filter
    
    .row
      .col-md-2
        Title:
      .col-md-10
        = grid_filter @tasks_grid, :title_filter
    
    .row
      .col-md-2
        Description:
      .col-md-10
        = grid_filter @tasks_grid, :description_filter
    
    .row
      .col-md-2
        Archived:
      .col-md-10
        = grid_filter @tasks_grid, :archived_filter
    
    
    .row
      .col-md-2
        Due date:
      .col-md-10
        = grid_filter @tasks_grid, :due_date
    
    
    .row
      .col-md-12
        %button.btn.btn-primary.wg-external-submit-button{'data-grid-name' => 'grid'} Submit
        %button.btn.btn-default.wg-external-reset-button{'data-grid-name' => 'grid'} Reset
        %button.btn.btn-primary.wg-external-csv-export-button{'data-grid-name' => 'grid'} Export To CSV
    
    %p
    
    .row
      .col-md-12
    
    
    
        = render_grid(@tasks_grid)
    
  • <%= define_grid(@tasks_grid, hide_submit_button: true, hide_reset_button: true) do |g|
    
      g.column name:  'ID', attribute: 'id', detach_with_id: :id_filter
    
      g.column name:  'Title', attribute: 'title', detach_with_id: :title_filter
    
      g.column  name:  'Description', attribute: 'description', detach_with_id: :description_filter
    
      g.column  name:  'Archived', attribute: 'archived', detach_with_id: :archived_filter do |task|
        task.archived? ? 'Yes' : 'No'
      end
    
    
      g.column name:  'Due Date', attribute: 'due_date', detach_with_id: :due_date do |task|
        task.due_date.to_s(:short)
      end
    
    
      g.column   do |task|
        link_to('Edit', edit_task_path(task))
      end
    
    end -%>
    
ID:
Title:
Description:
Archived:
Due date:

IDTitleDescription ArchivedDue Date
41-60 / 500 Sýna allt
473voluptatum quiBlanditiis quisquam ut eos eum.No22 MarEdit
376assumendaBlanditiis tempora qui ut ex.No25 SepEdit
50ipsum nam temporeBlanditiis totam ab aut.No23 MarEdit
161autCommodi delectus eaque quia occaecati molestiae voluptate ut qui.No25 AprEdit
138sint quiCommodi qui fugiat eum aut consequuntur.No 9 MarEdit
210molestiaeCommodi soluta deleniti magni nisi error voluptas.No 6 MayEdit
199ea consectetur velitConsectetur fuga adipisci ad quia alias qui.No 4 MayEdit
345consequatur est sequiConsectetur libero quia ut dicta.No28 AugEdit
424non autem solutaConsectetur omnis excepturi cum vitae.No14 JanEdit
86adipisciConsectetur optio rerum facilis explicabo enim consequatur delectus iste.No 7 FebEdit
53molestiaeConsequatur explicabo quos unde esse a distinctio sapiente voluptas.No 4 JunEdit
3aliquam repudiandaeConsequatur iste similique dolorum ducimus ut.No20 AprEdit
427quae assumendaConsequatur iure et odio nulla tenetur.No 9 OctEdit
300minimaConsequatur nesciunt tempora asperiores quo ipsa repudiandae qui dolorem.Yes 9 JunEdit
90commodi et quisConsequatur soluta eligendi et consequatur.No30 MayEdit
268quasi minima magniConsequuntur aspernatur eos cumque facere.No 5 OctEdit
79animiCorporis est inventore nesciunt est nam voluptas et.No 6 MayEdit
5dicta pariaturCorporis iure repellat fuga omnis alias iusto aut voluptatum.No 4 MarEdit
181temporeCorporis rerum id possimus adipisci placeat omnis et.No 1 JunEdit
493estCorporis vel omnis et quam illo.No 6 FebEdit

Fork me on GitHub