Basic Inventory Handling classes

nechromancer · nechromancer · commit 08685eb0fd93 · 2012-03-03T00:24:59.000-05:00
diff --git a/JavaSource/com/acminds/acuteauto/persistence/BaseDAO.java b/JavaSource/com/acminds/acuteauto/persistence/BaseDAO.java
@@ -8,6 +8,7 @@
 
 import javax.persistence.EntityManager;
 import javax.persistence.Query;
+import javax.persistence.TypedQuery;
 
 /**
  * @author MANSUR
@@ -16,7 +17,7 @@
 public class BaseDAO {
 	private EntityManager em = PersistenceManager.getEntityManager();
 	
-	public BaseDTO get(Class<BaseDTO> clazz, Integer id) {
+	public <T>T get(Class<T> clazz, Integer id) {
 		return em.find(clazz, id);
 	}
 	
@@ -94,12 +95,20 @@ public final void clearEntityManager()
 	 * ************************************************************************
 	 * ************************************************************************
 	 * 
-	 * Named Queries
+	 * Queries
 	 * 
 	 * ************************************************************************
 	 * ************************************************************************
 	 */
 
+	public Query createQuery(String query) {
+		return em.createQuery(query);
+	}
+	
+	public <T>TypedQuery<T> createQuery(String query, Class<T> clazz) {
+		return em.createQuery(query, clazz);
+	}
+	
 	public Query createNamedQuery(String name) {
 		return em.createNamedQuery(name);
 	}
diff --git a/JavaSource/com/acminds/acuteauto/persistence/dao/InventoryDAO.java b/JavaSource/com/acminds/acuteauto/persistence/dao/InventoryDAO.java
@@ -0,0 +1,47 @@
+/**
+ * 
+ */
+package com.acminds.acuteauto.persistence.dao;
+
+import java.util.List;
+
+import javax.persistence.TypedQuery;
+
+import com.acminds.acuteauto.persistence.BaseDAO;
+import com.acminds.acuteauto.persistence.dto.Category;
+import com.acminds.acuteauto.persistence.dto.Vehicle;
+import com.acminds.acuteauto.utils.Utils;
+
+/**
+ * @author Mansur
+ *
+ */
+public class InventoryDAO extends BaseDAO {
+	
+	public List<Vehicle> getCars(int makeId, int modelId, int styleId, int year, int mileage, int bodyType) {
+		String q = "from Vehicle v where 1=1 ";
+		if(!Utils.isEmpty(makeId)) q= q+" and v.make.id = "+makeId;
+		if(!Utils.isEmpty(modelId)) q= q+" and v.model.id = "+modelId;
+		if(!Utils.isEmpty(styleId)) q= q+" and v.style.id = "+styleId;
+		if(!Utils.isEmpty(year)) q= q+" and v.year = "+year;
+		if(!Utils.isEmpty(bodyType)) q= q+" and v.style.vehicleType= "+bodyType;
+		if(!Utils.isEmpty(mileage)) q= q+" and v.mileage <= "+mileage;		
+		TypedQuery<Vehicle> tq = createQuery(q, Vehicle.class);
+		return tq.getResultList();		
+	}
+	
+	public List<Vehicle> getCarsByCategory(int categoryId, String categoryName) {
+		Category c = null;
+		if(categoryId>0) {
+			c = get(Category.class, categoryId);			
+		} else if (!Utils.isEmpty(categoryName)) {
+			String q = "from Category c where c.name="+categoryName;
+			TypedQuery<Category> tq = createQuery(q, Category.class);
+			c = tq.getSingleResult();
+		}
+		if(!Utils.isEmpty(c))
+			return c.getVehicles();
+		return null;		
+	}
+
+}
diff --git a/JavaSource/com/acminds/acuteauto/service/InventoryService.java b/JavaSource/com/acminds/acuteauto/service/InventoryService.java
@@ -0,0 +1,21 @@
+/**
+ * 
+ */
+package com.acminds.acuteauto.service;
+
+import java.util.List;
+
+import com.acminds.acuteauto.persistence.dto.Vehicle;
+
+
+/**
+ * @author Mansur
+ *
+ */
+public class InventoryService {
+	
+	public List<Vehicle> getCars(String makeId, String modelId, String mileage, String bodyType, boolean smartSearch) {
+		return null;
+	}
+
+}
diff --git a/JavaSource/com/acminds/acuteauto/ui/BaseController.java b/JavaSource/com/acminds/acuteauto/ui/BaseController.java
@@ -0,0 +1,12 @@
+/**
+ * 
+ */
+package com.acminds.acuteauto.ui;
+
+/**
+ * @author Mansur
+ *
+ */
+public class BaseController {
+
+}
diff --git a/JavaSource/com/acminds/acuteauto/ui/controller/HomePageController.java b/JavaSource/com/acminds/acuteauto/ui/controller/HomePageController.java
@@ -0,0 +1,31 @@
+/**
+ * 
+ */
+package com.acminds.acuteauto.ui.controller;
+
+import javax.faces.bean.ManagedBean;
+import javax.faces.bean.RequestScoped;
+
+import com.acminds.acuteauto.ui.BaseController;
+import com.acminds.acuteauto.ui.form.CarSearchForm;
+
+/**
+ * @author Mansur
+ *
+ */
+@ManagedBean(name="hmpCtrl")
+@RequestScoped
+public class HomePageController extends BaseController{
+	
+	private CarSearchForm csForm = new CarSearchForm();
+	public CarSearchForm getCsForm() {
+		return csForm;
+	}
+	public void setCsForm(CarSearchForm csForm) {
+		this.csForm = csForm;
+	}
+	
+	public String searchCars() {
+		return null;
+	}
+}
diff --git a/JavaSource/com/acminds/acuteauto/ui/form/CarSearchForm.java b/JavaSource/com/acminds/acuteauto/ui/form/CarSearchForm.java
@@ -0,0 +1,41 @@
+/**
+ * 
+ */
+package com.acminds.acuteauto.ui.form;
+
+/**
+ * @author Mansur
+ *
+ */
+public class CarSearchForm {
+	
+	private String makeId;
+	private String modelId;
+	private String year;
+	private String mileage;
+	public String getMakeId() {
+		return makeId;
+	}
+	public void setMakeId(String makeId) {
+		this.makeId = makeId;
+	}
+	public String getModelId() {
+		return modelId;
+	}
+	public void setModelId(String modelId) {
+		this.modelId = modelId;
+	}
+	public String getYear() {
+		return year;
+	}
+	public void setYear(String year) {
+		this.year = year;
+	}
+	public String getMileage() {
+		return mileage;
+	}
+	public void setMileage(String mileage) {
+		this.mileage = mileage;
+	}
+
+}
diff --git a/JavaSource/sql/db-schema.sql b/JavaSource/sql/db-schema.sql
@@ -62,6 +62,8 @@ NAME VARCHAR(60) NOT NULL,
 DESCRIPTION VARCHAR(100),
 CATEGORY_TYPE INT(3), -- FUTURE USE.
 PARENT_ID INT,
+EFFECTIVE_DATE DATE NOT NULL,
+EXPIRY_DATE DATE,
 CREATE_DATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 CREATED_BY INT NOT NULL
 );
