package com.k_int.aggr2.mimsy.data.hdo;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.Query;
import org.hibernate.Session;

@Entity
@Table(name="MIMSY_LOCATION")
public class LocationHDO {

	private Long id;
	private String code;
	private String name;
	
	protected LocationHDO()
	{;}
	
	protected LocationHDO(String code, String name)
	{
		this.code=code;
		this.name=name;
	}
	
	@Id
	@Column(name="ID")
	@GeneratedValue(strategy=GenerationType.AUTO)
	public Long getId() 
	{
		return id;
	}
	
	protected void setId(Long id)
	{
		this.id = id;
	}
	
	@Column(name="LOC_NAME")
	public String getName()
	{
		return name;
	}
	
	@Column(name="LOC_CODE",length=128,unique=true)
	public String getCode()
	{
		return code;
	}
	
	protected void setCode(String code)
	{
		this.code=code;
	}
	
	public void setName(String name)
	{
		this.name=name;
	}
	
	public static LocationHDO lookupByCode(Session sess, String code)
	{
		Query q = sess.createQuery("select x from com.k_int.aggr2.mimsy.data.hdo.LocationHDO x where x.code=:code");
	 	q= q.setParameter("code", code);		  
	 
	 	return (LocationHDO)q.uniqueResult();
	}
	
	public static LocationHDO lookupOrCreateByCode(Session sess,String code)
	{
		LocationHDO retval = lookupByCode(sess,code);
		if(retval==null)
		{
			retval = new LocationHDO();
			retval.setCode(code);
			sess.save(retval);
			sess.flush();
		}
		return retval;
	}
	
}