CWorkflow::GetByFilename

static function GetByFilename($FILENAME, $SITE_ID, $arFilter = false)
{
	if(!is_array($arFilter))
	{
		$arFilter = array(
			"!STATUS_ID" => 1,
		);
	}

	$obQueryWhere = new CSQLWhere;
	$obQueryWhere->SetFields(array(
		"STATUS_ID" => array(
			"TABLE_ALIAS" => "D",
			"FIELD_NAME" => "D.STATUS_ID",
			"FIELD_TYPE" => "int",
			"JOIN" => false,
		),
	));
	$strSqlWhere = $obQueryWhere->GetQuery($arFilter);

	$err_mess = (CWorkflowStatus::err_mess())."
Function: GetByFilename
Line: ";
	global $DB, $USER;
	$MAX_LOCK = intval(COption::GetOptionString("workflow","MAX_LOCK_TIME","60"));
	$uid = intval($USER->GetID());
	$strSql = "
		SELECT
			D.*,
			".$DB->DateToCharFunction("D.DATE_ENTER")." DATE_ENTER,
			".$DB->DateToCharFunction("D.DATE_MODIFY")." DATE_MODIFY,
			".$DB->DateToCharFunction("D.DATE_LOCK")." DATE_LOCK,
			concat('(',UM.LOGIN,') ',ifnull(UM.NAME,''),' ',ifnull(UM.LAST_NAME,'')) MUSER_NAME,
			concat('(',UE.LOGIN,') ',ifnull(UE.NAME,''),' ',ifnull(UE.LAST_NAME,'')) EUSER_NAME,
			concat('(',UL.LOGIN,') ',ifnull(UL.NAME,''),' ',ifnull(UL.LAST_NAME,'')) LUSER_NAME,
			S.TITLE STATUS_TITLE,
			if (D.DATE_LOCK is null, 'green',
				if(DATE_ADD(D.DATE_LOCK, interval $MAX_LOCK MINUTE)Query($strSql, false, $err_mess.__LINE__);
	return $res;
}