python 下载企业微信邮箱中的附件文件

近日接了个需求，要求下载人员名单，心想很简单的个功能，于是就三下五除二的完成了后端代码编写，然后把请求地址和请求参数发给了前端，结果前端反馈政务微信不支持下载文件，如下图所示：

什么情况？？？

于是咨询了大佬，给了两个方法，1.用H5新打开页面去下载，2、将下载文件推送到政务微信的消息中；于是就按第二种方式场所了；闲言少叙上代码：

这是前端直接调用的方法，此时前端无需以下载的方式调用，按正常接口调用即可

截图加源码

@ApiOperation(notes ="下载会议人员", value = "下载会议人员")
    @RequestMapping(value = "/excel_user", method = {RequestMethod.POST,RequestMethod.GET})
    @ApiImplicitParams({
            @ApiImplicitParam(name = "meetId", value = "meetId",required = true, dataType = "String", paramType = "query")
    })
    @ResponseBody
    public void excelUser(@RequestParam(value = "meetId") String meetId){
        try {
            String streamNo=DateUtil.getCurrentCompactTime();
            Map<String, Object> params = new HashMap();
            params.put("meetId", meetId);
            List<Map<String, Object>> dataList= hyMeetinginfoService.excelExportReportList(meetId);
            String sheetName = (String) dataList.get(0).get("meetName");
            String userId = hyMeetinginfoService.cxhyyh(meetId);
            //将下载文件上传临时素材文件获得mediaId
            String mediaId= WxSend.uploadPic("http://hy.ydjw.jcy.gov.cn:8080/prod-api/api/meeting/dow_user?meetId="+meetId,sheetName);//这里的URL就是下面下载文件的请求地址及参数
            if (StringUtils.isNotBlank(mediaId) && StringUtils.isNotBlank(userId)){
                Map<String, Object> contentText = new HashMap<>(1);
                contentText.put("media_id",mediaId);
                WxSend.sendFile(userId,contentText);//将文件发送消息
            }
            log.info(streamNo+"|会议名单文件发送至通知消息" +  "|meetId="+meetId);
        } catch (Exception e) {
            log.error(e.getMessage(),e);
        }
    }

/********************************优美的分割线***********************************/

这是正常的下载文件代码

截图加源码

@ApiOperation(notes ="导出会议人员", value = "导出会议人员")
@RequestMapping(value = "/dow_user", method = {RequestMethod.POST,RequestMethod.GET})
@ApiImplicitParams({
        @ApiImplicitParam(name = "meetId", value = "meetId",required = true, dataType = "String", paramType = "query")
})
@ResponseBody
public void dowUser(@RequestParam(value = "meetId") String meetId,HttpServletRequest request,
                      HttpServletResponse response){
    try {
        String streamNo=DateUtil.getCurrentCompactTime();
        // 构造导出数据
        List<Map<String, Object>> dataList= hyMeetinginfoService.excelExportReportList(meetId);

        String sheetName = (String) dataList.get(0).get("meetName");
        String[] head0 = new String[] {"序号", "姓名","部门", "职务", "备注","报名时间"};//在excel中的第3行每列的参数
        String[] head1 = new String[] { "", "","",  "", "" };//在excel中的第4行每列（合并列）的参数
        //对应excel中的行和列，下表从0开始{"开始行,结束行,开始列,结束列"}
        String[] headnum0 = new String[] { "1,2,0,0","1,2,1,1","1,2,2,2","1,2,3,3","1,2,4,4","1,2,5,5"};//对应excel中的行和列，下表从0开始{"开始行,结束行,开始列,结束列"}
        String[] headnum1 = new String[] { "2,2,0,0","2,2,1,1", "2,2,2,2", "2,2,3,3","2,2,4,4"  };
        String[] colName = new String[] { "xh", "userName","bm", "zw", "bz", "bmsj"};//需要显示在excel中的参数对应的值，因为是用map存的，放的都是对应的key
        int colTable=6;//设置列数
        reportMergeXls(request, response, dataList, sheetName, head0,
                headnum0, head1, headnum1, colName,colTable); //utils类需要用到的参数
        log.info(streamNo+"|下载会议名单文件结束" + "|meetId="+meetId);
    } catch (Exception e) {
        log.error(e.getMessage(),e);
    }
}

/********************************优美的分割线***********************************/

这是下载的service

