BrightSide Workbench Full Report + Source Code
AptitudeCombobox.java
Go to the documentation of this file.
1 /*
2  * TurrĂ³ i Cutiller Foundation. License notice.
3  * Copyright (C) 2011 Lluis TurrĂ³ Cutiller <http://www.turro.org/>
4  *
5  * This program is free software: you can redistribute it and/or modify
6  * it under the terms of the GNU Affero General Public License as published by
7  * the Free Software Foundation, either version 3 of the License, or
8  * (at your option) any later version.
9  *
10  * This program is distributed in the hope that it will be useful,
11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13  * GNU Affero General Public License for more details.
14  *
15  * You should have received a copy of the GNU Affero General Public License
16  * along with this program. If not, see <http://www.gnu.org/licenses/>.
17  */
18 package org.turro.erp.aptitude;
19 
20 import java.util.LinkedList;
21 import java.util.List;
22 import javax.persistence.EntityManager;
23 import javax.persistence.Query;
24 import org.turro.elephant.db.SQLHelper;
25 import org.turro.elephant.db.WhereClause;
26 import org.turro.erp.db.ErpPU;
27 import org.turro.erp.entity.Aptitude;
28 import org.turro.zkoss.input.GenericCombobox;
29 
34 public class AptitudeCombobox extends GenericCombobox<Aptitude> {
35 
36  @Override
37  public void populateList(String value, LinkedList list, int nRows) {
38  EntityManager em = new ErpPU().getEntityManager();
39  try {
40  WhereClause wc = SQLHelper.getWhereClause(new String[]{
41  "apt.name"
42  }, value);
43  Query q = em.createQuery(
44  "select apt from Aptitude apt " +
45  "where 1=1 " +
46  wc.getClause() +
47  " order by apt.name"
48  );
49  q.setMaxResults(nRows);
50  wc.setNamedParameters(q);
51  List<Aptitude> l = q.getResultList();
52  for(Object o : l) {
53  list.add(((Aptitude) o).getName());
54  }
55  } finally {
56  em.close();
57  }
58  }
59 
60  @Override
61  public String getTextFromObject(Aptitude value) {
62  return value.getName();
63  }
64 
65 }
static WhereClause getWhereClause(String[] fields, String value)
Definition: SQLHelper.java:64
void populateList(String value, LinkedList list, int nRows)
EntityManager getEntityManager()
Definition: Dao.java:202