fairnesscoop / permacoop

import { Repository } from 'typeorm';

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

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

export class BillingRepository implements IBillingRepository {

  constructor(

    @InjectRepository(Billing)

    private readonly repository: Repository<Billing>

  ) {}

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

    return this.repository

      .createQueryBuilder('billing')

      .select('billing.id')

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

      .getCount();

  }

}