AyuntamientoMadrid/transparencia

require 'excel_importers/base'
require 'logger'

module ExcelImporters
  class Activities
    def initialize(path_to_file, period, logger = ExcelImporters::Base::NullLogger.new)
      @path_to_file = path_to_file
      @period = period
      @logger = logger
    end

    def import
      declarations = Declarations.new(@path_to_file,
                                      @period,
                                      logger: @logger,
                                      sheet_name: '1.DatosPersonales')
      pub = Public.new(@path_to_file,
                       @period,
                       logger: @logger,
                       sheet_name: '3.1PuestosDeTrabajo')
      priv = Private.new(@path_to_file,
                         @period,
                         logger: @logger,
                         sheet_name: '3.2ActividadesPrivadas')
      other = Other.new(@path_to_file,
                        @period,
                        logger: @logger,
                        sheet_name: '3.3OtrasActividades')

      ActiveRecord::Base.transaction do
        declarations.import! &&
          pub.import! &&
          priv.import! &&
          other.import!
      end
      true
    rescue => err
      @logger.error(err.message)
      false
    end

    class ActivitiesBaseImporter < ::ExcelImporters::Base
      def initialize(path_to_file, period, logger: nil, sheet_name: nil)
        super(path_to_file, logger: logger, sheet_name: sheet_name)
        @period = period
      end

      def get_declaration(person)
        person.activities_declarations.for_period(@period).first!
      end

      def import_row!(row, row_index)
        identifier = row.fetch(:identificador)
        if identifier.present?
          person = Person.find_by(personal_code: identifier)
          if person.present?
            import_person_row!(person, row)
          else
            logger.error("DATA PROBLEM!! No Person found for identifier #{identifier} at row #{row_index}")
          end
        else
          logger.error("DATA PROBLEM!! No identifier found at row #{row_index}")
        end
      end
    end

    class Declarations < ActivitiesBaseImporter
      def import_person_row!(person, row)
        declaration = person.activities_declarations.find_or_initialize_by(period: @period)
        declaration.declaration_date = row[:fecha_de_declaracion]
        declaration.save!
        logger.info(I18n.t('excel_importers.activities.declarations.imported', person: person.name, date: declaration.declaration_date))
      end
    end

    class Public < ActivitiesBaseImporter
      def import_person_row!(person, row)
        declaration = get_declaration(person)

        entity     = row[:entidad]
        position   = row[:cargo_o_categoria]
        start_date = row[:fecha_inicio]
        end_date   = row[:fecha_cese]

        declaration.add_public_activity(entity, position, start_date, end_date)
        declaration.save!

        logger.info(I18n.t('excel_importers.activities.public.imported',
                           period: @period,
                           person: person.name,
                           entity: entity,
                           position: position,
                           start_date: start_date,
                           end_date: end_date))
      end
    end

    class Private < ActivitiesBaseImporter

      def import_person_row!(person, row)
        declaration = get_declaration(person)

        kind        = row[:actividad]
        description = row[:descripcion]
        entity      = row[:entidad_colegio_profesional]
        position    = row[:cargo_o_categoria]
        start_date  = row[:fecha_inicio]
        end_date    = row[:fecha_cese]

        declaration.add_private_activity(kind, description, entity, position, start_date, end_date)
        declaration.save!

        logger.info(I18n.t('excel_importers.activities.private.imported',
                           period: @period,
                           person: person.name,
                           kind: kind,
                           entity: entity,
                           position: position,
                           start_date: start_date,
                           end_date: end_date))
      end
    end

    class Other < ActivitiesBaseImporter
      def import_person_row!(person, row)
        declaration = get_declaration(person)

        description = row[:descripcion]
        start_date  = row[:fecha_inicio]
        end_date    = row[:fecha_cese]

        declaration.add_other_activity(description, start_date, end_date)
        declaration.save!

        logger.info(I18n.t('excel_importers.activities.other.imported',
                           period: @period,
                           person: person.name,
                           start_date: start_date,
                           end_date: end_date))
      end
    end

  end
end