package com.panzhihua.service_community.service.impl;

import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.ArrayList;
import java.util.Comparator;
import java.util.Date;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
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.google.common.collect.Lists;
import com.panzhihua.common.model.dtos.community.PageQuestnaireAnswerDTO;
import com.panzhihua.common.model.dtos.community.PageQuestnaireDTO;
import com.panzhihua.common.model.dtos.community.PageQuestnaireSubDetailsDTO;
import com.panzhihua.common.model.dtos.community.QuestnaireAnswersDTO;
import com.panzhihua.common.model.dtos.community.questnaire.StatisticsSummaryDTO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComActQuestnaireAnswerContentVO;
import com.panzhihua.common.model.vos.community.ComActQuestnaireSubSelectionVO;
import com.panzhihua.common.model.vos.community.ComActQuestnaireSubVO;
import com.panzhihua.common.model.vos.community.ComActQuestnaireVO;
import com.panzhihua.common.model.vos.community.questnaire.*;
import com.panzhihua.common.service.user.UserService;
import com.panzhihua.common.utlis.DateUtils;
import com.panzhihua.service_community.dao.*;
import com.panzhihua.service_community.model.dos.*;
import com.panzhihua.service_community.service.ComActQuestnaireService;

import lombok.extern.slf4j.Slf4j;

/**
 * @Author: llming
 * @Description:
 */
@Slf4j
@Service
public class ComActQuestnaireServiceImpl implements ComActQuestnaireService {
    @Resource
    ComActQuestnaireDAO questnaireDAO;
    @Resource
    ComActQuestnaireSubDAO questnaireSubDAO;
    @Resource
    ComActDynUserDAO userDAO;
    @Resource
    ComActQuestnaireSubSelectionDAO questnaireSubSelectionDAO;
    @Resource
    ComActQuestnaireAnswerContentDAO questnaireAnswerContentDAO;
    @Resource
    ComActQuestnaireSubServiceImpl questnaireSubService;
    @Resource
    ComActQuestnaireSubSelectionServiceImpl subSelectionService;
    @Resource
    ComActQuestnaireAnswerContentServiceImpl answerContentService;
    @Resource
    UserService userService;
    @Resource
    private ComActQuestnaireUserAnswerMapper comActQuestnaireUserAnswerMapper;

    @Override
    @Transactional(rollbackFor = Exception.class)
    public R addQuestnaire(QuestnaireVO questnaireVO) {
        Long userId = questnaireVO.getUserId();
        if (questnaireVO.getAdverPositionPopup().equals(ComActQuestnaireDO.isOk.yes)) {
            // 查询当前时间段是否已有弹窗提醒了
            Integer count = questnaireDAO.getAdvPopupCount(questnaireVO.getCommunityId(), questnaireVO.getStartTime(),
                questnaireVO.getEndTime(), null);
            if (count > 0) {
                return R.fail("所选时间段已设置了问卷调查弹窗，暂不支持再次添加！");
            }
        }
        ComActQuestnaireDO comActQuestnaireDO = new ComActQuestnaireDO();
        Date nowDate = new Date();
        BeanUtils.copyProperties(questnaireVO, comActQuestnaireDO);
        comActQuestnaireDO.setState(ComActQuestnaireDO.state.dfb);
        comActQuestnaireDO.setTitle(questnaireVO.getTitle());
        comActQuestnaireDO.setJoinCount(0);
        comActQuestnaireDO.setCreateBy(userId);
        comActQuestnaireDO.setCreateAt(nowDate);
        Date startDate = DateUtils.stringToDate(questnaireVO.getStartTime(), DateUtils.ymdhms_format);
        if (startDate != null && startDate.getTime() <= nowDate.getTime()) {
            comActQuestnaireDO.setState(ComActQuestnaireDO.state.dyz);
            comActQuestnaireDO.setPublishTime(nowDate);
        }
        Date endDate = DateUtils.stringToDate(questnaireVO.getEndTime(), DateUtils.ymdhms_format);
        if (endDate != null && endDate.getTime() <= nowDate.getTime()) {
            comActQuestnaireDO.setState(ComActQuestnaireDO.state.yjs);
        }
        comActQuestnaireDO.setStartTime(startDate);
        comActQuestnaireDO.setEndTime(endDate);
        if (questnaireVO.getIdentity().equals(QuestnaireVO.identity.jm)) {
            comActQuestnaireDO.setForMasses(ComActQuestnaireDO.isOk.yes);
        } else if (questnaireVO.getIdentity().equals(QuestnaireVO.identity.dy)) {
            comActQuestnaireDO.setForParty(ComActQuestnaireDO.isOk.yes);
        } else if (questnaireVO.getIdentity().equals(QuestnaireVO.identity.zyz)) {
            comActQuestnaireDO.setForVolunteer(ComActQuestnaireDO.isOk.yes);
        }

        if (questnaireVO.getIsRelease() != null && questnaireVO.getIsRelease().equals(1)) {
            comActQuestnaireDO.setStartTime(nowDate);
        }
        // 统计该调查问卷填报题目数量
        int count = 0;
        List<QuestnaiteSubVO> questnaiteSubVOS = JSON.parseArray(questnaireVO.getJsonObject(), QuestnaiteSubVO.class);
        if (!questnaiteSubVOS.isEmpty()) {
            count = questnaiteSubVOS.size();
        }
        comActQuestnaireDO.setCount(count);
        comActQuestnaireDO.setJsonObject(questnaireVO.getJsonObject());

        int quesCount = questnaireDAO.insert(comActQuestnaireDO);
        if (quesCount != 1) {
            return R.fail("创建失败");
        }

        if (!questnaiteSubVOS.isEmpty()) {
            questnaiteSubVOS.forEach(sub -> {
                ComActQuestnaireSubDO comActQuestnaireSubDO = new ComActQuestnaireSubDO();
                comActQuestnaireSubDO.setType(sub.getType());
                comActQuestnaireSubDO.setContent(sub.getLabel());
                comActQuestnaireSubDO.setSort(sub.getSort());
                comActQuestnaireSubDO.setQueId(comActQuestnaireDO.getId());
                comActQuestnaireSubDO.setCreateBy(userId);
                comActQuestnaireSubDO.setKey(sub.getKey());
                questnaireSubDAO.insert(comActQuestnaireSubDO);
                ArrayList<ComActQuestnaireSubSelectionDO> subSelectionList = Lists.newArrayList();
                if (sub.getOptions() != null && !sub.getOptions().isEmpty()) {
                    List<QuestnaiteSubSelectionVO> subOptions = sub.getOptions();
                    for (int i = 0; i < subOptions.size(); i++) {
                        QuestnaiteSubSelectionVO subSelect = subOptions.get(i);
                        ComActQuestnaireSubSelectionDO subSelectionDO = new ComActQuestnaireSubSelectionDO();
                        subSelectionDO.setQueSubId(comActQuestnaireSubDO.getId());
                        if (subSelect.getType().equals(1)) {
                            // 添加选项名称
                            subSelectionDO.setOptionName(subSelect.getOptionName());
                        } else {
                            subSelectionDO.setOptionName(String.valueOf(Character.toChars('A' + i)));
                        }
                        subSelectionDO.setContent(subSelect.getLabel());
                        subSelectionDO.setQueId(comActQuestnaireDO.getId());
                        subSelectionDO.setCreateBy(userId);
                        subSelectionDO.setType(subSelect.getType());
                        subSelectionDO.setKey(subSelect.getKey());
                        subSelectionDO.setUrl(subSelect.getUrl());
                        subSelectionList.add(subSelectionDO);
                    }
                }
                subSelectionService.saveBatch(subSelectionList);
            });
        }
        return R.ok();
    }

