001// --------------------------------------------------------------------------------
002// Copyright 2002-2024 Echo Three, LLC
003//
004// Licensed under the Apache License, Version 2.0 (the "License");
005// you may not use this file except in compliance with the License.
006// You may obtain a copy of the License at
007//
008//     http://www.apache.org/licenses/LICENSE-2.0
009//
010// Unless required by applicable law or agreed to in writing, software
011// distributed under the License is distributed on an "AS IS" BASIS,
012// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013// See the License for the specific language governing permissions and
014// limitations under the License.
015// --------------------------------------------------------------------------------
016
017package com.echothree.model.control.search.server.database;
018
019import com.echothree.model.data.core.server.entity.EntityAttribute;
020import com.echothree.model.data.search.server.entity.UserVisitSearch;
021import com.echothree.util.server.persistence.Session;
022import java.util.List;
023
024public class EntityMultipleListItemAttributeFacetQuery
025        extends BaseFacetQuery<EntityMultipleListItemAttributeFacetResult> {
026    
027    public EntityMultipleListItemAttributeFacetQuery(UserVisitSearch userVisitSearch) {
028        super(userVisitSearch.getSearch().getCachedSearch() == null
029                ? "SELECT eli_entitylistitemid AS EntityListItem, COUNT(*) AS Count "
030                + "FROM searchresults, entitylistitems, entitylistitemdetails, entitymultiplelistitemattributes "
031                + "WHERE srchr_srch_searchid = ? "
032                + "AND eli_activedetailid = elidt_entitylistitemdetailid AND elidt_ena_entityattributeid = ? "
033                + "AND srchr_eni_entityinstanceid = emlia_eni_entityinstanceid AND emlia_eli_entitylistitemid = eli_entitylistitemid AND emlia_thrutime = ? "
034                + "GROUP BY eli_entitylistitemid "
035                + "ORDER BY Count DESC"
036                : "SELECT eli_entitylistitemid AS EntityListItem, COUNT(*) AS Count "
037                + "FROM cachedexecutedsearchresults, entitylistitems, entitylistitemdetails, entitymultiplelistitemattributes "
038                + "WHERE cxsrchr_cxsrch_cachedexecutedsearchid = ? "
039                + "AND eli_activedetailid = elidt_entitylistitemdetailid AND elidt_ena_entityattributeid = ? "
040                + "AND cxsrchr_eni_entityinstanceid = emlia_eni_entityinstanceid AND emlia_eli_entitylistitemid = eli_entitylistitemid AND emlia_thrutime = ? "
041                + "GROUP BY eli_entitylistitemid "
042                + "ORDER BY Count DESC",
043                userVisitSearch);
044    }
045    
046    public List<EntityMultipleListItemAttributeFacetResult> execute(EntityAttribute entityAttribute) {
047        return super.execute(cachedExecutedSearch == null ? search : cachedExecutedSearch, entityAttribute, Session.MAX_TIME_LONG);
048    }
049    
050}