import json from datetime import datetime def create_beautiful_html_from_json(json_data): """ Converts the message analytics JSON data into a beautiful HTML report """ # Parse JSON if it's a string if isinstance(json_data, str): data = json.loads(json_data) else: data = json_data # Calculate additional metrics total_attempts = data.get('total_transmissions', 0) success_rate = data.get('success_rate', 0) failure_rate = data.get('failure_rate', 0) # Build HTML html = f""" Message Analytics Report

📡 Message Analytics Report

Communication System Performance Dashboard
{data.get('success_count', 0)}
Successful Transmissions
{data.get('failure_count', 0)}
Failed Transmissions
{data.get('total_messages', 0)}
Total Messages
{total_attempts}
Total Transmissions
""" # Add message details if available if data.get('front_hauled_messages'): html += """

📨 Message Details

""" for message in data['front_hauled_messages']: # Format the message text message_text = message.get('text', '').replace('\\n', '\n') # Get message timestamp date_sent = message.get('dateSent', 'Unknown') mt_datetime = message.get('mtDateTime', 'Unknown') html += f"""
ID: {message.get('id', 'Unknown')[:8]}...
📅 {date_sent}
{message_text}
Sender: {message.get('sender', 'Unknown')[:8]}...
Conversation: {message.get('conversation', 'Unknown')[:8]}...
Channel: {message.get('sentByChannelValue', 'Unknown')}
Status: {message.get('stateValue', 'Unknown')}
""" # Add transmission status if available message_key = message.get('key', '') if message_key in data.get('successful_messages', {}) or message_key in data.get('failed_messages', {}): html += '
' # Successful devices successful_devices = data.get('successful_messages', {}).get(message_key, []) if successful_devices: html += f"""

✅ Successful Transmissions ({len(successful_devices)})

""" for device in successful_devices: html += f'{device}' html += '
' # Failed devices failed_devices = data.get('failed_messages', {}).get(message_key, []) if failed_devices: html += f"""

❌ Failed Transmissions ({len(failed_devices)})

""" for device in failed_devices: html += f'{device}' html += '
' html += '
' html += '
' html += '
' # Close HTML html += f"""
Generated on {datetime.now().strftime('%Y-%m-%d %H:%M:%S')} | Success Rate: {success_rate:.1f}% | Total Transmissions: {total_attempts}
""" return html # Example usage function def generate_transmission_report_html(json_file_path=None, json_string=None, output_file='message_report.html'): """ Generate HTML report from JSON data Args: json_file_path: Path to JSON file json_string: JSON data as string output_file: Output HTML file name """ if json_file_path: with open(json_file_path, 'r') as f: json_data = json.load(f) elif json_string: json_data = json.loads(json_string) else: # Sample data for demonstration json_data = { "success_count": 100, "failure_count": 35, "success_rate": 74.07407407407408, "failure_rate": 25.925925925925924, "total_messages": 27, "front_hauled_messages": [ { "id": "861228b0-7379-4919-9bcd-dc028a4834a7", "text": "Test message from 11 \\n 456d98ec-2162-407a-ae75-9619cd6ac356 ", "dateSent": "2025-05-23 15:11:53", "mtDateTime": "Fri May 23 15:11:52 PDT 2025", "sender": "85576b75-be28-4821-85b8-4e04bf6caf42", "conversation": "15e193b8-8456-4e92-8c2b-c875ac94f778", "parcelId": 767940816, "readDate": "null", "stateValue": "Received", "sentByChannelValue": "Radio", "userInitiatedCancel": 0, "typeValue": "Text", "uid": "null", "markerTitle": "null", "sosSessionId": "null", "casevacPreviewLatitude": None, "casevacPreviewLongitude": None, "key": "1748038313000" } ], "total_transmissions": 135, "failed_messages": { "1748038313000": [ "RFCN90ZVEXP", "R52T704P3RN", "RFCR70KP6ZP" ] }, "successful_messages": { "1748038313000": [ "23221JEGR11141", "RFCN901AZVL" ] } } html_content = create_beautiful_html_from_json(json_data) with open(output_file, 'w', encoding='utf-8') as f: f.write(html_content) print(f"HTML report generated: {output_file}") return html_content # Example usage: if __name__ == "__main__": # Generate report with sample data html_output = generate_transmission_report_html() # Or generate from JSON file: # html_output = generate_html_report(json_file_path='your_data.json') # Or generate from JSON string: # html_output = generate_html_report(json_string='{"your": "json_data"}')