-
Notifications
You must be signed in to change notification settings - Fork 9
/
Copy pathadmin_menu.py
157 lines (142 loc) · 5.69 KB
/
admin_menu.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
__author__ = 'user'
from connection import con,cur
import database_admin as db_admin
def print_closed_acc_history():
res = db_admin.get_closed_accounts()
print("Account No \t\t\t Closed On")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t ",res[i][1].strftime("%d-%b-%Y"))
def print_fd_report():
try:
cus_id = int(input("\nEnter customer ID : "))
except:
print("Invalid ID")
return
if db_admin.check_customer_exists(cus_id) is True:
res = db_admin.get_fd_report(cus_id)
if len(res) == 0:
print("N.A.")
else:
print("Account No \t\t\t\t Amount \t\t\t\t Deposit Term")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t ",res[i][1]," \t\t\t\t ",res[i][2])
else:
print("Customer Doesn't exist")
def print_fd_report_vis_customer():
try:
cus_id = int(input("\nEnter customer ID : "))
except:
print("Invalid ID")
return
if db_admin.check_customer_exists(cus_id) is True:
if db_admin.get_fd_count(cus_id) > 0:
res = db_admin.get_fd_report_vis_customer(cus_id)
if len(res) == 0:
print("N.A.")
else:
print("Customer ID \t\t\t\t Account No \t\t\t\t Amount \t\t\t\t Deposit Term")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t\t ",res[i][1]," \t\t\t\t\t ",res[i][2]," \t\t\t\t\t ",res[i][3])
else:
print("Customer doesn't have any FD Account")
else:
print("Customer Doesn't exist")
def print_fd_report_wrt_amount():
try:
amount = int(input("\nEnter an amount (in multiples of 1000) : "))
except:
print("Invalid Amount")
return
if amount > 0 and amount%1000 == 0 :
res = db_admin.get_fd_report_wrt_amount(amount)
if len(res) == 0:
print("N.A.")
else:
print("Customer ID \t\t\t\t Account No \t\t\t\t Amount \t\t\t\t Deposit Term")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t\t ",res[i][1]," \t\t\t\t\t ",res[i][2]," \t\t\t\t\t ",res[i][3])
else:
print("Sorry ! Invalid Amount")
def print_loan_report():
try:
cus_id = int(input("\nEnter customer ID : "))
except:
print("Invalid ID")
return
if db_admin.check_customer_exists(cus_id) is True:
res = db_admin.get_loan_report(cus_id)
if len(res) == 0:
print("Not Availed")
else:
print("Account No \t\t\t\t Amount \t\t\t\t Repayment Term")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t ",res[i][1]," \t\t\t\t ",res[i][2])
else:
print("Customer Doesn't exist")
def print_loan_report_vis_customer():
try:
cus_id = int(input("\nEnter customer ID : "))
except:
print("Invalid ID")
return
if db_admin.check_customer_exists(cus_id) is True:
if db_admin.get_loan_count(cus_id) > 0:
res = db_admin.get_loan_report_vis_customer(cus_id)
if len(res) == 0:
print("N.A.")
else:
print("Customer ID \t\t\t\t Account No \t\t\t\t Amount \t\t\t\t Repayment Term")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t\t ",res[i][1]," \t\t\t\t\t ",res[i][2]," \t\t\t\t\t ",res[i][3])
else:
print("Customer hasn't availed any loan")
else:
print("Customer Doesn't exist")
def print_loan_report_wrt_amount():
try:
amount = int(input("\nEnter an amount (in multiples of 1000) : "))
except:
print("Invalid Amount")
return
if amount > 0 and amount%1000 == 0 :
res = db_admin.get_loan_report_wrt_amount(amount)
if len(res) == 0:
print("N.A.")
else:
print("Customer ID \t\t\t\t First Name \t\t\t\t Last Name \t\t\t\t Loan Amount")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t\t ",res[i][1]," \t\t\t\t\t ",res[i][2]," \t\t\t\t\t ",res[i][3])
else:
print("Sorry ! Invalid Amount")
def print_loan_fd_report():
res = db_admin.get_loan_fd_report()
if len(res) == 0:
print("N.A.")
else:
print("Customer ID \t\t\t\t First Name \t\t\t\t Last Name \t\t\t\t Sum of Loan Amounts \t\t\t\t Sum of FD Amounts")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t\t ",res[i][1]," \t\t\t\t\t ",res[i][2]," \t\t\t\t\t ",res[i][3], " \t\t\t\t\t ",res[i][4])
def print_report_no_loan():
res = db_admin.get_report_no_loan()
if len(res) == 0:
print("N.A.")
else:
print("Customer ID \t\t\t\t First Name \t\t\t\t Last Name ")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t\t ",res[i][1]," \t\t\t\t\t ",res[i][2])
def print_report_no_fd():
res = db_admin.get_report_no_fd()
if len(res) == 0:
print("N.A.")
else:
print("Customer ID \t\t\t\t First Name \t\t\t\t Last Name ")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t\t ",res[i][1]," \t\t\t\t\t ",res[i][2])
def print_report_no_fd_loan():
res = db_admin.get_report_no_fd_loan()
if len(res) == 0:
print("N.A.")
else:
print("Customer ID \t\t\t\t First Name \t\t\t\t Last Name ")
for i in range(0,len(res)):
print(res[i][0]," \t\t\t\t\t\t ",res[i][1]," \t\t\t\t\t ",res[i][2])