smindel / silverstripe-gis

src/ORM/MySQLGISSchemaManager.php

<?php

namespace Smindel\GIS\ORM;

use SilverStripe\ORM\Connect\MySQLSchemaManager;
use SilverStripe\ORM\DB;
use Smindel\GIS\GIS;

class MySQLGISSchemaManager extends MySQLSchemaManager
{
    use GISSchemaManager;

The trait Smindel\GIS\ORM\GISSchemaManager requires some properties which are not provided by Smindel\GIS\ORM\MySQLGISSchemaManager: $wkt, $srid

    public function geography($values)

The parameter $values is not used and could be removed.

    {
        // ATTENTION: GEOGRAPHY IS NOT SUPPORTED BY MYSQL. THIS IS STRICTLY FOR COMPATIBILITY
        return 'geometry';
    }

    public function translateStGeometryTypeFilter($field, $value, $inclusive)
    {
        $null = $inclusive ? '' : ' OR ' . DB::get_conn()->nullCheckClause($field, true);
        $fragment = sprintf(
            '%sLOWER(ST_GeometryType(%s)) = ?%s',
            $inclusive ? '' : 'NOT ',
            $field,
            $null
        );
        return [$fragment => strtolower($value)];
    }
}