there are two major goals in this project. Before listing them, it should be noted, that this would be a part of a robotic device which is going to be used only for educational purposes and is working exclusively with limited amount of bottled liquid mixing components, such as: alcohol (vodka, whisky, rum, etc) and non-alcoholic beverages (coke, tonic, juice etc.), not with ice or with any other solid substance.
Web site - Objective is to implement a dynamic web site (for example using PHP) with a graphical user interface (arbitrary, your desgin/choice) via which could user search for a drink (=cocktail from a MYSQL database, read further) and choose it (if it is available). After the order was made, request is processed and sites provides data output for Raspberry.
Database - MYSQL, component of the website. Limited size (the main up to 60 items = drinks, the secondary up to 20). Each item should contain similar attributes as listed down below at "1)". Database should work together with the site - such as LAMP ( Linux, Apache, MYSQL, and PHP) stack. Other details at "2)".
OBJECTIVES: Databases and site with user interface
1) First objective is to design and develop two databases - the main one containing list of simple alcoholic cocktails (just the most popular - according to wiki/google, not all of them of course). For each drink the database should contain: name of the mix drink/cocktail, description of the drink, specifics for user in order to search for it on webserver, individual mixing parts of which it consists, preparation order (= which part should come first, second etc.). The database should be further managable/accessible (adding another drinks etc.). This should be the main one - with all necessary information.
The other should be build the way, that besides drink name, it mainly contains the mixing parts we currently have at our disposal - in other words, barbot is physically limited and could handle only up to 15-20 mixing parts at the same time but not more. So user would be able to see information about every drink (in the main db), but could order only the ones, which mixing parts are available (= in bottles and listed in the secondary db). Every mixing part should have a specific designation in order to differentiate them and also dose them in correct order - so when user makes the choice (see goal 2) his request is processed (checking if the mixing parts are available in sec. db) and if so, the correct designation order (in form of data) is passed over and the dispensing process is able to begin (further information would be provided).
2) Second part of the project is implementing a full website (running on Apache). The website should have an user interface, that would show the cocktails listed in the main database (e.g. pictures) and their info to the user, let him search for specific one, also let him know, if the desired drink is available or not and most importantly accept the order, process it (access the databases) and send the data for mixing (Additional info, not necessary for this project: Pi also controls relays and based on the sent data it would activate some of them one after another for a period of time. Activating relays would open a solenoid valve and therefore pushing air from airpump to the bottle and dispensing liquid).
Other requirement is that site should handle collisions = if there are multiple order requests at the same time, they should be processed continuously - right after the previous order is completed.
I am deeply sorry for such an 'exhaustive' and possibly unclear description. In case of interest I would be more than happy to share all the details there are with you. There will be an option to continue working on the later phases of the project (pumping and dosing).
Thank you very much for your time.
10 фрилансеров(-а) готовы выполнить эту работу в среднем за €157
Hi! I just read your project and would like to work with you. Please send a message to discuss more regarding this project. Thanks Website with a graphical UI and MYSQL database (Apache, Raspberry project)
I am Ring. I am about 19+ years experienced in GNU/Linux based system, server installation and customization, develop, deploy, security and support. I may help you in this regard.