import os
import json
import logging
from datetime import datetime
from flask import Flask, render_template, request, jsonify, send_file, flash, redirect, url_for
from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment
import tempfile
import re

# Configure logging
logging.basicConfig(level=logging.DEBUG)

app = Flask(__name__)
app.secret_key = os.environ.get("SESSION_SECRET", "your-secret-key-for-development")

# Ensure data directory exists
DATA_DIR = "data"
TICKETS_FILE = os.path.join(DATA_DIR, "tickets.json")

if not os.path.exists(DATA_DIR):
    os.makedirs(DATA_DIR)

def load_tickets():
    """Load tickets from JSON file"""
    try:
        if os.path.exists(TICKETS_FILE):
            with open(TICKETS_FILE, 'r', encoding='utf-8') as f:
                return json.load(f)
        return []
    except Exception as e:
        logging.error(f"Error loading tickets: {e}")
        return []

def save_tickets(tickets):
    """Save tickets to JSON file"""
    try:
        with open(TICKETS_FILE, 'w', encoding='utf-8') as f:
            json.dump(tickets, f, indent=2, ensure_ascii=False)
        return True
    except Exception as e:
        logging.error(f"Error saving tickets: {e}")
        return False

def validate_email(email):
    """Validate email format"""
    pattern = r'^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$'
    return re.match(pattern, email) is not None

def validate_phone(phone):
    """Validate phone number format"""
    # Allow digits, spaces, hyphens, parentheses, and plus sign
    pattern = r'^[\+\(\)\-\s\d]{7,20}$'
    return re.match(pattern, phone) is not None

@app.route('/')
def index():
    """Main page with API documentation"""
    return render_template('index.html')

@app.route('/admin')
def admin():
    """Admin dashboard to view all tickets"""
    tickets = load_tickets()
    return render_template('admin.html', tickets=tickets, total_tickets=len(tickets))

@app.route('/add_data/<email>/<phone>/<name>/<int:tickets>/<ticket_number>/<country>/<region>')
def add_ticket_data(email, phone, name, tickets, ticket_number, country, region):
    """Add ticket data via URL parameters"""
    try:
        # Validate input data
        errors = []
        
        if not validate_email(email):
            errors.append("Invalid email format")
        
        if not validate_phone(phone):
            errors.append("Invalid phone number format")
        
        if not name.strip():
            errors.append("Name cannot be empty")
        
        if tickets <= 0:
            errors.append("Number of tickets must be greater than 0")
        
        if not ticket_number.strip():
            errors.append("Ticket number cannot be empty")
        
        if not country.strip():
            errors.append("Country cannot be empty")
        
        if not region.strip():
            errors.append("Region cannot be empty")
        
        if errors:
            return jsonify({
                "success": False,
                "message": "Validation errors",
                "errors": errors
            }), 400
        
        # Create ticket record
        ticket_data = {
            "email": email.lower().strip(),
            "phone": phone.strip(),
            "name": name.strip(),
            "tickets": tickets,
            "ticket_number": ticket_number.strip(),
            "country": country.strip(),
            "region": region.strip(),
            "timestamp": datetime.now().strftime("%Y-%m-%d %H:%M:%S")
        }
        
        # Load existing tickets
        all_tickets = load_tickets()
        
        # Check for duplicate ticket numbers
        existing_ticket_numbers = [t.get('ticket_number') for t in all_tickets]
        if ticket_number in existing_ticket_numbers:
            return jsonify({
                "success": False,
                "message": "Ticket number already exists"
            }), 409
        
        # Add new ticket
        all_tickets.append(ticket_data)
        
        # Save to file
        if save_tickets(all_tickets):
            logging.info(f"New ticket added: {ticket_number} for {name}")
            return jsonify({
                "success": True,
                "message": "Ticket data added successfully",
                "ticket_id": ticket_number,
                "total_tickets": len(all_tickets)
            })
        else:
            return jsonify({
                "success": False,
                "message": "Failed to save ticket data"
            }), 500
            
    except Exception as e:
        logging.error(f"Error adding ticket data: {e}")
        return jsonify({
            "success": False,
            "message": "Internal server error"
        }), 500

