from flask import Flask, render_template, request, redirect, url_for
from flask_sqlalchemy import SQLAlchemy
 
# Database configuration (replace with your credentials)
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///tickets.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False  # Disable modification tracking for performance
 
db = SQLAlchemy(app)
 
# Ticket model with essential fields and relationships (optional)
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    password_hash = db.Column(db.String(128), nullable=False)
    tickets = db.relationship('Ticket', backref='submitter')  # One-to-Many relationship with Ticket
 
class Ticket(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)
    description = db.Column(db.Text, nullable=False)
    category = db.Column(db.String(50), nullable=False)
    status = db.Column(db.String(20), nullable=False, default='Open')
    submitter_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    comments = db.relationship('Comment', backref='ticket')  # One-to-Many relationship with Comment
 
class Comment(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    content = db.Column(db.Text, nullable=False)
    author = db.Column(db.String(80), nullable=False)  # Consider using User relationship for author identification
    ticket_id = db.Column(db.Integer, db.ForeignKey('ticket.id'), nullable=False)
 
# User registration and login functionality (basic implementation, consider using libraries like Flask-WTF for form validation and security)
@app.route('/register', methods=['GET', 'POST'])
def register():
    if request.method == 'POST':
        username = request.form['username']
        email = request.form['email']
        password = request.form['password']  # Implement secure password hashing and storage
 
        # Add user to database (replace with actual registration logic)
        new_user = User(username=username, email=email, password_hash=password)
        db.session.add(new_user)
        db.session.commit()
 
        return redirect(url_for('login'))
    return render_template('register.html')
 
@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        username = request.form['username']
        password = request.form['password']
 
        # Validate user credentials (replace with actual login logic, consider using Flask-Login for session management)
        user = User.query.filter_by(username=username).first()
        if user and check_password(password, user.password_hash):  # Implement secure password check
            return redirect(url_for('home'))
        else:
            flash('Invalid username or password', 'error')
    return render_template('login.html')
 
# Routes for core ticketing functionalities
@app.route("/")
def home():
    return render_template("index.html")
 
@app.route("/submit_ticket", methods=["POST"])
def submit_ticket():
    title = request.form["title"]
    description = request.form["description"]
    category = request.form["category"]
 
    # Create a new ticket object and store it in the database
    new_ticket = Ticket(title=title, description=description, category=category)
    db.session.add(new_ticket)
    db.session.commit()
 
    return "Ticket submitted successfully!"
 
@app.route("/tickets")
def view_tickets():
    tickets = Ticket.query.all()  # Retrieve all tickets from database
    return render_template("tickets.html", tickets=tickets)
 
@app.route("/ticket/<int:ticket_id
 

ZnJvbSBmbGFzayBpbXBvcnQgRmxhc2ssIHJlbmRlcl90ZW1wbGF0ZSwgcmVxdWVzdCwgcmVkaXJlY3QsIHVybF9mb3IKZnJvbSBmbGFza19zcWxhbGNoZW15IGltcG9ydCBTUUxBbGNoZW15CgojIERhdGFiYXNlIGNvbmZpZ3VyYXRpb24gKHJlcGxhY2Ugd2l0aCB5b3VyIGNyZWRlbnRpYWxzKQphcHAgPSBGbGFzayhfX25hbWVfXykKYXBwLmNvbmZpZ1snU1FMQUxDSEVNWV9EQVRBQkFTRV9VUkknXSA9ICdzcWxpdGU6Ly8vdGlja2V0cy5kYicKYXBwLmNvbmZpZ1snU1FMQUxDSEVNWV9UUkFDS19NT0RJRklDQVRJT05TJ10gPSBGYWxzZSAgIyBEaXNhYmxlIG1vZGlmaWNhdGlvbiB0cmFja2luZyBmb3IgcGVyZm9ybWFuY2UKCmRiID0gU1FMQWxjaGVteShhcHApCgojIFRpY2tldCBtb2RlbCB3aXRoIGVzc2VudGlhbCBmaWVsZHMgYW5kIHJlbGF0aW9uc2hpcHMgKG9wdGlvbmFsKQpjbGFzcyBVc2VyKGRiLk1vZGVsKToKICAgIGlkID0gZGIuQ29sdW1uKGRiLkludGVnZXIsIHByaW1hcnlfa2V5PVRydWUpCiAgICB1c2VybmFtZSA9IGRiLkNvbHVtbihkYi5TdHJpbmcoODApLCB1bmlxdWU9VHJ1ZSwgbnVsbGFibGU9RmFsc2UpCiAgICBlbWFpbCA9IGRiLkNvbHVtbihkYi5TdHJpbmcoMTIwKSwgdW5pcXVlPVRydWUsIG51bGxhYmxlPUZhbHNlKQogICAgcGFzc3dvcmRfaGFzaCA9IGRiLkNvbHVtbihkYi5TdHJpbmcoMTI4KSwgbnVsbGFibGU9RmFsc2UpCiAgICB0aWNrZXRzID0gZGIucmVsYXRpb25zaGlwKCdUaWNrZXQnLCBiYWNrcmVmPSdzdWJtaXR0ZXInKSAgIyBPbmUtdG8tTWFueSByZWxhdGlvbnNoaXAgd2l0aCBUaWNrZXQKCmNsYXNzIFRpY2tldChkYi5Nb2RlbCk6CiAgICBpZCA9IGRiLkNvbHVtbihkYi5JbnRlZ2VyLCBwcmltYXJ5X2tleT1UcnVlKQogICAgdGl0bGUgPSBkYi5Db2x1bW4oZGIuU3RyaW5nKDgwKSwgbnVsbGFibGU9RmFsc2UpCiAgICBkZXNjcmlwdGlvbiA9IGRiLkNvbHVtbihkYi5UZXh0LCBudWxsYWJsZT1GYWxzZSkKICAgIGNhdGVnb3J5ID0gZGIuQ29sdW1uKGRiLlN0cmluZyg1MCksIG51bGxhYmxlPUZhbHNlKQogICAgc3RhdHVzID0gZGIuQ29sdW1uKGRiLlN0cmluZygyMCksIG51bGxhYmxlPUZhbHNlLCBkZWZhdWx0PSdPcGVuJykKICAgIHN1Ym1pdHRlcl9pZCA9IGRiLkNvbHVtbihkYi5JbnRlZ2VyLCBkYi5Gb3JlaWduS2V5KCd1c2VyLmlkJyksIG51bGxhYmxlPUZhbHNlKQogICAgY29tbWVudHMgPSBkYi5yZWxhdGlvbnNoaXAoJ0NvbW1lbnQnLCBiYWNrcmVmPSd0aWNrZXQnKSAgIyBPbmUtdG8tTWFueSByZWxhdGlvbnNoaXAgd2l0aCBDb21tZW50CgpjbGFzcyBDb21tZW50KGRiLk1vZGVsKToKICAgIGlkID0gZGIuQ29sdW1uKGRiLkludGVnZXIsIHByaW1hcnlfa2V5PVRydWUpCiAgICBjb250ZW50ID0gZGIuQ29sdW1uKGRiLlRleHQsIG51bGxhYmxlPUZhbHNlKQogICAgYXV0aG9yID0gZGIuQ29sdW1uKGRiLlN0cmluZyg4MCksIG51bGxhYmxlPUZhbHNlKSAgIyBDb25zaWRlciB1c2luZyBVc2VyIHJlbGF0aW9uc2hpcCBmb3IgYXV0aG9yIGlkZW50aWZpY2F0aW9uCiAgICB0aWNrZXRfaWQgPSBkYi5Db2x1bW4oZGIuSW50ZWdlciwgZGIuRm9yZWlnbktleSgndGlja2V0LmlkJyksIG51bGxhYmxlPUZhbHNlKQoKIyBVc2VyIHJlZ2lzdHJhdGlvbiBhbmQgbG9naW4gZnVuY3Rpb25hbGl0eSAoYmFzaWMgaW1wbGVtZW50YXRpb24sIGNvbnNpZGVyIHVzaW5nIGxpYnJhcmllcyBsaWtlIEZsYXNrLVdURiBmb3IgZm9ybSB2YWxpZGF0aW9uIGFuZCBzZWN1cml0eSkKQGFwcC5yb3V0ZSgnL3JlZ2lzdGVyJywgbWV0aG9kcz1bJ0dFVCcsICdQT1NUJ10pCmRlZiByZWdpc3RlcigpOgogICAgaWYgcmVxdWVzdC5tZXRob2QgPT0gJ1BPU1QnOgogICAgICAgIHVzZXJuYW1lID0gcmVxdWVzdC5mb3JtWyd1c2VybmFtZSddCiAgICAgICAgZW1haWwgPSByZXF1ZXN0LmZvcm1bJ2VtYWlsJ10KICAgICAgICBwYXNzd29yZCA9IHJlcXVlc3QuZm9ybVsncGFzc3dvcmQnXSAgIyBJbXBsZW1lbnQgc2VjdXJlIHBhc3N3b3JkIGhhc2hpbmcgYW5kIHN0b3JhZ2UKCiAgICAgICAgIyBBZGQgdXNlciB0byBkYXRhYmFzZSAocmVwbGFjZSB3aXRoIGFjdHVhbCByZWdpc3RyYXRpb24gbG9naWMpCiAgICAgICAgbmV3X3VzZXIgPSBVc2VyKHVzZXJuYW1lPXVzZXJuYW1lLCBlbWFpbD1lbWFpbCwgcGFzc3dvcmRfaGFzaD1wYXNzd29yZCkKICAgICAgICBkYi5zZXNzaW9uLmFkZChuZXdfdXNlcikKICAgICAgICBkYi5zZXNzaW9uLmNvbW1pdCgpCgogICAgICAgIHJldHVybiByZWRpcmVjdCh1cmxfZm9yKCdsb2dpbicpKQogICAgcmV0dXJuIHJlbmRlcl90ZW1wbGF0ZSgncmVnaXN0ZXIuaHRtbCcpCgpAYXBwLnJvdXRlKCcvbG9naW4nLCBtZXRob2RzPVsnR0VUJywgJ1BPU1QnXSkKZGVmIGxvZ2luKCk6CiAgICBpZiByZXF1ZXN0Lm1ldGhvZCA9PSAnUE9TVCc6CiAgICAgICAgdXNlcm5hbWUgPSByZXF1ZXN0LmZvcm1bJ3VzZXJuYW1lJ10KICAgICAgICBwYXNzd29yZCA9IHJlcXVlc3QuZm9ybVsncGFzc3dvcmQnXQoKICAgICAgICAjIFZhbGlkYXRlIHVzZXIgY3JlZGVudGlhbHMgKHJlcGxhY2Ugd2l0aCBhY3R1YWwgbG9naW4gbG9naWMsIGNvbnNpZGVyIHVzaW5nIEZsYXNrLUxvZ2luIGZvciBzZXNzaW9uIG1hbmFnZW1lbnQpCiAgICAgICAgdXNlciA9IFVzZXIucXVlcnkuZmlsdGVyX2J5KHVzZXJuYW1lPXVzZXJuYW1lKS5maXJzdCgpCiAgICAgICAgaWYgdXNlciBhbmQgY2hlY2tfcGFzc3dvcmQocGFzc3dvcmQsIHVzZXIucGFzc3dvcmRfaGFzaCk6ICAjIEltcGxlbWVudCBzZWN1cmUgcGFzc3dvcmQgY2hlY2sKICAgICAgICAgICAgcmV0dXJuIHJlZGlyZWN0KHVybF9mb3IoJ2hvbWUnKSkKICAgICAgICBlbHNlOgogICAgICAgICAgICBmbGFzaCgnSW52YWxpZCB1c2VybmFtZSBvciBwYXNzd29yZCcsICdlcnJvcicpCiAgICByZXR1cm4gcmVuZGVyX3RlbXBsYXRlKCdsb2dpbi5odG1sJykKCiMgUm91dGVzIGZvciBjb3JlIHRpY2tldGluZyBmdW5jdGlvbmFsaXRpZXMKQGFwcC5yb3V0ZSgiLyIpCmRlZiBob21lKCk6CiAgICByZXR1cm4gcmVuZGVyX3RlbXBsYXRlKCJpbmRleC5odG1sIikKCkBhcHAucm91dGUoIi9zdWJtaXRfdGlja2V0IiwgbWV0aG9kcz1bIlBPU1QiXSkKZGVmIHN1Ym1pdF90aWNrZXQoKToKICAgIHRpdGxlID0gcmVxdWVzdC5mb3JtWyJ0aXRsZSJdCiAgICBkZXNjcmlwdGlvbiA9IHJlcXVlc3QuZm9ybVsiZGVzY3JpcHRpb24iXQogICAgY2F0ZWdvcnkgPSByZXF1ZXN0LmZvcm1bImNhdGVnb3J5Il0KCiAgICAjIENyZWF0ZSBhIG5ldyB0aWNrZXQgb2JqZWN0IGFuZCBzdG9yZSBpdCBpbiB0aGUgZGF0YWJhc2UKICAgIG5ld190aWNrZXQgPSBUaWNrZXQodGl0bGU9dGl0bGUsIGRlc2NyaXB0aW9uPWRlc2NyaXB0aW9uLCBjYXRlZ29yeT1jYXRlZ29yeSkKICAgIGRiLnNlc3Npb24uYWRkKG5ld190aWNrZXQpCiAgICBkYi5zZXNzaW9uLmNvbW1pdCgpCgogICAgcmV0dXJuICJUaWNrZXQgc3VibWl0dGVkIHN1Y2Nlc3NmdWxseSEiCgpAYXBwLnJvdXRlKCIvdGlja2V0cyIpCmRlZiB2aWV3X3RpY2tldHMoKToKICAgIHRpY2tldHMgPSBUaWNrZXQucXVlcnkuYWxsKCkgICMgUmV0cmlldmUgYWxsIHRpY2tldHMgZnJvbSBkYXRhYmFzZQogICAgcmV0dXJuIHJlbmRlcl90ZW1wbGF0ZSgidGlja2V0cy5odG1sIiwgdGlja2V0cz10aWNrZXRzKQoKQGFwcC5yb3V0ZSgiL3RpY2tldC88aW50OnRpY2tldF9pZAo=