topic Re: Add Text/Table with values to pdf !!! in Alfresco Archive

Add Text/Table with values to pdf !!!

irenailievska — Fri, 13 Feb 2015 10:29:11 GMT

I need to add small table filled with properties from my custom content model in the upper right corner of the pdf document. I am supposed to add this to an existing pdf document. This should be executed when I activate the action defined in share-config-custom.xml (DocLibActions). I am a beginner i

Re: Add Text/Table with values to pdf !!!

s_palyukh — Mon, 16 Feb 2015 10:53:06 GMT

Hello,

I believe the following post will be useful for you: http://www.marversolutions.com/wordpress/2012/04/15/adding-document-library-actions-in-alfresco-4-0/

Re: Add Text/Table with values to pdf !!!

irenailievska — Mon, 16 Feb 2015 11:10:29 GMT

I have seen this post. It's very helpful and I was using it to write the code I need in order to show the action and call a java class as a executor. But I have no Idea how to get the pdf from nodeRef or how to insert a table in a specific place. If there is a way by using JavaScript I would be glad to try it, although I haven't worked with javaScript very much and would be needing some guidance.
Thanks in advance,
Irena

Re: Add Text/Table with values to pdf !!!

s_palyukh — Mon, 16 Feb 2015 12:45:58 GMT

No, you can't use JS API to add table into PDF file. Use IText to create pdf table (http://itextpdf.com/examples/iia.php?id=75).

If you want to write into the file by NodeRef then look at the org.alfresco.service.cmr.repository.ContentService.


            ContentWriter writer = contentService.getWriter(nodeRef, ContentModel.PROP_CONTENT, true);
            writer.putContent(inputStream);

‍‍‍‍‍

Re: Add Text/Table with values to pdf !!!

irenailievska — Mon, 16 Feb 2015 13:23:56 GMT

Ok thanks a lot for the directions !!!

I have two more questions (sorry if they sound stupid - I don't have experience working with alfresco or java for that matter):

1. What is inputStream - because I need to insert table in the pdf document. Is it String or something else ?
2. How do I manipulate with writer ? Do I use it to create the table and to set the position for my table?
I am confused by this because in most of the examples and in the one you gave me, they create new document and I don`t know how to retrieve the existing one. They use :



 Document document = new Document();
        // step 2
        PdfWriter.getInstance(document, new FileOutputStream(filename));
        // step 3
        document.open();
        // step 4
        document.add(createFirstTable());
        // step 5
        document.close();

‍‍‍‍‍‍‍‍‍‍‍‍‍

and as I have noticed they have


   public static final String RESULT = "results/part1/chapter04/first_table.pdf";
‍‍‍

where they save the document. I need the document to stay in the same place.

Sorry but I am beginner and don`t really understand some of the things.

Thanks,
Irena

Re: Add Text/Table with values to pdf !!!

s_palyukh — Mon, 16 Feb 2015 13:35:00 GMT

1) About inputStream -> http://tutorials.jenkov.com/java-io/inputstream.html
2) You need to get OutputStream from Writer, something like that:


 Document document = new Document();
        // step 1 
        ContentWriter writer = contentService.getWriter(nodeRef, ContentModel.PROP_CONTENT, true);
        // step 2
        PdfWriter.getInstance(document, writer.getContentOutputStream());
        // step 3
        document.open();
        // step 4
        document.add(createFirstTable());
        // step 5
        document.close();
‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Add Text/Table with values to pdf !!!

irenailievska — Mon, 16 Feb 2015 13:46:00 GMT

If I use document.close() do I still need to use writter.putContent(inputStream) ?
Is this what I need from InputStream ?



InputStream inputStream = new ByteArrayInputStream(content.getBytes(encoding));

‍‍‍‍‍

Re: Add Text/Table with values to pdf !!!

s_palyukh — Mon, 16 Feb 2015 14:26:50 GMT

1) If I use document.close() do I still need to use writter.putContent(inputStream) ? - No, you don't
2) Is this what I need from InputStream ? - If you use PdfWriter to write content then you don't need inputstream

Re: Add Text/Table with values to pdf !!!

irenailievska — Tue, 17 Feb 2015 09:23:00 GMT

I tried doing it like you suggested but there are errors and I can't start the explorer at all.
Here Is my code:


   
package my.action.executer;

import java.util.List;

import my.model.myModel;

import org.alfresco.model.ContentModel;
import org.alfresco.repo.action.ParameterDefinitionImpl;
import org.alfresco.repo.action.executer.ActionExecuterAbstractBase;
import org.alfresco.service.cmr.action.Action;
import org.alfresco.service.cmr.action.ParameterDefinition;
import org.alfresco.service.cmr.dictionary.DataTypeDefinition;
import org.alfresco.service.cmr.repository.ContentService;
import org.alfresco.service.cmr.repository.ContentWriter;
import org.alfresco.service.cmr.repository.NodeRef;
import org.alfresco.service.cmr.repository.NodeService;
import org.alfresco.service.namespace.QName;
import org.springframework.beans.factory.InitializingBean;
import org.springframework.util.Assert;

