Documentation

EcReportGeneratorComponent extends AbstractVatEcReportGeneratorComponent
in package

Table of Contents

Constants

LIST_HEAD  = ['ARRIVAL_COUNTRY', 'DEPARTURE_COUNTRY', 'NET_VALUE', 'VAT_ID_ARRIVAL', 'COMPANY_NAME_ARRIVAL', 'VAT_ID_DEPARTURE', 'COMPANY_NAME_DEPARTURE', 'WEIGHT', 'ASIN', 'COMM_CODE', 'QUANTITY', 'DATE', 'CURRENCY_EXCHANGE', 'ORG_CURRENCY', 'VAT_TYPE', 'AMZ_TYPE', 'ORDER_ID', 'RCP_NUMBER', 'PROD_FLAG']
REPORT_EXTENSION  = 'xlsx'
REPORT_HEAD  = ['REPORT_NAME', 'COUNTRY', 'FROM', 'TO', 'CURRENCY', 'VAT_ID', 'COMPANY']
REPORT_HEAD_FILENAME  = 'vat_head'
REPORT_NAME  = 'EC REPORT SUMMARY'
REPORT_TYPE_NAME  = 'ec'
ROLL_REF  = []
ROLL_SUM  = ['ECA' => [], 'ECS' => []]
SQLDIR  = APP_PATH . 'Report' . DS . 'sql' . DS
SUM_HEAD  = ['VAT_TYPE', 'NET_VALUE', 'DEPARTURE_COUNTRY', 'VAT_ID_DEPARTURE', 'COMPANY_NAME_DEPARTURE', 'ARRIVAL_COUNTRY', 'VAT_ID_ARRIVAL', 'COMPANY_NAME_ARRIVAL', 'DATE', 'ORDER_ID']

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
add2Sum()  : mixed
formatSum()  : mixed

Constants

LIST_HEAD

public mixed LIST_HEAD = ['ARRIVAL_COUNTRY', 'DEPARTURE_COUNTRY', 'NET_VALUE', 'VAT_ID_ARRIVAL', 'COMPANY_NAME_ARRIVAL', 'VAT_ID_DEPARTURE', 'COMPANY_NAME_DEPARTURE', 'WEIGHT', 'ASIN', 'COMM_CODE', 'QUANTITY', 'DATE', 'CURRENCY_EXCHANGE', 'ORG_CURRENCY', 'VAT_TYPE', 'AMZ_TYPE', 'ORDER_ID', 'RCP_NUMBER', 'PROD_FLAG']

REPORT_HEAD

public mixed REPORT_HEAD = ['REPORT_NAME', 'COUNTRY', 'FROM', 'TO', 'CURRENCY', 'VAT_ID', 'COMPANY']

SUM_HEAD

public mixed SUM_HEAD = ['VAT_TYPE', 'NET_VALUE', 'DEPARTURE_COUNTRY', 'VAT_ID_DEPARTURE', 'COMPANY_NAME_DEPARTURE', 'ARRIVAL_COUNTRY', 'VAT_ID_ARRIVAL', 'COMPANY_NAME_ARRIVAL', 'DATE', 'ORDER_ID']

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 = [] 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results