|
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.OnlineSubscription;
48 import org.campware.cream.om.OnlineSubscriptionPeer;
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.SorderPeer;
53
54
58 public class OnlineSubscriptionForm extends CreamForm
59 {
60 protected void initScreen()
61 {
62 setModuleType(DOCUMENT);
63 setModuleName("ONLINE_SUBSCRIPTION");
64 setIdName(OnlineSubscriptionPeer.ONLINE_SUBS_ID);
65 setFormIdName("onlinesubsid");
66 }
67
68 protected boolean getEntry(Criteria criteria, Context context)
69 {
70 try
71 {
72 OnlineSubscription entry = (OnlineSubscription) OnlineSubscriptionPeer.doSelect(criteria).get(0);
73 context.put("entry", entry);
74
75 Criteria ordcrit = new Criteria();
76 Criteria.Criterion a1 = ordcrit.getNewCriterion(SorderPeer.SORDER_ID, new Integer  (1000), Criteria.EQUAL);
77 Criteria.Criterion a2 = ordcrit.getNewCriterion(SorderPeer.SORDER_ID, new Integer (entry.getSorderId()), Criteria.EQUAL);
78 Criteria.Criterion a3 = ordcrit.getNewCriterion(SorderPeer.CUSTOMER_ID, new Integer (entry.getCustomerId()), Criteria.EQUAL);
79 Criteria.Criterion a4 = ordcrit.getNewCriterion(SorderPeer.STATUS, new Integer (30), Criteria.EQUAL);
80 ordcrit.add( a1.or( a2.or(a3.and(a4))));
81 ordcrit.addAscendingOrderByColumn(SorderPeer.SORDER_CODE);
82 context.put("orders", SorderPeer.doSelect(ordcrit));
83
84 return true;
85 }
86 catch (Exception e)
87 {
88 return false;
89 }
90 }
91
92 protected boolean getNew(Context context)
93 {
94 try
95 {
96 OnlineSubscription entry = new OnlineSubscription();
97 context.put("entry", entry);
98
99 Criteria ordcrit = new Criteria();
100 ordcrit.add(SorderPeer.SORDER_ID, 1000, Criteria.EQUAL);
101 context.put("orders", SorderPeer.doSelect(ordcrit));
102
103 return true;
104 }
105 catch (Exception e)
106 {
107 return false;
108 }
109 }
110
111 protected boolean getLookups(Context context)
112 {
113 try
114 {
115 Criteria prodcrit = new Criteria();
116 Criteria.Criterion a1 = prodcrit.getNewCriterion(ProductPeer.PRODUCT_ID, new Integer (1000), Criteria.EQUAL);
117 Criteria.Criterion a2 = prodcrit.getNewCriterion(ProductPeer.PRODUCT_TYPE, new Integer (30), Criteria.EQUAL);
118 prodcrit.add( a1.or( a2));
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 return true;
135 }
136 catch (Exception e)
137 {
138 return false;
139 }
140 }
141
142
143 }
144 |
Popular Tags |
Java API By Example, From Geeks To Geeks.