This complete feature gives you a production-ready QR rotation system for digital signage with analytics tracking, admin management, and easy integration with any open-source signage platform.
class QRScan(db.Model): id = db.Column(db.Integer, primary_key=True) qr_content_id = db.Column(db.Integer, db.ForeignKey('qr_content.id')) scanned_at = db.Column(db.DateTime, default=datetime.utcnow) ip_address = db.Column(db.String(45)) user_agent = db.Column(db.String(500)) open source digital signage
<!-- Embed in Xibo as HTML content --> <iframe src="http://your-server:5000/static/qr_display.html" width="1920" height="1080" frameborder="0"></iframe> Add the HTML file URL as an asset This complete feature gives you a production-ready QR
with app.app_context(): db.create_all() def generate_qr_base64(url): qr = qrcode.QRCode(version=1, box_size=10, border=4) qr.add_data(url) qr.make(fit=True) img = qr.make_image(fill_color="black", back_color="white") buffered = BytesIO() img.save(buffered, format="PNG") return base64.b64encode(buffered.getvalue()).decode() Get current active QR for display @app.route('/api/current-qr', methods=['GET']) def get_current_qr(): active_qrs = QRContent.query.filter_by(is_active=True).all() primary_key=True) qr_content_id = db.Column(db.Integer