/** * 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 DashletPeer::populateObjects(DashletPeer::doSelectRS($criteria, $con)); }
private function getDashlets() { try { require_once 'classes/model/Dashlet.php'; $dashlets = array(); //SELECT $criteria = new Criteria('workflow'); $criteria->addSelectColumn(DashletPeer::DAS_UID); $criteria->addSelectColumn(DashletPeer::DAS_TITLE); $criteria->addSelectColumn(DashletPeer::DAS_CLASS); //ORDER BY $criteria->addAscendingOrderByColumn(DashletPeer::DAS_TITLE); $dataset = DashletPeer::doSelectRS($criteria); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $dataset->next(); while ($row = $dataset->getRow()) { if (strstr($row['DAS_TITLE'], '*')) { $row['DAS_TITLE'] = str_replace('*', '', $row['DAS_TITLE']); $row['DAS_TITLE'] = G::LoadTranslationPlugin('advancedDashboards', $row['DAS_TITLE']); } if ($this->pmDashlet->verifyPluginDashlet($row['DAS_CLASS'])) { $dashlets[] = array($row['DAS_UID'], $row['DAS_TITLE']); } $dataset->next(); } } catch (Exception $error) { throw $error; } return $dashlets; }
private function getDashlets() { try { require_once 'classes/model/Dashlet.php'; $dashlets = array(); //SELECT $criteria = new Criteria('workflow'); $criteria->addSelectColumn(DashletPeer::DAS_UID); $criteria->addSelectColumn(DashletPeer::DAS_TITLE); //ORDER BY $criteria->addAscendingOrderByColumn(DashletPeer::DAS_TITLE); $dataset = DashletPeer::doSelectRS($criteria); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $dataset->next(); while ($row = $dataset->getRow()) { $dashlets[] = array($row['DAS_UID'], $row['DAS_TITLE']); $dataset->next(); } } catch (Exception $error) { throw $error; } return $dashlets; }