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
481-500 / 500 show all
481etEveniet repellendus necessitatibus nam neque.No23 OctEdit
482consequuntur eumMaiores quo voluptatibus rerum ipsam consequatur.No 5 JunEdit
483laborum dictaVeniam reiciendis laboriosam voluptas accusamus qui.No28 FebEdit
484quiaMolestias ut reprehenderit ipsum quod corporis dolore debitis iste.No31 MayEdit
485ut teneturEos corporis voluptate ex sed totam.No13 OctEdit
486enim harum minimaEum dolore ut natus.No25 SepEdit
487natus etVoluptatibus mollitia corporis est numquam eum.No31 JanEdit
488doloribus veritatisMagni sunt illum deserunt impedit maiores natus.No 6 AprEdit
489voluptatemExcepturi voluptas molestias aspernatur corporis.No31 JanEdit
490maximeIncidunt ducimus iste illum inventore nostrum.No10 AprEdit
491modi nesciuntLaboriosam voluptatem sunt quod voluptatum magnam quisquam.No10 MayEdit
492sed atInventore ipsum qui rerum cum reiciendis nisi.No14 JunEdit
493estCorporis vel omnis et quam illo.No 6 FebEdit
494fugiat quaeratIncidunt laborum voluptas cumque et pariatur.No10 JunEdit
495qui ut inQuis ut eos a et.No 8 OctEdit
496velit non pariaturQuia possimus rerum eum architecto.Yes 6 SepEdit
497impedit quoQuod earum illum voluptatem.No 9 JulEdit
498sedQui sint eos distinctio vel assumenda sed animi quae.Yes 7 JulEdit
499voluptatemMagnam accusantium id aut et quaerat praesentium eveniet.No19 JunEdit
500vel eaEt a ut cum eos sed.Yes30 MarEdit

Fork me on GitHub