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.Payment; 48 import org.campware.cream.om.PaymentPeer; 49 import org.campware.cream.om.ProductPeer; 50 import org.campware.cream.om.ProjectPeer; 51 import org.campware.cream.om.CustomerPeer; 52 import org.campware.cream.om.CurrencyPeer; 53 import org.campware.cream.om.SorderPeer; 54 55 59 public class PaymentForm extends CreamForm 60 { 61 protected void initScreen() 62 { 63 setModuleType(DOCUMENT); 64 setModuleName("PAYMENT"); 65 setIdName(PaymentPeer.PAYMENT_ID); 66 setFormIdName("paymentid"); 67 } 68 69 protected boolean getEntry(Criteria criteria, Context context) 70 { 71 try 72 { 73 Payment entry = (Payment) PaymentPeer.doSelect(criteria).get(0); 74 context.put("entry", entry); 75 context.put("entryitems", entry.getPaymentItems()); 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 Payment entry = new Payment(); 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 prodcrit.add(ProductPeer.PRODUCT_ID, 999, Criteria.GREATER_THAN); 119 prodcrit.addAscendingOrderByColumn(ProductPeer.PRODUCT_CODE); 120 context.put("products", ProductPeer.doSelect(prodcrit)); 121 122 Criteria projcrit = new Criteria(); 123 projcrit.add(ProjectPeer.PROJECT_ID, 999, Criteria.GREATER_THAN); 124 projcrit.addAscendingOrderByColumn(ProjectPeer.PROJECT_NAME); 125 context.put("projects", ProjectPeer.doSelect(projcrit)); 126 127 Criteria custcrit = new Criteria(); 128 Criteria.Criterion b1 = custcrit.getNewCriterion(CustomerPeer.CUSTOMER_ID, new Integer (1000), Criteria.EQUAL); 129 Criteria.Criterion b2 = custcrit.getNewCriterion(CustomerPeer.STATUS, new Integer (29), Criteria.GREATER_THAN); 130 custcrit.add( b1.or( b2)); 131 custcrit.addAscendingOrderByColumn(CustomerPeer.CUSTOMER_DISPLAY); 132 context.put("customers", CustomerPeer.doSelect(custcrit)); 133 134 Criteria currcrit = new Criteria(); 135 currcrit.add(CurrencyPeer.CURRENCY_ID, 1000, Criteria.GREATER_THAN); 136 currcrit.addAscendingOrderByColumn(CurrencyPeer.CURRENCY_CODE); 137 context.put("currencies", CurrencyPeer.doSelect(currcrit)); 138 139 return true; 140 } 141 catch (Exception e) 142 { 143 return false; 144 } 145 } 146 147 148 } 149 | Popular Tags |