Node.JS app sending/receiving MQTT messages and interface with mySQL

IMPORTANT: Read before submitting! Responses not addressing requirements will be disregarded. Background: This is a home automation product that we’re creating. We need help with writing the Node.js and basic web page that talks live between an MQTT server, a MySQL database and a web browser. The pages for the web browser have already been structured so you will use them. A basic node.js app that serves the pages has been constructed. An MQTT server is live on the internet that you will be able to use to test against. Project deliverable: 1. Using a provided html form, collect the data from the form, format the data and send a message to the MQTT server on a topic based on details provided by the form and saving the message to a MySQL database. Report back to the browser: a. success showing MQTT topic it was sent to and the message that was sent b. or failure with failure reason. The format of the topic and message will be provided to the successful tenderer however as an example the format of the topic is similar to ‘variable1/variable2/variable3/variable4 and the message will be JSON encoded similar to {“variable5Name”:”variable5Value”, “variable6Name”:”variable6Value”, “variable7Name”:”variable7Value”) A username and password (encrypted using bcrypt [login to view URL]) and provided via the form will need to be validated against the MySQL server and a failure returned if not correct. 2. A second page that provides a topic to monitor, and once username/password authenticated, display live any messages that are sent to the MQTT server for the topic requested by the user (via the form). Again, the username/password will need to be validated against the MySQL server with any error returned to the browser. No page formatting (CSS styling) is required. General coding rules: Use of else is limited to a single statement in the else block. Example: if (test) { do some things } else { do one thing only or call another function that does more than one thing if needed } Variables should describe in plain English what the variable is. Don’t abbreviate. Exception is var i or other single letter when using it as an integer counter in a for loop and is declared in the for loop. Class names start with a capital letter eg MyClass, not myClass. Function names and variables start with a lower case letter eg myFunction, not MyFunction. Avoid underscore as word separator. Functions should not have more than 12-15 lines in their body. Branch out to another function if you approach this. Max three indents per function. Example myFunction = function(variableOne, variableTwo) { for (var i=0; i<someVariable;i++) { if (test) { do things… this level is still ok, but it’s at the maximum level. if (anotherTest) { this is not ok. It should have been passed to another function one indent previously. } } } } Use four spaces for indents, not tabs. Use comments to explain what is happening so it can be understood at a later date. Copyright and licensing You can retain copyright for the work you do, however you will provide an unrestricted license to do anything we choose to do with the code you provide. To use us a reference, you need to ask first. It will not be un-reasonably refused, however we will need to know where and how you use that reference to make sure it’s not going to adversely impact on our brand. Information to include in your response: 1. How many days do you need to have it completed. Include when you will have first draft ready for testing. 2. If you have any verifiable qualifications which could include experience in place of qualification. 3. What after project support you will provide 4. What is your fee 5. Any other terms and/or conditions