<?php
+/**
+ * @copyright Copyright (C) 2010-2023, the Friendica project
+ *
+ * @license GNU AGPL version 3 or any later version
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program. If not, see <https://www.gnu.org/licenses/>.
+ *
+ */
namespace Friendica\Model;
-use Friendica\BaseObject;
-use Friendica\Core\Protocol;
-use Friendica\Core\Worker;
use Friendica\Database\DBA;
-use Friendica\Network\Probe;
-use Friendica\Object\Search\ContactResult;
-use Friendica\Object\Search\ContactResultList;
-use Friendica\Protocol\PortableContact;
-use Friendica\Util\Network;
-use Friendica\Util\Strings;
+use Friendica\DI;
+use Friendica\Util\DateTimeFormat;
/**
- * Model for searches
+ * Model for DB specific logic for the search entity
*/
-class Search extends BaseObject
+class Search
{
- const DEFAULT_DIRECTORY = 'https://dir.friendica.social';
-
/**
* Returns the list of user defined tags (e.g. #Friendica)
*
* @return array
- *
* @throws \Exception
*/
- public static function getUserTags()
- {
- $termsStmt = DBA::p("SELECT DISTINCT(`term`) FROM `search`");
-
- $tags = [];
-
- while ($term = DBA::fetch($termsStmt)) {
- $tags[] = trim($term['term'], '#');
- }
-
- return $tags;
- }
-
- /**
- * Search a user based on his/her profile address
- * pattern: @username@domain.tld
- *
- * @param string $user The user to search for
- *
- * @return ContactResultList|null
- * @throws \Friendica\Network\HTTPException\InternalServerErrorException
- * @throws \ImagickException
- */
- public static function searchUser($user)
- {
- if ((filter_var($user, FILTER_VALIDATE_EMAIL) && Network::isEmailDomainValid($user)) ||
- (substr(Strings::normaliseLink($user), 0, 7) == "http://")) {
-
- $user_data = Probe::uri($user);
- if (empty($user_data)) {
- return null;
- }
-
- if (!(in_array($user_data["network"], [Protocol::ACTIVITYPUB, Protocol::DFRN, Protocol::OSTATUS, Protocol::DIASPORA]))) {
- return null;
- }
-
- $contactDetails = Contact::getDetailsByURL(defaults($user_data, 'url', ''), local_user());
- $itemurl = (($contactDetails["addr"] != "") ? $contactDetails["addr"] : defaults($user_data, 'url', ''));
-
- $result = new ContactResult(
- defaults($user_data, 'name', ''),
- defaults($user_data, 'addr', ''),
- $itemurl,
- defaults($user_data, 'url', ''),
- defaults($user_data, 'photo', ''),
- defaults($user_data, 'network', ''),
- defaults($contactDetails, 'cid', 0),
- 0,
- defaults($user_data, 'tags', '')
- );
-
- return new ContactResultList(1, 1, 1, [$result]);
-
- } else {
- return null;
- }
- }
-
- /**
- * Search in the global directory for occurrences of the search string
- * This is mainly based on the JSON results of https://dir.friendica.social
- *
- * @param string $search
- * @param int $page
- *
- * @return ContactResultList|null
- * @throws \Friendica\Network\HTTPException\InternalServerErrorException
- */
- public static function searchDirectory($search, $page = 1)
- {
- $config = self::getApp()->getConfig();
- $server = $config->get('system', 'directory', self::DEFAULT_DIRECTORY);
-
- $searchUrl = $server . '/search?q=' . urlencode($search);
-
- if ($page > 1) {
- $searchUrl .= '&page=' . $page;
- }
-
- $red = 0;
- $resultJson = Network::fetchUrl($searchUrl, false,$red, 0, 'application/json');
-
- $results = json_decode($resultJson, true);
-
- $resultList = new ContactResultList(
- defaults($results, 'page', 1),
- defaults($results, 'count', 1),
- defaults($results, 'itemsperpage', 1)
- );
-
- $profiles = defaults($results, 'profiles', []);
-
- foreach ($profiles as $profile) {
- $contactDetails = Contact::getDetailsByURL(defaults($profile, 'profile_url', ''), local_user());
- $itemurl = (!empty($contactDetails['addr']) ? $contactDetails['addr'] : defaults($profile, 'profile_url', ''));
-
- $result = new ContactResult(
- defaults($profile, 'name', ''),
- defaults($profile, 'addr', ''),
- $itemurl,
- defaults($profile, 'profile_url', ''),
- defaults($profile, 'photo', ''),
- Protocol::DFRN,
- defaults($contactDetails, 'cid', 0),
- 0,
- defaults($profile, 'tags', ''));
-
- $resultList->addResult($result);
- }
-
- return $resultList;
- }
-
- /**
- * Search in the local database for occurrences of the search string
- *
- * @param string $search
- * @param int $start
- * @param int $itemPage
- * @param bool $community
- *
- * @return ContactResultList|null
- * @throws \Friendica\Network\HTTPException\InternalServerErrorException
- */
- public static function searchLocal($search, $start = 0, $itemPage = 80, $community = false)
+ public static function getUserTags(): array
{
- $config = self::getApp()->getConfig();
+ $user_condition = ["`verified` AND NOT `blocked` AND NOT `account_removed` AND NOT `account_expired` AND `user`.`uid` > ?", 0];
- $diaspora = $config->get('system', 'diaspora_enabled') ? Protocol::DIASPORA : Protocol::DFRN;
- $ostatus = !$config->get('system', 'ostatus_disabled') ? Protocol::OSTATUS : Protocol::DFRN;
-
- $wildcard = Strings::escapeHtml('%' . $search . '%');
-
- $count = DBA::count('gcontact', [
- 'NOT `hide`
- AND `network` IN (?, ?, ?, ?)
- AND ((`last_contact` >= `last_failure`) OR (`updated` >= `last_failure`))
- AND (`url` LIKE ? OR `name` LIKE ? OR `location` LIKE ?
- OR `addr` LIKE ? OR `about` LIKE ? OR `keywords` LIKE ?)
- AND `community` = ?',
- Protocol::ACTIVITYPUB, Protocol::DFRN, $ostatus, $diaspora,
- $wildcard, $wildcard, $wildcard,
- $wildcard, $wildcard, $wildcard,
- $community,
- ]);
-
- if (empty($count)) {
- return null;
+ $abandon_days = intval(DI::config()->get('system', 'account_abandon_days'));
+ if (!empty($abandon_days)) {
+ $user_condition = DBA::mergeConditions($user_condition, ["`last-activity` > ?", DateTimeFormat::utc('now - ' . $abandon_days . ' days')]);
}
- $data = DBA::select('gcontact', ['nurl'], [
- 'NOT `hide`
- AND `network` IN (?, ?, ?, ?)
- AND ((`last_contact` >= `last_failure`) OR (`updated` >= `last_failure`))
- AND (`url` LIKE ? OR `name` LIKE ? OR `location` LIKE ?
- OR `addr` LIKE ? OR `about` LIKE ? OR `keywords` LIKE ?)
- AND `community` = ?',
- Protocol::ACTIVITYPUB, Protocol::DFRN, $ostatus, $diaspora,
- $wildcard, $wildcard, $wildcard,
- $wildcard, $wildcard, $wildcard,
- $community,
- ], [
- 'group_by' => ['nurl', 'updated'],
- 'limit' => [$start, $itemPage],
- 'order' => ['updated' => 'DESC']
- ]);
+ $condition = $user_condition;
+ $condition[0] = "SELECT DISTINCT(`term`) FROM `search` INNER JOIN `user` ON `search`.`uid` = `user`.`uid` WHERE " . $user_condition[0];
+ $sql = array_shift($condition);
+ $termsStmt = DBA::p($sql, $condition);
- if (!DBA::isResult($data)) {
- return null;
+ $tags = [];
+ while ($term = DBA::fetch($termsStmt)) {
+ $tags[] = trim(mb_strtolower($term['term']), '#');
}
-
- $resultList = new ContactResultList($start, $itemPage, $count);
-
- while ($row = DBA::fetch($data)) {
- if (PortableContact::alternateOStatusUrl($row["nurl"])) {
- continue;
+ DBA::close($termsStmt);
+
+ $condition = $user_condition;
+ $condition[0] = "SELECT `include-tags` FROM `channel` INNER JOIN `user` ON `channel`.`uid` = `user`.`uid` WHERE " . $user_condition[0];
+ $sql = array_shift($condition);
+ $channels = DBA::p($sql, $condition);
+ while ($channel = DBA::fetch($channels)) {
+ foreach (explode(',', $channel['include-tags']) as $tag) {
+ $tag = trim(mb_strtolower($tag));
+ if (empty($tag)) {
+ continue;
+ }
+ if (!in_array($tag, $tags)) {
+ $tags[] = $tag;
+ }
}
-
- $urlparts = parse_url($row["nurl"]);
-
- // Ignore results that look strange.
- // For historic reasons the gcontact table does contain some garbage.
- if (!empty($urlparts['query']) || !empty($urlparts['fragment'])) {
- continue;
- }
-
- $contact = Contact::getDetailsByURL($row["nurl"], local_user());
-
- if ($contact["name"] == "") {
- $contact["name"] = end(explode("/", $urlparts["path"]));
- }
-
- $result = new ContactResult(
- $contact["name"],
- $contact["addr"],
- $contact["addr"],
- $contact["url"],
- $contact["photo"],
- $contact["network"],
- $contact["cid"],
- $contact["zid"],
- $contact["keywords"]
- );
-
- $resultList->addResult($result);
}
+ DBA::close($channels);
- DBA::close($data);
+ sort($tags);
- // Add found profiles from the global directory to the local directory
- Worker::add(PRIORITY_LOW, 'DiscoverPoCo', "dirsearch", urlencode($search));
-
- return $resultList;
+ return $tags;
}
}