mGramSeva - eChallan Service v1.2.0

Overview

It enhanced the eChallan search query. It decouples challan and billing service from eChallan search query. To support PSPCL auto challan listing. It introduced reference id, a reference id can be tagged with multiple challan no. It doesn’t effect the previous challan activities. We can consider one challan number can have one singe event. It's reference id responsibility to manage multiple challans for single PSPCL account.

Reference Id Update

It introduced an attribute “referenceid” in “eg_echallan” table to consolidate consumer code. To match with all previous record, reference id will have the value of “challanno”. It’s only for old record maintenance.

Steps for SQL script.

Go to Kubernetes playground with mGramseva name space.

kubectl exec -it <playground> -n <mgramseva namespace> -- /bin/bash

Connect with Postgres DB using appropriate user credentials.

psql -h postgres.mgramseva -U <username> <mgramseva_db>

Run the update command

UPDATE EG_ECHALLAN SET REFERENCEID=CHALLANNO WHERE (REFERENCEID IS NULL OR REFERENCEID = '')

Verify by select command.

Deployment Details

Deploy the latest version of eChallan service

Environment Variables	Description
`billing.service.host`	It connects to billing service host to get the amount details for specific challan no.