com.aspc.Layers.aspc_app.Calendar.commands

Class CheckWorkHours

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.Layers.aspc_app.Calendar.commands.CheckWorkHours

All Implemented Interfaces:

CommandBuildResultsPlugin

public class CheckWorkHours
extends SQLCommand

CheckWorkHours Retrieve the working hours of users for a time period.
Syntax

  CHECK_WORK_HOURS user[,...]
  [LOCATION location]
  FROM from_time
  TO to_time
  

Usage

  CHECK_WORK_HOURS USER '1@1~1@1','1@2~1@1' LOCATION '1@1~1@1' FROM '20 Nov 2007' TO '30 Nov 2007'
  

THREAD MODE: SINGLE THREADED command

Since:

November 8, 2007, 8:43 PM

Author:

nabhilash

Field Summary

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
CheckWorkHours(Connection connection, Pattern pattern) Creates a new CheckWorkHours

Method Summary

Modifier and Type	Method and Description
void	execute(Parser parser) Retrieves availability
java.lang.String	getColumnName(int col) Gets the col name
java.lang.String	getColumnType(int col) Gets the col type
java.lang.String	getRecordID(int row) Gets the record id
protected int	getTimeSlotsMinutes(TimeSlotRule rule)
java.lang.Object	getValue(int row, int column) Gets a cell value
protected void	loadRules(TimeSlotRule[] ruleList, GlobalKey userKey, GlobalKey locationKey, java.util.TimeZone tz, java.util.Date fromDate, java.util.Date toDate)

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Constructor Detail

CheckWorkHours

public CheckWorkHours(Connection connection,
                      Pattern pattern)

Creates a new CheckWorkHours

Parameters:

connection - the command connection

pattern - the command pattern

Method Detail

execute

public void execute(Parser parser)
             throws java.lang.Exception

Retrieves availability

Specified by:

execute in class Command

Parameters:

parser - the command parser

Throws:

java.lang.Exception - a problem executing the command

loadRules

protected void loadRules(TimeSlotRule[] ruleList,
                         GlobalKey userKey,
                         GlobalKey locationKey,
                         java.util.TimeZone tz,
                         java.util.Date fromDate,
                         java.util.Date toDate)
                  throws java.lang.Exception

Throws:

java.lang.Exception

getTimeSlotsMinutes

protected int getTimeSlotsMinutes(TimeSlotRule rule)
                           throws java.lang.Exception

Throws:

java.lang.Exception

getValue

public java.lang.Object getValue(int row,
                                 int column)

Gets a cell value

Parameters:

row - the cell row

column - the cell column

Returns:

Object the cell value

getColumnType

public java.lang.String getColumnType(int col)

Gets the col type

Parameters:

col - the col to type

Returns:

String the col type

getColumnName

public java.lang.String getColumnName(int col)

Gets the col name

Parameters:

col - the col to name

Returns:

String the col name

getRecordID

public java.lang.String getRecordID(int row)

Gets the record id

Parameters:

row - the row to id

Returns:

String the record id