Documentation

ActivityInvoiceInfiniteDAO

in package

• Application

Table of Contents

Constants

columns  = ['_ai.*']

defaultLimit  = 100

defaultOffset  = 0

defaultOrder  = ['event_date' => 'DESC', 'transid' => 'ASC', 'value_eur' => 'DESC', 'from_country_id' => 'ASC', 'to_country_id' => 'ASC', 'vat_country_id' => 'ASC', "id" => "ASC"]

orderColumns  = ['trans_id' => '_ai.transid', 'event_date' => '_ai.event_date', 'value' => '_ai.value_eur', 'invoice_source' => '_ai.invoice_source', 'from_country_id' => '_fc.two', 'to_country_id' => '_tc.two', 'vat_country_id' => '_vc.two', 'channel_id' => '_ai.channel_id']

specialWhereCondition  = ['type' => [1 => '_ai.movement_perspective_id = 1 AND _ai.movement_class_id = 1 AND _ai.credit_note = 0', 2 => '_ai.movement_perspective_id = 2 AND _ai.movement_class_id = 1 AND _ai.credit_note = 0', 3 => '_ai.movement_perspective_id = 1 AND _ai.movement_class_id = 1 AND _ai.credit_note = 1', 4 => '_ai.movement_perspective_id = 2 AND _ai.movement_class_id = 1 AND _ai.credit_note = 1', 5 => '_ai.movement_class_id = 2', 6 => '_ai.source_type = 12', 7 => '_ai.source_type = 14', 8 => '_ai.source_type = 13', 9 => '_ai.movement_class_id = 2 AND _ai.module_id = 2', 35 => '_ai.source_type = 35', 36 => '_ai.source_type = 36'], 'has_zero_value' => [1 => '(_ai.value_eur IS NULL OR _ai.value IS NULL)', true => '(_ai.value_eur IS NULL OR _ai.value IS NULL)', 'true' => '(_ai.value_eur IS NULL OR _ai.value IS NULL)'], 'has_error' => [1 => '(((min_status_code < -1) and (min_status_code <> -2)) OR (has_status_code_null = 1))', true => '(((min_status_code < -1) and (min_status_code <> -2)) OR (has_status_code_null = 1))', 'true' => '(((min_status_code < -1) and (min_status_code <> -2)) OR (has_status_code_null = 1))'], 'has_missing_product' => [1 => 'has_missing_product = 1', true => 'has_missing_product = 1', 'true' => 'has_missing_product = 1']]

1 = sale 2 = expense 3 = refund given 4 = refund recieved 5 = Assets Movement 6 = FC Transfer 7 = Return 8 = Inbound 9 = Assets Movement Manual Upload

whereCondition  = ['user_id' => '_ai.user_id = :user_id:', 'trans_id' => '_ai.transid like :trans_id:', 'from_country_id' => '_ai.from_country_id = :from_country_id:', 'vat_country_id' => '_ai.vat_country_id = :vat_country_id:', 'to_country_id' => '_ai.to_country_id = :to_country_id: ', 'from_date' => '_ai.event_date >= :from_date: ', 'to_date' => '_ai.event_date <= :to_date: ', 'movement_type_id' => '_ai.movement_type_id = :type: ', 'module_id' => '_ai.module_id = :invoice_source:', 'user_module_id' => '_ai.user_module_id = :user_module_id:', 'activity_invoice_id' => '_ai.id = :activity_invoice_id:', 'source_type' => '_ai.source_type = :source_type:', 'channel_id' => '_ai.channel_id = :channel_id:']

Properties

$filters  : mixed

Methods

findAllByFilterLimitOffset()  : array<string|int, ActivityInvoice>

getActivityInvoiceList()  : Simple|null

getBindParams()  : array<string|int, mixed>|null

getBindTypes()  : array<string|int, mixed>|null

getLimit()  : int|null

getOffset()  : int|null

getOrder()  : string|null

getWhere()  : string|null

setBindParamsAndBindTypes()  : void

setFilters()  : void

setLimit()  : void

setOffset()  : void

setOrder()  : void

setWhere()  : void