public static function Update($arFields, $DOCUMENT_ID)
{
$err_mess = (CWorkflow::err_mess())."<br>Function: Update<br>Line: ";
global $DB;
$z = CWorkflow::GetByID($DOCUMENT_ID);
$change = false;
if ($zr=$z->Fetch())
{
if ($zr["STATUS_ID"] != $DB->ForSql($arFields["STATUS_ID"]) or
$zr["BODY"] != $DB->ForSql($arFields["BODY"]) or
$zr["BODY_TYPE"] != $DB->ForSql($arFields["BODY_TYPE"]) or
$zr["COMMENTS"] != $DB->ForSql($arFields["COMMENTS"]) or
$zr["FILENAME"] != $DB->ForSql($arFields["FILENAME"]) or
$zr["SITE_ID"] != $DB->ForSql($arFields["SITE_ID"]) or
$zr["TITLE"] != $DB->ForSql($arFields["TITLE"]))
$change = true;
}
$strUpdate = $DB->PrepareUpdate("b_workflow_document", $arFields, "workflow");
$strSql = "UPDATE b_workflow_document SET ".$strUpdate.", DATE_MODIFY=now(), DATE_ENTER=now() WHERE ID=".$DOCUMENT_ID;
$DB->Query($strSql, false, $err_mess.__LINE__);
if ($change)
{
$LOG_ID = CWorkflow::SetHistory($DOCUMENT_ID);
CWorkflow::SetMove($DOCUMENT_ID, $arFields["STATUS_ID"], $zr["STATUS_ID"], $LOG_ID);
}
}
public static function SetStatus($DOCUMENT_ID, $STATUS_ID, $OLD_STATUS_ID, $history = true)
{
$err_mess = CAllWorkflow::err_mess() . "<br>Function: SetStatus<br>Line: ";
global $DB, $APPLICATION, $USER, $strError;
//$arMsg = Array();
$DOCUMENT_ID = intval($DOCUMENT_ID);
$STATUS_ID = intval($STATUS_ID);
$OLD_STATUS_ID = intval($OLD_STATUS_ID);
if ($STATUS_ID == 1) {
// get all files associated with the document
$files = CWorkflow::GetFileList($DOCUMENT_ID);
while ($file = $files->Fetch()) {
$path = $file["FILENAME"];
$DOC_ROOT = CSite::GetSiteDocRoot($file["SITE_ID"]);
$pathto = $DOC_ROOT . $path;
$pathfrom = CWorkflow::GetTempDir() . $file["TEMP_FILENAME"];
if ($USER->CanDoFileOperation('fm_edit_in_workflow', array($file["SITE_ID"], $path)) && $USER->CanDoFileOperation('fm_edit_existent_file', array($file["SITE_ID"], $path)) && $USER->CanDoFileOperation('fm_create_new_file', array($file["SITE_ID"], $path))) {
if (!copy($pathfrom, $pathto)) {
$str = GetMessage("FLOW_CAN_NOT_WRITE_FILE", array("#FILENAME#" => $path));
$strError .= $str . "<br>";
}
} else {
$str = GetMessage("FLOW_ACCESS_DENIED_FOR_FILE_WRITE", array("#FILENAME#" => $path));
$strError .= $str . "<br>";
}
}
// still good
if (strlen($strError) <= 0) {
// publish the document
$y = CWorkflow::GetByID($DOCUMENT_ID);
$yr = $y->Fetch();
if ($USER->CanDoFileOperation('fm_edit_in_workflow', array($yr["SITE_ID"], $yr["FILENAME"])) && $USER->CanDoFileOperation('fm_edit_existent_file', array($yr["SITE_ID"], $yr["FILENAME"])) && $USER->CanDoFileOperation('fm_create_new_file', array($yr["SITE_ID"], $yr["FILENAME"]))) {
// save file
$prolog = $yr["PROLOG"];
if (strlen($prolog) > 0) {
$title = $yr["TITLE"];
$prolog = SetPrologTitle($prolog, $title);
}
$content = $yr["BODY_TYPE"] == "text" ? TxtToHTML($yr["BODY"]) : $yr["BODY"];
$content = WFToPath($content);
$epilog = $yr["EPILOG"];
$filesrc = $prolog . $content . $epilog;
global $BX_WORKFLOW_PUBLISHED_PATH, $BX_WORKFLOW_PUBLISHED_SITE;
$BX_WORKFLOW_PUBLISHED_PATH = $yr["FILENAME"];
$BX_WORKFLOW_PUBLISHED_SITE = $yr["SITE_ID"];
$DOC_ROOT = CSite::GetSiteDocRoot($yr["SITE_ID"]);
$APPLICATION->SaveFileContent($DOC_ROOT . $yr["FILENAME"], $filesrc);
$BX_WORKFLOW_PUBLISHED_PATH = "";
$BX_WORKFLOW_PUBLISHED_SITE = "";
} else {
// throw error
$str = GetMessage("FLOW_ACCESS_DENIED_FOLDER", array("#FILENAME#" => $yr["FILENAME"]));
$strError .= GetMessage("FLOW_ERROR") . htmlspecialcharsbx($str) . "<br>";
}
}
}
if (strlen($strError) <= 0) {
// update db
$arFields = array("DATE_MODIFY" => $DB->GetNowFunction(), "MODIFIED_BY" => $USER->GetID(), "STATUS_ID" => intval($STATUS_ID));
$DB->Update("b_workflow_document", $arFields, "WHERE ID='" . $DOCUMENT_ID . "'", $err_mess . __LINE__);
if ($history === true) {
$LOG_ID = CWorkflow::SetHistory($DOCUMENT_ID);
CWorkflow::SetMove($DOCUMENT_ID, $STATUS_ID, $OLD_STATUS_ID, $LOG_ID);
}
} else {
$strError = GetMessage("FLOW_DOCUMENT_NOT_PUBLISHED") . "<br>" . $strError;
}
CWorkflow::CleanUpPublished();
}
