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.ProjectPeer; 48 import org.campware.cream.om.ProjectCategoryPeer; 49 50 54 public class ProjectList extends CreamList 55 { 56 57 protected void initScreen() 58 { 59 setModuleType(ENTITY); 60 setModuleName("PROJECT"); 61 setIdName(ProjectPeer.PROJECT_ID); 62 setDefOrderColumn(ProjectPeer.PROJECT_NAME); 63 64 } 65 66 protected String getSortColumn(int sortNo) 67 { 68 if (sortNo==1){ 69 return ProjectPeer.PROJECT_CODE; 70 } else if (sortNo==2){ 71 return ProjectPeer.PROJECT_NAME; 72 } else if (sortNo==3){ 73 return ProjectCategoryPeer.PROJECT_CAT_NAME; 74 } else if (sortNo==4){ 75 return ProjectPeer.START_DATE; 76 } else if (sortNo==5){ 77 return ProjectPeer.EXPENSES; 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(ProjectPeer.STATUS, new Integer (30), Criteria.EQUAL); 90 } else if (filterNo==1002){ 91 listCriteria.add(ProjectPeer.STATUS, new Integer (50), Criteria.EQUAL); 92 } else if (filterNo==1003){ 93 listCriteria.add(ProjectPeer.CREATED_BY, (Object ) data.getUser().getName(), Criteria.EQUAL); 94 } 95 } 96 catch (Exception e) 97 { 98 } 99 } 100 101 protected void setFind(String findStr, Criteria listCriteria) 102 { 103 try 104 { 105 listCriteria.add(ProjectPeer.PROJECT_NAME, (Object )findStr, Criteria.LIKE); 106 } 107 catch (Exception e) 108 { 109 } 110 } 111 112 protected List getEntries(Criteria criteria) 113 { 114 try 115 { 116 criteria.addJoin(ProjectCategoryPeer.PROJECT_CAT_ID, ProjectPeer.PROJECT_CAT_ID); 117 return ProjectPeer.doSelect(criteria); 118 } 119 catch (Exception e) 120 { 121 return null; 122 } 123 } 124 125 } 126 | Popular Tags |