| | |
| | | |
| | | import com.dsh.course.feignClient.communityWorldCup.Model.*; |
| | | import com.dsh.course.feignClient.communityWorldCup.WorldCupClient; |
| | | import com.dsh.course.model.dto.UserDetailsOfSearch; |
| | | import com.dsh.guns.modular.system.util.ExcelUtil; |
| | | import com.dsh.guns.modular.system.util.ResultUtil; |
| | | import org.apache.poi.hssf.usermodel.HSSFWorkbook; |
| | |
| | | public String openWorldCupGameStatisticsInfo(Model model, Integer id){ |
| | | model.addAttribute("id", id); |
| | | return PREFIX + "worldCupGameStatisticsInfo.html"; |
| | | } |
| | | |
| | | @RequestMapping("/addWorldCupGameStatisticsInfo") |
| | | public String addWorldCupGameStatisticsInfo(Model model, Integer id){ |
| | | WorldCup worldCupById = worldCupClient.getWorldCupById(id); |
| | | model.addAttribute("item", worldCupById); |
| | | return PREFIX + "addWorldCupGameStatisticsListInfo.html"; |
| | | } |
| | | @RequestMapping("/userList") |
| | | public String userList(Integer id,Model model){ |
| | | WorldCup worldCupById = worldCupClient.getWorldCupById(id); |
| | | model.addAttribute("item", worldCupById); |
| | | return PREFIX + "TUserList.html"; |
| | | } |
| | | @RequestMapping("/userList1") |
| | | public String userList1(Integer id,Model model){ |
| | | WorldCup worldCupById = worldCupClient.getWorldCupById(id); |
| | | model.addAttribute("item", worldCupById); |
| | | return PREFIX + "TUserList1.html"; |
| | | } |
| | | |
| | | |
| | |
| | | public void exportUserStatistics(WorldCupGameStatisticsInfoList worldCupGameStatisticsInfoList, HttpServletResponse response){ |
| | | worldCupGameStatisticsInfoList.setOffset(0); |
| | | worldCupGameStatisticsInfoList.setLimit(100000); |
| | | Map<String, Object> map = worldCupClient.worldCupGameStatisticsInfoList(worldCupGameStatisticsInfoList); |
| | | Map<String, Object> map = worldCupClient.getUserGameRecordList(worldCupGameStatisticsInfoList); |
| | | List<Map<String, Object>> list = (List<Map<String, Object>>)map.get("rows"); |
| | | |
| | | try { |
| | |
| | | values[i] = new String[title.length]; |
| | | values[i][0] = d.get("name").toString(); |
| | | values[i][1] = d.get("phone").toString(); |
| | | values[i][2] = d.get("idcard").toString(); |
| | | values[i][2] = null == d.get("idcard") ? "" : d.get("idcard").toString(); |
| | | values[i][3] = d.get("totalSession").toString(); |
| | | values[i][4] = d.get("win").toString() + "-" + d.get("lose").toString(); |
| | | values[i][5] = d.get("winRate").toString() + "%"; |
| | |
| | | e.printStackTrace(); |
| | | } |
| | | } |
| | | |
| | | |
| | | @ResponseBody |
| | | @PostMapping("/userDetailsOfSearch") |
| | | public Object storeDetailsOfSearch(Integer id,String name,String phone,String idCard){ |
| | | UserDetailsOfSearch userDetailsOfSearch = new UserDetailsOfSearch(); |
| | | userDetailsOfSearch.setId( id); |
| | | userDetailsOfSearch.setName(name); |
| | | userDetailsOfSearch.setPhone(phone); |
| | | userDetailsOfSearch.setIdCard(idCard); |
| | | // 获取报了名的用户 未产生赛事 |
| | | return worldCupClient.userDetailsOfSearch(userDetailsOfSearch); |
| | | } |
| | | } |