package com.moon.server.service.all;

import com.moon.server.entity.all.MenusAuthEntity;
import com.moon.server.entity.all.PermsAuthEntity;
import com.moon.server.entity.data.CoordEntity;
import com.moon.server.entity.data.MetaEntity;
import com.moon.server.entity.data.MetaFileEntity;
import com.moon.server.entity.sys.ResEntity;
import com.moon.server.helper.*;
import com.moon.server.service.data.MetaService;
import com.moon.server.service.data.ReadRasterService;
import com.moon.server.service.data.UploadService;
import com.moon.server.service.sys.ArgsService;
import com.moon.server.service.sys.BlacklistService;
import com.moon.server.service.sys.ReportService;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.core.env.Environment;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;
import java.util.Map;

@Service
@SuppressWarnings("AlibabaRemoveCommentedCode")
public class TestService {
    @Resource
    PathHelper pathHelper;

    @Resource
    ArgsService argsService;

    @Resource
    PermsService permsService;

    @Resource
    BlacklistService blacklistService;

    @Resource
    BaseQueryService baseQueryService;

    @Resource
    Environment env;

    @Resource
    ReportService reportService;

    @Resource
    UploadService uploadService;

    @Resource
    MetaService metaService;

    @Resource
    ReadRasterService readRasterService;

    private final static Log log = LogFactory.getLog(TestService.class);

    public void testGdal() {
        GdalHelper.readTif("E:\\data\\7.Insar\\insartest.tif");
        GdalHelper.readShp("E:\\data\\13.cppe\\shps\\addr.shp");
        GdalHelper.readGdb("E:\\Test\\addr.gdb");
        //GdalHelper.readShpFirstRecord("D:\\LF\\data\\shp\\extent.shp");
        RsaHelper.generate();
        //FloatServerController.test();

        testReadExcel();
        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");
    }

    public void testMeta() {
        List<MetaEntity> list = metaService.selectByIdsForTab("1501,1500,1491,1492");
        String sql = metaService.getDelTabsSql(list);
    }

    public void testReadShp() {
        MetaFileEntity mf = new MetaFileEntity();
        //mf.setPath("D:\\model_data\\m_sitepoint.shp");
        mf.setPath("D:\\shpto\\m_sitepoint.shp");
        mf.setEntity("msitepoint");
        mf.setGuid("msitepoint");
        mf.setTab("bs.m_sitepoint");
        mf.setExtName(".shp");

        uploadService.loadSpatialData(mf);
    }

    public 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);
        }
    }

    public void testPerms() {
        List<ResEntity> raeList = permsService.selectRes("admin");
        List<ResEntity> 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();
    }

    public 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);
    }

    public void testReadExcel() {
        List<?> listMdZxcg = ExcelHelper.readExcel(CoordEntity.class, "D:\\LF\\data\\xls\\测绘\\1-项目成果-西三中\\1-1中线成果表\\海原县中线成果表.xlsx");
        int r1 = listMdZxcg.size();

        //List<MdGdcgEntity> listGdcg = ExcelHelper.readExcel(MdGdcgEntity.class, "D:\\LF\\data\\xls\\测绘\\2-地下管线探测成果\\2-2 管线成果表.xlsx");
        //int r2 = listGdcg.size();

        String entityName = "Gxcg";
        String xls = "D:\\LF\\data\\xls\\测绘\\2-地下管线探测成果\\2-2 管线成果表.xlsx";

        String className = "com.moon.server.entity.bs." + entityName;
        Object obj = ClassHelper.createInstance(className);

        List<?> list = ExcelHelper.readExcel(obj.getClass(), xls);
        int r3 = list.size();
    }

    public void testAccess() {
        List<Map<String, Object>> list = AccessHelper.readMdb("D:\\LF\\data\\test.mdb", "", "");
        int count = null == list || list.isEmpty() ? 0 : list.size();
    }

    public void testMd5() {
        try {
            String file = "E:\\data\\mpt\\A4mpt20131125.mpt";

            long stime = System.currentTimeMillis();
            // 2a0befb05146cd30213ee4b95038aca0
            String md51 = FileHelper.getFileMd5(file);
            long etime = System.currentTimeMillis();
            String s1 = String.format("执行时长：%d 毫秒.", (etime - stime));

            stime = System.currentTimeMillis();
            // 2a0befb05146cd30213ee4b95038aca0
            String md52 = FileHelper.getMd5ByJdk(file);
            etime = System.currentTimeMillis();
            String s2 = String.format("执行时长：%d 毫秒.", (etime - stime));

            stime = System.currentTimeMillis();
            // 9f1b7f050f41598710ffc08252484397
            String md53 = FileHelper.getFastMd5(file);
            etime = System.currentTimeMillis();
            String s3 = String.format("执行时长：%d 毫秒.", (etime - stime));

            etime = System.currentTimeMillis();
        } catch (Exception ex) {
            //
        }
    }

    public void testRaster() {
        MetaFileEntity mf1 = new MetaFileEntity();
        readRasterService.readRasterInfo(mf1, "D:\\Moon\\data\\DOM\\Lunar_LRO_LOLA_ClrShade_Global_128ppd_v04_2.tif");

        MetaFileEntity mf2 = new MetaFileEntity();
        readRasterService.readRasterInfo(mf2, "D:\\Moon\\data\\DOM\\0aceb83f-6d5f-43b3-a178-520edac5c23c.img");

        MetaFileEntity mf3 = new MetaFileEntity();
        readRasterService.readRasterInfo(mf3, "D:\\Moon\\data\\DOM\\uv750_basemap_warp_mosaic_100m.jp2");
    }
}