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.MsgConstants;
import kr.wisestone.owl.domain.CompanyField;
import kr.wisestone.owl.domain.CompanyFieldCategory;
import kr.wisestone.owl.domain.HostingField;
import kr.wisestone.owl.domain.IspField;
import kr.wisestone.owl.exception.OwlRuntimeException;
import kr.wisestone.owl.mapper.CompanyFieldCategoryMapper;
import kr.wisestone.owl.mapper.CompanyFieldMapper;
import kr.wisestone.owl.repository.CompanyFieldCategoryRepository;
import kr.wisestone.owl.repository.CompanyFieldRepository;
import kr.wisestone.owl.repository.HostingFieldRepository;
import kr.wisestone.owl.repository.IspFieldRepository;
import kr.wisestone.owl.service.*;
import kr.wisestone.owl.util.ConvertUtil;
import kr.wisestone.owl.vo.*;
import kr.wisestone.owl.web.condition.CompanyFieldCategoryCondition;
import kr.wisestone.owl.web.condition.CompanyFieldCondition;
import kr.wisestone.owl.web.condition.HostingFieldCondition;
import kr.wisestone.owl.web.form.CompanyFieldForm;
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 CompanyFieldCategoryServiceImpl extends AbstractServiceImpl<CompanyFieldCategory, Long, JpaRepository<CompanyFieldCategory, Long>> implements CompanyFieldCategoryService {

    @Autowired
    private CompanyFieldCategoryRepository companyFieldCategoryRepository;

    @Autowired
    private CompanyFieldCategoryMapper companyFieldCategoryMapper;

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

    @Override
    public List<CompanyFieldCategoryVo> find(Map<String, Object> resJsonData, CompanyFieldCategoryCondition condition, Pageable pageable) {
        condition.setPage(pageable.getPageNumber() * pageable.getPageSize());
        condition.setPageSize(pageable.getPageSize());

        List<Map<String, Object>> results = Lists.newArrayList();
        Long totalCount = 0L;

        if (condition.getTypeCategory() != null && !condition.getTypeCategory().equals(""))  {
            if(condition.getTypeCategory().equals("CHILDSECTOR")
                    && (condition.getParentId() == null || condition.getParentId().equals(""))){
                throw new OwlRuntimeException(
                        this.messageAccessor.getMessage(MsgConstants.PARENT_SECTOR_NOT_SELECT));
            }
            results = this.companyFieldCategoryMapper.find(condition);
            totalCount = this.companyFieldCategoryMapper.count(condition);
        }

        return this.convertCompanyFieldCategoryVoToMap(results, totalCount, pageable, resJsonData);
    }

    public CompanyFieldCategory find(Long id) {
        return this.companyFieldCategoryMapper.findById(id);
    }

    //  검색 결과를 Vo 로 변환한다.
    private List<CompanyFieldCategoryVo> convertCompanyFieldCategoryVoToMap(List<Map<String, Object>> results, Long totalCount, Pageable pageable, Map<String, Object> resJsonData) {
        List<CompanyFieldCategoryVo> companyFieldCategoryVos = Lists.newArrayList();

        for (Map<String, Object> result : results) {
            CompanyFieldCategoryVo companyFieldCategoryVo = ConvertUtil.convertMapToClass(result, CompanyFieldCategoryVo.class);
            companyFieldCategoryVos.add(companyFieldCategoryVo);
        }

        int totalPage = (int) Math.ceil((totalCount - 1) / pageable.getPageSize()) + 1;

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

        return companyFieldCategoryVos;
    }
}