Exemplo n.º 1
0
 /**
  * Implementation for 'GET' method for Rest API
  *
  * @param  mixed $repVarUid 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($repVarUid = 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(ReportVarPeer::REP_VAR_UID);
             $criteria->addSelectColumn(ReportVarPeer::PRO_UID);
             $criteria->addSelectColumn(ReportVarPeer::REP_TAB_UID);
             $criteria->addSelectColumn(ReportVarPeer::REP_VAR_NAME);
             $criteria->addSelectColumn(ReportVarPeer::REP_VAR_TYPE);
             $dataset = AppEventPeer::doSelectRS($criteria);
             $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
             while ($dataset->next()) {
                 $result[] = $dataset->getRow();
             }
         } else {
             $record = ReportVarPeer::retrieveByPK($repVarUid);
             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 ReportVar ({$paramValues})");
             }
         }
     } catch (RestException $e) {
         throw new RestException($e->getCode(), $e->getMessage());
     } catch (Exception $e) {
         throw new RestException(412, $e->getMessage());
     }
     return $result;
 }
 /**
  * Function deleteReportTable
  * This Function deletes report table
  *
  * @access public
  * @param string $sRepTabUid
  * @return void
  */
 public function deleteReportTable($sRepTabUid)
 {
     try {
         $oReportTable = new ReportTable();
         $aFields = $oReportTable->load($sRepTabUid);
         if (!empty($aFields)) {
             $this->dropTable($aFields['REP_TAB_NAME'], $aFields['REP_TAB_CONNECTION']);
             $oCriteria = new Criteria('workflow');
             $oCriteria->add(ReportVarPeer::REP_TAB_UID, $sRepTabUid);
             $oDataset = ReportVarPeer::doDelete($oCriteria);
             $oReportTable->remove($sRepTabUid);
         }
     } catch (Exception $oError) {
         throw $oError;
     }
 }
Exemplo n.º 3
0
 public function getTableVars($uid, $bWhitType = false)
 {
     require_once 'classes/model/Fields.php';
     try {
         $oCriteria = new Criteria('workflow');
         $oCriteria->addSelectColumn(FieldsPeer::ADD_TAB_UID);
         $oCriteria->addSelectColumn(FieldsPeer::FLD_NAME);
         $oCriteria->addSelectColumn(FieldsPeer::FLD_TYPE);
         $oCriteria->addSelectColumn(FieldsPeer::FLD_DYN_NAME);
         $oCriteria->add(FieldsPeer::ADD_TAB_UID, $uid);
         $oDataset = ReportVarPeer::doSelectRS($oCriteria);
         $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
         $oDataset->next();
         $aVars = array();
         $aImportedVars = array(); //This array will help to control if the variable already exist
         while ($aRow = $oDataset->getRow()) {
             if ($bWhitType) {
                 if (!in_array($aRow['FLD_NAME'], $aImportedVars)) {
                     $aImportedVars[] = $aRow['FLD_NAME'];
                     $aVars[] = array('sFieldName'    => $aRow['FLD_NAME'],
                                      'sFieldDynName' => $aRow['FLD_DYN_NAME'],
                                      'sType'         => $aRow['FLD_TYPE']);
                 }
             } else {
                 $aVars[] = $aRow['FLD_NAME'];
             }
             $oDataset->next();
         }
         return $aVars;
     } catch (Exception $oError) {
         throw($oError);
     }
 }
Exemplo n.º 4
0
    /**

     * Get Report Tables Vars Rows for a Process

     *

     * @param string $sProUid

     * @return array $aRepVars

     */

    public function getReportTablesVarsRows ($sProUid)

    {

        try {

            $aRepVars = array ();

            $oCriteria = new Criteria( 'workflow' );

            $oCriteria->add( ReportVarPeer::PRO_UID, $sProUid );

            $oDataset = ReportVarPeer::doSelectRS( $oCriteria );

            $oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC );

            $oDataset->next();

            while ($aRow = $oDataset->getRow()) {

                $oRepVar = new ReportVar();

                $aRepVars[] = $oRepVar->load( $aRow['REP_VAR_UID'] );

                $oDataset->next();

            }

            return $aRepVars;

        } catch (Exception $oError) {

            throw $oError;

        }

    }
Exemplo n.º 5
0
 function reportVarExists($sRepVarUid)
 {
     $con = Propel::getConnection(ReportVarPeer::DATABASE_NAME);
     try {
         $oRepVarUid = ReportVarPeer::retrieveByPk($sRepVarUid);
         if (is_object($oRepVarUid) && get_class($oRepVarUid) == 'ReportVar') {
             return true;
         } else {
             return false;
         }
     } catch (Exception $oError) {
         throw $oError;
     }
 }
Exemplo n.º 6
0
 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      Connection $con the connection to use
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(self::DATABASE_NAME);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria();
         $criteria->add(ReportVarPeer::REP_VAR_UID, $pks, Criteria::IN);
         $objs = ReportVarPeer::doSelect($criteria, $con);
     }
     return $objs;
 }
Exemplo n.º 7
0
 /**
  * Populates the object using an array.
  *
  * This is particularly useful when populating an object from one of the
  * request arrays (e.g. $_POST).  This method goes through the column
  * names, checking to see whether a matching key exists in populated
  * array. If so the setByName() method is called for that column.
  *
  * You can specify the key type of the array by additionally passing one
  * of the class type constants TYPE_PHPNAME, TYPE_COLNAME, TYPE_FIELDNAME,
  * TYPE_NUM. The default key type is the column's phpname (e.g. 'authorId')
  *
  * @param      array  $arr     An array to populate the object from.
  * @param      string $keyType The type of keys the array uses.
  * @return     void
  */
 public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
 {
     $keys = ReportVarPeer::getFieldNames($keyType);
     if (array_key_exists($keys[0], $arr)) {
         $this->setRepVarUid($arr[$keys[0]]);
     }
     if (array_key_exists($keys[1], $arr)) {
         $this->setProUid($arr[$keys[1]]);
     }
     if (array_key_exists($keys[2], $arr)) {
         $this->setRepTabUid($arr[$keys[2]]);
     }
     if (array_key_exists($keys[3], $arr)) {
         $this->setRepVarName($arr[$keys[3]]);
     }
     if (array_key_exists($keys[4], $arr)) {
         $this->setRepVarType($arr[$keys[4]]);
     }
 }