| Server IP : 78.140.185.180 / Your IP : 216.73.216.170 Web Server : LiteSpeed System : Linux cpanel13.v.fozzy.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : builderbox ( 1072) PHP Version : 7.3.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/builderbox/./././www/vendor/teamtnt/tntsearch/src/Indexer/ |
Upload File : |
<?php
namespace TeamTNT\TNTSearch\Indexer;
use PDO;
class TNTGeoIndexer extends TNTIndexer
{
public function createIndex($indexName)
{
$this->indexName = $indexName;
if (file_exists($this->config['storage'].$indexName)) {
unlink($this->config['storage'].$indexName);
}
$this->index = new PDO('sqlite:'.$this->config['storage'].$indexName);
$this->index->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->index->exec("CREATE TABLE IF NOT EXISTS locations (
doc_id INTEGER,
longitude REAL,
latitude REAL,
cos_lat REAL,
sin_lat REAL,
cos_lng REAL,
sin_lng REAL
)");
$this->index->exec("CREATE INDEX location_index ON locations ('longitude', 'latitude');");
$this->index->exec("CREATE TABLE IF NOT EXISTS info (key TEXT, value INTEGER)");
$connector = $this->createConnector($this->config);
if (!$this->dbh) {
$this->dbh = $connector->connect($this->config);
}
return $this;
}
public function processDocument($row)
{
$this->prepareInsertStatement();
$docId = $row->get($this->getPrimaryKey());
$longitude = $row->get('longitude');
$latitude = $row->get('latitude');
$cos_lat = cos($latitude * pi() / 180);
$sin_lat = sin($latitude * pi() / 180);
$cos_lng = cos($longitude * pi() / 180);
$sin_lng = sin($longitude * pi() / 180);
$this->insertStmt->bindParam(":doc_id", $docId);
$this->insertStmt->bindParam(":longitude", $longitude);
$this->insertStmt->bindParam(":latitude", $latitude);
$this->insertStmt->bindParam(":cos_lat", $cos_lat);
$this->insertStmt->bindParam(":sin_lat", $sin_lat);
$this->insertStmt->bindParam(":cos_lng", $cos_lng);
$this->insertStmt->bindParam(":sin_lng", $sin_lng);
$this->insertStmt->execute();
}
public function prepareInsertStatement()
{
if (isset($this->insertStmt)) {
return $this->insertStmt;
}
$this->insertStmt = $this->index->prepare("INSERT INTO locations (doc_id, longitude, latitude, cos_lat, sin_lat, cos_lng, sin_lng)
VALUES (:doc_id, :longitude, :latitude, :cos_lat, :sin_lat, :cos_lng, :sin_lng)");
}
}