mprintformatitem.java

Java写的ERP系统

		return ((Boolean)getValue("IsHeightOneLine")).booleanValue();
	}

	/**
	 * 	Set Order By
	 * 	@param orderBy order by
	 */
	public void setOrderBy (boolean orderBy)
	{
		setValue("IsOrderBy", new Boolean(orderBy));
	}
	public boolean isOrderBy()
	{
		return ((Boolean)getValue("IsOrderBy")).booleanValue();
	}

	/**
	 * 	Set Group by
	 * 	@param groupBy group by
	 */
	public void setGroupBy (boolean groupBy)
	{
		setValue("IsGroupBy", new Boolean(groupBy));
	}
	public boolean isGroupBy()
	{
		return ((Boolean)getValue("IsGroupBy")).booleanValue();
	}

	/**
	 * 	Set Page Break
	 * 	@param pageBreak page break
	 */
	public void setPageBreak (boolean pageBreak)
	{
		setValue("IsPageBreak", new Boolean(pageBreak));
	}
	public boolean isPageBreak()
	{
		return ((Boolean)getValue("IsPageBreak")).booleanValue();
	}

	public void setSummarized (boolean summarized)
	{
		setValue("IsSummarized", new Boolean(summarized));
	}
	public boolean isSummarized()
	{
		return ((Boolean)getValue("IsSummarized")).booleanValue();
	}

	public void setAveraged (boolean averaged)
	{
		setValue("IsAveraged", new Boolean(averaged));
	}
	public boolean isAveraged()
	{
		return ((Boolean)getValue("IsAveraged")).booleanValue();
	}

	public void setCounted (boolean counted)
	{
		setValue("IsCounted", new Boolean(counted));
	}
	public boolean isCounted()
	{
		return ((Boolean)getValue("IsCounted")).booleanValue();
	}

	private void setAD_PrintFormat_ID (int AD_PrintFormat_ID)
	{
		setValueNoCheck("AD_PrintFormat_ID", new Integer(AD_PrintFormat_ID));
	}
	public int getAD_PrintFormat_ID()
	{
		return ((Integer)getValue("AD_PrintFormat_ID")).intValue();
	}

	private void setAD_PrintFormatChild_ID (int AD_PrintFormatChild_ID)
	{
		setValueNoCheck("AD_PrintFormatChild_ID", new Integer(AD_PrintFormatChild_ID));
	}
	public int getAD_PrintFormatChild_ID()
	{
		Integer ii = (Integer)getValue("AD_PrintFormatChild_ID");
		if (ii == null)
			return 0;
		return ii.intValue();
	}

	public void setAD_Column_ID (int AD_Column_ID)
	{
		setValue("AD_Column_ID", new Integer(AD_Column_ID));
	}
	public int getAD_Column_ID()
	{
		Integer ii = (Integer)getValue("AD_Column_ID");
		if (ii == null)
			return 0;
		return ii.intValue();
	}

	public void setSeqNo (int seqNo)
	{
		setValue("SeqNo", new Integer(seqNo));
	}
	public int getSeqNo()
	{
		return ((Integer)getValue("SeqNo")).intValue();
	}

	public void setSortNo (int sortNo)
	{
		setValue("SortNo", new Integer(sortNo));
	}
	public int getSortNo()
	{
		return ((Integer)getValue("SortNo")).intValue();
	}

	public void setMaxHeight (int maxHeight)
	{
		setValue("MaxHeight", new Integer(maxHeight));
	}
	public int getMaxHeight()
	{
		return ((Integer)getValue("MaxHeight")).intValue();
	}

	public void setMaxWidth (int maxWidth)
	{
		setValue("MaxWidth", new Integer(maxWidth));
	}
	public int getMaxWidth()
	{
		return ((Integer)getValue("MaxWidth")).intValue();
	}

	public void setBelowColumn (int belowColumn)
	{
		setValue("BelowColumn", new Integer(belowColumn));
	}
	public int getBelowColumn()
	{
		Integer ii = (Integer)getValue("BelowColumn");
		if (ii != null)		//	optional
			return ii.intValue();
		return 0;
	}

	public void setXspace (int Xspace)
	{
		setValue("Xspace", new Integer(Xspace));
	}
	public int getXspace()
	{
		return ((Integer)getValue("Xspace")).intValue();
	}

	public void setYspace (int Yspace)
	{
		setValue("Yspace", new Integer(Yspace));
	}
	public int getYspace()
	{
		return ((Integer)getValue("Yspace")).intValue();
	}

	public void setXposition (int Xposition)
	{
		setValue("Xposition", new Integer(Xposition));
	}
	public int getXposition()
	{
		return ((Integer)getValue("Xposition")).intValue();
	}

	public void setYposition (int Yposition)
	{
		setValue("Yposition", new Integer(Yposition));
	}
	public int getYposition()
	{
		return ((Integer)getValue("Yposition")).intValue();
	}

	public void setAD_PrintColor_ID (int AD_PrintColor_ID)
	{
		setValue("AD_PrintColor_ID", new Integer(AD_PrintColor_ID));
	}
	public int getAD_PrintColor_ID()
	{
		Integer ii = (Integer)getValue("AD_PrintColor_ID");
		if (ii == null)
			return 0;
		return ii.intValue();
	}

	public void setAD_PrintFont_ID (int AD_PrintFont_ID)
	{
		setValue("AD_PrintFont_ID", new Integer(AD_PrintFont_ID));
	}
	public int getAD_PrintFont_ID()
	{
		Integer ii = (Integer)getValue("AD_PrintFont_ID");
		if (ii == null)
			return 0;
		return ii.intValue();
	}

	public void setImageIsAttached(boolean attached)
	{
		setValue("ImageIsAttached", new Boolean(attached));
	}
	public boolean isImageAttached()
	{
		return ((Boolean)getValue("ImageIsAttached")).booleanValue();
	}
	public void setImageURL(String url)
	{
		setValue("ImageURL", url);
	}
	public String getImageURL()
	{
		return (String)getValue("ImageURL");
	}


	/*************************************************************************/

	/**
	 * 	String representation
	 * 	@return info
	 */
	public String toString()
	{
		StringBuffer sb = new StringBuffer("MPrintFormatItem[");
		sb.append("ID=").append(getID())
			.append(",Name=").append(getName())
			.append(",Print=").append(getPrintName())
			.append(", Area=").append(getPrintAreaType())
			.append(", MaxWidth=").append(getMaxWidth())
			.append(",MaxHeight=").append(getMaxHeight())
			.append(",OneLine=").append(isHeightOneLine())
			.append(", Relative=").append(isRelativePosition());
		if (isRelativePosition())
			sb.append(",X=").append(getXspace()).append(",Y=").append(getYspace())
				.append(",LineAlign=").append(getLineAlignmentType())
				.append(",NewLine=").append(isNextLine())
				.append(",NewPage=").append(isPageBreak());
		else
			sb.append(",X=").append(getXposition()).append(",Y=").append(getYposition());
		sb.append(",FieldAlign=").append(getFieldAlignmentType());
		//
		sb.append(", Type=").append(getPrintFormatType());
		if (isTypeText())
			;
		else if (isTypeField())
			sb.append(",AD_Column_ID=").append(getAD_Column_ID());
		else if (isTypePrintFormat())
			sb.append(",AD_PrintFormatChild_ID=").append(getAD_PrintFormatChild_ID())
				.append(",AD_Column_ID=").append(getAD_Column_ID());
		else if (isTypeImage())
			sb.append(",ImageIsAttached=").append(isImageAttached()).append(",ImageURL=").append(getImageURL());
		//
		sb.append(", Printed=").append(isPrinted())
			.append(",SeqNo=").append(getSeqNo())
			.append(",OrderBy=").append(isOrderBy())
			.append(",SortNo=").append(getSortNo())
			.append(",Summarized=").append(isSummarized());
		sb.append("]");
		return sb.toString();
	}	//	toString


	/*************************************************************************/

	/**
	 * 	Get ColumnName from AD_Column_ID
	 *  @return ColumnName
	 */
	public String getColumnName()
	{
		if (m_columnName == null)
			m_columnName = getColumnName((Integer)getValue("AD_Column_ID"));
		return m_columnName;
	}	//	getColumnName


	/**	Lookup Map of AD_Column_ID for ColumnName	*/
	private static HashMap 	s_columns = new HashMap();


	/**
	 * 	Get Column Name from AD_Column_ID.
	 *  Be careful not to confuse it with PO method getAD_Column_ID (index)
	 * 	@param AD_Column_ID column
	 * 	@return Column Name
	 */
	public static String getColumnName (Integer AD_Column_ID)
	{
		if (AD_Column_ID == null || AD_Column_ID.intValue() == 0)
			return null;
		//
		String retValue = (String)s_columns.get(AD_Column_ID);
		if (retValue == null)
		{
			String sql = "SELECT ColumnName FROM AD_Column WHERE AD_Column_ID=?";
			try
			{
				PreparedStatement pstmt = DB.prepareStatement(sql);
				pstmt.setInt(1, AD_Column_ID.intValue());
				ResultSet rs = pstmt.executeQuery();
				if (rs.next())
				{
					retValue = rs.getString(1);
					s_columns.put(AD_Column_ID, retValue);
				}
				else
					Log.error("MPrintFormatItem.getColumnName - Not found AD_Column_ID=" + AD_Column_ID);
				rs.close();
				pstmt.close();
			}
			catch (SQLException e)
			{
				Log.error("MPrintFormatItem.getColumnName ID=" + AD_Column_ID, e);
			}
		}
		return retValue;
	}	//	setColumnName

	/*************************************************************************/

	/**
	 * 	Create Print Format Item from Column
	 * 	@param ctx context
	 * 	@param AD_Column_ID column
	 *  @param format parent
	 *  @param seqNo sequence of display
	 * 	@return Print Format Item
	 */
	public static MPrintFormatItem createFromColumn (Properties ctx, int AD_Column_ID, MPrintFormat format, int seqNo)
	{
		MPrintFormatItem pfi = new MPrintFormatItem (ctx, 0);
		pfi.setAD_PrintFormat_ID (format.getID());
		pfi.setValueNoCheck("AD_Client_ID", new Integer(format.getAD_Client_ID()));		//	overwrite to be sure
		pfi.setValueNoCheck("AD_Org_ID", new Integer(format.getAD_Org_ID()));
		pfi.setAD_Column_ID(AD_Column_ID);
		pfi.setPrintFormatType(FORMATTYPE_FIELD);

		//	translation is dome by trigger
		String sql = "SELECT c.ColumnName,e.Name,e.PrintName, "		//	1..3
			+ "c.AD_Reference_ID,c.IsKey,c.SeqNo "					//	4..6
			+ "FROM AD_Column c, AD_Element e "
			+ "WHERE c.AD_Column_ID=?"
			+ " AND c.AD_Element_ID=e.AD_Element_ID";
		//	translate base entry if single language - trigger copies to trl tables
		Language language = format.getLanguage();
		boolean trl = !Env.isMultiLingualDocument(ctx) && !language.isBaseLanguage();
		if (trl)
			sql = "SELECT c.ColumnName,e.Name,e.PrintName, "		//	1..3
				+ "c.AD_Reference_ID,c.IsKey,c.SeqNo "				//	4..6
				+ "FROM AD_Column c, AD_Element_Trl e "
				+ "WHERE c.AD_Column_ID=?"
				+ " AND c.AD_Element_ID=e.AD_Element_ID"
				+ " AND e.AD_Language=?";
		try
		{
			PreparedStatement pstmt = DB.prepareStatement(sql);
			pstmt.setInt(1, AD_Column_ID);
			if (trl)
				pstmt.setString(2, language.getAD_Language());
			ResultSet rs = pstmt.executeQuery();
			if (rs.next())
			{
				String ColumnName = rs.getString(1);
				pfi.setName(rs.getString(2));
				pfi.setPrintName(rs.getString(3));
				int displayType = rs.getInt(4);
				if (DisplayType.isNumeric(displayType))
					pfi.setFieldAlignmentType(FIELD_ALIGN_TRAILING);
				else if (displayType == DisplayType.Text || displayType == DisplayType.Memo )
					pfi.setFieldAlignmentType(FIELD_ALIGN_BLOCK);
				else
					pfi.setFieldAlignmentType(FIELD_ALIGN_LEADING);
				boolean isKey = "Y".equals(rs.getString(5));
				//
				if (isKey
					|| ColumnName.startsWith("Created") || ColumnName.startsWith("Updated")
					|| ColumnName.equals("AD_Client_ID") || ColumnName.equals("AD_Org_ID")
					|| ColumnName.equals("IsActive")
					|| displayType == DisplayType.Button || displayType == DisplayType.Binary
					|| displayType == DisplayType.ID || displayType == DisplayType.Image
					|| displayType == DisplayType.RowID)
				{
					pfi.setPrinted(false);
					pfi.setSeqNo(0);
				}
				else
				{
					pfi.setPrinted(true);
					pfi.setSeqNo(seqNo);
				}
				int idSeqNo = rs.getInt(6);	//	IsIdentifier SortNo
				if (idSeqNo > 0)
				{
					pfi.setOrderBy(true);
					pfi.setSortNo(idSeqNo);
				}
			}
			else
				Log.error("MPrintFormatItem.createFromColumn - Not Found AD_Column_ID=" + AD_Column_ID
					+ " Trl=" + trl + " " + language.getAD_Language());
			rs.close();
			pstmt.close();
		}
		catch (SQLException e)
		{
			Log.error("MPrintFormatItem.createFromColumn", e);
		}
		if (!pfi.save())
			return null;
	//	pfi.dump();
		return pfi;
	}	//	createFromColumn

	/**
	 * 	Copy existing Definition To Client
	 * 	@param To_Client_ID to client
	 *  @param AD_PrintFormat_ID parent print format
	 * 	@return print format item
	 */
	public MPrintFormatItem copyToClient (int To_Client_ID, int AD_PrintFormat_ID)
	{
		MPrintFormatItem to = new MPrintFormatItem (p_ctx, 0);
		MPrintFormatItem.copyValues(this, to);
		to.setValueNoCheck("AD_Client_ID", new Integer(To_Client_ID));
		to.setValueNoCheck("AD_Org_ID", new Integer(0));
		to.setAD_PrintFormat_ID (AD_PrintFormat_ID);
		to.save();
		return to;
	}	//	copyToClient

}	//	MPrintFormatItem