<%@page language="java" %>
<%@page import="java.sql.*,java.text.*,java.util.*"%>
<%@page import="db.*"%>


<%

//Festlegen der Variablen

String statement = "";

//----------------------------------------

String strDate="";
java.util.Date today = new java.util.Date();
SimpleDateFormat dayofweek = new SimpleDateFormat("EEE");
int iDifferenz = 0;

String Text="";

String weekday = dayofweek.format(today);
int akthours = today.getHours();

if (akthours >= 13){
   iDifferenz = iDifferenz + 1;//nächster Tag
   if (iDifferenz > 0 && weekday.equals("Fr")){
       iDifferenz  = iDifferenz + 2;
        }
    }

String lang = request.getParameter("lang");
if(lang == null){
   lang = "de";
}

   String strMenue="";

  // ------------MENU QUERY-------------
   /*
    * Get the menus, their date and their
    * id and save them in vectors
    */

      Abfrage qryMenu = new Abfrage("jdbc/kantine","select description, to_char(menu_date,'dd.mm.yyyy') from menu where to_char(menu_date,'yyyy.mm.dd') "+
                                                   " = to_char(sysdate+"+iDifferenz+",'yyyy.mm.dd')  and flag = 1");
      ResultSet resultMenu = qryMenu.abfrageAusfuehren();

      while(resultMenu != null && resultMenu.next()) {

          strMenue = resultMenu.getString(1);
          strDate  = resultMenu.getString(2);
      }

      qryMenu.abfrageSchliessen();

  // ----------------END----------------

  if (iDifferenz == 0) {
     Text = "Heute bekommen sie bei uns:";
     } else if (iDifferenz == 1){
     Text = "Morgen bekommen sie bei uns:";
     } else {
     Text = "Montag bekommen sie von uns:";
     }

//-------------------------------------------
//Variablen deklarieren (das Systemdatum wird als das "Heute Datum" verwendet)

String menueDate = "";
String description1 = "";
String description2 = "";
String description3 = "";

//Das Systemdatum mit dem Datum aus der Datenbank abgleichen

statement = "select to_char(menu_date, 'dd.mm.yyyy'), description, description02, description03, SYSdate from menu "+
            "where to_char(menu_date, 'dd.mm.yyyy') = to_char(sysdate, 'dd.mm.yyyy')";

// Abfrage starten, welche Gerichte es in den Vektoren gibt und in die Variablen schreiben

Abfrage menue = new Abfrage("jdbc/kantine",statement);

ResultSet getMenue = menue.abfrageAusfuehren();
while (getMenue.next()) {
   menueDate = getMenue.getString(1);
   description1 = getMenue.getString(2);
   description2 = getMenue.getString(3);
   description3 = getMenue.getString(4);

}

menue.abfrageSchliessen();


// Ausgabe an WML:

response.setContentType("text/vnd.wap.wml");


//Head
out.println("<?xml version=\"1.0\"?>");
out.println("<!DOCTYPE wml PUBLIC \"-//PHONE.COM//DTD WML 1.1//EN\" \"http://www.phone.com/dtd/wml11.dtd\" >");
//WML öffnen
out.println("<wml>");
//Card öffnen
out.println("<card id=\"eins\" title=\"Tagesmenue\" align=\"center\">");
//TechnoMealLogo einblenden
out.println("<p align=\"center\">");
out.println("<img src=\"images/TMLogo.gif\" alt=\"TechnoMealLogo\" />");
out.println(" </p>");
//Titelzeile
out.println("<p align=\"center\">");
out.println("<font><strong>Tagesmenü für den: "+strDate);
//font  color=\"#003466\"
out.println("</strong></font>");
out.println("</p>");
//Variabler Tageszeitabhängiger Text
out.println("<br/><em>"+Text);
out.println("</em>");
//Gerichte werden aus den Variablen angezeigt
out.println("<table title=\"Menue\" columns=\"2\">");
out.println("<tr><td>Hauptgericht: </td><td>"+description1);
out.println("</td></tr>");
out.println("<tr><td>Suppe:</td><td>"+description2);
out.println("</td></tr>");
out.println("</table>");
out.println("<br/>");
//Kommentar und Guten Appetit
out.println("<p align=\"center\">"+description3);
out.println("<br/><font><strong><big> Guten Appetit!");
//font  color=\"#003466\"
//Card und WML schliessen
out.println("</big></strong></font></p></card>");
out.println("</wml>");



%>