mysociety/alaveteli

# app/controllers/admin_track_controller.rb:
# Show email alerts / RSS feeds from admin interface.
#
# Copyright (c) 2008 UK Citizens Online Democracy. All rights reserved.
# Email: hello@mysociety.org; WWW: http://www.mysociety.org/

class AdminTrackController < AdminController
  before_action :set_track_thing, only: [:destroy]

  def index
    @query = params[:query]
    if @query
      track_things = TrackThing.where(["lower(track_query) like lower('%'||?||'%')", @query])
    else
      track_things = TrackThing
    end
    @admin_tracks =
      track_things.order(created_at: :desc).
        paginate(page: params[:page], per_page: 100)
    @popular = ActiveRecord::Base.connection.select_all("select count(*) as count, title, info_request_id from track_things join info_requests on info_request_id = info_requests.id where info_request_id is not null group by info_request_id, title order by count desc limit 10;")
  end

  def destroy
    @track_thing.destroy
    flash[:notice] = 'Track destroyed'
    redirect_to admin_user_url(@track_thing.tracking_user)
  end

  private

  def set_track_thing
    @track_thing = TrackThing.find(params[:id])
  end
end