package com.ld.igds.inout.service;

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

import com.ld.igds.constant.Constant;
import com.ld.igds.inout.InoutConstant;
import com.ld.igds.inout.dto.InoutParam;
import com.ld.igds.models.InoutRecord;

import org.apache.commons.lang3.StringUtils;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.stereotype.Component;

import com.bstek.bdf2.core.orm.hibernate.HibernateDao;
import com.bstek.dorado.data.provider.Page;
import com.ld.igds.models.InoutSettle;
import com.ld.igds.util.ContextUtil;
import com.ld.igds.util.DateUtil;

@Component
public class HInoutSettleService extends HibernateDao {


    public void pageIoutRecord(Page<InoutRecord> page, InoutParam param) throws Exception {
        String hql = " from " + InoutRecord.class.getName()
                + " where companyId =:companyId and progress =:progress";
        Map<String, Object> args = new HashMap<String, Object>();

        args.put("companyId", ContextUtil.getCompanyId());
        args.put("progress", InoutConstant.PROGRESS_RECORD);

        if (StringUtils.isNotEmpty(param.getType())) {
            hql += " and type =:type";
            args.put("type", param.getType());
        }

        if (StringUtils.isNotEmpty(param.getId())) {
            hql += " and id like:id";
            args.put("id", "%" + param.getId() + "%");
        }

        if (StringUtils.isNotEmpty(param.getPlateNum())) {
            hql += " and plateNum like:plateNum";
            args.put("plateNum", "%" + param.getPlateNum() + "%");
        }

        if (StringUtils.isNotEmpty(param.getCustomerId())) {
            hql += " and customerId =:customerId";
            args.put("customerId", param.getCustomerId());
        }

        if (StringUtils.isNotEmpty(param.getDepotId())) {
            hql += " and depotId =:depotId";
            args.put("depotId", param.getDepotId());
        }

        if (StringUtils.isNotEmpty(param.getFoodVariety())) {
            hql += " and foodVariety =:foodVariety";
            args.put("foodVariety", param.getFoodVariety());
        }


        if (null != param.getStart()) {
            hql += " and completeTime >=:start";
            args.put("start", DateUtil.getCurZero(param.getStart()));
        }

        if (null != param.getEnd()) {
            hql += " and completeTime <=:end";
            args.put("end", DateUtil.getNextZero(param.getEnd()));
        }

        hql += " and RECORD_STATUS_ <> 'ERROR' and RECORD_STATUS_ <> 'DEL'";

        String countHql = " select count(*) " + hql;

        hql += " order by id desc ";

        this.pagingQuery(page, hql, countHql, args);
    }

    public InoutSettle getSettleById(String companyId, String id) {
        String hql = " from " + InoutSettle.class.getName()
                + " where companyId=:companyId";

        Map<String, Object> args = new HashMap<String, Object>();
        if (StringUtils.isEmpty(companyId)) {
            companyId = ContextUtil.getCompanyId();
        }
        args.put("companyId", ContextUtil.getCompanyId());
        if (StringUtils.isNotEmpty(id)) {
            hql += " and id=:id";
            args.put("id", id);
        }

        hql += " order by payTime desc";
        List<InoutSettle> list = this.query(hql, args);
        if (list != null && list.size() > 0) {
            return list.get(0);
        }
        return null;
    }


    public String saveOrUpdateData(InoutSettle data) {
        Session session = this.getSessionFactory().openSession();

        try {
            if (null == data.getPayTime()) {
                data.setPayTime(new Date());
            }

            if (null == data.getCompanyId()) {
                data.setCompanyId(ContextUtil.getCompanyId());
                session.save(data);
            } else {
                session.update(data);
            }
        } finally {
            session.flush();
            session.close();
        }
        return null;
    }

    public void updateInoutRecordPay(String id) {
        String hql = " update " + InoutRecord.class.getName() + " set settleTag=:settleTag where id=:id";
        Session session = this.getSessionFactory().openSession();
        try {
            Query query = session.createQuery(hql);
            query.setString("settleTag", Constant.YN_Y);
            query.setString("id", id);
            query.executeUpdate();
        } finally {
            session.flush();
            session.close();
        }
    }

    /**
     * 根据条件分页获取结算信息
     *
     * @param page
     * @param param
     */
    public void pageSettle(Page<InoutSettle> page, InoutParam param) throws Exception {
        String hql = " from " + InoutSettle.class.getName()
                + " where companyId =:companyId and deptId=:deptId";
        Map<String, Object> args = new HashMap<>();

        args.put("companyId", param.getCompanyId());
        args.put("deptId", param.getDeptId());

        if (StringUtils.isNotEmpty(param.getType())) {
            hql += " and inoutType =:inoutType";
            args.put("inoutType", param.getType());
        }

        if (StringUtils.isNotEmpty(param.getId())) {
            hql += " and id like:id";
            args.put("id", "%" + param.getId() + "%");
        }

        if (StringUtils.isNotEmpty(param.getDepotId())) {
            hql += " and depotId =:depotId";
            args.put("depotId", param.getDepotId());
        }
        if (null != param.getStart()) {
            hql += " and payTime >=:start";
            args.put("start", DateUtil.getCurZero(param.getStart()));
        }
        if (null != param.getEnd()) {
            hql += " and payTime <=:end";
            args.put("end", DateUtil.getNextZero(param.getEnd()));
        }

        String countHql = " select count(*) " + hql;

        hql += " order by id desc ";

        this.pagingQuery(page, hql, countHql, args);
    }


}