Examples of org.jallinone.employees.java.EmployeeCalendarVO

org.jallinone.employees.java.EmployeeCalendarVO

Title: JAllInOne ERP/CRM application

Description: Value Object used to store an employee working week day.

Copyright: Copyright (C) 2006 Mauro Carniel

This file is part of JAllInOne ERP/CRM application. This application is free software; you can redistribute it and/or modify it under the terms of the (LGPL) Lesser General Public License as published by the Free Software Foundation; GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 This application is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details. You should have received a copy of the GNU Library General Public License along with this library; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. The author may be contacted at: maurocarniel@tin.it
@author Mauro Carniel @version 1.0

      pstmt.setObject(1,gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
      pstmt.setObject(2,gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
      pstmt.setObject(3,String.valueOf(Calendar.SUNDAY));
      ResultSet rset = pstmt.executeQuery();
      if (rset.next()) {
        EmployeeCalendarVO vo = new EmployeeCalendarVO();
        vo.setCompanyCodeSys01SCH02((String)gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
        vo.setProgressiveReg04SCH02((BigDecimal)gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
        vo.setDayOfWeekSCH02(String.valueOf(Calendar.SUNDAY));
        vo.setMorningStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(1)));
        vo.setMorningEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(2)));
        vo.setAfternoonStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(3)));
        vo.setAfternoonEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(4)));
        list.add(vo);
      }
      rset.close();


      pstmt.setObject(1,gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
      pstmt.setObject(2,gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
      pstmt.setObject(3,String.valueOf(Calendar.MONDAY));
      rset = pstmt.executeQuery();
      if (rset.next()) {
        EmployeeCalendarVO vo = new EmployeeCalendarVO();
        vo.setCompanyCodeSys01SCH02((String)gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
        vo.setProgressiveReg04SCH02((BigDecimal)gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
        vo.setDayOfWeekSCH02(String.valueOf(Calendar.MONDAY));
        vo.setMorningStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(1)));
        vo.setMorningEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(2)));
        vo.setAfternoonStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(3)));
        vo.setAfternoonEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(4)));
        list.add(vo);
      }
      rset.close();


      pstmt.setObject(1,gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
      pstmt.setObject(2,gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
      pstmt.setObject(3,String.valueOf(Calendar.TUESDAY));
      rset = pstmt.executeQuery();
      if (rset.next()) {
        EmployeeCalendarVO vo = new EmployeeCalendarVO();
        vo.setCompanyCodeSys01SCH02((String)gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
        vo.setProgressiveReg04SCH02((BigDecimal)gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
        vo.setDayOfWeekSCH02(String.valueOf(Calendar.TUESDAY));
        vo.setMorningStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(1)));
        vo.setMorningEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(2)));
        vo.setAfternoonStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(3)));
        vo.setAfternoonEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(4)));
        list.add(vo);
      }
      rset.close();


      pstmt.setObject(1,gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
      pstmt.setObject(2,gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
      pstmt.setObject(3,String.valueOf(Calendar.WEDNESDAY));
      rset = pstmt.executeQuery();
      if (rset.next()) {
        EmployeeCalendarVO vo = new EmployeeCalendarVO();
        vo.setCompanyCodeSys01SCH02((String)gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
        vo.setProgressiveReg04SCH02((BigDecimal)gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
        vo.setDayOfWeekSCH02(String.valueOf(Calendar.WEDNESDAY));
        vo.setMorningStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(1)));
        vo.setMorningEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(2)));
        vo.setAfternoonStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(3)));
        vo.setAfternoonEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(4)));
        list.add(vo);
      }
      rset.close();


      pstmt.setObject(1,gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
      pstmt.setObject(2,gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
      pstmt.setObject(3,String.valueOf(Calendar.THURSDAY));
      rset = pstmt.executeQuery();
      if (rset.next()) {
        EmployeeCalendarVO vo = new EmployeeCalendarVO();
        vo.setCompanyCodeSys01SCH02((String)gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
        vo.setProgressiveReg04SCH02((BigDecimal)gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
        vo.setDayOfWeekSCH02(String.valueOf(Calendar.THURSDAY));
        vo.setMorningStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(1)));
        vo.setMorningEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(2)));
        vo.setAfternoonStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(3)));
        vo.setAfternoonEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(4)));
        list.add(vo);
      }
      rset.close();


      pstmt.setObject(1,gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
      pstmt.setObject(2,gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
      pstmt.setObject(3,String.valueOf(Calendar.FRIDAY));
      rset = pstmt.executeQuery();
      if (rset.next()) {
        EmployeeCalendarVO vo = new EmployeeCalendarVO();
        vo.setCompanyCodeSys01SCH02((String)gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
        vo.setProgressiveReg04SCH02((BigDecimal)gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
        vo.setDayOfWeekSCH02(String.valueOf(Calendar.FRIDAY));
        vo.setMorningStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(1)));
        vo.setMorningEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(2)));
        vo.setAfternoonStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(3)));
        vo.setAfternoonEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(4)));
        list.add(vo);
      }
      rset.close();


      pstmt.setObject(1,gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
      pstmt.setObject(2,gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
      pstmt.setObject(3,String.valueOf(Calendar.SATURDAY));
      rset = pstmt.executeQuery();
      if (rset.next()) {
        EmployeeCalendarVO vo = new EmployeeCalendarVO();
        vo.setCompanyCodeSys01SCH02((String)gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01));
        vo.setProgressiveReg04SCH02((BigDecimal)gridParams.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_REG04));
        vo.setDayOfWeekSCH02(String.valueOf(Calendar.SATURDAY));
        vo.setMorningStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(1)));
        vo.setMorningEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(2)));
        vo.setAfternoonStartHourSCH02(DateUtils.removeDate(rset.getTimestamp(3)));
        vo.setAfternoonEndHourSCH02(DateUtils.removeDate(rset.getTimestamp(4)));
        list.add(vo);
      }
      rset.close();


      return new VOListResponse(list,false,list.size());

