module Carnival
  class QueryService
    
    attr_accessor :total_records
    def initialize(model, presenter, query_form)
      @model = model
      @presenter = presenter
      @query_form = query_form
      @total_records = 0
      @should_include_relation = !@model.is_a?(ActiveRecord::Relation)
    end

    def get_query
      records = records_without_pagination
      records = page_query(records)
    end

    def records_without_pagination_and_scope
      records = @model
      records = date_period_query(records)
      records = search_query(records)
      records = advanced_search_query(records)
      records = order_query(records)
      records = includes_relations(records)
    end

    def records_without_pagination
      records = records_without_pagination_and_scope
      records = scope_query(records)
    end

    def total_records
      records_without_pagination.size 
    end

    def scopes_number
      records = records_without_pagination_and_scope 
      scopes = {}
      @presenter.scopes.each do |key, index|
        rec = records
        scopes[key] = scope_query(rec, key).size
      end
      scopes
    end

    def scope_query(records, scope = @query_form.scope)
      if(scope.present? && scope.to_sym != :all)
        records = records.send(scope)
      end
      records
    end

    def date_period_query(records)
      date_filter_field = @presenter.date_filter_field
      if(date_filter_field.present? && @query_form.date_period_from.present? && @query_form.date_period_from != "" && @query_form.date_period_to.present? && @query_form.date_period_to != "")
        records = records.where("#{@presenter.table_name}.#{date_filter_field.name} between ? and ?", "#{@query_form.date_period_from} 00:00:00", "#{@query_form.date_period_to} 23:59:59")
      end
      records
    end

    def search_query(records)
      filtros = []
      if @query_form.search_term.present? and @presenter.searchable_fields.size > 0
        @presenter.searchable_fields.each do |key, field|
          filtros << "#{key.to_s} like :search"
        end
        records = includes_relations(records) if @should_include_relation
        records = records.where(filtros.join(" or "), search: "%#{@query_form.search_term}%")
      end
      records
    end

    def advanced_search_query(records)
      return records if !@query_form.advanced_search.present?
      @presenter.parse_advanced_search(records, @query_form.advanced_search)
    end

    def page_query(records)
        records = records.paginate(page: @query_form.page, per_page: @presenter.items_per_page)
    end

    def order_query(records)
      records.order("#{sort_column} #{sort_direction}")
    end

    def includes_relations(records)
      if @should_include_relation
        @presenter.join_tables.each do |relation_name|
          records = records.includes(relation_name)
        end
      end
      records
    end

    def sort_column
      column = @query_form.sort_column
      sorter = Carnival::GenericDatatable::ColumnSorterCreator.create_sorter(@presenter, column)
      sorter.build_sort_string
    end

    def sort_direction
      @query_form.sort_direction
    end

  end
end