SimpleCrud\Fields\Point

Complexity

Total Complexity

7

Size/Duplication

Total Lines	51
Duplicated Lines	21.57 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getSelectExpression()	11	11	2
A	getValueExpression()	0	4	1
A	dataFromDatabase()	0	12	2
A	dataToDatabase()	0	6	2

<?php

namespace SimpleCrud\Fields;

use SimpleCrud\SimpleCrud;

/**
 * To slugify values before save.
 */
class Point extends Field
{
    /**
     * {@inheritdoc}
     */
    public function getSelectExpression($as = null)
    {
        $tableName = $this->table->getName();
        $fieldName = $this->name;

        if ($as) {
            return "asText(`{$tableName}`.`{$fieldName}`) as `{$as}`";
        }

        return "asText(`{$tableName}`.`{$fieldName}`) as `{$fieldName}`";
    }

    /**
     * {@inheritdoc}
     */
    public function getValueExpression($mark)
    {
        return "PointFromText($mark)";
    }

    /**
     * {@inheritdoc}
     */
    public function dataFromDatabase($data)
    {
        //POINT(X Y)
        if ($data !== null) {
            $points = explode(' ', substr($data, 6, -1), 2);

            return [
                floatval($points[0]),
                floatval($points[1]),
            ];
        }
    }

    /**
     * {@inheritdoc}
     */
    public function dataToDatabase($data)
    {
        if (is_array($data)) {
            return 'POINT('.implode(' ', $data).')';
        }
    }
}