package com.ld.igds.view.service;

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

import com.ld.igds.models.*;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang.StringUtils;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.bstek.bdf2.core.orm.hibernate.HibernateDao;
import com.ld.igds.common.CoreCommonService;
import com.ld.igds.util.ContextUtil;

/**
 * @author kyle.zhao:
 * @version 创建时间：2018年1月29日 类说明
 */
@Slf4j
@Component
public class HDepotService extends HibernateDao {

    @Autowired
    private CoreCommonService coreCommonService;

    public List<Depot> getData(Map<String, Object> param) {

        if (null == param) {
            param = new HashMap<>();
        }

        if (null == param.get("companyId")) {
            param.put("companyId", ContextUtil.getDefaultCompanyId());
        }

        StringBuilder hql = new StringBuilder();
        hql.append(" from " + Depot.class.getName()
                + " where companyId = :companyId ");

        Map<String, Object> args = new HashMap<>();
        args.put("companyId", param.get("companyId"));

        if (null != param) {
            buildHql(hql, param, args);
        }

        hql.append(" order by id + 0 ");

        return this.query(hql.toString(), args);

    }

    private void buildHql(StringBuilder hql, Map<String, Object> param,
                          Map<String, Object> args) {
        Object obj = param.get("type");
        if (null != obj) {
            hql.append(" and depotType=:type ");
            args.put("type", obj);
        }
        obj = param.get("deptId");
        if (null != obj) {
            hql.append(" and deptId=:deptId ");
            args.put("deptId", obj);
        }
        obj = param.get("depotType");
        if (null != obj) {
            hql.append(" and depotType=:depotType ");
            args.put("depotType", obj);
        }
        String arg = (String) param.get("depotId");
        if (StringUtils.isNotEmpty(arg)) {
            hql.append(" and depotId=:depotId ");
            args.put("depotId", arg);
        }
    }

    public List<Depot> getAllCache(String name, String companyId) {
        if (null == companyId) companyId = ContextUtil.getCompanyId();

        String deptId = ContextUtil.subDeptId(null);

        List<Depot> list = coreCommonService.getCacheDepotList(companyId, deptId);

        return list;
    }

