Thread: [Cobricks-cvscommit] drehscheibe-in/src/de/tum/cobricks/course generateHTMLOverviews.java

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/cobricks/drehscheibe-in/src/de/tum/cobricks/course
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv7929

Added Files:
	generateHTMLOverviews.java 
Log Message:


--- NEW FILE: generateHTMLOverviews.java ---
/*
 * Copyright (c) 2006 Cobricks Group. All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted under the terms of the Cobricks Software
 * License, either version 1.0 of the License, or (at your option) any 
 * later version (see www.cobricks.org).
 *
 * The above copyright notice and this permission notice shall be
 * included in all copies or substantial portions of the Software.
 */

package de.tum.cobricks.course;

import java.io.*;
import java.net.*;
import java.sql.*;
import java.text.*;
import java.util.Date;
import java.util.*;

import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;

import org.cobricks.core.CobricksException;
import org.cobricks.core.ComponentDirectory;
import org.cobricks.core.CoreManager;
import org.cobricks.core.db.DBAccess;
import org.cobricks.core.util.DateUtil;
import org.cobricks.core.util.LogUtil;
import org.cobricks.core.util.PropertiesUtil;
import org.cobricks.course.Course;
import org.cobricks.course.CourseDate;
import org.cobricks.course.CourseLecturer;
import org.cobricks.course.CourseManager;
import org.cobricks.course.CourseProgram;
import org.cobricks.course.CourseRoom;
import org.cobricks.user.UserManager;

/**
 * Generate HTML files that list all lectures for one specific
 * study program.
 *
 * @author    Michael Koch, TUM
 * @version   $Date: 2006/11/29 15:22:57 $
 */

public class generateHTMLOverviews
{
    static Logger logger = Logger.getLogger(generateHTMLOverviews.class);

    static private CoreManager coreManager = null;
    static private DBAccess dbAccess;

    static final String ke = "<P><UL><LI>keine Eintr&auml;ge</UL>\n";

    static String querysem;
    static int    queryjahr;
    static String cterm;
    
    static CourseManager courseManager;
    static UserManager userManager;
    
    
    public static void main(String args[])
    {
        String confdir = "WEB-INF/conf";
        querysem  = "WS";
        queryjahr = 2006;
        if (args.length > 0)
            confdir = args[0];
        if (args.length > 1)
            querysem = args[1];
        if (args.length > 2)
            queryjahr = Integer.parseInt(args[2]);

        cterm = Integer.toString(queryjahr);
        if (querysem.equals("WS")) {
            cterm += "w";
        } else {
            cterm += "s";
        }
        
        generateHTMLOverviews o =
            new generateHTMLOverviews(confdir);
        o.doIt();
    }


    /**
     *
     */
    public generateHTMLOverviews(String confdir)
    {
        try {
            PropertyConfigurator.
                configure(confdir+File.separator+"log.properties");
        } catch (Throwable e) {
        }
        
	// Instantiate CoreManager
        coreManager = new CoreManager();

        // load Cobricks configuration (properties)
        Properties properties = new Properties();
        properties.put("configdir", confdir);
        PropertiesUtil.loadProperties(confdir, properties, coreManager);
        
        // initialize CoreManager object ...
	try {
            coreManager.init(properties);
        } catch (CobricksException e) {
	    System.err.println(e.toString());
	    System.exit(-1);
	}

        // initialize all the other components
        // this call instantiates all manager and presenter objects
        try {
            coreManager.initComponents(properties);
        } catch (Throwable e) {
            logger.error(LogUtil.ex("Failed initializing components.", e));
        }        

        this.dbAccess = coreManager.getDBAccess();

        ComponentDirectory componentDirectory =
            coreManager.getComponentDirectory();
        userManager = (UserManager)
            componentDirectory.getManager("userManager");
        courseManager = (CourseManager)
            componentDirectory.getManager("courseManager");

    }


    /**
     *
     */
    public void doIt()
    {
        String filename = "vv" + querysem + Integer.toString(queryjahr);
        try {
            makeInformatik(new File(filename+"-info.html"));
            makeWirtschaftsinformatik(new File(filename+"-wi.html"));
        } catch (Exception e) {
            logger.error(LogUtil.ex("failed", e));
        }
    }