import com.itextpdf.text.Document;
import com.itextpdf.text.Phrase;
import com.itextpdf.text.pdf.PdfContentByte;
import com.itextpdf.text.pdf.PdfPCell;
import com.itextpdf.text.pdf.PdfPTable;
import com.itextpdf.text.pdf.PdfWriter;

public class InsertArchiveStamp extends ActionExecuterAbstractBase
   implements InitializingBean {

    public static final String NAME = "watermark";
    public static final String PARAM_TEXT = "watermark-text";

    private ContentService contentService;
    protected NodeService nodeService;
    
    public void setContentService(ContentService contentService) {
   this.contentService = contentService;
    }

    public void afterPropertiesSet() throws Exception {
   Assert.notNull(contentService);
    }

    @Override
    protected void executeImpl(Action action, NodeRef actionedUponNodeRef) {
       
         
       Document document = new Document();
       // step 1 
       try{ 
       ContentWriter writer = contentService.getWriter(actionedUponNodeRef, ContentModel.PROP_CONTENT, true);
       
      // PdfContentByte canvas = ((PdfWriter) writer).getDirectContent();
       // step 2
       PdfWriter.getInstance(document, writer.getContentOutputStream());
       // step 3
       document.open();
       
       
       //////////////////////////////////////////////////////
      
    // a table with three columns
        PdfPTable table = new PdfPTable(4);
        // the cell object
        PdfPCell cell;
        
        // we add a cell with colspan 3
        cell = new PdfPCell(new Phrase("Примено:"));
        cell.setColspan(4);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase("Орг.един."));
        table.addCell(cell);
        // we add the four remaining cells with addCell()
        table.addCell("Број:");
        table.addCell("Прилог:");
        table.addCell("Вредност:");
        
        cell = new PdfPCell(new Phrase(""));
        cell.setRowspan(2);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase(""));
        cell.setRowspan(2);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase(""));
        cell.setRowspan(2);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase(""));
        cell.setRowspan(2);
        table.addCell(cell);
        
       
       //////////////////////////////////////////////
       
       // step 4
       document.add(table);
       
       // step 5
       document.close();
     }
     catch(Exception e){
        
     }
       
    }


    /* I THOUGHT TO PUT THE CREATING OF THE TABLE AS IN THE EXAMPLE - IN FUNCTION 
    public static PdfPTable createTable() {
       // a table with three columns
        PdfPTable table = new PdfPTable(4);
        // the cell object
        PdfPCell cell;
        

        ////////////////////////////////////////////////////////////////////////////////////////////

              THIS CODE IS FOR GETTING THE VALUES FROM MY CONTENT MODEL
            
        //QName PROP_QNAME_NAME = QName.createQName(myModel.NAMESPACE_ALFRESCO_MODEL, "name");   
   //String fileName = (String) nodeService.getProperty(actionedUponNodeRef, PROP_QNAME_NAME);



        ///////////////////////////////////////////////////////////////////////////////////////////
        // we add a cell with colspan 3
        cell = new PdfPCell(new Phrase("Примено:"));
        cell.setColspan(4);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase("Орг.един."));
        table.addCell(cell);
        // we add the four remaining cells with addCell()
        table.addCell("Број:");
        table.addCell("Прилог:");
        table.addCell("Вредност:");
        
        cell = new PdfPCell(new Phrase(""));
        cell.setRowspan(2);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase(""));
        cell.setRowspan(2);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase(""));
        cell.setRowspan(2);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase(""));
        cell.setRowspan(2);
        table.addCell(cell);
        
        //table.setTotalWidth(104);
        //table.completeRow();
        // write the table to an absolute position
       // table.writeSelectedRows(0, -1, 169, table.getTotalHeight() + 20, canvas);
        return table;
    }
*/
    @Override
    protected void addParameterDefinitions(List<ParameterDefinition> paramList) {
   paramList
      .add(new ParameterDefinitionImpl(PARAM_TEXT,
         DataTypeDefinition.TEXT, 
         false,
         getParamDisplayLabel(PARAM_TEXT)));
         
       return;
    }
    
    public void setNodeService(NodeService nodeService) {
      this.nodeService = nodeService;
   }
}

   
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The action is called on click on the action defined in share-config-custom.xml and there is a bean defined in service-context.xml.

I need to create the table and add values from my content model. I have the piece of code marked in my executor class. I have no idea what could be wrong.
There is a file attached I copied from the console.

Thanks,
Irena

Re: Add Text/Table with values to pdf !!!

irenailievska — Tue, 17 Feb 2015 09:24:59 GMT

There says that there is no itextpdf.text.Element. I don't know how to resolve this

Re: Add Text/Table with values to pdf !!!

s_palyukh — Tue, 17 Feb 2015 09:38:05 GMT

How do you deploy your changes on the server? Do you use Maven in development of the code?

looks like you didn't add jar into the lib folder…

1) Download IText archive http://sourceforge.net/projects/itext/files/iText/iText5.5.5/
2) unzip it
3) Put needed jars into {tomcat}/webapps/alfresco/WEB-INF/lib

Re: Add Text/Table with values to pdf !!!

irenailievska — Tue, 17 Feb 2015 10:07:00 GMT

