KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > dotmarketing > portlets > jobs > factories > JobsFactory


1 package com.dotmarketing.portlets.jobs.factories;
2 import java.util.Calendar JavaDoc;
3 import java.util.GregorianCalendar JavaDoc;
4 import java.util.List JavaDoc;
5
6 import com.dotmarketing.db.DotHibernate;
7 import com.dotmarketing.portlets.jobs.model.Jobs;
8 import com.dotmarketing.util.Config;
9 /**
10  * @author Steven Sajous
11  *
12  * To change this generated comment edit the template variable "typecomment":
13  * Window>Preferences>Java>Templates.
14  * To enable and disable the creation of type comments go to
15  * Window>Preferences>Java>Code Generation.
16  */

17 public class JobsFactory {
18     
19     public static Jobs getJob(String JavaDoc 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 JavaDoc 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 JavaDoc getJobs(String JavaDoc 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 JavaDoc getJobsRollByMonth(String JavaDoc orderby,int numberOfMonths) {
38         DotHibernate dh = new DotHibernate(Jobs.class);
39         GregorianCalendar JavaDoc calendar = new GregorianCalendar JavaDoc();
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 JavaDoc getJobsByLocation(String JavaDoc location, int limit, int offset) {
51         String JavaDoc 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 JavaDoc());
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 JavaDoc getJobsBySearchAndLocation(String JavaDoc s, String JavaDoc location, int limit, int offset) {
67         String JavaDoc superString = "%" + s + "%";
68         String JavaDoc 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 JavaDoc());
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 JavaDoc getJobsBySearch(String JavaDoc s, int limit, int offset) {
86         String JavaDoc 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 JavaDoc());
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 JavaDoc 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 JavaDoc());
105
106         if (limit!=0) {
107             dh.setFirstResult(offset);
108             dh.setMaxResults(limit);
109         }
110         return dh.list();
111     }
112     public static List JavaDoc 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