package com.store.action.gOm;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.DAO.ProductoutputDAO;
import com.bean.DTO.ProductoutputDTO;
import com.bean.DTO.UserinforDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;
import com.system.action.popedomCheck;

public class goSearch extends AbstractAction {

	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String path = "storeManage/gOm/GOSearch.jsp";
		UserinforDTO udt = (UserinforDTO) request.getSession().getAttribute(
				"userinfor");
		popedomCheck pc = new popedomCheck(udt);
		if (pc.storeCheck2()) {
			ProductoutputDAO pd = new ProductoutputDAO();
			String time = (String) request.getParameter("time");
			String time1 = (String) request.getParameter("time1");
			List<ProductoutputDTO> plist = null;
			Connection con;
			try {
				con = DataSourceFactory.getDataSource().getConnection();
				plist = pd.gettimeAll(time, time1, con);
				request.setAttribute("plist", plist);
				request.setAttribute("time", time);
				request.setAttribute("time1", time1);
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} else {
			path = "User/login.jsp";
		}
		return path;
	}

}