1 /**
2 * This file Copyright (c) 2018 Magnolia International
3 * Ltd. (http://www.magnolia-cms.com). All rights reserved.
4 *
5 *
6 * This file is dual-licensed under both the Magnolia
7 * Network Agreement and the GNU General Public License.
8 * You may elect to use one or the other of these licenses.
9 *
10 * This file is distributed in the hope that it will be
11 * useful, but AS-IS and WITHOUT ANY WARRANTY; without even the
12 * implied warranty of MERCHANTABILITY or FITNESS FOR A
13 * PARTICULAR PURPOSE, TITLE, or NONINFRINGEMENT.
14 * Redistribution, except as permitted by whichever of the GPL
15 * or MNA you select, is prohibited.
16 *
17 * 1. For the GPL license (GPL), you can redistribute and/or
18 * modify this file under the terms of the GNU General
19 * Public License, Version 3, as published by the Free Software
20 * Foundation. You should have received a copy of the GNU
21 * General Public License, Version 3 along with this program;
22 * if not, write to the Free Software Foundation, Inc., 51
23 * Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
24 *
25 * 2. For the Magnolia Network Agreement (MNA), this file
26 * and the accompanying materials are made available under the
27 * terms of the MNA which accompanies this distribution, and
28 * is available at http://www.magnolia-cms.com/mna.html
29 *
30 * Any modifications to this file must keep this entire header
31 * intact.
32 *
33 */
34 package info.magnolia.admincentral.findbar.sniff;
35
36 import info.magnolia.admincentral.findbar.PeriscopeAppDetailCreator;
37 import info.magnolia.ui.api.ioc.AdmincentralScoped;
38 import info.magnolia.ui.api.location.LocationController;
39
40 import java.util.regex.Pattern;
41
42 import javax.inject.Inject;
43
44 /**
45 * This operation does a full-text search within the given workspace regarding given search query.
46 *
47 * Examples: <b>find</b> page <b>about</b> conditions, <b>find</b> article <b>about</b> magnolia.
48 */
49 @AdmincentralScoped
50 public class FindContentCommandSniffer extends AbstractFindCommandSniffer {
51
52 private static final Pattern COMMAND_PATTERN = Pattern.compile("find (?<appName>([^\\s]+)) about (?<content>([^\\s]+))");
53
54 @Inject
55 public FindContentCommandSniffer(LocationController locationController, PeriscopeAppDetailCreator periscopeAppDetailCreator) {
56 super(locationController, periscopeAppDetailCreator, COMMAND_PATTERN);
57 }
58
59 @Override
60 protected String buildQuery(String content) {
61 return new StringBuilder().append("SELECT * FROM ").append("[nt:base] AS t")
62 .append(" WHERE (lower(LOCALNAME()) LIKE ").append("'%").append(content).append("%'")
63 .append(" OR lower(title) LIKE ").append("'%").append(content).append("%')")
64 .append(" OR ").append("CONTAINS(t.*, '").append(content).append("')")
65 .append(" order by score() desc")
66 .toString();
67 }
68 }