}
/**
* Prepare fix
*/
echo 'Start to fix routes ';
/**
* Run single cleanups
*/
$Routes = $PDO->query('
SELECT
`id`,
`accountid`,
`geohashes`
FROM `' . PREFIX . 'route`
WHERE `startpoint` = "7zzzzzzzzz" OR (`startpoint` IS NOT NULL AND `min` IS NULL)');
$Updater = new Runalyze\Model\Route\Updater($PDO);
while ($Route = $Routes->fetch()) {
$Updater->setAccountID($Route['accountid']);
GlobalCleanupAccount::$ID = $Route['accountid'];
$PDO->setAccountID($Route['accountid']);
$RouteEntity = new Runalyze\Model\Route\Entity($Route);
$RouteEntity->forceToSetMinMaxFromGeohashes();
$Updater->update($RouteEntity, array('startpoint', 'endpoint', 'min', 'max'));
echo '.' . (CLI ? '' : ' ');
}
/**
* Finish
*/
echo 'done;' . EOL;
echo EOL;
echo 'Time: ' . (microtime(true) - $starttime) . 's' . EOL;
/**
* Update object in database
*/
public function update()
{
$DB = DB::getInstance();
$AccountID = SessionAccountHandler::getId();
$OldData = isset($_POST['old-data']) ? unserialize(base64_decode($_POST['old-data'])) : array();
if (!is_array($OldData)) {
$OldData = array();
}
$NewActivity = $this->newActivityObject();
$UpdaterActivity = new \Runalyze\Model\Activity\Updater($DB, $NewActivity, new \Runalyze\Model\Activity\Object($OldData));
if (isset($OldData['routeid']) && $OldData['routeid'] > 0) {
$UpdaterActivity->setRoute(\Runalyze\Context::Factory()->route($OldData['routeid']));
} elseif ($this->get('route') != '') {
$InserterRoute = new Runalyze\Model\Route\Inserter($DB, new Runalyze\Model\Route\Object(array(Runalyze\Model\Route\Object::NAME => $this->get('route'), Runalyze\Model\Route\Object::CITIES => $this->get('route'), Runalyze\Model\Route\Object::DISTANCE => $this->get('distance'))));
$InserterRoute->setAccountID($AccountID);
$InserterRoute->insert();
$NewActivity->set(Runalyze\Model\Activity\Object::ROUTEID, $InserterRoute->insertedID());
}
$UpdaterActivity->setTrackdata(\Runalyze\Context::Factory()->trackdata($this->id()));
$UpdaterActivity->setEquipmentIDs(TrainingFormular::readEquipmentFromPost($NewActivity->sportid()), isset($_POST['equipment_old']) ? explode(',', $_POST['equipment_old']) : array());
$UpdaterActivity->setAccountID($AccountID);
$UpdaterActivity->update();
if (isset($OldData['routeid']) && isset($OldData['route'])) {
$UpdaterRoute = new \Runalyze\Model\Route\Updater($DB, new Runalyze\Model\Route\Object(array('id' => $OldData['routeid'], Runalyze\Model\Route\Object::NAME => $this->get('route'), Runalyze\Model\Route\Object::CITIES => $this->get('route'))), new Runalyze\Model\Route\Object(array('id' => $OldData['routeid'], Runalyze\Model\Route\Object::NAME => $OldData['route'], Runalyze\Model\Route\Object::CITIES => $OldData['route'])));
$UpdaterRoute->setAccountID($AccountID);
$UpdaterRoute->update();
}
}
/**
* Update object in database
*/
public function update()
{
$OldData = isset($_POST['old-data']) ? unserialize(base64_decode($_POST['old-data'])) : array();
if (!is_array($OldData)) {
$OldData = array();
}
$UpdaterActivity = new \Runalyze\Model\Activity\Updater(DB::getInstance(), $this->newActivityObject(), new \Runalyze\Model\Activity\Object($OldData));
if (isset($OldData['routeid'])) {
$UpdaterActivity->setRoute(\Runalyze\Context::Factory()->route($OldData['routeid']));
}
$UpdaterActivity->setTrackdata(\Runalyze\Context::Factory()->trackdata($this->id()));
$UpdaterActivity->setAccountID(SessionAccountHandler::getId());
$UpdaterActivity->update();
if (isset($OldData['routeid']) && isset($OldData['route'])) {
$UpdaterRoute = new \Runalyze\Model\Route\Updater(DB::getInstance(), new Runalyze\Model\Route\Object(array('id' => $OldData['routeid'], Runalyze\Model\Route\Object::NAME => $this->get('route'), Runalyze\Model\Route\Object::CITIES => $this->get('route'))), new Runalyze\Model\Route\Object(array('id' => $OldData['routeid'], Runalyze\Model\Route\Object::NAME => $OldData['route'], Runalyze\Model\Route\Object::CITIES => $OldData['route'])));
$UpdaterRoute->setAccountID(SessionAccountHandler::getId());
$UpdaterRoute->update();
}
}
/**
* Prepare fix
*/
echo 'Start to fix routes ';
/**
* Run single cleanups
*/
$Routes = $PDO->query('
SELECT
`id`,
`accountid`,
`lats`,
`lngs`
FROM `' . PREFIX . 'route`
WHERE (`lats` != "" AND `lngs` != "") AND (`startpoint_lat`=0 OR `startpoint_lng`=0 OR `endpoint_lng`=0 OR `endpoint_lng`=0 OR `min_lng`=0 OR `max_lng`=0 OR `min_lat`=0 OR `max_lat`=0)');
$Updater = new Runalyze\Model\Route\Updater($PDO);
while ($Route = $Routes->fetch()) {
$Updater->setAccountID($Route['accountid']);
GlobalCleanupAccount::$ID = $Route['accountid'];
$PDO->setAccountID($Route['accountid']);
$Updater->update(new Runalyze\Model\Route\Entity($Route), array('startpoint_lat', 'startpoint_lng', 'endpoint_lat', 'endpoint_lng', 'min_lng', 'max_lng', 'min_lat', 'max_lat'));
echo '.' . (CLI ? '' : ' ');
}
/**
* Finish
*/
echo 'done;' . EOL;
echo EOL;
echo 'Time: ' . (microtime(true) - $starttime) . 's' . EOL;
echo 'Memory peak: ' . memory_get_peak_usage() . 'B' . EOL;
echo EOL;
