/*
 *  Copyright (C) 2010-2012 Stichting Akvo (Akvo Foundation)
 *
 *  This file is part of Akvo FLOW.
 *
 *  Akvo FLOW is free software: you can redistribute it and modify it under the terms of
 *  the GNU Affero General Public License (AGPL) as published by the Free Software Foundation,
 *  either version 3 of the License or any later version.
 *
 *  Akvo FLOW 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 included below for more details.
 *
 *  The full license text can also be seen at <http://www.gnu.org/licenses/agpl.html>.
 */

package com.gallatinsystems.notification.dao;

import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.jdo.PersistenceManager;

import com.gallatinsystems.framework.dao.BaseDAO;
import com.gallatinsystems.framework.servlet.PersistenceFilter;
import com.gallatinsystems.notification.domain.NotificationHistory;
import com.gallatinsystems.notification.domain.NotificationSubscription;

/**
 * saves and finds NotificationSubscriptions from the datastore
 * 
 * @author Christopher Fagiani
 */
public class NotificationSubscriptionDao extends
        BaseDAO<NotificationSubscription> {

    public NotificationSubscriptionDao() {
        super(NotificationSubscription.class);
    }

    /**
     * lists all unexpired notifications (where expiryDate <= sysdate) and
     * NotificationSubscriptionType == type
     * 
     * @return
     */
    public List<NotificationSubscription> listUnexpiredNotifications(String type) {
        return listSubscriptions(null, type, true);
    }

    /**
     * lists all subscriptions
     * 
     * @param entityId
     * @param type
     * @return
     */
    @SuppressWarnings("unchecked")
    public List<NotificationSubscription> listSubscriptions(Long entityId,
            String type, boolean unexpiredOnly) {
        PersistenceManager pm = PersistenceFilter.getManager();
        javax.jdo.Query query = pm.newQuery(NotificationSubscription.class);
        Map<String, Object> paramMap = null;

        StringBuilder filterString = new StringBuilder();
        StringBuilder paramString = new StringBuilder();
        paramMap = new HashMap<String, Object>();

        appendNonNullParam("notificationType", filterString, paramString,
                "String", type, paramMap);
        appendNonNullParam("entityId", filterString, paramString, "Long",
                entityId, paramMap);
        if (unexpiredOnly) {
            appendNonNullParam("expiryDate", filterString, paramString, "Date",
                    new Date(), paramMap, GTE_OP);
            query.declareImports("import java.util.Date");
        }

        query.setFilter(filterString.toString());
        query.declareParameters(paramString.toString());

        return (List<NotificationSubscription>) query.executeWithMap(paramMap);
    }

    /**
     * finds the notification history record (if it exists) for this type/entity combination
     * 
     * @param type
     * @param entityId
     * @return
     */
    @SuppressWarnings("unchecked")
    public NotificationHistory findNotificationHistory(String type,
            Long entityId) {
        PersistenceManager pm = PersistenceFilter.getManager();
        javax.jdo.Query query = pm.newQuery(NotificationHistory.class);
        Map<String, Object> paramMap = null;

        StringBuilder filterString = new StringBuilder();
        StringBuilder paramString = new StringBuilder();
        paramMap = new HashMap<String, Object>();

        appendNonNullParam("type", filterString, paramString, "String", type,
                paramMap);
        appendNonNullParam("entityId", filterString, paramString, "Long",
                entityId, paramMap);

        query.setFilter(filterString.toString());
        query.declareParameters(paramString.toString());

        List<NotificationHistory> results = (List<NotificationHistory>) query
                .executeWithMap(paramMap);
        if (results != null && results.size() > 0) {
            return results.get(0);
        } else {
            return null;
        }
    }

    /**
     * saves the notification history object passed in, incrementing the count and updating the date
     * before saving.
     * 
     * @param h
     * @return
     */
    public static synchronized NotificationHistory saveNotificationHistory(
            NotificationHistory h) {
        if (h != null) {
            if (h.getCount() == null) {
                h.setCount(1L);
            } else {
                h.setCount(h.getCount() + 1);
            }
            h.setLastNotification(new Date());
            NotificationSubscriptionDao dao = new NotificationSubscriptionDao();
            h = dao.save(h);
        }
        return h;
    }

}