GetWebsiteCodeByWebsiteId.php 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. <?php
  2. /**
  3. * Copyright © Magento, Inc. All rights reserved.
  4. * See COPYING.txt for license details.
  5. */
  6. declare(strict_types=1);
  7. namespace Magento\InventorySales\Model\ResourceModel;
  8. use Magento\Framework\App\ResourceConnection;
  9. /**
  10. * Get website code by website id
  11. */
  12. class GetWebsiteCodeByWebsiteId
  13. {
  14. /**
  15. * @var ResourceConnection
  16. */
  17. private $resourceConnection;
  18. /**
  19. * @param ResourceConnection $resourceConnection
  20. */
  21. public function __construct(
  22. ResourceConnection $resourceConnection
  23. ) {
  24. $this->resourceConnection = $resourceConnection;
  25. }
  26. /**
  27. * @param int $websiteId
  28. * @return string|null
  29. */
  30. public function execute(int $websiteId): ?string
  31. {
  32. $connection = $this->resourceConnection->getConnection();
  33. $tableName = $this->resourceConnection->getTableName('store_website');
  34. $selectQry = $connection->select()->from($tableName, 'code')->where('website_id = ?', $websiteId);
  35. $result = $connection->fetchOne($selectQry);
  36. return (false === $result) ? null : $result;
  37. }
  38. }