def view_details(prop_id): # view by property id for details
statement = """SELECT * FROM BaseProperty WHERE PropertyID = ?"""
property_list = []
records = Get.read_multiple(statement=statement, row_id=prop_id)
for record in records:
property_list.append(vars(BaseProperty.BaseProperty(record)))
return property_list
def overview(property_id): # Overview of unpaid bill by property
statement = """SELECT * FROM Billing WHERE PaymentDate IS NULL AND PropertyID = ?"""
unpaid_bill_list = []
records = Get.read_multiple(statement=statement, row_id=property_id)
for record in records:
bill = Billing.Billing(record)
unpaid_bill_list.append(bill.billing_amount)
return {"property_id": property_id, "total": sum(unpaid_bill_list)}
def view(statement, user_id):
request_list = []
records = Get.read_multiple(statement=statement, row_id=user_id)
for record in records:
request_list.append(vars(Request.Request(record)))
return request_list
def view(statement, row_id):
billing_list = []
records = Get.read_multiple(statement=statement, row_id=row_id)
for record in records:
billing_list.append(vars(Billing.Billing(record)))
return billing_list