class Booking(db.Model):
id = db.Column(db.Integer, primary_key=True)
service_name = db.Column(db.String(length=100), nullable=True)
start = db.Column(db.String(length=200))
branch_id = db.Column(db.Integer)
ticket = db.Column(db.String(length=6), nullable=False)
date_added = db.Column(db.DateTime, default=datetime.now)
active = db.Column(db.Boolean, default=False, nullable=False)
nxt = db.Column(db.Integer, nullable=False)
serviced = db.Column(db.Boolean, nullable=False, default=False)
teller = db.Column(db.String(200), nullable=False, default=000000)
kind = db.Column(db.Integer, nullable=False)
user = db.Column(db.Integer)
is_instant = db.Column(db.Boolean, default=False)
def __init__(self, service_name, start, branch_id, ticket, active, nxt,
serviced, teller, kind, user, instant):
self.service_name = service_name
self.start = start
self.branch_id = branch_id
self.ticket = ticket
self.active = active
self.nxt = 1001
self.serviced = serviced
self.teller = teller
self.kind = kind
self.user = user
self.is_instant = instant
class Service(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(length=50))
service = db.Column(db.String(length=250))
is_medical = db.Column(db.Boolean, default=False)
def __init__(self, name, service, is_medical):
self.name = name
self.service = service
self.is_medical = is_medical
class Company(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(length=50))
service = db.Column(db.String(length=250))
def __init__(self, name, service):
self.name = name
self.service = service
def __repr__(self):
return f"Company {self.name} -> {self.service}"
class Help(db.Model):
id = db.Column(db.Integer, primary_key=True)
topic = db.Column(db.String(length=100), nullable=False)
title = db.Column(db.String(length=250), nullable=False)
solution = db.Column(db.Text, nullable=False)
date_added = db.Column(db.DateTime, default=datetime.now, nullable=False)
def __init__(self, topic, title, solution):
self.topic = topic
self.title = title
self.solution = solution
class Branch(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(length=100), unique=True)
company = db.Column(db.String(length=100),
db.ForeignKey("company.name"),
nullable=False)
longitude = db.Column(db.String(length=50))
latitude = db.Column(db.String(length=50))
opens = db.Column(db.String(length=50))
closes = db.Column(db.String(length=50))
service = db.Column(db.String(length=100), db.ForeignKey("service.name"))
description = db.Column(db.String(length=50))
key_ = db.Column(db.Text)
valid_till = db.Column(db.DateTime)
def __init__(self, name, company, longitude, latitude, opens, closes,
service, description, key_):
self.name = name
self.company = company
self.longitude = longitude
self.latitude = latitude
self.opens = opens
self.closes = closes
self.service = service
self.description = description
self.key_ = key_
class Customer(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(48), unique=True, nullable=False)
phoneNumber = db.Column(db.String(12), unique=True, nullable=False)
image_file = db.Column(db.String(200),
nullable=False,
default="default.jpg")
password = db.Column(db.String(200), nullable=False)
def __repr__(self):
return f"User (' {self.id} '{self.email}' )"
def __init__(self, email, password, phone_number):
self.email = email
self.password = password
self.phoneNumber = phone_number
class ServiceOffered(db.Model):
id = db.Column(db.Integer, primary_key=True)
branch_id = db.Column(db.Integer, nullable=False)
name = db.Column(db.String(length=50))
teller = db.Column(db.String(100), nullable=True)
date_added = db.Column(db.DateTime, default=datetime.now)
# date_expires = db.Column(db.DateTime, nullable=False)
code = db.Column(db.String(length=10), nullable=False)
icon = db.Column(db.String(length=20))
def __init__(self, name, branch_id, teller, code, icon):
self.name = name
self.branch_id = branch_id
self.teller = teller
self.code = code
self.icon = icon
class Payments(db.Model):
id = db.Column(db.Integer, primary_key=True, nullable=False)
body = db.Column(db.Text, nullable=False)
token = db.Column(db.String(length=255))
def __init__(self, body, token):
self.body = body
self.token = token
class Teller(db.Model):
id = db.Column(db.Integer, primary_key=True)
number = db.Column(db.Integer, nullable=False, unique=True)
date_added = db.Column(db.DateTime, default=datetime.now)
branch = db.Column(db.Integer)
service = db.Column(db.String(200))
def __init__(self, number, branch, service):
self.number = number
self.branch = branch
self.service = service
class Mpesa(db.Model):
id = db.Column(db.Integer, primary_key=True)
amount = db.Column(db.Float, nullable=True)
receipt_number = db.Column(db.String(255), nullable=True)
transaction_date = db.Column(db.String(255), nullable=True)
phone_number = db.Column(db.String(255), nullable=True)
checkout_request_id = db.Column(db.String(255), nullable=True)
merchant_request_id = db.Column(db.String(255), nullable=True)
result_code = db.Column(db.Integer, nullable=False)
result_desc = db.Column(db.Text, nullable=True)
date_added = db.Column(db.DateTime(), default=datetime.now)
local_transactional_key = db.Column(db.String(255), nullable=False)
def __init__(self, MerchantRequestID, CheckoutRequestID, ResultCode,
ResultDesc):
self.merchant_request_id = MerchantRequestID
self.checkout_request_id = CheckoutRequestID
self.result_code = ResultCode
self.result_desc = ResultDesc