徐文豪 / project_management

package com.project.demo.web;

import com.alibaba.fastjson.JSONObject;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.project.demo.domain.*;
import com.project.demo.service.*;
import org.apache.poi.hssf.usermodel.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.MediaType;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * Created by xuwenhao on 2018/4/10.
 */
@Controller
@RequestMapping("projects")
public class ProjectsController {
    @Autowired
    private ProjectsService projectsService;
    @Autowired
    private SalesManService salesManService;
    @Autowired
    private UsersService usersService;
    @Autowired
    private DockingManService dockingManService;
    @Autowired
    private BelongsService belongsService;
    @Autowired
    private TrackingRecordService trackingRecordService;
    @Autowired
    private ProjectsValueService projectsValueService;
    @Autowired
    private UnreadChatRecordNumService unreadChatRecordNumService;

    @RequestMapping(method = RequestMethod.GET)
    public String findAll() {
        return "/project/index";
    }

    @RequestMapping(value = "/projectsList",method = RequestMethod.GET,produces = MediaType.APPLICATION_JSON_VALUE)
    @ResponseBody
    public String projectsList(final HttpSession session, final HttpServletRequest request){
        Users currentUser = (Users) session.getAttribute("users");
        final Map<String,Object> params = new HashMap<>();
        DataTablePageUtil<Projects> dataTable = new DataTablePageUtil<Projects>(request);
        PageHelper.startPage(dataTable.getPage_num(),dataTable.getPage_size());
        if(currentUser.getLevel()!=0){
            List<Integer> projectsIds = projectsService.usersProjects(currentUser.getId());
            params.put("projectsIds",projectsIds);
        }

        final List<Projects> projectsList = projectsService.search(params);
        projectsList.stream().forEach(d ->{
            Integer id = d.getId();
            params.put("projectsId",id);
            List<TrackingRecord> trackingRecordList = trackingRecordService.search(params);
            Integer totalRecordNum = 0;
            if(trackingRecordList!=null) {
                totalRecordNum  =trackingRecordList.size();
            }

            //此处应该减去已读条数
            Integer usersId = currentUser.getId();
            UnreadChatRecordNum unreadChatRecordNum = unreadChatRecordNumService.find(usersId,id,null);
            Integer haveRead = 0;
            if(unreadChatRecordNum != null){
                haveRead = unreadChatRecordNum.getHaveRead();
            }
            d.setUnreadChatRecord(totalRecordNum-haveRead);

        });
        PageInfo<Projects> pageInfo = new PageInfo<>(projectsList, 2);
        //封装数据给DataTables
        dataTable.setDraw(dataTable.getDraw());
        dataTable.setData(pageInfo.getList());
        dataTable.setRecordsTotal((int)pageInfo.getTotal());
        dataTable.setRecordsFiltered(dataTable.getRecordsTotal());
        //返回数据到页面
        String jsonObject = JSONObject.toJSONString(dataTable);
        return jsonObject;
    }

    @RequestMapping(value = "/{projectId}/details", method = RequestMethod.GET)
    public String edit(final HttpSession session, @PathVariable Integer projectId , Model model){
        Users currentUser = (Users) session.getAttribute("users");
        Projects thisproject = projectsService.findById(projectId);
        List<Integer> usersIdList = projectsService.salesMans(projectId);
        if(currentUser.getLevel()==0 || usersIdList.contains(currentUser.getId())){
            //设置查看
            Integer usersId = currentUser.getId();
            Integer projectsId = projectId;
            UnreadChatRecordNum unreadChatRecordNum = unreadChatRecordNumService.find(usersId,projectsId,null);
            final Map<String,Object> params = new HashMap<>();
            params.put("projectsId",projectId);
            List<TrackingRecord> trackingRecordList = trackingRecordService.search(params);
         //   Integer trackingRecordListSize = trackingRecordList.size();
            Integer totalRecordNum = trackingRecordList.size();
            if(totalRecordNum>0){
                if(unreadChatRecordNum == null){
                    UnreadChatRecordNum unreadChatRecordNum1 = new UnreadChatRecordNum();
                    unreadChatRecordNum1.setUsersId(usersId);
                    unreadChatRecordNum1.setProjectsId(projectsId);
                    unreadChatRecordNum1.setHaveRead(totalRecordNum);
                    unreadChatRecordNumService.saveUnreadChatRecordNum(unreadChatRecordNum1);
                }else{
                    unreadChatRecordNumService.updateHaveRead(usersId,projectsId,null,totalRecordNum);
                }
            }
            model.addAttribute("thisproject", thisproject);
            return "/project/details";
        }else{
            session.removeAttribute("users");
            return "redirect:/welcome/index";
        }
    }

