/*
*    Copyright [2011] [wisemapping]
*
*   Licensed under WiseMapping Public License, Version 1.0 (the "License").
*   It is basically the Apache License, Version 2.0 (the "License") plus the
*   "powered by wisemapping" text requirement on every single page;
*   you may not use this file except in compliance with the License.
*   You may obtain a copy of the license at
*
*       http://www.wisemapping.org/license
*
*   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 com.wisemapping.dao;

import com.wisemapping.model.*;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.hibernate.criterion.Restrictions;
import org.hibernate.criterion.SimpleExpression;
import org.hibernate.criterion.Junction;
import org.hibernate.criterion.Order;
import org.hibernate.Criteria;

import java.util.List;
import java.util.Calendar;

public class MindmapManagerImpl
        extends HibernateDaoSupport
        implements MindmapManager {

    public Colaborator getColaboratorBy(final String email) {
        final Colaborator colaborator;
        final List colaborators = getHibernateTemplate().find("from com.wisemapping.model.Colaborator colaborator where email=?", email);
        if (colaborators != null && !colaborators.isEmpty()) {
            assert colaborators.size() == 1 : "More than one user with the same username!";
            colaborator = (Colaborator) colaborators.get(0);
        } else {
            colaborator = null;
        }
        return colaborator;
    }

    public List<MindMap> search(MindMapCriteria criteria) {
        return search(criteria,-1);
    }

    public List<MindMapHistory> getHistoryFrom(int mindmapId)
    {        
        final Criteria hibernateCriteria = getSession().createCriteria(MindMapHistory.class);
        hibernateCriteria.add(Restrictions.eq("mindmapId",mindmapId));
        hibernateCriteria.addOrder( Order.desc("creationTime"));
        // Mientras no haya paginacion solo los 10 primeros
        // This line throws errors in some environments, so getting all history and taking firsts 10 records
        // hibernateCriteria.setMaxResults(10);
        List list = hibernateCriteria.list();
        return list.subList(0,(10<list.size()?10:list.size()));
    }

    public MindMapHistory getHistory(int historyId)
    {
       return (MindMapHistory) getHibernateTemplate().get(MindMapHistory.class, historyId);
    }

    public List<MindMap> search(MindMapCriteria criteria, int maxResult) {
        final Criteria hibernateCriteria = getSession().createCriteria(MindMap.class);
        //always search public maps
        hibernateCriteria.add(Restrictions.like("public", Boolean.TRUE));

        if (criteria != null) {
            final Junction junction;
            if (criteria.isOrCriteria()) {
                junction = Restrictions.disjunction();
            } else {
                junction = Restrictions.conjunction();
            }

            if (criteria.getTitle() != null && criteria.getTitle().length() > 0) {
                final SimpleExpression titleRestriction = Restrictions.like("title", "%" + criteria.getTitle() + "%");
                junction.add(titleRestriction);
            }

            if (criteria.getDescription() != null && criteria.getDescription().length() > 0) {
                final SimpleExpression descriptionRestriction = Restrictions.like("description", "%" + criteria.getDescription() + "%");
                junction.add(descriptionRestriction);
            }
            if (criteria.getTags().size() > 0) {
                for (String tag : criteria.getTags()) {
                    final SimpleExpression tagRestriction = Restrictions.like("tags", "%" + tag + "%");
                    junction.add(tagRestriction);
                }
            }

            hibernateCriteria.add(junction);
        }
//        if (maxResult>0)
//        {
//            hibernateCriteria.setMaxResults(maxResult);
//        }
        return hibernateCriteria.list();
    }

    public Colaborator getColaboratorBy(long id) {
        return (Colaborator) getHibernateTemplate().get(Colaborator.class, id);
    }

    public List<MindmapUser> getMindmapUserByColaborator(final long colaboratorId) {
        return getHibernateTemplate().find("from com.wisemapping.model.MindmapUser mindmapUser where colaborator_id=?", colaboratorId);
    }

    public List<MindmapUser> getMindmapUserByRole(final UserRole userRole) {
        return getHibernateTemplate().find("from com.wisemapping.model.MindmapUser mindmapUser where roleId=?", userRole.ordinal());
    }

    public MindmapUser getMindmapUserBy(final int mindmapId, final User user) {
        final MindmapUser result;

        final List<MindmapUser> mindMaps = getHibernateTemplate().find("from com.wisemapping.model.MindmapUser mindmapUser where mindMap.id=? and colaborator_id=?", new Object[]{mindmapId, user.getId()});
        if (mindMaps != null && !mindMaps.isEmpty()) {
            result = mindMaps.get(0);
        } else {
            result = null;
        }

        return result;
    }

    public void addColaborator(Colaborator colaborator) {
        assert colaborator != null : "ADD MINDMAP COLABORATOR: Colaborator is required!";
        getHibernateTemplate().save(colaborator);
    }

    public void removeMindmapUser(MindmapUser mindmapUser) {
        getHibernateTemplate().delete(mindmapUser);
    }

    public void removeColaborator(Colaborator colaborator) {
        getHibernateTemplate().delete(colaborator);
    }

    public List<MindMap> getAllMindmaps() {
        return getHibernateTemplate().find("from com.wisemapping.model.MindMap wisemapping");
    }

    public MindMap getMindmapById(int mindmapId) {
        return (MindMap) getHibernateTemplate().get(MindMap.class, mindmapId);
    }

    public MindMap getMindmapByTitle(final String title, final User user) {
        final MindMap result;
        List<MindMap> mindMaps = getHibernateTemplate().find("from com.wisemapping.model.MindMap wisemapping where title=? and creator=?", new Object[]{title, user.getUsername()});
        if (mindMaps != null && !mindMaps.isEmpty()) {
            result = mindMaps.get(0);
        } else {
            result = null;
        }
        return result;
    }

    public void addView(int mapId)
    {
        
    }

    public void addMindmap(User user, MindMap mindMap) {
        saveMindmap(mindMap);
    }

    public void saveMindmap(MindMap mindMap) {
        assert mindMap != null : "Save Mindmap: Mindmap is required!";
        getSession().saveOrUpdate(mindMap.getNativeBrowser());
        getSession().save(mindMap);
    }

    public void updateMindmap(MindMap mindMap, boolean saveHistory) {
        assert mindMap != null : "Save Mindmap: Mindmap is required!";
        getHibernateTemplate().saveOrUpdate(mindMap.getNativeBrowser());
        getHibernateTemplate().saveOrUpdate(mindMap);
        if (saveHistory)
        {
            saveHistory(mindMap);
        }
    }

    public void removeMindmap(MindMap mindMap) {
        getHibernateTemplate().delete(mindMap);
    }

    public void saveHistory(MindMap mindMap)
    {
        final MindMapHistory history = new MindMapHistory();

        history.setXml(mindMap.getXml());
        history.setCreationTime(Calendar.getInstance());
        history.setCreator(mindMap.getLastModifierUser());
        history.setMindmapId(mindMap.getId());
        getHibernateTemplate().saveOrUpdate(history);
    }
}

