blocks|key|4495820|text|我之前实现的一个解决方法是在模型上使用以下验证的纬度和经度字段(请参阅Validator+class)：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4495821|$rules+=+array('latitude'+=>+'required%7Cnumeric%7Cbetween:-90,90',
++++++++++++++++++++++++++++'longitude'=>'required%7Cnumeric%7Cbetween:-180,180',)|code-block|syntax|javascript|4495822|神奇之处在于模型的boot+method，它设置空间点域的正确值：|4495823|/**
+*+Boot+method
+*+@return+void
+*/
public+static+function+boot(){
++++parent::boot();
++++static::creating(function($eloquentModel){

++++++++if(isset($eloquentModel->latitude,+$eloquentModel->longitude)){
++++++++++++$point+=+$eloquentModel->geoToPoint($eloquentModel->latitude,+$eloquentModel->longitude);
++++++++++++$eloquentModel->setAttribute('location',++DB::raw("GeomFromText('POINT("+.+$point+.+")')")+);
++++++++}

++++});

++++static::updated(function($eloquentModel){

++++++++if(isset($eloquentModel->latitude,+$eloquentModel->longitude)){
++++++++++++$point+=+$eloquentModel->geoToPoint($eloquentModel->latitude,+$eloquentModel->longitude);
++++++++++++DB::statement("UPDATE+"+.+$eloquentModel->getTable()+.+"+SET+location+=+GeomFromText('POINT("+.+$point+.+")')+WHERE+id+=+".+$eloquentModel->id);
++++++++}

++++});
}|4495824|关于迁移，就像@jhmilan所说的，你总是可以使用Schema::create和DB::statement方法来定制迁移。|4495825|Schema::create('locations',+function($table){
++++++++$table->engine+=+"MYISAM";
++++++++$table->increments('id')->unsigned();
++++++++$table->decimal('latitude',+10,+8);+
++++++++$table->decimal('longitude',+11,+8);
++++++++$table->timestamps();
++++});

++++/*Espatial+Column*/
++++DB::statement('ALTER+TABLE+locations+ADD+location+POINT+NOT+NULL'+);
++++/*Espatial+index+(MYISAM+only)*/
++++DB::statement(+'ALTER+TABLE+locations+ADD+SPATIAL+INDEX+index_point(location)'+);|4495826|entityMap|0|LINK|mutability|MUTABLE|url|http://laravel.com/docs/5.0/validation|1|http://laravel.com/docs/5.0/eloquent#model-events^0|Z|F|0|0|0|9|B|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|K|3|L|5|F|7|19|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|1A|8|@]|9|@]|C|$]]|$1|O|3|P|5|F|7|1B|8|@]|9|@]|C|$G|H]]|$1|Q|3|-4|5|6|7|1C|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]|Y|$5|T|U|V|C|$W|Z]]]]

A workaround I have implemented a while ago is to have a latitude and longitude fields on the model with the following validations (see <a href="http://laravel.com/docs/5.0/validation">Validator class</a>):

<pre><code>$rules = array('latitude' =&gt; 'required|numeric|between:-90,90',
 'longitude'=&gt;'required|numeric|between:-180,180',)
</code></pre>

The magic comes on the <a href="http://laravel.com/docs/5.0/eloquent#model-events">boot method</a> of the model, which sets the correct value of the spatial point field:

<pre><code>/**
 * Boot method
 * @return void
 */
public static function boot(){
 parent::boot();
 static::creating(function($eloquentModel){

 if(isset($eloquentModel-&gt;latitude, $eloquentModel-&gt;longitude)){
 $point = $eloquentModel-&gt;geoToPoint($eloquentModel-&gt;latitude, $eloquentModel-&gt;longitude);
 $eloquentModel-&gt;setAttribute('location', DB::raw("GeomFromText('POINT(" . $point . ")')") );
 }

 });

 static::updated(function($eloquentModel){

 if(isset($eloquentModel-&gt;latitude, $eloquentModel-&gt;longitude)){
 $point = $eloquentModel-&gt;geoToPoint($eloquentModel-&gt;latitude, $eloquentModel-&gt;longitude);
 DB::statement("UPDATE " . $eloquentModel-&gt;getTable() . " SET location = GeomFromText('POINT(" . $point . ")') WHERE id = ". $eloquentModel-&gt;id);
 }

 });
}
</code></pre>

