|
1 package org.campware.cream.modules.screens;
2
3
42
43 import java.util.List  ;
44 import java.util.Date ;
45 import java.util.Calendar ;
46
47 import org.apache.turbine.util.RunData;
48
49 import org.apache.torque.util.Criteria;
50 import org.campware.cream.om.ServicePeer;
51 import org.campware.cream.om.CustomerPeer;
52 import org.campware.cream.om.SorderPeer;
53
54
58 public class ServiceList extends CreamList
59 {
60
61 protected void initScreen()
62 {
63 setModuleType(DOCUMENT);
64 setModuleName("SERVICE");
65 setIdName(ServicePeer.SERVICE_ID);
66 setDefOrderColumn(ServicePeer.ISSUED_DATE);
67 }
68
69 protected String getSortColumn(int sortNo)
70 {
71 if (sortNo==1){
72 return ServicePeer.SERVICE_CODE;
73 } else if (sortNo==2){
74 return CustomerPeer.CUSTOMER_DISPLAY;
75 } else if (sortNo==3){
76 return SorderPeer.SORDER_CODE;
77 } else if (sortNo==4){
78 return ServicePeer.ISSUED_DATE;
79 }
80
81 return "";
82 }
83
84 protected void setFilter(int filterNo, Criteria listCriteria, RunData data)
85 {
86 int nowDay, nowMonth, nowYear;
87
88 Calendar rightNow = Calendar.getInstance();
89 nowMonth= rightNow.get(Calendar.MONTH);
90 nowYear= rightNow.get(Calendar.YEAR);
91
92 rightNow.set(nowYear, nowMonth, 1);
93 Date fDayThisMonth= rightNow.getTime();
94 rightNow.set(nowYear, nowMonth + 1, 1);
95 Date fDayNextMonth= rightNow.getTime();
96 rightNow.set(nowYear, nowMonth - 1, 1);
97 Date fDayLastMonth= rightNow.getTime();
98 rightNow.set(nowYear, 1, 1);
99 Date fDayThisYear= rightNow.getTime();
100 rightNow.set(nowYear + 1, 1, 1);
101 Date fDayNextYear= rightNow.getTime();
102 rightNow.set(nowYear - 1, 1, 1);
103 Date fDayLastYear= rightNow.getTime();
104
105 try
106 {
107 if (filterNo==1001){
108 listCriteria.add(ServicePeer.ISSUED_DATE, new Date (), Criteria.EQUAL);
109 } else if (filterNo==1002){
110 Criteria.Criterion b1 = listCriteria.getNewCriterion(ServicePeer.ISSUED_DATE, fDayThisMonth, Criteria.GREATER_EQUAL);
111 Criteria.Criterion b2 = listCriteria.getNewCriterion(ServicePeer.ISSUED_DATE, fDayNextMonth, Criteria.LESS_THAN);
112 listCriteria.add( b1.and( b2));
113 } else if (filterNo==1003){
114 Criteria.Criterion b1 = listCriteria.getNewCriterion(ServicePeer.ISSUED_DATE, fDayLastMonth, Criteria.GREATER_EQUAL);
115 Criteria.Criterion b2 = listCriteria.getNewCriterion(ServicePeer.ISSUED_DATE, fDayThisMonth, Criteria.LESS_THAN);
116 listCriteria.add( b1.and( b2));
117 } else if (filterNo==1004){
118 Criteria.Criterion b1 = listCriteria.getNewCriterion(ServicePeer.ISSUED_DATE, fDayThisYear, Criteria.GREATER_EQUAL);
119 Criteria.Criterion b2 = listCriteria.getNewCriterion(ServicePeer.ISSUED_DATE, fDayNextYear, Criteria.LESS_THAN);
120 listCriteria.add( b1.and( b2));
121 } else if (filterNo==1005){
122 Criteria.Criterion b1 = listCriteria.getNewCriterion(ServicePeer.ISSUED_DATE, fDayLastYear, Criteria.GREATER_EQUAL);
123 Criteria.Criterion b2 = listCriteria.getNewCriterion(ServicePeer.ISSUED_DATE, fDayThisYear, Criteria.LESS_THAN);
124 listCriteria.add( b1.and( b2));
125 } else if (filterNo==1006){
126 listCriteria.add(ServicePeer.STATUS, new Integer (10), Criteria.EQUAL);
127 } else if (filterNo==1007){
128 listCriteria.add(ServicePeer.STATUS, new Integer (30), Criteria.EQUAL);
129 } else if (filterNo==1008){
130 listCriteria.add(ServicePeer.STATUS, new Integer (50), Criteria.EQUAL);
131 } else if (filterNo==1009){
132 listCriteria.add(ServicePeer.CREATED_BY, (Object ) data.getUser().getName(), Criteria.EQUAL);
133 }
134 }
135 catch (Exception e)
136 {
137 }
138 }
139
140 protected void setFind(String findStr, Criteria listCriteria)
141 {
142 try
143 {
144 listCriteria.add(ServicePeer.SERVICE_CODE, (Object )findStr, Criteria.LIKE);
145 }
146 catch (Exception e)
147 {
148 }
149 }
150
151 protected List getEntries(Criteria criteria)
152 {
153 try
154 {
155 criteria.addJoin(CustomerPeer.CUSTOMER_ID, ServicePeer.CUSTOMER_ID);
156 criteria.addJoin(SorderPeer.SORDER_ID, ServicePeer.SORDER_ID);
157 return ServicePeer.doSelect(criteria);
158 }
159 catch (Exception e)
160 {
161 return null;
162 }
163 }
164
165 }
166 |
Popular Tags |
Java API By Example, From Geeks To Geeks.