package com.dsh.guns.modular.system.controller.code;
|
|
import com.alibaba.fastjson.JSON;
|
import com.alibaba.fastjson.JSONArray;
|
import com.alibaba.fastjson.JSONObject;
|
import com.dsh.course.feignClient.communityWorldCup.Model.WorldCupStore;
|
import com.dsh.course.feignClient.communityWorldCup.WorldCupClient;
|
import com.dsh.course.feignClient.communityWorldCup.Model.WorldCup;
|
import com.dsh.course.feignClient.communityWorldCup.Model.WorldCupListAll;
|
import com.dsh.course.feignClient.communityWorldCup.WorldCupStoreClient;
|
import com.dsh.course.feignClient.communityWorldCup.Model.RegisteredPersonnel;
|
import com.dsh.course.feignClient.competition.model.Competition;
|
import com.dsh.course.feignClient.competition.model.CompetitionUser;
|
import com.dsh.course.feignClient.competition.model.GetPeopleQuery;
|
import com.dsh.guns.core.util.ToolUtil;
|
import com.dsh.guns.modular.system.service.IStoreService;
|
import com.dsh.guns.modular.system.util.DateUtil;
|
import com.dsh.guns.modular.system.util.ExcelUtil;
|
import com.dsh.guns.modular.system.util.QRCodeUtils;
|
import com.dsh.guns.modular.system.util.ResultUtil;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.ui.Model;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletResponse;
|
import java.awt.image.BufferedImage;
|
import java.io.File;
|
import java.io.FileInputStream;
|
import java.io.InputStream;
|
import java.io.OutputStream;
|
import java.net.URLEncoder;
|
import java.text.DateFormat;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
import java.util.stream.Collectors;
|
import java.util.zip.ZipEntry;
|
import java.util.zip.ZipOutputStream;
|
|
/**
|
* @author zhibing.pu
|
* @Date 2024/3/2 10:40
|
*/
|
@Controller
|
@RequestMapping("/worldCup")
|
public class WorldCupController {
|
|
private String PREFIX = "/system/worldCup/";
|
|
@Resource
|
private WorldCupClient worldCupClient;
|
|
@Resource
|
private WorldCupStoreClient worldCupStoreClient;
|
|
@Autowired
|
private IStoreService storeService;
|
|
|
/**
|
* 跳转列表页
|
* @return
|
*/
|
@RequestMapping("")
|
public String showWorldCupList(){
|
return PREFIX + "worldCup.html";
|
}
|
|
/**
|
* 跳转到添加页
|
* @return
|
*/
|
@RequestMapping("/openAddWorldCup")
|
public String openAddWorldCup(){
|
return PREFIX + "worldCup_add.html";
|
}
|
|
|
@RequestMapping("/openEditWorldCup")
|
public String openEditWorldCup(Model model, Integer id){
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
WorldCup worldCup = worldCupClient.getWorldCupById(id);
|
model.addAttribute("item", worldCup);
|
model.addAttribute("startTime", sdf.format(worldCup.getStartTime()));
|
model.addAttribute("endTime", sdf.format(worldCup.getEndTime()));
|
model.addAttribute("registrationClosingTime", null != worldCup.getRegistrationClosingTime() ? sdf.format(worldCup.getRegistrationClosingTime()) : "");
|
List<WorldCupStore> worldCupStoreAllList = worldCupStoreClient.getWorldCupStoreAllList(id);
|
List<Integer> collect = worldCupStoreAllList.stream().map(WorldCupStore::getStoreId).collect(Collectors.toList());
|
List<Map<String, Object>> mapList = storeService.listStoreAllByIds(collect);
|
model.addAttribute("stores", JSON.toJSONString(mapList));
|
return PREFIX + "worldCup_edit.html";
|
}
|
|
|
@RequestMapping("/openInfoWorldCup")
|
public String openInfoWorldCup(Model model, Integer id){
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
WorldCup worldCup = worldCupClient.getWorldCupById(id);
|
model.addAttribute("item", worldCup);
|
model.addAttribute("startTime", sdf.format(worldCup.getStartTime()));
|
model.addAttribute("endTime", sdf.format(worldCup.getEndTime()));
|
model.addAttribute("registrationClosingTime", null != worldCup.getRegistrationClosingTime() ? sdf.format(worldCup.getRegistrationClosingTime()) : "");
|
List<WorldCupStore> worldCupStoreAllList = worldCupStoreClient.getWorldCupStoreAllList(id);
|
List<Integer> collect = worldCupStoreAllList.stream().map(WorldCupStore::getStoreId).collect(Collectors.toList());
|
List<Map<String, Object>> mapList = storeService.listStoreAllByIds(collect);
|
model.addAttribute("stores", JSON.toJSONString(mapList));
|
return PREFIX + "worldCup_info.html";
|
}
|
|
|
/**
|
* 跳转到已报名人员列表
|
* @param model
|
* @param id
|
* @return
|
*/
|
@RequestMapping("/openRegisteredPersonnel")
|
public String openRegisteredPersonnel(Model model, Integer id){
|
model.addAttribute("id", id);
|
return PREFIX + "registeredPersonnel.html";
|
}
|
|
|
|
/**
|
* 跳转到门店选择页面
|
* @return
|
*/
|
@RequestMapping("/openStore")
|
public String openStore(){
|
return PREFIX + "store.html";
|
}
|
|
|
|
|
|
/**
|
* 获取列表数据
|
* @param worldCupList
|
* @return
|
*/
|
@ResponseBody
|
@PostMapping("/listAll")
|
public Object listAll(WorldCupListAll worldCupList){
|
return worldCupClient.getWorldCupListAll(worldCupList);
|
}
|
|
|
/**
|
* 添加社区世界杯
|
* @param worldCup
|
* @param stores
|
* @return
|
*/
|
@ResponseBody
|
@PostMapping("/addWorldCup")
|
public ResultUtil addWorldCup(WorldCup worldCup, String stores){
|
if(worldCup.getStartTime().before(new Date())){
|
worldCup.setStatus(2);
|
}else{
|
worldCup.setStatus(1);
|
}
|
worldCup.setCreateTime(new Date());
|
worldCup.setMatchNumber(0);
|
Integer integer = worldCupClient.addWorldCup(worldCup);
|
if(null != integer){
|
JSONArray jsonArray = JSON.parseArray(stores);
|
for (int i = 0; i < jsonArray.size(); i++) {
|
JSONObject jsonObject = jsonArray.getJSONObject(i);
|
Integer id = jsonObject.getInteger("id");
|
WorldCupStore worldCupStore = new WorldCupStore();
|
worldCupStore.setStoreId(id);
|
worldCupStore.setWorldCupId(integer);
|
worldCupStore.setIsOpen(0);
|
worldCupStoreClient.addWorldCupStore(worldCupStore);
|
}
|
}
|
return ResultUtil.success();
|
}
|
|
|
|
/**
|
* 编辑社区世界杯
|
* @param worldCup
|
* @param stores
|
* @return
|
*/
|
@ResponseBody
|
@PostMapping("/editWorldCup")
|
public ResultUtil editWorldCup(WorldCup worldCup, String stores){
|
WorldCup worldCup1 = worldCupClient.getWorldCupById(worldCup.getId());
|
if(worldCup1.getStartTime().before(DateUtil.getDate())){
|
return ResultUtil.error("赛事已开始，不能编辑");
|
}
|
Integer maxPeople = worldCup1.getMaxPeople();
|
int registeredNumber = worldCupClient.getRegisteredNumber(worldCup.getId());
|
if(maxPeople.compareTo(registeredNumber) < 0){
|
return ResultUtil.error("报名人数不能小于已报名人数");
|
}
|
if(worldCup.getStartTime().before(new Date())){
|
worldCup.setStatus(2);
|
}else{
|
worldCup.setStatus(1);
|
}
|
worldCupClient.editWorldCup(JSON.toJSONString(worldCup));
|
worldCupStoreClient.delWorldCupStore(worldCup.getId());
|
JSONArray jsonArray = JSON.parseArray(stores);
|
for (int i = 0; i < jsonArray.size(); i++) {
|
JSONObject jsonObject = jsonArray.getJSONObject(i);
|
Integer id = jsonObject.getInteger("id");
|
WorldCupStore worldCupStore = new WorldCupStore();
|
worldCupStore.setStoreId(id);
|
worldCupStore.setWorldCupId(worldCup.getId());
|
worldCupStore.setIsOpen(0);
|
worldCupStoreClient.addWorldCupStore(worldCupStore);
|
}
|
return ResultUtil.success();
|
}
|
|
|
/**
|
* 修改赛事状态
|
* @param id
|
* @param state
|
* @return
|
*/
|
@ResponseBody
|
@PostMapping("/updateState")
|
public ResultUtil updateState(Integer id, Integer state){
|
WorldCup worldCup = new WorldCup();
|
worldCup.setId(id);
|
worldCup.setStatus(state);
|
worldCupClient.editWorldCup(JSON.toJSONString(worldCup));
|
//开始处理已支付的退费
|
worldCupClient.cancelWorldCupRefund(id);
|
return ResultUtil.success();
|
}
|
|
|
/**
|
* 获取已报名人员列表
|
* @param registeredPersonnel
|
* @return
|
*/
|
@ResponseBody
|
@PostMapping("/registeredPersonnel")
|
public Object registeredPersonnel(RegisteredPersonnel registeredPersonnel){
|
return worldCupClient.getRegisteredPersonnel(registeredPersonnel);
|
}
|
|
|
/**
|
* 下载二维码压缩包
|
* @param registeredPersonnel
|
* @param response
|
*/
|
@ResponseBody
|
@GetMapping("/downloadQRCodeZip")
|
public void downloadQRCodeZip(RegisteredPersonnel registeredPersonnel, HttpServletResponse response){
|
try {
|
registeredPersonnel.setOffset(0);
|
registeredPersonnel.setLimit(10000);
|
Map<String, Object> maps = worldCupClient.getRegisteredPersonnel(registeredPersonnel);
|
List<Map<String, Object>> list = (List<Map<String, Object>>)maps.get("rows");
|
response.setContentType("APPLICATION/OCTET-STREAM");
|
response.setHeader("Content-Disposition","attachment; filename=" + URLEncoder.encode("二维码", "UTF-8") + ".zip");
|
ZipOutputStream out = new ZipOutputStream(response.getOutputStream());
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS");
|
for(Map<String, Object> map : list){
|
String id = map.get("id").toString();
|
String isStudent = map.get("isStudent").toString();
|
String name = map.get("name").toString() + sdf.format(new Date());
|
String content = "{\"id\":" + id + ",\"isStudent\":" + isStudent + "}";
|
QRCodeUtils.encode(content, name, "/usr/playpai/qrcode", false);
|
File file = new File("/usr/playpai/qrcode/" + name + ".jpg");
|
FileInputStream fileInputStream = new FileInputStream(file);
|
|
out.putNextEntry(new ZipEntry(name + ".jpg"));
|
int len = 0;
|
byte[] buf = new byte[1024];
|
while ((len = fileInputStream.read(buf, 0, 1024)) != -1) {
|
out.write(buf, 0, len);
|
}
|
fileInputStream.close();
|
}
|
out.finish();
|
out.close();
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
}
|
|
|
/**
|
* 下载已报名人员
|
* @param registeredPersonnel
|
* @param response
|
*/
|
@ResponseBody
|
@GetMapping("/exportPersonnel")
|
public void exportPersonnel(RegisteredPersonnel registeredPersonnel, HttpServletResponse response){
|
try {
|
Date date = new Date();
|
DateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String time1 = format.format(date);
|
String fileName ="已报名人员.xls";
|
String[] title = new String[] {"姓名","性别","年龄","联系电话","身份证号","状态"};
|
registeredPersonnel.setOffset(0);
|
registeredPersonnel.setLimit(10000);
|
Map<String, Object> maps = worldCupClient.getRegisteredPersonnel(registeredPersonnel);
|
List<Map<String, Object>> list = (List<Map<String, Object>>)maps.get("rows");
|
String[][] values = new String[list.size()][];
|
for (int i = 0; i < list.size(); i++) {
|
Map<String, Object> d = list.get(i);
|
values[i] = new String[title.length];
|
values[i][0] = d.get("name").toString();
|
values[i][1] = d.get("gender").toString();
|
values[i][2] = d.get("age").toString();
|
values[i][3] = d.get("phone").toString();
|
values[i][4] = d.get("idcard").toString();
|
Integer state1 = Integer.valueOf(d.get("state").toString());
|
if(1 == state1){
|
values[i][5] = "正常";
|
}else {
|
values[i][5] = "取消";
|
}
|
}
|
HSSFWorkbook wb = ExcelUtil.getHSSFWorkbook("Variance"+time1, title, values, null);
|
ExcelUtil.setResponseHeader(response, fileName);
|
OutputStream os = response.getOutputStream();
|
wb.write(os);
|
os.flush();
|
os.close();
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