    @Override
    public R pageQuestnaire(PageQuestnaireDTO pageQuestnaireDTO) {
        IPage<QuestnaireListVo> voPage = questnaireDAO.selectPageList(
            new Page<>(pageQuestnaireDTO.getPageNum(), pageQuestnaireDTO.getPageSize()), pageQuestnaireDTO);
        return R.ok(voPage);
    }

    @Override
    public R pageQuestnaireAdmin(PageQuestnaireDTO pageQuestnaireDTO) {
        IPage<QuestnaireListAdminVO> voPage = questnaireDAO.selectPageListAdmin(
            new Page<>(pageQuestnaireDTO.getPageNum(), pageQuestnaireDTO.getPageSize()), pageQuestnaireDTO);
        if (!voPage.getRecords().isEmpty()) {
            voPage.getRecords().forEach(vo -> {
                // 判断调查人员身份
                if (vo.getForMasses().equals(ComActQuestnaireDO.isOk.yes)) {
                    vo.setIdentity("全部居民");
                } else if (vo.getForParty().equals(ComActQuestnaireDO.isOk.yes)) {
                    vo.setIdentity("党员");
                } else if (vo.getForVolunteer().equals(ComActQuestnaireDO.isOk.yes)) {
                    vo.setIdentity("志愿者");
                }
                // 判断广告位置
                StringBuilder sb = new StringBuilder();
                if (vo.getAdverPositionPopup().equals(ComActQuestnaireDO.isOk.yes)) {
                    sb.append("首页弹窗,");
                }
                if (vo.getAdverPositionTop().equals(ComActQuestnaireDO.isOk.yes)) {
                    sb.append("首页顶部,");
                }
                if (vo.getAdverPositionApplication().equals(ComActQuestnaireDO.isOk.yes)) {
                    sb.append("首页应用,");
                }
                if (vo.getIsCover().equals(ComActQuestnaireDO.isOk.yes)) {
                    sb.append("设置封面,");
                }
                String advertPosition = sb.toString();
                if (advertPosition.length() > 0) {
                    vo.setAdvertPosition(advertPosition.substring(0, advertPosition.length() - 1));
                } else {
                    vo.setAdvertPosition("无");
                }
            });
        }
        return R.ok(voPage);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public R editQuestnaire(QuestnaireVO questnaireVO) {
        Long queId = questnaireVO.getId();
        Long userId = questnaireVO.getUserId();
        ComActQuestnaireDO questnaireDO = this.questnaireDAO.selectById(queId);
        if (questnaireDO == null) {
            return R.fail("未查询到该问卷调查");
        }

        if (!questnaireDO.getState().equals(1)) {
            return R.fail("该调查问卷不是待发布状态，不可编辑");
        }

        if (questnaireVO.getAdverPositionPopup().equals(ComActQuestnaireDO.isOk.yes)) {
            // 查询当前时间段是否已有弹窗提醒了
            Integer count = questnaireDAO.getAdvPopupCount(questnaireVO.getCommunityId(), questnaireVO.getStartTime(),
                questnaireVO.getEndTime(), queId);
            if (count > 0) {
                return R.fail("所选时间段已设置了问卷调查弹窗，暂不支持再次添加！");
            }
        }

        // 更新调查问卷信息
        Date nowDate = new Date();
        BeanUtils.copyProperties(questnaireVO, questnaireDO);
        questnaireDO.setState(ComActQuestnaireDO.state.dfb);
        questnaireDO.setTitle(questnaireVO.getTitle());
        questnaireDO.setUpdateBy(userId);
        questnaireDO.setUpdateAt(nowDate);
        Date startDate = DateUtils.stringToDate(questnaireVO.getStartTime(), DateUtils.ymdhms_format);
        if (startDate != null && startDate.getTime() <= nowDate.getTime()) {
            questnaireDO.setState(ComActQuestnaireDO.state.dyz);
            questnaireDO.setPublishTime(nowDate);
        }
        Date endDate = DateUtils.stringToDate(questnaireVO.getEndTime(), DateUtils.ymdhms_format);
        if (endDate != null && endDate.getTime() <= nowDate.getTime()) {
            questnaireDO.setState(ComActQuestnaireDO.state.yjs);
        }
        questnaireDO.setStartTime(startDate);
        questnaireDO.setEndTime(endDate);
        if (questnaireVO.getIdentity().equals(QuestnaireVO.identity.jm)) {
            questnaireDO.setForMasses(ComActQuestnaireDO.isOk.yes);
        } else if (questnaireVO.getIdentity().equals(QuestnaireVO.identity.dy)) {
            questnaireDO.setForParty(ComActQuestnaireDO.isOk.yes);
        } else if (questnaireVO.getIdentity().equals(QuestnaireVO.identity.zyz)) {
            questnaireDO.setForVolunteer(ComActQuestnaireDO.isOk.yes);
        }

        if (questnaireVO.getIsRelease() != null && questnaireVO.getIsRelease().equals(1)) {
            questnaireDO.setStartTime(nowDate);
        }
        // 统计该调查问卷填报题目数量
        int count = 0;
        List<QuestnaiteSubVO> questnaiteSubVOS = JSON.parseArray(questnaireVO.getJsonObject(), QuestnaiteSubVO.class);
        if (!questnaiteSubVOS.isEmpty()) {
            count = questnaiteSubVOS.size();
        }
        questnaireDO.setCount(count);
        questnaireDO.setJsonObject(questnaireVO.getJsonObject());
        questnaireDAO.updateById(questnaireDO);
        // 删除原调查问卷题目以及选项，重新进行新增
        questnaireDAO.deleteQuesSubAll(queId);
        questnaireDAO.deleteQuesSubAll2(queId);
        // 重新新增题目以及题目选项
        if (!questnaiteSubVOS.isEmpty()) {
            questnaiteSubVOS.forEach(sub -> {
                ComActQuestnaireSubDO comActQuestnaireSubDO = new ComActQuestnaireSubDO();
                comActQuestnaireSubDO.setType(sub.getType());
                comActQuestnaireSubDO.setContent(sub.getLabel());
                comActQuestnaireSubDO.setSort(sub.getSort());
                comActQuestnaireSubDO.setKey(sub.getKey());
                comActQuestnaireSubDO.setQueId(queId);
                comActQuestnaireSubDO.setCreateBy(userId);
                questnaireSubDAO.insert(comActQuestnaireSubDO);
                ArrayList<ComActQuestnaireSubSelectionDO> subSelectionList = Lists.newArrayList();
                if (sub.getOptions() != null && !sub.getOptions().isEmpty()) {
                    List<QuestnaiteSubSelectionVO> subOptions = sub.getOptions();
                    for (int i = 0; i < subOptions.size(); i++) {
                        QuestnaiteSubSelectionVO subSelect = subOptions.get(i);
                        ComActQuestnaireSubSelectionDO subSelectionDO = new ComActQuestnaireSubSelectionDO();
                        subSelectionDO.setQueSubId(comActQuestnaireSubDO.getId());
                        if (subSelect.getType().equals(1)) {
                            // 添加选项名称
                            subSelectionDO.setOptionName(subSelect.getOptionName());
                        } else {
                            subSelectionDO.setOptionName(String.valueOf(Character.toChars('A' + i)));
                        }
                        subSelectionDO.setKey(subSelect.getKey());
                        subSelectionDO.setContent(subSelect.getLabel());
                        subSelectionDO.setQueId(queId);
                        subSelectionDO.setCreateBy(userId);
                        subSelectionDO.setType(subSelect.getType());
                        subSelectionList.add(subSelectionDO);
                    }
                }
                subSelectionService.saveBatch(subSelectionList);
            });
        }
        return R.ok();
    }

    @Override
    public R editQuestnaireDO(EditComActQuestnaireVo editComActQuestnaireVo) {
        Long userId = editComActQuestnaireVo.getUserId();
        LambdaQueryWrapper<ComActQuestnaireDO> subParam = new LambdaQueryWrapper<ComActQuestnaireDO>()
            .eq(ComActQuestnaireDO::getId, editComActQuestnaireVo.getQuestId());
        ComActQuestnaireDO questDO = questnaireDAO.selectOne(subParam);
        if (questDO == null) {
            return R.fail("未查询到调查问卷记录");
        }
        if (editComActQuestnaireVo.getType().equals(EditComActQuestnaireVo.type.jx)) {
            questDO.setEndTime(DateUtils.stringToDate(editComActQuestnaireVo.getEndTime(), DateUtils.ymdhms_format));
            questDO.setState(ComActQuestnaireDO.state.dyz);
        } else if (editComActQuestnaireVo.getType().equals(EditComActQuestnaireVo.type.tz)) {
            questDO.setState(ComActQuestnaireDO.state.yjs);
        } else if (editComActQuestnaireVo.getType().equals(EditComActQuestnaireVo.type.fb)) {
            questDO.setState(ComActQuestnaireDO.state.dyz);
            questDO.setStartTime(new Date());
        }
        questDO.setUpdateBy(userId);
        questDO.setUpdateAt(new Date());
        if (questnaireDAO.updateById(questDO) > 0) {
            return R.ok();
        } else {
            return R.fail();
        }
    }

    @Override
    public R deleteQuestnaire(Long questId, Long userId) {
        ComActQuestnaireDO queDO = questnaireDAO.selectById(questId);
        if (queDO == null) {
            return R.fail("未查询到调查问卷记录");
        }
//        if (!queDO.getState().equals(ComActQuestnaireDO.state.dfb) ) {

//        return R.fail("该调查问卷不是待发布状态，不可删除");
        if (queDO.getState().equals(ComActQuestnaireDO.state.dyz) ) {
            return R.fail("该调查问卷不是待发布状态或已结束状态，不可删除");
        }
        queDO.setUpdateBy(userId);
        queDO.setUpdateAt(new Date());
        queDO.setIsHide(1);
        if (questnaireDAO.updateById(queDO) > 0) {
            return R.ok();
        } else {
            return R.fail();
        }
    }

    @Override
    public R statQuestnaire(Long questId) {
        ComActQuestnaireDO comActQuestnaireDO = questnaireDAO.selectOne(new QueryWrapper<ComActQuestnaireDO>().lambda()
            .eq(ComActQuestnaireDO::getId, questId).eq(ComActQuestnaireDO::getIsHide, 0));

        if (comActQuestnaireDO == null) {
            return R.fail("问卷已删除!");
        }

        QuestnaireAnswerStatVO usersAnswerStatVO = new QuestnaireAnswerStatVO();
        // 问卷信息
        ComActQuestnaireVO comActQuestnaireVO = new ComActQuestnaireVO();
        BeanUtils.copyProperties(comActQuestnaireDO, comActQuestnaireVO);
        usersAnswerStatVO.setQuestnaire(comActQuestnaireVO);

        // 问卷题目列表
        List<ComActQuestnaireSubDO> comActQuestnaireSubDOList = questnaireSubDAO.selectList(
            new QueryWrapper<ComActQuestnaireSubDO>().lambda().eq(ComActQuestnaireSubDO::getQueId, questId));
        // 题目统计信息
        List<UserSubAnswerSelectionStatVO> usearSubAnswerSelectionStatVOList =
            questnaireAnswerContentDAO.selectQuestnaireStat(questId);

        List<UsersSubAnswerStatVO> usersSubAnswerStatVOList = new ArrayList<>();

        comActQuestnaireSubDOList.forEach(comActQuestnaireSubDO -> {
            UsersSubAnswerStatVO usersSubAnswerStatVO = new UsersSubAnswerStatVO();

            ComActQuestnaireSubVO comActQuestnaireSubVO = new ComActQuestnaireSubVO();
            BeanUtils.copyProperties(comActQuestnaireSubDO, comActQuestnaireSubVO);
            usersSubAnswerStatVO.setQuestSubVO(comActQuestnaireSubVO);

            List<UserSubAnswerSelectionStatVO> userSubAnswerSelectionStatVOList = new ArrayList<>();
            usersSubAnswerStatVO.setTotal(0);

            usearSubAnswerSelectionStatVOList.forEach(stat -> {
                if (stat.getSubId().equals(comActQuestnaireSubDO.getId()) && stat.getTotal() > 0) {
                    userSubAnswerSelectionStatVOList.add(stat);
                }
            });
            usersSubAnswerStatVO.setUsersAnswer(userSubAnswerSelectionStatVOList);
            Integer count = questnaireAnswerContentDAO
                .selectCount(new QueryWrapper<ComActQuestnaireAnswerContentDO>().select(" DISTINCT sub_id, user_id ")
                    .lambda().eq(ComActQuestnaireAnswerContentDO::getSubId, comActQuestnaireSubDO.getId()));
            usersSubAnswerStatVO.setTotal(count);
            usersSubAnswerStatVOList.add(usersSubAnswerStatVO);
        });
        usersAnswerStatVO.setUsersSubAnswerStat(usersSubAnswerStatVOList);
        return R.ok(usersAnswerStatVO);
    }

    @Override
    public R infoQuestnaire(Long questId) {
        return answerInfoQuestnaire(null, questId);
    }

    @Override
    public R answerInfoQuestnaire(Long userId, Long questId) {
        ComActQuestnaireDO comActQuestnaireDO = questnaireDAO.selectOne(new QueryWrapper<ComActQuestnaireDO>().lambda()
            .eq(ComActQuestnaireDO::getId, questId).eq(ComActQuestnaireDO::getIsHide, 0));
        if (comActQuestnaireDO == null) {
            return R.fail("问卷不存在!");
        }

        UsersAnswerVO usersAnswerVO = new UsersAnswerVO();
        ComActQuestnaireVO comActQuestnaireVO = new ComActQuestnaireVO();
        BeanUtils.copyProperties(comActQuestnaireDO, comActQuestnaireVO);
        usersAnswerVO.setQuestnaire(comActQuestnaireVO);

        List<ComActQuestnaireSubDO> list = questnaireSubDAO.selectList(
            new QueryWrapper<ComActQuestnaireSubDO>().lambda().eq(ComActQuestnaireSubDO::getQueId, questId));
        list.sort(Comparator.comparing(ComActQuestnaireSubDO::getSort));
        List<UsersSubAnswerVO> usersSubAnswerVOList = new ArrayList<>();

        list.forEach(comActQuestnaireSubDO -> {
            UsersSubAnswerVO usersSubAnswerVO = new UsersSubAnswerVO();
            // 问卷调查题目
            ComActQuestnaireSubVO comActQuestnaireSubVO = new ComActQuestnaireSubVO();
            BeanUtils.copyProperties(comActQuestnaireSubDO, comActQuestnaireSubVO);
            usersSubAnswerVO.setQuestSubVO(comActQuestnaireSubVO);

            // 问卷调查题目-选项
            Long subId = comActQuestnaireSubDO.getId();
            List<ComActQuestnaireSubSelectionDO> comActQuestnaireSubSelectionDOs =
                questnaireSubSelectionDAO.selectList(new QueryWrapper<ComActQuestnaireSubSelectionDO>().lambda()
                    .eq(ComActQuestnaireSubSelectionDO::getQueSubId, subId));

            List<ComActQuestnaireSubSelectionVO> comActQuestnaireSubSelectionVOs = new ArrayList<>();
            comActQuestnaireSubSelectionDOs.forEach(comActQuestnaireSubSelectionDO -> {
                ComActQuestnaireSubSelectionVO comActQuestnaireSubSelectionVO = new ComActQuestnaireSubSelectionVO();
                BeanUtils.copyProperties(comActQuestnaireSubSelectionDO, comActQuestnaireSubSelectionVO);
                comActQuestnaireSubSelectionVOs.add(comActQuestnaireSubSelectionVO);
            });
            usersSubAnswerVO.setQuestSelectionList(comActQuestnaireSubSelectionVOs);
            // 用户回答
            if (userId != null) {
                List<ComActQuestnaireAnswerContentDO> questnaireAnswerContentDOList =
                    questnaireAnswerContentDAO.selectList(new QueryWrapper<ComActQuestnaireAnswerContentDO>().lambda()
                        .eq(ComActQuestnaireAnswerContentDO::getUserId, userId)
                        .eq(ComActQuestnaireAnswerContentDO::getSubId, subId));

                List<ComActQuestnaireAnswerContentVO> questnaireAnswerContentVOList = new ArrayList<>();
                questnaireAnswerContentDOList.forEach(questnaireAnswerContentDO -> {
                    ComActQuestnaireAnswerContentVO comActQuestnaireSubSelectionVO =
                        new ComActQuestnaireAnswerContentVO();
                    BeanUtils.copyProperties(questnaireAnswerContentDO, comActQuestnaireSubSelectionVO);
                    questnaireAnswerContentVOList.add(comActQuestnaireSubSelectionVO);
                });

                usersSubAnswerVO.setUsersAnswer(questnaireAnswerContentVOList);
            }
            usersSubAnswerVOList.add(usersSubAnswerVO);
        });
        usersAnswerVO.setUsersSubAnswer(usersSubAnswerVOList);

        return R.ok(usersAnswerVO);
    }

    @Override
    public R answerResultList(Long questId) {
        QuestnaireAnswersDTO questnaireAnswersDTO = new QuestnaireAnswersDTO();
        /**
         * 查询题目
         */
        List<ComActQuestnaireSubDO> list = questnaireSubDAO.selectList(
            new QueryWrapper<ComActQuestnaireSubDO>().lambda()
                    .eq(ComActQuestnaireSubDO::getQueId, questId).orderByAsc(ComActQuestnaireSubDO::getCreateAt));
        List<ComActQuestnaireSubVO> listSubVo = new ArrayList<>();
        list.forEach(subDo -> {
            if(!subDo.getType().equals(ComActQuestnaireSubDO.type.describe)){
                ComActQuestnaireSubVO comActQuestnaireSubVO = new ComActQuestnaireSubVO();
                BeanUtils.copyProperties(subDo, comActQuestnaireSubVO);
                listSubVo.add(comActQuestnaireSubVO);
            }
        });
        questnaireAnswersDTO.setSubs(listSubVo);
        /**
         * 查询用户回答
         */
        List<ComActQuestnaireAnswerContentVO> questnaireAnswerContentDOList =
            questnaireAnswerContentDAO.selectListByQuestnaire(questId);
        questnaireAnswersDTO.setAnswers(questnaireAnswerContentDOList);

        return R.ok(questnaireAnswersDTO);
    }

    @Override
    public R qaQeustDetails(PageQuestnaireSubDetailsDTO pageQuestnaireSubDetailsDTO) {
        Page userPage = new Page(pageQuestnaireSubDetailsDTO.getPageNum(), pageQuestnaireSubDetailsDTO.getPageSize());
        IPage<ComActQuestnaireAnswerContentVO> doPager =
            questnaireAnswerContentDAO.selectVoByPage(userPage, pageQuestnaireSubDetailsDTO);
        return R.ok(doPager);
    }

    @Override
    public R pageQuestnaireAnswer(PageQuestnaireAnswerDTO pageQuestnaireAnswerDTO) {
        if (pageQuestnaireAnswerDTO.getPageNum() == null || pageQuestnaireAnswerDTO.getPageNum().longValue() == 0) {
            pageQuestnaireAnswerDTO.setPageNum(1L);
        }
        if (pageQuestnaireAnswerDTO.getPageSize() == null || pageQuestnaireAnswerDTO.getPageSize().longValue() == 0) {
            pageQuestnaireAnswerDTO.setPageSize(10L);
        }
        Page userPage = new Page(pageQuestnaireAnswerDTO.getPageNum(), pageQuestnaireAnswerDTO.getPageSize());
        IPage<ComActQuestnaireAnswerContentVO> doPager =
            questnaireAnswerContentDAO.selectAnswersByPage(userPage, pageQuestnaireAnswerDTO);
        return R.ok(doPager);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public R usersAnsweQuestnaire(UsersAnswerQuestnaireVO answerQuestnaireVO) {
        if (answerQuestnaireVO == null || answerQuestnaireVO.getJsonObject() == null) {
            return R.fail("数据为空！");
        }
        Long userId = answerQuestnaireVO.getUserId();
        Long questId = answerQuestnaireVO.getQuestId();
        Date nowDate = new Date();

        ComActQuestnaireDO questnaireDO = questnaireDAO.selectById(questId);
        if (questnaireDO == null) {
            return R.fail("调查问卷不存在！");
        }

        if (!questnaireDO.getState().equals(ComActQuestnaireDO.state.dyz)) {
            return R.fail("该调查问卷已结束，不可提交！");
        }

        ComActQuestnaireUserAnswerDO oldUserAnswerDO =
            comActQuestnaireUserAnswerMapper.selectOne(new QueryWrapper<ComActQuestnaireUserAnswerDO>().lambda()
                .eq(ComActQuestnaireUserAnswerDO::getQuestnaireId, questId)
                .eq(ComActQuestnaireUserAnswerDO::getUserId, userId));
        if (oldUserAnswerDO != null) {
            return R.fail("您已填写该问卷，不可重复提交");
        }

        // 查询填报人员信息
        R<LoginUserInfoVO> userResult = userService.getUserInfoByUserId(userId + "");
        if (!R.isOk(userResult)) {
            log.error("填写问卷调查失败，未查询到用户信息");
            return R.fail("填写失败");
        }
        LoginUserInfoVO userInfo = userResult.getData();
        if (questnaireDO.getForParty().equals(ComActQuestnaireDO.isOk.yes)) {
            if (!userInfo.getIsPartymember().equals(1)) {
                return R.fail("您还未进行党员认证，无法填报");
            }
        }
        if (questnaireDO.getForVolunteer().equals(ComActQuestnaireDO.isOk.yes)) {
            if (!userInfo.getIsVolunteer().equals(1)) {
                return R.fail("您还未进行志愿者认证，无法填报");
            }
        }

        List<ComActQuestnaireAnswerContentDO> answerContentList = new ArrayList<>();

        // 解析用户上传json数据
        List<QuestnaiteSubVO> questnaiteSubVOS =
            JSON.parseArray(answerQuestnaireVO.getJsonObject(), QuestnaiteSubVO.class);
        if (!questnaiteSubVOS.isEmpty()) {
            for (QuestnaiteSubVO questnaiteSub : questnaiteSubVOS) {
                // 查询用户填写题目
                ComActQuestnaireSubDO questnaireSubDO = questnaireSubDAO.selectOne(
                    new QueryWrapper<ComActQuestnaireSubDO>().lambda().eq(ComActQuestnaireSubDO::getQueId, questId)
                        .eq(ComActQuestnaireSubDO::getKey, questnaiteSub.getKey()));
                if (questnaireSubDO == null) {
                    log.error("未查询到调查问卷题目，题目名称：" + questnaiteSub.getLabel() + "题目key：" + questnaiteSub.getKey());
                    continue;
                }

                Long queSubId = questnaireSubDO.getId();
                // 根据上传的类型查询不同的题目选项
                if (questnaiteSub.getType().equals(QuestnaiteSubVO.type.danxuan) || questnaiteSub.getType().equals(QuestnaiteSubVO.type.imgselect)) {
                    // 单选题处理
                    ComActQuestnaireSubSelectionDO subSelectionDO =
                        questnaireSubSelectionDAO.selectOne(new QueryWrapper<ComActQuestnaireSubSelectionDO>().lambda()
                            .eq(ComActQuestnaireSubSelectionDO::getQueSubId, queSubId)
                            .eq(ComActQuestnaireSubSelectionDO::getQueId, questId)
                            .eq(ComActQuestnaireSubSelectionDO::getKey, questnaiteSub.getValues()));
                    if (subSelectionDO == null) {
                        log.error("未查询到调查问卷选项，题目名称：" + questnaiteSub.getLabel() + "选项key：" + questnaiteSub.getValues());
                        continue;
                    }

                    ComActQuestnaireAnswerContentDO answerContentDO = new ComActQuestnaireAnswerContentDO();
                    answerContentDO.setUserId(userId);
                    answerContentDO.setCreateAt(nowDate);
                    answerContentDO.setCreateBy(userId);
                    answerContentDO.setSelectionId(subSelectionDO.getId());
                    answerContentDO.setSubId(queSubId);
                    answerContentDO.setType(1);
                    answerContentDO.setChoice(subSelectionDO.getOptionName());
                    answerContentDO.setAnswerContent(subSelectionDO.getContent());
                    answerContentList.add(answerContentDO);
                } else if (questnaiteSub.getType().equals(QuestnaiteSubVO.type.duoxuan)) {
                    // 多选题处理
                    String values = questnaiteSub.getValues();
                    String[] value = values.split(",");
                    for (int i = 0; i < value.length; i++) {
                        ComActQuestnaireSubSelectionDO subSelectionDO =
                            questnaireSubSelectionDAO.selectOne(new QueryWrapper<ComActQuestnaireSubSelectionDO>()
                                .lambda().eq(ComActQuestnaireSubSelectionDO::getQueSubId, queSubId)
                                .eq(ComActQuestnaireSubSelectionDO::getQueId, questId)
                                .eq(ComActQuestnaireSubSelectionDO::getKey, value[i]));
                        if (subSelectionDO == null) {
                            log.error(
                                "未查询到调查问卷选项，题目名称：" + questnaiteSub.getLabel() + "选项key：" + questnaiteSub.getValues());
                            continue;
                        }
                        ComActQuestnaireAnswerContentDO answerContentDO = new ComActQuestnaireAnswerContentDO();
                        answerContentDO.setUserId(userId);
                        answerContentDO.setCreateAt(nowDate);
                        answerContentDO.setCreateBy(userId);
                        answerContentDO.setSelectionId(subSelectionDO.getId());
                        answerContentDO.setSubId(queSubId);
                        answerContentDO.setType(1);
                        answerContentDO.setChoice(subSelectionDO.getOptionName());
                        answerContentDO.setAnswerContent(subSelectionDO.getContent());
                        answerContentList.add(answerContentDO);
                    }
                } else {
                    // 问答题处理
                    String values = questnaiteSub.getValues();
                    ComActQuestnaireAnswerContentDO answerContentDO = new ComActQuestnaireAnswerContentDO();
                    answerContentDO.setUserId(userId);
                    answerContentDO.setCreateAt(nowDate);
                    answerContentDO.setCreateBy(userId);
                    answerContentDO.setSubId(queSubId);
                    answerContentDO.setType(2);
                    answerContentDO.setAnswerContent(values);
                    answerContentList.add(answerContentDO);
                }
            }
        }
        // 新增用户填写的答卷
        if (!answerContentList.isEmpty()) {
            // 更新回答用户数量
            Integer joinCount = questnaireDO.getJoinCount();
            questnaireDO.setJoinCount(joinCount != null ? joinCount + 1 : 1);
            questnaireDAO.updateById(questnaireDO);

            // 新增用户答题记录
            ComActQuestnaireUserAnswerDO userAnswerDO = new ComActQuestnaireUserAnswerDO();
            userAnswerDO.setQuestnaireId(questId);
            userAnswerDO.setUserId(userId);
            userAnswerDO.setCreateAt(nowDate);
            userAnswerDO.setJsonObject(answerQuestnaireVO.getJsonObject());
            comActQuestnaireUserAnswerMapper.insert(userAnswerDO);

            answerContentList.forEach(answerContent -> {
                answerContent.setAnswerId(userAnswerDO.getId());
            });
            answerContentService.saveBatch(answerContentList);

        }
        return R.ok();
    }

    /**
     * 社区后台-查询问卷调查详情
     * 
     * @param questId
     *            问卷id
     * @return 问卷调查详情
     */
    @Override
    public R getQuesDetailAdmin(Long questId) {
        QuestnaireDetailAdminVO result = questnaireDAO.getQuesDetailAdmin(questId);
        if (result == null) {
            return R.fail("未查询到该记录");
        }
        return R.ok(result);
    }

    /**
     * 小程序-问卷调查详情
     * 
     * @param userId
     *            用户id
     * @param questId
     *            问卷id
     * @return 问卷调查详情
     */
    @Override
    public R getQuesDetail(Long questId, Long userId) {
        QuestnaireDetailAdminVO result = questnaireDAO.getQuesDetail(questId, userId);
        if (result == null) {
            return R.fail("未查询到该记录");
        }
        ComActQuestnaireUserAnswerDO oldUserAnswerDO =
            comActQuestnaireUserAnswerMapper.selectOne(new QueryWrapper<ComActQuestnaireUserAnswerDO>().lambda()
                .eq(ComActQuestnaireUserAnswerDO::getQuestnaireId, questId)
                .eq(ComActQuestnaireUserAnswerDO::getUserId, userId));
        if (oldUserAnswerDO != null) {
            result.setIsOk(1);
        }

        return R.ok(result);
    }

    /**
     * 问卷调查统计汇总
     * 
     * @param summaryDTO
     *            请求参数
     * @return 统计汇总
     */
    @Override
    public R statisticsSummary(StatisticsSummaryDTO summaryDTO) {
        IPage<QuestnaireStatisticsSummaryAdminVO> summaryAdminList = questnaireDAO
            .getStatisticsSummaryAdmin(new Page(summaryDTO.getPageNum(), summaryDTO.getPageSize()), summaryDTO);
        summaryAdminList.getRecords().forEach(summary -> {
            if (summary.getAllCount().equals(0)) {
                summary.setTag(BigDecimal.ZERO);
            } else {
                summary.setTag(BigDecimal.valueOf(summary.getCount())
                    .divide(BigDecimal.valueOf(summary.getAllCount()), 2, RoundingMode.HALF_UP)
                    .multiply(BigDecimal.valueOf(100)));
            }
        });
        return R.ok(summaryAdminList);
    }

    /**
     * 问卷调查统计汇总导出数据查询
     * 
     * @param questId
     *            调查问卷id
     * @return 调查统计汇总导出数据
     */
    @Override
    public R statisticsSummaryExport(Long questId) {
        List<QuestnaireStatisticsSummaryExcelAdminVO> summaryExcelList =
            questnaireDAO.getStatisticsSummaryExcelAdmin(questId);
        summaryExcelList.forEach(summary -> {
            if (summary.getAllCount().equals(0)) {
                summary.setTag(BigDecimal.ZERO);
            } else {
                summary.setTag(BigDecimal.valueOf(summary.getCount())
                    .divide(BigDecimal.valueOf(summary.getAllCount()), 2, RoundingMode.HALF_UP)
                    .multiply(BigDecimal.valueOf(100)));
            }
        });
        return R.ok(summaryExcelList);
    }

    /**
     * 问卷调查统计汇总表头统计
     * 
     * @param questId
     *            调查问卷id
     * @return 问卷调查统计汇总表头统计数据
     */
    @Override
    public R statisticsSummaryHeader(Long questId, Long communityId) {
        QuestnaireStatisticsSummaryHeaderAdminVO summaryHeaderAdminVO =
            this.questnaireDAO.statisticsSummaryHeader(questId, communityId);
        if (summaryHeaderAdminVO != null) {
            if (!summaryHeaderAdminVO.getUserCount().equals(0)) {
                BigDecimal nub1 = BigDecimal.valueOf(summaryHeaderAdminVO.getAllCount());
                BigDecimal nub2 = BigDecimal.valueOf(summaryHeaderAdminVO.getUserCount());
                BigDecimal result = nub1.divide(nub2, 2, RoundingMode.HALF_UP).multiply(BigDecimal.valueOf(100));
                summaryHeaderAdminVO.setTag(result);
            }
        }
        return R.ok(summaryHeaderAdminVO);
    }

    /**
     * 定时任务检测待发布，调研中的问卷调查状态
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public R timedTaskQuestionnaire() {
        Date nowDate = new Date();
        // 查询所有开始时间已经超过当前时间的待发布状态调查问卷
        List<ComActQuestnaireDO> questnaireDOList = questnaireDAO.selectList(new QueryWrapper<ComActQuestnaireDO>()
            .lambda().eq(ComActQuestnaireDO::getState, ComActQuestnaireDO.state.dfb)
            .eq(ComActQuestnaireDO::getIsHide, 0).le(ComActQuestnaireDO::getStartTime, nowDate));
        questnaireDOList.forEach(questnaire -> {
            questnaire.setState(ComActQuestnaireDO.state.dyz);
            questnaire.setPublishTime(nowDate);
            questnaireDAO.updateById(questnaire);
        });

        // 查询所有结束时间已经超过当前时间的调研中状态调查问卷
        List<ComActQuestnaireDO> questnaireList = questnaireDAO.selectList(new QueryWrapper<ComActQuestnaireDO>()
            .lambda().eq(ComActQuestnaireDO::getState, ComActQuestnaireDO.state.dyz)
            .eq(ComActQuestnaireDO::getIsHide, 0).le(ComActQuestnaireDO::getEndTime, nowDate));
        questnaireList.forEach(questnaire -> {
            questnaire.setState(ComActQuestnaireDO.state.yjs);
            questnaireDAO.updateById(questnaire);
        });
        return R.ok();
    }

    /**
     * 小程序-新增问卷调查浏览数量
     * 
     * @param questId
     *            问卷调查id
     * @return 增加结果
     */
    @Override
    public R addQuestnaireView(Long questId) {
        ComActQuestnaireDO questnaireDO = questnaireDAO.selectById(questId);
        if (questnaireDO != null) {
            questnaireDO.setViewNum(questnaireDO.getViewNum() + 1);
            questnaireDAO.updateById(questnaireDO);
        }
        return R.ok();
    }

    /**
     * 小程序-用户弹窗添加不在提醒接口
     * 
     * @param questId
     *            问卷id
     * @param userId
     *            用户id
     * @return 添加结果
     */
    @Override
    public R addNoNotice(Long questId, Long userId) {
        questnaireDAO.addNoNotice(questId, userId);
        return R.ok();
    }

}