• 홈
• Kimai_Export_ExcelExporter

PHP 클래스 Kimai_Export_ExcelExporter

파일 보기 프로젝트 열기: kimai/kimai 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
$columns_dict	array	dictionary value: column name as in extensions/ki_export/templates/scripts/main.php key: true if active, else false
$customTimeformat	string	strftime format string for fields of type time
$exportData_arr	array	the data rows to be exported
$kga	array	Kimai Global Array

보호된 프로퍼티들

프로퍼티	타입	설명
$COLUMN_CONFIG	array	Column configuration: columns_dict> => [ 'fieldName' => exportData_arr - defaults to the same field name as in $this->columns> 'type' => 'langLabel' => kga['lang'] - defaults to the same as the field name in $this->columns> 'sum' => boolean - if true, sums will be generated for this field ]
$activeColumns_arr	array	contains names (as in $this->columns_dict) of active columns
$anySumsWereAdded	boolean	true, if there are any active columns with sums, else false
$dateFormat	string	excel format string for fields of type date
$sheet	PHPExcel_Worksheet	the first (and only) worksheet
$timeFormat	string	excel format string for fields of type time

공개 메소드들

메소드	설명
render ( array $kga, array $exportData_arr, array $columns_dict, string $customTimeformat )	generates an .xlsx file containing time sheets to be exported the file will be sent to the browser for download/viewing

보호된 메소드들

메소드	설명
addCellBorders ( )	add cell borders
doLayouting ( )	do layouting (cell borders, font styles, background colors, cell sizing, page setup)
excelAddr ( integer $x, integer $y ) : string	get excel field address by supplying coordinates (e.g. '1/1' becomes 'B2')
excelColumnAddr ( integer $n ) : string	get excel column letter by index (e.g. '2' becomes 'C') using this over PHPExcels built-in methods, because they are partly 1-based instead of 0-based
excelRange ( $x1, $y1, $x2, $y2 ) : string	get excel field range by supplying coordinates
formatDataRowsByType ( )	cell formatting (number/text/date .
formatHeaders ( )	format the headers (additional cell borders, background color, alignment)
formatSums ( )	format the sums row if there are any sums (borders and background color)
initialize ( )	initial PHPExcel settings; build $this->activeColumns_arr
renderExcel ( )	renders the excel and sends it to the browser
writeDataRows ( )	write the data rows for all active columns
writeHeaders ( )	write the headers for all active columns
writeSums ( )	write sums for active columns only if configured in self::$COLUMN_CONFIG

메소드 상세

프로퍼티 상세