package com.lf.server.config;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.OrderItem;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lf.server.entity.all.MenusAuthEntity;
import com.lf.server.entity.all.PermsAuthEntity;
import com.lf.server.entity.all.ResAuthEntity;
import com.lf.server.entity.bd.DlgAgnpEntity;
import com.lf.server.helper.AesHelper;
import com.lf.server.helper.FileHelper;
import com.lf.server.helper.GdalHelper;
import com.lf.server.helper.PathHelper;
import com.lf.server.mapper.bd.DlgAgnpMapper;
import com.lf.server.service.all.BaseQueryService;
import com.lf.server.service.all.PermsService;
import com.lf.server.service.show.LocateService;
import com.lf.server.service.sys.ArgsService;
import com.lf.server.service.sys.BlacklistService;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.ApplicationArguments;
import org.springframework.boot.ApplicationRunner;
import org.springframework.stereotype.Component;

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

/**
 * 初始化完成配置类
 * @author WWW
 */
@Component
public class InitConfig implements ApplicationRunner {
    private final static Log log = LogFactory.getLog(InitConfig.class);

    @Autowired
    PathHelper pathHelper;

    @Autowired
    ArgsService argsService;

    @Autowired
    DlgAgnpMapper dlgAgnpMapper;

    @Autowired
    PermsService permsService;

    @Autowired
    BlacklistService blacklistService;

    @Autowired
    BaseQueryService baseQueryService;

    @Autowired
    LocateService locateService;

    @Override
    public void run(ApplicationArguments args) {
        // noinspection AlibabaRemoveCommentedCode
        try {
            // GDAL测试："E:\\data\\7.Insar\\insartest.tif","E:\\data\\6.高光谱\\GF5_Cut_1.img","E:\\data\\22.tif\\110.747 sq km.tif","E:\\Test\\Test.gdb"
            //GdalHelper.readTif("E:\\data\\7.Insar\\insartest.tif")
            //GdalHelper.readShp("E:\\data\\13.cppe\\shps\\addr.shp");
            //GdalHelper.readGdb("E:\\Test\\addr.gdb");
            //ShpRecord sr = GdalHelper.readShpFirstRecord("D:\\LF\\data\\shp\\extent.shp");

            //com.lf.server.helper.RsaHelper.generate();
            //testMybatisPlus();
            //testAes();
            //testPerms();
            //testBlacklist();

            //boolean f1 = ZipHelper.unzip("D:\\LF\\data\\resources.zip", "D:\\LF\\data\\unzip");
            //boolean f2 = ZipHelper.zip("D:\\LF\\data\\res.zip", "D:\\LF\\data\\unzip\\resources");
            //boolean f3 = Zip4jHelper.zip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\resources", "12345");
            //boolean f4 = Zip4jHelper.unzip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\res", "12345");

            // 初始化
            GdalHelper.init();
            pathHelper.init();
            argsService.initSettingData();

            log.info("***************** 系统启动完毕 *****************" + "\n");
        } catch (Exception ex) {
            log.error(ex.getMessage(), ex);
        }
    }

    private void testMybatisPlus() {
        String s1 = locateService.selectWktById(1);

        String tabName = baseQueryService.getTabName(dlgAgnpMapper);
        List<String> list0 = dlgAgnpMapper.selectFieldFuzzy(tabName, "name", "%县%");

        DlgAgnpEntity dlg = dlgAgnpMapper.selectById(1);
        String wkt = dlgAgnpMapper.selectWktById(tabName, 2);

        Map<String, Object> map = new HashMap<String, Object>(3);
        map.put("gid", 2);
        List<DlgAgnpEntity> list1 = dlgAgnpMapper.selectByMap(map);

        QueryWrapper<DlgAgnpEntity> w1 = new QueryWrapper<>();
        w1.eq("name", "治多县");
        List<DlgAgnpEntity> list2 = dlgAgnpMapper.selectList(w1);

        UpdateWrapper<DlgAgnpEntity> w2 = new UpdateWrapper<DlgAgnpEntity>();
        // 设置更新内容
        w2.set("name", "newName").set("gb", "10013")
                // 设置更新条件
                .eq("gid", 0);
        // dlgAgnpMapper.update(null, w2)

        List<Integer> ids = new ArrayList<Integer>();
        ids.add(1);
        ids.add(2);
        // dlgAgnpMapper.deleteBatchIds(ids)
        List<DlgAgnpEntity> list3 = dlgAgnpMapper.selectBatchIds(ids);

        // dlgAgnpMapper.updateById(dlg)
        // List<DlgAgnp> all = dlgAgnpMapper.selectList(null)

        // 页数 / 每页记录数
        Page<DlgAgnpEntity> page = new Page<>(1, 10);
        // 升序排序
        page.addOrder(OrderItem.asc("gid"));
        // 分页：Wrapper查询条件
        Page<DlgAgnpEntity> userPage = dlgAgnpMapper.selectPage(page, null);
        // 总页数 / 总记录数：325 / 3247
        String str = userPage.getPages() + " / " + userPage.getTotal();
        List<DlgAgnpEntity> list4 = userPage.getRecords();

        QueryWrapper<DlgAgnpEntity> w3 = new QueryWrapper<>();
        w3.like("name", "多").ge("gid", 100);
        List<DlgAgnpEntity> list5 = dlgAgnpMapper.selectList(w3);
    }

    private void testAes() {
        try {
            String content = "POLYGON ((115.94927385452 32.3754479115071 0,121.989371092554 32.2766788010181 0,121.850621222894 29.6874200067864 0,115.9727267226 29.7835368627922 0,115.94927385452 32.3754479115071 0))";
            System.out.println("加密前：" + content);
            String encrypt = AesHelper.encrypt(content);

            System.out.println("加密后：" + encrypt);
            String decrypt = AesHelper.decrypt(encrypt);

            System.out.println("解密后：" + decrypt);
        } catch (Exception ex) {
            log.error(ex.getMessage(), ex);
        }
    }

    private void testPerms() {
        List<ResAuthEntity> raeList = permsService.selectRes("admin");
        List<ResAuthEntity> raeList2 = permsService.selectRes("admin");

        List<MenusAuthEntity> maeList = permsService.selectMenus("admin");
        List<MenusAuthEntity> maeList2 = permsService.selectMenus("admin");

        List<String> pList = permsService.selectPerms("admin");
        List<String> pList2 = permsService.selectPerms("admin");

        List<PermsAuthEntity> pauList = permsService.selectPermsEntity("admin");
        List<PermsAuthEntity> pauList2 = permsService.selectPermsEntity("admin");

        permsService.clearResCache();
        permsService.clearPermsCache();

        raeList = permsService.selectRes("admin");
        maeList = permsService.selectMenus("admin");
        pList = permsService.selectPerms("admin");
        pauList = permsService.selectPermsEntity("admin");
        permsService.clearAllCache();
    }

    private void testBlacklist() {
        List<String> list1 = blacklistService.selectIpList(1);
        List<String> list2 = blacklistService.selectIpList(1);
        List<String> list3 = blacklistService.selectIpList(2);
        List<String> list4 = blacklistService.selectIpList(2);
        blacklistService.clearCache();
        List<String> list5 = blacklistService.selectIpList(1);
    }
}