Table of Contents
Constants
-
bindType
= ['user_id' => \Phalcon\Db\Column::BIND_PARAM_INT, 'offset' => \Phalcon\Db\Column::BIND_PARAM_INT, 'limit' => \Phalcon\Db\Column::BIND_PARAM_INT]
-
columnOrder
= ['1', '_ai.event_date', '_ai.value_eur', '5', '_ai.to_country_id', '6']
-
defaultOrder
= [
'_ai.event_date' => 'DESC',
// '1' => 'ASC',
'_ai.value_eur' => 'DESC',
// '5' => 'ASC',
'_ai.to_country_id' => 'ASC',
// '6' => 'ASC',
"_ai.id" => "ASC",
]
-
fetchAsArray
= 2
-
fetchAsBuilder
= 0
-
fetchAsClass
= 10
-
fetchAsComplex
= 6
-
fetchAsDefault
= 10
-
fetchAsResult
= 1
-
fetchAsSimple
= 5
-
filterFormClass
= \Vatjar\Movement\Form\MovementFilterForm::class
-
havingCondition
= []
-
infinitRowClass
= \Vatjar\Movement\Component\InfinitActivityInvoiceRow::class
-
pageSize
= 100
-
whereCondition
= ['userId' => '_ai.user_id = :userId:', 'user_module_id' => '_ai.user_module_id = :user_module_id:', 'transid' => '_ai.transid like :transid:', 'fromCountryId' => '_ai.from_country_id = :fromCountryId:', 'vatCountryId' => '_ai.vat_country_id = :vatCountryId:', 'toCountryId' => '_ai.to_country_id = :toCountryId: ', 'fromDate' => '_ai.event_date >= :fromDate: ', 'toDate' => '_ai.event_date <= :toDate: ', 'type' => '_ai.source_type = :type: ', 'invoiceSource' => '_ai.module_id = :invoiceSource:', 'hasZeroValue' => '(((_ai.value IS NULL) AND (_ai.value_eur IS NULL))
OR (_ai.currency_id IS NULL AND (_ai.value_eur IS NULL)))', 'hasError' => '((_ai.min_status_code < -1) OR (_ai.min_status_code = 0))', 'errorReason' => '_ai.min_status_code = :errorReason:', 'creditNote' => '_ai.credit_note = :creditNote:', 'isInvoice' => '_ai.is_invoice = :isInvoice:']
Properties
-
$filter
: Obj
-
$filterForm
: Form
-
$classActivityInvoice
: mixed
Methods
-
__construct()
: array<string|int, mixed>
-
_build()
: mixed
-
_fetch()
: mixed
-
_fetchRow()
: mixed
-
_filter()
: Builder
-
emptyFilter()
: bool
-
formatList()
: mixed
-
formatRow()
: mixed
-
getCacheKeyPartClassName()
: mixed
-
getCacheKeyPartUser()
: mixed
-
getColorClass()
: mixed
-
getColumns()
: mixed
-
getEncodedColumns()
: mixed
-
getFilterPlusArray()
: array<string|int, mixed>
-
getHavingToPrepare()
: mixed
-
getHavingValueConditionBindType()
: mixed
-
getLink()
: mixed
-
getList()
: mixed
-
getOrder()
: mixed
-
getRawColumns()
: mixed
-
getRemovableLink()
: mixed
-
getWhereToPrepare()
: mixed
-
getWhereValueConditionBindType()
: mixed
-
hasError()
: mixed
-
initializeFilter()
: mixed
-
isRemovable()
: mixed
-
page2offset()
: mixed
-
getColumnOrder()
: array<string|int, mixed>
-
getDefaultOrder()
: array<string|int, mixed>
bindType
public
mixed
bindType
= ['user_id' => \Phalcon\Db\Column::BIND_PARAM_INT, 'offset' => \Phalcon\Db\Column::BIND_PARAM_INT, 'limit' => \Phalcon\Db\Column::BIND_PARAM_INT]
columnOrder
public
mixed
columnOrder
= ['1', '_ai.event_date', '_ai.value_eur', '5', '_ai.to_country_id', '6']
defaultOrder
public
mixed
defaultOrder
= [
'_ai.event_date' => 'DESC',
// '1' => 'ASC',
'_ai.value_eur' => 'DESC',
// '5' => 'ASC',
'_ai.to_country_id' => 'ASC',
// '6' => 'ASC',
"_ai.id" => "ASC",
]
fetchAsArray
public
mixed
fetchAsArray
= 2
fetchAsBuilder
public
mixed
fetchAsBuilder
= 0
fetchAsClass
public
mixed
fetchAsClass
= 10
fetchAsComplex
public
mixed
fetchAsComplex
= 6
fetchAsDefault
public
mixed
fetchAsDefault
= 10
fetchAsResult
public
mixed
fetchAsResult
= 1
fetchAsSimple
public
mixed
fetchAsSimple
= 5
public
mixed
filterFormClass
= \Vatjar\Movement\Form\MovementFilterForm::class
havingCondition
public
mixed
havingCondition
= []
infinitRowClass
public
mixed
infinitRowClass
= \Vatjar\Movement\Component\InfinitActivityInvoiceRow::class
pageSize
public
mixed
pageSize
= 100
whereCondition
public
mixed
whereCondition
= ['userId' => '_ai.user_id = :userId:', 'user_module_id' => '_ai.user_module_id = :user_module_id:', 'transid' => '_ai.transid like :transid:', 'fromCountryId' => '_ai.from_country_id = :fromCountryId:', 'vatCountryId' => '_ai.vat_country_id = :vatCountryId:', 'toCountryId' => '_ai.to_country_id = :toCountryId: ', 'fromDate' => '_ai.event_date >= :fromDate: ', 'toDate' => '_ai.event_date <= :toDate: ', 'type' => '_ai.source_type = :type: ', 'invoiceSource' => '_ai.module_id = :invoiceSource:', 'hasZeroValue' => '(((_ai.value IS NULL) AND (_ai.value_eur IS NULL))
OR (_ai.currency_id IS NULL AND (_ai.value_eur IS NULL)))', 'hasError' => '((_ai.min_status_code < -1) OR (_ai.min_status_code = 0))', 'errorReason' => '_ai.min_status_code = :errorReason:', 'creditNote' => '_ai.credit_note = :creditNote:', 'isInvoice' => '_ai.is_invoice = :isInvoice:']
$filter
public
Obj
$filter
public
Form
$filterForm
$classActivityInvoice
private
mixed
$classActivityInvoice
__construct()
public
__construct([array<string|int, mixed> $opt = [] ]) : array<string|int, mixed>
Parameters
-
$opt
: array<string|int, mixed>
= []
-
Return values
array<string|int, mixed>
_build()
public
_build([array<string|int, mixed> $opt = [] ]) : mixed
Parameters
-
$opt
: array<string|int, mixed>
= []
-
_fetch()
public
_fetch(Builder $builder[, array<string|int, mixed> $opt = [] ]) : mixed
Parameters
-
$builder
: Builder
-
-
$opt
: array<string|int, mixed>
= []
-
_fetchRow()
public
static _fetchRow(mixed $row, mixed $mode) : mixed
Parameters
-
$row
: mixed
-
-
$mode
: mixed
-
_filter()
public
_filter(Builder $builder[, array<string|int, mixed> $opt = [] ]) : Builder
Parameters
-
$builder
: Builder
-
-
$opt
: array<string|int, mixed>
= []
-
emptyFilter()
public
emptyFilter() : bool
public
formatList(mixed $list[, array<string|int, mixed> $opt = [] ]) : mixed
Parameters
-
$list
: mixed
-
-
$opt
: array<string|int, mixed>
= []
-
public
formatRow(InfinitRow $row) : mixed
Parameters
-
$row
: InfinitRow
-
getCacheKeyPartClassName()
public
getCacheKeyPartClassName() : mixed
getCacheKeyPartUser()
public
getCacheKeyPartUser([int $userId = null ]) : mixed
Parameters
-
$userId
: int
= null
-
getColorClass()
public
static getColorClass(mixed $row) : mixed
Parameters
-
$row
: mixed
-
getColumns()
public
getColumns([mixed $opt = [] ]) : mixed
Parameters
-
$opt
: mixed
= []
-
getEncodedColumns()
public
getEncodedColumns([mixed $opt = [] ]) : mixed
Parameters
-
$opt
: mixed
= []
-
getFilterPlusArray()
public
getFilterPlusArray() : array<string|int, mixed>
Return values
array<string|int, mixed>
getHavingToPrepare()
public
static getHavingToPrepare(mixed $params) : mixed
Parameters
-
$params
: mixed
-
getHavingValueConditionBindType()
public
static getHavingValueConditionBindType(mixed $name, mixed $value) : mixed
Parameters
-
$name
: mixed
-
-
$value
: mixed
-
getLink()
public
getLink(mixed $activity) : mixed
Parameters
-
$activity
: mixed
-
getList()
public
getList([array<string|int, mixed> $opt = [] ]) : mixed
Parameters
-
$opt
: array<string|int, mixed>
= []
-
getOrder()
public
static getOrder([mixed $order = null ]) : mixed
Parameters
-
$order
: mixed
= null
-
getRawColumns()
public
getRawColumns([mixed $opt = [] ]) : mixed
Parameters
-
$opt
: mixed
= []
-
getRemovableLink()
public
getRemovableLink(mixed $row, mixed $activity) : mixed
Parameters
-
$row
: mixed
-
-
$activity
: mixed
-
getWhereToPrepare()
public
static getWhereToPrepare(mixed $params) : mixed
Parameters
-
$params
: mixed
-
getWhereValueConditionBindType()
public
static getWhereValueConditionBindType(mixed $name, mixed $value) : mixed
Parameters
-
$name
: mixed
-
-
$value
: mixed
-
hasError()
public
static hasError(mixed $row) : mixed
Parameters
-
$row
: mixed
-
initializeFilter()
public
initializeFilter([mixed $opt = [] ]) : mixed
Parameters
-
$opt
: mixed
= []
-
isRemovable()
public
isRemovable(mixed $row) : mixed
Parameters
-
$row
: mixed
-
page2offset()
public
static page2offset([int $page = 1 ]) : mixed
Parameters
-
$page
: int
= 1
-
getColumnOrder()
protected
static getColumnOrder() : array<string|int, mixed>
Return values
array<string|int, mixed>
getDefaultOrder()
protected
static getDefaultOrder() : array<string|int, mixed>
Return values
array<string|int, mixed>