    public static void printHeader(PrintWriter out)
    {
        if (querysem.equals("SS"))
            out.println("<h2>Sommersemester "+queryjahr+"</h2>");
        else {
            int qpluseins = queryjahr + 1;
            out.println("<h2>Wintersemester "+queryjahr+"/"+
                        qpluseins+"</h2>");
        }
        
        Date today = new Date();
        DateFormat df = new SimpleDateFormat("dd.MM.yyy HH:mm");
        df.setTimeZone(TimeZone.getTimeZone("ECT"));

        String outs =
            "<p>Diese &Uuml;bersicht zeigt alle Veranstaltungen f&uuml;r das "+
            "oben angegebene Semester (Stand: "+df.format(today)+").<p> "+
            "(Geplante) Veranstaltungen anderer Semester oder "+
            "<a href=\"/studium/studiengaenge/index.html\">"+
            "anderer Studieng&auml;nge</a> k&ouml;nnen Sie &uuml;ber die "+
            "<a href=\"/myintum/kurs_verwaltung/csearch.html\">"+
            "Veranstaltungssuche</a> oder &uuml;ber die <a href=\""+
            "/studium/vvindex.html\">Links "+
            "zu anderen Veranstaltungs&uuml;bersichten</a> finden.</p>";
        out.println(outs);
    }
    
    public static void printFooter(PrintWriter out)
    {
        String outs =
            "\n<P><HR><P>"+
            "Diese Seite wird aus Effizienzgr&uuml;nden nicht on-the-fly "+
            "aus der Datenbasis generiert, sondern 'nur' zweimal "+
            "t&auml;glich erstellt - ganz ganz ganz aktuelle "+
            "&Auml;nderungen sind also nicht sofort hier "+
            "zu sehen.<P>\n"+
            "<p><a href=\"/studium/vvindex.html\">"+
            "VeranstaltungsÃ¼bersichten</a></p>";
        out.println(outs);        
    }
    
  
    public static void makeInformatik(File file)
        throws Exception
    {
        // PrintWriter out = new PrintWriter(new FileWriter(file));
        PrintWriter out =
            new PrintWriter(new BufferedWriter(new OutputStreamWriter(new java.io.FileOutputStream(file),"UTF8")));
        
        out.println("$portalPresenter.parse(\"/pageheader.html\", $portalRequest)\n");

        out.println("<H2>Studiengang Informatik (Diplom/Bachelor/Master)</h2><P>\n");
        
        printHeader(out);

        out.println("<form action=\"/COURSE\" method=\"POST\">");
        out.println("<input type=hidden name=\"cmd\" value=\"addcoursett\">");
        out.println("<input type=hidden name=\"uid\" value=\"$userId\">");
        out.println("<input type=hidden name=\"cmd.success\" value=\"/myintum/stundenplan/timetable.html\">");
        out.println("<input type=hidden name=\"cmd.error\" value=\"/myintum/stundenplan/timetable.html\">");
        
        out.println("<ul>");
        out.println("<li><a href=\"#infbachelor\">Informatik Bachelor</a>\n");
        out.println("<ul><li><a href=\"#bsi-vorl\">Vorlesungen</a>");
        out.println("<li><a href=\"#bsi-sem\">Seminare und Proseminare</a>");
        out.println("<li><a href=\"#bsi-prakt\">Praktika</a>");
        out.println("</ul>");
        out.println("<li><a href=\"#infmaster\">Informatik Master</a>\n");
        out.println("<ul><li><a href=\"#msi-vorl\">Vorlesungen</a>");
        out.println("<li><a href=\"#msi-sem\">Seminare und Proseminare</a>");
        out.println("<li><a href=\"#msi-prakt\">Praktika</a>");
        out.println("</ul>");
        out.println("<li><a href=\"#infdipl\">Informatik Diplom</a>\n");
        out.println("<ul><li><a href=\"#infdipl-vorl\">Vorlesungen</a>");
        out.println("<li><a href=\"#infdipl-sem\">Seminare und Proseminare</a>");
        out.println("<li><a href=\"#infdipl-prakt\">Praktika</a>");
        out.println("</ul>");
    
        out.println("</ul>");

        int tmpi;

        out.println("<p><hr><a name=\"infbachelor\">"
                    +"<p><h2>Informatik Bachelor</h2>");

        out.println("<P><a name=\"bsi-vorl\"></a><h3>Vorlesungen</h3>");
        tmpi = getData(out, "BS-INF", "Vorlesung", "");
        tmpi += getData(out, "BS-INF", "Ãbung", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"bsi-sem\"></a><h3>Seminare</h3>");
        tmpi = getData(out, "BS-INF", "Seminar", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"bsi-prakt\"></a><h3>Praktika</h3>");
        tmpi = getData(out, "BS-INF", "Praktikum", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<input type=submit "+
                    "value=\"Selektierte Veranstaltungen in Stundenplan "+
                    "aufnehmen\">");
        
        out.println("<p><hr><a name=\"infmaster\">"
                    +"<p><h2>Informatik Master</h2>");
        
        out.println("<P><a name=\"msi-vorl\"></a><h3>Vorlesungen</h3>");
        tmpi = getData(out, "MS-INF", "Vorlesung", "");
        tmpi += getData(out, "MS-INF", "Ãbung", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"msi-sem\"></a><h3>Seminare</h3>");
        tmpi = getData(out, "MS-INF", "Seminar", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"msi-prakt\"></a><h3>Praktika</h3>");
        tmpi = getData(out, "MS-INF", "Praktikum", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<input type=submit "+
                    "value=\"Selektierte Veranstaltungen in Stundenplan "+
                    "aufnehmen\">");
        
        out.println("<p><hr><a name=\"infdiplom\">"
                    +"<p><h2>Informatik Diplom</h2>");
        
        out.println("<P><a name=\"infdiplom-vorl\"></a><h3>Vorlesungen</h3>");
        tmpi = getData(out, "INF", "Vorlesung", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"infdiplom-sem\"></a><h3>Seminare</h3>");
        tmpi = getData(out, "INF", "Seminar", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"infdiplom-prakt\"></a><h3>Praktika</h3>");
        tmpi = getData(out, "INF", "Praktikum", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<input type=submit "+
                    "value=\"Selektierte Veranstaltungen in Stundenplan "+
                    "aufnehmen\">");
        
        out.println("</form>");
        
        printFooter(out);
        
        out.println("\n$portalPresenter.parse(\"/pagefooter.html\", $portalRequest)");

        out.flush();
        out.close();
    }
    
