/** * Function getTableVars * * @access public * @param string $sRepTabUid * @param boolean $bWhitType * @return void */ public function getTableVars($sRepTabUid, $bWhitType = false) { try { $oCriteria = new Criteria('workflow'); $oCriteria->add(ReportVarPeer::REP_TAB_UID, $sRepTabUid); $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['REP_VAR_NAME'], $aImportedVars)) { $aImportedVars[] = $aRow['REP_VAR_NAME']; $aVars[] = array('sFieldName' => $aRow['REP_VAR_NAME'], 'sType' => $aRow['REP_VAR_TYPE']); } } else { $aVars[] = $aRow['REP_VAR_NAME']; } $oDataset->next(); } return $aVars; } catch (Exception $oError) { throw $oError; } }
/** * 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; } }
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); } }
/** * Method to do selects. * * @param Criteria $criteria The Criteria object used to build the SELECT statement. * @param Connection $con * @return array Array of selected Objects * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelect(Criteria $criteria, $con = null) { return ReportVarPeer::populateObjects(ReportVarPeer::doSelectRS($criteria, $con)); }