RealEstateBMPBean.java

/*
 * $Id: RealEstateBMPBean.java,v 1.4 2008/04/16 18:33:26 valdas Exp $ Created on Mar 26, 2007
 * 
 * Copyright (C) 2007 Idega Software hf. All Rights Reserved.
 * 
 * This software is the proprietary information of Idega hf. Use is subject to license terms.
 */
package com.idega.core.location.data;

import javax.ejb.FinderException;

import com.idega.data.IDOQuery;

public class RealEstateBMPBean extends com.idega.data.GenericEntity implements RealEstate {

	// length of description field
	private static final int DESCRIPTION = 255;
	
	// length of fields that are identifiers (equal to size of primary keys)
	private static final int IDENTIFIER = 22;

	// long input fields
	private static final int LONG_INPUT_FIELD = 255;

	private static final String COLUMN_REAL_ESTATE_NUMBER = "REAl_ESTATE_NUMBER";
	
	private static final String COLUMN_REAL_ESTATE_UNIT = "REAL_ESTATE_UNIT";

	private static final String COLUMN_REAL_ESTATE_CODE = "REAL_ESTATE_CODE";
	
	private static final String COLUMN_LAND_REGISTER_MAP_NUMBER = "LAND_REGISTER";

	private static final String COLUMN_NAME = "NAME";

	private static final String COLUMN_USE = "REAL_ESTATE_USE";

	private static final String COLUMN_COMMENT = "REAL_ESTATE_COMMENT";

	private static final String COLUMN_STREET_NUMBER = "STREET_NUMBER";

	private static final String COLUMN_STREET_ID = "STREET_ID";

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.idega.data.GenericEntity#getEntityName()
	 */
	public String getEntityName() {
		return "ic_real_estate";
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.idega.data.GenericEntity#initializeAttributes()
	 */
	public void initializeAttributes() {
		addAttribute(getIDColumnName());
		addAttribute(COLUMN_REAL_ESTATE_NUMBER, "real estate number", String.class, LONG_INPUT_FIELD);
		addAttribute(COLUMN_REAL_ESTATE_UNIT, "real estate unit", String.class, LONG_INPUT_FIELD);
		addAttribute(COLUMN_REAL_ESTATE_CODE, "real estate code", String.class, LONG_INPUT_FIELD);
		addAttribute(COLUMN_NAME, "name", String.class, LONG_INPUT_FIELD);
		addAttribute(COLUMN_USE, "use of the real estate", String.class, DESCRIPTION);
		addAttribute(COLUMN_COMMENT, "some explanation", String.class, DESCRIPTION);
		addAttribute(COLUMN_STREET_NUMBER, "street number", String.class, LONG_INPUT_FIELD);
		// pseudo pointer to land register map number 
		addAttribute(COLUMN_LAND_REGISTER_MAP_NUMBER, "land register map number", String.class, IDENTIFIER);
		// pointers to other entities
		addManyToOneRelationship(COLUMN_STREET_ID, Street.class);
	}

	public void setRealEstateNumber(String realEstateNumber) {
		setColumn(COLUMN_REAL_ESTATE_NUMBER, realEstateNumber);
	}

	public String getRealEstateNumber() {
		return (String) getColumnValue(COLUMN_REAL_ESTATE_NUMBER);
	}
	
	public void setRealEstateUnit(String unit) {
		setColumn(COLUMN_REAL_ESTATE_UNIT, unit);
	}
	
	public String getRealEstateUnit() {
		return (String) getColumnValue(COLUMN_REAL_ESTATE_UNIT);
	}

	public void setRealEstateCode(String realEstateCode) {
		setColumn(COLUMN_REAL_ESTATE_CODE, realEstateCode);
	}

	public String getRealEstateCode() {
		return (String) getColumnValue(COLUMN_REAL_ESTATE_CODE);
	}

	public void setName(String name) {
		setColumn(COLUMN_NAME, name);
	}

	public String getName() {
		return (String) getColumnValue(COLUMN_NAME);
	}

	public void setUse(String use) {
		setColumn(COLUMN_USE, use);
	}

	public String getUse() {
		return (String) getColumnValue(COLUMN_USE);
	}

	public void setComment(String comment) {
		setColumn(COLUMN_COMMENT, comment);
	}

	public String getComment() {
		return (String) getColumnValue(COLUMN_COMMENT);
	}

	public void setLandRegisterMapNumber(String landRegisterMapNumber) {
		setColumn(COLUMN_LAND_REGISTER_MAP_NUMBER, landRegisterMapNumber);
	}

	public String getLandRegisterMapNumber() {
		return (String) getColumnValue(COLUMN_LAND_REGISTER_MAP_NUMBER);
	}

	public void setStreetNumber(String streetNumber) {
		setColumn(COLUMN_STREET_NUMBER, streetNumber);
	}

	public String getStreetNumber() {
		return (String) getColumnValue(COLUMN_STREET_NUMBER);
	}
	
	public void setStreet(Street street) {
		setColumn(COLUMN_STREET_ID, street);
	}

	public Street getStreet() {
		return (Street) getColumnValue(COLUMN_STREET_ID);
	}

	public void setStreetID(Integer streetID) {
		setColumn(COLUMN_STREET_ID, streetID);
	}

	public Integer getStreetID() {
		return getIntegerColumnValue(COLUMN_STREET_ID);
	}
	
	public boolean isDummy() {
		return 
			getLandRegisterMapNumber() == null &&
			getRealEstateNumber() == null &&
			getRealEstateUnit() == null &&
			getRealEstateCode() == null;
	}

	public Object ejbFindRealEstateByRealEstateIdentifier(String landRegisterMapNumber, String number, String unit, String code) throws FinderException {
		IDOQuery query = idoQueryGetSelect();
		query.appendWhere();
		// land register number
		if (landRegisterMapNumber == null) {
			query.append(COLUMN_LAND_REGISTER_MAP_NUMBER).appendIsNull();
		}
		else {
			query.appendEqualsQuoted(COLUMN_LAND_REGISTER_MAP_NUMBER, landRegisterMapNumber);
		}
		// real estate number
		if (number == null) {
			query.appendAndIsNull(COLUMN_REAL_ESTATE_NUMBER);
		}
		else {
			query.appendAnd().appendEqualsQuoted(COLUMN_REAL_ESTATE_NUMBER, number);
		}
		// real estate unit
		if (unit == null) {
			query.appendAndIsNull(COLUMN_REAL_ESTATE_UNIT);
		}
		else {
			query.appendAnd().appendEqualsQuoted(COLUMN_REAL_ESTATE_UNIT, unit);
		}
		// real estate code
		if (code == null) {
			query.appendAndIsNull(COLUMN_REAL_ESTATE_CODE);
		}
		else {
			query.appendAnd().appendEqualsQuoted(COLUMN_REAL_ESTATE_CODE, code);
		}
		return idoFindOnePKByQuery(query);
	}

}