AirLay backend

DepartmentsExcelParser extends ExcelParser
in package

Table of Contents

ALLOWED_TYPE  = ['int', 'double', 'string', 'array', 'date', 'json', 'jsonArray']
parse()  : array<string|int, mixed>
convertDepartments()  : array<string|int, mixed>
convertValueToType()  : int|float|string|array<string|int, string>
createDataSetsMap()  : array<string|int, mixed>
createProperties()  : array<string|int, mixed>
createRelationsMap()  : array<string|int, mixed>
parseDataSets()  : array<string|int, mixed>
parseFile()  : array<string|int, mixed>
parseHeader()  : array<string|int, mixed>
parseRow()  : array<string|int, mixed>
splitStringToArray()  : array<string|int, mixed>

Constants

ALLOWED_TYPE

public mixed ALLOWED_TYPE = ['int', 'double', 'string', 'array', 'date', 'json', 'jsonArray']

Methods

parse()

public parse(string $filename) : array<string|int, mixed>
Parameters
$filename : string
Return values
array<string|int, mixed> —

convertDepartments()

private convertDepartments(array<string|int, mixed> $rawDepartments, mixed $dataSets) : array<string|int, mixed>
Parameters
$rawDepartments : array<string|int, mixed>
$dataSets : mixed
Return values
array<string|int, mixed> —

convertValueToType()

private convertValueToType(mixed $value, string $type) : int|float|string|array<string|int, string>
Parameters
$value : mixed
$type : string
Return values
int|float|string|array<string|int, string> —

createDataSetsMap()

private createDataSetsMap(mixed $dataSets) : array<string|int, mixed>
Parameters
$dataSets : mixed
Return values
array<string|int, mixed> —

createProperties()

private createProperties(array<string|int, mixed> $rawDepartment) : array<string|int, mixed>
Parameters
$rawDepartment : array<string|int, mixed>
Return values
array<string|int, mixed> —

createRelationsMap()

private createRelationsMap(array<string|int, mixed> $rawDepartments) : array<string|int, mixed>
Parameters
$rawDepartments : array<string|int, mixed>
Return values
array<string|int, mixed> —

parseDataSets()

private parseDataSets(string $filename) : array<string|int, mixed>
Parameters
$filename : string
Return values
array<string|int, mixed> —

parseFile()

private parseFile(string $filename) : array<string|int, mixed>
Parameters
$filename : string
Return values
array<string|int, mixed> —

parseHeader()

private parseHeader(array<string|int, mixed> $rawHeader) : array<string|int, mixed>
Parameters
$rawHeader : array<string|int, mixed>
Return values
array<string|int, mixed> —

parseRow()

private parseRow(array<string|int, mixed> $rawRow, array<string|int, mixed> $header) : array<string|int, mixed>
Parameters
$rawRow : array<string|int, mixed>
$header : array<string|int, mixed>
Return values
array<string|int, mixed> —

splitStringToArray()

private splitStringToArray(string $string) : array<string|int, mixed>
Parameters
$string : string
Return values
array<string|int, mixed> —

Search results