package com.zy.acs.manager.manager.controller.utils;

import com.alibaba.excel.EasyExcel;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.google.common.collect.Lists;
import com.zy.acs.common.utils.Utils;
import com.zy.acs.manager.common.annotation.OperationLog;
import com.zy.acs.manager.manager.entity.Code;
import com.zy.acs.manager.manager.entity.Loc;
import com.zy.acs.manager.manager.service.CodeGapService;
import com.zy.acs.manager.manager.service.CodeService;
import com.zy.acs.manager.manager.service.LocService;
import com.zy.acs.manager.manager.service.RouteService;
import com.zy.acs.manager.system.controller.BaseController;
import io.swagger.annotations.Api;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.util.List;
import java.util.Map;

/**
 * Created by vincent on 2023/6/12
 */
@Api(tags = "Utils Api")
@RestController
@RequestMapping("/api/file")
public class UtilsController extends BaseController {

    @Autowired
    private RouteService routeService;

    @Autowired
    private LocService locService;

    @Autowired
    private CodeService codeService;

    @Autowired
    private CodeGapService codeGapService;

    /**
     * 文件上传
     * <p>
     * 1. 创建excel对应的实体对象 参照{@link Map<Integer, String>}
     * <p>
     * 2. 由于默认一行行的读取excel，所以需要创建excel一行一行的回调监听器，参照{@link MapDataListener}
     * <p>
     * 3. 直接读即可
     */
    @RequestMapping("/excel/map/import")
    @ResponseBody
    @OperationLog("import map data")
    public String upload(MultipartFile file) throws IOException {
        EasyExcel.read(file.getInputStream(), new MapDataListener(routeService, codeService, codeGapService)).sheet().doRead();
        return "success";
    }


    private List<Integer> starts = Lists.newArrayList(7, 62, 126, 182, 237, 292, 347, 436, 525, 614, 793, 882, 970, 1059, 1148, 1324, 1416, 1505);

    private int d = 10;

    private int d2 = 5;

    private List<Integer> starts2 = Lists.newArrayList(389, 478, 567, 656,835, 923, 1012, 1101, 1190, 1366, 1458, 1547);


    @RequestMapping("/loc")
    @ResponseBody
    @OperationLog("import map data")
    public String loc() {
        List<Loc> list = locService.list(new LambdaQueryWrapper<Loc>().orderByAsc(Loc::getRow).orderByAsc(Loc::getBay).orderByAsc(Loc::getLev));
        for (Loc loc : list) {
            if (loc.getBay() == 24||loc.getBay() == 8||loc.getBay() == 16) {
                Integer i = starts.get((loc.getRow() - 1) / 2);
                Code cacheByData = codeService.getCacheByData(Utils.zeroFill(((loc.getBay()-1)%8 + i + (loc.getBay()-1) / 8 * 10) + "", 8));
                loc.setCode(cacheByData.getId());
                locService.updateById(loc);
            }
//            if (loc.getBay() > 24 && loc.getBay() <= 32) {
//                Integer i = starts.get((loc.getRow() - 1)  / 2) + 30;
//                Code cacheByData = codeService.getCacheByData(Utils.zeroFill(((loc.getBay() - 24)%4-1 + i + (loc.getBay() - 24) / 4 * 6) + "", 8));
//                loc.setCode(cacheByData.getId());
//                locService.updateById(loc);
//            }
//            if (loc.getBay() > 32) {
//                Integer i = starts2.get((loc.getRow() - 13) / 2);
//                if (i==656){
//                    Code cacheByData = codeService.getCacheByData(Utils.zeroFill((Utils.zeroFill((((loc.getBay()-1) % 8) + i + (((loc.getBay()-1) / 8) - 4) * 10) + "", 8)) + "", 8));
//                    loc.setCode(cacheByData.getId());
//                    locService.updateById(loc);
//                }
//            }
        }
        return "success";
    }
}