public function getAll($arrayFilterData = array(), $sortField = "", $sortDir = "", $start = 0, $limit = 25) { //SQL $criteria = new Criteria("workflow"); $criteria->addSelectColumn(OauthClientsPeer::CLIENT_ID); $criteria->addSelectColumn(OauthClientsPeer::CLIENT_SECRET); $criteria->addSelectColumn(OauthClientsPeer::CLIENT_NAME); $criteria->addSelectColumn(OauthClientsPeer::CLIENT_DESCRIPTION); $criteria->addSelectColumn(OauthClientsPeer::CLIENT_WEBSITE); $criteria->addSelectColumn(OauthClientsPeer::REDIRECT_URI); $criteria->addSelectColumn(OauthClientsPeer::USR_UID); $criteria->add(OauthClientsPeer::CLIENT_ID, 'x-pm-local-client', Criteria::NOT_EQUAL); if ($arrayFilterData && isset($arrayFilterData["USR_UID"]) && $arrayFilterData["USR_UID"] != "") { $criteria->add(OauthClientsPeer::USR_UID, $arrayFilterData["USR_UID"], Criteria::EQUAL); } if ($arrayFilterData && isset($arrayFilterData["SEARCH"]) && $arrayFilterData["SEARCH"] != "") { //$criteria->add( // $criteria->getNewCriterion(OauthClientsPeer::CLIENT_NAME, "%" . $arrayFilterData["SEARCH"] . "%", Criteria::LIKE)->addOr( // $criteria->getNewCriterion(OauthClientsPeer::CLIENT_DESCRIPTION, "%" . $arrayFilterData["SEARCH"] . "%", Criteria::LIKE))->addOr( // $criteria->getNewCriterion(OauthClientsPeer::CLIENT_WEBSITE, "%" . $arrayFilterData["SEARCH"] . "%", Criteria::LIKE))->addOr( // $criteria->getNewCriterion(OauthClientsPeer::REDIRECT_URI, "%" . $arrayFilterData["SEARCH"] . "%", Criteria::LIKE)) //); $criteria->add($criteria->getNewCriterion(OauthClientsPeer::CLIENT_NAME, "%" . $arrayFilterData["SEARCH"] . "%", Criteria::LIKE)->addOr($criteria->getNewCriterion(OauthClientsPeer::CLIENT_DESCRIPTION, "%" . $arrayFilterData["SEARCH"] . "%", Criteria::LIKE))); } $sortField = $sortField && $sortField != "" ? OauthClientsPeer::TABLE_NAME . "." . $sortField : OauthClientsPeer::CLIENT_NAME; if ($sortDir && $sortDir == "DESC") { $criteria->addDescendingOrderByColumn($sortField); } else { $criteria->addAscendingOrderByColumn($sortField); } //Number records total $criteriaCount = clone $criteria; $criteriaCount->clearSelectColumns(); $criteriaCount->addSelectColumn("COUNT(" . OauthClientsPeer::CLIENT_ID . ") AS NUM_REC"); $rsCriteriaCount = OauthClientsPeer::doSelectRS($criteriaCount); $rsCriteriaCount->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rsCriteriaCount->next(); $row = $rsCriteriaCount->getRow(); $numRecTotal = $row["NUM_REC"]; //SQL if ($start && $limit && $limit > 0) { $criteria->setOffset($start); $criteria->setLimit($limit); } $rsCriteria = OauthClientsPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC); $arrayData = array(); while ($rsCriteria->next()) { $arrayData[] = $rsCriteria->getRow(); } return array("numRecTotal" => $numRecTotal, "data" => $arrayData); }
/** * 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 OauthClientsPeer::populateObjects(OauthClientsPeer::doSelectRS($criteria, $con)); }