Ruby China

新手问题 怎么把传到控制器的检索条件给写进语句里？

yu7272yu · November 01, 2016 · Last by yu7272yu replied at November 03, 2016 · 1875 hits 
ef index_data
    qc = params[:q]
    qc.merge!({"order_total_"+params[:order_total] => params[:order_total_cont]}) if params[:order_total].present? and params[:order_total_cont].present? 

        @q = StatisticalChargingPile.search(qc).result.select("sum(order_total) as order_total_sum, parking_area_name, third_party_pile_id, serial_number, operator_name").group("serial_number").having("order_total_sum > ? ",params[:order_total_cont] ).order("created_at desc")

end
2 Floor has deleted
yu7272yu #3 November 02, 2016

@hz_qiuyuanxin 传来的

params[:order_total]

是个 (gt,gteq,lt,lteq),想转换成符号（>,>=,<,<=）,写进 having 里面去

mimosa #4 November 02, 2016

#3 楼 @yu7272yu 


params[:order_total] = case params[:order_total]
when 'gt'
 '>'
when 'gteq'
 '>='
when 'lt'
 '<'
when 'lteq'
 '<='
else
 '='
end


...
.having("order_total_sum #{params[:order_total]} ? ", params[:order_total_cont] )
...
yu7272yu #5 November 02, 2016

@mimosa 谢谢了，这样写的是

hs = {"gt" => ">", "gteq" => ">=", "lt" => "<", "lteq" => "<="}
        constr1 = "order_total_sum #{hs[params[:order_total]]} #{params[:order_total_cont]} and " if params[:order_total].present? and params[:order_total_cont].present?
cs = "#{constr1} 1=1"
@q = StatisticalChargingPile.search(qc).result.select("sum(order_total) as order_total_sum, parking_area_name, third_party_pile_id, serial_number, operator_name").group("serial_number").having(cs ).order("created_at desc")
yu7272yu #6 November 02, 2016

@mimosa 但是这样写，在页面好像不能使用分页了？

mimosa #7 November 02, 2016

#6 楼 @yu7272yu kaminari 可以分页。

yu7272yu #8 November 02, 2016

@mimosa 

<nav class="com-pager">
<%= paginate statistical_charging_piles %>   
</nav>

像我在控制器中写的语句，分页就不行

mimosa #9 November 03, 2016

statistical_charging_piles 是什么，方法？

yu7272yu #10 November 03, 2016 
def index_data
        qc = params[:q]
        hs = {"gt" => ">", "gteq" => ">=", "lt" => "<", "lteq" => "<="}
        constr1 = "order_total_sum #{hs[params[:order_total]]} #{params[:order_total_cont]} and " if params[:order_total].present? and params[:order_total_cont].present?
        constr2 = "electricity_total_sum #{hs[params[:electricity_total]]} #{params[:electricity_total_cont]} and " if params[:electricity_total].present? and params[:electricity_total_cont].present?
        cs = "#{constr1} #{constr2} 1=1"
    @q = StatisticalChargingPile.search(qc).result.select("sum(order_total) as order_total_sum, sum(electricity_total) as electricity_total_sum, parking_area_name,charging_pile_id, third_party_pile_id, serial_number, operator_name").group("serial_number").having(cs).order("created_at desc")

        @statistical_charging_piles = @q.result.page(params[:page])

        render :json => {
        :htmls => render_to_string({
            :partial => "index_data",
            :locals => {statistical_charging_piles: @statistical_charging_piles}
        })
    }



end
You need to Sign in before reply, if you don't have an account, please Sign up first.