Visualforce Error :Attempt to de-reference a null object

Can any one help me out with this Error .I'm getting

Visual force Error :Attempt to de-reference a null object .

To identify the same product name in a table in a visual force page which is in a PDF format . I tried adding few lines in the code and it throws an Error .

Any help is very much appreciated.

Apex Code :

public with sharing class QuoteContentController {

       public Competitor__c com{get;set;}

       public gmod__Opportunity_Forecast__c opflist{get;set;}

       public Id qId {get;set;}

       Public string all{get;set;}

//Declare a wrapper class  

       public class Wrapperclass{

 //custom wrapper datatype  

       Public string Name{get;set;}  
       Public string AccountType{get;set;}  
       Public date todaysDate{get;set;}  
       Public date Expected_Order_Date{get;set;}
       Public string Probability{get;set;}  
       Public string Internal_Comment{get;set;}  
       Public string External_Comment{get;set;}  

       Public string Segment{get;set;}  
       Public string Application{get;set;}  
       Public string Persona{get;set;}  
       Public string Geogrpahy{get;set;}  

       Public string PartNumbers{get;set;}  
       Public Decimal  Price{get;set;}  
       Public Decimal End_Customer_Price{get;set;}  
       Public Decimal Quantity {get;set;}  
       Public Decimal Total{get;set;}  

       Public string RFQ_justification{get;set;}  
       Public string Main_Customer_of_Account{get;set;}  
       Public string Bridgelux_competition_at_account{get;set;}
       Public string Geographic_regions_serviced{get;set;}  
       Public string Annual_lighting_revenue{get;set;}  
       Public string Annual_LED_revenue_or_percent{get;set;}  
       Public string Annual_purchases_of_LED_light_sources{get;set;}
       Public string Percent_of_LED_purchases_that_are_COB{get;set;}  
       Public string Other_information{get;set;}  

       Public string Product_Series{get;set;}  
       Public string Volume{get;set;} 
       Public string Date_Price_is_Valid{get;set;} 

       Public string gmod_Opportunity{get;set;}
       Public string gmod_Product{get;set;}
       Public Decimal gmod_Quantity{get;set;}
       Public Decimal gmod_Price{get;set;}
       Public Decimal gmod_Quarter{get;set;}
       Public Decimal gmod_Month{get;set;}
       Public Decimal gmod_Amount{get;set;}
       Public Decimal Actual_Price{get;set;}
       Public Decimal  gmod_Year{get;set;}
       Public Date gmod_date{get;set;}
       Public string gmod_Month_Text{get;set;}
       Public Date  Forecast_Date{get;set;}




       Public wrapperClass(){} 

  }

       Public QuoteContentController(){}

       Public QuoteContentController(ApexPages.StandardController controller) {

       qId=Apexpages.currentPage().getparameters().get('Id');

       disp_Map = new Map<String,wrapperClass>();


    }


        Public Integer subtotalofquantity{get;set;}

        Public Integer subtotalofamount{get;set;}

        public Map<String,wrapperClass> disp_Map{get;set;}


       Public List<wrapperClass> disp_list {get;set;}{

       //subtotalofquantity=0;

      // subtotalofamount=0;

     // Public List<wrapperClass> disp_list(){
    //define constructor to instantiate the wrapper data type 

       disp_list=new list<wrapperclass>();

     //Query all the list 

     list<Quote> q =[select id ,Name ,QuoteNumber,Effective_Date__c ,Comments__c ,Quote.Opportunity.id, 
                    Quote.Opportunity.Probability ,Quote.Opportunity.AccSegment__c ,Quote.Opportunity.AccApplication__c,Quote.Opportunity.Persona__c,Quote.Opportunity.Region__c
                    from Quote where id=:apexpages.currentpage().getparameters().get('id')];

    // list<QuoteLineItem> qli =[Select QuoteId , PricebookEntry.Product2.Name ,Unitprice ,End_Customer_Price__c ,Quantity , TotalPrice from QuoteLineItem where QuoteId =:qId ];

   //  list<Account> a = [Select id ,Name ,Main_Customers_of_Account__c ,Bridgelux_Competition_at_Account__c,Servicing_Region__c ,
                     // Annual_LED_Revenue__c,Annual_Purchases_of_LED_Sources_SAM__c ,Percent_of_LED_purchases_that_are_COB__c from Account where account.id =:qId ];

   //  list<Competitor__c>  com = [Select id ,Part_Number__c,Product_Series__c,Price_Offered__c,Volume__c,Date_Price_is_Valid__c from Competitor__c ]  ; 

     Opportunity opp =[select id , Name, (select id, Quantity, product2id from OpportunityLineItems), probability, AccSegment__c from Opportunity where opportunity.Id =:q[0].opportunity.id];

    list<gmod__Opportunity_Forecast__c>  opflist = [Select id ,Name ,gmod__opportunity__r.id,gmod__Product__c,gmod__Quantity__c,gmod__Price__c , gmod__Month__c,    gmod__date__c,  gmod__Quarter__c ,gmod__Amount__c ,Actual_Price__c ,gmod__Year__c ,gmod__Month_Text__c ,Forecast_Date__c,gmod__Product__r.Name ,gmod__opportunity__r.name from gmod__Opportunity_Forecast__c WHERE gmod__Product__c!=null and gmod__opportunity__r.id =:opp.id order by gmod__Month__c asc limit 9]; 

   // list<gmod__Opportunity_Forecast__c>  opflist=[ SELECT  id,gmod__product__r.name,gmod__Quantity__c,createdby.name , gmod__opportunity__r.name ,gmod__Amount__c,GROUPING(gmod__Quantity__c) grpQty, GROUPING(gmod__Amount__c) grpAmt ,COUNT(id) oppfc from gmod__Opportunity_Forecast__c GROUP BY CUBE(gmod__Quantity__c, gmod__Amount__c) ORDER BY GROUPING(gmod__Quantity__c), GROUPING(gmod__Amount__c) ];

  // Executes in DC 
  // [SELECT  gmod__product__r.name ,gmod__opportunity__c,COUNT(id) cnt FROM gmod__Opportunity_Forecast__c WHERE gmod__Product__c!=null GROUP BY  gmod__product__r.name ,gmod__opportunity__c];
//Executes in DC
 /*list<AggregateResult> groupedResults   =[SELECT  gmod__product__r.name ,gmod__opportunity__c,sum(gmod__Price__c) gmod__Price__c ,SUm(gmod__Amount__c) gmod__Amount__c,Sum(gmod__Quantity__c) gmod__Qunatity__c,COUNT(id) Quantity FROM gmod__Opportunity_Forecast__c WHERE  gmod__date__c=THIS_FISCAL_YEAR GROUP BY  gmod__product__r.name ,gmod__opportunity__c];

 for (AggregateResult ar : groupedResults)  {
   // System.debug('Campaign ID' + ar.get('CampaignId'));
    System.debug('sum amount' + ar.get('gmod__Amount__c'));
    System.debug('Count' + ar.get('Quantity'));
   // System.debug('Sum Quantity' + ar.get('gmod__Quantity__c'));


}*/

       //Iterate through each list to extract the values and add it to the custom wrapper data type  

        for (Quote qt :q){
             System.debug('Quote Size ++ '+q.size());
             System.debug('opp forcast ++ ' +opflist.size());


            for(integer i=1;i<opflist.size();i++){

            subtotalofquantity+= integer.valueOf(opflist[i].gmod__Quantity__c);

            subtotalofamount+= integer.valueOf(opflist[i]. gmod__Amount__c);


                                        //Instantiating the wrapper SObject 

                                        wrapperclass w = new wrapperclass();

             if(i == 0) 
                     {



                         if(disp_Map.containsKey(opflist[i].gmod__Product__r.Name )){

                               w = disp_Map.get(opflist[i].gmod__Product__r.Name);

                               w.gmod_Quantity =disp_Map.get(opflist[i].gmod__Product__r.Name).gmod_Quantity + opflist[i].gmod__Quantity__c;

                               w.gmod_Amount = disp_Map.get(opflist[i].gmod__Product__r.Name).gmod_Amount + opflist[i].gmod__Amount__c;

                  } else {

                    w.gmod_Quantity =opflist[i].gmod__Quantity__c;

                    w.gmod_Amount=opflist[i]. gmod__Amount__c;
           }

                    //Assigning the wrapper variables from the SObject Fields in the database. 

                 w.gmod_Opportunity = opflist[i].gmod__Opportunity__r.Name;

                 w.gmod_Product = opflist[i].gmod__Product__r.Name;

                 w.gmod_Quantity =opflist[i].gmod__Quantity__c;

                 w.gmod_Price=opflist[i].gmod__Price__c;

                 w.Name =opflist[i].Name;

                 w.gmod_Quarter=opflist[i].gmod__Quarter__c;

                 w.gmod_Month=opflist[i].gmod__Month__c;

                 w.gmod_Amount=opflist[i]. gmod__Amount__c;

                 w.Actual_Price=opflist[i].Actual_Price__c;

                 w.gmod_Year=opflist[i].gmod__Year__c;

                 w.gmod_date=opflist[i].gmod__date__c;

                 w.gmod_Month_Text=opflist[i].gmod__Month_Text__c;

                 w.Forecast_Date=opflist[i].Forecast_Date__c;

                 disp_Map.put(opflist[i].gmod__Product__r.Name,w);

                              //Adding everthing to the List  


                            // w.name =qt.name;

                             // disp_list.add(w);

                              // return disp_list;  

                 }
          else{


                         if(opflist[i].gmod__Product__r.Name != opflist[i-1].gmod__Product__r.Name ){

                         if(disp_Map.containsKey(opflist[i].gmod__Product__r.Name ) != disp_Map.containsKey(opflist[i-1].gmod__Product__r.Name)){

                               w = disp_Map.get(opflist[i].gmod__Product__r.Name);

                               w.gmod_Quantity =disp_Map.get(opflist[i].gmod__Product__r.Name).gmod_Quantity + opflist[i].gmod__Quantity__c;

                               w.gmod_Amount = disp_Map.get(opflist[i].gmod__Product__r.Name).gmod_Amount + opflist[i].gmod__Amount__c;

                  } else {

                    w.gmod_Quantity =opflist[i].gmod__Quantity__c;

                    w.gmod_Amount=opflist[i]. gmod__Amount__c;
                } 


                    //Assigning the wrapper variables from the SObject Fields in the database. 

                 w.gmod_Opportunity = opflist[i].gmod__Opportunity__r.Name;

                 w.gmod_Product = opflist[i].gmod__Product__r.Name;

                 w.gmod_Quantity =opflist[i].gmod__Quantity__c;

                 w.gmod_Price=opflist[i].gmod__Price__c;

                 w.Name =opflist[i].Name;

                 w.gmod_Quarter=opflist[i].gmod__Quarter__c;

                 w.gmod_Month=opflist[i].gmod__Month__c;

                 w.gmod_Amount=opflist[i]. gmod__Amount__c;

                 w.Actual_Price=opflist[i].Actual_Price__c;

                 w.gmod_Year=opflist[i].gmod__Year__c;

                 w.gmod_date=opflist[i].gmod__date__c;

                 w.gmod_Month_Text=opflist[i].gmod__Month_Text__c;

                 w.Forecast_Date=opflist[i].Forecast_Date__c;

                 disp_Map.put(opflist[i].gmod__Product__r.Name,w);

                              //Adding everthing to the List  


                            // w.name =qt.name;

                             // disp_list.add(w);

                              // return disp_list;  



              }       
              }
         }    
       for(wrapperclass w : disp_Map.values()){
            disp_list.add(w);
      }

   }  
 } //End of Class

February 25, 2015
·
Answer
·
Like
0
·
Follow
2

Arunkumar R
Hi nikke,

Can you share your full code and visualforce page and Error Line number. It will be helpful to find an issue.

February 25, 2015
·
Like
0
·
Dislike
0

Manga Lakshmi
Hi Nikke,
Check the list size before using those variables in the queries at line no. 113 and 115.

February 25, 2015
·
Like
0
·
Dislike
0

nikkey
Hi Arunkumar R
The Error line number is not mentioned.Any help is very much appreciated.

Here the Visual force Code .
<apex:page standardController="Quote" applyHtmlTag="false" renderAs="PDF" showheader="false" applyBodyTag="false" extensions="QuoteContentController"> <div class="title"> <center> <h2>RFQ Information </h2> </center> </div> <table cellspacing="0" cellpadding="0" width="100%" border="0" > <tr> <th bgcolor="Silver">General</th> <th bgcolor="Silver">Information:</th> <th bgcolor="Silver">Justification and Account </th> <th bgcolor="Silver">Information:</th> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">QuoteNumber:</f></td> <td class="header-data"><apex:outputText value="{!Quote.QuoteNumber}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">RFQ Justification:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Name}"/></td> </tr> <tr> <td> <f style="color:Black; font-size:12px; font-family:Verdana;">CustomerName: </f></td> <td class="header-data"><apex:outputField value="{!Quote.Name}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Main Customers of Account:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Main_Customers_of_Account__c}"/></td> </tr> <tr> <td> <f style="color:Black; font-size:12px; font-family:Verdana;">Account Type:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Recordtype.Name}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Bridgelux Competition at Account:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Bridgelux_Competition_at_Account__c}"/></td> </tr> <tr> <td> <f style="color:Black; font-size:12px; font-family:Verdana;">Date:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Effective_Date__c}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Geographic regions serviced:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Servicing_Region__c}"/></td> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Expected Order Date:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Effective_Date__c}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Annual lighting revenue:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Annual_LED_Revenue__c}"/></td> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Internal Comments:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Description}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Annual LED revenue or percent:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Annual_LED_Revenue__c}"/></td> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">External Comments: </f></td> <td class="header-data"><apex:outputField value="{!Quote.Comments__c}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Annual Purchases of LED Sources (SAM):</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Annual_Purchases_of_LED_Sources_SAM__c}"/></td> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Probability(%):</f></td> <td class="header-data"><apex:outputField value="{!Quote.Opportunity.Probability}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Percent of LED purchases that are COB:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Percent_of_LED_purchases_that_are_COB__c}"/></td> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Segment:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Opportunity.AccSegment__c}"/></td> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Other Info:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Account.Percent_of_LED_purchases_that_are_COB__c}"/></td> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Application:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Opportunity.AccApplication__c}"/></td> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Persona:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Opportunity.Persona__c}"/></td> </tr> <tr> <td ><f style="color:Black; font-size:12px; font-family:Verdana;">Geography:</f></td> <td class="header-data"><apex:outputField value="{!Quote.Opportunity.Region__c}"/></td> </tr> </table> <h3>QuotelineItems Details</h3> <table class="bordered"> <thead> <tr> <td class="header-table-heading" bgcolor="#C0C0C0">PartNumbers</td> <td class="header-table-heading" bgcolor="#C0C0C0">Price</td> <td class="header-table-heading" bgcolor="#C0C0C0">EndCustomerPrice</td> <td class="header-table-heading" bgcolor="#C0C0C0">Quantity</td> <td class="header-table-heading" bgcolor="#C0C0C0">Total</td> </tr> </thead> <tbody> <apex:repeat value="{!Quote.QuotelineItems}" var="qli"> <tr> <td class="header-table-data" ><apex:outputText value="{!qli.Product2.Name}"/></td> <td class="header-table-data" ><apex:outputText value="{!qli.Unitprice}"/></td> <td class="header-table-data"><apex:outputField value="{!qli.End_Customer_Price__c}"/></td> <td class="header-table-data"><apex:outputField value="{!qli.Quantity}"/></td> <td class="header-table-data"><apex:outputField value="{!qli.TotalPrice}"/></td> </tr> </apex:repeat> </tbody> </table> <h3>Competitive Data</h3> <table class="bordered"> <thead> <tr> <td class="header-table-heading" bgcolor="#C0C0C0">Company</td> <td class="header-table-heading" bgcolor="#C0C0C0">Product Series</td> <td class="header-table-heading" bgcolor="#C0C0C0">Part Numbers</td> <td class="header-table-heading" bgcolor="#C0C0C0">Price</td> <td class="header-table-heading" bgcolor="#C0C0C0">volume</td> <td class="header-table-heading" bgcolor="#C0C0C0">Date Price is Valid</td> </tr> </thead> <tbody> <apex:repeat value="{!Quote.Competitor_s__r}" var="com"> <tr> <td class="header-table-data"><apex:outputText value="{!com.Name}"/></td> <td class="header-table-data"><apex:outputText value="{!com.Product_Series__c}"/></td> <td class="header-table-data"><apex:outputField value="{!com.Part_Number__c }"/></td> <td class="header-table-data"><apex:outputField value="{!com.Price_Offered__c}"/></td> <td class="header-table-data"><apex:outputField value="{!com.Volume__c}"/></td> <td class="header-table-data"><apex:outputField value="{!com.Date_Price_is_Valid__c}"/></td> </tr> </apex:repeat> </tbody> </table> <h3>OpportunityForecast Details</h3> <table class="bordered"> <thead> <tr> <td class="header-table-heading" bgcolor="#C0C0C0" colspan="3" ></td> <td class="header-table-heading" bgcolor="#C0C0C0" colspan="5" >FORECAST DATE</td> </tr> <tr> <td class="header-table-heading" bgcolor="#C0C0C0">Opportunity Name</td> <td class="header-table-heading" bgcolor="#C0C0C0">PartNumbers</td> <td class="header-table-heading" bgcolor="#C0C0C0"></td> <td class="header-table-heading" bgcolor="#C0C0C0">Q1 2014 </td> <td class="header-table-heading" bgcolor="#C0C0C0">Q2 2014 </td> <td class="header-table-heading" bgcolor="#C0C0C0">Q3 2014 </td> <td class="header-table-heading" bgcolor="#C0C0C0">Q4 2014 </td>  <td class="header-table-heading" bgcolor="#C0C0C0">MonthText</td>  <td rowspan="0" class="header-table-heading">Grand<br/>Total </td> </tr> </thead> <tbody> <apex:repeat value="{!disp_list}" var="opf"> <tr> <td class="header-table-data"><apex:outputText value="{!opf.gmod_Opportunity}"/></td> <td class="header-table-data"><apex:outputText value="{!opf.gmod_Product}"/></td> <td class="header-table-data" >Forecast Qty<br/>ForecastAmt<br/></td> <td class="header-table-data"><apex:outputText value="{!opf.gmod_Quantity}"/><br/><apex:outputText value="{!opf.gmod_Amount }"/><br/></td> <td class="header-table-data"><apex:outputText value="{!opf.gmod_Quantity}"/><br/><apex:outputText value="{!opf.gmod_Amount }"/><br/></td> <td class="header-table-data"><apex:outputText value="{!opf.gmod_Quantity}"/><br/><apex:outputText value="{!opf.gmod_Amount }"/><br/></td> <td class="header-table-data"><apex:outputText value="{!opf.gmod_Quantity}"/><br/><apex:outputText value="{!opf.gmod_Amount }"/><br/></td>  <td class="header-table-data"><apex:outputText value="{!opf.gmod_Month_Text }"/></td>  <td rowspan="1" style="text-align:left" align="right" class="header-table-heading"> {!subtotalofquantity }<br/> {!subtotalofAmount }<br/></td> </tr> </apex:repeat> </tbody> <tfoot> <tr class="foot">  <tr> <td colspan="2" style="text-align:left" align="right" class="header-table-data">SubTotal :</td> <td colspan="0" style="text-align:left" align="right" class="header-table-data" >Forecast Qty<br/>ForecastAmt<br/> </td> <td colspan="1" style="text-align:left" align="right" class="header-table-data"> {!subtotalofquantity}<br/> {!subtotalofAmount}<br/></td> <td colspan="1" style="text-align:left" align="right" class="header-table-data"> {!subtotalofquantity }<br/> {!subtotalofAmount }<br/></td> <td colspan="1" style="text-align:left" align="right" class="header-table-data"> {!subtotalofquantity }<br/> {!subtotalofAmount }<br/></td> <td colspan="1" style="text-align:left" align="right" class="header-table-data"> {!subtotalofquantity }<br/> {!subtotalofAmount }<br/></td> </tr> <tr> <td colspan="2" style="text-align:left" align="right" class="header-table-heading">GrandTotal</td> <td colspan="0" style="text-align:left" align="right" class="header-table-heading" >Forecast Qty<br/>ForecastAmt<br/> </td> <td colspan="1" style="text-align:left" align="right" class="header-table-heading"> {!subtotalofquantity }<br/> {!subtotalofAmount }<br/></td> <td colspan="1" style="text-align:left" align="right" class="header-table-heading"> {!subtotalofquantity }<br/> {!subtotalofAmount }<br/></td> <td colspan="1" style="text-align:left" align="right" class="header-table-heading"> {!subtotalofquantity }<br/> {!subtotalofAmount }<br/></td> <td colspan="1" style="text-align:left" align="right" class="header-table-heading"> {!subtotalofquantity }<br/> {!subtotalofAmount }<br/></td> </tr> </tr> </tfoot> </table> </apex:page>

February 25, 2015
·
Like
0
·
Dislike
0

nikkey
Hi Arun , It throws the Error as :System.NullPointerException: Attempt to de-reference a null object Class.QuoteContentController.: line 155, column 1.The line is : if(disp_Map.containsKey(opflist[i].gmod__Product__r.Name )){

February 26, 2015
·
Like
0
·
Dislike
0

Arunkumar R
Hi Nikkey,

Can you add this condition in you if statement,

if(opflist[i].gmod__Product__r.Name != null && disp_Map.containsKey(opflist[i].gmod__Product__r.Name )){

March 2, 2015
·
Like
0
·
Dislike
0

nikkey
Hi Arun , Thanks for your reply.I have posted in the below link with the query. https://developer.salesforce.com/forums/ForumsMain?id=906F0000000Azxm

March 2, 2015
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Visualforce Error :Attempt to de-reference a null object

You need to sign in to do that.