DealScoring::getTrainingSet

public function getTrainingSet($fromId, $limit)
{
	$categoryId = static::getModelCategory($this->name);
	$rows = DealTable::getList([
		"select" => ["ID"],
		"filter" => [
			"=STAGE_SEMANTIC_ID" => ["S", "F"],
			"=CATEGORY_ID" => $categoryId,
			"=HAS_ACT" => 1,
			">ID" => $fromId
		],
		"runtime" => [
			new ExpressionField(
				"HAS_ACT",
				"CASE WHEN EXISTS(SELECT 'x' FROM b_crm_act WHERE OWNER_TYPE_ID = " . CCrmOwnerType::Deal . " and OWNER_ID = %s) THEN 1 ELSE 0 END",
				["ID"]
			),
		],
		"limit" => $limit,
		"order" => ["ID" => "asc"]
	])->fetchAll();

	return array_column($rows, "ID");
}