1 //1.微信自动回复接口 2 public void receiveMSG(HttpServletRequest request, HttpServletResponse response, @PathVariable(value = "comId") 3 String comId) throws Exception { 4 try { 5 boolean isGet = request.getMethod().toLowerCase().equals("get"); 6 request.setCharacterEncoding("UTF-8"); 7 response.setCharacterEncoding("UTF-8"); 8 if (isGet) { 9 // 验证URL真实性 10 String token = Utils.getParmValueByName(request, comId, "WeChat_Token", ""); // "rrtxxvafgargae";// 11 String signature = request.getParameter("signature");// 微信加密签名 12 String timestamp = request.getParameter("timestamp");// 时间戳 13 String nonce = request.getParameter("nonce");// 随机数 14 String echostr = request.getParameter("echostr");// 随机字符串 15 List<String> params = new ArrayList<String>(); 16 params.add(token);// Token 17 params.add(timestamp); 18 params.add(nonce); 19 // 1. 将token、timestamp、nonce三个参数进行字典序排序 20 Collections.sort(params, new Comparator<String>() { 21 @Override 22 public int compare(String o1, String o2) { 23 return o1.compareTo(o2); 24 } 25 }); 26 // 2. 将三个参数字符串拼接成一个字符串进行sha1加密 27 String temp = Utils.toShaString(params.get(0) + params.get(1) + params.get(2)); 28 // log.debug("temp:"+temp); 29 // log.debug("signature:"+signature); 30 if (temp.equals(signature)) { 31 response.getWriter().write(echostr); 32 } 33 } else { 34 // 处理接收消息 35 /** 读取接收到的xml消息 */ 36 StringBuffer sb = new StringBuffer(); 37 InputStream is = request.getInputStream(); 38 InputStreamReader isr = new InputStreamReader(is, "UTF-8"); 39 BufferedReader br = new BufferedReader(isr); 40 String s = ""; 41 while ((s = br.readLine()) != null) { 42 sb.append(s); 43 } 44 String xml = sb.toString(); // 次即为接收到微信端发送过来的xml数据 45 HashMap<String, String> xmlmap = WeChatUtils.xml2HashMap(xml); 46 log.debug(xmlmap.toString()); 47 // 接收事件推送 48 String msgType = xmlmap.get("MsgType"); 49 if ("event".equals(msgType)) { 50 String event = xmlmap.get("Event"); 51 if ("subscribe".equals(event)) { 52 String msg = Utils.getParmValueByName(request, comId, "WeChat_SubscribeMsg", "您好，欢迎关注！"); 53 String xmlTo = "<xml>"; 54 xmlTo += "<ToUserName>" + xmlmap.get("FromUserName") + "</ToUserName>"; 55 xmlTo += "<FromUserName>" + xmlmap.get("ToUserName") + "</FromUserName>"; 56 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 57 xmlTo += "<MsgType>text</MsgType>"; 58 xmlTo += "<Content>" + msg + "</Content>"; 59 xmlTo += "</xml>"; 60 response.getWriter().write(xmlTo); 61 } 62 if ("subscribe".equals(event) || "SCAN".equals(event)) { 63 log.debug("订阅"); 64 65 String sql = " select cust_id from WECHAT_CUST where com_id = ? and OPENID = ? order by TYPE_BIND desc "; 66 ArrayList parms = new ArrayList(); 67 parms.add(comId); 68 parms.add(xmlmap.get("FromUserName")); 69 String custId = utilsService.getValueBySql(sql, parms, ""); 70 if (StringUtils.isBlank(custId)) { 71 String accessToken = WeChatUtils.getAccessToken(request, comId); 72 String usermsg = WeChatUtils.getUserInfo(accessToken, xmlmap.get("FromUserName")); 73 JSONObject jsonUser = WeChatUtils.string2JSON(usermsg); 74 if (jsonUser.containsKey("errcode")) 75 throw new Exception(jsonUser.toString()); 76 77 Cust cust = new Cust(); 78 String cust_id = utilsService.getMemNum(comId); 79 cust.setCustId(cust_id); 80 cust.setCustName(jsonUser.getString("nickname").replaceAll("'", "").replaceAll(""", "")); 81 cust.setCustShortName(""); 82 cust.setReturnlimitdays(99999); 83 cust.setCustPwd(""); 84 cust.setComId(comId); 85 cust.setCallRut(comId); 86 cust.setInnerType("05"); 87 cust.setIsMkt("0"); 88 cust.setCustType5("1"); 89 cust.setStatus("02"); 90 cust.setCallState("M"); 91 cust.setTel(""); 92 cust.setIsTel("0"); 93 cust.setEmail(""); 94 cust.setIsWeb("0"); 95 if (!jsonUser.getString("sex").equals("1")) { 96 cust.setCallState("F"); 97 } 98 sql = " select min(MCP_CLS_ID) from MEM_CLASS_POLICE where MCP_COM_ID = ? "; 99 parms.clear(); 100 parms.add(comId); 101 String mcp_cls_id = utilsService.getValueBySql(sql, parms, ""); 102 cust.setCustType4(mcp_cls_id); 103 CustOther custOther = new CustOther(); 104 custOther.setCustId(cust_id); 105 if (xmlmap.containsKey("Ticket")) { 106 sql = " select cust_id from WECHAT_CUST where TICKET = ? "; 107 parms.clear(); 108 parms.add(xmlmap.get("Ticket")); 109 String CorCusNum = utilsService.getValueBySql(sql, parms, ""); 110 cust.setCorCusNum(CorCusNum); 111 } else { 112 cust.setCorCusNum(""); 113 } 114 WechatCust wechatcust = new WechatCust(); 115 wechatcust.setComId(comId); 116 wechatcust.setCustId(cust_id); 117 wechatcust.setOpenid(xmlmap.get("FromUserName")); 118 wechatcust.setTicket(""); 119 wechatcust.setHeadimgurl(jsonUser.getString("headimgurl")); 120 wechatcust.setStatus("1"); 121 wechatcust.setCrtDate(Utils.GetCurrentDate()); 122 wechatcust.setTypeBind("0"); 123 wechatcust.setCancelDate(""); 124 weChatBaseService.addCust(cust, custOther, wechatcust); 125 126 } else if ("subscribe".equals(event)) { 127 WechatCust wechatcust = new WechatCust(); 128 wechatcust.setComId(comId); 129 wechatcust.setCustId(custId); 130 wechatcust = wechatCustService.findByPrimaryKey(wechatcust.getPrimaryKey()); 131 Cust cust = custService.findByPrimaryKey(custId); 132 if (StringUtils.isBlank(wechatcust.getHeadimgurl())) { 133 String accessToken = WeChatUtils.getAccessToken(request, comId); 134 String usermsg = WeChatUtils.getUserInfo(accessToken, xmlmap.get("FromUserName")); 135 JSONObject jsonUser = WeChatUtils.string2JSON(usermsg); 136 if (jsonUser.containsKey("errcode")) 137 throw new Exception(jsonUser.toString()); 138 String nickname = ""; 139 String sex = "1"; 140 String headimgurl = ""; 141 String ticket = ""; 142 try { 143 nickname = jsonUser.getString("nickname").replaceAll("'", "").replaceAll(""", ""); 144 sex = jsonUser.getString("sex"); 145 headimgurl = jsonUser.getString("headimgurl"); 146 ticket = WeChatUtils.getQRCode(accessToken, custId).get("ticket").toString(); 147 } catch (Throwable e) { 148 149 } 150 151 wechatcust.setOpenid(xmlmap.get("FromUserName")); 152 wechatcust.setTicket(ticket); 153 wechatcust.setHeadimgurl(headimgurl); 154 wechatcust.setCrtDate(Utils.GetCurrentDate()); 155 cust.setCustName(nickname); 156 if (!sex.equals("1")) { 157 cust.setCallState("F"); 158 } 159 } 160 wechatcust.setStatus("1"); 161 weChatBaseService.updateCust(cust, wechatcust); 162 String updatesql = " update WECHAT_CUST set STATUS = '1' where com_id = ? and OPENID = ? "; 163 String nowDate = Utils.GetCurrentDate(); 164 parms.clear(); 165 parms.add(comId); 166 parms.add(xmlmap.get("FromUserName")); 167 utilsService.updateSql(updatesql, parms); 168 } 169 170 } else if ("unsubscribe".equals(event)) { 171 log.debug("取消订阅"); 172 String sql = " update WECHAT_CUST set STATUS = '0', CANCEL_DATE = ? where com_id = ? and OPENID = ? "; 173 ArrayList parms = new ArrayList(); 174 String nowDate = Utils.GetCurrentDate(); 175 parms.add(nowDate); 176 parms.add(comId); 177 parms.add(xmlmap.get("FromUserName")); 178 179 utilsService.updateSql(sql, parms); 180 181 }else if ("SCAN".equals(event)) { 182 log.debug("用户已关注时的事件推送 "); 183 } else if ("LOCATION".equals(event)) { 184 log.debug("上报地理位置事件"); 185 } else if ("CLICK".equals(event)) { 186 log.debug("点击菜单拉取消息时的事件推送"); 187 String eventKey = xmlmap.get("EventKey"); 188 log.debug("eventKey:"+eventKey); 189 if (StringUtils.equalsIgnoreCase("cust_service", eventKey)) { 190 String fromUserName = xmlmap.get("FromUserName"); 191 String sql = " select COR_CUS_NUM from cust , wechat_cust where wechat_cust.cust_id = cust.cust_id " 192 + " and wechat_cust.com_id = ? and wechat_cust.openid = ? " + " order by wechat_cust.TYPE_BIND desc "; 193 String mSql = " select MEDIA_ID from WECHAT_CUST_MEDIA where cust_id = ? and com_id = ? "; 194 String custSql = "select COR_CUS_NUM from cust where cust_id = ? "; 195 ArrayList parms = new ArrayList(); 196 parms.add(comId); 197 parms.add(fromUserName); 198 199 String mediaId = ""; 200 String custId = utilsService.getValueBySql(sql, parms, ""); 201 int count = 0; 202 while (StringUtils.isBlank(mediaId) && StringUtils.isNotBlank(custId) && count < 3) { 203 count++; 204 parms.clear(); 205 parms.add(custId); 206 parms.add(comId); 207 mediaId = utilsService.getValueBySql(mSql, parms, ""); 208 if (StringUtils.isBlank(mediaId)) { 209 parms.clear(); 210 parms.add(custId); 211 custId = utilsService.getValueBySql(custSql, parms, ""); 212 } 213 } 214 if (StringUtils.isBlank(mediaId)) { 215 mediaId = Utils.getParmValueByName(request, comId, "WeChat_ServiceMediaId", ""); 216 } 217 if (StringUtils.isNotBlank(mediaId)) { 218 log.debug("mediaId:"+mediaId); 219 String xmlTo = "<xml>"; 220 xmlTo += "<ToUserName>" + xmlmap.get("FromUserName") + "</ToUserName>"; 221 xmlTo += "<FromUserName>" + xmlmap.get("ToUserName") + "</FromUserName>"; 222 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 223 xmlTo += "<MsgType>image</MsgType>"; 224 xmlTo += "<Image>"; 225 xmlTo += "<MediaId>" + mediaId + "</MediaId>"; 226 xmlTo += "</Image>"; 227 xmlTo += "</xml>"; 228 response.getWriter().write(xmlTo); 229 }else { 230 String xmlTo = "<xml>"; 231 xmlTo += "<ToUserName>" + xmlmap.get("FromUserName") + "</ToUserName>"; 232 xmlTo += "<FromUserName>" + xmlmap.get("ToUserName") + "</FromUserName>"; 233 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 234 xmlTo += "<MsgType>text</MsgType>"; 235 xmlTo += "<Content>还未绑定客服资料</Content>"; 236 xmlTo += "</xml>"; 237 response.getWriter().write(xmlTo); 238 } 239 } 240 } 241 } else if ("text".equals(msgType)) {//回复文本 242 String key = xmlmap.get("Content"); 243 String xmlTo = "<xml>"; 244 xmlTo += "<ToUserName>" + xmlmap.get("ToUserName") + "</ToUserName>"; 245 xmlTo += "<FromUserName>" + xmlmap.get("FromUserName") + "</FromUserName>"; 246 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 247 xmlTo += "<MsgType>text</MsgType>"; 248 String repltSql="select * from WECHAT_AUTO_KEY where WECHAT_AUTO_KEY.KEY_NAME = ? and WECHAT_AUTO_KEY.COM_ID=? "; 249 ArrayList parms = new ArrayList(); 250 parms.add(key); 251 parms.add(comId); 252 List replylist=utilsService.getDataList(repltSql, parms); 253 String desc=""; 254 if(replylist!=null && replylist.size()>0){ 255 HashMap replyLine = (HashMap)replylist.get(0); 256 desc=(String) replyLine.get("DESC"); 257 } 258 if(StringUtils.isNotBlank(desc)) 259 xmlTo += "<Content>" + desc + "</Content>"; 260 else 261 xmlTo += "<Content>" + "查无内容" + "</Content>"; 262 xmlTo += "</xml>"; 263 response.getWriter().write(xmlTo); 264 }else if ("image".equals(msgType)) {//回复图片 265 String key = xmlmap.get("MediaId"); 266 String xmlTo = "<xml>"; 267 xmlTo += "<ToUserName>" + xmlmap.get("ToUserName") + "</ToUserName>"; 268 xmlTo += "<FromUserName>" + xmlmap.get("FromUserName") + "</FromUserName>"; 269 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 270 xmlTo += "<MsgType>image</MsgType>"; 271 xmlTo += "<Image>"; 272 String repltSql="select * from WECHAT_AUTO_KEY where WECHAT_AUTO_KEY.KEY_NAME = ? and WECHAT_AUTO_KEY.COM_ID=? "; 273 ArrayList parms = new ArrayList(); 274 parms.add(key); 275 parms.add(comId); 276 List replylist=utilsService.getDataList(repltSql, parms); 277 String mediaId=""; 278 if(replylist!=null && replylist.size()>0){ 279 HashMap replyLine = (HashMap)replylist.get(0); 280 mediaId=(String) replyLine.get("MEDIA_ID"); 281 } 282 if(StringUtils.isNotBlank(mediaId)) 283 xmlTo += "<MediaId>" + mediaId + "</MediaId>"; 284 else 285 xmlTo += "<MediaId>" + "查无内容" + "</MediaId>"; 286 xmlTo += "</Image>"; 287 xmlTo += "</xml>"; 288 response.getWriter().write(xmlTo); 289 }else if ("voice".equals(msgType)) {//回复语音 290 String key = xmlmap.get("MediaId"); 291 String xmlTo = "<xml>"; 292 xmlTo += "<ToUserName>" + xmlmap.get("ToUserName") + "</ToUserName>"; 293 xmlTo += "<FromUserName>" + xmlmap.get("FromUserName") + "</FromUserName>"; 294 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 295 xmlTo += "<MsgType>voice</MsgType>"; 296 xmlTo += "<Voice>"; 297 String repltSql="select * from WECHAT_AUTO_KEY where WECHAT_AUTO_KEY.KEY_NAME = ? and WECHAT_AUTO_KEY.COM_ID=? "; 298 ArrayList parms = new ArrayList(); 299 parms.add(key); 300 parms.add(comId); 301 List replylist=utilsService.getDataList(repltSql, parms); 302 String mediaId=""; 303 if(replylist!=null && replylist.size()>0){ 304 HashMap replyLine = (HashMap)replylist.get(0); 305 mediaId=(String) replyLine.get("MEDIA_ID"); 306 } 307 if(StringUtils.isNotBlank(mediaId)) 308 xmlTo += "<MediaId>" + mediaId + "</MediaId>"; 309 else 310 xmlTo += "<MediaId>" + "查无内容" + "</MediaId>"; 311 xmlTo += "</Voice>"; 312 xmlTo += "</xml>"; 313 response.getWriter().write(xmlTo); 314 }else if ("video".equals(msgType)) {//回复视频 315 String key = xmlmap.get("MediaId"); 316 String xmlTo = "<xml>"; 317 xmlTo += "<ToUserName>" + xmlmap.get("ToUserName") + "</ToUserName>"; 318 xmlTo += "<FromUserName>" + xmlmap.get("FromUserName") + "</FromUserName>"; 319 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 320 xmlTo += "<MsgType>video</MsgType>"; 321 xmlTo += "<Video>"; 322 String repltSql="select * from WECHAT_AUTO_KEY where WECHAT_AUTO_KEY.KEY_NAME = ? and WECHAT_AUTO_KEY.COM_ID=? "; 323 ArrayList parms = new ArrayList(); 324 parms.add(key); 325 parms.add(comId); 326 List replylist=utilsService.getDataList(repltSql, parms); 327 String mediaId=""; 328 String title=""; 329 String desc=""; 330 if(replylist!=null && replylist.size()>0){ 331 HashMap replyLine = (HashMap)replylist.get(0); 332 mediaId=(String) replyLine.get("MEDIA_ID"); 333 title=(String) replyLine.get("TITLE"); 334 desc=(String) replyLine.get("DESC"); 335 } 336 if(StringUtils.isNotBlank(mediaId)) 337 xmlTo += "<MediaId>" + mediaId + "</MediaId>"; 338 else 339 xmlTo += "<MediaId>" + "查无内容" + "</MediaId>"; 340 xmlTo += "<Title>" + title + "</Title>"; 341 xmlTo += "<Description>" + desc + "</Title>"; 342 xmlTo += "</Video> "; 343 xmlTo += "</xml>"; 344 response.getWriter().write(xmlTo); 345 }else if ("music".equals(msgType)) {//回复音乐 346 String key = xmlmap.get("ThumbMediaId"); 347 String xmlTo = "<xml>"; 348 xmlTo += "<ToUserName>" + xmlmap.get("ToUserName") + "</ToUserName>"; 349 xmlTo += "<FromUserName>" + xmlmap.get("FromUserName") + "</FromUserName>"; 350 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 351 xmlTo += "<MsgType>music</MsgType>"; 352 xmlTo += "<Music>"; 353 String repltSql="select * from WECHAT_AUTO_KEY where WECHAT_AUTO_KEY.KEY_NAME = ? and WECHAT_AUTO_KEY.COM_ID=? "; 354 ArrayList parms = new ArrayList(); 355 parms.add(key); 356 parms.add(comId); 357 List replylist=utilsService.getDataList(repltSql, parms); 358 String mediaId=""; 359 String title=""; 360 String desc=""; 361 String url=""; 362 if(replylist!=null && replylist.size()>0){ 363 HashMap replyLine = (HashMap)replylist.get(0); 364 mediaId=(String) replyLine.get("MEDIA_ID"); 365 title=(String) replyLine.get("TITLE"); 366 desc=(String) replyLine.get("DESC"); 367 url=(String) replyLine.get("URL"); 368 } 369 xmlTo += "<Title>" + title + "</Title>"; 370 xmlTo += "<Description>" + desc + "</Title>"; 371 xmlTo += "<MusicUrl>" + url + "</MusicUrl>"; 372 if(StringUtils.isNotBlank(mediaId)) 373 xmlTo += "<ThumbMediaId>" + mediaId + "</ThumbMediaId>"; 374 else 375 xmlTo += "<ThumbMediaId>" + "查无内容" + "</ThumbMediaId>"; 376 377 xmlTo += "</Music> "; 378 xmlTo += "</xml>"; 379 response.getWriter().write(xmlTo); 380 }else if ("news".equals(msgType)) {//回复图文 381 String key = xmlmap.get("Articles"); 382 String xmlTo = "<xml>"; 383 xmlTo += "<ToUserName>" + xmlmap.get("ToUserName") + "</ToUserName>"; 384 xmlTo += "<FromUserName>" + xmlmap.get("FromUserName") + "</FromUserName>"; 385 xmlTo += "<CreateTime>" + xmlmap.get("CreateTime") + "</CreateTime>"; 386 xmlTo += "<MsgType>news</MsgType>"; 387 xmlTo += "<ArticleCount>1</ArticleCount>"; 388 xmlTo += "<Articles>"; 389 xmlTo += "<item>"; 390 String repltSql="select * from WECHAT_AUTO_KEY where WECHAT_AUTO_KEY.KEY_NAME = ? and WECHAT_AUTO_KEY.COM_ID=? "; 391 ArrayList parms = new ArrayList(); 392 parms.add(key); 393 parms.add(comId); 394 List replylist=utilsService.getDataList(repltSql, parms); 395 String mediaId=""; 396 String title=""; 397 String desc=""; 398 String url=""; 399 String goUrl=""; 400 if(replylist!=null && replylist.size()>0){ 401 HashMap replyLine = (HashMap)replylist.get(0); 402 mediaId=(String) replyLine.get("MEDIA_ID"); 403 title=(String) replyLine.get("TITLE"); 404 desc=(String) replyLine.get("DESC"); 405 url=(String) replyLine.get("URL"); 406 goUrl=(String) replyLine.get("GO_URL"); 407 } 408 xmlTo += "<Title>" + title + "</Title>"; 409 if(StringUtils.isNotBlank(desc)) 410 xmlTo += "<Description>" + desc + "</Description>"; 411 else 412 xmlTo += "<Description>" + "查无内容" + "</Description>"; 413 xmlTo += "<PicUrl>" + url + "</PicUrl>"; 414 xmlTo += "<Url>" + goUrl + "</Url>"; 415 xmlTo += "</item> "; 416 xmlTo += "</Articles> "; 417 xmlTo += "</xml>"; 418 response.getWriter().write(xmlTo); 419 } 420 } 421 } catch (Exception e) { 422 log.debug("", e); 423 } 424 }