Salesforce Developer Community

Chatter

Feed
0

Best Answers
1

Likes Received
0

Likes Given
34

Questions
38

Replies

trigger validation on account status

Hi Experts,

I have the below requirement and I need to know how can I proceed.
I have a custom field in Account Obj as Status "Active and Inactive" which is a picklist.
When an account is Inactive, I should not allow the user to edit the record. But I need to allow them to enter or edit Tasks, Events, Relatedlists on that record.

I have created the Validation Rule but it is not allowing any changes on the account when Inactive.

Kindly need your inputs to complete.

Thanks in Advance.

HTANIRS
November 06, 2020
Like
0

1 replies

Trigger test class code coverage for custom metadata loop

Hi Experts,

Need help in code coverage for Trigger Test Class.
Test Class not covering in Custom Metadata part which was mentioned in Bold.

Trigger:

trigger updateMembershipPrice on OpportunityLineItem (after insert) {
    Set<Id> oppsIds = new Set<Id>();    
    List<OpportunityLineItem> oliList = new List<OpportunityLineItem>();
    List<OpportunityLineItem> updateOliList = new List<OpportunityLineItem>();
    Map<String, String> mapOpp = new Map<String, String>();
                
    for(OpportunityLineItem oli : Trigger.new) {
        oppsIds.add(oli.OpportunityId);
        System.debug('--- Opps Id ---' + oli.OpportunityId);
    }
    
    Map<String, Decimal> mapcustomProRate = new Map<String, Decimal>();
    
    for(MembershipPrice__mdt customMetadata : [SELECT Membership_Type__c, Month__c, Pro_Rate_Price__c FROM MembershipPrice__mdt]) {
        mapcustomProRate.put(customMetadata.Month__c +'' + customMetadata.Membership_Type__c, customMetadata.Pro_Rate_Price__c);        
    }
         
    Map<Id, Date> mapDateApproved = new Map<Id, Date>();
    
    for(OpportunityLineItem olit : [SELECT Id, OpportunityId, Opportunity.Date_Approved__c, Product2.Name FROM OpportunityLineItem WHERE OpportunityId IN: oppsIds]) {
        if(olit.Opportunity.Date_Approved__c != NULL && olit.Product2Id != NULL) {
            Datetime dt = (Datetime)olit.Opportunity.Date_Approved__c;
            String monthname = dt.format('MMMM');
            if(mapcustomProRate.containsKey(monthname +''+ olit.Product2.Name)) {
                OpportunityLineItem oli = new OpportunityLineItem();
                oli.Id = olit.Id;
                oli.UnitPrice = mapcustomProRate.get(monthname +''+ olit.Product2.Name);
                updateOliList.add(oli);
            }   
        }
    }    

    if(updateOliList.size() > 0) {
        update updateOliList;
    }   
    
}

Test Class:

@isTest
private class updateMembershipPrice_Test {
    static testMethod void updateMembershipPrice_Test () {
        //create Account
        Account acc = new Account(Name = 'Test Account');
        insert acc;
        
        //create Contact
        Contact con = new Contact(LastName = 'Test', AccountId = acc.Id, FirstName = 'Contact', Email = 'Test@sf.com', MailingStreet = '123', OtherStreet = '213');
        insert con;        

        //get standard pricebook
        Id pricebookId = Test.getStandardPricebookId();

        //add product
        Product2 prd1 = new Product2 (Name='Test Product Entry 1',Description='Test Product Entry 1',productCode = 'ABC', isActive = true);
        insert prd1;
        
        //add pricebookentry for standard pricebook
        PricebookEntry pbe1 = new PricebookEntry (Product2ID = prd1.id, Pricebook2ID = pricebookId, UnitPrice = 50, isActive = true);
        insert pbe1;
        
        //add opportunity
        Opportunity opp = new Opportunity (Name = 'Opp', Date_Approved__c = Date.today(), StageName = 'Qualification', CloseDate = Date.today(), Pricebook2Id = pbe1.Pricebook2Id, AccountId = acc.id);
        insert opp;
        
        //add opportunity line item
        OpportunityLineItem lineItem = new OpportunityLineItem (OpportunityID = opp.id, PriceBookEntryID = pbe1.id, quantity = 1, totalprice = 200);
        insert lineItem;
        
        lineItem.quantity = 2;
        lineItem.UnitPrice = 400;
        update lineItem;        
    }
}

