From b37275dba6b782bf3bb3817c4504f6cdef1bef7c Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期四, 18 三月 2021 18:38:51 +0800
Subject: [PATCH] APP首页顶部标签兼容

---
 src/test/java/com/hxh/spring/test/PPTVTest.java |  106 ++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 97 insertions(+), 9 deletions(-)

diff --git a/src/test/java/com/hxh/spring/test/PPTVTest.java b/src/test/java/com/hxh/spring/test/PPTVTest.java
index 3bdc1b5..03cc422 100644
--- a/src/test/java/com/hxh/spring/test/PPTVTest.java
+++ b/src/test/java/com/hxh/spring/test/PPTVTest.java
@@ -7,7 +7,14 @@
 import com.yeshi.buwan.pptv.entity.PPTVSeries;
 import com.yeshi.buwan.service.inter.LoginUserService;
 import com.yeshi.buwan.service.inter.juhe.PPTVService;
+import com.yeshi.buwan.util.StringUtil;
 import com.yeshi.buwan.util.log.LoggerUtil;
+import jxl.Sheet;
+import jxl.Workbook;
+import jxl.write.Label;
+import jxl.write.WritableCell;
+import jxl.write.WritableSheet;
+import jxl.write.WritableWorkbook;
 import org.junit.Test;
 import org.junit.runner.RunWith;
 import org.springframework.data.mongodb.core.query.Criteria;
@@ -18,7 +25,9 @@
 import org.yeshi.utils.HtmlToolUtil;
 
 import javax.annotation.Resource;
-import java.util.List;
+import java.io.File;
+import java.io.FileInputStream;
+import java.util.*;
 
 
 @RunWith(SpringJUnit4ClassRunner.class) //浣跨敤junit4杩涜娴嬭瘯
@@ -42,7 +51,7 @@
     @Test
     public void saveAll() {
         List<PPTVSeries> list = PPTVApiUtil.getTotalList();
-        pptvService.save(list);
+//        pptvService.save(list);
     }
 
     @Test
@@ -58,11 +67,6 @@
         }
     }
 
-    @Test
-    public void getDetail() {
-        PPTVSeries pptvSeries = pptvService.getSeriesDetail("201161");
-        System.out.println(pptvSeries);
-    }
 
     @Test
     public void test() {
@@ -143,7 +147,7 @@
     }
 
     @Test
-    public void reAddVideo(){
+    public void reAddVideo() {
         reAdd("姝︽灄澶栦紶");
     }
 
@@ -164,10 +168,94 @@
         }
     }
 
+    private List<String[]> getPPTVVideos(File f, int sheetNum) {
+        List<String[]> videoList = new ArrayList<>();
+        try {
+            jxl.Workbook rwb = Workbook.getWorkbook(new FileInputStream(f));
+            Sheet sheet = rwb.getSheet(sheetNum);
+            for (int c = 1; c < sheet.getRows(); c++) {
+                String infoId = sheet.getCell(0, c).getContents().trim();
+                String name = sheet.getCell(2, c).getContents().trim();
+                String del = sheet.getCell(21, c).getContents().trim();
+                if (!StringUtil.isNullOrEmpty(infoId) && StringUtil.isNullOrEmpty(del)) {
+                    videoList.add(new String[]{infoId, name, del});
+                }
+            }
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+
+        return videoList;
+    }
+
+
+    @Test
+    public void checkPPTVVideos() {
+        List<String[]> list1 = getPPTVVideos(new File("C:\\Users\\Administrator\\Desktop\\鍏ㄩ噺.xls"), 0);
+        List<String[]> list2 = getPPTVVideos(new File("C:\\Users\\Administrator\\Desktop\\鍏ㄩ噺.xls"), 1);
+        Map<String, String[]> map = new TreeMap<>();
+        for (String[] sts : list1) {
+            map.put(sts[0], sts);
+        }
+
+        for (String[] sts : list2) {
+            map.put(sts[0], sts);
+        }
+
+        List<PPTVSeries> list = pptvSeriesDao.list(0, 10000);
+        Set<String> infoIds = new HashSet<>();
+        for (PPTVSeries s : list) {
+            infoIds.add(s.getInfoID());
+        }
+
+        for (String infoId : infoIds) {
+            map.remove(infoId);
+        }
+
+        try {
+            save(map);
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+
+        System.out.println(map);
+    }
+
+    private void save(Map<String, String[]> data) throws Exception {
+        WritableWorkbook wwb = Workbook.createWorkbook(new File("C:\\Users\\Administrator\\Desktop\\甯冧父杈撳嚭鐗囧崟_缂哄け.xls"));
+        WritableSheet sheet = wwb.createSheet("缂哄け", 0);
+        sheet.addCell((WritableCell) new Label(0, 0, "鐧剧ID"));
+        sheet.addCell((WritableCell) new Label(1, 0, "鍚嶇О"));
+        int row = 1;
+        for (Iterator<String> its = data.keySet().iterator(); its.hasNext(); ) {
+            String key = its.next();
+            sheet.addCell((WritableCell) new Label(0, row, key));
+            sheet.addCell((WritableCell) new Label(1, row, data.get(key)[1]));
+            row++;
+        }
+        wwb.write();
+        wwb.close();
+    }
+
 
     @Test
     public void logs() {
-        LoggerUtil.getVIPLogger().info("123123");
+//        LoggerUtil.getVIPLogger().info("123123");
+
+        Map<String, String[]> data = new TreeMap<>();
+        data.put("4234234", new String[]{"4234234", "娴嬭瘯"});
+        try {
+            save(data);
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+    }
+
+    @Test
+    public void getDetail() {
+        PPTVSeries series = PPTVApiUtil.getDetail("32385373");
+        pptvService.save(series);
+        System.out.println(series);
     }
 
 

--
Gitblit v1.8.0