/** * Resolve customers data based on ids quote table. * * @return void */ public function resolveCustomerNames() { $select = $this->customerResource->getReadConnection()->select(); $customerName = $select->getAdapter()->getConcatSql(['firstname', 'lastname'], ' '); $select->from(['customer' => $this->customerResource->getTable('customer_entity')], ['email'])->columns(['customer_name' => $customerName])->where('customer.entity_id IN (?)', array_column($this->getData(), 'customer_id')); $customersData = $select->getAdapter()->fetchAll($select); foreach ($this->getItems() as $item) { $item->setData(array_merge($item->getData(), current($customersData))); next($customersData); } }