Пример #1
0
 /**
  * Loads a list of attributeValueBeans from the TAttributeValue table by an array of workItemIDs
  *
  * @param workItemIDs
  * @return
  */
 @Override
 public List<TAttributeValueBean> loadByWorkItemKeys(int[] workItemIDs) {
   List<TAttributeValueBean> attributeValueBeansList = new ArrayList<TAttributeValueBean>();
   List<TAttributeValue> tav = new ArrayList<TAttributeValue>();
   if (workItemIDs == null || workItemIDs.length == 0) {
     return attributeValueBeansList;
   }
   Criteria criteria;
   List<int[]> workItemIDChunksList = GeneralUtils.getListOfChunks(workItemIDs);
   if (workItemIDChunksList == null) {
     return attributeValueBeansList;
   }
   Iterator<int[]> iterator = workItemIDChunksList.iterator();
   while (iterator.hasNext()) {
     int[] workItemIDChunk = iterator.next();
     criteria = new Criteria();
     criteria.addIn(WORKITEM, workItemIDChunk);
     try {
       tav.addAll(doSelect(criteria));
     } catch (Exception e) {
       LOGGER.error(
           "Loading the attributeValueBeans by workItemIDs failed with " + e.getMessage());
     }
   }
   return convertTorqueListToBeanList(tav);
 }
Пример #2
0
 /**
  * Get the custom option type attributeValueBeans for an array of workItemIDs
  *
  * @param workItemIDs
  * @return
  */
 @Override
 public List<TAttributeValueBean> loadLuceneCustomOptionAttributeValues(int[] workItemIDs) {
   List<TAttributeValueBean> attributeValueBeansList = new ArrayList<TAttributeValueBean>();
   if (workItemIDs == null || workItemIDs.length == 0) {
     return attributeValueBeansList;
   }
   Criteria criteria;
   List<int[]> workItemIDChunksList = GeneralUtils.getListOfChunks(workItemIDs);
   if (workItemIDChunksList == null) {
     return attributeValueBeansList;
   }
   Iterator<int[]> iterator = workItemIDChunksList.iterator();
   while (iterator.hasNext()) {
     int[] workItemIDChunk = iterator.next();
     criteria = new Criteria();
     criteria.addIn(WORKITEM, workItemIDChunk);
     try {
       attributeValueBeansList.addAll(getReportCustomOptionAttributeValues(criteria));
     } catch (Exception e) {
       LOGGER.error(
           "Loading the custom option type attributeValueBeans by workItemIDs failed with "
               + e.getMessage());
     }
   }
   return attributeValueBeansList;
 }
Пример #3
0
 /**
  * Whether a system option from list appears as custom attribute The reflection does not work
  * because an additional condition should be satisfied (no direct foreign key relationship exists)
  *
  * @param objectIDs
  * @param fieldID
  */
 @Override
 public boolean isSystemOptionAttribute(List<Integer> objectIDs, Integer fieldID) {
   if (objectIDs == null || objectIDs.isEmpty()) {
     return false;
   }
   List attributes = null;
   Criteria selectCriteria;
   List<int[]> chunkList = GeneralUtils.getListOfChunks(objectIDs);
   Iterator<int[]> iterator = chunkList.iterator();
   while (iterator.hasNext()) {
     int[] idChunk = iterator.next();
     selectCriteria = new Criteria();
     selectCriteria.addIn(SYSTEMOPTIONID, idChunk);
     selectCriteria.add(SYSTEMOPTIONTYPE, fieldID);
     selectCriteria.setDistinct();
     try {
       attributes = doSelect(selectCriteria);
     } catch (Exception e) {
       LOGGER.error(
           "Verifiying the dependent "
               + "oldPersonIDs "
               + objectIDs.size()
               + " for the user picker failed with "
               + e.getMessage(),
           e);
     }
     if (attributes != null && !attributes.isEmpty()) {
       return true;
     }
   }
   return false;
 }
