com.aspc.Layers.aspc_app.Task.commands

Class SendEmailPageV2

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.Layers.aspc_app.Task.commands.SendEmailPageV2

All Implemented Interfaces:

CommandBuildResultsPlugin

public class SendEmailPageV2
extends SQLCommand

Send page in email. Syntax

  SEND_EMAIL_PAGEV2  PAGE_URL pageUrl
                                           SENDER sender_email
                                           USER run_as_user
                                           TARGET target_object
                                           [SUBJECT email_subject]
                                           RECIPIENTS recipient_list[,...]
                                           [SHOW_CHARTS show_charts]
                                           [ASOF asof_date]
                                           [START_DATE_PREVIOUS_PERIODS start_date_previous_periods]
  

Usage

  SEND_EMAIL_PAGEV2 PAGE_URL 'http://aspc.jobtrack.com.au/site/reports/continuous-improvement-report-v2?job_key=123286@2097152781~21@2'
      SENDER support@stsoftware.com.au
      USER lei
      TARGET 123288@2097152781~21@2
      RECIPIENTS 13245@2097152781~12@1 
      SHOW_CHARTS TRUE
      ASOF '1 Feb 2018'
      START_DATE_PREVIOUS_PERIODS '1 Jan 2018'
  

THREAD MODE: SINGLE THREADED command

Since:

26 June 2020

Author:

Parminder Singh

Field Summary

Fields

Modifier and Type	Field and Description
static ConcurrentDecimalFormat	HOUR_FORMATTER

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

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
SendEmailPageV2(Connection connection, Pattern pattern)

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) execute the command.
java.lang.String	getColumnName(int col) Not mandatory to supply a key for the row as well.
java.lang.String	getColumnType(int col) get the column type
java.lang.String	getRecordID(int row) We are at the last row when we return null for the record ID.
java.lang.Object	getValue(int row, int col) The value for this column/row

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

Field Detail

HOUR_FORMATTER

public static final ConcurrentDecimalFormat HOUR_FORMATTER

Constructor Detail

SendEmailPageV2

public SendEmailPageV2(Connection connection,
                       Pattern pattern)

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

execute the command.

Specified by:

execute in class Command

Parameters:

p - The parser

Throws:

java.lang.Exception - A serious problem

getColumnName

public java.lang.String getColumnName(int col)

Description copied from interface: CommandBuildResultsPlugin

Not mandatory to supply a key for the row as well. If not the ID will be used.

Parameters:

col - The column number ( offset from 1)

Returns:

The column name

getRecordID

public java.lang.String getRecordID(int row)

Description copied from interface: CommandBuildResultsPlugin

We are at the last row when we return null for the record ID. All rows must have a unique ID. Nothing else is assumed about a record ID other than it is unique and will return the same value at a later time.

Parameters:

row - The row number ( offset from 1)

Returns:

The record ID

getColumnType

public java.lang.String getColumnType(int col)

Description copied from interface: CommandBuildResultsPlugin

get the column type

Parameters:

col - The column number ( offset from 1)

Returns:

The column name

getValue

@CheckReturnValue
 @Nullable
public java.lang.Object getValue(@Nonnegative
                                                              int row,
                                                              @Nonnegative
                                                              int col)

Description copied from interface: CommandBuildResultsPlugin

The value for this column/row

Parameters:

row - The row number ( offset from 1)

col - The column number ( offset from 1)

Returns:

The value