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.ProductPeer; 48 import org.campware.cream.om.ProductCategoryPeer; 49 import org.campware.cream.om.UomPeer; 50 51 55 public class ProductList extends CreamList 56 { 57 58 protected void initScreen() 59 { 60 setModuleType(ENTITY); 61 setModuleName("PRODUCT"); 62 setIdName(ProductPeer.PRODUCT_ID); 63 setDefOrderColumn(ProductPeer.PRODUCT_DISPLAY); 64 } 65 66 protected String getSortColumn(int sortNo) 67 { 68 if (sortNo==1){ 69 return ProductPeer.PRODUCT_CODE; 70 } else if (sortNo==2){ 71 return ProductPeer.PRODUCT_DISPLAY; 72 } else if (sortNo==3){ 73 return ProductCategoryPeer.PRODUCT_CAT_NAME; 74 } else if (sortNo==4){ 75 return UomPeer.UOM_CODE; 76 } else if (sortNo==5){ 77 return ProductPeer.BASE_PRICE; 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(ProductPeer.PRODUCT_TYPE, new Integer (10), Criteria.EQUAL); 90 } else if (filterNo==1002){ 91 listCriteria.add(ProductPeer.PRODUCT_TYPE, new Integer (20), Criteria.EQUAL); 92 } else if (filterNo==1003){ 93 listCriteria.add(ProductPeer.PRODUCT_TYPE, new Integer (30), Criteria.EQUAL); 94 } else if (filterNo==1004){ 95 listCriteria.add(ProductPeer.PRODUCT_TYPE, new Integer (40), Criteria.EQUAL); 96 } else if (filterNo==1005){ 97 listCriteria.add(ProductPeer.STATUS, new Integer (30), Criteria.EQUAL); 98 } else if (filterNo==1006){ 99 listCriteria.add(ProductPeer.STATUS, new Integer (50), Criteria.EQUAL); 100 } else if (filterNo==1007){ 101 listCriteria.add(ProductPeer.CREATED_BY, (Object ) data.getUser().getName(), Criteria.EQUAL); 102 } 103 } 104 catch (Exception e) 105 { 106 } 107 } 108 109 protected void setFind(String findStr, Criteria listCriteria) 110 { 111 try 112 { 113 listCriteria.add(ProductPeer.PRODUCT_DISPLAY, (Object )findStr, Criteria.LIKE); 114 } 115 catch (Exception e) 116 { 117 } 118 } 119 120 protected List getEntries(Criteria criteria) 121 { 122 try 123 { 124 criteria.addJoin(ProductCategoryPeer.PRODUCT_CAT_ID, ProductPeer.PRODUCT_CAT_ID); 125 criteria.addJoin(UomPeer.UOM_ID, ProductPeer.UOM_ID); 126 return ProductPeer.doSelect(criteria); 127 } 128 catch (Exception e) 129 { 130 return null; 131 } 132 } 133 134 } 135 | Popular Tags |