View Full Code Here

  public VOListResponse updateEmployeeCalendars(ArrayList oldList,ArrayList newList,String serverLanguageId,String username) throws Throwable {
    PreparedStatement pstmt = null;
    Connection conn = null;
    try {
      if (this.conn==null) conn = getConn(); else conn = this.conn;
     EmployeeCalendarVO oldVO = null;
      EmployeeCalendarVO newVO = null;


      pstmt = conn.prepareStatement(
        "update SCH02_EMPLOYEE_CALENDAR set "+
        "MORNING_START_HOUR=?,MORNING_END_HOUR=?,AFTERNOON_START_HOUR=?,AFTERNOON_END_HOUR=?, "+
        "LAST_UPDATE_USER=?,LAST_UPDATE_DATE=? "+
        "where "+
        "COMPANY_CODE_SYS01=? and PROGRESSIVE_REG04=? and DAY_OF_WEEK=? "
      );
      for(int i=0;i<newList.size();i++) {
        newVO = (EmployeeCalendarVO)newList.get(i);


        pstmt.setTimestamp(1,DateUtils.setTime(newVO.getMorningStartHourSCH02()));
        pstmt.setTimestamp(2,DateUtils.setTime(newVO.getMorningEndHourSCH02()));
        pstmt.setTimestamp(3,DateUtils.setTime(newVO.getAfternoonStartHourSCH02()));
        pstmt.setTimestamp(4,DateUtils.setTime(newVO.getAfternoonEndHourSCH02()));
        pstmt.setString(5,username);
        pstmt.setTimestamp(6,new Timestamp(System.currentTimeMillis()));
        pstmt.setString(7,newVO.getCompanyCodeSys01SCH02());
        pstmt.setBigDecimal(8,newVO.getProgressiveReg04SCH02());
        pstmt.setString(9,newVO.getDayOfWeekSCH02());


        pstmt.execute();
      }
//      HashSet pkAttrs = new HashSet();
//      pkAttrs.add("companyCodeSys01SCH02");

View Full Code Here

      if (afternoonEndHour==null)
        afternoonEndHour = new java.sql.Timestamp(cal.getTimeInMillis());




      // insert employee calendar, according to the company calendar default settings...
      EmployeeCalendarVO calVO = new EmployeeCalendarVO();
      calVO.setCompanyCodeSys01SCH02(vo.getCompanyCodeSys01SCH01());
      calVO.setProgressiveReg04SCH02(vo.getProgressiveReg04SCH01());
      calVO.setMorningStartHourSCH02(DateUtils.setTime(morningStartHour));
      calVO.setMorningEndHourSCH02(DateUtils.setTime(morningEndHour));
      calVO.setAfternoonStartHourSCH02(DateUtils.setTime(afternoonStartHour));
      calVO.setAfternoonEndHourSCH02(DateUtils.setTime(afternoonEndHour));


      calVO.setDayOfWeekSCH02(String.valueOf(Calendar.MONDAY));
      ArrayList list = new ArrayList();
      list.add(calVO);




      calRes = calbean.insertEmployeeCalendars(list,serverLanguageId,username);
      if (calRes.isError()) {
          throw new Exception(calRes.getErrorMessage());
      }


      calVO.setDayOfWeekSCH02(String.valueOf(Calendar.TUESDAY));
      list.clear();
      list.add(calVO);
      calRes = calbean.insertEmployeeCalendars(list,serverLanguageId,username);
      if (calRes.isError()) {
        throw new Exception(calRes.getErrorMessage());
      }


      calVO.setDayOfWeekSCH02(String.valueOf(Calendar.WEDNESDAY));
      list.clear();
      list.add(calVO);
      calRes = calbean.insertEmployeeCalendars(list,serverLanguageId,username);
      if (calRes.isError()) {
        throw new Exception(calRes.getErrorMessage());
      }


      calVO.setDayOfWeekSCH02(String.valueOf(Calendar.THURSDAY));
      list.clear();
      list.add(calVO);
      calRes = calbean.insertEmployeeCalendars(list,serverLanguageId,username);
      if (calRes.isError()) {
        throw new Exception(calRes.getErrorMessage());
      }


      calVO.setDayOfWeekSCH02(String.valueOf(Calendar.FRIDAY));
      list.clear();
      list.add(calVO);
      calRes = calbean.insertEmployeeCalendars(list,serverLanguageId,username);
      if (calRes.isError()) {
        throw new Exception(calRes.getErrorMessage());

View Full Code Here

    Connection conn = null;
    try {
      if (this.conn==null) conn = getConn(); else conn = this.conn;
      stmt = conn.createStatement();


      EmployeeCalendarVO vo = null;
      for(int i=0;i<list.size();i++) {
        vo = (EmployeeCalendarVO)list.get(i);
        // phisically delete record in SCH02...
        stmt.execute(
          "delete from SCH02_EMPLOYEE_CALENDAR where COMPANY_CODE_SYS01='"+vo.getCompanyCodeSys01SCH02()+"' and "+
          "PROGRESSIVE_REG04="+vo.getProgressiveReg04SCH02()+" and "+
          "DAY_OF_WEEK='"+vo.getDayOfWeekSCH02()+"'"
        );
      }


      return new VOResponse(new Boolean(true));
    }

View Full Code Here

     */
    public VOListResponse insertEmployeeCalendars(ArrayList list,String serverLanguageId,String username) throws Throwable {
      Connection conn = null;
      try {
        if (this.conn==null) conn = getConn(); else conn = this.conn;
        EmployeeCalendarVO vo = null;




        Map attribute2dbField = new HashMap();
        attribute2dbField.put("companyCodeSys01SCH02","COMPANY_CODE_SYS01");
        attribute2dbField.put("progressiveReg04SCH02","PROGRESSIVE_REG04");
        attribute2dbField.put("dayOfWeekSCH02","DAY_OF_WEEK");
        attribute2dbField.put("morningStartHourSCH02","MORNING_START_HOUR");
        attribute2dbField.put("morningEndHourSCH02","MORNING_END_HOUR");
        attribute2dbField.put("afternoonStartHourSCH02","AFTERNOON_START_HOUR");
        attribute2dbField.put("afternoonEndHourSCH02","AFTERNOON_END_HOUR");
        Response res = null;


        for(int i=0;i<list.size();i++) {
          vo = (EmployeeCalendarVO)list.get(i);


          vo.setMorningStartHourSCH02(DateUtils.setTime(vo.getMorningStartHourSCH02()));
          vo.setMorningEndHourSCH02(DateUtils.setTime(vo.getMorningEndHourSCH02()));
          vo.setAfternoonStartHourSCH02(DateUtils.setTime(vo.getAfternoonStartHourSCH02()));
          vo.setAfternoonEndHourSCH02(DateUtils.setTime(vo.getAfternoonEndHourSCH02()));


          // insert into SCH02...
          res = org.jallinone.commons.server.QueryUtilExtension.insertTable(
              conn,
              new UserSessionParameters(username),

View Full Code Here

   * Set day to view
   * @param currentDay day to view
   */
  public void setCurrentDay(Date currentDay) {
    this.currentDay = currentDay;
    EmployeeCalendarVO vo = null;
    Calendar cal = Calendar.getInstance();
    cal.setTime(currentDay);
    for(int i=0;i<empCalendar.size();i++) {
      vo = (EmployeeCalendarVO)empCalendar.get(i);
      if (vo.getDayOfWeekSCH02().equals(String.valueOf(cal.get(cal.DAY_OF_WEEK)))) {
        empCalVO = vo;
        break;
      }
    }
    if (empVO!=null)

View Full Code Here

   * Set the employee working hours.
   * @param empCalendar employee working hours
   */
  public void setEmpCalendar(ArrayList empCalendar) {
    this.empCalendar = empCalendar;
    EmployeeCalendarVO vo = null;
    Calendar cal = Calendar.getInstance();
    cal.setTime(currentDay);
    for(int i=0;i<empCalendar.size();i++) {
      vo = (EmployeeCalendarVO)empCalendar.get(i);
      if (vo.getDayOfWeekSCH02().equals(String.valueOf(cal.get(cal.DAY_OF_WEEK)))) {
        empCalVO = vo;
        break;
      }
    }
  }

View Full Code Here

TOP

Related Classes of org.jallinone.employees.java.EmployeeCalendarVO

org.jallinone.employees.server.EmployeesBean

org.jallinone.employees.server.InsertEmployeeCalendarsBean

org.jallinone.scheduler.appointments.client.Day

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.