package cn.besteam.modules.medical.service.impl;

import cn.besteam.common.constant.DepartmentEnum;
import cn.besteam.modules.medical.dto.MwServicePeriodDTO;
import cn.besteam.modules.medical.dto.MwServicePeriodEditDTO;
import cn.besteam.modules.medical.dto.RenewOrderRequestVO;
import cn.besteam.modules.medical.dto.RenewOrderResponseVO;
import cn.besteam.modules.medical.entity.MwServicePeriod;
import cn.besteam.modules.medical.entity.MwServicePeriodLog;
import cn.besteam.modules.medical.mapper.MwServicePeriodMapper;
import cn.besteam.modules.medical.service.IMwServicePeriodLogService;
import cn.besteam.modules.medical.service.IMwServicePeriodService;
import cn.besteam.modules.medical.vo.MwServicePeriodListDTO;
import cn.besteam.modules.shiro.authc.util.EnvUtils;
import cn.besteam.modules.system.entity.SysDepartment;
import cn.besteam.modules.system.entity.SysDictItem;
import cn.besteam.modules.system.service.ISysDepartmentService;
import cn.besteam.modules.system.service.ISysDictItemService;
import cn.besteam.modules.system.util.NouNouPayUtil;
import cn.hutool.poi.excel.ExcelWriter;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.apache.commons.collections.CollectionUtils;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.*;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.servlet.http.HttpServletResponse;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.stream.Collectors;

/**
* 服务期限
* @author pzb
* @Date 2022/7/13 20:01
*/
@Service
public class MwServicePeriodServiceImpl extends ServiceImpl<MwServicePeriodMapper, MwServicePeriod> implements IMwServicePeriodService {

    @Autowired
    private ISysDictItemService sysDictItemService;

    @Autowired
    private ISysDepartmentService departmentService;

    @Autowired
    private IMwServicePeriodLogService servicePeriodLogService;

    @Autowired
    private ISysDictItemService dictItemService;

    @Autowired
    private NouNouPayUtil nouNouPayUtil;



    private List<Integer> getSearchHospitalIdList(Integer hospitalId) {

        if (hospitalId == null) {
            return departmentService.listMyHospital(EnvUtils.getUser().getId()).stream().map(SysDepartment::getId).collect(Collectors.toList());
        } else {
            SysDepartment sysDepartment = departmentService.getById(hospitalId);
            if (sysDepartment == null) {
                return new ArrayList<>();
            }
            List<SysDepartment> childrenList = departmentService.list(new QueryWrapper<SysDepartment>().lambda().likeRight(SysDepartment::getTreeCode, sysDepartment.getTreeCode()).eq(SysDepartment::getOrgType, DepartmentEnum.OrgTypeEnum.HOSPITAL.getType()));
            if (CollectionUtils.isEmpty(childrenList)) {
                return new ArrayList<>();
            }
            return childrenList.stream().map(SysDepartment::getId).collect(Collectors.toList());
        }
    }

    /**
     * 获取服务期管理列表
     * @param dto
     * @return
     */
    @Override
    public List<MwServicePeriodListDTO> getServicePeriodList(MwServicePeriodDTO dto) {
        return this.baseMapper.getServicePeriodList(dto);
    }

    @Override
    public MwServicePeriodListDTO getServicePeriodInfo(Integer id) {
        MwServicePeriod one = this.getOne(new QueryWrapper<MwServicePeriod>().lambda().eq(MwServicePeriod::getDepartmentId, id)
                .eq(MwServicePeriod::getStatus, 1).eq(MwServicePeriod::getDelFlag, 0).orderByDesc(MwServicePeriod::getCreateTime));
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        MwServicePeriodListDTO dto = new MwServicePeriodListDTO();
        SysDepartment byId = departmentService.getById(one.getDepartmentId());
        if(null != one){
            dto.setId(id);
            dto.setExpireDate(sdf.format(byId.getExpireDate()));
            dto.setReminderDays(byId.getReminderDays());
            dto.setServiceCharge(byId.getServiceCharge());
            SysDictItem dictItem = sysDictItemService.getById(byId.getServiceUnit());
            dto.setServiceUnit(dictItem.getItemText());
            dto.setNote(byId.getNote());
        }
        return dto;
    }

    @Override
    public List<MwServicePeriodListDTO> getServicePeriodHistoryRecord(Integer id) {
        return this.baseMapper.getServicePeriodHistoryRecord(id);
    }

