class Pays(dbase.Model):
__tablename__ = "pays"
paysID = dbase.Column(dbase.Integer, primary_key=True, autoincrement= True)
issued_by = dbase.Column(dbase.String(60))
reference_no = dbase.Column(dbase.String(60))
or_no = dbase.Column(dbase.String(60))
# rent = dbase.Column(dbase.Float)
sCharge = dbase.Column(dbase.Float)
month = dbase.Column(dbase.String(20))
remark = dbase.Column(dbase.String(20))
amount = dbase.Column(dbase.Float)
total = dbase.Column(dbase.Float)
date_issued =dbase.Column(dbase.DATE)
tenantID = dbase.Column(dbase.Integer,dbase.ForeignKey("tenants.tenantID"), nullable=True)
stallID = dbase.Column(dbase.Integer, dbase.ForeignKey("stalls.stallID"), nullable=True)
def __init__(self, issued_by,or_no,sCharge, tenantID, stallID,month, amount,total,date_issued, remark):
self.issued_by = issued_by
self.or_no = or_no
# self.rent = rent
self.sCharge = sCharge
self.tenantID = tenantID
self.stallID = stallID
self.month = month
self.amount = amount
self.total = total
self.date_issued = date_issued
self.remark = remark
def __repr__(self):
return '< issued_by{}>'.format(self.issued_by)
class Rents(dbase.Model):
__tablename__ = "rents"
rentID = dbase.Column(dbase.Integer, primary_key=True)
date_started = dbase.Column(dbase.DATE)
tenantID = dbase.Column(dbase.Integer,dbase.ForeignKey("tenants.tenantID"), nullable=True)
stallID = dbase.Column(dbase.Integer, dbase.ForeignKey("stalls.stallID"), nullable=True)
def __index__(self,date_started, tenantID, stallID):
self.date_started = date_started
self.tenantID = tenantID
self.stallID = stallID
def __repr__(self):
return '<date_started{}>'.format(self.date_started)
class Tenants(dbase.Model):
__tablename__ = "tenants"
tenantID = dbase.Column(dbase.Integer, primary_key= True, autoincrement=True)
contact_no = dbase.Column(dbase.String(12))
first_name = dbase.Column(dbase.String(24))
mid_name = dbase.Column(dbase.String(24))
last_name = dbase.Column(dbase.String(24))
present_addr = dbase.Column(dbase.String(60))
tenant_photo = dbase.Column(dbase.String(60))
tenant_status = dbase.Column(dbase.String(2))
stallID = dbase.Column(dbase.Integer, dbase.ForeignKey("stalls.stallID"), nullable=True)
balance = dbase.Column(dbase.Float)
def __init__(self,contact_no, first_name, mid_name, last_name, present_addr, stallID):
self.first_name = first_name
self.mid_name = mid_name
self.last_name = last_name
self.contact_no = contact_no
self.present_addr = present_addr
self.stallID = stallID
self.tenant_status = '1'
self.balance = 0.0
def __repr__(self):
return '<last_name {}>'.format(self.last_name)
class wares(dbase.Model):
__bind_key__ = 'itemPool'
__tablename__ = 'wares'
ID = dbase.Column(dbase.Integer, primary_key=True)
merchantID = dbase.Column(dbase.Integer,
dbase.ForeignKey('merchants.merchantID'),
nullable=False)
productID = dbase.Column(dbase.Integer,
dbase.ForeignKey('products.productID'),
nullable=False)
stock = dbase.Column(dbase.Integer)
price = dbase.Column(dbase.Integer)
def __init__(self, mID, pID, stock, price):
self.merchantID = mID
self.productID = pID
self.stock = stock
self.price = price
class Stalls(dbase.Model):
__tablename__ = 'stalls'
stallID = dbase.Column(dbase.Integer, primary_key=True, autoincrement= True)
stall_no = dbase.Column(dbase.Integer)
stall_rate = dbase.Column(dbase.Integer)
stall_loc = dbase.Column(dbase.String(60))
stall_status = dbase.Column(dbase.String(60))
typeID = dbase.Column(dbase.Integer, dbase.ForeignKey("types.typeID"), nullable= False)
# branchID = dbase.Column(dbase.Integer, dbase.ForeignKey("branch.branchID"), nullable=False)
t_stall_no = relationship("Tenants", backref="stallNO", lazy="dynamic" )
def __init__ (self,stall_rate, stall_loc, stall_status, stall_no, typeID):
self.stall_rate =stall_rate
self.stall_status = '0'
self.stall_loc = stall_loc
self.stall_no = stall_no
# self.branchID = branchID
self.typeID = typeID
def __repr__(self):
return '<stall_rate{}>'.format(self.stall_rate)
