StartingtimeFieldConfigBMPBean.java

/**
 * Title:        Golf<p>
 * Description:  <p>
 * Copyright:    Copyright (c) idega 2000 - idega team - gummi<p>
 * Company:      idega margmi�lun<p>
 * @author idega 2000 - idega team - gummi
 * @version 1.0
 */
package is.idega.idegaweb.golf.entity;

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

import javax.ejb.FinderException;

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

public class StartingtimeFieldConfigBMPBean extends GenericEntity implements StartingtimeFieldConfig {

  public void initializeAttributes(){
    addAttribute(getIDColumnName());
    addAttribute("field_id","Numer vallar",true,true,"java.lang.Integer");
    addAttribute("begin_date","Tekur gildi",true,true,"java.sql.Timestamp");
    addAttribute("open_time","Opnar",true,true,"java.sql.Timestamp");
    addAttribute("close_time","Lokar",true,true,"java.sql.Timestamp");
    addAttribute("minutes_between_start","Bil milli holla",true,true,"java.lang.Integer");
    addAttribute("days_shown","Dagar i skraningu - felagar",true,true,"java.lang.Integer");
    addAttribute("days_kept","Hve lengi geymt",false,false,"java.lang.Integer");
    addAttribute("tournament_id","M�t",false,false,"java.lang.Integer");
    addAttribute("end_date","H�tti a� gilda",true,true,"java.sql.Timestamp");
    addAttribute("days_shown_non_member","Dagar i skraningu - adrir",true,true,"java.lang.Integer");
    addAttribute(getPublicRegistrationColumnName(),"skr�ning � neti f�lagar",false,false,"java.lang.Boolean");
    addAttribute(getNonMemberRegistrationColumnName(),"skr�ning � neti a�rir",false,false,"java.lang.Boolean");
  }

  public String getEntityName(){
    return "startingtime_field_config";
  }


  public void setDefultValues(){
    setDaysShown( new Integer(0) );
    setDaysShownNonMember( new Integer(0) );
  }



  public static String getPublicRegistrationColumnName(){
    return "public_registration";
  }

  public static String getNonMemberRegistrationColumnName(){
    return "nonmember_reg";
  }


  // ### get- & set-F�ll ###



  public int getTournamentID() {
      return getIntColumnValue("tournament_id");
  }

  public void setTournamentID(int tournament_id) {
      setColumn("tournament_id",tournament_id);
  }


  public int getFieldID(){
    return getIntColumnValue("field_id");
  }

  public void setFieldID( Integer field_id){
    setColumn("field_id",field_id);
  }


  public Timestamp getBeginDate(){
    return (Timestamp)getColumnValue("begin_date");
  }

  public void setBeginDate( Timestamp begin_date ){
    setColumn("begin_date",begin_date);
  }
  public Timestamp getEndDate(){
    return (Timestamp)getColumnValue("end_date");
  }

  public void setEndDate( Timestamp end_date ){
    setColumn("end_date",end_date);
  }


  public Timestamp getOpenTime(){
    return (Timestamp)getColumnValue("open_time");
  }

  public void setOpenTime( Timestamp open_time ){
    setColumn("open_time",open_time);
  }


  public Timestamp getCloseTime(){
    return (Timestamp)getColumnValue("close_time");
  }

  public void setCloseTime( Timestamp close_time ){
    setColumn("close_time",close_time);
  }


  public int getMinutesBetweenStart(){
    return getIntColumnValue("minutes_between_start");
  }

  public void setMinutesBetweenStart( Integer minutes_between_start){
    setColumn("minutes_between_start",minutes_between_start);
  }


  public int getDaysShown(){
    return getIntColumnValue("days_shown");
  }

  public int getDaysShownNonMember(){
    return getIntColumnValue("days_shown_non_member");
  }

  public void setDaysShown( Integer days_shown){
    setColumn("days_shown",days_shown);
  }

  public void setDaysShownNonMember( Integer days_shown){
    setColumn("days_shown_non_member",days_shown);
  }

  public int getDaysKept(){
    return getIntColumnValue("days_kept");
  }

  public void setDaysKept( Integer days_kept){
    setColumn("days_kept",days_kept);
  }



  public boolean publicRegistration(){
    return getBooleanColumnValue(getPublicRegistrationColumnName());
  }

  public void setPublicRegistration(boolean value){
    setColumn(getPublicRegistrationColumnName(),value);
  }

  public boolean getNonMemberRegistration(){
    return getBooleanColumnValue(getNonMemberRegistrationColumnName());
  }

  public void setNonMemberRegistration(boolean value){
    setColumn(getNonMemberRegistrationColumnName(),value);
  }
  
  public Collection ejbFindAllActiveTeetimeFieldConfigurations(IWTimestamp date) throws FinderException{
  	//select s.* from startingtime_field_config s, (SELECT field_id, max(BEGIN_DATE) as max_begin_date  FROM startingtime_field_config where begin_date < '2004-06-15 00:00:00' GROUP BY field_id) m where s.field_id = m.field_id and s.begin_date=m.max_begin_date order by open_time
  	IDOQuery query = idoQuery();
  	query.appendSelect().append("s.*").appendFrom().append(getEntityName()).append(" s, ");
  	IDOQuery sub = idoQuery();
  	sub.appendSelect().append("field_id, max(BEGIN_DATE) as max_begin_date ").appendFrom().append(getEntityName()).appendWhere("begin_date").appendLessThanOrEqualsSign().appendWithinSingleQuotes(date).appendGroupBy("field_id");
  	query.appendWithinParentheses(sub).append(" m where s.field_id = m.field_id and s.begin_date=m.max_begin_date ");
//  	System.out.println(query.toString());
  	return idoFindPKsByQuery(query);
  }


}   // class  StartingtimeFieldConfig