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()
Use the "Web Page" asset type pointing to your display URL Installation & Setup # 1. Clone or create files mkdir qr-signage cd qr-signage 2. Install dependencies pip install -r requirements.txt 3. Initialize database python >>> from qr_signage_api import db, app >>> with app.app_context(): ... db.create_all() >>> exit() 4. Run API server python qr_signage_api.py 5. Access endpoints: - Display: http://localhost:5000/static/qr_display.html - Admin: http://localhost:5000/static/admin_dashboard.html - API: http://localhost:5000/api/current-qr open source digital signage
CMD ["python", "qr_signage_api.py"]
return jsonify('success': True) @app.route('/api/analytics', methods=['GET']) def get_analytics(): total_scans = QRScan.query.count() qr_performance = db.session.query( QRContent.name, db.func.count(QRScan.id).label('scan_count') ).outerjoin(QRScan).group_by(QRContent.id).all() with app
last_hour = datetime.utcnow() - timedelta(hours=1) scans_last_hour = QRScan.query.filter(QRScan.scanned_at >= last_hour).count() Initialize database python >
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.
<!-- 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