import User from 'App/Models/User';

async function getUsersFilteredByTotalRemainingDays(minDays: number) {
  const users = await User.query()
    .select('users.*') // Include user fields
    .withAggregate('vacationBalances', (query) => {
      query.sum('remainingDays').as('totalRemainingDays');
    })
    .having('totalRemainingDays', '>=', minDays) // it says that totalRemainingDays does not exist
    .orderBy('totalRemainingDays', 'desc'); // but totalRemainingDays can be used here to order

  return users;
}