1 package com.dotmarketing.portlets.webforms.factories; 2 3 import java.util.ArrayList ; 4 import java.util.List ; 5 import java.util.Map ; 6 7 import com.dotmarketing.db.DotConnect; 8 import com.dotmarketing.db.DotHibernate; 9 import com.dotmarketing.portlets.webforms.model.WebForm; 10 import com.dotmarketing.util.UtilMethods; 11 12 public class WebFormFactory { 13 public static List <WebForm> getWebFormsByType (String formType) { 14 String query = "select {web_form.*} from web_form where form_type = ?"; 15 DotHibernate dh = new DotHibernate (WebForm.class); 16 dh.setSQLQuery(query); 17 dh.setParam(formType); 18 List <WebForm> list = dh.list(); 19 return list; 20 } 21 22 public static List <WebForm> getWebFormsWithOutType () { 23 String query = "select {web_form.*} from web_form where form_type is null or form_type = ''"; 24 DotHibernate dh = new DotHibernate (WebForm.class); 25 dh.setSQLQuery(query); 26 List <WebForm> list = dh.list(); 27 return list; 28 } 29 30 public static void removeWebFormsByType (String formType) { 31 String query = "delete from web_form where form_type = ?"; 32 DotConnect dc = new DotConnect (); 33 dc.setSQL(query); 34 dc.addParam(formType); 35 dc.getResult(); 36 } 37 38 public static void removeWebFormsWithoutType () { 39 String query = "delete from web_form where form_type is null or form_type = ''"; 40 DotConnect dc = new DotConnect (); 41 dc.setSQL(query); 42 dc.getResult(); 43 } 44 45 public static String [] getWebFormsTypes () { 46 String query = "select distinct(form_type) as form_type from web_form"; 47 DotConnect dc = new DotConnect (); 48 dc.setSQL(query); 49 List <Map > results = dc.getResults(); 50 List <String > typesList = new ArrayList <String > (); 51 for (Map result : results) { 52 if (UtilMethods.isSet((String )result.get("form_type"))) { 53 typesList.add((String )result.get("form_type")); 54 } 55 } 56 return typesList.toArray(new String [0]); 57 } 58 } 59 | Popular Tags |