public function caseSchedulerCron ($date, &$log = array(), $cron = 0)
{
try {
require_once("classes" . PATH_SEP . "model" . PATH_SEP . "LogCasesScheduler.php");
//Set variables
$port = "";
if (isset($_SERVER["SERVER_PORT"])) {
$port = ($_SERVER["SERVER_PORT"] . "" != "80")? ":" . $_SERVER["SERVER_PORT"] : "";
} else {
if (defined("SERVER_PORT")) {
$port = (SERVER_PORT . "" != "80")? ":" . SERVER_PORT : "";
}
}
$wsdl = "http://" . SERVER_NAME . $port . "/sys" . SYS_SYS . "/" . SYS_LANG . "/classic/services/wsdl2";
$timeDate = strtotime($date);
$dateHour = date("H", $timeDate);
$dateMinutes = date("i", $timeDate);
$dateCurrentIni = date("Y-m-d", $timeDate) . " 00:00:00";
$dateCurrentEnd = date("Y-m-d", $timeDate) . " 23:59:59";
//Query
$criteria = $this->getAllCriteria();
$criteria->add(
$criteria->getNewCriterion(CaseSchedulerPeer::SCH_STATE, "INACTIVE", Criteria::NOT_EQUAL)->addAnd(
$criteria->getNewCriterion(CaseSchedulerPeer::SCH_STATE, "PROCESSED", Criteria::NOT_EQUAL))
);
$criteria->add(
$criteria->getNewCriterion(CaseSchedulerPeer::SCH_TIME_NEXT_RUN, $dateCurrentIni, Criteria::GREATER_EQUAL)->addAnd(
$criteria->getNewCriterion(CaseSchedulerPeer::SCH_TIME_NEXT_RUN, $dateCurrentEnd, Criteria::LESS_EQUAL))->addOr(
//$criteria->getNewCriterion(CaseSchedulerPeer::SCH_OPTION, 5, Criteria::GREATER_EQUAL))->addOr(
$criteria->getNewCriterion(CaseSchedulerPeer::SCH_TIME_NEXT_RUN, $dateCurrentIni, Criteria::LESS_THAN))
);
$criteria->add(
$criteria->getNewCriterion(CaseSchedulerPeer::SCH_END_DATE, null, Criteria::EQUAL)->addOr(
$criteria->getNewCriterion(CaseSchedulerPeer::SCH_END_DATE, $dateCurrentIni, Criteria::GREATER_EQUAL))
);
$rsCriteria = CaseSchedulerPeer::doSelectRS($criteria);
$rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC);
while ($rsCriteria->next()) {
$row = $rsCriteria->getRow();
if ($cron == 1) {
$arrayCron = unserialize(trim(@file_get_contents(PATH_DATA . "cron")));
$arrayCron["processcTimeStart"] = time();
@file_put_contents(PATH_DATA . "cron", serialize($arrayCron));
}
$caseSchedulerUid = $row["SCH_UID"];
$caseSchedulerOption = (int)($row["SCH_OPTION"]);
$caseSchedulerTimeNextRun = $row["SCH_TIME_NEXT_RUN"];
//Create the new case
$flagNewCase = false;
$caseSchedulerTimeNextRunNew = "";
if (strtotime($caseSchedulerTimeNextRun) < strtotime($dateCurrentIni)) {
//Generate new date for old SCH_TIME_NEXT_RUN
$flagNewCase = true; //Create the old case
$caseSchedulerTimeNextRunNew = $this->getTimeNextRunByDate($row, $date, false);
} else {
$caseSchedulerTimeNextRunHour = date("H", strtotime($row["SCH_TIME_NEXT_RUN"]));
$caseSchedulerTimeNextRunMinutes = date("i", strtotime($row["SCH_TIME_NEXT_RUN"]));
if ((int)($dateHour . $dateMinutes) <= (int)($caseSchedulerTimeNextRunHour . $caseSchedulerTimeNextRunMinutes)) {
$flagNewCase = $caseSchedulerTimeNextRunHour == $dateHour && $caseSchedulerTimeNextRunMinutes == $dateMinutes;
} else {
$flagNewCase = true; //Create the old case
}
}
if ($flagNewCase) {
println(" CASE SCHEDULER: " . $row["SCH_NAME"]);
println(" - Connecting webservice: $wsdl");
$user = $row["SCH_DEL_USER_NAME"];
$pass = $row["SCH_DEL_USER_PASS"];
$processId = $row["PRO_UID"];
$taskId = $row["TAS_UID"];
$client = new SoapClient($wsdl);
$result = $client->__SoapCall("login",
array(
array("userid" => $user, "password" => Bootstrap::getPasswordHashType() . ":" . $pass)
)
);
eprintln(" - Logging as user \"$user\"...");
$paramsLog = array(
"PRO_UID" => $processId,
"TAS_UID" => $taskId,
"SCH_UID" => $caseSchedulerUid,
"USR_NAME" => $user,
"RESULT" => "",
"EXEC_DATE" => date("Y-m-d"),
"EXEC_HOUR" => date("H:i:s"),
"WS_CREATE_CASE_STATUS" => "",
"WS_ROUTE_CASE_STATUS" => ""
);
$paramsLogResult = "FAILED";
$paramsRouteLogResult = "FAILED";
if ($result->status_code == 0) {
eprintln(" OK", "green");
$sessionId = $result->message;
$params = array("sessionId" => $sessionId, "processId" => $processId, "taskId" => $taskId, "variables" => array());
//If this Job was was registered to be performed by a plugin
if (isset($row["CASE_SH_PLUGIN_UID"]) && $row["CASE_SH_PLUGIN_UID"] != "") {
//Check if the plugin is active
$pluginParts = explode("--", $row["CASE_SH_PLUGIN_UID"]);
if (count($pluginParts) == 2) {
//Plugins
G::LoadClass("plugin");
//Here we are loading all plugins registered
//The singleton has a list of enabled plugins
$sSerializedFile = PATH_DATA_SITE . "plugin.singleton";
$oPluginRegistry = &PMPluginRegistry::getSingleton();
if (file_exists($sSerializedFile)) {
$oPluginRegistry->unSerializeInstance(file_get_contents($sSerializedFile));
}
$oPluginRegistry = &PMPluginRegistry::getSingleton();
$activePluginsForCaseScheduler = $oPluginRegistry->getCaseSchedulerPlugins();
foreach ($activePluginsForCaseScheduler as $key => $caseSchedulerPlugin) {
if (isset($caseSchedulerPlugin->sNamespace) && $caseSchedulerPlugin->sNamespace == $pluginParts[0] && isset($caseSchedulerPlugin->sActionId) && $caseSchedulerPlugin->sActionId == $pluginParts[1]) {
$caseSchedulerSelected = $caseSchedulerPlugin;
}
}
}
}
//If there is a trigger that is registered to do this then transfer control
if (isset($caseSchedulerSelected) && is_object($caseSchedulerSelected)) {
eprintln(" - Transfering control to a Plugin: " . $caseSchedulerSelected->sNamespace . "/" . $caseSchedulerSelected->sActionId, "green");
$oData = array();
$oData["OBJ_SOAP"] = $client;
$oData["SCH_UID"] = $row["SCH_UID"];
$oData["params"] = $params;
$oData["sessionId"] = $sessionId;
$oData["userId"] = $user;
$paramsLogResultFromPlugin = $oPluginRegistry->executeMethod($caseSchedulerSelected->sNamespace, $caseSchedulerSelected->sActionExecute, $oData);
$paramsLog["WS_CREATE_CASE_STATUS"] = $paramsLogResultFromPlugin["WS_CREATE_CASE_STATUS"];
$paramsLog["WS_ROUTE_CASE_STATUS"] = $paramsLogResultFromPlugin["WS_ROUTE_CASE_STATUS"];
$paramsLogResult = $paramsLogResultFromPlugin["paramsLogResult"];
$paramsRouteLogResult = $paramsLogResultFromPlugin["paramsRouteLogResult"];
} else {
eprintln(" - Creating the new case...");
$paramsAux = $params;
$paramsAux["executeTriggers"] = 1;
$oPluginRegistry = &PMPluginRegistry::getSingleton();
if ($oPluginRegistry->existsTrigger(PM_SCHEDULER_CREATE_CASE_BEFORE)) {
$oPluginRegistry->executeTriggers(PM_SCHEDULER_CREATE_CASE_BEFORE, $paramsAux);
}
$result = $client->__SoapCall("NewCase", array($paramsAux));
if ($oPluginRegistry->existsTrigger (PM_SCHEDULER_CREATE_CASE_AFTER)) {
$oPluginRegistry->executeTriggers(PM_SCHEDULER_CREATE_CASE_AFTER, $result);
}
if ($result->status_code == 0) {
eprintln(" OK case #" . $result->caseNumber . " was created!", "green");
$caseId = $result->caseId;
$caseNumber = $result->caseNumber;
$log[] = $caseNumber . " was created!, ProcessID: " . $row["PRO_UID"];
$paramsLog["WS_CREATE_CASE_STATUS"] = "Case " . $caseNumber . " " . strip_tags($result->message);
$paramsLogResult = "SUCCESS";
$params = array("sessionId" => $sessionId, "caseId" => $caseId, "delIndex" => "1");
try {
eprintln(" - Routing the case #$caseNumber...");
$result = $client->__SoapCall("RouteCase", array($params));
if ($result->status_code == 0) {
$paramsLog["WS_ROUTE_CASE_STATUS"] = strip_tags($result->message);
$retMsg = explode("Debug", $paramsLog["WS_ROUTE_CASE_STATUS"]);
$retMsg = $retMsg[0];
$paramsRouteLogResult = "SUCCESS";
eprintln(" OK $retMsg", "green");
} else {
$paramsLog["WS_ROUTE_CASE_STATUS"] = strip_tags($result->message);
$paramsRouteLogResult = "FAILED";
eprintln(" Failed: " . $paramsLog["WS_ROUTE_CASE_STATUS"], "red");
}
} catch (Exception $e) {
//setExecutionResultMessage("WITH ERRORS", "error");
$paramsLog["WS_ROUTE_CASE_STATUS"] = strip_tags($e->getMessage());
$paramsRouteLogResult = "FAILED";
eprintln(" Failed: " . strip_tags($e->getMessage()), "red");
}
} else {
$paramsLog["WS_CREATE_CASE_STATUS"] = strip_tags($result->message);
$paramsLogResult = "FAILED";
eprintln(" Failed: " . $paramsLog["WS_CREATE_CASE_STATUS"], "red");
}
}
} else {
//Invalid user or bad password
eprintln(" " . $result->message, "red");
}
if ($paramsLogResult == "SUCCESS" && $paramsRouteLogResult == "SUCCESS") {
$paramsLog["RESULT"] = "SUCCESS";
} else {
$paramsLog["RESULT"] = "FAILED";
}
$newCaseLog = new LogCasesScheduler();
$newCaseLog->saveLogParameters($paramsLog);
$newCaseLog->save();
//Update the SCH_TIME_NEXT_RUN field
switch ($caseSchedulerOption) {
case 1:
case 2:
case 3:
//Daily
//Weekly
//Monthly
if ($caseSchedulerTimeNextRunNew == "") {
list($value, $daysPerformTask, $weeks, $startDay, $months) = $this->getVariablesFromRecord($row);
$caseSchedulerTimeNextRunNew = $this->updateNextRun($caseSchedulerOption, $value, $caseSchedulerTimeNextRun, $daysPerformTask, $weeks, $startDay, $months);
}
if ($row["SCH_END_DATE"] . "" != "" && strtotime($row["SCH_END_DATE"]) < strtotime($caseSchedulerTimeNextRunNew)) {
$result = $this->update(array(
"SCH_UID" => $caseSchedulerUid,
"SCH_LAST_STATE" => $row["SCH_STATE"],
"SCH_LAST_RUN_TIME" => $caseSchedulerTimeNextRun,
"SCH_STATE" => "PROCESSED"
));
} else {
$this->updateDate($caseSchedulerUid, $caseSchedulerTimeNextRunNew, $caseSchedulerTimeNextRun);
}
break;
case 4:
//One time only
$result = $this->update(array(
"SCH_UID" => $caseSchedulerUid,
"SCH_LAST_STATE" => $row["SCH_STATE"],
"SCH_LAST_RUN_TIME" => $caseSchedulerTimeNextRun,
"SCH_STATE" => "PROCESSED"
));
break;
case 5:
//Every
if ($caseSchedulerTimeNextRunNew == "") {
$caseSchedulerTimeNextRunNew = date("Y-m-d H:i:s", $timeDate + round(floatval($row["SCH_REPEAT_EVERY"]) * 60 * 60));
}
$this->updateDate($caseSchedulerUid, $caseSchedulerTimeNextRunNew, $caseSchedulerTimeNextRun);
break;
}
}
}
} catch (Exception $e) {
throw $e;
}
}
/**
* this function remove all Process except the PROCESS ROW
*
* @param string $sProUid
* @return boolean
*/
public function removeProcessRows ($sProUid)
{
try {
//Instance all classes necesaries
$oProcess = new Process();
$oDynaform = new Dynaform();
$oInputDocument = new InputDocument();
$oOutputDocument = new OutputDocument();
$oTrigger = new Triggers();
$oStepTrigger = new StepTrigger();
$oRoute = new Route();
$oStep = new Step();
$oSubProcess = new SubProcess();
$oCaseTracker = new CaseTracker();
$oCaseTrackerObject = new CaseTrackerObject();
$oObjectPermission = new ObjectPermission();
$oSwimlaneElement = new SwimlanesElements();
$oConnection = new DbSource();
$oStage = new Stage();
$oEvent = new Event();
$oCaseScheduler = new CaseScheduler();
$oConfig = new Configuration();
//Delete the tasks of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( TaskPeer::PRO_UID, $sProUid );
$oDataset = TaskPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
$oTask = new Task();
while ($aRow = $oDataset->getRow()) {
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( StepTriggerPeer::TAS_UID, $aRow['TAS_UID'] );
StepTriggerPeer::doDelete( $oCriteria );
if ($oTask->taskExists( $aRow['TAS_UID'] )) {
$oTask->remove( $aRow['TAS_UID'] );
}
$oDataset->next();
}
//Delete the dynaforms of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( DynaformPeer::PRO_UID, $sProUid );
$oDataset = DynaformPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
$sWildcard = PATH_DYNAFORM . $aRow['PRO_UID'] . PATH_SEP . $aRow['DYN_UID'] . '_tmp*';
foreach (glob( $sWildcard ) as $fn) {
@unlink( $fn );
}
$sWildcard = PATH_DYNAFORM . $aRow['PRO_UID'] . PATH_SEP . $aRow['DYN_UID'] . '.*';
foreach (glob( $sWildcard ) as $fn) {
@unlink( $fn );
}
if ($oDynaform->dynaformExists( $aRow['DYN_UID'] )) {
$oDynaform->remove( $aRow['DYN_UID'] );
}
$oDataset->next();
}
//Delete the input documents of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( InputDocumentPeer::PRO_UID, $sProUid );
$oDataset = InputDocumentPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oInputDocument->InputExists( $aRow['INP_DOC_UID'] )) {
$oInputDocument->remove( $aRow['INP_DOC_UID'] );
}
$oDataset->next();
}
//Delete the output documents of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( OutputDocumentPeer::PRO_UID, $sProUid );
$oDataset = OutputDocumentPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oOutputDocument->OutputExists( $aRow['OUT_DOC_UID'] )) {
$oOutputDocument->remove( $aRow['OUT_DOC_UID'] );
}
$oDataset->next();
}
//Delete the steps
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( StepPeer::PRO_UID, $sProUid );
$oDataset = StepPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
//Delete the steptrigger of process
/*$oCriteria = new Criteria('workflow');
$oCriteria->add(StepTriggerPeer::STEP_UID, $aRow['STEP_UID']);
$oDataseti = StepTriggerPeer::doSelectRS($oCriteria);
$oDataseti->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$oDataseti->next();
while ($aRowi = $oDataseti->getRow()) {
if ($oStepTrigger->stepTriggerExists($aRowi['STEP_UID'], $aRowi['TAS_UID'], $aRowi['TRI_UID'], $aRowi['ST_TYPE']))
$oStepTrigger->remove($aRowi['STEP_UID'], $aRowi['TAS_UID'], $aRowi['TRI_UID'], $aRowi['ST_TYPE']);
$oDataseti->next();
}*/
$oStep->remove( $aRow['STEP_UID'] );
$oDataset->next();
}
//Delete the StepSupervisor
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( StepSupervisorPeer::PRO_UID, $sProUid );
$oDataset = StepSupervisorPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oStep->StepExists( $aRow['STEP_UID'] )) {
$oStep->remove( $aRow['STEP_UID'] );
}
$oDataset->next();
}
//Delete the triggers of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( TriggersPeer::PRO_UID, $sProUid );
$oDataset = TriggersPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oTrigger->TriggerExists( $aRow['TRI_UID'] )) {
$oTrigger->remove( $aRow['TRI_UID'] );
}
$oDataset->next();
}
//Delete the routes of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( RoutePeer::PRO_UID, $sProUid );
$oDataset = RoutePeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oRoute->routeExists( $aRow['ROU_UID'] )) {
$oRoute->remove( $aRow['ROU_UID'] );
}
$oDataset->next();
}
//Delete the swimlanes elements of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( SwimlanesElementsPeer::PRO_UID, $sProUid );
$oDataset = SwimlanesElementsPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oSwimlaneElement->swimlanesElementsExists( $aRow['SWI_UID'] )) {
$oSwimlaneElement->remove( $aRow['SWI_UID'] );
}
$oDataset->next();
}
//Delete the DB connections of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( DbSourcePeer::PRO_UID, $sProUid );
$oDataset = DbSourcePeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oConnection->Exists( $aRow['DBS_UID'], $aRow['PRO_UID'] )) {
$oConnection->remove( $aRow['DBS_UID'], $aRow['PRO_UID'] );
}
$oDataset->next();
}
//Delete the sub process of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( SubProcessPeer::PRO_PARENT, $sProUid );
$oDataset = SubProcessPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oSubProcess->subProcessExists( $aRow['SP_UID'] )) {
$oSubProcess->remove( $aRow['SP_UID'] );
}
$oDataset->next();
}
//Delete the caseTracker of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( CaseTrackerPeer::PRO_UID, $sProUid );
$oDataset = CaseTrackerPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oCaseTracker->caseTrackerExists( $aRow['PRO_UID'] )) {
$oCaseTracker->remove( $aRow['PRO_UID'] );
}
$oDataset->next();
}
//Delete the caseTrackerObject of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( CaseTrackerObjectPeer::PRO_UID, $sProUid );
$oDataset = CaseTrackerObjectPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oCaseTrackerObject->caseTrackerObjectExists( $aRow['CTO_UID'] )) {
$oCaseTrackerObject->remove( $aRow['CTO_UID'] );
}
$oDataset->next();
}
//Delete the ObjectPermission of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( ObjectPermissionPeer::PRO_UID, $sProUid );
$oDataset = ObjectPermissionPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oObjectPermission->Exists( $aRow['OP_UID'] )) {
$oObjectPermission->remove( $aRow['OP_UID'] );
}
$oDataset->next();
}
//Delete the Stage of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( StagePeer::PRO_UID, $sProUid );
$oDataset = StagePeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oStage->Exists( $aRow['STG_UID'] )) {
$oStage->remove( $aRow['STG_UID'] );
}
$oDataset->next();
}
//Delete the Event of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( EventPeer::PRO_UID, $sProUid );
$oDataset = EventPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oEvent->Exists( $aRow['EVN_UID'] )) {
$oEvent->remove( $aRow['EVN_UID'] );
}
$oDataset->next();
if ($oEvent->existsByTaskUidFrom( $aRow['TAS_UID'] )) {
$aRowEvent = $oEvent->getRowByTaskUidFrom( $aRow['TAS_UID'] );
$oEvent->remove( $aRowEvent['EVN_UID'] );
}
$oDataset->next();
}
//Delete the CaseScheduler of process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( CaseSchedulerPeer::PRO_UID, $sProUid );
$oDataset = CaseSchedulerPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oCaseScheduler->Exists( $aRow['SCH_UID'] )) {
$oCaseScheduler->remove( $aRow['SCH_UID'] );
}
$oDataset->next();
}
//Delete the TaskExtraProperties of the process
$oCriteria = new Criteria( 'workflow' );
$oCriteria->addSelectColumn( ConfigurationPeer::CFG_UID );
$oCriteria->addSelectColumn( ConfigurationPeer::OBJ_UID );
$oCriteria->addSelectColumn( ConfigurationPeer::CFG_VALUE );
$oCriteria->addSelectColumn( TaskPeer::PRO_UID );
$oCriteria->addSelectColumn( ConfigurationPeer::USR_UID );
$oCriteria->addSelectColumn( ConfigurationPeer::APP_UID );
$oCriteria->add( TaskPeer::PRO_UID, $sProUid );
$oCriteria->add( ConfigurationPeer::CFG_UID, 'TAS_EXTRA_PROPERTIES' );
$oCriteria->addJoin( ConfigurationPeer::OBJ_UID, TaskPeer::TAS_UID );
$oDataset = ConfigurationPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
if ($oConfig->exists($aRow['CFG_UID'], $aRow['OBJ_UID'], $aRow['PRO_UID'], $aRow['USR_UID'], $aRow['APP_UID'])) {
$oConfig->remove( $aRow['CFG_UID'], $aRow['OBJ_UID'], $aRow['PRO_UID'], $aRow['USR_UID'], $aRow['APP_UID'] );
}
$oDataset->next();
}
return true;
} catch (Exception $oError) {
throw ($oError);
}
}
/**
* Method to do selects.
*
* @param Criteria $criteria The Criteria object used to build the SELECT statement.
* @param Connection $con
* @return array Array of selected Objects
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelect(Criteria $criteria, $con = null)
{
return CaseSchedulerPeer::populateObjects(CaseSchedulerPeer::doSelectRS($criteria, $con));
}
public function caseSchedulerCron($date, &$log = array(), $cron = 0)
{
G::LoadClass('dates');
require_once 'classes/model/LogCasesScheduler.php';
$oDates = new dates();
$nTime = strtotime($date);
$dCurrentDate = date('Y-m-d', $nTime) . ' 00:00:00';
$dNextDay = date('Y-m-d', strtotime("{$dCurrentDate}")) . ' 23:59:59';
$oCriteria = $this->getAllCriteria();
$oCriteria->addAnd(CaseSchedulerPeer::SCH_STATE, 'INACTIVE', Criteria::NOT_EQUAL);
$oCriteria->addAnd(CaseSchedulerPeer::SCH_STATE, 'PROCESSED', Criteria::NOT_EQUAL);
$oCriteria->add($oCriteria->getNewCriterion(CaseSchedulerPeer::SCH_TIME_NEXT_RUN, $dCurrentDate, Criteria::GREATER_EQUAL)->addAnd($oCriteria->getNewCriterion(CaseSchedulerPeer::SCH_TIME_NEXT_RUN, $dNextDay, Criteria::LESS_EQUAL))->addOr($oCriteria->getNewCriterion(CaseSchedulerPeer::SCH_OPTION, '5', Criteria::GREATER_EQUAL)));
$oCriteria->add(CaseSchedulerPeer::SCH_END_DATE, null, Criteria::EQUAL);
$oCriteria->addOr(CaseSchedulerPeer::SCH_END_DATE, $dCurrentDate, Criteria::GREATER_EQUAL);
$oDataset = CaseSchedulerPeer::doSelectRS($oCriteria);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$oDataset->next();
$sValue = '';
$sActualTime = '';
$sDaysPerformTask = '';
$sWeeks = '';
$sStartDay = '';
$sMonths = '';
while ($aRow = $oDataset->getRow()) {
if ($cron == 1) {
$arrayCron = unserialize(trim(@file_get_contents(PATH_DATA . "cron")));
$arrayCron["processcTimeStart"] = time();
@file_put_contents(PATH_DATA . "cron", serialize($arrayCron));
}
$sSchedulerUid = $aRow['SCH_UID'];
$sOption = $aRow['SCH_OPTION'];
switch ($sOption) {
case '1':
$sDaysPerformTask = $aRow['SCH_DAYS_PERFORM_TASK'];
$aDaysPerformTask = explode('|', $sDaysPerformTask);
$sValue = $aDaysPerformTask[0];
if ($sValue != 1) {
$sDaysPerformTask = $aDaysPerformTask[1];
}
break;
case '2':
$sDaysPerformTask = $aRow['SCH_EVERY_DAYS'];
$sWeeks = $aRow['SCH_WEEK_DAYS'];
break;
case '3':
$sStartDay = $aRow['SCH_START_DAY'];
$sMonths = $aRow['SCH_MONTHS'];
$aStartDay = explode('|', $sStartDay);
$sValue = $aStartDay[0];
break;
case '4':
$aRow['SCH_STATE'] = 'PROCESSED';
break;
case '5':
break;
}
$sActualTime = $aRow['SCH_TIME_NEXT_RUN'];
$sActualDataHour = date('H', strtotime($aRow['SCH_TIME_NEXT_RUN']));
$sActualDataMinutes = date('i', strtotime($aRow['SCH_TIME_NEXT_RUN']));
$dActualSysHour = date('H', $nTime);
$dActualSysHour = $dActualSysHour == '00' ? '24' : $dActualSysHour;
$dActualSysMinutes = date('i', $nTime);
$sActualDataTime = strtotime($aRow['SCH_TIME_NEXT_RUN']);
$sActualSysTime = strtotime($nTime);
// note added consider the posibility to encapsulate some in functionality in a class method or some funtions
if ($sActualDataHour < $dActualSysHour) {
$_PORT = SERVER_PORT != '80' ? ':' . SERVER_PORT : '';
$defaultEndpoint = 'http://' . SERVER_NAME . $_PORT . '/sys' . SYS_SYS . '/' . SYS_LANG . '/classic/services/wsdl2';
println(" - Connecting webservice: {$defaultEndpoint}");
$user = $aRow["SCH_DEL_USER_NAME"];
$pass = $aRow["SCH_DEL_USER_PASS"];
$processId = $aRow["PRO_UID"];
$taskId = $aRow["TAS_UID"];
$client = new SoapClient($defaultEndpoint);
$params = array('userid' => $user, 'password' => 'md5:' . $pass);
$result = $client->__SoapCall('login', array($params));
eprint(" - Logging as user {$user}.............");
if ($result->status_code == 0) {
eprintln("OK+", 'green');
$sessionId = $result->message;
$newCaseLog = new LogCasesScheduler();
$newRouteLog = new LogCasesScheduler();
$variables = array();
$params = array('sessionId' => $sessionId, 'processId' => $processId, 'taskId' => $taskId, 'variables' => $variables);
$paramsLog = array('PRO_UID' => $processId, 'TAS_UID' => $taskId, 'SCH_UID' => $sSchedulerUid, 'USR_NAME' => $user, 'RESULT' => '', 'EXEC_DATE' => date('Y-m-d'), 'EXEC_HOUR' => date('H:i:s'), 'WS_CREATE_CASE_STATUS' => '', 'WS_ROUTE_CASE_STATUS' => '');
$sw_transfer_control_plugin = false;
//This SW will be true only if a plugin is allowed to continue the action
//If this Job was was registered to be performed by a plugin
if (isset($aRow['CASE_SH_PLUGIN_UID']) && $aRow['CASE_SH_PLUGIN_UID'] != "") {
//Check if the plugin is active
$pluginParts = explode("--", $aRow['CASE_SH_PLUGIN_UID']);
if (count($pluginParts) == 2) {
//***************** Plugins **************************
G::LoadClass('plugin');
//here we are loading all plugins registered
//the singleton has a list of enabled plugins
$sSerializedFile = PATH_DATA_SITE . 'plugin.singleton';
$oPluginRegistry =& PMPluginRegistry::getSingleton();
if (file_exists($sSerializedFile)) {
$oPluginRegistry->unSerializeInstance(file_get_contents($sSerializedFile));
}
$oPluginRegistry =& PMPluginRegistry::getSingleton();
$activePluginsForCaseScheduler = $oPluginRegistry->getCaseSchedulerPlugins();
foreach ($activePluginsForCaseScheduler as $key => $caseSchedulerPlugin) {
if (isset($caseSchedulerPlugin->sNamespace) && $caseSchedulerPlugin->sNamespace == $pluginParts[0] && isset($caseSchedulerPlugin->sActionId) && $caseSchedulerPlugin->sActionId == $pluginParts[1]) {
$sw_transfer_control_plugin = true;
$caseSchedulerSelected = $caseSchedulerPlugin;
}
}
}
}
//If there is a trigger that is registered to do this then transfer control
if (isset($caseSchedulerSelected) && is_object($caseSchedulerSelected)) {
eprintln(" - Transfering control to a Plugin: " . $caseSchedulerSelected->sNamespace . "/" . $caseSchedulerSelected->sActionId, 'green');
$oData['OBJ_SOAP'] = $client;
$oData['SCH_UID'] = $aRow['SCH_UID'];
$oData['params'] = $params;
$oData['sessionId'] = $sessionId;
$oData['userId'] = $user;
$paramsLogResultFromPlugin = $oPluginRegistry->executeMethod($caseSchedulerSelected->sNamespace, $caseSchedulerSelected->sActionExecute, $oData);
$paramsLog['WS_CREATE_CASE_STATUS'] = $paramsLogResultFromPlugin['WS_CREATE_CASE_STATUS'];
$paramsLog['WS_ROUTE_CASE_STATUS'] = $paramsLogResultFromPlugin['WS_ROUTE_CASE_STATUS'];
$paramsLogResult = $paramsLogResultFromPlugin['paramsLogResult'];
$paramsRouteLogResult = $paramsLogResultFromPlugin['paramsRouteLogResult'];
} else {
eprint(" - Creating the new case.............");
$paramsAux = $params;
$paramsAux["executeTriggers"] = 1;
$result = $client->__SoapCall("NewCase", array($paramsAux));
if ($result->status_code == 0) {
eprintln("OK+ CASE #{$result->caseNumber} was created!", 'green');
$caseId = $result->caseId;
$caseNumber = $result->caseNumber;
$log[] = $caseNumber . ' was created!, ProcessID: ' . $aRow['PRO_UID'];
$paramsLog['WS_CREATE_CASE_STATUS'] = "Case " . $caseNumber . " " . strip_tags($result->message);
$paramsLogResult = 'SUCCESS';
$params = array('sessionId' => $sessionId, 'caseId' => $caseId, 'delIndex' => "1");
eprint(" - Routing the case #{$caseNumber}..............");
try {
$result = $client->__SoapCall('RouteCase', array($params));
if ($result->status_code == 0) {
$paramsLog['WS_ROUTE_CASE_STATUS'] = strip_tags($result->message);
$retMsg = explode("Debug", $paramsLog['WS_ROUTE_CASE_STATUS']);
$retMsg = $retMsg[0];
eprintln("OK+ {$retMsg}", 'green');
$paramsRouteLogResult = 'SUCCESS';
} else {
$paramsLog['WS_ROUTE_CASE_STATUS'] = strip_tags($result->message);
eprintln("FAILED-> {$paramsLog['WS_ROUTE_CASE_STATUS']}", 'red');
$paramsRouteLogResult = 'FAILED';
}
} catch (Exception $oError) {
setExecutionResultMessage(' WITH ERRORS', 'error');
$paramsLog['WS_ROUTE_CASE_STATUS'] = strip_tags($oError->getMessage());
eprintln(" '-" . strip_tags($oError->getMessage()), 'red');
$paramsRouteLogResult = 'FAILED';
}
} else {
$paramsLog['WS_CREATE_CASE_STATUS'] = strip_tags($result->message);
$paramsLogResult = 'FAILED';
}
}
} else {
eprintln($result->message, 'red');
// invalid user or bad password
}
if ($paramsLogResult == 'SUCCESS' && $paramsRouteLogResult == 'SUCCESS') {
$paramsLog['RESULT'] = 'SUCCESS';
} else {
$paramsLog['RESULT'] = 'FAILED';
}
$newCaseLog->saveLogParameters($paramsLog);
$newCaseLog->save();
if ($sOption != '4' && $sOption != '5') {
$nSchLastRunTime = $sActualTime;
$dEstimatedDate = $this->updateNextRun($sOption, $sValue, $sActualTime, $sDaysPerformTask, $sWeeks, $sStartDay, $sMonths);
if ($aRow['SCH_END_DATE'] != '') {
if (date("Y-m-d", strtotime($dEstimatedDate)) > date("Y-m-d", strtotime($aRow['SCH_END_DATE']))) {
$Fields = $this->Load($sSchedulerUid);
$Fields['SCH_LAST_STATE'] = $aRow['SCH_STATE'];
$Fields['SCH_STATE'] = 'PROCESSED';
$this->Update($Fields);
}
}
$nSchTimeNextRun = $dEstimatedDate;
$this->updateDate($sSchedulerUid, $nSchTimeNextRun, $nSchLastRunTime);
} elseif ($sOption != '5') {
$Fields = $this->Load($sSchedulerUid);
$Fields['SCH_LAST_STATE'] = $aRow['SCH_STATE'];
$Fields['SCH_LAST_RUN_TIME'] = $Fields['SCH_TIME_NEXT_RUN'];
$Fields['SCH_STATE'] = 'PROCESSED';
$this->Update($Fields);
} else {
$nSchLastRunTime = $sActualTime;
$Fields = $this->Load($sSchedulerUid);
$Fields['SCH_LAST_RUN_TIME'] = $Fields['SCH_TIME_NEXT_RUN'];
//$nSchTimeNextRun = strtotime( $Fields['SCH_TIME_NEXT_RUN'] );
$nSchTimeNextRun = $nTime;
$nextRun = $Fields['SCH_REPEAT_EVERY'] * 60 * 60;
$nSchTimeNextRun += $nextRun;
$nSchTimeNextRun = date("Y-m-d H:i", $nSchTimeNextRun);
$this->updateDate($sSchedulerUid, $nSchTimeNextRun, $nSchLastRunTime);
}
} elseif ($sActualDataHour == $dActualSysHour && $sActualDataMinutes <= $dActualSysMinutes) {
$_PORT = '';
if (isset($_SERVER['SERVER_PORT'])) {
$_PORT = $_SERVER['SERVER_PORT'] != '80' ? ':' . $_SERVER['SERVER_PORT'] : '';
} elseif (defined('SERVER_PORT')) {
$_PORT = SERVER_PORT != '80' ? ':' . SERVER_PORT : '';
}
//$defaultEndpoint = 'http://' . $_SERVER ['SERVER_NAME'] . ':' . $_PORT . '/sys' . SYS_SYS .'/'.SYS_LANG.'/classic/green/services/wsdl2';
$defaultEndpoint = 'http://' . SERVER_NAME . $_PORT . '/sys' . SYS_SYS . '/' . SYS_LANG . '/classic/services/wsdl2';
println(" - Connecting webservice: {$defaultEndpoint}");
$user = $aRow["SCH_DEL_USER_NAME"];
$pass = $aRow["SCH_DEL_USER_PASS"];
$processId = $aRow["PRO_UID"];
$taskId = $aRow["TAS_UID"];
$client = new SoapClient($defaultEndpoint);
$params = array('userid' => $user, 'password' => 'md5:' . $pass);
$result = $client->__SoapCall('login', array($params));
eprint(" - Logging as user {$user}.............");
if ($result->status_code == 0) {
eprintln("OK+", 'green');
$sessionId = $result->message;
$newCaseLog = new LogCasesScheduler();
$newRouteLog = new LogCasesScheduler();
$variables = array();
$params = array('sessionId' => $sessionId, 'processId' => $processId, 'taskId' => $taskId, 'variables' => $variables);
$paramsLog = array('PRO_UID' => $processId, 'TAS_UID' => $taskId, 'SCH_UID' => $sSchedulerUid, 'USR_NAME' => $user, 'RESULT' => '', 'EXEC_DATE' => date('Y-m-d'), 'EXEC_HOUR' => date('H:i:s'), 'WS_CREATE_CASE_STATUS' => '', 'WS_ROUTE_CASE_STATUS' => '');
$paramsAux = $params;
$paramsAux["executeTriggers"] = 1;
$result = $client->__SoapCall("NewCase", array($paramsAux));
eprint(" - Creating the new case.............");
if ($result->status_code == 0) {
eprintln("OK+ CASE #{$result->caseNumber} was created!", 'green');
$caseId = $result->caseId;
$caseNumber = $result->caseNumber;
$log[] = $caseNumber . ' was created!, ProcessID: ' . $aRow['PRO_UID'];
$paramsLog['WS_CREATE_CASE_STATUS'] = "Case " . $caseNumber . " " . strip_tags($result->message);
$paramsLogResult = 'SUCCESS';
$params = array('sessionId' => $sessionId, 'caseId' => $caseId, 'delIndex' => "1");
try {
$result = $client->__SoapCall('RouteCase', array($params));
eprint(" - Routing the case #{$caseNumber}..............");
if ($result->status_code == 0) {
$paramsLog['WS_ROUTE_CASE_STATUS'] = strip_tags($result->message);
$retMsg = explode("Debug", $paramsLog['WS_ROUTE_CASE_STATUS']);
$retMsg = $retMsg[0];
eprintln("OK+ {$retMsg}", 'green');
$paramsRouteLogResult = 'SUCCESS';
} else {
eprintln("FAILED-> {$paramsLog['WS_ROUTE_CASE_STATUS']}", 'red');
$paramsLog['WS_ROUTE_CASE_STATUS'] = strip_tags($result->message);
$paramsRouteLogResult = 'FAILED';
}
} catch (Exception $oError) {
setExecutionResultMessage(' WITH ERRORS', 'error');
$paramsLog['WS_ROUTE_CASE_STATUS'] = strip_tags($oError->getMessage());
eprintln(" '-" . strip_tags($oError->getMessage()), 'red');
$paramsRouteLogResult = 'FAILED';
}
} else {
$paramsLog['WS_CREATE_CASE_STATUS'] = strip_tags($result->message);
eprintln("FAILED->{$paramsLog['WS_CREATE_CASE_STATUS']}", 'red');
$paramsLogResult = 'FAILED';
}
} else {
// invalid user or bad password
eprintln($result->message, 'red');
}
if ($paramsLogResult == 'SUCCESS' && $paramsRouteLogResult == 'SUCCESS') {
$paramsLog['RESULT'] = 'SUCCESS';
} else {
$paramsLog['RESULT'] = 'FAILED';
}
$newCaseLog->saveLogParameters($paramsLog);
$newCaseLog->save();
if ($sOption != '4' && $sOption != '5') {
$nSchLastRunTime = $sActualTime;
$dEstimatedDate = $this->updateNextRun($sOption, $sValue, $sActualTime, $sDaysPerformTask, $sWeeks, $sStartDay, $sMonths);
if ($aRow['SCH_END_DATE'] != '') {
if (date("Y-m-d", strtotime($dEstimatedDate)) > date("Y-m-d", strtotime($aRow['SCH_END_DATE']))) {
$Fields = $this->Load($sSchedulerUid);
$Fields['SCH_LAST_STATE'] = $aRow['SCH_STATE'];
$Fields['SCH_STATE'] = 'PROCESSED';
$this->Update($Fields);
}
}
$nSchTimeNextRun = $dEstimatedDate;
$this->updateDate($sSchedulerUid, $nSchTimeNextRun, $nSchLastRunTime);
} elseif ($sOption != '5') {
$Fields = $this->Load($sSchedulerUid);
$Fields['SCH_LAST_STATE'] = $aRow['SCH_STATE'];
$Fields['SCH_LAST_RUN_TIME'] = $Fields['SCH_TIME_NEXT_RUN'];
$Fields['SCH_STATE'] = 'PROCESSED';
$this->Update($Fields);
} else {
$nSchLastRunTime = $sActualTime;
$Fields = $this->Load($sSchedulerUid);
$Fields['SCH_LAST_RUN_TIME'] = $Fields['SCH_TIME_NEXT_RUN'];
//$nSchTimeNextRun = strtotime( $Fields['SCH_TIME_NEXT_RUN'] );
$nSchTimeNextRun = $nTime;
$nextRun = $Fields['SCH_REPEAT_EVERY'] * 60 * 60;
$nSchTimeNextRun += $nextRun;
$nSchTimeNextRun = date("Y-m-d H:i", $nSchTimeNextRun);
$this->updateDate($sSchedulerUid, $nSchTimeNextRun, $nSchLastRunTime);
}
}
$oDataset->next();
}
}
/**
* Checks if the name exists in the case Scheduler
*
* @param string $processUid Unique id of Process
* @param string $name Name
*
* return bool Return true if the name exists, false otherwise
*/
public function existsNameUpdate($processUid, $schUid, $name)
{
try {
$criteria = new \Criteria("workflow");
$criteria->addSelectColumn(\CaseSchedulerPeer::TAS_UID);
$criteria->add(\CaseSchedulerPeer::SCH_NAME, $name, \Criteria::EQUAL);
$criteria->add(\CaseSchedulerPeer::SCH_UID, $schUid, \Criteria::NOT_EQUAL);
$criteria->add(\CaseSchedulerPeer::PRO_UID, $processUid, \Criteria::EQUAL);
$rsCriteria = \CaseSchedulerPeer::doSelectRS($criteria);
$rsCriteria->setFetchmode(\ResultSet::FETCHMODE_ASSOC);
$rsCriteria->next();
return $rsCriteria->getRow();
} catch (\Exception $e) {
throw $e;
}
}
