SchoolAreaBMPBean.java

package com.idega.block.school.data;

import com.idega.data.GenericEntity;
import com.idega.data.IDOQuery;

import java.util.Collection;
import java.util.Iterator;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: </p>
 * @author <br><a href="mailto:aron@idega.is">Aron Birkir</a><br>
 * @version 1.0
 */

public class SchoolAreaBMPBean extends GenericEntity implements SchoolArea {

	public final static String SCHOOL = "SCH_SCHOOL_AREA";
	public final static String NAME = "AREA_NAME";
	public final static String INFO = "AREA_INFO";
	public final static String CITY = "AREA_CITY";

	public void initializeAttributes() {
		this.addAttribute(getIDColumnName());
		this.addAttribute(NAME, "Schoolname", true, true, String.class);
		this.addAttribute(INFO, "Info", true, true, String.class);
		this.addAttribute(CITY, "City", true, true, String.class);
	}
	public String getEntityName() {
		return SCHOOL;
	}
	public String getName() {
		return getSchoolAreaName();
	}
	public String getSchoolAreaName() {
		return this.getStringColumnValue(NAME);
	}
	public void setSchoolAreaName(String name) {
		this.setColumn(NAME, name);
	}
	public String getSchoolAreaInfo() {
		return this.getStringColumnValue(INFO);
	}
	public void setSchoolAreaInfo(String info) {
		this.setColumn(INFO, info);
	}
	public String getSchoolAreaCity() {
		return this.getStringColumnValue(CITY);
	}
	public void setSchoolAreaCity(String city) {
		this.setColumn(CITY, city);
	}

	public Collection ejbFindAllSchoolAreas() throws javax.ejb.FinderException {
		IDOQuery sql = idoQuery();
		sql.appendSelectAllFrom(this.getEntityName()).appendOrderBy(NAME);
		return super.idoFindPKsBySQL(sql.toString());
	}
	
	public Integer ejbFindSchoolAreaByAreaName(String name) throws javax.ejb.FinderException {
		IDOQuery sql = idoQuery();
		sql.appendSelectAllFrom(this.getEntityName()).appendWhereEqualsQuoted(NAME,name);
		
		return (Integer)super.idoFindOnePKByQuery(sql);
	}


	public Collection ejbFindAllBySchoolType(int type_id) throws javax.ejb.FinderException {
		StringBuffer sql = new StringBuffer("select distinct a.* ");
		sql.append(" from sch_school_area a,sch_school s,sch_school_type t,sch_school_sch_school_type m ");
		sql.append(" where a.sch_school_area_id = s.sch_school_area_id ");
		sql.append(" and t.sch_school_type_id = m.sch_school_type_id ");
		sql.append(" and s.sch_school_id = m.sch_school_id ");
		sql.append(" and t.sch_school_type_id = ");
		sql.append(type_id);
		sql.append(" order by a.AREA_NAME asc");

		return super.idoFindPKsBySQL(sql.toString());
	}

	public Collection ejbFindAllBySchoolTypes(Collection types) throws javax.ejb.FinderException {
		StringBuffer sql = new StringBuffer("select distinct a.* ");
		sql.append(" from sch_school_area a,sch_school s,sch_school_type t,sch_school_sch_school_type m ");
		sql.append(" where a.sch_school_area_id = s.sch_school_area_id ");
		sql.append(" and t.sch_school_type_id = m.sch_school_type_id ");
		sql.append(" and s.sch_school_id = m.sch_school_id ");
		if (types != null && !types.isEmpty()) {
			sql.append(" and t.sch_school_type_id in (");
			Iterator it = types.iterator();
			SchoolType type = null;
			while (it.hasNext()) {
				type = (SchoolType) it.next();
				Integer pk = (Integer) type.getPrimaryKey();
				sql.append(pk);
				if (it.hasNext()) {
					sql.append(",");
				}					
			}
			sql.append(")");
		}

		return super.idoFindPKsBySQL(sql.toString());
	}

	public Collection ejbFindAllBySchoolTypeCityAndManagementTypes(int schoolTypeId, String city, Collection managementTypes) throws javax.ejb.FinderException {
		StringBuffer sql = new StringBuffer("select distinct a.* ");
		sql.append(" from sch_school_area a,sch_school s,sch_school_type t,sch_school_sch_school_type m ");
		sql.append(" where a.sch_school_area_id = s.sch_school_area_id ");
		sql.append(" and t.sch_school_type_id = m.sch_school_type_id ");
		sql.append(" and s.sch_school_id = m.sch_school_id ");
		sql.append(" and t.sch_school_type_id = ");
		sql.append(schoolTypeId);
		sql.append(" and ").append(CITY).append(" = '").append(city).append("'");
		if (managementTypes != null && !managementTypes.isEmpty()) {
			sql.append(" and s.management_type in (");
			Iterator it = managementTypes.iterator();
			String type = null;
			while (it.hasNext()) {
				type = (String) it.next();
				sql.append("'").append(type).append("'");
				if (it.hasNext()) {
					sql.append(",");
				}					
			}
			sql.append(")");
		}
		sql.append(" order by a.").append(NAME);

		return super.idoFindPKsBySQL(sql.toString());
	}
	
	public Collection ejbFindAllBySchoolTypeAndCity(int type_id, String city) throws javax.ejb.FinderException {
		StringBuffer sql = new StringBuffer("select distinct a.* ");
		sql.append(" from sch_school_area a,sch_school s,sch_school_type t,sch_school_sch_school_type m ");
		sql.append(" where a.sch_school_area_id = s.sch_school_area_id ");
		sql.append(" and t.sch_school_type_id = m.sch_school_type_id ");
		sql.append(" and s.sch_school_id = m.sch_school_id ");
		sql.append(" and t.sch_school_type_id = ");
		sql.append(type_id);
		sql.append(" and ").append(CITY).append(" = '").append(city).append("'");
		sql.append(" order by ").append(NAME);

		return super.idoFindPKsBySQL(sql.toString());
	}
}