import DataLoader from 'dataloader';
import { Injectable, Scope } from 'graphql-modules';
import { sql } from '@pgtyped/runtime';
import { TenantAwareDBClient } from '../../app-providers/tenant-db-client.js';
import type { IGetEmployeesByEmployerQuery, IGetEmployeesByIdQuery } from '../types.js';

const getEmployeesByEmployer = sql<IGetEmployeesByEmployerQuery>`
    SELECT *
    FROM accounter_schema.employees
    WHERE employer in $$employerIDs;`;

const getEmployeesById = sql<IGetEmployeesByIdQuery>`
    SELECT *
    FROM accounter_schema.employees
    WHERE business_id in $$employeeIDs;`;

@Injectable({
  scope: Scope.Operation,
  global: true,
})
export class EmployeesProvider {
  constructor(private db: TenantAwareDBClient) {}

  private async batchEmployeesByEmployerIDs(employerIDs: readonly string[]) {
    if (employerIDs.length) {
      return getEmployeesByEmployer
        .run({ employerIDs }, this.db)
        .then(res =>
          employerIDs.map(employerId => res.filter(employee => employee.employer === employerId)),
        );
    }
    return [];
  }

  public getEmployeesByEmployerLoader = new DataLoader((employerIDs: readonly string[]) =>
    this.batchEmployeesByEmployerIDs(employerIDs),
  );

  private async batchEmployeesByIDs(employeeIDs: readonly string[]) {
    if (employeeIDs.length) {
      return getEmployeesById
        .run({ employeeIDs }, this.db)
        .then(res =>
          employeeIDs.map(employeeId => res.find(employee => employee.business_id === employeeId)),
        );
    }
    return [];
  }

  public getEmployeesByIdLoader = new DataLoader((employeeIDs: readonly string[]) =>
    this.batchEmployeesByIDs(employeeIDs),
  );

  public clearCache() {
    this.getEmployeesByEmployerLoader.clearAll();
    this.getEmployeesByIdLoader.clearAll();
  }
}