|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectcom.knowgate.addrbook.WorkingCalendar
public class WorkingCalendar
Represents a working/non working time calendar
| Field Summary | |
|---|---|
static short |
ClassId
|
| Constructor Summary | |
|---|---|
|
WorkingCalendar()
Default constructor for an empty calendar |
protected |
WorkingCalendar(int nDays,
java.lang.String sNmCalendar,
java.util.Date dtFrom,
java.util.Date dtTo)
|
|
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 |
| Method Summary | |
|---|---|
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)
|
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Field Detail |
|---|
public static final short ClassId
| Constructor Detail |
|---|
public WorkingCalendar()
public WorkingCalendar(java.lang.String sGuCalendar)
public WorkingCalendar(JDCConnection oConn,
java.lang.String sGuCalendar)
throws java.sql.SQLException
java.sql.SQLException
protected WorkingCalendar(int nDays,
java.lang.String sNmCalendar,
java.util.Date dtFrom,
java.util.Date dtTo)
| Method Detail |
|---|
public boolean load(JDCConnection oConn,
java.lang.String sGuCalendar)
throws java.sql.SQLException
JDCConnection - sGuCalendar - String GUID of Working Calendar to be loaded
java.sql.SQLException
public boolean store(JDCConnection oConn)
throws java.sql.SQLException
java.sql.SQLExceptionpublic int getDayCount()
public java.lang.Boolean isWorkingDay(int iDate)
throws java.lang.NullPointerException
iDate - An integer representing a date in format yyyymmdd
java.lang.NullPointerException
public java.lang.Boolean isWorkingDay(java.util.Date oDate)
throws java.lang.NullPointerException
oDate - Date to be checked
java.lang.NullPointerExceptionpublic java.lang.Boolean isWorkingDay(long lDate)
lDate - An long representing a date in miliseconds
public 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 1
java.sql.SQLExceptionpublic 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.SQLExceptionpublic 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.SQLExceptionpublic 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
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||