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