/*
 * 
 *
 * Created on August 3, 2001, 2:35 PM
 */

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.javaexchange.dbConnectionBroker.*;
/** 
 *
 * @author  alieberman
 * @version implements SingleThreadModel
 */
public class dayCalendar extends HttpServletJXGB  {
     private String sql;
     int numbHoursInDay = 8;
     int s= 0;
   
     Connection conn = null;
    /** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
    * @param request servlet request
    * @param response servlet response
    */

     private PrintWriter out = null;
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, java.io.IOException {
     
        HttpSession session = request.getSession();
        sessionInfo info = (sessionInfo)session.getAttribute("Attribute");   



	response.setContentType("text/html");
        out = response.getWriter();
       

   
	
        conn = myBroker.getConnection();
        drawDay(1,info.getDay(),info.getMonth_String());
       
        myBroker.freeConnection(conn) ; 
       out.println("dayCalendar" + s);
       s++;        
       out.close();
       sql = null;
  	
    }
     

    /** Handles the HTTP <code>GET</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, java.io.IOException {
        processRequest(request, response);
        
       
    } 

    /** Handles the HTTP <code>POST</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, java.io.IOException {
        processRequest(request, response);
    }

    /** Returns a short description of the servlet.
    */
    public String getServletInfo() {
        return "Short description";
    }


  public void drawDay(int id, int day, String month){
    String[] time= {"9 a.m.", "10 a.m.", "11 a.m.", "12 noon", "1 p.m.", "2 p.m.", "3 p.m.","4 p.m.", "5 p.m."}; 
    
    out.println("<TABLE bgcolor=\"#ffffff\" BORDER=5 CELLPADDING=5 CELLSPACING=3 ALIGN=CENTER>");


     out.println("<form METHOD=POST NAME=\"hour\"");
     out.println("ACTION=\"/jd/DateForm\">" );
     out.println("<script language=\"JavaScript\">");
     out.println("function timeSelector(t)");
     out.println("{document.hour.time.value = t;");
    
     out.println("document.hour.submit();}");
     out.println("</script>");
     
     out.println("<input type=hidden NAME=\"time\">");
   
     

    out.println("<TR ALIGN=CENTER><TD COLSPAN=50><B>AMOS CALENDAR ");
    out.print(month + " " + day);
    out.println("</B></TD></TR>");
    out.println("<TR ALIGN=CENTER><TD><B>Time</B></TD><TD ><B>Appointments<B></TD>");
    for(int i = 0; i < numbHoursInDay; i ++){
       out.println("<tr> <td>");
       out.println("<a href=\"javascript:timeSelector("+ i + ")\">" + time[i] + "</a>");
       out.println("</td> <td >"); 
       getData(id, i, day, month);
       out.println("</td> </tr>");
      
    }
     out.println("</FORM>"); 
    out.print("</TABLE>");
   
   }


public void HourSelect(String time){
     out.println("<form METHOD=POST NAME=\"hour\" ");
     out.println("ACTION=\"/jd/DateForm\">" );
     out.println("<input type=hidden NAME=\"time\">");
     out.println("<input type=hidden NAME=\"Year\">");
     out.println("<a href=\"javascript:timeSelector('"+time + "')\"> time" +                      "</a>");
     out.println("</FORM>");   


    }


  public void getData(int id, int time, int day, String month) {
   sql = "Select Event_Title From EVENT WHERE Person_ID =" + id; 
   sql += "AND Event_Time =" + time;
   sql += "AND Event_Day =" + day;
   sql += "AND Event_Month = '" + month + "'";
   
  //System.out.println(sql);

   try {

     
     Statement stmt = conn.createStatement();

     if (stmt.execute(sql)) {
       // There is a ResultSet
         ResultSet rs = stmt.getResultSet();
       //  System.out.println(rs);
        
         ResultSetMetaData rsmd = rs.getMetaData();
         int numcols = rsmd.getColumnCount();
        
         System.out.println(rs);
         out.println("<TABLE bgcolor=\"#ffffff\">");
         while (rs.next() == true) {
               out.println("<tr>");
               for(int i = 1; i <= numcols; i++) {
                   Object obj = rs.getObject(i);
                   System.out.println(obj.toString());
		   if (obj != null){
                        out.println("<td colspan=2>");
                        out.println(obj.toString());
                        out.println("</td><td>");
                    //   MonthArrowss("Jan", 2001,
                    //   "Jan", 2001);
                        out.println(" </td>");
                    }
                  
               }
                out.println("</tr>");
         }
       
           out.println("</TABLE>");
     }
   stmt.close();
   
   }
   
 catch (SQLException e) {
      out.println("</TABLE><H1>ERROReee:</H1> " + e.getMessage());
         }     
  
 
}
}