    @RequestMapping(value = "/projectContent",method = RequestMethod.POST)
    @ResponseBody
    public Projects projectContent(HttpSession session , @RequestParam Integer projectId){
        Users currentUser = (Users) session.getAttribute("users");
        Projects projects = projectsService.findById(projectId);
        ProjectsValue projectsValue = projectsValueService.findByProjectsId(projects.getId());
        projects.setProjectsValue(projectsValue);
        System.out.println(projects.toString());
        return projects;
    }

    @RequestMapping(value = "/personnel",method = RequestMethod.POST)
    @ResponseBody
    public Personnel personnel(HttpSession session , @RequestParam Integer projectId){
        Personnel personnel = new Personnel();
        Users currentUser = (Users) session.getAttribute("users");

        //找到创建人
        Projects projects = projectsService.findById(projectId);
        Users createMan = usersService.findById(projects.getUsersId());
        personnel.setName(createMan.getName());
        personnel.setMobile(createMan.getMobile());

        final Map<String,Object> params = new HashMap<>();
        params.put("projectsId",projectId);

        //找到关联业务
        List<PersonnelSales> personnelSalesList = new ArrayList<>();
        List<SalesMan> salesManList = salesManService.search(params);
        for(int i = 0;i<salesManList.size();i++){
            Users salesMan = usersService.findById(salesManList.get(i).getUsersId());
            PersonnelSales personnelSales = new PersonnelSales();
            personnelSales.setName(salesMan.getName());
            personnelSales.setMobile(salesMan.getMobile());
            personnelSalesList.add(personnelSales);
        }

        //找到客户对接人
        List<PersonnelDocking> personnelDockingList = new ArrayList<>();
        List<DockingMan> dockingManList = dockingManService.search(params);
        for(int j = 0;j<dockingManList.size();j++){
            PersonnelDocking personnelDocking = new PersonnelDocking();
            personnelDocking.setId(dockingManList.get(j).getId());
            personnelDocking.setName(dockingManList.get(j).getName());
            personnelDocking.setMobile(dockingManList.get(j).getMobile());
            personnelDocking.setGender(dockingManList.get(j).getGender());
            personnelDocking.setPosition(dockingManList.get(j).getPosition());
            personnelDocking.setCorporateName(dockingManList.get(j).getCorporateName());
            personnelDocking.setIndustry(dockingManList.get(j).getIndustry());
            personnelDocking.setAddress(dockingManList.get(j).getAddress());
            personnelDockingList.add(personnelDocking);
        }
        if(personnelSalesList.size()>0) {
            personnel.setPersonnelSales(personnelSalesList);
        }
        if(personnelDockingList.size()>0) {
            personnel.setPersonnelDocking(personnelDockingList);
        }
        return personnel;
    }

