150 lines
6.9 KiB
Python
150 lines
6.9 KiB
Python
from sqlalchemy import Column, Integer, String, Boolean, DateTime, Date, Numeric, ForeignKey, func, desc
|
|
from sqlalchemy.orm import relationship
|
|
from .database import Base
|
|
|
|
class Tenant(Base):
|
|
__tablename__ = "tenants"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
slug = Column(String(64), unique=True, index=True, nullable=False)
|
|
name = Column(String(150), nullable=False)
|
|
subdomain = Column(String(100), unique=True, nullable=False)
|
|
contact_email = Column(String(191), default="")
|
|
is_active = Column(Boolean, default=True)
|
|
created_at = Column(DateTime, default=func.now())
|
|
|
|
products = relationship("Product", back_populates="tenant", cascade="all, delete-orphan")
|
|
events = relationship("Event", back_populates="tenant", cascade="all, delete-orphan")
|
|
orders = relationship("Order", back_populates="tenant", cascade="all, delete-orphan")
|
|
users = relationship("User", back_populates="tenant", cascade="all, delete-orphan")
|
|
invitations = relationship("Invitation", back_populates="tenant", cascade="all, delete-orphan")
|
|
|
|
|
|
class User(Base):
|
|
__tablename__ = "users"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
tenant_id = Column(Integer, ForeignKey("tenants.id", ondelete="CASCADE"), nullable=False)
|
|
email = Column(String(191), nullable=False)
|
|
username = Column(String(100), nullable=False)
|
|
password_hash = Column(String(255), default="")
|
|
first_name = Column(String(100), nullable=False)
|
|
last_name = Column(String(100), nullable=False)
|
|
role = Column(String(20), default="user") # 'admin', 'organizer', 'user', 'guest'
|
|
balance = Column(Numeric(10, 2), default=0.00, nullable=False)
|
|
is_active = Column(Boolean, default=True)
|
|
created_at = Column(DateTime, default=func.now())
|
|
|
|
tenant = relationship("Tenant", back_populates="users")
|
|
orders = relationship("Order", back_populates="user")
|
|
transactions = relationship("BalanceTransaction", foreign_keys="BalanceTransaction.user_id", back_populates="user", order_by="desc(BalanceTransaction.created_at)")
|
|
|
|
|
|
class BalanceTransaction(Base):
|
|
__tablename__ = "balance_transactions"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
tenant_id = Column(Integer, ForeignKey("tenants.id", ondelete="CASCADE"), nullable=False)
|
|
user_id = Column(Integer, ForeignKey("users.id", ondelete="CASCADE"), nullable=False)
|
|
order_id = Column(Integer, ForeignKey("orders.id", ondelete="SET NULL"), nullable=True)
|
|
amount = Column(Numeric(10, 2), nullable=False)
|
|
transaction_type = Column(String(30), nullable=False) # 'deposit', 'order_charge', 'adjustment', 'refund'
|
|
description = Column(String(255), nullable=True)
|
|
created_by_id = Column(Integer, ForeignKey("users.id", ondelete="SET NULL"), nullable=True)
|
|
created_at = Column(DateTime, default=func.now())
|
|
|
|
tenant = relationship("Tenant")
|
|
user = relationship("User", foreign_keys=[user_id], back_populates="transactions")
|
|
order = relationship("Order")
|
|
created_by = relationship("User", foreign_keys=[created_by_id])
|
|
|
|
|
|
class Invitation(Base):
|
|
__tablename__ = "invitations"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
tenant_id = Column(Integer, ForeignKey("tenants.id", ondelete="CASCADE"), nullable=False)
|
|
token = Column(String(64), unique=True, index=True, nullable=False)
|
|
email = Column(String(191), nullable=True)
|
|
role = Column(String(20), default="user", nullable=False) # 'admin', 'organizer', 'user', 'guest'
|
|
created_by = Column(Integer, nullable=True)
|
|
expires_at = Column(DateTime, nullable=True)
|
|
used_at = Column(DateTime, nullable=True)
|
|
is_reusable = Column(Boolean, default=False, nullable=False)
|
|
created_at = Column(DateTime, default=func.now())
|
|
|
|
tenant = relationship("Tenant", back_populates="invitations")
|
|
|
|
|
|
class Product(Base):
|
|
__tablename__ = "products"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
tenant_id = Column(Integer, ForeignKey("tenants.id", ondelete="CASCADE"), nullable=False)
|
|
name = Column(String(150), nullable=False)
|
|
description = Column(String(255), default="")
|
|
price = Column(Numeric(10, 2), nullable=False, default=0.00)
|
|
unit = Column(String(50), default="Stück")
|
|
is_active = Column(Boolean, default=True)
|
|
sort_order = Column(Integer, default=0)
|
|
|
|
tenant = relationship("Tenant", back_populates="products")
|
|
|
|
|
|
class Event(Base):
|
|
__tablename__ = "events"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
tenant_id = Column(Integer, ForeignKey("tenants.id", ondelete="CASCADE"), nullable=False)
|
|
title = Column(String(150), nullable=False)
|
|
event_date = Column(Date, nullable=False)
|
|
deadline = Column(DateTime, nullable=False)
|
|
status = Column(String(20), default="open") # 'open', 'closed', 'completed'
|
|
allow_guests = Column(Boolean, default=True, nullable=False)
|
|
sponsor_name = Column(String(150), nullable=True)
|
|
guest_token = Column(String(64), nullable=True)
|
|
buyer_id = Column(Integer, ForeignKey("users.id", ondelete="SET NULL"), nullable=True)
|
|
created_at = Column(DateTime, default=func.now())
|
|
|
|
tenant = relationship("Tenant", back_populates="events")
|
|
buyer = relationship("User", foreign_keys=[buyer_id])
|
|
orders = relationship("Order", back_populates="event", cascade="all, delete-orphan")
|
|
|
|
|
|
class Order(Base):
|
|
__tablename__ = "orders"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
tenant_id = Column(Integer, ForeignKey("tenants.id", ondelete="CASCADE"), nullable=False)
|
|
event_id = Column(Integer, ForeignKey("events.id", ondelete="CASCADE"), nullable=False)
|
|
user_id = Column(Integer, ForeignKey("users.id", ondelete="SET NULL"), nullable=True)
|
|
guest_display_name = Column(String(150), nullable=True)
|
|
total_price = Column(Numeric(10, 2), nullable=False, default=0.00)
|
|
is_paid = Column(Boolean, default=False)
|
|
payment_method = Column(String(30), default="cash") # 'cash', 'balance', 'sponsored'
|
|
created_at = Column(DateTime, default=func.now())
|
|
|
|
tenant = relationship("Tenant", back_populates="orders")
|
|
event = relationship("Event", back_populates="orders")
|
|
user = relationship("User", back_populates="orders")
|
|
items = relationship("OrderItem", back_populates="order", cascade="all, delete-orphan")
|
|
|
|
@property
|
|
def display_name(self) -> str:
|
|
if self.user:
|
|
return f"{self.user.first_name} {self.user.last_name}"
|
|
return self.guest_display_name or "Gast"
|
|
|
|
|
|
class OrderItem(Base):
|
|
__tablename__ = "order_items"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
order_id = Column(Integer, ForeignKey("orders.id", ondelete="CASCADE"), nullable=False)
|
|
product_id = Column(Integer, ForeignKey("products.id", ondelete="RESTRICT"), nullable=False)
|
|
quantity = Column(Integer, default=1, nullable=False)
|
|
unit_price = Column(Numeric(10, 2), nullable=False)
|
|
|
|
order = relationship("Order", back_populates="items")
|
|
product = relationship("Product")
|