* 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; echo 'Memory peak: ' . memory_get_peak_usage() . 'B' . EOL; echo EOL; echo 'You are done. All routes are cleaned.' . EOL; echo EOL; echo 'Remember to unset your credentials within this file.' . EOL; echo '(Or simply delete this file if you are not working on our git repository)' . 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(); } }
/** * 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; echo 'You are done. All routes are cleaned.' . EOL; echo EOL; echo 'Remember to unset your credentials within this file.' . EOL; echo '(Or simply delete this file if you are not working on our git repository)' . EOL;