    @Override
    public void editServicePeriod(MwServicePeriodEditDTO dto, Integer userId) {
        String[] split = dto.getIds().split(",");
        for (String s : split) {
            MwServicePeriod one = this.getOne(new QueryWrapper<MwServicePeriod>().lambda().eq(MwServicePeriod::getDepartmentId, s)
                    .eq(MwServicePeriod::getStatus, 1).eq(MwServicePeriod::getDelFlag, 0).orderByDesc(MwServicePeriod::getCreateTime));
            if(null != one){
                one.setStatus(0);
                this.baseMapper.updateById(one);
            }
            MwServicePeriod mwServicePeriod = new MwServicePeriod();
            BeanUtils.copyProperties(dto, mwServicePeriod);
            mwServicePeriod.setDepartmentId(Integer.valueOf(s));
            mwServicePeriod.setPayStatus(1);
            mwServicePeriod.setStatus(1);
            mwServicePeriod.setDelFlag(0);
            mwServicePeriod.setCreateUserId(userId);
            mwServicePeriod.setCreateTime(new Date());
            //支付为0直接修改数据
            SysDepartment department = departmentService.getById(s);
            department.setReminderDays(dto.getReminderDays());
            department.setExpireDate(dto.getExpireDate());
            department.setServiceCharge(dto.getServiceCharge());
            department.setServiceUnit(dto.getServiceUnit());
            department.setNote(dto.getNote());
            departmentService.updateById(department);

            //添加操作日志记录
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            if(null == one || department.getExpireDate().getTime() != dto.getExpireDate().getTime()){
//                MwServicePeriodLog servicePeriodLog = new MwServicePeriodLog();
//                servicePeriodLog.setServicePeriodId(mwServicePeriod.getId());
//                servicePeriodLog.setServiceType(1);
//                servicePeriodLog.setHistoricalData(null == one ? "" : sdf.format(department.getExpireDate()));
//                servicePeriodLog.setCurrentData(sdf.format(department.getExpireDate()));
//                servicePeriodLog.setCreateTime(new Date());
                servicePeriodLogService.saveLog(Integer.valueOf(s),dto.getServiceCharge(),dto.getExpireDate(),dto.getReminderDays(),dto.getServiceUnit(),dto.getNote(),userId,1);
            }else{
//            if(null == one || department.getServiceCharge() != dto.getServiceCharge()){
//                MwServicePeriodLog servicePeriodLog = new MwServicePeriodLog();
//                servicePeriodLog.setServicePeriodId(mwServicePeriod.getId());
//                servicePeriodLog.setServiceType(2);
//                servicePeriodLog.setHistoricalData(null == one ? "" : department.getServiceCharge().toString());
//                servicePeriodLog.setCurrentData(department.getServiceCharge().toString());
//                servicePeriodLog.setCreateTime(new Date());
//                servicePeriodLogService.saveLog(Integer.valueOf(s),dto.getServiceCharge(),dto.getExpireDate(),dto.getReminderDays(),dto.getServiceUnit(),dto.getNote(),userId,2);
            }
        }

    }

    @Override
    public void exportServicePeriodList(MwServicePeriodDTO dto, HttpServletResponse response) throws Exception {
        ExcelWriter excelWriter = new ExcelWriter(exportServicePeriodList(dto, "服务期管理"), "服务期管理");
        if (excelWriter != null) {
            response.setContentType("application/octet-stream;charset=utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("服务期管理", "UTF-8") + ".xlsx");
            excelWriter.flush(response.getOutputStream(), true);
            excelWriter.close();
        }
    }


    private XSSFWorkbook exportServicePeriodList(MwServicePeriodDTO dto, String fileName){
        List<MwServicePeriodListDTO> servicePeriodList = this.baseMapper.getServicePeriodList(dto);
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet(fileName);
        XSSFCellStyle cellStyle = createDefaultCellStyle(workbook);

        XSSFRow row = sheet.createRow(0);//表头
        XSSFCell cell = row.createCell(0);
        cell.setCellStyle(cellStyle);
        cell.setCellValue("服务期管理");
        sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 4));


        XSSFRow row1 = sheet.createRow(0);//表头
        XSSFCell cel2 = row1.createCell(0);
        cel2.setCellStyle(cellStyle);
        cel2.setCellValue("所属区域");

        XSSFCell cel3 = row1.createCell(1);
        cel3.setCellStyle(cellStyle);
        cel3.setCellValue("医院名称");

        XSSFCell cel4 = row1.createCell(2);
        cel4.setCellStyle(cellStyle);
        cel4.setCellValue("到期时间");

        XSSFCell cel5 = row1.createCell(3);
        cel5.setCellStyle(cellStyle);
        cel5.setCellValue("是否到期");

        XSSFCell cel6 = row1.createCell(4);
        cel6.setCellStyle(cellStyle);
        cel6.setCellValue("即将到期");

