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');
}
