Migration is required in individuals and attendance data if worksv0.1 is already deployed.
This migration is Mukta-specific, it will not be part of our master code.
Migration Steps
Use this specific branch of the organization service, which includes the mentioned changes. Follow the links here to access the branch and change details.
Build and deploy this service in your environment.
Run the below queries manually if the phone number is changed for the existing organisation.
//GET organisations for which mobile numberis changedselect id, mobilenumber from individual where id in ( select id from eg_org_contact_detail where individual_id is null and tenant_id='od.testing');
// Find those user details for each byencrypted mobile numberselect id, uuid, username from eg_user where mobilenumber='encMobileNumber';//Update that individual with correct valuesupdate individual set userid='userid', useruuid='userUuid', issystemuseractive=true, username='decMobileNumber', type='CITIZEN', roles='[{"code": "ORG_ADMIN", "name":"Organization admin", "tenantId": null, "description": null}]' WHERE id='individualId';
//restore the contact details with older mobile numberupdate eg_org_contact_detail set contact_mobile_number='decMobileNumber' , individual_id='individualId' where id='individualId';
//Get attendence staff detils with older detailsselect*from eg_wms_attendance_staff where individual_id='userUuid';//if attendence staff details are there thenupdate according to new attendance serviceUPDATE eg_wms_attendance_staff set individual_id='individualId'where individual_id='userUuid';