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.Shipment; 48 import org.campware.cream.om.ShipmentPeer; 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.SorderPeer; 54 55 59 public class ShipmentForm extends CreamForm 60 { 61 protected void initScreen() 62 { 63 setModuleType(DOCUMENT); 64 setModuleName("SHIPMENT"); 65 setIdName(ShipmentPeer.SHIPMENT_ID); 66 setFormIdName("shipmentid"); 67 } 68 69 protected boolean getEntry(Criteria criteria, Context context) 70 { 71 try 72 { 73 Shipment entry = (Shipment) ShipmentPeer.doSelect(criteria).get(0); 74 context.put("entry", entry); 75 context.put("entryitems", entry.getShipmentItems()); 76 77 Criteria ordcrit = new Criteria(); 78 Criteria.Criterion a1 = ordcrit.getNewCriterion(SorderPeer.SORDER_ID, new Integer (1000), Criteria.EQUAL); 79 Criteria.Criterion a2 = ordcrit.getNewCriterion(SorderPeer.SORDER_ID, new Integer (entry.getSorderId()), Criteria.EQUAL); 80 Criteria.Criterion a3 = ordcrit.getNewCriterion(SorderPeer.CUSTOMER_ID, new Integer (entry.getCustomerId()), Criteria.EQUAL); 81 Criteria.Criterion a4 = ordcrit.getNewCriterion(SorderPeer.STATUS, new Integer (30), Criteria.EQUAL); 82 ordcrit.add( a1.or( a2.or(a3.and(a4)))); 83 ordcrit.addAscendingOrderByColumn(SorderPeer.SORDER_CODE); 84 context.put("orders", SorderPeer.doSelect(ordcrit)); 85 86 return true; 87 } 88 catch (Exception e) 89 { 90 return false; 91 } 92 } 93 94 protected boolean getNew(Context context) 95 { 96 try 97 { 98 Shipment entry = new Shipment(); 99 context.put("entry", entry); 100 101 Criteria ordcrit = new Criteria(); 102 ordcrit.add(SorderPeer.SORDER_ID, 1000, Criteria.EQUAL); 103 context.put("orders", SorderPeer.doSelect(ordcrit)); 104 105 return true; 106 } 107 catch (Exception e) 108 { 109 return false; 110 } 111 } 112 113 protected boolean getLookups(Context context) 114 { 115 try 116 { 117 Criteria prodcrit = new Criteria(); 118 Criteria.Criterion a1 = prodcrit.getNewCriterion(ProductPeer.PRODUCT_ID, new Integer (1000), Criteria.EQUAL); 119 Criteria.Criterion a2 = prodcrit.getNewCriterion(ProductPeer.PRODUCT_TYPE, new Integer (10), Criteria.EQUAL); 120 prodcrit.add( a1.or( a2)); 121 prodcrit.addAscendingOrderByColumn(ProductPeer.PRODUCT_CODE); 122 context.put("products", ProductPeer.doSelect(prodcrit)); 123 124 Criteria projcrit = new Criteria(); 125 projcrit.add(ProjectPeer.PROJECT_ID, 999, Criteria.GREATER_THAN); 126 projcrit.addAscendingOrderByColumn(ProjectPeer.PROJECT_NAME); 127 context.put("projects", ProjectPeer.doSelect(projcrit)); 128 129 Criteria carrcrit = new Criteria(); 130 carrcrit.add(CarrierPeer.CARRIER_ID, 999, Criteria.GREATER_THAN); 131 carrcrit.addAscendingOrderByColumn(CarrierPeer.CARRIER_NAME); 132 context.put("carriers", CarrierPeer.doSelect(carrcrit)); 133 134 Criteria custcrit = new Criteria(); 135 Criteria.Criterion b1 = custcrit.getNewCriterion(CustomerPeer.CUSTOMER_ID, new Integer (1000), Criteria.EQUAL); 136 Criteria.Criterion b2 = custcrit.getNewCriterion(CustomerPeer.STATUS, new Integer (29), Criteria.GREATER_THAN); 137 custcrit.add( b1.or( b2)); 138 custcrit.addAscendingOrderByColumn(CustomerPeer.CUSTOMER_DISPLAY); 139 context.put("customers", CustomerPeer.doSelect(custcrit)); 140 141 return true; 142 } 143 catch (Exception e) 144 { 145 return false; 146 } 147 } 148 149 150 } 151 | Popular Tags |