1 package org.campware.cream.modules.screens; 2 3 42 43 import org.apache.torque.util.Criteria; 44 45 import org.apache.velocity.context.Context; 46 47 import org.campware.cream.om.Product; 48 import org.campware.cream.om.ProductPeer; 49 import org.campware.cream.om.VendorPeer; 50 import org.campware.cream.om.ProductCategoryPeer; 51 import org.campware.cream.om.UomPeer; 52 53 57 public class ProductForm extends CreamForm 58 { 59 protected void initScreen() 60 { 61 setModuleType(ENTITY); 62 setModuleName("PRODUCT"); 63 setIdName(ProductPeer.PRODUCT_ID); 64 setFormIdName("productid"); 65 } 66 67 protected boolean getEntry(Criteria criteria, Context context) 68 { 69 try 70 { 71 Product entry = (Product) ProductPeer.doSelect(criteria).get(0); 72 context.put("entry", entry); 73 74 return true; 75 } 76 catch (Exception e) 77 { 78 return false; 79 } 80 } 81 82 protected boolean getNew(Context context) 83 { 84 try 85 { 86 Product entry = new Product(); 87 context.put("entry", entry); 88 return true; 89 } 90 catch (Exception e) 91 { 92 return false; 93 } 94 } 95 96 protected boolean getLookups(Context context) 97 { 98 try 99 { 100 Criteria vendorcrit = new Criteria(); 101 vendorcrit.add(VendorPeer.VENDOR_ID, 999, Criteria.GREATER_THAN); 102 vendorcrit.addAscendingOrderByColumn(VendorPeer.VENDOR_NAME); 103 context.put("vendors", VendorPeer.doSelect(vendorcrit)); 104 105 Criteria prodcatcrit = new Criteria(); 106 prodcatcrit.add(ProductCategoryPeer.PRODUCT_CAT_ID, 999, Criteria.GREATER_THAN); 107 prodcatcrit.addAscendingOrderByColumn(ProductCategoryPeer.PRODUCT_CAT_NAME); 108 context.put("productcats", ProductCategoryPeer.doSelect(prodcatcrit)); 109 110 Criteria uomcrit = new Criteria(); 111 uomcrit.add(UomPeer.UOM_ID, 900, Criteria.LESS_THAN); 112 Criteria.Criterion criterion = uomcrit.getCriterion(UomPeer.UOM_ID); 113 criterion.or( 114 uomcrit.getNewCriterion( 115 criterion.getTable(), 116 criterion.getColumn(), 117 new Integer (999), 118 Criteria.GREATER_THAN ) 119 ); 120 121 uomcrit.addAscendingOrderByColumn(UomPeer.UOM_NAME); 122 context.put("uoms", UomPeer.doSelect(uomcrit)); 123 124 return true; 125 } 126 catch (Exception e) 127 { 128 return false; 129 } 130 } 131 132 } 133 | Popular Tags |