    @RequestMapping(value = "/updateProjectsName",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson updateProjectsName(HttpSession session , @RequestParam Integer projectId, @RequestParam String projectName){
        AjaxJson ajaxJson = new AjaxJson();
        String result;
        if(projectName == null || projectName.equals("")){
            ajaxJson.setCode(1);
            ajaxJson.setMsg("项目名称不能为空");
        }else{
            final Map<String,Object> params = new HashMap<>();
            params.put("projectName",projectName);
            projectsService.updateProjects(projectId,params);
            ajaxJson.setCode(0);
            ajaxJson.setMsg("设置成功");
        }
        return ajaxJson;
    }


    //跟踪记录==>编辑
    @RequestMapping(value = "/updateProjectsRemark",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson updateProjectsRemark(HttpSession session ,@RequestParam String result, @RequestParam Integer id, @RequestParam String remark, @RequestParam String content){
        AjaxJson ajaxJson = new AjaxJson();
            if (content == null || content.equals("")) {
                ajaxJson.setCode(1);
                ajaxJson.setMsg("项目描述不能为空");

            } else {

                final Map<String, Object> params = new HashMap<>();
                Date currentTime = new Date();
                SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                String endTime = formatter.format(currentTime);

                    trackingRecordService.upEdit(remark, id, content, result);
                    ajaxJson.setCode(0);
                    ajaxJson.setMsg(result+"设置成功");
            }
        return ajaxJson;
    }





    @RequestMapping(value = "/salesList",method = RequestMethod.GET,produces = MediaType.APPLICATION_JSON_VALUE)
    @ResponseBody
    public String salesList(final HttpSession session, final HttpServletRequest request,@RequestParam Integer projectId){
        Users currentUser = (Users) session.getAttribute("users");
        final Map<String,Object> params = new HashMap<>();

        DataTablePageUtil<PersonnelSales> dataTable = new DataTablePageUtil<PersonnelSales>(request);
      //  PageHelper.startPage(dataTable.getPage_num(),dataTable.getPage_size());

        Personnel personnel = personnel(session,projectId);
        List<PersonnelSales> personnelSales;
        if(personnel.getPersonnelSales() != null){
            personnelSales = personnel.getPersonnelSales();
        }else{
            personnelSales = new ArrayList<>();
        }
        PageInfo<PersonnelSales> pageInfo = new PageInfo<>(personnelSales, 2);
        dataTable.setDraw(dataTable.getDraw());
        dataTable.setData(pageInfo.getList());
        dataTable.setRecordsTotal((int)pageInfo.getTotal());
        dataTable.setRecordsFiltered(dataTable.getRecordsTotal());
        String jsonObject = JSONObject.toJSONString(dataTable);
        return jsonObject;
    }

    @RequestMapping(value = "/removeSales",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson removeSales(HttpSession session , @RequestParam Integer projectId, @RequestParam String mobiles){
        AjaxJson ajaxJson = new AjaxJson();
        String[] mobilesArray = mobiles.split(",");
        Users users = new Users();
        for (int i = 0; i<mobilesArray.length; i++) {
            users = usersService.findByMobile(mobilesArray[i]);
            salesManService.delete(users.getId(),projectId);
        }
        ajaxJson.setCode(0);
        ajaxJson.setMsg("删除成功");
        return ajaxJson;
    }

    @RequestMapping(value = "/usersList",method = RequestMethod.GET,produces = MediaType.APPLICATION_JSON_VALUE)
    @ResponseBody
    public String usersList(final HttpSession session, final HttpServletRequest request,@RequestParam Integer projectId){
        Users currentUser = (Users) session.getAttribute("users");
        final Map<String,Object> params = new HashMap<>();

        //或许当前项目已关联人员和创建人员
        Integer createManId= projectsService.findById(projectId).getUsersId();
        Users createUsers = usersService.findById(createManId);
        Personnel personnel = personnel(session,projectId);
        List<PersonnelSales> personnelSales;
        if(personnel.getPersonnelSales()!=null){
            personnelSales = personnel.getPersonnelSales();
        }else{
            personnelSales =new ArrayList<>();
        }
        PersonnelSales createPersonnelSales = new PersonnelSales();
        createPersonnelSales.setName(createUsers.getName());
        createPersonnelSales.setMobile(createUsers.getMobile());
        personnelSales.add(createPersonnelSales);
        List<String> mobiles = new ArrayList<>();
        for(int i=0;i<personnelSales.size();i++) {
            String personnePobile = personnelSales.get(i).getMobile();
            mobiles.add(personnePobile);
        }
        params.put("mobiles",mobiles);
        DataTablePageUtil<Users> dataTable = new DataTablePageUtil<Users>(request);
        PageHelper.startPage(dataTable.getPage_num(),dataTable.getPage_size());
        List<Users> usersList = usersService.search(params);
        PageInfo<Users> pageInfo = new PageInfo<>(usersList, 2);
        //封装数据给DataTables
        dataTable.setDraw(dataTable.getDraw());
        dataTable.setData(pageInfo.getList());
        dataTable.setRecordsTotal((int)pageInfo.getTotal());
        dataTable.setRecordsFiltered(dataTable.getRecordsTotal());
        //返回数据到页面
        String jsonObject = JSONObject.toJSONString(dataTable);
        return jsonObject;
    }

    @RequestMapping(value = "/addSales",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson addSales(HttpSession session , @RequestParam Integer projectId, @RequestParam String mobiles){
        AjaxJson ajaxJson = new AjaxJson();
        String[] mobilesArray = mobiles.split(",");
        Users users = new Users();
        SalesMan salesMan = new SalesMan();
        for (int i = 0; i<mobilesArray.length; i++) {
            users = usersService.findByMobile(mobilesArray[i]);
            salesMan.setUsersId(users.getId());
            salesMan.setProjectsId(projectId);
            salesMan.setState("1");
            salesManService.insert(salesMan);
        }
        ajaxJson.setCode(0);
        ajaxJson.setMsg("添加成功");
        return ajaxJson;
    }


    @RequestMapping(value = "/dockingList",method = RequestMethod.GET,produces = MediaType.APPLICATION_JSON_VALUE)
    @ResponseBody
    public String dockingList(final HttpSession session, final HttpServletRequest request,@RequestParam Integer projectId){
        Users currentUser = (Users) session.getAttribute("users");
        final Map<String,Object> params = new HashMap<>();
        DataTablePageUtil<PersonnelDocking> dataTable = new DataTablePageUtil<PersonnelDocking>(request);
       // PageHelper.startPage(dataTable.getPage_num(),dataTable.getPage_size());
        Personnel personnel = personnel(session,projectId);
        List<PersonnelDocking> personnelDockingList;
        if(personnel.getPersonnelDocking() != null){
            personnelDockingList = personnel.getPersonnelDocking();
        }else{
            personnelDockingList = new ArrayList<>();
        }
        PageInfo<PersonnelDocking> pageInfo = new PageInfo<>(personnelDockingList, 2);
        dataTable.setDraw(dataTable.getDraw());
        dataTable.setData(pageInfo.getList());
        dataTable.setRecordsTotal((int)pageInfo.getTotal());
        dataTable.setRecordsFiltered(dataTable.getRecordsTotal());
        String jsonObject = JSONObject.toJSONString(dataTable);
        return jsonObject;
    }

    //删除客户对接人员
    @RequestMapping(value = "/removeDocking",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson removeDocking(HttpSession session , @RequestParam Integer projectId, @RequestParam String ids){
        AjaxJson ajaxJson = new AjaxJson();
        String[] idsArray = ids.split(",");
        Users users = new Users();
        for (int i = 0; i<idsArray.length; i++) {
            users = usersService.findByMobile(idsArray[i]);
           // salesManService.delete(users.getId(),projectId);
            dockingManService.delete(Integer.parseInt(idsArray[i]));
        }
        ajaxJson.setCode(0);
        ajaxJson.setMsg("删除成功");
        return ajaxJson;
    }

    //创建客户对接人员
    @RequestMapping(value = "/addDocking",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson addSales(HttpSession session , @RequestParam Integer projectId, @RequestParam String name,@RequestParam String position,@RequestParam String gender,@RequestParam String mobile,@RequestParam String corporateName,@RequestParam String industry,@RequestParam String address){
        AjaxJson ajaxJson = new AjaxJson();
        DockingMan dockingMan = new DockingMan();
        dockingMan.setName(name);
        dockingMan.setProjectsId(projectId);
        dockingMan.setMobile(mobile);
        dockingMan.setPosition(position);
        dockingMan.setGender(gender);
        dockingMan.setCorporateName(corporateName);
        dockingMan.setIndustry(industry);
        dockingMan.setAddress(address);
        dockingManService.insert(dockingMan);

        ajaxJson.setCode(0);
        ajaxJson.setMsg("添加成功");
        return ajaxJson;
    }

    //创建跟踪记录
    @RequestMapping(value = "/addTracks",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson addTracks(HttpSession session , @RequestParam Integer projectId, @RequestParam String projectTracks){
        AjaxJson ajaxJson = new AjaxJson();
        Users currentUser = (Users) session.getAttribute("users");
        TrackingRecord trackingRecord = new TrackingRecord();
        trackingRecord.setProjectsId(projectId);
        trackingRecord.setUsersId(currentUser.getId());
        trackingRecord.setState("进行中");
        trackingRecord.setContent(projectTracks);
        trackingRecordService.insert(trackingRecord);
        ajaxJson.setCode(0);
        ajaxJson.setMsg("添加成功");
        return ajaxJson;
    }

    //跳转创建项目页面
    @RequestMapping(value = "/create")
    public String create() {
        return "/project/new";
    }

    //创建项目
    @RequestMapping(value = "/new",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson newProject(HttpSession session ,
                               @RequestParam String projectName,
                               @RequestParam String surveyCategory,
                               @RequestParam Integer cillectionPointNum,
                               @RequestParam String sceneName,
                               @RequestParam String enviroment,
                               @RequestParam String presentSituation,
                               @RequestParam String planningIntention,
                               @RequestParam String plannedImplementationTime){
        AjaxJson ajaxJson = new AjaxJson();
        Users currentUser = (Users) session.getAttribute("users");
        Projects projects = new Projects();
        projects.setProjectName(projectName);
        Date date =new Date();
        projects.setStartTime(date);
        projects.setUsersId(currentUser.getId());
        Integer saveProjectsRes = projectsService.saveProjects(projects);
        if(saveProjectsRes != null && saveProjectsRes == 1){
            Projects saved = projectsService.findByStartTime(date);
            Integer savedId = saved.getId();
            ProjectsValue projectsValue = new ProjectsValue();
            projectsValue.setSurveyCategory(surveyCategory);
            projectsValue.setCillectionPointNum(cillectionPointNum);
            projectsValue.setSceneName(sceneName);
            projectsValue.setEnviroment(enviroment);
            projectsValue.setPresentSituation(presentSituation);
            projectsValue.setPlanningIntention(planningIntention);
            String[] plannedImplementationTimeArray = plannedImplementationTime.split("-");
            projectsValue.setPlannedImplementationTime(new Date(Integer.parseInt(plannedImplementationTimeArray[0])-1900,Integer.parseInt(plannedImplementationTimeArray[1])-1,Integer.parseInt(plannedImplementationTimeArray[2])));
            projectsValue.setProjectId(savedId);
            Integer saveProjectsValueRes = projectsValueService.saveProjectsValue(projectsValue);
            if(saveProjectsValueRes != null && saveProjectsValueRes == 1){
                ajaxJson.setCode(1);
                ajaxJson.setMsg("项目创建成功");
            }else{
                ajaxJson.setCode(0);
                ajaxJson.setMsg("项目信息表创建失败");
            }

        }else{
            //主表插入失败
            ajaxJson.setCode(0);
            ajaxJson.setMsg("主表创建失败");
        }
        return ajaxJson;
    }

    @RequestMapping(value = "/updateProjectsillectionPointNum",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson cillectionPointNum(@RequestParam Integer projectId,
                                       @RequestParam Integer cillectionPointNum){
        AjaxJson ajaxJson = new AjaxJson();
        final Map<String, Object> params = new HashMap<>();
        params.put("projectId",projectId);
        params.put("cillectionPointNum",cillectionPointNum);
        projectsValueService.updateVal(params);
        ajaxJson.setCode(1);
        ajaxJson.setMsg("修改成功");
        return ajaxJson;
    }

    @RequestMapping(value = "/updateSceneName",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson sceneName(@RequestParam Integer projectId,
                                       @RequestParam String sceneName){
        AjaxJson ajaxJson = new AjaxJson();
        final Map<String, Object> params = new HashMap<>();
        params.put("projectId",projectId);
        params.put("sceneName",sceneName);
        projectsValueService.updateVal(params);
        ajaxJson.setCode(1);
        ajaxJson.setMsg("修改成功");
        return ajaxJson;
    }

    @RequestMapping(value = "/updateEnviroment",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson enviroment(@RequestParam Integer projectId,
                              @RequestParam String enviroment){
        AjaxJson ajaxJson = new AjaxJson();
        final Map<String, Object> params = new HashMap<>();
        params.put("projectId",projectId);
        params.put("enviroment",enviroment);
        projectsValueService.updateVal(params);
        ajaxJson.setCode(1);
        ajaxJson.setMsg("修改成功");
        return ajaxJson;
    }

    @RequestMapping(value = "/updatePresentSituation",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson presentSituation(@RequestParam Integer projectId,
                               @RequestParam String presentSituation){
        AjaxJson ajaxJson = new AjaxJson();
        final Map<String, Object> params = new HashMap<>();
        params.put("projectId",projectId);
        params.put("presentSituation",presentSituation);
        projectsValueService.updateVal(params);
        ajaxJson.setCode(1);
        ajaxJson.setMsg("修改成功");
        return ajaxJson;
    }

    @RequestMapping(value = "/updateSurveyCategory",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson surveyCategory(@RequestParam Integer projectId,
                                     @RequestParam String surveyCategory){
        AjaxJson ajaxJson = new AjaxJson();
        final Map<String, Object> params = new HashMap<>();
        params.put("projectId",projectId);
        params.put("surveyCategory",surveyCategory);
        projectsValueService.updateVal(params);
        ajaxJson.setCode(1);
        ajaxJson.setMsg("修改成功");
        return ajaxJson;
    }

    @RequestMapping(value = "/updatePlanningIntention",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson planningIntention(@RequestParam Integer projectId,
                                   @RequestParam String planningIntention){
        AjaxJson ajaxJson = new AjaxJson();
        final Map<String, Object> params = new HashMap<>();
        params.put("projectId",projectId);
        params.put("planningIntention",planningIntention);
        projectsValueService.updateVal(params);
        ajaxJson.setCode(1);
        ajaxJson.setMsg("修改成功");
        return ajaxJson;
    }

    @RequestMapping(value = "/updatePlannedImplementationTime",method = RequestMethod.POST)
    @ResponseBody
    public AjaxJson plannedImplementationTime(@RequestParam Integer projectId,
                                      @RequestParam String plannedImplementationTimeStr){
        AjaxJson ajaxJson = new AjaxJson();
        final Map<String, Object> params = new HashMap<>();
        String[] plannedImplementationTimeArray = plannedImplementationTimeStr.split("-");
        Date plannedImplementationTime = (new Date(Integer.parseInt(plannedImplementationTimeArray[0])-1900,Integer.parseInt(plannedImplementationTimeArray[1])-1,Integer.parseInt(plannedImplementationTimeArray[2])));
        params.put("projectId",projectId);
        params.put("plannedImplementationTime",plannedImplementationTime);
        projectsValueService.updateVal(params);
        ajaxJson.setCode(1);
        ajaxJson.setMsg("修改成功");
        return ajaxJson;
    }

    @RequestMapping(value = "/projectsExcelDownloads", method = RequestMethod.GET)
    public void downloadAllClassmate(
            HttpSession session,
            HttpServletResponse response) throws IOException {



        Users currentUser = (Users) session.getAttribute("users");
        //final Map<String,Object> params = new HashMap<>();
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet("信息表");
        final Map<String, Object> params = new HashMap<String, Object>();
        if(currentUser.getLevel()!=0){
            List<Integer> projectsIds = projectsService.usersProjects(currentUser.getId());
            params.put("projectsIds",projectsIds);
        }

        List<Projects> classmateList = projectsService.search(params);

        String fileName = "projects_management" + ".xls";//设置要导出的文件的名字
        //新增数据行，并且设置单元格数据

        int rowNum = 1;

        String[] headers = {"项目名称","创建时间","勘察类别", "采集点数量", "监控设备(场景)名称","安装环境","工业物联网现状","工业物联网项目规划意向","计划实施时间","创建人员"};
        //headers表示excel表中第一行的表头

        HSSFRow row = sheet.createRow(0);
        //在excel表中添加表头

        for (int i = 0; i < headers.length; i++) {
            HSSFCell cell = row.createCell(i);
            HSSFRichTextString text = new HSSFRichTextString(headers[i]);
            cell.setCellValue(text);
        }

        //在表中存放查询到的数据放入对应的列
        for (Projects projects : classmateList) {
            ProjectsValue projectsValue = projectsValueService.findByProjectsId(projects.getId());
            Users createUser = usersService.findById(projects.getUsersId());
            HSSFRow row1 = sheet.createRow(rowNum);
            row1.createCell(0).setCellValue(projects.getProjectName());
            Date startTime = projects.getStartTime();
            String startTimeStr = startTime.getYear()+1900+"-"+(startTime.getMonth()+1)+"-"+startTime.getDate();
            row1.createCell(1).setCellValue(startTimeStr);
            row1.createCell(2).setCellValue(projectsValue.getSurveyCategory());
            row1.createCell(3).setCellValue(projectsValue.getCillectionPointNum());
            row1.createCell(4).setCellValue(projectsValue.getSceneName());
            row1.createCell(5).setCellValue(projectsValue.getEnviroment());
            row1.createCell(6).setCellValue(projectsValue.getPresentSituation());
            row1.createCell(7).setCellValue(projectsValue.getPlanningIntention());
            Date plannedImplementationTime = projectsValue.getPlannedImplementationTime();
            String plannedImplementationTimeStr =  plannedImplementationTime.getYear()+1900+"-"+(plannedImplementationTime.getMonth()+1)+"-"+plannedImplementationTime.getDate();
            row1.createCell(8).setCellValue(plannedImplementationTimeStr);
            row1.createCell(9).setCellValue(createUser.getName());
            rowNum++;
        }

        response.setContentType("application/octet-stream");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName);
        response.flushBuffer();
        workbook.write(response.getOutputStream());
    }









}