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.NewsSubscriptionPeer; 51 import org.campware.cream.om.CustomerPeer; 52 import org.campware.cream.om.ProductPeer; 53 54 58 public class NewsSubscriptionList extends CreamList 59 { 60 61 protected void initScreen() 62 { 63 setModuleType(DOCUMENT); 64 setModuleName("NEWS_SUBSCRIPTION"); 65 setIdName(NewsSubscriptionPeer.NEWS_SUBS_ID); 66 setDefOrderColumn(NewsSubscriptionPeer.ISSUED_DATE); 67 } 68 69 protected String getSortColumn(int sortNo) 70 { 71 if (sortNo==1){ 72 return NewsSubscriptionPeer.NEWS_SUBS_CODE; 73 } else if (sortNo==2){ 74 return NewsSubscriptionPeer.EMAIL; 75 } else if (sortNo==3){ 76 return ProductPeer.PRODUCT_DISPLAY; 77 } else if (sortNo==4){ 78 return NewsSubscriptionPeer.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(NewsSubscriptionPeer.ISSUED_DATE, new Date (), Criteria.EQUAL); 109 } else if (filterNo==1002){ 110 Criteria.Criterion b1 = listCriteria.getNewCriterion(NewsSubscriptionPeer.ISSUED_DATE, fDayThisMonth, Criteria.GREATER_EQUAL); 111 Criteria.Criterion b2 = listCriteria.getNewCriterion(NewsSubscriptionPeer.ISSUED_DATE, fDayNextMonth, Criteria.LESS_THAN); 112 listCriteria.add( b1.and( b2)); 113 } else if (filterNo==1003){ 114 Criteria.Criterion b1 = listCriteria.getNewCriterion(NewsSubscriptionPeer.ISSUED_DATE, fDayLastMonth, Criteria.GREATER_EQUAL); 115 Criteria.Criterion b2 = listCriteria.getNewCriterion(NewsSubscriptionPeer.ISSUED_DATE, fDayThisMonth, Criteria.LESS_THAN); 116 listCriteria.add( b1.and( b2)); 117 } else if (filterNo==1004){ 118 Criteria.Criterion b1 = listCriteria.getNewCriterion(NewsSubscriptionPeer.ISSUED_DATE, fDayThisYear, Criteria.GREATER_EQUAL); 119 Criteria.Criterion b2 = listCriteria.getNewCriterion(NewsSubscriptionPeer.ISSUED_DATE, fDayNextYear, Criteria.LESS_THAN); 120 listCriteria.add( b1.and( b2)); 121 } else if (filterNo==1005){ 122 Criteria.Criterion b1 = listCriteria.getNewCriterion(NewsSubscriptionPeer.ISSUED_DATE, fDayLastYear, Criteria.GREATER_EQUAL); 123 Criteria.Criterion b2 = listCriteria.getNewCriterion(NewsSubscriptionPeer.ISSUED_DATE, fDayThisYear, Criteria.LESS_THAN); 124 listCriteria.add( b1.and( b2)); 125 } else if (filterNo==1006){ 126 listCriteria.add(NewsSubscriptionPeer.STATUS, new Integer (10), Criteria.EQUAL); 127 } else if (filterNo==1007){ 128 listCriteria.add(NewsSubscriptionPeer.STATUS, new Integer (30), Criteria.EQUAL); 129 } else if (filterNo==1008){ 130 listCriteria.add(NewsSubscriptionPeer.STATUS, new Integer (50), Criteria.EQUAL); 131 } else if (filterNo==1009){ 132 listCriteria.add(NewsSubscriptionPeer.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(NewsSubscriptionPeer.EMAIL, (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(ProductPeer.PRODUCT_ID, NewsSubscriptionPeer.PRODUCT_ID); 156 return NewsSubscriptionPeer.doSelect(criteria); 157 } 158 catch (Exception e) 159 { 160 return null; 161 } 162 } 163 164 } 165 | Popular Tags |