public static function searchProperties($searchquery)
{
$ids = AddressBook::activeIds(\OCP\USER::getUser());
$id_sql = join(',', array_fill(0, count($ids), '?'));
$SQL = "SELECT `c`.`id`,`c`.`fullname`,`cp`.`name`,`cp`.`value` FROM `" . self::ContactsTable . "` c\n\t\t LEFT JOIN `" . self::ContactsProbTable . "` cp ON `c`.`id`=`cp`.`contactid`\n\t\t WHERE `c`.`addressbookid` IN (" . $id_sql . ") AND `cp`.`value` LIKE '%" . addslashes($searchquery) . "%' AND `c`.`component`='VCARD' GROUP BY `c`.`id`";
$stmt = \OCP\DB::prepare($SQL);
//array_push($ids,$searchquery);
$result = $stmt->execute($ids);
$cards = array();
if (!is_null($result)) {
while ($row = $result->fetchRow()) {
//if($row[''])
$cards[] = $row;
}
}
return $cards;
}
