/**
* Return case scheduler of a project
* @param string $sProcessUID
* @param string $sCaseSchedulerUID
* @return array
*
* @access public
*/
public function getCaseScheduler($sProcessUID = '', $sCaseSchedulerUID = '')
{
try {
$oCaseSchedulerTest = \CaseSchedulerPeer::retrieveByPK($sCaseSchedulerUID);
if (is_null($oCaseSchedulerTest)) {
throw new \Exception(\G::LoadTranslation("ID_CASE_SCHEDULER_DOES_NOT_EXIST", array($sCaseSchedulerUID)));
}
$oCriteria = new \Criteria('workflow');
$oCriteria->clearSelectColumns();
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_UID);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_NAME);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_DEL_USER_NAME);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_DEL_USER_UID);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::PRO_UID);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::TAS_UID);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_TIME_NEXT_RUN);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_LAST_RUN_TIME);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_STATE);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_LAST_STATE);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::USR_UID);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_OPTION);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_START_TIME);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_START_DATE);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_DAYS_PERFORM_TASK);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_EVERY_DAYS);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_WEEK_DAYS);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_START_DAY);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_MONTHS);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_END_DATE);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_REPEAT_EVERY);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_REPEAT_UNTIL);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::SCH_REPEAT_STOP_IF_RUNNING);
$oCriteria->addSelectColumn(\CaseSchedulerPeer::CASE_SH_PLUGIN_UID);
$oCriteria->add(\CaseSchedulerPeer::PRO_UID, $sProcessUID);
$oCriteria->add(\CaseSchedulerPeer::SCH_UID, $sCaseSchedulerUID);
$oDataset = \CaseSchedulerPeer::doSelectRS($oCriteria);
$oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC);
$oDataset->next();
$aRows = array();
while ($aRow = $oDataset->getRow()) {
$aRow = array_change_key_case($aRow, CASE_LOWER);
$aRows = $aRow;
$oDataset->next();
}
return $aRows;
} catch (Exception $e) {
throw $e;
}
}
public function remove($SchUid)
{
$con = Propel::getConnection(CaseSchedulerPeer::DATABASE_NAME);
try {
$oCaseScheduler = CaseSchedulerPeer::retrieveByPK($SchUid);
if (!is_null($oCaseScheduler)) {
$iResult = $oCaseScheduler->delete();
$con->commit();
return $iResult;
} else {
throw new Exception('This row doesn\'t exist!');
}
} catch (Exception $e) {
$con->rollback();
throw $e;
}
}
public function remove ($SchUid)
{
$con = Propel::getConnection( CaseSchedulerPeer::DATABASE_NAME );
try {
$oCaseScheduler = CaseSchedulerPeer::retrieveByPK( $SchUid );
if (! is_null( $oCaseScheduler )) {
$fields = $this->Load( $SchUid );
$iResult = $oCaseScheduler->delete();
$con->commit();
//Add Audit Log
G::auditLog("DeleteCaseScheduler", "Scheduler Name: ".$fields['SCH_NAME'].", Task: ".$fields['TAS_UID']);
return $iResult;
} else {
throw (new Exception( 'This row doesn\'t exist!' ));
}
} catch (Exception $e) {
$con->rollback();
throw ($e);
}
}
/**
* Implementation for 'GET' method for Rest API
*
* @param mixed $schUid Primary key
*
* @return array $result Returns array within multiple records or a single record depending if
* a single selection was requested passing id(s) as param
*/
protected function get($schUid = null)
{
$result = array();
try {
$noArguments = true;
$argumentList = func_get_args();
foreach ($argumentList as $arg) {
if (!is_null($arg)) {
$noArguments = false;
}
}
if ($noArguments) {
$criteria = new Criteria('workflow');
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_UID);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_DEL_USER_NAME);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_DEL_USER_PASS);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_DEL_USER_UID);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_NAME);
$criteria->addSelectColumn(CaseSchedulerPeer::PRO_UID);
$criteria->addSelectColumn(CaseSchedulerPeer::TAS_UID);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_TIME_NEXT_RUN);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_LAST_RUN_TIME);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_STATE);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_LAST_STATE);
$criteria->addSelectColumn(CaseSchedulerPeer::USR_UID);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_OPTION);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_START_TIME);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_START_DATE);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_DAYS_PERFORM_TASK);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_EVERY_DAYS);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_WEEK_DAYS);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_START_DAY);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_MONTHS);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_END_DATE);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_REPEAT_EVERY);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_REPEAT_UNTIL);
$criteria->addSelectColumn(CaseSchedulerPeer::SCH_REPEAT_STOP_IF_RUNNING);
$criteria->addSelectColumn(CaseSchedulerPeer::CASE_SH_PLUGIN_UID);
$dataset = AppEventPeer::doSelectRS($criteria);
$dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
while ($dataset->next()) {
$result[] = $dataset->getRow();
}
} else {
$record = CaseSchedulerPeer::retrieveByPK($schUid);
if ($record) {
$result = $record->toArray(BasePeer::TYPE_FIELDNAME);
} else {
$paramValues = "";
foreach ($argumentList as $arg) {
$paramValues .= strlen($paramValues) ? ', ' : '';
if (!is_null($arg)) {
$paramValues .= "{$arg}";
} else {
$paramValues .= "NULL";
}
}
throw new RestException(417, "table CaseScheduler ({$paramValues})");
}
}
} catch (RestException $e) {
throw new RestException($e->getCode(), $e->getMessage());
} catch (Exception $e) {
throw new RestException(412, $e->getMessage());
}
return $result;
}
