PSPCL iFix Adapter

Owned by Pintu (Unlicensed)
Last updated: Jul 21, 2022
3 min read

Overview

PSPCL iFix Adapter is a java standalone application, which will be running as a cron job to fetch the bills and payments from the PSPCL system and reconcile the same. And finally, publish them to the iFix core system.

Version

Current version : 1.0.0

Prerequisites

Before proceeding with the configuration, ensure the following pre-requisites are met.

  • Java 8

  • Postgres DB should be up and running

Features

pspcl-ifix-adapter fetches the pspcl bills and payments from the PSPCL system based on the account number that is mapped in MDMS (can be found in https://github.com/misdwss/mdms-mgramseva/blob/QA/data/pb/pspcl-integration/accountNumberGpMapping.json ). Once will get the bills and payments, the below steps are there to reconcile and publish to the iFix Core system.

  1. Sort the pspcl bills and payments results based on 'BILL_ISSUE_DATE' and 'TXNDATE' respectively.

  2. Get the latest i.e the 0th index bill and payment result And check - Is it already registered in the system by any previous job?

  3. if reconciled already stop the reconciliation.

  4. if not reconciled, calculate the current bill (since in the pspcl bill result, we are getting all the accumulated bills together). And this calculated bill will become the 'actual current bill' of the current month. if the previous bill has been cleared, then the calculated bill amount will come out to be same as the current bill.

    1. Calculated bill = (Curr_Bill - Last_Bill + Last_Payment).

    2. Curr_Bill: This is the pspcl bill that we get in the sorted 0th index pspcl bill result.

    3. Last_Bill: Will get this bill based 'DATE_READING_PREV' date.

    4. Last_Payment: Will pick up the record from the payment detail table with 'TXNDATE' as a range from 'DATE_READING_PREV' & 'Current time'. And then finally sort and take the latest payment TXNDATE as Last_Payment record.

  5. Add that we are just noting down the response from the pspcl for historical purposes.

  6. Publish the bill and payment as event type 'Demand' and 'Receipt' respectively with calculated actual bill and payment amount to the iFix Core system.

  7. Log the success or failure of fiscal events to the DB.

Interaction Diagram

 

Environment

Below are the list of environment variables :

Key

Description

Key

Description

pspcl.fetch.bill.url

PSPCL fetch bill url.

e.g : https://billapp.pspcl.in//fetchbillingdata.asmx

pspcl.fetch.payment.url

PSPCL fetch payment url.

e.g : https://billapp.pspcl.in//fetchbillingdata.asmx

ifix.host

Fiscal event host address for specific environment.

e.g : https://ifix-qa.ifix.org.in

egov.mdms.host

MDMS host address for specific environment.

e.g : https://mgramseva-qa.egov.org.in

keycloak.host

Keycloak host address for specific address.

e.g : https://ifix-qa.ifix.org.in

keycloak.credentials.clientid

Keycloak client id of pspcl-ifix-adapter.

e.g : pspcl-ifix-qa

keycloak.credentials.clientsecret

Keycloak client secret of pspcl-ifix-adapter.

fiscal.event.tenantId

Fiscal event tenant id.

e.g : ‘pb’

demand.coaCode

Chart of account code for ‘DEMAND’ event.

e.g : 8247-12-373-56-78-90

receipt.coaCode

Chart of account code for ‘RECEIPT’ event.

e.g : 8247-12-373-56-78-90

fiscal.event.receiver

mGramSeva keycloak client id

e.g : mgramseva-qa

timestamp.logging.enabled

Mark it as ‘false', if don’t want to log the PSPCL fetch bills and payments time.

Configurations and Setup

Update all the configuration in the dev.yaml, qa.yaml, prod.yaml file.