Documentation

GdriveComponent extends InfiniteReportComponent
in package

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  = ['country.two', 'YEAR(entry.startDate)', 'MONTH(entry.startDate)', 'entry.startDate', 'entry.endDate', 'entry.reportTypeId', 'entryReport.createTime', 'entryReport.generateDoneDateTime']
defaultOrder  = ['entryReport.id' => 'ASC']
exportColumns  = []
fetchAsArray  = 2
fetchAsBuilder  = 0
fetchAsClass  = 10
fetchAsComplex  = 6
fetchAsDefault  = 10
fetchAsResult  = 1
fetchAsSimple  = 5
filterFormClass  = \Vatjar\Report\Form\ReportFilterForm::class
GDRIVE_API_REQUEST_DIR_NAME  = 'vatjar_api_requests'
GDRIVE_REPORTS_DIRECTORY_NAME  = 'vatjar_reports'
GDRIVE_USERS_VATLIST  = 'vatjar_user_vatlist'
havingCondition  = []
HOME_DEFAULT  = 'default'
infinitRowClass  = \Vatjar\Report\Model\InfinitReportRow::class
OLD_FILES_DAYS  = 7
pageSize  = 100
REPORT_LIMIT  = false
whereCondition  = [ // 'userList' => 'FIND_IN_SET(entry.userId, :user_id:)', 'country_id' => ' FIND_IN_SET(entry.countryId, :country_id:)', 'monthFrom' => ' entry.startDate >= :monthFrom:', 'monthTo' => ' entry.endDate <= :monthTo:', 'doneFrom' => ' entryReport.generateDoneDateTime >= :doneFrom:', 'doneTo' => ' entryReport.generateDoneDateTime <= :doneTo:', 'type' => ' entry.reportTypeId = :type:', // 'userId' => '(entry.userId = user.id OR user.permission IN (0,1,2))', // 'hasUserVat' => "entry.userId IS NOT NULL AND userVat.user_id IS NOT NULL", // 'noUserVat' => "userVat.user_id IS NULL", 'doneAt' => ' entryReport.generateDoneDateTime >= :doneAt:', ]

Properties

$filter  : Obj
$filterForm  : Form
$reportTypes  : mixed

Methods

__construct()  : array<string|int, mixed>
_build()  : mixed
_fetch()  : mixed
_fetchRow()  : mixed
_filter()  : Builder
emptyFilter()  : bool
formatList()  : mixed
formatRow()  : mixed
formatRowExport()  : mixed
generateExport()  : ExportXlsxComponent
getCacheKeyPartClassName()  : mixed
getCacheKeyPartUser()  : mixed
getColumns()  : mixed
getEncodedColumns()  : mixed
getExportFilename()  : mixed
getFilterPlusArray()  : array<string|int, mixed>
getHavingToPrepare()  : mixed
getHavingValueConditionBindType()  : mixed
getList()  : mixed
getOrder()  : mixed
getRawColumns()  : mixed
getReportTypes()  : mixed
getWhereToPrepare()  : mixed
getWhereValueConditionBindType()  : mixed
initializeFilter()  : mixed
page2offset()  : mixed
uploadList()  : mixed
getColumnOrder()  : array<string|int, mixed>
getDefaultOrder()  : array<string|int, mixed>

Constants

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 = ['country.two', 'YEAR(entry.startDate)', 'MONTH(entry.startDate)', 'entry.startDate', 'entry.endDate', 'entry.reportTypeId', 'entryReport.createTime', 'entryReport.generateDoneDateTime']

GDRIVE_API_REQUEST_DIR_NAME

public mixed GDRIVE_API_REQUEST_DIR_NAME = 'vatjar_api_requests'

GDRIVE_REPORTS_DIRECTORY_NAME

public mixed GDRIVE_REPORTS_DIRECTORY_NAME = 'vatjar_reports'

GDRIVE_USERS_VATLIST

public mixed GDRIVE_USERS_VATLIST = 'vatjar_user_vatlist'

whereCondition

public mixed whereCondition = [ // 'userList' => 'FIND_IN_SET(entry.userId, :user_id:)', 'country_id' => ' FIND_IN_SET(entry.countryId, :country_id:)', 'monthFrom' => ' entry.startDate >= :monthFrom:', 'monthTo' => ' entry.endDate <= :monthTo:', 'doneFrom' => ' entryReport.generateDoneDateTime >= :doneFrom:', 'doneTo' => ' entryReport.generateDoneDateTime <= :doneTo:', 'type' => ' entry.reportTypeId = :type:', // 'userId' => '(entry.userId = user.id OR user.permission IN (0,1,2))', // 'hasUserVat' => "entry.userId IS NOT NULL AND userVat.user_id IS NOT NULL", // 'noUserVat' => "userVat.user_id IS NULL", 'doneAt' => ' entryReport.generateDoneDateTime >= :doneAt:', ]

Properties

Methods

__construct()

public __construct([mixed $opt = [] ]) : array<string|int, mixed>
Parameters
$opt : 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> = []
Return values
Builder

formatList()

public formatList(mixed $list[, array<string|int, mixed> $opt = [] ]) : mixed
Parameters
$list : mixed
$opt : array<string|int, mixed> = []

getCacheKeyPartUser()

public getCacheKeyPartUser([int $userId = null ]) : mixed
Parameters
$userId : int = null

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

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

getWhereToPrepare()

public static getWhereToPrepare(mixed $params) : mixed
Parameters
$params : mixed

getWhereValueConditionBindType()

public static getWhereValueConditionBindType(mixed $name, mixed $value) : mixed
Parameters
$name : mixed
$value : mixed

initializeFilter()

public initializeFilter([mixed $opt = [] ]) : mixed
Parameters
$opt : mixed = []

page2offset()

public static page2offset([int $page = 1 ]) : mixed
Parameters
$page : int = 1

uploadList()

public uploadList(mixed $file, mixed $destination) : mixed
Parameters
$file : mixed
$destination : mixed

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> 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results