# app/controllers/admin_controller.rb:
# Controller for main admin pages.
#
# Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved.
# Email: hello@mysociety.org; WWW: http://www.mysociety.org/

class AdminGeneralController < AdminController
    skip_before_filter :authenticate, :only => :admin_js

    def index
        # ensure we have a trailing slash
        current_uri = request.env['REQUEST_URI']
        if params[:suppress_redirect].nil? && !(current_uri =~ /\/$/)
            redirect_to admin_general_index_url + "/"
            return
        end

        # Overview counts of things
        @public_body_count = PublicBody.count

        @info_request_count = InfoRequest.count
        @outgoing_message_count = OutgoingMessage.count
        @incoming_message_count = IncomingMessage.count

        @user_count = User.count
        @track_thing_count = TrackThing.count

        @comment_count = Comment.count

        # Tasks to do
        @requires_admin_requests = InfoRequest.find(:all, :select => '*, ' + InfoRequest.last_event_time_clause + ' as last_event_time', :conditions => ["described_state = 'requires_admin'"], :order => "last_event_time")
        @error_message_requests = InfoRequest.find(:all, :select => '*, ' + InfoRequest.last_event_time_clause + ' as last_event_time', :conditions => ["described_state = 'error_message'"], :order => "last_event_time")
        @attention_requests = InfoRequest.find(:all, :select => '*, ' + InfoRequest.last_event_time_clause + ' as last_event_time', :conditions => ["described_state = 'attention_requested'"], :order => "last_event_time")
        @blank_contacts = PublicBody.find(:all, :conditions => ["request_email = ''"], :order => "updated_at")
        @old_unclassified = InfoRequest.find_old_unclassified(:limit => 20,
                                                                       :conditions => ["prominence = 'normal'"])
        @holding_pen_messages = InfoRequest.holding_pen_request.incoming_messages
    end

    def timeline
        # Recent events
        @events_title = "Events in last two days"
        date_back_to = Time.now - 2.days
        if params[:hour]
            @events_title = "Events in last hour"
            date_back_to = Time.now - 1.hour
        end
        if params[:day]
            @events_title = "Events in last day"
            date_back_to = Time.now - 1.day
        end
        if params[:week]
            @events_title = "Events in last week"
            date_back_to = Time.now - 1.week
        end
        if params[:month]
            @events_title = "Events in last month"
            date_back_to = Time.now - 1.month
        end
        if params[:all]
            @events_title = "Events, all time"
            date_back_to = Time.now - 1000.years
        end

        # Get an array of event attributes within the timespan in the format
        # [id, type_of_model, event_timestamp]
        # Note that the relevent date for InfoRequestEvents is creation, but
        # for PublicBodyVersions is update thoughout
        connection = InfoRequestEvent.connection
        timestamps = connection.select_rows("SELECT id,'InfoRequestEvent',
                                                    created_at AS timestamp
                                             FROM info_request_events
                                             WHERE created_at > '#{date_back_to.getutc}'
                                             UNION
                                             SELECT id, 'PublicBodyVersion',
                                                  updated_at AS timestamp
                                             FROM #{PublicBody.versioned_class.table_name}
                                             WHERE updated_at > '#{date_back_to.getutc}'
                                             ORDER by timestamp desc")
        @events = WillPaginate::Collection.create((params[:page] or 1), 100) do |pager|
            # create a hash for each model type being returned
            info_request_event_ids = {}
            public_body_version_ids = {}
            # get the relevant slice from the paginator
            timestamps.slice(pager.offset, pager.per_page).each_with_index do |event, index|
                # for each event in the slice, add an item to the hash for the model type
                # whose key is the model id, and value is the position in the slice
                if event[1] == 'InfoRequestEvent'
                    info_request_event_ids[event[0].to_i] = index
                else
                    public_body_version_ids[event[0].to_i] = index
                end
            end
            # get all the models in the slice, eagerly loading the associations we use in the view
            public_body_versions = PublicBody.versioned_class.find(:all,
                                          :conditions => ['id in (?)', public_body_version_ids.keys],
                                          :include => [ { :public_body => :translations }])
            info_request_events = InfoRequestEvent.find(:all,
                                          :conditions => ['id in (?)', info_request_event_ids.keys],
                                          :include => [:info_request])
            @events = []
            # drop the models into a combined array, ordered by their position in the timestamp slice
            public_body_versions.each do |version|
                @events[public_body_version_ids[version.id]] = [version, version.updated_at]
            end
            info_request_events.each do |event|
                @events[info_request_event_ids[event.id]] = [event, event.created_at]
            end

            # inject the result array into the paginated collection:
            pager.replace(@events)

            # set the total entries for the page to the overall number of results
            pager.total_entries = timestamps.size
        end

    end

    def stats
        # Overview counts of things
        @public_body_count = PublicBody.count

        @info_request_count = InfoRequest.count
        @outgoing_message_count = OutgoingMessage.count
        @incoming_message_count = IncomingMessage.count

        @user_count = User.count
        @track_thing_count = TrackThing.count

        @comment_count = Comment.count
        @request_by_state = InfoRequest.count(:group => 'described_state')
        @tracks_by_type = TrackThing.count(:group => 'track_type')
    end

    def debug
        @admin_current_user = admin_current_user
        @current_commit = `git log -1 --format="%H"`
        @current_branch = `git branch | perl -ne 'print $1 if /^\\* (.*)/'`
        @current_version = `git describe --always --tags`
        repo = `git remote show origin -n | perl -ne 'print $1 if m{Fetch URL: .*github\\.com[:/](.*)\\.git}'`
        @github_origin = "https://github.com/#{repo}/tree/"
        @request_env = request.env
    end

    # TODO: Remove this when support for proxy admin interface is removed
    def admin_js
      render :layout => false, :content_type => "application/javascript"
    end
end