mGramSeva - eChallan Service v1.2.0
- rkrahu
Analytics
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 |
| It connects to billing service host to get the amount details for specific challan no. |
Related Document