/*
<<<<<<< ContractAccountsBMPBean.java
*
* $Id: ContractAccountsBMPBean.java,v 1.5.4.1 2006/12/13 15:07:28 palli Exp $
*
*
*
=======
* $Id: ContractAccountsBMPBean.java,v 1.5.4.1 2006/12/13 15:07:28 palli Exp $
*
>>>>>>> 1.3
* Copyright (C) 2001 Idega hf. All Rights Reserved.
*
*
*
* This software is the proprietary information of Idega hf.
*
* Use is subject to license terms.
*
*
*
*/
package is.idega.idegaweb.campus.data;
import java.sql.Date;
import java.sql.SQLException;
import java.sql.Timestamp;
import javax.ejb.FinderException;
/**
*
* Title:
*
* Description:
*
* Copyright: Copyright (c) 2000-2001 idega.is All Rights Reserved
*
* Company: idega
*
* @author <a href="mailto:aron@idega.is">Aron Birkir</a>
*
* @version 1.1
*
*/
public class ContractAccountsBMPBean
extends com.idega.data.GenericView
implements is.idega.idegaweb.campus.data.ContractAccounts {
/*
*
*
*
* CREATE VIEW "V_CONTRACT_ACCOUNTS" ( "CAM_CONTRACT_ID", "IC_USER_ID",
* "BU_APARTMENT_ID", "FIN_ACCOUNT_ID", "PHONE_ACCOUNT_ID", "FIN_BALANCE",
* "PHONE_BALANCE", "VALID_FROM", "VALID_TO", "DELIVER_DATE",
* "RETURN_DATE", "STATUS", "RENTED", "BU_APRT_TYPE_ID", "BU_APRT_CAT_ID",
* "BU_FLOOR_ID", "BU_BUILDING_ID", "BU_COMPLEX_ID", "CONTRACT_STATUS" ) AS
* select cc.cam_contract_id, cc.ic_user_id, cc.bu_apartment_id,
* fa.fin_account_id, fa2.fin_account_id phone_account_id, fa.balance
* fin_balance, fa2.balance phone_balance, cc.valid_from, cc.valid_to,
* cc.deliver_date,
*
* cc.return_date,
*
* cc.status,
*
* cc.rented,
*
* ba.bu_aprt_type_id ,
*
* bc.bu_aprt_cat_id,
*
* bf.bu_floor_id,
*
* bb.bu_building_id,
*
* bx.bu_complex_id,
*
* cc.status contract_status
*
*
*
* from cam_contract cc,fin_account fa, fin_account fa2,bu_apartment ba,
*
* bu_floor bf,bu_building bb,bu_complex bx,bu_aprt_cat bc,bu_aprt_type bt
*
* where cc.ic_user_id = fa.ic_user_id
*
* and cc.bu_apartment_id = ba.bu_apartment_id
*
* and ba.bu_floor_id = bf.bu_floor_id
*
* and bf.bu_building_id = bb.bu_building_id
*
* and bb.bu_complex_id = bx.bu_complex_id
*
* and ba.bu_aprt_type_id = bt.bu_aprt_type_id
*
* and bt.bu_aprt_cat_id = bc.bu_aprt_cat_id
*
* and fa.ic_user_id = fa2.ic_user_id
*
* and fa.account_type = 'FINANCE'
*
* and fa2.account_type = 'PHONE'
*
*/
public static String getEntityTableName() {
return "V_CONTRACT_ACCOUNTS";
}
public static String getColumnNameContractId() {
return "CAM_CONTRACT_ID";
}
public String getIDColumnName(){
return getColumnNameContractId();
}
public static String getColumnNameUserId() {
return "IC_USER_ID";
}
public static String getColumnNameApartmentId() {
return "BU_APARTMENT_ID";
}
public static String getColumnNameFinanceAccountId() {
return "FIN_ACCOUNT_ID";
}
public static String getColumnNamePhoneAccountId() {
return "PHONE_ACCOUNT_ID";
}
public static String getColumnNameFinanceBalance() {
return "FIN_BALANCE";
}
public static String getColumnNamePhoneBalance() {
return "PHONE_BALANCE";
}
public static String getColumnValidFrom() {
return "VALID_FROM";
}
public static String getColumnValidTo() {
return "VALID_TO";
}
public static String getColumnReturnDate() {
return "RETURN_DATE";
}
public static String getColumnDeliverdate() {
return "DELIVER_DATE";
}
public static String getColumnStatus() {
return "STATUS";
}
public static String getColumnRented() {
return "RENTED";
}
public static String getColumnNameApartmentTypeId() {
return "BU_APRT_TYPE_ID";
}
public static String getColumnNameApartmentCategoryId() {
return "BU_APRT_CAT_ID";
}
public static String getColumnNameFloorId() {
return "BU_FLOOR_ID";
}
public static String getColumnNameBuildingId() {
return "BU_BUILDING_ID";
}
public static String getColumnNameComplexId() {
return "BU_COMPLEX_ID";
}
public static String getColumnNameContractStatus() {
return "CONTRACT_STATUS";
}
public ContractAccountsBMPBean() {
}
public ContractAccountsBMPBean(int id) throws SQLException {
}
public void initializeAttributes() {
addAttribute(getIDColumnName());
addAttribute(getColumnNameContractId(), "Contract id", true, true, Integer.class);
addAttribute(getColumnNameUserId(), "User id", true, true, Integer.class);
addAttribute(getColumnNameApartmentId(), "Apartment id", true, true, Integer.class);
addAttribute(getColumnNameFinanceAccountId(), "Finance account id", true, true, Integer.class);
addAttribute(getColumnNamePhoneAccountId(), "Phone account id", true, true, Integer.class);
addAttribute(getColumnNameFinanceBalance(), "Finance Balance", true, true, Float.class);
addAttribute(getColumnNamePhoneBalance(), "Phone Balance", true, true, Float.class);
addAttribute(getColumnValidFrom(), "Valid from", true, true, Date.class);
addAttribute(getColumnValidTo(), "Valid to", true, true, Date.class);
addAttribute(getColumnDeliverdate(), "Deliver date", true, true, Timestamp.class);
addAttribute(getColumnReturnDate(), "Return date", true, true, Timestamp.class);
addAttribute(getColumnStatus(), "status", true, true, String.class, 1);
addAttribute(getColumnRented(), "rented", true, true, Boolean.class);
addAttribute(getColumnNameApartmentTypeId(), "Apartmenttype id", true, true, Integer.class);
addAttribute(getColumnNameApartmentCategoryId(), "Apartmentcategory id", true, true, Integer.class);
addAttribute(getColumnNameFloorId(), "Floor id", true, true, Integer.class);
addAttribute(getColumnNameBuildingId(), "Building id", true, true, Integer.class);
addAttribute(getColumnNameComplexId(), "Complex id", true, true, Integer.class);
addAttribute(getColumnNameContractStatus(), "Complex id", true, true, String.class);
}
public String getEntityName() {
return (getEntityTableName());
}
public int getContractId() {
return getIntColumnValue(getColumnNameContractId());
}
public int getUserId() {
return getIntColumnValue(getColumnNameUserId());
}
public int getApartmentId() {
return getIntColumnValue(getColumnNameApartmentId());
}
public int getApartmentTypeId() {
return getIntColumnValue(getColumnNameApartmentTypeId());
}
public int getFinanceAccountId() {
return getIntColumnValue(getColumnNameFinanceAccountId());
}
public int getPhoneAccountId() {
return getIntColumnValue(getColumnNamePhoneAccountId());
}
public float getFinanceBalance() {
return getFloatColumnValue(getColumnNameFinanceBalance());
}
public float getPhoneBalance() {
return getFloatColumnValue(getColumnNamePhoneBalance());
}
public int getApartmentCategoryId() {
return getIntColumnValue(getColumnNameApartmentCategoryId());
}
public int getFloorId() {
return getIntColumnValue(getColumnNameFloorId());
}
public int getBuildingId() {
return getIntColumnValue(getColumnNameBuildingId());
}
public int getComplexId() {
return getIntColumnValue(getColumnNameComplexId());
}
public String getContracStatus() {
return getStringColumnValue(getColumnNameContractStatus());
}
public Date getValidFrom() {
return ((Date) getColumnValue(getColumnValidFrom()));
}
public Date getValidTo() {
return ((Date) getColumnValue(getColumnValidTo()));
}
public Timestamp getDeliverTime() {
return ((Timestamp) getColumnValue(getColumnDeliverdate()));
}
public Timestamp getReturnTime() {
return ((Timestamp) getColumnValue(getColumnReturnDate()));
}
public boolean getIsRented() {
return getBooleanColumnValue(getColumnRented());
}
public String getStatus() {
return getStringColumnValue(getColumnStatus());
}
public void insert() throws SQLException {
}
public void delete() throws SQLException {
}
/*
* (non-Javadoc)
*
* @see com.idega.data.IDOView#getCreationSQL()
*/
public String getCreationSQL() {
StringBuffer sql = new StringBuffer();
sql.append(" CREATE VIEW V_CONTRACT_ACCOUNTS ( ");
sql.append(" CAM_CONTRACT_ID, ");
sql.append(" IC_USER_ID, ");
sql.append(" BU_APARTMENT_ID, ");
sql.append(" FIN_ACCOUNT_ID, ");
sql.append(" PHONE_ACCOUNT_ID, ");
sql.append(" FIN_BALANCE, ");
sql.append(" PHONE_BALANCE, ");
sql.append(" VALID_FROM, ");
sql.append(" VALID_TO, ");
sql.append(" DELIVER_DATE, ");
sql.append(" RETURN_DATE, ");
sql.append(" STATUS, ");
sql.append(" RENTED, ");
sql.append(" BU_APRT_TYPE_ID, ");
sql.append(" BU_APRT_CAT_ID, ");
sql.append(" BU_FLOOR_ID, ");
sql.append(" BU_BUILDING_ID, ");
sql.append(" BU_COMPLEX_ID, ");
sql.append(" CONTRACT_STATUS ");
sql.append(" ) AS ");
sql.append(" select ");
sql.append(" cc.cam_contract_id, ");
sql.append(" cc.ic_user_id, ");
sql.append(" cc.bu_apartment_id, ");
sql.append(" fa.fin_account_id, ");
sql.append(" fa2.fin_account_id phone_account_id, ");
sql.append(" fa.balance fin_balance, ");
sql.append(" fa2.balance phone_balance, ");
sql.append(" cc.valid_from, ");
sql.append(" cc.valid_to, ");
sql.append(" cc.deliver_date, ");
sql.append(" cc.return_date, ");
sql.append(" cc.status, ");
sql.append(" cc.rented, ");
sql.append(" ba.bu_aprt_type_id , ");
sql.append(" bc.bu_aprt_cat_id, ");
sql.append(" bf.bu_floor_id, ");
sql.append(" bb.bu_building_id, ");
sql.append(" bx.bu_complex_id, ");
sql.append(" cc.status contract_status ");
sql.append(" from cam_contract cc,fin_account fa, fin_account fa2,bu_apartment ba, ");
sql.append(" bu_floor bf,bu_building bb,bu_complex bx,bu_aprt_cat bc,bu_aprt_type bt ");
sql.append(" where cc.ic_user_id = fa.ic_user_id ");
sql.append(" and cc.bu_apartment_id = ba.bu_apartment_id ");
sql.append(" and ba.bu_floor_id = bf.bu_floor_id ");
sql.append(" and bf.bu_building_id = bb.bu_building_id ");
sql.append(" and bb.bu_complex_id = bx.bu_complex_id ");
sql.append(" and ba.bu_aprt_type_id = bt.bu_aprt_type_id ");
sql.append(" and bt.bu_aprt_cat_id = bc.bu_aprt_cat_id ");
sql.append(" and fa.ic_user_id = fa2.ic_user_id ");
sql.append(" and fa.account_type = 'FINANCE' ");
sql.append(" and fa2.account_type = 'PHONE' ");
return sql.toString();
}
/*
* (non-Javadoc)
*
* @see com.idega.data.GenericView#getViewName()
*/
public String getViewName() {
// TODO Auto-generated method stub
return super.getViewName();
}
public java.util.Collection ejbFindByPeriodOverLap(Date from ,Date to)throws FinderException{
return super.idoFindPKsByQuery(super.idoQueryGetSelect().appendWhere().appendOverlapPeriod(getColumnValidFrom(),getColumnValidTo(),from,to));
}
}