toArray( BasePeer::TYPE_FIELDNAME );
$this->fromArray( $aFields, BasePeer::TYPE_FIELDNAME );
$this->setNew( false );
return $aFields;
} else {
throw (new Exception( "The row '$Uid' in table CaseTrackerObject doesn't exist!" ));
}
} catch (Exception $oError) {
throw ($oError);
}
}
public function create ($aData)
{
$oConnection = Propel::getConnection( CaseTrackerObjectPeer::DATABASE_NAME );
try {
if (! isset( $aData['CTO_UID'] )) {
$aData['CTO_UID'] = G::generateUniqueID();
}
$oCaseTrackerObject = new CaseTrackerObject();
$oCaseTrackerObject->fromArray( $aData, BasePeer::TYPE_FIELDNAME );
if ($oCaseTrackerObject->validate()) {
$oConnection->begin();
$iResult = $oCaseTrackerObject->save();
$oConnection->commit();
return $aData['CTO_UID'];
} else {
$sMessage = '';
$aValidationFailures = $oCaseTrackerObject->getValidationFailures();
foreach ($aValidationFailures as $oValidationFailure) {
$sMessage .= $oValidationFailure->getMessage() . '
';
}
throw (new Exception( 'The registry cannot be created!
' . $sMessage ));
}
} catch (Exception $oError) {
$oConnection->rollback();
throw ($oError);
}
}
public function update ($aData)
{
$oConnection = Propel::getConnection( CaseTrackerObjectPeer::DATABASE_NAME );
try {
$oCaseTrackerObject = CaseTrackerObjectPeer::retrieveByPK( $aData['CTO_UID'] );
if (! is_null( $oCaseTrackerObject )) {
$oCaseTrackerObject->fromArray( $aData, BasePeer::TYPE_FIELDNAME );
if ($oCaseTrackerObject->validate()) {
$oConnection->begin();
$iResult = $oCaseTrackerObject->save();
$oConnection->commit();
return $iResult;
} else {
$sMessage = '';
$aValidationFailures = $oCaseTrackerObject->getValidationFailures();
foreach ($aValidationFailures as $oValidationFailure) {
$sMessage .= $oValidationFailure->getMessage() . '
';
}
throw (new Exception( 'The registry cannot be updated!
' . $sMessage ));
}
} else {
throw (new Exception( 'This row doesn\'t exist!' ));
}
} catch (Exception $oError) {
$oConnection->rollback();
throw ($oError);
}
}
public function remove ($sCTOUID)
{
$oConnection = Propel::getConnection( CaseTrackerObjectPeer::DATABASE_NAME );
try {
$oCaseTobj = CaseTrackerObjectPeer::retrieveByPK( $sCTOUID );
if (is_object( $oCaseTobj ) && get_class( $oCaseTobj ) == 'CaseTrackerObject') {
$oConnection->begin();
$iResult = $oCaseTobj->delete();
$oConnection->commit();
return $iResult;
} else {
throw (new Exception( "The row '" . $sCTOUID . "' in table CaseTrackerObject doesn't exist!" ));
}
} catch (Exception $oError) {
var_dump( $oError );
die();
$oConnection->rollback();
throw ($oError);
}
}
public function reorderPositions ($sProcessUID, $iPosition)
{
try {
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( CaseTrackerObjectPeer::PRO_UID, $sProcessUID );
$oCriteria->add( CaseTrackerObjectPeer::CTO_POSITION, $iPosition, '>' );
$oDataset = CaseTrackerObjectPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
$this->update( array ('CTO_UID' => $aRow['CTO_UID'],'PRO_UID' => $aRow['PRO_UID'],'CTO_TYPE_OBJ' => $aRow['CTO_TYPE_OBJ'],'CTO_UID_OBJ' => $aRow['CTO_UID_OBJ'],'CTO_CONDITION' => $aRow['CTO_CONDITION'],'CTO_POSITION' => $aRow['CTO_POSITION'] - 1
) );
$oDataset->next();
}
} catch (Exception $oException) {
throw $Exception;
}
}
public function caseTrackerObjectExists ($Uid)
{
try {
$oObj = CaseTrackerObjectPeer::retrieveByPk( $Uid );
if (is_object( $oObj ) && get_class( $oObj ) == 'CaseTrackerObject') {
return true;
} else {
return false;
}
} catch (Exception $oError) {
throw ($oError);
}
}
public function removeByObject ($sType, $sObjUid)
{
try {
$oCriteria = new Criteria( 'workflow' );
$oCriteria->add( CaseTrackerObjectPeer::CTO_TYPE_OBJ, $sType );
$oCriteria->add( CaseTrackerObjectPeer::CTO_UID_OBJ, $sObjUid );
CaseTrackerObjectPeer::doDelete( $oCriteria );
} catch (Exception $e) {
throw ($e);
}
}
/**
* verify if a dynaform is assigned some steps
*
* @param string $proUid the uid of the process
* @param string $dynUid the uid of the dynaform
*
* @return array
*/
public function verifyDynaformAssigCaseTracker ($dynUid, $proUid)
{
$res = array();
$oCriteria = new Criteria();
$oCriteria->addSelectColumn( CaseTrackerObjectPeer::CTO_UID );
$oCriteria->add( CaseTrackerObjectPeer::PRO_UID, $proUid );
$oCriteria->add( CaseTrackerObjectPeer::CTO_UID_OBJ, $dynUid );
$oCriteria->add( CaseTrackerObjectPeer::CTO_TYPE_OBJ, 'DYNAFORM' );
$oDataset = CaseTrackerObjectPeer::doSelectRS( $oCriteria );
$oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );
while($oDataset->next()) {
$res[] = $oDataset->getRow();
}
return $res;
}
}