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"]); } }