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
    
  • <%= 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 -%>
    
  • .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)
    
ID:
Title:
Description:
Archived:
Due date:

IDTitleDescriptionArchivedDue Date
61-80 / 500 show all
61quia architectoRerum sit aliquid quia corrupti praesentium.No 2 AugEdit
62eum velit saepeVoluptas voluptas nesciunt in eos eum inventore.No18 OctEdit
63accusamusPraesentium quod ipsum error odit.No17 SepEdit
64reiciendisQuaerat voluptatum nihil iure.No12 AprEdit
65eosOccaecati atque assumenda qui deleniti.Yes31 JulEdit
66vitae at autemNihil quae dolores quia ut non.No16 JunEdit
67officia quo maioresAut aperiam aut sint voluptas voluptatibus ut cumque id.No 5 OctEdit
68exercitationem delectusSapiente ipsa dolorem aut sed cumque in esse.No 1 OctEdit
69similique placeat ipsaAlias ratione autem ut impedit non nihil itaque eaque.No19 MarEdit
70autemSit ipsa aut qui quia voluptatem omnis.No 4 AugEdit
71atRatione distinctio eligendi quaerat.No13 JulEdit
72illum explicabo modiNesciunt exercitationem quisquam commodi ut.No27 MayEdit
73iure architectoVoluptatum aperiam ad dolore aut fugit.No20 AugEdit
74molestiaeAd dolores occaecati fuga ratione praesentium quo.No 5 MarEdit
75velit non magniTotam dolor est sint et sed.No16 SepEdit
76totamDistinctio et pariatur non est consequatur enim.No 6 SepEdit
77sed quibusdam isteQuis non ducimus quia perferendis.No18 JunEdit
78exercitationem sapienteQuasi numquam aut magnam expedita dolor repudiandae officiis.No18 JunEdit
79animiCorporis est inventore nesciunt est nam voluptas et.No 6 MayEdit
80corrupti officiaDolore odit consequatur dolores quia deleniti veniam.No29 SepEdit

Fork me on GitHub