package kr.wisestone.owl.service.impl;

import com.google.common.collect.Lists;
import kr.wisestone.owl.common.ExcelConditionCheck;
import kr.wisestone.owl.constant.Constants;
import kr.wisestone.owl.constant.MngPermission;
import kr.wisestone.owl.constant.MsgConstants;
import kr.wisestone.owl.domain.Guide;
import kr.wisestone.owl.domain.User;
import kr.wisestone.owl.domain.UserLevel;
import kr.wisestone.owl.exception.OwlRuntimeException;
import kr.wisestone.owl.mapper.GuideMapper;
import kr.wisestone.owl.repository.GuideRepository;
import kr.wisestone.owl.service.GuideService;
import kr.wisestone.owl.service.UserLevelService;
import kr.wisestone.owl.service.UserWorkspaceService;
import kr.wisestone.owl.service.WorkspaceService;
import kr.wisestone.owl.util.CommonUtil;
import kr.wisestone.owl.util.ConvertUtil;
import kr.wisestone.owl.vo.*;
import kr.wisestone.owl.web.condition.GuideCondition;
import kr.wisestone.owl.web.condition.NoticeCondition;
import kr.wisestone.owl.web.form.GuideForm;
import kr.wisestone.owl.web.form.NoticeForm;
import kr.wisestone.owl.web.view.ExcelView;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.ui.Model;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service
public class GuideServiceImpl extends AbstractServiceImpl<Guide, Long, JpaRepository<Guide, Long>> implements GuideService {

    @Autowired
    private GuideRepository guideRepository;

    @Autowired
    private GuideMapper guideMapper;

    @Autowired
    private WorkspaceService workspaceService;

    @Autowired
    private ExcelView excelView;

    @Autowired
    private ExcelConditionCheck excelConditionCheck;

    @Autowired
    private UserLevelService userLevelService;

    @Autowired
    private UserWorkspaceService userWorkspaceService;

    @Override
    protected JpaRepository<Guide, Long> getRepository() {
        return this.guideRepository;
    }

    //  guide 등록
    @Override
    @Transactional
    public Guide addGuide(GuideForm guideForm) {
        //  guide 제목 및 내용 공백 체크
        this.verifyTitleAndDescription(guideForm.getTitle(), guideForm.getDescription());

        guideForm.setStatus(Guide.INACTIVATION);
        Guide guide = ConvertUtil.copyProperties(guideForm, Guide.class);

        return this.guideRepository.saveAndFlush(guide);
    }

