Example #1
0
 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);
 }