from datetime import datetime
from extensions import db

class Invoice(db.Model):
    id = db.Column(db.Integer, primary_key=True)

    client_id = db.Column(db.Integer, db.ForeignKey("client.id"))
    client = db.relationship("Client", backref="invoices")

    quote_id = db.Column(db.Integer, db.ForeignKey("quote.id"))
    quote = db.relationship("Quote", backref="invoices")

    status = db.Column(db.String(20), default="unpaid")

    total = db.Column(db.Numeric(10,2), default=0)
    amount_paid = db.Column(db.Numeric(10,2), default=0)

    created_at = db.Column(db.DateTime, default=datetime.utcnow)

class InvoiceLine(db.Model):
    id = db.Column(db.Integer, primary_key=True)

    invoice_id = db.Column(db.Integer, db.ForeignKey("invoice.id"))
    invoice = db.relationship("Invoice", backref="lines")

    description = db.Column(db.String(255))
    qty = db.Column(db.Numeric(10,2))
    unit_price = db.Column(db.Numeric(10,2))