Kindly suggest the changes need to be done.

Thanks.

HTANIRS
September 20, 2020
Like
0

1 replies

trigger to insert split values as record

Hi Experts,

I need assistance in completing the below trigger.
I have a custom object where it has lookup to Order object. I have a custom fields ProductName, Quantity.
Product Name, Quantity will be with more values sometimes single value which is separated by commas.
Ex: ProductName: SampleProduct,SampleProduct1
Quantity: 5,2
I want to insert multiple Order Item with respect to that Order like ProductName: SampleProduct, Quantity: 5 as 1 record and another record as ProductName: SampleProduct1, Quantity: 2 where ProductName should be matched from Pricebookentry and insert in orderitem.

trigger insertOrderItem on OrderItem__c (after insert) {
    // Custom Order Item Collections
    Set<Id> orderitemIds = new Set<Id>();
    List<OrderItem__c> oiList = new List<OrderItem__c>();
    List<OrderItem__c> deloiList = new List<OrderItem__c>();
    
    // order collections
    List<order> ordList = new List<Order>();
    Map<Id, Order> ordMap = new Map<Id, Order>();
    
    // pricebookentry collections
    Map<String, List<pricebookentry>> pricebookMap = new Map<String, List<pricebookentry>>();
    List<Pricebookentry> pbeList = new List<Pricebookentry>();
    
    // orderitem collections
    List<OrderItem> oitList = new List<OrderItem>();
    
    for(OrderItem__c oi : Trigger.New) {
        orderitemIds.add(oi.Order__c);
        System.debug('--- Order Id in Custom Oi Obj ---' + oi.Order__c);        
    }
    
    if(!orderitemIds.isEmpty()) {
        pbeList = [SELECT Id, Name, Pricebook2Id, Pricebook2.Name, Product2Id, IsActive
                      FROM Pricebookentry
                      WHERE IsActive = true AND Pricebook2.Name = 'Standard Price Book' AND Pricebook2.Name IN: orderitemIds];
        
        for(Order ord : [SELECT Id FROM Order WHERE Id IN: orderitemIds]) {
            ordMap.put(ord.Id, ord);
        }
        
        for(Pricebookentry pbe : pbeList) {
            if(!pricebookMap.containsKey(pbe.Product2.Name)) {
                pricebookMap.put(pbe.Product2.Name, new List<Pricebookentry> {pbe});
            }
            else {
                List<Pricebookentry> pbeLists = pricebookMap.get(pbe.Product2.Name);
                pbeLists.add(pbe);
                pricebookMap.put(pbe.Product2.Name, pbeLists);
            }
        }
    }
    
    for(OrderItem__c oi : Trigger.New) {
/* Need to insert Order Item*/ 
     
   List<String> Name = oi.ProductName__c.split(',');
        List<String> Qty = oi.Quantity__c.split(',');
        List<String> UnitPrice = oi.UnitPrice__c.split(',');
        
        System.debug('--- Name ---' + Name);
        System.debug('--- Qty ---' + Qty);
        System.debug('--- UnitPrice ---' + UnitPrice);
        
        Map<Id, Product2> proIdMap = new Map<Id, Product2>([SELECT Id FROM Product2 WHERE Name IN: Name]);
        
        OrderItem oit = new OrderItem();
        oit.OrderId = oi.Order__c;
        oit.Quantity = // Split Quantity Value.
        oit.UnitPrice = // Split UnitPrice Value.
        oit.PricebookEntryId = // Split ProductName Value;
        oitList.add(oit);
    }
    
    if(!oitList.isEmpty()) {
        insert oitList;
        System.debug('---Order Item Inserted Size---' + oitList.size());
    }
}

Thanks in Advance.

HTANIRS
July 21, 2020
Like
0