Serialize\SpreadSheetSerializer

Complexity

Total Complexity

22

Size/Duplication

Total Lines	109
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes	2
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	getRowArray()	0	12	3
A	getKeysFromData()	0	13	3
A	prependAndMergeKeys()	0	8	2
C	addValueByColName()	0	47	10
B	getArray()	0	22	4

<?php
namespace Serialize;

abstract class SpreadSheetSerializer extends Serializer
{
    private function getKeysFromData($array)

This method is not used, and could be removed.

    {
        $first = reset($array);
        if(is_array($first))
        {
            return array_keys($first);
        }
        else if(is_object($first))
        {
            return array_keys(get_object_vars($first));
        }
        return false;
    }

    private function getRowArray($row)
    {
        if(is_object($row))
        {
            return get_object_vars($row);
        }
        if(!is_array($row))
        {
            return array($row);
        }
        return $row;
    }

    private function prependAndMergeKeys(&$keys, $prefix, $newKeys)

This method is not used, and could be removed.

    {
        foreach($newKeys as &$key)
        {
            $key = $prefix.$key;
        }
        $keys = array_unique(array_merge($keys, $newKeys));
    }

    protected function addValueByColName(&$cols, &$row, $colName, $value)
    {
        if(is_object($value))
        {
            switch($colName)
            {
                case '_id':
                    if(isset($value->{'$id'}))
                    {
                        $this->addValueByColName($cols, $row, $colName, $value->{'$id'});
                        break;
                    }
                default:
                    $props = get_object_vars($value);
                    foreach($props as $key=>$newValue)
                    {
                        $this->addValueByColName($cols, $row, $colName.'.'.$key, $newValue);
                    }
            }
            return;
        }
        $index = array_search($colName, $cols);
        if($index === false)
        {
            $index = count($cols);
            $cols[$index] = $colName;
        }
        if(is_array($value))
        {
            if(isset($value[0]) && is_object($value[0]))
            {
                $count = count($value);
                for($i = 0; $i < $count; $i++)
                {
                    $this->addValueByColName($cols, $row, $colName.'['.$i.']', $value[$i]);
                }
            }
            else
            {
                $row[$index] = implode(',', $value);
            }
        }
        else
        {
            $row[$index] = $value;
        }
    }

    protected function getArray(&$array)
    {
        $res = array();
        if(is_object($array))
        {
            $array = array(get_object_vars($array));
        }
        $res[] = array();
        foreach($array as $row)
        {
            $tmp = array();
            $row = $this->getRowArray($row);
            foreach($row as $colName=>$value)
            {
                $this->addValueByColName($res[0], $tmp, $colName, $row[$colName]);
            }
            $tmp = $tmp+array_fill_keys(range(0,max(array_keys($tmp))),false);
            ksort($tmp);
            $res[] = $tmp;
        }
        return $res;
    }
}