- Модуль: crm
- Путь к файлу: ~/bitrix/modules/crm/lib/ml/model/leadscoring.php
- Класс: Bitrix\Crm\Ml\Model\LeadScoring
- Вызов: LeadScoring::getTrainingSet
public function getTrainingSet($fromId, $limit)
{
$rows = LeadTable::getList([
"select" => ["ID", "HAS_ACT"],
"filter" => [
"=STATUS_SEMANTIC_ID" => ["S", "F"],
"=HAS_ACT" => 1,
">ID" => $fromId
],
"runtime" => [
new ExpressionField(
"HAS_ACT",
"CASE WHEN EXISTS(SELECT 'x' FROM b_crm_act WHERE OWNER_TYPE_ID = " . CCrmOwnerType::Lead . " and OWNER_ID = %s) THEN 1 ELSE 0 END",
["ID"]
),
],
"limit" => $limit,
"order" => ["ID" => "asc"]
])->fetchAll();
return array_column($rows, "ID");
}