order--正序倒序-select
参考:https://apidock.com/rails/ActiveRecord/QueryMethods/order
视图页面
<%= form_tag '', method: :get do %>
总数: <%= select_tag :order, options_for_select([['不排序', nil],['升序', 'asc'],['降序', 'desc']], params[:order]) %>
<%= submit_tag raw(" 查询"), class: "form_submit", class: 'btn btn-secondary btn-sm fa-input' %>
<%= link_to raw('<i class="fa fa-download"></i>下载csv'), download_csv_accounts_path, class: "btn btn-primary btn-sm"%>
<% end %>
controller页面增加判断
@accounts = Account
if params[:order] == 'asc'
@accounts = @accounts.order('nft_asset_count ASC')
elsif params[:order] == 'desc'
@accounts = @accounts.order('nft_asset_count DESC')
else
@accounts = @accounts.order('id desc')
end
@accounts = @accounts.page(params[:page]).per(100)