public class StageProcessingHandler {
    public static void processStaging(List<StageRecord__c> incomingRecords) {
        // Ensure processing if there are records to avoid unnecessary queries/calculations
        if (incomingRecords == null || incomingRecords.isEmpty()) {
            return;
        }
 
        Map<Id, StageRecord__c> currentDataMap = new Map<Id, StageRecord__c>();
        Map<String, StageRecord__c> freshDataMap = new Map<String, StageRecord__c>();
 
        // Divide incoming records into respective maps based on LinkID__c or MortgageID__c
        for (StageRecord__c record : incomingRecords) {
            if (record.LinkID__c != null) {
                currentDataMap.put(record.LinkID__c, record);
            } else if (record.MortgageID__c != null) {
                freshDataMap.put(record.MortgageID__c, record);
            }
        }
 
        // Skip if there is no fresh data to process
        if (freshDataMap.isEmpty()) {
            return;
        }
 
        // Retrieve matching deals from the database
        Map<Id, Deal> dealMap = new Map<Id, Deal>([
            SELECT Id, MortgageID__c FROM Deal WHERE MortgageID__c IN :freshDataMap.keySet()
        ]);
 
        // Handle existing deals and check for absent deals using a separate method 
        Map<Id,Deal> absentData = Deal_Processing.getDealInstances(dealMap.keySet());
 
        List<Deal> newEntries = new List<Deal>();
 
        // Map the absent deals to be inserted
        for (Deal loanDeal : absentData.values()) {
            Deal adjustedDeal = Deal_Processing.applyMapping(loanDeal);
            if (adjustedDeal != null) { // Null check for safe processing.
                newEntries.add(adjustedDeal);
            }
        }
 
        // Insert all new entries in bulk if there are any
        if (!newEntries.isEmpty()) {
            try {
                insert newEntries;
            } catch (DmlException ex) {
                // Log the error and handle failed inserts appropriately
                System.debug('Failed to insert deals: ' + ex.getMessage());
            }
        }
    }
}
 

