We are a small bridge club in Madrid. We play duplicate bridge every evening and we would like to have a data entry system that allows to collect payments electronically. We do not want a payment system. We would like to work with our "own currency".
We would like to have a member NFC card where we can "load" our fake currency or credit for the member to pay their playing fee. The SW should read via NFC the card and mark the player in a list as a "paid player". The idea is to have a NFC reader easily available for the player to wipe his card and get the thing done without any other action. It should also permit not member to to pay the old fashion way ( in cash ) and also enter the list as a "paid player".
The SW ( ideally a python app) should provide information about how may players have already paid during the process ( showing everything on teh screen), and also at the end.
A typical use case would be :
1) User launches the app and creates a "game", giving a name and a type.
2) The app offers autocomplete search bar with the know ( members / frequent players ) of the club, and the user can add them to a list and mark them as paid or not paid.
2.1 ) If a player swipes his member NFC card and has credit in it, is added to the list for the current open game and marked as paid.
2.2 ) if the player has no credir or no card, he will have to pay cash and will be added to the list manually.
3) Once all the player are added ( paid ) user will "finish the game" and access some metrics as:
* number of users. This metric should be shown during all the process on teh screen in a separate box.
* amount paid
Additionally, the user should be able to create different game types. A game type defines amount to be played, game type name. There shuld be at least two different prices ( for member or not members ) that te Sw must keep track of.
Our database currently contains only members, but it should be upgraded with non member also. It is an excel file. We also need that the new app be able to register, modify, delete..etc players from the database in a simple graphic mode.
Finally, we don`t want to pay any proprietary fees such as oracle or any cloud service fees. The app should run locally on windows and should be open like a normal app.