Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%= form_tag(sheets_path, :method => "get", id: "search-form") do %>
- <%= date_field :search, params[:search], placeholder: "Procurar sheets" %>
- <%= submit_tag "Procurar", :name => nil,class: "button" %>
- <% end %>
- def index
- @sheets = Sheet.where(user_id: current_user)
- if params[:search]
- @sheets = Sheet.search(params[:search], current_user.id)
- else
- @sheets = Sheet.where(user_id: current_user)
- end
- end
- def self.search(search, userid)
- date_start = search
- date_end = '2017-07-27T00:00:00'#hardcoded, for now, implement date_start +24h later
- self.where("user_id =" + userid.to_s ).where("inicio > ?", date_start).where("inicio < ?", date_end)
- end
- Processing by SheetsController#index as HTML
- Parameters: {"utf8"=>"✓", "search"=>{""2017-07-03""=>"2017-07-05"}}
- User Load (1.0ms) EXEC sp_executesql N'SELECT [users].* FROM [users] WHERE [users].[id] = @0 ORDER BY [users].[id] ASC OFFSET 0 ROWS FETCH NEXT @1 ROWS ONLY', N'@0 int, @1 int', @0 = 7, @1 = 1 [["id", nil], ["LIMIT", nil]]
- Completed 500 Internal Server Error in 6ms (ActiveRecord: 1.0ms)
- TypeError (can't quote Array):
- app/models/sheet.rb:7:in `search'
- <%= date_field :search, params[:search], placeholder: "Procurar sheets" %>
- <%= date_field_tag(:search, Date.today)%>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement