78 "DELETE FROM b_bp_workflow_instance ".
79 "WHERE ID = '".
$DB->ForSql($id).
"'"
85 "SELECT ID, IF (".$queryCondition.
", 'Y', 'N') as UPDATEABLE ".
86 "FROM b_bp_workflow_instance ".
87 "WHERE ID = '".$DB->ForSql($id).
"' "
94 "UPDATE b_bp_workflow_instance SET ".
96 " STATUS = ".intval(
$status).
", ".
97 " MODIFIED = ".$DB->CurrentTimeFunction().
", ".
98 " OWNER_ID = ".($bUnlocked ?
"NULL" :
"'".$DB->ForSql($this->serviceInstanceId).
"'").
", ".
99 " OWNED_UNTIL = ".($bUnlocked ?
"NULL" :
$DB->CharToDateFunction(date(
$GLOBALS[
"DB"]->DateFormatToPHP(
FORMAT_DATETIME), $this->GetOwnershipTimeout()))).
" ".
100 "WHERE ID = '".
$DB->ForSql($id).
"' "
105 throw new Exception(
GetMessage(
'BPCGWP_WF_LOCKED'));
111 "INSERT INTO b_bp_workflow_instance (ID, WORKFLOW, STATUS, MODIFIED, OWNER_ID, OWNED_UNTIL) ".
112 "VALUES ('".
$DB->ForSql($id).
"', '".
$DB->ForSql(
$buffer).
"', ".intval(
$status).
", ".
$DB->CurrentTimeFunction().
", ".($bUnlocked ?
"NULL" :
"'".$DB->ForSql($this->serviceInstanceId).
"'").
", ".($bUnlocked ?
"NULL" :
$DB->CharToDateFunction(date(
$GLOBALS[
"DB"]->DateFormatToPHP(
FORMAT_DATETIME), $this->GetOwnershipTimeout()))).
")"
if( $daysToExpire >=0 &&$daysToExpire< 60 elseif)( $daysToExpire< 0)