BrightSide Workbench Full Report + Source Code
CampaignFilter.java
Go to the documentation of this file.
1 /*
2  * TurrĂ³ i Cutiller Foundation. License notice.
3  * Copyright (C) 2013 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.crm.zul.sale;
20 
21 import java.util.Collection;
22 import java.util.List;
23 import org.turro.crm.db.CrmPU;
24 import org.turro.crm.entity.Campaign;
25 import org.turro.elephant.db.WhereClause;
26 import org.turro.jpa.Dao;
27 import org.turro.plugin.filter.IFilterValue;
28 
33 public class CampaignFilter {
34 
35  public CampaignFilter() {
36  }
37 
38  public Collection<Campaign> getCampaigns(List<IFilterValue> values) {
39  Dao dao = new CrmPU();
40  WhereClause wc = createCriteria(values);
41  return dao.getResultList(wc);
42  }
43 
44  private WhereClause createCriteria(List<IFilterValue> values) {
45  WhereClause wc = new WhereClause();
46  wc.addClause("select campaign from Campaign as campaign");
47  wc.addClause("where 1=1");
48  for(IFilterValue v : values) {
49  v.addConstraint(wc);
50  }
51  wc.addClause("order by campaign.campaignDate");
52  return wc;
53  }
54 
55 }
Collection< Campaign > getCampaigns(List< IFilterValue > values)