def admin(): # admin view pending request list statement = """SELECT * FROM Request r INNER JOIN BaseProperty bp ON bp.PropertyID = r.PropertyID WHERE bp.OwnershipID = '7EE30661-80AD-4862-966B-7279D0F80D22'""" request_list = [] records = Get.read_all(statement=statement) for record in records: request_list.append(vars(Request.Request(record))) return request_list
def overview_unpaid(): # Overview of unpaid bill statement = """SELECT * FROM Billing WHERE PaymentDate IS NULL""" unpaid_bill_list = [] records = Get.read_all(statement=statement) for record in records: bill = Billing.Billing(record) unpaid_bill_list.append(bill.billing_amount) return sum(unpaid_bill_list)
def view(statement): property_list = [] records = Get.read_all(statement=statement) for record in records: property_list.append(vars(BaseProperty.BaseProperty(record))) return property_list