package com.shlanbao.tzsc.pms.qm.qmsd.service.impl;

import com.shlanbao.tzsc.base.dao.MdMatDaoI;
import com.shlanbao.tzsc.base.dao.QmStdDaoI;
import com.shlanbao.tzsc.base.mapping.MdMat;
import com.shlanbao.tzsc.base.mapping.QmStd;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.base.model.PageParams;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.qm.qmsd.bean.QmStdBean;
import com.shlanbao.tzsc.pms.qm.qmsd.service.QmStdService;
import com.shlanbao.tzsc.utils.tools.DateUtil;
import com.shlanbao.tzsc.utils.tools.StringUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@Service
public class QmStdServiceImpl extends BaseService implements QmStdService {
    @Autowired
    private QmStdDaoI qmStdDaoI;
    @Autowired
    private MdMatDaoI mdMatDaoI;
    @Override
    public DataGrid queryList(QmStdBean bean, PageParams pageParams) throws Exception {
        List<QmStdBean > list = new ArrayList<>();
        List<Object> params = new ArrayList<Object>();
        StringBuffer hql=new StringBuffer();
        hql.append("from QmStd o where 1=1 ");
        if(StringUtil.notNull(bean.getMatid())){
           hql.append(" and o.mdMat = "+"'"+bean.getMatid()+"'");
        }
        if (StringUtil.notEmpty(bean.getEffedate()) ) {
            hql.append(" and to_char(o.effedate,'yyyy-mm-dd')='"+bean.getEffedate()+"'");
        }
        List<QmStd> rows = qmStdDaoI.queryByPage(hql.toString(), pageParams.getPage(), pageParams.getRows(), params);
        Long count = 0l;
        if(rows!=null&&rows.size()>0) {
            count = Long.valueOf(rows.size());
            for (QmStd item:rows){
                QmStdBean qmStdBean = new QmStdBean();
                qmStdBean.setId(item.getId());
                if(item.getMatname()!=null) qmStdBean.setMatname(item.getMatname());
                if(item.getWeightstd()!=null) qmStdBean.setWeightstd(item.getWeightstd());
                if(item.getCirsd()!=null) qmStdBean.setCirsd(item.getCirsd());
                if(item.getRoundsd()!=null) qmStdBean.setRoundsd(item.getRoundsd());
                if(item.getLensd()!=null) qmStdBean.setLensd(item.getLensd());
                if(item.getXzsd()!=null) qmStdBean.setXzsd(item.getXzsd());
                if(item.getVentsd()!=null) qmStdBean.setVentsd(item.getVentsd());
                if(item.getHdsd()!=null) qmStdBean.setHdsd(item.getHdsd());
                if(item.getEffedate()!=null) {
                    String date = DateUtil.formatDateToString(item.getEffedate(), "yyyy-MM-dd");
                    qmStdBean.setEffedate(date);
                }
                list.add(qmStdBean);
            }
        }


        return new DataGrid(list,count) ;
    }

    @Override
    public void saveOrUpdate(QmStdBean bean) throws Exception {

        MdMat mat = mdMatDaoI.findById(MdMat.class, bean.getMatid());

        QmStd o = new QmStd();
        o.setId(bean.getId());
        o.setCirsd(bean.getCirsd());
        o.setMatname(bean.getMatname());
        o.setWeightstd(bean.getWeightstd());
        o.setRoundsd(bean.getRoundsd());
        o.setLensd(bean.getLensd());
        o.setXzsd(bean.getXzsd());
        o.setVentsd(bean.getVentsd());
        o.setHdsd(bean.getHdsd());
        if(mat!=null){
            o.setMatname(mat.getName());
            o.setMdMat(mat);
        }
        if(bean.getEffedate()!=null){
            Date date = DateUtil.strToDate(bean.getEffedate(), "yyyy-MM-dd");
            o.setEffedate(date);
        }
        if(bean.getMatid()!=null){
            MdMat mdMat = new MdMat();
            mdMat.setId(bean.getMatid());
            o.setMdMat(mdMat);
        }
        qmStdDaoI.saveOrUpdate(o);

    }

    @Override
    public void delSd(String id) throws  Exception {
        qmStdDaoI.deleteById(id,QmStd.class);
    }

    @Override
    public void batchDeleteSd(String ids) throws  Exception {
        String[] split = ids.split(",");
        for (int i =0;i<split.length;i++){
            qmStdDaoI.deleteById(split[i],QmStd.class);
        }
    }

    @Override
    public QmStdBean querySdById(String id) {
        QmStd bean = qmStdDaoI.findById(QmStd.class, id);
        QmStdBean o =  new QmStdBean();
        o.setId(bean.getId());
        o.setCirsd(bean.getCirsd());
        o.setMatname(bean.getMatname());
        o.setWeightstd(bean.getWeightstd());
        o.setRoundsd(bean.getRoundsd());
        o.setLensd(bean.getLensd());
        o.setXzsd(bean.getXzsd());
        o.setVentsd(bean.getVentsd());
        o.setHdsd(bean.getHdsd());
        if(bean.getEffedate()!=null){
        String date =  DateUtil.formatDateToString(bean.getEffedate(), "yyyy-MM-dd");
            o.setEffedate(date);
        }
        if(bean.getMdMat()!=null){

            o.setMatid(bean.getMdMat().getId());
        }
        return o;
    }
}