Example #1
0
 /**
  * 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);
     }
 }