|
1 package org.campware.cream.modules.screens;
2
3
42
43 import java.util.Date  ;
44 import java.text.SimpleDateFormat ;
45 import java.text.DecimalFormat ;
46 import java.text.DecimalFormatSymbols ;
47
48 import org.apache.turbine.util.RunData;
49
50 import org.apache.torque.util.Criteria;
51
52 import org.apache.velocity.context.Context;
53
54 import org.campware.cream.om.CustomerPeer;
55 import org.campware.cream.om.ProductPeer;
56 import org.campware.cream.om.ProjectPeer;
57 import org.campware.cream.om.CustomerCategoryPeer;
58 import org.campware.cream.om.ProjectCategoryPeer;
59 import org.campware.cream.om.ProductCategoryPeer;
60 import org.campware.cream.om.CountryPeer;
61 import org.campware.cream.om.RegionPeer;
62 import org.campware.cream.om.LanguagePeer;
63 import org.campware.cream.om.HouseholdCategoryPeer;
64 import org.campware.cream.om.EducationCategoryPeer;
65 import org.campware.cream.om.VendorPeer;
66 import org.campware.cream.om.UomPeer;
67
68
72 public class ReportForm extends SecureScreen
73 {
74
75 public void doBuildTemplate(RunData data, Context context)
76 {
77 try
78 {
79
80 context.put("df", new SimpleDateFormat ("dd.MM.yyyy"));
81 context.put("dtf", new SimpleDateFormat ("dd.MM.yyyy hh:mm:ss"));
82
83 DecimalFormatSymbols symb= new DecimalFormatSymbols ();
84 symb.setDecimalSeparator('.');
85
86 context.put("af", new DecimalFormat ("0.00", symb));
87 context.put("rf", new DecimalFormat ("0.000000", symb));
88 context.put("today", new Date ());
89
90 Criteria prodcrit = new Criteria();
91 prodcrit.add(ProductPeer.PRODUCT_ID, 999, Criteria.GREATER_THAN);
92 prodcrit.addAscendingOrderByColumn(ProductPeer.PRODUCT_DISPLAY);
93 context.put("products", ProductPeer.doSelect(prodcrit));
94
95 Criteria projcrit = new Criteria();
96 projcrit.add(ProjectPeer.PROJECT_ID, 999, Criteria.GREATER_THAN);
97 projcrit.addAscendingOrderByColumn(ProjectPeer.PROJECT_NAME);
98 context.put("projects", ProjectPeer.doSelect(projcrit));
99
100 Criteria custcrit = new Criteria();
101 Criteria.Criterion b1 = custcrit.getNewCriterion(CustomerPeer.CUSTOMER_ID, new Integer (1000), Criteria.EQUAL);
102 Criteria.Criterion b2 = custcrit.getNewCriterion(CustomerPeer.STATUS, new Integer (29), Criteria.GREATER_THAN);
103 custcrit.add( b1.or( b2));
104 custcrit.addAscendingOrderByColumn(CustomerPeer.CUSTOMER_DISPLAY);
105 context.put("customers", CustomerPeer.doSelect(custcrit));
106
107 Criteria custcatcrit = new Criteria();
108 custcatcrit.add(CustomerCategoryPeer.CUSTOMER_CAT_ID, 999, Criteria.GREATER_THAN);
109 custcatcrit.addAscendingOrderByColumn(CustomerCategoryPeer.CUSTOMER_CAT_NAME);
110 context.put("customercats", CustomerCategoryPeer.doSelect(custcatcrit));
111
112 Criteria countrycrit = new Criteria();
113 countrycrit.add(CountryPeer.COUNTRY_ID, 999, Criteria.GREATER_THAN);
114 countrycrit.addAscendingOrderByColumn(CountryPeer.COUNTRY_NAME);
115 context.put("countries", CountryPeer.doSelect(countrycrit));
116
117 Criteria regioncrit = new Criteria();
118 regioncrit.add(RegionPeer.REGION_ID, 999, Criteria.GREATER_THAN);
119 regioncrit.addAscendingOrderByColumn(RegionPeer.REGION_NAME);
120 context.put("regions", RegionPeer.doSelect(regioncrit));
121
122 Criteria langcrit = new Criteria();
123 langcrit.add(LanguagePeer.LANGUAGE_ID, 999, Criteria.GREATER_THAN);
124 langcrit.addAscendingOrderByColumn(LanguagePeer.LANGUAGE_NAME);
125 context.put("languages", LanguagePeer.doSelect(langcrit));
126
127 Criteria housecatcrit = new Criteria();
128 housecatcrit.add(HouseholdCategoryPeer.HOUSEHOLD_CAT_ID, 999, Criteria.GREATER_THAN);
129 housecatcrit.addAscendingOrderByColumn(HouseholdCategoryPeer.HOUSEHOLD_CAT_NAME);
130 context.put("householdcats", HouseholdCategoryPeer.doSelect(housecatcrit));
131
132 Criteria educationcrit = new Criteria();
133 educationcrit.add(EducationCategoryPeer.EDUCATION_CAT_ID, 999, Criteria.GREATER_THAN);
134 educationcrit.addAscendingOrderByColumn(EducationCategoryPeer.EDUCATION_CAT_NAME);
135 context.put("educationcats", EducationCategoryPeer.doSelect(educationcrit));
136
137 Criteria vendorcrit = new Criteria();
138 vendorcrit.add(VendorPeer.VENDOR_ID, 999, Criteria.GREATER_THAN);
139 vendorcrit.addAscendingOrderByColumn(VendorPeer.VENDOR_NAME);
140 context.put("vendors", VendorPeer.doSelect(vendorcrit));
141
142 Criteria uomcrit = new Criteria();
143 uomcrit.add(UomPeer.UOM_ID, 900, Criteria.LESS_THAN);
144 Criteria.Criterion criterion = uomcrit.getCriterion(UomPeer.UOM_ID);
145 criterion.or(
146 uomcrit.getNewCriterion(
147 criterion.getTable(),
148 criterion.getColumn(),
149 new Integer (999),
150 Criteria.GREATER_THAN )
151 );
152 uomcrit.addAscendingOrderByColumn(UomPeer.UOM_NAME);
153 context.put("uoms", UomPeer.doSelect(uomcrit));
154
155 Criteria prodcatcrit = new Criteria();
156 prodcatcrit.add(ProductCategoryPeer.PRODUCT_CAT_ID, 999, Criteria.GREATER_THAN);
157 prodcatcrit.addAscendingOrderByColumn(ProductCategoryPeer.PRODUCT_CAT_NAME);
158 context.put("productcats", ProductCategoryPeer.doSelect(prodcatcrit));
159
160 Criteria projcatcrit = new Criteria();
161 projcatcrit.add(ProjectCategoryPeer.PROJECT_CAT_ID, 999, Criteria.GREATER_THAN);
162 projcatcrit.addAscendingOrderByColumn(ProjectCategoryPeer.PROJECT_CAT_NAME);
163 context.put("projectcats", ProjectCategoryPeer.doSelect(projcatcrit));
164 }
165 catch (Exception e)
166 {
167 }
169 }
170
171
172 protected String formatDateTime(Date d)
173 {
174 SimpleDateFormat formatter = new SimpleDateFormat ("dd.MM.yyyy hh:mm:ss");
175 return formatter.format(d);
176 }
177
178 protected String formatDate(Date d)
179 {
180 SimpleDateFormat formatter = new SimpleDateFormat ("dd.MM.yyyy");
181 return formatter.format(d);
182 }
183
184 }
185 |
Popular Tags |
Java API By Example, From Geeks To Geeks.