package com.sincere.student.service.impl;

import com.github.pagehelper.PageHelper;
import com.sincere.student.dto.UniversitySearchDto;
import com.sincere.student.mapper.UniversityMajorMapper;
import com.sincere.student.mapper.UniversityMapper;
import com.sincere.student.model.University;
import com.sincere.student.model.UniversityMajor;
import com.sincere.student.service.UniversityService;
import com.sincere.student.utils.Page;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.logging.Handler;

@Service
public class UniversityServiceImpl implements UniversityService {

    @Autowired
    UniversityMapper universityMapper;

    @Autowired
    UniversityMajorMapper universityMajorMapper;


    @Override
    public Page<University> getList(UniversitySearchDto universitySearchDto) {
        Page<University> page = new Page<>(universitySearchDto.getPage(), universitySearchDto.getPageSize());
        PageHelper.startPage(universitySearchDto.getPage(), universitySearchDto.getPageSize());
        if (StringUtils.isNotBlank(universitySearchDto.getSearch())) {
            universitySearchDto.setSearch("%" + universitySearchDto.getSearch() + "%");
        }
        List<University> list = universityMapper.getList(universitySearchDto);
        for (University university : list) {
            university.setMajorList(universityMajorMapper.selectUniversityMajor(university.getId()));
        }
        page.setList(list);
        page.setCount(universityMapper.getListCount(universitySearchDto));
        return page;
    }

    @Override
    public int create(University university) {
        return universityMapper.create(university);
    }

    @Override
    public int delete(int id) {
        universityMajorMapper.deleteByUniversityId(id);
        return universityMapper.delete(id);
    }

    @Override
    public University getById(int id) {
        return universityMapper.getById(id);
    }

    @Override
    public int update(University university) {
        return universityMapper.update(university);
    }

    @Override
    public int addMajor(List<UniversityMajor> list) {
        universityMajorMapper.deleteByUniversityId(list.get(0).getUniversityId());
        List<UniversityMajor> result = new ArrayList<>();
        int i = 0;
        for (UniversityMajor universityMajor : list) {
            i++;
            result.add(universityMajor);
            if (i % 100 == 0) {
                universityMajorMapper.insertBatch(result);
                result = new ArrayList<>();
            }
        }
        if (result.size() > 0) {
            universityMajorMapper.insertBatch(result);
        }
        return 1;
    }

    @Override
    public Integer selectByName(String name) {
        return universityMapper.selectByName(name);
    }

    @Override
    public Integer selectIdByMajor(String major, int id) {
        Map<String, String> map = new HashMap<>();
        map.put("major", major);
        map.put("id", id + "");
        return universityMajorMapper.selectIdByMajor(map);
    }
}