/**
* Sheet data row
*
* @param LaravelExcelWorksheet $sheet
* @param int $index
* @param Project\Issue $issue
*
* @return void
*/
protected function sheetRow(LaravelExcelWorksheet $sheet, $index, Project\Issue $issue)
{
// Setup row data
array_walk($this->columns, function (&$column, $key, Project\Issue $issue) {
$column = (string) $issue->{$key};
if ($key === 'status') {
$column = (int) $issue->status === Project\Issue::STATUS_OPEN ? 'open' : 'closed';
$column = trans('tinyissue.' . $column);
}
}, $issue);
// Write row
$sheet->row($index, $this->columns);
// Format last cell
$sheet->cell('G' . $index, function (CellWriter $cell) use($issue) {
$color = (int) $issue->status === Project\Issue::STATUS_CLOSED ? '#FF0000' : '#00FF00';
$cell->setBackground($color);
});
}
