Hi Loftux,
Thanks for your suggestion.I modified Content Model to set user statistics & used webscripts to get it per user , its working fine.
http://forums.alfresco.com/en/viewtopic.php?f=36&t=26649&start=0
Thanks for your suggestion.I modified Content Model to set user statistics & used webscripts to get it per user , its working fine.
http://forums.alfresco.com/en/viewtopic.php?f=36&t=26649&start=0
Hi Sanket,
I tried the same to create a custom table & insert data but was not fruitful as i was also getting NPE.
My requirement was to get user statistics per user in Alfresco,to get total number of doc uploaded by him in DM, no of approvals & rejection for him etc.
I tried hard but inserting into Alfresco DB schema seems to be trivial. I tried a lot but could not achieve it successfully.
Finally, i modified content model to get these details.Here is a snippet contentModel.xml:
I injected three more properties : contentStatus,originalOwner & contentRating.
Now once content is under workflow, i am setting values of these properties using NodeService in ActionHandler as :
Hereby the values are set for these properties.
Now to retrieve these properties, i used NodeService in a web script to be invoked from a dashlet JSP as:
Finally i got the output in jsp which is as:
This is how i implemented the requirement.You can take a que from here if it is helpful.
Also if you find out how to implement DB tables in alfresco, please share it with me. :arrow:
I tried the same to create a custom table & insert data but was not fruitful as i was also getting NPE.
My requirement was to get user statistics per user in Alfresco,to get total number of doc uploaded by him in DM, no of approvals & rejection for him etc.
I tried hard but inserting into Alfresco DB schema seems to be trivial. I tried a lot but could not achieve it successfully.
Finally, i modified content model to get these details.Here is a snippet contentModel.xml:
…
<type name="cm:content">
<title>Content</title>
<parent>cm:cmobject</parent>
<archive>true</archive>
<properties>
<property name="cm:content">
<type>d:content</type>
<mandatory>false</mandatory>
<!– Although content is marked as indexed atomically it may end up asynchronous –>
<!– if the content conversion will take too long. Content that does not require conversion –>
<!– to UTF8 test/plain will always be indexed atomically –>
<index enabled="true">
<atomic>true</atomic>
<stored>false</stored>
<tokenised>true</tokenised>
</index>
</property>
<!–Custom Properties added by Lalit for User Statistics.–>
<property name="cm:contentStatus">
<type>d:text</type>
<mandatory>false</mandatory>
</property>
<property name="cm:originalOwner">
<type>d:text</type>
<mandatory>false</mandatory>
</property>
<property name="cm:contentRating">
<type>d:text</type>
<mandatory>false</mandatory>
</property>
<!–Custom Properties added by Lalit for User Statistics.–>
</properties>
</type>
…
I injected three more properties : contentStatus,originalOwner & contentRating.
Now once content is under workflow, i am setting values of these properties using NodeService in ActionHandler as :
package com.xxxx.alfresco.km.bpm;
import java.io.IOException;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import javax.faces.context.FacesContext;
import org.alfresco.deployment.transformers.CompressionTransformer;
import org.alfresco.model.ContentModel;
import org.alfresco.repo.content.MimetypeMap;
import org.alfresco.repo.content.transform.ComplexContentTransformer;
import org.alfresco.repo.content.transform.ComplexContentTransformerTest;
import org.alfresco.repo.content.transform.ContentTransformer;
import org.alfresco.repo.content.transform.PoiHssfContentTransformer;
import org.alfresco.repo.security.authentication.AuthenticationUtil;
import org.alfresco.repo.workflow.jbpm.JBPMSpringActionHandler;
import org.alfresco.service.Auditable;
import org.alfresco.service.PublicService;
import org.alfresco.service.ServiceRegistry;
import org.alfresco.service.cmr.model.FileFolderService;
import org.alfresco.service.cmr.model.FileInfo;
import org.alfresco.service.cmr.repository.ChildAssociationRef;
import org.alfresco.service.cmr.repository.ContentData;
import org.alfresco.service.cmr.repository.ContentIOException;
import org.alfresco.service.cmr.repository.ContentReader;
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.cmr.repository.TransformationOptions;
import org.alfresco.service.cmr.search.CategoryService;
import org.alfresco.service.namespace.QName;
import org.alfresco.web.bean.repository.Node;
import org.alfresco.web.bean.repository.Repository;
import org.alfresco.web.ui.common.Utils;
import org.alfresco.web.ui.common.Utils.URLMode;
import org.apache.log4j.Logger;
import org.jbpm.context.exe.ContextInstance;
import org.jbpm.graph.exe.ExecutionContext;
import org.springframework.beans.factory.BeanFactory;
import com.xxxx.alfresco.km.property.KmPropertyReader;
/**
* @author Lalit Jangra
* Action Class for xxxx Approval Workflow. Content is
* moved to "Under Review" once it is uploaded. If content is approved,
* it will be moved back to original location. If content is rejected,
* it will be moved to User Home of Workflow initiator.Also as per approval
* or rejection, content will be assigned a property to get/set user statistics.
*/
@PublicService
public class KMReviewProcessAction extends JBPMSpringActionHandler {
private static final long serialVersionUID = 1L;
private static Logger logger = Logger
.getLogger(KMReviewProcessAction.class);
private ServiceRegistry services;
private FileFolderService fileFolderService;
private NodeService nodeService;
int approvalRating = 5;
int rejOrURRating = 0;
ContentService contentService = null;
String content = "";
CategoryService categoryService = null;
List<String> categoryList = new ArrayList<String>();
private String solrServIp = null;
private String solrFileLoc = null;
private String alfServerIp = null;
/**
* Method to initialize services.
*/
@Override
protected void initialiseHandler(BeanFactory factory) {
logger.debug("Inside initialiseHandler of KMReviewProcessAction!!!!");
services = (ServiceRegistry) factory
.getBean(ServiceRegistry.SERVICE_REGISTRY);
fileFolderService = services.getFileFolderService();
services.getAuditService();
nodeService = services.getNodeService();
contentService = services.getContentService();
logger.debug("contentService "+contentService );
categoryService = services.getCategoryService();
}
/**
* Method to move content in workflow. It will move content depending upon
* wfFlag variable value.Also it will get/set the user statistics by use of 'contentStatus' property.
* For under review or rejected content, rating will be 0 & for approved content, rating will be 5.
* Once content is approved , an XML is formed to be posted to SOLR.
**/
@Auditable
public void execute(ExecutionContext context) throws Exception {
logger.debug("Inside execute of KMReviewProcessAction");
try{
KmPropertyReader kmPropertyReader = new KmPropertyReader();
solrServIp = kmPropertyReader.getProperty("solr.server.ip");
logger.debug("solrServIp : "+solrServIp);
solrFileLoc = kmPropertyReader.getProperty("solr.file.location");
logger.debug("solrFileLoc : "+solrFileLoc);
alfServerIp = kmPropertyReader.getProperty("alfresco.server.ip");
logger.debug("alfServerIp : "+alfServerIp);
}catch (Exception e) {
logger.error("Error while reading property in KMReviewProcessAction : "+e.getMessage());
}
final ContextInstance contextInstance = context.getContextInstance();
AuthenticationUtil.runAs(new AuthenticationUtil.RunAsWork<Object>() {
String userName = (String) contextInstance.getVariable("userName");
String wfFlag = (String) contextInstance.getVariable("wfFlag");
NodeRef nodeRef = (NodeRef) contextInstance.getVariable("nodeRef");
NodeRef targetNodeRef = (NodeRef) contextInstance
.getVariable("targetNodeRef");
NodeRef docParentRef = (NodeRef) contextInstance
.getVariable("docParentRef");
NodeRef userHomeRef = (NodeRef) contextInstance
.getVariable("userHomeRef");
List<ChildAssociationRef> children = null;
String docPath = (String) contextInstance.getVariable("docPath");
String docName = (String) contextInstance.getVariable("docName");
public Object doWork() throws Exception {
logger.debug("User name " + userName);
logger.debug("wfFlag in KMReviewProcessAction " + wfFlag);
logger.debug("docPath in execute() " + docPath);
logger.debug("docName in execute() " + docName);
logger.debug("nodeRef in execute() " + nodeRef);
logger.debug("targetNodeRef in execute() " + targetNodeRef);
logger.debug("docParentRef in execute() " + docParentRef);
logger.debug("userHomeRef in execute() " + userHomeRef);
if (wfFlag.equalsIgnoreCase("Moved")) { //Under Review Case
// Moving Content from its original location to Under Review.
logger.debug("Moving content to Under Review & set user statistics properties");
try {
@SuppressWarnings("unused")
FileInfo fileInfo = fileFolderService.move(nodeRef,
targetNodeRef, null);
Map<QName, Serializable> propertyMap = nodeService
.getProperties(nodeRef);
QName statusQname = QName.createQName("{http://www.alfresco.org/model/content/1.0}contentStatus");
QName contentRating = QName.createQName("{http://www.alfresco.org/model/content/1.0}contentRating");
QName ownerQname = QName.createQName("{http://www.alfresco.org/model/content/1.0}originalOwner");
propertyMap.put(statusQname, "underreview");
propertyMap.put(contentRating,getRating(rejOrURRating, nodeRef, userName));
propertyMap.put(ownerQname, userName);
nodeService.setProperties(nodeRef, propertyMap);
} catch (Exception e) {
logger
.error("Error while moving content to Under Review "
+ e.getMessage());
}
} else if (wfFlag.equalsIgnoreCase("Approved")) { //Content Approval Case
// Move Content back to original location.
logger.debug("Moving Content back after Approval & set user statistics properties");
try {
@SuppressWarnings("unused")
FileInfo fileInfo = fileFolderService.move(nodeRef,
docParentRef, null);
Map<QName, Serializable> propertyMap = nodeService
.getProperties(nodeRef);
QName statusQname = QName.createQName("{http://www.alfresco.org/model/content/1.0}contentStatus");
QName ownerQname = QName.createQName("{http://www.alfresco.org/model/content/1.0}originalOwner");
QName contentRating = QName.createQName("{http://www.alfresco.org/model/content/1.0}contentRating");
propertyMap.put(statusQname, "approved");
propertyMap.put(ownerQname, userName);
propertyMap.put(contentRating,getRating(approvalRating, nodeRef, userName));
nodeService.setProperties(nodeRef, propertyMap);
} catch (Exception e) {
logger
.error("Error while moving content to original location after approval : "
+ e.getMessage());
e.printStackTrace();
}
} else if (wfFlag.equalsIgnoreCase("Rejected")) { //Content Rejection Case
// Move content to User Home.
logger.debug("Moving Content to User Home after Rejection & set user statistics properties");
try {
FileInfo fileInfo = fileFolderService.move(nodeRef,
userHomeRef, null);
Map<QName, Serializable> propertyMap = nodeService
.getProperties(nodeRef);
QName statusQname = QName.createQName("{http://www.alfresco.org/model/content/1.0}contentStatus");
QName ownerQname = QName.createQName("{http://www.alfresco.org/model/content/1.0}originalOwner");
QName contentRating = QName.createQName("{http://www.alfresco.org/model/content/1.0}contentRating");
propertyMap.put(statusQname, "rejected");
propertyMap.put(ownerQname, userName);
propertyMap.put(contentRating,getRating(rejOrURRating, nodeRef, userName));
nodeService.setProperties(nodeRef, propertyMap);
System.out.println("After Rejection "
+ fileInfo.getName());
} catch (Exception e) {
logger.error("Error while moving content to User Home after rejection "
+ e.getMessage());
}
}
return children;
}
}, "admin");
}
/*
* Method to get overall rating for a user.
*/
public String getRating(int newRating, NodeRef nodeRef,String userName){
QName contentRating = QName.createQName("{http://www.alfresco.org/model/content/1.0}contentRating");
String totalCurRating = null;
try{
totalCurRating = nodeService.getProperty(nodeRef, contentRating).toString();
}catch (NullPointerException e) {
logger.debug("Null Rating for user in getRating()");
totalCurRating = "0";
}
int tempRating = new Integer(totalCurRating).intValue();
int overallRating = tempRating + newRating;
logger.debug("Final rating for content "+overallRating);
String result = "";
return (result+overallRating);
}
Hereby the values are set for these properties.
Now to retrieve these properties, i used NodeService in a web script to be invoked from a dashlet JSP as:
package com.xxxx.alfresco.km.webscripts;
import java.io.IOException;
import org.alfresco.service.ServiceRegistry;
import org.alfresco.service.cmr.repository.NodeRef;
import org.alfresco.service.cmr.repository.NodeService;
import org.alfresco.service.cmr.repository.StoreRef;
import org.alfresco.service.cmr.search.ResultSet;
import org.alfresco.service.cmr.search.ResultSetRow;
import org.alfresco.service.cmr.search.SearchParameters;
import org.alfresco.service.cmr.search.SearchService;
import org.alfresco.service.namespace.QName;
import org.alfresco.web.scripts.AbstractWebScript;
import org.alfresco.web.scripts.WebScriptRequest;
import org.alfresco.web.scripts.WebScriptResponse;
import org.apache.log4j.Logger;
/**
* @author Lalit Jangra
* Web Script to get user statistics per user. User name
* will be passed a parameter on basis of which all content on which he
* is owner will be searched. Once all content are available, it will be
* checked for approved, rejected & under review property.
* Finally an HTML string will be returned back as output to a custom dashlet for the same.
*/
public class GetUserStatisticsWebScript extends AbstractWebScript {
private static Logger logger = Logger
.getLogger(GetUserStatisticsWebScript.class);
private SearchService searchService;
private ServiceRegistry serviceRegistry;
private NodeService nodeService;
/*
* Method to get user statistics. User name will be passed as a request parameter &
* for this user, a search will be performed to get all the content of which he is
* original owner. After this, each of content in resultset will be checked for the
* status.
*/
public void execute(WebScriptRequest req, WebScriptResponse res)
throws IOException {
int totalNoOfContent = 0;
int approvedContent = 0;
int rejectedContent = 0;
int underReviewContent = 0;
String ratingPerContent = null;
NodeRef currentNodeRef = null;
int ratingToDisplay = 0;
String userName = req.getParameter("userName");
logger.debug("User name to get statistics for : " + userName);
nodeService = serviceRegistry.getNodeService();
StoreRef storeRef = new StoreRef(StoreRef.PROTOCOL_WORKSPACE,"SpacesStore");
SearchParameters sp = new SearchParameters();
sp.addStore(storeRef);
sp.setLanguage(SearchService.LANGUAGE_LUCENE);
sp.setQuery("@cm\\:originalOwner:" + userName + "");
ResultSet results = null;
try {
results = getSearchService().query(sp);
totalNoOfContent = results.length();
//logger.debug("Size of resultset is " + totalNoOfContent);
for (ResultSetRow row : results) {
currentNodeRef = row.getNodeRef();
QName statusQname = QName
.createQName("{http://www.alfresco.org/model/content/1.0}contentStatus");
nodeService.getProperty(currentNodeRef, statusQname);
//logger.debug("Status for "+ currentNodeRef.toString()+ " is "+ nodeService.getProperty(currentNodeRef, statusQname).toString());
if((nodeService.getProperty(currentNodeRef, statusQname)
.toString()).equalsIgnoreCase("underreview")){
underReviewContent = underReviewContent + 1;
}else if ((nodeService.getProperty(currentNodeRef, statusQname)
.toString()).equalsIgnoreCase("approved")) {
approvedContent = approvedContent + 1;
} else if ((nodeService
.getProperty(currentNodeRef, statusQname).toString())
.equalsIgnoreCase("rejected")) {
rejectedContent = rejectedContent + 1;
}
//For User Rating.
QName contentRating = QName.createQName("{http://www.alfresco.org/model/content/1.0}contentRating");
try{
ratingPerContent = nodeService.getProperty(currentNodeRef, contentRating).toString();
ratingToDisplay += new Integer(ratingPerContent).intValue();
}catch (NullPointerException e) {
//logger.debug("Null Rating for user in GetUserStatisticsWebScript");
ratingToDisplay = 0;
}
}
logger.debug("totalNoOfContent for " + userName+ " : " + totalNoOfContent);
logger.debug("approvedContent for " + userName+ " : " + approvedContent);
logger.debug("rejectedContent for " + userName+ " : " + rejectedContent);
logger.debug("underReviewContent for " + userName+ " : " + underReviewContent);
logger.debug("ratingToDisplay for " + userName+ " : " + ratingToDisplay);
//Creating an HTML String that include total output.
res.setContentType("text/html");
String finalOutput = "";
finalOutput += "<html>"+
"<body>"+
"<table border=1>"+
"<tr>"+
"<th>"+
"Total No of KM Contribution"+
"</th>"+
"<th>"+
"Total No of KM Approvals"+
"</th>"+
"<th>"+
"Total No of KM Disapprovals"+
"</th>"+
"<th>"+
"Total No of KM Under Reviews"+
"</th>"+
"<th>"+
"Total User Rating"+
"</th>"+
"</tr>";
finalOutput += "<tr><td align=center>";
finalOutput +=totalNoOfContent;
finalOutput += "</td><td align=center>";
finalOutput += approvedContent;
finalOutput += "</td><td align=center>";
finalOutput += rejectedContent;
finalOutput += "</td><td align=center>";
finalOutput += underReviewContent;
finalOutput += "</td><td align=center>";
finalOutput += ratingToDisplay;
finalOutput += "</td></tr></table></body></html>";
res.getWriter().write(finalOutput);
} finally {
if (results != null) {
totalNoOfContent = 0;
approvedContent = 0;
rejectedContent = 0;
underReviewContent = 0;
ratingToDisplay = 0;
results.close();
}
}
}
public ServiceRegistry getServiceRegistry() {
return serviceRegistry;
}
public void setServiceRegistry(ServiceRegistry serviceRegistry) {
this.serviceRegistry = serviceRegistry;
}
public void setSearchService(SearchService searchService) {
this.searchService = searchService;
}
public SearchService getSearchService() {
return searchService;
}
}
Finally i got the output in jsp which is as:
<%@ taglib uri="/WEB-INF/repo.tld" prefix="r" %>
<%@ page import="com.xxxx.alfresco.km.webscripts.WebScriptInvoker"%>
<%@ page import="com.xxxx.alfresco.km.webscripts.WebScriptCall"%>
<r:webScript scriptUrl="/wcservice/com/xxxx/alfresco/km/getuserstatistics?userName=#{NavigationBean.currentUser.userName}" />
This is how i implemented the requirement.You can take a que from here if it is helpful.
Also if you find out how to implement DB tables in alfresco, please share it with me. :arrow:
