Example usage for org.joda.time DateTime toLocalDate

List of usage examples for org.joda.time DateTime toLocalDate

Introduction

In this page you can find the example usage for org.joda.time DateTime toLocalDate.

Prototype

public LocalDate toLocalDate() 

Source Link

Document

Converts this object to a LocalDate with the same date and chronology.

Usage

From source file:de.avanux.smartapplianceenabler.appliance.DayTimeframe.java

License:Open Source License

@Override
public List<TimeframeInterval> getIntervals(LocalDateTime now) {
    List<TimeframeInterval> intervals = new ArrayList<>();
    if (start != null && end != null) {
        Interval interval = buildMidnightAdjustedInterval(now);
        List<Integer> dowValues = getDaysOfWeekValues();
        // if today's interval already ended we ignore today
        int dayOffset = (interval.getEnd().isBefore(now.toDateTime()) ? 1 : 0);
        for (int i = dayOffset; i < 7 + dayOffset; i++) {
            DateTime timeFrameStart = interval.getStart().plusDays(i);
            DateTime timeFrameEnd = interval.getEnd().plusDays(i);
            if (dowValues != null) {
                int dow = timeFrameStart.getDayOfWeek();
                if (dowValues.contains(DOW_HOLIDAYS) && isHoliday(timeFrameStart.toLocalDate())) {
                    dow = DOW_HOLIDAYS;//from w  w w .jav a  2  s  .co  m
                }
                if (dowValues.contains(dow)) {
                    intervals.add(new TimeframeInterval(this, new Interval(timeFrameStart, timeFrameEnd)));
                }
            } else {
                intervals.add(new TimeframeInterval(this, new Interval(timeFrameStart, timeFrameEnd)));
            }
        }
    }
    return intervals;
}

From source file:divconq.util.TimeUtil.java

License:Open Source License

/**
 * check if a date is before today, ignore the time just look at the date
 * /* ww  w .ja  va 2  s  .c  o m*/
 * @param d date to check
 * @return true if it comes before today
 */
static public boolean isBeforeToday(DateTime d) {
    return d.toLocalDate().isBefore(new LocalDate());
}

From source file:divconq.util.TimeUtil.java

License:Open Source License

/**
 * detect if given datetime lands on a DST transition
 * //from  w ww  .  j a  va 2  s.c  o m
 * @param n date to check
 * @return START if is a start of DST, END if is a end of DST, NA means day is not a transition
 */
public static DaylightTransition checkDST(DateTime n) {
    DateTime start = TimeUtil.startDST(n.getYear());

    if (start.toLocalDate().equals(n.toLocalDate()))
        return DaylightTransition.START;

    DateTime end = TimeUtil.startDST(n.getYear());

    if (end.toLocalDate().equals(n.toLocalDate()))
        return DaylightTransition.END;

    return DaylightTransition.NA;
}

From source file:energy.usef.dso.event.endpoint.EventEndpoint.java

License:Apache License

private static LocalDate parseDate(String value) {
    DateTimeFormatter formatter = DateTimeFormat.forPattern(DATE_PATTERN);
    DateTime dateTime = formatter.parseDateTime(value);
    return dateTime.toLocalDate();
}

From source file:es.usc.citius.servando.calendula.scheduling.DailyAgenda.java

License:Open Source License

public void createDailySchedule(DateTime d) {

    boolean todayCreated = DB.dailyScheduleItems().isDatePresent(d.toLocalDate());

    if (!todayCreated) {
        createScheduleForDate(d.toLocalDate());
    }/* w  w  w.ja v a 2  s. c om*/

    for (int i = 1; i <= NEXT_DAYS_TO_SHOW; i++) {
        LocalDate date = d.plusDays(i).toLocalDate();
        if (!DB.dailyScheduleItems().isDatePresent(date)) {
            createScheduleForDate(date);
        }
    }
}

From source file:eu.uqasar.model.user.User.java

License:Apache License

public Integer getAge() {
    if (this.birthDay != null) {
        DateTime start = new DateTime(this.birthDay);
        DateTime end = DateTime.now();/*from   w w w  .j a v  a2  s.c o  m*/
        return Years.yearsBetween(start.toLocalDate(), end.toLocalDate()).getYears();
    }
    return null;
}