Yes I use Maven. I did add the jar - I added even three…. But your version took care of the problem! Thanks
Ok I created the table, but it appears that when I insert the table I somehow delete the content that was in the pdf document. And since I have to insert cyrillic text I put it in the cells but it doesn't show. I even tried to set width with


table.setTotalWidth(104);
‍‍‍

but it did nothing
Thanks a lot ,
Irena

Re: Add Text/Table with values to pdf !!!

s_palyukh — Tue, 17 Feb 2015 11:58:31 GMT

Should be something like that (http://stackoverflow.com/questions/3335126/itext-add-content-to-existing-pdf-file😞



// Create output PDF
Document document = new Document(PageSize.A4);

ContentWriter writer = contentService.getWriter(actionedUponNodeRef, ContentModel.PROP_CONTENT, true);

PdfWriter writer = PdfWriter.getInstance(document, writer.getContentOutputStream());

document.open();

PdfContentByte cb = writer.getDirectContent();

// Load existing PDF

ContentReader cread = contentService.getReader(actionedUponNodeRef, ContentModel.PROP_CONTENT);
PdfReader reader = new PdfReader(cread.getContentInputStream());
PdfImportedPage page = writer.getImportedPage(reader, 1); 

// Copy first page of existing PDF into output PDF
document.newPage();
cb.addTemplate(page, 0, 0);

// Add your new data / text here
// for example…
document.add(new Paragraph("my timestamp")); 

document.close();
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Add Text/Table with values to pdf !!!

irenailievska — Tue, 17 Feb 2015 12:28:00 GMT

I am going to try that, but before that I have one more question. When I try to read a property from my custom content model I get an error. I am trying with this code


….
   QName PROP_QNAME_NAME = QName.createQName(myModel.NAMESPACE_MY_MODEL, "name");   
   String fileName = (String) nodeService.getProperty(actionedUponNodeRef, PROP_QNAME_NAME);
   String[] array = fileName.split("_");
….

cell = new PdfPCell(new Phrase(" "+array[0]));
        cell.setRowspan(2);
        table.addCell(cell);

….

‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I guess it's because of the nodeService. Can I do this? (Add nodeService and contentService? )



   <bean id="insert-archive-stamp" class="neoarchive.action.executer.InsertArchiveStamp" parent="action-executer">
      <property name="contentService">
         <ref bean="contentService" />
      </property>

                <property name="nodeService">
         <ref bean="NodeService" />
      </property>
 
      <property name="publicAction">
         <value>false</value>
      </property>
   </bean>

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks,
Irena

Re: Add Text/Table with values to pdf !!!

s_palyukh — Tue, 17 Feb 2015 12:35:59 GMT

sure, you can add any service that you need and inject it through the spring context

Re: Add Text/Table with values to pdf !!!

irenailievska — Fri, 20 Feb 2015 13:46:11 GMT

Before I was able to add my filled table, but now it isn't showing at all.
I just need it to be in the corner of the first page.
- How can I insert my table/text in the right top corner without moving the content that previously was there?
- What happens if the pdf I am inserting my text/table has more than one page?
- How do I take the rest of the pages?
This is my code



 Document document = new Document(PageSize.A4);
       // step 1 
       try{ 
          ContentWriter writer = contentService.getWriter(actionedUponNodeRef, ContentModel.PROP_CONTENT, true);
          // step 2
          PdfWriter.getInstance(document, writer.getContentOutputStream());
          // step 3
          document.open();
       
          //NEW
          PdfContentByte cb =  (PdfContentByte)((PdfWriter) writer).getDirectContent();
          ContentReader cread = contentService.getReader(actionedUponNodeRef, ContentModel.PROP_CONTENT);
          PdfReader reader = new PdfReader(cread.getContentInputStream());
          PdfImportedPage page = (PdfImportedPage)((PdfWriter) writer).getImportedPage(reader, 1); 
          document.newPage();
          cb.addTemplate(page, 0, 0);
       
       
    // a table with three columns
        PdfPTable table = new PdfPTable(3);
        // the cell object
        PdfPCell cell;
        
        // we add a cell with colspan 3
        cell = new PdfPCell(new Phrase("Primeno " +date[0]));// day + "." + month + "." + year ));
        cell.setColspan(4);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase("Org.edin"));
        table.addCell(cell);
        table.addCell("Broj");
        table.addCell("Podbroj");
        
        cell = new PdfPCell(new Phrase(""+array[0]));
        cell.setRowspan(2);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase(""+array[1]));
        cell.setRowspan(2);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        table.addCell(cell);
        
        cell = new PdfPCell(new Phrase(""+array[2]));
        cell.setRowspan(2);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        table.addCell(cell);
        
        table.setWidthPercentage(30);
        table.setHorizontalAlignment(Element.ALIGN_RIGHT);
       
       // step 4
       document.add(table);
       
       // step 5
       document.close();
     }
     catch(Exception e){
        
     }
       


‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Add Text/Table with values to pdf !!!

s_palyukh — Fri, 20 Feb 2015 13:59:52 GMT

Take a look at the following code http://itextpdf.com/sandbox/events/Watermarking . Maybe it will help you