BrightSide Workbench Full Report + Source Code
ContractGroupingCombobox.java
Go to the documentation of this file.
1 /*
2  * TurrĂ³ i Cutiller Foundation. License notice.
3  * Copyright (C) 2017 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 
19 package org.turro.financials.contract;
20 
21 import java.util.LinkedList;
22 import java.util.List;
23 import org.turro.string.Strings;
24 import org.turro.elephant.db.WhereClause;
25 import org.turro.financials.db.FinancialsPU;
26 import org.turro.jpa.Dao;
27 import org.turro.zkoss.input.GenericCombobox;
28 
33 public class ContractGroupingCombobox extends GenericCombobox<String> {
34 
35  @Override
36  public void populateList(String value, LinkedList list, int nRows) {
37  Dao dao = new FinancialsPU();
38  WhereClause wc = new WhereClause();
39  wc.addClause("select distinct i.grouping from Contract i");
40  wc.setPrefix("where");
41  wc.addLikeFields(new String[] { "i.grouping" }, value);
42  for(String s : (List<String>) dao.getResultList(wc)) {
43  if(!Strings.isBlank(s)) {
44  list.add(s);
45  }
46  }
47  }
48 
49  @Override
50  public String getTextFromObject(String value) {
51  return value;
52  }
53 
54 }
void addLikeFields(String[] fields, String value)
void populateList(String value, LinkedList list, int nRows)