Scope refactor

project.rb

class Project < ActiveRecord::Base

  # Scopes
  scope :current_application, lambda { |application|
    joins(:event).
    where(["events.application_id = ?", application.id])
  }
  scope :ordered, lambda {
    order('end ASC')
  }
  scope :unfinished, lambda {
    where("projects.end > ?", Time.now) # auto wrap Time.now with '' thanks AR
  }
  scope :search, lambda { |params|
    joins(:manifolds).
    where(
      '(title LIKE ? OR manifolds.firstname LIKE ? OR manifolds.lastname LIKE ?)', 
      "%#{params[:search]}%", "%#{params[:search]}%", "%#{params[:search]}%"
    )
  }
  scope :localize, lambda {
    where("projects.locale LIKE ?", I18n.locale.to_s)
  }

end

projects_controller.rb

class Front::ProjectsController < FrontController

  def index
    @projects   = @current_application.projects.search(params).unfinished.ordered.localize
  end

end