三年没弄ror了,最近兼职,ruby 1.86,rails2.2.2
遇到这么一个问题,请教一下
查询过滤条件需要动态,即表单有输入时则过滤,否则不过滤。
并且日期过滤为between and方式
created_at=params[:created_at]
if !created_at.nil?
created_at='>'+created_at //此处改成'>='不行
end
created_at_end=params[:created_at_end]
if !created_at_end.nil?
created_at_end='<'+created_at_end //此处改成'<='不行
end
cond = Sql.and(
Sql.find?('corp_name', params[:corp_name] == ''? nil : params[:corp_name]),
Sql.find?('branch_bank_no', session['user'].organ.organ_id),
Sql.find?("to_char(created_at,'yyyy-mm-dd')", created_at == ''? nil :created_at),
Sql.find?("to_char(created_at,'yyyy-mm-dd')", created_at_end == ''? nil :created_at_end)
)
求解决方案,先多谢!