Prompt for pms

PMS system development using AI Code Assistant:

(Payment management system)

Client:- BSNL - Land Line customer (Monthly bill payment).

Prompt:- Provide Python code for developing PMS system.

            Provide Python Streamlit code (using Postgress database tables) for developing Payment Management system for the following requirements:

           

There should be two pages. 1. Login Page for Admins 2. Main Page

1). Login page for Admin to redirect to Main page after successful login:

              Login credential are be checked using Postgres database using a table "check_admin"

              check_admin table should contain the columns: username, password, enabled_or_not, date_of_creation_of_username



            2). Main page should contain:

            Heading of the page:     "BSNL Bill Payment Portal"

            Input boxes:      Account_number or Telephone_Number

            Once, either Account_number or Telephone_Number are submitted, the following data to be fetched from Cutomer_info table

            Custemer_Name:          To be fetched from database base(Cutomer_info table) on Account_number or Telephone_number

            Telephone_No: Telephone_Number

            Telephone_Exchange: Telephone Exchange

            Monthly_Plan:                  Current Plan is to be fetched from database (Cutomer_info table)

            Billed_Month:  To be fetched from database (Cutomer_info table)

            Amount_payable:          To be fetched from database (Cutomer_info table)

            Payment_method:         "Cash"

            Submit_button:               Submit

           

            Once Submitted, The data to be updated in the Cutomer_info table with payment completed successfully with a receipt.



            The Cutomer_info table should contain the following columns:

            Custemer_Name, Telephone_No, Telephone_Exchange, Monthly_Plan, Billed_Month, Amount_payable,  Payment_method, Payment_Status, paid_dt_time, Name_of_the_Accounts_Officer



            3). Receipt format:         Customer_Name, Telephone Number, Plan, Billed Month, Amount paid, Payment method, Date_time,

                                                            Account_Officer_details