cHVibGljIGNsYXNzIFN0YWdlUHJvY2Vzc2luZ0hhbmRsZXIgewogICAgcHVibGljIHN0YXRpYyB2b2lkIHByb2Nlc3NTdGFnaW5nKExpc3Q8U3RhZ2VSZWNvcmRfX2M+IGluY29taW5nUmVjb3JkcykgewogICAgICAgIC8vIEVuc3VyZSBwcm9jZXNzaW5nIGlmIHRoZXJlIGFyZSByZWNvcmRzIHRvIGF2b2lkIHVubmVjZXNzYXJ5IHF1ZXJpZXMvY2FsY3VsYXRpb25zCiAgICAgICAgaWYgKGluY29taW5nUmVjb3JkcyA9PSBudWxsIHx8IGluY29taW5nUmVjb3Jkcy5pc0VtcHR5KCkpIHsKICAgICAgICAgICAgcmV0dXJuOwogICAgICAgIH0KCiAgICAgICAgTWFwPElkLCBTdGFnZVJlY29yZF9fYz4gY3VycmVudERhdGFNYXAgPSBuZXcgTWFwPElkLCBTdGFnZVJlY29yZF9fYz4oKTsKICAgICAgICBNYXA8U3RyaW5nLCBTdGFnZVJlY29yZF9fYz4gZnJlc2hEYXRhTWFwID0gbmV3IE1hcDxTdHJpbmcsIFN0YWdlUmVjb3JkX19jPigpOwoKICAgICAgICAvLyBEaXZpZGUgaW5jb21pbmcgcmVjb3JkcyBpbnRvIHJlc3BlY3RpdmUgbWFwcyBiYXNlZCBvbiBMaW5rSURfX2Mgb3IgTW9ydGdhZ2VJRF9fYwogICAgICAgIGZvciAoU3RhZ2VSZWNvcmRfX2MgcmVjb3JkIDogaW5jb21pbmdSZWNvcmRzKSB7CiAgICAgICAgICAgIGlmIChyZWNvcmQuTGlua0lEX19jICE9IG51bGwpIHsKICAgICAgICAgICAgICAgIGN1cnJlbnREYXRhTWFwLnB1dChyZWNvcmQuTGlua0lEX19jLCByZWNvcmQpOwogICAgICAgICAgICB9IGVsc2UgaWYgKHJlY29yZC5Nb3J0Z2FnZUlEX19jICE9IG51bGwpIHsKICAgICAgICAgICAgICAgIGZyZXNoRGF0YU1hcC5wdXQocmVjb3JkLk1vcnRnYWdlSURfX2MsIHJlY29yZCk7CiAgICAgICAgICAgIH0KICAgICAgICB9CgogICAgICAgIC8vIFNraXAgaWYgdGhlcmUgaXMgbm8gZnJlc2ggZGF0YSB0byBwcm9jZXNzCiAgICAgICAgaWYgKGZyZXNoRGF0YU1hcC5pc0VtcHR5KCkpIHsKICAgICAgICAgICAgcmV0dXJuOwogICAgICAgIH0KCiAgICAgICAgLy8gUmV0cmlldmUgbWF0Y2hpbmcgZGVhbHMgZnJvbSB0aGUgZGF0YWJhc2UKICAgICAgICBNYXA8SWQsIERlYWw+IGRlYWxNYXAgPSBuZXcgTWFwPElkLCBEZWFsPihbCiAgICAgICAgICAgIFNFTEVDVCBJZCwgTW9ydGdhZ2VJRF9fYyBGUk9NIERlYWwgV0hFUkUgTW9ydGdhZ2VJRF9fYyBJTiA6ZnJlc2hEYXRhTWFwLmtleVNldCgpCiAgICAgICAgXSk7CgogICAgICAgIC8vIEhhbmRsZSBleGlzdGluZyBkZWFscyBhbmQgY2hlY2sgZm9yIGFic2VudCBkZWFscyB1c2luZyBhIHNlcGFyYXRlIG1ldGhvZCAKICAgICAgICBNYXA8SWQsRGVhbD4gYWJzZW50RGF0YSA9IERlYWxfUHJvY2Vzc2luZy5nZXREZWFsSW5zdGFuY2VzKGRlYWxNYXAua2V5U2V0KCkpOwoKICAgICAgICBMaXN0PERlYWw+IG5ld0VudHJpZXMgPSBuZXcgTGlzdDxEZWFsPigpOwogICAgICAgIAogICAgICAgIC8vIE1hcCB0aGUgYWJzZW50IGRlYWxzIHRvIGJlIGluc2VydGVkCiAgICAgICAgZm9yIChEZWFsIGxvYW5EZWFsIDogYWJzZW50RGF0YS52YWx1ZXMoKSkgewogICAgICAgICAgICBEZWFsIGFkanVzdGVkRGVhbCA9IERlYWxfUHJvY2Vzc2luZy5hcHBseU1hcHBpbmcobG9hbkRlYWwpOwogICAgICAgICAgICBpZiAoYWRqdXN0ZWREZWFsICE9IG51bGwpIHsgLy8gTnVsbCBjaGVjayBmb3Igc2FmZSBwcm9jZXNzaW5nLgogICAgICAgICAgICAgICAgbmV3RW50cmllcy5hZGQoYWRqdXN0ZWREZWFsKTsKICAgICAgICAgICAgfQogICAgICAgIH0KCiAgICAgICAgLy8gSW5zZXJ0IGFsbCBuZXcgZW50cmllcyBpbiBidWxrIGlmIHRoZXJlIGFyZSBhbnkKICAgICAgICBpZiAoIW5ld0VudHJpZXMuaXNFbXB0eSgpKSB7CiAgICAgICAgICAgIHRyeSB7CiAgICAgICAgICAgICAgICBpbnNlcnQgbmV3RW50cmllczsKICAgICAgICAgICAgfSBjYXRjaCAoRG1sRXhjZXB0aW9uIGV4KSB7CiAgICAgICAgICAgICAgICAvLyBMb2cgdGhlIGVycm9yIGFuZCBoYW5kbGUgZmFpbGVkIGluc2VydHMgYXBwcm9wcmlhdGVseQogICAgICAgICAgICAgICAgU3lzdGVtLmRlYnVnKCdGYWlsZWQgdG8gaW5zZXJ0IGRlYWxzOiAnICsgZXguZ2V0TWVzc2FnZSgpKTsKICAgICAgICAgICAgfQogICAgICAgIH0KICAgIH0KfQo=