    public static void makeWirtschaftsinformatik(File file)
        throws Exception
    {
        // PrintWriter out = new PrintWriter(new FileWriter(file));
        PrintWriter out =
            new PrintWriter(new BufferedWriter(new OutputStreamWriter(new java.io.FileOutputStream(file),"UTF8")));

        out.println("$portalPresenter.parse(\"/pageheader.html\", $portalRequest)\n");

        out.println("<H2>Studiengang Wirtschaftsinformatik (Bachelor/Master)</h2><P>\n");
        
        printHeader(out);
        
        out.println("<form action=\"/COURSE\" method=\"POST\">");
        out.println("<input type=hidden name=\"cmd\" value=\"addcoursett\">");
        out.println("<input type=hidden name=\"uid\" value=\"$userId\">");
        out.println("<input type=hidden name=\"cmd.success\" value=\"/myintum/stundenplan/index.html\">");
        out.println("<input type=hidden name=\"cmd.error\" value=\"/myintum/stundenplan/index.html\">");
                
        out.println("<ul>");
        out.println("<LI><a href=\"#winfbachelor\">Wirtschaftsinformatik Bachelor</a>\n");
        out.println("<ul><li><a href=\"#bswi-vorl\">Vorlesungen</a>");
        out.println("<li><a href=\"#bswi-sem\">Seminare und Proseminare</a>");
        out.println("<li><a href=\"#bswi-prakt\">Praktika</a>");
        out.println("</ul>");
        
        out.println("<LI><a href=\"#winfms\">Wirtschaftsinformatik Master</a>\n");
        out.println("<ul><li><a href=\"#mswi-vorl\">Vorlesungen</a>");
        out.println("<li><a href=\"#mswi-sem\">Seminare</a>");
        out.println("<li><a href=\"#mswi-prakt\">Praktika</a>");
        out.println("</ul>");
        
        out.println("</ul>");
        out.println("<P>\n");
        
        int tmpi;
        
        out.println("<p><hr><a name=\"winfbachelor\"><P>"+
                    "<h2>Wirtschaftsinformatik Bachelor</h2>");
        
        out.println("<P><a name=\"bswi-vorl\"></a><h4>Vorlesungen</h4>");
        tmpi = getData(out, "BS-WIRTINF", "Vorlesung", "");
        tmpi += getData(out, "BS-WIRTINF", "Ãbung", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"bswi-sem\"></a><h4>Proseminare/Seminare</h4>");
        tmpi = getData(out, "BS-WIRTINF", "Proseminar", "");
        tmpi = getData(out, "BS-WIRTINF", "Seminar", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"bswi-prakt\"></a><h4>Praktika</h4>");
        tmpi = getData(out, "BS-WIRTINF", "Praktikum", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<input type=submit "+
                    "value=\"Selektierte Veranstaltungen in Stundenplan "+
                    "aufnehmen\">");
        
        out.println("</form>");
        
        printFooter(out);
        
        out.println("<p><hr><a name=\"winfms\"><P>"+
                    "<h2>Wirtschaftsinformatik Master</h2>");
        
        out.println("<P><a name=\"mswi-vorl\"></a><h4>Vorlesungen</h4>");
        tmpi = getData(out, "MS-WIRTINF", "Vorlesung", "");
        tmpi += getData(out, "MS-WIRTINF", "Ãbung", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"mswi-sem\"></a><h4>Seminare</h4>");
        tmpi = getData(out, "MS-WIRTINF", "Seminar", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<P><a name=\"mswi-prakt\"></a><h4>Praktika</h4>");
        tmpi = getData(out, "MS-WIRTINF", "Praktikum", "");
        if (tmpi < 1) {
            out.println(ke);
        }
        
        out.println("<input type=submit "+
                    "value=\"Selektierte Veranstaltungen in Stundenplan "+
                    "aufnehmen\">");
        
        out.println("</form>");
        
        out.println("\n$portalPresenter.parse(\"/pagefooter.html\", $portalRequest)");

        out.flush();
        out.close();
    }

    
    /**
     *
     */
    static int getData(PrintWriter out, String nameunivis, 
                       String typ, String wkz)
        throws Exception
    {
        Map attrs = new HashMap();
        CourseProgram cp =
            courseManager.getProgramForLabel(nameunivis);
        if (cp == null) {
            logger.error("did not find course program for "+nameunivis);
            return 0;
        }
        attrs.put("cpid", new Integer(cp.getId()));
        if (typ.length()>0) {
            attrs.put("cmtype", typ);
        }
        if (wkz!=null && wkz.length()>0) {
            attrs.put("coursetype", wkz);
        }
        attrs.put("cterm", cterm);
            
        List clist =
            courseManager.searchCourses(attrs, "course_module.cmname");
        
        int fullcount = 0;

        out.println("<UL>");
    
        Date today = new Date();
        long todayTime = today.getTime();

        Iterator i = clist.iterator();
        while (i.hasNext()) {
            fullcount++;
            Course c = (Course)i.next();

            long valctime = 0;
            Date d = c.getLastUpdate();
            if (d != null) {
                valctime = d.getTime();
            }
            
            out.print("<li>");
            String vaurl = c.getUrl();
            if (vaurl!=null && vaurl.length()>0) {
                out.print("<a href=\""+vaurl+"\">");
            }
            String vatitel = c.getFullName();
            out.print(vatitel);
            if (vaurl!=null && vaurl.length()>0) {
                out.print("</a>");
            }
            int vasws = c.getHoursLecture()
                +c.getHoursSeminar()+c.getHoursLab();
            out.print(" <i>("+getDozenten(c)+")</i>, "+vasws);
            if (c.getHoursExercises() > 0) {
                out.print("+"+c.getHoursExercises());
            }
            out.println(" SWS");
            long tdiff = todayTime - valctime;
            if (tdiff < 605000000) {
                if (tdiff < 173000000) {
                    out.print(" <IMG SRC=\"/images/image-changed.gif\" alt=\"(changed in letzten zwei Tagen)\">");
                } else if (tdiff < 346000000) {
                    out.print(" <IMG SRC=\"/images/image-changed2.gif\" alt=\"(changed in letzten vier Tagen)\">");
                } else {
                    out.print(" <IMG SRC=\"/images/image-changed3.gif\" alt=\"(changed in letzter Woche)\">");
                }
            }
            
            out.print("<input type=checkbox name=cid value=\""
                      +c.getId()+"\">");
            
            StringBuffer termine = new StringBuffer("");
            StringBuffer termineue = new StringBuffer("");
            StringBuffer terminezue = new StringBuffer("");
            int count = 0;
            List cdates = c.getCourseDates();
            Iterator i2 = cdates.iterator();
            while (i2.hasNext()) {
                
                CourseDate cd = (CourseDate)i2.next();
                
                int tewotag = cd.getWeekday();
                int teanstd  = cd.getStartHour();
                int teanmin  = cd.getStartMin();
                int teenstd  = cd.getEndHour();
                int teenmin  = cd.getEndMin();
                Date teandat = cd.getStartDate();
                Date teendat = cd.getEndDate();
                char tetyp = cd.getType();
                CourseRoom room = cd.getRoom();
                int teturnus = cd.getCycle();
                
                StringBuffer tmpsb = new StringBuffer("");
                switch (tewotag) {
                case 0: tmpsb.append("So "); break;
                case 1: tmpsb.append("Mo "); break;
                case 2: tmpsb.append("Di "); break;
                case 3: tmpsb.append("Mi "); break;
                case 4: tmpsb.append("Do "); break;
                case 5: tmpsb.append("Fr "); break;
                case 6: tmpsb.append("Sa "); break;
                }
                tmpsb.append(teanstd+":"+min2string(teanmin)+" - "+
                             teenstd+":"+min2string(teenmin)+" ");
                if (room != null) {
                    tmpsb.append(room.getName());
                }
                if (teandat != null) {
                    if (teturnus >= 1) {
                        tmpsb.append(" ab "+DateUtil.
                                     date2String(teandat, "dd.MM.yyyy"));
                        if (teturnus > 1) {
                            tmpsb.append(" alle "+teturnus+" Wochen");
                        }
                    } else {
                        if (teendat==null)
                            tmpsb.append(" am "+DateUtil.
                                         date2String(teandat, "dd.MM.yyyy"));
                        else
                            tmpsb.append(" ab "+DateUtil.
                                         date2String(teandat, "dd.MM.yyyy"));
                    }
                }
                if (teendat != null) {
                        tmpsb.append(" bis "+DateUtil.
                                     date2String(teendat, "dd.MM.yyyy"));
                }
                if (tetyp == 'Z') {
                    if (terminezue.length()<1) {
                        terminezue.append(" ZentralÃ¼bung ");
                    } else {
                        terminezue.append(", ");
                    }
                    terminezue.append(tmpsb.toString());
                }
                else if (tetyp == 'U') {
                    if (termineue.length()<1) {
                        termineue.append(" Ãbung ");
                    } else {
                        termineue.append(", ");
                    }
                    termineue.append(tmpsb.toString());
                }
                else {
                    if (termine.length()>0) {
                        termine.append(", ");
                    }
                    termine.append(tmpsb.toString());
                }
                count ++;
            }
            
            out.println("<br>"+termine.toString());
            if (terminezue.length()>0)
                out.println("<br>"+terminezue.toString());
            if (termineue.length()>0)
                out.println("<br>"+termineue.toString());

            String vacomment = c.getComment();
            if (vacomment!=null && vacomment.trim().length()>0) {
                out.println("<br>\n"+vacomment);
            }
        }
        
        out.println("</UL>");
        return fullcount;
    }


    static private String getDozenten(Course course)
        throws SQLException
    {
        List llist =
            courseManager.getLecturersForCourse(course.getId());
        StringBuffer result = new StringBuffer("");
        int count = 0;
        Iterator i = llist.iterator();
        while (i.hasNext()) {
            CourseLecturer l = (CourseLecturer)i.next();
            if (count > 0) result.append(", ");
            String doname = l.getLastName();
            String dovorname = l.getFirstName();
            String dourl = l.getUrl();
            if (dourl!=null && dourl.length()>0) {
                result.append("<a href=\""+dourl+"\" target=_top>");
            }
            result.append(doname);
            if (dovorname!=null && dovorname.length()>0) {
                result.append(" "+dovorname.substring(0, 1)+".");
            }
            if (dourl!=null && dourl.length()>0) {
                result.append("</a>");
            }
            count++;
        }
        return result.toString();
    }

  
    static private String min2string(int min)
    {
        if (min < 10)
            return new String("0"+Integer.toString(min));
        else
            return Integer.toString(min);
    }
    
}

Thread: [Cobricks-cvscommit] drehscheibe-in/src/de/tum/cobricks/course generateHTMLOverviews.java

cobricks-cvscommit