public function updateactivitiesleadidAction() { set_time_limit(500); $dbSql = $this->getServiceLocator()->get('dbSql'); $dbAdapter = $this->getServiceLocator()->get('dbAdapter'); $select = $dbSql->select(['act' => \Crm\Model\ActivityMapper::TABLE_NAME]); $select->where(['leadId IS NULL']); $select->group(['accountId', 'opportunityId']); $query = $dbSql->buildSqlString($select); $rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE); $activityMapper = $this->getServiceLocator()->get('\\Crm\\Model\\ActivityMapper'); if ($rows->count()) { foreach ($rows as $row) { $activity = new \Crm\Model\Activity(); $activity->exchangeArray((array) $row); $activityMapper->updateLeadId($activity); } } die('Xong'); }