Serialize\ExcelSerializer::serializeData()

Complexity

Conditions	8
Paths	14

Size

Total Lines	37
Code Lines	23

Duplication

Lines	8
Ratio	21.62 %

Importance

Changes	2
Bugs	1	Features	1

<?php
    public function serializeData($type, $array)
    {
        if($this->supportsType($type) === false)
        {
            return null;
        }
        if(count($array) === 0)
        {
            return null;
        }
        $data = $this->getArray($array);
        $ssheat = new \PHPExcel();
        $sheat = $ssheat->setActiveSheetIndex(0);
        $keys = array_shift($data);
        $rowCount = count($data);
        $colCount = count($keys);
        for($i = 0; $i < $colCount; $i++)

This code seems to be duplicated across your project.

        {
            $sheat->setCellValueByColumnAndRow($i, 1, $keys[$i]);
        }
        for($i = 0; $i < $rowCount; $i++)
        {
            for($j = 0; $j < $colCount; $j++)

This code seems to be duplicated across your project.

            {
                $sheat->setCellValueByColumnAndRow($j, (2 + $i), $data[$i][$j]);
            }
        }
        $writerType = 'Excel5';
        if(strcasecmp($type, 'xlsx') === 0 || strcasecmp($type, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') === 0)
        {
            $writerType = 'Excel2007';
        }
        $writer = \PHPExcel_IOFactory::createWriter($ssheat, $writerType);
        ob_start();
        $writer->save('php://output');
        return ob_get_clean();
    }
}