Sort json data alphabetically in ruby on rails

Question

I have this data with me:

[{:id=>250,
      :application_date=>"02/04/2016",
      :customer_number=>"",
      :customer_name=>"Neymar Silva Junior",
      :city=>"Auckland",
      :region=>"Auckland",
      :service=>"Electricity",
      :name=>"Bosco and Sons",
      :service_plan=>"Electricity Plan",
      :connection_type=>nil,
      :billing_method=>nil,
      :icp_number=>nil,
      :moving_date=>"",
      :supplier_commission=>21.0,
      :show_url=>"/applications/250"},
 {:id=>257,
      :application_date=>"27/05/2016",
      :customer_number=>"",
      :customer_name=>"Ariel name Parra",
      :city=>"Dunedin",
      :region=>"Dunedin",
      :service=>"Electricity",
      :name=>"Bosco and Sons",
      :service_plan=>"Electricity Plan",
      :connection_type=>nil,
      :billing_method=>nil,
      :icp_number=>nil,
      :moving_date=>"28/05/2016",
      :supplier_commission=>21.0,
      :show_url=>"/applications/257"},
 {:id=>291,
      :application_date=>"29/04/2016",
      :customer_number=>"aaaa",
      :customer_name=>"Neymar Silva Junior",
      :city=>"Auckland",
      :region=>"Auckland",
      :service=>"Electricity",
      :name=>"Bosco and Sons",
      :service_plan=>"Electricity Plan",
      :connection_type=>nil,
      :billing_method=>nil,
      :icp_number=>"",
      :moving_date=>"",
      :supplier_commission=>28.0,
      :show_url=>"/applications/291"},
 {:id=>292,
      :application_date=>"29/04/2016",
      :customer_number=>"23223",
      :customer_name=>"Neymar Silva Junior",
      :city=>"Auckland",
      :region=>"Auckland",
      :service=>"Electricity",
      :name=>"Bosco and Sons",
      :service_plan=>"Electricity Plan",
      :connection_type=>nil,
      :billing_method=>nil,
      :icp_number=>"",
      :moving_date=>"",
      :supplier_commission=>21.0,
      :show_url=>"/applications/292"}]

I want to sort this data in two different ways, alphabetically(from A to Z) as well as Recursively(Z to A) according to its attributes in following scenarios:

If the sort parameter is service_plan alphabetically it will sort as per this attribute from A to Z, if recursively then Z to A for this attribute and so on for all attributes.
Id is integer so it should be sorted in increasing or decreasing order.
Moreover the nil value should not through an error and should be present in the result.

Thanks in advance!

jan.zikan · Accepted Answer · 2016-09-09 15:17:17Z

3

def my_sort(data, attribute, asc = true)
  # Make sure that all elements have attribute we want the data to be sorted by
  return data unless data.all? { |elem| elem.key?(attribute) }

  sorted = data.sort_by { |elem| elem[attribute] }
  asc ? sorted : sorted.reverse
end

my_sort(data, :id) # ascending order by default
my_sort(data, :city, false)

If you want to sort by element that can be missing:

def my_sort(data, attribute, asc = true)
  # Convert to string because of possible nil values      
  sorted = data.sort_by { |elem| elem[attribute].to_s }
  asc ? sorted : sorted.reverse
end

edited Sep 9, 2016 at 15:17

answered Sep 9, 2016 at 14:52

jan.zikan

1,31610 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sort json data alphabetically in ruby on rails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related