QR gate entry, code generated by Rental Confirmation E-mail

[Jasen 0]

Hello. I am working on a pilot project building an automated RV park. Our goal is to have people sign in online, or in person at a kiosk. Make their reservation, payment, and get their confirmation e-mail. In that e-mail, will be a QR, or Bar Code, that when scanned at the gate opens the gate, and starts a light that flashes at the site they rented. Power will then be turned on at that site, and a timer in the process will begin, based off their rental time. Once their time has expired, the power at the site will be turned off, controlled by a PLC, and relays. 

So I am looking for help in all directions. I have some leads on some plug-ins for Wordpress that offer reservations, and other plug-ins that do Bar code production. As far as the web part I have that covered. We can generate a custom barcode, or QR code based on individual rentals and those can be sent to customers.

So what I need is someone to help point me in the right direction of equipment that can speak between the online Barcode process and the PLC to allow a process to begin when scanned. Based off their rental parameters their power is turned on or off. Perhaps a SQL query in some form? I haven't used it, but am aware of its capabilities, and this does seem like an application where it would be used. Is there anything that you have used that are tried and true? I know it's a strange request, just hoping someone bites.

Thanks in advance for any ideas, I look forward to solving this puzzle, one piece at a time. 

[BobLfoot 301]

Just one possibility.  Your WebSite and App work to populate a SQL Database with all the pertinent information including barcode.

At your rental property the check-in kiosk runs a Visual Studio Application which reads the bar code and transmits the state data to the PLC.

Basically you'll have a status array in the PLC and a data telegram passing over OPC from the VS App to the PLC.

I've done this before in Baggage Handling at Airports, Mail Routing and Order Fulfillment Centers but never in a rental property application.

Good Luck and let us know how your project goes.