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)