<%@page import="cz.futurait.apolloarcade.VisitWriter"%>
<%@page import="cz.futurait.apolloarcade.LoginWriter"%>
<%@page import="cz.futurait.apolloarcade.PurchaseWriter"%>
<%@page import="cz.futurait.apolloarcade.LastIdFinder"%>
<%@page import="cz.futurait.apolloarcade.GetActualTime"%>
<%@page import="java.util.Calendar"%>
<%@page import="cz.futurait.apolloarcade.GetPreFormattedActualYear"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Date"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%
request.setCharacterEncoding("UTF-8");
Connection con = null;
String url = pageContext.getServletContext().getInitParameter("url");//"jdbc:mysql://localhost:3306/";
String driver = "com.mysql.jdbc.Driver";
String db = pageContext.getServletContext().getInitParameter("db");
String user = pageContext.getServletContext().getInitParameter("user");
String password = pageContext.getServletContext().getInitParameter("password");
String fullurl = url+db+"?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8";

if(request.getParameter("visitsPrinter")!=null){
    String from = request.getParameter("from");
    String to = request.getParameter("to");
    if(from==null){
        from = GetPreFormattedActualYear.get();
        to=GetPreFormattedActualYear.get();
    }
    %>
    <div class='customerRegistration center' >
        <form method="post">
            OD <input type="text" name="from" value="<%=from%>" class='inputText2'/><br/>
            DO <input type="text" name="to" value="<%=to%>" class='inputText2'/><br/>
            <input type="submit" name="visitsFind" value="Hledat" class='buttonBigger'/>
        </form>
    </div>
    <%

    String fromDate = request.getParameter("from");
    String toDate = request.getParameter("to");

    SimpleDateFormat sdf = new SimpleDateFormat("dd.MM.yyyy");

    if(fromDate == null)fromDate=GetPreFormattedActualYear.get(); toDate=GetPreFormattedActualYear.get();
    Date fromDateDate = sdf.parse(fromDate);
    Date toDateDate = sdf.parse(toDate);

    Calendar c = Calendar.getInstance();
    c.setTime(toDateDate);
    c.add(Calendar.DAY_OF_MONTH, 1);
    Date endDate = c.getTime();


    %>
    <table class='tablec2'>
    <%
    try {
        Class.forName(driver).newInstance();
        con = DriverManager.getConnection(fullurl, user, password);
        try {
            PreparedStatement st = con.prepareStatement("select * from visit left join customer on customer_id = customer.id where visit.from_time > ? and visit.to_time < ?;");
            st.setDate(1, new java.sql.Date(fromDateDate.getTime()));
            st.setDate(2, new java.sql.Date(endDate.getTime()));
            ResultSet res = st.executeQuery();
                while (res.next()){
                    String lastname = res.getString("lastname");
                    String firstname = res.getString("firstname");
                    String fromTime = res.getString("from_time");
                    String toTime = res.getString("to_time");
                    System.out.println(fromTime);
                    SimpleDateFormat in = new SimpleDateFormat("yyyy.M.dd HH:mm:ss.S");
                    SimpleDateFormat out2 = new SimpleDateFormat("dd-MM-yy HH:mm:ss");

                    Date fromDateDate2 = in.parse(fromTime);
                    String result = out2.format(fromDateDate2);
                    //Date toDateDate2 = in.parse(toTime);
                    %>
                    <tr>
                        <td>
                            <%=firstname+lastname %>
                        </td>
                        <td width='300px'>
                            <small><%=result+"<br/>"%></small>
                        </td>
                    </tr>
                    <%
                }
            con.close();
        }catch (SQLException s) {
            out.println("SQL code does not execute 5.");
            s.printStackTrace();
        }
    }catch (Exception e) {
        e.printStackTrace();
    }

}


%>
</table>