@app.route('/api/tickets')
def get_tickets_api():
    """API endpoint to get all tickets"""
    tickets = load_tickets()
    return jsonify({
        "success": True,
        "tickets": tickets,
        "total": len(tickets)
    })

@app.route('/export/excel')
def export_excel():
    """Export tickets data to Excel file"""
    try:
        tickets = load_tickets()
        
        if not tickets:
            flash("No ticket data available to export", "warning")
            return redirect(url_for('admin'))
        
        # Create workbook and worksheet
        wb = Workbook()
        ws = wb.active
        ws.title = "Ticket Data"
        
        # Define headers
        headers = ['Email', 'Phone', 'Name', 'Tickets', 'Ticket Number', 'Country', 'Region', 'Timestamp']
        
        # Style for headers
        header_font = Font(bold=True, color='FFFFFF')
        header_fill = PatternFill(start_color='366092', end_color='366092', fill_type='solid')
        header_alignment = Alignment(horizontal='center', vertical='center')
        
        # Add headers
        for col, header in enumerate(headers, 1):
            cell = ws.cell(row=1, column=col, value=header)
            cell.font = header_font
            cell.fill = header_fill
            cell.alignment = header_alignment
        
        # Add data
        for row, ticket in enumerate(tickets, 2):
            ws.cell(row=row, column=1, value=ticket.get('email', ''))
            ws.cell(row=row, column=2, value=ticket.get('phone', ''))
            ws.cell(row=row, column=3, value=ticket.get('name', ''))
            ws.cell(row=row, column=4, value=ticket.get('tickets', ''))
            ws.cell(row=row, column=5, value=ticket.get('ticket_number', ''))
            ws.cell(row=row, column=6, value=ticket.get('country', ''))
            ws.cell(row=row, column=7, value=ticket.get('region', ''))
            ws.cell(row=row, column=8, value=ticket.get('timestamp', ''))
        
        # Auto-adjust column widths
        for col in ws.columns:
            max_length = 0
            column = col[0].column_letter
            for cell in col:
                try:
                    if len(str(cell.value)) > max_length:
                        max_length = len(str(cell.value))
                except:
                    pass
            adjusted_width = min(max_length + 2, 50)
            ws.column_dimensions[column].width = adjusted_width
        
        # Create temporary file
        temp_file = tempfile.NamedTemporaryFile(delete=False, suffix='.xlsx')
        wb.save(temp_file.name)
        temp_file.close()
        
        # Generate filename with timestamp
        timestamp = datetime.now().strftime("%Y%m%d_%H%M%S")
        filename = f"ticket_data_{timestamp}.xlsx"
        
        return send_file(
            temp_file.name,
            as_attachment=True,
            download_name=filename,
            mimetype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
        )
        
    except Exception as e:
        logging.error(f"Error exporting Excel: {e}")
        flash("Error exporting data to Excel", "error")
        return redirect(url_for('admin'))

@app.route('/delete_ticket/<ticket_number>', methods=['POST'])
def delete_ticket(ticket_number):
    """Delete a specific ticket"""
    try:
        tickets = load_tickets()
        original_count = len(tickets)
        
        # Filter out the ticket to delete
        tickets = [t for t in tickets if t.get('ticket_number') != ticket_number]
        
        if len(tickets) < original_count:
            if save_tickets(tickets):
                flash(f"Ticket {ticket_number} deleted successfully", "success")
            else:
                flash("Error deleting ticket", "error")
        else:
            flash("Ticket not found", "warning")
        
        return redirect(url_for('admin'))
        
    except Exception as e:
        logging.error(f"Error deleting ticket: {e}")
        flash("Error deleting ticket", "error")
        return redirect(url_for('admin'))

@app.errorhandler(404)
def not_found(error):
    return jsonify({
        "success": False,
        "message": "Endpoint not found"
    }), 404

@app.errorhandler(500)
def internal_error(error):
    return jsonify({
        "success": False,
        "message": "Internal server error"
    }), 500

if __name__ == "__main__":
    app.run(debug=True, host="0.0.0.0", port=5000)