/*

  * Copyright 2009 The Kuali Foundation

  *

  * Licensed under the Educational Community License, Version 2.0 (the "License");

  * you may not use this file except in compliance with the License.

  * You may obtain a copy of the License at

  *

  * http://www.opensource.org/licenses/ecl2.php

  *

  * Unless required by applicable law or agreed to in writing, software

  * distributed under the License is distributed on an "AS IS" BASIS,

  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

  * See the License for the specific language governing permissions and

  * limitations under the License.

  */

 package org.kuali.rice.kew.quicklinks.dao.impl;

 import java.util.ArrayList;

 import java.util.Collections;

 import java.util.List;

 import java.util.StringTokenizer;

 import javax.persistence.EntityManager;

 import javax.persistence.PersistenceContext;

 import org.kuali.rice.kew.docsearch.service.DocumentSearchService;

 import org.kuali.rice.kew.doctype.DocumentTypePolicy;

 import org.kuali.rice.kew.doctype.bo.DocumentType;

 import org.kuali.rice.kew.doctype.service.DocumentTypeService;

 import org.kuali.rice.kew.exception.WorkflowRuntimeException;

 import org.kuali.rice.kew.quicklinks.ActionListStats;

 import org.kuali.rice.kew.quicklinks.InitiatedDocumentType;

 import org.kuali.rice.kew.quicklinks.WatchedDocument;

 import org.kuali.rice.kew.quicklinks.dao.QuickLinksDAO;

 import org.kuali.rice.kew.service.KEWServiceLocator;

 import org.kuali.rice.kew.util.KEWConstants;

 import org.kuali.rice.kew.util.Utilities;

 import org.kuali.rice.kew.web.KeyValue;

 import org.kuali.rice.kns.util.KNSConstants;

 public class QuickLinksDAOJpaImpl implements QuickLinksDAO {

     private static final org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(QuickLinksDAOJpaImpl.class);

     @PersistenceContext(unitName = "kew-unit")

     private EntityManager entityManager;

     @SuppressWarnings("unchecked")

     public List<ActionListStats> getActionListStats(final String principalId) {

         try {

             final List<Object[]> stats = (List<Object[]>) entityManager.createNamedQuery("ActionItem.QuickLinks.FindActionListStatsByPrincipalId").setParameter("principalId", principalId).getResultList();

             final List<ActionListStats> docTypes = new ArrayList<ActionListStats>(stats.size());

             for (Object[] res : stats) {

                 final String docTypeName = (String) res[0];

                 final Long count = (Long) res[1];

                 final List<String> docTypeLabel = (List<String>) entityManager.createNamedQuery("DocumentType.QuickLinks.FindLabelByTypeName").setParameter("docTypeName", docTypeName).getResultList();

                 if (docTypeLabel.size() > 0) {

                     docTypes.add(new ActionListStats(docTypeName, docTypeLabel.get(0), count.intValue()));

                 }

             }

             Collections.sort(docTypes);

             return docTypes;

         } catch (Exception e) {

             throw new WorkflowRuntimeException("Error getting action list stats for user: " + principalId, e);

         }

     }

     @SuppressWarnings("unchecked")

     public List<InitiatedDocumentType> getInitiatedDocumentTypesList(final String principalId) {

         String documentNames = Utilities.getKNSParameterValue(KEWConstants.KEW_NAMESPACE, KNSConstants.DetailTypes.QUICK_LINK_DETAIL_TYPE, KEWConstants.QUICK_LINKS_RESTRICT_DOCUMENT_TYPES);

         if (documentNames != null) {

             documentNames = documentNames.trim();

         }

         if (documentNames == null || "none".equals(documentNames)) {

             documentNames = "";

         }

         final StringTokenizer st = new StringTokenizer(documentNames, ",");

         final List<String> docTypesToRestrict = new ArrayList<String>();

         while (st.hasMoreTokens()) {

             docTypesToRestrict.add(st.nextToken());

         }

         try {

             final List<Object[]> list = (List<Object[]>) entityManager.createNamedQuery("DocumentType.QuickLinks.FindInitiatedDocumentTypesListByInitiatorWorkflowId").setParameter("initiatorWorkflowId", principalId).getResultList();

             final List<InitiatedDocumentType> documentTypesByName = new ArrayList<InitiatedDocumentType>(list.size());

             for (Object[] doc : list) {

                 final String docTypeName = (String) doc[0];

                 final String label = (String) doc[1];

                 final String docTypeTopParent;

                 final int firstPeriod = docTypeName.indexOf(".");

                 if (firstPeriod == -1) {

                     docTypeTopParent = docTypeName.substring(0);

                 } else {

                     docTypeTopParent = docTypeName.substring(0, firstPeriod);

                 }

                 if (!docTypesToRestrict.contains(docTypeTopParent)) {

                     // the document types should be cached so this should be pretty quick

                     final DocumentType docType = KEWServiceLocator.getDocumentTypeService().findByName(docTypeName);

                     final DocumentTypePolicy quickInitiatePolicy = docType.getSupportsQuickInitiatePolicy();

                     if (quickInitiatePolicy.getPolicyValue().booleanValue()) {

                         documentTypesByName.add(new InitiatedDocumentType(docTypeName, label));

                     }

                 }

             }

             return documentTypesByName;

         } catch (Exception e) {

             throw new WorkflowRuntimeException("Error getting initiated document types for user: " + principalId, e);

         }

     }

     public List<KeyValue> getNamedSearches(String principalId) {

         return getDocumentSearchService().getNamedSearches(principalId);

     }

     public List<KeyValue> getRecentSearches(String principalId) {

         return getDocumentSearchService().getMostRecentSearches(principalId);

     }

     @SuppressWarnings("unchecked")

     public List<WatchedDocument> getWatchedDocuments(final String principalId) {

         try {

             return (List<WatchedDocument>) entityManager.createNamedQuery("DocumentRouteHeaderValue.QuickLinks.FindWatchedDocumentsByInitiatorWorkflowId").setParameter("initiatorWorkflowId", principalId).getResultList();

         } catch (Exception e) {

             throw new WorkflowRuntimeException("Error getting watched documents for user: " + principalId, e);

         }

     }

     public DocumentTypeService getDocumentTypeService() {

         return ((DocumentTypeService) KEWServiceLocator.getService(KEWServiceLocator.DOCUMENT_TYPE_SERVICE));

     }

     public DocumentSearchService getDocumentSearchService() {

         return ((DocumentSearchService) KEWServiceLocator.getService(KEWServiceLocator.DOCUMENT_SEARCH_SERVICE));

     }

     public EntityManager getEntityManager() {

         return this.entityManager;

     }

     public void setEntityManager(EntityManager entityManager) {

         this.entityManager = entityManager;

     }

 }