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