function CleanUpPublished()
{
$err_mess = CWorkflow::err_mess() . "<br>Function: CleanUpPublished<br>Line: ";
global $DB;
$DAYS_AFTER_PUBLISHING = intval(COption::GetOptionString("workflow", "DAYS_AFTER_PUBLISHING", "0"));
if ($DAYS_AFTER_PUBLISHING >= 0) {
$strSql = "\n\t\t\t\tSELECT\n\t\t\t\t\tID\n\t\t\t\tFROM\n\t\t\t\t\tb_workflow_document\n\t\t\t\tWHERE\n\t\t\t\t\tSTATUS_ID = 1\n\t\t\t\tand to_days(now())-to_days(DATE_MODIFY)>={$DAYS_AFTER_PUBLISHING}\n\t\t\t\t";
$z = $DB->Query($strSql, false, $err_mess . __LINE__);
while ($zr = $z->Fetch()) {
CWorkflow::Delete($zr["ID"]);
}
}
}
public static function CleanUpPreview($DOCUMENT_ID = false)
{
$err_mess = CWorkflow::err_mess() . "<br>Function: CleanUpPreview<br>Line: ";
global $DB;
if ($DOCUMENT_ID === false) {
$strSql = "\n\t\t\t\tSELECT\n\t\t\t\t\tP.FILENAME, D.SITE_ID\n\t\t\t\tFROM\n\t\t\t\t\tb_workflow_document D,\n\t\t\t\t\tb_workflow_preview P\n\t\t\t\tWHERE\n\t\t\t\t\tD.STATUS_ID = 1\n\t\t\t\t\tand P.DOCUMENT_ID = D.ID\n\t\t\t\t";
} else {
$DOCUMENT_ID = intval($DOCUMENT_ID);
$strSql = "\n\t\t\t\tSELECT\n\t\t\t\t\tFILENAME\n\t\t\t\tFROM\n\t\t\t\t\tb_workflow_preview\n\t\t\t\tWHERE\n\t\t\t\t\tDOCUMENT_ID = " . $DOCUMENT_ID . "\n\t\t\t\t";
}
$z = $DB->Query($strSql, false, $err_mess . __LINE__);
while ($zr = $z->Fetch()) {
CWorkflow::DeletePreview($zr["FILENAME"], $zr["SITE"]);
}
}