    public void flushCache(String companyId) {
        if (StringUtils.isEmpty(companyId)) {
            companyId = ContextUtil.getCompanyId();
        }
        List<Depot> list;
        try {
            Map<String, Object> args = new HashMap<>();
            args.put("companyId", companyId);
            list = this.getData(args);


            coreCommonService.setCacheDepot(list, companyId);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 添加仓库信息
     *
     * @throws Exception
     */
    public void saveDepot(Depot depot) throws Exception {
        depot.setCompanyId(ContextUtil.getCompanyId());
        if (org.apache.commons.lang3.StringUtils.isEmpty(depot.getId())) {
            Depot lastDepot = this.findLastDepot(depot.getDeptId());
            String id;
            if (lastDepot != null) {
                id = ContextUtil.getNextDepotId(depot.getDeptId(), lastDepot.getId(), 1000);
            } else {
                id = ContextUtil.getNextDepotId(depot.getDeptId(), null, 1000);
            }
            depot.setId(id);
        }
        Session session = this.getSessionFactory().openSession();
        try {
            flushCache(depot.getCompanyId());
            session.save(depot);
        } finally {
            session.flush();
            session.close();
        }
    }

    private Depot findLastDepot(String deptId) throws Exception {

        Map<String, Object> param = new HashMap<>();
        param.put("deptId", deptId);
        List<Depot> list = this.getData(param);
        if (list != null && list.size() > 0) {
            return list.get(list.size() - 1);
        } else {
            return null;
        }
    }

    /**
     * 修改仓库信息
     *
     * @throws Exception
     */
    public void updateDepot(Depot depot) throws Exception {
        Session session = this.getSessionFactory().openSession();
        try {
            flushCache(depot.getCompanyId());
            session.update(depot);
        } finally {
            session.flush();
            session.close();
        }
    }

    /**
     * 删除仓库信息
     */
    public void deleteDepot(Depot depot) {
        Session session = this.getSessionFactory().openSession();
        try {
            session.delete(depot);
        } finally {
            session.flush();
            session.close();
        }
    }

    public List<DepotConf> getConfList(String companyId) {
        if (StringUtils.isEmpty(companyId))
            companyId = ContextUtil.getCompanyId();

        String hql = " from " + DepotConf.class.getName()
                + " where companyId=:companyId order by depotId + 0 ";

        Map<String, Object> args = new HashMap<String, Object>();
        args.put("companyId", companyId);

        List<DepotConf> list = this.query(hql, args);

        if (null == list || list.isEmpty()) {
            log.info("当前仓库配置数据为空，系统自动生成基础数据");
            this.addConfByDepot(companyId);
            list = this.query(hql, args);
        }

        return list;
    }

    private void addConfByDepot(String companyId) {
        try {
            Map<String, Object> args = new HashMap<>();
            args.put("companyId", companyId);

            List<Depot> list = this.getData(args);

            if (null == list || list.isEmpty()) return;

            DepotConf conf;
            for (Depot depot : list) {
                conf = new DepotConf();
                conf.setDepotId(depot.getId());
                conf.setCompanyId(depot.getCompanyId());
                this.saveConf(conf);
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void saveConf(DepotConf conf) {
        Session session = this.getSessionFactory().openSession();
        try {
            if (StringUtils.isEmpty(conf.getCompanyId())) {
                conf.setCompanyId(ContextUtil.getCompanyId());
            }
            session.saveOrUpdate(conf);
        } finally {
            session.flush();
            session.close();
        }
    }

    public String deleteDepotConf(DepotConf conf) {
        if (null == conf.getCompanyId())
            return null;

        Session session = this.getSessionFactory().openSession();
        try {
            session.delete(conf);
        } finally {
            session.flush();
            session.close();
        }

        flushConfCache(conf.getCompanyId());
        return null;
    }

    public void flushConfCache(String companyId) {
        if (StringUtils.isEmpty(companyId)) {
            companyId = ContextUtil.getCompanyId();
        }

        List<DepotConf> list = getConfList(companyId);

        coreCommonService.setCacheDepotConf(list, companyId);
    }


    public void updateFreq(String freq) {
        String sql = "UPDATE D_DEPOT_CONF SET GRAIN_FREQ_ =:freq WHERE COMPANY_ID_ =:companyId";

        Session session = this.getSessionFactory().openSession();
        String companyId = ContextUtil.getCompanyId();
        try {
            SQLQuery query = session.createSQLQuery(sql);
            query.setString("freq", freq);
            query.setString("companyId", companyId);
            query.executeUpdate();

            flushConfCache(companyId);
        } finally {
            session.flush();
            session.close();
        }
    }

    public Depot getDepotById(String companyId, String depotId) {
        return coreCommonService.getDepotById(companyId, depotId);
    }

    public List<Depot> getDepotByTimer(List<TimingDepot> list) {
        if (null == list || list.isEmpty())
            return null;
        String hql = "from " + Depot.class.getName()
                + " where companyId=:companyId and id in(:ids)";
        Map<String, Object> param = new HashMap<String, Object>();
        param.put("companyId", list.get(0).getCompanyId());
        List<String> ids = new ArrayList<>();
        for (TimingDepot tim : list) {
            ids.add(tim.getDepotId());
        }
        param.put("ids", ids);

        return this.query(hql, param);
    }

    public void initUserDeptMap(String companyId) {
        List<Depot> list = coreCommonService.getCacheDepotList(companyId);
        if (null == list || list.isEmpty()) return;
        for (Depot depot : list) {
            ContextUtil.updateSubDept(depot.getId(), depot.getDeptId());
        }
    }
}