Documentation

VatReportGeneratorComponent extends AbstractVatEcReportGeneratorComponent
in package

Table of Contents

Constants

LIST_HEAD  = ['TRANS_DATE', 'VAT_TYPE', 'AMZ_TYPE', 'TRANS_TYPE', 'SALES_CHANNEL', 'EVENT_ID', 'QTY_VALUE', 'NET_VALUE', 'VAT_VALUE', 'VAT_RATE', 'GROSS_VALUE', 'CURR_EXC_RATE', 'ORG_CURR', 'DEPARTURE', 'ARRIVAL']
REPORT_EXTENSION  = 'xlsx'
REPORT_HEAD  = ['REPORT_NAME', 'COUNTRY', 'FROM', 'TO', 'CURRENCY', 'VAT_ID', 'COMPANY']
REPORT_HEAD_FILENAME  = ''
REPORT_NAME  = 'VAT REPORT SUMMARY'
REPORT_TYPE_NAME  = 'vat'
ROLL_REF  = ['DOMV' => [], 'DOMREV' => 0, 'DSF' => 0, 'DST' => [], 'ECA' => [], 'ECS' => 0, 'EXP' => [], 'IMP' => 0]
ROLL_SUM  = ['DOMV' => [], 'DOMREV' => 0, 'DSF' => 0, 'DST' => [], 'ECA' => [], 'ECS' => 0, 'EXP' => [], 'IMP' => 0]
SQL_VAT_LIST  = 'vat'
SQL_VAT_SUM_HEAD  = 'vat_head'
SQLDIR  = APP_PATH . 'Report' . DS . 'sql' . DS
SUM_HEAD  = ['VAT_TYPE', 'NET_VALUE', 'VAT_VALUE', 'VAT_RATE', 'GROSS_VALUE']

Properties

$report  : mixed

Methods

__construct()  : mixed
buildSum()  : mixed
createGenerator()  : mixed
done()  : mixed
formatListAndGenerateSummary()  : mixed
generate()  : mixed
getFilename()  : mixed
getFullFilename()  : mixed
getRawSqlFile()  : mixed
getReportDataFor()  : mixed
getReportDataSql()  : mixed
getReportSummaryHeadFor()  : mixed
getReportSummaryHeadSql()  : mixed
getSqlFile()  : mixed
getStorageFilename()  : mixed
prepareSaveDir()  : mixed
add2SumOrRef()  : mixed
formatSum()  : mixed

Constants

LIST_HEAD

public mixed LIST_HEAD = ['TRANS_DATE', 'VAT_TYPE', 'AMZ_TYPE', 'TRANS_TYPE', 'SALES_CHANNEL', 'EVENT_ID', 'QTY_VALUE', 'NET_VALUE', 'VAT_VALUE', 'VAT_RATE', 'GROSS_VALUE', 'CURR_EXC_RATE', 'ORG_CURR', 'DEPARTURE', 'ARRIVAL']

ROLL_REF

public mixed ROLL_REF = ['DOMV' => [], 'DOMREV' => 0, 'DSF' => 0, 'DST' => [], 'ECA' => [], 'ECS' => 0, 'EXP' => [], 'IMP' => 0]

ROLL_SUM

public mixed ROLL_SUM = ['DOMV' => [], 'DOMREV' => 0, 'DSF' => 0, 'DST' => [], 'ECA' => [], 'ECS' => 0, 'EXP' => [], 'IMP' => 0]

Properties

Methods

createGenerator()

public static createGenerator(Report $report[, array<string|int, mixed> $opt = [] ]) : mixed
Parameters
$report : Report
$opt : array<string|int, mixed> = []

formatListAndGenerateSummary()

public static formatListAndGenerateSummary(mixed &$list) : mixed
Parameters
$list : mixed

getRawSqlFile()

public static getRawSqlFile(mixed $filename) : mixed
Parameters
$filename : mixed

getReportDataFor()

public static getReportDataFor(mixed $db, int $user_id, int $country, int $month) : mixed
Parameters
$db : mixed
$user_id : int
$country : int
$month : int

getReportSummaryHeadFor()

public static getReportSummaryHeadFor(mixed $db, int $user_id, int $country, int $month) : mixed
Parameters
$db : mixed
$user_id : int
$country : int
$month : int

getSqlFile()

public static getSqlFile(mixed $filename) : mixed
Parameters
$filename : mixed

getStorageFilename()

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

add2SumOrRef()

private static add2SumOrRef(mixed $l, mixed &$s, mixed &$r) : mixed
Parameters
$l : mixed
$s : mixed
$r : mixed

        
On this page

Search results