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.Sorder; 48 import org.campware.cream.om.SorderPeer; 49 import org.campware.cream.om.ProductPeer; 50 import org.campware.cream.om.ProjectPeer; 51 import org.campware.cream.om.CarrierPeer; 52 import org.campware.cream.om.CustomerPeer; 53 import org.campware.cream.om.CurrencyPeer; 54 55 59 public class OrderForm extends CreamForm 60 { 61 protected void initScreen() 62 { 63 setModuleType(DOCUMENT); 64 setModuleName("SORDER"); 65 setIdName(SorderPeer.SORDER_ID); 66 setFormIdName("sorderid"); 67 } 68 69 protected boolean getEntry(Criteria criteria, Context context) 70 { 71 try 72 { 73 Sorder entry = (Sorder) SorderPeer.doSelect(criteria).get(0); 74 context.put("entry", entry); 75 context.put("entryitems", entry.getSorderItems()); 76 return true; 77 } 78 catch (Exception e) 79 { 80 return false; 81 } 82 } 83 84 protected boolean getNew(Context context) 85 { 86 try 87 { 88 Sorder entry = new Sorder(); 89 context.put("entry", entry); 90 return true; 91 } 92 catch (Exception e) 93 { 94 return false; 95 } 96 } 97 98 protected boolean getLookups(Context context) 99 { 100 try 101 { 102 Criteria prodcrit = new Criteria(); 103 prodcrit.add(ProductPeer.PRODUCT_ID, 999, Criteria.GREATER_THAN); 104 prodcrit.addAscendingOrderByColumn(ProductPeer.PRODUCT_CODE); 105 context.put("products", ProductPeer.doSelect(prodcrit)); 106 107 Criteria projcrit = new Criteria(); 108 projcrit.add(ProjectPeer.PROJECT_ID, 999, Criteria.GREATER_THAN); 109 projcrit.addAscendingOrderByColumn(ProjectPeer.PROJECT_NAME); 110 context.put("projects", ProjectPeer.doSelect(projcrit)); 111 112 Criteria carrcrit = new Criteria(); 113 carrcrit.add(CarrierPeer.CARRIER_ID, 999, Criteria.GREATER_THAN); 114 carrcrit.addAscendingOrderByColumn(CarrierPeer.CARRIER_NAME); 115 context.put("carriers", CarrierPeer.doSelect(carrcrit)); 116 117 Criteria custcrit = new Criteria(); 118 Criteria.Criterion b1 = custcrit.getNewCriterion(CustomerPeer.CUSTOMER_ID, new Integer (1000), Criteria.EQUAL); 119 Criteria.Criterion b2 = custcrit.getNewCriterion(CustomerPeer.STATUS, new Integer (29), Criteria.GREATER_THAN); 120 custcrit.add( b1.or( b2)); 121 custcrit.addAscendingOrderByColumn(CustomerPeer.CUSTOMER_DISPLAY); 122 context.put("customers", CustomerPeer.doSelect(custcrit)); 123 124 Criteria currcrit = new Criteria(); 125 currcrit.add(CurrencyPeer.CURRENCY_ID, 1000, Criteria.GREATER_THAN); 126 currcrit.addAscendingOrderByColumn(CurrencyPeer.CURRENCY_CODE); 127 context.put("currencies", CurrencyPeer.doSelect(currcrit)); 128 129 return true; 130 } 131 catch (Exception e) 132 { 133 return false; 134 } 135 } 136 137 138 } 139 | Popular Tags |