+ Start a Discussion
Mohammed AzarudeenMohammed Azarudeen 

How Do I Download Invoice which has Notes and Attachment on List View

Scenario : In the ListView of Invoice Download button is placed. This will Download the Invoice PDFif the invoice has notes and attachments else notes and attachments is null for the invoice then it will download another PDF which has some contents of the invoice.
Problem : I can able to download the corresponding PDF for single invoice selection on the List View. If I select Records(Multiple selection) with notes and attachments and without notes and attachments then it is downloading the INVOICE PDF only for both record.

Below is my Code
 
global class DownloadInvoice 
{

   private static String API_STATUS_NORMAL = '200';

   webService static string getAttachmentByParentId(string sfdcId)
    {

         List<id> ids = new List<id>();
         if(string.isempty(sfdcId))  {
            return DownloadInvoiceResponse.errorJson('Parameter sfdcId is required.');
        }
        system.debug('SFDCid'+sfdcId);
        string[] idsArray = sfdcId.split(',');
        for(integer i=0; i<idsArray.size();i++)
        {
           ids.add(idsArray[i]);
        }


        List<Invoice__c> invList = New List<Invoice__c>();
        invList = [Select id, name, Print_Invoice__c,Account__r.name from Invoice__c where ID IN: ids];

        List<Attachment> attInsert = new List<Attachment>();

        if(invList.size() > 0){

            for(Invoice__c invc : invList){

                String msg = 'Selected invoices are not eligible for Invoice Printing, please check the Account '+invc.Account__r.name;
                if(invc.Print_Invoice__c == false){

                    return DownloadInvoiceResponse.errorJson( msg );
                }
                Blob body;

       ****From here taking Attachment and adding the condition****

                Integer WithAttachCount = [SELECT count() FROM Attachment where ParentId IN:ids AND id !=null];

                if (WithAttachCount > 0){

                        PageReference pdf = new PageReference('/apex/InvoicePDF?id='+invc.id);

                        try {
                            if(Test.IsRunningTest()){
                                System.debug(' ==> as Test Class <== ');
                                body = Blob.valueOf('Some Text');
                            }
                            else{
                                System.debug(' ==> as Apex normal Class <== ');
                                body = pdf.getContentAsPDF(); 
                                Attachment attach = new Attachment(); 
                                attach.Body = body;
                                attach.name= invc.name +'_Invoice_'+ Datetime.Now() +'.PDF';
                                attach.IsPrivate = false;
                                attach.ParentId = invc.id;
                                attach.contentType = 'application/pdf';
                                attInsert.add(attach); 
                           }
                         } 
                        catch (VisualforceException e) {
                                String msg2 = e.getMessage();
                                return DownloadInvoiceResponse.errorJson( msg2 );
                           }

                        }

                 if(WithAttachCount <= 0 || WithAttachCount == null){

                        PageReference pdff = new PageReference('/apex/InvoicesIfAttachIsNull?id='+invc.id); 
                        try {
                             if(Test.IsRunningTest()){
                             body = Blob.valueOf('Some Text');
                            }
                        else{
                            System.debug(' ==> as Apex normal Class <== ');
                            body = pdff.getContentAsPDF();
                            Attachment attach = new Attachment(); 
                            attach.Body = body;
                            attach.name= invc.name +'_Invoice_'+ Datetime.Now() +'.PDF';
                            attach.IsPrivate = false;
                            attach.ParentId = invc.id;
                            attach.contentType = 'application/pdf';
                            attInsert.add(attach);   
                            }
                         } 
                        catch (VisualforceException e) {
                            String msg2 = e.getMessage();
                            return DownloadInvoiceResponse.errorJson( msg2 );
                           }
                       }                               
                    }       
                }    

        Insert attInsert;

        integer totalSizeOfFiles=0;
        integer totalSizeAnInvoice=0;
        String invoiceId='';
        set<String> remainingsIdsSet=new set<String>();
        List<attachment> attachmentList = new List<attachment>();
          //for(attachment att:[select ParentId,id,Name,Body,contenttype from attachment where ParentId IN:ids]) {
          for(attachment att: attInsert) {          
                integer eachFileSize=att.Body.size();
                String parentId=att.ParentId;
                att.contenttype='application/pdf';
                if(!invoiceId.equals(parentId)){
                    invoiceId=parentId;
                    totalSizeAnInvoice=eachFileSize;
                    System.debug('--ID: '+att.id+'. ParentId: '+parentId+'. FileSize: '+eachFileSize+'. TotalInvoiceSize: '+totalSizeAnInvoice);
                }else if(invoiceId.equals(parentId)){
                    totalSizeAnInvoice=totalSizeAnInvoice+eachFileSize;
                    System.debug('--ID: '+att.id+'. ParentId: '+parentId+'. FileSize: '+eachFileSize+'. TotalInvoiceSize: '+totalSizeAnInvoice);
                }
                if(eachFileSize<4500000 && totalSizeAnInvoice<4500000){
                    totalSizeOfFiles=totalSizeOfFiles+eachFileSize;
                    System.debug('--ID: '+parentId+'. FileSize: '+eachFileSize+'. TotalFileSize: '+totalSizeOfFiles+'. HeapSize: '+Limits.getHeapSize());
                    if(totalSizeOfFiles>= 4500000){
                          System.debug('--Adding to RemIDs ID: '+parentId+'. FileSize: '+eachFileSize);
                          remainingsIdsSet.add(parentId);
                     }else{
                          attachmentList.add(att);                      
                     }
                 }
           }
             String remainingIds=null;
             List<String> remainingIdList=new List<String>(remainingsIdsSet);
             for(integer i=0;i<remainingIdList.size();i++){
                 if(i==0){
                     remainingIds=remainingIdList.get(i);
                 }else{
                     remainingIds=remainingIds+','+remainingIdList.get(i);
                  }                 
             }

             List<Object> dataList = new List<Object>();
             for(Attachment at :attachmentList)
             {
                Map<String, String> atMap = new Map<String, String>();
                atMap.put( 'Name', at.Name );
                atMap.put( 'Body', EncodingUtil.base64Encode( at.body ));
                datalist.add( atMap );

             }

                 Map<String, Object> response = new Map<String, Object>();
                 response.put('status', API_STATUS_NORMAL);
                 if( datalist != null ){
                     response.put('data',datalist);
                     response.put('id', remainingIds);
                 }
                 return json.serialize( response );
          }                      

     }
}

