微信小程序新能源汽车信息安全服务平台源码数据库.zip

package com.example.controller; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.collection.CollectionUtil; import cn.hutool.core.io.IoUtil; import cn.hutool.core.util.ObjectUtil; import cn.hutool.core.util.StrUtil; import cn.hutool.crypto.SecureUtil; import cn.hutool.json.JSONObject; import cn.hutool.poi.excel.ExcelUtil; import cn.hutool.poi.excel.ExcelWriter; import com.example.common.Result; import com.example.common.ResultCode; import com.example.entity.CheliangxinxiInfo; import com.example.dao.CheliangxinxiInfoDao; import com.example.service.CheliangxinxiInfoService; import com.example.exception.CustomException; import com.example.common.ResultCode; import com.example.vo.EchartsData; import com.example.vo.CheliangxinxiInfoVo; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.example.service.*; import org.apache.ibatis.annotations.Param; import org.springframework.web.bind.annotation.*; import org.springframework.beans.factory.annotation.Value; import cn.hutool.core.util.StrUtil; import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.util.*; import java.util.stream.Collectors; @RestController @RequestMapping(value = "/cheliangxinxiInfo") public class CheliangxinxiInfoController { @Resource private CheliangxinxiInfoService cheliangxinxiInfoService; @Resource private CheliangxinxiInfoDao cheliangxinxiInfoDao; @PostMapping public Result<CheliangxinxiInfo> add(@RequestBody CheliangxinxiInfoVo cheliangxinxiInfo) { //mixmajixami cheliangxinxiInfoService.add(cheliangxinxiInfo); return Result.success(cheliangxinxiInfo); } //youtixing1 //youtixing2 @DeleteMapping("/{id}") public Result delete(@PathVariable Long id) { cheliangxinxiInfoService.delete(id); return Result.success(); } @PutMapping public Result update(@RequestBody CheliangxinxiInfoVo cheliangxinxiInfo) { cheliangxinxiInfoService.update(cheliangxinxiInfo); return Result.success(); } //@PutMapping("/update2") // public Result update2(@RequestBody CheliangxinxiInfoVo cheliangxinxiInfo) { // cheliangxinxiInfoService.update2(cheliangxinxiInfo); // return Result.success(); // } @GetMapping("/{id}") public Result<CheliangxinxiInfo> detail(@PathVariable Long id) { CheliangxinxiInfo cheliangxinxiInfo = cheliangxinxiInfoService.findById(id); return Result.success(cheliangxinxiInfo); } @GetMapping("/searchGoods") public Result<List<CheliangxinxiInfo>> search(@RequestParam("text") String text) { List<CheliangxinxiInfo> cheliangxinxiInfo = cheliangxinxiInfoService.findByText(text); return Result.success(cheliangxinxiInfo); } @GetMapping("/changeStatus/{id}") public Result<CheliangxinxiInfo> changeStatus(@PathVariable Long id) { cheliangxinxiInfoService.changeStatus(id); return Result.success(); } @GetMapping public Result<List<CheliangxinxiInfoVo>> all() { return Result.success(cheliangxinxiInfoService.findAll()); } @GetMapping("/findAllType") public Result<List<CheliangxinxiInfoVo>> findAllType() { return Result.success(cheliangxinxiInfoService.findAllType()); } @GetMapping("/findByType/{type}") public Result<List<CheliangxinxiInfoVo>> findByType(@PathVariable String type) { return Result.success(cheliangxinxiInfoService.findByType(type)); } @GetMapping("/page/{name}") public Result<PageInfo<CheliangxinxiInfoVo>> page(@PathVariable String name, @RequestParam(defaultValue = "1") Integer pageNum, @RequestParam(defaultValue = "5") Integer pageSize, HttpServletRequest request) { return Result.success(cheliangxinxiInfoService.findPage(name, pageNum, pageSize, request)); } @GetMapping("/pageqt/{name}") public Result<PageInfo<CheliangxinxiInfoVo>> pageqt(@PathVariable String name, @RequestParam(defaultValue = "1") Integer pageNum, @RequestParam(defaultValue = "8") Integer pageSize, HttpServletRequest request) { return Result.success(cheliangxinxiInfoService.findPageqt(name, pageNum, pageSize, request)); } // @PostMapping("/register") // public Result<CheliangxinxiInfo> register(@RequestBody CheliangxinxiInfo cheliangxinxiInfo) { // if (StrUtil.isBlank(cheliangxinxiInfo.getName()) || StrUtil.isBlank(cheliangxinxiInfo.getPassword())) { // throw new CustomException(ResultCode.PARAM_ERROR); // } // return Result.success(cheliangxinxiInfoService.add(cheliangxinxiInfo)); // } /** * 批量通过excel添加信息 * @param file excel文件 * @throws IOException */ @PostMapping("/upload") public Result upload(MultipartFile file) throws IOException { List<CheliangxinxiInfo> infoList = ExcelUtil.getReader(file.getInputStream()).readAll(CheliangxinxiInfo.class); if (!CollectionUtil.isEmpty(infoList)) { // 处理一下空数据 List<CheliangxinxiInfo> resultList = infoList.stream().filter(x -> ObjectUtil.isNotEmpty(x.getCheliangbianhao())).collect(Collectors.toList()); for (CheliangxinxiInfo info : resultList) { cheliangxinxiInfoService.add(info); } } return Result.success(); } @GetMapping("/get/cheliangxinxi_tj_cheliangpinpai") Result<List<EchartsData>> cheliangxinxi_tj_cheliangpinpai() { List<EchartsData> list = new ArrayList<>(); List<Map<String, Object>> cheliangxinxi_tj_cheliangpinpaiList = cheliangxinxiInfoDao.cheliangxinxi_tj_cheliangpinpai(); Map<String, Double> typeMap = new HashMap<>(); for (Map<String, Object> map : cheliangxinxi_tj_cheliangpinpaiList) { typeMap.put((String)map.get("aa"), (Double.valueOf((String)map.get("bb").toString()))); } getPieData("车辆信息按车辆品牌统计", list, typeMap); getBarData("车辆信息按车辆品牌统计", list, typeMap); return Result.success(list); } @GetMapping("/get/cheliangxinxi_tj_chexing") Result<List<EchartsData>> cheliangxinxi_tj_chexing() { List<EchartsData> list = new ArrayList<>(); List<Map<String, Object>> cheliangxinxi_tj_chexingList = cheliangxinxiInfoDao.cheliangxinxi_tj_chexing(); Map<String, Double> typeMap = new HashMap<>(); for (Map<String, Object> map : cheliangxinxi_tj_chexingList) { typeMap.put((String)map.get("aa"), (Double.valueOf((String)map.get("bb").toString()))); } getPieData("车辆信息按车型统计", list, typeMap); getBarData("车辆信息按车型统计", list, typeMap); return Result.success(list); } @GetMapping("/get/cheliangxinxi_tj_qudongfangshi") Result<List<EchartsData>> cheliangxinxi_tj_qudongfangshi() { List<EchartsData> list = new ArrayList<>(); List<Map<String, Object>> cheliangxinxi_tj_qudongfangshiList = cheliangxinxiInfoDao.cheliangxinxi_tj_qudongfangshi(); Map<String, Double> typeMap = new HashMap<>(); for (Map<String, Object> map : cheliangxinxi_tj_qudongfangshiList) { typeMap.put((String)map.get("aa"), (Double.valueOf((String)map.get("bb").toString()))); } getPieData("车辆信息