Documentation

DateValue extends WizardAbstract implements WizardInterface

Interfaces, Classes and Traits

WizardInterface

Table of Contents

EXPRESSIONS  = [PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_YESTERDAY => 'FLOOR(%s,1)=TODAY()-1', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_TODAY => 'FLOOR(%s,1)=TODAY()', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_TOMORROW => 'FLOOR(%s,1)=TODAY()+1', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_7_DAYS => 'AND(TODAY()-FLOOR(%s,1)<=6,FLOOR(%s,1)<=TODAY())', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_WEEK => 'AND(TODAY()-ROUNDDOWN(%s,0)>=(WEEKDAY(TODAY())),TODAY()-ROUNDDOWN(%s,0)<(WEEKDAY(TODAY())+7))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_THIS_WEEK => 'AND(TODAY()-ROUNDDOWN(%s,0)<=WEEKDAY(TODAY())-1,ROUNDDOWN(%s,0)-TODAY()<=7-WEEKDAY(TODAY()))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_NEXT_WEEK => 'AND(ROUNDDOWN(%s,0)-TODAY()>(7-WEEKDAY(TODAY())),ROUNDDOWN(%s,0)-TODAY()<(15-WEEKDAY(TODAY())))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_MONTH => 'AND(MONTH(%s)=MONTH(EDATE(TODAY(),0-1)),YEAR(%s)=YEAR(EDATE(TODAY(),0-1)))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_THIS_MONTH => 'AND(MONTH(%s)=MONTH(TODAY()),YEAR(%s)=YEAR(TODAY()))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_NEXT_MONTH => 'AND(MONTH(%s)=MONTH(EDATE(TODAY(),0+1)),YEAR(%s)=YEAR(EDATE(TODAY(),0+1)))']
MAGIC_OPERATIONS  = ['yesterday' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_YESTERDAY, 'today' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_TODAY, 'tomorrow' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_TOMORROW, 'lastSevenDays' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_7_DAYS, 'last7Days' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_7_DAYS, 'lastWeek' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_WEEK, 'thisWeek' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_THIS_WEEK, 'nextWeek' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_NEXT_WEEK, 'lastMonth' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_MONTH, 'thisMonth' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_THIS_MONTH, 'nextMonth' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_NEXT_MONTH]
$cellRange  : string
$expression  : string
$operator  : string
$referenceCell  : string
$referenceColumn  : int
$referenceRow  : int
$stopIfTrue  : bool
$style  : Style|null
__call()  : self
__construct()  : mixed
fromConditional()  : WizardInterface
getCellRange()  : string
getConditional()  : Conditional
getStopIfTrue()  : bool
getStyle()  : Style
lastMonth()  :
lastSevenDays()  :
lastWeek()  :
nextMonth()  :
nextWeek()  :
reverseAdjustCellRef()  : string
setCellRange()  : void
setStopIfTrue()  : void
setStyle()  : void
thisMonth()  :
thisWeek()  :
today()  :
tomorrow()  :
yesterday()  :
adjustConditionsForCellReferences()  : array<string|int, mixed>
cellConditionCheck()  : string
conditionCellAdjustment()  : string
operator()  : void
reverseCellAdjustment()  : string
setExpression()  : void
setReferenceCellForExpressions()  : void
validateOperand()  : string

Constants

EXPRESSIONS

protected mixed EXPRESSIONS = [PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_YESTERDAY => 'FLOOR(%s,1)=TODAY()-1', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_TODAY => 'FLOOR(%s,1)=TODAY()', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_TOMORROW => 'FLOOR(%s,1)=TODAY()+1', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_7_DAYS => 'AND(TODAY()-FLOOR(%s,1)<=6,FLOOR(%s,1)<=TODAY())', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_WEEK => 'AND(TODAY()-ROUNDDOWN(%s,0)>=(WEEKDAY(TODAY())),TODAY()-ROUNDDOWN(%s,0)<(WEEKDAY(TODAY())+7))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_THIS_WEEK => 'AND(TODAY()-ROUNDDOWN(%s,0)<=WEEKDAY(TODAY())-1,ROUNDDOWN(%s,0)-TODAY()<=7-WEEKDAY(TODAY()))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_NEXT_WEEK => 'AND(ROUNDDOWN(%s,0)-TODAY()>(7-WEEKDAY(TODAY())),ROUNDDOWN(%s,0)-TODAY()<(15-WEEKDAY(TODAY())))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_MONTH => 'AND(MONTH(%s)=MONTH(EDATE(TODAY(),0-1)),YEAR(%s)=YEAR(EDATE(TODAY(),0-1)))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_THIS_MONTH => 'AND(MONTH(%s)=MONTH(TODAY()),YEAR(%s)=YEAR(TODAY()))', PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_NEXT_MONTH => 'AND(MONTH(%s)=MONTH(EDATE(TODAY(),0+1)),YEAR(%s)=YEAR(EDATE(TODAY(),0+1)))']

MAGIC_OPERATIONS

protected mixed MAGIC_OPERATIONS = ['yesterday' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_YESTERDAY, 'today' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_TODAY, 'tomorrow' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_TOMORROW, 'lastSevenDays' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_7_DAYS, 'last7Days' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_7_DAYS, 'lastWeek' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_WEEK, 'thisWeek' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_THIS_WEEK, 'nextWeek' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_NEXT_WEEK, 'lastMonth' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_LAST_MONTH, 'thisMonth' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_THIS_MONTH, 'nextMonth' => PhpOfficePhpSpreadsheetStyleConditional::TIMEPERIOD_NEXT_MONTH]

Properties

Methods

__call()

public __call(string $methodName, array<string|int, mixed> $arguments) : self
Parameters
$methodName : string
$arguments : array<string|int, mixed>
Return values
self —

__construct()

public __construct(string $cellRange) : mixed
Parameters
$cellRange : string
Return values
mixed —

getCellRange()

public getCellRange() : string
Return values
string —

getStopIfTrue()

public getStopIfTrue() : bool
Return values
bool —

lastMonth()

public lastMonth() :
Return values
—

lastSevenDays()

public lastSevenDays() :
Return values
—

lastWeek()

public lastWeek() :
Return values
—

nextMonth()

public nextMonth() :
Return values
—

nextWeek()

public nextWeek() :
Return values
—

reverseAdjustCellRef()

public static reverseAdjustCellRef(string $condition, string $cellRange) : string
Parameters
$condition : string
$cellRange : string
Return values
string —

setCellRange()

public setCellRange(string $cellRange) : void
Parameters
$cellRange : string
Return values
void —

setStopIfTrue()

public setStopIfTrue(bool $stopIfTrue) : void
Parameters
$stopIfTrue : bool
Return values
void —

thisMonth()

public thisMonth() :
Return values
—

thisWeek()

public thisWeek() :
Return values
—

tomorrow()

public tomorrow() :
Return values
—

yesterday()

public yesterday() :
Return values
—

adjustConditionsForCellReferences()

protected adjustConditionsForCellReferences(array<string|int, mixed> $conditions) : array<string|int, mixed>
Parameters
$conditions : array<string|int, mixed>
Return values
array<string|int, mixed> —

cellConditionCheck()

protected cellConditionCheck(string $condition) : string
Parameters
$condition : string
Return values
string —

conditionCellAdjustment()

protected conditionCellAdjustment(array<string|int, mixed> $matches) : string
Parameters
$matches : array<string|int, mixed>
Return values
string —

operator()

protected operator(string $operator) : void
Parameters
$operator : string
Return values
void —

reverseCellAdjustment()

protected static reverseCellAdjustment(array<string|int, mixed> $matches, int $referenceColumn, int $referenceRow) : string
Parameters
$matches : array<string|int, mixed>
$referenceColumn : int
$referenceRow : int
Return values
string —

setExpression()

protected setExpression() : void
Return values
void —

setReferenceCellForExpressions()

protected setReferenceCellForExpressions(string $conditionalRange) : void
Parameters
$conditionalRange : string
Return values
void —

validateOperand()

protected validateOperand(string $operand[, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : string
Parameters
$operand : string
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
string —

Search results