KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > campware > cream > modules > screens > Home


1 package org.campware.cream.modules.screens;
2
3 /* ====================================================================
4  * Copyright (C) 2003-2005 Media Development Loan Fund
5  *
6  * * contact: contact@campware.org - http://www.campware.org
7  * Campware encourages further development. Please let us know.
8  *
9  * This program is free software; you can redistribute it and/or
10  * modify it under the terms of the GNU General Public License
11  * as published by the Free Software Foundation; either version 2
12  * of the License, or (at your option) any later version.
13  *
14  * This program is distributed in the hope that it will be useful,
15  * but WITHOUT ANY WARRANTY; without even the implied warranty of
16  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17  * GNU General Public License for more details.
18  *
19  * You should have received a copy of the GNU General Public License
20  * along with this program; if not, write to the Free Software
21  * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
22  *
23  * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
24  * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
25  * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
26  * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
27  * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
28  * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
29  * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
30  * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
31  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
32  * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
33  * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
34  * SUCH DAMAGE.
35  * ====================================================================
36  *
37  * This software consists of voluntary contributions made by many
38  * individuals on behalf of the Apache Software Foundation. For more
39  * information on the Apache Software Foundation, please see
40  * <http://www.apache.org/>.
41  */
42
43 import java.math.BigDecimal JavaDoc;
44 import java.text.DecimalFormat JavaDoc;
45 import java.text.DecimalFormatSymbols JavaDoc;
46 import java.text.SimpleDateFormat JavaDoc;
47 import java.util.ArrayList JavaDoc;
48 import java.util.Date JavaDoc;
49 import java.util.List JavaDoc;
50
51 import org.apache.turbine.util.RunData;
52 import org.apache.torque.util.BasePeer;
53 import org.apache.torque.util.Criteria;
54 import org.apache.velocity.context.Context;
55 import org.campware.cream.om.CustomerPeer;
56 import org.campware.cream.om.ProductPeer;
57 import org.campware.cream.om.ProjectPeer;
58 import org.campware.cream.om.InboxEventPeer;
59 import org.campware.cream.om.OutboxEventPeer;
60 import org.campware.cream.om.NewsSubscriptionPeer;
61 import org.campware.cream.om.NewsletterPeer;
62 import org.campware.cream.om.SorderPeer;
63 import org.campware.cream.om.PaymentPeer;
64 import org.campware.cream.om.ShipmentPeer;
65 import org.campware.cream.om.ServicePeer;
66 import org.campware.cream.om.OnlineSubscriptionPeer;
67 import org.campware.cream.om.PrintSubscriptionPeer;
68
69 import com.workingdogs.village.Record;
70
71 /**
72  * To read comments for this class, please see
73  * the ancestor class
74  */
75 public class Home extends SecureScreen
76 {
77
78     public void doBuildTemplate(RunData data, Context context)
79     {
80         try
81         {
82
83             // customer count
84 Criteria criteria = new Criteria();
85             criteria.addSelectColumn("COUNT(" + CustomerPeer.CUSTOMER_ID + ")");
86             criteria.add(CustomerPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
87   
88             List JavaDoc countrecord = BasePeer.doSelect(criteria);
89             String JavaDoc recordno= ((Record) countrecord.get(0)).getValue(1).asString();
90             context.put ("customerno", recordno);
91
92             // product count
93 criteria = new Criteria();
94             criteria.addSelectColumn("COUNT(" + ProductPeer.PRODUCT_ID + ")");
95             criteria.add(ProductPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
96     
97             countrecord = BasePeer.doSelect(criteria);
98             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
99             context.put ("productno", recordno);
100
101             // project count
102 criteria = new Criteria();
103             criteria.addSelectColumn("COUNT(" + ProjectPeer.PROJECT_ID + ")");
104             criteria.add(ProjectPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
105     
106             countrecord = BasePeer.doSelect(criteria);
107             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
108             context.put ("projectno", recordno);
109
110             // inbox count
111 criteria = new Criteria();
112             criteria.addSelectColumn("COUNT(" + InboxEventPeer.INBOX_EVENT_ID + ")");
113             criteria.add(InboxEventPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
114     
115             countrecord = BasePeer.doSelect(criteria);
116             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
117             context.put ("inboxno", recordno);
118
119             // outbox count
120 criteria = new Criteria();
121             criteria.addSelectColumn("COUNT(" + OutboxEventPeer.OUTBOX_EVENT_ID + ")");
122             criteria.add(OutboxEventPeer.STATUS, new Integer JavaDoc(10), Criteria.EQUAL);
123     
124             countrecord = BasePeer.doSelect(criteria);
125             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
126             context.put ("outboxno", recordno);
127
128             // news subscription count
129 criteria = new Criteria();
130             criteria.addSelectColumn("COUNT(" + NewsSubscriptionPeer.NEWS_SUBS_ID + ")");
131             criteria.add(NewsSubscriptionPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
132     
133             countrecord = BasePeer.doSelect(criteria);
134             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
135             context.put ("newssubsno", recordno);
136
137             // newsletter count
138 criteria = new Criteria();
139             criteria.addSelectColumn("COUNT(" + NewsletterPeer.NEWSLETTER_ID + ")");
140             criteria.add(NewsletterPeer.STATUS, new Integer JavaDoc(10), Criteria.EQUAL);
141     
142             countrecord = BasePeer.doSelect(criteria);
143             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
144             context.put ("newsletterno", recordno);
145
146             // sales order count
147 criteria = new Criteria();
148             criteria.addSelectColumn("COUNT(" + SorderPeer.SORDER_ID + ")");
149             criteria.add(SorderPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
150     
151             countrecord = BasePeer.doSelect(criteria);
152             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
153             context.put ("sorderno", recordno);
154
155             // payment count
156 criteria = new Criteria();
157             criteria.addSelectColumn("COUNT(" + PaymentPeer.PAYMENT_ID + ")");
158             criteria.add(PaymentPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
159     
160             countrecord = BasePeer.doSelect(criteria);
161             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
162             context.put ("paymentno", recordno);
163
164             // shipment count
165 criteria = new Criteria();
166             criteria.addSelectColumn("COUNT(" + ShipmentPeer.SHIPMENT_ID + ")");
167             criteria.add(ShipmentPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
168     
169             countrecord = BasePeer.doSelect(criteria);
170             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
171             context.put ("shipmentno", recordno);
172
173             // service count
174 criteria = new Criteria();
175             criteria.addSelectColumn("COUNT(" + ServicePeer.SERVICE_ID + ")");
176             criteria.add(ServicePeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
177     
178             countrecord = BasePeer.doSelect(criteria);
179             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
180             context.put ("serviceno", recordno);
181
182             // print subscription count
183 criteria = new Criteria();
184             criteria.addSelectColumn("COUNT(" + PrintSubscriptionPeer.PRINT_SUBS_ID + ")");
185             criteria.add(PrintSubscriptionPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
186     
187             countrecord = BasePeer.doSelect(criteria);
188             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
189             context.put ("printsubsno", recordno);
190
191             // online subscription count
192 criteria = new Criteria();
193             criteria.addSelectColumn("COUNT(" + OnlineSubscriptionPeer.ONLINE_SUBS_ID + ")");
194             criteria.add(OnlineSubscriptionPeer.STATUS, new Integer JavaDoc(30), Criteria.EQUAL);
195     
196             countrecord = BasePeer.doSelect(criteria);
197             recordno= ((Record) countrecord.get(0)).getValue(1).asString();
198             context.put ("onlinesubsno", recordno);
199         }
200         catch (Exception JavaDoc e)
201         {
202
203         }
204
205     }
206
207
208 }
209
Popular Tags