JumpstartLab/tracks

class SearchController < ApplicationController

  helper :todos, :application, :notes, :projects, :contexts
  
  def results
    @source_view = params['_source_view'] || 'search'
    @page_title = "TRACKS::Search Results for #{params[:search]}"
    terms = "%#{params[:search]}%"

    @found_not_complete_todos = current_user.todos.
      where("(todos.description LIKE ? OR todos.notes LIKE ?) AND todos.completed_at IS NULL", terms, terms).
      includes(Todo::DEFAULT_INCLUDES).
      reorder("todos.due IS NULL, todos.due ASC, todos.created_at ASC").
      all
    
    @found_complete_todos = current_user.todos.
      where("(todos.description LIKE ? OR todos.notes LIKE ?) AND NOT (todos.completed_at IS NULL)", terms, terms).
      includes(Todo::DEFAULT_INCLUDES).
      reorder("todos.completed_at DESC").
      all
      
    @found_todos = @found_not_complete_todos + @found_complete_todos

    @found_projects = current_user.projects.where("name LIKE ? OR description LIKE ?", terms, terms).all
    @found_notes = current_user.notes.where("body LIKE ?", terms).all
    @found_contexts = current_user.contexts.where("name LIKE ?", terms).all
    
    # TODO: limit search to tags on todos
    @found_tags = Tagging.find_by_sql([
        "SELECT DISTINCT tags.name as name "+
          "FROM tags "+
          "LEFT JOIN taggings ON tags.id = taggings.tag_id "+
          "LEFT JOIN todos ON taggings.taggable_id = todos.id "+
          "WHERE todos.user_id=? "+
          "AND tags.name LIKE ? ", current_user.id, terms])

    @count = @found_todos.size  + @found_projects.size + @found_notes.size + @found_contexts.size + @found_tags.size

    init_not_done_counts
    init_project_hidden_todo_counts
  end

  def index
    @page_title = "TRACKS::Search"
  end

  def init
    @source_view = params['_source_view'] || 'search'
  end

end