How to deal with multiple selection of records with notes and attachments and without notes and attachments. Any help is appreciable. Thanks
logontokartiklogontokartik
Looking at the code, I see that the class is built to handle only 1 invoice at a time i.e via passing the invoice id as Page Parameter to the Visualforce that is rendering as PDF.

See lines 43 and 71
 
PageReference pdf = new PageReference('/apex/InvoicePDF?id='+invc.id);
PageReference pdff = new PageReference('/apex/InvoicesIfAttachIsNull?id='+invc.id);
The above lines clearly are using invoice Id as you can see.

If you want to handle multiple records that will be not a single line change. You need explain your requirements with your developer who built the code and make code changes to the way pages are built and if necessary the controller class as well.
 
Mohammed AzarudeenMohammed Azarudeen
here is my updated code 
problem here is,
    If i try to download Multiple records its downloading the last one record only.

for example:

If I click on two invoices called,
  • Invc-00000001 (with Attachments) it should download the InvoicePDF
  • Invc-00000002 (with Attachments) it should download the InvoicePDF

It is only downloading the second Invoice with the name Invc-00000002.

How to overcome this?

My Updated code 
global class DownloadInvoice 
   {
    // Receive Attachments info from Attachment ParentId
    private static String API_STATUS_NORMAL = '200';

    webService static string getAttachmentByParentId(string sfdcId)
      {

       List<id> ids = new List<id>();
        if(string.isempty(sfdcId))  {
           return DownloadInvoiceResponse.errorJson('Parameter sfdcId is required.');
         }

          string[] idsArray = sfdcId.split(',');
          for(integer i=0; i<idsArray.size();i++)
           {
                ids.add(idsArray[i]);
           }


           List<Invoice__c> invList = New List<Invoice__c>();
           invList = [Select id, name, Print_Invoice__c,Account__r.name from Invoice where ID IN: ids];

           List<Attachment> attInsert = new List<Attachment>();

           if(invList.size() > 0){

           for(Invoice__c invc : invList){

              Blob body;

              Attachment[] attachments = [SELECT ParentId FROM Attachment where ParentId IN:ids];

              for (Attachment a : attachments){
                attchmentParentIds.add(a.ParentId);
              }

              Integer WithAttachCount = [SELECT count() FROM Attachment where ParentId IN:ids AND id !=null]

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

                 if(WithAttachCount > 0 && attchmentParentIds.get(0) == invc.Id){
                    PageReference pdf = new PageReference('/apex/InvoicePDF?id='+invc.id);
                    body = pdf.getContentAsPDF(); 

                  }

                  else if(WithAttachCount <= 0){

                    PageReference pdff = new PageReference('/apex/InvoiceIfAttachIsNull?id='+invc.id);
                    body = pdff.getContentAsPDF();
                    }

                }                              
                attach.Body = body;
                attach.name= invc.name +'_Invoice_'+ Datetime.Now() +'.PDF';
                attach.IsPrivate = false;
                attach.ParentId = invc.id;
                attach.contentType = 'application/pdf';
                attInsert.add(attach);     

                    }    
                }

      Insert attInsert;
}