1 package org.campware.cream.modules.screens; 2 3 42 43 import java.util.List ; 44 import org.apache.turbine.util.RunData; 45 46 import org.apache.torque.util.Criteria; 47 import org.campware.cream.om.CustomerPeer; 48 import org.campware.cream.om.CustomerCategoryPeer; 49 import org.campware.cream.om.CountryPeer; 50 51 55 public class CustomerList extends CreamList 56 { 57 58 protected void initScreen() 59 { 60 setModuleType(ENTITY); 61 setModuleName("CUSTOMER"); 62 setIdName(CustomerPeer.CUSTOMER_ID); 63 setDefOrderColumn(CustomerPeer.CUSTOMER_DISPLAY); 64 } 65 66 protected String getSortColumn(int sortNo) 67 { 68 if (sortNo==1){ 69 return CustomerPeer.CUSTOMER_CODE; 70 } else if (sortNo==2){ 71 return CustomerPeer.CUSTOMER_DISPLAY; 72 } else if (sortNo==3){ 73 return CustomerCategoryPeer.CUSTOMER_CAT_NAME; 74 } else if (sortNo==4){ 75 return CustomerPeer.CITY; 76 } else if (sortNo==5){ 77 return CountryPeer.COUNTRY_CODE; 78 } 79 80 return ""; 81 } 82 83 protected void setFilter(int filterNo, Criteria listCriteria, RunData data) 84 { 85 86 try 87 { 88 if (filterNo==1001){ 89 listCriteria.add(CustomerPeer.CUSTOMER_TYPE, new Integer (10), Criteria.EQUAL); 90 } else if (filterNo==1002){ 91 listCriteria.add(CustomerPeer.CUSTOMER_TYPE, new Integer (20), Criteria.EQUAL); 92 } else if (filterNo==1003){ 93 listCriteria.add(CustomerPeer.STATUS, new Integer (10), Criteria.EQUAL); 94 } else if (filterNo==1004){ 95 listCriteria.add(CustomerPeer.STATUS, new Integer (30), Criteria.EQUAL); 96 } else if (filterNo==1005){ 97 listCriteria.add(CustomerPeer.STATUS, new Integer (50), Criteria.EQUAL); 98 } else if (filterNo==1006){ 99 listCriteria.add(CustomerPeer.CREATED_BY, (Object ) data.getUser().getName(), Criteria.EQUAL); 100 } 101 } 102 catch (Exception e) 103 { 104 } 105 } 106 107 protected void setFind(String findStr, Criteria listCriteria) 108 { 109 try 110 { 111 listCriteria.add(CustomerPeer.CUSTOMER_DISPLAY, (Object )findStr, Criteria.LIKE); 112 } 113 catch (Exception e) 114 { 115 } 116 } 117 118 protected List getEntries(Criteria criteria) 119 { 120 try 121 { 122 criteria.addJoin(CustomerCategoryPeer.CUSTOMER_CAT_ID, CustomerPeer.CUSTOMER_CAT_ID); 123 criteria.addJoin(CountryPeer.COUNTRY_ID, CustomerPeer.COUNTRY_ID); 124 return CustomerPeer.doSelect(criteria); 125 } 126 catch (Exception e) 127 { 128 return null; 129 } 130 } 131 132 } 133 | Popular Tags |