uireport.java

国外的一套开源CRM

				String qlFieldName = "";
				String qlAttributeId = "";
				String qlDisplayObjectId = "";
				String qlDisplayTypeId = "";
				String qlDisplayLabel = "";
						
				if (tokSemi.countTokens() == 5) {
						qlFieldName = tokSemi.nextToken();
						qlAttributeId = tokSemi.nextToken();
						qlDisplayTypeId = tokSemi.nextToken();
						qlDisplayObjectId = tokSemi.nextToken();
						qlDisplayLabel = tokSemi.nextToken();
				}
				else
				{
					qlFieldName = selectField;
				}
			
				reportFields.add(new UIReportField(qlAttributeId, qlDisplayTypeId, qlDisplayObjectId, qlDisplayLabel, String.valueOf(i)));		
					
				String entityName = UIWebUtility.getEntityFromParamName(qlFieldName);
				String attributeName = UIWebUtility.getAttribFromParamName(qlFieldName);
				String aliasName = attributeName;
				if ( ! entityName.equals(primaryEntityName))
					aliasName = entityName + "_" + attributeName;
					
				String hasJoin = (String) joinedEntities.get(entityName);
						
				if ( ( hasJoin == null ) || ( !hasJoin.equals("Y")) )
				{
					eventProcessor.addOneRelationClause(delegator, "", "", entityName, primaryEntityName, primaryME, false, queryInfo);
			
					joinedEntities.put(entityName, "Y");
				}
				
				queryInfo.checkAttribute(entityName, attributeName, aliasName);
	
				selectFields.add(aliasName);
				selectFieldLabels.add(qlDisplayLabel);
			}
			
			setSelectFieldNames(selectFields);
			setSelectFieldLabels(selectFieldLabels);
			
			queryInfo.setSelectFields(selectFields);

			//get orderBy Fields
			String [] sortFieldsParam = request.getParameterValues("sortFields");
			if ( sortFieldsParam != null )
			{
				for (int i = 0; i < sortFieldsParam.length; i++)
				{
					// Do what you need for each string:  foo[i]
					String sortField = sortFieldsParam[i];
					StringTokenizer tokSemi = new StringTokenizer(sortField,";");
					String qlFieldName = "";
					String qlAttributeId = "";
					String qlDisplayObjectId = "";
					String qlDisplayTypeId = "";
					String qlDisplayLabel = "";
							
					if (tokSemi.countTokens() == 5) {
							qlFieldName = tokSemi.nextToken();
							qlAttributeId = tokSemi.nextToken();
							qlDisplayTypeId = tokSemi.nextToken();
							qlDisplayObjectId = tokSemi.nextToken();
							qlDisplayLabel = tokSemi.nextToken();
					}
					else
					{
						qlFieldName = sortField;
					}
					reportOrderBy.add(new UIReportOrderBy(qlAttributeId, i, qlDisplayLabel));		
				
					String entityName = UIWebUtility.getEntityFromParamName(qlFieldName);
					String attributeName = UIWebUtility.getAttribFromParamName(qlFieldName);
					String aliasName = attributeName;
					if ( ! entityName.equals(primaryEntityName))
						aliasName = entityName + "_" + attributeName;
	
					String hasJoin = (String) joinedEntities.get(entityName);
							
					if ( ( hasJoin == null ) || ( !hasJoin.equals("Y")) )
					{
						eventProcessor.addOneRelationClause(delegator, "", "", entityName, primaryEntityName, primaryME, false, queryInfo);
				
						joinedEntities.put(entityName, "Y");
					}
					
					queryInfo.checkAttribute(entityName, attributeName, aliasName);
	
					sortFields.add(aliasName);
				}
				queryInfo.setOrderBy(sortFields);
			}
			setReportFields(reportFields);
			setReportCriteria(reportCriteria);
			setReportOrderBy(reportOrderBy);
			
		} catch (NumberFormatException e)
		{
			Debug.logError("Error formatting Number: " + e.getMessage(), module);
			return false;
		} catch (GenericEntityException e)
		{
			Debug.logError("Error loading QueryInfo: " + e.getMessage(), module);
			return false;
		}
		return true;
	}
	
	public List runReport(UserInfo userInfo, int maxRows)
	{
		EntityListIterator eli = null;
		
		if ( eventProcessor == null)
			eventProcessor = new GenericEventProcessor();
		
		if ( queryInfo == null )
			throw new RuntimeException("You must call loadQueryInfo prior to runReport");
		
		SecurityLinkInfo securityInfo = eventProcessor.getSecurityLinkInfo(userInfo, delegator);
		if (securityInfo == null) {
			try {
				eli = queryInfo.getQueryIterator();
			} catch (GenericEntityException e) {
				Debug.logError("An error occurred in the " +
					"GenericDelegator.findByCondition method: " +
					e.getLocalizedMessage(), module);
			}
		} else {
			try {
				
				eli = SecurityWrapper.findListIteratorByCondition(queryInfo.getPrimaryEntity(),
						queryInfo, queryInfo.getOrderBy(), userInfo, securityInfo,	delegator);
			} catch (GenericEntityException e) {
				Debug.logError("An error occurred in the " +
					"SecurityWrapper.findByCondition method: " +
					e.getLocalizedMessage(), module);
			}
		}

		if ( eli != null )
		{
			try {
				List resultGVL = eli.getPartialList( 1, maxRows);
				
				boolean hasMoreRows = false;
				
				// check next value since we close the cursor anyway.  
				if ( (resultGVL.size() == maxRows) && (eli.next() != null ))
					hasMoreRows = true;
					
				eli.close();
				
				return resultGVL;

			} catch (GenericEntityException e) {
				Debug.logError("An error occurred in the  getPartialList method: " + e.getLocalizedMessage(), module);
			}
		}

		return null;

	}
	
 	public GenericDelegator getDelegator()
 	{
 		return delegator;
 	}
 	
 	public void setDelegator(GenericDelegator delegator_)
 	{
 		delegator = delegator_;
 	}

	/**
	 * @return
	 */
	public String getPartyId()
	{
		return partyId;
	}

	/**
	 * @return
	 */
	public List getPrimaryFields()
	{
		if ( !primaryFieldsLoaded )
			loadPrimarySectionFields();
		return primaryFields;
	}

	/**
	 * @return
	 */
	public List getRelatedFields()
	{
		if ( !relatedFieldsLoaded )
			loadRelatedSectionQueryFields();
		return relatedFields;
	}

	/**
	 * @return
	 */
	public String getReportId()
	{
		return reportId;
	}

	/**
	 * @return
	 */
	public String getReportName()
	{
		return reportName;
	}

	/**
	 * @return
	 */
	public String getSectionId()
	{
		return sectionId;
	}

	/**
	 * @param string
	 */
	public void setPartyId(String string)
	{
		partyId = string;
	}

	/**
	 * @param list
	 */
	public void setPrimaryFields(List list)
	{
		primaryFields = list;
		primaryFieldsLoaded = true;
	}

	/**
	 * @param list
	 */
	public void setRelatedFields(List list)
	{
		relatedFields = list;
		relatedFieldsLoaded = true;
	}

	/**
	 * @param string
	 */
	public void setReportId(String string)
	{
		reportId = string;
	}

	/**
	 * @param string
	 */
	public void setReportName(String string)
	{
		reportName = string;
	}

	/**
	 * @param string
	 */
	public void setSectionId(String string)
	{
		sectionId = string;
	}

	/**
	 * @return
	 */
	public List getReportCriteria()
	{
		return reportCriteria;
	}

	/**
	 * @return
	 */
	public List getReportFields()
	{
		return reportFields;
	}

	/**
	 * @return
	 */
	public List getReportOrderBy()
	{
		return reportOrderBy;
	}

	/**
	 * @param list
	 */
	public void setReportCriteria(List list)
	{
		reportCriteria = list;
	}

	/**
	 * @param list
	 */
	public void setReportFields(List list)
	{
		reportFields = list;
	}

	/**
	 * @param list
	 */
	public void setReportOrderBy(List list)
	{
		reportOrderBy = list;
	}

	protected List getStringListfromGVL( List gvl, String fieldName)
	{
		List sList = new ArrayList();
		
		Iterator iter = gvl.iterator();
		while (iter.hasNext())
		{
			GenericValue gv = (GenericValue) iter.next();
			sList.add(gv.getString(fieldName));	
		}
		return sList;
	}
	
	/**
	 * @return
	 */
	public String getPublicFlag()
	{
		return publicFlag;
	}

	/**
	 * @param string
	 */
	public void setPublicFlag(String string)
	{
		publicFlag = string;
	}

	/**
	 * @return
	 */
	public List getSelectFieldLabels()
	{
		return selectFieldLabels;
	}

	/**
	 * @return
	 */
	public List getSelectFieldNames()
	{
		return selectFieldNames;
	}

	/**
	 * @param list
	 */
	public void setSelectFieldLabels(List list)
	{
		selectFieldLabels = list;
	}

	/**
	 * @param list
	 */
	public void setSelectFieldNames(List list)
	{
		selectFieldNames = list;
	}

 }