CAllMeetingItem::GetTasksCount

static function GetTasksCount($ID, $INSTANCE_ID = 0)
{
	global $DB;

	$ID = intval($ID);
	$INSTANCE_ID = intval($INSTANCE_ID);

	if ($ID <= 0)
		return;

	if ($INSTANCE_ID > 0)
	{
		$strSql = "
SELECT COUNT(TASK_ID) AS CNT, INSTANCE_ID
FROM b_meeting_item_tasks
WHERE INSTANCE_ID='".$INSTANCE_ID."' OR INSTANCE_ID IS NULL AND ITEM_ID='".$ID."'
GROUP BY INSTANCE_ID
";

		$dbRes = $DB->Query($strSql);
		$arResult = array(0 => 0, 1 => 0);
		while ($arRes = $dbRes->Fetch())
		{
			$arResult[$arRes['INSTANCE_ID'] > 0 ? 1 : 0] = $arRes['CNT'];
		}
		$arResult[0] += $arResult[1];
		return $arResult;
	}
	else
	{
		$strSql = "SELECT COUNT(TASK_ID) AS CNT FROM b_meeting_item_tasks WHERE ITEM_ID='".$ID."'";
		$dbRes = $DB->Query($strSql);
		if ($arRes = $dbRes->Fetch())
			return $arRes['CNT'];
	}
}