• Модуль: bizproc
  • Путь к файлу: ~/bitrix/modules/bizproc/classes/general/stateservice.php
  • Класс: CBPStateService
  • Вызов: CBPStateService::countDocumentWorkflows
static function countDocumentWorkflows($documentId)
{
	global $DB;

	$arDocumentId = CBPHelper::ParseDocumentId($documentId);

	$dbResult = $DB->Query(
		"SELECT COUNT(WI.ID) CNT ".
		"FROM b_bp_workflow_instance WI ".
		"WHERE WI.DOCUMENT_ID = '".$DB->ForSql($arDocumentId[2])."' ".
		"	AND WI.ENTITY = '".$DB->ForSql($arDocumentId[1])."' ".
		"	AND WI.MODULE_ID ".(($arDocumentId[0] <> '') ? "= '".$DB->ForSql($arDocumentId[0])."'" : "IS NULL").
		"	AND WI.STARTED_EVENT_TYPE <> ".(int)CBPDocumentEventType::Automation
	);

	if ($arResult = $dbResult->Fetch())
	{
		return (int) $arResult['CNT'];
	}

	return 0;
}