com.aspc.Layers.aspc_app.Task.commands

Class ConvertDBEmailToTask

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.Layers.aspc_app.Task.commands.ConvertDBEmailToTask

All Implemented Interfaces:

CommandBuildResultsPlugin

Direct Known Subclasses:

ConvertSmegDBEmailToTask

public class ConvertDBEmailToTask
extends SQLCommand

Create task from dbemailread
Syntax

  CONVERT_EMAIL_TO_TASK EMAIL_GK global_key EMAIL_ADDRESS_PAT address_pattern SUBJECT_PAT subject_pattern ID_PAT id_pattern [CREATE_QUOTE] [CUSTOMER_GK cus_gk] [ERROR_EMAIL error_email_address] [RECIPIENT recipient_email] [IGNORED_RECIPIENT ignored_recipient] [UNSUCCESSFUL_PAT unsuccessful_pattern] [SUCCESSFUL_PAT successful_pattern]
  

Usage

  CONVERT_EMAIL_TO_TASK EMAIL_GK 123@2~1@1 EMAIL_ADDRESS_PAT '^.*hotmail\\.com\\.au$' SUBJECT_PAT '^Quote.*$' ID_PAT '\\d{14}'
  

THREAD MODE: SINGLE THREADED command

Since:

$Date: 2014-08-06 07:15:33 $

Author:

Rick Lu

Field Summary

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

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
ConvertDBEmailToTask(Connection connection, Pattern pattern)

Method Summary

Modifier and Type	Method and Description
SalesCycle	additionalSearch(DBEmail email, MutableDataSource ds) Additional search for sale opportunity
protected void	execute(Parser p) Execute the JOB command.
java.lang.String	getColumnName(int col) The column name
java.lang.String	getColumnType(int col) The column type
java.lang.String	getRecordID(int row) The record ID for this row
java.lang.Object	getValue(int row, int col) The value for this row/col
DBFile	relocateAttachment(DBEmail email, MutableDataSource ds, DBFile file, boolean createQuote) Relocate email attachment
protected void	scanFile(SalesCycle sc, DBFile file, DBEmail email)

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

ConvertDBEmailToTask

public ConvertDBEmailToTask(Connection connection,
                            Pattern pattern)

Parameters:

connection -

pattern -

Method Detail

execute

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

Execute the JOB command.

Specified by:

execute in class Command

Parameters:

p - the parameters

Throws:

java.lang.Exception - a serious problem

scanFile

protected void scanFile(SalesCycle sc,
                        DBFile file,
                        DBEmail email)
                 throws java.lang.Exception

Throws:

java.lang.Exception

additionalSearch

public SalesCycle additionalSearch(DBEmail email,
                                   MutableDataSource ds)
                            throws java.lang.Exception

Additional search for sale opportunity

Parameters:

email - the parameters

ds - the parameters

Returns:

the sale opportunity

Throws:

java.lang.Exception - a serious problem.

relocateAttachment

public DBFile relocateAttachment(DBEmail email,
                                 MutableDataSource ds,
                                 DBFile file,
                                 boolean createQuote)
                          throws java.lang.Exception

Relocate email attachment

Parameters:

email - the parameters

ds - the parameters

file - the parameters

createQuote -

Returns:

the sale opportunity

Throws:

java.lang.Exception - a serious problem.

getColumnName

public java.lang.String getColumnName(int col)

The column name

Parameters:

col - offset from 1

Returns:

The name

getColumnType

public java.lang.String getColumnType(int col)
                               throws java.lang.Exception

The column type

Parameters:

col - offset from 1

Returns:

The column type

Throws:

java.lang.Exception - a serious problem

getValue

public java.lang.Object getValue(int row,
                                 int col)
                          throws java.lang.Exception

The value for this row/col

Parameters:

row - offset from 1

col - offset from 1

Returns:

The value

Throws:

java.lang.Exception - a serious problem

getRecordID

public java.lang.String getRecordID(int row)

The record ID for this row

Parameters:

row - offset from 1

Returns:

The record ID