From source file:json.Calendar2Servlet.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./* ww  w  . j a va2  s.c om*/
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    CalendarDates2 cal;

    SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
    SimpleDateFormat nor = new SimpleDateFormat("dd-MM-yyyy");
    DateTime fin;
    CalendarDTO c[] = new CalendarDTO[1344]; //  capasidad de 1344
    int t = 0;
    List l = new ArrayList();

    try {
        cal = new CalendarDates2();

        while (cal.getDatos().getResultSet().next()) {

            c[t] = new CalendarDTO();
            c[t].setId(t);
            c[t].setStart("" + cal.getDatos().getResultSet().getDate("Incextr"));
            fin = DateTime.parse(cal.getDatos().getResultSet().getDate("Finextr").toString());
            fin = fin.plusDays(1);
            c[t].setEnd("" + f.format(fin.toLocalDate().toDate()));
            c[t].setTitle("" + cal.getDatos().getResultSet().getInt("Orden") + " "
                    + cal.getDatos().getResultSet().getString("Responsable").trim());
            if (!f.format(cal.getDatos().getResultSet().getDate("Finreal")).equals("2001-01-01")) {
                c[t].setDescription("<h2 align='center'>"
                        + cal.getDatos().getResultSet().getString("AREA").trim() + " </h2>"
                        + "<h4> Ubicacion Tecnica  : </h4>"
                        + cal.getDatos().getResultSet().getString("Denominacion").trim()
                        + "<h4> Responsable  : </h4>"
                        + cal.getDatos().getResultSet().getString("PtoTrbRes").trim() + "<h4> Operarios  :</h4>"
                        + cal.getDatos().getResultSet().getString("ayudantes").trim()
                        + "<h4> TextoBreveOperacion : </h4> <p>"
                        + cal.getDatos().getResultSet().getString("TextoOperacion") + "</p>"
                        + "<h4> TextoBreve : </h4> <p> "
                        + cal.getDatos().getResultSet().getString("Textobreve").trim() + "</p>"
                        + "<h4> Periodo: </h4> <p> "
                        + nor.format(cal.getDatos().getResultSet().getDate("Incextr")) + " AL  "
                        + nor.format(cal.getDatos().getResultSet().getDate("Finextr")) + "</p>"
                        + "<h4> Estado : </h4>" + cal.getDatos().getResultSet().getString("Estado").trim()
                        + "<h4> Finaliz el : </h4> <p>"
                        + nor.format(cal.getDatos().getResultSet().getDate("Finreal")) + "</p>");
            } else {
                c[t].setDescription("<h2 align='center'>"
                        + cal.getDatos().getResultSet().getString("AREA").trim() + " </h2>"
                        + "<h4> Ubicacion Tecnica  : </h4>"
                        + cal.getDatos().getResultSet().getString("Denominacion").trim()
                        + "<h4> Responsable  : </h4>"
                        + cal.getDatos().getResultSet().getString("PtoTrbRes").trim() + "<h4> Operarios  :</h4>"
                        + cal.getDatos().getResultSet().getString("ayudantes").trim()
                        + "<h4> TextoBreveOperacion : </h4> <p>"
                        + cal.getDatos().getResultSet().getString("TextoOperacion") + "</p>"
                        + "<h4> TextoBreve : </h4> <p> "
                        + cal.getDatos().getResultSet().getString("Textobreve").trim() + "</p>"
                        + "<h4> Periodo: </h4> <p> "
                        + nor.format(cal.getDatos().getResultSet().getDate("Incextr")) + " AL  "
                        + nor.format(cal.getDatos().getResultSet().getDate("Finextr")) + "</p>"
                        + "<h4> Estado : </h4>" + cal.getDatos().getResultSet().getString("Estado").trim()
                        + "<h4> Finaliz el : </h4> <p> </p>");

            }
            if (!f.format(cal.getDatos().getResultSet().getDate("Finreal")).equals("2001-01-01")) {
                c[t].setColor("white");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("MANTENIMIENTO")) {
                c[t].setColor("skyblue");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("OPERACION")) {
                c[t].setColor("black");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("white");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("SEGURIDAD")) {
                c[t].setColor("#ff6347");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("UAT")) {
                c[t].setColor("gray");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            }

            l.add(c[t]);
            t++;

        }

        cal.getConexion().close();

    } catch (SQLException ex) {
        Logger.getLogger(CalendarJsonServlet.class.getName()).log(Level.SEVERE, null, ex);
    }

    response.setContentType("application/json");
    response.setCharacterEncoding("UTF-8");
    PrintWriter out = response.getWriter();
    out.write(new Gson().toJson(l));
}

