Inter-Actief / alexia

Alexia is het borrelbeheersysteem voor de borrelruimtes in de Zilverling op de Universiteit Twente, de Abscint en MBasement.
https://alex.ia.utwente.nl/
BSD 3-Clause "New" or "Revised" License
8 stars 6 forks source link

Only count drinks with DCF or transactions towards "tended drinks" #108

Closed FrankvanMourik closed 1 year ago

FrankvanMourik commented 2 years ago

As Inter-Actief will use the Alexia "tended drinks" for their bartenders' appreciation policy, it would be nice to have the tended drinks as a better representation of exactly how many drinks a bartender has tended.

To have a better indication, we propose the following additional constraint on the query: only count drinks that have either a digital consumption form filled out or have at least one transaction linked with them. By taking this constraint into account, drinks like "Bartenders' outing [inventarisation]" or "TIPcie & SBZ trekken bak" will not be taken into account.

Furthermore, we believe that this would not negatively impact other associations in any way.

CasEbb commented 2 years ago

Bear in mind that this comes at the expense of the accuracy of the historical data. Consumption forms or Juliana transactions were not in use before 2012, which would mean that for former bartenders, their counter either goes down drastically or goes to zero.

This may lead to a violation of honour.

FrankvanMourik commented 2 years ago

@CasEbb your statement is taken into account by adding an OR filter on drinks before the date of the first DCF (December 13th, 2016)

CasEbb commented 2 years ago

On behalf of the oude lullen of this world, 'vo.