示例#1
0
def print_statement(id):
    try:
        acc_no = int(input("Enter your account No\n"))
    except:
        print("Invalid Account No")
        return
    account = database.get_all_info_account(acc_no,id,"statement")
    if account is not None:
        print("Enter Dates in format (day-Mon-Year) ")
        date_from = input("Date From : ")
        date_to = input("\nDate To : ")
        if validate.validate_date(date_from,date_to) == True:
            res = database.get_transactions_account(acc_no,date_from,date_to)
            print("Date \t\t\t Transaction Type \t\t\t Amount \t\t\t Balance \t")
            for i in range(0,len(res)):
                print(res[i][0].strftime("%d-%b-%Y")," \t\t\t ",res[i][1]," \t\t\t ",res[i][2]," \t\t\t ",res[i][3])
        else:
            print("Please Enter Valid Dates")
 def print_statement(self):
     try:
         acc_no = int(input("Enter your account No\n"))
     except:
         print("Invalid Account No")
         return
     account = database.get_all_info_account(acc_no, self.id, "statement")
     if account is not None:
         print("Enter Dates in format (Year-Mon-Day) ")
         date_from = input("Date From : ")
         date_to = input("Date To : ")
         if validate.validate_date(date_from, date_to):
             res = database.get_transactions_account(
                 acc_no, date_from, date_to)
             print(
                 tabulate(res,
                          headers=[
                              "Date", "Transaction Type", "Amount",
                              "Balance", "Account Type"
                          ],
                          tablefmt="pretty"))
         else:
             print("Please Enter Valid Dates")