/* * $Id:$ * * Copyright (C) 2002 Idega hf. All Rights Reserved. * * This software is the proprietary information of Idega hf. * Use is subject to license terms. * */ package is.idega.idegaweb.atvr.supplier.application.data; import com.idega.core.user.data.User; import com.idega.data.GenericEntity; import java.rmi.RemoteException; import java.sql.Timestamp; import java.util.Collection; import javax.ejb.FinderException; /** * This class does something very clever..... * * @author <a href="palli@idega.is">Pall Helgason</a> * @version 1.0 */ public class NewProductApplicationBMPBean extends GenericEntity implements NewProductApplication { private final static String ENTITY_NAME = "wine_newprod"; protected final static String APPLICATION_TYPE = "appl_type"; protected final static String DESCRIPTION = "description"; protected final static String DESCRIPTION2 = "description_2"; protected final static String QUANTITY = "quantity"; protected final static String STRENGTH = "strength"; protected final static String PRODUCER = "producer"; protected final static String COUNTRY_OF_ORIGIN = "country"; protected final static String BAR_CODE = "bar_code"; protected final static String PRODUCT_CATEGORY = "prod_category"; protected final static String SUPPLIER = "supplier"; protected final static String APPLICATION_SENT = "sent"; protected final static String PRICE = "price"; protected final static String SUPPLIERS_PROD_ID = "suppl_prod_id"; protected final static String AMOUNT = "amount"; protected final static String WEIGHT = "weight"; protected final static String STATUS = "status"; protected final static String CARBON_MONOXIDE = "monoxide"; /** * @see com.idega.data.IDOLegacyEntity#getEntityName() */ public String getEntityName() { return ENTITY_NAME; } /** * @see com.idega.data.IDOLegacyEntity#initializeAttributes() */ public void initializeAttributes() { addAttribute(getIDColumnName()); addAttribute(APPLICATION_TYPE,"",true,true,java.lang.String.class,1); addAttribute(DESCRIPTION,"",true,true,java.lang.String.class,1000); addAttribute(DESCRIPTION2,"",true,true,java.lang.String.class,1000); addAttribute(QUANTITY,"",true,true,java.lang.String.class,100); addAttribute(STRENGTH,"",true,true,java.lang.String.class,100); addAttribute(PRODUCER,"",true,true,java.lang.String.class,1000); addAttribute(COUNTRY_OF_ORIGIN,"",true,true,java.lang.String.class,1000); addAttribute(BAR_CODE,"",true,true,java.lang.String.class,50); addAttribute(APPLICATION_SENT,"",true,true,java.sql.Timestamp.class); addAttribute(PRICE,"",true,true,java.lang.Float.class); addAttribute(SUPPLIERS_PROD_ID,"",true,true,java.lang.String.class,100); addAttribute(AMOUNT,"",true,true,java.lang.String.class,100); addAttribute(WEIGHT,"",true,true,java.lang.String.class,100); addAttribute(STATUS,"",true,true,java.lang.String.class,1); addAttribute(CARBON_MONOXIDE,"",true,true,java.lang.Float.class); addManyToOneRelationship(PRODUCT_CATEGORY,ProductCategory.class); addManyToOneRelationship(SUPPLIER,User.class); } public void setApplicationType(String type) { setColumn(APPLICATION_TYPE,type); } public void setDescription(String description) { setColumn(DESCRIPTION,description); } public void setDescription2(String description) { setColumn(DESCRIPTION2,description); } public void setQuantity(String qty) { setColumn(QUANTITY,qty); } public void setStrength(String strength) { setColumn(STRENGTH,strength); } public void setProducer(String producer) { setColumn(PRODUCER,producer); } public void setCountryOfOrigin(String country) { setColumn(COUNTRY_OF_ORIGIN,country); } public void setBarCode(String code) { setColumn(BAR_CODE,code); } public void setProductCategoryId(int id) { setColumn(PRODUCT_CATEGORY,id); } public void setProductCategory(ProductCategory cat) { setColumn(PRODUCT_CATEGORY,cat); } public void setSupplierId(int id) { setColumn(SUPPLIER,id); } public void setSupplier(User supplier) { setColumn(SUPPLIER,supplier); } public void setApplicationSent(Timestamp sent) { setColumn(APPLICATION_SENT,sent); } public void setPrice(float price) { setColumn(PRICE,price); } public void setSuppliersProductId(String id) { setColumn(SUPPLIERS_PROD_ID,id); } public void setAmount(String amount) { setColumn(AMOUNT,amount); } public void setWeigth(String weight) { setColumn(WEIGHT,weight); } public void setStatus(String status) { setColumn(STATUS,status); } public void setCarbonMonoxide(float monoxide) { setColumn(CARBON_MONOXIDE,monoxide); } public String getApplicationType() { return getStringColumnValue(APPLICATION_TYPE); } public String getDescription() { return getStringColumnValue(DESCRIPTION); } public String getDescription2() { return getStringColumnValue(DESCRIPTION2); } public String getQuantity() { return getStringColumnValue(QUANTITY); } public String getStrength() { return getStringColumnValue(STRENGTH); } public String getProducer() { return getStringColumnValue(PRODUCER); } public String getCountryOfOrigin() { return getStringColumnValue(COUNTRY_OF_ORIGIN); } public String getBarCode() { return getStringColumnValue(BAR_CODE); } public int getProductCategoryId() { return getIntColumnValue(PRODUCT_CATEGORY); } public ProductCategory getProductCategory() { return (ProductCategory)getColumnValue(PRODUCT_CATEGORY); } public int getSupplierId() { return getIntColumnValue(SUPPLIER); } public User getSupplier() { return (User)getColumnValue(SUPPLIER); } public Timestamp getApplicationSent() { return (Timestamp)getColumnValue(APPLICATION_SENT); } public float getPrice() { return getFloatColumnValue(PRICE); } public String getSuppliersProductId() { return getStringColumnValue(SUPPLIERS_PROD_ID); } public String getAmount() { return getStringColumnValue(AMOUNT); } public String getWeigth() { return getStringColumnValue(WEIGHT); } public String getStatus() { return getStringColumnValue(STATUS); } public float getCarbonMonoxide() { return getFloatColumnValue(CARBON_MONOXIDE); } public Collection ejbFindAll() throws FinderException, RemoteException { return super.idoFindAllIDsBySQL(); } public Collection ejbFindAllByStatus(String status) throws FinderException, RemoteException { StringBuffer sql = new StringBuffer("select * from "); sql.append(getEntityName()); sql.append(" where "); sql.append(STATUS); sql.append(" = '"); sql.append(status); sql.append("'"); return super.idoFindPKsBySQL(sql.toString()); } }