/*
 * Created on 21.12.2003
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package cz.triangle.dostal.knihajizd.action;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Calendar;
import java.util.Locale;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;

import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import cz.triangle.dostal.knihajizd.SeznamJizd;
import cz.triangle.dostal.knihajizd.form.KnihaJizdForm;

/**
 * @author xrusr01
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class SeznamJizdAction extends DispatchAction {

	public SeznamJizdAction() {
	}

	public ActionForward unspecified(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
		Connection con = null;
		HttpSession session = request.getSession();
		
		ActionErrors errors = new ActionErrors();
		SeznamJizd jizdy = new SeznamJizd();
		KnihaJizdForm kjf = (KnihaJizdForm) session.getAttribute("knihaJizdForm");
		
		try {
			Context initContext = new InitialContext();
			Context envContext  = (Context)initContext.lookup("java:/comp/env");
			DataSource ds = (DataSource)envContext.lookup("jdbc/dostal");
			con = ds.getConnection();

			Calendar cal = Calendar.getInstance(new Locale("cs", "CZ"));
			Timestamp nyni = new Timestamp(cal.getTimeInMillis());
			Integer misto_odvozu = null;
			
			if (kjf != null) {
				try {
					misto_odvozu = new Integer(kjf.getMisto_odvozu());
				} catch (Exception e) {
					misto_odvozu = null;
				}
				/*
				if (kjf.getId() > 0) {
					kjf = null;
					session.setAttribute("knihaJizdForm", kjf);
				}
				*/
			} else {
				kjf = new KnihaJizdForm();
			}
			if (Integer.valueOf(kjf.getMisto_odvozu()).intValue()== 0) {
				boolean isLitovel = request.isUserInRole("admin_dostal_litovel");
				boolean isUnicov = request.isUserInRole("admin_dostal_unicov");
				if (isLitovel && !isUnicov) {
					misto_odvozu = new Integer("1");
				} else if (!isLitovel && isUnicov) {
					misto_odvozu = new Integer("2");
				} else {
					misto_odvozu = new Integer("-1");
				}
			}

			kjf.setMisto_odvozu(String.valueOf(misto_odvozu));
			if (misto_odvozu.intValue() <= 0) {
				misto_odvozu = null;
			}

			try {
				jizdy.nactiBudouci(con, nyni, misto_odvozu);
			} catch (SQLException e) {
				errors.add(ActionErrors.GLOBAL_ERROR, new ActionError("error.seznamJizd.cteni", e.getMessage()));
			}
			request.setAttribute("jizdy", jizdy);
			session.setAttribute("akceJizdy", "budouci");
			session.setAttribute("knihaJizdForm", kjf);
			con.close();
			con = null;
		} finally {
			if (!errors.isEmpty()) {
				saveErrors(request, errors);
			}
			if (con != null) {
				try {
					con.close();
					con = null;
				} catch (SQLException e) {
				}
			}
		}
		
		return mapping.findForward("seznamJizd");
	}

	public ActionForward minule(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
		Connection con = null;
		HttpSession session = request.getSession();
		
		ActionErrors errors = new ActionErrors();
		SeznamJizd jizdy = new SeznamJizd();
		KnihaJizdForm kjf = (KnihaJizdForm) session.getAttribute("knihaJizdForm");
		
		try {
			Context initContext = new InitialContext();
			Context envContext  = (Context)initContext.lookup("java:/comp/env");
			DataSource ds = (DataSource)envContext.lookup("jdbc/dostal");
			con = ds.getConnection();

			Calendar cal = Calendar.getInstance(new Locale("cs", "CZ"));
			Timestamp nyni = new Timestamp(cal.getTimeInMillis());
			Integer misto_odvozu = null;
			
			if (kjf != null) {
				try {
					misto_odvozu = new Integer(kjf.getMisto_odvozu());
				} catch (Exception e) {
					misto_odvozu = null;
				}
				/*
				if (kjf.getId() > 0) {
					kjf = null;
					session.setAttribute("knihaJizdForm", kjf);
				}
				*/
			} else {
				kjf = new KnihaJizdForm();
				misto_odvozu = new Integer("1");
			}
			kjf.setMisto_odvozu(String.valueOf(misto_odvozu));
			if (misto_odvozu.intValue() <= 0) {
				misto_odvozu = null;
			}

			try {
				jizdy.nactiMinule(con, nyni, misto_odvozu);
			} catch (SQLException e) {
				errors.add(ActionErrors.GLOBAL_ERROR, new ActionError("error.seznamJizd.cteni", e.getMessage()));
			}
			request.setAttribute("jizdy", jizdy);
			session.setAttribute("akceJizdy", "minule");
			session.setAttribute("knihaJizdForm", kjf);
			con.close();
			con = null;
		} finally {
			if (!errors.isEmpty()) {
				saveErrors(request, errors);
			}
			if (con != null) {
				try {
					con.close();
					con = null;
				} catch (SQLException e) {
				}
			}
		}
		
		return mapping.findForward("seznamJizd");
	}

}