TopNodeGroupBMPBean.java

/*
 * Created on 13.8.2004
 *
 * Copyright (C) 2004 Idega hf. All Rights Reserved.
 *
 *  This software is the proprietary information of Idega hf.
 *  Use is subject to license terms.
 */
package com.idega.user.data;


import java.sql.Timestamp;
import java.util.Collection;

import javax.ejb.CreateException;
import javax.ejb.FinderException;

import com.idega.data.GenericEntity;
import com.idega.data.IDORelationshipException;

/**
 * @author aron
 *
 * TopNodeGroupBMPBean keeps track of users top group nodes to be displayed in group tree
 */
public class TopNodeGroupBMPBean extends GenericEntity  implements TopNodeGroup{
    
    public final static String TABLE_NAME = "IC_USER_TOPNODES";
    public final static String COLUMN_USER_ID = "USER_ID";
    public final static String COLUMN_GROUP_ID = "GROUP_ID";
    public final static String COLUMN_LOGIN_DURATION = "LOGIN_DURATION";
    public final static String COLUMN_NUMBER_OF_PERMISSIONS = "NUMBER_OF_PERMISSIONS";
    public final static String COLUMN_LASTCHANGED = "LAST_CHANGED";
    public final static String COLUMN_COMMENT = "TN_COMMENT";
    

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

    /* (non-Javadoc)
     * @see com.idega.data.GenericEntity#initializeAttributes()
     */
    public void initializeAttributes() {
        addAttribute(COLUMN_USER_ID,"User id",true,true,Integer.class);
        addAttribute(COLUMN_GROUP_ID,"Group id",true,true,Integer.class);
        addAttribute(COLUMN_LOGIN_DURATION,"Login duration",true,true,String.class);
        addAttribute(COLUMN_NUMBER_OF_PERMISSIONS,"Number of permissions",true,true,Integer.class);
        addAttribute(COLUMN_LASTCHANGED,"Last changed",true,true,Timestamp.class);
        addAttribute(COLUMN_COMMENT,"Comment",true,true,String.class);
        
        setAsPrimaryKey(COLUMN_USER_ID,true);
        addManyToOneRelationship(COLUMN_USER_ID,User.class);
        setAsPrimaryKey(COLUMN_GROUP_ID,true);
        addManyToOneRelationship(COLUMN_GROUP_ID,Group.class);
        
        setNullable(COLUMN_USER_ID, false);
		setNullable(COLUMN_GROUP_ID, false);
    }
    
    /* (non-Javadoc)
	 * @see com.idega.data.IDOEntityBean#getPrimaryKeyClass()
	 */
	public Class getPrimaryKeyClass() {
		return TopNodeGroupKey.class;
	}
	
	public Object ejbFindByPrimaryKey(TopNodeGroupKey primaryKey) throws FinderException {
		return super.ejbFindByPrimaryKey(primaryKey);
	}
	
	protected boolean doInsertInCreate() {
		return true;
	}
	
	public Object ejbCreate(TopNodeGroupKey primaryKey) throws CreateException {
		setPrimaryKey(primaryKey);
		return super.ejbCreate();
	}
	
	public Object ejbCreate(Integer userID,Integer groupID) throws CreateException {
	    TopNodeGroupKey primaryKey = new TopNodeGroupKey(userID,groupID);
		setPrimaryKey(primaryKey);
		return super.ejbCreate();
	}
    
    public Integer getUserId(){
        return getIntegerColumnValue(COLUMN_USER_ID);
    }
    
    public void setUserId(Integer id){
        setColumn(COLUMN_USER_ID,id);
    }
    
    public Integer getGroupId(){
        return getIntegerColumnValue(COLUMN_GROUP_ID);
    }
    
    public void setGroupId(Integer id){
        setColumn(COLUMN_GROUP_ID,id);
    }
    
    public Timestamp getLastChanged(){
        return getTimestampColumnValue(COLUMN_LASTCHANGED);
    }
    
    public void setLastChanged(Timestamp stamp){
        setColumn(COLUMN_LASTCHANGED,stamp);
    }
    
    public String getComment(){
        return getStringColumnValue(COLUMN_COMMENT);
    }

    public void setComment(String comment){
        setColumn(COLUMN_COMMENT,comment);
    }
    
    public String getLoginDuration() {
        return getStringColumnValue(COLUMN_LOGIN_DURATION);
    }

    public void setLoginDuration(String login_duration) {
        setColumn(COLUMN_LOGIN_DURATION, login_duration);
    }

    public void setNumberOfPermissions(Integer number_of_permissions) {
        setColumn(COLUMN_NUMBER_OF_PERMISSIONS, number_of_permissions);
    }

    public Integer getNumberOfPermissions() {
        return getIntegerColumnValue(COLUMN_NUMBER_OF_PERMISSIONS);
    }

    public Collection ejbFindByUser(Integer userID)throws FinderException{
        return super.idoFindPKsByQuery(idoQueryGetSelect().appendWhereEquals(COLUMN_USER_ID,userID));
    }
    
    public Collection ejbFindByUser(User user)throws FinderException{
        return super.idoFindPKsByQuery(idoQueryGetSelect().appendWhereEquals(COLUMN_USER_ID,(Integer)user.getPrimaryKey()));
    }
    
    public Collection ejbFindByGroup(Integer groupID)throws FinderException{
        return super.idoFindPKsByQuery(idoQueryGetSelect().appendWhereEquals(COLUMN_GROUP_ID,groupID));
    }
    
    public Collection ejbHomegetTopNodeGroups(User user)throws IDORelationshipException{
        String sql = "Select gr.* from ic_group gr,"+TABLE_NAME+" tn where gr.ic_group_id = tn."+COLUMN_GROUP_ID +" and tn."+COLUMN_USER_ID+" = "+user.getPrimaryKey().toString();
        return super.idoGetRelatedEntitiesBySQL(Group.class,sql);
    }
}