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
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']
REPORT_EXTENSION
public
mixed
REPORT_EXTENSION
= 'xlsx'
REPORT_HEAD
public
mixed
REPORT_HEAD
= ['REPORT_NAME', 'COUNTRY', 'FROM', 'TO', 'CURRENCY', 'VAT_ID', 'COMPANY']
REPORT_HEAD_FILENAME
public
mixed
REPORT_HEAD_FILENAME
= ''
REPORT_NAME
public
mixed
REPORT_NAME
= 'VAT REPORT SUMMARY'
REPORT_TYPE_NAME
public
mixed
REPORT_TYPE_NAME
= 'vat'
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]
SQL_VAT_LIST
public
mixed
SQL_VAT_LIST
= 'vat'
SQL_VAT_SUM_HEAD
public
mixed
SQL_VAT_SUM_HEAD
= 'vat_head'
SQLDIR
public
mixed
SQLDIR
= APP_PATH . 'Report' . DS . 'sql' . DS
SUM_HEAD
public
mixed
SUM_HEAD
= ['VAT_TYPE', 'NET_VALUE', 'VAT_VALUE', 'VAT_RATE', 'GROSS_VALUE']
$report
public
mixed
$report
__construct()
public
__construct(Report $report[, array<string|int, mixed> $opt = [] ]) : mixed
Parameters
-
$report
: Report
-
-
$opt
: array<string|int, mixed>
= []
-
buildSum()
public
static buildSum(mixed $h, mixed $sumList) : mixed
Parameters
-
$h
: mixed
-
-
$sumList
: mixed
-
createGenerator()
public
static createGenerator(Report $report[, array<string|int, mixed> $opt = [] ]) : mixed
Parameters
-
$report
: Report
-
-
$opt
: array<string|int, mixed>
= []
-
done()
public
done() : mixed
public
static formatListAndGenerateSummary(mixed &$list) : mixed
Parameters
-
$list
: mixed
-
generate()
public
generate() : mixed
getFilename()
public
getFilename([mixed $opt = [] ]) : mixed
Parameters
-
$opt
: mixed
= []
-
getFullFilename()
public
getFullFilename([mixed $opt = [] ]) : mixed
Parameters
-
$opt
: 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
-
getReportDataSql()
public
static getReportDataSql() : mixed
getReportSummaryHeadFor()
public
static getReportSummaryHeadFor(mixed $db, int $user_id, int $country, int $month) : mixed
Parameters
-
$db
: mixed
-
-
$user_id
: int
-
-
$country
: int
-
-
$month
: int
-
getReportSummaryHeadSql()
public
static getReportSummaryHeadSql() : mixed
getSqlFile()
public
static getSqlFile(mixed $filename) : mixed
Parameters
-
$filename
: mixed
-
getStorageFilename()
public
getStorageFilename([mixed $opt = [] ]) : mixed
Parameters
-
$opt
: mixed
= []
-
prepareSaveDir()
public
prepareSaveDir([mixed $opt = [] ]) : mixed
Parameters
-
$opt
: mixed
= []
-
add2SumOrRef()
private
static add2SumOrRef(mixed $l, mixed &$s, mixed &$r) : mixed
Parameters
-
$l
: mixed
-
-
$s
: mixed
-
-
$r
: mixed
-
private
static formatSum(mixed $sum) : mixed
Parameters
-
$sum
: mixed
-