public function performAction()
{
if (!file_exists($this->path)) {
throw new \Exception(Expression::create('File ? not found', $this->path));
}
$GPSEssentials = new GPSEssentials($this->path);
$database = new Database('sqlite:///' . realpath($this->path));
$database->log(new Log('colored-stdout'));
TrackElement::bindDatabase($database);
//$this->count = $database->query("SELECT COUNT(1) AS c FROM ?", TrackElement::table())->fetchRow('c');
$pageQuery = TrackElement::statement()->order("? ASC", TrackElement::columns()->id)->limit($this->pageSize);
if ($this->from) {
$pageQuery->where('? >= 1000 * ?', TrackElement::columns()->time, strtotime($this->from));
}
if ($this->to) {
$pageQuery->where('? <= 1000 * ?', TrackElement::columns()->time, strtotime($this->to));
}
$this->segments = array(Segment5::className(), Segment10::className(), Segment100::className(), Segment500::className(), Segment1k::className(), Segment5k::className(), Segment10k::className());
$timeSegments = array(Segment10s::className(), Segment60s::className());
/** @var BatchSaver[] $batchSavers */
$batchSavers = array();
foreach ($this->segments as $segment) {
$batchSavers[$segment] = new BatchSaver();
}
foreach ($timeSegments as $segment) {
$batchSavers[$segment] = new BatchSaver();
}
while ($res = $pageQuery->query()->fetchAll()) {
/** @var TrackElement $row */
foreach ($res as $row) {
$row->time /= 1000;
/** @var Segment5|string $segment */
foreach ($this->segments as $segment) {
if (!isset($this->lastPoints[$segment])) {
$this->lastPoints[$segment] = $row;
}
/** @var TrackElement $lastPoint */
$lastPoint = $this->lastPoints[$segment];
if (($distance = GPSEssentials::distance($lastPoint, $row)) > $segment::MIN_DISTANCE) {
/** @var Segment5 $segmentItem */
$segmentItem = new $segment();
$segmentItem->distance = $distance;
$segmentItem->latitude = $row->latitude;
$segmentItem->longitude = $row->longitude;
$segmentItem->ut = $row->time;
$segmentItem->altitude = $row->altitude;
$segmentItem->time = $row->time - $lastPoint->time;
if ($segmentItem->time) {
$segmentItem->speed = $segmentItem->distance / $segmentItem->time;
}
$segmentItem->elevation = $row->altitude - $lastPoint->altitude;
$batchSavers[$segment]->add($segmentItem);
//$segmentItem->save();
$this->lastPoints[$segment] = $row;
}
}
/** @var Segment10s|string $segment */
foreach ($timeSegments as $segment) {
if (!isset($this->lastPoints[$segment])) {
$this->lastPoints[$segment] = $row;
}
/** @var TrackElement $lastPoint */
$lastPoint = $this->lastPoints[$segment];
if ($row->time - $lastPoint->time > $segment::MIN_TIME) {
/** @var Segment5 $segmentItem */
$segmentItem = new $segment();
$segmentItem->distance = GPSEssentials::distance($lastPoint, $row);
$segmentItem->latitude = $row->latitude;
$segmentItem->longitude = $row->longitude;
$segmentItem->ut = $row->time;
$segmentItem->altitude = $row->altitude;
$segmentItem->time = $row->time - $lastPoint->time;
if ($segmentItem->time) {
$segmentItem->speed = $segmentItem->distance / $segmentItem->time;
}
$segmentItem->elevation = $row->altitude - $lastPoint->altitude;
$batchSavers[$segment]->add($segmentItem);
//$segmentItem->save();
$this->lastPoints[$segment] = $row;
}
}
}
$this->offset += $this->pageSize;
$pageQuery->offset($this->offset);
}
foreach ($batchSavers as $batchSaver) {
$batchSaver->flush();
}
}