From source file:json.CalendarJsonServlet.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from  w  w  w .  jav a2s .  c o  m*/
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    calendarDates cal;

    SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
    SimpleDateFormat nor = new SimpleDateFormat("dd-MM-yyyy");
    DateTime fin;
    List l = new ArrayList();

    try {
        cal = new calendarDates();

        while (cal.getDatos().getResultSet().next()) {
            CalendarDTO c = new CalendarDTO();
            c.setStart("" + cal.getDatos().getResultSet().getDate("Incextr"));
            fin = DateTime.parse(cal.getDatos().getResultSet().getDate("Finextr").toString());
            fin = fin.plusDays(1);
            c.setEnd("" + f.format(fin.toLocalDate().toDate()));
            c.setTitle("" + cal.getDatos().getResultSet().getInt("Orden") + " "
                    + cal.getDatos().getResultSet().getString("Responsable").trim());
            if (!f.format(cal.getDatos().getResultSet().getDate("Finreal")).equals("2001-01-01")) {
                c.setDescription("<h2 align='center'>" + cal.getDatos().getResultSet().getString("AREA").trim()
                        + " </h2>" + "<h4> Ubicacion Tecnica  : </h4>"
                        + cal.getDatos().getResultSet().getString("UbicacionTecnica").trim()
                        + "<h4> Responsable  : </h4>"
                        + cal.getDatos().getResultSet().getString("PtoTrbRes").trim() + "<h4> Operarios  :</h4>"
                        + cal.getDatos().getResultSet().getString("ayudantes").trim()
                        + "<h4> TextoBreveOperacion : </h4> <p>"
                        + cal.getDatos().getResultSet().getString("TextoOperacion") + "</p>"
                        + "<h4> TextoBreve : </h4> <p> "
                        + cal.getDatos().getResultSet().getString("Textobreve").trim() + "</p>"
                        + "<h4> Estado : </h4>" + cal.getDatos().getResultSet().getString("Estado").trim()
                        + "<h4> Finaliz el : </h4> <p>"
                        + nor.format(cal.getDatos().getResultSet().getDate("Finreal")) + "</p>");
            } else {
                c.setDescription("<h2 align='center'>" + cal.getDatos().getResultSet().getString("AREA").trim()
                        + " </h2>" + "<h4> Ubicacion Tecnica  : </h4>"
                        + cal.getDatos().getResultSet().getString("UbicacionTecnica").trim()
                        + "<h4> Responsable  : </h4>"
                        + cal.getDatos().getResultSet().getString("PtoTrbRes").trim() + "<h4> Operarios  :</h4>"
                        + cal.getDatos().getResultSet().getString("ayudantes").trim()
                        + "<h4> TextoBreveOperacion : </h4> <p>"
                        + cal.getDatos().getResultSet().getString("TextoOperacion") + "</p>"
                        + "<h4> TextoBreve : </h4> <p> "
                        + cal.getDatos().getResultSet().getString("Textobreve").trim() + "</p>"
                        + "<h4> Estado : </h4>" + cal.getDatos().getResultSet().getString("Estado").trim()
                        + "<h4> Finaliz el : </h4> <p> </p>");

            }
            if (!f.format(cal.getDatos().getResultSet().getDate("Finreal")).equals("2001-01-01")) {
                c.setColor("white");
                c.setBorderColor("skyblue");
                c.setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("MANTENIMIENTO")) {
                c.setColor("skyblue");
                c.setBorderColor("skyblue");
                c.setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("OPERACION")) {
                c.setColor("black");
                c.setBorderColor("skyblue");
                c.setTextColor("white");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("SEGURIDAD")) {
                c.setColor("#ff6347");
                c.setBorderColor("skyblue");
                c.setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("UAT")) {
                c.setColor("gray");
                c.setBorderColor("skyblue");
                c.setTextColor("black");
            }

            l.add(c);

        }
        cal.getConexion().close();

    } catch (SQLException ex) {
        Logger.getLogger(CalendarJsonServlet.class.getName()).log(Level.SEVERE, null, ex);
    }

    response.setContentType("application/json");
    response.setCharacterEncoding("UTF-8");
    PrintWriter out = response.getWriter();
    out.write(new Gson().toJson(l));

}

