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