About migrations, like @jhmilan says you can always use the Schema::create and DB::statement methods to customize the migration.

<pre><code>Schema::create('locations', function($table){
 $table-&gt;engine = "MYISAM";
 $table-&gt;increments('id')-&gt;unsigned();
 $table-&gt;decimal('latitude', 10, 8); 
 $table-&gt;decimal('longitude', 11, 8);
 $table-&gt;timestamps();
 });

 /*Espatial Column*/
 DB::statement('ALTER TABLE locations ADD location POINT NOT NULL' );
 /*Espatial index (MYISAM only)*/
 DB::statement( 'ALTER TABLE locations ADD SPATIAL INDEX index_point(location)' );
</code></pre>

blocks|key|4495858|text|可以使用https://github.com/grimzy/laravel-mysql-spatial|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4495859|您可以使用：|4495860|namespace+App;

use+Illuminate\Database\Eloquent\Model;
use+Grimzy\LaravelMysqlSpatial\Eloquent\SpatialTrait;

/**
+*+@property+\Grimzy\LaravelMysqlSpatial\Types\Point+$location
+*/
class+Place+extends+Model
{
++++use+SpatialTrait;

++++protected+$fillable+=+[
++++++++'name',
++++];

++++protected+$spatialFields+=+[
++++++++'location',
++++];
}|code-block|syntax|javascript|4495861|然后你就可以在'location‘字段上运行查询了。|4495862|要存储模型，您可以使用：|4495863|$place1+=+new+Place();
$place1->name+=+'Empire+State+Building';
$place1->location+=+new+Point(40.7484404,+-73.9878441);
$place1->save();|4495864|要检索应该使用的模型，请执行以下操作：|4495865|$place2+=+Place::first();
$lat+=+$place2->location->getLat();+//+40.7484404
$lng+=+$place2->location->getLng();+//+-73.9878441|4495866|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/grimzy/laravel-mysql-spatial^0|4|1B|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|17|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|19|8|@]|9|@]|C|$]]|$1|O|3|P|5|H|7|1A|8|@]|9|@]|C|$I|J]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|C|$]]|$1|S|3|T|5|H|7|1C|8|@]|9|@]|C|$I|J]]|$1|U|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]]|V|$W|$5|X|Y|Z|C|$10|11]]]]

It is available to use <a href="https://github.com/grimzy/laravel-mysql-spatial" rel="nofollow noreferrer">https://github.com/grimzy/laravel-mysql-spatial</a>

you may use:

<pre><code>namespace App;

use Illuminate\Database\Eloquent\Model;
use Grimzy\LaravelMysqlSpatial\Eloquent\SpatialTrait;

/**
 * @property \Grimzy\LaravelMysqlSpatial\Types\Point $location
 */
class Place extends Model
{
 use SpatialTrait;

 protected $fillable = [
 'name',
 ];

 protected $spatialFields = [
 'location',
 ];
}
</code></pre>

then you are able to run queries on the 'location' field.

to store model you may use:

<pre><code>$place1 = new Place();
$place1-&gt;name = 'Empire State Building';
$place1-&gt;location = new Point(40.7484404, -73.9878441);
$place1-&gt;save();
</code></pre>

to retrieving a model you should use:

<pre><code>$place2 = Place::first();
$lat = $place2-&gt;location-&gt;getLat(); // 40.7484404
$lng = $place2-&gt;location-&gt;getLng(); // -73.9878441
</code></pre>

How to handle mysql spatial datatypes in eloquent ORM?, This include how to create migration, insert spatial data and performing spatial query's. If there is not actual solutions exists, is there any workarounds?

Handling Mysql Spatial datatypes in Laravel Eloquent ORM

如何在雄辩的ORM中处理mysql空间数据类型?这包括如何创建迁移、插入空间数据和执行空间查询。如果没有实际的解决方案，有什么解决方法吗？

问在Laravel雄辩ORM中处理Mysql Spatial数据类型
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Laravel雄辩ORM中处理Mysql Spatial数据类型EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Laravel雄辩ORM中处理Mysql Spatial数据类型
EN