From source file:json.mantenimientoServlet.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//  ww w .java2s  . c  om
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    CalendarDates2 cal;

    SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
    SimpleDateFormat nor = new SimpleDateFormat("dd-MM-yyyy");
    DateTime fin;
    CalendarDTO c[] = new CalendarDTO[1344]; //  capasidad de 1344
    int t = 0;
    List l = new ArrayList();

    try {
        cal = new CalendarDates2("MANTENIMIENTO");

        while (cal.getDatos().getResultSet().next()) {

            c[t] = new CalendarDTO();
            c[t].setId(t);
            c[t].setStart("" + cal.getDatos().getResultSet().getDate("Incextr"));
            fin = DateTime.parse(cal.getDatos().getResultSet().getDate("Finextr").toString());
            fin = fin.plusDays(1);
            c[t].setEnd("" + f.format(fin.toLocalDate().toDate()));
            c[t].setTitle("" + cal.getDatos().getResultSet().getInt("Orden") + " "
                    + cal.getDatos().getResultSet().getString("Responsable").trim());
            if (!f.format(cal.getDatos().getResultSet().getDate("Finreal")).equals("2001-01-01")) {
                c[t].setDescription("<h2 align='center'>"
                        + cal.getDatos().getResultSet().getString("AREA").trim() + " </h2>"
                        + "<h4> Ubicacion Tecnica  : </h4>"
                        + cal.getDatos().getResultSet().getString("Denominacion").trim()
                        + "<h4> Responsable  : </h4>"
                        + cal.getDatos().getResultSet().getString("PtoTrbRes").trim() + "<h4> Operarios  :</h4>"
                        + cal.getDatos().getResultSet().getString("ayudantes").trim()
                        + "<h4> TextoBreveOperacion : </h4> <p>"
                        + cal.getDatos().getResultSet().getString("TextoOperacion") + "</p>"
                        + "<h4> TextoBreve : </h4> <p> "
                        + cal.getDatos().getResultSet().getString("Textobreve").trim() + "</p>"
                        + "<h4> Periodo: </h4> <p> "
                        + nor.format(cal.getDatos().getResultSet().getDate("Incextr")) + " AL  "
                        + nor.format(cal.getDatos().getResultSet().getDate("Finextr")) + "</p>"
                        + "<h4> Estado : </h4>" + cal.getDatos().getResultSet().getString("Estado").trim()
                        + "<h4> Finaliz el : </h4> <p>"
                        + nor.format(cal.getDatos().getResultSet().getDate("Finreal")) + "</p>");
            } else {
                c[t].setDescription("<h2 align='center'>"
                        + cal.getDatos().getResultSet().getString("AREA").trim() + " </h2>"
                        + "<h4> Ubicacion Tecnica  : </h4>"
                        + cal.getDatos().getResultSet().getString("Denominacion").trim()
                        + "<h4> Responsable  : </h4>"
                        + cal.getDatos().getResultSet().getString("PtoTrbRes").trim() + "<h4> Operarios  :</h4>"
                        + cal.getDatos().getResultSet().getString("ayudantes").trim()
                        + "<h4> TextoBreveOperacion : </h4> <p>"
                        + cal.getDatos().getResultSet().getString("TextoOperacion") + "</p>"
                        + "<h4> TextoBreve : </h4> <p> "
                        + cal.getDatos().getResultSet().getString("Textobreve").trim() + "</p>"
                        + "<h4> Periodo: </h4> <p> "
                        + nor.format(cal.getDatos().getResultSet().getDate("Incextr")) + " AL  "
                        + nor.format(cal.getDatos().getResultSet().getDate("Finextr")) + "</p>"
                        + "<h4> Estado : </h4>" + cal.getDatos().getResultSet().getString("Estado").trim()
                        + "<h4> Finaliz el : </h4> <p> </p>");

            }
            if (!f.format(cal.getDatos().getResultSet().getDate("Finreal")).equals("2001-01-01")) {
                c[t].setColor("white");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("MANTENIMIENTO")) {
                c[t].setColor("skyblue");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("OPERACION")) {
                c[t].setColor("black");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("white");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("SEGURIDAD")) {
                c[t].setColor("#ff6347");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("UAT")) {
                c[t].setColor("gray");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            }

            l.add(c[t]);
            t++;

        } // fin while

        cal.getConexion().close();

    } catch (SQLException ex) {
        Logger.getLogger(CalendarJsonServlet.class.getName()).log(Level.SEVERE, null, ex);
    }

    response.setContentType("application/json");
    response.setCharacterEncoding("UTF-8");
    PrintWriter out = response.getWriter();
    out.write(new Gson().toJson(l));
}

