back

SEF Support Processes

Process bank account validations

curl --location --request POST "http://127.0.0.1:5002/apicall/doBankValidation" --header "Content-Type: application/json" -d ' {"communityId": "sef-them-57c8a265-4467-47f3-82d9-72865c20b80d","participantUUID": "EPWPParticipant-03f50ae1-f12e-40c9-8ae1-57c5b1ed61ae","bankDetailsUUID": "EPWPParticipantBankDetails-5fdbae51-c847-48b2-fa29-2c58e7cfaaf6"}' >> curl.out

SELECT  -- p.`IDNUMBER`,p.`G_COMMUNITYID`, 
CONCAT('curl --location --request POST "http://127.0.0.1:5002/apicall/doBankValidation" --header "Content-Type: application/json" -d '' {"communityId": "',p.`G_COMMUNITYID`,'","participantUUID": "',p.`G_UUID`,'","bankDetailsUUID": "',b.`G_UUID`,'"}'' >> curl.out ')
FROM `ms_prt_participantdetails` p
JOIN `ms_prt_bankdetails` b ON b.`G_PROFILEUUID` = p.`G_PROFILEUUID`
WHERE p.`IDNUMBER` IN (SELECT `idnumber` FROM `payments`.`tranchedetails` WHERE trancheno = 33);
IN ('8805090176086',
'9607270343083',

SELECT  p.`IDNUMBER`,p.`G_COMMUNITYID`, 
	CONCAT('curl --location --request POST "http://127.0.0.1:5002/apicall/doBankValidation" --header "Content-Type: application/json" -d '' {"communityId": "',p.`G_COMMUNITYID`,'","participantUUID": "',p.`G_UUID`,'","bankDetailsUUID": "',b.`G_UUID`,'"}'' >> curl.out ')
FROM `ms_prt_participantdetails` p
JOIN `ms_prt_bankdetails` b ON b.`G_PROFILEUUID` = p.`G_PROFILEUUID`
WHERE -- b.`BANK` =  'Capitec'  and 
      IFNULL(b.`ISVALIDACCOUNT`,'null') = 'null' ;
--  and 
     b.`MESSAGEDESCRIPTION` = 'Transaction sent to the bank. Waiting for feedback'
ORDER BY p.`G_COMMUNITYID` DESC;

Regenerate the UIF reports

SELECT CONCAT("curl http://localhost:5002/apicall/createUIFReportWorker?communityId=",communityId)
FROM community WHERE elasticCode = 'sef' AND communityid LIKE 'sef-%';

Refresh all the reports on the UIF Month End Run

Note that this can only be done if the month end is completed and in complete status

curl http://localhost:8888/exist/restdb/kwantu-resource/_tools/refreshUIFReports.xq?communityId=xxxxxx&seq=n

Exclude participants from payment

 curl "http://localhost:8888/exist/rest/db/kwantu-resource/webhookServices/customAPIServices/SEF/excludeParticipantFromPayment.xql?tranchedeailsId=159296&idnumber=9607230771084" >> curl.out

Fix the benefiary date of birth and gender problems

The service to fix DOB and Gender is placed on staging at the following location.

/db/kwantu-resource/webhookServices/customAPIServices/SEF/fixParticipantGenderAndDOB.xq

Point to note:

1. This service will only fix the RSA cases for now.
2. The output progress of the service can be seen in exist logs by using grep on S001 like below

    tail -fn 200 /usr/local/exist/webapp/WEB-INF/logs/exist.log | grep "S001" 

3. These logs will print the ID Number of Non-RSA data as well which is not in correct format and needs to be fixed manually.

4. For pagination purpose to avoid any memory leak three parameters are specified

declare variable $local:startPage := 1;   (: Page to be processed :)

declare variable $local:pageSize := 1000;  (: Page size :)

declare variable $local:autoTravelAllPages := true();   (: If this is true it will scroll through all the pages one by one automatically, otherwise you need to run manually :)