const registeree = (getCount?: boolean) => {
return tx
.select({
...(getCount ? { total: count() } : {}),
})
.from(eventHasParticipant)
.innerJoin(events, eq(eventHasParticipant.eventId, events.id))
.innerJoin(
participants,
eq(eventHasParticipant.participantId, participants.id)
)
.where(and(eq(events.id, eventID), eq(events.createdBy, createdBy)));
};
const total = await registeree(true).limit(limit).offset((page - 1) * limit);
const registereeResult = await registeree();
total[0].total = total[0].total || 0;
return { total: total[0].total, registereeResult };
const registeree = (getCount?: boolean) => {
return tx
.select({
...(getCount ? { total: count() } : {}),
})
.from(eventHasParticipant)
.innerJoin(events, eq(eventHasParticipant.eventId, events.id))
.innerJoin(
participants,
eq(eventHasParticipant.participantId, participants.id)
)
.where(and(eq(events.id, eventID), eq(events.createdBy, createdBy)));
};
const total = await registeree(true).limit(limit).offset((page - 1) * limit);
const registereeResult = await registeree();
total[0].total = total[0].total || 0;
return { total: total[0].total, registereeResult };