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