Open Source Digital Signage ✓

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()

# requirements.txt Flask==2.3.0 flask-cors==4.0.0 flask-sqlalchemy==3.0.5 qrcode==7.4.2 Pillow==10.0.0 For Xibo: Use the HTML package with iframe embedding

qr_base64 = generate_qr_base64(current_qr.url)

return jsonify( 'total_scans': total_scans, 'scans_last_hour': scans_last_hour, 'qr_performance': ['name': name, 'scans': count for name, count in qr_performance] ) @app.route('/api/qr-content', methods=['POST']) def add_qr_content(): data = request.json qr = QRContent( name=data['name'], url=data['url'], description=data.get('description'), display_duration=data.get('display_duration', 30) ) db.session.add(qr) db.session.commit() return jsonify('id': qr.id, 'message': 'QR content added') open source digital signage

EXPOSE 5000

COPY requirements.txt . RUN pip install -r requirements.txt

<!-- 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 return jsonify('success': True) @app

return jsonify( 'id': current_qr.id, 'name': current_qr.name, 'url': current_qr.url, 'qr_image': qr_base64, 'description': current_qr.description, 'duration': current_qr.display_duration ) @app.route('/api/track-scan', methods=['POST']) def track_scan(): data = request.json qr_id = data.get('qr_id')

scan = QRScan( qr_content_id=qr_id, ip_address=request.remote_addr, user_agent=request.headers.get('User-Agent') ) db.session.add(scan) db.session.commit()

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 Install dependencies pip install -r requirements

last_hour = datetime.utcnow() - timedelta(hours=1) scans_last_hour = QRScan.query.filter(QRScan.scanned_at >= last_hour).count()

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))