    //  guide 제목 및 내용 공백 체크
    private void verifyTitleAndDescription(String title, String description) {
        if (StringUtils.isEmpty(title) || StringUtils.isEmpty(description)) {
            throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.GUIDE_EMPTY_CONTENT));
        }
    }

    //  guide 조회
    @Override
    @Transactional(readOnly = true)
    public List<GuideVo> findGuide(Map<String, Object> resJsonData,
                                   GuideCondition guideCondition, Pageable pageable) {

        guideCondition.setPage(pageable.getPageNumber() * pageable.getPageSize());
        guideCondition.setPageSize(pageable.getPageSize());
        guideCondition.setTitle(guideCondition.getTitle());

        User user = this.webAppUtil.getLoginUserObject();
        UserLevel userLevel = this.userLevelService.getUserLevel(user.getUserLevel().getId());

        List<Map<String, Object>> results = Lists.newArrayList();
        Long totalCount = 0L;
        if (this.userWorkspaceService.checkWorkspaceManager(user)
                || MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_GUIDE)) {
            results = this.guideMapper.find(guideCondition);
            totalCount = this.guideMapper.count(guideCondition);
        } else {
            results = this.guideMapper.findNotActivation(guideCondition);
            totalCount = this.guideMapper.countNotActivation(guideCondition);
        }
        int totalPage = (int) Math.ceil((totalCount - 1) / pageable.getPageSize()) + 1;
        List<GuideVo> guideVos = ConvertUtil.convertListToListClass(results, GuideVo.class);

        for (GuideVo guideVo : guideVos) {
            Boolean bActivation = false;

            if(guideVo.getStatus().equals(Guide.ACTIVATION)) {
                bActivation = true;
            }
            guideVo.activation =  bActivation;
        }

        resJsonData.put(Constants.RES_KEY_CONTENTS, guideVos);
        resJsonData.put(Constants.REQ_KEY_PAGE_VO, new ResPage(pageable.getPageNumber(), pageable.getPageSize(),
                totalPage, totalCount));

        return guideVos;
    }

    //  guide 수정
    @Override
    @Transactional
    public Guide modifyGuide(GuideForm guideForm) {
        //  guide 제목 및 내용 공백 체크
        this.verifyTitleAndDescription(guideForm.getTitle(), guideForm.getDescription());

        Guide guide = this.getGuide(guideForm.getId());
        ConvertUtil.copyProperties(guideForm, guide, "id");

        return this.guideRepository.saveAndFlush(guide);
    }

    //  guide 수정
    @Override
    @Transactional
    public Guide activeGuide(GuideForm guideForm) {

        boolean bActivation = guideForm.getActivation();

        if(bActivation) {
            guideForm.setStatus(Guide.ACTIVATION);
        } else {
            guideForm.setStatus(Guide.INACTIVATION);
        }

        Guide guide = this.getGuide(guideForm.getId());
        ConvertUtil.copyProperties(guideForm, guide, "id");

        if(bActivation) {
            this.guideRepository.updateInActivation(guideForm.getId());
        }

        return this.guideRepository.saveAndFlush(guide);
    }

    //  guide을 id 로 조회한다.
    @Override
    @Transactional(readOnly = true)
    public Guide getGuide(Long id) {
        if (id == null) {
            throw new OwlRuntimeException(
                    this.messageAccessor.getMessage(MsgConstants.GUIDE_NOT_EXIST));
        }

        Guide guide = this.findOne(id);

        if (guide == null) {
            throw new OwlRuntimeException(
                    this.messageAccessor.getMessage(MsgConstants.GUIDE_NOT_EXIST));
        }

        return guide;
    }

    //  guide 상세 정보를 조회한다.
    @Override
    @Transactional(readOnly = true)
    public void detailGuide(Map<String, Object> resJsonData, GuideCondition guideCondition) {
        GuideVo guideVo = new GuideVo();

        if (guideCondition.getId() != null) {
            Guide guide = this.getGuide(guideCondition.getId());
            guideVo = ConvertUtil.copyProperties(guide, GuideVo.class);
        }

        resJsonData.put(Constants.RES_KEY_CONTENTS, guideVo);
    }

    @Override
    public void remove(GuideForm guideForm) {
        if (guideForm.getRemoveIds().size() < 1) {
            throw new OwlRuntimeException(
                    this.messageAccessor.getMessage(MsgConstants.COMPANY_REMOVE_NOT_SELECT));
        }
        for (Long id : guideForm.getRemoveIds()) {
            this.guideRepository.deleteById(id);
            this.guideRepository.flush();
        }
    }

    @Override
    public ModelAndView downloadExcel(HttpServletRequest request, Model model) {
        ModelAndView modelAndView = this.workspaceService.checkUseExcelDownload(model);
        if (modelAndView != null) {
            return modelAndView;
        }

        Map<String, Object> conditions = new HashMap<>();
        //  엑셀 다운로드에 필요한 검색 조건 정보를 추출하고 검색 조건 추출에 오류가 발생하면 경고를 표시해준다.
        modelAndView = this.excelConditionCheck.checkCondition(conditions, request, model);
        if (modelAndView != null) {
            return modelAndView;
        }

        GuideCondition guideCondition = GuideCondition.make(conditions);
        List<Map<String, Object>> results = this.guideMapper.find(guideCondition);
        List<GuideVo> guideVos = ConvertUtil.convertListToListClass(results, GuideVo.class);

        // code_ko_KR 에 code명 설정
        ExportExcelVo excelInfo = new ExportExcelVo();
        excelInfo.setFileName(this.messageAccessor.message("가이드 목록"));
        excelInfo.addAttrInfos(new ExportExcelAttrVo("title", this.messageAccessor.message("guide.title"), 6, ExportExcelAttrVo.ALIGN_CENTER));
        excelInfo.addAttrInfos(new ExportExcelAttrVo("registerDate", this.messageAccessor.message("guide.registerDate"), 10, ExportExcelAttrVo.ALIGN_CENTER));
        excelInfo.addAttrInfos(new ExportExcelAttrVo("writer", this.messageAccessor.message("guide.registerId"), 10, ExportExcelAttrVo.ALIGN_CENTER));

        excelInfo.setDatas(guideVos);

        model.addAttribute(Constants.EXCEL, excelInfo);
        return new ModelAndView(this.excelView);
    }
}