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