Accounts.java

Go to the documentation of this file.

/*
 * Autopsy Forensic Browser
 *
 * Copyright 2011-2021 Basis Technology Corp.
 * Contact: carrier <at> sleuthkit <dot> org
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.sleuthkit.autopsy.datamodel.accounts;
 
import com.google.common.collect.Range;
import com.google.common.collect.RangeMap;
import com.google.common.collect.TreeRangeMap;
import com.google.common.eventbus.EventBus;
import com.google.common.eventbus.Subscribe;
import java.awt.event.ActionEvent;
import java.beans.PropertyChangeEvent;
import java.beans.PropertyChangeListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.Collections;
import java.util.EnumSet;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import java.util.Optional;
import java.util.Set;
import java.util.function.Function;
import java.util.logging.Level;
import java.util.stream.Collectors;
import java.util.stream.Stream;
import javax.annotation.Nonnull;
import javax.annotation.concurrent.Immutable;
import javax.swing.AbstractAction;
import javax.swing.Action;
import javax.swing.SwingUtilities;
import org.apache.commons.lang3.StringUtils;
import org.openide.nodes.ChildFactory;
import org.openide.nodes.Children;
import org.openide.nodes.Node;
import org.openide.nodes.NodeNotFoundException;
import org.openide.nodes.NodeOp;
import org.openide.nodes.Sheet;
import org.openide.util.NbBundle;
import org.openide.util.Utilities;
import org.openide.util.WeakListeners;
import org.openide.util.lookup.Lookups;
import org.sleuthkit.autopsy.casemodule.Case;
import org.sleuthkit.autopsy.casemodule.NoCurrentCaseException;
import org.sleuthkit.autopsy.corecomponents.DataResultTopComponent;
import org.sleuthkit.autopsy.coreutils.Logger;
import org.sleuthkit.autopsy.datamodel.AutopsyItemVisitor;
import org.sleuthkit.autopsy.datamodel.AutopsyVisitableItem;
import org.sleuthkit.autopsy.datamodel.BlackboardArtifactNode;
import org.sleuthkit.autopsy.datamodel.CreditCards;
import org.sleuthkit.autopsy.datamodel.DataModelActionsFactory;
import org.sleuthkit.autopsy.datamodel.DisplayableItemNode;
import org.sleuthkit.autopsy.datamodel.DisplayableItemNodeVisitor;
import org.sleuthkit.autopsy.datamodel.Artifacts.UpdatableCountTypeNode;
import org.sleuthkit.autopsy.datamodel.NodeProperty;
import org.sleuthkit.autopsy.directorytree.DirectoryTreeTopComponent;
import org.sleuthkit.autopsy.ingest.IngestManager;
import org.sleuthkit.autopsy.ingest.ModuleDataEvent;
import org.sleuthkit.datamodel.AbstractFile;
import org.sleuthkit.datamodel.Account;
import org.sleuthkit.datamodel.BlackboardArtifact;
import org.sleuthkit.datamodel.BlackboardArtifact.Type;
import static org.sleuthkit.datamodel.BlackboardArtifact.Type.TSK_ACCOUNT;
import org.sleuthkit.datamodel.BlackboardAttribute;
import org.sleuthkit.datamodel.Content;
import org.sleuthkit.datamodel.DataArtifact;
import org.sleuthkit.datamodel.SleuthkitCase;
import org.sleuthkit.datamodel.TskCoreException;
import org.sleuthkit.datamodel.TskData.DbType;

final public class Accounts implements AutopsyVisitableItem {
 
    private static final Logger LOGGER = Logger.getLogger(Accounts.class.getName());
    private static final String ICON_BASE_PATH = "/org/sleuthkit/autopsy/images/"; //NON-NLS
    private static final Set<IngestManager.IngestJobEvent> INGEST_JOB_EVENTS_OF_INTEREST = EnumSet.of(IngestManager.IngestJobEvent.COMPLETED, IngestManager.IngestJobEvent.CANCELLED);
    private static final Set<IngestManager.IngestModuleEvent> INGEST_MODULE_EVENTS_OF_INTEREST = EnumSet.of(IngestManager.IngestModuleEvent.DATA_ADDED);
    private static final String DISPLAY_NAME = Bundle.Accounts_RootNode_displayName();
 
    @NbBundle.Messages("AccountsRootNode.name=Accounts")  //used for the viewArtifact navigation
    final public static String NAME = Bundle.AccountsRootNode_name();
 
    private final long filteringDSObjId; // 0 if not filtering/grouping by data source
 
    private final EventBus reviewStatusBus = new EventBus("ReviewStatusBus");
 
    /*
     * Should rejected accounts be shown in the accounts section of the tree.
     */
    private boolean showRejected = false; //NOPMD redundant initializer
 
    private final RejectAccounts rejectActionInstance;
    private final ApproveAccounts approveActionInstance;
 
    // tracks the number of each account type found
    private final AccountTypeResults accountTypeResults;

    public Accounts() {
        this(0);
    }

    public Accounts(long objId) {
        this.filteringDSObjId = objId;
 
        this.rejectActionInstance = new RejectAccounts();
        this.approveActionInstance = new ApproveAccounts();
        this.accountTypeResults = new AccountTypeResults();
    }
 
    @Override
    public <T> T accept(AutopsyItemVisitor<T> visitor) {
        return visitor.visit(this);
    }

    private String getRejectedArtifactFilterClause() {
        return showRejected ? " " : " AND blackboard_artifacts.review_status_id != " + BlackboardArtifact.ReviewStatus.REJECTED.getID() + " "; //NON-NLS
    }

    private String getFilterByDataSourceClause() {
        if (filteringDSObjId > 0) {
            return "  AND blackboard_artifacts.data_source_obj_id = " + filteringDSObjId + " ";
        }
 
        return " ";
    }

    @Deprecated
    public Action newToggleShowRejectedAction() {
        return new ToggleShowRejected();
    }

    private abstract class ObservingChildren<X> extends ChildFactory.Detachable<X> {

        ObservingChildren() {
            super();
        }

        @Override
        abstract protected boolean createKeys(List<X> list);

        @Subscribe
        abstract void handleReviewStatusChange(ReviewStatusChangeEvent event);
 
        @Subscribe
        abstract void handleDataAdded(ModuleDataEvent event);
 
        @Override
        protected void finalize() throws Throwable {
            super.finalize();
            reviewStatusBus.unregister(ObservingChildren.this);
        }
 
        @Override
        protected void addNotify() {
            super.addNotify();
            refresh(true);
            reviewStatusBus.register(ObservingChildren.this);
        }
    }

    @NbBundle.Messages({"Accounts.RootNode.displayName=Communication Accounts"})
    final public class AccountsRootNode extends UpdatableCountTypeNode {
 
        public AccountsRootNode() {
            super(Children.create(new AccountTypeFactory(), true),
                    Lookups.singleton(Accounts.this),
                    DISPLAY_NAME,
                    filteringDSObjId,
                    TSK_ACCOUNT);
 
            setName(Accounts.NAME);
            this.setIconBaseWithExtension("org/sleuthkit/autopsy/images/accounts.png");    //NON-NLS
        }
 
        @Override
        public boolean isLeafTypeNode() {
            return false;
        }
 
        @Override
        public <T> T accept(DisplayableItemNodeVisitor<T> visitor) {
            return visitor.visit(this);
        }
 
        @Override
        public String getItemType() {
            return getClass().getName();
        }
 
        @Override
        protected long fetchChildCount(SleuthkitCase skCase) throws TskCoreException {
            String accountTypesInUseQuery
                    = "SELECT COUNT(*) AS count\n"
                    + "FROM (\n"
                    + "  SELECT MIN(blackboard_attributes.value_text) AS account_type\n"
                    + "  FROM blackboard_artifacts\n"
                    + "  LEFT JOIN blackboard_attributes ON blackboard_artifacts.artifact_id = blackboard_attributes.artifact_id\n"
                    + "  WHERE blackboard_artifacts.artifact_type_id = " + TSK_ACCOUNT.getTypeID() + "\n"
                    + "  AND blackboard_attributes.attribute_type_id = " + BlackboardAttribute.Type.TSK_ACCOUNT_TYPE.getTypeID() + "\n"
                    + "  AND blackboard_attributes.value_text IS NOT NULL\n"
                    + getFilterByDataSourceClause() + "\n"
                    + "  -- group by artifact_id to ensure only one account type per artifact\n"
                    + "  GROUP BY blackboard_artifacts.artifact_id\n"
                    + ") res\n";
 
            try (SleuthkitCase.CaseDbQuery executeQuery = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(accountTypesInUseQuery);
                    ResultSet resultSet = executeQuery.getResultSet()) {
 
                if (resultSet.next()) {
                    return resultSet.getLong("count");
                }
 
            } catch (TskCoreException | SQLException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error querying for count of all account types", ex);
            }
 
            return 0;
        }
 
    }

    private class AccountTypeResults {
 
        private final Map<String, Long> counts = new HashMap<>();
 
        AccountTypeResults() {
            update();
        }

        Long getCount(String accountType) {
            return counts.get(accountType);
        }

        List<String> getTypes() {
            List<String> types = new ArrayList<>(counts.keySet());
            Collections.sort(types);
            return types;
        }

        private void update() {
            String accountTypesInUseQuery
                    = "SELECT res.account_type, COUNT(*) AS count\n"
                    + "FROM (\n"
                    + "  SELECT MIN(blackboard_attributes.value_text) AS account_type\n"
                    + "  FROM blackboard_artifacts\n"
                    + "  LEFT JOIN blackboard_attributes ON blackboard_artifacts.artifact_id = blackboard_attributes.artifact_id\n"
                    + "  WHERE blackboard_artifacts.artifact_type_id = " + TSK_ACCOUNT.getTypeID() + "\n"
                    + "  AND blackboard_attributes.attribute_type_id = " + BlackboardAttribute.Type.TSK_ACCOUNT_TYPE.getTypeID() + "\n"
                    + getFilterByDataSourceClause() + "\n"
                    + "  -- group by artifact_id to ensure only one account type per artifact\n"
                    + "  GROUP BY blackboard_artifacts.artifact_id\n"
                    + ") res\n"
                    + "GROUP BY res.account_type";
 
            try (SleuthkitCase.CaseDbQuery executeQuery = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(accountTypesInUseQuery);
                    ResultSet resultSet = executeQuery.getResultSet()) {
 
                counts.clear();
                while (resultSet.next()) {
                    String accountType = resultSet.getString("account_type");
                    Long count = resultSet.getLong("count");
                    counts.put(accountType, count);
                }
            } catch (TskCoreException | SQLException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error querying for account_types", ex);
            }
        }
    }

    private class AccountTypeFactory extends ObservingChildren<String> {
 
        /*
         * The pcl is in this class because it has the easiest mechanisms to add
         * and remove itself during its life cycles.
         */
        private final PropertyChangeListener pcl = new PropertyChangeListener() {
            @Override
            public void propertyChange(PropertyChangeEvent evt) {
                String eventType = evt.getPropertyName();
                if (eventType.equals(IngestManager.IngestModuleEvent.DATA_ADDED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        ModuleDataEvent eventData = (ModuleDataEvent) evt.getOldValue();
                        if (null != eventData
                                && eventData.getBlackboardArtifactType().getTypeID() == Type.TSK_ACCOUNT.getTypeID()) {
                            accountTypeResults.update();
                            reviewStatusBus.post(eventData);
                        }
                    } catch (NoCurrentCaseException notUsed) {
                        // Case is closed, do nothing.
                    }
                } else if (eventType.equals(IngestManager.IngestJobEvent.COMPLETED.toString())
                        || eventType.equals(IngestManager.IngestJobEvent.CANCELLED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        accountTypeResults.update();
                        refresh(true);
                    } catch (NoCurrentCaseException notUsed) {
                        // Case is closed, do nothing.
                    }
                }
            }
        };
 
        private final PropertyChangeListener weakPcl = WeakListeners.propertyChange(pcl, null);
 
        @Subscribe
        @Override
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            refresh(true);
        }
 
        @Subscribe
        @Override
        void handleDataAdded(ModuleDataEvent event) {
            refresh(true);
        }
 
        @Override
        protected boolean createKeys(List<String> list) {
            list.addAll(accountTypeResults.getTypes());
            return true;
        }

        private Node[] getNodeArr(Node node) {
            reviewStatusBus.register(node);
            return new Node[]{node};
        }
 
        @Override
        protected Node[] createNodesForKey(String accountTypeName) {
 
            if (Account.Type.CREDIT_CARD.getTypeName().equals(accountTypeName)) {
                return getNodeArr(new CreditCardNumberAccountTypeNode());
            } else {
 
                try {
                    Account.Type accountType = Case.getCurrentCaseThrows().getSleuthkitCase().getCommunicationsManager().getAccountType(accountTypeName);
                    if (accountType != null) {
                        return getNodeArr(new DefaultAccountTypeNode(accountType));
                    } else {
                        // This can only happen if a TSK_ACCOUNT artifact was created not using CommunicationManager
                        LOGGER.log(Level.SEVERE, "Unknown account type '" + accountTypeName + "' found - account will not be displayed.\n"
                                + "Account type names must match an entry in the display_name column of the account_types table.\n"
                                + "Accounts should be created using the CommunicationManager API.");
                    }
                } catch (TskCoreException | NoCurrentCaseException ex) {
                    LOGGER.log(Level.SEVERE, "Error getting display name for account type. ", ex);
                }
 
                return new Node[]{};
            }
        }
 
        @Override
        protected void finalize() throws Throwable {
            IngestManager.getInstance().removeIngestJobEventListener(weakPcl);
            IngestManager.getInstance().removeIngestModuleEventListener(weakPcl);
            Case.removeEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
            super.finalize();
        }
 
        @Override
        protected void addNotify() {
            IngestManager.getInstance().addIngestJobEventListener(INGEST_JOB_EVENTS_OF_INTEREST, weakPcl);
            IngestManager.getInstance().addIngestModuleEventListener(INGEST_MODULE_EVENTS_OF_INTEREST, weakPcl);
            Case.addEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
            super.addNotify();
            refresh(true);
        }
 
    }
 
    final private class DefaultAccountFactory extends ObservingChildren<Long> {
 
        private final Account.Type accountType;
 
        private DefaultAccountFactory(Account.Type accountType) {
            this.accountType = accountType;
        }
 
        private final PropertyChangeListener pcl = new PropertyChangeListener() {
            @Override
            public void propertyChange(PropertyChangeEvent evt) {
                String eventType = evt.getPropertyName();
                if (eventType.equals(IngestManager.IngestModuleEvent.DATA_ADDED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        ModuleDataEvent eventData = (ModuleDataEvent) evt.getOldValue();
                        if (null != eventData
                                && eventData.getBlackboardArtifactType().getTypeID() == Type.TSK_ACCOUNT.getTypeID()) {
                            reviewStatusBus.post(eventData);
                        }
                    } catch (NoCurrentCaseException notUsed) {
                        // Case is closed, do nothing.
                    }
                } else if (eventType.equals(IngestManager.IngestJobEvent.COMPLETED.toString())
                        || eventType.equals(IngestManager.IngestJobEvent.CANCELLED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        refresh(true);
 
                    } catch (NoCurrentCaseException notUsed) {
                        // Case is closed, do nothing.
                    }
                }
            }
        };
 
        private final PropertyChangeListener weakPcl = WeakListeners.propertyChange(pcl, null);
 
        @Override
        protected void addNotify() {
            IngestManager.getInstance().addIngestJobEventListener(INGEST_JOB_EVENTS_OF_INTEREST, weakPcl);
            IngestManager.getInstance().addIngestModuleEventListener(INGEST_MODULE_EVENTS_OF_INTEREST, weakPcl);
            Case.addEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
        }
 
        @Override
        protected void finalize() throws Throwable {
            super.finalize();
            IngestManager.getInstance().removeIngestJobEventListener(weakPcl);
            IngestManager.getInstance().removeIngestModuleEventListener(weakPcl);
            Case.removeEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
        }
 
        @Override
        protected boolean createKeys(List<Long> list) {
            String query
                    = "SELECT blackboard_artifacts.artifact_obj_id " //NON-NLS
                    + " FROM blackboard_artifacts " //NON-NLS
                    + "      JOIN blackboard_attributes ON blackboard_artifacts.artifact_id = blackboard_attributes.artifact_id " //NON-NLS
                    + " WHERE blackboard_artifacts.artifact_type_id = " + BlackboardArtifact.Type.TSK_ACCOUNT.getTypeID() //NON-NLS
                    + "     AND blackboard_attributes.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_ACCOUNT_TYPE.getTypeID() //NON-NLS
                    + "     AND blackboard_attributes.value_text = '" + accountType.getTypeName() + "'" //NON-NLS
                    + getFilterByDataSourceClause()
                    + getRejectedArtifactFilterClause(); //NON-NLS
            try (SleuthkitCase.CaseDbQuery results = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(query);
                    ResultSet rs = results.getResultSet();) {
                List<Long> tempList = new ArrayList<>();
                while (rs.next()) {
                    tempList.add(rs.getLong("artifact_obj_id")); // NON-NLS
                }
                list.addAll(tempList);
            } catch (TskCoreException | SQLException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error querying for account artifacts.", ex); //NON-NLS
            }
 
            return true;
        }
 
        @Override
        protected Node[] createNodesForKey(Long t) {
            try {
                return new Node[]{new BlackboardArtifactNode(Case.getCurrentCaseThrows().getSleuthkitCase().getBlackboard().getDataArtifactById(t))};
            } catch (TskCoreException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error get black board artifact with id " + t, ex);
                return new Node[0];
            }
        }
 
        @Subscribe
        @Override
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            refresh(true);
        }
 
        @Subscribe
        @Override
        void handleDataAdded(ModuleDataEvent event) {
            refresh(true);
        }
    }

    final public class DefaultAccountTypeNode extends DisplayableItemNode {
 
        private final Account.Type accountType;
 
        private DefaultAccountTypeNode(Account.Type accountType) {
            super(Children.create(new DefaultAccountFactory(accountType), true), Lookups.singleton(accountType));
            this.accountType = accountType;
            String iconPath = getIconFilePath(accountType);
            this.setIconBaseWithExtension(iconPath != null && iconPath.charAt(0) == '/' ? iconPath.substring(1) : iconPath);   //NON-NLS
            setName(accountType.getTypeName());
            updateName();
        }
 
        @Override
        public boolean isLeafTypeNode() {
            return true;
        }
 
        @Override
        public <T> T accept(DisplayableItemNodeVisitor<T> visitor) {
            return visitor.visit(this);
        }
 
        @Override
        public String getItemType() {
            return getClass().getName();
        }
 
        @Subscribe
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            updateName();
        }
 
        @Subscribe
        void handleDataAdded(ModuleDataEvent event) {
            updateName();
        }

        public void updateName() {
            setDisplayName(String.format("%s (%d)", accountType.getDisplayName(), accountTypeResults.getCount(accountType.getTypeName())));
        }
    }

    private enum CreditCardViewMode {
        BY_FILE,
        BY_BIN;
    }
 
    final private class ViewModeFactory extends ObservingChildren<CreditCardViewMode> {
 
        private final PropertyChangeListener pcl = new PropertyChangeListener() {
            @Override
            public void propertyChange(PropertyChangeEvent evt) {
                String eventType = evt.getPropertyName();
                if (eventType.equals(IngestManager.IngestModuleEvent.DATA_ADDED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        ModuleDataEvent eventData = (ModuleDataEvent) evt.getOldValue();
                        if (null != eventData
                                && eventData.getBlackboardArtifactType().getTypeID() == Type.TSK_ACCOUNT.getTypeID()) {
                            reviewStatusBus.post(eventData);
                        }
                    } catch (NoCurrentCaseException notUsed) {
                        // Case is closed, do nothing.
                    }
                } else if (eventType.equals(IngestManager.IngestJobEvent.COMPLETED.toString())
                        || eventType.equals(IngestManager.IngestJobEvent.CANCELLED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        refresh(true);
 
                    } catch (NoCurrentCaseException notUsed) {
                        // Case is closed, do nothing.
                    }
                }
            }
        };
 
        private final PropertyChangeListener weakPcl = WeakListeners.propertyChange(pcl, null);
 
        @Subscribe
        @Override
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            refresh(true);
        }
 
        @Subscribe
        @Override
        void handleDataAdded(ModuleDataEvent event) {
            refresh(true);
        }
 
        @Override
        protected void addNotify() {
            IngestManager.getInstance().addIngestJobEventListener(INGEST_JOB_EVENTS_OF_INTEREST, weakPcl);
            IngestManager.getInstance().addIngestModuleEventListener(INGEST_MODULE_EVENTS_OF_INTEREST, weakPcl);
            Case.addEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
            super.addNotify();
        }
 
        @Override
        protected void finalize() throws Throwable {
            super.finalize();
            IngestManager.getInstance().removeIngestJobEventListener(weakPcl);
            IngestManager.getInstance().removeIngestModuleEventListener(weakPcl);
            Case.removeEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
            super.removeNotify();
        }

        @Override
        protected boolean createKeys(List<CreditCardViewMode> list) {
            list.addAll(Arrays.asList(CreditCardViewMode.values()));
 
            return true;
        }
 
        @Override
        protected Node[] createNodesForKey(CreditCardViewMode key) {
            switch (key) {
                case BY_BIN:
                    return new Node[]{new ByBINNode()};
                case BY_FILE:
                    return new Node[]{new ByFileNode()};
                default:
                    return new Node[0];
            }
        }
    }

    final public class CreditCardNumberAccountTypeNode extends DisplayableItemNode {

        private CreditCardNumberAccountTypeNode() {
            super(Children.create(new ViewModeFactory(), true), Lookups.singleton(Account.Type.CREDIT_CARD.getDisplayName()));
            setName(Account.Type.CREDIT_CARD.getDisplayName());
            this.setIconBaseWithExtension("org/sleuthkit/autopsy/images/credit-cards.png");   //NON-NLS
        }

        public void updateName() {
            setName(String.format("%s (%d)", Account.Type.CREDIT_CARD.getDisplayName(), accountTypeResults.getCount(Account.Type.CREDIT_CARD.getTypeName())));
        }
 
        @Subscribe
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            updateName();
        }
 
        @Subscribe
        void handleDataAdded(ModuleDataEvent event) {
            updateName();
        }
 
        @Override
        public boolean isLeafTypeNode() {
            return false;
        }
 
        @Override
        public <T> T accept(DisplayableItemNodeVisitor<T> visitor) {
            return visitor.visit(this);
        }
 
        @Override
        public String getItemType() {
            return getClass().getName();
        }
    }
 
    final private class FileWithCCNFactory extends ObservingChildren<FileWithCCN> {
 
        private final PropertyChangeListener pcl = new PropertyChangeListener() {
            @Override
            public void propertyChange(PropertyChangeEvent evt) {
                String eventType = evt.getPropertyName();
                if (eventType.equals(IngestManager.IngestModuleEvent.DATA_ADDED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        ModuleDataEvent eventData = (ModuleDataEvent) evt.getOldValue();
                        if (null != eventData
                                && eventData.getBlackboardArtifactType().getTypeID() == Type.TSK_ACCOUNT.getTypeID()) {
                            reviewStatusBus.post(eventData);
                        }
                    } catch (NoCurrentCaseException notUsed) {
                        // Case is closed, do nothing.
                    }
                } else if (eventType.equals(IngestManager.IngestJobEvent.COMPLETED.toString())
                        || eventType.equals(IngestManager.IngestJobEvent.CANCELLED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        refresh(true);
 
                    } catch (NoCurrentCaseException notUsed) {
                        // Case is closed, do nothing.
                    }
                }
            }
        };
 
        private final PropertyChangeListener weakPcl = WeakListeners.propertyChange(pcl, null);
 
        @Override
        protected void addNotify() {
            IngestManager.getInstance().addIngestJobEventListener(INGEST_JOB_EVENTS_OF_INTEREST, weakPcl);
            IngestManager.getInstance().addIngestModuleEventListener(INGEST_MODULE_EVENTS_OF_INTEREST, weakPcl);
            Case.addEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
            super.addNotify();
        }
 
        @Override
        protected void finalize() throws Throwable {
            super.finalize();
            IngestManager.getInstance().removeIngestJobEventListener(weakPcl);
            IngestManager.getInstance().removeIngestModuleEventListener(weakPcl);
            Case.removeEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
        }
 
        @Subscribe
        @Override
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            refresh(true);
        }
 
        @Subscribe
        @Override
        void handleDataAdded(ModuleDataEvent event) {
            refresh(true);
        }
 
        @Override
        protected boolean createKeys(List<FileWithCCN> list) {
            try {
                String query
                        = "SELECT blackboard_artifacts.obj_id," //NON-NLS
                        + "      solr_attribute.value_text AS solr_document_id, "; //NON-NLS
                if (Case.getCurrentCaseThrows().getSleuthkitCase().getDatabaseType().equals(DbType.POSTGRESQL)) {
                    query += "      string_agg(blackboard_artifacts.artifact_id::character varying, ',') AS artifact_IDs, " //NON-NLS
                            + "      string_agg(blackboard_artifacts.review_status_id::character varying, ',') AS review_status_ids, ";
                } else {
                    query += "      GROUP_CONCAT(blackboard_artifacts.artifact_id) AS artifact_IDs, " //NON-NLS
                            + "      GROUP_CONCAT(blackboard_artifacts.review_status_id) AS review_status_ids, ";
                }
                query += "      COUNT( blackboard_artifacts.artifact_id) AS hits  " //NON-NLS
                        + " FROM blackboard_artifacts " //NON-NLS
                        + " LEFT JOIN blackboard_attributes as solr_attribute ON blackboard_artifacts.artifact_id = solr_attribute.artifact_id " //NON-NLS
                        + "                                AND solr_attribute.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_KEYWORD_SEARCH_DOCUMENT_ID.getTypeID() //NON-NLS
                        + " LEFT JOIN blackboard_attributes as account_type ON blackboard_artifacts.artifact_id = account_type.artifact_id " //NON-NLS
                        + "                                AND account_type.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_ACCOUNT_TYPE.getTypeID() //NON-NLS
                        + "                                AND account_type.value_text = '" + Account.Type.CREDIT_CARD.getTypeName() + "'" //NON-NLS
                        + " WHERE blackboard_artifacts.artifact_type_id = " + BlackboardArtifact.Type.TSK_ACCOUNT.getTypeID() //NON-NLS
                        + getFilterByDataSourceClause()
                        + getRejectedArtifactFilterClause()
                        + " GROUP BY blackboard_artifacts.obj_id, solr_document_id " //NON-NLS
                        + " ORDER BY hits DESC ";  //NON-NLS
                try (SleuthkitCase.CaseDbQuery results = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(query);
                        ResultSet resultSet = results.getResultSet();) {
                    while (resultSet.next()) {
                        long file_id = resultSet.getLong("obj_id");
                        AbstractFile abstractFileById = Case.getCurrentCaseThrows().getSleuthkitCase().getAbstractFileById(file_id);
                        if (abstractFileById != null) {
                            list.add(new FileWithCCN(
                                    abstractFileById,
                                    file_id, //NON-NLS
                                    resultSet.getString("solr_document_id"), //NON-NLS
                                    unGroupConcat(resultSet.getString("artifact_IDs"), Long::valueOf), //NON-NLS
                                    resultSet.getLong("hits"), //NON-NLS
                                    new HashSet<>(unGroupConcat(resultSet.getString("review_status_ids"), reviewStatusID -> BlackboardArtifact.ReviewStatus.withID(Integer.valueOf(reviewStatusID))))));  //NON-NLS
                        }
                    }
                } catch (TskCoreException | SQLException ex) {
                    LOGGER.log(Level.SEVERE, "Error querying for files with ccn hits.", ex); //NON-NLS
                }
                
            } catch (NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error getting case.", ex);
            }
            return true;
        }
 
        @Override
        protected Node[] createNodesForKey(FileWithCCN key) {
            //add all account artifacts for the file and the file itself to the lookup
            try {
                List<Object> lookupContents = new ArrayList<>();
                for (long artId : key.artifactIDs) {
                    lookupContents.add(Case.getCurrentCaseThrows().getSleuthkitCase().getBlackboardArtifact(artId));
                }
                AbstractFile abstractFileById = key.getFile();
                lookupContents.add(abstractFileById);
                return new Node[]{new FileWithCCNNode(key, abstractFileById, lookupContents.toArray())};
            } catch (TskCoreException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error getting content for file with ccn hits.", ex); //NON-NLS
                return new Node[0];
            }
        }
    }

    final public class ByFileNode extends DisplayableItemNode {

        private ByFileNode() {
            super(Children.create(new FileWithCCNFactory(), true), Lookups.singleton("By File"));
            setName("By File");   //NON-NLS
            updateDisplayName();
            this.setIconBaseWithExtension("org/sleuthkit/autopsy/images/file-icon.png");   //NON-NLS
            reviewStatusBus.register(this);
        }
 
        @NbBundle.Messages({
            "# {0} - number of children",
            "Accounts.ByFileNode.displayName=By File ({0})"})
        private void updateDisplayName() {
            String query
                    = "SELECT count(*) FROM ( SELECT count(*) AS documents "
                    + " FROM blackboard_artifacts " //NON-NLS
                    + " LEFT JOIN blackboard_attributes as solr_attribute ON blackboard_artifacts.artifact_id = solr_attribute.artifact_id " //NON-NLS
                    + "                                AND solr_attribute.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_KEYWORD_SEARCH_DOCUMENT_ID.getTypeID() //NON-NLS
                    + " LEFT JOIN blackboard_attributes as account_type ON blackboard_artifacts.artifact_id = account_type.artifact_id " //NON-NLS
                    + "                                AND account_type.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_ACCOUNT_TYPE.getTypeID() //NON-NLS
                    + "                                AND account_type.value_text = '" + Account.Type.CREDIT_CARD.getTypeName() + "'" //NON-NLS
                    + " WHERE blackboard_artifacts.artifact_type_id = " + BlackboardArtifact.Type.TSK_ACCOUNT.getTypeID() //NON-NLS
                    + getFilterByDataSourceClause()
                    + getRejectedArtifactFilterClause()
                    + " GROUP BY blackboard_artifacts.obj_id, solr_attribute.value_text ) AS foo";
            try (SleuthkitCase.CaseDbQuery results = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(query);
                    ResultSet resultSet = results.getResultSet();) {
                while (resultSet.next()) {
                    if (Case.getCurrentCaseThrows().getSleuthkitCase().getDatabaseType().equals(DbType.POSTGRESQL)) {
                        setDisplayName(Bundle.Accounts_ByFileNode_displayName(resultSet.getLong("count")));
                    } else {
                        setDisplayName(Bundle.Accounts_ByFileNode_displayName(resultSet.getLong("count(*)")));
                    }
                }
            } catch (TskCoreException | SQLException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error querying for files with ccn hits.", ex); //NON-NLS
 
            }
        }
 
        @Override
        public boolean isLeafTypeNode() {
            return true;
        }
 
        @Override
        public <T> T accept(DisplayableItemNodeVisitor<T> visitor) {
            return visitor.visit(this);
        }
 
        @Override
        public String getItemType() {
            return getClass().getName();
        }
 
        @Subscribe
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            updateDisplayName();
        }
 
        @Subscribe
        void handleDataAdded(ModuleDataEvent event) {
            updateDisplayName();
        }
    }
 
    final private class BINFactory extends ObservingChildren<BinResult> {
 
        private final PropertyChangeListener pcl = new PropertyChangeListener() {
            @Override
            public void propertyChange(PropertyChangeEvent evt) {
                String eventType = evt.getPropertyName();
                if (eventType.equals(IngestManager.IngestModuleEvent.DATA_ADDED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
                        ModuleDataEvent eventData = (ModuleDataEvent) evt.getOldValue();
                        if (null != eventData
                                && eventData.getBlackboardArtifactType().getTypeID() == Type.TSK_ACCOUNT.getTypeID()) {
                            reviewStatusBus.post(eventData);
                        }
                    } catch (NoCurrentCaseException notUsed) { //NOPMD empy catch clause
                        // Case is closed, do nothing.
                    }
                } else if (eventType.equals(IngestManager.IngestJobEvent.COMPLETED.toString())
                        || eventType.equals(IngestManager.IngestJobEvent.CANCELLED.toString())) {
                    try {
                        Case.getCurrentCaseThrows();
 
                        refresh(true);
                    } catch (NoCurrentCaseException notUsed) { //NOPMD empy catch clause
                        // Case is closed, do nothing.
                    }
                }
            }
        };
 
        private final PropertyChangeListener weakPcl = WeakListeners.propertyChange(pcl, null);
 
        @Override
        protected void addNotify() {
            IngestManager.getInstance().addIngestJobEventListener(INGEST_JOB_EVENTS_OF_INTEREST, weakPcl);
            IngestManager.getInstance().addIngestModuleEventListener(INGEST_MODULE_EVENTS_OF_INTEREST, weakPcl);
            Case.addEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
            super.addNotify();
        }
 
        @Override
        protected void finalize() throws Throwable {
            super.finalize();
            IngestManager.getInstance().removeIngestJobEventListener(weakPcl);
            IngestManager.getInstance().removeIngestModuleEventListener(weakPcl);
            Case.removeEventTypeSubscriber(EnumSet.of(Case.Events.CURRENT_CASE), weakPcl);
        }
 
        @Subscribe
        @Override
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            refresh(true);
        }
 
        @Subscribe
        @Override
        void handleDataAdded(ModuleDataEvent event) {
            refresh(true);
        }
 
        @Override
        protected boolean createKeys(List<BinResult> list) {
 
            RangeMap<Integer, BinResult> binRanges = TreeRangeMap.create();
 
            String query
                    = "SELECT SUBSTR(blackboard_attributes.value_text,1,8) AS BIN, " //NON-NLS
                    + "     COUNT(blackboard_artifacts.artifact_id) AS count " //NON-NLS
                    + " FROM blackboard_artifacts " //NON-NLS
                    + "      JOIN blackboard_attributes ON blackboard_artifacts.artifact_id = blackboard_attributes.artifact_id" //NON-NLS
                    + " WHERE blackboard_artifacts.artifact_type_id = " + BlackboardArtifact.Type.TSK_ACCOUNT.getTypeID() //NON-NLS
                    + "     AND blackboard_attributes.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_CARD_NUMBER.getTypeID() //NON-NLS
                    + getFilterByDataSourceClause()
                    + getRejectedArtifactFilterClause()
                    + " GROUP BY BIN " //NON-NLS
                    + " ORDER BY BIN "; //NON-NLS
            try (SleuthkitCase.CaseDbQuery results = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(query);
                    ResultSet resultSet = results.getResultSet();) {
                //sort all te individual bins in to the ranges
                while (resultSet.next()) {
                    final Integer bin = Integer.valueOf(resultSet.getString("BIN"));
                    long count = resultSet.getLong("count");
 
                    BINRange binRange = (BINRange) CreditCards.getBINInfo(bin);
                    BinResult previousResult = binRanges.get(bin);
 
                    if (previousResult != null) {
                        binRanges.remove(Range.closed(previousResult.getBINStart(), previousResult.getBINEnd()));
                        count += previousResult.getCount();
                    }
 
                    if (binRange == null) {
                        binRanges.put(Range.closed(bin, bin), new BinResult(count, bin, bin));
                    } else {
                        binRanges.put(Range.closed(binRange.getBINstart(), binRange.getBINend()), new BinResult(count, binRange));
                    }
                }
                binRanges.asMapOfRanges().values().forEach(list::add);
            } catch (TskCoreException | SQLException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error querying for BINs.", ex); //NON-NLS
            }
 
            return true;
        }
 
        @Override
        protected Node[] createNodesForKey(BinResult key) {
            return new Node[]{new BINNode(key)};
        }
    }

    final public class ByBINNode extends DisplayableItemNode {

        @NbBundle.Messages("Accounts.ByBINNode.name=By BIN")
        private ByBINNode() {
            super(Children.create(new BINFactory(), true), Lookups.singleton(Bundle.Accounts_ByBINNode_name()));
            setName(Bundle.Accounts_ByBINNode_name());  //NON-NLS
            updateDisplayName();
            this.setIconBaseWithExtension("org/sleuthkit/autopsy/images/bank.png");   //NON-NLS
            reviewStatusBus.register(this);
        }
 
        @NbBundle.Messages({
            "# {0} - number of children",
            "Accounts.ByBINNode.displayName=By BIN ({0})"})
        private void updateDisplayName() {
            String query
                    = "SELECT count(distinct SUBSTR(blackboard_attributes.value_text,1,8)) AS BINs " //NON-NLS
                    + " FROM blackboard_artifacts " //NON-NLS
                    + "      JOIN blackboard_attributes ON blackboard_artifacts.artifact_id = blackboard_attributes.artifact_id" //NON-NLS
                    + " WHERE blackboard_artifacts.artifact_type_id = " + BlackboardArtifact.Type.TSK_ACCOUNT.getTypeID() //NON-NLS
                    + "     AND blackboard_attributes.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_CARD_NUMBER.getTypeID() //NON-NLS
                    + getFilterByDataSourceClause()
                    + getRejectedArtifactFilterClause(); //NON-NLS
            try (SleuthkitCase.CaseDbQuery results = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(query);
                    ResultSet resultSet = results.getResultSet();) {
                while (resultSet.next()) {
                    setDisplayName(Bundle.Accounts_ByBINNode_displayName(resultSet.getLong("BINs")));
                }
            } catch (TskCoreException | SQLException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error querying for BINs.", ex); //NON-NLS
            }
        }
 
        @Override
        public boolean isLeafTypeNode() {
            return false;
        }
 
        @Override
        public <T> T accept(DisplayableItemNodeVisitor<T> visitor) {
            return visitor.visit(this);
        }
 
        @Override
        public String getItemType() {
            return getClass().getName();
        }
 
        @Subscribe
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            updateDisplayName();
        }
 
        @Subscribe
        void handleDataAdded(ModuleDataEvent event) {
            updateDisplayName();
        }
    }

    @Immutable
    final private static class FileWithCCN {
 
        @Override
        public int hashCode() {
            int hash = 5;
            hash = 79 * hash + (int) (this.objID ^ (this.objID >>> 32));
            hash = 79 * hash + Objects.hashCode(this.keywordSearchDocID);
            hash = 79 * hash + Objects.hashCode(this.artifactIDs);
            hash = 79 * hash + (int) (this.hits ^ (this.hits >>> 32));
            hash = 79 * hash + Objects.hashCode(this.statuses);
            return hash;
        }
 
        @Override
        public boolean equals(Object obj) {
            if (this == obj) {
                return true;
            }
            if (obj == null) {
                return false;
            }
            if (getClass() != obj.getClass()) {
                return false;
            }
            final FileWithCCN other = (FileWithCCN) obj;
            if (this.objID != other.objID) {
                return false;
            }
            if (this.hits != other.hits) {
                return false;
            }
            if (!Objects.equals(this.keywordSearchDocID, other.keywordSearchDocID)) {
                return false;
            }
            if (!Objects.equals(this.artifactIDs, other.artifactIDs)) {
                return false;
            }
            if (!Objects.equals(this.statuses, other.statuses)) {
                return false;
            }
            return true;
        }
 
        private final long objID;
        private final String keywordSearchDocID;
        private final List<Long> artifactIDs;
        private final long hits;
        private final Set<BlackboardArtifact.ReviewStatus> statuses;
        private final AbstractFile file;
 
        private FileWithCCN(AbstractFile file, long objID, String solrDocID, List<Long> artifactIDs, long hits, Set<BlackboardArtifact.ReviewStatus> statuses) {
            this.objID = objID;
            this.keywordSearchDocID = solrDocID;
            this.artifactIDs = artifactIDs;
            this.hits = hits;
            this.statuses = statuses;
            this.file = file;
        }

        public long getObjID() {
            return objID;
        }

        public String getkeywordSearchDocID() {
            return keywordSearchDocID;
        }

        public List<Long> getArtifactIDs() {
            return Collections.unmodifiableList(artifactIDs);
        }

        public long getHits() {
            return hits;
        }

        public Set<BlackboardArtifact.ReviewStatus> getStatuses() {
            return Collections.unmodifiableSet(statuses);
        }
 
        AbstractFile getFile() {
            return file;
        }
    }

    static <X> List<X> unGroupConcat(String groupConcat, Function<String, X> mapper) {
        return StringUtils.isBlank(groupConcat) ? Collections.emptyList()
                : Stream.of(groupConcat.split(",")) //NON-NLS
                        .map(mapper::apply)
                        .collect(Collectors.toList());
    }

    final public class FileWithCCNNode extends DisplayableItemNode {
 
        private final FileWithCCN fileKey;
        private final String fileName;

        @NbBundle.Messages({
            "# {0} - raw file name",
            "# {1} - solr chunk id",
            "Accounts.FileWithCCNNode.unallocatedSpaceFile.displayName={0}_chunk_{1}"})
        private FileWithCCNNode(FileWithCCN key, Content content, Object[] lookupContents) {
            super(Children.LEAF, Lookups.fixed(lookupContents));
            this.fileKey = key;
            this.fileName = (key.getkeywordSearchDocID() == null)
                    ? content.getName()
                    : Bundle.Accounts_FileWithCCNNode_unallocatedSpaceFile_displayName(content.getName(), StringUtils.substringAfter(key.getkeywordSearchDocID(), "_")); //NON-NLS
            setName(fileName + key.getObjID());
            setDisplayName(fileName);
        }
 
        @Override
        public boolean isLeafTypeNode() {
            return true;
        }
 
        @Override
        public <T> T accept(DisplayableItemNodeVisitor<T> visitor) {
            return visitor.visit(this);
        }
 
        @Override
        public String getItemType() {
            return getClass().getName();
        }
 
        @Override
        @NbBundle.Messages({
            "Accounts.FileWithCCNNode.nameProperty.displayName=File",
            "Accounts.FileWithCCNNode.accountsProperty.displayName=Accounts",
            "Accounts.FileWithCCNNode.statusProperty.displayName=Status",
            "Accounts.FileWithCCNNode.noDescription=no description"})
        protected Sheet createSheet() {
            Sheet sheet = super.createSheet();
            Sheet.Set propSet = sheet.get(Sheet.PROPERTIES);
            if (propSet == null) {
                propSet = Sheet.createPropertiesSet();
                sheet.put(propSet);
            }
 
            propSet.put(new NodeProperty<>(Bundle.Accounts_FileWithCCNNode_nameProperty_displayName(),
                    Bundle.Accounts_FileWithCCNNode_nameProperty_displayName(),
                    Bundle.Accounts_FileWithCCNNode_noDescription(),
                    fileName));
            propSet.put(new NodeProperty<>(Bundle.Accounts_FileWithCCNNode_accountsProperty_displayName(),
                    Bundle.Accounts_FileWithCCNNode_accountsProperty_displayName(),
                    Bundle.Accounts_FileWithCCNNode_noDescription(),
                    fileKey.getHits()));
            propSet.put(new NodeProperty<>(Bundle.Accounts_FileWithCCNNode_statusProperty_displayName(),
                    Bundle.Accounts_FileWithCCNNode_statusProperty_displayName(),
                    Bundle.Accounts_FileWithCCNNode_noDescription(),
                    fileKey.getStatuses().stream()
                            .map(BlackboardArtifact.ReviewStatus::getDisplayName)
                            .collect(Collectors.joining(", ")))); //NON-NLS
 
            return sheet;
        }
 
        @Override
        public Action[] getActions(boolean context) {
            Action[] actions = super.getActions(context);
            ArrayList<Action> arrayList = new ArrayList<>();
            try {
                arrayList.addAll(DataModelActionsFactory.getActions(Case.getCurrentCaseThrows().getSleuthkitCase().getContentById(fileKey.getObjID()), false));
            } catch (TskCoreException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error gettung content by id", ex);
            }
 
            arrayList.add(approveActionInstance);
            arrayList.add(rejectActionInstance);
            arrayList.add(null);
            arrayList.addAll(Arrays.asList(actions));
            return arrayList.toArray(new Action[arrayList.size()]);
        }
    }
 
    final private class CreditCardNumberFactory extends ObservingChildren<DataArtifact> {
 
        private final BinResult bin;
 
        private CreditCardNumberFactory(BinResult bin) {
            this.bin = bin;
        }
 
        @Subscribe
        @Override
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            refresh(true);
        }
 
        @Subscribe
        @Override
        void handleDataAdded(ModuleDataEvent event) {
            refresh(true);
        }
 
        @Override
        protected boolean createKeys(List<DataArtifact> list) {
 
            String query
                    = "SELECT blackboard_artifacts.artifact_obj_id " //NON-NLS
                    + " FROM blackboard_artifacts " //NON-NLS
                    + "      JOIN blackboard_attributes ON blackboard_artifacts.artifact_id = blackboard_attributes.artifact_id " //NON-NLS
                    + " WHERE blackboard_artifacts.artifact_type_id = " + BlackboardArtifact.Type.TSK_ACCOUNT.getTypeID() //NON-NLS
                    + "     AND blackboard_attributes.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_CARD_NUMBER.getTypeID() //NON-NLS
                    + "     AND blackboard_attributes.value_text >= '" + bin.getBINStart() + "' AND  blackboard_attributes.value_text < '" + (bin.getBINEnd() + 1) + "'" //NON-NLS
                    + getFilterByDataSourceClause()
                    + getRejectedArtifactFilterClause()
                    + " ORDER BY blackboard_attributes.value_text"; //NON-NLS
            try (SleuthkitCase.CaseDbQuery results = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(query);
                    ResultSet rs = results.getResultSet();) {
                while (rs.next()) {
                    list.add(Case.getCurrentCaseThrows().getSleuthkitCase().getBlackboard().getDataArtifactById(rs.getLong("artifact_obj_id"))); //NON-NLS
                }
            } catch (TskCoreException | SQLException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error querying for account artifacts.", ex); //NON-NLS
 
            }
            return true;
        }
 
        @Override
        protected Node[] createNodesForKey(DataArtifact artifact) {
            return new Node[]{new AccountArtifactNode(artifact)};
        }
    }
 
    private String getBinRangeString(BinResult bin) {
        if (bin.getBINStart() == bin.getBINEnd()) {
            return Integer.toString(bin.getBINStart());
        } else {
            return bin.getBINStart() + "-" + StringUtils.difference(bin.getBINStart() + "", bin.getBINEnd() + "");
        }
    }
 
    final public class BINNode extends DisplayableItemNode {

        private final BinResult bin;
 
        private BINNode(BinResult bin) {
            super(Children.create(new CreditCardNumberFactory(bin), true), Lookups.singleton(getBinRangeString(bin)));
            this.bin = bin;
            setName(getBinRangeString(bin));
            updateDisplayName();
            this.setIconBaseWithExtension("org/sleuthkit/autopsy/images/bank.png");   //NON-NLS
            reviewStatusBus.register(this);
        }
 
        @Subscribe
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
            updateDisplayName();
            updateSheet();
        }
 
        @Subscribe
        void handleDataAdded(ModuleDataEvent event) {
            updateDisplayName();
        }
 
        private void updateDisplayName() {
            String query
                    = "SELECT count(blackboard_artifacts.artifact_id ) AS count" //NON-NLS
                    + " FROM blackboard_artifacts " //NON-NLS
                    + "      JOIN blackboard_attributes ON blackboard_artifacts.artifact_id = blackboard_attributes.artifact_id " //NON-NLS
                    + " WHERE blackboard_artifacts.artifact_type_id = " + BlackboardArtifact.Type.TSK_ACCOUNT.getTypeID() //NON-NLS
                    + "     AND blackboard_attributes.attribute_type_id = " + BlackboardAttribute.ATTRIBUTE_TYPE.TSK_CARD_NUMBER.getTypeID() //NON-NLS
                    + "     AND blackboard_attributes.value_text >= '" + bin.getBINStart() + "' AND  blackboard_attributes.value_text < '" + (bin.getBINEnd() + 1) + "'" //NON-NLS
                    + getFilterByDataSourceClause()
                    + getRejectedArtifactFilterClause();
            try (SleuthkitCase.CaseDbQuery results = Case.getCurrentCaseThrows().getSleuthkitCase().executeQuery(query);
                    ResultSet resultSet = results.getResultSet();) {
                while (resultSet.next()) {
                    setDisplayName(getBinRangeString(bin) + " (" + resultSet.getLong("count") + ")"); //NON-NLS
                }
            } catch (TskCoreException | SQLException | NoCurrentCaseException ex) {
                LOGGER.log(Level.SEVERE, "Error querying for account artifacts.", ex); //NON-NLS
 
            }
 
        }
 
        @Override
        public boolean isLeafTypeNode() {
            return true;
        }
 
        @Override
        public <T> T accept(DisplayableItemNodeVisitor<T> visitor) {
            return visitor.visit(this);
        }
 
        @Override
        public String getItemType() {
            return getClass().getName();
        }
 
        private Sheet.Set getPropertySet(Sheet sheet) {
            Sheet.Set sheetSet = sheet.get(Sheet.PROPERTIES);
            if (sheetSet == null) {
                sheetSet = Sheet.createPropertiesSet();
                sheet.put(sheetSet);
            }
            return sheetSet;
        }
 
        @Override
        @NbBundle.Messages({
            "Accounts.BINNode.binProperty.displayName=Bank Identifier Number",
            "Accounts.BINNode.accountsProperty.displayName=Accounts",
            "Accounts.BINNode.cardTypeProperty.displayName=Payment Card Type",
            "Accounts.BINNode.schemeProperty.displayName=Credit Card Scheme",
            "Accounts.BINNode.brandProperty.displayName=Brand",
            "Accounts.BINNode.bankProperty.displayName=Bank",
            "Accounts.BINNode.bankCityProperty.displayName=Bank City",
            "Accounts.BINNode.bankCountryProperty.displayName=Bank Country",
            "Accounts.BINNode.bankPhoneProperty.displayName=Bank Phone #",
            "Accounts.BINNode.bankURLProperty.displayName=Bank URL",
            "Accounts.BINNode.noDescription=no description"})
        protected Sheet createSheet() {
            Sheet sheet = super.createSheet();
            Sheet.Set properties = getPropertySet(sheet);
 
            properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_binProperty_displayName(),
                    Bundle.Accounts_BINNode_binProperty_displayName(),
                    Bundle.Accounts_BINNode_noDescription(),
                    getBinRangeString(bin)));
            properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_accountsProperty_displayName(),
                    Bundle.Accounts_BINNode_accountsProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                    bin.getCount()));
 
            //add optional properties if they are available
            if (bin.hasDetails()) {
                bin.getCardType().ifPresent(cardType -> properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_cardTypeProperty_displayName(),
                        Bundle.Accounts_BINNode_cardTypeProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                        cardType)));
                bin.getScheme().ifPresent(scheme -> properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_schemeProperty_displayName(),
                        Bundle.Accounts_BINNode_schemeProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                        scheme)));
                bin.getBrand().ifPresent(brand -> properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_brandProperty_displayName(),
                        Bundle.Accounts_BINNode_brandProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                        brand)));
                bin.getBankName().ifPresent(bankName -> properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_bankProperty_displayName(),
                        Bundle.Accounts_BINNode_bankProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                        bankName)));
                bin.getBankCity().ifPresent(bankCity -> properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_bankCityProperty_displayName(),
                        Bundle.Accounts_BINNode_bankCityProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                        bankCity)));
                bin.getCountry().ifPresent(country -> properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_bankCountryProperty_displayName(),
                        Bundle.Accounts_BINNode_bankCountryProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                        country)));
                bin.getBankPhoneNumber().ifPresent(phoneNumber -> properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_bankPhoneProperty_displayName(),
                        Bundle.Accounts_BINNode_bankPhoneProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                        phoneNumber)));
                bin.getBankURL().ifPresent(url -> properties.put(new NodeProperty<>(Bundle.Accounts_BINNode_bankURLProperty_displayName(),
                        Bundle.Accounts_BINNode_bankURLProperty_displayName(), Bundle.Accounts_BINNode_noDescription(),
                        url)));
            }
            return sheet;
        }
 
        private void updateSheet() {
            SwingUtilities.invokeLater(() -> {
                this.setSheet(createSheet());
            });
        }
 
    }

    @Immutable
    final static private class BinResult implements CreditCards.BankIdentificationNumber {
 
        @Override
        public int hashCode() {
            int hash = 3;
            hash = 97 * hash + this.binEnd;
            hash = 97 * hash + this.binStart;
            return hash;
        }
 
        @Override
        public boolean equals(Object obj) {
            if (this == obj) {
                return true;
            }
            if (obj == null) {
                return false;
            }
            if (getClass() != obj.getClass()) {
                return false;
            }
            final BinResult other = (BinResult) obj;
            if (this.binEnd != other.binEnd) {
                return false;
            }
            if (this.binStart != other.binStart) {
                return false;
            }
            return true;
        }

        private final long count;
 
        private final BINRange binRange;
        private final int binEnd;
        private final int binStart;
 
        private BinResult(long count, @Nonnull BINRange binRange) {
            this.count = count;
            this.binRange = binRange;
            binStart = binRange.getBINstart();
            binEnd = binRange.getBINend();
        }
 
        private BinResult(long count, int start, int end) {
            this.count = count;
            this.binRange = null;
            binStart = start;
            binEnd = end;
        }
 
        int getBINStart() {
            return binStart;
        }
 
        int getBINEnd() {
            return binEnd;
        }
 
        long getCount() {
            return count;
        }
 
        boolean hasDetails() {
            return binRange != null;
        }
 
        @Override
        public Optional<Integer> getNumberLength() {
            return binRange.getNumberLength();
        }
 
        @Override
        public Optional<String> getBankCity() {
            return binRange.getBankCity();
        }
 
        @Override
        public Optional<String> getBankName() {
            return binRange.getBankName();
        }
 
        @Override
        public Optional<String> getBankPhoneNumber() {
            return binRange.getBankPhoneNumber();
        }
 
        @Override
        public Optional<String> getBankURL() {
            return binRange.getBankURL();
        }
 
        @Override
        public Optional<String> getBrand() {
            return binRange.getBrand();
        }
 
        @Override
        public Optional<String> getCardType() {
            return binRange.getCardType();
        }
 
        @Override
        public Optional<String> getCountry() {
            return binRange.getCountry();
        }
 
        @Override
        public Optional<String> getScheme() {
            return binRange.getScheme();
        }
    }
 
    final private class AccountArtifactNode extends BlackboardArtifactNode {
 
        private final BlackboardArtifact artifact;
 
        private AccountArtifactNode(BlackboardArtifact artifact) {
            super(artifact, "org/sleuthkit/autopsy/images/credit-card.png");   //NON-NLS
            this.artifact = artifact;
            setName(Long.toString(this.artifact.getArtifactID()));
 
            reviewStatusBus.register(this);
        }
 
        @Override
        public Action[] getActions(boolean context) {
            List<Action> actionsList = new ArrayList<>();
            actionsList.addAll(Arrays.asList(super.getActions(context)));
 
            actionsList.add(approveActionInstance);
            actionsList.add(rejectActionInstance);
 
            return actionsList.toArray(new Action[actionsList.size()]);
        }
 
        @Override
        protected Sheet createSheet() {
            Sheet sheet = super.createSheet();
            Sheet.Set properties = sheet.get(Sheet.PROPERTIES);
            if (properties == null) {
                properties = Sheet.createPropertiesSet();
                sheet.put(properties);
            }
            properties.put(new NodeProperty<>(Bundle.Accounts_FileWithCCNNode_statusProperty_displayName(),
                    Bundle.Accounts_FileWithCCNNode_statusProperty_displayName(),
                    Bundle.Accounts_FileWithCCNNode_noDescription(),
                    artifact.getReviewStatus().getDisplayName()));
 
            return sheet;
        }
 
        @Subscribe
        void handleReviewStatusChange(ReviewStatusChangeEvent event) {
 
            // Update the node if event includes this artifact
            event.artifacts.stream().filter((art) -> (art.getArtifactID() == this.artifact.getArtifactID())).map((_item) -> {
                return _item;
            }).forEachOrdered((_item) -> {
                updateSheet();
            });
        }
 
        private void updateSheet() {
            SwingUtilities.invokeLater(() -> {
                this.setSheet(createSheet());
            });
        }
 
    }
 
    @Deprecated
    private final class ToggleShowRejected extends AbstractAction {
 
        @NbBundle.Messages("ToggleShowRejected.name=Show Rejected Results")
        ToggleShowRejected() {
            super(Bundle.ToggleShowRejected_name());
        }
 
        @Override
        public void actionPerformed(ActionEvent e) {
            showRejected = !showRejected;
            reviewStatusBus.post(new ReviewStatusChangeEvent(Collections.emptySet(), null));
        }
    }

    public void setShowRejected(boolean showRejected) {
        this.showRejected = showRejected;
        reviewStatusBus.post(new ReviewStatusChangeEvent(Collections.emptySet(), null));
    }
 
    private abstract class ReviewStatusAction extends AbstractAction {
 
        private final BlackboardArtifact.ReviewStatus newStatus;
 
        private ReviewStatusAction(String displayName, BlackboardArtifact.ReviewStatus newStatus) {
            super(displayName);
            this.newStatus = newStatus;
 
        }
 
        @Override
        public void actionPerformed(ActionEvent e) {
 
            /*
             * get paths for selected nodes to reselect after applying review
             * status change
             */
            List<String[]> selectedPaths = Utilities.actionsGlobalContext().lookupAll(Node.class).stream()
                    .map(node -> {
                        String[] createPath;
                        /*
                         * If the we are rejecting and not showing rejected
                         * results, then the selected node, won't exist any
                         * more, so we select the previous one in stead.
                         */
                        if (newStatus == BlackboardArtifact.ReviewStatus.REJECTED && showRejected == false) {
                            List<Node> siblings = Arrays.asList(node.getParentNode().getChildren().getNodes());
                            if (siblings.size() > 1) {
                                int indexOf = siblings.indexOf(node);
                                //there is no previous for the first node, so instead we select the next one
                                Node sibling = indexOf > 0
                                        ? siblings.get(indexOf - 1)
                                        : siblings.get(Integer.max(indexOf + 1, siblings.size() - 1));
                                createPath = NodeOp.createPath(sibling, null);
                            } else {
                                /*
                                 * if there are no other siblings to select,
                                 * just return null, but note we need to filter
                                 * this out of stream below
                                 */
                                return null;
                            }
                        } else {
                            createPath = NodeOp.createPath(node, null);
                        }
                        //for the reselect to work we need to strip off the first part of the path.
                        return Arrays.copyOfRange(createPath, 1, createPath.length);
                    })
                    .filter(Objects::nonNull)
                    .collect(Collectors.toList());
 
            //change status of selected artifacts
            final Collection<? extends BlackboardArtifact> artifacts = Utilities.actionsGlobalContext().lookupAll(BlackboardArtifact.class);
            artifacts.forEach(artifact -> {
                try {
                    artifact.setReviewStatus(newStatus);
                } catch (TskCoreException ex) {
                    LOGGER.log(Level.SEVERE, "Error changing artifact review status.", ex); //NON-NLS
                }
            });
            //post event
            reviewStatusBus.post(new ReviewStatusChangeEvent(artifacts, newStatus));
 
            final DataResultTopComponent directoryListing = DirectoryTreeTopComponent.findInstance().getDirectoryListing();
            final Node rootNode = directoryListing.getRootNode();
 
            //convert paths back to nodes
            List<Node> toArray = new ArrayList<>();
            selectedPaths.forEach(path -> {
                try {
                    toArray.add(NodeOp.findPath(rootNode, path));
                } catch (NodeNotFoundException ex) { //NOPMD empty catch clause
                    //just ingnore paths taht don't exist.  this is expected since we are rejecting
                }
            });
            //select nodes
            directoryListing.setSelectedNodes(toArray.toArray(new Node[toArray.size()]));
        }
    }
 
    final private class ApproveAccounts extends ReviewStatusAction {
 
        @NbBundle.Messages({"ApproveAccountsAction.name=Approve Accounts"})
        private ApproveAccounts() {
            super(Bundle.ApproveAccountsAction_name(), BlackboardArtifact.ReviewStatus.APPROVED);
        }
    }
 
    final private class RejectAccounts extends ReviewStatusAction {
 
        @NbBundle.Messages({"RejectAccountsAction.name=Reject Accounts"})
        private RejectAccounts() {
            super(Bundle.RejectAccountsAction_name(), BlackboardArtifact.ReviewStatus.REJECTED);
        }
    }
 
    static private class ReviewStatusChangeEvent {
 
        Collection<? extends BlackboardArtifact> artifacts;
        BlackboardArtifact.ReviewStatus newReviewStatus;
 
        ReviewStatusChangeEvent(Collection<? extends BlackboardArtifact> artifacts, BlackboardArtifact.ReviewStatus newReviewStatus) {
            this.artifacts = artifacts;
            this.newReviewStatus = newReviewStatus;
        }
    }

    public static String getIconFilePath(Account.Type type) {
 
        if (type.equals(Account.Type.CREDIT_CARD)) {
            return ICON_BASE_PATH + "credit-card.png";
        } else if (type.equals(Account.Type.DEVICE)) {
            return ICON_BASE_PATH + "image.png";
        } else if (type.equals(Account.Type.EMAIL)) {
            return ICON_BASE_PATH + "email.png";
        } else if (type.equals(Account.Type.FACEBOOK)) {
            return ICON_BASE_PATH + "facebook.png";
        } else if (type.equals(Account.Type.INSTAGRAM)) {
            return ICON_BASE_PATH + "instagram.png";
        } else if (type.equals(Account.Type.MESSAGING_APP)) {
            return ICON_BASE_PATH + "messaging.png";
        } else if (type.equals(Account.Type.PHONE)) {
            return ICON_BASE_PATH + "phone.png";
        } else if (type.equals(Account.Type.TWITTER)) {
            return ICON_BASE_PATH + "twitter.png";
        } else if (type.equals(Account.Type.WEBSITE)) {
            return ICON_BASE_PATH + "web-file.png";
        } else if (type.equals(Account.Type.WHATSAPP)) {
            return ICON_BASE_PATH + "WhatsApp.png";
        } else {
            //there could be a default icon instead...
            return ICON_BASE_PATH + "face.png";
//            throw new IllegalArgumentException("Unknown Account.Type: " + type.getTypeName());
        }
    }
}