In need of a custom POS system for bar sales in a gentlemens club. My vision is to have some front end that is run off a small PC and touch screen monitor driven by a back end of SQL or mySQL, but since I am very proficient in SQL would prefer that.
The database structure would be pretty simple upfront and be a couple tables consisting of a list of the cateogries of liquors, the liquors carried (linked via lookup to the categories), inventory in (done through an admin module), sales out (inventory out), user logins and dancer names.
The front end would be require a user to slide an ID card or enter their user id prior to any sale. The terminal would be hardcoded to the PC which would hold the bartender responsible to the cash and sales on that terminal and cash drawer. Once a user ID and password is entered the main sales screen would pop up with a category listing of them in liquors (whiskey, Scotch. Vodka, Gin, Tequila etc) and branch out to subcategories of of individual liquors). Once a brand is tapped it would appear with the price and name of the liquor on the in the middle which would represent the tab or receipt.
On the far right would be a listing of the girls in that night that could have drink bought for them. It should be a touch responsive to the last drink entered and saved so a report can be run later to show all the drinks and total each girl had ordered each night.
An admin module would be needed to add users and permissions, add new categories, new brands, set and edit bottle proces, and add girls/dancers.
This is a start and would like to add several other modules in the future after the initial system is built and tested.
This system should be built so that the following hardware can be used:
Touch screen monitor
Cash register drawer