class Order(db.Model):
id = db.Column(db.Integer, primary_key=True)
status = db.Column(db.String(50))
created = db.Column(db.DateTime)
description = db.Column(db.Text())
def __init__(self, status, description, created=None):
self.status = status
if created is None:
created = datetime.utcnow()
self.created = created
self.description = description
def __repr__(self):
return '<Order %r>' % self.id
class Client(db.Model):
id = db.Column(db.Integer, primary_key=True)
order_id = db.Column(db.Integer, db.ForeignKey('order.id'))
order = db.relationship('Order',
backref=db.backref('clients', lazy='dynamic'))
client_name = db.Column(db.String(50))
address = db.Column(db.Text())
client_type = db.Column(db.String(50))
def __init__(self, client_name, address, client_type, order, order_id):
self.client_name = client_name
self.address = address
self.client_type = client_type
self.order_id = order_id
self.order = order
def __repr__(self):
return '<Client %r>' % self.client_name
class Ticket(db.Model):
id = db.Column(db.Integer, primary_key=True)
order_id = db.Column(db.Integer, db.ForeignKey('order.id'))
order = db.relationship('Order',
backref=db.backref('tickets', lazy='dynamic'))
status = db.Column(db.String(50))
created = db.Column(db.DateTime)
description = db.Column(db.Text())
def __init__(self, status, description, order, order_id, created=None):
self.status = status
if created is None:
created = datetime.utcnow()
self.created = created
self.description = description
self.order_id = order_id
self.order = order
class Task(db.Model):
id = db.Column(db.Integer, primary_key=True)
ticket_id = db.Column(db.Integer, db.ForeignKey('ticket.id'))
ticket = db.relationship('Ticket',
backref=db.backref('tasks', lazy='dynamic'))
task_type = db.Column(db.String(80))
assignee = db.Column(db.String(80))
sequence_order = db.Column(db.Integer)
created = db.Column(db.DateTime)
def __init__(self,
task_type,
assignee,
sequence_order,
ticket,
ticket_id,
created=None):
self.task_type = task_type
self.assignee = assignee
self.sequence_order = sequence_order
self.ticket_id = ticket_id
self.ticket = ticket
if created is None:
created = datetime.utcnow()
self.created = created
def __repr__(self):
return '<Task %r>' % self.task_type
class OrderComment(db.Model):
id = db.Column(db.Integer, primary_key=True)
order_id = db.Column(db.Integer, db.ForeignKey('order.id'))
order = db.relationship('Order',
backref=db.backref('orderComments',
lazy='dynamic'))
details = db.Column(db.String(150))
created = db.Column(db.DateTime)
reporter = db.Column(db.String(80))
def __init__(self, details, created, reporter, order, order_id):
self.details = details
if created is None:
created = datetime.utcnow()
self.created = created
self.reporter = reporter
self.order_id = order_id
self.order = order
def __repr__(self):
return '<Order Comment %r>' % self.client_name
class Garment(db.Model):
id = db.Column(db.Integer, primary_key=True)
ticket_id = db.Column(db.Integer, db.ForeignKey('ticket.id'))
ticket = db.relationship('Ticket',
backref=db.backref('garments', lazy='dynamic'))
style = db.Column(db.String(50))
color = db.Column(db.String(50))
size = db.Column(db.String(50))
quantity = db.Column(db.Integer)
def __init__(self, style, color, size, quantity, ticket, ticket_id):
self.style = style
self.color = color
self.size = size
self.quantity = quantity
self.ticket_id = ticket_id
self.ticket = ticket
def __repr__(self):
return '<Garment %r>' % self.style