Posts Tagged ‘ROR’

Here we will discuss about the server side datatable with rails 4.
I was working with a project where we need to list/show a few thousands of records in a table, pagination, sorting  and also advanced searching for those records. So for this scenario I had to use a datatable (server side).

So today we will see how the datatable can be used with serverside in rails 4.

jQuery Datatable can be used for sorting, searching, paginating a number of records in a table.


First of all we need include the js and css in the application.js and the application.css respectively.

require dataTables/jquery.dataTables

Now first we will write the code for view then controller then datatables.
In the view, lets see a piece of code as the example.
Suppose we have to show User name, email, joining date etc.

<table id="users_listing" class="datatable-list">
    <th>User Name</th>
    <th>Join Date</th>

Now we have to make a datatable folder for the model so that we can save all the datatable at the same place , it may useful when we have more than one datatable. Like assets , controller, model folder we will make datatable folder, in that we will make user_datatable.rb

class UsersDatatable
delegate :params, :h, :link_to, :edit_user_path, to: :@view

def initialize(view)
@view = view

def as_json(options = {})
sEcho: params[:sEcho].to_i,
iTotalRecords: User.all.count,
iTotalDisplayRecords: users.total_count,
aaData: data

in the private methods we have to write the methods for data


def data do |user|
link_to(, edit_user_path(user)),,
(user.status ? 'Active': 'Inactive'),
link_to('Delete', admin_user_path(user, type: 'users'), method: :delete, data: {confirm: 'Are you sure to delete this user?'})

def users
@users ||= fetch_users

def fetch_users

if user_search.present?
#do something


def page
params[:iDisplayStart].to_i/per_page + 1

def per_page
params[:iDisplayLength].to_i &amp;gt; 0 ? params[:iDisplayLength].to_i : 10

def sort_column
columns = %w[first_name email created_at sum(test_23.total_ad) total status]

def sort_direction
params[:sSortDir_0] == &quot;desc&quot; ? &quot;desc&quot; : &quot;asc&quot;

def user_search
#here you can write searching mechanism.


Now moving to controller

render json:

in the js file we need to add this

  var table = $("#users_listing").DataTable({
        iDisplayLength: 100,
        bInfo: false,
        bSort: true,
        sPaginationType: "full_numbers",
        bStateSave: true,
        bDestroy: true,
        bProcessing: true,
        bServerSide: true,
        bFilter: false,
        sAjaxSource: '/test_users/search',
        fnServerParams: function (aoData) {
                { "name": "email_or_name", "value": $("#_email_or_name").val() },
                { "name": "check_token", "value": check_token_value },
                { "name": "from_no_of_tokens", "value": from_token_value }
                { "name": "status", "value": $("#_status").val() }
        "aoColumns": [ null,  null,   null, { "bSortable": true}, { "bSortable": true}, null,  { "bSortable": false}],
            sZeroRecords: "No users found."},
        "sDom": 'rtlfip'


Now call the function and enjoy.
Hope this will help!!!


In many cases we need to deal with a huge number of pdf files. As in my case I am currently working on a shipping project , which deals with the pdf labels so I have faced the problem to store a pdf in database in encoded form and to display the decoded pdf file inline by base64. So here I will share the steps to solve this problem.

Data type for the column of the table where we have to save the pdf in encrypted form should be “text” type.
Lets say column name is image_hex.

(t.text     “image_hex”)

Then we need to add the base64 module.

require ‘base64’

The purpose of using base64 to encode data is that it translates any binary data into purely printable characters.

The methods for encode and decode is given below-

  1.  encode64(data) – Returns the encoded version data.
  2.  decode64(str) – Returns the Base64-decoded version of str(encrypted date).

Lets see an example.

First we will encode pdf so that we can store it in a database.

image_hex = Base64.encode64( “#{PATH}#{file_name}.pdf”).read)

Now, image_hex contains the encoded form of pdf which we can store in database.

Now if we want to delete the original pdf(physical file) file then

File.delete(“#{PATH}#{file_name}.pdf”) if File.exist?(“#{PATH}#{file_name}.pdf”)

Now we have to use the stored encoded form of the file to show in the view(Display pdf inline).

@pdf_file = Base64.decode64(database_object.image_hex).html_safe
send_data @label_image, :type => ‘application/pdf’, :disposition => ‘inline’

This will display the pdf file decode form(original form).

Hope this will help!!