/** * Implementation for 'GET' method for Rest API * * @param mixed $gatUid 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($gatUid = 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(GatewayPeer::GAT_UID); $criteria->addSelectColumn(GatewayPeer::PRO_UID); $criteria->addSelectColumn(GatewayPeer::TAS_UID); $criteria->addSelectColumn(GatewayPeer::GAT_NEXT_TASK); $criteria->addSelectColumn(GatewayPeer::GAT_X); $criteria->addSelectColumn(GatewayPeer::GAT_Y); $criteria->addSelectColumn(GatewayPeer::GAT_TYPE); $dataset = AppEventPeer::doSelectRS($criteria); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); while ($dataset->next()) { $result[] = $dataset->getRow(); } } else { $record = GatewayPeer::retrieveByPK($gatUid); 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 Gateway ({$paramValues})"); } } } catch (RestException $e) { throw new RestException($e->getCode(), $e->getMessage()); } catch (Exception $e) { throw new RestException(412, $e->getMessage()); } return $result; }
public function remove($GatewayUid) { $oConnection = Propel::getConnection(GatewayPeer::DATABASE_NAME); try { $oGateWay = GatewayPeer::retrieveByPK($GatewayUid); if (!is_null($oGateWay)) { $oConnection->begin(); $iResult = $oGateWay->delete(); $oConnection->commit(); //return $iResult; return true; } else { throw new Exception('This row does not exist!'); } } catch (Exception $oError) { $oConnection->rollback(); throw $oError; } }
public function addGateway($oData) { try { $oGateway = new Gateway(); $aData = array(); $aData['PRO_UID'] = $oData->pro_uid; $aData['GAT_X'] = $oData->position->x; $aData['GAT_Y'] = $oData->position->y; $aData['GAT_TYPE'] = $oData->gat_type; $sGat_uid = $oData->gat_uid; $oGatewayData = GatewayPeer::retrieveByPK($sGat_uid); if (is_null($oGatewayData)) { $sGat_uid = $oGateway->create($aData); } else { $aData['GAT_UID'] = $sGat_uid; if (isset($oData->tas_from)) { $aData['TAS_UID'] = $oData->tas_from; } if (isset($oData->tas_to)) { $aData['GAT_NEXT_TASK'] = $oData->tas_to; } $oGateway->update($aData); } $oEncode->uid = $sGat_uid; //$oJSON = new Services_JSON(); return Bootstrap::json_encode($oEncode); //$oJSON->encode( $oEncode ); } catch (Exception $oError) { throw $oError; } }