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
61-80 / 500 Sýna allt
436accusantiumCorrupti qui mollitia temporibus.No 1 OctEdit
111sit eaCulpa numquam dolorem corporis corrupti aliquam.Yes 7 AprEdit
10rerum occaecatiCum aperiam voluptas aut.No14 AugEdit
307omnisCum ducimus rerum officiis nihil quam.No 4 JunEdit
47temporibus iure delectusCumque placeat aut vel repellat omnis accusamus error odio.No11 FebEdit
231quia quisCupiditate error facilis qui nobis modi hic.Yes17 OctEdit
291odio fugit etCupiditate repudiandae corrupti sed culpa cumque vitae aut et.No22 JunEdit
426accusantium eligendiDebitis dolore id eos tempora.No 1 SepEdit
246eos laborumDelectus assumenda sint praesentium est.No12 MarEdit
385et teneturDelectus consectetur vitae dicta eveniet.No 6 SepEdit
347sint aut velDeleniti et aut laboriosam praesentium.No12 AugEdit
228reprehenderitDeleniti non necessitatibus voluptas.No13 OctEdit
218quaerat sequiDeserunt et rem ut.No10 OctEdit
233nesciunt suscipit quisDicta vel atque occaecati quisquam qui est tempora.Yes23 MayEdit
319et voluptatemDicta vel deleniti quasi enim laudantium repudiandae est sint.No23 MarEdit
247eum temporeDignissimos cumque rem dolores voluptatem numquam omnis unde autem.No13 OctEdit
121dolore idDignissimos fugit amet nulla quis numquam sed explicabo.No 2 MarEdit
48qui inciduntDignissimos harum ut ea veritatis ut.No 2 AugEdit
28laborum enim voluptasDignissimos sed laudantium in consequatur quaerat molestias optio maxime.No23 MayEdit
237vel esseDistinctio accusamus et dolores aliquam repudiandae omnis.No10 OctEdit

Fork me on GitHub