1 package com.dotmarketing.portlets.jobs.factories; 2 import java.util.Calendar ; 3 import java.util.GregorianCalendar ; 4 import java.util.List ; 5 6 import com.dotmarketing.db.DotHibernate; 7 import com.dotmarketing.portlets.jobs.model.Jobs; 8 import com.dotmarketing.util.Config; 9 17 public class JobsFactory { 18 19 public static Jobs getJob(String id) { 20 DotHibernate dh = new DotHibernate(Jobs.class); 21 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs where jobs.inode = ?"); 22 dh.setParam(id); 23 return (Jobs)dh.load(); 24 } 25 26 public static List getJobs() { 27 DotHibernate dh = new DotHibernate(Jobs.class); 28 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs order by jobs.entrydate desc"); 29 return dh.list(); 30 } 31 32 public static List getJobs(String orderby) { 33 DotHibernate dh = new DotHibernate(Jobs.class); 34 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs order by " + orderby); 35 return dh.list(); 36 } 37 public static List getJobsRollByMonth(String orderby,int numberOfMonths) { 38 DotHibernate dh = new DotHibernate(Jobs.class); 39 GregorianCalendar calendar = new GregorianCalendar (); 40 calendar.add(Calendar.MONTH,numberOfMonths); 41 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs where jobs.entrydate >= ? order by " + orderby); 42 dh.setParam(calendar.getTime()); 43 return dh.list(); 44 } 45 public static Jobs save(Jobs x) { 46 DotHibernate.saveOrUpdate(x); 47 return x; 48 } 49 50 public static List getJobsByLocation(String location, int limit, int offset) { 51 String locationString = "%" + location + "%"; 52 DotHibernate dh = new DotHibernate(Jobs.class); 53 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs where jobs.active = " + com.dotmarketing.db.DbConnectionFactory.getDBTrue() + " and expdate >= ? and (jobs.joblocation like ? or jobs.city like ?) order by jobs.entrydate desc"); 54 dh.setParam(new java.util.Date ()); 55 dh.setParam(locationString); 56 dh.setParam(locationString); 57 58 if (limit!=0) { 59 dh.setFirstResult(offset); 60 dh.setMaxResults(limit); 61 } 62 63 return dh.list(); 64 } 65 66 public static List getJobsBySearchAndLocation(String s, String location, int limit, int offset) { 67 String superString = "%" + s + "%"; 68 String locationString = "%" + location + "%"; 69 DotHibernate dh = new DotHibernate(Jobs.class); 70 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs where jobs.active = " + com.dotmarketing.db.DbConnectionFactory.getDBTrue() + " and expdate >= ? and (jobs.organization like ? or jobs.description like ? or jobs.jobtitle like ? ) and (jobs.city like ? or jobs.joblocation like ?) order by jobs.entrydate desc"); 71 dh.setParam(new java.util.Date ()); 72 dh.setParam(superString); 73 dh.setParam(superString); 74 dh.setParam(superString); 75 dh.setParam(locationString); 76 dh.setParam(locationString); 77 78 if (limit!=0) { 79 dh.setFirstResult(offset); 80 dh.setMaxResults(limit); 81 } 82 return dh.list(); 83 } 84 85 public static List getJobsBySearch(String s, int limit, int offset) { 86 String superString = "%" + s + "%"; 87 DotHibernate dh = new DotHibernate(Jobs.class); 88 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs where jobs.active = " + com.dotmarketing.db.DbConnectionFactory.getDBTrue() + " and expdate >= ? and (jobs.organization like ? or jobs.description like ? or jobs.jobtitle like ?) order by jobs.entrydate desc"); 89 dh.setParam(new java.util.Date ()); 90 dh.setParam(superString); 91 dh.setParam(superString); 92 dh.setParam(superString); 93 94 if (limit!=0) { 95 dh.setFirstResult(offset); 96 dh.setMaxResults(limit); 97 } 98 return dh.list(); 99 } 100 101 public static List getActiveJobs(int limit, int offset) { 102 DotHibernate dh = new DotHibernate(Jobs.class); 103 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs where jobs.active = " + com.dotmarketing.db.DbConnectionFactory.getDBTrue() + " and expdate >= ? order by jobs.entrydate desc"); 104 dh.setParam(new java.util.Date ()); 105 106 if (limit!=0) { 107 dh.setFirstResult(offset); 108 dh.setMaxResults(limit); 109 } 110 return dh.list(); 111 } 112 public static List getPremiumJobs() { 113 DotHibernate dh = new DotHibernate(Jobs.class); 114 dh.setQuery("from jobs in class com.dotmarketing.portlets.jobs.model.Jobs where jobs.active = " + com.dotmarketing.db.DbConnectionFactory.getDBTrue() + " and jobs.premiumlisting = " + com.dotmarketing.db.DbConnectionFactory.getDBTrue() + " order by jobs.entrydate desc"); 115 return dh.list(); 116 } 117 118 } 119 | Popular Tags |