fairnesscoop / permacoop

import { Repository } from 'typeorm';

import { IInvoiceRepository } from 'src/Domain/Accounting/Repository/IInvoiceRepository';

import { Invoice } from 'src/Domain/Accounting/Invoice.entity';

export class InvoiceRepository implements IInvoiceRepository {

  constructor(

    @InjectRepository(Invoice)

    private readonly repository: Repository<Invoice>

  ) {}

  public countByYear(year: number): Promise<number> {

    return this.repository

      .createQueryBuilder('billing')

      .select('billing.id')

      .where('extract(year FROM billing.createdAt) = :year', {year})

      .getCount();

  }

}