public class WorkingCalendar
extends java.lang.Object
Represents a working/non working time calendar
Modifier and Type | Field and Description |
---|---|
static short |
ClassId |
Constructor and Description |
---|
WorkingCalendar()
Default constructor for an empty calendar
|
WorkingCalendar(JDCConnection oConn,
java.lang.String sGuCalendar)
Create calendar and load it from the database
|
WorkingCalendar(java.lang.String sGuCalendar)
Create empty calendar with given GUID
|
Modifier and Type | Method and Description |
---|---|
void |
addNonWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo) |
void |
addNonWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
java.lang.String sDescription) |
void |
addTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
boolean bWorking,
java.util.Set oWeeklyHolidays,
java.lang.String sDescription) |
void |
addTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
short HourStart,
short MinuteStart,
short HourEnd,
short MinuteEnd,
boolean bWorking,
java.util.Set oWeeklyHolidays,
java.lang.String sDescription) |
void |
addTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd,
short EveningHourStart,
short EveningMinuteStart,
short EveningHourEnd,
short EveningMinuteEnd,
boolean bWorking,
java.util.Set oWeeklyHolidays,
java.lang.String sDescription) |
void |
addTime(JDCConnection oConn,
java.util.Date dtFrom,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd,
short EveningHourStart,
short EveningMinuteStart,
short EveningHourEnd,
short EveningMinuteEnd,
boolean[] aWorking,
java.lang.String sDescription) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
java.util.Set oWeeklyHolidays,
java.lang.String sDescription) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd,
java.util.Set oWeeklyHolidays) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd,
java.util.Set oWeeklyHolidays,
java.lang.String sDescription) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd,
short EveningHourStart,
short EveningMinuteStart,
short EveningHourEnd,
short EveningMinuteEnd,
java.util.Set oWeeklyHolidays,
java.lang.String sDescription) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd,
short EveningHourStart,
short EveningMinuteStart,
short EveningHourEnd,
short EveningMinuteEnd,
java.lang.String sDescription) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd,
java.lang.String sDescription) |
void |
addWorkingTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo,
java.lang.String sDescription) |
static DBSubset |
byCountry(JDCConnection oConn,
int iDomainId,
java.lang.String sWorkAreaId,
java.lang.String sLanguage) |
static DBSubset |
byGroup(JDCConnection oConn,
int iDomainId,
java.lang.String sWorkAreaId) |
static DBSubset |
byState(JDCConnection oConn,
int iDomainId,
java.lang.String sWorkAreaId,
java.lang.String sCountryId) |
static DBSubset |
byUser(JDCConnection oConn,
int iDomainId,
java.lang.String sWorkAreaId) |
static WorkingCalendar |
create(JDCConnection oConn,
int iDomainId,
java.lang.String sWorkAreaId,
java.lang.String sCalendarName,
java.util.Date dtFrom,
java.util.Date dtTo,
java.lang.String sGroupId,
java.lang.String sUserId,
java.lang.String sCountryId,
java.lang.String sStateId,
java.lang.String sZoneId,
java.util.Set oWeeklyHolidays) |
static WorkingCalendar |
create(JDCConnection oConn,
int iDomainId,
java.lang.String sWorkAreaId,
java.lang.String sCalendarName,
java.util.Date dtFrom,
java.util.Date dtTo,
java.lang.String sGroupId,
java.lang.String sUserId,
java.lang.String sCountryId,
java.lang.String sStateId,
java.lang.String sZoneId,
short MorningHourStart,
short MorningMinuteStart,
short MorningHourEnd,
short MorningMinuteEnd,
short EveningHourStart,
short EveningMinuteStart,
short EveningHourEnd,
short EveningMinuteEnd,
java.util.Set oWeeklyHolidays) |
void |
delete(JDCConnection oConn) |
static void |
delete(JDCConnection oConn,
java.lang.String sGuCalendar) |
int |
deleteTime(JDCConnection oConn,
java.util.Date dtFrom,
java.util.Date dtTo) |
int |
deleteTime(JDCConnection oConn,
java.util.Date dtFrom,
long nDays) |
static WorkingCalendar |
forUser(JDCConnection oConn,
java.lang.String sUserId,
java.util.Date dtFrom,
java.util.Date dtTo,
java.lang.String sCountryId,
java.lang.String sStateId) |
java.util.Date |
getCreationDate(JDCConnection oConn) |
int |
getDayCount()
Get number of days from the earliest date to the latest date covered by this calendar
|
java.util.Date |
getFromDate() |
java.lang.String |
getName() |
java.lang.String |
getString(java.lang.String sColumnName) |
java.lang.String |
getStringNull(java.lang.String sColumnName,
java.lang.String sDefault) |
java.util.Date |
getToDate() |
short[] |
getWorkDaysArray(JDCConnection oConn,
int iFromYear,
int iFromMonth,
int nMonths)
Get array of working vs. non-working days for a months period
|
java.lang.Boolean |
isWorkingDay(java.util.Date oDate)
Get working / non working day status
|
java.lang.Boolean |
isWorkingDay(int iDate)
Get working / non working day status
|
java.lang.Boolean |
isWorkingDay(long lDate)
Get working / non working day status
|
java.lang.Boolean |
isWorkingTime(java.util.Date dt) |
java.lang.Boolean |
isWorkingTime(int iDate,
int iHour,
int iMin)
Check if a given hour and minute falls into the working intervals of a day
|
boolean |
load(JDCConnection oConn,
java.lang.String sGuCalendar)
Load calendar from database including working time
|
WorkingCalendar |
merge(WorkingCalendar oLocalCalendar) |
void |
put(java.lang.String sColunmName,
java.util.Date dtValue) |
void |
put(java.lang.String sColunmName,
int iValue) |
void |
put(java.lang.String sColunmName,
java.lang.String sValue) |
boolean |
store(JDCConnection oConn) |
static java.util.Date |
toDate(int iDt) |
static java.util.Date |
toDate(java.lang.String sYearMonthDate) |
static java.util.Date |
toDate(java.lang.String sYear,
java.lang.String sMonth,
java.lang.String sDate) |
public static final short ClassId
public WorkingCalendar()
public WorkingCalendar(java.lang.String sGuCalendar)
public WorkingCalendar(JDCConnection oConn, java.lang.String sGuCalendar) throws java.sql.SQLException
java.sql.SQLException
public boolean load(JDCConnection oConn, java.lang.String sGuCalendar) throws java.sql.SQLException
JDCConnection
- sGuCalendar
- String GUID of Working Calendar to be loadedjava.sql.SQLException
public boolean store(JDCConnection oConn) throws java.sql.SQLException
java.sql.SQLException
public int getDayCount()
public java.lang.Boolean isWorkingDay(int iDate) throws java.lang.NullPointerException
iDate
- An integer representing a date in format yyyymmddjava.lang.NullPointerException
public java.lang.Boolean isWorkingDay(java.util.Date oDate) throws java.lang.NullPointerException
oDate
- Date to be checkedjava.lang.NullPointerException
public java.lang.Boolean isWorkingDay(long lDate)
lDate
- An long representing a date in milisecondspublic java.lang.Boolean isWorkingTime(int iDate, int iHour, int iMin)
iDate
- public java.lang.Boolean isWorkingTime(java.util.Date dt)
public void addTime(JDCConnection oConn, java.util.Date dtFrom, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd, short EveningHourStart, short EveningMinuteStart, short EveningHourEnd, short EveningMinuteEnd, boolean[] aWorking, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd, short EveningHourStart, short EveningMinuteStart, short EveningHourEnd, short EveningMinuteEnd, boolean bWorking, java.util.Set oWeeklyHolidays, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, short HourStart, short MinuteStart, short HourEnd, short MinuteEnd, boolean bWorking, java.util.Set oWeeklyHolidays, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, boolean bWorking, java.util.Set oWeeklyHolidays, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd, short EveningHourStart, short EveningMinuteStart, short EveningHourEnd, short EveningMinuteEnd, java.util.Set oWeeklyHolidays, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd, short EveningHourStart, short EveningMinuteStart, short EveningHourEnd, short EveningMinuteEnd, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd, java.util.Set oWeeklyHolidays, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd, java.util.Set oWeeklyHolidays) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, java.util.Set oWeeklyHolidays, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addNonWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo, java.lang.String sDescription) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void addNonWorkingTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException, java.lang.NullPointerException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
java.lang.NullPointerException
public void delete(JDCConnection oConn) throws java.sql.SQLException, java.lang.NullPointerException
java.sql.SQLException
java.lang.NullPointerException
public int deleteTime(JDCConnection oConn, java.util.Date dtFrom, java.util.Date dtTo) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
public int deleteTime(JDCConnection oConn, java.util.Date dtFrom, long nDays) throws java.sql.SQLException, java.lang.IllegalStateException, java.lang.IllegalArgumentException
java.sql.SQLException
java.lang.IllegalStateException
java.lang.IllegalArgumentException
public short[] getWorkDaysArray(JDCConnection oConn, int iFromYear, int iFromMonth, int nMonths) throws java.lang.IllegalArgumentException, java.sql.SQLException
JDCConnection
- iFromYear
- int Year to start fromiFromMonth
- int Month to start from [0..11]java.lang.IllegalArgumentException
- if iFromYear<1900 or iFromMonth not between 0 and 11 or nMonths is less than 1java.sql.SQLException
public java.lang.String getString(java.lang.String sColumnName)
public java.lang.String getStringNull(java.lang.String sColumnName, java.lang.String sDefault)
public java.lang.String getName()
public java.util.Date getCreationDate(JDCConnection oConn) throws java.sql.SQLException
java.sql.SQLException
public java.util.Date getFromDate()
public java.util.Date getToDate()
public void put(java.lang.String sColunmName, java.lang.String sValue)
public void put(java.lang.String sColunmName, int iValue)
public void put(java.lang.String sColunmName, java.util.Date dtValue)
public WorkingCalendar merge(WorkingCalendar oLocalCalendar) throws java.lang.NullPointerException
java.lang.NullPointerException
public static WorkingCalendar create(JDCConnection oConn, int iDomainId, java.lang.String sWorkAreaId, java.lang.String sCalendarName, java.util.Date dtFrom, java.util.Date dtTo, java.lang.String sGroupId, java.lang.String sUserId, java.lang.String sCountryId, java.lang.String sStateId, java.lang.String sZoneId, short MorningHourStart, short MorningMinuteStart, short MorningHourEnd, short MorningMinuteEnd, short EveningHourStart, short EveningMinuteStart, short EveningHourEnd, short EveningMinuteEnd, java.util.Set oWeeklyHolidays) throws java.sql.SQLException, java.lang.NullPointerException
java.sql.SQLException
java.lang.NullPointerException
public static WorkingCalendar create(JDCConnection oConn, int iDomainId, java.lang.String sWorkAreaId, java.lang.String sCalendarName, java.util.Date dtFrom, java.util.Date dtTo, java.lang.String sGroupId, java.lang.String sUserId, java.lang.String sCountryId, java.lang.String sStateId, java.lang.String sZoneId, java.util.Set oWeeklyHolidays) throws java.sql.SQLException, java.lang.NullPointerException
java.sql.SQLException
java.lang.NullPointerException
public static void delete(JDCConnection oConn, java.lang.String sGuCalendar) throws java.sql.SQLException
java.sql.SQLException
public static java.util.Date toDate(int iDt)
public static java.util.Date toDate(java.lang.String sYear, java.lang.String sMonth, java.lang.String sDate) throws java.lang.NumberFormatException
java.lang.NumberFormatException
public static java.util.Date toDate(java.lang.String sYearMonthDate) throws java.lang.NumberFormatException
java.lang.NumberFormatException
public static DBSubset byGroup(JDCConnection oConn, int iDomainId, java.lang.String sWorkAreaId) throws java.sql.SQLException, java.lang.NullPointerException
java.sql.SQLException
java.lang.NullPointerException
public static DBSubset byUser(JDCConnection oConn, int iDomainId, java.lang.String sWorkAreaId) throws java.sql.SQLException, java.lang.NullPointerException
java.sql.SQLException
java.lang.NullPointerException
public static DBSubset byCountry(JDCConnection oConn, int iDomainId, java.lang.String sWorkAreaId, java.lang.String sLanguage) throws java.sql.SQLException, java.lang.NullPointerException
java.sql.SQLException
java.lang.NullPointerException
public static DBSubset byState(JDCConnection oConn, int iDomainId, java.lang.String sWorkAreaId, java.lang.String sCountryId) throws java.sql.SQLException, java.lang.NullPointerException
java.sql.SQLException
java.lang.NullPointerException
public static WorkingCalendar forUser(JDCConnection oConn, java.lang.String sUserId, java.util.Date dtFrom, java.util.Date dtTo, java.lang.String sCountryId, java.lang.String sStateId) throws java.sql.SQLException, java.lang.NullPointerException
java.sql.SQLException
java.lang.NullPointerException