Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. <%= form_tag(sheets_path, :method => "get", id: "search-form") do %>
  2. <%= date_field :search, params[:search], placeholder: "Procurar sheets" %>
  3. <%= submit_tag "Procurar", :name => nil,class: "button" %>
  4. <% end %>
  5.  
  6. def index
  7. @sheets = Sheet.where(user_id: current_user)
  8. if params[:search]
  9. @sheets = Sheet.search(params[:search], current_user.id)
  10. else
  11. @sheets = Sheet.where(user_id: current_user)
  12. end
  13. end
  14.  
  15. def self.search(search, userid)
  16. date_start = search
  17. date_end = '2017-07-27T00:00:00'#hardcoded, for now, implement date_start +24h later
  18. self.where("user_id =" + userid.to_s ).where("inicio > ?", date_start).where("inicio < ?", date_end)
  19. end
  20.  
  21. Processing by SheetsController#index as HTML
  22. Parameters: {"utf8"=>"✓", "search"=>{""2017-07-03""=>"2017-07-05"}}
  23. 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]]
  24. Completed 500 Internal Server Error in 6ms (ActiveRecord: 1.0ms)
  25.  
  26.  
  27.  
  28. TypeError (can't quote Array):
  29.  
  30. app/models/sheet.rb:7:in `search'
  31.  
  32. <%= date_field :search, params[:search], placeholder: "Procurar sheets" %>
  33.  
  34. <%= date_field_tag(:search, Date.today)%>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement