CWorkflow::GetByID

static function GetByID($ID)
{
	$err_mess = (CWorkflowStatus::err_mess())."
Function: GetByID
Line: ";
	global $DB, $USER;
	$ID = intval($ID);
	$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,
			UE.EMAIL EUSER_EMAIL,
			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;
}