static function doSearch($TEXT, $idS = 1)
{
$C = new Criteria();
$C = AgendatelefonicaPeer::getCriteriaActiu($C, $idS);
$PARAULES = explode(" ", $TEXT);
$PAR2 = array();
foreach ($PARAULES as $P) {
if (strlen($P) > 2) {
$PAR2[] = trim($P);
}
}
foreach ($PAR2 as $P) {
// $text1Criterion = $C->getNewCriterion( AgendatelefonicadadesPeer::DADA , '%'.$P.'%', CRITERIA::LIKE);
$text1Criterion = $C->getNewCriterion(AgendatelefonicaPeer::NOM, '%' . $P . '%', CRITERIA::LIKE);
$text2Criterion = $C->getNewCriterion(AgendatelefonicaPeer::TAGS, '%' . $P . '%', CRITERIA::LIKE);
$text3Criterion = $C->getNewCriterion(AgendatelefonicaPeer::ENTITAT, '%' . $P . '%', CRITERIA::LIKE);
$text1Criterion->addOr($text2Criterion);
$text1Criterion->addOr($text3Criterion);
$C->add($text1Criterion);
}
$C->add(AgendatelefonicaPeer::SITE_ID, $idS);
$C->addGroupByColumn(AgendatelefonicaPeer::AGENDATELEFONICAID);
$C->addAscendingOrderByColumn(AgendatelefonicaPeer::NOM);
$C->setLimit(20);
$ATD = AgendatelefonicaPeer::doSelect($C);
return $ATD;
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(AgendatelefonicaPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(AgendatelefonicaPeer::DATABASE_NAME);
$criteria->add(AgendatelefonicaPeer::AGENDATELEFONICAID, $pks, Criteria::IN);
$objs = AgendatelefonicaPeer::doSelect($criteria, $con);
}
return $objs;
}
