Shopware 6：如何通过ID查询订单关联的账单地址与销售渠道详情

在CheckoutOrderPlacedEvent触发时，订单对象默认不会自动加载关联的账单地址和销售渠道，所以需要通过对应的Repository来手动查询详情，具体实现如下：

1. 注入所需的Repository #

首先在你的事件订阅器类中，通过构造函数注入销售渠道和客户地址的Repository：

use Shopware\Core\System\SalesChannel\SalesChannelRepository;
use Shopware\Core\Checkout\Customer\CustomerAddressRepository;
use Shopware\Core\Framework\DataAbstractionLayer\Search\Criteria;
use Shopware\Core\Framework\DataAbstractionLayer\Search\Filter\EqualsFilter;

class YourOrderSubscriber
{
    private SalesChannelRepository $salesChannelRepo;
    private CustomerAddressRepository $addressRepo;

    public function __construct(
        SalesChannelRepository $salesChannelRepo,
        CustomerAddressRepository $addressRepo
    ) {
        $this->salesChannelRepo = $salesChannelRepo;
        $this->addressRepo = $addressRepo;
    }

    // 事件订阅配置
    public static function getSubscribedEvents(): array
    {
        return [
            CheckoutOrderPlacedEvent::class => 'onOrderReceived',
        ];
    }

    // 处理事件的方法
    public function onOrderReceived(CheckoutOrderPlacedEvent $event): void
    {
        // 后续查询逻辑写在这里
    }
}

2. 查询销售渠道详情 #

在onOrderReceived方法中，用销售渠道ID通过Repository查询完整实体：

public function onOrderReceived(CheckoutOrderPlacedEvent $event): void
{
    $order = $event->getOrder();
    $salesChannelId = $order->getSalesChannelId();

    if (!$salesChannelId) {
        return;
    }

    // 获取事件上下文，确保查询权限正确
    $context = $event->getContext();
    $salesChannel = $this->salesChannelRepo->search(
        (new Criteria())->addFilter(new EqualsFilter('id', $salesChannelId)),
        $context
    )->first();

    // 现在可以获取销售渠道的详细信息
    if ($salesChannel) {
        $channelName = $salesChannel->getName();
        $channelDomain = $salesChannel->getDomains()->first()->getUrl();
        // 其他业务操作...
    }
}

3. 查询账单地址详情 #

账单地址属于客户地址，用地址ID通过CustomerAddressRepository查询：

public function onOrderReceived(CheckoutOrderPlacedEvent $event): void
{
    $order = $event->getOrder();
    $billingAddressId = $order->getBillingAddressId();

    if (!$billingAddressId) {
        return;
    }

    $context = $event->getContext();
    $billingAddress = $this->addressRepo->search(
        (new Criteria())->addFilter(new EqualsFilter('id', $billingAddressId)),
        $context
    )->first();

    // 获取地址详情
    if ($billingAddress) {
        $street = $billingAddress->getStreet();
        $city = $billingAddress->getCity();
        $zipCode = $billingAddress->getZipcode();
        // 其他业务操作...
    }
}

关键说明 #

• 必须使用事件传递的Context进行查询，避免权限或数据隔离问题
• 如果需要批量查询或更复杂的筛选，可以调整Criteria的参数，比如添加关联加载（如果需要）

内容的提问来源于stack exchange，提问作者tee