package com.jevon.service.impl;

import com.jevon.mapper.LeagueMapper;
import com.jevon.model.League;
import com.jevon.service.LeagueService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;

/**
 * @author chen
 * @version 1.0
 * @date 2019/10/22 0022 9:09
 */
@Service
public class LeagueServiceImpl implements LeagueService {

    @Autowired
    LeagueMapper leagueMapper;

    @Override
    public int insertBatch(List<League> list) {

        return leagueMapper.insertBatch(list);
    }

    @Override
    public int update(int id, String league) {

        League update = new League();
        update.setId(id);
        update.setLeague(league);

        return leagueMapper.update(update);
    }

    @Override
    public List<League> selectByAnalyseId(int analyseId) {
        League league = new League();
        league.setAnalyseId(analyseId);
        return leagueMapper.selectByLeague(league);

    }

    @Override
    public List<String> getLeagueBySchoolName(int analyseId, String schoolName) {
        League league = new League();
        league.setAnalyseId(analyseId);

        league.setSchoolName(schoolName);
        List<League> leagues = leagueMapper.selectByLeague(league);
        if(leagues != null && leagues.size() > 0){
            League search = new League();
            search.setAnalyseId(analyseId);
            search.setLeague(leagues.get(0).getLeague());
            List<League> result = leagueMapper.selectByLeague(search);
            List<String> leagueSchoolName = new ArrayList<>();
            for(League league1 : result){
                leagueSchoolName.add(league1.getSchoolName());
            }
            return leagueSchoolName ;
        }
        return null;
    }
}