        XSSFCell cel7 = row1.createCell(5);
        cel7.setCellStyle(cellStyle);
        cel7.setCellValue("即将到期提醒");

        XSSFCell cel8 = row1.createCell(6);
        cel8.setCellStyle(cellStyle);
        cel8.setCellValue("服务费");

        XSSFCell cel9 = row1.createCell(7);
        cel9.setCellStyle(cellStyle);
        cel9.setCellValue("服务单位");

        for (int i = 0; i < servicePeriodList.size(); i++) {
            MwServicePeriodListDTO mwServicePeriodListDTO = servicePeriodList.get(i);
            XSSFRow row21 = sheet.createRow(i);//表头
            row21.setRowStyle(cellStyle);
            XSSFCell cel21 = row21.createCell(0);
            cel21.setCellValue(mwServicePeriodListDTO.getDepartment());

            XSSFCell cel22 = row21.createCell(1);
            cel22.setCellValue(mwServicePeriodListDTO.getHospital());

            XSSFCell cel23 = row21.createCell(2);
            cel23.setCellValue(null == mwServicePeriodListDTO.getExpireDate() ? "" : mwServicePeriodListDTO.getExpireDate());

            XSSFCell cel24 = row21.createCell(3);
            cel24.setCellValue(mwServicePeriodListDTO.getIsExpire() == 1 ? "是" : "否");

            XSSFCell cel25 = row21.createCell(4);
            cel25.setCellValue(mwServicePeriodListDTO.getAboutToExpire() == 1 ? "是" : "否");

            XSSFCell cel26 = row21.createCell(5);
            cel26.setCellValue(null == mwServicePeriodListDTO.getReminderDays() ? "" : mwServicePeriodListDTO.getReminderDays().toString());

            XSSFCell cel27 = row21.createCell(6);
            cel27.setCellValue(null == mwServicePeriodListDTO.getServiceCharge() ? "" : mwServicePeriodListDTO.getServiceCharge().toString());

            XSSFCell cel28 = row21.createCell(7);
            cel28.setCellValue(mwServicePeriodListDTO.getServiceUnit());
        }
        return workbook;


    }


    private XSSFCellStyle createDefaultCellStyle(XSSFWorkbook workbook) {

        XSSFCellStyle cellStyle = workbook.createCellStyle();
        cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
        cellStyle.setAlignment(HorizontalAlignment.CENTER);
        XSSFFont font = workbook.createFont();
        font.setFontName("宋体");
        font.setFontHeightInPoints((short) 12);
        cellStyle.setFont(font);
        return cellStyle;
    }

    @Override
    public IPage<RenewOrderResponseVO> getRenewOrderList(RenewOrderRequestVO vo, Integer pageNo, Integer pageSize) {
        pageNo = vo.getPageNo();
        pageSize = vo.getPageSize();
        vo.setHospitalIdList(getSearchHospitalIdList(vo.getDepartmentId()));
        Page<RenewOrderResponseVO> pageParam = new Page<>(pageNo, pageSize);
        IPage<RenewOrderResponseVO> renewOrderList = this.baseMapper.getRenewOrderList(pageParam, vo);
        return renewOrderList;
    }

    @Override
    public RenewOrderResponseVO getRenewOrderOne(Integer id) {
        return this.baseMapper.getRenewOrderOne(id);
    }

    @Override
    public void exportRenewOrder(RenewOrderRequestVO vo, HttpServletResponse response) throws Exception {
        ExcelWriter excelWriter = new ExcelWriter(exportRenewOrder(vo, "续费订单"), "续费订单");
        if (excelWriter != null) {
            response.setContentType("application/octet-stream;charset=utf-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("续费订单", "UTF-8") + ".xlsx");
            excelWriter.flush(response.getOutputStream(), true);
            excelWriter.close();
        }
    }


    private XSSFWorkbook exportRenewOrder(RenewOrderRequestVO vo, String fileName){
        Page<RenewOrderResponseVO> pageParam = new Page<>(0, 100000000);
        IPage<RenewOrderResponseVO> renewOrderList = this.baseMapper.getRenewOrderList(pageParam, vo);
        List<RenewOrderResponseVO> records = renewOrderList.getRecords();



        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet(fileName);
        XSSFCellStyle cellStyle = createDefaultCellStyle(workbook);

        XSSFRow row = sheet.createRow(0);//表头
        XSSFCell cell = row.createCell(0);
        cell.setCellStyle(cellStyle);
        cell.setCellValue("续费订单");
        sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 10));


        XSSFRow row1 = sheet.createRow(1);//表头
        XSSFCell cel2 = row1.createCell(0);
        cel2.setCellStyle(cellStyle);
        cel2.setCellValue("所属区域");

        XSSFCell cel3 = row1.createCell(1);
        cel3.setCellStyle(cellStyle);
        cel3.setCellValue("医院名称");

        XSSFCell cel4 = row1.createCell(2);
        cel4.setCellStyle(cellStyle);
        cel4.setCellValue("订单编号");

        XSSFCell cel5 = row1.createCell(3);
        cel5.setCellStyle(cellStyle);
        cel5.setCellValue("订单时间");

        XSSFCell cel6 = row1.createCell(4);
        cel6.setCellStyle(cellStyle);
        cel6.setCellValue("订单状态");

        XSSFCell cel7 = row1.createCell(5);
        cel7.setCellStyle(cellStyle);
        cel7.setCellValue("订单金额");

        XSSFCell cel8 = row1.createCell(6);
        cel8.setCellStyle(cellStyle);
        cel8.setCellValue("支付时间");

        XSSFCell cel9 = row1.createCell(7);
        cel9.setCellStyle(cellStyle);
        cel9.setCellValue("支付方式");

        XSSFCell cel10 = row1.createCell(8);
        cel10.setCellStyle(cellStyle);
        cel10.setCellValue("支付金额");

        XSSFCell cel11 = row1.createCell(9);
        cel11.setCellStyle(cellStyle);
        cel11.setCellValue("微信/支付宝订单号");

        XSSFCell cel12 = row1.createCell(10);
        cel12.setCellStyle(cellStyle);
        cel12.setCellValue("开票状态");

        for (int i = 2; i < records.size(); i++) {
            RenewOrderResponseVO renewOrderResponseVO = records.get(i);
            XSSFRow row21 = sheet.createRow(i);//表头
            row21.setRowStyle(cellStyle);
            XSSFCell cel21 = row21.createCell(0);
            cel21.setCellValue(renewOrderResponseVO.getDepartmentName());

            XSSFCell cel22 = row21.createCell(1);
            cel22.setCellValue(renewOrderResponseVO.getHospitalName());

            XSSFCell cel23 = row21.createCell(2);
            cel23.setCellValue(renewOrderResponseVO.getCode());

            XSSFCell cel24 = row21.createCell(3);
            cel24.setCellValue(renewOrderResponseVO.getOrderTime());

            XSSFCell cel25 = row21.createCell(4);
            switch (renewOrderResponseVO.getPayStatus()){
                case 0:
                    cel25.setCellValue("待支付");
                    break;
                case 1:
                    cel25.setCellValue("已支付");
                    break;
                case 2:
                    cel25.setCellValue("支付失败");
                    break;
                case 3:
                    cel25.setCellValue("关闭");
                    break;
                case 4:
                    cel25.setCellValue("退款中");
                    break;
                case 5:
                    cel25.setCellValue("退款成功");
                    break;
                case 6:
                    cel25.setCellValue("退款失败");
                    break;
            }

            XSSFCell cel26 = row21.createCell(5);
            cel26.setCellValue(renewOrderResponseVO.getServiceCharge());

            XSSFCell cel27 = row21.createCell(6);
            cel27.setCellValue(renewOrderResponseVO.getPayTime());

            XSSFCell cel28 = row21.createCell(7);
            cel28.setCellValue(renewOrderResponseVO.getPayType()==null?"":renewOrderResponseVO.getPayType() == 1 ? "微信" : "支付宝");

            XSSFCell cel29 = row21.createCell(8);
            cel29.setCellValue(renewOrderResponseVO.getPayMoney()==null?0:renewOrderResponseVO.getPayMoney());

            XSSFCell cel30 = row21.createCell(9);
            cel30.setCellValue(renewOrderResponseVO.getOrderNumber());

            XSSFCell cel31 = row21.createCell(10);
            if(renewOrderResponseVO.getIsInvoiced()!=null){
                switch (renewOrderResponseVO.getIsInvoiced()){
                    case 0:
                        cel31.setCellValue("未开票");
                        break;
                    case 1:
                        cel31.setCellValue("已开票");
                        break;
                    case 2:
                        cel31.setCellValue("开票失败");
                        break;
                    case 3:
                        cel31.setCellValue("正在开票");
                        break;
                }
            }else{
                cel31.setCellValue("");
            }


        }
        return workbook;
    }

    @Override
    public String getBillingAddress(Integer id) {
        MwServicePeriod servicePeriod = this.getById(id);
        SysDepartment department = departmentService.getById(servicePeriod.getDepartmentId());
        SysDictItem dictItem = dictItemService.getById(department.getBillingCompany());
        String invoiceLinks = nouNouPayUtil.getInvoiceLinks("", servicePeriod.getCode(), dictItem.getItemValue());
        return invoiceLinks;
    }
}