fj-dc/.svn/pristine/0a/0a90ede0f6f347903e23dfc61c0cdc4476c50c85.svn-base

package cn.com.goldenwater.dcproj.service.impl.wiu;

import cn.com.goldenwater.dcproj.dao.AttWiuWatLicDao;
import cn.com.goldenwater.dcproj.model.AttWiuWatLic;
import cn.com.goldenwater.dcproj.model.WrSwsB;
import cn.com.goldenwater.dcproj.param.AttWiuWatLicParam;
import cn.com.goldenwater.dcproj.service.AttWiuWatLicService;
import cn.com.goldenwater.core.service.AbstractCrudService;
import cn.com.goldenwater.dcproj.utils.BeanUtil;
import cn.com.goldenwater.dcproj.utils.expExcel.ExcelExport;
import cn.com.goldenwater.dcproj.utils.expExcel.ExportAbstract;
import com.github.pagehelper.PageHelper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.servlet.http.HttpServletResponse;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * @author lune
 * @date 2019-8-9
 */
@Service
@Transactional(rollbackFor = Exception.class)
public class AttWiuWatLicServiceImpl extends AbstractCrudService<AttWiuWatLic, AttWiuWatLicParam> implements AttWiuWatLicService {

    @Autowired
    private AttWiuWatLicDao attWiuWatLicDao;

    public AttWiuWatLicServiceImpl(AttWiuWatLicDao attWiuWatLicDao) {
        super(attWiuWatLicDao);
        this.attWiuWatLicDao = attWiuWatLicDao;
    }


    @Override
    public void exportAttWiuWatLic(AttWiuWatLicParam attWiuWatLicParam, HttpServletResponse response) {
        List<AttWiuWatLic> list =attWiuWatLicDao.findList(attWiuWatLicParam);

        List<Map<String,Object>> mapList = new ArrayList<>();

        for (AttWiuWatLic attWiuWatLic : list) {
            DateFormat dateFormat=new SimpleDateFormat("yyyy-MM-DD HH:mm:ss");
            Date intBdDate = attWiuWatLic.getIntBd();
            String intBd=dateFormat.format(intBdDate);
            Date intDlDate = attWiuWatLic.getIntDl();
            String intDl=dateFormat.format(intDlDate);
            Date apprDtDate = attWiuWatLic.getApprDt();
            String apprDt=dateFormat.format(apprDtDate);
            String certCond = attWiuWatLic.getCertCond();

            if ("1".equals(certCond)){
                attWiuWatLic.setCertCond("新发");
            } else if ("2".equals(certCond)){
                attWiuWatLic.setCertCond("变更");
            }else if ("3".equals(certCond)){
                attWiuWatLic.setCertCond("注销");
            }else if ("4".equals(certCond)){
                attWiuWatLic.setCertCond("吊销");
            }else if ("5".equals(certCond)){
                attWiuWatLic.setCertCond("延续");
            }else if ("6".equals(certCond)){
                attWiuWatLic.setCertCond("失败备案");
            }

            mapList.add(BeanUtil.transBean2Map(attWiuWatLic));
        }

        ExportAbstract export = new ExcelExport();
        export.setFileName("取水许可证信息列表");
        export.setExport_ps_export(true);
        export.setExport_ps_type(ExportAbstract.XLS);
        export.setExport_bzip(false);
        export.setTitle("取水许可证信息列表");
        ArrayList<Object> cols = new ArrayList<Object>();
        cols.add("wintCode[取水许可证代码]");
        cols.add("watLicCode[取水许可证编号]");
        cols.add("wrpNm[取水权人名称]");
        cols.add("wiuCode[取用水户代码]");
        cols.add("name[法人代表]");
        cols.add("rwAddr[取水地点]");
        cols.add("chkIntMet[取水方式]");
        cols.add("wiuWw[取水量]");
        cols.add("intUse[取水用途]");
        cols.add("chkSourTp[水源类型]");
        cols.add("intBd[取水起始日期]");
        cols.add("intDl[取水终止日期]");
        cols.add("certCond[证件状态]");
        cols.add("rwAddr[退水地点]");
        cols.add("rwTp[退水方式]");
        cols.add("bkWw[退水量]");
        cols.add("rwWqReq[退水水质要求]");
        cols.add("apprOrgCd[审批单位代码]");
        cols.add("apprOrgName[审批单位名称]");
        cols.add("apprDt[审批日期]");
        cols.add("manOrgCd[监督管理单位代码]");
        cols.add("manOrgName[监管单位名称]");
        export.setCols(cols);
        export.setGroupable(false);
        // 设置视图指标
        export.setLevel(1);
        export.setLocksize(0);

        try {
            export.Export(response);
            export.ExportHeadForCustom(response);//导出表头
            export.ContinueExport(mapList);
            export.EndExport();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}