Nap York QR Check-in Automation

This Python script provides a simple web interface (using Gradio) to automate the guest check-in information process from Mews. It reads guest data and room access codes from CSV files, generates a personalized HTML page with essential check-in details for a specific guest, uploads this page to a web server, and generates a QR code linking directly to that guest's unique page.

*Operator View (Gradio Interface)*

*Client View (Personalized HTML Page)*

Features

Data Sync and Cleaning Script (pull_reports.py)

• Automated Report Retrieval: Uses Selenium to log into the Mews system and navigate to the "Guests in house" report.
• Date Filtering: Configures the report dates for the current day's guests.
• Report Export: Triggers the export/download of the report from Mews.
• Data Cleaning & Structuring: Reads the downloaded Excel report (Sheet 2) using pandas, restructuring rows to ensure each guest has all relevant details on a single row.
• Date Extraction: Parses check-in and check-out dates from a specific column (currently assumes they are embedded within the 'Companions' column string).
• CSV Output: Saves the cleaned and formatted data to a CSV file (cleaned_guest_list.csv), which serves as the input for the QR Check-in App.

QR Check-in Web Application (app.py)

• Gradio Web Interface: Provides an intuitive, browser-based interface for staff to trigger the process.
• Guest Data Integration: Reads the cleaned_guest_list.csv file using pandas.
• Current Guest Identification: Logic to find the currently checked-in guest for a specific bed number, handling potential overlaps based on dates.
• Personalized HTML Page Generation: Dynamically creates a web page for each guest containing their name, room number, room access code, bed/locker number, and checkout date. (The HTML template is embedded within the script).
• Secure File Transfer: Uploads the generated HTML page to a remote web server via SFTP (using paramiko).
• Local File Copy: Also copies the generated HTML to a local web server directory (e.g., /var/www/html).
• QR Code Generation: Creates a scannable QR code image linking to the guest's specific online check-in page. Includes error handling to generate a default QR even if guest lookup or balance check fails.
• Balance Alert: Notifies the user (via a UI message and a system sound) and customizes the QR link if the guest has an outstanding balance above $1.
• Activity Logging: Records each successful QR code generation event in a log file with timestamp, URL, bed number, and guest name. Logs errors as well.
• Integrated Wi-Fi Info: Includes a static QR code for the Nap York Wi-Fi within the interface.
• Basic Authentication: Protects the Gradio web interface with a simple username and password login.

Prerequisites

• Python 3.10 installed.
• The Python libraries listed in the Dependencies section.
• A Mews account with access to the "Guests in house" report.
• A Chrome browser installed on the machine running the pull_reports.py script.
• A web server configured to serve static files (e.g., Nginx, Apache). The pull_reports.py script is configured to copy files to a local web root (like /var/www/html) and upload via SFTP to a remote server.
• SFTP access credentials (host, port, username, password, target directory) for the server hosting the public domain used in the QR code links (e.g., napyorkguest.com).
• Appropriate directory structure on the server running the scripts and the target web server.

Dependencies

Install the necessary libraries using pip:

pip install gradio pandas qrcode pillow paramiko pytz selenium webdriver-manager openpyxl requests beautifulsoup4

How to Use

The Gradio application will start, and its local URL (e.g., http://127.0.0.1:7860) and URL will be displayed in the console output.

1. Access the Web UI: Open a web browser and go to the URL provided by Gradio.
2. Authenticate: Enter the configured username and password when prompted by the browser's basic authentication dialog.
3. Enter Bed Number: In the web interface, type the guest's bed number (e.g., 201-1) into the "Enter Room & Bed Number" textbox.
4. Submit: Click the "submit" button.
5. View Results:
   • The script will process the request, look up the guest, check their balance, generate the HTML, copy/upload it, and create the QR code.
   • If the guest has a balance over $1, an audible bell will sound from the server terminal, and an error message "Please take care of balance" will appear in the web interface outputs.
   • If successful and the balance is acceptable, the generated QR code image, the public URL linking to the guest's check-in page, and the guest's name will be displayed in the output section of the web page.
6. Share Information: Staff can show the displayed QR code for the guest to scan with their smartphone, or provide them with the generated QR link directly.
7. Review Logs: The activity_logs.txt file will be updated with a record of the QR code generation event, including the timestamp, URL, bed number, and guest name.

Licensing

This software is proprietary and not open source. It is provided under a commercial license.

Any use, modification, or distribution of this code requires obtaining a valid commercial license directly from Dre Dyson.

If you are interested in using this software, please contact Dre Dyson to inquire about licensing terms and costs.