/** * Resolve customers data based on ids quote table. * * @return void */ public function resolveCustomerNames() { $select = $this->customerResource->getConnection()->select(); $customerName = $this->customerResource->getConnection()->getConcatSql(['firstname', 'lastname'], ' '); $select->from(['customer' => $this->customerResource->getTable('customer_entity')], ['email']); $select->columns(['customer_name' => $customerName]); $select->where('customer.entity_id IN (?)', array_column($this->getData(), 'customer_id')); $customersData = $this->customerResource->getConnection()->fetchAll($select); foreach ($this->getItems() as $item) { $item->setData(array_merge($item->getData(), current($customersData))); next($customersData); } }
/** * Reset Authentication data for customer. * * @param int $customerId * @return $this */ public function saveAuth($customerId) { $customerSecure = $this->customerRegistry->retrieveSecureData($customerId); $this->customerResourceModel->getConnection()->update($this->customerResourceModel->getTable('customer_entity'), ['failures_num' => $customerSecure->getData('failures_num'), 'first_failure' => $customerSecure->getData('first_failure'), 'lock_expires' => $customerSecure->getData('lock_expires')], $this->customerResourceModel->getConnection()->quoteInto('entity_id = ?', $customerId)); return $this; }