/**
     * Gets Persons by PersonFilter.
     *
     * @param PersonFilter $personFilter
     * @return array of DibiRow Objects
     */
    public function getPersonsByFilter(PersonFilter $personFilter)
    {
        $textValues = array("EID" => "ID", "Surname" => "Surname", "Name" => "Firstname");
        $selectValues = array("Group_ID" => "GroupID", "CostCenter" => "CostCenterID");

        $db_result = $this->conn
                ->select('*')
                ->from('[Person]');

        foreach ($textValues as $dbKey => $key)
            $db_result->where("[$dbKey] LIKE %~like~", $personFilter->$key);

        foreach ($selectValues as $dbKey => $key)
            if ($personFilter->$key)
                $db_result->where("[$dbKey] = %i", $personFilter->$key);

        return $db_result->fetchAll();
    }