Пример #4
0
 /**
  * Loads a filterCategoryBeans by parentIDs
  *
  * @param parentIDs
  * @return
  */
 @Override
 public List<TReportCategoryBean> loadByParents(List<Integer> parentIDs) {
   List<TReportCategory> categories = new ArrayList<TReportCategory>();
   if (parentIDs == null || parentIDs.isEmpty()) {
     return new ArrayList<TReportCategoryBean>();
   }
   List<int[]> parentIDChunksList = GeneralUtils.getListOfChunks(parentIDs);
   if (parentIDChunksList != null && !parentIDChunksList.isEmpty()) {
     Iterator<int[]> iterator = parentIDChunksList.iterator();
     while (iterator.hasNext()) {
       int[] parentIDsChunk = iterator.next();
       Criteria criteria = new Criteria();
       criteria.addIn(PARENTID, parentIDsChunk);
       criteria.addAscendingOrderByColumn(LABEL);
       try {
         categories.addAll(doSelect(criteria));
       } catch (Exception e) {
         LOGGER.error(
             "Getting the report categories by parents "
                 + parentIDsChunk.length
                 + " failed with "
                 + e.getMessage(),
             e);
       }
     }
   }
   return convertTorqueListToBeanList(categories);
 }
Пример #5
0
 /**
  * Loads filterCategoryBeans by repository
  *
  * @param repository
  * @param personID
  * @return
  */
 @Override
 public List<TReportCategoryBean> loadByRepositoryPersonProjects(
     Integer repository, Integer personID, List<Integer> projects) {
   List<TReportCategory> categories = new ArrayList<TReportCategory>();
   Criteria criteria = new Criteria();
   criteria.add(REPOSITORY, repository);
   if (personID != null) {
     criteria.add(CREATEDBY, personID);
   }
   if (projects != null && !projects.isEmpty()) {
     criteria.addIn(PROJECT, projects);
   }
   criteria.addAscendingOrderByColumn(LABEL);
   try {
     categories.addAll(doSelect(criteria));
   } catch (Exception e) {
     LOGGER.error(
         "Getting filter categories by repository "
             + repository
             + " personID "
             + personID
             + " projects "
             + projects
             + " failed with "
             + e.getMessage(),
         e);
   }
   return convertTorqueListToBeanList(categories);
 }
Пример #6
0
 /**
  * Retrieve a multiple objects by pk
  *
  * @param pks List of primary keys
  * @param dbcon the connection to use
  * @throws TorqueException Any exceptions caught during processing will be rethrown wrapped into a
  *     TorqueException.
  */
 public static List retrieveByPKs(List pks, Connection dbcon) throws TorqueException {
   List objs = null;
   if (pks == null || pks.size() == 0) {
     objs = new LinkedList();
   } else {
     Criteria criteria = new Criteria();
     criteria.addIn(EXAM_ID, pks);
     objs = doSelect(criteria, dbcon);
   }
   return objs;
 }
Пример #7
0
 /**
  * Retrieve a multiple objects by pk
  *
  * @param pks List of primary keys
  * @param dbcon the connection to use
  * @throws TorqueException Any exceptions caught during processing will be rethrown wrapped into a
  *     TorqueException.
  */
 public static List<TRoleListType> retrieveByPKs(List<ObjectKey> pks, Connection dbcon)
     throws TorqueException {
   List<TRoleListType> objs = null;
   if (pks == null || pks.size() == 0) {
     objs = new LinkedList<TRoleListType>();
   } else {
     Criteria criteria = new Criteria();
     criteria.addIn(OBJECTID, pks);
     objs = doSelect(criteria, dbcon);
   }
   return objs;
 }
Пример #8
0
 /**
  * Gets the user picker attributes by a list of workItemIDs
  *
  * @param allWorkItemIDs
  * @return
  */
 @Override
 public List<TAttributeValueBean> getUserPickerAttributesByWorkItems(List<Integer> workItemIDs) {
   List<TAttributeValueBean> attributeValueBeans = new LinkedList<TAttributeValueBean>();
   if (workItemIDs == null || workItemIDs.isEmpty()) {
     return attributeValueBeans;
   }
   List<int[]> workItemIDChunksList = GeneralUtils.getListOfChunks(workItemIDs);
   Iterator<int[]> chunkIterator = workItemIDChunksList.iterator();
   while (chunkIterator.hasNext()) {
     int[] workItemIDChunk = chunkIterator.next();
     Criteria crit = new Criteria();
     crit.addIn(WORKITEM, workItemIDChunk);
     crit.add(VALIDVALUE, ValueType.SYSTEMOPTION);
     crit.add(SYSTEMOPTIONTYPE, SystemFields.INTEGER_PERSON);
     try {
       attributeValueBeans.addAll(convertTorqueListToBeanList(doSelect(crit)));
     } catch (TorqueException e) {
       LOGGER.error(
           "Loading the user pickers by workItemIDs failed with failed with " + e.getMessage());
     }
   }
   return attributeValueBeans;
 }