public List<Map<String,Object>> excelExportReportList(String meetId) {
    List<Map<String, Object>> result = new ArrayList<>();
    List<Map<String, Object>> userInfoList = hyMeetinginfoMapper.selectMeetUser(meetId);
    if (userInfoList != null && userInfoList.size() > 0) {
        int i=1;
        for (Map<String, Object> user:userInfoList) {
            Map<String, Object> map = new HashMap<>();
            map.put("meetName", user.get("meetName"));
            map.put("xh", i++);
            map.put("userName", user.get("userName"));
            map.put("bm", user.get("bm"));
            map.put("zw", user.get("zw"));
            map.put("bz", user.get("bz"));
            map.put("bmsj", user.get("bmsj"));
            result.add(map);
        }
    }
    return result;
}

/********************************优美的分割线***********************************/

截图加源码

源码

//上传下载的文件至临时素材文件获得mediaId
    public static String uploadPic(String filePath,String sheetName) throws Exception{
        String accessToken = getAccessToken();
        //返回结果
        String result=null;
        URL url2 = new URL(filePath);
        URLConnection con = url2.openConnection();
        // 输入流
        InputStream is = con.getInputStream();
        String urlString="http://ydjw.jcy.gov.cn:90/cgi-bin/media/upload?access_token="+accessToken+"&type=file";
        URL url=new URL(urlString);
        HttpURLConnection conn=(HttpURLConnection) url.openConnection();
        conn.setRequestMethod("POST");//以POST方式提交表单
        conn.setDoInput(true);
        conn.setDoOutput(true);
        conn.setUseCaches(false);//POST方式不能使用缓存
        //设置请求头信息
        conn.setRequestProperty("Connection", "Keep-Alive");;
        conn.setRequestProperty("Charset", "UTF-8");
        //设置边界
        String BOUNDARY="----------"+System.currentTimeMillis();
        conn.setRequestProperty("Content-Type", "multipart/form-data; boundary=" + BOUNDARY);
        //请求正文信息
        //第一部分
        StringBuilder sb=new StringBuilder();
        sb.append("--");//必须多两条道
        sb.append(BOUNDARY);
        sb.append("\r\n");
//        sb.append("Content-Disposition: form-data;name=\"media\"; filename=\"" + filePath.substring(filePath.lastIndexOf("/")+1)+"\"\r\n");
        //必须注意文件格式
        sb.append("Content-Disposition: form-data;name=\"media\"; filename=\"" +sheetName+"."+"xls"+"\"\r\n");
        sb.append("Content-Type:application/octet-stream\r\n\r\n");
        System.out.println("sb:"+sb);

        //获得输出流
        OutputStream out=new DataOutputStream(conn.getOutputStream());
        //输出表头
        out.write(sb.toString().getBytes("UTF-8"));
        //文件正文部分
        //把文件以流的方式 推送道URL中
        DataInputStream din=new DataInputStream(is);
        int bytes=0;
        byte[] buffer=new byte[1024];
        while((bytes=din.read(buffer))!=-1){
            out.write(buffer,0,bytes);
        }
        din.close();
        //结尾部分
        byte[] foot=("\r\n--" + BOUNDARY + "--\r\n").getBytes("UTF-8");//定义数据最后分割线
        out.write(foot);
        out.flush();
        out.close();
        if(HttpsURLConnection.HTTP_OK==conn.getResponseCode()){

            StringBuffer strbuffer=null;
            BufferedReader reader=null;
            try {
                strbuffer=new StringBuffer();
                reader=new BufferedReader(new InputStreamReader(conn.getInputStream()));
                String lineString=null;
                while((lineString=reader.readLine())!=null){
                    strbuffer.append(lineString);

                }
                if(result==null){
                    result=strbuffer.toString();
                    System.out.println("result:"+result);
                    JSONObject jsonObject = JSON.parseObject(result);
                    result = jsonObject.get("media_id").toString();
                    System.out.println("media_id:"+jsonObject.get("media_id"));
                }
            } catch (IOException e) {
                System.out.println("发送POST请求出现异常！"+e);
                e.printStackTrace();
            }finally{
                if(reader!=null){
                    reader.close();
                }
            }

        }
        return result;
    }

/********************************优美的分割线***********************************/

截图加源码

//文件发送给消息的形式
public static String  sendFile(String touser ,Map<String, Object> content) {
    String errmsg = null;
    String accessToken = getAccessToken();
    Gson gson = new Gson();
    Map<String, Object> map = new HashMap<>(5);
    map.put("touser", touser);
    map.put("msgtype", "file");//text
    map.put("agentid", "111111");
    content.put("url","URL");
    map.put("file", content);
    String s = gson.toJson(map);
    String url = "http://ydjw.jcy.gov.cn:90/cgi-bin/message/send?access_token=" + accessToken;
    String data = HttpUtil.post(url, s);
    if (data != null) {
        JSONObject jsonObject = JSONObject.parseObject(data);
        errmsg = jsonObject.getString("errmsg");
    }
    return errmsg;
}

/********************************优美的分割线***********************************/

以上做完就可以达到预期要求了