/** * reassign Case * * @param string sessionId : The session ID (which was obtained during login) * @param string caseId : The case ID (which can be obtained with the caseList() function) * @param string delIndex : The delegation index number of the case (which can be obtained with the caseList() * function). * @param string userIdSource : The user who is currently assigned the case. * @param string userIdTarget : The target user who will be newly assigned to the case. * @return $result will return an object */ public function reassignCase ($sessionId, $caseId, $delIndex, $userIdSource, $userIdTarget) { $g = new G(); try { $g->sessionVarSave(); $_SESSION["APPLICATION"] = $caseId; $_SESSION["INDEX"] = $delIndex; $_SESSION["USER_LOGGED"] = $userIdSource; if ($userIdTarget == $userIdSource) { $result = new wsResponse( 30, G::loadTranslation( 'ID_TARGET_ORIGIN_USER_SAME' ) ); $g->sessionVarRestore(); return $result; } /** * ****************( 1 )***************** */ $oCriteria = new Criteria( 'workflow' ); $oCriteria->add( UsersPeer::USR_STATUS, 'ACTIVE' ); $oCriteria->add( UsersPeer::USR_UID, $userIdSource ); $oDataset = UsersPeer::doSelectRS( $oCriteria ); $oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC ); $oDataset->next(); $aRow = $oDataset->getRow(); if (! is_array( $aRow )) { $result = new wsResponse( 31, G::loadTranslation( 'ID_INVALID_ORIGIN_USER' ) ); $g->sessionVarRestore(); return $result; } /** * ****************( 2 )***************** */ $oCase = new Cases(); $rows = $oCase->loadCase( $caseId ); if (! is_array( $aRow )) { $result = new wsResponse( 32, G::loadTranslation( 'ID_CASE_NOT_OPEN' ) ); $g->sessionVarRestore(); return $result; } /** * ****************( 3 )***************** */ $oCriteria = new Criteria( 'workflow' ); $aConditions = array (); // $aConditions[] = array(AppDelegationPeer::USR_UID, TaskUserPeer::USR_UID); // $aConditions[] = array(AppDelegationPeer::TAS_UID, TaskUserPeer::TAS_UID); // $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); //$oCriteria->addJoin(AppDelegationPeer::USR_UID, TaskUserPeer::USR_UID, Criteria::LEFT_JOIN); $oCriteria->add( AppDelegationPeer::APP_UID, $caseId ); $oCriteria->add( AppDelegationPeer::USR_UID, $userIdSource ); $oCriteria->add( AppDelegationPeer::DEL_INDEX, $delIndex ); $oCriteria->add( AppDelegationPeer::DEL_FINISH_DATE, null, Criteria::ISNULL ); $oDataset = AppDelegationPeer::doSelectRS( $oCriteria ); $oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC ); $oDataset->next(); $aRow = $oDataset->getRow(); if (! is_array( $aRow )) { $result = new wsResponse( 33, G::loadTranslation( 'ID_INVALID_CASE_DELEGATION_INDEX' ) ); $g->sessionVarRestore(); return $result; } $tasUid = $aRow['TAS_UID']; $derivation = new Derivation(); $userList = $derivation->getAllUsersFromAnyTask($tasUid, true); if (! in_array( $userIdTarget, $userList )) { $result = new wsResponse( 34, G::loadTranslation( 'ID_TARGET_USER_DOES_NOT_HAVE_RIGHTS' ) ); $g->sessionVarRestore(); return $result; } /** * ****************( 4 )***************** */ $oCriteria = new Criteria( 'workflow' ); $oCriteria->add( UsersPeer::USR_STATUS, 'ACTIVE' ); $oCriteria->add( UsersPeer::USR_UID, $userIdTarget ); $oDataset = UsersPeer::doSelectRS( $oCriteria ); $oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC ); $oDataset->next(); $aRow = $oDataset->getRow(); if (! is_array( $aRow )) { $result = new wsResponse( 35, G::loadTranslation( 'ID_TARGET_USER_DESTINATION_INVALID' ) ); $g->sessionVarRestore(); return $result; } /** * ****************( 5 )***************** */ $var = $oCase->reassignCase( $caseId, $delIndex, $userIdSource, $userIdTarget ); if (! $var) { $result = new wsResponse( 36, G::loadTranslation( 'ID_CASE_COULD_NOT_REASSIGNED' ) ); $g->sessionVarRestore(); return $result; } $result = new wsResponse( 0, G::loadTranslation( 'ID_COMMAND_EXECUTED_SUCCESSFULLY' ) ); $g->sessionVarRestore(); return $result; } catch (Exception $e) { $result[] = array ('guid' => $e->getMessage(),'name' => $e->getMessage() ); $g->sessionVarRestore(); return $result; } }
/** * This function creates transitions * @param array $routes * @param array $tasks * @return array */ function createTransitionsXpdl($routes, $tasks, $taskHidden) { $cont = 0; $dataRoutes = ''; $endEvent = 1; $taskParallel = ''; $routeParallel = ''; $taskSecJoin = ''; $routeSecJoin = ''; $taskEvaluate = ''; $routeEvaluate = ''; $taskParallelEv = ''; $routeParallelEv = ''; $taskSelect = ''; $routeSelect = ''; $routeEnd = ''; $arraySecJoin = array(); $position = 0; $fillColor = ''; $transitions = ''; $condition = ''; $nextTask = ''; $findFrom = 0; $findTo = 0; $routesTasks = $routes; foreach ($routes as $key => $row) { if ($row['ROU_TYPE'] == 'SEC-JOIN') { $arraySecJoin[$position] = array(); $arraySecJoin[$position] = $row; $position = $position + 1; unset($routes[$key]); } } $aux = $arraySecJoin; foreach ($arraySecJoin as $key => $row) { $aux[$key] = $row['ROU_NEXT_TASK']; } if (sizeof($arraySecJoin) > 0) { array_multisort($aux, SORT_ASC, $arraySecJoin); unset($aux); } foreach ($routes as $key => $row) { $uid[$key] = $row['TAS_UID']; $case[$key] = $row['ROU_CASE']; } if (sizeof($routes) > 0) { array_multisort($uid, SORT_ASC, $case, SORT_ASC, $routes); } $routes = array_merge($routes, $arraySecJoin); $routesTasks = $routes; foreach ($routes as $key => $val) { $end = 0; $idRoute = $val['ROU_UID']; $idTask = $val['TAS_UID']; $nextTask = $val['ROU_NEXT_TASK']; $condition = htmlentities($val['ROU_CONDITION']); if ($nextTask == "-1") { $end = 1; } $typeRoute = $val['ROU_TYPE']; $route = ''; if ($typeRoute != "SEQUENTIAL") { switch ($typeRoute) { case 'PARALLEL': $coordinateX = 0; $coordinateY = 0; foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; } } foreach ($taskHidden as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; $idRoute = $idTask; } } $positionX = $coordinateX + 60; $positionY = $coordinateY + 40; if ($idTask != $taskParallel) { $taskParallel = $idTask; $routeParallel = $idRoute; $dataRoutes .= ' <Activity Id="' . $routeParallel . '"> <Description /> <Route GatewayType="AND" /> <Documentation /> <ExtendedAttributes /> <NodeGraphicsInfos> <NodeGraphicsInfo ToolId="Processmaker" Height="30" Width="30" BorderColor="-5855715" FillColor="' . $fillColor . '"> <Coordinates XCoordinate="' . $positionX . '" YCoordinate="' . $positionY . '" /> </NodeGraphicsInfo> </NodeGraphicsInfos> <IsForCompensationSpecified>false</IsForCompensationSpecified> </Activity>'; if ($taskParallel != $routeParallel) { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $taskParallel . '" To="' . $routeParallel . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeParallel . '" To="' . $nextTask . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } else { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeParallel . '" To="' . $nextTask . '" Name=""> <Condition/> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } break; case 'SEC-JOIN': $coordinateX = 0; $coordinateY = 0; foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $nextTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; } } foreach ($taskHidden as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; $idRoute = $idTask; } } $positionX = $coordinateX + 60; $positionY = $coordinateY - 45; if ($nextTask != $taskSecJoin) { $taskSecJoin = $nextTask; $routeSecJoin = $idRoute; $dataRoutes .= ' <Activity Id="' . $routeSecJoin . '"> <Description /> <Route GatewayType="AND" /> <Documentation /> <ExtendedAttributes /> <NodeGraphicsInfos> <NodeGraphicsInfo ToolId="Processmaker" Height="30" Width="30" BorderColor="-5855715" FillColor="' . $fillColor . '"> <Coordinates XCoordinate="' . $positionX . '" YCoordinate="' . $positionY . '" /> </NodeGraphicsInfo> </NodeGraphicsInfos> <IsForCompensationSpecified>false</IsForCompensationSpecified> </Activity>'; if ($routeSecJoin != $taskSecJoin) { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeSecJoin . '" To="' . $taskSecJoin . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $idTask . '" To="' . $routeSecJoin . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } else { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $idTask . '" To="' . $routeSecJoin . '" Name=""> <Condition/> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } break; case 'EVALUATE': $coordinateX = 0; $coordinateY = 0; foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; } } foreach ($taskHidden as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; $idRoute = $idTask; } } $positionX = $coordinateX + 60; $positionY = $coordinateY + 40; if ($idTask != $taskEvaluate) { $taskEvaluate = $idTask; $routeEvaluate = $idRoute; if ($nextTask != "-1") { $dataRoutes .= ' <Activity Id="' . $routeEvaluate . '"> <Description /> <Route MarkerVisible="true"/> <Documentation /> <ExtendedAttributes /> <NodeGraphicsInfos> <NodeGraphicsInfo ToolId="Processmaker" Height="30" Width="30" BorderColor="-5855715" FillColor="' . $fillColor . '"> <Coordinates XCoordinate="' . $positionX . '" YCoordinate="' . $positionY . '" /> </NodeGraphicsInfo> </NodeGraphicsInfos> <IsForCompensationSpecified>false</IsForCompensationSpecified> </Activity>'; if ($taskEvaluate != $routeEvaluate) { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $taskEvaluate . '" To="' . $routeEvaluate . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeEvaluate . '" To="' . $nextTask . '" Name=""> <Condition Type="CONDITION"> <Expression>' . $condition . '</Expression> </Condition> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } } else { if ($nextTask != "-1") { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeEvaluate . '" To="' . $nextTask . '" Name=""> <Condition Type="CONDITION"> <Expression>' . $condition . '</Expression> </Condition> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } else { $routeEnd = $routeEvaluate; } } break; case 'PARALLEL-BY-EVALUATION': $coordinateX = 0; $coordinateY = 0; foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; } } foreach ($taskHidden as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; $idRoute = $idTask; } } $positionX = $coordinateX + 60; $positionY = $coordinateY + 40; if ($idTask != $taskParallelEv) { $taskParallelEv = $idTask; $routeParallelEv = $idRoute; $dataRoutes .= ' <Activity Id="' . $routeParallelEv . '"> <Description /> <Route GatewayType="OR"/> <Documentation /> <ExtendedAttributes /> <NodeGraphicsInfos> <NodeGraphicsInfo ToolId="Processmaker" Height="30" Width="30" BorderColor="-5855715" FillColor="' . $fillColor . '"> <Coordinates XCoordinate="' . $positionX . '" YCoordinate="' . $positionY . '" /> </NodeGraphicsInfo> </NodeGraphicsInfos> <IsForCompensationSpecified>false</IsForCompensationSpecified> </Activity>'; if ($taskParallelEv != $routeParallelEv) { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $taskParallelEv . '" To="' . $routeParallelEv . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeParallelEv . '" To="' . $nextTask . '" Name=""> <Condition Type="CONDITION"> <Expression>' . $condition . '</Expression> </Condition> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } else { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeParallelEv . '" To="' . $nextTask . '" Name=""> <Condition Type="CONDITION"> <Expression>' . $condition . '</Expression> </Condition> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } break; case 'SELECT': $coordinateX = 0; $coordinateY = 0; foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; } } foreach ($taskHidden as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; $idRoute = $idTask; } } $positionX = $coordinateX + 60; $positionY = $coordinateY + 40; if ($idTask != $taskSelect) { $taskSelect = $idTask; $routeSelect = $idRoute; $dataRoutes .= ' <Activity Id="' . $routeSelect . '"> <Description /> <Route GatewayType="Complex" /> <Documentation /> <ExtendedAttributes /> <NodeGraphicsInfos> <NodeGraphicsInfo ToolId="Processmaker" Height="30" Width="30" BorderColor="-5855715" FillColor="' . $fillColor . '"> <Coordinates XCoordinate="' . $positionX . '" YCoordinate="' . $positionY . '" /> </NodeGraphicsInfo> </NodeGraphicsInfos> <IsForCompensationSpecified>false</IsForCompensationSpecified> </Activity>'; if ($taskSelect != $routeSelect) { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $taskSelect . '" To="' . $routeSelect . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeSelect . '" To="' . $nextTask . '" Name=""> <Condition Type="CONDITION"> <Expression>' . $condition . '</Expression> </Condition> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } else { if ($nextTask != "-1") { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeSelect . '" To="' . $nextTask . '" Name=""> <Condition Type="CONDITION"> <Expression>' . $condition . '</Expression> </Condition> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } else { $routeEnd = $routeSelect; } } break; case 'DISCRIMINATOR': $coordinateX = 0; $coordinateY = 0; $optional = $val['ROU_OPTIONAL']; foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $nextTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; } } foreach ($taskHidden as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; $idRoute = $idTask; } } $positionX = $coordinateX + 60; $positionY = $coordinateY - 45; if ($nextTask != $taskSecJoin) { $taskDiscriminator = $nextTask; $routeDiscriminator = $idRoute; $dataRoutes .= ' <Activity Id="' . $routeDiscriminator . '"> <Description /> <Route GatewayType="Complex" /> <Documentation /> <ExtendedAttributes> <ExtendedAttribute Name="option" Value="' . $optional . '" /> <ExtendedAttribute Name="condition" Value="' . $condition . '" /> </ExtendedAttributes> <NodeGraphicsInfos> <NodeGraphicsInfo ToolId="Processmaker" Height="30" Width="30" BorderColor="-5855715" FillColor="' . $fillColor . '"> <Coordinates XCoordinate="' . $positionX . '" YCoordinate="' . $positionY . '" /> </NodeGraphicsInfo> </NodeGraphicsInfos> <IsForCompensationSpecified>false</IsForCompensationSpecified> </Activity>'; if ($routeDiscriminator != $taskDiscriminator) { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $routeDiscriminator . '" To="' . $taskDiscriminator . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $idTask . '" To="' . $routeDiscriminator . '" Name=""> <Condition /> <Description /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } else { $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $idTask . '" To="' . $routeDiscriminator . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } break; } } if ($end == 1) { if ($typeRoute == "SEQUENTIAL") { $coordinateX = 0; $coordinateY = 0; foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; } } $positionX = $coordinateX + 65; $positionY = $coordinateY + 40; $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $idTask . '" To="' . $idRoute . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } else { $coordinateX = 0; $coordinateY = 0; foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX']; $coordinateY = $idVal['TAS_POSY']; } } $positionX = $coordinateX + 120; $positionY = $coordinateY + 40; $idTask = $routeEnd; $transitions .= ' <Transition Id="' . G::generateUniqueID() . '" From="' . $idTask . '" To="' . $idRoute . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="4" ToPort="3"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } $dataRoutes .= ' <Activity Id="' . $idRoute . '"> <Description /> <Event> <EndEvent /> </Event> <Documentation /> <ExtendedAttributes /> <NodeGraphicsInfos> <NodeGraphicsInfo ToolId="Processmaker" Height="30" Width="30" BorderColor="-6750208" FillColor="' . $fillColor . '"> <Coordinates XCoordinate="' . $positionX . '" YCoordinate="' . $positionY . '" /> </NodeGraphicsInfo> </NodeGraphicsInfos> <IsForCompensationSpecified>false</IsForCompensationSpecified> </Activity>'; $end = 0; $endEvent = 0; } else { if ($typeRoute == "SEQUENTIAL") { $transitions .= ' <Transition Id="' . $idRoute . '" From="' . $idTask . '" To="' . $nextTask . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="2" ToPort="1"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } foreach ($tasks as $taskVal => $idVal) { if ($idVal['TAS_UID'] == $idTask) { $coordinateX = $idVal['TAS_POSX'] + 190; $coordinateY = $idVal['TAS_POSY'] + 5; if (isset($idVal['TAS_DEF_MESSAGE'])) { if ($idVal['TAS_DEF_MESSAGE'] != '' and $idVal['TAS_DEF_MESSAGE'] != Null) { $idEvent = G::generateUniqueID(); $example = new Derivation(); $fieldUserTo = $example->getAllUsersFromAnyTask($nextTask); $fieldUserTo = $example->getUsersFullNameFromArray($fieldUserTo); $fieldUserFrom = $example->getAllUsersFromAnyTask($idTask); $fieldUserFrom = $example->getUsersFullNameFromArray($fieldUserFrom); /*$oUser = new Users(); $aUser = $oUser->load($_SESSION['USER_LOGGED']); $from = $aUser['USR_USERNAME'];*/ $description = ''; $userFrom = ''; $userTo = ''; if (isset($fieldUserFrom[0]['USR_USERNAME'])) { $userFrom = $fieldUserFrom[0]['USR_USERNAME']; } if (isset($fieldUserTo[0]['USR_USERNAME'])) { $userTo = $fieldUserTo[0]['USR_USERNAME']; } $dataRoutes .= ' <Activity Id="' . $idEvent . '" Name="' . $description . '"> <Description>' . $description . '</Description> <Event> <IntermediateEvent Trigger="Message" Implementation="Other"> <TriggerResultMessage CatchThrow="THROW"> <Message Id="' . $idEvent . '" From="' . $userFrom . '" To="' . $userTo . '" Name="' . $description . '"> </Message> </TriggerResultMessage> </IntermediateEvent> </Event> <Documentation>' . $description . '</Documentation> <ExtendedAttributes /> <NodeGraphicsInfos> <NodeGraphicsInfo ToolId="BizAgi_Process_Modeler" Height="30" Width="30" BorderColor="-6909623" FillColor="-66833"> <Coordinates XCoordinate="' . $coordinateX . '" YCoordinate="' . $coordinateY . '" /> </NodeGraphicsInfo> </NodeGraphicsInfos> <IsForCompensationSpecified>false</IsForCompensationSpecified> </Activity>'; $transitions .= ' <Transition Id="t' . $idEvent . '" From="' . $idTask . '" To="' . $idEvent . '" Name=""> <Condition /> <Description /> <ExtendedAttributes /> <ConnectorGraphicsInfos> <ConnectorGraphicsInfo ToolId="Processmaker" BorderColor="0" FromPort="4" ToPort="3"> </ConnectorGraphicsInfo> </ConnectorGraphicsInfos> </Transition>'; } } } } } } $data = array(); $data['ACTIVITIES'] = $dataRoutes; $data['TRANSITION'] = $transitions; return $data; }
public function load($sProcessUID, $bView = false, $sApplicationUID = '', $iDelegation = 0, $sTask = '', $bCT = false) { try { $oProcess = new Process(); $aRow = $oProcess->load($sProcessUID); $oPM->title->label = strip_tags($aRow['PRO_TITLE']); $oPM->title->position->x = $aRow['PRO_TITLE_X']; $oPM->title->position->y = $aRow['PRO_TITLE_Y']; $oPM->task = array(); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(TaskPeer::PRO_UID); $oCriteria->addSelectColumn(TaskPeer::TAS_UID); $oCriteria->addSelectColumn(ContentPeer::CON_VALUE); $oCriteria->addSelectColumn(TaskPeer::TAS_START); $oCriteria->addSelectColumn(TaskPeer::TAS_POSX); $oCriteria->addSelectColumn(TaskPeer::TAS_POSY); $oCriteria->addSelectColumn(TaskPeer::TAS_COLOR); $oCriteria->addSelectColumn(TaskPeer::TAS_TYPE); $aConditions = array(); $aConditions[] = array(0 => TaskPeer::TAS_UID, 1 => ContentPeer::CON_ID); $aConditions[] = array(0 => ContentPeer::CON_CATEGORY, 1 => DBAdapter::getStringDelimiter() . 'TAS_TITLE' . DBAdapter::getStringDelimiter()); $aConditions[] = array(0 => ContentPeer::CON_LANG, 1 => DBAdapter::getStringDelimiter() . SYS_LANG . DBAdapter::getStringDelimiter()); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $oCriteria->add(TaskPeer::PRO_UID, $sProcessUID); $oDataset = TaskPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aRow1 = $oDataset->getRow()) { $oTask = null; $oTask->uid = $aRow1['TAS_UID']; $oTask->task_type = $aRow1['TAS_TYPE']; if ($aRow1['TAS_TYPE'] == 'NORMAL') { if ($aRow1['CON_VALUE'] == "") { //There is no Label in Current SYS_LANG language so try to find in English - by default $oTask1 = new Task(); $aFields1 = $oTask1->load($oTask->uid); $aRow1['CON_VALUE'] = $oTask1->getTasTitle(); } $oTask->label = strip_tags($aRow1['CON_VALUE']); } else { $oCriteria = new Criteria('workflow'); $del = DBAdapter::getStringDelimiter(); $oCriteria->add(SubProcessPeer::PRO_PARENT, $aRow1['PRO_UID']); $oCriteria->add(SubProcessPeer::TAS_PARENT, $aRow1['TAS_UID']); $oCriteria->addAsColumn('TAS_TITLE', 'C1.CON_VALUE'); $oCriteria->addAlias("C1", 'CONTENT'); $tasTitleConds = array(); $tasTitleConds[] = array(SubProcessPeer::TAS_PARENT, 'C1.CON_ID'); $tasTitleConds[] = array('C1.CON_CATEGORY', $del . 'TAS_TITLE' . $del); $tasTitleConds[] = array('C1.CON_LANG', $del . SYS_LANG . $del); $oCriteria->addJoinMC($tasTitleConds, Criteria::LEFT_JOIN); $oDatasetX = SubProcessPeer::doSelectRS($oCriteria); $oDatasetX->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDatasetX->next(); $aRowx = $oDatasetX->getRow(); if ($oProcess->exists($aRowx['PRO_UID'])) { //$aRowy = $oProcess->load($aRowx['PRO_UID']); //$oTask->label = $aRowy['PRO_TITLE']; $oTask->label = $aRowx['TAS_TITLE']; } else { $oTask->label = strip_tags($aRow1['CON_VALUE']); } } $oTask->taskINI = strtolower($aRow1['TAS_START']) == 'true' ? true : false; $oTask->position->x = (int) $aRow1['TAS_POSX']; $oTask->position->y = (int) $aRow1['TAS_POSY']; $oTask->derivation = null; $oTask->derivation->to = array(); $oCriteria = new Criteria('workflow'); $oCriteria->add(RoutePeer::PRO_UID, $sProcessUID); $oCriteria->add(RoutePeer::TAS_UID, $aRow1['TAS_UID']); $oDataset2 = RoutePeer::doSelectRS($oCriteria); $oDataset2->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); while ($aRow2 = $oDataset2->getRow()) { switch ($aRow2['ROU_TYPE']) { case 'SEQUENTIAL': $aRow2['ROU_TYPE'] = 0; break; case 'SELECT': $aRow2['ROU_TYPE'] = 1; break; case 'EVALUATE': $aRow2['ROU_TYPE'] = 2; break; case 'PARALLEL': $aRow2['ROU_TYPE'] = 3; break; case 'PARALLEL-BY-EVALUATION': $aRow2['ROU_TYPE'] = 4; break; case 'SEC-JOIN': $aRow2['ROU_TYPE'] = 5; break; case 'DISCRIMINATOR': $aRow2['ROU_TYPE'] = 8; break; } $oTo = null; $oTo->task = $aRow2['ROU_NEXT_TASK']; $oTo->condition = $aRow2['ROU_CONDITION']; $oTo->executant = $aRow2['ROU_TO_LAST_USER']; $oTo->optional = $aRow2['ROU_OPTIONAL']; $oTask->derivation->type = $aRow2['ROU_TYPE']; $oTask->derivation->to[] = $oTo; $oDataset2->next(); } if ($bCT) { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn('COUNT(*) AS CANT'); $oCriteria->addSelectColumn('MIN(DEL_FINISH_DATE) AS FINISH'); $oCriteria->add(AppDelegationPeer::APP_UID, $sApplicationUID); $oCriteria->add(AppDelegationPeer::TAS_UID, $aRow1['TAS_UID']); $oDataset2 = AppDelegationPeer::doSelectRS($oCriteria); $oDataset2->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow2 = $oDataset2->getRow(); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn('DEL_FINISH_DATE'); $oCriteria->add(AppDelegationPeer::APP_UID, $sApplicationUID); $oCriteria->add(AppDelegationPeer::TAS_UID, $aRow1['TAS_UID']); $oCriteria->add(AppDelegationPeer::DEL_FINISH_DATE, null); $oDataset2 = AppDelegationPeer::doSelectRS($oCriteria); $oDataset2->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow3 = $oDataset2->getRow(); if ($aRow3) { $aRow2['FINISH'] = ''; } /* if (($aRow2['FINISH'] == null) && ($aRow1['TAS_UID'] == $sTask)) { $oTask->color = '#FF0000'; } else { if ($aRow2['CANT'] != 0) { if ($aRow2['FINISH'] == null) { //$oTask->color = '#FF9900'; $oTask->color = '#FF0000'; } else { $oTask->color = '#006633'; } } else { $oTask->color = "#939598"; } } */ if (empty($aRow2["FINISH"]) && $aRow1["TAS_UID"] == $sTask) { $oTask->color = "#FF0000"; //Red } else { if (!empty($aRow2["FINISH"])) { $oTask->color = "#006633"; //Green } else { if ($aRow2["CANT"] == 0 || $oTask->derivation->type != 5) { $oTask->color = "#939598"; //Gray } else { //$oTask->color = "#FF9900"; //Yellow $oTask->color = "#FF0000"; //Red } } } } else { if ($bView && $sApplicationUID != '' && $iDelegation > 0 && $sTask != '') { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn('COUNT(*) AS CANT'); $oCriteria->addSelectColumn('MIN(DEL_FINISH_DATE) AS FINISH'); $oCriteria->add(AppDelegationPeer::APP_UID, $sApplicationUID); $oCriteria->add(AppDelegationPeer::TAS_UID, $aRow1['TAS_UID']); $oDataset2 = AppDelegationPeer::doSelectRS($oCriteria); $oDataset2->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow2 = $oDataset2->getRow(); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn('DEL_FINISH_DATE'); $oCriteria->add(AppDelegationPeer::APP_UID, $sApplicationUID); $oCriteria->add(AppDelegationPeer::TAS_UID, $aRow1['TAS_UID']); $oCriteria->add(AppDelegationPeer::DEL_FINISH_DATE, null); $oDataset2 = AppDelegationPeer::doSelectRS($oCriteria); $oDataset2->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset2->next(); $aRow3 = $oDataset2->getRow(); if ($aRow3) { $aRow2['FINISH'] = ''; } /* if (($aRow2['FINISH'] == null) && ($aRow1['TAS_UID'] == $sTask)) { $oTask->color = '#FF0000'; } else { if ($aRow2['CANT'] != 0) { if ($aRow2['FINISH'] == null) { $oTask->color = '#FF9900'; } else { $oTask->color = '#006633'; } } else { $oTask->color = '#939598'; } } */ if (empty($aRow2["FINISH"]) && $aRow1["TAS_UID"] == $sTask) { $oTask->color = "#FF0000"; //Red } else { if (!empty($aRow2["FINISH"])) { $oTask->color = "#006633"; //Green } else { if ($aRow2["CANT"] == 0 || $oTask->derivation->type != 5) { $oTask->color = "#939598"; //Gray } else { $oTask->color = "#FF9900"; //Yellow } } } } } $msg = array(); G::LoadClass('derivation'); $Derivation = new Derivation(); $users = $Derivation->getAllUsersFromAnyTask($aRow1['TAS_UID']); $sw_error = false; if (count($users) == 0) { $sw_error = true; $msg[] = G::LoadTranslation('ID_NO_USERS'); } G::LoadClass('ArrayPeer'); $stepsCriteria = $this->getStepsCriteria($aRow1['TAS_UID']); $oDatasetSteps = ArrayBasePeer::doSelectRS($stepsCriteria); $oDatasetSteps->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDatasetSteps->next(); $countDynaform = 0; $countOutput = 0; $countInput = 0; $countExternal = 0; while ($aRowSteps = $oDatasetSteps->getRow()) { switch ($aRowSteps['STEP_TYPE_OBJ']) { case 'DYNAFORM': $countDynaform++; break; case 'INPUT_DOCUMENT': $countInput++; break; case 'OUTPUT_DOCUMENT': $countOutput++; break; case 'EXTERNAL': $countExternal++; break; } $oDatasetSteps->next(); } $totalSteps = $countDynaform + $countInput + $countOutput + $countExternal; if ($totalSteps == 0) { $sw_error = true; $msg[] = G::LoadTranslation('ID_TASK_NO_STEPS'); } if ($sw_error) { $oTask->statusIcons[] = array('label' => implode(",", $msg), 'icon' => '/images/alert.gif', 'message' => implode(", ", $msg), 'url' => ''); } $oPM->task[] = $oTask; $oDataset->next(); } $oPM->executant[] = G::LoadTranslation('ID_RULES_AND_USER_GROUPS'); $oPM->executant[] = G::LoadTranslation('ID_ADD_USER_OF_TASK'); $oPM->tasExtra[0]->label = '-- ' . G::LoadTranslation('ID_END_OF_PROCESS') . ' --'; $oPM->tasExtra[0]->uid = 'end'; $oPM->tasExtra[1]->label = '-- ' . G::LoadTranslation('ID_TAREA_COLGANTE') . ' --'; $oPM->tasExtra[1]->uid = 'leaf'; $oPM->guide = array(); $oPM->text = array(); $oPM->statusIcons = array(); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(SwimlanesElementsPeer::SWI_UID); // $oCriteria->addSelectColumn ( ContentPeer::CON_VALUE ); $oCriteria->addAsColumn("CON_VALUE", "CASE WHEN CONTENT.CON_VALUE IS NULL THEN (SELECT DISTINCT MAX(A.CON_VALUE) FROM CONTENT A WHERE SWIMLANES_ELEMENTS.SWI_UID=A.CON_ID ) ELSE CONTENT.CON_VALUE END "); $oCriteria->addSelectColumn(SwimlanesElementsPeer::SWI_TYPE); $oCriteria->addSelectColumn(SwimlanesElementsPeer::SWI_X); $oCriteria->addSelectColumn(SwimlanesElementsPeer::SWI_Y); $aConditions = array(); $aConditions[] = array(0 => SwimlanesElementsPeer::SWI_UID, 1 => ContentPeer::CON_ID); $aConditions[] = array(0 => ContentPeer::CON_CATEGORY, 1 => DBAdapter::getStringDelimiter() . 'SWI_TEXT' . DBAdapter::getStringDelimiter()); $aConditions[] = array(0 => ContentPeer::CON_LANG, 1 => DBAdapter::getStringDelimiter() . SYS_LANG . DBAdapter::getStringDelimiter()); $oCriteria->addJoinMC($aConditions, Criteria::LEFT_JOIN); $oCriteria->add(SwimlanesElementsPeer::PRO_UID, $sProcessUID); $oDataset = SwimlanesElementsPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aRow = $oDataset->getRow()) { switch (strtolower($aRow['SWI_TYPE'])) { case 'line': $oGuide = null; $oGuide->uid = $aRow['SWI_UID']; $oGuide->position = $aRow['SWI_X'] > 0 ? $aRow['SWI_X'] : $aRow['SWI_Y']; $oGuide->direction = $aRow['SWI_X'] > 0 ? 'vertical' : 'horizontal'; $oPM->guide[] = $oGuide; break; case 'text': $oText = null; $oText->uid = $aRow['SWI_UID']; $oText->label = strip_tags($aRow['CON_VALUE'] != '' ? str_replace(chr(92), '\', str_replace('<', '<', $aRow['CON_VALUE'])) : '-'); // $oText->label = '->' . $aRow ['CON_VALUE'] . '<-' ; $oText->position->x = $aRow['SWI_X']; $oText->position->y = $aRow['SWI_Y']; $oPM->text[] = $oText; break; } $oDataset->next(); } $oPM->derivation = array('Sequential', 'Evaluate (manual)', 'Evaluate (auto)', 'Parallel (fork)', 'Parallel by evaluation (fork)', 'Parallel (sequential join)', 'Parallel (sequential main join)'); //Load extended task properties from plugin. By JHL Jan 18, 2011 $oPluginRegistry =& PMPluginRegistry::getSingleton(); $activePluginsForTaskProperties = $oPluginRegistry->getTaskExtendedProperties(); $oPM->taskOptions = array(); foreach ($activePluginsForTaskProperties as $key => $taskPropertiesInfo) { $taskOption['title'] = $taskPropertiesInfo->sName; $taskOption['id'] = $taskPropertiesInfo->sNamespace . "--" . $taskPropertiesInfo->sName; $oPM->taskOptions[] = $taskOption; } //$oJSON = new Services_JSON(); return Bootstrap::json_encode($oPM); //$oJSON->encode( $oPM ); } catch (Exception $oError) { throw $oError; } }
public function sendNotifications($taskUid, $arrayTask, $arrayData, $applicationUid, $delIndex, $from = '') { try { $arrayApplicationData = $this->loadCase($applicationUid); $arrayData['APP_NUMBER'] = $arrayApplicationData['APP_NUMBER']; if (!class_exists('System')) { G::LoadClass('system'); } $aConfiguration = System::getEmailConfiguration(); $msgError = ""; if (!isset($aConfiguration['MESS_ENABLED']) || $aConfiguration['MESS_ENABLED'] != '1') { $msgError = "The default configuration wasn't defined"; $aConfiguration['MESS_ENGINE'] = ''; } //Send derivation notification - Start $oTask = new Task(); $aTaskInfo = $oTask->load($taskUid); if ($aTaskInfo['TAS_SEND_LAST_EMAIL'] != 'TRUE') { return false; } $from = G::buildFrom($aConfiguration, $from); if (isset($aTaskInfo['TAS_DEF_SUBJECT_MESSAGE']) && $aTaskInfo['TAS_DEF_SUBJECT_MESSAGE'] != '') { $sSubject = G::replaceDataField($aTaskInfo['TAS_DEF_SUBJECT_MESSAGE'], $arrayData); } else { $sSubject = G::LoadTranslation('ID_MESSAGE_SUBJECT_DERIVATION'); } //erik: new behaviour for messages G::loadClass('configuration'); $oConf = new Configurations(); $oConf->loadConfig($x, 'TAS_EXTRA_PROPERTIES', $aTaskInfo['TAS_UID'], '', ''); $conf = $oConf->aConfig; $pathEmail = PATH_DATA_SITE . "mailTemplates" . PATH_SEP . $aTaskInfo["PRO_UID"] . PATH_SEP; $swtplDefault = 0; $sBody = null; if (isset($conf["TAS_DEF_MESSAGE_TYPE"]) && isset($conf["TAS_DEF_MESSAGE_TEMPLATE"]) && $conf["TAS_DEF_MESSAGE_TYPE"] == "template" && $conf["TAS_DEF_MESSAGE_TEMPLATE"] != "") { if ($conf["TAS_DEF_MESSAGE_TEMPLATE"] == "alert_message.html") { $swtplDefault = 1; } $fileTemplate = $pathEmail . $conf["TAS_DEF_MESSAGE_TEMPLATE"]; if (!file_exists($fileTemplate)) { $tempale = PATH_CORE . "templates" . PATH_SEP . "mails" . PATH_SEP . "alert_message.html"; $copied = @copy($tempale, $fileTemplate); if ($copied) { $dataTemplate = array("prf_filename" => $conf["TAS_DEF_MESSAGE_TEMPLATE"], "prf_path" => $fileTemplate, "pro_uid" => $aTaskInfo["PRO_UID"], "usr_uid" => "00000000000000000000000000000001", "prf_uid" => G::generateUniqueID(), "prf_type" => "file", "prf_create_date" => date("Y-m-d H:i:s")); $filesManager = new ProcessMaker\BusinessModel\FilesManager(); $filesManager->addProcessFilesManagerInDb($dataTemplate); } else { throw new Exception("Template file \"{$fileTemplate}\" does not exist."); } } $sBody = file_get_contents($fileTemplate); } else { $sBody = nl2br($aTaskInfo['TAS_DEF_MESSAGE']); } G::LoadClass("tasks"); G::LoadClass("groups"); G::LoadClass("spool"); $task = new Tasks(); $group = new Groups(); $oUser = new Users(); foreach ($arrayTask as $aTask) { $sTo = null; $sCc = null; if (isset($aTask['DEL_INDEX'])) { $arrayData2 = $arrayData; $appDelegation = AppDelegationPeer::retrieveByPK($applicationUid, $aTask['DEL_INDEX']); if (!is_null($appDelegation)) { $arrayData2['TAS_TITLE'] = Content::load('TAS_TITLE', '', $appDelegation->getTasUid(), SYS_LANG); $arrayData2['DEL_TASK_DUE_DATE'] = $appDelegation->getDelTaskDueDate(); } } else { $arrayData2 = $arrayData; } if (isset($aTask['USR_UID']) && !empty($aTask['USR_UID'])) { $user = new \ProcessMaker\BusinessModel\User(); $arrayUserData = $user->getUser($aTask['USR_UID'], true); $arrayData2 = \ProcessMaker\Util\DateTime::convertUtcToTimeZone($arrayData2, trim($arrayUserData['USR_TIME_ZONE']) != '' ? trim($arrayUserData['USR_TIME_ZONE']) : \ProcessMaker\Util\System::getTimeZone()); } else { $arrayData2 = \ProcessMaker\Util\DateTime::convertUtcToTimeZone($arrayData2); } $sBody2 = G::replaceDataGridField($sBody, $arrayData2, false); switch ($aTask["TAS_ASSIGN_TYPE"]) { case "SELF_SERVICE": if ($swtplDefault == 1) { G::verifyPath($pathEmail, true); //Create if it does not exist $fileTemplate = $pathEmail . G::LoadTranslation('ID_UNASSIGNED_MESSAGE'); if (!file_exists($fileTemplate) && file_exists(PATH_TPL . "mails" . PATH_SEP . G::LoadTranslation('ID_UNASSIGNED_MESSAGE'))) { @copy(PATH_TPL . "mails" . PATH_SEP . G::LoadTranslation('ID_UNASSIGNED_MESSAGE'), $fileTemplate); } $sBody2 = G::replaceDataField(file_get_contents($fileTemplate), $arrayData2); } if (isset($aTask["TAS_UID"]) && !empty($aTask["TAS_UID"])) { $arrayTaskUser = array(); $arrayAux1 = $task->getGroupsOfTask($aTask["TAS_UID"], 1); foreach ($arrayAux1 as $arrayGroup) { $arrayAux2 = $group->getUsersOfGroup($arrayGroup["GRP_UID"]); foreach ($arrayAux2 as $arrayUser) { $arrayTaskUser[] = $arrayUser["USR_UID"]; } } $arrayAux1 = $task->getUsersOfTask($aTask["TAS_UID"], 1); foreach ($arrayAux1 as $arrayUser) { $arrayTaskUser[] = $arrayUser["USR_UID"]; } $criteria = new Criteria("workflow"); $criteria->addSelectColumn(UsersPeer::USR_UID); $criteria->addSelectColumn(UsersPeer::USR_USERNAME); $criteria->addSelectColumn(UsersPeer::USR_FIRSTNAME); $criteria->addSelectColumn(UsersPeer::USR_LASTNAME); $criteria->addSelectColumn(UsersPeer::USR_EMAIL); $criteria->add(UsersPeer::USR_UID, $arrayTaskUser, Criteria::IN); $rsCriteria = UsersPeer::doSelectRs($criteria); $rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC); $to = null; $cc = null; $sw = 1; while ($rsCriteria->next()) { $row = $rsCriteria->getRow(); $toAux = ($row["USR_FIRSTNAME"] != "" || $row["USR_LASTNAME"] != "" ? $row["USR_FIRSTNAME"] . " " . $row["USR_LASTNAME"] . " " : "") . "<" . $row["USR_EMAIL"] . ">"; if ($sw == 1) { $to = $toAux; $sw = 0; } else { $cc = $cc . ($cc != null ? "," : null) . $toAux; } } $sTo = $to; $sCc = $cc; } break; case "MULTIPLE_INSTANCE": $to = null; $cc = null; $sw = 1; $oDerivation = new Derivation(); $userFields = $oDerivation->getUsersFullNameFromArray($oDerivation->getAllUsersFromAnyTask($aTask["TAS_UID"])); if (isset($userFields)) { foreach ($userFields as $row) { $toAux = ($row["USR_FIRSTNAME"] != "" || $row["USR_LASTNAME"] != "" ? $row["USR_FIRSTNAME"] . " " . $row["USR_LASTNAME"] . " " : "") . "<" . $row["USR_EMAIL"] . ">"; if ($sw == 1) { $to = $toAux; $sw = 0; } else { $cc = $cc . ($cc != null ? "," : null) . $toAux; } } $sTo = $to; $sCc = $cc; } break; case "MULTIPLE_INSTANCE_VALUE_BASED": $aTaskNext = $oTask->load($aTask["TAS_UID"]); if (isset($aTaskNext["TAS_ASSIGN_VARIABLE"]) && !empty($aTaskNext["TAS_ASSIGN_VARIABLE"])) { $to = null; $cc = null; $sw = 1; $nextTaskAssignVariable = trim($aTaskNext["TAS_ASSIGN_VARIABLE"], " @#"); $arrayUsers = $arrayData[$nextTaskAssignVariable]; $oDerivation = new Derivation(); $userFields = $oDerivation->getUsersFullNameFromArray($arrayUsers); foreach ($userFields as $row) { $toAux = ($row["USR_FIRSTNAME"] != "" || $row["USR_LASTNAME"] != "" ? $row["USR_FIRSTNAME"] . " " . $row["USR_LASTNAME"] . " " : "") . "<" . $row["USR_EMAIL"] . ">"; if ($sw == 1) { $to = $toAux; $sw = 0; } else { $cc = $cc . ($cc != null ? "," : null) . $toAux; } } $sTo = $to; $sCc = $cc; } break; default: if (isset($aTask["USR_UID"]) && !empty($aTask["USR_UID"])) { $aUser = $oUser->load($aTask["USR_UID"]); $sTo = ($aUser["USR_FIRSTNAME"] != "" || $aUser["USR_LASTNAME"] != "" ? $aUser["USR_FIRSTNAME"] . " " . $aUser["USR_LASTNAME"] . " " : "") . "<" . $aUser["USR_EMAIL"] . ">"; } break; } if ($sTo != null) { $oSpool = new spoolRun(); $oSpool->setConfig($aConfiguration); $oSpool->create(array("msg_uid" => "", 'app_uid' => $applicationUid, 'del_index' => $delIndex, "app_msg_type" => "DERIVATION", "app_msg_subject" => $sSubject, 'app_msg_from' => $from, "app_msg_to" => $sTo, 'app_msg_body' => $sBody2, "app_msg_cc" => $sCc, "app_msg_bcc" => "", "app_msg_attach" => "", "app_msg_template" => "", "app_msg_status" => "pending", "app_msg_error" => $msgError)); if ($msgError == '') { if ($aConfiguration["MESS_BACKGROUND"] == "" || $aConfiguration["MESS_TRY_SEND_INMEDIATLY"] == "1") { $oSpool->sendMail(); } } } } //Send derivation notification - End } catch (Exception $oException) { throw $oException; } }