public static function search($criteria, sfUser $user) { $c = new Criteria(); $c->addSelectColumn(self::ID . ' ID'); $c->addSelectColumn(self::USERNAME . ' NAME'); $c->addSelectColumn(self::NAME . ' DESCRIPTION'); $tableName = self::TABLE_NAME; $c->addSelectColumn("'{$tableName}' TNAME"); $c->add(self::HIDDEN, 0); if ($user->isAuthenticated()) { $c->add(self::ID, $user->getRaykuUserId(), Criteria::NOT_EQUAL); } $cton = $c->getNewCriterion(self::USERNAME, "%{$criteria}%", Criteria::LIKE); $cton->addOr($c->getNewCriterion(self::NAME, "%{$criteria}%", Criteria::LIKE)); $cton->addOr($c->getNewCriterion(self::EMAIL, "%{$criteria}%", Criteria::LIKE)); $c->add($cton); return self::doSelectStmt($c); }