. */ namespace SP\Services\Upgrade; use Exception; use SP\Core\Events\Event; use SP\Core\Events\EventMessage; use SP\DataModel\PublickLinkOldData; use SP\DataModel\PublicLinkData; use SP\Services\PublicLink\PublicLinkService; use SP\Services\Service; use SP\Storage\Database\Database; use SP\Storage\Database\QueryData; use SP\Util\Util; /** * Class UpgradePublicLink * * @package SP\Services\Upgrade */ final class UpgradePublicLink extends Service { /** * @var Database */ private $db; /** * upgrade_300_18010101 */ public function upgrade_300_18010101() { $this->eventDispatcher->notifyEvent('upgrade.publicLink.start', new Event($this, EventMessage::factory() ->addDescription(__u('Public links update')) ->addDescription(__FUNCTION__)) ); try { $this->transactionAware(function () { $publicLinkService = $this->dic->get(PublicLinkService::class); $queryData = new QueryData(); $queryData->setQuery('SELECT id, `data` FROM PublicLink'); foreach ($this->db->doSelect($queryData)->getDataAsArray() as $item) { /** @var PublickLinkOldData $data */ $data = Util::unserialize(PublickLinkOldData::class, $item->data, 'SP\DataModel\PublicLinkData'); $itemData = new PublicLinkData(); $itemData->setId($item->id); $itemData->setItemId($data->getItemId()); $itemData->setHash($data->getLinkHash()); $itemData->setUserId($data->getUserId()); $itemData->setTypeId($data->getTypeId()); $itemData->setNotify($data->isNotify()); $itemData->setDateAdd($data->getDateAdd()); $itemData->setDateExpire($data->getDateExpire()); $itemData->setCountViews($data->getCountViews()); $itemData->setMaxCountViews($data->getCountViews()); $itemData->setUseInfo($data->getUseInfo()); $itemData->setData($data->getData()); $publicLinkService->update($itemData); $this->eventDispatcher->notifyEvent('upgrade.publicLink.process', new Event($this, EventMessage::factory() ->addDescription(__u('Link updated')) ->addDetail(__u('Link'), $item->id)) ); } }); } catch (Exception $e) { processException($e); $this->eventDispatcher->notifyEvent('exception', new Event($e)); } $this->eventDispatcher->notifyEvent('upgrade.publicLink.end', new Event($this, EventMessage::factory() ->addDescription(__u('Public links update')) ->addDescription(__FUNCTION__)) ); } protected function initialize() { $this->db = $this->dic->get(Database::class); } }