From source file:json.operacionesServlet.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.// w ww .  j  a  v  a  2 s.  c  o m
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    CalendarDates2 cal;

    SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
    SimpleDateFormat nor = new SimpleDateFormat("dd-MM-yyyy");
    DateTime fin;
    CalendarDTO c[] = new CalendarDTO[1344]; //  capasidad de 1344
    int t = 0;
    List l = new ArrayList();

    try {
        cal = new CalendarDates2("OPERACION");

        while (cal.getDatos().getResultSet().next()) {

            c[t] = new CalendarDTO();
            c[t].setId(t);
            c[t].setStart("" + cal.getDatos().getResultSet().getDate("Incextr"));
            fin = DateTime.parse(cal.getDatos().getResultSet().getDate("Finextr").toString());
            fin = fin.plusDays(1);
            c[t].setEnd("" + f.format(fin.toLocalDate().toDate()));
            c[t].setTitle("" + cal.getDatos().getResultSet().getInt("Orden") + " "
                    + cal.getDatos().getResultSet().getString("Responsable").trim());
            if (!f.format(cal.getDatos().getResultSet().getDate("Finreal")).equals("2001-01-01")) {
                c[t].setDescription("<h2 align='center'>"
                        + cal.getDatos().getResultSet().getString("AREA").trim() + " </h2>"
                        + "<h4> Ubicacion Tecnica  : </h4>"
                        + cal.getDatos().getResultSet().getString("Denominacion").trim()
                        + "<h4> Responsable  : </h4>"
                        + cal.getDatos().getResultSet().getString("PtoTrbRes").trim() + "<h4> Operarios  :</h4>"
                        + cal.getDatos().getResultSet().getString("ayudantes").trim()
                        + "<h4> TextoBreveOperacion : </h4> <p>"
                        + cal.getDatos().getResultSet().getString("TextoOperacion") + "</p>"
                        + "<h4> TextoBreve : </h4> <p> "
                        + cal.getDatos().getResultSet().getString("Textobreve").trim() + "</p>"
                        + "<h4> Periodo: </h4> <p> "
                        + nor.format(cal.getDatos().getResultSet().getDate("Incextr")) + " AL  "
                        + nor.format(cal.getDatos().getResultSet().getDate("Finextr")) + "</p>"
                        + "<h4> Estado : </h4>" + cal.getDatos().getResultSet().getString("Estado").trim()
                        + "<h4> Finaliz el : </h4> <p>"
                        + nor.format(cal.getDatos().getResultSet().getDate("Finreal")) + "</p>");
            } else {
                c[t].setDescription("<h2 align='center'>"
                        + cal.getDatos().getResultSet().getString("AREA").trim() + " </h2>"
                        + "<h4> Ubicacion Tecnica  : </h4>"
                        + cal.getDatos().getResultSet().getString("Denominacion").trim()
                        + "<h4> Responsable  : </h4>"
                        + cal.getDatos().getResultSet().getString("PtoTrbRes").trim() + "<h4> Operarios  :</h4>"
                        + cal.getDatos().getResultSet().getString("ayudantes").trim()
                        + "<h4> TextoBreveOperacion : </h4> <p>"
                        + cal.getDatos().getResultSet().getString("TextoOperacion") + "</p>"
                        + "<h4> TextoBreve : </h4> <p> "
                        + cal.getDatos().getResultSet().getString("Textobreve").trim() + "</p>"
                        + "<h4> Periodo: </h4> <p> "
                        + nor.format(cal.getDatos().getResultSet().getDate("Incextr")) + " AL  "
                        + nor.format(cal.getDatos().getResultSet().getDate("Finextr")) + "</p>"
                        + "<h4> Estado : </h4>" + cal.getDatos().getResultSet().getString("Estado").trim()
                        + "<h4> Finaliz el : </h4> <p> </p>");

            }
            if (!f.format(cal.getDatos().getResultSet().getDate("Finreal")).equals("2001-01-01")) {
                c[t].setColor("white");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("MANTENIMIENTO")) {
                c[t].setColor("skyblue");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("OPERACION")) {
                c[t].setColor("black");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("white");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("SEGURIDAD")) {
                c[t].setColor("#ff6347");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            } else if (cal.getDatos().getResultSet().getString("AREA").equals("UAT")) {
                c[t].setColor("gray");
                c[t].setBorderColor("skyblue");
                c[t].setTextColor("black");
            }

            l.add(c[t]);
            t++;

        } // fin while

        cal.getConexion().close();

    } catch (SQLException ex) {
        Logger.getLogger(CalendarJsonServlet.class.getName()).log(Level.SEVERE, null, ex);
    }

    response.setContentType("application/json");
    response.setCharacterEncoding("UTF-8");
    PrintWriter out = response.getWriter();
    out.write(new Gson().toJson(l));
}