moooc_review/src/main/java/com/mooctest/controller/PaperController.java

package com.mooctest.controller;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.mooctest.service.AuditTaskService;
import com.mooctest.service.BugExcelInputService;
import com.mooctest.service.ExcelInputService;
import com.mooctest.service.PaperService;
import org.apache.poi.hssf.record.DVALRecord;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.sql.Timestamp;

@Controller
public class PaperController {

    @Value("${report.host}")
    String reportHost ;
    @Autowired
    PaperService paperService;

    @Autowired
    BugExcelInputService bugExcelInputService;

    @Autowired
    ExcelInputService excelInputService;

    private String ITEM_GROUP_NAME = "item_group_list";

    @GetMapping("/addPaper")
    public String addPaper (Model model){
        model.addAttribute("reportHost",reportHost);
        return "add_paper";
    }

//    @GetMapping("/reloadTask")
//    public String reloadTask ( Model model ){
//        return "addTask";
//    }

    @GetMapping("/addExcel")
    public String addExcel (Model model){
        return "add_excel";
    }

    @PostMapping("/excelToMongo")
    public String excelToMongo (@RequestParam("name")String name, @RequestParam("excelFile") MultipartFile multipartFile){
        // 从前端接收Excel文件，并返回文件保存的全路径
//        String fileFullPath = bugExcelInputService.saveMultipartFile(multipartFile, multipartFile.getName());
        String fileFullPath = excelInputService.saveMultipartFile(multipartFile, name);
        // 拿取文件，并将文件内容插入到Mongo数据库中
//        bugExcelInputService.excelToMongo(27017,"localhost","crowd_review","root","root","bug",fileFullPath);
        excelInputService.excelToMongo(fileFullPath, name);
        return "add_excel_ok";
    }


    @DeleteMapping("/dpaper")
    @ResponseBody
    public JSONObject deletePaper (Model model ,  @RequestParam("id") String id ){
        return paperService.deletePaper(id);
    }

    @GetMapping("/papers")
    public String auditTask ( Model model){
        JSONArray jsonArray = paperService.getPaperData(); // 所有的数据。
        for (Object single : jsonArray){
            single = (JSONObject) single;
            changeTime2Long(single); // 修改创建时间的格式  以便前段展示
        }
        model.addAttribute("tasks",jsonArray);
        model.addAttribute("reportHost",reportHost);
        return "paper_list";
    }


    @GetMapping("/changePaper")
    public String changeTask ( Model model ,@RequestParam("id") String id ){
        JSONObject data = paperService.getSinglePaper(id);
        JSONArray arrary = data.getJSONArray(ITEM_GROUP_NAME);
        model.addAttribute("data",data);
        model.addAttribute("ruleLength",arrary.size());
        model.addAttribute("reportHost",reportHost);
        return "changePaper";
    }

    @GetMapping("/paperDetail")
    public String paperDetail ( Model model , @RequestParam("id") String id){
        JSONObject data = paperService.getSinglePaper(id);
        JSONArray jobs = paperService.getJobsByPaperId(id);
        for(Object o : jobs){
            changeTime2Long(o);
        }
        model.addAttribute("data",data);
        model.addAttribute("reportHost",reportHost);
        model.addAttribute("jobs",jobs);
        return "paperDetail";
    }


//    @GetMapping("/reloadJob")
//    @ResponseBody
//    public JSONObject reloadJob ( Model model, @RequestParam("id") String id ){
//        JSONObject res = auditTaskService.getSingleTask(id);
//        return res;
//    }
private void changeTime2Long ( Object input){
    JSONObject temp = (JSONObject) input;
    temp.put("create_time",new Timestamp(Long.parseLong(temp.get("create_time").toString()))); // 修改创建时间的格式  以便前段展示
}
}