Dev Bank.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Welcome to Dev Bank CRM (Customer Relation Management) System\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[34;1m ♕ Welcome to Dev Bank\n",
      "\n",
      "               \u001b[32;1m The Bank of Technical Era\n",
      "____________________________________________________________\n",
      "\n",
      "DATE:- Sunday, March 14 \t   TIME:- 18:08:33\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |      \u001b[34;1m Last Visit \u001b[31;1m Sun Mar 14 17:29:46 2021      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 1\n",
      "____________________________________________________________\n",
      "\n",
      "\t♕ User Id\t➤\t\tarman@dev\n",
      "\t♕ Key\t\t➤\t\t········\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |\u001b[34;1m Paswrd is【Wrong】as ID           \u001b[31;1m arman@dev      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 1\n",
      "____________________________________________________________\n",
      "\n",
      "\t♕ User Id\t➤\t\tarman@dev\n",
      "\t♕ Key\t\t➤\t\t········\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t3\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |    \u001b[34;1m Type 'devs' ➤             \u001b[31;1m For all      \u001b[32;1m |\n",
      "● Enter Customer ID │ dev\n",
      "************************************************************\n",
      "\n",
      "               \u001b[31;1m ✋【Unauthenticated】 Id has given ✋\n",
      "\n",
      "************************************************************\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t3\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |    \u001b[34;1m Type 'devs' ➤             \u001b[31;1m For all      \u001b[32;1m |\n",
      "● Enter Customer ID │ devs\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[35;1m ✤ Accounts Details ✤\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "          A/C_Num A/C Type         Name         DOB  UAID (Aadhar No.)  Age  \\\n",
      "Cust ID                                                                       \n",
      "dev7415  30584575   saving  Ajay sharma  2001-02-25       456123789852   19   \n",
      "\n",
      "              Phone  Status  Balance  \n",
      "Cust ID                               \n",
      "dev7415  1593572580       1     2000  \n",
      "\n",
      "➤ Want to Save this Data 【y/n】 │ n\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[36;1m ✤ Proposal Rejected ✤\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t33\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ✌ Thanks for Visit ✌ \n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m User Id ➤           \u001b[31;1m arman@dev      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |       \u001b[34;1m Leave at ➤            \u001b[31;1m 18:09:23      \u001b[32;1m |\n",
      "\n",
      "               \u001b[34;1m Sunday, March 14\n",
      "\n",
      "               \u001b[32;1m ★ Have a Good Day ★\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 1\n",
      "____________________________________________________________\n",
      "\n",
      "\t♕ User Id\t➤\t\tdev4575\n",
      "************************************************************\n",
      "\n",
      "               \u001b[31;1m ✋【Unauthenticated】 Id has given ✋\n",
      "\n",
      "************************************************************\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 1\n",
      "____________________________________________________________\n",
      "\n",
      "\t♕ User Id\t➤\t\tarman@dev\n",
      "\t♕ Key\t\t➤\t\t········\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "● Condition Chosen │ \t3\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |    \u001b[34;1m Type 'devs' ➤             \u001b[31;1m For all      \u001b[32;1m |\n",
      "● Enter Customer ID │ devs\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[35;1m ✤ Accounts Details ✤\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "          A/C_Num A/C Type         Name         DOB  UAID (Aadhar No.)  Age  \\\n",
      "Cust ID                                                                       \n",
      "dev7415  30584575   saving  Ajay sharma  2001-02-25       456123789852   19   \n",
      "\n",
      "              Phone  Status  Balance  \n",
      "Cust ID                               \n",
      "dev7415  1593572580       1     2000  \n",
      "\n",
      "➤ Want to Save this Data 【y/n】 │ 33\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[36;1m ✤ Proposal Rejected ✤\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t133\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ✌ Thanks for Visit ✌ \n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m User Id ➤           \u001b[31;1m arman@dev      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |       \u001b[34;1m Leave at ➤            \u001b[31;1m 18:09:46      \u001b[32;1m |\n",
      "\n",
      "               \u001b[34;1m Sunday, March 14\n",
      "\n",
      "               \u001b[32;1m ★ Have a Good Day ★\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 1\n",
      "____________________________________________________________\n",
      "\n",
      "\t♕ User Id\t➤\t\tdev7415\n",
      "\t♕ Key\t\t➤\t\t········\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |\u001b[34;1m Paswrd is【Wrong】as ID             \u001b[31;1m dev7415      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "➤ Do You Forget Your Password 【y/n】 │3\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[36;1m ✤ Proposal Rejected ✤\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[34;1m ♕ Welcome to Dev Bank\n",
      "\n",
      "               \u001b[32;1m The Bank of Technical Era\n",
      "____________________________________________________________\n",
      "\n",
      "DATE:- Sunday, March 14 \t   TIME:- 18:10:18\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |      \u001b[34;1m Last Visit \u001b[31;1m Sun Mar 14 18:09:22 2021      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 1\n",
      "____________________________________________________________\n",
      "\n",
      "\t♕ User Id\t➤\t\tdev4614\n",
      "************************************************************\n",
      "\n",
      "               \u001b[31;1m ✋【Unauthenticated】 Id has given ✋\n",
      "\n",
      "************************************************************\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 1\n",
      "____________________________________________________________\n",
      "\n",
      "\t♕ User Id\t➤\t\tdev7415\n",
      "\t♕ Key\t\t➤\t\t········\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |\u001b[34;1m Paswrd is【Wrong】as ID             \u001b[31;1m dev7415      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "➤ Do You Forget Your Password 【y/n】 │y\n",
      "\n",
      "               \u001b[35;1m ❖ Validation Started ❖\n",
      "● Enter Your Dev A/C Number │ 30584575\n",
      "● Enter Your Regd. Mob. No. │ 1593572580\n",
      "● Enter Your Aadhar Card No. │ 159357258000\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[31;1m ❌❌ Validation Failed ❌❌\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 3\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[31;1m T&C.txt File not Found \n",
      " If you deleted or lost \n",
      "\n",
      " Download it from \n",
      " https://devbank.netlify.app\n",
      "\n",
      "\u001b[32;1m |      \u001b[34;1m File Name ➤             \u001b[31;1m T&C.txt      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 1\n",
      "____________________________________________________________\n",
      "\n",
      "\t♕ User Id\t➤\t\tarman@dev\n",
      "\t♕ Key\t\t➤\t\t········\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "● Condition Chosen │ \t1\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press S ➤          \u001b[31;1m Saving A/C      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press C ➤         \u001b[31;1m Current A/C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "A/C Type \t│ 33\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[34;1m ★ Be Sure Any Error ★\n",
      "\n",
      "               \u001b[34;1m ➤ will make System ➤\n",
      "\n",
      "               \u001b[34;1m All entered data erase\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[31;1m ❌ Wrong Condition Chosen ❌\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t5\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[34;1m Things Can be Done\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤           \u001b[31;1m Add Money      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤       \u001b[31;1m Withdrw Money      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Back      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t  1\n",
      "● Enter Customer ID │ dev7415\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |\u001b[34;1m Present Balance ➤                \u001b[31;1m 2000      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |\u001b[34;1m Account Number  ➤            \u001b[31;1m 30584575      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |\u001b[34;1m A/C Type of Cus ➤              \u001b[31;1m saving      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "➤ Want to add Money ? 【y/n】 │ y\n",
      "➤ Amount to be Added \t │ 600\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |\u001b[34;1m Amount in Words │         \u001b[31;1m Six Hundred       \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[34;1m Deposit in Refrence\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤                \u001b[31;1m Cash      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤              \u001b[31;1m Cheque      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤              \u001b[31;1m Others      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |          \u001b[34;1m Any Num                \u001b[31;1m Back      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t  2\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "➤ Cheque No. \t│ 455120\n",
      "➤ Bank Name. in short form e.g. SBI \t│ UPD\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ❖ Transaction Successful ❖\n",
      "\n",
      "\u001b[32;1m |    \u001b[34;1m Now Balance ➤                \u001b[31;1m 2600      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t6\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[35;1m ❖ E-Applications below ❖\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[34;1m ✤ No Record Found ✤\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t6\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[35;1m ❖ E-Applications below ❖\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[34;1m ✤ No Record Found ✤\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t7\n",
      "____________________________________________________________\n",
      "● Enter Customer ID │ dev4715\n",
      "************************************************************\n",
      "\n",
      "               \u001b[31;1m ✋【Unauthenticated】 Id has given ✋\n",
      "\n",
      "************************************************************\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "● Condition Chosen │ \tdev7415\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[31;1m ❌ Given Number is not valid ❌\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t7\n",
      "____________________________________________________________\n",
      "● Enter Customer ID │ dev7415\n",
      "____________________________________________________________\n",
      "(OPTIONAL) Statement From the Date(format : YYYY-MM-DD) of│ \n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[35;1m Cusid : dev7415A/C Statement \n",
      "\n",
      "\u001b[32;1m |           \u001b[34;1m As on \u001b[31;1m 2021-03-14 18:13:37.408468      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "                         Description ChqNum. Dr.Amt Cr.Amt Transaction Time  \\\n",
      "Transaction Date                                                              \n",
      "2021-02-07            Initial Amount       0   ----   2000         16:56:50   \n",
      "2021-03-14        UPD Cheq No.455120  455120   ----    600         18:12:53   \n",
      "\n",
      "                 Balance  \n",
      "Transaction Date          \n",
      "2021-02-07          2000  \n",
      "2021-03-14          2600  \n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "➤ Want to Save this Data 【y/n】 │ 3\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[36;1m ✤ Proposal Rejected ✤\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "\t\t♕ Welcome Arman Singh 【manager】\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤    \u001b[31;1m Add New Customer      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 2 ➤     \u001b[31;1m Change Password      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 3 ➤  \u001b[31;1m View Cust. Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 4 ➤ \u001b[31;1m Update Cust.Details      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 5 ➤     \u001b[31;1m Update Balances      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 6 ➤    \u001b[31;1m See Apllications      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 7 ➤      \u001b[31;1m A/C Statements      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤                \u001b[31;1m Exit      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen │ \t33\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ✌ Thanks for Visit ✌ \n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m User Id ➤           \u001b[31;1m arman@dev      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |       \u001b[34;1m Leave at ➤            \u001b[31;1m 18:14:02      \u001b[32;1m |\n",
      "\n",
      "               \u001b[34;1m Sunday, March 14\n",
      "\n",
      "               \u001b[32;1m ★ Have a Good Day ★\n",
      "____________________________________________________________\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 1 ➤\u001b[31;1m Login/Apply E-Banking      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Press 0 ➤         \u001b[31;1m System Exit      \u001b[32;1m |\n",
      "\n",
      "\u001b[32;1m |        \u001b[34;1m Any Num ➤            \u001b[31;1m Read T&C      \u001b[32;1m |\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[32;1m ★ You have Agreed ours T&C ★\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "● Condition Chosen  : 0\n",
      "____________________________________________________________\n",
      "____________________________________________________________\n",
      "\n",
      "               \u001b[31;1m ✤ System Closes Successfully ✤\n",
      "\n",
      "               \u001b[31;1m ❖ Thanks for Your Concern ❖\n",
      "____________________________________________________________\n"
     ]
    },
    {
     "ename": "SystemExit",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "An exception has occurred, use %tb to see the full traceback.\n",
      "\u001b[1;31mSystemExit\u001b[0m\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\abc\\anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3351: UserWarning: To exit: use 'exit', 'quit', or Ctrl-D.\n",
      "  warn(\"To exit: use 'exit', 'quit', or Ctrl-D.\", stacklevel=1)\n"
     ]
    }
   ],
   "source": [
    "def design(stop,design):\n",
    "        r=''\n",
    "        if design == 2:\n",
    "            hyphen='_'\n",
    "        else:\n",
    "            hyphen='*'\n",
    "        for a in range(0,stop):\n",
    "            r+=hyphen\n",
    "        print(r)\n",
    "        \n",
    "def colour(textual_data,color):\n",
    "    a=\"\\033[3{};1m \".format(str(color)) #31:Red,32:Green,33:Yellow,34:Blue,35:Purple,36:Cyan,37:White\n",
    "    return (a+str(textual_data))\n",
    "\n",
    "def datarep(left_side_data,right_side_data):\n",
    "    print(\"\\n{0:>00}{1:>25}{2:>28}{3:>15}\\n\".format((colour('|',2)),(colour(left_side_data,4)),(colour(right_side_data,1)),(colour('|',2))),end='')\n",
    "    \n",
    "def center(textual_data):\n",
    "    print(\"\\n{0:<15}\".format(''),end='')\n",
    "    print(\"{0:>22}\".format(textual_data))\n",
    "    \n",
    "def message(textual_data,time_interface):\n",
    "    for char in textual_data:\n",
    "        print(char,end='')\n",
    "        time.sleep(time_interface)\n",
    "\n",
    "try:\n",
    "    import sys\n",
    "    import time\n",
    "    import numpy as np\n",
    "    import pandas as pd\n",
    "    from datetime import datetime,date\n",
    "    import math, random\n",
    "    import os\n",
    "    from getpass import getpass\n",
    "    import mysql.connector as sqltor\n",
    "    %matplotlib inline\n",
    "    import matplotlib.pyplot as plt\n",
    "    import pyautogui as pyg\n",
    "    import webbrowser\n",
    "    start1=True\n",
    "except ImportError as err:\n",
    "    design(60,2)\n",
    "    design(60,2)\n",
    "    center(colour('Error Occurs while Importing Libraries\\n Error: {}'.format(err),1))\n",
    "    design(60,2)\n",
    "    center(colour('Check All Libraries Presence',4))\n",
    "    design(60,2)\n",
    "    sys.exit()\n",
    "    start1=False\n",
    "\n",
    "if start1 :\n",
    "    if os.path.exists('Boot_Memory.csv'):\n",
    "        pyg.alert(\"Boot_Memory.csv at local Path - Found \\n\\\n",
    "        All Opeartions Established Successfully !!\\n\\nNote :\\n\\t❖ Deletion of this file results Boot-Recovery\\\n",
    "        \\n\\ti.e. Fresh Start by Rebuilding New Database (clearing all previous data).\\\n",
    "        \\n\\t❖ Its path should be local with respect to Dev Bank.ipynb\\n\\t❖ Don't make any Changes in this file. \",'Dev Bank CRM')\n",
    "        start2=True ## Showing Avail. of prior created Boot_Memory.csv\n",
    "    else:\n",
    "        a=['Version','MySQL Password','Database Name','Path','*CAUTION : CHANGES RESULTS ERRORs & Deletion (whole file) results Mester Reset*']\n",
    "        df=pd.DataFrame(a,columns=['DevBank'])\n",
    "        df.to_csv('Boot_Memory.csv')\n",
    "        pyg.alert('As Boot_Memory.csv absent\\nNew Boot_Memory Established Successfully !!\\n\\n\\\n",
    "        The System will have Master Restart/Start !!\\n\\nNote :\\n\\t❖ Deletion of this file results Boot-Recovery\\\n",
    "        \\n\\ti.e. Fresh Start by Rebuilding New Database (clearing all previous data).\\\n",
    "        \\n\\t❖ Its path should be local with respect to Dev Bank.ipynb\\n\\t❖ Don-t make any Changes in this file. ' ,'Dev Bank CRM')\n",
    "        start2=False\n",
    "        ## Showing the Availab. of Database but not of Boot_Memory.csv\n",
    "auth=''\n",
    "acnum=''\n",
    "\n",
    "def boot_data(index_value):\n",
    "    df=pd.read_csv('Boot_Memory.csv')\n",
    "    a=df.at[index_value,'DevBank']\n",
    "    return a\n",
    "\n",
    "if start1 :\n",
    "    df=pd.read_csv('Boot_Memory.csv')\n",
    "    if df.at[0,'DevBank'] == 'Version':\n",
    "        df.at[0,'DevBank']= '4.1.3'\n",
    "        df.to_csv('Boot_Memory.csv')\n",
    "        design(60,2)\n",
    "        center(colour('Boot_Memory Found @local_path',2))\n",
    "        design(60,2)\n",
    "        time.sleep(0.2)\n",
    "        design(60,2)\n",
    "        m=getpass('♕ Provide MySQL DBMS Password│ ')\n",
    "        t=input('♕ Provide Any Existing Database Name│ ')\n",
    "        df.at[1,'DevBank']= m\n",
    "        df.at[2,'DevBank']= t\n",
    "        df.to_csv('Boot_Memory.csv')\n",
    "        design(60,2)\n",
    "        center(colour('❖ Important Points ❖',1))\n",
    "        design(60,2)\n",
    "        datarep('Types of A/C','Saving & Current')\n",
    "        center(colour('For Saving',4))\n",
    "        datarep('Min. Bal','2000')\n",
    "        datarep('Service Chg.','0.5%')\n",
    "        datarep('Min. Bal. Def. Chg.','5%')\n",
    "        datarep('A/C will Suspended','Bal<100')\n",
    "        design(60,2)\n",
    "        time.sleep(0.1)\n",
    "        center(colour('For Current',4))\n",
    "        datarep('Min. Bal','10000')\n",
    "        datarep('Service Chg.','0%')\n",
    "        datarep('Min. Bal. Def. Chg.','5%')\n",
    "        datarep('A/C will Suspended','Bal<100')\n",
    "        design(60,2)\n",
    "        time.sleep(0.1)\n",
    "        design(60,2)\n",
    "        datarep('Version',df.at[0,'DevBank'])\n",
    "        center(colour('Made under Supervision of',2))\n",
    "        center(colour('MR. Shah & Company',2))\n",
    "        center(colour('Mansion3058 ',4))\n",
    "        design(60,2)\n",
    "        center(colour('★ The Above Message only Shows Once ★',1))\n",
    "        design(60,2)\n",
    "        time.sleep(0.3)\n",
    "        #Creating a Directory for Dev BanK Files\n",
    "        design(60,2)\n",
    "        center(colour('Select Drive for Storage',4))\n",
    "        datarep(' Press 1 ➤','D Drive')\n",
    "        datarep(' Press 2 ➤','E Drive')\n",
    "        datarep('Any Key ➤','C Drive')\n",
    "        design(60,2)\n",
    "        c=input('● Condition Chosen │ ')\n",
    "        if c =='1':\n",
    "            p=\"D:/\"\n",
    "        elif c=='2':\n",
    "            p=\"E:/\"\n",
    "        else:\n",
    "            p=\"C:/\"\n",
    "        d=\"Dev Bank\"\n",
    "        df.at[3,'DevBank']= p\n",
    "        df.to_csv('Boot_Memory.csv')\n",
    "        webbrowser.open('file:///'+p)\n",
    "        design(60,2)\n",
    "        center(colour('❖ Repositories Created Sucsfly ❖',2))\n",
    "        design(60,2)\n",
    "        time.sleep(0.2)\n",
    "## Checking the Availabilities of the Directories\n",
    "d=\"Dev Bank\"\n",
    "p=df.at[3,'DevBank']\n",
    "path=os.path.join(p,d)\n",
    "if os.path.exists(path) is False:\n",
    "    os.mkdir(path)\n",
    "d=\"Report Graphs\"\n",
    "p_dir=p+\"Dev Bank/\"\n",
    "path=os.path.join(p_dir,d)\n",
    "if os.path.exists(path) is False:\n",
    "    os.mkdir(path)\n",
    "d=\"ACC Statement\"\n",
    "path=os.path.join(p_dir,d)\n",
    "if os.path.exists(path) is False:\n",
    "    os.mkdir(path)\n",
    "d=\"Others\"\n",
    "path=os.path.join(p_dir,d)\n",
    "if os.path.exists(path) is False:\n",
    "    os.mkdir(path)\n",
    "## Checking the Availabilities of the Directories    \n",
    "if start1 :\n",
    "    try:\n",
    "        mycon=sqltor.connect(host=\"localhost\",user=\"root\",passwd=boot_data(1),database=boot_data(2))\n",
    "        files=mycon.cursor(buffered=True)\n",
    "        if start2 is False:\n",
    "            try:\n",
    "                files.execute('use devbank')\n",
    "                files.execute('drop database devbank;')\n",
    "                files.execute('create database if not exists devbank')\n",
    "                \n",
    "            except sqltor.Error:\n",
    "                files.execute('create database if not exists devbank')\n",
    "        else:\n",
    "            files.execute('create database if not exists devbank')\n",
    "        files.execute('use devbank')\n",
    "        start3=True\n",
    "    except sqltor.Error as err:\n",
    "        start3=False\n",
    "        a='⚠-❌ Something went Wrong ❌-⚠ \\n Database Refuse to Connect\\n\\n Error : {}'.format(err)\n",
    "        pyg.alert(a,'Dev Bank CRM')\n",
    "        design(60,2)\n",
    "        center(colour(a,1))\n",
    "        design(60,2)\n",
    "        sys.exit()\n",
    "        \n",
    "if start1  and start3 :\n",
    "    try:\n",
    "        files.execute('Select * from devcus;')\n",
    "    except sqltor.Error:\n",
    "        sql='''create table if not exists devcus(\n",
    "            cusid char(12) primary key,\n",
    "            acnum integer,\n",
    "            ac_type char(10),\n",
    "            name char(20),\n",
    "            passw char(20) default '******',\n",
    "            dob date,\n",
    "            age int(3),\n",
    "            uaid bigint(20),\n",
    "            gender char(1),\n",
    "            phone bigint(20),\n",
    "            crdate date,\n",
    "            crtime time,\n",
    "            active tinyint(1) default 0,\n",
    "            balance integer\n",
    "        )'''\n",
    "        files.execute(sql)\n",
    "    try:\n",
    "        files.execute('Select * from staff;')\n",
    "    except sqltor.Error:\n",
    "            sql='''create table if not exists staff(\n",
    "                id char(12) primary key,\n",
    "                name char(20) not null ,\n",
    "                pasw char(20) not null,\n",
    "                post char(20) not null\n",
    "                    )'''\n",
    "            files.execute(sql)\n",
    "            #Inserting Default Values into Staff Tables \n",
    "            files.execute(\"insert into staff values('arman@dev','Arman Singh','arman123','manager')\")\n",
    "            mycon.commit()\n",
    "            files.execute(\"insert into staff values('aman@dev','Aman Kaur','aman123','teller')\")\n",
    "            mycon.commit()\n",
    "            files.execute(\"insert into staff values('rahul@dev','Rahul Kumar','rahul123','cashier')\")\n",
    "            mycon.commit()\n",
    "    try:\n",
    "        files.execute('Select * from acstatement;')\n",
    "    except sqltor.Error:\n",
    "        sql='''create table if not exists acstatement(\n",
    "                cusid char(12),\n",
    "                description varchar(50),\n",
    "                chqnum varchar(20) default '0',\n",
    "                Withdrawn varchar(20) default '----',\n",
    "                Deposit varchar(20) default '----',\n",
    "                trandate date,\n",
    "                trantime time,\n",
    "                operation char(10),\n",
    "                balance varchar(20)\n",
    "\n",
    "            )'''\n",
    "        files.execute(sql)\n",
    "    try:\n",
    "        files.execute('Select * from atm;')\n",
    "    except sqltor.Error:\n",
    "        sql='''create table if not exists atm(\n",
    "                    cusid char(12),\n",
    "                    atmnumber varchar(20),\n",
    "                    date timestamp default current_timestamp,\n",
    "                    pin char(4),\n",
    "                    status char(12) default 'Active'\n",
    "\n",
    "                )'''\n",
    "        files.execute(sql)\n",
    "    try:\n",
    "        files.execute('Select * from application;')\n",
    "    except sqltor.Error:\n",
    "        sql='''create table if not exists application(\n",
    "                cusid char(12),\n",
    "                application varchar(20),\n",
    "                date timestamp default current_timestamp,\n",
    "                status char(12) default 'Unaccepted'\n",
    "\n",
    "            )'''\n",
    "        files.execute(sql)\n",
    "    try:\n",
    "        files.execute('Select * from blocktrans;')\n",
    "        start3=True\n",
    "    except sqltor.Error:\n",
    "        sql='''create table if not exists blocktrans(\n",
    "                    cusid char(12),\n",
    "                    cheqnum char(12),\n",
    "                    date timestamp default current_timestamp\n",
    "\n",
    "                )'''\n",
    "        files.execute(sql)\n",
    "message('Welcome to Dev Bank CRM (Customer Relation Management) System',0.2)\n",
    "print()\n",
    "while True:\n",
    "    def vals(data):\n",
    "        if data !='' and data!=' ':\n",
    "            if data.isalpha():\n",
    "                return True\n",
    "            else:\n",
    "                design(50,1)\n",
    "                center(colour(\"❌ Enter Data is Not valid ❌\\n\",1))\n",
    "                design(50,1)\n",
    "        else:\n",
    "            design(50,1)\n",
    "            center(colour(\"❌ Null Value unacceptable ❌\\n\",1))\n",
    "            design(50,1)\n",
    "    def valn(data):\n",
    "        if data.isdigit()  :\n",
    "            return True\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('❌ Given Number is not valid ❌',1))\n",
    "            design(60,2)\n",
    "            \n",
    "    def nonzero(numeric_data_in_string_form):\n",
    "        if numeric_data_in_string_form[0] != '0':\n",
    "            return True\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('❌ Zero at First place Unacceptable ❌',1))\n",
    "            design(60,2)\n",
    "            \n",
    "    def valcon(data,length_condition):\n",
    "        if len(data) == length_condition:\n",
    "            return True        \n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('❌ Given Argument Unacceptable ❌',1))\n",
    "            design(60,2)\n",
    "            \n",
    "    def alpha(numeric_data):\n",
    "        num=[\"\",\"One\",\"Two\",\"Three\",\"Four\",\"Five\",\"Six\",\"Seven\",\"Eight\",\"Nine\"]\n",
    "        tens=[\"Ten\",\"Eleven\",\"Tweleve\",\"Thirteen\",\"Fourteen\",\"Fifteen\",\"Sixteen\",\"Seventeen\",\"Eighteen\",\"Nineteen\"]\n",
    "        nty=[\"\",\"\",\"Twenty\",\"Thirty\",\"Fourty\",\"Fifty\",\"Sixty\",\"Seventy\",\"Eighty\",\"Ninety\"]\n",
    "        wrd=\"\"\n",
    "        r=1\n",
    "        numeric_data=str(numeric_data)\n",
    "        if numeric_data[0]!=\"0\":\n",
    "            if len(numeric_data)==7:\n",
    "                if numeric_data[0]==\"1\":\n",
    "                    wrd+=tens[int(numeric_data[1])]+ \" Lakhs \"\n",
    "                    numeric_data=numeric_data[2::]\n",
    "                    while int(numeric_data[0])==0 and r<5:\n",
    "                        numeric_data=numeric_data[1::]\n",
    "                        r=r+1\n",
    "                else:\n",
    "                    wrd+=nty[int(numeric_data[0])]+ \" \"+num[int(numeric_data[1])] + \" Lakhs \"\n",
    "                    numeric_data=numeric_data[2::]\n",
    "                    while int(numeric_data[0])==0 and r<5:\n",
    "                        numeric_data=numeric_data[1::]\n",
    "                        r=r+1\n",
    "            if len(numeric_data)==6:\n",
    "                wrd+=num[int(numeric_data[0])]+ \" Lakhs \"\n",
    "                numeric_data=numeric_data[1::]\n",
    "                while int(numeric_data[0])==0 and r<5:\n",
    "                    numeric_data=numeric_data[1::]\n",
    "                    r=r+1\n",
    "            if len(numeric_data)==5:\n",
    "                if numeric_data[0]==\"1\":\n",
    "                    wrd+=tens[int(numeric_data[1])]+ \" Thousand \"\n",
    "                    numeric_data=numeric_data[2::]\n",
    "                else:\n",
    "                    wrd+=nty[int(numeric_data[0])]+ \" \"+num[int(numeric_data[1])] + \" Thousand \"\n",
    "                    numeric_data=numeric_data[2::]\n",
    "            if len(numeric_data)==4:\n",
    "                wrd+=num[int(numeric_data[0])]+\" Thousand \"\n",
    "                numeric_data=numeric_data[1::]\n",
    "            if len(numeric_data)==3:\n",
    "                if numeric_data[0]!=\"0\":\n",
    "                    wrd+=num[int(numeric_data[0])]+\" Hundred \"\n",
    "                    numeric_data=numeric_data[1::]\n",
    "                else:\n",
    "                    numeric_data=numeric_data[1::]\n",
    "            if len(numeric_data)<=2:\n",
    "                if len(numeric_data)==1:\n",
    "                    wrd+=num[int(numeric_data)]\n",
    "                elif int(numeric_data)<20:\n",
    "                    if numeric_data[0]==\"0\":\n",
    "                        wrd+=num[int(numeric_data[1])]\n",
    "                    else:\n",
    "                        wrd+=tens[int(numeric_data[1])]\n",
    "                else:\n",
    "                    wrd+=str(nty[int(numeric_data[0])])+\" \"+str(num[int(numeric_data[1])])\n",
    "            else:\n",
    "                design(60,2)\n",
    "                center(colour(\"Out of Range 9999999\",1))\n",
    "                design(60,2)\n",
    "        return wrd\n",
    "    \n",
    "    def unique(column,data):\n",
    "        df=usdetails('staff','a')\n",
    "        if df.empty is False:\n",
    "            for a in df[column]:\n",
    "                if a==data:\n",
    "                    break\n",
    "                    return False\n",
    "                else:\n",
    "                    return True\n",
    "        else:\n",
    "            return True\n",
    "\n",
    "    def usdetails(author,cusid):\n",
    "        if author=='staff':\n",
    "            if cusid!='a':\n",
    "                files.execute(\"select cusid,acnum,ac_type,name,dob,uaid,age,phone,active,balance from devcus where cusid = '{}' \".format(cusid))\n",
    "                dt=files.fetchall()\n",
    "                df=pd.DataFrame(dt,columns=[\"Cust ID\",\"A/C_Num\",\"A/C Type\",\"Name\",\"DOB\",\"UAID (Aadhar No.)\",\"Age\",\"Phone\",\"Status\",\"Balance\"])\n",
    "                df.set_index('Cust ID',inplace=True)\n",
    "                return df\n",
    "            elif cusid=='a':\n",
    "                files.execute(\"select cusid,acnum,ac_type,name,dob,uaid,age,phone,active,balance from devcus\")\n",
    "                dt=files.fetchall()\n",
    "                df=pd.DataFrame(dt,columns=[\"Cust ID\",\"A/C_Num\",\"A/C Type\",\"Name\",\"DOB\",\"UAID (Aadhar No.)\",\"Age\",\"Phone\",\"Status\",\"Balance\"])\n",
    "                df.set_index('Cust ID',inplace=True)\n",
    "                return df\n",
    "        elif author=='cus':\n",
    "            files.execute(\"select cusid,acnum,ac_type,name,dob,uaid,age,gender,phone,crdate,crtime,balance from devcus where cusid = '{}' \".format(cusid))\n",
    "            dt=files.fetchall()\n",
    "            df=pd.DataFrame(dt,columns=[\"Cust ID\",\"A/C_Num\",\"A/C Type\",\"Name\",\"DOB\",\"UAID (Aadhar No.)\",\"Age\",\"M/F\",\"Phone\",\\\n",
    "                                        \"Admisn.Date\",\"Admisn.Time\",\"Balance\"])\n",
    "            df.set_index('Cust ID',inplace=True)\n",
    "            return df\n",
    "        else:\n",
    "            files.execute(\"select * from devcus where cusid = '{}' \".format(cusid))\n",
    "            dt=files.fetchall()\n",
    "            df=pd.DataFrame(dt,columns=[\"Cust ID\",\"A/C_Num\",\"A/C Type\",\"Name\",\"key\",\"DOB\",\"Age\",\"UAID (Aadhar No.)\",\"M/F\",\"Phone\",\"Admisn.Date\",\"Admisn.Time\",\"Status\",\"Balance\"])\n",
    "            df.set_index('Cust ID',inplace=True)\n",
    "            return df\n",
    "        \n",
    "    def hasatm():\n",
    "        files.execute(\"select cusid,atmnumber,date,status from atm \")\n",
    "        dt=files.fetchall()\n",
    "        df=pd.DataFrame(dt,columns=[\"Cust ID\",\"ATM Card No.\",\"Applied Date\",\"Status\"])\n",
    "        df.set_index('Cust ID',inplace=True)\n",
    "        return df\n",
    "    \n",
    "    def applatm(cusid):\n",
    "        df=hasatm()\n",
    "        if cusid in df.index:\n",
    "            design(60,2)\n",
    "            center(colour('❖ You already have ATM Card ❖',4))\n",
    "            design(60,2)\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('★ Pin should be = 4 digit ★',1))\n",
    "            cn=getpass('➤ Enter Pin for Your ATM Card │ ')\n",
    "            if valn(cn)  and valcon(cn,4):\n",
    "                cn=int(cn)\n",
    "                design(60,2)\n",
    "                acnum=''\n",
    "                digits = \"989006500058525800\"\n",
    "                for i in range(10):\n",
    "                    acnum+=digits[math.floor(random.random() * 10)]\n",
    "                acnum='560000'+acnum\n",
    "                files.execute(\"insert into atm(cusid,atmnumber,pin,status) values(%s,%s,%s,%s)\"\\\n",
    "                                  ,(cusid,acnum,cn,'Unactive'))\n",
    "                mycon.commit()\n",
    "                files.execute(\"insert into application(cusid,application) values(%s,%s)\"\\\n",
    "                                  ,(cusid,'ATM '+acnum))\n",
    "                mycon.commit()\n",
    "                design(60,2)\n",
    "                pyg.alert('Application Submitted Successfully','Dev CRM -'+str(cusid))\n",
    "                center(colour('❖ Application Submitted Successfully ❖',2))\n",
    "                datarep('ATM No.',acnum)\n",
    "                center(colour('For ATM Card visit Bank',2))\n",
    "                design(60,2)\n",
    "    \n",
    "    def atmdetails():\n",
    "        files.execute(\"select * from atm\")\n",
    "        dt=files.fetchall()\n",
    "        df=pd.DataFrame(dt,columns=[\"Cust ID\",\"ATM Number\",\"Date\",\"Pin\",\"Status\"])\n",
    "        df.set_index('Cust ID',inplace=True)\n",
    "        return df\n",
    "        \n",
    "    def leave(cusid):\n",
    "        design(60,2)\n",
    "        center(colour('✌ Thanks for Visit ✌ ',2))\n",
    "        datarep('User Id ➤',cusid)\n",
    "        t=datetime.now()\n",
    "        datarep('Leave at ➤',t.strftime(\"%H:%M:%S\"))\n",
    "        center(colour(d.strftime(\"%A, %B %d\"),4))\n",
    "        center(colour('★ Have a Good Day ★',2))\n",
    "        design(60,2)\n",
    "        time.sleep(0.2)\n",
    "\n",
    "    def status(cusid,category):\n",
    "        if category=='Account':\n",
    "            df=usdetails('staff',cusid)\n",
    "            if df.at[cusid,'Status'] == 1:\n",
    "                return True\n",
    "            else:\n",
    "                return False\n",
    "        elif category=='ATM':\n",
    "            df=hasatm()\n",
    "            if df.at[cusid,'Status'] == 'Unactive':\n",
    "                return False\n",
    "            else:\n",
    "                return True\n",
    "        else:\n",
    "            df=appldetails()\n",
    "            if df.at[cusid,'Status'] == 'Unaccepted':\n",
    "                return False\n",
    "            else:\n",
    "                return True\n",
    "            \n",
    "    def appldetails():\n",
    "        files.execute(\"select * from application\")\n",
    "        dt=files.fetchall()\n",
    "        df=pd.DataFrame(dt,columns=[\"Cust ID\",\"Application\",\"Date\",\"Status\"])\n",
    "        df.set_index('Cust ID',inplace=True)\n",
    "        return df\n",
    "        \n",
    "    def updstatus(cusid,category,active_or_not):\n",
    "        if category=='Account':\n",
    "            files.execute(\"update devcus set active='{}' where cusid='{}'\".format(active_or_not,cusid))\n",
    "            mycon.commit()\n",
    "            design(60,2)\n",
    "            center(colour(\"❖ Changes made Successfully ❖\",2))\n",
    "            design(60,2)\n",
    "            design(60,2)\n",
    "            datarep('Current Status ➤',active_or_not)\n",
    "            design(60,2)\n",
    "        elif category=='ATM':\n",
    "            files.execute(\"update atm set status='{}' where cusid='{}'\".format(active_or_not,cusid))\n",
    "            mycon.commit()\n",
    "            design(60,2)\n",
    "            center(colour(\"❖ Changes made Successfully ❖\",2))\n",
    "            design(60,2)\n",
    "            design(60,2)\n",
    "            datarep('Current Status ➤',active_or_not)\n",
    "            design(60,2)\n",
    "        else:\n",
    "            if status(cusid,'Appl') is False:\n",
    "                files.execute(\"update application set status='{}' where cusid='{}'\".format(active_or_not,cusid))\n",
    "                mycon.commit()\n",
    "                design(60,2)\n",
    "                center(colour(\"❖ Apllication Accepted Successfully ❖\",2))\n",
    "                design(60,2)\n",
    "            else:\n",
    "                design(60,2)\n",
    "                center(colour(\"❖ Apllication Already Accepted ❖\",1))\n",
    "                center(colour(\" ✌ No Changes Detected ✌ \",2))\n",
    "                design(60,2)\n",
    "\n",
    "    def is_date(date_in_string_format):\n",
    "        format = \"%Y-%m-%d\"\n",
    "        try:\n",
    "            datetime.strptime(date_in_string_format, format)\n",
    "            return True\n",
    "        except ValueError:\n",
    "            return False\n",
    "    \n",
    "    def acstatement(x,p):\n",
    "        design(60,2)\n",
    "        cn=input('(OPTIONAL) Statement From the Date(format : YYYY-MM-DD) of│ ')\n",
    "        if is_date(cn) == False:\n",
    "            files.execute(\"select description,chqnum,Withdrawn,Deposit,trandate,trantime,balance from acstatement where cusid = '{}' \".format(x))\n",
    "        else:\n",
    "            files.execute(\"select description,chqnum,Withdrawn,Deposit,trandate,trantime,balance from acstatement where cusid = '{}' and trandate >= '{}' \".format(x,cn))\n",
    "        dt=files.fetchall()\n",
    "        df=pd.DataFrame(dt,columns=[\"Description\",\"ChqNum.\",\"Dr.Amt\",\"Cr.Amt\",\"Transaction Date\",\"Transaction Time\",\"Balance\"])\n",
    "        df.set_index('Transaction Date',inplace=True)\n",
    "        if df.empty is not True:\n",
    "            design(60,2)\n",
    "            t='Cusid : '+x\n",
    "            center(colour(t+'A/C Statement ',5))\n",
    "            d=datetime.now()\n",
    "            if is_date(cn) :\n",
    "                datarep('From ',cn)\n",
    "                datarep('To ',str(d)[:19:])                                                                    \n",
    "            else:\n",
    "                datarep('As on ',str(d))\n",
    "            design(60,2)\n",
    "            print(df)\n",
    "            design(60,2)\n",
    "            time.sleep(0.2)\n",
    "            if p!='s':\n",
    "                graph(df,cn)\n",
    "            design(60,2)\n",
    "            cn=input('\\n➤ Want to Save this Data 【y/n】 │ ')\n",
    "            if cn == 'Y' or cn=='y':\n",
    "                if p!='s':\n",
    "                    design(60,2)\n",
    "                    datarep('Press 1 ➤','Statement')\n",
    "                    datarep('Press 2 ➤','Graph')\n",
    "                    datarep('Press 3 ➤','Both')\n",
    "                    datarep('Any Key ➤',' Back')\n",
    "                    design(60,2)\n",
    "                    c=input('\\n● Condition Chosen │ ')\n",
    "                    if c == '1':\n",
    "                        save(df,'ac')\n",
    "                        design(60,2)\n",
    "                    elif c == '2':\n",
    "                        graph(df,'y')\n",
    "                        design(60,2)\n",
    "                    elif c == '3':\n",
    "                        design(60,2)\n",
    "                        center(colour('❖ For Statement ❖',5))\n",
    "                        save(df,'ac')\n",
    "                        design(60,2)\n",
    "                        center(colour('❖ For Graphical Data ❖',5))\n",
    "                        design(60,2)\n",
    "                        graph(df,'y')\n",
    "                        design(60,2)\n",
    "\n",
    "                    else:\n",
    "                        design(60,2)\n",
    "                        center(colour('✤ Back to Menu ✤',4))\n",
    "                        design(60,2)\n",
    "                else:\n",
    "                    \n",
    "                    (df,'other')\n",
    "                    \n",
    "            else:\n",
    "                design(60,2)\n",
    "                center(colour('✤ Proposal Rejected ✤',6))\n",
    "                design(60,2)\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('✤ No Record Found ✤',4))\n",
    "            design(60,2)\n",
    "        \n",
    "        return df\n",
    "    \n",
    "    def graph(df,f):\n",
    "        l1=[]\n",
    "        l2=[]\n",
    "        clr=[]\n",
    "        xa=df.index\n",
    "        xa=xa.values\n",
    "        y=df['Balance']\n",
    "        y=y.values\n",
    "        for a in range(len(xa)):\n",
    "            l1.append(a+1)\n",
    "            l2.append(float(y[a]))\n",
    "            if acty(x,0) == 'saving':\n",
    "                if l2[a] < 2000 :\n",
    "                    clr.append('r')\n",
    "                elif l2[a] == 2000 or l2[a] < 4000:\n",
    "                    clr.append('b')\n",
    "                else:\n",
    "                    clr.append('g')\n",
    "            else:\n",
    "                if l2[a] < 10000 :\n",
    "                    clr.append('r')\n",
    "                elif l2[a] == 10000 or l2[a] < 20000:\n",
    "                    clr.append('b')\n",
    "                else:\n",
    "                    clr.append('g')\n",
    "        plt.figure(figsize=(10,5))\n",
    "        plt.grid(True)\n",
    "        d=datetime.now()\n",
    "        if is_date(f) :\n",
    "            cn=f+' to '+ str(d)\n",
    "            plt.title('Change in Balance from '+cn)\n",
    "            plt.xlabel(cn)\n",
    "        else:\n",
    "            plt.title('Change in Balance as on'+str(d)[:19:])\n",
    "            plt.xlabel('Interval of Time')\n",
    "        plt.ylabel('Balance in Rupees')\n",
    "        plt.bar(l1,l2,color=clr)\n",
    "        if f == 'y':\n",
    "            design(60,2)\n",
    "            b=input('\\n➤ Enter the Name for  Document │ \\t ')\n",
    "            design(60,2)\n",
    "            d=boot_data(3)+'Dev Bank\\Report Graphs'\n",
    "            p=os.path.join(d,b+'.pdf')\n",
    "            if os.path.exists(p):\n",
    "                design(60,2)\n",
    "                center(colour('【 File Name Already Exists 】',1))\n",
    "                design(60,2)\n",
    "                design(60,2)\n",
    "                a=input('\\n➤ Want to Replace or Overwrite ? 【y/n】 │ ')\n",
    "                design(60,2)\n",
    "                if vals(a)  :\n",
    "                    if a=='y' or a=='Y':\n",
    "                        d=date.today()\n",
    "                        t=datetime.now()\n",
    "                        n='Balances Report till ' + t.strftime(\"%H:%M:%S\")+ ' ' + str(d) + ' Dev Bank ID :- ' + x\n",
    "                        plt.title(n)\n",
    "                        plt.savefig(p)\n",
    "                        center(colour('❖ Graph Save Successfully ❖',2))\n",
    "                        datarep('Document Name ➤',b+'.pdf')\n",
    "                        datarep('Path ➤ ',p)\n",
    "                        p=os.path.join(boot_data(3)+'Dev%20Bank/Report%20Graphs/',b+'.pdf')\n",
    "                        webbrowser.open('file:///'+p)\n",
    "                        design(60,2)\n",
    "                else:\n",
    "                    design(60,2)\n",
    "                    center(colour('❖ Try Again with Different Name ❖',4))\n",
    "                    design(60,2)\n",
    "            else:\n",
    "                plt.savefig(p)\n",
    "                center(colour('❖ Graph Save Successfully ❖',2))\n",
    "                datarep('Document Name ➤ ',b+'.pdf')\n",
    "                datarep('Path ➤ ',p)\n",
    "                p=os.path.join(boot_data(3)+'Dev%20Bank/Report%20Graphs/',b+'.pdf')\n",
    "                webbrowser.open('file:///'+p)\n",
    "                design(60,2)\n",
    "        else:\n",
    "            plt.show()\n",
    "        \n",
    "    def amountstatus(x,a,c,b):\n",
    "        while True:\n",
    "            if c == 'aa' or c=='ac':\n",
    "                if c =='aa':\n",
    "                    files.execute(\"select description,chqnum,Deposit,trandate,trantime from acstatement where deposit={} and cusid = '{}' and operation = 'Add' \".format(a,x))\n",
    "                    dt=files.fetchall()\n",
    "                    break\n",
    "                else:\n",
    "                    files.execute(\"select description,chqnum,Deposit,trandate,trantime from acstatement where chqnum={} and cusid = '{}' and operation = 'Add'\".format(a,x))\n",
    "                    dt=files.fetchall()\n",
    "                    break\n",
    "\n",
    "            else:\n",
    "                if c == 'wa':\n",
    "                    files.execute(\"select description,chqnum,Withdrawn,trandate,trantime from acstatement where withdrawn={} and cusid = '{}' and operation = 'Less' \".format(a,x))\n",
    "                    dt=files.fetchall()\n",
    "                    break\n",
    "                else:\n",
    "                    files.execute(\"select description,chqnum,Withdrawn,trandate,trantime from acstatement where chqnum={} and cusid = '{}' and operation = 'Less' \".format(a,x))\n",
    "                    dt=files.fetchall()\n",
    "                    break\n",
    "                    \n",
    "        if dt == []:\n",
    "            design(60,2)\n",
    "            center(colour('❖ No Such Transaction Found ❖',1))\n",
    "            design(60,2)\n",
    "        else:\n",
    "            df=pd.DataFrame(dt,columns=[\"Reference description\",\"Cheq No.\",\"Amount\",\"Transaction Date\",\"Transaction Time\"])\n",
    "            df.set_index('Reference description',inplace=True)\n",
    "            return print(df)\n",
    "    \n",
    "    def cheqnum(x,c):\n",
    "        files.execute(\"select chqnum,description from acstatement where cusid = '{}' and operation ='Less';\".format(x))\n",
    "        dt=files.fetchall()\n",
    "        df=pd.DataFrame(dt,columns=[\"Cheq No.\",\"description\"])\n",
    "        df.set_index('Cheq No.',inplace=True)\n",
    "        if c in df.index :\n",
    "            design(60,2)\n",
    "            center(colour('☛ Cheque already in System',1))\n",
    "            center(colour('❖ Changes unmade Yet ❖',4))\n",
    "            design(60,2)\n",
    "            \n",
    "        else:\n",
    "            return True\n",
    "        \n",
    "        \n",
    "    def blcdup(x,c):\n",
    "        files.execute(\"select cheqnum,date from blocktrans where cusid = '{}'\".format(x))\n",
    "        dt=files.fetchall()\n",
    "        df=pd.DataFrame(dt,columns=[\"Cheq No.\",\"Date\"])\n",
    "        df.set_index('Cheq No.',inplace=True)\n",
    "        if c in df.index :\n",
    "            design(60,2)\n",
    "            center(colour('☛ Cheque already Blocked',1))\n",
    "            center(colour('❖ Changes unmade Yet ❖',4))\n",
    "            design(60,2)   \n",
    "        else:\n",
    "            return True\n",
    "        \n",
    "    def chcid(x):\n",
    "        if x!='' and x!=' ':\n",
    "            op=x[::-1]\n",
    "            p=1\n",
    "            if op[0]=='v':\n",
    "                df1=staffdetails()\n",
    "                if x in df1.index:\n",
    "                    return True,'staff'\n",
    "                else:\n",
    "                    design(60,1)\n",
    "                    center(colour('✋【Unauthenticated】 Id has given ✋\\n',1))\n",
    "                    design(60,1)\n",
    "                    return False,'staff'\n",
    "            elif x[0]=='d':\n",
    "                df1=usdetails('staff','a')\n",
    "                if x in df1.index:\n",
    "                    return True,'cus'\n",
    "                else:\n",
    "                    design(60,1)\n",
    "                    center(colour('✋【Unauthenticated】 Id has given ✋\\n',1))\n",
    "                    design(60,1)\n",
    "                    return False,'cus'\n",
    "            else:\n",
    "                design(60,1)\n",
    "                center(colour('✋【Unauthenticated】 Id has given ✋\\n',1))\n",
    "                design(60,1)\n",
    "                return False,'cus'\n",
    "        else:\n",
    "            design(60,1)\n",
    "            center(colour('✋【Unauthenticated】 Id has given ✋\\n',1))\n",
    "            design(60,1)\n",
    "            return False,'staff'\n",
    "\n",
    "    def staffdetails():\n",
    "        files.execute('select * from staff')\n",
    "        d=files.fetchall()\n",
    "        df1=pd.DataFrame(d,columns=['id','name','key','post'])\n",
    "        df1.set_index('id',inplace=True)\n",
    "        return df1\n",
    "    \n",
    "    def login(x,y,z):\n",
    "        if y == 'staff':\n",
    "            df=staffdetails()\n",
    "            if df.at[x,'key'] == z:     \n",
    "                return True\n",
    "            else:\n",
    "                design(60,2)\n",
    "                datarep('Paswrd is【Wrong】as ID',x)\n",
    "                design(60,2)\n",
    "                \n",
    "        else:\n",
    "            df=usdetails('login',x)\n",
    "            if df.at[x,'key'] == z:\n",
    "                return True\n",
    "            else:\n",
    "                design(60,2)\n",
    "                datarep('Paswrd is【Wrong】as ID',x)\n",
    "                design(60,2)\n",
    "                \n",
    "            \n",
    "    def chcauth(x,y):\n",
    "        df1=staffdetails()\n",
    "        if y=='addcus' or y=='updcus':\n",
    "            if df1.at[x,'post'] == 'manager' or df1.at[x,'post'] == 'teller':\n",
    "                return True\n",
    "            else:\n",
    "                pyg.alert('☛ Authorisation Error\\n● You Are not Authorised for this Task','Dev CRM - '+str(x))\n",
    "                print('Your are NOT AUTHORISED for this fuction.')\n",
    "        elif y=='updcash':\n",
    "            if df1.at[x,'post'] == 'manager' or df1.at[x,'post'] == 'cashier':\n",
    "                return True\n",
    "            else:\n",
    "                pyg.alert('☛ Authorisation Error\\n● You Are not Authorised for Updating Balances of Customers.','Dev CRM - '+str(x))\n",
    "                print('☛ Your are NOT AUTHORISED for updating Cash Balances.')\n",
    "                \n",
    "    def acty(x,y):\n",
    "        if y == 0:\n",
    "            df=usdetails('staff',x)\n",
    "            return df.at[x,'A/C Type']\n",
    "        else:\n",
    "            df=usdetails('staff',x)\n",
    "            ty=df.at[x,'A/C Type']\n",
    "            if ty=='saving':\n",
    "                files.execute(\"update devcus set ac_type='{}' where cusid='{}'\".format('current',x))\n",
    "                mycon.commit()\n",
    "            else:\n",
    "                files.execute(\"update devcus set ac_type='{}' where cusid='{}'\".format('saving',x))\n",
    "                mycon.commit()\n",
    "\n",
    "    def phnchg(x):\n",
    "        df=usdetails('staff',x)\n",
    "        p=df.at[c,'Phone']\n",
    "        design(60,2)\n",
    "        datarep('At Present',p)\n",
    "        design(60,2)\n",
    "        d=input('➤ Want to Change Number of Customer 【y/n】 │ ')\n",
    "        if d=='y' or d=='Y':\n",
    "            phn=input('☛ New Phone Number \\t │')\n",
    "            if valn(phn)  and valcon(phn,10)  and nonzero(phn) :\n",
    "                phn=int(phn)\n",
    "                files.execute(\"update devcus set phone='{}' where cusid='{}'\".format(phn,x))\n",
    "                mycon.commit()\n",
    "                return True\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('❖ Changes unmade Yet ❖',4))\n",
    "            design(60,2)\n",
    "\n",
    "    def cusbal(x):\n",
    "        df=usdetails('staff',x) \n",
    "        return df.at[x,'Balance']\n",
    "    \n",
    "    def blchq(x,c):\n",
    "        if c == 'b':\n",
    "            d=input('➤ Want to Block Any Transaction Continue 【y/n】 │ ')\n",
    "            if d == 'y' or d=='Y':\n",
    "                design(60,2)\n",
    "                d=input('\\n➤ Enter Cheque Number │ ')\n",
    "                if valn(d)  and nonzero(d) :\n",
    "                    if cheqnum(x,d) :\n",
    "                        if blcdup(x,d) :\n",
    "                            files.execute(\"insert into blocktrans(cusid,cheqnum) values(%s,%s)\",(x,d))\n",
    "                            mycon.commit()\n",
    "                            design(60,2)\n",
    "                            t='Blocking Successfully for \\n' + 'Cheque No. '+str(d)\n",
    "                            pyg.alert(t,'Dev CRM - '+str(x))\n",
    "                            center(colour('Changes made Successfully',2))\n",
    "                            design(60,2)\n",
    "                else:\n",
    "                    design(60,2)\n",
    "                    center(colour('❖ Changes unmade Yet ❖',4))\n",
    "                    design(60,2)\n",
    "        else:\n",
    "            if c=='h':\n",
    "                files.execute(\"select * from blocktrans where cusid='{}'\".format(x))\n",
    "            else:\n",
    "                files.execute(\"select * from blocktrans where cusid = '{}' and cheqnum = '{}'\".format(x,c))\n",
    "            d=files.fetchall()\n",
    "            df1=pd.DataFrame(d,columns=['ID','Cheq No.','Entered Date'])\n",
    "            df1.set_index('Cheq No.',inplace=True)\n",
    "            return df1\n",
    "            \n",
    "    def pswpwr(x):\n",
    "        if len(x)>=6:\n",
    "            if x.isalpha():\n",
    "                design(60,2)\n",
    "                center(colour(\"✤ Password Status : 【Too Weak】✤\",1))\n",
    "                design(60,2)\n",
    "            elif x==\"\" or x==\" \":\n",
    "                design(60,2)\n",
    "                center(colour(\"✤ Password Status : 【Null】 ✤\",1))\n",
    "                design(60,2)\n",
    "            else:\n",
    "                return True\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour(\"✤ Password must >= 6 digit ✤ \",1))\n",
    "            design(60,2)\n",
    "    \n",
    "    def pswmatch(x,y):\n",
    "        if x==y:\n",
    "            return True\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('✤ Password Not Match ✤',1))\n",
    "            design(60,2)\n",
    "            \n",
    "    def changepsw(x,y,z,forget):\n",
    "        design(60,2)\n",
    "        ph=''\n",
    "        if forget==False:\n",
    "            ph=getpass('\\n➤ Current Password/PIN │ \\t ')\n",
    "            design(60,2)\n",
    "        if ph == x:\n",
    "            if z==1 or z==0:\n",
    "                design(60,2)\n",
    "                print('Password must have 6 digits including at least ')\n",
    "                datarep('1','Number')\n",
    "                datarep('1','capital char')\n",
    "                design(60,2)\n",
    "                design(60,2)\n",
    "                ph=getpass('\\n➤ New Password │ \\t ')\n",
    "                if pswpwr(ph) :\n",
    "                    ph2=getpass('➤ Confirm Password │ \\t ')\n",
    "                    design(60,2)\n",
    "                    if pswmatch(ph,ph2) :\n",
    "                        if z == 1:  #if Z==1 it means Staff Password Conversion else of Customer\n",
    "                            files.execute(\"update staff set pasw ='{}' where id='{}'\".format(ph,y))\n",
    "                            mycon.commit()\n",
    "                            pyg.alert('❖ Password Sets Successfully ❖','Dev Staff - '+str(y))\n",
    "                            design(60,2)\n",
    "                            center(colour('❖ Password Sets Successfully ❖',2))\n",
    "                            design(60,2)\n",
    "                        elif z == 0:\n",
    "                            files.execute(\"update devcus set passw ='{}' where cusid='{}'\".format(ph,y))\n",
    "                            mycon.commit()\n",
    "                            pyg.alert('❖ Password Sets Successfully ❖','Dev CRM - '+str(y))\n",
    "                            design(60,2)\n",
    "                            center(colour('❖ Password Sets Successfully ❖',2))\n",
    "                            design(60,2)\n",
    "            else:\n",
    "                design(60,2)\n",
    "                center(colour('★ PIN must have 4 digits ★',1))\n",
    "                design(60,2)\n",
    "                ph=getpass('\\n➤ New PIN │ \\t ')\n",
    "                if valn(ph) :\n",
    "                    if valcon(ph,4) :\n",
    "                        ph2=getpass('➤ Confirm PIN │ \\t ')\n",
    "                        design(60,2)\n",
    "                        if pswmatch(ph,ph2) :\n",
    "                            files.execute(\"update atm set pin ='{}' where cusid='{}'\".format(ph,y))\n",
    "                            mycon.commit()\n",
    "                            pyg.alert('❖ Pin Change Successfully ❖','Dev CRM - '+str(y))\n",
    "                            design(60,2)\n",
    "                            center(colour('❖ Pin Change Successfully ❖',2))\n",
    "                            design(60,2)\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('❖ Pssword/PIN is unmatched ❖ ',1))\n",
    "            design(60,2)\n",
    "                            \n",
    "    def chcbal(x,y):\n",
    "        if y == 'saving':\n",
    "            if x >= 2000 and x < 1000000:\n",
    "                return True\n",
    "            else:\n",
    "                center(colour('Saving A/C Initial Bal.',4))\n",
    "                datarep('★ I.Bal >= 2000 ','I.Bal < 10 Lakh ★')\n",
    "                \n",
    "        elif y =='current':\n",
    "            if x >= 10000 and x < 10000000:\n",
    "                return True\n",
    "            else:\n",
    "                center(colour('Current A/C Initial Bal.',4))\n",
    "                datarep('★ I.Bal >= 10000 ','I.Bal < 1 Crore ★')\n",
    "                \n",
    "    def amtmang(i,b,v,a,p,c):\n",
    "        files.execute(\"update devcus set balance ='{}' where cusid='{}'\".format(b,i))\n",
    "        mycon.commit()\n",
    "        if p=='Add':\n",
    "            files.execute(\"insert into acstatement(cusid,description,chqnum,Deposit,operation,trandate,trantime,balance) values(%s,%s,%s,%s,%s,%s,%s,%s)\"\\\n",
    "                                  ,(i,v,c,a,p,dt()[0],dt()[1],str(b)))\n",
    "        else:\n",
    "            files.execute(\"insert into acstatement(cusid,description,chqnum,Withdrawn,operation,trandate,trantime,balance) values(%s,%s,%s,%s,%s,%s,%s,%s)\"\\\n",
    "                                  ,(i,v,c,a,p,dt()[0],dt()[1],str(b)))\n",
    "        mycon.commit()\n",
    "        if v != 'Def.Chg. 5%' and v!='Service Chg. 0.5%':\n",
    "            if '+Trf By' not in v :\n",
    "                chcdef(i,b,a)\n",
    "                pyg.alert('❖ Transaction Successful ❖ \\n\\n Now Balance\\t: {}'.format(cusbal(i)),'Dev CRM - '+str(i))\n",
    "                design(60,2)\n",
    "                center(colour('❖ Transaction Successful ❖',2))\n",
    "                datarep('Now Balance ➤',cusbal(i))\n",
    "                design(60,2)\n",
    "\n",
    "    def dt():\n",
    "        a=date.today()\n",
    "        b=datetime.now()\n",
    "        b=b.strftime(\"%H:%M:%S\")\n",
    "        return a,b\n",
    "\n",
    "    def minmax(x,y):\n",
    "        df=usdetails('staff',x)\n",
    "        a=df.at[x,'A/C Type']\n",
    "        design(60,2)\n",
    "        if a == 'saving':\n",
    "            if y >= 100 and y < 1000000:\n",
    "                return True\n",
    "            else:\n",
    "                center(colour('❖ For Saving A/C ❖',4))\n",
    "                datarep('• Min Deposit',' >=100')\n",
    "                datarep('• Max Deposit',' < 10 Lakhs')\n",
    "        else:\n",
    "            if y >= 200 and y < 10000000:\n",
    "                return True\n",
    "            else:\n",
    "                center(colour('❖ For Current A/C ❖',4))\n",
    "                datarep('• Min Deposit',' >=200')\n",
    "                datarep('• Max Deposit',' < 1 Crore')\n",
    "        design(60,2)\n",
    "                \n",
    "    def addmoney(x):\n",
    "        ty=acty(x,0)\n",
    "        p=cusbal(x)\n",
    "        design(60,2)\n",
    "        df=usdetails('staff',x)\n",
    "        design(60,2)\n",
    "        datarep('Present Balance ➤',p)\n",
    "        datarep('Account Number  ➤',str(df.at[x,'A/C_Num']))\n",
    "        datarep('A/C Type of Cus ➤',ty)\n",
    "        design(60,2)\n",
    "        c=input('\\n➤ Want to add Money ? 【y/n】 │ ')\n",
    "        if c == 'Y' or c=='y':\n",
    "            a=input('➤ Amount to be Added \\t │ ')\n",
    "            if valn(a)  and nonzero(a) :\n",
    "                a=int(a)\n",
    "                if minmax(x,a):\n",
    "                    design(60,2)\n",
    "                    datarep('Amount in Words │ ',alpha((a)))\n",
    "                    design(60,2)\n",
    "                    center(colour('Deposit in Refrence',4))\n",
    "                    design(60,2)\n",
    "                    datarep('Press 1 ➤','Cash')\n",
    "                    datarep('Press 2 ➤','Cheque')\n",
    "                    datarep('Press 3 ➤','Others')\n",
    "                    datarep('Any Num','Back')\n",
    "                    design(60,2)\n",
    "                    cn=input('\\n● Condition Chosen │ \\t  ')\n",
    "                    design(60,2)\n",
    "                    if valn(cn) :\n",
    "                        cn=int(cn)\n",
    "                        if cn > 3 or cn <= 0:\n",
    "                            center(colour('❖ Back to Main Menu ❖',4))\n",
    "                        else:\n",
    "                            if cn == 1:\n",
    "                                t='Cash Deposit'\n",
    "                                b=p+a\n",
    "                                amtmang(x,b,t,str(a),'Add','0')\n",
    "                            elif cn == 2:\n",
    "                                design(60,2)\n",
    "                                c=input('\\n➤ Cheque No. \\t│ ')\n",
    "                                y=input('➤ Bank Name. in short form e.g. SBI \\t│ ')\n",
    "                                design(60,2)\n",
    "                                if valn(c)  and nonzero(c) :\n",
    "                                    y=y.upper()\n",
    "                                    if vals(y.replace(' ','')) :\n",
    "                                        t=y+' Cheq No.' + c\n",
    "                                        b=p+a\n",
    "                                        amtmang(x,b,t,str(a),'Add',c)\n",
    "                            elif cn == 3:\n",
    "                                design(60,2)\n",
    "                                c=input(\"\\nRef. (No Special Character)\\t │ \")\n",
    "                                if vals(c.replace(' ','')) :\n",
    "                                    design(60,2)\n",
    "                                    b=p+a\n",
    "                                    amtmang(x,b,c.upper(),str(a),'Add','0')\n",
    "                            else:\n",
    "                                center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                design(60,2)\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('❖ Back to Main Menu ❖',4))\n",
    "            design(60,2)\n",
    "#        This is For Charging Interest >> below:     \n",
    "    def cg(x,a):\n",
    "        p=cusbal(x)\n",
    "        cg=a//100*0.5\n",
    "        design(60,2)\n",
    "        datarep('Service Chg.(0.5%) Deducted ➤',cg)\n",
    "        design(60,2)\n",
    "        p=p-cg\n",
    "        amtmang(x,p,'Service Chg. 0.5%',str(cg),'Less','0')\n",
    "        \n",
    "    def validation(x):\n",
    "        center(colour('❖ Validation Started ❖',5))\n",
    "        a=input('● Enter Your Dev A/C Number │ ')\n",
    "        if valn(a) :\n",
    "            df=usdetails('staff',x)\n",
    "            if df.at[x,'A/C_Num'] == int(a):\n",
    "                b=input('● Enter Your Regd. Mob. No. │ ')\n",
    "                if valn(b) :\n",
    "                    if df.at[x,'Phone'] == int(b):\n",
    "                        u=input('● Enter Your Aadhar Card No. │ ')\n",
    "                        if valn(b)  and df.at[x,\"UAID (Aadhar No.)\"] ==int(u):\n",
    "                            design(60,2)\n",
    "                            center(colour('❖ As Per Given Details ❖',2))\n",
    "                            datarep('Name    ➤',df.at[x,'Name'])\n",
    "                            datarep('CutID   ➤',x)\n",
    "                            datarep('A/C NO. ➤',a)\n",
    "                            datarep('Mob. No.➤',b)\n",
    "                            design(60,2)\n",
    "                            return True\n",
    "                        else:\n",
    "                            design(60,2)\n",
    "                            center(colour('❌❌ Validation Failed ❌❌',1))\n",
    "                            design(60,2)\n",
    "                            return False\n",
    "                    else:\n",
    "                        design(60,2)\n",
    "                        center(colour('❌❌ Validation Failed ❌❌',1))\n",
    "                        design(60,2)\n",
    "                        return False\n",
    "            else:\n",
    "                design(60,2)\n",
    "                center(colour('❌❌ Validation Failed ❌❌',1))\n",
    "                design(60,2)\n",
    "                return False\n",
    "                \n",
    "    def defchg(x,a):\n",
    "        p=cusbal(x)\n",
    "        cg=a//100*5\n",
    "        design(60,2)\n",
    "        print('\\n\\t Minimum Bal. Defaulting Charges ➤',cg)\n",
    "        design(60,2)\n",
    "        p=p-cg\n",
    "        amtmang(x,p,'Def.Chg. 5%',str(cg),'Less','0')\n",
    "        \n",
    "    def chcdef(x,b,a):\n",
    "        a=int(a)\n",
    "        t=acty(x,0)\n",
    "        if t =='saving' and b<2000 or t =='current' and b<10000:\n",
    "            design(60,2)\n",
    "            center(colour('◆ As A/C Balance < Minimum Balance',1))\n",
    "            center(colour('◆ Rate of Int. will charge @ 5%',1))\n",
    "            design(60,2)\n",
    "            defchg(x,a)\n",
    "            \n",
    "    def suspension(x):\n",
    "        ty=acty(x,0)\n",
    "        if ty == 'saving':\n",
    "            if cusbal(x) < 100 :\n",
    "                return True\n",
    "            else:\n",
    "                return False\n",
    "\n",
    "        else:\n",
    "            if cusbal(x) < 1000:\n",
    "                return True\n",
    "            else:\n",
    "                return False\n",
    "\n",
    "    def lessmoney(x):\n",
    "        p=cusbal(x)\n",
    "        ty=acty(x,0)\n",
    "        df=usdetails('staff',x)\n",
    "        design(60,2)\n",
    "        datarep('Present Balance ➤',p)\n",
    "        datarep('Account Number  ➤',str(df.at[x,'A/C_Num']))\n",
    "        datarep('A/C Type of Cus ➤',ty)\n",
    "        design(60,2)\n",
    "        c=input('\\n➤ Want to Deduct Amount ? 【y/n】 │ ')\n",
    "        if c == 'Y' or c=='y':\n",
    "            a=input('Amount to be Deducted \\t│ ')\n",
    "            if valn(a)  and nonzero(a) :\n",
    "                design(60,2)\n",
    "                datarep('Amount in Words │ ',alpha(a))\n",
    "                design(60,2)\n",
    "                a=int(a)\n",
    "                if a >=100:\n",
    "                    if a < p:\n",
    "                        center(colour('Deducted in Refrence',4))\n",
    "                        design(60,2)\n",
    "                        datarep('Press 1 ➤','Withdrwn Cash')\n",
    "                        datarep('Press 2 ➤','Self_Cheq/DD')\n",
    "                        datarep('Press 3 ➤','Transfer')\n",
    "                        datarep('Press 4 ➤','NEFT/RTGS')\n",
    "                        datarep('Press 5 ➤','Others')\n",
    "                        datarep('Any Num','Back')\n",
    "                        design(60,2)\n",
    "                        cn=input('\\n● Condition Chosen │ \\t  ')\n",
    "                        design(60,2)\n",
    "                        if valn(cn) :\n",
    "                            cn=int(cn)\n",
    "                            if cn > 5 or cn <= 0:\n",
    "                                center(colour('❖ Back to Main Menu ❖',4))\n",
    "                            else:\n",
    "                                if cn == 1:\n",
    "                                    t='Cash Wihdrawn'\n",
    "                                    b=p-a\n",
    "                                    amtmang(x,b,t,str(a),'Less','0')\n",
    "                                else:\n",
    "                                    if cn == 2:\n",
    "                                        design(60,2)\n",
    "                                        c=input('\\n● Cheque No. \\t│ ')\n",
    "                                        design(60,2)\n",
    "                                        if valn(c)  and nonzero(c) :\n",
    "                                            if cheqnum(x,c) :\n",
    "                                                df=blchq(x,'h')\n",
    "                                                if c in df.index:\n",
    "                                                    design(60,2)\n",
    "                                                    t='Cheque No. 【'+c+'】 is TERMINATED/BLOCK \\n'+\\\n",
    "                                                    'As per Account Holder Wish \\n'+ '❖ Changes Unmade Yet ❖'\n",
    "                                                    pyg.alert(t,'Dev CRM')\n",
    "                                                    center(colour('✋ This Cheque is Termminated ✋',1))\n",
    "                                                    center(colour('● As per Account Holder',6))\n",
    "                                                    center(colour('❖ Changes Unmade ❖',4))\n",
    "                                                    design(60,2)\n",
    "                                                else:\n",
    "                                                    if ty=='saving':\n",
    "                                                        t='Cheq. '+ c\n",
    "                                                        b=p-a\n",
    "                                                        amtmang(x,b,t,str(a),'Less',c)\n",
    "                                                        cg(x,a)\n",
    "                                                    else:\n",
    "                                                        t='Cheq. '+ c\n",
    "                                                        b=p-a\n",
    "                                                        amtmang(x,b,t,str(a),'Less',c)\n",
    "                                    elif cn==3:\n",
    "                                        design(60,2)\n",
    "                                        c=input('\\n● Cheque No. \\t│ ')\n",
    "                                        design(60,2)\n",
    "                                        if valn(c)  and nonzero(c) :\n",
    "                                            if cheqnum(x,c) :\n",
    "                                                transfund(x,'s',str(a),c)\n",
    "                                    elif cn == 4:\n",
    "                                        design(60,2)\n",
    "                                        c=input('\\n● Cheque No. \\t│ ')\n",
    "                                        design(60,2)\n",
    "                                        if valn(c)  and nonzero(c) :\n",
    "                                            if cheqnum(x,c) :\n",
    "                                                c2=input('● Ref to. (No Special Character) \\t│ ')\n",
    "                                                if int(c) > 0 and vals(c2.replace(' ',''))  and c2 !='' or c2 !=' ':\n",
    "                                                    if ty=='saving':\n",
    "                                                        t='NEFT/RTGS ' + c2\n",
    "                                                        b=p-a\n",
    "                                                        amtmang(x,b,t,str(a),'Less',c)\n",
    "                                                        cg(x,a)\n",
    "                                                    else:\n",
    "                                                        t='NEFT/RTGS ' + c2\n",
    "                                                        b=p-a\n",
    "                                                        amtmang(x,b,t,str(a),'Less',c)\n",
    "                                                else:\n",
    "                                                    design(60,2)\n",
    "                                                    center(colour('❖ Invalid Data has Given ❖',1))\n",
    "                                                    design(60,2)\n",
    "\n",
    "                                    else:\n",
    "                                        design(60,2)\n",
    "                                        c=input('\\n● Ref to \\t│ ')\n",
    "                                        design(60,2)\n",
    "                                        if valn(c) is False:\n",
    "                                            c=c.upper()\n",
    "                                            if ty=='saving':\n",
    "                                                b=p-a\n",
    "                                                amtmang(x,b,c,str(a),'Less','0')\n",
    "                                                cg(x,a)\n",
    "                                            else:\n",
    "                                                b=p-a\n",
    "                                                amtmang(x,b,c,str(a),'Less','0')\n",
    "                    else:\n",
    "                        design(60,2)\n",
    "                        datarep('● Maximum Drawing < ',p)\n",
    "                        design(60,2)\n",
    "                else:\n",
    "                    design(60,2)\n",
    "                    center(colour('● Minimum Drawing ➤ 100 ',1))\n",
    "                    design(60,2)\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('❖ Back to Main Menu ❖',4))\n",
    "            design(60,2)\n",
    "            \n",
    "    def chcacnum(a):\n",
    "        files.execute(\"select cusid,acnum,ac_type,name,balance from devcus where acnum = '{}'\".format(a))\n",
    "        dt=files.fetchall()\n",
    "        if dt == []:\n",
    "            return False\n",
    "        else:\n",
    "            df=pd.DataFrame(dt,columns=[\"Cusid\",\"A/C Num\",\"A/C Type\",\"Name\",\"Balance\"])\n",
    "            df.set_index('A/C Num',inplace=True)\n",
    "            return df\n",
    "            \n",
    "    def transfund(x,y,a,i):\n",
    "        p=cusbal(x)\n",
    "        ty=acty(x,0)\n",
    "        dfx=usdetails('staff',x)\n",
    "        if valn(a)  and nonzero(a) :\n",
    "            a=int(a)\n",
    "            if a >=100:\n",
    "                if a < p:\n",
    "                    design(60,2)\n",
    "                    if i=='0' and y!='s':\n",
    "                        b=input('\\n● Enter Beneficiary Account Number │ ')\n",
    "                    elif i!='0' or y=='s':\n",
    "                        print('● Enter Beneficiary Account Number : ',end='')\n",
    "                        b='3058'+input('3058')\n",
    "                    design(60,2)\n",
    "                    if valn(b)  and nonzero(b) :\n",
    "                        if y == 's':\n",
    "                            if chcacnum(b) is not False:\n",
    "                                design(60,2)\n",
    "                                df=chcacnum(b)\n",
    "                                if df.at[int(b),'Cusid'] != x:\n",
    "                                    datarep('Name',df.at[int(b),'Name'])\n",
    "                                    datarep('A/C Type',df.at[int(b),'A/C Type'])\n",
    "                                    design(60,2)\n",
    "                                    c=input('\\n➤ Want to Benefit Amount ? 【y/n】 │ ')\n",
    "                                    if c == 'Y' or c=='y':\n",
    "                                        c='-Trf To '+ df.at[int(b),'Name'] + ' ' + b\n",
    "                                        t=datetime.now()\n",
    "                                        y=p-a\n",
    "                                        if i=='0':\n",
    "                                            receipt(int(b),df.at[int(b),'Name'],a,t.strftime(\"%H:%M:%S\"),d.strftime(\"%A, %B %d\"),'Dev Bank')\n",
    "                                            amtmang(x,y,c,a,'Less','0')\n",
    "                                        else:\n",
    "                                            amtmang(x,y,c,a,'Less',i)\n",
    "                                        c='+Trf By '+ dfx.at[x,'Name'] + ' ' + str(dfx.at[x,'A/C_Num']) \n",
    "                                        y=df.at[int(b),'Balance']\n",
    "                                        y=y+a\n",
    "                                        if i=='0':\n",
    "                                            amtmang(df.at[int(b),'Cusid'],y,c,a,'Add','0')\n",
    "                                        else:\n",
    "                                            amtmang(df.at[int(b),'Cusid'],y,c,a,'Add',i)\n",
    "                                        design(60,2) \n",
    "                                        center(colour('❖ Amount Transfer Successfully ❖',2))\n",
    "                                        datarep(b+' Credited',a)\n",
    "                                        design(60,2)\n",
    "                                        if i=='0':\n",
    "                                            t='❖ Amt. Transfer Successfully ❖' + '\\n'+ b +' Credited' + str(a)\n",
    "                                            pyg.alert(t,'Dev CRM -'+ str(x))\n",
    "                                        if ty=='saving':\n",
    "                                            cg(x,a)\n",
    "                                    else:\n",
    "                                        design(60,2)\n",
    "                                        center(colour('❖ Transaction Terminated ❖',1))\n",
    "                                        design(60,2)\n",
    "                                else:\n",
    "                                    design(60,2)\n",
    "                                    center(colour(\"❖ You Can't Benefit Your Own A/C ❖\",1))\n",
    "                                    design(60,2)\n",
    "                            else:\n",
    "                                design(60,2)\n",
    "                                center(colour('❖ No Such Dev Account Found ❖',1))\n",
    "                                design(60,2)\n",
    "                        else:\n",
    "                            if chcacnum(b) is False:\n",
    "                                if len(b) >= 9 and len(b) <= 18:\n",
    "                                    df=chcacnum(b)\n",
    "                                    if b!= dfx.at[x,'A/C_Num']:\n",
    "                                        design(60,2)\n",
    "                                        c=input('\\n➤ Want to Benefit Amount ? 【y/n】 │ ')\n",
    "                                        design(60,2)\n",
    "                                        if c == 'Y' or c=='y':\n",
    "                                            c='-To '+ b\n",
    "                                            y=p-a\n",
    "                                            t=datetime.now()\n",
    "                                            receipt(int(b),'Unknown',a,t.strftime(\"%H:%M:%S\"),d.strftime(\"%A, %B %d\"),'UnKnown')\n",
    "                                            amtmang(x,y,c,a,'Less','0')\n",
    "                                            design(60,2)\n",
    "                                            center(colour('❖ Amount Transfer Successfully ❖',2))\n",
    "                                            datarep(b+' Credited',a)\n",
    "                                            design(60,2)\n",
    "                                            t='❖ Amt. Transfer Successfully ❖' + '\\n'+ b+' Credited' + str(a)\n",
    "                                            pyg.alert(t,'Dev CRM - '+str(x))\n",
    "                                            if ty=='saving':\n",
    "                                                cg(x,a)\n",
    "                                else:\n",
    "                                    design(60,2)\n",
    "                                    center(colour('❖ Invalid A/C Number has given ❖',1))\n",
    "                                    design(60,2)\n",
    "                            else:\n",
    "                                design(60,2)\n",
    "                                center(colour('✋ Given A/C No. is of Dev Bank ✋',1))\n",
    "                                center(colour('● Kindly Choose 1. Option - ',2))\n",
    "                                center(colour(\"★ 'Benefit same Bank' ★\",4))\n",
    "                                design(60,2)\n",
    "\n",
    "                else:\n",
    "                    design(60,2)\n",
    "                    center(colour('❖ Balance Defeciency Occurs ❖',1))\n",
    "                    design(60,2)\n",
    "\n",
    "            else:\n",
    "                design(60,2)\n",
    "                center(colour('❖ Minimum Fund tranfer > = 100 ❖',1))\n",
    "                design(60,2)\n",
    "\n",
    "    def save(x,t):\n",
    "        design(60,2)\n",
    "        b=input('\\n● Enter the Name of the Document │ \\t ')\n",
    "        design(60,2)\n",
    "        if t == 'ac':\n",
    "            d=boot_data(3)+'Dev Bank\\ACC Statement'\n",
    "            p=os.path.join(d,b+'.csv')\n",
    "        else:\n",
    "            d=boot_data(3)+\"Dev Bank\\Others\"\n",
    "            p=os.path.join(d,b+'.csv')\n",
    "        if os.path.exists(p):\n",
    "            design(60,2)\n",
    "            center(colour('❖ File Name Already Exists ❖',1))\n",
    "            design(60,2)\n",
    "            design(60,2)\n",
    "            a=input('\\n➤ Want to Replace or Overwrite ? 【y/n】 │ ')\n",
    "            design(60,2)\n",
    "            if vals(a)  :\n",
    "                if a=='y' or a=='Y':\n",
    "                    x.to_csv(p)\n",
    "                    design(60,2)\n",
    "                    center(colour('❖ Document Save Successfully ❖',2))\n",
    "                    datarep('Document Name ➤',b+'.csv')\n",
    "                    datarep('Path : ',p)\n",
    "                    p=os.path.join(boot_data(3)+'Dev%20Bank/ACC%20Statement',b+'.csv')\n",
    "                    webbrowser.open('file:///'+p)\n",
    "                    design(60,2)\n",
    "                else:\n",
    "                    design(60,2)\n",
    "                    center(colour('✌ Try Again with Different Name ✌',4))\n",
    "                    design(60,2)\n",
    "        else:\n",
    "            x.to_csv(p)\n",
    "            design(60,2)\n",
    "            center(colour('❖ Document Save Successfully ❖',1))\n",
    "            datarep('Document Name ➤',b+'.csv')\n",
    "            datarep('Path : ',p)\n",
    "            p=os.path.join(boot_data(3)+'Dev%20Bank/ACC%20Statement',b+'.csv')\n",
    "            webbrowser.open('file:///'+p)\n",
    "            design(60,2)\n",
    "    \n",
    "    def receipt(x,y,z,a,d,b):\n",
    "        t='Dev Bank CRM \\n Kapurthala Road Jalandhar \\n Transfer Memo as per Tansac.\\n\\n Benef. Bank : ' + b +\\\n",
    "        '\\n Benef. A/C  : ' + str(x) + '\\n Benef. Name : ' + y + '\\n Amount(fig) : ' + str(z) + \\\n",
    "        '\\n Amount(wrd) : ' + alpha(str(z)) + '\\n Trnsc. Time : ' + str(a) + '\\n Trnsc. Date : ' + str(d) +\\\n",
    "        '\\n Thanks for Operation'\n",
    "        \n",
    "        pyg.alert(t,'Dev Bank CRM - '+ str(x))\n",
    "        time.sleep(0.5)\n",
    "        \n",
    "    def hasE(cusid):\n",
    "        df=usdetails('now',cusid)\n",
    "        if df.at[cusid,'Status']==1:\n",
    "            return True\n",
    "        else:\n",
    "            return False\n",
    "        \n",
    "    def calculateAge(birthDate):\n",
    "        today = date.today() \n",
    "        age = today.year - birthDate.year - ((today.month, today.day) < (birthDate.month, birthDate.day)) \n",
    "        return age\n",
    "    def addcus():\n",
    "        design(60,2)\n",
    "        datarep('Press S ➤','Saving A/C')\n",
    "        datarep('Press C ➤','Current A/C')\n",
    "        design(60,2)\n",
    "        design(60,2)\n",
    "        cond=input('\\nA/C Type \\t│ ')\n",
    "        design(60,2)\n",
    "        center(colour('★ Be Sure Any Error ★',4))\n",
    "        center(colour('➤ will make System ➤',4))\n",
    "        center(colour('All entered data erase',4))\n",
    "        design(60,2)\n",
    "        if cond == 'S' or cond=='s':\n",
    "            s=1\n",
    "            typ='saving'\n",
    "        elif cond == 'C' or cond=='c':\n",
    "            s=2\n",
    "            typ='current'\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('❌ Wrong Condition Chosen ❌',1))\n",
    "            design(60,2)\n",
    "            s=3\n",
    "            return s\n",
    "        if s!=3:\n",
    "            while True:\n",
    "                design(60,2)\n",
    "                nam=input('\\n● Enter Full Name of the person│ ')\n",
    "                if vals(nam.replace(' ','')) :\n",
    "                    nam=nam.capitalize()\n",
    "                    dob=input('● D.O.B YYYY-MM-DD (Age >=18 and < 80) │ ')\n",
    "                    if is_date(dob) :\n",
    "                        dob2=dob.replace('-',',')\n",
    "                        dob2=datetime.strptime(dob2,'%Y,%m,%d').date()\n",
    "                        age=calculateAge(dob2)\n",
    "                        if age >= 80 or age < 18:\n",
    "                            center(colour('★ Age > 80 and < 18 is not allowed ★',1))\n",
    "                        else:\n",
    "                            uaid=input('● UAID (Aadhar Card No.) │ ')\n",
    "                            if unique('UAID (Aadhar No.)',int(uaid)):\n",
    "                                if valcon(uaid,12)  and valn and nonzero(uaid) :\n",
    "                                    gen=input(\"● Gender M/F : \")\n",
    "                                    if gen == 'm' or gen=='M' or gen == 'F' or gen == 'f':\n",
    "                                        gen=gen.upper()\n",
    "                                        phn=input(\"● Contact No. : \")\n",
    "                                        if valn(phn)  and valcon(phn,10)  and nonzero(phn) :\n",
    "                                            phn=int(phn)\n",
    "                                            design(60,2)\n",
    "                                            if cond == 'S' or cond == 's':\n",
    "                                                center(colour('Minimum Saving A/C Bal.',4))\n",
    "                                                datarep(' >= 2000 ',' <=1 Lakh')\n",
    "                                            else:\n",
    "                                                center(colour('Minimum Current A/C Bal.',4))\n",
    "                                                datarep(' >= 10000 ',' <=10 Lakh')\n",
    "                                            design(60,2)\n",
    "                                            bal=input('● Enter the initial Amount│ ')\n",
    "                                            if valn(bal)  and nonzero(bal) :\n",
    "                                                bal=int(bal)\n",
    "                                                if chcbal(bal,typ) :\n",
    "                                                    design(60,2)\n",
    "                                                    datarep('Amount in Words │ ',alpha(str(bal)))\n",
    "                                                    design(60,2)\n",
    "                                                    acnum=''\n",
    "                                                    devid='dev'\n",
    "                                                    digits = \"987456154542525874\"\n",
    "                                                    for i in range(4):\n",
    "                                                        acnum+=digits[math.floor(random.random() * 10)]\n",
    "                                                    for i in range(4) :\n",
    "                                                        devid += digits[math.floor(random.random() * 10)]\n",
    "                                                    acnum=int('3058'+acnum)\n",
    "                                                    files.execute(\"insert into devcus(cusid,acnum,ac_type,name,age,gender,phone,balance,crdate,crtime,uaid,dob) values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)\"\\\n",
    "                                                                  ,(devid,acnum,typ,nam,age,gen,phn,bal,dt()[0],dt()[1],int(uaid),dob))\n",
    "                                                    mycon.commit()\n",
    "                                                    files.execute(\"insert into acstatement(cusid,description,Deposit,trandate,trantime,balance,operation) values(%s,%s,%s,%s,%s,%s,%s)\"\\\n",
    "                                                                  ,(devid,'Initial Amount',str(bal),dt()[0],dt()[1],str(bal),'Add'))\n",
    "                                                    mycon.commit()\n",
    "                                                    t='Customer Created Successfully ! \\n\\n '+\\\n",
    "                                                    'Account Type : '+typ+'\\n\\n'+\\\n",
    "                                                    'Cust. Credentials :- '+'\\n'+\\\n",
    "                                                    'Customer Id : '+devid+'\\n'+\\\n",
    "                                                    'A/C Number  : '+str(acnum)+'\\n\\n'+\\\n",
    "                                                    'Cust. General Info :- '+'\\n'+\\\n",
    "                                                    'Name : '+nam+'\\n'+\\\n",
    "                                                    'UAID :'+str(uaid)+'\\n'+\\\n",
    "                                                    'D.O.B :'+str(dob)+'\\n'+\\\n",
    "                                                    'Age  : '+str(age)+'\\n'+\\\n",
    "                                                    'Gend : '+gen+'\\n'+\\\n",
    "                                                    'Mob. : '+str(phn)+'\\n'+\\\n",
    "                                                    'Balance : '+str(bal) +' : '+ alpha(str(bal))+'\\n'\n",
    "                                                    pyg.alert(t,'Dev Bank CRM')\n",
    "                                                    acstatus=True\n",
    "                                                    return acstatus,devid\n",
    "                                                    break\n",
    "                                    else:\n",
    "                                        design(60,2)\n",
    "                                        center(colour(\"★ Gender Either M/F or m/f ★\",1))\n",
    "                                        design(60,2)\n",
    "                            else:\n",
    "                                design(60,2)\n",
    "                                center(colour(\"★ Duplicacy of UAID Occurs ★\",1))\n",
    "                                design(60,2)\n",
    "                                \n",
    "                    else:\n",
    "                        design(60,2)\n",
    "                        center(colour(\"★ Wrong D.O.B has Given ★\",1))\n",
    "                        design(60,2)\n",
    "                else:\n",
    "                    design(60,2)\n",
    "                    center(colour(\"★ Changes Unmade Yet ★\",1))\n",
    "                    design(60,2)\n",
    "                    return False,'not'\n",
    "                    break\n",
    "    design(60,2)\n",
    "    center(colour('♕ Welcome to Dev Bank',4)),center(colour('The Bank of Technical Era',2))\n",
    "    design(60,2)\n",
    "    d=date.today()\n",
    "    t=datetime.now()\n",
    "    print(\"\\nDATE:-\",d.strftime(\"%A, %B %d\"),\"\\t   TIME:-\",t.strftime(\"%H:%M:%S\"))\n",
    "    design(60,2)\n",
    "    a=os.path.getmtime('Dev Bank.ipynb')\n",
    "    datarep('Last Visit ',time.ctime(a))\n",
    "    design(60,2)\n",
    "    while True:\n",
    "        if start3 :\n",
    "            datarep('Press 1 ➤','Login/Apply E-Banking')\n",
    "            datarep('Press 0 ➤','System Exit')\n",
    "            datarep('Any Num ➤','Read T&C')\n",
    "            design(60,2)\n",
    "            center(colour('★ You have Agreed ours T&C ★',2))\n",
    "            design(60,2)\n",
    "            time.sleep(0.1)\n",
    "            design(60,2)\n",
    "            st=input(\"\\n● Condition Chosen  : \")\n",
    "            if valn(st) :\n",
    "                if int(st) == 1:\n",
    "                    design(60,2)\n",
    "                    x=input(\"\\n\\t♕ User Id\\t➤\\t\\t\")\n",
    "                    response=chcid(x)\n",
    "                    if response[0] :\n",
    "                        if response[1] == 'staff':\n",
    "                            pasw=getpass('\\t♕ Key\\t\\t➤\\t\\t')\n",
    "                            design(60,2)\n",
    "                            response2=login(x,response[1],pasw)\n",
    "                            if response2 :\n",
    "                                while True:\n",
    "                                    design(60,2)\n",
    "                                    df=staffdetails()\n",
    "                                    print('\\n\\t\\t♕ Welcome',df.at[x,'name'],'【{}】'.format(df.at[x,'post']))\n",
    "                                    design(60,2)\n",
    "                                    datarep('Press 1 ➤','Add New Customer')\n",
    "                                    datarep('Press 2 ➤','Change Password')\n",
    "                                    datarep('Press 3 ➤','View Cust. Details')\n",
    "                                    datarep('Press 4 ➤','Update Cust.Details')\n",
    "                                    datarep('Press 5 ➤','Update Balances')\n",
    "                                    datarep('Press 6 ➤','See Apllications')\n",
    "                                    datarep('Press 7 ➤','A/C Statements')\n",
    "                                    datarep('Any Num ➤','Exit')\n",
    "                                    design(60,2)\n",
    "                                    cn2=input(\"\\n● Condition Chosen │ \\t\")\n",
    "                                    if valn(cn2) :\n",
    "                                        cn2=int(cn2)\n",
    "                                        design(60,2)\n",
    "                                        if cn2 == 1:\n",
    "                                            if chcauth(x,'addcus') :\n",
    "                                                response2=addcus()\n",
    "                                                if response2 !=3:\n",
    "                                                    if response2[0] :\n",
    "                                                        design(60,2)\n",
    "                                                        center(colour('❖ Account Crtd. Successfully ❖',2))\n",
    "                                                        design(60,2)\n",
    "                                                        time.sleep(0.1)\n",
    "                                                        response=usdetails('staff',response2[1])\n",
    "                                                        print(response)\n",
    "                                        elif cn2 == 2:\n",
    "                                            df1=staffdetails()\n",
    "                                            p=df1.at[x,'key']\n",
    "                                            changepsw(p,x,1,False)\n",
    "                                        elif cn2 == 3:\n",
    "                                            design(60,2)\n",
    "                                            datarep(\"Type 'devs' ➤\",'For all')\n",
    "                                            print('● Enter Customer ID │ ',end='')\n",
    "                                            c='dev'+input('dev')\n",
    "                                            if c=='devs':\n",
    "                                                design(60,2)\n",
    "                                                response=usdetails('staff','a')\n",
    "                                                design(60,2)\n",
    "                                                center(colour('✤ Accounts Details ✤',5))\n",
    "                                                design(60,2)\n",
    "                                                design(60,2)\n",
    "                                                print(response)\n",
    "                                                time.sleep(0.1)\n",
    "                                                cn=input('\\n➤ Want to Save this Data 【y/n】 │ ')\n",
    "                                                if cn == 'Y' or cn=='y':\n",
    "                                                    save(response,'ad')\n",
    "                                                    design(60,2)\n",
    "                                                else:\n",
    "                                                    design(60,2)\n",
    "                                                    center(colour('✤ Proposal Rejected ✤',6))\n",
    "                                                    design(60,2)\n",
    "                                            else:\n",
    "                                                response=chcid(c)\n",
    "                                                if response[0]  and response[1] == 'cus':\n",
    "                                                    design(60,2)\n",
    "                                                    response=usdetails('staff',c)\n",
    "                                                    design(60,2)\n",
    "                                                    center(colour('✤ Accounts Details ✤',5))\n",
    "                                                    design(60,2)\n",
    "                                                    design(60,2)\n",
    "                                                    print(response)\n",
    "                                                    time.sleep(0.1)\n",
    "                                                    design(60,2)\n",
    "                                        elif cn2 == 4:\n",
    "                                            if chcauth(x,'updcus') :\n",
    "                                                design(60,2)\n",
    "                                                center(colour('✤ Things Can be Updated ✤',4))\n",
    "                                                design(60,2)\n",
    "                                                datarep('Press 1 ➤','A/C Type')\n",
    "                                                datarep('Press 2 ➤','Phone')\n",
    "                                                datarep('Any Num ➤','Back')\n",
    "                                                design(60,2)\n",
    "                                                cn=input('\\n● Condition Chosen │ \\t  ')\n",
    "                                                if valn(cn) :\n",
    "                                                    cn=int(cn)\n",
    "                                                    if cn > 2 or cn <= 0:\n",
    "                                                        center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                    else:\n",
    "                                                        print('● Enter Customer ID │ ',end='')\n",
    "                                                        c='dev'+input('dev')\n",
    "                                                        response=chcid(c)\n",
    "                                                        if response[0]  and response[1] == 'cus':\n",
    "                                                            if cn == 1:\n",
    "                                                                response=acty(c,0)\n",
    "                                                                bal=cusbal(c)\n",
    "                                                                if response == 'saving' and bal>=10000:\n",
    "                                                                    design(60,2)\n",
    "                                                                    datarep('At Present ➤','Saving A/c')\n",
    "                                                                    design(60,2)\n",
    "                                                                    d=input('\\n● Convert Saving A/C to Current A/C - 【y/n】 │ ')\n",
    "                                                                    if d =='Y' or d=='y':\n",
    "                                                                        acty(c,1)\n",
    "                                                                        design(60,2)\n",
    "                                                                        pyg.alert('Successfuly Converted to Current A/c','Dev Staff - '+ str(x))\n",
    "                                                                        center(colour('❖ Successfuly Converted to Current A/c ❖',2))\n",
    "                                                                        design(60,2)\n",
    "                                                                        time.sleep(0.1)\n",
    "                                                                    else:\n",
    "                                                                        design(60,2)\n",
    "                                                                        center(colour('❖ Changes unmade Yet ❖',4))\n",
    "                                                                        design(60,2)\n",
    "                                                                elif response == 'current' and bal>=2000:\n",
    "                                                                    design(60,2)\n",
    "                                                                    datarep('At Present ➤','Current A/c')\n",
    "                                                                    design(60,2)\n",
    "                                                                    d=input('\\n● Convert Current A/C to Saving A/C - 【y/n】 │ ')\n",
    "                                                                    if d =='Y' or d=='y':\n",
    "                                                                        acty(c,1)\n",
    "                                                                        design(60,2)\n",
    "                                                                        pyg.alert('Successfuly Converted to Saving A/c','Dev Staff - '+ str(x))\n",
    "                                                                        center(colour('❖ Successfuly Converted to Saving A/c ❖',2))\n",
    "                                                                        design(60,2)\n",
    "                                                                        time.sleep(0.1)\n",
    "                                                                    else:\n",
    "                                                                        design(60,2)\n",
    "                                                                        center(colour('✌ Changes Yet Unmade ✌',4))\n",
    "                                                                        design(60,2)\n",
    "                                                                else:\n",
    "                                                                    design(60,2)\n",
    "                                                                    pyg.alert('Balance Insufficient for Conversion','Dev Staff - '+ str(x))\n",
    "                                                                    center(colour('❖ Balance Insufficient for Conversion ❖',1))\n",
    "                                                                    design(60,2)\n",
    "                                                                    design(60,2)\n",
    "                                                                    datarep('current ➤','Bal>=10000')\n",
    "                                                                    datarep('Saving  ➤','Bal>=2000')\n",
    "                                                                    design(60,2)\n",
    "\n",
    "                                                            elif cn == 2:\n",
    "                                                                if phnchg(c) :\n",
    "                                                                    design(60,2)\n",
    "                                                                    pyg.alert('Ph. No. Successfully Updated','Dev Staff - '+ str(x))\n",
    "                                                                    center(colour('✌ Ph. No. Successfully Updated ✌',2))\n",
    "                                                                    design(60,2)\n",
    "                                                                    time.sleep(0.1)\n",
    "\n",
    "                                                        else:\n",
    "                                                            design(60,2)\n",
    "                                                            center(colour('❌ Wrong Customer ID has Given ❌',1))\n",
    "                                                            design(60,2)\n",
    "                                                            time.sleep(0.1)\n",
    "                                        elif cn2 == 5:\n",
    "                                            if chcauth(x,'updcash') :\n",
    "                                                design(60,2)\n",
    "                                                center(colour('Things Can be Done',4))\n",
    "                                                design(60,2)\n",
    "                                                datarep('Press 1 ➤','Add Money')\n",
    "                                                datarep('Press 2 ➤','Withdrw Money')\n",
    "                                                datarep('Any Num ➤','Back')\n",
    "                                                design(60,2)\n",
    "                                                cn=input('\\n● Condition Chosen │ \\t  ')\n",
    "                                                if valn(cn) :\n",
    "                                                    cn=int(cn)\n",
    "                                                    if cn > 2 or cn <= 0:\n",
    "                                                        center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                    else:\n",
    "                                                        print('● Enter Customer ID │ ',end='')\n",
    "                                                        c='dev'+input('dev')\n",
    "                                                        response=chcid(c)\n",
    "                                                        if response[0]  and response[1] == 'cus':\n",
    "                                                            if cn == 1:\n",
    "                                                                addmoney(c)\n",
    "                                                                time.sleep(0.2)\n",
    "                                                            else:\n",
    "                                                                lessmoney(c)\n",
    "                                                                time.sleep(0.2)\n",
    "                                        elif cn2 == 6:\n",
    "                                            if chcauth(x,'updcus') :\n",
    "                                                design(60,2)\n",
    "                                                center(colour('❖ E-Applications below ❖',5))\n",
    "                                                design(60,2)\n",
    "                                                df=appldetails()\n",
    "                                                if df.empty:\n",
    "                                                    design(60,2)\n",
    "                                                    center(colour('✤ No Record Found ✤',4))\n",
    "                                                    design(60,2)\n",
    "                                                else:\n",
    "                                                    design(60,2)\n",
    "                                                    print(df)\n",
    "                                                    design(60,2)\n",
    "                                                    datarep('Press 1 ➤','Update Status')\n",
    "                                                    datarep('Any Key ➤','Back')\n",
    "                                                    design(60,2)\n",
    "                                                    cn=input('\\n● Condition Chosen │ \\t  ')\n",
    "                                                    if valn(cn) :\n",
    "                                                        cn=int(cn)\n",
    "                                                        if cn > 2 or cn <= 0:\n",
    "                                                            center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                        else:\n",
    "                                                            print('\\n● Enter Customer ID │ ',end='')\n",
    "                                                            c='dev'+input('dev')\n",
    "                                                            response=chcid(c)\n",
    "                                                            if response[0]  and response[1] == 'cus':\n",
    "                                                                updstatus(c,'Appl','Accepted')\n",
    "                                                                if status(c,'Appl') is False:\n",
    "                                                                    updstatus(c,'ATM','Active')\n",
    "                                        elif cn2==7:\n",
    "                                            print('● Enter Customer ID │ ',end='')\n",
    "                                            c='dev'+input('dev')\n",
    "                                            response=chcid(c)\n",
    "                                            if response[0]  and response[1] == 'cus':\n",
    "                                                acstatement(c,'s')\n",
    "\n",
    "                                        else:\n",
    "                                            leave(x)\n",
    "                                            break\n",
    "                        else:\n",
    "                            if hasE(x) :\n",
    "                                if suspension(x) is False:\n",
    "                                    pasw=getpass('\\t♕ Key\\t\\t➤\\t\\t')\n",
    "                                    design(60,2)\n",
    "                                    response2=login(x,response[1],pasw)\n",
    "                                    if response2 :\n",
    "                                        while True:\n",
    "                                            design(60,2)\n",
    "                                            df=usdetails('staff',x)\n",
    "                                            print('\\n\\t\\t♕ Welcome',df.at[x,'Name'],'【{}】'.format(x))\n",
    "                                            design(60,2)\n",
    "                                            datarep('Press 1 ➤','Your Details')\n",
    "                                            datarep('Press 2 ➤','Change Password')\n",
    "                                            datarep('Press 3 ➤','Online Support')\n",
    "                                            datarep('Press 4 ➤','E-banking')\n",
    "                                            datarep('Any Num ➤','Exit')\n",
    "                                            design(60,2)\n",
    "                                            if int(cusbal(x))>=2000 and acty(x,0) =='saving':\n",
    "                                                if int(cusbal(x)) > 4000:\n",
    "                                                    m=2\n",
    "                                                else:\n",
    "                                                    m=4\n",
    "                                            elif int(cusbal(x))>=10000 and acty(x,0) == 'current':\n",
    "                                                if int(cusbal(x)) > 20000:\n",
    "                                                    m=2\n",
    "                                                else:\n",
    "                                                    m=4\n",
    "                                            else:\n",
    "                                                m=1\n",
    "                                            center(colour('★ Present Balance【 {} 】★'.format(str(cusbal(x))),m))\n",
    "                                            design(60,2)\n",
    "                                            cn2=input(\"\\n● Condition Chosen │ \\t\")\n",
    "                                            design(60,2)\n",
    "                                            if valn(cn2) :\n",
    "                                                cn2=int(cn2)\n",
    "                                                design(60,2)\n",
    "                                                if cn2 > 4 or cn2 <= 0 :\n",
    "                                                    leave(x)\n",
    "                                                    break\n",
    "                                                else:\n",
    "                                                    if cn2 == 1:\n",
    "                                                        df=usdetails('cus',x)\n",
    "                                                        design(60,2)\n",
    "                                                        center(colour('❖ Your Details are below ❖',5))\n",
    "                                                        design(60,2)                             \n",
    "                                                        print(df)\n",
    "                                                        design(60,2)                             \n",
    "                                                        design(60,2)\n",
    "                                                        time.sleep(0.1)\n",
    "                                                    elif cn2 == 2:\n",
    "                                                        df1=usdetails('login',x)\n",
    "                                                        p=df1.at[x,'key']\n",
    "                                                        changepsw(p,x,0,False)\n",
    "                                                    elif cn2 == 3:\n",
    "                                                        design(60,2)\n",
    "                                                        center(colour('✤ Available Online Support ✤',4))\n",
    "                                                        design(60,2)\n",
    "                                                        datarep('Press 1 ➤','ATM Support')\n",
    "                                                        datarep('Press 2 ➤','Request A/C Statement')\n",
    "                                                        datarep('Any Num ➤','Back')\n",
    "                                                        design(60,2)     \n",
    "                                                        cn=input('\\n● Condition Chosen │ ')\n",
    "                                                        design(60,2)    \n",
    "                                                        if valn(cn) :\n",
    "                                                            cn=int(cn)\n",
    "                                                            if cn>2 or cn<=0:\n",
    "                                                                design(60,2)\n",
    "                                                                center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                design(60,2)\n",
    "                                                            else:\n",
    "                                                                if cn == 1:\n",
    "                                                                    df=hasatm()\n",
    "                                                                    if x in df.index:\n",
    "                                                                        while True:\n",
    "                                                                            design(60,2)\n",
    "                                                                            center(colour('✤ Available ATM Support ✤',4))\n",
    "                                                                            design(60,2)\n",
    "                                                                            datarep('Press 1 ➤','Change ATM PIN')\n",
    "                                                                            datarep('Press 2 ➤','ON/OFF ATM Card')\n",
    "                                                                            datarep('Any Num ➤','Back')\n",
    "                                                                            design(60,2)     \n",
    "                                                                            cn=input('● Condition Chosen │ ')\n",
    "                                                                            design(60,2)    \n",
    "                                                                            if valn(cn) :\n",
    "                                                                                cn=int(cn)\n",
    "                                                                                if cn > 2 or cn <= 0:\n",
    "                                                                                    design(60,2)\n",
    "                                                                                    center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                                    design(60,2)\n",
    "                                                                                    break\n",
    "                                                                                else:\n",
    "                                                                                    if cn == 1:\n",
    "                                                                                        df1=atmdetails()\n",
    "                                                                                        p=df1.at[x,'Pin']\n",
    "                                                                                        changepsw(p,x,2,False)\n",
    "                                                                                        time.sleep(0.1)\n",
    "                                                                                    else:\n",
    "                                                                                        if status(x,'Appl.') :\n",
    "                                                                                            if status(x,'ATM') :\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                datarep('ATM Status ➤', 'Active/ON')\n",
    "                                                                                                datarep('Press 1 ➤','Make Unactive/OFF')\n",
    "                                                                                                datarep('Any Key ➤','BacK')\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                cn=input('\\n● Condition Chosen │\\t ')\n",
    "                                                                                                if valn(cn)  :\n",
    "                                                                                                    cn=int(cn)\n",
    "                                                                                                    if cn > 1 or cn <=0:\n",
    "                                                                                                        center(colour('✤ Back to Menu ✤',4))\n",
    "                                                                                                    else:\n",
    "                                                                                                        updstatus(x,'ATM','Unactive')\n",
    "                                                                                                        time.sleep(0.1)\n",
    "                                                                                            else:\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                datarep('ATM Status ➤', 'Unactive/OFF')\n",
    "                                                                                                datarep('Press 1 ➤','Make Active/ON')\n",
    "                                                                                                datarep('Any Key ➤','BacK')\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                cn=input('\\n● Condition Chosen │\\t ')\n",
    "                                                                                                if valn(cn)  :\n",
    "                                                                                                    cn=int(cn)\n",
    "                                                                                                    if cn > 1 or cn <=0:\n",
    "                                                                                                        design(60,2)\n",
    "                                                                                                        center(colour('✤ Back to Menu ✤',4))\n",
    "                                                                                                        design(60,2)\n",
    "                                                                                                    else:\n",
    "                                                                                                        updstatus(x,'ATM','Active')\n",
    "                                                                                                        time.sleep(0.1)\n",
    "                                                                                        else:\n",
    "                                                                                            design(60,2)\n",
    "                                                                                            center(colour('Your ATM is Temporarily OFF',1))\n",
    "                                                                                            center(colour('as application Unccepted Yet',2))\n",
    "                                                                                            center(colour('Wait till it get Accepted',2))\n",
    "                                                                                            design(60,2)\n",
    "                                                                                            time.sleep(0.2)\n",
    "\n",
    "                                                                    else:\n",
    "                                                                        design(60,2)\n",
    "                                                                        center(colour(\"✤ You don't have ATM yet ✤\",4))\n",
    "                                                                        design(60,2)\n",
    "                                                                        time.sleep(0.1)\n",
    "                                                                        design(60,2)\n",
    "                                                                        cn=input('\\n➤ Want to have an ATM Card ? 【y/n】 │ ')\n",
    "                                                                        if vals(cn) :\n",
    "                                                                            if cn == 'Y' or cn == 'y':\n",
    "                                                                                applatm(x)\n",
    "                                                                            else:\n",
    "                                                                                design(60,2)\n",
    "                                                                                center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                                design(60,2)\n",
    "                                                                elif cn == 2:\n",
    "                                                                    design(60,2)\n",
    "                                                                    acstatement(x,'u')                                                                            \n",
    "                                                    else:\n",
    "                                                        design(60,2)\n",
    "                                                        center(colour('✤ Available Facilities ✤',4))\n",
    "                                                        design(60,2)\n",
    "                                                        datarep('Press 1 ➤','Transfer Fund')\n",
    "                                                        datarep('Press 2 ➤','Check Transactions')\n",
    "                                                        datarep('Press 3 ➤','Block Transactions')\n",
    "                                                        datarep('Any Num','Back')\n",
    "                                                        design(60,2)     \n",
    "                                                        cn=input('\\n● Condition Chosen │ ')\n",
    "                                                        design(60,2)    \n",
    "                                                        if valn(cn) :\n",
    "                                                            cn=int(cn)\n",
    "                                                            if cn > 3 or cn <= 0:\n",
    "                                                                design(60,2)\n",
    "                                                                center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                design(60,2)\n",
    "                                                            else:\n",
    "                                                                if cn == 2:\n",
    "                                                                    design(60,2)\n",
    "                                                                    center(colour('✤ Available Options ✤',4))\n",
    "                                                                    design(60,2)\n",
    "                                                                    datarep('Press 1 ➤','Check Acceptance')\n",
    "                                                                    datarep('Press 2 ➤','Check Drwaings')\n",
    "                                                                    datarep('Any Num ➤','Back')\n",
    "                                                                    design(60,2)     \n",
    "                                                                    cn=input('\\n● Condition Chosen │ ')\n",
    "                                                                    design(60,2)    \n",
    "                                                                    if valn(cn) :\n",
    "                                                                        cn=int(cn)\n",
    "                                                                        if cn > 2 or cn <= 0:\n",
    "                                                                            design(60,2)\n",
    "                                                                            center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                            design(60,2)\n",
    "                                                                        else:\n",
    "                                                                            design(60,2)\n",
    "                                                                            datarep('Press 1 ➤','Via Amount')\n",
    "                                                                            datarep('Press 2 ➤','Via Chq.No.')\n",
    "                                                                            datarep('Any Num ➤','Back')\n",
    "                                                                            design(60,2)     \n",
    "                                                                            cn2=input('\\n● Condition Chosen │ ')\n",
    "                                                                            design(60,2)    \n",
    "                                                                            if valn(cn2) :\n",
    "                                                                                cn2=int(cn2)\n",
    "                                                                                if cn2 > 2 or cn2 <= 0:\n",
    "                                                                                    design(60,2)\n",
    "                                                                                    center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                                    design(60,2)\n",
    "\n",
    "                                                                                else:\n",
    "                                                                                    if cn == 1:\n",
    "                                                                                        if cn2 == 1:\n",
    "                                                                                            design(60,2)\n",
    "                                                                                            a=input('\\n● Amount\\t│ ')\n",
    "                                                                                            if valn(a) :\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                amountstatus(x,a,'aa','0')\n",
    "                                                                                                design(60,2)\n",
    "                                                                                        else:\n",
    "                                                                                            design(60,2)\n",
    "                                                                                            a=input('\\n● Cheque No. │ ')                                                    \n",
    "                                                                                            if valn(a) :\n",
    "                                                                                                b=input('● Bank Name in Short form e.g. SBI│ ')\n",
    "                                                                                                if vals(b) :\n",
    "                                                                                                    design(60,2)\n",
    "                                                                                                    amountstatus(x,a,'ac',b)\n",
    "                                                                                                    design(60,2)\n",
    "                                                                                    else:\n",
    "                                                                                        if cn2 == 1:\n",
    "                                                                                            design(60,2)\n",
    "                                                                                            a=input('\\n● Amount\\t│ ')\n",
    "                                                                                            if valn(a) :\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                amountstatus(x,a,'wa','0')\n",
    "                                                                                                design(60,2)\n",
    "                                                                                        else:\n",
    "                                                                                            design(60,2)\n",
    "                                                                                            a=input('\\n● DD/Self cheque \\t│ ')\n",
    "                                                                                            if valn(a) :\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                amountstatus(x,a,'wc','0')\n",
    "                                                                                                design(60,2)\n",
    "\n",
    "                                                                elif cn == 3:\n",
    "                                                                    design(60,2)\n",
    "                                                                    center(colour('✤ Available Options ✤',4))\n",
    "                                                                    design(60,2)\n",
    "                                                                    datarep('Press 1 ➤','Block a Cheque')\n",
    "                                                                    datarep('Press 2 ➤','Block (Back/History)')\n",
    "                                                                    datarep('Any Num ➤','Back')\n",
    "                                                                    design(60,2)     \n",
    "                                                                    cn=input('\\n● Condition Chosen │ ')\n",
    "                                                                    design(60,2)    \n",
    "                                                                    if valn(cn) :\n",
    "                                                                        cn=int(cn)\n",
    "                                                                        if cn > 2 or cn <= 0:\n",
    "                                                                            design(60,2)\n",
    "                                                                            center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                            design(60,2)\n",
    "                                                                        else:\n",
    "                                                                            if cn == 1:\n",
    "                                                                                blchq(x,'b')\n",
    "                                                                            else:\n",
    "                                                                                df=blchq(x,'h')\n",
    "                                                                                if df.empty:\n",
    "                                                                                    design(60,2)\n",
    "                                                                                    center(colour('✤ No Record Found ✤',4))\n",
    "                                                                                    design(60,2)\n",
    "                                                                                else:\n",
    "                                                                                    design(60,2)\n",
    "                                                                                    center(colour('❖ Block Trans. History ❖',4))\n",
    "                                                                                    print(df)\n",
    "                                                                                    design(60,2)\n",
    "                                                                                    center(colour('✤ Things can be done ✤',4))\n",
    "                                                                                    datarep('Press 1 ➤','Block Back')\n",
    "                                                                                    datarep('Press 2 ➤','Save the Data')\n",
    "                                                                                    datarep('Any Key ➤','Back Menu')\n",
    "                                                                                    design(60,2)\n",
    "                                                                                    cn=input('\\n● Condition Chosen │ ')\n",
    "                                                                                    if cn == '1':\n",
    "                                                                                        design(60,2)\n",
    "                                                                                        c=input('\\n● Enter the Cheque Number │ ')\n",
    "                                                                                        if valn(c) :\n",
    "                                                                                            if c in df.index:\n",
    "                                                                                                df=blchq(x,c)\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                print(df)\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                cn=input('\\n➤ Want to back this cheque 【y/n】 │ :')\n",
    "                                                                                                if cn == 'Y' or cn=='y':\n",
    "                                                                                                    files.execute(\"delete from blocktrans where cusid ='{}' and cheqnum ='{}' \".format(x,c))\n",
    "                                                                                                    mycon.commit()\n",
    "                                                                                                    t='Successfully Block Back \\n'+'Chq No. '+str(c)\n",
    "                                                                                                    pyg.alert(t,'Dev CRM-'+str(x))\n",
    "                                                                                                    design(60,2)\n",
    "                                                                                                    center(colour('Successfully Block-Back',2))\n",
    "                                                                                                    design(60,2)\n",
    "                                                                                                else:\n",
    "                                                                                                    design(60,2)\n",
    "                                                                                                    center(colour('✤ Proposal Rejected ✤',6))\n",
    "                                                                                                    design(60,2)\n",
    "                                                                                            else:\n",
    "                                                                                                design(60,2)\n",
    "                                                                                                center(colour('✤ No Block Cheque Found ✤',4))\n",
    "                                                                                                design(60,2)\n",
    "\n",
    "                                                                                    elif cn == '2':\n",
    "                                                                                        cn=input('\\n➤ Want to Save this Data 【y/n】 │ ')\n",
    "                                                                                        if cn == 'Y' or cn=='y':\n",
    "                                                                                            save(df,'ad')\n",
    "                                                                                            design(60,2)\n",
    "                                                                                        else:\n",
    "                                                                                            design(60,2)\n",
    "                                                                                            center(colour('✤ Proposal Rejected ✤',6))\n",
    "                                                                                            design(60,2)\n",
    "                                                                                    else:\n",
    "                                                                                        design(60,2)\n",
    "                                                                                        center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                                        design(60,2)\n",
    "                                                                else:\n",
    "                                                                    design(60,2)\n",
    "                                                                    center(colour('✤ Transfer Fund ✤',4))\n",
    "                                                                    design(60,2)\n",
    "                                                                    datarep('Press 1 ➤','Benefit Same Bank')\n",
    "                                                                    datarep('Press 2 ➤','Benefit Another Bank')\n",
    "                                                                    datarep('Any Num ➤','Back')\n",
    "                                                                    design(60,2)     \n",
    "                                                                    cn=input('\\n● Condition Chosen │ ')\n",
    "                                                                    design(60,2)    \n",
    "                                                                    if valn(cn) :\n",
    "                                                                        cn=int(cn)\n",
    "                                                                        if cn > 2 or cn <= 0:\n",
    "                                                                            design(60,2)\n",
    "                                                                            center(colour('❖ Back to Main Menu ❖',4))\n",
    "                                                                            design(60,2)\n",
    "                                                                        else:\n",
    "                                                                            p=cusbal(x)\n",
    "                                                                            design(60,2)\n",
    "                                                                            datarep('Present Balance ➤',p)\n",
    "                                                                            design(60,2)\n",
    "                                                                            a=input('● Amount to be Transfer \\t│ ')\n",
    "                                                                            if valn(a)  and nonzero(a) :\n",
    "                                                                                design(60,2)\n",
    "                                                                                datarep('Amount in Words │ ',alpha(a))\n",
    "                                                                                design(60,2)\n",
    "                                                                                ty=acty(x,0)\n",
    "                                                                                z=p-int(a)\n",
    "                                                                                if z < 100 and p>=int(a) and ty=='saving':\n",
    "                                                                                    pyg.alert('As the Balance gonna less than 100\\n'+\\\n",
    "                                                                                    'it will results in 【 SUSPENSION of your Account 】: '+str(x)+\\\n",
    "                                                                                    'Kindly Cancel this Transaction to AVOID SUSPENSION','Dev CRM -'+ str(x))\n",
    "                                                                                elif z < 1000 and p>=int(a) and ty=='current':\n",
    "                                                                                    pyg.alert('As the Balance gonna less than 1000\\n'+\\\n",
    "                                                                                    'it will results in 【 SUSPENSION of your Account 】: '+str(x)+\\\n",
    "                                                                                    'Kindly Cancel this Transaction to AVOID SUSPENSION','Dev CRM -'+ str(x))\n",
    "                                                                                c=input('\\n➤ Want to Transfer Amount ? 【y/n】 │ ')\n",
    "                                                                                if c == 'Y' or c=='y':\n",
    "                                                                                    if cn == 1:\n",
    "                                                                                        transfund(x,'s',str(a),'0')\n",
    "                                                                                    else:\n",
    "                                                                                        transfund(x,'o',str(a),'0')\n",
    "                                                                                else:\n",
    "                                                                                    design(60,2)\n",
    "                                                                                    center(colour('✤ Changes Unmade Yet ✤',4))\n",
    "                                                                                    design(60,2)\n",
    "                                    else:\n",
    "                                        design(60,2)\n",
    "                                        cn=input('➤ Do You Forget Your Password 【y/n】 │')\n",
    "                                        if cn == 'Y' or cn=='y':\n",
    "                                            if validation(x) == True:\n",
    "                                                changepsw('',x,0,True)\n",
    "                                        else:\n",
    "                                            design(60,2)\n",
    "                                            center(colour('✤ Proposal Rejected ✤',6))\n",
    "                                            design(60,2)\n",
    "                                            break\n",
    "                                else:\n",
    "                                    design(60,2)\n",
    "                                    design(60,2)\n",
    "                                    center(colour('✋ Oops Your Account has【Suspended】✋',1))\n",
    "                                    center(colour('Reason For this may be',3))\n",
    "                                    datarep('A/C Bal. ➤','< Oprt. Bal.')\n",
    "                                    center(colour('Opertaing Balance for',5))\n",
    "                                    datarep('Saving A/C ➤','Bal > 100')\n",
    "                                    datarep('Curent A/C ➤','Bal > 1000')\n",
    "                                    center(colour('❖ To know more visit our Bank ❖',6))\n",
    "                                    design(60,2)\n",
    "                                    design(60,2)\n",
    "                                    break\n",
    "                            else:\n",
    "                                design(60,2)\n",
    "                                center(colour(\"✋ You don't have Dev E-Banking Yet ✋\",1))\n",
    "                                center(colour('➤ Want to Apply for that',4))\n",
    "                                datarep('Press Y ➤','For Yes')\n",
    "                                datarep('Any Key ➤','For No')\n",
    "                                design(60,2)\n",
    "                                c=input('\\n● Condition Chosen │ ')\n",
    "                                if c=='Y'or c=='y':\n",
    "                                    design(60,2)\n",
    "                                    if validation(x) == True:\n",
    "                                        center(colour('✤ Few Steps Ahead ✤',4))\n",
    "                                        design(60,2)\n",
    "                                        ph=getpass('\\n● Create Your Password │ ')\n",
    "                                        if pswpwr(ph) :\n",
    "                                            ph2=getpass('● Confirm Your Password │ ')\n",
    "                                            if pswmatch(ph,ph2) :\n",
    "                                                files.execute(\"update devcus set passw ='{}',active = 1 where cusid='{}' \".format(ph,x))\n",
    "                                                mycon.commit()\n",
    "                                                design(60,2)\n",
    "                                                t='Well Done '+ '\\nYour E-Banking Activated Successfully'\\\n",
    "                                                'Try Login using Your Credentials \\n'+'Login Id and Password'\n",
    "                                                pyg.alert(t,'Dev Bank')\n",
    "                                                center(colour('Your E-Banking Activated Successfully',2))\n",
    "                                                center(colour('Login Credentials are',6))\n",
    "                                                datarep('Cust ID','Password')\n",
    "                                                center(colour('Hope You Know T&C of Dev Bank',2))\n",
    "                                                design(60,2)\n",
    "                                                time.sleep(0.3)\n",
    "                                            else:\n",
    "                                                design(60,2)\n",
    "                                                center(colour('❌❌ Validation Failed ❌❌',1))\n",
    "                                                design(60,2)\n",
    "                                                break\n",
    "                                        else:\n",
    "                                            design(60,2)\n",
    "                                            center(colour('❌❌ Validation Failed ❌❌',1))\n",
    "                                            design(60,2)\n",
    "                                            break\n",
    "                                else:\n",
    "                                    design(60,2)\n",
    "                                    center(colour('✤ Proposal Rejected ✤',6))\n",
    "                                    design(60,2)\n",
    "                                    break\n",
    "                elif int(st) == 0:\n",
    "                    pyg.alert('✤ System Closes Successfully ✤\\nThanks for Your Concern')\n",
    "                    design(60,2)\n",
    "                    design(60,2)\n",
    "                    center(colour('✤ System Closes Successfully ✤',1))\n",
    "                    center(colour('❖ Thanks for Your Concern ❖',1))\n",
    "                    design(60,2)\n",
    "                    mycon.close()\n",
    "                    sys.exit()\n",
    "                else:\n",
    "                    design(60,2)\n",
    "                    if os.path.exists('T&C.txt'):\n",
    "                        f = open(\"T&C.txt\", \"r\")\n",
    "                        pyg.alert(f.read(),'Dev Bank CRM T&C')\n",
    "                        design(60,2)\n",
    "                    else:\n",
    "                        f='T&C.txt File not Found \\n If you deleted or lost \\n\\n Download it from \\n https://devbank.netlify.app'\n",
    "                        pyg.alert(f,'Dev Bank CRM T&C')\n",
    "                        center(colour(f,1))\n",
    "                        datarep('File Name ➤','T&C.txt')\n",
    "                        design(60,2)\n",
    "        else:\n",
    "            design(60,2)\n",
    "            center(colour('!! ❌❌❌❌❌❌ System Faces Error ❌❌❌❌❌❌ !! \\n',1))\n",
    "            center(colour('Prior Errors Needs to be Corrected\\nBefore Opeartions',5))\n",
    "            design(60,2)\n",
    "            mycon.close()\n",
    "            sys.exit()\n",
    "            break\n",
    "            "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}